# DW_CE_STATEMENT_BALANCES_DAILY_CF (Preview)

This table requires activation of Cash Management functional area. This table will hold the day level snapshot records for an account and balance code from the snapshot start date.

## Details

Module: Cash Management

## Key Columns

BALANCE_SNAPSHOT_DATE, BANK_ACCOUNT_ID, BALANCE_CODE

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
BANK_ACCOUNT_ID | NUMBER | 38 | 0 | True | Bank account on which the balance is reported. | DW_BANK_ACCOUNT_D | BANK_ACCOUNT_ID
BALANCE_CODE | VARCHAR2 | 256 |  | True | Specifies the nature of balance. For example opening booked balance. |  |
BALANCE_SNAPSHOT_DATE | DATE |  |  | True | balance snapshot date |  |
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. |  |
STMT_BALANCE_ID | NUMBER | 38 | 0 |  | Unique identifier of the bank statement balance. |  |
LAST_BALANCE_DATE | DATE |  |  |  | Specifies the Date of the Balance. |  |
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_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
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_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. |  |
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 | 64 |  |  | Manual: Entered Manually Electronic: Imported | DW_CE_STMT_ENTRY_TYPE_LKP_TL | STMT_ENTRY_TYPE_CODE
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.