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.
|
|
|
|
|
|
|