| XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for TsfShipCtnDesc 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 |
| tsf_ship_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 |
| store_id |
number10 |
1 |
1 |
The unique store identifier from where shipment is created. |
TSF_SHIP_CARTON |
STORE_ID |
NUMBER |
10 |
Yes |
The store id from which the Shipment is created |
| external_id |
varchar2128 |
0 |
1 |
The external identifier. |
TSF_SHIP_CARTON |
EXTERNAL_ID |
VARCHAR2 |
128 |
No |
The external identifier |
| tsf_ship_id |
number15 |
1 |
1 |
The transfer shipment identifier. |
TSF_SHIP_CARTON |
TSF_SHIP_ID |
NUMBER |
15 |
Yes |
The transfer shipment identifer the carton is associated to |
| 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 |
| destination_type |
tsf_ship_dest_type |
1 |
1 |
The destination type of the destination the transfer shipment is being shipped to. Valid values are FINISHER, STORE, WAREHOUSE, UNKNOWN. |
TSF_SHIP |
DESTINATION_TYPE |
RIB or/and RSB |
2 |
Yes |
The shipment destination type. 1- Store, 3 Warehouse, 4 - Finisher |
| destination_name |
varchar2128 |
1 |
1 |
The destination name of the destination the transfer shipment is being shipped to. |
WAREHOUSE,PARTNER,STORE |
NAME |
VARCHAR2 |
150 , 240 |
Yes |
Shipment destination entity name. |
| hierarchy_level |
tsf_hierarchy_level |
1 |
1 |
The container restricted hierarchy level. Valid values are NONE, DEPT, CLASS, SUBCLASS. |
TSF_SHIP_CARTON |
RESTRICTION_LEVEL |
NUMBER |
4 |
Yes |
The hierarchy restriction level for items in a container |
|
TsfShipCtnSize
|
*
|
0
|
1
|
The container size.
|
|
|
|
|
|
|
| weight |
number12_4 |
0 |
1 |
The weight of the container. |
TSF_SHIP_CARTON |
WEIGHT |
NUMBER |
12,4 |
No |
The weight of the 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 |
| create_user |
varchar2128 |
1 |
1 |
The user who created the container. |
TSF_SHIP_CARTON |
CREATE_USER |
VARCHAR2 |
128 |
Yes |
The user who created the Shipment carton |
| update_user |
varchar2128 |
0 |
1 |
The user who last updated the container. |
TSF_SHIP_CARTON |
UPDATE_USER |
VARCHAR2 |
128 |
Yes |
The user who last updated the Shipment carton |
| approval_user |
varchar2128 |
0 |
1 |
The user who approved the container. |
TSF_SHIP_CARTON |
APPROVAL_USER |
VARCHAR2 |
128 |
No |
The user who approved the Shipment |
| create_date |
xs:dateTime |
1 |
1 |
The date the transfer shipment container was created. |
TSF_SHIP_CARTON. |
CREATE_DATE |
DATE |
|
Yes |
The create date of the Shipment carton |
| update_date |
xs:dateTime |
0 |
1 |
The most recent date when the transfer shipment container was updated. |
TSF_SHIP_CARTON |
UPDATE_DATE |
DATE |
|
Yes |
The date when the Shipment carton was updated |
| approval_date |
xs:dateTime |
0 |
1 |
The date when the transfer shipment container was approved. |
TSF_SHIP_CARTON |
APPROVAL_DATE |
DATE |
|
No |
The date when the Shipment was approved |
| use_available |
xs:boolean |
1 |
1 |
True if container uses only available inventory. |
TSF_SHIP_CARTON |
USE_AVAILABLE |
VARCHAR2 |
1 |
Yes |
value of Y indicates carton will use only available inventory, N means carton will use unavailable inventory |
| order_related |
xs:boolean |
1 |
1 |
Indicates if any customer orders are associated with the container. |
TSF_SHIP_CARTON |
CUSTOMER_ORDER_RELATED |
NUMBER |
4 |
Yes |
Indicates if carton contains customer order items. 1 - all items customer order related; 2 - some items customer related; 3 - no items customer order related |
|
TsfShipCtnItm
|
*
|
0
|
5000
|
A collection of items in the container.
|
|
|
|
|
|
|
