Table : dealReceipts

Raw table description

Fields

id id

{
  "name": "id",
  "type": "primaryKey"
}

estateDisplayName

{
  "name": "estateDisplayName",
  "type": "text",
  "maxLength": 200
}

dealId M  → deals

{
  "name": "dealId",
  "type": "foreignKey",
  "table": "deals",
  "mandatory": "true"
}

number

{
  "name": "number",
  "type": "text",
  "maxLength": 20
}

payer   (The person or organization that paid the money the receipt describes)

{
  "name": "payer",
  "type": "text",
  "maxLength": 200,
  "note": "The person or organization that paid the money the receipt describes"
}

recipientContactId  → contacts  (If both recipient and recipientContactId is set then contactId will be used)

{
  "name": "recipientContactId",
  "type": "foreignKey",
  "table": "contacts",
  "note": "If both recipient and recipientContactId is set then contactId will be used"
}

recipient   (If both recipient and recipientContactId is set then contactId will be used)

{
  "name": "recipient",
  "type": "text",
  "note": "If both recipient and recipientContactId is set then contactId will be used"
}

type E

{
  "name": "type",
  "type": "enum",
  "enums": [
    "ENUM_RECEIPT_TYPE_GENERAL (Kvitto)",
    "ENUM_RECEIPT_TYPE_DOWNPAYMENT (Kvitto - handpenning)",
    "ENUM_RECEIPT_TYPE_REPORTING_OF_DEPOSIT_DOWN_PAYMENT (Redovisning av deponerad handpenning)",
    "ENUM_RECEIPT_TYPE_COMMISSION (Kvitto - provision)"
  ]
}

signeeContactId  → contacts

{
  "name": "signeeContactId",
  "type": "foreignKey",
  "table": "contacts"
}

otherSignee

{
  "name": "otherSignee",
  "type": "text"
}

hideSignees bit

{
  "name": "hideSignees",
  "type": "bit"
}

city

{
  "name": "city",
  "type": "text",
  "maxLength": 100
}

date

{
  "name": "date",
  "type": "date"
}

description

{
  "name": "description",
  "type": "text"
}

hideVATCalculation bit

{
  "name": "hideVATCalculation",
  "type": "bit"
}

signeeCompanyDescription

{
  "name": "signeeCompanyDescription",
  "type": "text"
}

createdDate

{
  "name": "createdDate",
  "type": "timestamp"
}

updatedDate

{
  "name": "updatedDate",
  "type": "updated"
}

Referenced by

dealReceiptAmounts as dealReceiptId