xpms.v_sheet_po_line_items

View

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

Columns of xpms.v_sheet_po_line_items
Column	Type	Nullable	Description
source_row	integer	Yes	Row number in the source sheet.
po_line_id	text	Yes	PO LINE ID (column A), field.
po_number	text	Yes	PO NUMBER (column B), field.
expense_ref_id	text	Yes	EXPENSE REF ID (column C), field.
item_id	text	Yes	ITEM ID (column D), field.
user_line_description	text	Yes	USER LINE DESCRIPTION (column E), field.
quantity	text	Yes	QUANTITY (column F), field.
unit_rate	text	Yes	UNIT RATE (column G), field.
gl_account	text	Yes	GL ACCOUNT (column I), field.
cost_center	text	Yes	COST CENTER (column J), field.
line_state	text	Yes	LINE STATE (column K), field.
total_amount	numeric	Yes	TOTAL AMOUNT (column H), computed.