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_INTRA_INT_T#

Source

View Text - Preformatted


select GROUP_ID GROUP_ID, LE_ID LE_ID, BAL_SEG_VAL BAL_SEG_VAL, ENTERED_CURRENCY_CODE ENTERED_CURRENCY_CODE, EXCHANGE_DATE EXCHANGE_DATE, EXCHANGE_RATE EXCHANGE_RATE, EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE, GL_DATE GL_DATE, DRIVING_DR_BSV DRIVING_DR_BSV, DRIVING_CR_BSV DRIVING_CR_BSV, INTRACOMPANY_MODE INTRACOMPANY_MODE, BALANCE_BY BALANCE_BY, CLEARING_BSV CLEARING_BSV, TEMPLATE_ID TEMPLATE_ID, CLEARING_OPTION CLEARING_OPTION, DR_CR_DEBIT_CCID DR_CR_DEBIT_CCID, DR_CR_CREDIT_CCID DR_CR_CREDIT_CCID, CR_DR_DEBIT_CCID CR_DR_DEBIT_CCID, CR_DR_CREDIT_CCID CR_DR_CREDIT_CCID, ACCOUNTED_AMT_CR ACCOUNTED_AMT_CR, ACCOUNTED_AMT_DR ACCOUNTED_AMT_DR, ENTERED_AMT_CR ENTERED_AMT_CR, ENTERED_AMT_DR ENTERED_AMT_DR, TYPE TYPE from "FUN"."FUN_BAL_INTRA_INT_T"

View Text - HTML Formatted

SELECT GROUP_ID GROUP_ID
, LE_ID LE_ID
, BAL_SEG_VAL BAL_SEG_VAL
, ENTERED_CURRENCY_CODE ENTERED_CURRENCY_CODE
, EXCHANGE_DATE EXCHANGE_DATE
, EXCHANGE_RATE EXCHANGE_RATE
, EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE
, GL_DATE GL_DATE
, DRIVING_DR_BSV DRIVING_DR_BSV
, DRIVING_CR_BSV DRIVING_CR_BSV
, INTRACOMPANY_MODE INTRACOMPANY_MODE
, BALANCE_BY BALANCE_BY
, CLEARING_BSV CLEARING_BSV
, TEMPLATE_ID TEMPLATE_ID
, CLEARING_OPTION CLEARING_OPTION
, DR_CR_DEBIT_CCID DR_CR_DEBIT_CCID
, DR_CR_CREDIT_CCID DR_CR_CREDIT_CCID
, CR_DR_DEBIT_CCID CR_DR_DEBIT_CCID
, CR_DR_CREDIT_CCID CR_DR_CREDIT_CCID
, ACCOUNTED_AMT_CR ACCOUNTED_AMT_CR
, ACCOUNTED_AMT_DR ACCOUNTED_AMT_DR
, ENTERED_AMT_CR ENTERED_AMT_CR
, ENTERED_AMT_DR ENTERED_AMT_DR
, TYPE TYPE
FROM "FUN"."FUN_BAL_INTRA_INT_T"