This table requires activation of Cash Management functional area. This is the Fact table for Pre SLA External Transactions
Module: Cash Management
EXTERNAL_TRANSACTION_ID
| 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.