CE_AVAILABLE_TRANSACTIONS

Details

Schema: FUSION
Object owner: CE
Object type: VIEW

Columns

Name
TRANSACTION_SOURCE TRANSACTION_ID BANK_ACCOUNT_ID BA_CURRENCY_CODE TRX_CURRENCY_CODE RECON_MATCH_REFERENCE STRUCTURED_PAYMENT_REFERENCE RECON_MATCH_AMOUNT RECON_MATCH_EXCHANGE_RATE RECON_MATCH_DATE RECON_MATCH_TYPE TRX_SUBTYPE TRX_DATE TRX_AMOUNT TRANSACTION_NUMBER CLEARED_DATE PAY_RECEIPT_METHOD RECEIPT_CLASS_NAME STATUS CPARTY_NAME CPARTY_SITE CPARTY_BANK_ACCOUNT_ID PAYMENT_INSTRUCTION_ID PAYMENT_REFERENCE_ID PAYMENT_LOGICAL_GROUP_ID END_TO_END_IDENTIFIER BATCH_NAME RECEIPT_BATCH_NAME BANK_DEPOSIT_NUMBER BUSINESS_UNIT_ID LEGAL_ENTITY_ID RECON_FLAG RECON_HISTORY_ID EXTERNAL_TRX_SOURCE TRX_EXCHANGE_RATE TRX_EXCHANGE_RATE_TYPE TRX_EXCHANGE_DATE ACCOUNTING_FLAG JOURNAL_BATCH_NAME JOURNAL_NAME TRX_LINE_ID JOURNAL_BATCH_ID PAYMENT_FILE_REFERENCE PAYMENT_PROCESS_REQUEST_NAME ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE15 LOGICAL_GROUP_REFERENCE PAYMENT_SERVER_ORDER_NUMBER UNIQUE_REMITTANCE_IDENTIFIER JOURNAL_LINE_DESCRIPTION

Name

TRANSACTION_SOURCE

TRANSACTION_ID

BANK_ACCOUNT_ID

BA_CURRENCY_CODE

TRX_CURRENCY_CODE

RECON_MATCH_REFERENCE

STRUCTURED_PAYMENT_REFERENCE

RECON_MATCH_AMOUNT

RECON_MATCH_EXCHANGE_RATE

RECON_MATCH_DATE

RECON_MATCH_TYPE

TRX_SUBTYPE

TRX_DATE

TRX_AMOUNT

TRANSACTION_NUMBER

CLEARED_DATE

PAY_RECEIPT_METHOD

RECEIPT_CLASS_NAME

STATUS

CPARTY_NAME

CPARTY_SITE

CPARTY_BANK_ACCOUNT_ID

PAYMENT_INSTRUCTION_ID

PAYMENT_REFERENCE_ID

PAYMENT_LOGICAL_GROUP_ID

END_TO_END_IDENTIFIER

BATCH_NAME

RECEIPT_BATCH_NAME

BANK_DEPOSIT_NUMBER

BUSINESS_UNIT_ID

LEGAL_ENTITY_ID

RECON_FLAG

RECON_HISTORY_ID

EXTERNAL_TRX_SOURCE

TRX_EXCHANGE_RATE

TRX_EXCHANGE_RATE_TYPE

TRX_EXCHANGE_DATE

ACCOUNTING_FLAG

JOURNAL_BATCH_NAME

JOURNAL_NAME

TRX_LINE_ID

JOURNAL_BATCH_ID

PAYMENT_FILE_REFERENCE

PAYMENT_PROCESS_REQUEST_NAME

ATTRIBUTE_CATEGORY

ATTRIBUTE1

ATTRIBUTE2

ATTRIBUTE3

ATTRIBUTE4

ATTRIBUTE5

ATTRIBUTE6

ATTRIBUTE7

ATTRIBUTE8

ATTRIBUTE9

ATTRIBUTE10

ATTRIBUTE11

ATTRIBUTE12

ATTRIBUTE13

ATTRIBUTE14

ATTRIBUTE15

GLOBAL_ATTRIBUTE_CATEGORY

GLOBAL_ATTRIBUTE1

GLOBAL_ATTRIBUTE2

GLOBAL_ATTRIBUTE3

GLOBAL_ATTRIBUTE4

GLOBAL_ATTRIBUTE5

GLOBAL_ATTRIBUTE6

GLOBAL_ATTRIBUTE7

GLOBAL_ATTRIBUTE8

GLOBAL_ATTRIBUTE9

GLOBAL_ATTRIBUTE10

GLOBAL_ATTRIBUTE11

GLOBAL_ATTRIBUTE12

GLOBAL_ATTRIBUTE13

GLOBAL_ATTRIBUTE14

GLOBAL_ATTRIBUTE15

