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

stg_postgres__ar_receipts

staging view

AR receipts, cleaned.

Lineage Builds
Definition

AR cash receipts per customer with `source_payment_id` linkage back to the operational payments capture (so a customer DSAR reaches matched bank lines — H4).

18 of 18
Column
Description
Tests · PII
ar_receipt_id
Primary key — UInt64.
3 tests
receipt_number
Receipt reference number. Unique.
2 tests
customer_id
FK to ecommerce `stg_postgres__customers.customer_id`. NOT NULL.
customer +18 PII2 tests
bank_account_id
FK to `stg_postgres__bank_accounts.bank_account_id`. NOT NULL.
2 tests
source_payment_id
FK to ecommerce `stg_postgres__payments.payment_id` (operational capture). Nullable.
customer +1 PII
journal_entry_id
FK to `stg_postgres__gl_journal_entries.journal_entry_id`. Nullable.
receipt_date
Date the receipt cleared. Date.
receipt_day
Calendar date — toDate(receipt_date).
method
Method — ach / wire / card / check.
1 test
currency
Transaction currency, uppercased.
fx_rate_id
FK to `stg_postgres__fx_rates.fx_rate_id`. Nullable.
amount
Receipt amount in txn currency. Decimal(12,2).
base_amount
Receipt amount in functional USD. Decimal(14,2).
realized_fx_gain_loss
Realized FX gain/loss in USD. Decimal(14,2).
status
Lifecycle — pending / cleared / returned.
1 test
source_created_at
Row insert timestamp from the source DB. DateTime64(6).
source_updated_at
Row update timestamp from the source DB. DateTime64(6).
airbyte_extracted_at
When the loader extracted this row from postgres-source.