CE_RECON_TXNSAGGR_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_MIN | DATE | Oracle internal use only. | ||
RECON_MATCH_DATE_MAX | 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. |