xpms.v_sheet_shipping_manifest

Vista

The Playbook Shipping Manifest sheet as the database holds it: one row per source row, computed columns reproduced in SQL.

Columnas de xpms.v_sheet_shipping_manifest
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.
vendor_id	text	Sí	VENDOR ID (column F), field.
item	text	Sí	ITEM (column G), field.
description	text	Sí	DESCRIPTION (column H), field.
container	text	Sí	CONTAINER (column I), field.
pallet_count	text	Sí	PALLET COUNT (column J), field.
piece_count	text	Sí	PIECE COUNT (column K), field.
length_ft	text	Sí	LENGTH (FT) (column L), field.
width_ft	text	Sí	WIDTH (FT) (column M), field.
height_ft	text	Sí	HEIGHT (FT) (column N), field.
weight	text	Sí	WEIGHT (column Q), field.
shipment_date	text	Sí	SHIPMENT DATE (column R), field.
sender	text	Sí	SENDER (column S), field.
origin	text	Sí	ORIGIN (column T), field.
personnel_id	text	Sí	PERSONNEL ID (column U), field.
location_id	text	Sí	LOCATION ID (column V), field.
carrier	text	Sí	CARRIER (column W), field.
carrier_phone	text	Sí	CARRIER PHONE (column X), field.
trailer_license	text	Sí	TRAILER LICENSE (column Y), field.
seal_number	text	Sí	SEAL NUMBER (column Z), field.
freight_type	text	Sí	FREIGHT TYPE (column AA), field.
tracking_number	text	Sí	TRACKING NUMBER (column AB), field.
bill_of_lading_bol	text	Sí	BILL OF LADING (BOL) (column AC), field.
status	text	Sí	STATUS (column AD), field.
flag	text	Sí	FLAG (column AE), field.
notes	text	Sí	NOTES (column AF), field.
created_by	text	Sí	CREATED BY (column AG), field.
created_at	text	Sí	CREATED AT (column AH), field.
updated_at	text	Sí	UPDATED AT (column AI), field.
project_id	text	Sí	PROJECT ID (column B), computed.
volume_cu_ft	numeric	Sí	VOLUME (CU FT) (column O), computed.
dimensions	text	Sí	DIMENSIONS (column P), computed.