xpms.v_sheet_asset_inventory

View

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

Columns of xpms.v_sheet_asset_inventory
Column	Type	Nullable	Description
source_row	integer	Yes	Row number in the source sheet.
record_id	text	Yes	RECORD ID (column A), field.
item_id	text	Yes	ITEM ID (column C), field.
color	text	Yes	COLOR (column G), field.
make_and_model	text	Yes	MAKE & MODEL (column H), field.
serial_number	text	Yes	SERIAL NUMBER (column I), field.
label	text	Yes	LABEL (column J), field.
quantity	text	Yes	QUANTITY (column K), field.
condition	text	Yes	CONDITION (column L), field.
location_id	text	Yes	LOCATION ID (column M), field.
vendor_id	text	Yes	VENDOR ID (column N), field.
status	text	Yes	STATUS (column P), field.
flag	text	Yes	FLAG (column Q), field.
notes	text	Yes	NOTES (column R), field.
created_by	text	Yes	CREATED BY (column S), field.
created_at	text	Yes	CREATED AT (column T), field.
updated_at	text	Yes	UPDATED AT (column U), field.
project_id	text	Yes	PROJECT ID (column B), computed.
item	text	Yes	ITEM (column D), computed.
description	text	Yes	DESCRIPTION (column E), computed.
specifications	text	Yes	SPECIFICATIONS (column F), computed.
unit_cost	numeric	Yes	UNIT COST (column O), computed.