XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for TsfShipHdrDesc 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 |
The unique identifier for the transfer shipment |
asn |
varchar2128 |
0 |
1 |
ASN external identifier. |
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 |
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 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 the transfer shipment is being shipped to. |
WAREHOUSE,PARTNER,STORE |
NAME |
VARCHAR2 |
150 , 240 |
Yes |
Name of the destination entity |
last_update_date |
xs:dateTime |
1 |
1 |
The date when the transfer shipment was last updated. |
TSF_SHIP |
UPDATE_DATE |
DATE |
|
Yes |
The date when the Shipment was updated |
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_containers |
number10 |
1 |
1 |
The number of containers within the shipment. |
|
|
|
|
No |
Derived from number of cartons associated with shipment |
order_related |
xs:boolean |
1 |
1 |
Indicates if shipment(s) have any customer order. |
|
|
|
|
No |
Derived from the associated transfer document. |