# DW_CE_ACCT_HISTORY_D (Preview)

This table requires activation of Cash Management functional area. DW_CE_ACCT_HISTORY_D contains information about account history.

## Details

Module: Cash Management

## Key Columns

ACCT_HISTORY_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
ACCT_HISTORY_ID | NUMBER | 38 | 0 | True | Uniquely identifies account history. |  |
SOURCE_RECORD_ID | VARCHAR2 | 64 |  |  | This column is for Oracle Internal use only. Source record identifier |  |
TRANSACTION_SOURCE | VARCHAR2 | 32 |  |  | Source of the transaction that is being accounted. |  |
TRANSACTION_ID | NUMBER | 38 | 0 |  | Identifier to identify the transaction. For external transactions, this is the TRANSACTION_ID, not the EXTERNAL_TRANSACTION_ID. |  |
EVENT_ID | NUMBER | 38 | 0 |  | Accounting event identifier when the event is raised. |  |
EVENT_TYPE | VARCHAR2 | 32 |  |  | Event type. For an external transaction, it could be CE_EXTERNAL_RECONCILED or CE_EXTERNAL_UNRECONCILED. |  |
ACCOUNTING_DATE | DATE |  |  |  | Date when the transaction was accounted. |  |
STATUS_CODE | VARCHAR2 | 32 |  |  | Status of the event, whether it is 'ACCOUNTED', 'UNACCOUNTED', or 'NOT_APPLICABLE'. |  |
CURRENT_RECORD_FLAG | VARCHAR2 | 16 |  |  | Flag to indicate whether this is the current record of the transaction. |  |
CLEARED_DATE | DATE |  |  |  | Date when the transaction was cleared. |  |
CLEARED_AMOUNT | BIGDECIMAL |  | 10 |  | Transaction amount that is cleared. |  |
CLEARED_EXCHANGE_RATE | BIGDECIMAL |  | 10 |  | Exchange rate used for clearing. |  |
CLEARED_EXCHANGE_DATE | DATE |  |  |  | Exchange date used for clearing. |  |
CLEARED_EXCHANGE_RATE_TYPE | VARCHAR2 | 32 |  |  | Exchange rate type used for clearing. |  |
REVERSAL_INDICATOR_FLAG | VARCHAR2 | 16 |  |  | Flag to indicate whether this is a reversal event. For example, 'CE_EXTERNAL_UNRECONCILED' is reversal event. |  |
REVERSAL_FIRST_DIST_ID | NUMBER | 38 | 0 |  | For a reversal event, the TRANSACTION_ID that this event is reversing. |  |
REVERSAL_SECOND_DIST_NUM | NUMBER | 38 | 0 |  | For a reversal event, the previous ACCT_HISTORY_ID that this event is reversing. |  |
CREATED_BY | VARCHAR2 | 128 |  |  | Indicates the user who created the row. |  |
CREATION_DATE | TIMESTAMP |  |  |  | Indicates the date and time of the creation of the row. |  |
LAST_UPDATED_BY | VARCHAR2 | 128 |  |  | Indicates the user who last updated the row. |  |
LAST_UPDATE_DATE | TIMESTAMP |  |  |  | Indicates the date and time of the last update of the row. |  |
LAST_UPDATE_LOGIN | VARCHAR2 | 32 |  |  | Indicates the session login associated to the user who last updated the row. |  |
OBJECT_VERSION_NUMBER | NUMBER | 38 | 0 |  | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. |  |

Copyright Â© 2019, 2026, Oracle and/or its affiliates.