PurchaseOrderHeaders - main table giving an overview of purchase orders
| Column | Type | Notes |
|---|---|---|
| AnalysisCode3 | TEXT | |
| CallActionNumber | WHOLE NUMBER | |
| CallNumber | WHOLE NUMBER | |
| CompanyNumberPurchaseOrderNo | TEXT | Tugger created column combining: CompanyNumber, PurchaseOrderNo |
| CompanyNumber | WHOLE NUMBER | |
| DeliveryAdd1 | TEXT | |
| DeliveryInstructions | TEXT | |
| DeliveryStatus | TEXT | |
| Discount | DECIMAL NUMBER | |
| DueDeliveryDate | DATETIME | |
| Goods | DECIMAL NUMBER | |
| InvoiceReceived_YN | TEXT | |
| JobCostingJobNo | WHOLE NUMBER | |
| LocationCode | TEXT | |
| OrderDate | DATETIME | |
| OrderPlacedBy | TEXT | |
| OrderStatus | TEXT | |
| PurchaseOrderNo | WHOLE NUMBER | |
| PurchaseOrderTotal | DECIMAL NUMBER | |
| SupplierCode | TEXT | |
| SupplierOrderNo | TEXT | |
| VAT | DECIMAL NUMBER | |
| LastEditDate | DATETIME | |
| Deleted | BINARY |