The shipments table contains 1 row per shipment (shipment_id is the unique key).

A shipment contains 1 or more containers.

COLUMN NAMEDESCRIPTIONTYPE
shipment_idShipment ID. This is the unique key of the table.text
shipping_line_scacStandard carrier alpha numeric code of the shipping linetext
shipping_line_nameName of the shipping linetext
bill_of_lading_numberShipment number from the tracking requesttext
normalized_numberThe normalized version of the shipment number used for querying the carriertext
reference_numbersReference numbers of the shipment, contatenatedtext
tagsTags added to the shipment, sorted by alphabetical order, concatenated and separated by a commatext
customer_idAccount ID of the customertext
customer_nameName of the customertext
pol_locodePort of Lading UN/LOCODEtext
pod_locodePort of Discharge UN/LOCODEtext
pod_terminal_firms_codePort of Discharge terminal firms codetext
destination_locodeDestination UN/LOCODEtext
destination_terminal_firms_codeDestination terminal firms codetext
pol_atd_atPort of Lading Actual Time of Departure, as a UTC timestamptimestamp
pol_etd_atPort of Lading Estimated Time of Departure, as a UTC timestamptimestamp
pod_eta_atPort of Discharge Estimated Time of Arrival, as a UTC timestamptimestamp
pod_arrived_atPort of Discharge Actual Time of Arrival, as a UTC timestamptimestamp
pod_voyage_numberVoyage number of the vessel that arrived or will arrive at the PODtext
pod_vessel_nameName of the vessel that arrived or will arrive at the PODtext
pod_vessel_imoIMO of the vessel that arrived or will arrive at the PODtext
line_tracking_last_succeeded_atWhen the shipment information was last refreshed from the shipping line, as a UTC timestamptimestamp
line_tracking_stopped_atWhen the tracking of the shipment stopped, as a UTC timestamptimestamp
line_tracking_stopped_reasonReason why the tracking of the shipment stoppedtext
created_atWhen the shipment was added, as a UTC timestamptimestamp
updated_atWhen the shipment was last updated, as a UTC timestamptimestamp