maiven gateway · online··
manifest · 2d ago
Sign in Back to catalog
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 deterministically — H4). Statutory record kept 7 years.
16 of 16
Column
Description
Tests · PII
ar_receipt_id
Primary key — BIGSERIAL on the source.
2 tests
receipt_number
Receipt reference number. Unique.
2 tests
bank_account_id
FK to `bank_accounts.bank_account_id`. NOT NULL.
1 test
source_payment_id
FK to ecommerce `payments.payment_id` (operational capture). Nullable.
journal_entry_id
FK to the GL entry that recorded the receipt. Nullable.
receipt_date
Date the receipt cleared.
method
Method — `ach` / `wire` / `card` / `check`.
1 test
currency
Transaction currency.
fx_rate_id
FK to `fx_rates.fx_rate_id`. Nullable.
amount
Receipt amount in txn currency. NUMERIC(12,2).
base_amount
Receipt amount in functional USD. NUMERIC(14,2).
realized_fx_gain_loss
Realized FX gain/loss in USD. NUMERIC(14,2).
status
Lifecycle — `pending` / `cleared` / `returned`.
1 test
created_at
Row insert timestamp in the source DB.
updated_at
Row update timestamp in the source DB.