api_external.deliveries
View
Shipments the caller's account carries to and from a project where its engagement has the operational area open; dock slots for them read from api_external.dock_slots.
| Column | Type | Nullable | Description |
|---|---|---|---|
| id | uuid | Yes | Shipment. |
| project_id | uuid | Yes | Project. |
| project_name | text | Yes | Project name. |
| direction | app.shipment_direction | Yes | Inbound or Outbound. |
| tracking_identifier | text | Yes | Carrier tracking number. |
| ships_at | timestamp with time zone | Yes | When it ships. |
| arrives_at | timestamp with time zone | Yes | When it is due. |