Reporting View Source: TRRACCD

Go To View:	RETURN TO REPORTING VIEW REPORTS LIST
	Composite View Source: TRRACCD Accounts Receivable Reporting View Meta Data Reports

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

Ver: 9.0