XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for TsfDelvFulOrdVo 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 |
container_id |
number15 |
1 |
1 |
Container unique identifier. |
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 container external identifier |
customer_order_id |
varchar2128 |
1 |
1 |
The customer order external identifier. |
FUL_ORD |
CUST_ORDER_ID |
VARCHAR2 |
128 |
Yes |
The customer order external identifier. |
fulfillment_order_id |
varchar2128 |
1 |
1 |
The fulfillment order external identifier. |
FUL_ORD_DLV |
EXTERNAL_ID |
VARCHAR2 |
25 |
No |
The fulfillment order external identifier. |
status |
ful_ord_status |
1 |
1 |
Fulfillment order status. Valid values are NEW, IN_PROGRESS, COMPLETED, CANCELED, UNKNOWN. |
FUL_ORD_DLV |
STATUS |
NUMBER |
4 |
Yes |
Indicates the status of the delivery. 1 - In Progress, 2 - Submitted, 3 - Completed, 4 - Canceled, 5- Active |
total_items |
number10 |
1 |
1 |
Total number of items on the fulfillment order. |
n/a |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |