| XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for TsfDelvDesc 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. |
| asn |
varchar2128 |
1 |
1 |
External identifier of the ASN for the transfer delivery. |
TSF_DELV |
ASN_ID |
VARCHAR2 |
128 |
Yes |
External identifier of the ASN for the transfer delivery. |
| 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 |
VARCHAR2 |
150 |
Yes |
The name of the location that shipped the items. |
| 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. |
| carrier_name |
varchar2128 |
0 |
1 |
The name of the carrier. |
TSF_DELV |
CARRIER_ENTITY |
VARCHAR2 |
128 |
No |
The name of the carrier. |
| carrier_type |
carrier_type |
1 |
1 |
The type of the carrier. Valid values are CORPORATE, THIRD_PARTY, UNKNOWN. |
TSF_DELV |
CARRIER_TYPE |
NUMBER |
2 |
No |
The Carrier type.0 - Corporate,1 - Third Party |
| carrier_code |
varchar24 |
0 |
1 |
Unique code identifier for a carrier. |
TSF_DELV |
CARRIER_CODE |
VARCHAR2 |
4 |
No |
Unique code identifier for a carrier. |
| source_address |
varchar21000 |
0 |
1 |
The address of source location that is sending the shipment. |
TSF_DELV |
SOURCE_ADDRESS |
VARCHAR2 |
1000 |
Yes |
The address of source location that is sending the shipment. |
| license_plate |
varchar2128 |
0 |
1 |
License plate. |
TSF_DELV |
LICENSE_PLATE |
VARCHAR2 |
128 |
No |
License plate. |
| freight_id |
varchar2128 |
0 |
1 |
Freight identifier. |
TSF_DELV |
FREIGHT_ID |
VARCHAR2 |
128 |
No |
Freight identifier. |
| external_bol |
varchar2128 |
0 |
1 |
External bill of lading number. |
TSF_DELV |
BOL_EXTERNAL_ID |
VARCHAR2 |
128 |
No |
External bill of lading number. |
| create_date |
xs:dateTime |
1 |
1 |
The date when transfer delivery was created. |
TSF_DELV |
CREATE_DATE |
DATE |
7 |
Yes |
The date when transfer delivery was created. |
| update_date |
xs:dateTime |
0 |
1 |
The date when transfer delivery was last updated. |
TSF_DELV |
UPDATE_DATE |
DATE |
7 |
Yes |
The date when transfer delivery was last updated. |
| expected_date |
xs:dateTime |
0 |
1 |
The expected date of the transfer delivery. |
TSF_DELV |
EXPECTED_DATE |
DATE |
7 |
No |
The expected date of the transfer delivery. |
| received_date |
xs:dateTime |
0 |
1 |
The received date of the transfer delivery. |
TSF_DELV |
RECEIVED_DATE |
DATE |
7 |
No |
The received date of the transfer delivery. |
| create_user |
varchar2128 |
1 |
1 |
The user who created the transfer delivery. |
TSF_DELV |
CREATE_DATE |
DATE |
7 |
Yes |
The user who created the transfer delivery |
| update_user |
varchar2128 |
1 |
1 |
The user who last updated the transfer delivery. |
TSF_DELV |
UPDATE_USER |
VARCHAR2 |
128 |
Yes |
Fill this description. |
| 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. |
| adhoc_document_id |
number15 |
0 |
1 |
Reference to adhoc transfer document. |
TSF_DELV |
ADHOC_DOCUMENT_ID |
NUMBER |
15 |
No |
Reference to adhoc transfer document. |
| 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. |
| total_documents |
number10 |
1 |
1 |
Total number of documents in the transfer delivery. |
n/a |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
|
TsfDelvDescNote
|
*
|
0
|
1000
|
Notes associated to the vendor delivery.
|
|
|
|
|
|
|
