XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for TsfDelvHdrDesc 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 |
delivery_id |
number15 |
1 |
1 |
Transfer delivery unique identifier. |
TSF_DELV |
ID |
NUMBER |
15 |
Yes |
Transfer delivery unique identifier. |
store_id |
number10 |
1 |
1 |
Store identifier. |
TSF_DELV |
STORE_ID |
NUMBER |
10 |
Yes |
Store identifier. |
source_type |
tsf_delv_source_type |
1 |
1 |
The type of location that shipped the items. Valid values are WAREHOUSE, FINISHER, STORE, UNKNOWN. |
TSF_DELV |
SOURCE_TYPE |
NUMBER |
4 |
Yes |
The Transfer delivery source type. 1- Store, 3 Warehouse, 4 - Finisher |
source_name |
varchar2250 |
0 |
1 |
The name of the location that shipped the items. |
STORE, WAREHOUSE, FINISHER |
NAME |
RIB or/and RSB |
150 |
Yes |
Fill this description. |
status |
tsf_delv_status |
1 |
1 |
Status of the transfer delivery. Valid values are NEW, IN_PROGRESS, RECEIVED, CANCELED, UNKNOWN. |
TSF_DELV |
STATUS |
NUMBER |
4 |
Yes |
The status of Transfer Delivery.0 - New,1 - In Progress,2 - Received,3 - Missing,4 - Canceled,5 - Damaged. |
asn |
varchar2128 |
1 |
1 |
External ASN. |
TSF_DELV |
ASN_ID |
VARCHAR2 |
128 |
No |
ASN external identifier. |
expected_date |
xs:dateTime |
0 |
1 |
The date the transfer delivery is expected to arrive. |
TSF_DELV |
EXPECTED_DATE |
DATE |
7 |
No |
Delivery expected date |
received_date |
xs:dateTime |
0 |
1 |
The date the transfer delivery was received. |
TSF_DELV |
RECEIVED_DATE |
DATE |
7 |
No |
Delivery received date |
received_user |
varchar2128 |
0 |
1 |
The user who received the transfer delivery. |
TSF_DELV |
RECEIVED_USER |
VARCHAR2 |
128 |
No |
The user who received the transfer delivery. |
num_of_cartons |
number10 |
1 |
1 |
Total number of containers in the transfer delivery. |
n/a |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
total_skus |
number10 |
1 |
1 |
Total number of items in the transfer delivery. |
n/a |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
cartons_missing |
xs:boolean |
1 |
1 |
Indicates if the transfer delivery holds missing containers. |
n/a |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
customer_order_related |
xs:boolean |
1 |
1 |
True indicates the transfer delivery is associated to customer order. |
n/a |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |