VIEW: FV.FV_SF224_TEMP#

Source

View Text - Preformatted

select JE_BATCH_ID JE_BATCH_ID, FUND_CODE FUND_CODE, FUND_DESCRIPTION FUND_DESCRIPTION, NAME NAME, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, POSTED_DATE POSTED_DATE, GL_PERIOD GL_PERIOD, DEFAULT_PERIOD_NAME DEFAULT_PERIOD_NAME, AMOUNT AMOUNT, SF224_TYPE_CODE SF224_TYPE_CODE, D_R_FLAG D_R_FLAG, ACCOMPLISH_DATE ACCOMPLISH_DATE, REPORTED_MONTH REPORTED_MONTH, REFERENCE_1 REFERENCE_1, REFERENCE_2 REFERENCE_2, EXCEPTION_CATEGORY EXCEPTION_CATEGORY, COLUMN_GROUP COLUMN_GROUP, INTER_AGENCY_FLAG INTER_AGENCY_FLAG, RECORD_TYPE RECORD_TYPE, OBLIGATION_DATE OBLIGATION_DATE, EXTERNAL_REFERENCE EXTERNAL_REFERENCE, TREASURY_SYMBOL TREASURY_SYMBOL, REFERENCE_3 REFERENCE_3, SUPPLEMENTAL_FLAG SUPPLEMENTAL_FLAG, REFERENCE_4 REFERENCE_4, REPORTED_GL_PERIOD REPORTED_GL_PERIOD, ALC_CODE ALC_CODE, ORG_ID ORG_ID, REFERENCE_5 REFERENCE_5, REFERENCE_6 REFERENCE_6, REPORTED_FLAG REPORTED_FLAG, EXCEPTION_EXISTS EXCEPTION_EXISTS, RECORD_CATEGORY RECORD_CATEGORY, JE_LINE_NUM JE_LINE_NUM, JE_HEADER_ID JE_HEADER_ID, SF224_PROCESSED_FLAG SF224_PROCESSED_FLAG, DEF_ORG_ID DEF_ORG_ID, PROCESSED_FLAG PROCESSED_FLAG, REFERENCE_9 REFERENCE_9, PROCESS_ID PROCESS_ID, TREASURY_SYMBOL_ID TREASURY_SYMBOL_ID, FEDERAL_RPT_ID FEDERAL_RPT_ID, JE_SOURCE JE_SOURCE, JE_CATEGORY JE_CATEGORY, DOCUMENT_NUMBER DOCUMENT_NUMBER, REFERENCE_8 REFERENCE_8, EXCEPTION_SECTION EXCEPTION_SECTION, START_PERIOD_DATE START_PERIOD_DATE, END_PERIOD_DATE END_PERIOD_DATE, UPDATE_TYPE UPDATE_TYPE, TXN_CATEGORY TXN_CATEGORY, SIGN_NUMBER SIGN_NUMBER, ACTUAL_AMOUNT ACTUAL_AMOUNT, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_REQUEST_ID CREATED_REQUEST_ID, UPDATED_REQUEST_ID UPDATED_REQUEST_ID, GL_DATE GL_DATE, RECLASS RECLASS, ACCOUNT ACCOUNT, JE_FROM_SLA_FLAG JE_FROM_SLA_FLAG from "FV"."FV_SF224_TEMP"

View Text - HTML Formatted

SELECT JE_BATCH_ID JE_BATCH_ID
, FUND_CODE FUND_CODE
, FUND_DESCRIPTION FUND_DESCRIPTION
, NAME NAME
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, POSTED_DATE POSTED_DATE
, GL_PERIOD GL_PERIOD
, DEFAULT_PERIOD_NAME DEFAULT_PERIOD_NAME
, AMOUNT AMOUNT
, SF224_TYPE_CODE SF224_TYPE_CODE
, D_R_FLAG D_R_FLAG
, ACCOMPLISH_DATE ACCOMPLISH_DATE
, REPORTED_MONTH REPORTED_MONTH
, REFERENCE_1 REFERENCE_1
, REFERENCE_2 REFERENCE_2
, EXCEPTION_CATEGORY EXCEPTION_CATEGORY
, COLUMN_GROUP COLUMN_GROUP
, INTER_AGENCY_FLAG INTER_AGENCY_FLAG
, RECORD_TYPE RECORD_TYPE
, OBLIGATION_DATE OBLIGATION_DATE
, EXTERNAL_REFERENCE EXTERNAL_REFERENCE
, TREASURY_SYMBOL TREASURY_SYMBOL
, REFERENCE_3 REFERENCE_3
, SUPPLEMENTAL_FLAG SUPPLEMENTAL_FLAG
, REFERENCE_4 REFERENCE_4
, REPORTED_GL_PERIOD REPORTED_GL_PERIOD
, ALC_CODE ALC_CODE
, ORG_ID ORG_ID
, REFERENCE_5 REFERENCE_5
, REFERENCE_6 REFERENCE_6
, REPORTED_FLAG REPORTED_FLAG
, EXCEPTION_EXISTS EXCEPTION_EXISTS
, RECORD_CATEGORY RECORD_CATEGORY
, JE_LINE_NUM JE_LINE_NUM
, JE_HEADER_ID JE_HEADER_ID
, SF224_PROCESSED_FLAG SF224_PROCESSED_FLAG
, DEF_ORG_ID DEF_ORG_ID
, PROCESSED_FLAG PROCESSED_FLAG
, REFERENCE_9 REFERENCE_9
, PROCESS_ID PROCESS_ID
, TREASURY_SYMBOL_ID TREASURY_SYMBOL_ID
, FEDERAL_RPT_ID FEDERAL_RPT_ID
, JE_SOURCE JE_SOURCE
, JE_CATEGORY JE_CATEGORY
, DOCUMENT_NUMBER DOCUMENT_NUMBER
, REFERENCE_8 REFERENCE_8
, EXCEPTION_SECTION EXCEPTION_SECTION
, START_PERIOD_DATE START_PERIOD_DATE
, END_PERIOD_DATE END_PERIOD_DATE
, UPDATE_TYPE UPDATE_TYPE
, TXN_CATEGORY TXN_CATEGORY
, SIGN_NUMBER SIGN_NUMBER
, ACTUAL_AMOUNT ACTUAL_AMOUNT
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_REQUEST_ID CREATED_REQUEST_ID
, UPDATED_REQUEST_ID UPDATED_REQUEST_ID
, GL_DATE GL_DATE
, RECLASS RECLASS
, ACCOUNT ACCOUNT
, JE_FROM_SLA_FLAG JE_FROM_SLA_FLAG
FROM "FV"."FV_SF224_TEMP"