LOGICAL_GROUP_REFERENCE

PAYMENT_SERVER_ORDER_NUMBER

UNIQUE_REMITTANCE_IDENTIFIER

JOURNAL_LINE_DESCRIPTION

Query

SQL_Statement
SELECT "TRANSACTION_SOURCE","TRANSACTION_ID","BANK_ACCOUNT_ID","BA_CURRENCY_CODE","TRX_CURRENCY_CODE","RECON_MATCH_REFERENCE",NULL as "STRUCTURED_PAYMENT_REFERENCE","RECON_MATCH_AMOUNT","RECON_MATCH_EXCHANGE_RATE","RECON_MATCH_DATE","RECON_MATCH_TYPE","TRX_SUBTYPE","TRX_DATE","TRX_AMOUNT","TRANSACTION_NUMBER","CLEARED_DATE","PAY_RECEIPT_METHOD","RECEIPT_CLASS_NAME","STATUS","CPARTY_NAME","CPARTY_SITE","CPARTY_BANK_ACCOUNT_ID","PAYMENT_INSTRUCTION_ID","PAYMENT_REFERENCE_ID","PAYMENT_LOGICAL_GROUP_ID",NULL AS "END_TO_END_IDENTIFIER","BATCH_NAME","RECEIPT_BATCH_NAME","BANK_DEPOSIT_NUMBER","BUSINESS_UNIT_ID","LEGAL_ENTITY_ID","RECON_FLAG","RECON_HISTORY_ID","EXTERNAL_TRX_SOURCE","TRX_EXCHANGE_RATE","TRX_EXCHANGE_RATE_TYPE","TRX_EXCHANGE_DATE","ACCOUNTING_FLAG","JOURNAL_BATCH_NAME","JOURNAL_NAME","TRX_LINE_ID","JOURNAL_BATCH_ID",NULL AS "PAYMENT_FILE_REFERENCE",NULL AS "PAYMENT_PROCESS_REQUEST_NAME","ATTRIBUTE_CATEGORY","ATTRIBUTE1","ATTRIBUTE2","ATTRIBUTE3","ATTRIBUTE4","ATTRIBUTE5","ATTRIBUTE6","ATTRIBUTE7","ATTRIBUTE8","ATTRIBUTE9","ATTRIBUTE10","ATTRIBUTE11","ATTRIBUTE12","ATTRIBUTE13","ATTRIBUTE14","ATTRIBUTE15","GLOBAL_ATTRIBUTE_CATEGORY","GLOBAL_ATTRIBUTE1","GLOBAL_ATTRIBUTE2","GLOBAL_ATTRIBUTE3","GLOBAL_ATTRIBUTE4","GLOBAL_ATTRIBUTE5","GLOBAL_ATTRIBUTE6","GLOBAL_ATTRIBUTE7","GLOBAL_ATTRIBUTE8","GLOBAL_ATTRIBUTE9","GLOBAL_ATTRIBUTE10","GLOBAL_ATTRIBUTE11","GLOBAL_ATTRIBUTE12","GLOBAL_ATTRIBUTE13","GLOBAL_ATTRIBUTE14","GLOBAL_ATTRIBUTE15" ,NULL AS "LOGICAL_GROUP_REFERENCE", NULL AS "PAYMENT_SERVER_ORDER_NUMBER", NULL AS "UNIQUE_REMITTANCE_IDENTIFIER","JOURNAL_LINE_DESCRIPTION" FROM CE_GL_AVAILABLE_TRX_V UNION ALL SELECT "TRANSACTION_SOURCE","TRANSACTION_ID","BANK_ACCOUNT_ID","BA_CURRENCY_CODE","TRX_CURRENCY_CODE","RECON_MATCH_REFERENCE",NULL as "STRUCTURED_PAYMENT_REFERENCE","RECON_MATCH_AMOUNT","RECON_MATCH_EXCHANGE_RATE","RECON_MATCH_DATE","RECON_MATCH_TYPE","TRX_SUBTYPE","TRX_DATE","TRX_AMOUNT","TRANSACTION_NUMBER","CLEARED_DATE","PAY_RECEIPT_METHOD","RECEIPT_CLASS_NAME","STATUS","CPARTY_NAME","CPARTY_SITE","CPARTY_BANK_ACCOUNT_ID","PAYMENT_INSTRUCTION_ID","PAYMENT_REFERENCE_ID","PAYMENT_LOGICAL_GROUP_ID",NULL AS "END_TO_END_IDENTIFIER","BATCH_NAME","RECEIPT_BATCH_NAME","BANK_DEPOSIT_NUMBER","BUSINESS_UNIT_ID","LEGAL_ENTITY_ID","RECON_FLAG","RECON_HISTORY_ID","EXTERNAL_TRX_SOURCE","TRX_EXCHANGE_RATE","TRX_EXCHANGE_RATE_TYPE","TRX_EXCHANGE_DATE","ACCOUNTING_FLAG",NULL AS "JOURNAL_BATCH_NAME",NULL AS "JOURNAL_NAME",NULL AS "TRX_LINE_ID",NULL AS "JOURNAL_BATCH_ID",NULL AS "PAYMENT_FILE_REFERENCE",NULL AS "PAYMENT_PROCESS_REQUEST_NAME","ATTRIBUTE_CATEGORY","ATTRIBUTE1","ATTRIBUTE2","ATTRIBUTE3","ATTRIBUTE4","ATTRIBUTE5","ATTRIBUTE6","ATTRIBUTE7","ATTRIBUTE8","ATTRIBUTE9","ATTRIBUTE10","ATTRIBUTE11","ATTRIBUTE12","ATTRIBUTE13","ATTRIBUTE14","ATTRIBUTE15","GLOBAL_ATTRIBUTE_CATEGORY","GLOBAL_ATTRIBUTE1","GLOBAL_ATTRIBUTE2","GLOBAL_ATTRIBUTE3","GLOBAL_ATTRIBUTE4","GLOBAL_ATTRIBUTE5","GLOBAL_ATTRIBUTE6","GLOBAL_ATTRIBUTE7","GLOBAL_ATTRIBUTE8","GLOBAL_ATTRIBUTE9","GLOBAL_ATTRIBUTE10","GLOBAL_ATTRIBUTE11","GLOBAL_ATTRIBUTE12","GLOBAL_ATTRIBUTE13","GLOBAL_ATTRIBUTE14","GLOBAL_ATTRIBUTE15" ,NULL AS "LOGICAL_GROUP_REFERENCE", NULL AS "PAYMENT_SERVER_ORDER_NUMBER", NULL AS "UNIQUE_REMITTANCE_IDENTIFIER", NULL AS "JOURNAL_LINE_DESCRIPTION" FROM CE_XT_AVAILABLE_TRX_V UNION ALL SELECT "TRANSACTION_SOURCE","TRANSACTION_ID","BANK_ACCOUNT_ID","BA_CURRENCY_CODE","TRX_CURRENCY_CODE","RECON_MATCH_REFERENCE",NULL as "STRUCTURED_PAYMENT_REFERENCE","RECON_MATCH_AMOUNT","RECON_MATCH_EXCHANGE_RATE","RECON_MATCH_DATE","RECON_MATCH_TYPE","TRX_SUBTYPE","TRX_DATE","TRX_AMOUNT","TRANSACTION_NUMBER","CLEARED_DATE","PAY_RECEIPT_METHOD","RECEIPT_CLASS_NAME","STATUS","CPARTY_NAME","CPARTY_SITE","CPARTY_BANK_ACCOUNT_ID","PAYMENT_INSTRUCTION_ID","PAYMENT_REFERENCE_ID","PAYMENT_LOGICAL_GROUP_ID",NULL AS "END_TO_END_IDENTIFIER","BATCH_NAME","RECEIPT_BATCH_NAME","BANK_DEPOSIT_NUMBER","BUSINESS_UNIT_ID","LEGAL_ENTITY_ID","RECON_FLAG","RECON_HISTORY_ID","EXTERNAL_TRX_SOURCE","TRX_EXCHANGE_RATE","TRX_EXCHANGE_RATE_TYPE","TRX_EXCHANGE_DATE","ACCOUNTING_FLAG",NULL AS "JOURNAL_BATCH_NAME",NULL AS "JOURNAL_NAME",NULL AS "TRX_LINE_ID",NULL AS "JOURNAL_BATCH_ID",NULL AS "PAYMENT_FILE_REFERENCE",NULL AS "PAYMENT_PROCESS_REQUEST_NAME","ATTRIBUTE_CATEGORY","ATTRIBUTE1","ATTRIBUTE2","ATTRIBUTE3","ATTRIBUTE4","ATTRIBUTE5","ATTRIBUTE6","ATTRIBUTE7","ATTRIBUTE8","ATTRIBUTE9","ATTRIBUTE10","ATTRIBUTE11","ATTRIBUTE12","ATTRIBUTE13","ATTRIBUTE14","ATTRIBUTE15","GLOBAL_ATTRIBUTE_CATEGORY","GLOBAL_ATTRIBUTE1","GLOBAL_ATTRIBUTE2","GLOBAL_ATTRIBUTE3","GLOBAL_ATTRIBUTE4","GLOBAL_ATTRIBUTE5","GLOBAL_ATTRIBUTE6","GLOBAL_ATTRIBUTE7","GLOBAL_ATTRIBUTE8","GLOBAL_ATTRIBUTE9","GLOBAL_ATTRIBUTE10","GLOBAL_ATTRIBUTE11","GLOBAL_ATTRIBUTE12","GLOBAL_ATTRIBUTE13","GLOBAL_ATTRIBUTE14","GLOBAL_ATTRIBUTE15" ,NULL AS "LOGICAL_GROUP_REFERENCE", NULL AS "PAYMENT_SERVER_ORDER_NUMBER", NULL AS "UNIQUE_REMITTANCE_IDENTIFIER", NULL AS "JOURNAL_LINE_DESCRIPTION" FROM CE_PR_AVAILABLE_TRX_V UNION ALL SELECT "TRANSACTION_SOURCE","TRANSACTION_ID","BANK_ACCOUNT_ID","BA_CURRENCY_CODE","TRX_CURRENCY_CODE","RECON_MATCH_REFERENCE",NULL as "STRUCTURED_PAYMENT_REFERENCE","RECON_MATCH_AMOUNT","RECON_MATCH_EXCHANGE_RATE","RECON_MATCH_DATE","RECON_MATCH_TYPE","TRX_SUBTYPE","TRX_DATE","TRX_AMOUNT","TRANSACTION_NUMBER","CLEARED_DATE","PAY_RECEIPT_METHOD","RECEIPT_CLASS_NAME","STATUS","CPARTY_NAME","CPARTY_SITE","CPARTY_BANK_ACCOUNT_ID","PAYMENT_INSTRUCTION_ID","PAYMENT_REFERENCE_ID","PAYMENT_LOGICAL_GROUP_ID","END_TO_END_IDENTIFIER","BATCH_NAME","RECEIPT_BATCH_NAME","BANK_DEPOSIT_NUMBER","BUSINESS_UNIT_ID","LEGAL_ENTITY_ID","RECON_FLAG","RECON_HISTORY_ID","EXTERNAL_TRX_SOURCE","TRX_EXCHANGE_RATE","TRX_EXCHANGE_RATE_TYPE","TRX_EXCHANGE_DATE","ACCOUNTING_FLAG",NULL AS "JOURNAL_BATCH_NAME",NULL AS "JOURNAL_NAME",NULL AS "TRX_LINE_ID",NULL AS "JOURNAL_BATCH_ID","PAYMENT_FILE_REFERENCE","PAYMENT_PROCESS_REQUEST_NAME","ATTRIBUTE_CATEGORY","ATTRIBUTE1","ATTRIBUTE2","ATTRIBUTE3","ATTRIBUTE4","ATTRIBUTE5","ATTRIBUTE6","ATTRIBUTE7","ATTRIBUTE8","ATTRIBUTE9","ATTRIBUTE10","ATTRIBUTE11","ATTRIBUTE12","ATTRIBUTE13","ATTRIBUTE14","ATTRIBUTE15","GLOBAL_ATTRIBUTE_CATEGORY","GLOBAL_ATTRIBUTE1","GLOBAL_ATTRIBUTE2","GLOBAL_ATTRIBUTE3","GLOBAL_ATTRIBUTE4","GLOBAL_ATTRIBUTE5","GLOBAL_ATTRIBUTE6","GLOBAL_ATTRIBUTE7","GLOBAL_ATTRIBUTE8","GLOBAL_ATTRIBUTE9","GLOBAL_ATTRIBUTE10","GLOBAL_ATTRIBUTE11","GLOBAL_ATTRIBUTE12","GLOBAL_ATTRIBUTE13","GLOBAL_ATTRIBUTE14","GLOBAL_ATTRIBUTE15" ,"LOGICAL_GROUP_REFERENCE", NULL AS "PAYMENT_SERVER_ORDER_NUMBER","UNIQUE_REMITTANCE_IDENTIFIER", NULL AS "JOURNAL_LINE_DESCRIPTION" FROM CE_AP_AVAILABLE_TRX_V UNION ALL SELECT "TRANSACTION_SOURCE","TRANSACTION_ID","BANK_ACCOUNT_ID","BA_CURRENCY_CODE","TRX_CURRENCY_CODE","RECON_MATCH_REFERENCE","STRUCTURED_PAYMENT_REFERENCE","RECON_MATCH_AMOUNT","RECON_MATCH_EXCHANGE_RATE","RECON_MATCH_DATE","RECON_MATCH_TYPE","TRX_SUBTYPE","TRX_DATE","TRX_AMOUNT","TRANSACTION_NUMBER","CLEARED_DATE","PAY_RECEIPT_METHOD","RECEIPT_CLASS_NAME","STATUS","CPARTY_NAME","CPARTY_SITE","CPARTY_BANK_ACCOUNT_ID","PAYMENT_INSTRUCTION_ID","PAYMENT_REFERENCE_ID","PAYMENT_LOGICAL_GROUP_ID",NULL AS "END_TO_END_IDENTIFIER","BATCH_NAME","RECEIPT_BATCH_NAME","BANK_DEPOSIT_NUMBER","BUSINESS_UNIT_ID","LEGAL_ENTITY_ID","RECON_FLAG","RECON_HISTORY_ID","EXTERNAL_TRX_SOURCE","TRX_EXCHANGE_RATE","TRX_EXCHANGE_RATE_TYPE","TRX_EXCHANGE_DATE","ACCOUNTING_FLAG",NULL AS "JOURNAL_BATCH_NAME",NULL AS "JOURNAL_NAME",NULL AS "TRX_LINE_ID",NULL AS "JOURNAL_BATCH_ID",NULL AS "PAYMENT_FILE_REFERENCE",NULL AS "PAYMENT_PROCESS_REQUEST_NAME","ATTRIBUTE_CATEGORY","ATTRIBUTE1","ATTRIBUTE2","ATTRIBUTE3","ATTRIBUTE4","ATTRIBUTE5","ATTRIBUTE6","ATTRIBUTE7","ATTRIBUTE8","ATTRIBUTE9","ATTRIBUTE10","ATTRIBUTE11","ATTRIBUTE12","ATTRIBUTE13","ATTRIBUTE14","ATTRIBUTE15","GLOBAL_ATTRIBUTE_CATEGORY","GLOBAL_ATTRIBUTE1","GLOBAL_ATTRIBUTE2","GLOBAL_ATTRIBUTE3","GLOBAL_ATTRIBUTE4","GLOBAL_ATTRIBUTE5","GLOBAL_ATTRIBUTE6","GLOBAL_ATTRIBUTE7","GLOBAL_ATTRIBUTE8","GLOBAL_ATTRIBUTE9","GLOBAL_ATTRIBUTE10","GLOBAL_ATTRIBUTE11","GLOBAL_ATTRIBUTE12","GLOBAL_ATTRIBUTE13","GLOBAL_ATTRIBUTE14","GLOBAL_ATTRIBUTE15" ,"LOGICAL_GROUP_REFERENCE","PAYMENT_SERVER_ORDER_NUMBER", NULL AS "UNIQUE_REMITTANCE_IDENTIFIER", NULL AS "JOURNAL_LINE_DESCRIPTION" FROM CE_AR_AVAILABLE_TRX_V

