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.
Problems that run through this table