Composite View Source: TRRACCD

Go To View:	RETURN TO COMPOSITE VIEW REPORTS LIST
	Reporting View Source: TRRACCD Accounts Receivable

**SGHE Banner Operational Data Store**
Source Column	Source Form	Target Type	Target	Target Column	Calculation Formula
TRRACCD_ACCT_FEED_IND	FRIAPPL	COMPOSITE VIEW	AT_GRANT_ACCOUNT_DETAIL	ACCOUNT_POSTING_STATUS	NA
TRRACCD_ACTUAL_COST_AMT	NA	COMPOSITE VIEW	AT_GRANT_ACCOUNT_DETAIL	ACCOUNT_ACTUAL_COST_AMOUNT	NA
TRRACCD_AMOUNT	FRAAREV	COMPOSITE VIEW	AT_GRANT_ACCOUNT_DETAIL	ACCOUNT_AMOUNT	NA
TRRACCD_BALANCE	FRAAREV	COMPOSITE VIEW	AT_GRANT_ACCOUNT_DETAIL	ACCOUNT_BALANCE	NA
TRRACCD_BILL_DATE	NA	COMPOSITE VIEW	AT_GRANT_ACCOUNT_DETAIL	BILL_DATE	NA
TRRACCD_BILL_INV_ADJ_NO	FRAAREV	COMPOSITE VIEW	AT_GRANT_ACCOUNT_DETAIL	ADJUSTED_BILLED_INVOICE_NUMBER	NA
TRRACCD_BILL_INV_SEQ_NO	FRAAREV	COMPOSITE VIEW	AT_GRANT_ACCOUNT_DETAIL	BILLED_INVOICE_NUMBER	NA
TRRACCD_COAS_CODE	NA	COMPOSITE VIEW	AT_GRANT_ACCOUNT_DETAIL	ACCOUNT_CHART_OF_ACCOUNTS	NA
TRRACCD_CSHR_END_DATE	NA	COMPOSITE VIEW	AT_GRANT_ACCOUNT_DETAIL	CASHIER_END_DATE	NA
TRRACCD_DESC	NA	COMPOSITE VIEW	AT_GRANT_ACCOUNT_DETAIL	TRANSACTION_DESC	NA
TRRACCD_DETAIL_CODE	FRAAREV	COMPOSITE VIEW	AT_GRANT_ACCOUNT_DETAIL	DETAIL_CODE	NA
TRRACCD_EFFECTIVE_DATE	FRAAREV	COMPOSITE VIEW	AT_GRANT_ACCOUNT_DETAIL	EFFECTIVE_DATE	NA
TRRACCD_ENTRY_DATE	NA	COMPOSITE VIEW	AT_ACCOUNT_DETAIL AT_GRANT_ACCOUNT_DETAIL	ENTRY_DATE ENTRY_DATE	NA
TRRACCD_FEED_DATE	FRAAREV	COMPOSITE VIEW	AT_GRANT_ACCOUNT_DETAIL	POSTING_DATE	NA
TRRACCD_FEED_DOC_CODE	FRAAREV	COMPOSITE VIEW	AT_GRANT_ACCOUNT_DETAIL	POSTING_DOCUMENT	NA
TRRACCD_FUND_CODE	NA	COMPOSITE VIEW	AT_GRANT_ACCOUNT_DETAIL	ACCOUNT_FUND	NA
TRRACCD_GRNT_CODE	FRAAREV	COMPOSITE VIEW	AT_GRANT_ACCOUNT_DETAIL	GRANT_ID	NA
TRRACCD_PAID_INV_ADJ_NO	FRAAREV	COMPOSITE VIEW	AT_GRANT_ACCOUNT_DETAIL	ADJUSTED_PAID_INVOICE_NUMBER	NA
TRRACCD_PAID_INV_SEQ_NO	FRAAREV	COMPOSITE VIEW	AT_GRANT_ACCOUNT_DETAIL	PAID_INVOICE_NUMBER	NA
TRRACCD_PAYMENT_ID	FRAAREV	COMPOSITE VIEW	AT_GRANT_ACCOUNT_DETAIL	PAYMENT_REFERENCE_NUMBER	NA
TRRACCD_REBILL_IND	FRAAREV	COMPOSITE VIEW	AT_GRANT_ACCOUNT_DETAIL	REBILL_IND	NA
TRRACCD_RUCL_CODE	NA				NA
TRRACCD_SESSION_NUMBER	NA	COMPOSITE VIEW	AT_GRANT_ACCOUNT_DETAIL	CASHIER_SESSION_NUMBER	NA
TRRACCD_SRCE_CODE	NA	COMPOSITE VIEW	AT_GRANT_ACCOUNT_DETAIL	SOURCE	NA
TRRACCD_TRANS_DATE	FRAAREV	COMPOSITE VIEW	AT_GRANT_ACCOUNT_DETAIL	TRANSACTION_DATE	NA
TRRACCD_TRAN_NUMBER	FRAAREV	COMPOSITE VIEW	AT_GRANT_ACCOUNT_DETAIL	ACCOUNT_TRANSACTION_NUMBER	NA
TRRACCD_TRAN_NUMBER_PAID	FRIAPPL	COMPOSITE VIEW	AT_GRANT_ACCOUNT_DETAIL	TRANSACTION_NUMBER_PAID	NA
TRRACCD_USER_ID	FRIAPPL	COMPOSITE VIEW	AT_GRANT_ACCOUNT_DETAIL	POST_CASHIER	NA
TRRACCD_WITHHOLDING_AMT	FRAAREV	COMPOSITE VIEW	AT_GRANT_ACCOUNT_DETAIL	WITHHOLDING_AMOUNT	NA
TRRACCD_WITHHOLDING_IND	NA	COMPOSITE VIEW	AT_GRANT_ACCOUNT_DETAIL	WITHHOLDING_IND	NA

Ver: 8.1