# DW_CE_STATEMENT_BALANCES_CF (Preview)

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

## Details

Module: Cash Management

## Key Columns

STMT_BALANCE_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
STMT_BALANCE_ID | NUMBER | 38 | 0 | True | Unique identifier of the bank statement balance. |  |
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 balance identifier. |  |
LEGAL_ENTITY_ID | NUMBER | 38 | 0 |  | Account Owner Organization Id | 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
BALANCE_CODE | VARCHAR2 | 256 |  |  | Specifies the nature of balance. For example opening booked balance. | DW_CE_INTERNAL_BALANCE_CODES_LKP_TL | CE_INTERNAL_BALANCE_CODES_CODE
BALANCE_CURR | VARCHAR2 | 128 |  |  | Currency code of the bank account balance. | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE
BALANCE_DATE | DATE |  |  |  | Specifies the Date of the Balance. | DW_FISCAL_DAY_D | FISCAL_DAY_DATE
BANK_ACCOUNT_ID | NUMBER | 38 | 0 |  | Bank account on which the balance is reported. | DW_BANK_ACCOUNT_D | BANK_ACCOUNT_ID
BALANCE_CREATED_BY | VARCHAR2 | 512 |  |  | Who column: indicates the user who created the row. | DW_USER_D | USERNAME
BALANCE_CREATION_DATE | TIMESTAMP |  |  |  | Who column: indicates the date and time of the creation of the row. |  |
STATEMENT_CREATED_BY | VARCHAR2 | 128 |  |  | Who column: indicates the user who created the row. | DW_USER_D | USERNAME
STATEMENT_CREATION_DATE | TIMESTAMP |  |  |  | Who column: indicates the date and time of the creation of the row. |  |
BANK_ACCOUNT_CURRENCY_CODE | VARCHAR2 | 32 |  |  | Currency of the bank account. | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE
LAST_UPDATED_BY | VARCHAR2 | 512 |  |  | 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. |  |
STATEMENT_DATE | DATE |  |  |  | Date when the bank statement was created. It appears on the bank statement. | DW_DAY_D | CALENDAR_DATE
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
STATEMENT_ENTRY_TYPE | VARCHAR2 | 32 |  |  | Manual: Entered Manually Electronic: Imported | DW_CE_STMT_ENTRY_TYPE_LKP_TL | STMT_ENTRY_TYPE_CODE
STATEMENT_HEADER_ID | NUMBER | 38 | 0 |  | Unique identifier of the bank statement header. |  |
STATEMENT_NUMBER | VARCHAR2 | 64 |  |  | Statement number. Should be unique within a bank account. |  |
STATEMENT_RECON_STATUS_CODE | VARCHAR2 | 32 |  |  | Status of the reconciliation process. | DW_CE_HDR_RECON_STATUS_LKP_TL | HDR_RECON_STATUS_CODE
ELECTRONIC_SEQ_NUM | VARCHAR2 | 32 |  |  | Sequential number of the report assigned by the account servicer. It is increased incrementally for each report sent electronically. |  |
LEGAL_SEQ_NUM | VARCHAR2 | 32 |  |  | Legal sequential number of the report assigned by the account servicer. It is increased incrementally for each report sent. |  |
INTRADAY_FLAG | VARCHAR2 | 16 |  |  | Indicator identifying this is an intraday bank statement. | DW_YN_LKP_TL | YN_LKP_CODE
GLOBAL_CURRENCY_CODE | VARCHAR2 | 32 |  |  | Global currency code. | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE
GLOBAL_CURRENCY_EXCH_RATE | BIGDECIMAL |  | 10 |  | Global currency conversion rate. |  |
BALANCE_AMOUNT | BIGDECIMAL |  | 10 |  | Balance amount corresponding to the balance code. |  |
BALANCE_GLOBAL_AMOUNT | BIGDECIMAL |  | 10 |  | Balance amount in global currency. |  |

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