xpms.v_sheet_marshalling_yard_log
Vista
The Playbook Marshalling Yard Log sheet as the database holds it: one row per source row, computed columns reproduced in SQL.
| Columna | Tipo | Admite nulos | Descripción |
|---|---|---|---|
| source_row | integer | Sí | Row number in the source sheet. |
| record_id | text | Sí | RECORD ID (column A), field. |
| department | text | Sí | DEPARTMENT (column C), field. |
| category | text | Sí | CATEGORY (column D), field. |
| sub_category | text | Sí | SUB CATEGORY (column E), field. |
| vehicle_callsign | text | Sí | VEHICLE CALLSIGN (column F), field. |
| carrier_vendor_id | text | Sí | CARRIER / VENDOR ID (column G), field. |
| shipment_id | text | Sí | SHIPMENT ID (column H), field. |
| vehicle_type | text | Sí | VEHICLE TYPE (column I), field. |
| driver_name | text | Sí | DRIVER NAME (column J), field. |
| carrier_phone | text | Sí | CARRIER PHONE (column K), field. |
| trailer_license | text | Sí | TRAILER LICENSE (column L), field. |
| seal_number | text | Sí | SEAL NUMBER (column M), field. |
| dimensions | text | Sí | DIMENSIONS (column N), field. |
| weight | text | Sí | WEIGHT (column O), field. |
| staging_bay | text | Sí | STAGING BAY (column P), field. |
| target_dock_id | text | Sí | TARGET DOCK ID (column Q), field. |
| check_in_time | text | Sí | CHECK-IN TIME (column R), field. |
| dock_call_time | text | Sí | DOCK CALL TIME (column S), field. |
| dock_release_time | text | Sí | DOCK RELEASE TIME (column T), field. |
| status | text | Sí | STATUS (column U), field. |
| flag | text | Sí | FLAG (column V), field. |
| notes | text | Sí | NOTES (column W), field. |
| created_by | text | Sí | CREATED BY (column X), field. |
| created_at | text | Sí | CREATED AT (column Y), field. |
| updated_at | text | Sí | UPDATED AT (column Z), field. |
| project_id | text | Sí | PROJECT ID (column B), computed. |