Invoices
Generated schema file.
Columns
| Name | Type | References | |
| Id [KEY] | Integer | ||
| CompanyId | Integer | ||
| IssueDate | Date | ||
| PartnerId | Integer | ||
| PartnerCode | String | ||
| InvoiceNumber | String | ||
| Title | String | ||
| DueDate | Date | ||
| TotalAmount | Decimal | ||
| TotalVat | Decimal | ||
| SubTotal | Integer | ||
| BookingDate | Date | ||
| Description | String | ||
| InvoiceStatus | String | ||
| PaymentStatus | String | ||
| PaymentDate | Date | ||
| WebConfirmedAt | Datetime | ||
| WebPublishedAt | Datetime | ||
| WebDownloadedAt | Datetime | ||
| MailSentAt | Datetime | ||
| PostingStatus | String | ||
| PartnerName | String | ||
| PartnerDisplayName | String | ||
| PartnerTitle | String | ||
| PartnerZipcode | String | ||
| PartnerPrefectureCode | Integer | ||
| PartnerPrefectureName | String | ||
| PartnerAddress1 | String | ||
| PartnerAddress2 | String | ||
| PartnerContactInfo | String | ||
| CompanyName | String | ||
| CompanyZipcode | String | ||
| CompanyPrefectureCode | Integer | ||
| CompanyPrefectureName | String | ||
| CompanyAddress1 | String | ||
| CompanyAddress2 | String | ||
| CompanyContactInfo | String | ||
| PaymentType | String | ||
| PaymentBankInfo | String | ||
| Message | String | ||
| Notes | String | ||
| InvoiceLayout | String | ||
| TaxEntryMethod | String | ||
| DealId | Integer | ||
| InvoiceContents | String | ||
| TotalAmountPerVatRateVat5 | Decimal | ||
| TotalAmountPerVatRateVat8 | Decimal | ||
| TotalAmountPerVatRateReducedVat8 | Decimal | ||
| TotalAmountPerVatRateVat10 | Decimal |