XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for StkRtnBolMod 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 |
bill_of_lading_tax_id |
varchar218 |
0 |
1 |
Bill of lading tax id |
SHIPMENT_BOL |
TAX_ID |
VARCHAR2` |
18 |
No |
this field contains the tax id of the supplier |
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 |
StkRtnModCarrierRole |
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_BOL |
Fill table column name. |
RIB or/and RSB or/and RSL |
Fill column length. |
Yes |
Fill this description. |
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 |
ship_to_address_type |
StkRtnModAddressType |
1 |
1 |
Bill of lading destination address type Valid values are BUSINESS, POSTAL, RETURNS, ORDER, INVOICE, REMITTANCE. |
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. |