home / portal / procurement_vendor_payments

procurement_vendor_payments: 2

Pre-aggregated checkbook totals per vendor string at rung L1/L2. net_usd sums debit and credit rows together and is allowed to be negative. Two strings can reach the same checkbook name, so summing this table's rows double-counts — it is a per-vendor lookup, not a total.

This data as json

rowid vendor_string rung n_checkbook_names n_checkbook_vendor_ids n_rows gross_debits_usd credits_usd net_usd n_credits n_credits_paired n_credits_unpaired first_check_date last_check_date computed_at run_id
2 3-D SMART STRUCTURES, INC. L1 1 1 10 163419.28 -10000.0 153419.28 1 1 0 2024-08-01 2026-09-15 2026-11-21T22:36:21Z pv-c6b0d6196bc9
Powered by Datasette · Queries took 2.68ms