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.
Skip to content
[Home] [Help]
Home › ETRM 12.2.2 › GL - General Ledger › GL_LOOKUPS_AVG_AMOUNT_TYPES_V View: GL_LOOKUPS_AVG_AMOUNT_TYPES_V
View Text
SELECT L.LOOKUP_CODE AMOUNT_TYPE , L.MEANING SHOW_AMOUNT_TYPE , L.DESCRIPTION DESCRIPTION FROM GL_LOOKUPS L WHERE L.LOOKUP_TYPE = 'PATD_EOD' OR L.LOOKUP_TYPE = 'PTD_YTD'
Columns
Name
AMOUNT_TYPE
SHOW_AMOUNT_TYPE
DESCRIPTION