VIEW: FV.FV_GTAS_TRX_REG_TEMP#

Source

View Text - Preformatted

select ACCOUNT_NUMBER ACCOUNT_NUMBER, TREASURY_SYMBOL_ID TREASURY_SYMBOL_ID, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, USSGL_ACCOUNT USSGL_ACCOUNT, CODE_COMBINATION_ID CODE_COMBINATION_ID, EXCH_NON_EXCH EXCH_NON_EXCH, CUST_NON_CUST CUST_NON_CUST, FUND_VALUE FUND_VALUE, DIRECT_OR_REIMB_CODE DIRECT_OR_REIMB_CODE, APPOR_CAT_CODE APPOR_CAT_CODE, APPOR_CAT_B_CODE APPOR_CAT_B_CODE, PROGRAM_REPT_CODE PROGRAM_REPT_CODE, BEA_CAT_CODE BEA_CAT_CODE, BORR_SRC_CODE BORR_SRC_CODE, NEW_BAL_CODE NEW_BAL_CODE, CUR_SUBSEQUENT_CODE CUR_SUBSEQUENT_CODE, PYA_CODE PYA_CODE, CREDIT_COHORT_YR CREDIT_COHORT_YR, PROGRAM_COST_IND PROGRAM_COST_IND, BUDGET_IMPACT_IND BUDGET_IMPACT_IND, AUTHORITY_TYPE_CODE AUTHORITY_TYPE_CODE, FED_NON_FED FED_NON_FED, TRADING_PARTNER_AGENCY_ID TRADING_PARTNER_AGENCY_ID, TRADING_PARTNER_MAIN_ACCOUNT TRADING_PARTNER_MAIN_ACCOUNT, ENTRY_USER ENTRY_USER, JOURNAL_CREATION_DATE JOURNAL_CREATION_DATE, JOURNAL_MODIFIED_DATE JOURNAL_MODIFIED_DATE, PERIOD_NAME PERIOD_NAME, 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, 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, PERIOD_ACTIVITY PERIOD_ACTIVITY, DEF_LIQUID_FLAG DEF_LIQUID_FLAG, DEFICIENCY_FLAG DEFICIENCY_FLAG, AVAILABILITY_FLAG AVAILABILITY_FLAG, LEGISLATION_FLAG LEGISLATION_FLAG, DEBIT DEBIT, CREDIT CREDIT, BEGIN_END BEGIN_END, INDEF_DEF_FLAG INDEF_DEF_FLAG, AUTHORITY_TYPE AUTHORITY_TYPE, TRANSACTION_PARTNER TRANSACTION_PARTNER, REIMBURSEABLE_FLAG REIMBURSEABLE_FLAG from "FV"."FV_GTAS_TRX_REG_TEMP"

View Text - HTML Formatted

SELECT ACCOUNT_NUMBER ACCOUNT_NUMBER
, TREASURY_SYMBOL_ID TREASURY_SYMBOL_ID
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, USSGL_ACCOUNT USSGL_ACCOUNT
, CODE_COMBINATION_ID CODE_COMBINATION_ID
, EXCH_NON_EXCH EXCH_NON_EXCH
, CUST_NON_CUST CUST_NON_CUST
, FUND_VALUE FUND_VALUE
, DIRECT_OR_REIMB_CODE DIRECT_OR_REIMB_CODE
, APPOR_CAT_CODE APPOR_CAT_CODE
, APPOR_CAT_B_CODE APPOR_CAT_B_CODE
, PROGRAM_REPT_CODE PROGRAM_REPT_CODE
, BEA_CAT_CODE BEA_CAT_CODE
, BORR_SRC_CODE BORR_SRC_CODE
, NEW_BAL_CODE NEW_BAL_CODE
, CUR_SUBSEQUENT_CODE CUR_SUBSEQUENT_CODE
, PYA_CODE PYA_CODE
, CREDIT_COHORT_YR CREDIT_COHORT_YR
, PROGRAM_COST_IND PROGRAM_COST_IND
, BUDGET_IMPACT_IND BUDGET_IMPACT_IND
, AUTHORITY_TYPE_CODE AUTHORITY_TYPE_CODE
, FED_NON_FED FED_NON_FED
, TRADING_PARTNER_AGENCY_ID TRADING_PARTNER_AGENCY_ID
, TRADING_PARTNER_MAIN_ACCOUNT TRADING_PARTNER_MAIN_ACCOUNT
, ENTRY_USER ENTRY_USER
, JOURNAL_CREATION_DATE JOURNAL_CREATION_DATE
, JOURNAL_MODIFIED_DATE JOURNAL_MODIFIED_DATE
, PERIOD_NAME PERIOD_NAME
, 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
, 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
, PERIOD_ACTIVITY PERIOD_ACTIVITY
, DEF_LIQUID_FLAG DEF_LIQUID_FLAG
, DEFICIENCY_FLAG DEFICIENCY_FLAG
, AVAILABILITY_FLAG AVAILABILITY_FLAG
, LEGISLATION_FLAG LEGISLATION_FLAG
, DEBIT DEBIT
, CREDIT CREDIT
, BEGIN_END BEGIN_END
, INDEF_DEF_FLAG INDEF_DEF_FLAG
, AUTHORITY_TYPE AUTHORITY_TYPE
, TRANSACTION_PARTNER TRANSACTION_PARTNER
, REIMBURSEABLE_FLAG REIMBURSEABLE_FLAG
FROM "FV"."FV_GTAS_TRX_REG_TEMP"