CE_CP_STMT_LINES_INT
This interface table contains the bank statement line.
Details
-
Schema: FUSION
-
Object owner: CE
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
CE_CP_STMT_LINES_INT_PK |
CP_STMT_LINE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CP_STMT_LINE_ID | NUMBER | 18 | Yes | Sequentially generated surrogate ket for the statement lines interface table. | |
| SOURCE_STMT_HEADER_ID | NUMBER | 18 | Yes | Foreign key to the statement header of the statement line. | |
| SOURCE_SYSTEM | VARCHAR2 | 50 | Yes | Name of source application of the statement line. | |
| SOURCE | VARCHAR2 | 30 | Yes | Source of bank statement line. Valid values are Prior-Day Bank Statement Line and Intra-day Bank Statement Line. | |
| SOURCE_STMT_LINE_ID | NUMBER | 18 | Foreign key to the statement line. | ||
| BOOKING_DATE | DATE | Bank statement line booking date. | |||
| VALUE_DATE | DATE | Value date of the statement line. | |||
| FLOW_INDICATOR | VARCHAR2 | 15 | Flow indicator of the transaction. Valid values are INFLOW or OUTFLOW. | ||
| RECON_STATUS | VARCHAR2 | 30 | Reconciliation Status of the statement lines. | ||
| TRANSACTION_TYPE | VARCHAR2 | 80 | Transaction type of the statement line. | ||
| BANK_ACCT_AMOUNT | NUMBER | Amount in bank account currency. | |||
| REPORTING_AMOUNT | NUMBER | Statement line amount in reporting currency. | |||
| FUNCTIONAL_AMOUNT | NUMBER | Statement line amount in ledger 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 deleted transaction 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CE_CP_STMT_LINES_INT_N1 | Non Unique | FUSION_TS_TX_DATA | SOURCE_STMT_HEADER_ID, SOURCE, SOURCE_SYSTEM |
| CE_CP_STMT_LINES_INT_U1 | Unique | FUSION_TS_INTERFACE | CP_STMT_LINE_ID |