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"
}
{
"name": "currencyId",
"type": "foreignKey",
"table": "currencies",
"schema": "mspx_admin"
}
{
"name": "createdByUserId",
"type": "foreignKey",
"table": "userAccounts",
"schema": "mspx_admin"
}
createdDate
{
"name": "createdDate",
"type": "timestamp"
}
updatedDate
{
"name": "updatedDate",
"type": "updated"
}