maiven gateway · online··
manifest · 1d ago
Sign in
Back to catalog
MAIVENmodelstaging

stg_postgres__vendor_bills

staging view

Vendor bills, cleaned.

Lineage Builds
Definition

AP bill headers with txn vs functional totals. Open balance (`total_amount` - `amount_paid`) ties to the AP control account.

21 of 21
Column
Description
Tests · PII
vendor_bill_id
Primary key — UInt64.
vendor +1 PII4 tests
bill_number
Vendor-facing bill number. Unique.
2 tests
legal_entity_id
FK to `stg_postgres__legal_entities.legal_entity_id`. Nullable.
vendor_id
FK to `stg_postgres__vendors.vendor_id`. NOT NULL.
vendor +1 PII2 tests
period_id
FK to fiscal_periods.period_id (not staged in this slice). NOT NULL.
1 test
journal_entry_id
FK to `stg_postgres__gl_journal_entries.journal_entry_id`. Nullable.
bill_date
Invoice date on the bill. Date.
bill_day
Calendar date — toDate(bill_date). MergeTree partition/sort key candidate.
due_date
Payment due date. Date.
currency
Transaction currency, uppercased.
fx_rate_id
FK to `stg_postgres__fx_rates.fx_rate_id`. Nullable.
subtotal_amount
Pre-tax total in txn currency. Decimal(12,2).
tax_amount
Tax total in txn currency. Decimal(12,2).
total_amount
Grand total in txn currency. Decimal(12,2).
base_total_amount
Grand total in functional USD. Decimal(14,2).
amount_paid
Cumulative amount paid in txn currency. Decimal(12,2).
status
Lifecycle — draft / open / partially_paid / paid / void.
1 test
approved_by_employee_id
FK to the approving employee — actor reference. Nullable.
source_created_at
Row insert timestamp from the source DB. DateTime64(6).
source_updated_at
Row update timestamp from the source DB. DateTime64(6).
airbyte_extracted_at
When the loader extracted this row from postgres-source.