XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for TsfDelvCtnHdrDesc 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 |
delivery_id |
number15 |
1 |
1 |
Transfer delivery unique identifier. |
TSF_DELV_CARTON |
TSF_DELV_ID |
NUMBER |
15 |
Yes |
Transfer delivery unique identifier. |
store_id |
number10 |
1 |
1 |
Store unique identifier. |
TSF_DELV_CARTON |
STORE_ID |
NUMBER |
10 |
Yes |
Store unique identifier. |
carton_id |
number15 |
1 |
1 |
The unique identifier for the transfer delivery container. |
TSF_DELV_CARTON |
ID |
NUMBER |
15 |
Yes |
Container unique identifier. |
external_id |
varchar2128 |
0 |
1 |
Container external identifier. |
TSF_DELV_CARTON |
EXTERNAL_ID |
VARCHAR2 |
128 |
No |
Container external identifier. |
status |
tsf_delv_carton_status |
1 |
1 |
The current status of the transfer delivery container. Valid values are IN_PROGRESS, DAMAGED, RECEIVED, MISSING, UNKNOWN. |
TSF_DELV_CARTON |
STATUS |
NUMBER |
4 |
Yes |
The status of the Transfer delivery carton. 1 - New,2 - In progress,3 - Damaged,4 - Received,5 - Missing. |
number_of_skus |
number10 |
1 |
1 |
Number of line items in the transfer delivery container. |
|
|
|
|
No |
Number of items on the container. |
number_of_docs |
number10 |
1 |
1 |
Number of documents in the transfer delivery container. |
|
|
|
|
No |
Number of document associated with items on the container. |
customer_order_related |
cust_order_related |
1 |
1 |
Indicates if container contains customer order items. Valid values are YES, NO, MIX, UNKNOWN. |
TSF_DELV_CARTON |
CUSTOMER_ORDER_RELATED |
NUMBER |
4 |
No |
Indicates if carton contains customer order items. 1 - all items customer order related; 2 - some items customer related; 3 - no items customer order related |
discrepant |
xs:boolean |
1 |
1 |
Indicates if there is any discrepancy in the item quantities. |
TSF_DELV_CARTON |
DISCREPANT |
VARCHAR2 |
1 |
Yes |
Indicates if there is any discrepancy in the item quantities. |
uin_required |
xs:boolean |
1 |
1 |
Indicates if there is any UINs (Universal Identification Number) in the container. |
|
|
|
|
No |
True if the container has UINs else false. |