XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for TsfDelvCtnDesc 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. |
container_id |
number15 |
1 |
1 |
Container unique identifier. |
TSF_DELV_CARTON |
ID |
NUMBER |
15 |
Yes |
Container unique identifier. |
store_id |
number10 |
1 |
1 |
Store unique identifier. |
TSF_DELV_CARTON |
STORE_ID |
NUMBER |
10 |
Yes |
Store unique identifier. |
external_id |
varchar2128 |
0 |
1 |
The external identifier. |
TSF_DELV_CARTON |
EXTERNAL_ID |
VARCHAR2 |
128 |
No |
The external carton identifier |
misdirected_carton_id |
number15 |
0 |
1 |
Misdirected container identifier that refers back to the misdirected container this was copied from. |
TSF_DELV_CARTON |
ID |
NUMBER |
15 |
No |
Misdirected container identifier that refers back to the misdirected container this was copied from. |
reference_id |
varchar2128 |
0 |
1 |
A reference identifier. |
TSF_DELV_CARTON |
REFERENCE_ID |
VARCHAR2 |
128 |
No |
A reference identifier. |
status |
tsf_delv_carton_status |
1 |
1 |
The current status of the 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. |
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 |
damaged_reason |
varchar2128 |
0 |
1 |
The reason for container damage. |
TSF_DELV_CARTON |
DAMAGED_REASON |
VARCHAR2 |
128 |
No |
The reason for container damage. |
serial_code |
number18 |
0 |
1 |
A Serial code associated to the container. |
TSF_DELV_CARTON |
SERIAL_CODE |
NUMBER |
18 |
No |
A Serial code associated to the container. |
tracking_number |
varchar2128 |
0 |
1 |
The Tracking number for the container. |
TSF_DELV_CARTON |
TRACKING_NUMBER |
VARCHAR2 |
128 |
No |
The Tracking number for the container. |
create_date |
xs:dateTime |
1 |
1 |
The date when the transfer delivery container was created. |
TSF_DELV_CARTON |
CREATE_DATE |
DATE |
|
Yes |
The date when the transfer delivery container was created. |
update_date |
xs:dateTime |
1 |
1 |
The date when the transfer delivery container was updated. |
TSF_DELV_CARTON |
UPDATE_DATE |
DATE |
|
Yes |
The date when the transfer delivery container was updated. |
received_date |
xs:dateTime |
0 |
1 |
The date when the Transfer delivery carton was received. |
TSF_DELV_CARTON |
RECEIVED_DATE |
DATE |
|
No |
The date when the Transfer delivery carton was received. |
create_user |
varchar2128 |
1 |
1 |
The user who created the transfer delivery container. |
TSF_DELV_CARTON |
CREATE_USER |
VARCHAR2 |
128 |
Yes |
The user who created the transfer delivery container. |
update_user |
varchar2128 |
1 |
1 |
The user who last updated the transfer delivery container. |
TSF_DELV_CARTON |
UPDATE_USER |
VARCHAR2 |
128 |
Yes |
The user who last updated the transfer delivery container. |
received_user |
varchar2128 |
0 |
1 |
The user who received the transfer delivery container. |
TSF_DELV_CARTON |
RECEIVED_USER |
VARCHAR2 |
128 |
No |
The user who received the transfer delivery container. |
adjusted |
xs:boolean |
1 |
1 |
Indicates if container has been opened for adjustment. |
TSF_DELV_CARTON |
ADJUSTED |
VARCHAR2 |
1 |
Yes |
Indicates if container has been opened for adjustment. |
external_create |
xs:boolean |
1 |
1 |
Indicates if container was externally created. |
TSF_DELV_CARTON |
EXTERNAL_CREATE |
VARCHAR2 |
1 |
Yes |
Indicates if container was externally created. |
damage_remaining |
xs:boolean |
1 |
1 |
Indicates all remaining quantities should be damaged on final receipt. |
TSF_DELV_CARTON |
DAMAGE_REMAINING |
VARCHAR2 |
1 |
Yes |
Indicates all remaining quantities should be damaged on final receipt. |
receive_shopfloor |
xs:boolean |
1 |
1 |
True indicates the stock should be received at shop floor, false indicates it should be received in a back room. |
TSF_DELV_CARTON |
RECEIVE_AT_SHOP_FLOOR |
VARCHAR2 |
1 |
Yes |
True indicates the stock should be received at shop floor, false indicates it should be received in a back room. |
TsfDelvCtnItm
|
*
|
0
|
5000
|
Collection of items within the container.
|
|
|
|
|
|
|