XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for TsfDelvMisCtnVo in SIM application. |
SIM's Table Name |
SIM's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
SIM's Column Length |
Is Column Required in SIM's API? |
SIM's API Description |
store_id |
number10 |
1 |
1 |
The unique store identifier where container is created. |
TSF_DELV_CARTON |
STORE_ID |
NUMBER |
10 |
Yes |
Store unique identifier. |
delivery_id |
number15 |
1 |
1 |
Transfer delivery unique identifier. |
TSF_DELV_CARTON |
TSF_DELV_ID |
NUMBER |
15 |
Yes |
Transfer delivery 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 |
The container external identifier. |
TSF_DELV_CARTON |
EXTERNAL_ID |
VARCHAR2 |
128 |
No |
The external carton identifier |
asn |
varchar2128 |
0 |
1 |
An ASN number associated to the misdirected container. |
TSF_DELV |
ASN_ID |
VARCHAR2 |
128 |
No |
ASN 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. |