| XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for TsfShipDesc 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 |
| shipment_id |
number15 |
1 |
1 |
The unique transfer shipment identifier. |
TSF_SHIP |
ID |
NUMBER |
15 |
Yes |
Fill this description. |
| store_id |
number10 |
1 |
1 |
Store identifier of the shipping store. |
TSF_SHIP |
STORE_ID |
NUMBER |
10 |
Yes |
Fill this description. |
| store_name |
varchar2128 |
0 |
1 |
Store name of the shipping store. |
STORE |
NAME |
VARCHAR2 |
150 |
No |
Fill this description. |
| bol_id |
number12 |
0 |
1 |
The unique bill of lading identifier. |
TSF_SHIP |
SHIPMENT_BOL_ID |
NUMBER |
12 |
No |
Fill this description. |
| asn |
varchar2128 |
0 |
1 |
The asn associated with a transfer shipment. |
TSF_SHIP |
ASN |
VARCHAR2 |
128 |
No |
Fill this description. |
| status |
tsf_ship_status |
1 |
1 |
The current status of a transfer shipment. Valid values are NEW, IN_PROGRESS, SUBMITTED, SHIPPED, CANCELED, UNKNOWN. |
TSF_SHIP |
STATUS. |
NUMBER |
4 |
Yes |
The status of the Shipment. 1-New,2-In Progress,3-Submitted,4-Shipped,5-Canceled |
| destination_type |
tsf_ship_dest_type |
1 |
1 |
The destination type of the destination the transfer shipment is being shipped to. Valid values are FINISHER, STORE, WAREHOUSE, UNKNOWN. |
TSF_SHIP |
DESTINATION_TYPE |
NUMBER |
2 |
Yes |
The shipment destination type. 1- Store, 3 Warehouse, 4 - Finisher |
| destination_name |
varchar2250 |
1 |
1 |
The destination name of the destination the transfer shipment is being shipped to. |
n/a (multiple tables) |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
| not_after_date |
xs:dateTime |
0 |
1 |
The stipulated deadline that transfer shipment must be shipped. |
TSF_SHIP |
NOT_AFTER_DATE |
date |
7 |
No |
Fill this description. |
| authorization_code |
varchar212 |
0 |
1 |
The authorization code for processing this shipment. |
TSF_SHIP |
AUTHORIZATION_CODE |
VARCHAR2 |
12 |
No |
Fill this description. |
| adhoc_doc_id |
number15 |
0 |
1 |
The unique adhoc transfer document identifier. |
TSF_SHIP |
ADHOC_DOCUMENT_ID |
NUMBER |
15 |
No |
Fill this description. |
| create_user |
varchar2128 |
1 |
1 |
The user who created the shipment. |
TSF_SHIP |
CREATE_USER |
VARCHAR2 |
128 |
Yes |
Fill this description. |
| update_user |
varchar2128 |
0 |
1 |
The user who last updated the shipment. |
TSF_SHIP |
UPDATE_USER |
VARCHAR2 |
128 |
Yes |
Fill this description. |
| submit_user |
varchar2128 |
0 |
1 |
The user who approved the shipment. |
TSF_SHIP |
SUBMIT_USER |
VARCHAR2 |
128 |
No |
Fill this description. |
| dispatch_user |
varchar2128 |
0 |
1 |
The user who last updated the shipment. |
TSF_SHIP |
DISPATCH_USER |
VARCHAR2 |
128 |
No |
Fill this description. |
| create_date |
xs:dateTime |
1 |
1 |
The date the transfer shipment was created. |
TSF_SHIP |
CREATE_DATE |
DATE |
7 |
Yes |
Fill this description. |
| last_update_date |
xs:dateTime |
0 |
1 |
The date the transfer shipment was last updated. |
TSF_SHIP |
UPDATE_DATE |
date |
7 |
Yes |
Fill this description. |
| submit_date |
xs:dateTime |
0 |
1 |
The date the transfer shipment was submitted. |
TSF_SHIP |
SUBMIT_DATE |
date |
7 |
No |
Fill this description. |
| dispatch_date |
xs:dateTime |
0 |
1 |
The date the transfer shipment was dispatched. |
TSF_SHIP |
DISPATCH_DATE |
DATE |
7 |
No |
Fill this description. |
| num_of_cartons |
number12 |
1 |
1 |
The number of containers within the shipment. |
n/a |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
| skus |
number12 |
1 |
1 |
The number of items in the transfer shipment. |
TSF_SHIP_LINE_ITEM |
n/a |
RIB or/and RSB |
Fill column length. |
Yes |
The number of lines in the transfer shipement |
| num_of_docs |
number12 |
1 |
1 |
The number of transfer documents associated with the transfer shipment. |
n/a |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
|
TsfShipDescNote
|
*
|
0
|
1000
|
Collection of transfer shipment notes that will be added to the transfer shipment.
|
|
|
|
|
|
|
