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.
Module: Cash Management
BALANCE_SNAPSHOT_DATE, BANK_ACCOUNT_ID, BALANCE_CODE
| 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.