stg_postgres__ap_payments

staging view

AP payments, cleaned.

Lineage Builds

Definition

AP payment events with txn vs functional amounts and realized FX gain/loss posted on settlement.

18 of 18

Column

Description

Tests · PII

ap_payment_id

Primary key — UInt64.

3 tests

payment_number

Payment reference number. Unique.

2 tests

vendor_id

FK to `stg_postgres__vendors.vendor_id`. NOT NULL.

vendor +1 PII2 tests

bank_account_id

FK to `stg_postgres__bank_accounts.bank_account_id`. NOT NULL.

2 tests

journal_entry_id

FK to `stg_postgres__gl_journal_entries.journal_entry_id`. Nullable.

payment_date

Date the payment cleared / was issued. Date.

payment_day

Calendar date — toDate(payment_date).

method

Method — ach / wire / check / card.

1 test

currency

Transaction currency, uppercased.

fx_rate_id

FK to `stg_postgres__fx_rates.fx_rate_id`. Nullable.

amount

Payment amount in txn currency. Decimal(12,2).

base_amount

Payment amount in functional USD. Decimal(14,2).

realized_fx_gain_loss

Realized FX gain/loss in USD. Decimal(14,2).

status

Lifecycle — pending / cleared / void.

1 test

approved_by_employee_id

FK to the approving employee — actor reference. Nullable.

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.