This table requires activation of Cash Management functional area. DW_CE_ACCT_HISTORY_D contains information about account history.
Module: Cash Management
ACCT_HISTORY_ID
| 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.