> ## Documentation Index
> Fetch the complete documentation index at: https://terminal49-mintlify-seo-audit-2026-10-05.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# Shipments Table

> Reference the Terminal49 DataSync shipments table schema, including column definitions, relationships to containers, and shipment-level tracking fields.

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

A shipment contains 1 or more containers.

| COLUMN NAME | DESCRIPTION | TYPE |
| - | - | - |
| `shipment_id` | Shipment ID. This is the unique key of the table. | `text` |
| `shipping_line_scac` | Standard carrier alpha numeric code of the shipping line | `text` |
| `shipping_line_name` | Name of the shipping line | `text` |
| `bill_of_lading_number` | Shipment number exactly as submitted in the tracking request. May differ from `normalized_number` when the carrier expects a different format. | `text` |
| `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 `bill_of_lading_number`. | `text` |
| `reference_numbers` | Reference numbers of the shipment, contatenated | `text` |
| `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` |
| `pol_locode` | Port of Lading UN/LOCODE | `text` |
| `pod_locode` | Port of Discharge UN/LOCODE | `text` |
| `pod_terminal_firms_code` | Port of Discharge terminal firms code | `text` |
| `destination_locode` | Destination UN/LOCODE | `text` |
| `destination_terminal_firms_code` | Destination terminal firms code | `text` |
| `pol_atd_at` | Port of Lading Actual Time of Departure, as a UTC timestamp | `timestamp` |
| `pol_etd_at` | Port of Lading Estimated Time of Departure, as a UTC timestamp | `timestamp` |
| `pod_eta_at` | Port of Discharge Estimated Time of Arrival, as a UTC timestamp | `timestamp` |
| `pod_arrived_at` | Port of Discharge Actual Time of Arrival, as a UTC timestamp | `timestamp` |
| `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` |
| `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 shipment stopped, as a UTC timestamp | `timestamp` |
| `line_tracking_stopped_reason` | Reason why the tracking of the shipment stopped | `text` |
| `created_at` | When the shipment was added, as a UTC timestamp | `timestamp` |
| `updated_at` | When the shipment was last updated, as a UTC timestamp | `timestamp` |


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.