app.invoice_match_results

Vista

Three-way match results, derived from rows the caller may read: variance between the invoice total (subtotal plus tax) and the value received at order prices, whether vendor, currency and amount agree, and whether a mismatch was accepted.

Columnas de app.invoice_match_results
Columna	Tipo	Admite nulos	Descripción
invoice_match_id	uuid	Sí	Match.
invoice_id	uuid	Sí	Invoice.
purchase_order_id	uuid	Sí	Purchase order.
goods_receipt_id	uuid	Sí	Receipt.
variance_minor	bigint	Sí	Invoice total minus value received in minor units; NULL when either side is unpriced.
is_matched	boolean	Sí	True when amount, vendor and currency agree.
is_resolved	boolean	Sí	True when a mismatch was accepted with a resolution.