SQL_Statement

SELECT "TRANSACTION_SOURCE","TRANSACTION_ID","BANK_ACCOUNT_ID","BA_CURRENCY_CODE","TRX_CURRENCY_CODE","RECON_MATCH_REFERENCE",NULL as "STRUCTURED_PAYMENT_REFERENCE","RECON_MATCH_AMOUNT","RECON_MATCH_EXCHANGE_RATE","RECON_MATCH_DATE","RECON_MATCH_TYPE","TRX_SUBTYPE","TRX_DATE","TRX_AMOUNT","TRANSACTION_NUMBER","CLEARED_DATE","PAY_RECEIPT_METHOD","RECEIPT_CLASS_NAME","STATUS","CPARTY_NAME","CPARTY_SITE","CPARTY_BANK_ACCOUNT_ID","PAYMENT_INSTRUCTION_ID","PAYMENT_REFERENCE_ID","PAYMENT_LOGICAL_GROUP_ID",NULL AS "END_TO_END_IDENTIFIER","BATCH_NAME","RECEIPT_BATCH_NAME","BANK_DEPOSIT_NUMBER","BUSINESS_UNIT_ID","LEGAL_ENTITY_ID","RECON_FLAG","RECON_HISTORY_ID","EXTERNAL_TRX_SOURCE","TRX_EXCHANGE_RATE","TRX_EXCHANGE_RATE_TYPE","TRX_EXCHANGE_DATE","ACCOUNTING_FLAG","JOURNAL_BATCH_NAME","JOURNAL_NAME","TRX_LINE_ID","JOURNAL_BATCH_ID",NULL AS "PAYMENT_FILE_REFERENCE",NULL AS "PAYMENT_PROCESS_REQUEST_NAME","ATTRIBUTE_CATEGORY","ATTRIBUTE1","ATTRIBUTE2","ATTRIBUTE3","ATTRIBUTE4","ATTRIBUTE5","ATTRIBUTE6","ATTRIBUTE7","ATTRIBUTE8","ATTRIBUTE9","ATTRIBUTE10","ATTRIBUTE11","ATTRIBUTE12","ATTRIBUTE13","ATTRIBUTE14","ATTRIBUTE15","GLOBAL_ATTRIBUTE_CATEGORY","GLOBAL_ATTRIBUTE1","GLOBAL_ATTRIBUTE2","GLOBAL_ATTRIBUTE3","GLOBAL_ATTRIBUTE4","GLOBAL_ATTRIBUTE5","GLOBAL_ATTRIBUTE6","GLOBAL_ATTRIBUTE7","GLOBAL_ATTRIBUTE8","GLOBAL_ATTRIBUTE9","GLOBAL_ATTRIBUTE10","GLOBAL_ATTRIBUTE11","GLOBAL_ATTRIBUTE12","GLOBAL_ATTRIBUTE13","GLOBAL_ATTRIBUTE14","GLOBAL_ATTRIBUTE15"

