Oracle Fusion · Data dictionary
AR_ADJUSTMENTS_ALL
ReceivablesUsed in 2 subject areas19 reporting columns
Receivables (AR) — transaction table (rows scoped across all operating units).
Primary key: ADJUSTMENT_ID
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ACCTD_AMOUNT | ● | Acctd amount. | |
| ADJUSTMENT_ID | PK | ○ | Identifier for the adjustment. |
| ADJUSTMENT_NUMBER | ● | Adjustment number. | |
| ADJUSTMENT_TYPE | ● | Type of adjustment. | |
| AMOUNT | ● | Amount. | |
| APPLY_DATE | ● | Apply date. | |
| COMMENTS | ● | Comments. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| DOC_SEQUENCE_VALUE | ● | Doc sequence value. | |
| FREIGHT_ADJUSTED | ● | Freight adjusted. | |
| GL_DATE | ● | General ledger date. | |
| GL_POSTED_DATE | ● | General ledger posted date. | |
| LAST_UPDATE_DATE | ● | Date and time the row was last updated (the incremental-extract key). | |
| LINE_ADJUSTED | ● | Line adjusted. | |
| POSTABLE | ● | Postable. | |
| POSTING_CONTROL_ID | ● | Identifier for the posting control. | |
| REASON_CODE | ● | Code identifying the reason. | |
| RECEIVABLES_CHARGES_ADJUSTED | ● | Receivables charges adjusted. | |
| TAX_ADJUSTED | ● | Tax adjusted. | |
| TYPE | ● | Type. |
6 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_ADJUSTMENTS_ALL.
- AR Receivable Activity Report
- Invoice Settlement Report
- Potential Reconciling Items Report
- Billing History Report
- Print Adjustments Report
- Document Number Audit 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.
Need the extract + dbt staging for AR_ADJUSTMENTS_ALL?
We ship parameterized SQL, BICC config, and dbt models you own.