XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for FodCreBolMod 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 |
NA |
NA |
NA |
NA |
NA |
NA |
requested_pickup_date |
xs:dateTime |
0 |
1 |
Bill of lading requested pickup date |
NA |
NA |
NA |
NA |
NA |
NA |
carrier_role |
fod_carrier_role |
1 |
1 |
Bill of lading carrier role. Valid values are SENDER, RECEIVER, THIRD_PARTY. |
NA |
NA |
NA |
NA |
NA |
NA |
carrier_code |
varchar225 |
0 |
1 |
Bill of lading carrier code |
NA |
NA |
NA |
NA |
NA |
NA |
carrier_service_code |
varchar225 |
0 |
1 |
Bill of lading carrier service role |
NA |
NA |
NA |
NA |
NA |
NA |
carrier_name |
varchar2240 |
0 |
1 |
Bill of lading carrier name |
NA |
NA |
NA |
NA |
NA |
NA |
carrier_address |
varchar22000 |
0 |
1 |
Bill of lading carrier address |
NA |
NA |
NA |
NA |
NA |
NA |
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 |
NA |
NA |
NA |
NA |
NA |
NA |
tracking_number |
varchar2128 |
0 |
1 |
Bill of lading tracking number |
NA |
NA |
NA |
NA |
NA |
NA |