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 |