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.

[Home] [Help]

VIEW: AR.AR_TRX_SUMMARY_HIST#

Source

View Text - Preformatted


select HISTORY_ID HISTORY_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CUSTOMER_TRX_ID CUSTOMER_TRX_ID, CASH_RECEIPT_ID CASH_RECEIPT_ID, PAYMENT_SCHEDULE_ID PAYMENT_SCHEDULE_ID, PREVIOUS_HISTORY_ID PREVIOUS_HISTORY_ID, DUE_DATE DUE_DATE, AMOUNT_IN_DISPUTE AMOUNT_IN_DISPUTE, AMOUNT_DUE_ORIGINAL AMOUNT_DUE_ORIGINAL, AMOUNT_ADJUSTED AMOUNT_ADJUSTED, COMPLETE_FLAG COMPLETE_FLAG, CUSTOMER_ID CUSTOMER_ID, SITE_USE_ID SITE_USE_ID, AMOUNT_DUE_REMAINING AMOUNT_DUE_REMAINING, CURRENCY_CODE CURRENCY_CODE, TRX_DATE TRX_DATE, EVENT_NAME EVENT_NAME, INSTALLMENTS INSTALLMENTS from "AR"."AR_TRX_SUMMARY_HIST"

View Text - HTML Formatted

SELECT HISTORY_ID HISTORY_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CUSTOMER_TRX_ID CUSTOMER_TRX_ID
, CASH_RECEIPT_ID CASH_RECEIPT_ID
, PAYMENT_SCHEDULE_ID PAYMENT_SCHEDULE_ID
, PREVIOUS_HISTORY_ID PREVIOUS_HISTORY_ID
, DUE_DATE DUE_DATE
, AMOUNT_IN_DISPUTE AMOUNT_IN_DISPUTE
, AMOUNT_DUE_ORIGINAL AMOUNT_DUE_ORIGINAL
, AMOUNT_ADJUSTED AMOUNT_ADJUSTED
, COMPLETE_FLAG COMPLETE_FLAG
, CUSTOMER_ID CUSTOMER_ID
, SITE_USE_ID SITE_USE_ID
, AMOUNT_DUE_REMAINING AMOUNT_DUE_REMAINING
, CURRENCY_CODE CURRENCY_CODE
, TRX_DATE TRX_DATE
, EVENT_NAME EVENT_NAME
, INSTALLMENTS INSTALLMENTS
FROM "AR"."AR_TRX_SUMMARY_HIST"