This table requires activation of Cash Management functional area. This is the Fact table forCash Management External Transactions SLA fact
Module: Cash Management
EXTERNAL_TRANSACTION_ID, TEMP_LINE_NUM, TRANSACTION_ID, AE_HEADER_ID, REF_AE_HEADER_ID, 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. | DW_CE_ACCT_HISTORY_D | ACCT_HISTORY_ID |
| TRANSACTION_ID | NUMBER | 38 | 0 | True | Identifier to identify the transaction. For external transactions, this is the TRANSACTION_ID, not the EXTERNAL_TRANSACTION_ID. | ||
| EXTERNAL_TRANSACTION_ID | NUMBER | 38 | 0 | True | System generated identifier that is the primary key of the table. | ||
| REF_AE_HEADER_ID | NUMBER | 38 | 0 | True | Reversed subledger journal entry header identifier. | ||
| AE_HEADER_ID | NUMBER | 38 | 0 | True | Subledger journal entry identifier. | ||
| TEMP_LINE_NUM | NUMBER | 38 | 0 | True | Intermediary line number generated by the accounting engine when the entries are in most detail form. | ||
| SOURCE_RECORD_ID | VARCHAR2 | 512 | This column is for Oracle Internal use only. Source record identifier | ||||
| TRANSACTION_SOURCE | VARCHAR2 | 32 | Source of the transaction that is being accounted. | ||||
| 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. | ||||
| EVENT_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. | DW_YN_LKP_TL | YN_LKP_CODE | ||
| CLEARED_DATE | DATE | Date when the transaction was cleared. | DW_DAY_D | CALENDAR_DATE | |||
| 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. | ||||
| 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. | ||||
| 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 | ||
| 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). | ||||
| 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 | |
| XT_CLEARED_DATE | DATE | Date when the transaction was 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 | ||
| GLOBAL_CURRENCY_EXCH_RATE | NUMBER | Global currency conversion rate. | |||||
| XLA_TRANSACTION_CURRENCY_CODE | VARCHAR2 | 16 | Entered currency for the transaction data. | ||||
| XLA_LEDGER_CURRENCY_CODE | VARCHAR2 | 16 | Functional currency of the ledger. | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE | ||
| XLA_TRANSACTION_AMOUNT | BIGDECIMAL | 10 | Unrounded entered debit amount for the journal line minus Unrounded entered credit amount for the journal line. | ||||
| XLA_LEDGER_AMOUNT | BIGDECIMAL | 10 | Unrounded accounted debit for journal entry line minus Unrounded accounted credit for journal entry line. | ||||
| XLA_ENTERED_DR_AMOUNT | BIGDECIMAL | 10 | Unrounded entered debit amount for the journal line. | ||||
| XLA_ENTERED_CR_AMOUNT | BIGDECIMAL | 10 | Unrounded entered credit amount for the journal line. | ||||
| XLA_ACCOUNTED_DR_AMOUNT | BIGDECIMAL | 10 | Unrounded accounted debit for journal entry line. | ||||
| XLA_ACCOUNTED_CR_AMOUNT | BIGDECIMAL | 10 | Unrounded accounted credit for journal entry line. | ||||
| XLA_GLOBAL_AMOUNT | BIGDECIMAL | 10 | Unrounded global debit amount for the journal line minus Unrounded global credit amount for the journal line. | ||||
| XLA_GLOBAL_DR_AMOUNT | BIGDECIMAL | 10 | Unrounded global debit amount for the journal line. | ||||
| XLA_GLOBAL_CR_AMOUNT | BIGDECIMAL | 10 | Unrounded global credit amount for the journal line. | ||||
| XLA_MANUAL_OVERRIDE_FLAG | VARCHAR2 | 32 | Indicates a manual override. Values are from the table DW_YESNO_LKP_TL with CODE_TYPE=FA_YESNO. | DW_YESNO_LKP_TL | YESNO_LKP_CODE | ||
| SOURCE_DISTRIBUTION_TYPE | VARCHAR2 | 32 | Classification of transaction source distribution. | ||||
| ACCOUNTING_LINE_CODE | VARCHAR2 | 32 | Short name of a rule to convert transactional data into a journal entry line. | ||||
| ACCOUNTING_LINE_TYPE_CODE | VARCHAR2 | 16 | Indicates whether the journal line rule is seeded. | ||||
| AE_LINE_NUM | NUMBER | 38 | 0 | Number that is associated with each subledger journal entry line. | |||
| ACCOUNTING_CLASS_CODE | VARCHAR2 | 32 | Short name of a lookup type that is shared across application used to classify journal entry lines. | DW_XLA_ACCOUNT_CLASS_LKP_TL | ACCOUNTING_CLASS_CODE | ||
| XLA_LINE_TRANSACTION_AMOUNT | BIGDECIMAL | 10 | Line level unrounded entered debit amount for the journal line minus Line level unrounded entered credit amount for the journal line. | ||||
| XLA_LINE_ENTERED_DR_AMOUNT | BIGDECIMAL | 10 | Line level unrounded entered debit amount for the journal line. | ||||
| XLA_LINE_ENTERED_CR_AMOUNT | BIGDECIMAL | 10 | Line level unrounded entered credit amount for the journal line. | ||||
| XLA_LINE_LEDGER_AMOUNT | BIGDECIMAL | 10 | Line level unrounded accounted debit amount of the journal entry line minus Line level unrounded accounted credit amount of the journal entry line. | ||||
| XLA_LINE_ACCOUNTED_DR_AMOUNT | BIGDECIMAL | 10 | Line level unrounded accounted debit amount of the journal entry line. | ||||
| XLA_LINE_ACCOUNTED_CR_AMOUNT | BIGDECIMAL | 10 | Line level unrounded accounted credit amount of the journal entry line. | ||||
| XLA_LINE_GLOBAL_AMOUNT | BIGDECIMAL | 10 | Line level unrounded global debit amount for the journal line minus Line level unrounded global credit amount for the journal line. | ||||
| XLA_LINE_GLOBAL_DR_AMOUNT | BIGDECIMAL | 10 | Line level unrounded global debit amount for the journal line. | ||||
| XLA_LINE_GLOBAL_CR_AMOUNT | BIGDECIMAL | 10 | Line level unrounded global credit amount for the journal line. | ||||
| XLA_EVENT_ID | NUMBER | 38 | 0 | Identifier of the categorization of accounting events that is unique within an application and event class. | |||
| XLA_EVENT_CLASS_CODE | VARCHAR2 | 32 | Unique abbreviated name assigned to an event class and used for reporting or in reference to an option. | ||||
| XLA_EVENT_TYPE_CODE | VARCHAR2 | 32 | Unique abbreviated name assigned to an event type and used for reporting or in reference to an option. | ||||
| XLA_ACCOUNTING_DATE | DATE | Date, referenced from Oracle Fusion General Ledger, used to determine the accounting period for transactions. | |||||
| XLA_LEDGER_ID | NUMBER | 38 | 0 | Self-contained accounting information set for single or multiple legal or management entities. | |||
| 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 | ||
| FISCAL_PERIOD_NAME | VARCHAR2 | 64 | Accounting period name. | ||||
| GL_CODE_COMBINATION_ID | NUMBER | 38 | 0 | GL account identifier. | DW_GL_CODE_COMBINATION_D | CODE_COMBINATION_ID | |
| COST_CENTER_SEGMENT | VARCHAR2 | 32 | Cost center segment. | DW_COST_CENTER_D | COST_CENTER_SEGMENT | ||
| COST_CENTER_VALUESET_CODE | VARCHAR2 | 64 | Cost center value set code. | DW_COST_CENTER_D | COST_CENTER_VALUESET_CODE | ||
| GL_BALANCING_SEGMENT | VARCHAR2 | 32 | Balancing segment. | DW_BALANCING_SEGMENT_D | GL_BALANCING_SEGMENT | ||
| GL_BLNC_SGMNT_VALUESET_CODE | VARCHAR2 | 64 | Balancing segment value set code. | DW_BALANCING_SEGMENT_D | GL_BLNC_SGMNT_VALUESET_CODE | ||
| NATURAL_ACCOUNT_SEGMENT | VARCHAR2 | 32 | Natural account segment. | DW_NATURAL_ACCOUNT_D | NATURAL_ACCOUNT_SEGMENT | ||
| NTRL_ACNT_SGMNT_VALUESET_CODE | VARCHAR2 | 64 | Natural account value set code. | DW_NATURAL_ACCOUNT_D | NTRL_ACNT_SGMNT_VALUESET_CODE | ||
| GL_SEGMENT1 | VARCHAR2 | 32 | Accounting segment 1. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE | ||
| GL_SEGMENT1_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 1 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE | ||
| GL_SEGMENT2 | VARCHAR2 | 32 | Accounting segment 2. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE | ||
| GL_SEGMENT2_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 2 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE | ||
| GL_SEGMENT3 | VARCHAR2 | 32 | Accounting segment 3. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE | ||
| GL_SEGMENT3_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 3 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE | ||
| GL_SEGMENT4 | VARCHAR2 | 32 | Accounting segment 4. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE | ||
| GL_SEGMENT4_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 4 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE | ||
| GL_SEGMENT5 | VARCHAR2 | 32 | Accounting segment 5. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE | ||
| GL_SEGMENT5_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 5 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE | ||
| GL_SEGMENT6 | VARCHAR2 | 32 | Accounting segment 6. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE | ||
| GL_SEGMENT6_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 6 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE | ||
| GL_SEGMENT7 | VARCHAR2 | 32 | Accounting segment 7. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE | ||
| GL_SEGMENT7_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 7 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE | ||
| GL_SEGMENT8 | VARCHAR2 | 32 | Accounting segment 8. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE | ||
| GL_SEGMENT8_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 8 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE | ||
| GL_SEGMENT9 | VARCHAR2 | 32 | Accounting segment 9. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE | ||
| GL_SEGMENT9_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 9 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE | ||
| GL_SEGMENT10 | VARCHAR2 | 32 | Accounting segment 10. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE | ||
| GL_SEGMENT10_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 10 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE | ||
| XDL_CREATION_DATE | TIMESTAMP | Indicates the date and time of the creation of the row. |
Copyright © 2019, 2026, Oracle and/or its affiliates.