AR_PAYMENT_SCHEDULES_ALL

ReceivablesUsed in 6 subject areas32 reporting columns

Receivables (AR) — payment schedules. One per due date per invoice — the anchor for AR aging.

Primary key: PAYMENT_SCHEDULE_ID

Columns

Column	Key	In reports	Description (inferred)
ACCTD_AMOUNT_DUE_REMAINING		●	Acctd amount due remaining.
ACTUAL_DATE_CLOSED		●	Actual date closed.
AMOUNT_ADJUSTED		●	Amount adjusted.
AMOUNT_ADJUSTED_PENDING		●	Amount adjusted pending.
AMOUNT_APPLIED		●	Amount applied.
AMOUNT_CREDITED		●	Amount credited.
AMOUNT_DUE_ORIGINAL		●	Amount due original.
AMOUNT_DUE_REMAINING		●	Amount due remaining.
AMOUNT_IN_DISPUTE		●	Amount in dispute.
AMOUNT_LINE_ITEMS_ORIGINAL		●	Amount line items original.
AMOUNT_LINE_ITEMS_REMAINING		●	Amount line items remaining.
AMOUNT_ON_ACCOUNT		●	Amount on account.
CLASS		●	Class.
DISCOUNT_TAKEN_EARNED		●	Discount taken earned.
DISCOUNT_TAKEN_UNEARNED		●	Discount taken unearned.
DISPUTE_DATE		●	Dispute date.
DUE_DATE		●	Due date.
EXCHANGE_DATE		●	Exchange date.
EXCHANGE_RATE		●	Exchange rate.
EXCHANGE_RATE_TYPE		●	Type of exchange rate.
FREIGHT_ORIGINAL		●	Freight original.
FREIGHT_REMAINING		●	Freight remaining.
GL_DATE		●	General ledger date.
GL_DATE_CLOSED		●	General ledger date closed.
NUMBER_OF_DUE_DATES		●	Number of due dates.
PAYMENT_SCHEDULE_ID	PK	○	Identifier for the payment schedule.
RECEIVABLES_CHARGES_CHARGED		●	Receivables charges charged.
RECEIVABLES_CHARGES_REMAINING		●	Receivables charges remaining.
STATUS		●	Status.
TAX_ORIGINAL		●	Tax original.
TAX_REMAINING		●	Tax remaining.
TRX_DATE		●	Transaction date.
TRX_NUMBER		●	Transaction number.

Change a column here and these are the reports that move with it — the blast radius for any change to AR_PAYMENT_SCHEDULES_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 AR_PAYMENT_SCHEDULES_ALL?

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