CE_RECON_TXNS_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 |
|---|---|---|---|---|
| BANK_ACCOUNT_ID | NUMBER | 18 | Oracle internal use only. | |
| TRANSACTION_SOURCE | VARCHAR2 | 30 | Oracle internal use only. | |
| TRANSACTION_ID | NUMBER | 18 | Oracle internal use only. | |
| RECON_MATCH_AMOUNT | NUMBER | Oracle internal use only. | ||
| RECON_MATCH_DATE | DATE | Oracle internal use only. | ||
| RECON_MATCH_REFERENCE | VARCHAR2 | 240 | Reconciliation reference of a system transaction. | |
| RECON_MATCH_TYPE | VARCHAR2 | 30 | Oracle internal use only. | |
| TRX_SUBTYPE | NUMBER | 18 | Oracle internal use only. | |
| TRX_CURRENCY_CODE | VARCHAR2 | 15 | Oracle internal use only. | |
| TRX_AMOUNT | NUMBER | Oracle internal use only. | ||
| TRANSACTION_NUMBER | VARCHAR2 | 240 | Oracle internal use only. | |
| TRX_DATE | DATE | Oracle internal use only. | ||
| CLEARED_DATE | DATE | Oracle internal use only. | ||
| BANK_DEPOSIT_NUMBER | VARCHAR2 | 30 | Oracle internal use only. | |
| BATCH_NAME | VARCHAR2 | 255 | Oracle internal use only. | |
| RECEIPT_BATCH_NAME | VARCHAR2 | 50 | Oracle internal use only. | |
| PAYMENT_REFERENCE_ID | NUMBER | 18 | Oracle internal use only. | |
| PAYMENT_LOGICAL_GROUP_ID | NUMBER | 18 | Oracle internal use only. | |
| PAYMENT_INSTRUCTION_ID | NUMBER | 18 | Oracle internal use only. | |
| LEGAL_ENTITY_ID | NUMBER | 18 | Oracle internal use only. | |
| BUSINESS_UNIT_ID | NUMBER | 18 | Oracle internal use only. | |
| CPARTY_BANK_ACCOUNT_ID | NUMBER | 18 | Oracle internal use only. | |
| CPARTY_NAME | VARCHAR2 | 360 | Oracle internal use only. | |
| CPARTY_SITE | VARCHAR2 | 15 | Oracle internal use only. | |
| RECON_FLAG | VARCHAR2 | 1 | Oracle internal use only. | |
| RECON_HISTORY_ID | NUMBER | 18 | Oracle internal use only. | |
| PAY_RECEIPT_METHOD | VARCHAR2 | 30 | Oracle internal use only. | |
| RECEIPT_CLASS_NAME | VARCHAR2 | 30 | Oracle internal use only. | |
| STATUS | VARCHAR2 | 30 | Oracle internal use only. | |
| RECON_MATCH_EXCHANGE_RATE | NUMBER | Oracle internal use only. | ||
| TRX_EXCHANGE_DATE | DATE | Oracle internal use only. | ||
| TRX_EXCHANGE_RATE_TYPE | VARCHAR2 | 30 | 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. | |
| GLOBAL_ATTRIBUTE16 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |
| GLOBAL_ATTRIBUTE17 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |
| GLOBAL_ATTRIBUTE18 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |
| GLOBAL_ATTRIBUTE19 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |
| GLOBAL_ATTRIBUTE20 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |
| ACCOUNTING_FLAG | VARCHAR2 | 1 | Oracle internal use only. | |
| TRX_LINE_ID | NUMBER | 18 | Oracle internal use only. | |
| JOURNAL_BATCH_NAME | VARCHAR2 | 100 | Oracle internal use only. | |
| JOURNAL_NAME | VARCHAR2 | 100 | Oracle internal use only. | |
| PAYMENT_PROCESS_REQUEST_NAME | VARCHAR2 | 255 | Name of payment batch denormalized from IBY_PAY_SERVICE_REQUESTS.CALL_APP_PAY_SERVICE_REQ_CODE and derived through PAYMENT_SERVICE_REQUEST_ID. | |
| PAYMENT_FILE_REFERENCE | VARCHAR2 | 30 | Identifier of payment file generated for given payment. | |
| STRUCTURED_PAYMENT_REFERENCE | VARCHAR2 | 256 | Structured payment or receipt reference on system transaction. Used for reconciliation. | |
| LOGICAL_GROUP_REFERENCE | VARCHAR2 | 30 | Indicates the logical group reference for the payments or receipts. | |
| PAYMENT_SERVER_ORDER_NUMBER | VARCHAR2 | 80 | Identifies credit card payment authorized by the Oracle Payment Server. | |
| UNIQUE_REMITTANCE_IDENTIFIER | VARCHAR2 | 256 | Industry standard reference on payment or receipts used to uniquely identify the transactions in the bank statements. | |
| JOURNAL_LINE_DESCRIPTION | VARCHAR2 | 240 | The journal entry line description. | |
| EXTERNAL_RECON_REFERENCE | VARCHAR2 | 50 | Oracle internal use only. Stores the external reconciliation reference stamped by user. | |
| END_TO_END_IDENTIFIER | VARCHAR2 | 100 | Oracle internal use only. Unique identification assigned by the initiating party to unumbiguously identify the transaction. It is passed on unchanged, throughout the entire end to end chain. |