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

stg_postgres__ar_receipt_applications

staging view

AR receipt applications, cleaned.

Lineage Builds
Definition

Allocation rows tying AR receipts to the customer invoices they settle.

6 of 6
Column
Description
Tests · PII
ar_receipt_application_id
Primary key — UInt64.
2 tests
ar_receipt_id
FK to `stg_postgres__ar_receipts.ar_receipt_id`. NOT NULL.
2 tests
customer_invoice_id
FK to `stg_postgres__customer_invoices.customer_invoice_id`. NOT NULL.
2 tests
applied_amount
Amount applied to this invoice. Decimal(12,2).
source_created_at
Row insert timestamp from the source DB. DateTime64(6).
airbyte_extracted_at
When the loader extracted this row from postgres-source.