# DW_CE_STATEMENT_LINES_CF (Preview)

This table requires activation of Cash Management functional area. This table contains details of all types of statement lines.

## Details

Module: Cash Management

## Key Columns

STATEMENT_LINE_ID, STATEMENT_HEADER_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
STATEMENT_HEADER_ID | NUMBER | 38 | 0 | True | Unique identifier of the bank statement header. |  |
STATEMENT_LINE_ID | NUMBER | 38 | 0 | True | Unique identifier of the bank statement line interface. |  |
SOURCE_RECORD_ID | VARCHAR2 | 128 |  |  | This column is for Oracle Internal use only. Source record identifier. Values are derived from combination of statement header identifier and statement line identifier. |  |
LEGAL_ENTITY_ID | NUMBER | 38 | 0 |  | Legal entity identifier. | DW_LEGAL_ENTITY_D | LEGAL_ENTITY_ID
LEDGER_ID | NUMBER | 38 | 0 |  | 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
ACCNT_SERVICER_REF | VARCHAR2 | 64 |  |  | Reference of the account servicing institution for the underlying transaction. |  |
ADDENDA_TXT | VARCHAR2 | 999 |  |  | Addenda Text Addtional information regarding the statement line. |  |
BANK_ACCOUNT_ID | NUMBER | 38 | 0 |  | Bank account on which the statement is reported. | DW_BANK_ACCOUNT_D | BANK_ACCOUNT_ID
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
CHECK_NUMBER | VARCHAR2 | 64 |  |  | Check number of the underlying transaction. |  |
CLEARING_SYSTEM_REF | VARCHAR2 | 64 |  |  | Clearing System Reference Number assigned by the clearing house. |  |
COMM_WAIVER_IND_FLAG | VARCHAR2 | 16 |  |  | Indicates whether the transaction is exempted from commission. Y or N | DW_YN_LKP_TL | YN_LKP_CODE
CONTRACT_IDENTIFICATION | VARCHAR2 | 32 |  |  | Unique and unambiguous identifier of the foreign exchange contract. |  |
STMT_CREATED_BY | VARCHAR2 | 128 |  |  | Who column: indicates the user who created the row for the statement header. | DW_USER_D | USERNAME
STMT_CREATION_DATE | TIMESTAMP |  |  |  | Who column: indicates the date and time of the creation of the row for the statement header. |  |
LINE_CREATED_BY | VARCHAR2 | 128 |  |  | Who column: indicates the user who created the row for the statement line. | DW_USER_D | USERNAME
LINE_CREATION_DATE | TIMESTAMP |  |  |  | Who column: indicates the date and time of the creation of the row for the statement line. |  |
BANK_ACCOUNT_CURRENCY_CODE | VARCHAR2 | 16 |  |  | Currency of the bank account. | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE
CUSTOMER_REFERENCE | VARCHAR2 | 32 |  |  | Used by BAI2 format. Alphanumeric field defined by the originator. |  |
ELECTRONIC_SEQ_NUM | VARCHAR2 | 32 |  |  | Sequential number of the report assigned by the account servicer. It is increased incrementally for each report sent electronically. |  |
END_TO_END_ID | VARCHAR2 | 128 |  |  | End to End Identification This is the unique identification of a transaction assigned by the initiating party. |  |
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. |  |
EXCHANGE_RATE_DATE | DATE |  |  |  | Date and time at which an exchange rate is quoted. |  |
EXTERNAL_TRANSACTION_ID | NUMBER | 38 | 0 |  | Foreign key of the bank statement transaction created in CE_EXTERNAL_TRANSACTIONS. |  |
FLOW_INDICATOR | VARCHAR2 | 32 |  |  | 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
INSTRUCTION_IDENTIFICATION | VARCHAR2 | 128 |  |  | Unique identification assigned by an instructing party for an instructed party to unambiguously identify the instruction. The instruction identification is a point to point reference that can be used between the instructing party and the instructed party to refer the individual instruction. It can be included in several messages related to the instruction. |  |
INTRADAY_FLAG | VARCHAR2 | 16 |  |  | Indicator identifying this is an intraday bank statement. | DW_YN_LKP_TL | YN_LKP_CODE
LAST_UPDATED_BY | VARCHAR2 | 128 |  |  | Who column: indicates the user who last updated the row. | DW_USER_D | USERNAME
LAST_UPDATE_DATE | TIMESTAMP |  |  |  | Who column: indicates the date and time of the last update of the row. |  |
LEGAL_SEQ_NUM | VARCHAR2 | 32 |  |  | Legal sequential number of the report assigned by the account servicer. It is increased incrementally for each report sent. |  |
LINE_NUMBER | NUMBER | 38 | 0 |  | Statement Line number. It is automatically assigned and is incremented by 1. |  |
RECON_REFERENCE | VARCHAR2 | 64 |  |  | Reconciliation Reference This field is used to store the bank reconciliation reference number. |  |
LINE_RECON_STATUS | VARCHAR2 | 32 |  |  | Indicates whether a statement line is reconciled or not. | DW_CE_LINE_RECON_STATUS_LKP_TL | LINE_RECON_STATUS_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_DATE | DATE |  |  |  | Date when the bank statement was created. It appears on the bank statement. | DW_DAY_D | CALENDAR_DATE
STATEMENT_ENTRY_TYPE | VARCHAR2 | 32 |  |  | Manual: Entered Manually Electronic: Imported | DW_CE_STMT_ENTRY_TYPE_LKP_TL | STMT_ENTRY_TYPE_CODE
STATEMENT_NUMBER | VARCHAR2 | 64 |  |  | Statement number. Should be unique within a bank account. |  |
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
TRANSACTION_ID | VARCHAR2 | 32 |  |  | Unique identification assigned by the first instructing agent to unambiguously identify the transaction. It is passed on unchanged throughout the entire interbank chain |  |
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_CURR_CODE | VARCHAR2 | 32 |  |  | Currency of the underlying transaction. | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE
TRX_TYPE | VARCHAR2 | 32 |  |  | 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
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
EXCEPTION_FLAG | VARCHAR2 | 16 |  |  | Indicates if the line is parked as exception. Possible values are from lookup table with code type = CE_EXCEPTION. | DW_YN_LKP_TL | YN_LKP_CODE
AUTO_RECON_FLAG | VARCHAR2 | 16 |  |  | Flag to indicate whether this is a result from the automatic reconciliation. | DW_YN_LKP_TL | YN_LKP_CODE
RECON_CREATION_DATE | TIMESTAMP |  |  |  | Who column: indicates the date and time of the creation of the row. |  |
RECON_CREATED_BY | VARCHAR2 | 512 |  |  | Who column: indicates the user who created the row. | DW_USER_D | USERNAME
GLOBAL_CURRENCY_CODE | VARCHAR2 | 32 |  |  | Currency of the global amount column. Should be a constant value. | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE
GLOBAL_CURRENCY_EXCH_RATE | BIGDECIMAL |  | 10 |  | Exchange rate used to calculate the global amount. It is the exchange rate between the bank currency and the global currency on the booking date. |  |
STMT_LINE_AMOUNT | BIGDECIMAL |  | 10 |  | Statement line amount recorded in the bank statement. |  |
STMT_LINE_ORIGINAL_TRX_AMOUNT | BIGDECIMAL |  | 10 |  | Amount of the underlying transaction. |  |
GLOBAL_LINE_AMOUNT | BIGDECIMAL |  | 10 |  | Amount of the statement line converted to the global currency using the booking date. |  |
STMT_LINE_ORIGINAL_TRX_GLOBAL_AMOUNT | BIGDECIMAL |  | 10 |  | Original transaction amount of the statement line converted to the global currency using the transaction date exchange rate. |  |
DEPOSIT_AMOUNT | BIGDECIMAL |  | 10 |  | Amount of the statement line if it is a deposit in the currency of the bank statement. |  |
PAYMENT_AMOUNT | BIGDECIMAL |  | 10 |  | Amount of the statement line if it is a payment in the currency of the bank statement. |  |
DEPOSIT_GLOBAL_AMOUNT | BIGDECIMAL |  | 10 |  | Amount of the statement line if it is a deposit converted to the global currency using the booking date. |  |
PAYMENT_GLOBAL_AMOUNT | BIGDECIMAL |  | 10 |  | Amount of the statement line if it is a payment converted to the global currency using the booking date. |  |
ORIG_BANK_ACCOUNT_ID | VARCHAR2 | 64 |  |  | A depository financial institution. Data is reported for accounts held. | DW_YN_LKP_TL | YN_LKP_CODE
REVERSAL_IND_FLAG | VARCHAR2 | 16 |  |  | Reversal Ind Flag | DW_YN_LKP_TL | YN_LKP_CODE

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