Aruba Import Export Data — Bill of Lading & Customs

Shipment & dates

• bill_of_lading_no Unique bill of lading number
• master_bill_of_lading Master B/L reference
• bill_type_code B/L type (e.g. seaway bill)
• flow Trade direction (import / export)
• sailing_date Date the vessel departed origin
• estimate_arrival_date Estimated arrival date
• actual_arrival_date Actual arrival date
• year Shipment year
• month Shipment month
• period Reporting period (year-month)
• mode_of_transportation Sea / air / land mode
• system_identity_id Internal record identifier

Product & HS classification

• hs_code Harmonised System (HS) code
• product_description Full commercial description of goods
• hs_code_sure_level Confidence level of the HS match
• marks_and_numbers Shipping marks & numbers

Route & geography

• origin_country Country goods shipped from
• destination_country Country goods shipped to
• del_country Final delivery country
• country_sure_level Confidence level of the country match
• origin_port Port of loading
• destination_port Port of discharge
• port_of_final_delivery Final delivery point

Value, quantity & weight

• lane_value_usd Shipment value on the lane (USD)
• cif_value_usd CIF value (USD)
• estimated_value_usd Estimated value (USD)
• per_shipment_quantity Quantity in this shipment
• quantity_unit Unit of quantity
• per_shipment_weight_kg Shipment weight (kg)
• weight_unit Unit of weight
• cbm Cubic metres (volume)
• teu Twenty-foot equivalent units
• feu Forty-foot equivalent units

Supplier / exporter

• supplier_name Exporter / shipper company name 🔒 paid
• supplier_address Supplier full address 🔒 paid
• supplier_city Supplier city 🔒 paid
• supplier_phone Supplier phone number 🔒 paid
• supplier_website Supplier website 🔒 paid
• supplier_contact Supplier contact 🔒 paid
• indicator_true_supplier Verified-supplier flag

Buyer / importer

• importer_name Importer / consignee company name 🔒 paid
• importer_address Importer full address 🔒 paid
• importer_city Importer city 🔒 paid
• importer_phone Importer phone number 🔒 paid
• importer_website Importer website 🔒 paid
• importer_contact Importer contact 🔒 paid
• indicator_true_buyer Verified-buyer flag

Notify parties

• notify_party_name Notify party company name 🔒 paid
• notify_party_address Notify party address 🔒 paid
• also_notify_name Additional notify party 🔒 paid

Vessel & voyage

• vessel_name Vessel name
• vessel_code IMO vessel code
• vessel_country_code Vessel flag country
• voyage Voyage number
• manifest_no Manifest number
• carrier_sasc_code Carrier SCAC code
• freight_forwarder_name Freight forwarder

Container details

• container_id Container number
• container_size Container size
• container_type Container type
• container_desc_code Container description code
• container_load_status FCL / LCL load status
• container_type_of_service Service type

Booking contacts

• booking_contact_email Booking contact email 🔒 paid
• booking_contact_phone Booking contact phone 🔒 paid