,NULL AS "LOGICAL_GROUP_REFERENCE", NULL AS "PAYMENT_SERVER_ORDER_NUMBER", NULL AS "UNIQUE_REMITTANCE_IDENTIFIER","JOURNAL_LINE_DESCRIPTION"

FROM CE_GL_AVAILABLE_TRX_V

UNION ALL

SELECT "TRANSACTION_SOURCE","TRANSACTION_ID","BANK_ACCOUNT_ID","BA_CURRENCY_CODE","TRX_CURRENCY_CODE","RECON_MATCH_REFERENCE",NULL as "STRUCTURED_PAYMENT_REFERENCE","RECON_MATCH_AMOUNT","RECON_MATCH_EXCHANGE_RATE","RECON_MATCH_DATE","RECON_MATCH_TYPE","TRX_SUBTYPE","TRX_DATE","TRX_AMOUNT","TRANSACTION_NUMBER","CLEARED_DATE","PAY_RECEIPT_METHOD","RECEIPT_CLASS_NAME","STATUS","CPARTY_NAME","CPARTY_SITE","CPARTY_BANK_ACCOUNT_ID","PAYMENT_INSTRUCTION_ID","PAYMENT_REFERENCE_ID","PAYMENT_LOGICAL_GROUP_ID",NULL AS "END_TO_END_IDENTIFIER","BATCH_NAME","RECEIPT_BATCH_NAME","BANK_DEPOSIT_NUMBER","BUSINESS_UNIT_ID","LEGAL_ENTITY_ID","RECON_FLAG","RECON_HISTORY_ID","EXTERNAL_TRX_SOURCE","TRX_EXCHANGE_RATE","TRX_EXCHANGE_RATE_TYPE","TRX_EXCHANGE_DATE","ACCOUNTING_FLAG",NULL AS "JOURNAL_BATCH_NAME",NULL AS "JOURNAL_NAME",NULL AS "TRX_LINE_ID",NULL AS "JOURNAL_BATCH_ID",NULL AS "PAYMENT_FILE_REFERENCE",NULL AS "PAYMENT_PROCESS_REQUEST_NAME","ATTRIBUTE_CATEGORY","ATTRIBUTE1","ATTRIBUTE2","ATTRIBUTE3","ATTRIBUTE4","ATTRIBUTE5","ATTRIBUTE6","ATTRIBUTE7","ATTRIBUTE8","ATTRIBUTE9","ATTRIBUTE10","ATTRIBUTE11","ATTRIBUTE12","ATTRIBUTE13","ATTRIBUTE14","ATTRIBUTE15","GLOBAL_ATTRIBUTE_CATEGORY","GLOBAL_ATTRIBUTE1","GLOBAL_ATTRIBUTE2","GLOBAL_ATTRIBUTE3","GLOBAL_ATTRIBUTE4","GLOBAL_ATTRIBUTE5","GLOBAL_ATTRIBUTE6","GLOBAL_ATTRIBUTE7","GLOBAL_ATTRIBUTE8","GLOBAL_ATTRIBUTE9","GLOBAL_ATTRIBUTE10","GLOBAL_ATTRIBUTE11","GLOBAL_ATTRIBUTE12","GLOBAL_ATTRIBUTE13","GLOBAL_ATTRIBUTE14","GLOBAL_ATTRIBUTE15"

