maiven gateway · online··
manifest · 1d ago
Sign in Back to catalog
Definition
GL-coded AR line items with tax breakout, optionally tied to an ecommerce product. Statutory record kept 7 years.
14 of 14
Column
Description
Tests · PII
invoice_line_id
Primary key — BIGSERIAL on the source.
2 tests
customer_invoice_id
FK to `customer_invoices.customer_invoice_id`. NOT NULL.
1 test
line_number
1-based line ordinal within the invoice.
gl_account_id
FK to `gl_accounts.gl_account_id`. NOT NULL.
1 test
product_id
FK to ecommerce `products.product_id`. Nullable.
description
Free-text line description. Nullable.
quantity
Quantity invoiced. NUMERIC(12,2).
unit_price
Per-unit price. NUMERIC(10,2).
line_amount
Line total. NUMERIC(12,2).
tax_code
Tax code. Nullable.
tax_rate
Tax rate. NUMERIC(6,4).
tax_amount
Tax amount. NUMERIC(12,2).
tax_jurisdiction
Tax jurisdiction. Nullable.
created_at
Row insert timestamp in the source DB.