This table requires activation of Cash Management functional area. This table contains aggregated details of statement headers.
Module: Cash Management
STATEMENT_HEADER_ID
| 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.