VIEW: AR.AR_CREATE_RECEIPTS_ERROR#

Source

View Text - Preformatted

select BATCH_ID BATCH_ID, REQUEST_ID REQUEST_ID, CASH_RECEIPT_ID CASH_RECEIPT_ID, RECEIPT_NUMBER RECEIPT_NUMBER, RECEIPT_DATE RECEIPT_DATE, CUSTOMER_TRX_ID CUSTOMER_TRX_ID, TRXN_NUMBER TRXN_NUMBER, PAYMENT_SCHEDULE_ID PAYMENT_SCHEDULE_ID, APPLIED_PAYMENT_SCHEDULE_ID APPLIED_PAYMENT_SCHEDULE_ID, PAYING_CUSTOMER_ID PAYING_CUSTOMER_ID, PAYING_SITE_USE_ID PAYING_SITE_USE_ID, EXCEPTION_CODE EXCEPTION_CODE, ADDITIONAL_MESSAGE ADDITIONAL_MESSAGE, REMIT_BANK_ACCT_USE_ID REMIT_BANK_ACCT_USE_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY from "AR"."AR_CREATE_RECEIPTS_ERROR"

View Text - HTML Formatted

SELECT BATCH_ID BATCH_ID
, REQUEST_ID REQUEST_ID
, CASH_RECEIPT_ID CASH_RECEIPT_ID
, RECEIPT_NUMBER RECEIPT_NUMBER
, RECEIPT_DATE RECEIPT_DATE
, CUSTOMER_TRX_ID CUSTOMER_TRX_ID
, TRXN_NUMBER TRXN_NUMBER
, PAYMENT_SCHEDULE_ID PAYMENT_SCHEDULE_ID
, APPLIED_PAYMENT_SCHEDULE_ID APPLIED_PAYMENT_SCHEDULE_ID
, PAYING_CUSTOMER_ID PAYING_CUSTOMER_ID
, PAYING_SITE_USE_ID PAYING_SITE_USE_ID
, EXCEPTION_CODE EXCEPTION_CODE
, ADDITIONAL_MESSAGE ADDITIONAL_MESSAGE
, REMIT_BANK_ACCT_USE_ID REMIT_BANK_ACCT_USE_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
FROM "AR"."AR_CREATE_RECEIPTS_ERROR"