Table : invoices

Raw table description

Fields

id id

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

referenceContactId  → contacts

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

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"
}

number

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

penaltyInterest

{
  "name": "penaltyInterest",
  "type": "percentage"
}

date M

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

dueDate

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

information

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

comment   (Private text that will not be on invoice.)

{
  "name": "comment",
  "type": "text",
  "note": "Private text that will not be on invoice."
}

description   (Will appear at the end of the invoice.)

{
  "name": "description",
  "type": "text",
  "note": "Will appear at the end of the invoice."
}

isPaid bit

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

includeEstateAddress bit

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

hideCommunicationToken bit  (Only in use when deal invoice, if false we will print deal token AAA BBB if true we will not print)

{
  "name": "hideCommunicationToken",
  "type": "bit",
  "note": "Only in use when deal invoice, if false we will print deal token AAA BBB if true we will not print"
}

paidDate

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

vatPercentage

{
  "name": "vatPercentage",
  "type": "percentage"
}

plusgiroNumber

{
  "name": "plusgiroNumber",
  "type": "text",
  "maxLength": 15
}

bankgiroNumber

{
  "name": "bankgiroNumber",
  "type": "text",
  "maxLength": 15
}

period

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

invoiceTermsOfPayment

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

currencyId  → currencies

{
  "name": "currencyId",
  "type": "foreignKey",
  "table": "currencies",
  "schema": "mspx_admin"
}

createdByUserId  → userAccounts

{
  "name": "createdByUserId",
  "type": "foreignKey",
  "table": "userAccounts",
  "schema": "mspx_admin"
}

createdDate

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

updatedDate

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

Referenced by

dealInvoices as invoiceId
invoiceAmounts as invoiceId
organizationInvoices as invoiceId
organizationUnitInvoices as invoiceId