,NULL AS "LOGICAL_GROUP_REFERENCE", NULL AS "PAYMENT_SERVER_ORDER_NUMBER", NULL AS "UNIQUE_REMITTANCE_IDENTIFIER", NULL AS "JOURNAL_LINE_DESCRIPTION"

FROM CE_XT_AVAILABLE_TRX_V

UNION ALL

SELECT "TRANSACTION_SOURCE","TRANSACTION_ID","BANK_ACCOUNT_ID","BA_CURRENCY_CODE","TRX_CURRENCY_CODE","RECON_MATCH_REFERENCE",NULL as "STRUCTURED_PAYMENT_REFERENCE","RECON_MATCH_AMOUNT","RECON_MATCH_EXCHANGE_RATE","RECON_MATCH_DATE","RECON_MATCH_TYPE","TRX_SUBTYPE","TRX_DATE","TRX_AMOUNT","TRANSACTION_NUMBER","CLEARED_DATE","PAY_RECEIPT_METHOD","RECEIPT_CLASS_NAME","STATUS","CPARTY_NAME","CPARTY_SITE","CPARTY_BANK_ACCOUNT_ID","PAYMENT_INSTRUCTION_ID","PAYMENT_REFERENCE_ID","PAYMENT_LOGICAL_GROUP_ID",NULL AS "END_TO_END_IDENTIFIER","BATCH_NAME","RECEIPT_BATCH_NAME","BANK_DEPOSIT_NUMBER","BUSINESS_UNIT_ID","LEGAL_ENTITY_ID","RECON_FLAG","RECON_HISTORY_ID","EXTERNAL_TRX_SOURCE","TRX_EXCHANGE_RATE","TRX_EXCHANGE_RATE_TYPE","TRX_EXCHANGE_DATE","ACCOUNTING_FLAG",NULL AS "JOURNAL_BATCH_NAME",NULL AS "JOURNAL_NAME",NULL AS "TRX_LINE_ID",NULL AS "JOURNAL_BATCH_ID",NULL AS "PAYMENT_FILE_REFERENCE",NULL AS "PAYMENT_PROCESS_REQUEST_NAME","ATTRIBUTE_CATEGORY","ATTRIBUTE1","ATTRIBUTE2","ATTRIBUTE3","ATTRIBUTE4","ATTRIBUTE5","ATTRIBUTE6","ATTRIBUTE7","ATTRIBUTE8","ATTRIBUTE9","ATTRIBUTE10","ATTRIBUTE11","ATTRIBUTE12","ATTRIBUTE13","ATTRIBUTE14","ATTRIBUTE15","GLOBAL_ATTRIBUTE_CATEGORY","GLOBAL_ATTRIBUTE1","GLOBAL_ATTRIBUTE2","GLOBAL_ATTRIBUTE3","GLOBAL_ATTRIBUTE4","GLOBAL_ATTRIBUTE5","GLOBAL_ATTRIBUTE6","GLOBAL_ATTRIBUTE7","GLOBAL_ATTRIBUTE8","GLOBAL_ATTRIBUTE9","GLOBAL_ATTRIBUTE10","GLOBAL_ATTRIBUTE11","GLOBAL_ATTRIBUTE12","GLOBAL_ATTRIBUTE13","GLOBAL_ATTRIBUTE14","GLOBAL_ATTRIBUTE15"

