Composite View Source: FGBTRNH

Go To View:	RETURN TO COMPOSITE VIEW REPORTS LIST
	Reporting View Source: FGBTRNH Finance

**SGHE Banner Operational Data Store**
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_POSTING_PERIOD	TBD
FGBTRNH_PRJD_CODE	NA	COMPOSITE VIEW	AF_TRANSACTION_HISTORY	PROJECT	NA
FGBTRNH_REVERSAL_IND	NA	COMPOSITE VIEW	AF_TRANSACTION_HISTORY	REVERSAL_IND	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: