This table requires activation of Cash Management functional area. This table contains details of all types of statement lines.
Module: Cash Management
STATEMENT_LINE_ID, STATEMENT_HEADER_ID
| 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.