xpms.v_sheet_purchase_orders

Vista

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

Columnas de xpms.v_sheet_purchase_orders
Columna	Tipo	Admite nulos	Descripción
source_row	integer	Sí	Row number in the source sheet.
po_number	text	Sí	PO NUMBER (column A), field.
project_id	text	Sí	PROJECT ID (column B), field.
vendor_id	text	Sí	VENDOR ID (column C), field.
issue_date	text	Sí	ISSUE DATE (column E), field.
delivery_date	text	Sí	DELIVERY DATE (column F), field.
payment_terms	text	Sí	PAYMENT TERMS (column G), field.
tax_amount	text	Sí	TAX AMOUNT (column I), field.
shipping_amount	text	Sí	SHIPPING AMOUNT (column J), field.
invoiced_amount	text	Sí	INVOICED AMOUNT (column M), field.
paid_amount	text	Sí	PAID AMOUNT (column N), field.
currency	text	Sí	CURRENCY (column O), field.
status	text	Sí	STATUS (column P), field.
flag	text	Sí	FLAG (column Q), field.
notes	text	Sí	NOTES (column R), field.
created_by	text	Sí	CREATED BY (column S), field.
created_at	text	Sí	CREATED AT (column T), field.
updated_at	text	Sí	UPDATED AT (column U), field.
vendor_name	text	Sí	VENDOR NAME (column D), computed.
subtotal_amount	numeric	Sí	SUBTOTAL AMOUNT (column H), computed.
total_amount	numeric	Sí	TOTAL AMOUNT (column K), computed.
committed_amount	numeric	Sí	COMMITTED AMOUNT (column L), computed.