PurchaseInvoiceHeaders - Main table for purchase invoices


ColumnTypeNotes
Authorised_YNTEXT
CompanyNumberPurchaseInvoiceNumberTEXTTugger created column combining:
CompanyNumber, PurchaseInvoiceNumber
CompanyNumberWHOLE NUMBER
EnteredDateDATETIME
ExtractedToLedger_YNTEXT
GoodsDECIMAL NUMBER
InvoiceDateDATETIME
InvoiceTotalDECIMAL NUMBER
InvoiceTypeTEXT
PurchaseInvoiceNumberWHOLE NUMBER
SupplierCodeTEXT
SupplierInvoiceNumberTEXT
TextTEXT
VATDECIMAL NUMBER
DeletedBINARY