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**
Banner Source Column	Source Form	ODS Target	ODS Target Column
TRRACCD_ACCT_FEED_IND	FRIAPPL	GRANT_RECEIVABLE_ACCT_DETAIL GRANT_APPLIED_PAYMENTS	ACCOUNT_POSTING_STATUS ACCOUNT_POSTING_STATUS
TRRACCD_ACTUAL_COST_AMT	NA	GRANT_APPLIED_PAYMENTS GRANT_RECEIVABLE_ACCT_DETAIL	ACCOUNT_ACTUAL_COST_AMOUNT ACCOUNT_ACTUAL_COST_AMOUNT
TRRACCD_AMOUNT	FRAAREV	GRANT_RECEIVABLE_ACCT_DETAIL GRANT_APPLIED_PAYMENTS	ACCOUNT_AMOUNT ACCOUNT_AMOUNT
TRRACCD_BALANCE	FRAAREV	GRANT_RECEIVABLE_ACCT_DETAIL GRANT_APPLIED_PAYMENTS	ACCOUNT_BALANCE ACCOUNT_BALANCE
TRRACCD_BILL_DATE	NA	GRANT_APPLIED_PAYMENTS GRANT_RECEIVABLE_ACCT_DETAIL	BILL_DATE BILL_DATE
TRRACCD_BILL_INV_ADJ_NO	FRAAREV	GRANT_APPLIED_PAYMENTS GRANT_RECEIVABLE_ACCT_DETAIL	ADJUSTED_BILLED_INVOICE_NUMBER ADJUSTED_BILLED_INVOICE_NUMBER
TRRACCD_BILL_INV_SEQ_NO	FRAAREV	GRANT_APPLIED_PAYMENTS GRANT_RECEIVABLE_ACCT_DETAIL	BILLED_INVOICE_NUMBER BILLED_INVOICE_NUMBER
TRRACCD_COAS_CODE	NA	GRANT_RECEIVABLE_ACCT_DETAIL	ACCOUNT_CHART_OF_ACCOUNTS
TRRACCD_CSHR_END_DATE	NA	GRANT_RECEIVABLE_ACCT_DETAIL	CASHIER_END_DATE
TRRACCD_DESC	NA	GRANT_RECEIVABLE_ACCT_DETAIL	TRANSACTION_DESC
TRRACCD_DETAIL_CODE	FRAAREV	GRANT_RECEIVABLE_ACCT_DETAIL	DETAIL_CODE
TRRACCD_EFFECTIVE_DATE	FRAAREV	GRANT_APPLIED_PAYMENTS GRANT_RECEIVABLE_ACCT_DETAIL	EFFECTIVE_DATE EFFECTIVE_DATE
TRRACCD_ENTRY_DATE	NA	GRANT_APPLIED_PAYMENTS GRANT_RECEIVABLE_ACCT_DETAIL	ENTRY_DATE ENTRY_DATE
TRRACCD_FEED_DATE	FRAAREV	GRANT_RECEIVABLE_ACCT_DETAIL GRANT_APPLIED_PAYMENTS	POSTING_DATE POSTING_DATE
TRRACCD_FEED_DOC_CODE	FRAAREV	GRANT_APPLIED_PAYMENTS GRANT_RECEIVABLE_ACCT_DETAIL	POSTING_DOCUMENT POSTING_DOCUMENT
TRRACCD_FUND_CODE	NA	GRANT_RECEIVABLE_ACCT_DETAIL	ACCOUNT_FUND
TRRACCD_GRNT_CODE	FRAAREV	GRANT_RECEIVABLE_ACCT_DETAIL	GRANT_ID
TRRACCD_PAID_INV_ADJ_NO	FRAAREV	GRANT_RECEIVABLE_ACCT_DETAIL GRANT_APPLIED_PAYMENTS	ADJUSTED_PAID_INVOICE_NUMBER ADJUSTED_PAID_INVOICE_NUMBER
TRRACCD_PAID_INV_SEQ_NO	FRAAREV	GRANT_RECEIVABLE_ACCT_DETAIL GRANT_APPLIED_PAYMENTS	PAID_INVOICE_NUMBER PAID_INVOICE_NUMBER
TRRACCD_PAYMENT_ID	FRAAREV	GRANT_APPLIED_PAYMENTS GRANT_RECEIVABLE_ACCT_DETAIL	PAYMENT_REFERENCE_NUMBER PAYMENT_REFERENCE_NUMBER
TRRACCD_REBILL_IND	FRAAREV	GRANT_APPLIED_PAYMENTS GRANT_RECEIVABLE_ACCT_DETAIL	REBILL_IND REBILL_IND
TRRACCD_RUCL_CODE	NA
TRRACCD_SESSION_NUMBER	NA	GRANT_RECEIVABLE_ACCT_DETAIL	CASHIER_SESSION_NUMBER
TRRACCD_SRCE_CODE	NA	GRANT_RECEIVABLE_ACCT_DETAIL	SOURCE
TRRACCD_TRANS_DATE	FRAAREV	GRANT_RECEIVABLE_ACCT_DETAIL GRANT_APPLIED_PAYMENTS	TRANSACTION_DATE TRANSACTION_DATE
TRRACCD_TRAN_NUMBER	FRAAREV	GRANT_APPLIED_PAYMENTS GRANT_RECEIVABLE_ACCT_DETAIL	ACCOUNT_TRANSACTION_NUMBER ACCOUNT_TRANSACTION_NUMBER
TRRACCD_TRAN_NUMBER_PAID	FRIAPPL	GRANT_RECEIVABLE_ACCT_DETAIL	TRANSACTION_NUMBER_PAID
TRRACCD_USER_ID	FRIAPPL	GRANT_RECEIVABLE_ACCT_DETAIL GRANT_APPLIED_PAYMENTS	POST_CASHIER POST_CASHIER
TRRACCD_WITHHOLDING_AMT	FRAAREV	GRANT_RECEIVABLE_ACCT_DETAIL GRANT_APPLIED_PAYMENTS	WITHHOLDING_AMOUNT WITHHOLDING_AMOUNT
TRRACCD_WITHHOLDING_IND	NA	GRANT_RECEIVABLE_ACCT_DETAIL GRANT_APPLIED_PAYMENTS	WITHHOLDING_IND WITHHOLDING_IND

Ver: 8.3