This is a deprecated version of the containers table, used by DataSync customers before September 2024.

The containers table contains 1 row per container (container_id is the unique key).

Each container is part of 1 shipment (shipment_id).

This is a large table with denormalized columns to make it easy to use for reporting purposes.

COLUMN NAMEDESCRIPTIONTYPE
container_idContainer ID. This is the unique key of the table.text
container_numberContainer numbertext
shipment_idShipment ID associated to the containertext
shipment_bill_of_lading_numberShipment number from the tracking requesttext
shipment_normalized_numberThe normalized version of the shipment number used for querying the carriertext
shipment_reference_numbersReference numbers of the shipment, concatenatedtext
container_reference_numbersReference numbers of the container, concatenatedtext
shipment_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
shipping_line_scacStandard carrier alpha numeric code of the shipping linetext
shipping_line_nameName of the shipping linetext
origin_country_codeOrigin country code, populated only if the Empty Out event happens at a different location from the POLtext
origin_locodeOrigin UN/LOCODE, populated only if the Empty Out event happens at a different location from the POLtext
origin_cityOrigin city, populated only if the Empty Out event happens at a different location from the POLtext
origin_timezoneOrigin time zone, populated only if the Empty Out event happens at a different location from the POLtext
pol_country_codePort of Lading country codetext
pol_locodePort of Lading UN/LOCODEtext
pol_cityPort of Lading citytext
pol_timezonePort of Lading time zonetext
pod_country_codePort of Discharge country codetext
pod_locodePort of Discharge UN/LOCODEtext
pod_cityPort of Discharge citytext
pod_timezonePort of Discharge time zonetext
pod_terminal_firms_codePort of Discharge terminal firms codetext
pod_terminal_nicknamePort of Discharge terminal nicknametext
pod_terminal_namePort of Discharge terminal nametext
destination_country_codeDestination country codetext
destination_locodeDestination UN/LOCODEtext
destination_cityDestination citytext
destination_timezoneDestination time zonetext
destination_terminal_firms_codeDestination terminal firms codetext
destination_terminal_nicknameDestination terminal nicknametext
destination_terminal_nameDestination terminal nametext
pol_empty_out_atEmpty Out, as a UTC timestamptimestamp
pol_empty_out_at_localEmpty Out, as a string in the POL local time zonetext
pol_full_in_atFull In event, as a UTC timestamptimestamp
pol_full_in_at_localFull In event, as a string in the POL local time zonetext
origin_rail_loaded_atOrigin Rail Loaded, as a UTC timestamptimestamp
origin_rail_loaded_at_localOrigin Rail Loaded, as a string in the origin local time zonetext
origin_rail_departed_atOrigin Rail Departed, as a UTC timestamptimestamp
origin_rail_departed_at_localOrigin Rail Departed, as a string in the origin local time zonetext
pol_rail_arrived_atPort of Lading Rail Arrived, as a UTC timestamptimestamp
pol_rail_arrived_at_localPort of Lading Rail Arrived, as a string in the origin local time zonetext
pol_rail_unloaded_atPort of Lading Rail Unloaded, as a UTC timestamptimestamp
pol_rail_unloaded_at_localPort of Lading Rail Unloaded, as a string in the origin local time zonetext
pol_loaded_atPort of Lading Loaded event, as a UTC timestamptimestamp
pol_loaded_at_localPort of Lading Loaded event, as a string in the POL local time zonetext
pol_etd_atPort of Lading Estimated Time of Departure, as a UTC timestamptimestamp
pol_etd_at_localPort of Lading Estimated Time of Departure, as a string in the POL local time zonetext
pol_atd_atPort of Lading Actual Time of Departure, as a UTC timestamptimestamp
pol_atd_at_localPort of Lading Actual Time of Departure, as a string in the POL local time zonetext
pod_eta_atPort of Discharge Estimated Time of Arrival, as a UTC timestamptimestamp
pod_eta_at_localPort of Discharge Estimated Time of Arrival, as a string in the POD local time zonetext
pod_arrived_atPort of Discharge Actual Time of Arrival, as a UTC timestamptimestamp
pod_arrived_at_localPort of Discharge Actual Time of Arrival, as a string in the POD local time zonetext
pod_berthed_atPort of Discharge Berthed event, as a UTC timestamptimestamp
pod_berthed_at_localPort of Discharge Berthed event, as a string in the POD local time zonetext
pod_discharged_atPort of Discharge Discharged event, as a UTC timestamptimestamp
pod_discharged_at_localPort of Discharge Discharged event, as a string in the POD local time zonetext
pod_last_free_day_onCurrent Last Free Day at the POD terminal, as a UTC timestamptimestamp
pod_last_free_day_on_localCurrent Last Free Day at the POD terminal, as a string in the POD local time zonetext
pod_pickup_appointment_atPort of Discharge Pickup Appointment, as a UTC timestamptimestamp
pod_pickup_appointment_at_localPort of Discharge Pickup Appointment, as a string in the POD local time zonetext
pod_full_out_atPort of Discharge Full Out event, as a UTC timestamptimestamp
pod_full_out_at_localPort of Discharge Full Out event, as a string in the POD local time zonetext
rail_loaded_atFirst rail loaded after the POD discharge, as a UTC timestamptimestamp
rail_loaded_at_localFirst rail loaded after the POD discharge, as a string in the POD local time zonetext
rail_departed_atFirst rail departure after the POD discharge, as a UTC timestamptimestamp
rail_departed_at_localFirst rail departure after the POD discharge, as a string in the POD local time zonetext
destination_eta_atDestination Estimated Time of Arrival, as a UTC timestamptimestamp
destination_eta_at_localDestination Estimated Time of Arrival, as a string in the Destination local time zonetext
destination_arrived_atDestination Actual Time of Arrival, as a UTC timestamptimestamp
destination_arrived_at_localDestination Actual Time of Arrival, as a string in the Destination local time zonetext
rail_unloaded_atDestination Rail Unloaded, as a UTC timestamptimestamp
rail_unloaded_at_localDestination Rail Unloaded, as a string in the Destination local time zonetext
destination_full_out_atDestination Full Out event, as a UTC timestamptimestamp
destination_full_out_at_localDestination Full Out event, as a string in the Destination local time zonetext
empty_terminated_atContainer Empty Returned event, as a UTC timestamptimestamp
empty_terminated_at_localContainer Empty Returned event, as a string in the POD local time zonetext
fees_at_pod_terminalCurrent fee amounts, in JSON formattext
demurrage_at_pod_terminalCurrent demurrage amount owedtext
holds_at_pod_terminalCurrent terminal hold statuses, in JSON formattext
freight_hold_at_pod_terminalCurrent freight hold, value is either Hold or emptytext
customs_hold_at_pod_terminalCurrent customs hold, value is either Hold or emptytext
usda_hold_at_pod_terminalCurrent USDA hold, value is either Hold or emptytext
tmf_hold_at_pod_terminalCurrent Traffic Mitigation Fee hold, value is either Hold or emptytext
other_hold_at_pod_terminalAny other current hold, value is either Hold or emptytext
location_at_pod_terminalLocation at port of discharge terminaltext
availability_knownYes if Terminal49 is receiving availability status from the terminal, No otherwise.text
available_for_pickupIf availability_known is Yes, then Yes if the container is available to be picked up at terminal, No otherwisetext
equipment_lengthLength of the containerinteger
equipment_typeContainer type: Dry, Flat Rack, Open Top, Reefer, Tank, unknowntext
equipment_heightContainer height: High Cube, Standard, unknowntext
equipmentConcatenation of the equipment_length, equipment_type, and equipment_heighttext
weight_in_lbsWeight of the containre in lbsinteger
seal_numberSeal number of the containertext
pod_full_out_chassis_numberThe chassis number used when container was picked up at POD, if availabletext
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
terminal_checked_atWhen the terminal was last checked, as a UTC timestamptimestamp
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 container stopped, as a UTC timestamptimestamp
line_tracking_stopped_reasonThe reason Terminal49 stopped the trackingtext
created_atWhen the container was added, as a UTC timestamptimestamp
updated_atWhen the container was last updated, as a UTC timestamptimestamp