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

Source

View Text - Preformatted


select GROUP_ID GROUP_ID, LEDGER_ID LEDGER_ID, JE_SOURCE_NAME JE_SOURCE_NAME, JE_CATEGORY_NAME JE_CATEGORY_NAME, GL_DATE GL_DATE, CLEARING_BSV CLEARING_BSV, STATUS STATUS, INTERCOMPANY_MODE INTERCOMPANY_MODE, DRIVING_DR_LE_ID DRIVING_DR_LE_ID, DRIVING_CR_LE_ID DRIVING_CR_LE_ID, DRIVING_DR_LE_CURR_CODE DRIVING_DR_LE_CURR_CODE, DRIVING_CR_LE_CURR_CODE DRIVING_CR_LE_CURR_CODE, CHART_OF_ACCOUNTS_ID CHART_OF_ACCOUNTS_ID, BAL_SEG_COLUMN_NAME BAL_SEG_COLUMN_NAME, BAL_SEG_COLUMN_NUMBER BAL_SEG_COLUMN_NUMBER, INTERCOMPANY_COLUMN_NUMBER INTERCOMPANY_COLUMN_NUMBER, LE_ID LE_ID, LE_COUNT LE_COUNT, UNMAPPED_BSV_LE_ID UNMAPPED_BSV_LE_ID, ERROR_CODE ERROR_CODE from "FUN"."FUN_BAL_HEADERS_T"

View Text - HTML Formatted

SELECT GROUP_ID GROUP_ID
, LEDGER_ID LEDGER_ID
, JE_SOURCE_NAME JE_SOURCE_NAME
, JE_CATEGORY_NAME JE_CATEGORY_NAME
, GL_DATE GL_DATE
, CLEARING_BSV CLEARING_BSV
, STATUS STATUS
, INTERCOMPANY_MODE INTERCOMPANY_MODE
, DRIVING_DR_LE_ID DRIVING_DR_LE_ID
, DRIVING_CR_LE_ID DRIVING_CR_LE_ID
, DRIVING_DR_LE_CURR_CODE DRIVING_DR_LE_CURR_CODE
, DRIVING_CR_LE_CURR_CODE DRIVING_CR_LE_CURR_CODE
, CHART_OF_ACCOUNTS_ID CHART_OF_ACCOUNTS_ID
, BAL_SEG_COLUMN_NAME BAL_SEG_COLUMN_NAME
, BAL_SEG_COLUMN_NUMBER BAL_SEG_COLUMN_NUMBER
, INTERCOMPANY_COLUMN_NUMBER INTERCOMPANY_COLUMN_NUMBER
, LE_ID LE_ID
, LE_COUNT LE_COUNT
, UNMAPPED_BSV_LE_ID UNMAPPED_BSV_LE_ID
, ERROR_CODE ERROR_CODE
FROM "FUN"."FUN_BAL_HEADERS_T"