InvoiceHeaders - Main table giving an overview of invoices.
| Column | Type | Notes |
|---|---|---|
| AccountingPeriodDate | DATETIME | |
| AccountingPeriod | WHOLE NUMBER | |
| AnalysisCode1 | TEXT | |
| AnalysisCode2 | TEXT | |
| Area | TEXT | |
| Branch | TEXT | |
| CallNumber | WHOLE NUMBER | |
| CompanyNoInvoiceNo | TEXT | |
| CompanyNumber | WHOLE NUMBER | |
| CurrencyCode | WHOLE NUMBER | |
| CustomerNo | TEXT | |
| DateGenerated | DATETIME | |
| DatePostedToLedger | DATETIME | |
| ExchangeRate | DECIMAL NUMBER | |
| ExpectedPaymentDate | DATETIME | |
| Goods | DECIMAL NUMBER | |
| InvoiceDate | DATETIME | |
| InvoiceHeld_YN | TEXT | |
| InvoiceName | TEXT | |
| InvoiceNo | WHOLE NUMBER | |
| InvoiceTotal | DECIMAL NUMBER | |
| InvoiceType | TEXT | |
| LedgerActivityType | TEXT | |
| LedgerCostCentre | TEXT | |
| LedgerDepartment | TEXT | |
| LedgerServiceType | TEXT | |
| Origin | TEXT | |
| OurRef | TEXT | |
| OutstandingAmountToBePaid | DECIMAL NUMBER | |
| Paid_Date | DATETIME | |
| Paid_YN | TEXT | |
| PaymentMethod | TEXT | |
| PremisesType | TEXT | |
| SalesMan | TEXT | |
| SettlementDate | DATETIME | |
| SettlementDays | WHOLE NUMBER | |
| SettlementDiscount | DECIMAL NUMBER | |
| SettlementText | TEXT | |
| SiteId | TEXT | |
| SiteName | TEXT | |
| TaxPointDate | DATETIME | |
| VAT | DECIMAL NUMBER | |
| Deleted | BINARY |