bill_lines

source 1 PII columns

Line-level detail behind every vendor bill.

Definition

GL-coded AP line items with tax breakout. `description` can echo incidental personal data, so it is nullify-on-erasure. Statutory record kept 7 years.

14 of 14

Column

Description

Tests · PII

bill_line_id

Primary key — BIGSERIAL on the source.

2 tests

vendor_bill_id

FK to `vendor_bills.vendor_bill_id`. NOT NULL.

vendor PII1 test

line_number

1-based line ordinal within the bill.

gl_account_id

FK to `gl_accounts.gl_account_id`. NOT NULL.

1 test

cost_center_id

FK to `cost_centers.cost_center_id`. Nullable.

description

Free-text line description. May echo PII. Nullable.

PII

quantity

Quantity billed. NUMERIC(12,2).

unit_price

Per-unit price. NUMERIC(10,2).

line_amount

Line total. NUMERIC(12,2).

tax_code

Tax code — `VAT_STD` / `VAT_RED` / `NONE` / `REVERSE_CHARGE`. Nullable.

tax_rate

Tax rate. NUMERIC(6,4).

tax_amount

Tax amount. NUMERIC(12,2).

tax_jurisdiction

Tax jurisdiction (e.g. `US-CA`, `DE`). Nullable.

created_at

Row insert timestamp in the source DB.