PurchaseInvoiceHeaders - Main table for purchase invoices
| Column | Type | Notes |
|---|---|---|
| Authorised_YN | TEXT | |
| CompanyNumberPurchaseInvoiceNumber | TEXT | Tugger created column combining: CompanyNumber, PurchaseInvoiceNumber |
| CompanyNumber | WHOLE NUMBER | |
| EnteredDate | DATETIME | |
| ExtractedToLedger_YN | TEXT | |
| Goods | DECIMAL NUMBER | |
| InvoiceDate | DATETIME | |
| InvoiceTotal | DECIMAL NUMBER | |
| InvoiceType | TEXT | |
| PurchaseInvoiceNumber | WHOLE NUMBER | |
| SupplierCode | TEXT | |
| SupplierInvoiceNumber | TEXT | |
| Text | TEXT | |
| VAT | DECIMAL NUMBER | |
| Deleted | BINARY |