xpms.v_sheet_po_line_items

Vista

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

Columnas de xpms.v_sheet_po_line_items
Columna	Tipo	Admite nulos	Descripción
source_row	integer	Sí	Row number in the source sheet.
po_line_id	text	Sí	PO LINE ID (column A), field.
po_number	text	Sí	PO NUMBER (column B), field.
expense_ref_id	text	Sí	EXPENSE REF ID (column C), field.
item_id	text	Sí	ITEM ID (column D), field.
user_line_description	text	Sí	USER LINE DESCRIPTION (column E), field.
quantity	text	Sí	QUANTITY (column F), field.
unit_rate	text	Sí	UNIT RATE (column G), field.
gl_account	text	Sí	GL ACCOUNT (column I), field.
cost_center	text	Sí	COST CENTER (column J), field.
line_state	text	Sí	LINE STATE (column K), field.
total_amount	numeric	Sí	TOTAL AMOUNT (column H), computed.