IEX_PAYMENTS_V

Details

• Schema: FUSION

• Object owner: IEX

• Object type: VIEW

Columns

Name

CASH_RECEIPT_ID LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN CREATED_BY CREATION_DATE AMOUNT SET_OF_BOOKS_ID CURRENCY_CODE RECEIVABLES_TRX_ID PAY_FROM_CUSTOMER STATUS TYPE RECEIPT_NUMBER RECEIPT_DATE MISC_PAYMENT_SOURCE COMMENTS DISTRIBUTION_SET_ID REVERSAL_DATE REVERSAL_CATEGORY REVERSAL_REASON_CODE REVERSAL_COMMENTS EXCHANGE_RATE_TYPE EXCHANGE_RATE EXCHANGE_DATE ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 REMITTANCE_BANK_ACCOUNT_ID ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 CONFIRMED_FLAG CUSTOMER_BANK_ACCOUNT_ID CUSTOMER_SITE_USE_ID DEPOSIT_DATE PROGRAM_APPLICATION_ID PROGRAM_ID PROGRAM_UPDATE_DATE RECEIPT_METHOD_ID REQUEST_ID SELECTED_FOR_FACTORING_FLAG SELECTED_REMITTANCE_BATCH_ID FACTOR_DISCOUNT_AMOUNT USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE_CONTEXT DOC_SEQUENCE_VALUE DOC_SEQUENCE_ID VAT_TAX_ID REFERENCE_TYPE REFERENCE_ID CUSTOMER_RECEIPT_REFERENCE OVERRIDE_REMIT_ACCOUNT_FLAG ORG_ID ANTICIPATED_CLEARING_DATE 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 GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE_CATEGORY ISSUER_NAME ISSUE_DATE ISSUER_BANK_BRANCH_ID CUSTOMER_BANK_BRANCH_ID PAYMENT_SERVER_ORDER_NUM APPROVAL_CODE ADDRESS_VERIFICATION_CODE TAX_RATE ACTUAL_VALUE_DATE POSTMARK_DATE APPLICATION_NOTES UNIQUE_REFERENCE PROMISE_SOURCE REC_VERSION_NUMBER CC_ERROR_CODE CC_ERROR_TEXT CC_ERROR_FLAG REMIT_BANK_ACCT_USE_ID OLD_CUSTOMER_BANK_BRANCH_ID OLD_ISSUER_BANK_BRANCH_ID LEGAL_ENTITY_ID PAYMENT_TRXN_EXTENSION_ID AX_ACCOUNTED_FLAG OLD_CUSTOMER_BANK_ACCOUNT_ID OBJECT_VERSION_NUMBER

Query

SQL_Statement

