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_TA_VRH_MTRX_V

Product:	AR - Receivables
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT RH.BATCH_NAME
, RH.CHECK_NUMBER
, RH.CASH_RECEIPT_ID
, RH.HISTORY_LINE_ID
, RH.MATCHED_TRX_NUMBER
, RH.MATCHED_TRX_TYPE
, PS.DUE_DATE DUE_DATE
, PS.STATUS
, RH.APPLICATION_STATUS
, RH.AMOUNT
, RH.DISCOUNT_BASIS_USED
, RH.DISCOUNT_DATE_BASIS_USED
, RH.DISCOUNT_DATE_USED
, RH.UNEARNED_DISCOUNT
, RH.FULL_DISCOUNT_FLAG
, RH.DISCOUNT_GRACE_DAYS_USED
, NVL(RH.AMOUNT_APPLIED
, 0) AMOUNT_APPLIED
, NVL(RH.DISCOUNT_AMT
, 0) DISCOUNT_AMT
FROM AR_TA_REMIT_HIST RH
, AR_PAYMENT_SCHEDULES PS
WHERE PS.CUSTOMER_TRX_ID = RH.MATCHED_TRX_ID(+)
AND RH.CREATED_FROM = 'CASH_ENGINE'
AND RH.RECORD_TYPE=6

Columns

Name
BATCH_NAME
CHECK_NUMBER
CASH_RECEIPT_ID
HISTORY_LINE_ID
MATCHED_TRX_NUMBER
MATCHED_TRX_TYPE
DUE_DATE
STATUS
APPLICATION_STATUS
AMOUNT
DISCOUNT_BASIS_USED
DISCOUNT_DATE_BASIS_USED
DISCOUNT_DATE_USED
UNEARNED_DISCOUNT
FULL_DISCOUNT_FLAG
DISCOUNT_GRACE_DAYS_USED
AMOUNT_APPLIED
DISCOUNT_AMT