eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: AR.AR_CASH_RECOS_ALL#

Source

View Text - Preformatted


select RECOMMENDATION_ID RECOMMENDATION_ID, REMIT_REFERENCE_ID REMIT_REFERENCE_ID, PAY_FROM_CUSTOMER PAY_FROM_CUSTOMER, RESOLVED_MATCHING_NUMBER RESOLVED_MATCHING_NUMBER, RESOLVED_MATCHING_DATE RESOLVED_MATCHING_DATE, RESOLVED_MATCHING_CLASS RESOLVED_MATCHING_CLASS, RESOLVED_MATCH_CURRENCY RESOLVED_MATCH_CURRENCY, RESOLVED_TRX_AMOUNT RESOLVED_TRX_AMOUNT, RESOLVED_TRX_AMOUNT_REM RESOLVED_TRX_AMOUNT_REM, MATCH_RESOLVED_USING MATCH_RESOLVED_USING, MATCH_SCORE_VALUE MATCH_SCORE_VALUE, MATCH_REASON_CODE MATCH_REASON_CODE, RECOMMENDATION_STATUS RECOMMENDATION_STATUS, RECOMMENDATION_REASON RECOMMENDATION_REASON, ORG_ID ORG_ID, 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, AUTOMATCH_ID AUTOMATCH_ID, PRIORITY PRIORITY, AUTOAPPLY_STATUS AUTOAPPLY_STATUS, CUSTOMER_SITE_USE_ID CUSTOMER_SITE_USE_ID, RECOMMENDATION_SOURCE RECOMMENDATION_SOURCE, RECOMMENDATION_TYPE RECOMMENDATION_TYPE, CONS_INV_ID CONS_INV_ID from "AR"."AR_CASH_RECOS_ALL"

View Text - HTML Formatted

SELECT RECOMMENDATION_ID RECOMMENDATION_ID
, REMIT_REFERENCE_ID REMIT_REFERENCE_ID
, PAY_FROM_CUSTOMER PAY_FROM_CUSTOMER
, RESOLVED_MATCHING_NUMBER RESOLVED_MATCHING_NUMBER
, RESOLVED_MATCHING_DATE RESOLVED_MATCHING_DATE
, RESOLVED_MATCHING_CLASS RESOLVED_MATCHING_CLASS
, RESOLVED_MATCH_CURRENCY RESOLVED_MATCH_CURRENCY
, RESOLVED_TRX_AMOUNT RESOLVED_TRX_AMOUNT
, RESOLVED_TRX_AMOUNT_REM RESOLVED_TRX_AMOUNT_REM
, MATCH_RESOLVED_USING MATCH_RESOLVED_USING
, MATCH_SCORE_VALUE MATCH_SCORE_VALUE
, MATCH_REASON_CODE MATCH_REASON_CODE
, RECOMMENDATION_STATUS RECOMMENDATION_STATUS
, RECOMMENDATION_REASON RECOMMENDATION_REASON
, ORG_ID ORG_ID
, 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
, AUTOMATCH_ID AUTOMATCH_ID
, PRIORITY PRIORITY
, AUTOAPPLY_STATUS AUTOAPPLY_STATUS
, CUSTOMER_SITE_USE_ID CUSTOMER_SITE_USE_ID
, RECOMMENDATION_SOURCE RECOMMENDATION_SOURCE
, RECOMMENDATION_TYPE RECOMMENDATION_TYPE
, CONS_INV_ID CONS_INV_ID
FROM "AR"."AR_CASH_RECOS_ALL"