# DW_CE_STATEMENT_HEADERS_CA (Preview)

This table requires activation of Cash Management functional area. This table contains aggregated details of statement headers.

## Details

Module: Cash Management

## Key Columns

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 for the bank statement header. |  |
SOURCE_RECORD_ID | VARCHAR2 | 128 |  |  | This column is for Oracle Internal use only. Source record identifier for the statement header. |  |
ELECTRONIC_SEQ_NUM | VARCHAR2 | 32 |  |  | Electronic sequential number assigned to the statement. |  |
LEGAL_SEQ_NUM | VARCHAR2 | 64 |  |  | Legal sequential number of the statement. |  |
STMT_FROM_DATE | DATE |  |  |  | Start date for the bank statement period. | DW_DAY_D | CALENDAR_DATE
STMT_TO_DATE | DATE |  |  |  | End date for the bank statement period. | DW_DAY_D | CALENDAR_DATE
INTRADAY_FLAG | VARCHAR2 | 16 |  |  | Indicates whether the statement is intraday. | DW_YN_LKP_TL | YN_LKP_CODE
STATEMENT_DATE | DATE |  |  |  | Date of the statement. | DW_DAY_D | CALENDAR_DATE
STATEMENT_NUMBER | VARCHAR2 | 64 |  |  | Number of the statement. |  |
STATEMENT_ENTRY_TYPE | VARCHAR2 | 64 |  |  | Type of statement entry (Manual or Electronic). | DW_CE_STMT_ENTRY_TYPE_LKP_TL | STMT_ENTRY_TYPE_CODE
RECON_STATUS_CODE | VARCHAR2 | 32 |  |  | Status of the reconciliation process. | DW_CE_HDR_RECON_STATUS_LKP_TL | HDR_RECON_STATUS_CODE
BANK_ACCOUNT_ID | NUMBER | 38 | 0 |  | Bank account ID for the statement header. | DW_BANK_ACCOUNT_D | BANK_ACCOUNT_ID
LEDGER_ID | NUMBER | 38 | 0 |  | Identifier for the associated ledger. | DW_LEDGER_D | LEDGER_ID
LEGAL_ENTITY_ID | NUMBER | 38 | 0 |  | Identifier for the legal entity associated with the account. | DW_LEGAL_ENTITY_D | LEGAL_ENTITY_ID
BANK_ACCOUNT_CURRENCY_CODE | VARCHAR2 | 32 |  |  | Currency code of the bank account. | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE
FISCAL_PERIOD_SET_NAME | VARCHAR2 | 64 |  |  | Name of the fiscal period set. | DW_FISCAL_DAY_D | FISCAL_PERIOD_SET_NAME
FISCAL_PERIOD_TYPE | VARCHAR2 | 64 |  |  | Type of the fiscal period. | DW_FISCAL_DAY_D | FISCAL_PERIOD_TYPE
CREATED_BY | VARCHAR2 | 64 |  |  | User who created the statement. | DW_USER_D | USERNAME
CREATION_DATE | TIMESTAMP |  |  |  | Date when the statement was created. |  |
GLOBAL_CURRENCY_CODE | VARCHAR2 | 32 |  |  | Global currency code used for reporting. | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE
STMT_AMOUNT | BIGDECIMAL |  | 10 |  | Amount of the statement transactions (in bank account currency). |  |
STMT_ORIGINAL_TRX_AMOUNT | BIGDECIMAL |  | 10 |  | Original transaction amount. |  |
STMT_GLOBAL_AMOUNT | BIGDECIMAL |  | 10 |  | Amount of the statement transactions in the global currency. |  |
STMT_ORIGINAL_TRX_GLOBAL_AMOUNT | BIGDECIMAL |  | 10 |  | Original transaction amount in the global currency. |  |
DEPOSIT_AMOUNT | BIGDECIMAL |  | 10 |  | Total deposit amount for the statement. |  |
PAYMENT_AMOUNT | BIGDECIMAL |  | 10 |  | Total payment amount for the statement. |  |
DEPOSIT_GLOBAL_AMOUNT | BIGDECIMAL |  | 10 |  | Total deposit amount for the statement in the global currency. |  |
PAYMENT_GLOBAL_AMOUNT | BIGDECIMAL |  | 10 |  | Total payment amount for the statement in the global currency. |  |
LAST_RECON_DATE | TIMESTAMP |  |  |  | Latest statement line recon date |  |

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