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 BDI) |
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 |
Shipment unique identifier. |
store_id |
number10 |
1 |
1 |
Store identifier of the shipping store. |
TSF_SHIP |
STORE_ID |
NUMBER |
10 |
Yes |
Store identifier. |
store_name |
varchar2128 |
0 |
1 |
Store name of the shipping store. |
STORE |
NAME |
VARCHAR2 |
150 |
No |
Store name. |
bol_id |
number12 |
0 |
1 |
The unique bill of lading identifier. |
TSF_SHIP |
SHIPMENT_BOL_ID |
NUMBER |
12 |
No |
The shipment bill of lading id |
asn |
varchar2128 |
0 |
1 |
The asn associated with a transfer shipment. |
TSF_SHIP |
ASN |
VARCHAR2 |
128 |
No |
The Advance Shipment Notification number |
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 |
2 |
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. |
WAREHOUSE,PARTNER,STORE |
NAME |
VARCHAR2 |
150 , 240 |
Yes |
Destination entity name. |
not_after_date |
xs:dateTime |
0 |
1 |
The stipulated deadline that transfer shipment must be shipped. |
TSF_SHIP |
NOT_AFTER_DATE |
DATE |
|
No |
The not after date for the shipment |
authorization_code |
varchar212 |
0 |
1 |
The authorization code for processing this shipment. |
TSF_SHIP |
AUTHORIZATION_CODE |
VARCHAR2 |
12 |
No |
The authorization number |
adhoc_doc_id |
number15 |
0 |
1 |
The unique adhoc transfer document identifier. |
TSF_SHIP |
ADHOC_DOCUMENT_ID |
NUMBER |
15 |
No |
Refer to adhoc transfer document identifier. |
create_user |
varchar2128 |
1 |
1 |
The user who created the shipment. |
TSF_SHIP |
CREATE_USER |
VARCHAR2 |
128 |
Yes |
The user who created the Shipment |
update_user |
varchar2128 |
0 |
1 |
The user who last updated the shipment. |
TSF_SHIP |
UPDATE_USER |
VARCHAR2 |
128 |
Yes |
The user who last updated the Shipment |
submit_user |
varchar2128 |
0 |
1 |
The user who approved the shipment. |
TSF_SHIP |
SUBMIT_USER |
VARCHAR2 |
128 |
No |
The user who submitted the Shipment |
dispatch_user |
varchar2128 |
0 |
1 |
The user who last updated the shipment. |
TSF_SHIP |
DISPATCH_USER |
VARCHAR2 |
128 |
No |
The user who dispatched the Shipment |
create_date |
xs:dateTime |
1 |
1 |
The date the transfer shipment was created. |
TSF_SHIP |
CREATE_DATE |
DATE |
|
Yes |
The create date of the Shipment |
last_update_date |
xs:dateTime |
0 |
1 |
The date the transfer shipment was last updated. |
TSF_SHIP |
UPDATE_DATE |
DATE |
|
Yes |
The date when the Shipment was updated |
submit_date |
xs:dateTime |
0 |
1 |
The date the transfer shipment was submitted. |
TSF_SHIP |
SUBMIT_DATE |
DATE |
|
No |
The date when the Shipment was submitted |
dispatch_date |
xs:dateTime |
0 |
1 |
The date the transfer shipment was dispatched. |
TSF_SHIP |
DISPATCH_DATE |
DATE |
|
No |
The date when the Shipment was dispatched |
num_of_cartons |
number12 |
1 |
1 |
The number of containers within the shipment. |
|
|
|
|
No |
Number of containers associated with shipment. |
skus |
number12 |
1 |
1 |
The number of items in the transfer shipment. |
|
|
|
|
No |
The number of lines in the transfer shipement |
num_of_docs |
number12 |
1 |
1 |
The number of transfer documents associated with the transfer shipment. |
|
|
|
|
No |
Number of transfer document associated with shipment. |
TsfShipDescNote
|
*
|
0
|
1000
|
Collection of transfer shipment notes that will be added to the transfer shipment.
|
|
|
|
|
|
|