vendor_bills

source

What vendors billed us, and how much is still owed.

Definition

AP bill headers per vendor, with txn vs functional (`base_*`) totals. `amount_paid` vs `total_amount` drives the open-AP balance that ties to the AP control account. Statutory record kept 7 years.

19 of 19

Column

Description

Tests · PII

vendor_bill_id

Primary key — BIGSERIAL on the source.

vendor +1 PII2 tests

bill_number

Vendor-facing bill number. Unique.

2 tests

legal_entity_id

FK to `legal_entities.legal_entity_id`. Nullable.

vendor_id

FK to `vendors.vendor_id`. NOT NULL.

vendor +1 PII1 test

period_id

FK to `fiscal_periods.period_id` (not staged in this slice). NOT NULL.

1 test

journal_entry_id

FK to the GL entry that recorded the bill. Nullable.

bill_date

Invoice date on the bill.

due_date

Payment due date.

currency

Transaction currency.

fx_rate_id

FK to `fx_rates.fx_rate_id` used for translation. Nullable.

subtotal_amount

Pre-tax total in txn currency. NUMERIC(12,2).

tax_amount

Tax total in txn currency. NUMERIC(12,2).

total_amount

Grand total in txn currency. NUMERIC(12,2).

base_total_amount

Grand total in functional USD. NUMERIC(14,2).

amount_paid

Cumulative amount paid in txn currency. NUMERIC(12,2).

status

Lifecycle — `draft` / `open` / `partially_paid` / `paid` / `void`.

1 test

approved_by_employee_id

FK to the approving employee — actor reference. Nullable.

created_at

Row insert timestamp in the source DB.

updated_at

Row update timestamp in the source DB.