Composite View Source: FGBTRND

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

**SGHE Banner Operational Data Store**
Source Column	Source Form	Target Type	Target	Target Column	Calculation Formula
FGBTRND_ACCI_CODE	FGIDOCR	COMPOSITE VIEW	AF_TRANSACTION_HISTORY	ACCOUNT_INDEX	NA
FGBTRND_ACCT_CODE	FGIDOCR	COMPOSITE VIEW	AF_TRANSACTION_HISTORY	ACCOUNT	NA
FGBTRND_ACTIVITY_DATE	FGITRND	COMPOSITE VIEW	AF_TRANSACTION_HISTORY	ACTIVITY_DATE	NA
FGBTRND_ACTV_CODE	FGIDOCR	COMPOSITE VIEW	AF_TRANSACTION_HISTORY	ACTIVITY	NA
FGBTRND_AMT_IND	FTMRUCL	COMPOSITE VIEW	AF_TRANSACTION_HISTORY	AMOUNT_IND	NA
FGBTRND_BUDGET_PERIOD	NA	COMPOSITE VIEW	AF_TRANSACTION_HISTORY	DETAIL_BUDGET_PERIOD	NA
FGBTRND_BUD_ID	NA	COMPOSITE VIEW	AF_TRANSACTION_HISTORY	BUDGET_ID	NA
FGBTRND_CMT_PCT	NA	COMPOSITE VIEW	AF_TRANSACTION_HISTORY	COMMIT_PERCENT	NA
FGBTRND_CMT_TYPE	FGIDOCR	COMPOSITE VIEW	AF_TRANSACTION_HISTORY	COMMIT_TYPE	NA
FGBTRND_COAS_CODE	FGIDOCR	COMPOSITE VIEW	AF_TRANSACTION_HISTORY	CHART_OF_ACCOUNTS	NA
FGBTRND_CS_RATE_PERCENT	NA	COMPOSITE VIEW	AF_TRANSACTION_HISTORY	COST_SHARE_RATE	NA
FGBTRND_DR_CR_IND	FGIDOCR	COMPOSITE VIEW	AF_TRANSACTION_HISTORY	DEBIT_CREDIT_IND	NA
FGBTRND_ENCD_ITEM_NUM	FGIENCD	COMPOSITE VIEW	AF_TRANSACTION_HISTORY	ENCUMBRANCE_ITEM_NUMBER	NA
FGBTRND_ENCD_NUM	FGIENCD	COMPOSITE VIEW	AF_TRANSACTION_HISTORY	ENCUMBRANCE_NUMBER	NA
FGBTRND_ENCD_SEQ_NUM	FGIENCD	COMPOSITE VIEW	AF_TRANSACTION_HISTORY	ENCUMBRANCE_SEQ_NUMBER	NA
FGBTRND_FIELD_CODE	FGIDOCR	COMPOSITE VIEW	AF_TRANSACTION_HISTORY	FIELD_CODE	NA
FGBTRND_FUND_CODE	FGIDOCR	COMPOSITE VIEW	AF_TRANSACTION_HISTORY	FUND	NA
FGBTRND_IC_MEMO_RATE_PERCENT	NA	COMPOSITE VIEW	AF_TRANSACTION_HISTORY	INDIRECT_COST_MEMO_RATE	NA
FGBTRND_IC_RATE_PERCENT	NA	COMPOSITE VIEW	AF_TRANSACTION_HISTORY	INDIRECT_COST_RATE	NA
FGBTRND_LEDGER_IND	FGIDOCR	COMPOSITE VIEW	AF_TRANSACTION_HISTORY	LEDGER_IND	NA
FGBTRND_LOCN_CODE	FGIDOCR	COMPOSITE VIEW	AF_TRANSACTION_HISTORY	LOCATION	NA
FGBTRND_ORGN_CODE	FGIDOCR	COMPOSITE VIEW	AF_TRANSACTION_HISTORY	ORGANIZATION_CODE	NA
FGBTRND_OTHER_DATA	NA	COMPOSITE VIEW	AF_TRANSACTION_HISTORY	OTHER_DATA	NA
FGBTRND_POSTING_PERIOD	FGIDOCR	COMPOSITE VIEW	AF_TRANSACTION_HISTORY	POSTING_PERIOD	NA
FGBTRND_PRJD_CODE	FGIDOCR	COMPOSITE VIEW	AF_TRANSACTION_HISTORY	DETAIL_PROJECT	NA
FGBTRND_PROC_CODE	FGIDOCR	COMPOSITE VIEW	AF_TRANSACTION_HISTORY	DETAIL_POSTING_PROCESS	NA
FGBTRND_PROG_CODE	FGIDOCR	COMPOSITE VIEW	AF_TRANSACTION_HISTORY	PROGRAM	NA
FGBTRND_RECON_IND	NA	COMPOSITE VIEW	AF_TRANSACTION_HISTORY	RECONCILIATION_IND	NA
FGBTRND_REVERSAL_IND	NA	COMPOSITE VIEW	AF_TRANSACTION_HISTORY	DETAIL_REVERSAL_IND	NA
FGBTRND_RUCL_CODE	FGIDOCR	COMPOSITE VIEW	AF_TRANSACTION_HISTORY	RULE_CLASS	NA
FGBTRND_RULP_CODE	NA	COMPOSITE VIEW	AF_TRANSACTION_HISTORY	RULE_PROCESS	NA
FGBTRND_SERIAL_NUM	NA	COMPOSITE VIEW	AF_TRANSACTION_HISTORY	DETAIL_SERIAL_NUMBER	NA
FGBTRND_SUM_POST_DOC_CODE	NA	COMPOSITE VIEW	AF_TRANSACTION_HISTORY	DETAIL_SUM_POST_DOC_CODE	NA
FGBTRND_TRANS_AMT	FGIDOCR	COMPOSITE VIEW	AF_TRANSACTION_HISTORY	TRANSACTION_AMOUNT	NA
FGBTRND_USER_ID	NA	COMPOSITE VIEW	AF_TRANSACTION_HISTORY	DETAIL_USER_ID	NA

Ver: 8.1