Oracle Fusion · Data dictionary
AR_RECEIVABLE_APPLICATIONS_ALL
ReceivablesUsed in 2 subject areas35 reporting columns
Receivables (AR) — how cash receipts are applied to invoices.
Primary key: RECEIVABLE_APPLICATION_ID
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ACCTD_AMOUNT_APPLIED_FROM | ● | Acctd amount applied from. | |
| ACCTD_AMOUNT_APPLIED_TO | ● | Acctd amount applied to. | |
| ACCTD_EARNED_DISCOUNT_TAKEN | ● | Acctd earned discount taken. | |
| ACCTD_UNEARNED_DISCOUNT_TAKEN | ● | Acctd unearned discount taken. | |
| AMOUNT_APPLIED | ● | Amount applied. | |
| AMOUNT_APPLIED_FROM | ● | Amount applied from. | |
| APPLICATION_TYPE | ● | Type of application. | |
| APPLIED_PAYMENT_SCHEDULE_ID | ● | Identifier for the applied payment schedule. | |
| APPLY_DATE | ● | Apply date. | |
| CHARGES_EDISCOUNTED | ● | Charges ediscounted. | |
| CHARGES_UEDISCOUNTED | ● | Charges uediscounted. | |
| COMMENTS | ● | Comments. | |
| CUSTOMER_REASON | ● | Customer reason. | |
| CUSTOMER_REFERENCE | ● | Customer reference. | |
| DAYS_LATE | ● | Days late. | |
| DISPLAY | ● | Display. | |
| EARNED_DISCOUNT_TAKEN | ● | Earned discount taken. | |
| EXCEPTION_REASON_CODE | ● | Code identifying the exception reason. | |
| FREIGHT_APPLIED | ● | Freight applied. | |
| FREIGHT_EDISCOUNTED | ● | Freight ediscounted. | |
| FREIGHT_UEDISCOUNTED | ● | Freight uediscounted. | |
| GL_DATE | ● | General ledger date. | |
| GL_POSTED_DATE | ● | General ledger posted date. | |
| LINE_EDISCOUNTED | ● | Line ediscounted. | |
| LINE_UEDISCOUNTED | ● | Line uediscounted. | |
| POSTABLE | ● | Postable. | |
| POSTING_CONTROL_ID | ● | Identifier for the posting control. | |
| RECEIVABLES_CHARGES_APPLIED | ● | Receivables charges applied. | |
| RECEIVABLE_APPLICATION_ID | PK | ○ | Identifier for the receivable application. |
| REVERSAL_GL_DATE | ● | Reversal general ledger date. | |
| STATUS | ● | Status. | |
| TAX_APPLIED | ● | Tax applied. | |
| TAX_EDISCOUNTED | ● | Tax ediscounted. | |
| TAX_UEDISCOUNTED | ● | Tax uediscounted. | |
| TRANS_TO_RECEIPT_RATE | ● | Trans to receipt rate. | |
| UNEARNED_DISCOUNT_TAKEN | ● | Unearned discount taken. |
17 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_RECEIVABLE_APPLICATIONS_ALL.
- AR Aging Detail Report
- AR Open Claim Summary and Detail Report
- AR Receivable Activity Report
- Cash Settlement Report
- Customer Statement of Open Balance Report
- Invoice Settlement Report
- Receipt History Report
- Vietnam Receipt Voucher Report
- Billing History Report
- Create Customer Statements Execution Report
- Receipts Days Late Analysis Report
- Bank Risk Report
- Reversal Status Report
- Automatic Receipt Creation and Remittance Execution Report
- Create Automatic Receipt Write-offs Execution Report
- Format Automatic Receipts Report
- Process Receipts Through Lockbox Execution Report
Where this surfaces in OTBI
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.
- Receivables - Credit Memo Applications Real Time
- Receivables - Standard Receipts Application Details Real Time
Need the extract + dbt staging for AR_RECEIVABLE_APPLICATIONS_ALL?
We ship parameterized SQL, BICC config, and dbt models you own.