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 BDI) |
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. |
TSF_DELV_LINE_ITEM |
CUST_ORD_EXTERNAL_ID |
VARCHAR2 |
128 |
No |
The customer order external identifier. |
fulfillment_order_id |
varchar2128 |
1 |
1 |
The fulfillment order external identifier. |
TSF_DELV_LINE_ITEM |
FUL_ORD_EXTERNAL_ID |
VARCHAR2 |
128 |
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 |
STATUS |
NUMBER |
4 |
Yes |
"Indicates the status of the fulfillment order. Valid values are:
0 - New, 1 - In Progress, 2 - Completed, 3 - Canceled, 4- Active" |
total_items |
number10 |
1 |
1 |
Total number of items on the fulfillment order. |
|
|
|
|
No |
Number of items associated with customer order on the container. |