PurchaseOrderHeaders - main table giving an overview of purchase orders


ColumnTypeNotes
AnalysisCode3TEXT
CallActionNumberWHOLE NUMBER
CallNumberWHOLE NUMBER
CompanyNumberPurchaseOrderNoTEXTTugger created column combining:
CompanyNumber, PurchaseOrderNo
CompanyNumberWHOLE NUMBER
DeliveryAdd1TEXT
DeliveryInstructionsTEXT
DeliveryStatusTEXT
DiscountDECIMAL NUMBER
DueDeliveryDateDATETIME
GoodsDECIMAL NUMBER
InvoiceReceived_YNTEXT
JobCostingJobNoWHOLE NUMBER
LocationCodeTEXT
OrderDateDATETIME
OrderPlacedByTEXT
OrderStatusTEXT
PurchaseOrderNoWHOLE NUMBER
PurchaseOrderTotalDECIMAL NUMBER
SupplierCodeTEXT
SupplierOrderNoTEXT
VATDECIMAL NUMBER
LastEditDateDATETIME
DeletedBINARY