CE_STATEMENT_HEADERS
CE_STATEMENT_HEADERS contains the statement header information.
Details
-
Schema: FUSION
-
Object owner: CE
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
CE_STATEMENT_HEADERS_PK |
STATEMENT_HEADER_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
|---|---|---|---|---|---|---|
| STATEMENT_HEADER_ID | NUMBER | 18 | Yes | Unique identifier of the bank statement header. | ||
| BALANCE_CHECK | NUMBER | Amount difference between the opening balance plus all activities compared to the closing balance reported on the bank statement. If the amount does not equal zero there is an issue with the bank statement and needs to be investigated. | ||||
| STATEMENT_NUMBER | VARCHAR2 | 50 | Statement number. Should be unique within a bank account. | |||
| BANK_ACCOUNT_ID | NUMBER | 18 | Yes | Bank account on which the statement is reported. | ||
| CURRENCY_CODE | VARCHAR2 | 30 | Currency of the bank statement. | |||
| ELECTRONIC_SEQ_NUM | VARCHAR2 | 20 | Sequential number of the report, assigned by the account servicer. It is increased incrementally for each report sent electronically. | |||
| LEGAL_SEQ_NUM | VARCHAR2 | 20 | Legal sequential number of the report, assigned by the account servicer. It is increased incrementally for each report sent. | |||
| STATEMENT_DATE | DATE | Yes | Date when the bank statement was created. It appears on the bank statement. | |||
| STMT_FROM_DATE | DATE | Yes | Start date or time for which the account statement is issued. | |||
| STMT_TO_DATE | DATE | Yes | End date or time for which the account statement is issued. | |||
| RECON_STATUS_CODE | VARCHAR2 | 30 | Yes | Status of Bank Statement Reconciliation. Valid states are: New: New Statement, never reconciled. Ready: Statement ready for reconciliation. In Process: Reconciliation is in process Complete: Reconciliation is Complete. Reviewed: Statement has been reviewed and approved. | ||
| AUTOREC_PROCESS_CODE | VARCHAR2 | 30 | Status of the automatic reconciliation program completion. Valid values are UNPROCESSED, INPROCESS, WARNING, ERROR, PROCESSED. | |||
| AUTOREC_PROCESS_ID | NUMBER | Program identifier of the automatic reconciliation program. | ||||
| STATEMENT_ENTRY_TYPE | VARCHAR2 | 30 | Manual: Entered Manually Electronic: Imported | |||
| STATEMENT_TYPE | VARCHAR2 | 30 | Indicates the statement type. Interim Notification: memo information provided for daily cash flow projections, balances, and entries not booked by bank yet. Booking Notification: final statement data, information booked by bank, and balances reported. | |||
| INBOUND_FILE_ID | NUMBER | 18 | Indentifies the file from where the statement is imported. Foreign key to iby_inbound_file table. | |||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | |||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | |||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Statement Headers (CE_STATEMENT_HEADERS) | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Statement Headers (CE_STATEMENT_HEADERS) | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Statement Headers (CE_STATEMENT_HEADERS) | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Statement Headers (CE_STATEMENT_HEADERS) | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Statement Headers (CE_STATEMENT_HEADERS) | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Statement Headers (CE_STATEMENT_HEADERS) | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Statement Headers (CE_STATEMENT_HEADERS) | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Statement Headers (CE_STATEMENT_HEADERS) | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Statement Headers (CE_STATEMENT_HEADERS) | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Statement Headers (CE_STATEMENT_HEADERS) | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Statement Headers (CE_STATEMENT_HEADERS) | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Statement Headers (CE_STATEMENT_HEADERS) | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Statement Headers (CE_STATEMENT_HEADERS) | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Statement Headers (CE_STATEMENT_HEADERS) | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Statement Headers (CE_STATEMENT_HEADERS) | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Statement Headers (CE_STATEMENT_HEADERS) | ||
| GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Global Descriptive Flexfield: structure definition of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE1 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE2 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE3 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE4 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE5 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE6 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE7 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE8 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE9 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE10 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE11 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE12 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE13 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE14 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE15 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| INTRADAY_FLAG | VARCHAR2 | 1 | Indicator identifying this is an intraday bank statement. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| CE_STATEMENT_HEADERS | ce_bank_accounts | BANK_ACCOUNT_ID |
| ce_statement_lines | ce_statement_headers | STATEMENT_HEADER_ID |
| ce_stmt_balances | ce_statement_headers | STATEMENT_HEADER_ID |
| ce_recon_exceptions | ce_statement_headers | STATEMENT_HEADER_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CE_STATEMENT_HEADERS_N1 | Non Unique | Default | BANK_ACCOUNT_ID, RECON_STATUS_CODE |
| CE_STATEMENT_HEADERS_U1 | Unique | Default | STATEMENT_HEADER_ID |