SELECT CR.CASH_RECEIPT_ID , CR.LAST_UPDATED_BY , CR.LAST_UPDATE_DATE , CR.LAST_UPDATE_LOGIN , CR.CREATED_BY , CR.CREATION_DATE , CR.AMOUNT , CR.SET_OF_BOOKS_ID , CR.CURRENCY_CODE , CR.RECEIVABLES_TRX_ID , CR.PAY_FROM_CUSTOMER , CR.STATUS , CR.TYPE , CR.RECEIPT_NUMBER , CR.RECEIPT_DATE , CR.MISC_PAYMENT_SOURCE , CR.COMMENTS , CR.DISTRIBUTION_SET_ID , CR.REVERSAL_DATE , CR.REVERSAL_CATEGORY , CR.REVERSAL_REASON_CODE , CR.REVERSAL_COMMENTS , CR.EXCHANGE_RATE_TYPE , CR.EXCHANGE_RATE , CR.EXCHANGE_DATE , CR.ATTRIBUTE_CATEGORY , CR.ATTRIBUTE1 , CR.ATTRIBUTE2 , CR.ATTRIBUTE3 , CR.ATTRIBUTE4 , CR.ATTRIBUTE5 , CR.ATTRIBUTE6 , CR.ATTRIBUTE7 , CR.ATTRIBUTE8 , CR.ATTRIBUTE9 , CR.ATTRIBUTE10 , CR.REMITTANCE_BANK_ACCOUNT_ID , CR.ATTRIBUTE11 , CR.ATTRIBUTE12 , CR.ATTRIBUTE13 , CR.ATTRIBUTE14 , CR.ATTRIBUTE15 , CR.CONFIRMED_FLAG , CR.CUSTOMER_BANK_ACCOUNT_ID , CR.CUSTOMER_SITE_USE_ID , CR.DEPOSIT_DATE , CR.PROGRAM_APPLICATION_ID , CR.PROGRAM_ID , CR.PROGRAM_UPDATE_DATE , CR.RECEIPT_METHOD_ID , CR.REQUEST_ID , CR.SELECTED_FOR_FACTORING_FLAG , CR.SELECTED_REMITTANCE_BATCH_ID , CR.FACTOR_DISCOUNT_AMOUNT , CR.USSGL_TRANSACTION_CODE , CR.USSGL_TRANSACTION_CODE_CONTEXT , CR.DOC_SEQUENCE_VALUE , CR.DOC_SEQUENCE_ID , CR.VAT_TAX_ID , CR.REFERENCE_TYPE , CR.REFERENCE_ID , CR.CUSTOMER_RECEIPT_REFERENCE , CR.OVERRIDE_REMIT_ACCOUNT_FLAG , CR.ORG_ID , CR.ANTICIPATED_CLEARING_DATE , CR.GLOBAL_ATTRIBUTE1 , CR.GLOBAL_ATTRIBUTE2 , CR.GLOBAL_ATTRIBUTE3 , CR.GLOBAL_ATTRIBUTE4 , CR.GLOBAL_ATTRIBUTE5 , CR.GLOBAL_ATTRIBUTE6 , CR.GLOBAL_ATTRIBUTE7 , CR.GLOBAL_ATTRIBUTE8 , CR.GLOBAL_ATTRIBUTE9 , CR.GLOBAL_ATTRIBUTE10 , CR.GLOBAL_ATTRIBUTE11 , CR.GLOBAL_ATTRIBUTE12 , CR.GLOBAL_ATTRIBUTE13 , CR.GLOBAL_ATTRIBUTE14 , CR.GLOBAL_ATTRIBUTE15 , CR.GLOBAL_ATTRIBUTE16 , CR.GLOBAL_ATTRIBUTE17 , CR.GLOBAL_ATTRIBUTE18 , CR.GLOBAL_ATTRIBUTE19 , CR.GLOBAL_ATTRIBUTE20 , CR.GLOBAL_ATTRIBUTE_CATEGORY , CR.ISSUER_NAME , CR.ISSUE_DATE , CR.ISSUER_BANK_BRANCH_ID , CR.CUSTOMER_BANK_BRANCH_ID , CR.PAYMENT_SERVER_ORDER_NUM , CR.APPROVAL_CODE , CR.ADDRESS_VERIFICATION_CODE , CR.TAX_RATE , CR.ACTUAL_VALUE_DATE , CR.POSTMARK_DATE , CR.APPLICATION_NOTES , CR.UNIQUE_REFERENCE , CR.PROMISE_SOURCE , CR.REC_VERSION_NUMBER , CR.CC_ERROR_CODE , CR.CC_ERROR_TEXT , CR.CC_ERROR_FLAG , CR.REMIT_BANK_ACCT_USE_ID , CR.OLD_CUSTOMER_BANK_BRANCH_ID , CR.OLD_ISSUER_BANK_BRANCH_ID , CR.LEGAL_ENTITY_ID , CR.PAYMENT_TRXN_EXTENSION_ID , CR.AX_ACCOUNTED_FLAG , CR.OLD_CUSTOMER_BANK_ACCOUNT_ID , CR.OBJECT_VERSION_NUMBER FROM AR_CASH_RECEIPTS_ALL CR