> ## Documentation Index
> Fetch the complete documentation index at: https://terminal49-sinan-dev-10929-support-initial-shipment-and-per.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 from the tracking request                                                       | `text`      |
| `normalized_number`               | The normalized version of the shipment number used for querying the carrier                     | `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` |