Invoices
Generated schema file.
Columns
| Name | Type | References | |
| Id [KEY] | Integer | ||
| IssueDate | Date | ||
| PaymentDueOn | Date | ||
| ArchivedAt | Datetime | ||
| TrashedAt | Datetime | ||
| InvoiceNumber | String | ||
| InvoiceStatus | Integer | ||
| PaymentStatus | Integer | ||
| InvoicePaymentHistoryLastPaidOn | Date | ||
| Issued | Boolean | ||
| UserId | Integer | ||
| RecipientName | String | ||
| RecipientTitle | String | ||
| RecipientNotes | String | ||
| Subject | String | ||
| BodySenderName1 | String | ||
| BodySenderName2 | String | ||
| BodySenderName3 | String | ||
| BodySenderZipCode | String | ||
| BodySenderAddress1 | String | ||
| BodySenderAddress2 | String | ||
| BodySenderAddress3 | String | ||
| BodySenderTel | String | ||
| BodySenderFax | String | ||
| BodySenderEmail | String | ||
| BodyRecipientZipCode | String | ||
| BodyRecipientAddress1 | String | ||
| BodyRecipientAddress2 | String | ||
| BodyRecipientName1 | String | ||
| BodyRecipientName2 | String | ||
| BodyRecipientName3 | String | ||
| BodyRecipientName4 | String | ||
| BodyRecipientTitle | String | ||
| BodyNotes | String | ||
| BodyPrivateSenderMemo | String | ||
| BodyTaxOption | String | ||
| BodyTaxRoundingPolicy | String | ||
| BodyWithholdingTaxType | String | ||
| BodyAmountOfWithholdingTax | Decimal | ||
| BodyTotalAmount | Decimal | ||
| BodyTax | Decimal | ||
| BodyTotalAmountIncludingTax | Decimal | ||
| BodyBankAccounts | String | ||
| Items | String | ||
| ContactId | Integer | ||
| LockVersion | Integer | ||
| CreatedAt | Datetime | ||
| UpdatedAt | Datetime | ||
| Condition | String | ||
| Type | String | ||
| ContactGroupId | String |