XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for FodBol 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 |
Fill column length. |
No |
the field contains the requested pickup date |
carrier_role |
fod_carrier_role |
1 |
1 |
Bill of lading carrier role Valid values are SENDER, RECEIVER, THIRD_PARTY. |
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. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB or/and RSL |
Fill column length. |
Yes |
Fill this description. |
package_weight |
number12_4 |
0 |
1 |
The weight of the package measured by package_weight_uom. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB or/and RSL |
Fill column length. |
Yes |
Fill this description. |
package_weight_uom |
varchar24 |
0 |
1 |
The unit of measure of the package weight. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB or/and RSL |
Fill column length. |
Yes |
Fill this description. |
ship_to_address_type |
fod_address_type |
1 |
1 |
Bill of lading destination address type Valid values are BUSINESS, POSTAL, RETURNS, ORDER, INVOICE, REMITTANCE, NO_VALUE. |
SHIPMENT_BOL |
SHIP_TO_ADDRESS_TYPE |
VARCHAR2 |
2 |
No |
The address type for the ship to address. valid values
01 - Business Address,
02 - Postal Address,
03 - Return Address,
04 - Order Address,
05 - Invoice Address,
06 - Remittance Address,
07 - Billing Address,
08 - Delivery Address |
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. |