XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for StsTsfBolMod 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 |
bill_of_lading_motive_id |
varchar2120 |
0 |
1 |
Bill of lading motive identifier |
SHIPMENT_BOL |
MOTIVE |
VARCHAR2 |
120 |
Yes |
this field contains the motive |
requested_pickup_date |
xs:dateTime |
0 |
1 |
Bill of lading requested pickup date |
SHIPMENT_BOL |
REQUESTED_PICKUP_DATE |
DATE |
|
No |
the field contains the requested pickup date |
carrier_role |
sts_tsf_mod_carrier_role |
1 |
1 |
Bill of lading carrier role. Valid values are THIRD_PARTY, SENDER. |
SHIPMENT_BOL |
CARRIER_ROLE |
varchar2 |
12 |
Yes |
this field contains the type of carrier for the shipment |
carrier_code |
varchar225 |
0 |
1 |
Bill of lading carrier code |
SHIPMENT_CARRIER |
CODE |
VARCHAR2 |
4 |
Yes |
Unique code identifier for a carrier |
carrier_service_code |
varchar225 |
0 |
1 |
Bill of lading carrier service role |
SHIPMENT_CARRIER_SERVICE |
CODE |
VARCHAR2 |
6 |
Yes |
Unique identifier that represents the delivery service |
carrier_name |
varchar2240 |
0 |
1 |
Bill of lading carrier name |
SHIPMENT_BOL |
THIRD_PARTY_NAME |
varchar2 |
240 |
No |
this field contains the name of the third party |
carrier_address |
varchar22000 |
0 |
1 |
Bill of lading carrier address |
SHIPMENT_BOL |
THIRD_PARTY_ADDRESS |
VARCHAR2 |
2000 |
No |
this field contains the address of the third party |
carton_type_id |
number12 |
0 |
1 |
Unique identifier of the shipment carton type that the order is shipped in. |
NA |
NA |
NA |
NA |
NA |
NA |
package_weight |
number12_4 |
0 |
1 |
The weight of the package measured by package_weight_uom. |
NA |
NA |
NA |
NA |
NA |
NA |
package_weight_uom |
varchar24 |
0 |
1 |
The unit of measure of the package weight. |
NA |
NA |
NA |
NA |
NA |
NA |
alternate_ship_to_address |
varchar22000 |
0 |
1 |
Bill of lading alternate destination address |
SHIPMENT_BOL |
ALT_DESTINATION_ADDRESS |
VARCHAR2 |
2000 |
No |
this field contains the alternate destination address |
tracking_number |
varchar2128 |
0 |
1 |
Bill of lading tracking number |
SHIPMENT_BOL |
TRACKING_NUMBER |
VARCHAR2 |
128 |
No |
Holds the tracking number for the transaction. |