CE_STATEMENT_LINES
CE_STATEMENT_LINES contains information about statement lines.
Details
-
Schema: FUSION
-
Object owner: CE
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
CE_STATEMENT_LINES_PK |
STATEMENT_LINE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
|---|---|---|---|---|---|---|
| STATEMENT_LINE_ID | NUMBER | 18 | Yes | Unique identifier of the bank statement line interface. | ||
| STATEMENT_HEADER_ID | NUMBER | 18 | Yes | Foreign key to the parent bank statement row. | ||
| LINE_NUMBER | NUMBER | 18 | Yes | Statement Line number. It is automatically assigned and is incremented by 1. | ||
| TRX_CODE_ID | NUMBER | 18 | Yes | Foreign key to TRANSACTION_CODE_ID in CE_TRANSACTION_CODES. | ||
| TRX_TYPE | VARCHAR2 | 30 | Yes | This is same as the one associated with TRX_CODE_ID in CE_TRANSACTION_CODES. Storing this column redundantly again along with TRX_CODE to reduce a simple join to CE_TRANSACTION_CODES every time (TRX_TYPE is used in many queries). | ||
| FLOW_INDICATOR | VARCHAR2 | 20 | Stores the line amount flow direction that is, credit or debit. Possible values are CRDT and DBIT. | |||
| RECON_STATUS | VARCHAR2 | 30 | Yes | Indicates whether a statement line is reconciled or not. | ||
| SERVICER_STATUS | VARCHAR2 | 20 | Status of an entry on the books of an account servicer. | |||
| AMOUNT | NUMBER | Yes | Statement line amount recorded in the bank statement. | |||
| REVERSAL_IND_FLAG | VARCHAR2 | 1 | Indicates whether the entry is the result of a reversal operation. | |||
| BOOKING_DATE | DATE | Yes | Date and time when an entry is posted to an account and on the books of an account servicer. | |||
| VALUE_DATE | DATE | Date and time when assets become available to the account owner in a credit entry, or cease to be available to the account owner in a debit entry. | ||||
| ACCNT_SERVICER_REF | VARCHAR2 | 50 | Reference of the account servicing institution for the underlying transaction. | |||
| COMM_WAIVER_IND_FLAG | VARCHAR2 | 1 | Indicates whether the transaction is exempted from commission. | |||
| TRX_AMOUNT | NUMBER | Amount of the underlying transaction. | ||||
| TRX_CURR_CODE | VARCHAR2 | 30 | Currency of the underlying transaction. | |||
| EXCHANGE_RATE | NUMBER | Factor used for the conversion of amount from one currency to another. This reflects the price at which one currency was bought with another currency. | ||||
| EXCHANGE_RATE_DATE | DATE | Date and time at which an exchange rate is quoted. | ||||
| EXCHANGE_RATE_TYPE | VARCHAR2 | 30 | Exchange rate type used in foreign exchange. | |||
| CONTRACT_IDENTIFICATION | VARCHAR2 | 20 | Unique and unambiguous identifier of the foreign exchange contract. | |||
| ORIG_BANK_ACCOUNT_ID | VARCHAR2 | 50 | A depository financial institution. Data is reported for accounts held. | |||
| ADDENDA_TXT | VARCHAR2 | 1000 | Additional information on the entry details. | |||
| CUSTOMER_REFERENCE | VARCHAR2 | 30 | Used by BAI2 format. Alphanumeric field defined by the originator. | |||
| EXTERNAL_TRANSACTION_ID | NUMBER | 18 | Foreign key of the bank statement transaction created in CE_EXTERNAL_TRANSACTIONS. | |||
| INSTRUCTION_IDENTIFICATION | VARCHAR2 | 100 | Unique identification assigned by an instructing party for an instructed party to unambiguously identify the instruction. The instruction identification is a point to point reference that can be used between the instructing party and the instructed party to refer the individual instruction. It can be included in several messages related to the instruction. | |||
| END_TO_END_ID | VARCHAR2 | 100 | Unique identification assigned by the initiating party to unumbiguously identify the transaction. It is passed on unchanged, throughout the entire end to end chain. | |||
| TRANSACTION_ID | VARCHAR2 | 20 | Unique identification assigned by the first instructing agent to unambiguously identify the transaction. It is passed on unchanged, throughout the entire interbank chain | |||
| RECON_REFERENCE | VARCHAR2 | 50 | Reference to the underlying transaction information. Used for reconciliation. | |||
| CHECK_NUMBER | VARCHAR2 | 40 | Check number of the underlying transaction. | |||
| CLEARING_SYSTEM_REF | VARCHAR2 | 50 | Unique and unambiguous identifier for a payment instruction, assigned by the clearing system. | |||
| RECON_HISTORY_ID | NUMBER | 18 | Identifier of the reconciliation history information. | |||
| EXCEPTION_FLAG | VARCHAR2 | 1 | Indicates whether a reconciliation exception is found for the statement line. | |||
| REVERSAL_REASON_CODE | VARCHAR2 | 30 | Indicates the statement line reversal reason. | |||
| STRUCTURED_PAYMENT_REFERENCE | VARCHAR2 | 256 | Structured payment or receipt reference on bank statement line. Used for reconciliation. | |||
| 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. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | |||
| 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. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Statement Lines (CE_STATEMENT_LINES) | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Statement Lines (CE_STATEMENT_LINES) | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Statement Lines (CE_STATEMENT_LINES) | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Statement Lines (CE_STATEMENT_LINES) | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Statement Lines (CE_STATEMENT_LINES) | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Statement Lines (CE_STATEMENT_LINES) | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Statement Lines (CE_STATEMENT_LINES) | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Statement Lines (CE_STATEMENT_LINES) | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Statement Lines (CE_STATEMENT_LINES) | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Statement Lines (CE_STATEMENT_LINES) | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Statement Lines (CE_STATEMENT_LINES) | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Statement Lines (CE_STATEMENT_LINES) | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Statement Lines (CE_STATEMENT_LINES) | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Statement Lines (CE_STATEMENT_LINES) | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Statement Lines (CE_STATEMENT_LINES) | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Statement Lines (CE_STATEMENT_LINES) | ||
| 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. | |||
| MESSAGE_IDENTIFIER | VARCHAR2 | 30 | Point-to-point reference assigned by the sending party to identify the transaction batch. | |||
| PAYMENT_INFO_IDENTIFIER | VARCHAR2 | 30 | Unique identification assigned by the sending party to identify the payment information group within the message. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| CE_STATEMENT_LINES | ce_transaction_codes | TRX_CODE_ID |
| CE_STATEMENT_LINES | ce_statement_headers | STATEMENT_HEADER_ID |
| ce_stmt_line_avalbty | ce_statement_lines | STATEMENT_LINE_ID |
| ce_recon_exceptions | ce_statement_lines | STATEMENT_LINE_ID |
| ce_stmt_line_charges | ce_statement_lines | STATEMENT_LINE_ID |
| ce_external_transactions | ce_statement_lines | STATEMENT_LINE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CE_STATEMENT_LINES_N1 | Non Unique | Default | STATEMENT_HEADER_ID, RECON_STATUS |
| CE_STATEMENT_LINES_U1 | Unique | Default | STATEMENT_LINE_ID |