AP_INVOICE_PAYMENTS_ALL

PayablesUsed in 2 subject areas22 reporting columns

Payables (AP) — invoice payments. Links invoices to the payments that cleared them.

Primary key: INVOICE_PAYMENT_ID

Columns

Column	Key	In reports	Description (inferred)
ACCOUNTING_DATE		●	Accounting date.
AMOUNT		●	Amount.
AMOUNT_INV_CURR		●	Amount inventory currency.
BANK_ACCOUNT_NUM		●	Bank account number.
BANK_ACCOUNT_TYPE		●	Type of bank account.
BANK_NUM		●	Bank number.
DISCOUNT_LOST		●	Discount lost.
DISCOUNT_TAKEN		●	Discount taken.
DISCOUNT_TAKEN_INV_CURR		●	Discount taken inventory currency.
EXCHANGE_DATE		●	Exchange date.
EXCHANGE_RATE		●	Exchange rate.
EXCHANGE_RATE_TYPE		●	Type of exchange rate.
IBAN_NUMBER		●	Iban number.
INVOICE_BASE_AMOUNT		●	Invoice base amount.
INVOICE_PAYMENT_ID	PK	○	Identifier for the invoice payment.
PAYMENT_BASE_AMOUNT		●	Payment base amount.
PAYMENT_NUM		●	Payment number.
PERIOD_NAME		●	Name of the period.
POSTED_FLAG		●	Indicator (Y/N) for the posted.
REMIT_TO_ADDRESS_NAME		●	Name of the remit to address.
REMIT_TO_SUPPLIER_NAME		●	Name of the remit to supplier.
REVERSAL_FLAG		●	Indicator (Y/N) for the reversal.
X_CURR_RATE		●	X currency rate.

Change a column here and these are the reports that move with it — the blast radius for any change to AP_INVOICE_PAYMENTS_ALL.

The OTBI subject areas that expose this table. You can't join across them in OTBI — the owned conformed model joins them on shared keys.

Need the extract + dbt staging for AP_INVOICE_PAYMENTS_ALL?

We ship parameterized SQL, BICC config, and dbt models you own.