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 |