maiven gateway · online··
manifest · 1d ago
Sign in Back to catalog
Definition
AP payment events per vendor, with txn vs functional amounts and realized FX gain/loss posted when bill and payment rates differ. Statutory record kept 7 years.
16 of 16
Column
Description
Tests · PII
ap_payment_id
Primary key — BIGSERIAL on the source.
2 tests
payment_number
Payment reference number. Unique.
2 tests
bank_account_id
FK to `bank_accounts.bank_account_id`. NOT NULL.
1 test
journal_entry_id
FK to the GL entry that recorded the payment. Nullable.
payment_date
Date the payment cleared / was issued.
method
Method — `ach` / `wire` / `check` / `card`.
1 test
currency
Transaction currency.
fx_rate_id
FK to `fx_rates.fx_rate_id`. Nullable.
amount
Payment amount in txn currency. NUMERIC(12,2).
base_amount
Payment amount in functional USD. NUMERIC(14,2).
realized_fx_gain_loss
Realized FX gain/loss in USD. NUMERIC(14,2).
status
Lifecycle — `pending` / `cleared` / `void`.
1 test
approved_by_employee_id
FK to the approving employee — actor reference. Nullable.
created_at
Row insert timestamp in the source DB.
updated_at
Row update timestamp in the source DB.