CE_RECON_STMT_GT
This is a temporary table which is used internally by Oracle.
Details
-
Schema: FUSION
-
Object owner: CE
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Comments |
|---|---|---|---|---|
| STATEMENT_LINE_ID | NUMBER | 18 | Oracle internal use only. | |
| LINE_NUMBER | NUMBER | 18 | Oracle internal use only. | |
| STATEMENT_HEADER_ID | NUMBER | 18 | Oracle internal use only. | |
| REVERSAL_IND_FLAG | VARCHAR2 | 1 | Oracle internal use only. | |
| BOOKING_DATE | DATE | Oracle internal use only. | ||
| VALUE_DATE | DATE | Oracle internal use only. | ||
| ACCNT_SERVICER_REF | VARCHAR2 | 50 | Oracle internal use only. | |
| COMM_WAIVER_IND_FLAG | VARCHAR2 | 1 | Oracle internal use only. | |
| ADDITIONAL_INFO_MSG_ID | NUMBER | 18 | Oracle internal use only. | |
| ADDENDA_TXT | VARCHAR2 | 1000 | Oracle internal use only. | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | |
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
| 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. | |
| TRX_CODE_ID | NUMBER | 18 | Oracle internal use only. | |
| TRX_TYPE | VARCHAR2 | 30 | Oracle internal use only. | |
| STATUS | VARCHAR2 | 30 | Oracle internal use only. | |
| AMOUNT | NUMBER | Oracle internal use only. | ||
| CURRENCY_CODE | VARCHAR2 | 30 | Oracle internal use only. | |
| TRX_AMOUNT | NUMBER | Oracle internal use only. | ||
| TRX_CURR_CODE | VARCHAR2 | 30 | Oracle internal use only. | |
| EXCHANGE_RATE | NUMBER | Oracle internal use only. | ||
| EXCHANGE_RATE_DATE | DATE | Oracle internal use only. | ||
| EXCHANGE_RATE_TYPE | VARCHAR2 | 30 | Oracle internal use only. | |
| CONTRACT_IDENTIFICATION | VARCHAR2 | 20 | Oracle internal use only. | |
| QUOTATION_DATE | DATE | Oracle internal use only. | ||
| ORIG_BANK_ACCOUNT_ID | VARCHAR2 | 50 | Oracle internal use only. | |
| TRX_TEXT | VARCHAR2 | 255 | Oracle internal use only. | |
| BANK_ACCOUNT_TEXT | VARCHAR2 | 30 | Oracle internal use only. | |
| CUSTOMER_TXT | VARCHAR2 | 255 | Oracle internal use only. | |
| ORIGINAL_AMOUNT | NUMBER | Oracle internal use only. | ||
| EXTERNAL_TRANSACTION_ID | NUMBER | 18 | Oracle internal use only. | |
| INSTRUCTION_IDENTIFICATION | VARCHAR2 | 100 | Oracle internal use only. | |
| END_TO_END_ID | VARCHAR2 | 100 | Oracle internal use only. | |
| TRANSACTION_ID | VARCHAR2 | 20 | Oracle internal use only. | |
| RECON_REFERENCE | VARCHAR2 | 50 | Oracle internal use only. | |
| CHECK_NUMBER | VARCHAR2 | 40 | Oracle internal use only. | |
| CLEARING_SYSTEM_REF | VARCHAR2 | 50 | Oracle internal use only. | |
| RECON_HISTORY_ID | NUMBER | 18 | Oracle internal use only. | |
| EXCEPTION_FLAG | VARCHAR2 | 1 | Oracle internal use only. | |
| RECON_STATUS | VARCHAR2 | 30 | Oracle internal use only. | |
| STRUCTURED_PAYMENT_REFERENCE | VARCHAR2 | 256 | Structured payment or receipt reference on bank statement line. Used for reconciliation. | |
| BANK_TRANSACTION_CODE | VARCHAR2 | 30 | The transaction code on the bank statement line. | |
| VALUE_DATE_STRING | VARCHAR2 | 30 | The statement line value date converted to a string. | |
| EXTERNAL_RECON_REFERENCE | VARCHAR2 | 50 | Oracle internal use only. Stores the external reconciliation reference stamped by user. | |
| 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. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CE_RECON_STMT_GT_U1 | Unique | STATEMENT_LINE_ID |