Go To View:  RETURN TO COMPOSITE VIEW REPORTS LIST
Reporting View Source: FGBTRNH Finance
SGHE Banner Operational Data Store Composite View Source: FGBTRNH - NULL

Source Column Source Form Target Type Target Target Column Calculation Formula
FGBTRNH_ABAL_OVERRIDE FGIDOCR COMPOSITE VIEW

AF_TRANSACTION_HISTORY

AVAILABLE_BUDGET_OVERRIDE

NA
FGBTRNH_ACCRUAL_IND FGIDOCR COMPOSITE VIEW

AF_TRANSACTION_HISTORY

ACCRUAL_IND

NA
FGBTRNH_AUTO_JRNL_ID NA COMPOSITE VIEW

AF_TRANSACTION_HISTORY

AUTO_JOURNAL_ID

NA
FGBTRNH_BANK_CODE FGIDOCR COMPOSITE VIEW

AF_TRANSACTION_HISTORY

BANK

NA
FGBTRNH_BUDGET_PERIOD NA COMPOSITE VIEW

AF_TRANSACTION_HISTORY

BUDGET_PERIOD

NA
FGBTRNH_BUD_DISPN NA COMPOSITE VIEW

AF_TRANSACTION_HISTORY

BUDGET_DISPOSITION

NA
FGBTRNH_COAS_CODE_POOL FGAJVCD COMPOSITE VIEW

AF_TRANSACTION_HISTORY

CHART_OF_ACCOUNTS_POOL

NA
FGBTRNH_CONVERT_AMT NA COMPOSITE VIEW

AF_TRANSACTION_HISTORY

CONVERT_AMOUNT

NA
FGBTRNH_CURR_CODE FGIDOCR COMPOSITE VIEW

AF_TRANSACTION_HISTORY

CURRENCY

NA
FGBTRNH_DEP_NUM FGAJVCD COMPOSITE VIEW

AF_TRANSACTION_HISTORY

DEPOSIT_NUMBER

NA
FGBTRNH_DIST_PCT NA COMPOSITE VIEW

AF_TRANSACTION_HISTORY

DISTRIBUTION_PERCENT

NA
FGBTRNH_DOC_CODE FGIDOCR COMPOSITE VIEW

AF_TRANSACTION_HISTORY

DOCUMENT

NA
FGBTRNH_DOC_REF_NUM FGIDOCR COMPOSITE VIEW

AF_TRANSACTION_HISTORY

DOC_REFERENCE_NUMBER

NA
FGBTRNH_DOC_SEQ_CODE NA COMPOSITE VIEW

AF_TRANSACTION_HISTORY

DOCUMENT_TYPE

NA
FGBTRNH_ENCB_TYPE FGAENCB COMPOSITE VIEW

AF_TRANSACTION_HISTORY

ENCUMBRANCE_TYPE

NA
FGBTRNH_ENCD_ACTION_IND FGIENCD COMPOSITE VIEW

AF_TRANSACTION_HISTORY

ENCUMBRANCE_ACTION_IND

NA
FGBTRNH_EXCHANGE_AMT NA COMPOSITE VIEW

AF_TRANSACTION_HISTORY

EXCHANGE_AMOUNT

NA
FGBTRNH_EXCHANGE_DIFF NA COMPOSITE VIEW

AF_TRANSACTION_HISTORY

EXCHANGE_DIFFERENCE

NA
FGBTRNH_FSYR_CODE FGIDOCR COMPOSITE VIEW

AF_TRANSACTION_HISTORY

FISCAL_YEAR_TWO_CHAR

NA
FGBTRNH_FUND_CODE_POOL NA COMPOSITE VIEW

AF_TRANSACTION_HISTORY

FUND_POOL

NA
FGBTRNH_ITEM_NUM FGIDOCR COMPOSITE VIEW

AF_TRANSACTION_HISTORY

ITEM

NA
FGBTRNH_PRJD_CODE NA COMPOSITE VIEW

AF_TRANSACTION_HISTORY

PROJECT

NA
FGBTRNH_REVERSAL_IND NA COMPOSITE VIEW

AF_TRANSACTION_HISTORY

REVERSAL_IND

NA
FGBTRNH_RUCL_CODE FGIDOCR       NA
FGBTRNH_SEQ_NUM FGIDOCR COMPOSITE VIEW

AF_TRANSACTION_HISTORY

SEQUENCE_NUMBER

NA
FGBTRNH_SERIAL_NUM NA COMPOSITE VIEW

AF_TRANSACTION_HISTORY

SERIAL_NUMBER

NA
FGBTRNH_SUBMISSION_NUMBER FGIDOCR COMPOSITE VIEW

AF_TRANSACTION_HISTORY

SUBMISSION_NUMBER

NA
FGBTRNH_SUM_POST_DOC_CODE NA COMPOSITE VIEW

AF_TRANSACTION_HISTORY

SUM_POSTING_DOCUMENT_CODE

NA
FGBTRNH_TRANS_DATE FGIDOCR COMPOSITE VIEW

AF_TRANSACTION_HISTORY

TRANSACTION_DATE

NA
FGBTRNH_TRANS_DESC FGIDOCR COMPOSITE VIEW

AF_TRANSACTION_HISTORY

TRANSACTION_DESC

NA
FGBTRNH_USER_ID NA COMPOSITE VIEW

AF_TRANSACTION_HISTORY

USER_ID

NA
FGBTRNH_VENDOR_PIDM NA COMPOSITE VIEW

AF_TRANSACTION_HISTORY

VENDOR_UID

NA


Ver: 8.0