api_external.dock_slots
View
Dock slots of the caller's vendor account: slots booked for shipments it carries and slots booked for its own engagement, while that engagement is in the operational area (Section 8.7). Other vendors' slots never appear.
| Column | Type | Nullable | Description |
|---|---|---|---|
| id | uuid | Yes | Dock slot. |
| project_id | uuid | Yes | Project. |
| project_name | text | Yes | Project name. |
| zone_id | uuid | Yes | Dock zone. |
| zone_code | text | Yes | Zone code. |
| zone_name | text | Yes | Zone name. |
| shipment_id | uuid | Yes | Shipment. |
| direction | app.shipment_direction | Yes | Inbound or Outbound. |
| tracking_identifier | text | Yes | Carrier tracking number. |
| starts_at | timestamp with time zone | Yes | Slot start. |
| ends_at | timestamp with time zone | Yes | Slot end. |
| engagement_id | uuid | Yes | Vendor engagement the slot serves, when booked for one. |