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: FV.FV_SF1219_TEMP#

Source

View Text - Preformatted


select TEMP_RECORD_ID TEMP_RECORD_ID, BATCH_ID BATCH_ID, FUND_CODE FUND_CODE, NAME NAME, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, GL_PERIOD GL_PERIOD, RECORD_TYPE RECORD_TYPE, LINES_EXIST LINES_EXIST, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, POSTED_DATE POSTED_DATE, REPORTED_GL_PERIOD REPORTED_GL_PERIOD, AMOUNT AMOUNT, SF1219_TYPE_CODE SF1219_TYPE_CODE, REFERENCE_1 REFERENCE_1, REFERENCE_2 REFERENCE_2, REFERENCE_3 REFERENCE_3, REFERENCE_4 REFERENCE_4, REFERENCE_5 REFERENCE_5, REFERENCE_6 REFERENCE_6, REPORTED_MONTH REPORTED_MONTH, DEFAULT_PERIOD_NAME DEFAULT_PERIOD_NAME, EXCEPTION_CATEGORY EXCEPTION_CATEGORY, ACCOMPLISH_MONTH ACCOMPLISH_MONTH, ACCOMPLISH_DATE ACCOMPLISH_DATE, OBLIGATION_DATE OBLIGATION_DATE, INTER_AGENCY_FLAG INTER_AGENCY_FLAG, TREASURY_SYMBOL TREASURY_SYMBOL, ALC_CODE ALC_CODE, ORG_ID ORG_ID, GROUP_NAME GROUP_NAME, UPDATE_TYPE UPDATE_TYPE, TYPE TYPE, GL_PERIOD_NAME GL_PERIOD_NAME, PROCESSED_FLAG PROCESSED_FLAG, TREASURY_SYMBOL_ID TREASURY_SYMBOL_ID, JE_HEADER_ID JE_HEADER_ID, JE_LINE_NUM JE_LINE_NUM, REFERENCE_9 REFERENCE_9, SUPPLEMENT_NUMBER SUPPLEMENT_NUMBER, JE_FROM_SLA_FLAG JE_FROM_SLA_FLAG from "FV"."FV_SF1219_TEMP"

View Text - HTML Formatted

SELECT TEMP_RECORD_ID TEMP_RECORD_ID
, BATCH_ID BATCH_ID
, FUND_CODE FUND_CODE
, NAME NAME
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, GL_PERIOD GL_PERIOD
, RECORD_TYPE RECORD_TYPE
, LINES_EXIST LINES_EXIST
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, POSTED_DATE POSTED_DATE
, REPORTED_GL_PERIOD REPORTED_GL_PERIOD
, AMOUNT AMOUNT
, SF1219_TYPE_CODE SF1219_TYPE_CODE
, REFERENCE_1 REFERENCE_1
, REFERENCE_2 REFERENCE_2
, REFERENCE_3 REFERENCE_3
, REFERENCE_4 REFERENCE_4
, REFERENCE_5 REFERENCE_5
, REFERENCE_6 REFERENCE_6
, REPORTED_MONTH REPORTED_MONTH
, DEFAULT_PERIOD_NAME DEFAULT_PERIOD_NAME
, EXCEPTION_CATEGORY EXCEPTION_CATEGORY
, ACCOMPLISH_MONTH ACCOMPLISH_MONTH
, ACCOMPLISH_DATE ACCOMPLISH_DATE
, OBLIGATION_DATE OBLIGATION_DATE
, INTER_AGENCY_FLAG INTER_AGENCY_FLAG
, TREASURY_SYMBOL TREASURY_SYMBOL
, ALC_CODE ALC_CODE
, ORG_ID ORG_ID
, GROUP_NAME GROUP_NAME
, UPDATE_TYPE UPDATE_TYPE
, TYPE TYPE
, GL_PERIOD_NAME GL_PERIOD_NAME
, PROCESSED_FLAG PROCESSED_FLAG
, TREASURY_SYMBOL_ID TREASURY_SYMBOL_ID
, JE_HEADER_ID JE_HEADER_ID
, JE_LINE_NUM JE_LINE_NUM
, REFERENCE_9 REFERENCE_9
, SUPPLEMENT_NUMBER SUPPLEMENT_NUMBER
, JE_FROM_SLA_FLAG JE_FROM_SLA_FLAG
FROM "FV"."FV_SF1219_TEMP"