XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for StrVnsModBol 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 |
Motive identifier |
SHIPMENT_BOL |
MOTIVE |
VARCHAR2 |
120 |
No |
this field contains the motive |
bill_of_lading_tax_id |
varchar218 |
0 |
1 |
Tax identifier |
SHIPMENT_BOL |
TAX_ID |
VARCHAR2 |
18 |
No |
this field contains the tax id of the supplier |
requested_pickup_date |
xs:dateTime |
0 |
1 |
Date pickup is requested |
SHIPMENT_BOL |
REQUESTED_PICKUP_DATE |
DATE |
Fill column length. |
No |
the field contains the requested pickup date |
carrier_type |
rtv_ship_mod_carrier_type |
1 |
1 |
Type of carrier used for shipment 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 |
varchar24 |
0 |
1 |
Carrier code of carrier responsible for shipment |
SHIPMENT_CARRIER |
CODE |
VARCHAR2 |
4 |
No |
unique code identifier for a carrier |
carrier_service_code |
varchar26 |
0 |
1 |
Service code of shipment service being used |
SHIPMENT_BOL |
SHIP_CARRIER_SERVICE_ID |
NUMBER |
10,0 |
No |
Fill this description. |
carrier_name |
varchar2128 |
0 |
1 |
Name of the carrier |
SHIPMENT_BOL |
THIRD_PARTY_NAME |
VARCHAR2 |
240 |
No |
this field contains the name of the third party |
carrier_address |
varchar22000 |
0 |
1 |
Address of the carrier |
SHIPMENT_BOL |
THIRD_PARTY_ADDRESS |
VARCHAR2 |
2000 |
No |
this field contains the address of the third party |
ship_to_address_type |
rtv_ship_mod_address_type |
1 |
1 |
Address type of the destination address Valid values are BUSINESS, POSTAL, RETURNS, ORDER, INVOICE, REMITTANCE, BILLING, DELIVERY. |
SHIPMENT_BOL |
SHIP_TO_ADDRESS_TYPE |
VARCHAR2 |
2 |
Yes |
"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 |
Alternate ship to address if substituted for normal address |
SHIPMENT_BOL |
ALT_DESTINATION_ADDRESS |
VARCHAR2 |
2000 |
No |
this field contains the alternate destination address |