xpms.v_sheet_universal_posting_line

View

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

Columns of xpms.v_sheet_universal_posting_line
Column	Type	Nullable	Description
source_row	integer	Yes	Row number in the source sheet.
date	text	Yes	DATE (column A), field.
account_code	text	Yes	ACCOUNT CODE (column B), field.
cost_center_code	text	Yes	COST CENTER CODE (column C), field.
vendor_id	text	Yes	VENDOR ID (column E), field.
item_id	text	Yes	ITEM ID (column F), field.
description	text	Yes	DESCRIPTION (column G), field.
quantity	text	Yes	QUANTITY (column H), field.
unit_basis	text	Yes	UNIT BASIS (column I), field.
amount	text	Yes	AMOUNT (column J), field.
tax_type	text	Yes	TAX TYPE (column K), field.
currency	text	Yes	CURRENCY (column L), field.
external_ref	text	Yes	EXTERNAL REF (column M), field.
line_state	text	Yes	LINE STATE (column N), field.
urid	text	Yes	URID (column D), computed.