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

stg_postgres__bill_lines

staging view 1 PII columns

Vendor-bill lines, cleaned.

Lineage Builds PII registry
Definition

GL-coded AP line items with tax breakout. `description` may echo incidental PII (nullify on erasure).

15 of 15
Column
Description
Tests · PII
bill_line_id
Primary key — UInt64.
2 tests
vendor_bill_id
FK to `stg_postgres__vendor_bills.vendor_bill_id`. NOT NULL.
vendor PII2 tests
line_number
1-based line ordinal within the bill. Int16.
gl_account_id
FK to `stg_postgres__gl_accounts.gl_account_id`. NOT NULL.
2 tests
cost_center_id
FK to `stg_postgres__cost_centers.cost_center_id`. Nullable.
description
Free-text line description. May echo PII. Nullable.
PII
quantity
Quantity billed. Decimal(12,2).
unit_price
Per-unit price. Decimal(10,2).
line_amount
Line total. Decimal(12,2).
tax_code
Tax code. Nullable.
tax_rate
Tax rate. Decimal(6,4).
tax_amount
Tax amount. Decimal(12,2).
tax_jurisdiction
Tax jurisdiction. Nullable.
source_created_at
Row insert timestamp from the source DB. DateTime64(6).
airbyte_extracted_at
When the loader extracted this row from postgres-source.