app.invoice_match_results
View
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.
| Column | Type | Nullable | Description |
|---|---|---|---|
| invoice_match_id | uuid | Yes | Match. |
| invoice_id | uuid | Yes | Invoice. |
| purchase_order_id | uuid | Yes | Purchase order. |
| goods_receipt_id | uuid | Yes | Receipt. |
| variance_minor | bigint | Yes | Invoice total minus value received in minor units; NULL when either side is unpriced. |
| is_matched | boolean | Yes | True when amount, vendor and currency agree. |
| is_resolved | boolean | Yes | True when a mismatch was accepted with a resolution. |