maiven gateway · online··
manifest · 2d ago
Sign in Back to catalog
Definition
GL-coded AR line items with tax breakout, optionally tied to an ecommerce product.
15 of 15
Column
Description
Tests · PII
invoice_line_id
Primary key — UInt64.
2 tests
customer_invoice_id
FK to `stg_postgres__customer_invoices.customer_invoice_id`. NOT NULL.
2 tests
line_number
1-based line ordinal within the invoice. Int16.
gl_account_id
FK to `stg_postgres__gl_accounts.gl_account_id`. NOT NULL.
2 tests
product_id
FK to ecommerce `stg_postgres__products.product_id`. Nullable.
description
Free-text line description. Nullable.
quantity
Quantity invoiced. 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.