Oracle Fusion · Data dictionary
AR_TRANSACTION_HISTORY_ALL
ReceivablesUsed in 1 subject areas13 reporting columns
Receivables (AR) — transaction table (rows scoped across all operating units).
Primary key: TRANSACTION_HISTORY_ID
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| COMMENTS | ● | Comments. | |
| CURRENT_ACCOUNTED_FLAG | ● | Indicator (Y/N) for the current accounted. | |
| CURRENT_RECORD_FLAG | ● | Indicator (Y/N) for the current record. | |
| EVENT | ● | Event. | |
| GL_DATE | ● | General ledger date. | |
| GL_POSTED_DATE | ● | General ledger posted date. | |
| LAST_UPDATED_BY | ● | User who last updated the row. | |
| LAST_UPDATE_DATE | ● | Date and time the row was last updated (the incremental-extract key). | |
| MATURITY_DATE | ● | Maturity date. | |
| POSTABLE_FLAG | ● | Indicator (Y/N) for the postable. | |
| POSTING_CONTROL_ID | ● | Identifier for the posting control. | |
| STATUS | ● | Status. | |
| TRANSACTION_HISTORY_ID | PK | ○ | Identifier for the transaction history. |
| TRX_DATE | ● | Transaction date. |
5 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_TRANSACTION_HISTORY_ALL.
- Greece Notes Receivable - Post Dated Checks and Drafts Report
- Automatic Bills Receivable Remittance Execution Report
- Automatic Bills Receivable Transactions Batch Report
- Close Matured Bills Receivable Execution Report
- Print Bills Receivable 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_TRANSACTION_HISTORY_ALL?
We ship parameterized SQL, BICC config, and dbt models you own.