VIEW: AR.AR_CASH_RECEIPTS_ALL#

Source

View Text - Preformatted

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

View Text - HTML Formatted

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