,NULL AS "LOGICAL_GROUP_REFERENCE", NULL AS "PAYMENT_SERVER_ORDER_NUMBER", NULL AS "UNIQUE_REMITTANCE_IDENTIFIER", NULL AS "JOURNAL_LINE_DESCRIPTION"

FROM CE_PR_AVAILABLE_TRX_V

UNION ALL

SELECT "TRANSACTION_SOURCE","TRANSACTION_ID","BANK_ACCOUNT_ID","BA_CURRENCY_CODE","TRX_CURRENCY_CODE","RECON_MATCH_REFERENCE",NULL as "STRUCTURED_PAYMENT_REFERENCE","RECON_MATCH_AMOUNT","RECON_MATCH_EXCHANGE_RATE","RECON_MATCH_DATE","RECON_MATCH_TYPE","TRX_SUBTYPE","TRX_DATE","TRX_AMOUNT","TRANSACTION_NUMBER","CLEARED_DATE","PAY_RECEIPT_METHOD","RECEIPT_CLASS_NAME","STATUS","CPARTY_NAME","CPARTY_SITE","CPARTY_BANK_ACCOUNT_ID","PAYMENT_INSTRUCTION_ID","PAYMENT_REFERENCE_ID","PAYMENT_LOGICAL_GROUP_ID","END_TO_END_IDENTIFIER","BATCH_NAME","RECEIPT_BATCH_NAME","BANK_DEPOSIT_NUMBER","BUSINESS_UNIT_ID","LEGAL_ENTITY_ID","RECON_FLAG","RECON_HISTORY_ID","EXTERNAL_TRX_SOURCE","TRX_EXCHANGE_RATE","TRX_EXCHANGE_RATE_TYPE","TRX_EXCHANGE_DATE","ACCOUNTING_FLAG",NULL AS "JOURNAL_BATCH_NAME",NULL AS "JOURNAL_NAME",NULL AS "TRX_LINE_ID",NULL AS "JOURNAL_BATCH_ID","PAYMENT_FILE_REFERENCE","PAYMENT_PROCESS_REQUEST_NAME","ATTRIBUTE_CATEGORY","ATTRIBUTE1","ATTRIBUTE2","ATTRIBUTE3","ATTRIBUTE4","ATTRIBUTE5","ATTRIBUTE6","ATTRIBUTE7","ATTRIBUTE8","ATTRIBUTE9","ATTRIBUTE10","ATTRIBUTE11","ATTRIBUTE12","ATTRIBUTE13","ATTRIBUTE14","ATTRIBUTE15","GLOBAL_ATTRIBUTE_CATEGORY","GLOBAL_ATTRIBUTE1","GLOBAL_ATTRIBUTE2","GLOBAL_ATTRIBUTE3","GLOBAL_ATTRIBUTE4","GLOBAL_ATTRIBUTE5","GLOBAL_ATTRIBUTE6","GLOBAL_ATTRIBUTE7","GLOBAL_ATTRIBUTE8","GLOBAL_ATTRIBUTE9","GLOBAL_ATTRIBUTE10","GLOBAL_ATTRIBUTE11","GLOBAL_ATTRIBUTE12","GLOBAL_ATTRIBUTE13","GLOBAL_ATTRIBUTE14","GLOBAL_ATTRIBUTE15"

