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.