XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for TsfShipCtnHdrDesc in SIM application. |
SIM's Table Name |
SIM's Column Name |
Integration API(RIB or/and RSB or/and BDI) |
SIM's Column Length |
Is Column Required in SIM's API? |
SIM's API Description |
carton_id |
number15 |
1 |
1 |
The unique transfer shipment container identifier. |
TSF_SHIP_CARTON |
ID |
NUMBER |
15 |
Yes |
The unique identifier for the shipment carton/container |
external_id |
varchar2128 |
0 |
1 |
The external identifier. |
TSF_SHIP_CARTON |
EXTERNAL_ID |
VARCHAR2 |
128 |
No |
The external identifier |
store_id |
number10 |
1 |
1 |
The unique store identifier of shipping store. |
TSF_SHIP_CARTON |
STORE_ID |
NUMBER |
10 |
Yes |
Store identifier. |
status |
tsf_ship_ctn_status |
1 |
1 |
The current status of the container. Valid values are NEW, IN_PROGRESS, COMPLETED, SHIPPED, CANCELED, UNKNOWN, NO_VALUE. |
TSF_SHIP_CARTON |
STATUS |
NUMBER |
4 |
Yes |
The status of theShipment carton. Valid values: 1- New, 2- In progress, 3- Completed, 4- Canceled |
TsfShipHdrCtnSize
|
*
|
0
|
1
|
The container size.
|
|
|
|
|
|
|
weight |
number12_4 |
0 |
1 |
The weight of the container. |
TSF_SHIP_CARTON |
WEIGHT |
NUMBER |
12,4 |
No |
Weight of the shipment container. |
weight_uom |
varchar24 |
0 |
1 |
The unit of measure of the weight of the container. |
TSF_SHIP_CARTON |
WEIGHT_UOM |
VARCHAR2 |
4 |
No |
The UOM of the container |
tracking_number |
varchar2128 |
0 |
1 |
The tracking number for the container. |
TSF_SHIP_CARTON |
TRACKING_NUMBER |
VARCHAR2 |
128 |
No |
The Tracking number for the container |
skus |
number10 |
0 |
1 |
The number of skus within the container. |
|
|
|
|
No |
The number of skus within the container |
transfer_ids |
number15 |
0 |
999 |
Collection of all the unique transfer ids associated with the container. |
|
|
|
|
No |
List of transfer document identifiers associated to the shipment. |
order_related |
xs:boolean |
1 |
1 |
True if it has order related items, false otherwise. |
|
|
|
|
No |
True if document attached to the shipment are related to a customer order other wise false. |