xpms.v_sheet_shipping_manifest
View
The Playbook Shipping Manifest sheet as the database holds it: one row per source row, computed columns reproduced in SQL.
| Column | Type | Nullable | Description |
|---|---|---|---|
| source_row | integer | Yes | Row number in the source sheet. |
| record_id | text | Yes | RECORD ID (column A), field. |
| department | text | Yes | DEPARTMENT (column C), field. |
| category | text | Yes | CATEGORY (column D), field. |
| sub_category | text | Yes | SUB CATEGORY (column E), field. |
| vendor_id | text | Yes | VENDOR ID (column F), field. |
| item | text | Yes | ITEM (column G), field. |
| description | text | Yes | DESCRIPTION (column H), field. |
| container | text | Yes | CONTAINER (column I), field. |
| pallet_count | text | Yes | PALLET COUNT (column J), field. |
| piece_count | text | Yes | PIECE COUNT (column K), field. |
| length_ft | text | Yes | LENGTH (FT) (column L), field. |
| width_ft | text | Yes | WIDTH (FT) (column M), field. |
| height_ft | text | Yes | HEIGHT (FT) (column N), field. |
| weight | text | Yes | WEIGHT (column Q), field. |
| shipment_date | text | Yes | SHIPMENT DATE (column R), field. |
| sender | text | Yes | SENDER (column S), field. |
| origin | text | Yes | ORIGIN (column T), field. |
| personnel_id | text | Yes | PERSONNEL ID (column U), field. |
| location_id | text | Yes | LOCATION ID (column V), field. |
| carrier | text | Yes | CARRIER (column W), field. |
| carrier_phone | text | Yes | CARRIER PHONE (column X), field. |
| trailer_license | text | Yes | TRAILER LICENSE (column Y), field. |
| seal_number | text | Yes | SEAL NUMBER (column Z), field. |
| freight_type | text | Yes | FREIGHT TYPE (column AA), field. |
| tracking_number | text | Yes | TRACKING NUMBER (column AB), field. |
| bill_of_lading_bol | text | Yes | BILL OF LADING (BOL) (column AC), field. |
| status | text | Yes | STATUS (column AD), field. |
| flag | text | Yes | FLAG (column AE), field. |
| notes | text | Yes | NOTES (column AF), field. |
| created_by | text | Yes | CREATED BY (column AG), field. |
| created_at | text | Yes | CREATED AT (column AH), field. |
| updated_at | text | Yes | UPDATED AT (column AI), field. |
| project_id | text | Yes | PROJECT ID (column B), computed. |
| volume_cu_ft | numeric | Yes | VOLUME (CU FT) (column O), computed. |
| dimensions | text | Yes | DIMENSIONS (column P), computed. |