VIEW: FV.FV_FACTS_TRX_TEMP#

Source

View Text - Preformatted

select TREASURY_SYMBOL_ID TREASURY_SYMBOL_ID, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, ACCOUNT_NUMBER ACCOUNT_NUMBER, COHORT COHORT, BEGIN_END BEGIN_END, INDEF_DEF_FLAG INDEF_DEF_FLAG, APPOR_CAT_B_DTL APPOR_CAT_B_DTL, APPOR_CAT_B_TXT APPOR_CAT_B_TXT, PUBLIC_LAW PUBLIC_LAW, APPOR_CAT_CODE APPOR_CAT_CODE, AUTHORITY_TYPE AUTHORITY_TYPE, TRANSACTION_PARTNER TRANSACTION_PARTNER, REIMBURSEABLE_FLAG REIMBURSEABLE_FLAG, BEA_CATEGORY BEA_CATEGORY, BORROWING_SOURCE BORROWING_SOURCE, DEF_LIQUID_FLAG DEF_LIQUID_FLAG, DEFICIENCY_FLAG DEFICIENCY_FLAG, AVAILABILITY_FLAG AVAILABILITY_FLAG, LEGISLATION_FLAG LEGISLATION_FLAG, DEBIT DEBIT, CREDIT CREDIT, FUND_VALUE FUND_VALUE, DOCUMENT_NUMBER DOCUMENT_NUMBER, DOCUMENT_DATE DOCUMENT_DATE, DOCUMENT_SOURCE DOCUMENT_SOURCE, TRANSACTION_DATE TRANSACTION_DATE, CREATION_DATE_TIME CREATION_DATE_TIME, ADVANCE_FLAG ADVANCE_FLAG, TRANSFER_DEPT_ID TRANSFER_DEPT_ID, TRANSFER_MAIN_ACCT TRANSFER_MAIN_ACCT, YEAR_BUDGET_AUTH YEAR_BUDGET_AUTH, BUDGET_FUNCTION BUDGET_FUNCTION, PERIOD_ACTIVITY PERIOD_ACTIVITY, CODE_COMBINATION_ID CODE_COMBINATION_ID, ENTRY_USER ENTRY_USER, FED_NON_FED FED_NON_FED, TRADING_PARTNER TRADING_PARTNER, EXCH_NON_EXCH EXCH_NON_EXCH, CUST_NON_CUST CUST_NON_CUST, BUDGET_SUBFUNCTION BUDGET_SUBFUNCTION, JOURNAL_CREATION_DATE JOURNAL_CREATION_DATE, JOURNAL_MODIFIED_DATE JOURNAL_MODIFIED_DATE, PERIOD_NAME PERIOD_NAME, PROGRAM_RPT_CAT_NUM PROGRAM_RPT_CAT_NUM, PROGRAM_RPT_CAT_TXT PROGRAM_RPT_CAT_TXT, GL_DATE GL_DATE, GL_POSTED_DATE GL_POSTED_DATE, DOCUMENT_CATEGORY DOCUMENT_CATEGORY, REVERSAL_FLAG REVERSAL_FLAG, SLA_HDR_EVENT_ID SLA_HDR_EVENT_ID, SLA_HDR_CREATION_DATE SLA_HDR_CREATION_DATE, SLA_ENTITY_ID SLA_ENTITY_ID, PYA_FLAG PYA_FLAG from "FV"."FV_FACTS_TRX_TEMP"

View Text - HTML Formatted

SELECT TREASURY_SYMBOL_ID TREASURY_SYMBOL_ID
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, ACCOUNT_NUMBER ACCOUNT_NUMBER
, COHORT COHORT
, BEGIN_END BEGIN_END
, INDEF_DEF_FLAG INDEF_DEF_FLAG
, APPOR_CAT_B_DTL APPOR_CAT_B_DTL
, APPOR_CAT_B_TXT APPOR_CAT_B_TXT
, PUBLIC_LAW PUBLIC_LAW
, APPOR_CAT_CODE APPOR_CAT_CODE
, AUTHORITY_TYPE AUTHORITY_TYPE
, TRANSACTION_PARTNER TRANSACTION_PARTNER
, REIMBURSEABLE_FLAG REIMBURSEABLE_FLAG
, BEA_CATEGORY BEA_CATEGORY
, BORROWING_SOURCE BORROWING_SOURCE
, DEF_LIQUID_FLAG DEF_LIQUID_FLAG
, DEFICIENCY_FLAG DEFICIENCY_FLAG
, AVAILABILITY_FLAG AVAILABILITY_FLAG
, LEGISLATION_FLAG LEGISLATION_FLAG
, DEBIT DEBIT
, CREDIT CREDIT
, FUND_VALUE FUND_VALUE
, DOCUMENT_NUMBER DOCUMENT_NUMBER
, DOCUMENT_DATE DOCUMENT_DATE
, DOCUMENT_SOURCE DOCUMENT_SOURCE
, TRANSACTION_DATE TRANSACTION_DATE
, CREATION_DATE_TIME CREATION_DATE_TIME
, ADVANCE_FLAG ADVANCE_FLAG
, TRANSFER_DEPT_ID TRANSFER_DEPT_ID
, TRANSFER_MAIN_ACCT TRANSFER_MAIN_ACCT
, YEAR_BUDGET_AUTH YEAR_BUDGET_AUTH
, BUDGET_FUNCTION BUDGET_FUNCTION
, PERIOD_ACTIVITY PERIOD_ACTIVITY
, CODE_COMBINATION_ID CODE_COMBINATION_ID
, ENTRY_USER ENTRY_USER
, FED_NON_FED FED_NON_FED
, TRADING_PARTNER TRADING_PARTNER
, EXCH_NON_EXCH EXCH_NON_EXCH
, CUST_NON_CUST CUST_NON_CUST
, BUDGET_SUBFUNCTION BUDGET_SUBFUNCTION
, JOURNAL_CREATION_DATE JOURNAL_CREATION_DATE
, JOURNAL_MODIFIED_DATE JOURNAL_MODIFIED_DATE
, PERIOD_NAME PERIOD_NAME
, PROGRAM_RPT_CAT_NUM PROGRAM_RPT_CAT_NUM
, PROGRAM_RPT_CAT_TXT PROGRAM_RPT_CAT_TXT
, GL_DATE GL_DATE
, GL_POSTED_DATE GL_POSTED_DATE
, DOCUMENT_CATEGORY DOCUMENT_CATEGORY
, REVERSAL_FLAG REVERSAL_FLAG
, SLA_HDR_EVENT_ID SLA_HDR_EVENT_ID
, SLA_HDR_CREATION_DATE SLA_HDR_CREATION_DATE
, SLA_ENTITY_ID SLA_ENTITY_ID
, PYA_FLAG PYA_FLAG
FROM "FV"."FV_FACTS_TRX_TEMP"