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.
For each event timestamp there are 2 columns :
- a
timestamptype column in the UTC time zone (Universal Time Coordinated), e.g.,pol_loaded_at. - a
texttype column in the local time zone of where the event happened, e.g.,pol_loaded_at_local. The format of the text is :YYYY-MM-DD HH:MI:SS. For example2024-09-24 17:25:00for 5:25 PM on September 24, 2024. Depending on the event, the time zone applied can be the one from the Port of Lading (pol_timezone), the Port of Discharge (pod_timezone), or the Inland Destination (ind_timezone).
| COLUMN NAME | DESCRIPTION | TYPE |
|---|---|---|
container_id | Container ID. This is the unique key of the table. | text |
container_number | Container number | text |
shipment_id | Shipment ID associated to the container | text |
shipment_bill_of_lading_number | Shipment number exactly as submitted in the tracking request. May differ from shipment_normalized_number when the carrier expects a different format. | text |
shipment_normalized_number | The normalized version of the shipment number that Terminal49 uses when querying the carrier. Some carriers require a specific format (for example a stripped prefix or padded digits), so this value may differ from shipment_bill_of_lading_number. | text |
shipment_reference_numbers | Reference numbers of the shipment, concatenated | text |
container_reference_numbers | Reference numbers of the container, concatenated | text |
shipment_tags | Tags added to the shipment, sorted by alphabetical order, concatenated and separated by a comma | text |
customer_id | Account ID of the customer | text |
customer_name | Name of the customer | text |
shipping_line_scac | Standard carrier alpha numeric code of the shipping line | text |
shipping_line_name | Name of the shipping line | text |
pol_country_code | Port of Lading country code | text |
pol_locode | Port of Lading UN/LOCODE | text |
pol_city | Port of Lading city | text |
pol_timezone | Port of Lading time zone | text |
pod_country_code | Port of Discharge country code | text |
pod_locode | Port of Discharge UN/LOCODE | text |
pod_city | Port of Discharge city | text |
pod_timezone | Port of Discharge time zone | text |
pod_terminal_firms_code | Port of Discharge terminal firms code | text |
pod_terminal_nickname | Port of Discharge terminal nickname | text |
pod_terminal_name | Port of Discharge terminal name | text |
ind_country_code | Inland Destination country code | text |
ind_locode | Inland Destination UN/LOCODE | text |
ind_city | Inland Destination city | text |
ind_timezone | Inland Destination time zone | text |
ind_terminal_firms_code | Inland Destination terminal firms code | text |
ind_terminal_nickname | Inland Destination terminal nickname | text |
ind_terminal_name | Inland Destination terminal name | text |
empty_out_at | Empty Out, as a UTC timestamp | timestamp |
empty_out_at_local | Empty Out, as a string in the POL local time zone | text |
full_in_at | Full In event, as a UTC timestamp | timestamp |
full_in_at_local | Full In event, as a string in the POL local time zone | text |
pol_loaded_at | Port of Lading Loaded event, as a UTC timestamp | timestamp |
pol_loaded_at_local | Port of Lading Loaded event, as a string in the POL local time zone | text |
pol_etd_at | Port of Lading Estimated Time of Departure, as a UTC timestamp | timestamp |
pol_etd_at_local | Port of Lading Estimated Time of Departure, as a string in the POL local time zone | text |
pol_atd_at | Port of Lading Actual Time of Departure, as a UTC timestamp | timestamp |
pol_atd_at_local | Port of Lading Actual Time of Departure, as a string in the POL local time zone | text |
pod_eta_at | Port of Discharge Estimated Time of Arrival, as a UTC timestamp | timestamp |
pod_eta_at_local | Port of Discharge Estimated Time of Arrival, as a string in the POD local time zone | text |
pod_arrived_at | Port of Discharge Actual Time of Arrival, as a UTC timestamp | timestamp |
pod_arrived_at_local | Port of Discharge Actual Time of Arrival, as a string in the POD local time zone | text |
pod_berthed_at | Port of Discharge Berthed event, as a UTC timestamp | timestamp |
pod_berthed_at_local | Port of Discharge Berthed event, as a string in the POD local time zone | text |
pod_discharged_at | Port of Discharge Discharged event, as a UTC timestamp | timestamp |
pod_discharged_at_local | Port of Discharge Discharged event, as a string in the POD local time zone | text |
pod_last_free_day_on | Current Last Free Day from the POD terminal, as a UTC timestamp Named pickup_lfd in the API | timestamp |
pod_last_free_day_on_local | Current Last Free Day from the POD terminal, as a string in the POD local time zone | text |
ssl_last_free_day_on | Current Last Free Day from the shipping line, as a UTC timestamp | timestamp |
ssl_last_free_day_on_local | Current Last Free Day from the shipping line, as a string in the Destination or POD local time zone | text |
pod_pickup_appointment_at | Port of Discharge Pickup Appointment, as a UTC timestamp Named pickup_appointment_at in the API | timestamp |
pod_pickup_appointment_at_local | Port of Discharge Pickup Appointment, as a string in the POD local time zone | text |
pod_full_out_at | Port of Discharge Full Out event, as a UTC timestamp | timestamp |
pod_full_out_at_local | Port of Discharge Full Out event, as a string in the POD local time zone | text |
pod_rail_carrier_scac* | SCAC of the rail carrier at the POD | text |
pod_rail_loaded_at* | First rail loaded after the POD discharge, as a UTC timestamp | timestamp |
pod_rail_loaded_at_local* | First rail loaded after the POD discharge, as a string in the POD local time zone | text |
pod_rail_departed_at* | First rail departure after the POD discharge, as a UTC timestamp | timestamp |
pod_rail_departed_at_local* | First rail departure after the POD discharge, as a string in the POD local time zone | text |
ind_rail_carrier_scac* | SCAC of the rail carrier at the inland destination | text |
ind_eta_at* | Inland Destination Estimated Time of Arrival, as a UTC timestamp | timestamp |
ind_eta_at_local* | Inland Destination Estimated Time of Arrival, as a string in the Inland Destination local time zone | text |
ind_arrived_at* | Inland Destination Actual Time of Arrival, as a UTC timestamp Named ind_ata_at in the API | timestamp |
ind_arrived_at_local* | Inland Destination Actual Time of Arrival, as a string in the Inland Destination local time zone | text |
ind_rail_unloaded_at* | Inland Destination Rail Unloaded, as a UTC timestamp | timestamp |
ind_rail_unloaded_at_local* | Inland Destination Rail Unloaded, as a string in the Inland Destination local time zone | text |
ind_last_free_day_on* | Last Free Day at the inland destination facility from the rail carrier, as a UTC timestamp Named ind_facility_lfd_on in the API | timestamp |
ind_last_free_day_on_local* | Last Free Day at the inland destination facility from the rail carrier, as a string in the inland estination local time zone | text |
ind_full_out_at | Inland Destination Full Out event, as a UTC timestamp Named final_destination_full_out_at in the API | timestamp |
ind_full_out_at_local | Inland Destination Full Out event, as a string in the Inland Destination local time zone | text |
empty_terminated_at | Container Empty Returned event, as a UTC timestamp | timestamp |
empty_terminated_at_local | Container Empty Returned event, as a string in the Destination or POD local time zone | text |
fees_at_pod_terminal | Current fee amounts at the POD terminal, in JSON format. See hold and fee types. | text |
demurrage_at_pod_terminal | Current demurrage amount owed at the POD terminal. See fee types. | text |
holds_at_pod_terminal | Current terminal hold statuses at the POD, in JSON format. See hold types. | text |
freight_hold_at_pod_terminal | Current freight hold at the POD terminal, value is either “Hold”, “Pending”, or blank | text |
customs_hold_at_pod_terminal | Current customs hold at the POD terminal, value is either “Hold”, “Pending”, or blank | text |
usda_hold_at_pod_terminal | Current USDA hold at the POD terminal, value is either “Hold”, “Pending”, or blank | text |
tmf_hold_at_pod_terminal | Current Traffic Mitigation Fee hold at the POD terminal, value is either “Hold”, “Pending”, or blank | text |
other_hold_at_pod_terminal | Any other current hold at the POD terminal, value is either “Hold”, “Pending”, or blank | text |
location_at_pod_terminal | Location at the port of discharge terminal | text |
availability_known | Yes if Terminal49 is receiving availability status from the POD terminal, No otherwise. | text |
available_for_pickup | If availability_known is Yes, then Yes if the container is available to be picked up at the POD terminal, No otherwise | text |
equipment_length | Length of the container | integer |
equipment_type | Container type: Dry, Flat Rack, Open Top, Reefer, Tank, unknown | text |
equipment_height | Container height: High Cube, Standard, unknown | text |
equipment | Concatenation of the equipment_length, equipment_type, and equipment_height | text |
weight_in_lbs | Weight of the containre in lbs | integer |
seal_number | Seal number of the container | text |
pod_full_out_chassis_number | The chassis number used when container was picked up at POD, if available | text |
pod_voyage_number | Voyage number of the vessel that arrived or will arrive at the POD | text |
pod_vessel_name | Name of the vessel that arrived or will arrive at the POD | text |
pod_vessel_imo | IMO of the vessel that arrived or will arrive at the POD | text |
terminal_checked_at | When the POD terminal was last checked, as a UTC timestamp | timestamp |
line_tracking_last_succeeded_at | When the shipment information was last refreshed from the shipping line, as a UTC timestamp | timestamp |
line_tracking_stopped_at | When the tracking of the container stopped, as a UTC timestamp | timestamp |
line_tracking_stopped_reason | The reason Terminal49 stopped the tracking | text |
created_at | When the container was added, as a UTC timestamp | timestamp |
updated_at | When the container was last updated, as a UTC timestamp | timestamp |