# DW_CE_EXTERNAL_TRANSACTIONS_CF (Preview)

This table requires activation of Cash Management functional area. This is the Fact table for Pre SLA External Transactions

## Details

Module: Cash Management

## Key Columns

EXTERNAL_TRANSACTION_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
EXTERNAL_TRANSACTION_ID | NUMBER | 38 | 0 | True | System generated identifier that is the primary key of the table. |  |
SOURCE_RECORD_ID | VARCHAR2 | 64 |  |  | This column is for Oracle Internal use only. Source record identifier |  |
LEDGER_ID | NUMBER | 38 | 0 |  | Unique ledger identifier. | DW_LEDGER_D | LEDGER_ID
FISCAL_PERIOD_SET_NAME | VARCHAR2 | 16 |  |  | Name of the accounting calendar. | DW_FISCAL_DAY_D | FISCAL_PERIOD_SET_NAME
FISCAL_PERIOD_TYPE | VARCHAR2 | 16 |  |  | Accounting period type. Examples are Weekly, Monthly, Quarterly. | DW_FISCAL_DAY_D | FISCAL_PERIOD_TYPE
CURRENT_ACCT_HISTORY_ID | NUMBER | 38 | 0 |  | Uniquely identifies account history. | DW_CE_ACCT_HISTORY_D | ACCT_HISTORY_ID
CURRENT_EVENT_ID | NUMBER | 38 | 0 |  | Accounting event identifier when the event is raised. |  |
CURRENT_EVENT_TYPE | VARCHAR2 | 32 |  |  | Event type. For an external transaction, it could be CE_EXTERNAL_RECONCILED or CE_EXTERNAL_UNRECONCILED. |  |
CURRENT_EVENT_STATUS_CODE | VARCHAR2 | 32 |  |  | Status of the event, whether it is 'ACCOUNTED', 'UNACCOUNTED', or 'NOT_APPLICABLE'. |  |
RECON_HISTORY_ID | NUMBER | 38 | 0 |  | Identifier for reconciliation history in which the transaction is reconciled. |  |
BANK_ACCOUNT_ID | NUMBER | 38 | 0 |  | Identifier of the bank account to which the transaction belongs. | DW_BANK_ACCOUNT_D | BANK_ACCOUNT_ID
BUSINESS_UNIT_ID | NUMBER | 38 | 0 |  | Identifier of the business unit to which the transaction belongs. | DW_BUSINESS_UNIT_D | BUSINESS_UNIT_ID
LEGAL_ENTITY_ID | NUMBER | 38 | 0 |  | Identifier of the legal entity to which the transaction belongs. | DW_LEGAL_ENTITY_D | LEGAL_ENTITY_ID
REFERENCE_TEXT | VARCHAR2 | 64 |  |  | External transaction reconciliation reference. |  |
TRANSACTION_ID | NUMBER | 38 | 0 |  | Identifier to identify the transaction. For external transactions, this is the TRANSACTION_ID, not the EXTERNAL_TRANSACTION_ID. |  |
STATEMENT_LINE_ID | NUMBER | 38 | 0 |  | Statement line from which the transaction is created. It is updated when the transaction source is of type statement. |  |
TRANSACTION_DATE | DATE |  |  |  | Date when the external transaction was created. | DW_DAY_D | CALENDAR_DATE
XT_VALUE_DATE | DATE |  |  |  | Actual value date of the transaction. | DW_DAY_D | CALENDAR_DATE
AMOUNT | BIGDECIMAL |  | 10 |  | Transaction amount. |  |
CURRENCY_CODE | VARCHAR2 | 16 |  |  | Currency code of the transaction. | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE
TRANSACTION_TYPE | VARCHAR2 | 32 |  |  | Type of transaction. | DW_CE_TRX_TYPE_LKP_TL | CE_TRX_TYPE_CODE
ACCOUNTING_FLAG | VARCHAR2 | 16 |  |  | Flag to indicate whether to raise accounting event when reconciled. | DW_YN_LKP_TL | YN_LKP_CODE
XT_STATUS | VARCHAR2 | 32 |  |  | Status to indicate whether this is a reconciled, unreconciled, or void transaction. | DW_CE_EXT_STATUS_LKP_TL | CE_EXT_STATUS_CODE
DESCRIPTION | VARCHAR2 | 512 |  |  | Description of the transaction. |  |
SOURCE | VARCHAR2 | 32 |  |  | Source from where this transaction is created. Possible values are: MANUAL (manually entered), IMPORT (imported), STMT (created from statement line), or RECON_DIFF (balancing transaction created from reconciliation amount difference). | DW_CE_EXT_TRANSACTION_SOURCE_LKP_TL | CE_EXT_TRANSACTION_SOURCE_CODE
ASSET_CCID | NUMBER | 38 | 0 |  | Cash general ledger account to be used when accounted. | DW_GL_CODE_COMBINATION_D | CODE_COMBINATION_ID
OFFSET_CCID | NUMBER | 38 | 0 |  | Offset general ledger account to be used when accounted. | DW_GL_CODE_COMBINATION_D | CODE_COMBINATION_ID
CLEARED_DATE | DATE |  |  |  | Date when the transaction is cleared. | DW_DAY_D | CALENDAR_DATE
TRANSFER_ID | NUMBER | 38 | 0 |  | Unique identifier of the bank account transfer or ad hoc payment that created the external cash transaction. | DW_CE_BAT_TRANSFERS_D | TRANSFER_ID
BANK_CONVERSION_RATE | BIGDECIMAL |  | 10 |  | The conversion rate between the bank account currency and the ledger currency on the external transaction. |  |
BANK_CONVERSION_RATE_TYPE | VARCHAR2 | 32 |  |  | The type of conversion rate between the bank account currency and the ledger currency on the external transaction. |  |
LAST_UPDATE_DATE | TIMESTAMP |  |  |  | Indicates the date and time of the last update of the row. |  |
LAST_UPDATED_BY | VARCHAR2 | 64 |  |  | Indicates the user who last updated the row. |  |
CREATION_DATE | TIMESTAMP |  |  |  | Indicates the date and time of the creation of the row. | DW_DAY_D | CALENDAR_DATE
CREATED_BY | VARCHAR2 | 64 |  |  | Indicates the user who created the row. |  |
AUTO_RECON_FLAG | VARCHAR2 | 16 |  |  | Flag to indicate whether this is a result from the automatic reconciliation. | DW_YN_LKP_TL | YN_LKP_CODE
STATEMENT_HEADER_ID | NUMBER | 38 | 0 |  | Unique identifier of the bank statement header. |  |
ELECTRONIC_SEQ_NUM | VARCHAR2 | 128 |  |  | Sequential number of the report assigned by the account servicer. It is increased incrementally for each report sent electronically. |  |
LEGAL_SEQ_NUM | VARCHAR2 | 128 |  |  | Legal sequential number of the report assigned by the account servicer. It is increased incrementally for each report sent. |  |
STMT_FROM_DATE | DATE |  |  |  | Start date or time for which the account statement is issued. | DW_DAY_D | CALENDAR_DATE
STMT_TO_DATE | DATE |  |  |  | End date or time for which the account statement is issued. | DW_DAY_D | CALENDAR_DATE
INTRADAY_FLAG | VARCHAR2 | 16 |  |  | Indicator identifying this is an intraday bank statement. | DW_YN_LKP_TL | YN_LKP_CODE
STATEMENT_ENTRY_TYPE | VARCHAR2 | 128 |  |  | Manual: Entered Manually Electronic: Imported | DW_CE_STMT_ENTRY_TYPE_LKP_TL | STMT_ENTRY_TYPE_CODE
HEADER_RECON_STATUS_CODE | VARCHAR2 | 32 |  |  | Status of Bank Statement Reconciliation. Valid states are: New: New Statement never reconciled. Ready: Statement ready for reconciliation. In Process: Reconciliation is in process Complete: Reconciliation is Complete. Reviewed: Statement has been reviewed and approved. | DW_CE_HDR_RECON_STATUS_LKP_TL | HDR_RECON_STATUS_CODE
STATEMENT_NUMBER | VARCHAR2 | 64 |  |  | Statement number. Should be unique within a bank account. |  |
STATEMENT_DATE | DATE |  |  |  | Date when the bank statement was created. It appears on the bank statement. | DW_DAY_D | CALENDAR_DATE
LINE_NUMBER | NUMBER | 38 | 0 |  | Statement Line number. It is automatically assigned and is incremented by 1. |  |
BOOKING_DATE | DATE |  |  |  | Date and time when an entry is posted to an account and on the books of an account servicer. | DW_FISCAL_DAY_D | FISCAL_DAY_DATE
STMT_LINE_VALUE_DATE | DATE |  |  |  | Date and time when assets become available to the account owner in a credit entry or cease to be available to the account owner in a debit entry. | DW_DAY_D | CALENDAR_DATE
RECON_REFERENCE | VARCHAR2 | 256 |  |  | Reconciliation Reference This field is used to store the bank reconciliation reference number. |  |
FLOW_INDICATOR | VARCHAR2 | 128 |  |  | Flow Indicator Indicates credit or debit of the statement line. Possible values are from lookup table with code type = CE_DEBIT_CREDIT. | DW_CE_FLOW_INDICATOR_LKP_TL | FLOW_INDICATOR_CODE
TRX_CODE_ID | NUMBER | 38 | 0 |  | Foreign key to TRANSACTION_CODE_ID in CE_TRANSACTION_CODES. | DW_CE_TRANSACTION_CODES_D | TRANSACTION_CODE_ID
TRX_TYPE | VARCHAR2 | 128 |  |  | This is same as the one associated with TRX_CODE_ID in CE_TRANSACTION_CODES. Storing this column redundantly again along with TRX_CODE to reduce a simple join to CE_TRANSACTION_CODES every time (TRX_TYPE is used in many queries). | DW_CE_TRX_TYPE_LKP_TL | CE_TRX_TYPE_CODE
CHECK_NUMBER | VARCHAR2 | 128 |  |  | Check number of the underlying transaction. |  |
ACCNT_SERVICER_REF | VARCHAR2 | 256 |  |  | Reference of the account servicing institution for the underlying transaction. |  |
CUSTOMER_REFERENCE | VARCHAR2 | 128 |  |  | Used by BAI2 format. Alphanumeric field defined by the originator. |  |
CLEARING_SYSTEM_REF | VARCHAR2 | 256 |  |  | Clearing System Reference Number assigned by the clearing house. |  |
ADDENDA_TXT | VARCHAR2 | 999 |  |  | Addenda Text Addtional information regarding the statement line. |  |
REVERSAL_IND_FLAG | VARCHAR2 | 16 |  |  | Reversal Ind Flag | DW_YN_LKP_TL | YN_LKP_CODE
CONTRACT_IDENTIFICATION | VARCHAR2 | 128 |  |  | Unique and unambiguous identifier of the foreign exchange contract. |  |
STMT_LINE_EXCHANGE_RATE | BIGDECIMAL |  | 10 |  | Factor used for the conversion of amount from one currency to another. This reflects the price at which one currency was bought with another currency. |  |
STMT_LINE_EXCHANGE_RATE_DATE | DATE |  |  |  | Date and time at which an exchange rate is quoted. |  |
GLOBAL_CURRENCY_CODE | VARCHAR2 | 16 |  |  | Global currency code. | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE
LEDGER_CURRENCY_CODE | VARCHAR2 | 16 |  |  | Functional currency of the ledger. | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE

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