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_NET_REVENUE_AMOUNT_OLD

Product:	AR - Receivables
Description:	Determine the uncredited amount on a transaction line
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT ORIG_CTL.CUSTOMER_TRX_LINE_ID /* CUSTOMER_TRX_LINE_ID */
, ORIG_CTL.CUSTOMER_TRX_ID
, SUM( DECODE(CT.COMPLETE_FLAG
, 'N'
, 0
, CTL.EXTENDED_AMOUNT ) ) /* NET_AMOUNT */
, ORIG_CTL.LINE_TYPE
FROM RA_CUSTOMER_TRX_LINES CTL
, RA_CUSTOMER_TRX CT
, RA_CUSTOMER_TRX_LINES ORIG_CTL
WHERE ( CTL.CUSTOMER_TRX_LINE_ID = ORIG_CTL.CUSTOMER_TRX_LINE_ID OR CTL.PREVIOUS_CUSTOMER_TRX_LINE_ID = ORIG_CTL.CUSTOMER_TRX_LINE_ID )
AND CTL.CUSTOMER_TRX_ID = CT.CUSTOMER_TRX_ID GROUP BY ORIG_CTL.CUSTOMER_TRX_LINE_ID
, ORIG_CTL.CUSTOMER_TRX_ID
, ORIG_CTL.LINE_TYPE

Columns

Name
CUSTOMER_TRX_LINE_ID
CUSTOMER_TRX_ID
NET_AMOUNT
LINE_TYPE