xpms.v_sheet_purchase_orders

View

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

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