Transport Order Dispatch View
Reference No: R2-553
Details
A custom detailed Shipping Report can be generated using the Rep_TransportOrderDispatchView, that considers all the Items dispatched under the specific Logistic ID. The details of the columns in the view are provided in Table 1.0.
Table 1.0 Column Reference Table
Column | Parameter | Description |
TRANSPORTATION ID | VARCHAR2 <12> | The Logistic ID of the Items that was dispatched. |
ORDER ID | VARCHAR2 <20> | The Order ID containing the Items that were dispatched within the Logistic ID (including the Sub-Orders). |
SKU | VARCHAR2 <22> | The Product ID of the Items dispatched. |
ITEM DESCRIPTION | NVARCHAR2 <2000> | The Description of the Items dispatched. |
QTY DISPATCHED | NUMBER <9> | The quantity of a specific SKU that was shipped within the Logistic ID. |
ASSET ID | VARCHAR2 <50> | The Asset ID of the Item dispatched within the Logistic ID (if applicable). |
DEPARTMENT | VARCHAR2 <40> | The Department ID of the Products dispatched. |
CONTAINER ID | VARCHAR2 <20> | The Container ID associated with the items dispatched (if applicable). |
This view is applicable only for the Order and not for the Transfer Order or the Purchase Order.