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: GL.GL_RX_TRIAL_BALANCE_ITF#

Source

View Text - Preformatted


select REQUEST_ID REQUEST_ID, PERIOD_NAME PERIOD_NAME, LEDGER_ID LEDGER_ID, LEDGER_NAME LEDGER_NAME, CHART_OF_ACCOUNTS_ID CHART_OF_ACCOUNTS_ID, CURRENCY_CODE CURRENCY_CODE, BALANCING_SEGMENT BALANCING_SEGMENT, ACCOUNT_SEGMENT ACCOUNT_SEGMENT, BALANCING_DESCRIPTION BALANCING_DESCRIPTION, ACCOUNT_DESCRIPTION ACCOUNT_DESCRIPTION, SUMMARY_FLAG SUMMARY_FLAG, BEGIN_YEAR_BALANCE_DR BEGIN_YEAR_BALANCE_DR, BEGIN_YEAR_BALANCE_CR BEGIN_YEAR_BALANCE_CR, BEGIN_ADJ_PERIOD_NET_DR BEGIN_ADJ_PERIOD_NET_DR, BEGIN_ADJ_PERIOD_NET_CR BEGIN_ADJ_PERIOD_NET_CR, PRIOR_PERIODS_NET_DR PRIOR_PERIODS_NET_DR, PRIOR_PERIODS_NET_CR PRIOR_PERIODS_NET_CR, BEGIN_PERIOD_BALANCE_DR BEGIN_PERIOD_BALANCE_DR, BEGIN_PERIOD_BALANCE_CR BEGIN_PERIOD_BALANCE_CR, PERIOD_NET_DR PERIOD_NET_DR, PERIOD_NET_CR PERIOD_NET_CR, YEAR_TO_DATE_BALANCE_DR YEAR_TO_DATE_BALANCE_DR, YEAR_TO_DATE_BALANCE_CR YEAR_TO_DATE_BALANCE_CR, YEAR_TO_DATE_NET_DIFFERENCE_DR YEAR_TO_DATE_NET_DIFFERENCE_DR, YEAR_TO_DATE_NET_DIFFERENCE_CR YEAR_TO_DATE_NET_DIFFERENCE_CR from "GL"."GL_RX_TRIAL_BALANCE_ITF"

View Text - HTML Formatted

SELECT REQUEST_ID REQUEST_ID
, PERIOD_NAME PERIOD_NAME
, LEDGER_ID LEDGER_ID
, LEDGER_NAME LEDGER_NAME
, CHART_OF_ACCOUNTS_ID CHART_OF_ACCOUNTS_ID
, CURRENCY_CODE CURRENCY_CODE
, BALANCING_SEGMENT BALANCING_SEGMENT
, ACCOUNT_SEGMENT ACCOUNT_SEGMENT
, BALANCING_DESCRIPTION BALANCING_DESCRIPTION
, ACCOUNT_DESCRIPTION ACCOUNT_DESCRIPTION
, SUMMARY_FLAG SUMMARY_FLAG
, BEGIN_YEAR_BALANCE_DR BEGIN_YEAR_BALANCE_DR
, BEGIN_YEAR_BALANCE_CR BEGIN_YEAR_BALANCE_CR
, BEGIN_ADJ_PERIOD_NET_DR BEGIN_ADJ_PERIOD_NET_DR
, BEGIN_ADJ_PERIOD_NET_CR BEGIN_ADJ_PERIOD_NET_CR
, PRIOR_PERIODS_NET_DR PRIOR_PERIODS_NET_DR
, PRIOR_PERIODS_NET_CR PRIOR_PERIODS_NET_CR
, BEGIN_PERIOD_BALANCE_DR BEGIN_PERIOD_BALANCE_DR
, BEGIN_PERIOD_BALANCE_CR BEGIN_PERIOD_BALANCE_CR
, PERIOD_NET_DR PERIOD_NET_DR
, PERIOD_NET_CR PERIOD_NET_CR
, YEAR_TO_DATE_BALANCE_DR YEAR_TO_DATE_BALANCE_DR
, YEAR_TO_DATE_BALANCE_CR YEAR_TO_DATE_BALANCE_CR
, YEAR_TO_DATE_NET_DIFFERENCE_DR YEAR_TO_DATE_NET_DIFFERENCE_DR
, YEAR_TO_DATE_NET_DIFFERENCE_CR YEAR_TO_DATE_NET_DIFFERENCE_CR
FROM "GL"."GL_RX_TRIAL_BALANCE_ITF"