app.shipments
TablaSeguridad a nivel de fila activa
Shipments to and from a project's sites.
Clave primaria: id
| Columna | Tipo | Admite nulos | Descripción |
|---|---|---|---|
| id | uuid | No | Primary key, UUID v7. |
| org_id | uuid | No | Owning org, derived from app.projects on insert; never accepted from the caller and never changed.Hace referencia a app.organizations.id |
| project_id | uuid | No | Project.Hace referencia a app.projects.id |
| direction | app.shipment_direction | No | Inbound or Outbound. |
| carrier_counterparty_id | uuid | Sí | Carrier.Hace referencia a app.counterparties.id |
| freight_type_enum_id | text | Sí | Freight type: a row of the canon Freight Type enumeration.Hace referencia a xpms.std_enumeration.record_id |
| tracking_identifier | text | Sí | Carrier tracking number. |
| ships_at | timestamp with time zone | Sí | When it ships. |
| arrives_at | timestamp with time zone | Sí | When it is due to arrive. |
| deleted_at | timestamp with time zone | Sí | Soft delete time. A row with deleted_at set is ignored by every access helper. |
| created_at | timestamp with time zone | No | When the row was inserted. Set by the database. |
| created_by | uuid | Sí | Person who inserted the row, or null for a platform process. Set by the database.Hace referencia a app.people.id |
| updated_at | timestamp with time zone | No | When the row last changed. Set by the database. |
| updated_by | uuid | Sí | Person who last changed the row, or null for a platform process. Set by the database.Hace referencia a app.people.id |
| shipment_number | bigint | No | Number within the project from the record sequence. The display key is {project_key}-{shipment_number}, read through app.shipment_display_key. |
| urid | text | Sí | URID category the shipment serves (dimension 2), for example 5000.52.01.Hace referencia a xpms.dim_category.cat_urid |
| description | text | Sí | What the shipment carries, in a sentence. |
| origin | text | Sí | Where the freight ships from, as a locality (Orlando, FL). |
| sender_counterparty_id | uuid | Sí | Vendor sending the freight; the carrier is carrier_counterparty_id.Hace referencia a app.counterparties.id |
| pallet_count | integer | Sí | Number of pallets. |
| piece_count | integer | Sí | Number of pieces. |
| length_ft | numeric(8,2) | Sí | Length of the load in feet. |
| width_ft | numeric(8,2) | Sí | Width of the load in feet. |
| height_ft | numeric(8,2) | Sí | Height of the load in feet. |
| weight_lb | numeric(10,2) | Sí | Weight of the load in pounds. |
| trailer_license | text | Sí | License plate of the trailer, issued by a motor vehicle authority. |
| seal_identifier | text | Sí | Number of the seal applied to the trailer. |
| bill_of_lading_identifier | text | Sí | Bill of lading number issued by the carrier. |