xpms.v_sheet_universal_posting_line

Vista

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

Columnas de xpms.v_sheet_universal_posting_line
Columna	Tipo	Admite nulos	Descripción
source_row	integer	Sí	Row number in the source sheet.
date	text	Sí	DATE (column A), field.
account_code	text	Sí	ACCOUNT CODE (column B), field.
cost_center_code	text	Sí	COST CENTER CODE (column C), field.
vendor_id	text	Sí	VENDOR ID (column E), field.
item_id	text	Sí	ITEM ID (column F), field.
description	text	Sí	DESCRIPTION (column G), field.
quantity	text	Sí	QUANTITY (column H), field.
unit_basis	text	Sí	UNIT BASIS (column I), field.
amount	text	Sí	AMOUNT (column J), field.
tax_type	text	Sí	TAX TYPE (column K), field.
currency	text	Sí	CURRENCY (column L), field.
external_ref	text	Sí	EXTERNAL REF (column M), field.
line_state	text	Sí	LINE STATE (column N), field.
urid	text	Sí	URID (column D), computed.