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: AP.AP_MC_PAYMENT_HISTORY#

Source

View Text - Preformatted


select PAYMENT_HISTORY_ID PAYMENT_HISTORY_ID, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, PMT_TO_BASE_XRATE_TYPE PMT_TO_BASE_XRATE_TYPE, PMT_TO_BASE_XRATE_DATE PMT_TO_BASE_XRATE_DATE, PMT_TO_BASE_XRATE PMT_TO_BASE_XRATE, BANK_TO_BASE_XRATE_TYPE BANK_TO_BASE_XRATE_TYPE, BANK_TO_BASE_XRATE_DATE BANK_TO_BASE_XRATE_DATE, BANK_TO_BASE_XRATE BANK_TO_BASE_XRATE, TRX_BASE_AMOUNT TRX_BASE_AMOUNT, ERRORS_BASE_AMOUNT ERRORS_BASE_AMOUNT, CHARGES_BASE_AMOUNT CHARGES_BASE_AMOUNT from "AP"."AP_MC_PAYMENT_HISTORY"

View Text - HTML Formatted

SELECT PAYMENT_HISTORY_ID PAYMENT_HISTORY_ID
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, PMT_TO_BASE_XRATE_TYPE PMT_TO_BASE_XRATE_TYPE
, PMT_TO_BASE_XRATE_DATE PMT_TO_BASE_XRATE_DATE
, PMT_TO_BASE_XRATE PMT_TO_BASE_XRATE
, BANK_TO_BASE_XRATE_TYPE BANK_TO_BASE_XRATE_TYPE
, BANK_TO_BASE_XRATE_DATE BANK_TO_BASE_XRATE_DATE
, BANK_TO_BASE_XRATE BANK_TO_BASE_XRATE
, TRX_BASE_AMOUNT TRX_BASE_AMOUNT
, ERRORS_BASE_AMOUNT ERRORS_BASE_AMOUNT
, CHARGES_BASE_AMOUNT CHARGES_BASE_AMOUNT
FROM "AP"."AP_MC_PAYMENT_HISTORY"