,"LOGICAL_GROUP_REFERENCE", NULL AS "PAYMENT_SERVER_ORDER_NUMBER","UNIQUE_REMITTANCE_IDENTIFIER", NULL AS "JOURNAL_LINE_DESCRIPTION"

FROM CE_AP_AVAILABLE_TRX_V

UNION ALL

SELECT "TRANSACTION_SOURCE","TRANSACTION_ID","BANK_ACCOUNT_ID","BA_CURRENCY_CODE","TRX_CURRENCY_CODE","RECON_MATCH_REFERENCE","STRUCTURED_PAYMENT_REFERENCE","RECON_MATCH_AMOUNT","RECON_MATCH_EXCHANGE_RATE","RECON_MATCH_DATE","RECON_MATCH_TYPE","TRX_SUBTYPE","TRX_DATE","TRX_AMOUNT","TRANSACTION_NUMBER","CLEARED_DATE","PAY_RECEIPT_METHOD","RECEIPT_CLASS_NAME","STATUS","CPARTY_NAME","CPARTY_SITE","CPARTY_BANK_ACCOUNT_ID","PAYMENT_INSTRUCTION_ID","PAYMENT_REFERENCE_ID","PAYMENT_LOGICAL_GROUP_ID",NULL AS "END_TO_END_IDENTIFIER","BATCH_NAME","RECEIPT_BATCH_NAME","BANK_DEPOSIT_NUMBER","BUSINESS_UNIT_ID","LEGAL_ENTITY_ID","RECON_FLAG","RECON_HISTORY_ID","EXTERNAL_TRX_SOURCE","TRX_EXCHANGE_RATE","TRX_EXCHANGE_RATE_TYPE","TRX_EXCHANGE_DATE","ACCOUNTING_FLAG",NULL AS "JOURNAL_BATCH_NAME",NULL AS "JOURNAL_NAME",NULL AS "TRX_LINE_ID",NULL AS "JOURNAL_BATCH_ID",NULL AS "PAYMENT_FILE_REFERENCE",NULL AS "PAYMENT_PROCESS_REQUEST_NAME","ATTRIBUTE_CATEGORY","ATTRIBUTE1","ATTRIBUTE2","ATTRIBUTE3","ATTRIBUTE4","ATTRIBUTE5","ATTRIBUTE6","ATTRIBUTE7","ATTRIBUTE8","ATTRIBUTE9","ATTRIBUTE10","ATTRIBUTE11","ATTRIBUTE12","ATTRIBUTE13","ATTRIBUTE14","ATTRIBUTE15","GLOBAL_ATTRIBUTE_CATEGORY","GLOBAL_ATTRIBUTE1","GLOBAL_ATTRIBUTE2","GLOBAL_ATTRIBUTE3","GLOBAL_ATTRIBUTE4","GLOBAL_ATTRIBUTE5","GLOBAL_ATTRIBUTE6","GLOBAL_ATTRIBUTE7","GLOBAL_ATTRIBUTE8","GLOBAL_ATTRIBUTE9","GLOBAL_ATTRIBUTE10","GLOBAL_ATTRIBUTE11","GLOBAL_ATTRIBUTE12","GLOBAL_ATTRIBUTE13","GLOBAL_ATTRIBUTE14","GLOBAL_ATTRIBUTE15"

,"LOGICAL_GROUP_REFERENCE","PAYMENT_SERVER_ORDER_NUMBER", NULL AS "UNIQUE_REMITTANCE_IDENTIFIER", NULL AS "JOURNAL_LINE_DESCRIPTION"

FROM CE_AR_AVAILABLE_TRX_V