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