XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for ManifestCloseVo 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 |
carrier_code |
varchar24 |
1 |
1 |
Carrier code |
SHIPMENT_CARRIER |
CODE |
VARCHAR2 |
4 |
Yes |
Unique code identifier for a carrier |
carrier_service_code |
varchar26 |
0 |
1 |
Carrier service code. |
SHIPMENT_CARRIER_SERVICE |
CODE |
VARCHAR2 |
6 |
Yes |
Unique identifier that represents the delivery service |
carrier_track_info_col |
varchar2120 |
0 |
1000 |
Collection of carrier tracking information. |
SHIPMENT_BOL |
TRACKING_NUMBER |
VARCHAR2 |
128 |
No |
Holds the tracking number for the transaction. |
ship_date |
xs:dateTime |
0 |
1 |
All items manifested prior to this date have been shipped. |
TRANSFER,RETURN,FUL_ORD_DLV |
SUBMIT_DATE |
Date |
Fill column length. |
No |
Transfer pre-shipment submit date. |