1. Tables and Views for Financials
  2. CE_CP_STMT_HEADERS_INT

CE_CP_STMT_HEADERS_INT

This interface table contains the bank statement header.

Details

  • Schema: FUSION

  • Object owner: CE

  • Object type: TABLE

  • Tablespace: INTERFACE

Primary Key

Name Columns

CE_CP_STMT_HEADERS_INT_PK

CP_STMT_HEADER_ID

Columns

Name Datatype Length Precision Not-null Comments
CP_STMT_HEADER_ID NUMBER 18 Yes Sequentially generated surrogate key for the statement headers interface table.
SOURCE_SYSTEM VARCHAR2 50 Yes Instance of the source. Valid values are FUSION, EBS or OTHER.
SOURCE VARCHAR2 30 Yes Source of bank statement. Valid values are Prior-Day Bank Statement and Intra-day Bank Statement.
FLOW_INDICATOR VARCHAR2 15 Flow Indicator of the statement header. Valid value is Balance.
SOURCE_STMT_HEADER_ID NUMBER 18 Yes Foreign key to the statement header.
BANK_ACCOUNT_NAME VARCHAR2 360 Name assigned to a bank account for identification purposes.
BANK_ACCOUNT_NUMBER VARCHAR2 80 Number of the bank account used by the deploying company.
IBAN_NUMBER VARCHAR2 50 International Bank Account Number.
BANK_NAME VARCHAR2 360 Name of the bank of the statement header.
LEGAL_ENTITY_NAME VARCHAR2 240 Name of the legal entity of the statement header.
LEGAL_ENTITY_REGION VARCHAR2 360 Name of the legal entity region of the statement header.
CASH_POOL_NAME VARCHAR2 80 Name of the cash pool dimension member
PARENT_CASH_POOL_NAME VARCHAR2 250 Fully qualified dimension member name of the parent cash pool
BANK_ACCT_CURRENCY_CODE VARCHAR2 15 Currency code of the bank account.
STATEMENT_TYPE VARCHAR2 20 Statement type of the statement header.
OPEN_LEDGER_BAL_DATE DATE Bank account's opening ledger balance date.
CLOSE_LEDGER_BAL_DATE DATE Bank account's closing ledger balance date.
OPEN_AVAILABLE_BAL_DATE DATE Bank account's opening available balance date.
CLOSE_AVAILABLE_BAL_DATE DATE Bank account's closing available balance date.
VALUE_DATED_BAL_DATE DATE Value dated balance date of the statement header.
BALANCE_DATE DATE Date when the statement balance was last reported.
TARGET_BAL_DATE DATE Date when the bank account target balance was reported.
BANK_ACCT_BAL NUMBER Bank account's balance in bank account currency.
BANK_ACCT_TARGET_BAL NUMBER Bank account's target balance in bank account currency.
FUNCTIONAL_BAL NUMBER Bank account's balance in ledger currency.
FUNCTIONAL_TARGET_BAL NUMBER Bank account's target balance in ledger currency.
REPORTING_BAL NUMBER Bank account's balance in reporting currency.
REPORTING_TARGET_BAL NUMBER Bank account's target balance in reporting currency.
BANK_ACCT_OPEN_LEDGER_BAL NUMBER Bank account's opening ledger balance in bank account currency.
BANK_ACCT_CLOSE_LEDGER_BAL NUMBER Bank account's closing ledger balance in bank account currency.
BANK_ACCT_OPEN_AVAILABLE_BAL NUMBER Bank account's available ledger balance in bank account currency.
BANK_ACCT_CLOSE_AVAILABLE_BAL NUMBER Bank account's closing available balance in bank account currency.
BANK_ACCT_1DAY_OPEN_FLOAT NUMBER Bank statement's opening 1 day float in bank account currency.
BANK_ACCT_2DAY_OPEN_FLOAT NUMBER Bank statement's opening 2 or more days float in bank account currency.
BANK_ACCT_1DAY_CLOSE_FLOAT NUMBER Bank statement's closing 1 day float in bank account currency.
BANK_ACCT_2DAY_CLOSE_FLOAT NUMBER Bank statement's closing 2 or more days float in bank account currency.
BANK_ACCT_CLOSE_VDATED_BAL NUMBER Bank account's closing value dated balance in bank account currency.
FUNCTIONAL_CURRENCY_CODE VARCHAR2 15 Ledger currency code of the statement header.
FUNCTIONAL_OPEN_LEDGER_BAL NUMBER Bank account's opening balance in ledger currency.
FUNCTIONAL_CLOSE_LEDGER_BAL NUMBER Bank account's closing balance in ledger currency.
FUNCTIONAL_OPEN_AVAILABLE_BAL NUMBER Bank account's opening available balance in ledger currency.
FUNCTIONAL_CLOSE_AVAILABLE_BAL NUMBER Bank account's closing available balance in ledger currency.
FUNCTIONAL_1DAY_OPEN_FLOAT NUMBER Bank account's opening 1 day float in ledger currency.
FUNCTIONAL_2DAY_OPEN_FLOAT NUMBER Bank account's opening 2 or more days float in ledger currency.
FUNCTIONAL_1DAY_CLOSE_FLOAT NUMBER Bank account's closing 1 day float in ledger currency.
FUNCTIONAL_2DAY_CLOSE_FLOAT NUMBER Bank account's closing 2 or more days float in ledger currency.
FUNCTIONAL_CLOSE_VDATED_BAL NUMBER Bank account's closing value dated balance in ledger currency.
REPORTING_OPEN_LEDGER_BAL NUMBER Bank account's opening ledger balance in reporting currency.
REPORTING_CLOSE_LEDGER_BAL NUMBER Bank account's closing ledger balance in reporting currency.
REPORTING_OPEN_AVAILABLE_BAL NUMBER Bank account's opening available balance in reporting currency.
REPORTING_CLOSE_AVAILABLE_BAL NUMBER Bank account's closing available balance in reporting currency.
REPORTING_1DAY_OPEN_FLOAT NUMBER Bank account's opening 1 day float in reporting currency.
REPORTING_2DAY_OPEN_FLOAT NUMBER Bank account's opening 2 or more days float in reporting currency.
REPORTING_1DAY_CLOSE_FLOAT NUMBER Bank account's closing 1 day float in reporting currency.
REPORTING_2DAY_CLOSE_FLOAT NUMBER Bank account's closing 2 or more days float in reporting currency.
REPORTING_CLOSE_VDATED_BAL NUMBER Bank account's closing value dated balance in reporting currency.
EXT_DIM_ATTRIBUTE1 VARCHAR2 80 Extensible Dimension Attribute 1
EXT_DIM_ATTRIBUTE2 VARCHAR2 80 Extensible Dimension Attribute 2
EXT_DIM_ATTRIBUTE3 VARCHAR2 80 Extensible Dimension Attribute 3
EXT_DIM_ATTRIBUTE4 VARCHAR2 80 Extensible Dimension Attribute 4
EXT_DIM_ATTRIBUTE5 VARCHAR2 80 Extensible Dimension Attribute 5
EXT_DIM_ATTRIBUTE6 VARCHAR2 80 Extensible Dimension Attribute 6
EXT_DIM_ATTRIBUTE7 VARCHAR2 80 Extensible Dimension Attribute 7
EXT_DIM_ATTRIBUTE8 VARCHAR2 80 Extensible Dimension Attribute 8
EXT_DIM_ATTRIBUTE9 VARCHAR2 80 Extensible Dimension Attribute 9
EXT_DIM_ATTRIBUTE10 VARCHAR2 80 Extensible Dimension Attribute 10
EXT_DIM_ATTRIBUTE11 VARCHAR2 80 Extensible Dimension Attribute 11
EXT_DIM_ATTRIBUTE12 VARCHAR2 80 Extensible Dimension Attribute 12
EXT_DIM_ATTRIBUTE13 VARCHAR2 80 Extensible Dimension Attribute 13
EXT_DIM_ATTRIBUTE14 VARCHAR2 80 Extensible Dimension Attribute 14
EXT_DIM_ATTRIBUTE15 VARCHAR2 80 Extensible Dimension Attribute 15
DELETE_FLAG VARCHAR2 1 Represents a transaction deleted from the source. Valid values are Yes or No.
ERROR_FLAG VARCHAR2 1 Indicates if there is a validation error for this record.
ERROR_CODE VARCHAR2 30 Error code of the validation error.
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_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LOAD_REQUEST_ID NUMBER 18 Request ID of the interface load job that created the row.
TRANSACTION_CALENDAR_ID NUMBER 18 Oracle internal use only.

Indexes

Index Uniqueness Tablespace Columns
CE_CP_STMT_HEADERS_INT_U1 Unique FUSION_TS_INTERFACE CP_STMT_HEADER_ID
CE_CP_STMT_HEADERS_INT_N1 Non Unique FUSION_TS_TX_DATA SOURCE_STMT_HEADER_ID, SOURCE, SOURCE_SYSTEM
CE_CP_STMT_HEADERS_INT_N2 Non Unique FUSION_TS_TX_DATA BANK_ACCOUNT_NAME, BANK_NAME, SOURCE_SYSTEM, SOURCE