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: FUN.FUN_BAL_RESULTS_T#

Source

View Text - Preformatted


select GROUP_ID GROUP_ID, BAL_SEG_VAL BAL_SEG_VAL, ENTERED_AMT_DR ENTERED_AMT_DR, ENTERED_AMT_CR ENTERED_AMT_CR, ENTERED_CURRENCY_CODE ENTERED_CURRENCY_CODE, EXCHANGE_DATE EXCHANGE_DATE, EXCHANGE_RATE EXCHANGE_RATE, EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE, ACCOUNTED_AMT_DR ACCOUNTED_AMT_DR, ACCOUNTED_AMT_CR ACCOUNTED_AMT_CR, CCID CCID, JGZZ_RECON_STATUS JGZZ_RECON_STATUS, JGZZ_RECON_DATE JGZZ_RECON_DATE, JGZZ_RECON_ID JGZZ_RECON_ID, JGZZ_RECON_REF JGZZ_RECON_REF, JGZZ_RECON_CONTEXT JGZZ_RECON_CONTEXT, DR_BSV DR_BSV, CR_BSV CR_BSV, ACCT_TYPE ACCT_TYPE, TEMPLATE_ID TEMPLATE_ID, LE_ID LE_ID, BALANCING_TYPE BALANCING_TYPE from "FUN"."FUN_BAL_RESULTS_T"

View Text - HTML Formatted

SELECT GROUP_ID GROUP_ID
, BAL_SEG_VAL BAL_SEG_VAL
, ENTERED_AMT_DR ENTERED_AMT_DR
, ENTERED_AMT_CR ENTERED_AMT_CR
, ENTERED_CURRENCY_CODE ENTERED_CURRENCY_CODE
, EXCHANGE_DATE EXCHANGE_DATE
, EXCHANGE_RATE EXCHANGE_RATE
, EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE
, ACCOUNTED_AMT_DR ACCOUNTED_AMT_DR
, ACCOUNTED_AMT_CR ACCOUNTED_AMT_CR
, CCID CCID
, JGZZ_RECON_STATUS JGZZ_RECON_STATUS
, JGZZ_RECON_DATE JGZZ_RECON_DATE
, JGZZ_RECON_ID JGZZ_RECON_ID
, JGZZ_RECON_REF JGZZ_RECON_REF
, JGZZ_RECON_CONTEXT JGZZ_RECON_CONTEXT
, DR_BSV DR_BSV
, CR_BSV CR_BSV
, ACCT_TYPE ACCT_TYPE
, TEMPLATE_ID TEMPLATE_ID
, LE_ID LE_ID
, BALANCING_TYPE BALANCING_TYPE
FROM "FUN"."FUN_BAL_RESULTS_T"