xpms.v_sheet_asset_inventory

Vista

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

Columnas de xpms.v_sheet_asset_inventory
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.
item_id	text	Sí	ITEM ID (column C), field.
color	text	Sí	COLOR (column G), field.
make_and_model	text	Sí	MAKE & MODEL (column H), field.
serial_number	text	Sí	SERIAL NUMBER (column I), field.
label	text	Sí	LABEL (column J), field.
quantity	text	Sí	QUANTITY (column K), field.
condition	text	Sí	CONDITION (column L), field.
location_id	text	Sí	LOCATION ID (column M), field.
vendor_id	text	Sí	VENDOR ID (column N), field.
status	text	Sí	STATUS (column P), field.
flag	text	Sí	FLAG (column Q), field.
notes	text	Sí	NOTES (column R), field.
created_by	text	Sí	CREATED BY (column S), field.
created_at	text	Sí	CREATED AT (column T), field.
updated_at	text	Sí	UPDATED AT (column U), field.
project_id	text	Sí	PROJECT ID (column B), computed.
item	text	Sí	ITEM (column D), computed.
description	text	Sí	DESCRIPTION (column E), computed.
specifications	text	Sí	SPECIFICATIONS (column F), computed.
unit_cost	numeric	Sí	UNIT COST (column O), computed.