Oracle Fusion · Data dictionary
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. |
21 reports read from this table
Change a column here and these are the reports that move with it, the blast radius for any change to AR_PAYMENT_SCHEDULES_ALL.
- Intercompany Invoiced Reconciliation Report
- AR Applied and Unapplied Receipts Register Report
- AR Transaction Register Summary and Detail Report
- Customer Statement of Open Balance Report
- Greece Customer Balance by Account Report
- Invoice Settlement Report
- Receipt History Report
- SEPA Letter for Italy Customer
- Transaction Resolution Report
- Receivables to General Ledger Reconciliation Report
- Receivables Aging Report
- Bad Debt Provision Report
- Billing History Report
- Receivables Aging by General Ledger Account Report
- Customer Account Status Report
- Customer Balances Revaluation Report
- Generate Late Charges Report
- Receivables Open Items Revaluation Report
- Receivables Projected Gains and Losses Report
- Create Customer Statements Execution Report
- Receipts Days Late Analysis Report
Where this surfaces in OTBI
The OTBI subject areas that expose this table. In OTBI they combine only through shared dimensions or set operators such as union, inside one application; the owned conformed model joins this table across modules and systems on conformed keys.
- Receivables - Adjustments Real Time
- Receivables - Bills Receivable Real Time
- Receivables - Credit Memo Applications Real Time
- Receivables - Payment Schedules Real Time
- Receivables - Receipts Details Real Time
- Receivables - Standard Receipts Application Details Real Time
Need the extract + dbt staging for AR_PAYMENT_SCHEDULES_ALL?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table