The Purchase order tables are referenced/used by:
| FIELD | DATA TYPE | REQUIRED | DESCRIPTION |
|---|---|---|---|
| POH__ID | int | Y | Auto Generated Primary Key Clustered |
| POH__NUMBER | varchar(50) | Y | A unique purchase order number as imported with Integration |
| POH__DATE | datetime | Y | The date of the Purchase Order (typically date created) |
| POH__REFERENCE | varchar(50) | Y | An additional reference attached to the purchase order. Typically the Supplier PO number |
| POH__POS_ID | int | Y | This is a Foreign Key Reference to qx_PurchaseOrderStatus table, indicating the status of the purchase order |
| POH__POV_ID | int | Y | Foreign Key to the qx_PurchaseOrderVariant Table (Sub-variant of PO) |
| POH__AUTOMATION_STATUS | varchar(255) | Additional Status value used to propagate automation action status to the Purchase order | |
| POH__ROUTE | varchar(50) | Route Indicator | |
| POH__WRITEBACK_STATUS | varchar(1000) | Additional Status value for integration (writebacks) | |
| POH__GRN_NUMBER | varchar(50) | External GRN reference number, typically populated as a result of a writeback action | |
| POH__DATE_MODIFIED | datetime | Y | The date the PO was last modified, via integration or user input |
| POH__INVOICE | varchar(50) | The Invoice number, typically captured on arrival of the PO for receiving | |
| POH__PALLET_COUNT | varchar(10) | Used to store last known pallet number for pallet printing report | |
| POH__DATE_PLANNED | datetime | The Planned Date of arrival/processing | |
| POH__SUP_ID | int | Y | Foreign Key to qx_Supplier, The supplier of the Purchase order. |
| POH__ILC_ID | int | Y | Foreign Key to the Location (The expected Warehouse to process the PO) |
| POH__PRP_ID | int | Y | Foreign Key to qx_Principal, The Principle for this PO (for 3PL & Multi-company) |
| POH__SIT_ID | int | Y | The Site this PO is related to (Multi-site) |
| POH__TRUCKSEAL | varchar(100) | Barcode identifying the delivery by truck | |
| POH__UNRELEASED_FLAG | bit | ||
| POH__WRITEBACK_STATUS_PUT | varchar(50) | ||
| POH__DELIVERY_TYPE | varchar(50) | ||
| POH__QTY_MISMATCH | bit | ||
| POH__RCV_SCAN_COMPLETE | bit | ||
| POH__EPACK_LOCK_STATUS | varchar(50) |
| FIELD | DATA TYPE | REQUIRED | DESCRIPTION |
|---|---|---|---|
| POL__ID | int | Y | Auto-Generated Primary Key Clustered |
| POL__ITM_ID | int | Y | Foreign key reference to the qx_Item Table indicating the Item |
| POL__QTY | float | Y | Line Qty |
| POL__QTY_INVOICE | float | Invoice Qty | |
| POL__MEMO | varchar(200) | Additional Txt information relevant to the Line item | |
| POL__POH_ID | int | Y | Foreign key reference to the qx_PurchaseOrderHeader table to link the line to a Purchase order |
| POL__NUMBER | int | Y | Line Number |
| POL__UOM_CONVERSION | float | TBC? | |
| POL__UNIT_PRICE | numeric(18, 2) | Price of the Item as received | |
| POL__BCH_ID | int | Foreign key reference to the qx_Batch table. | |
| POL__CLASS | char(1) | ||
| POL__DRENCH | smallint | ||
| POL__UOM | varchar(20) | ||
| FIELD | DATA TYPE | REQUIRED | DESCRIPTION |
|---|---|---|---|
| POB__POL_ID | int | Y | Foreign Key to the qx_PurchaseOrderLine table |
| POB__BCH_ID | int | Y | Foreign Key to the qx_Batch Table |
| POB__Qty | float | Y | Qty for the Linked line and batch |
| FIELD | DATA TYPE | REQUIRED | DESCRIPTION |
|---|---|---|---|
| POS__ID | int | Y | Auto-Generated Primary Key |
| POS__CODE | varchar(50) | Y | Short Description of the Purchase Order Status |
| POS__DESCRIPTION | varchar(200) | Long Description of the Purchase Order Status |
| FIELD | DATA TYPE | REQUIRED | DESCRIPTION |
|---|---|---|---|
| POT__ID | int | Y | Auto-Generated Purchase Order Transfer ID. |
| POT__ITH_ID | bigint | Y | Foreign Key to the qx_ItemLocationTransferHeader Table |
| POT__POH_ID | int | Y | Foreign Key to the qx_PurchaseOrderHeader Table |
| (POT__ITH_ID, POT__POH__ID) Composite Primary key |
| FIELD | DATA TYPE | REQUIRED | DESCRIPTION |
|---|---|---|---|
| POV__ID | int | Y | Auto-Generated Primary Key Clustered |
| POV__CODE | varchar(50) | Y | Code of the Purchase Order Variant |
| POV__DESCRIPTION | varchar(200) | Y | Description for the Purchase Order Variant |
| FIELD | DATA TYPE | REQUIRED | DESCRIPTION |
|---|---|---|---|
| POB__POL_ID | int | Y | Foreign Key to qx_PurchaseOrderLine Table (Linked Line) |
| POB__BCH_ID | int | Y | Foreign Key to qx_Batch (Lined Batch) |
| POB__QTY | float | Qty for Line/Batch combination |