VIEW: AR.AR_CASH_REMIT_REFS_ALL#

Source

View Text - Preformatted

select REMIT_REFERENCE_ID REMIT_REFERENCE_ID, AUTOMATCH_SET_ID AUTOMATCH_SET_ID, CASH_RECEIPT_ID CASH_RECEIPT_ID, LINE_NUMBER LINE_NUMBER, REFERENCE_SOURCE REFERENCE_SOURCE, CUSTOMER_ID CUSTOMER_ID, CUSTOMER_NUMBER CUSTOMER_NUMBER, BANK_ACCOUNT_NUMBER BANK_ACCOUNT_NUMBER, TRANSIT_ROUTING_NUMBER TRANSIT_ROUTING_NUMBER, INVOICE_REFERENCE INVOICE_REFERENCE, MATCHING_REFERENCE_DATE MATCHING_REFERENCE_DATE, RESOLVED_MATCHING_NUMBER RESOLVED_MATCHING_NUMBER, RESOLVED_MATCHING_INSTALLMENT RESOLVED_MATCHING_INSTALLMENT, RESOLVED_MATCHING_DATE RESOLVED_MATCHING_DATE, INVOICE_CURRENCY_CODE INVOICE_CURRENCY_CODE, AMOUNT_APPLIED AMOUNT_APPLIED, AMOUNT_APPLIED_FROM AMOUNT_APPLIED_FROM, TRANS_TO_RECEIPT_RATE TRANS_TO_RECEIPT_RATE, INVOICE_STATUS INVOICE_STATUS, MATCH_RESOLVED_USING MATCH_RESOLVED_USING, ORG_ID ORG_ID, CUSTOMER_TRX_ID CUSTOMER_TRX_ID, PAYMENT_SCHEDULE_ID PAYMENT_SCHEDULE_ID, CUSTOMER_REFERENCE CUSTOMER_REFERENCE, AUTO_APPLIED AUTO_APPLIED, MANUALLY_APPLIED MANUALLY_APPLIED, INSTALLMENT_NUMBER INSTALLMENT_NUMBER, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, REQUEST_ID REQUEST_ID, RECEIPT_REFERENCE_STATUS RECEIPT_REFERENCE_STATUS, BATCH_ID BATCH_ID, TRANSMISSION_ID TRANSMISSION_ID, INSTALLMENT_REFERENCE INSTALLMENT_REFERENCE, MATCH_SCORE_VALUE MATCH_SCORE_VALUE from "AR"."AR_CASH_REMIT_REFS_ALL"

View Text - HTML Formatted

SELECT REMIT_REFERENCE_ID REMIT_REFERENCE_ID
, AUTOMATCH_SET_ID AUTOMATCH_SET_ID
, CASH_RECEIPT_ID CASH_RECEIPT_ID
, LINE_NUMBER LINE_NUMBER
, REFERENCE_SOURCE REFERENCE_SOURCE
, CUSTOMER_ID CUSTOMER_ID
, CUSTOMER_NUMBER CUSTOMER_NUMBER
, BANK_ACCOUNT_NUMBER BANK_ACCOUNT_NUMBER
, TRANSIT_ROUTING_NUMBER TRANSIT_ROUTING_NUMBER
, INVOICE_REFERENCE INVOICE_REFERENCE
, MATCHING_REFERENCE_DATE MATCHING_REFERENCE_DATE
, RESOLVED_MATCHING_NUMBER RESOLVED_MATCHING_NUMBER
, RESOLVED_MATCHING_INSTALLMENT RESOLVED_MATCHING_INSTALLMENT
, RESOLVED_MATCHING_DATE RESOLVED_MATCHING_DATE
, INVOICE_CURRENCY_CODE INVOICE_CURRENCY_CODE
, AMOUNT_APPLIED AMOUNT_APPLIED
, AMOUNT_APPLIED_FROM AMOUNT_APPLIED_FROM
, TRANS_TO_RECEIPT_RATE TRANS_TO_RECEIPT_RATE
, INVOICE_STATUS INVOICE_STATUS
, MATCH_RESOLVED_USING MATCH_RESOLVED_USING
, ORG_ID ORG_ID
, CUSTOMER_TRX_ID CUSTOMER_TRX_ID
, PAYMENT_SCHEDULE_ID PAYMENT_SCHEDULE_ID
, CUSTOMER_REFERENCE CUSTOMER_REFERENCE
, AUTO_APPLIED AUTO_APPLIED
, MANUALLY_APPLIED MANUALLY_APPLIED
, INSTALLMENT_NUMBER INSTALLMENT_NUMBER
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, REQUEST_ID REQUEST_ID
, RECEIPT_REFERENCE_STATUS RECEIPT_REFERENCE_STATUS
, BATCH_ID BATCH_ID
, TRANSMISSION_ID TRANSMISSION_ID
, INSTALLMENT_REFERENCE INSTALLMENT_REFERENCE
, MATCH_SCORE_VALUE MATCH_SCORE_VALUE
FROM "AR"."AR_CASH_REMIT_REFS_ALL"