Reporting View Source: TBRACCD

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

**SGHE Banner Operational Data Store**
Source Column	Source Form	Target Type	Target	Target Column	Calculation Formula
TBRACCD_ACCT_FEED_IND	TSADETL	REPORTING VIEW	RECEIVABLE_ACCOUNT_DETAIL	ACCOUNT_POSTING_STATUS	NA
TBRACCD_ACTIVITY_DATE	TBD	REPORTING VIEW	RECEIVABLE_ACCOUNT_DETAIL	ACCOUNT_DETAIL_ACTIVITY_DATE
TBRACCD_AIDY_CODE	TSADETL	REPORTING VIEW	RECEIVABLE_ACCOUNT_DETAIL	AID_YEAR
TBRACCD_AMOUNT	TSADETL	REPORTING VIEW	RECEIVABLE_ACCOUNT_DETAIL	AMOUNT	NA
TBRACCD_BALANCE	TSADETL	REPORTING VIEW	RECEIVABLE_ACCOUNT_DETAIL	BALANCE	NA
TBRACCD_BILL_DATE	TSADETL	REPORTING VIEW	RECEIVABLE_ACCOUNT_DETAIL	BILL_DATE	NA
TBRACCD_CPDT_IND	TSADETL	REPORTING VIEW	RECEIVABLE_ACCOUNT_DETAIL	CONTRACT_PYMT_TRANSACTION_IND
TBRACCD_CRN	TBD	REPORTING VIEW	RECEIVABLE_ACCOUNT_DETAIL	COURSE_REFERENCE_NUMBER
TBRACCD_CROSSREF_DCAT_CODE	TSADETL	REPORTING VIEW	RECEIVABLE_ACCOUNT_DETAIL	CROSSREF_CATEGORY	NA
TBRACCD_CROSSREF_DETAIL_CODE	TSADETL	REPORTING VIEW	RECEIVABLE_ACCOUNT_DETAIL	CROSSREF_DETAIL_CODE	NA
TBRACCD_CROSSREF_NUMBER	TSADETL	REPORTING VIEW	RECEIVABLE_ACCOUNT_DETAIL	CROSSREF_NUMBER	NA
TBRACCD_CROSSREF_PIDM	NA	REPORTING VIEW	RECEIVABLE_ACCOUNT_DETAIL	CROSSREF_ENTITY_UID	NA
TBRACCD_CROSSREF_SRCE_CODE	TSADETL	REPORTING VIEW	RECEIVABLE_ACCOUNT_DETAIL	CROSSREF_SOURCE	NA
TBRACCD_CSHR_END_DATE	TSADETL	REPORTING VIEW	RECEIVABLE_ACCOUNT_DETAIL APPLICATION_OF_PAYMENT	CASHIER_END_DATE CASHIER_END_DATE	NA
TBRACCD_CURR_CODE	TSADETF				NA
TBRACCD_DATA_ORIGIN	TSADETL	REPORTING VIEW	RECEIVABLE_ACCOUNT_DETAIL	ACCOUNT_DETAIL_DATA_ORIGIN
TBRACCD_DESC	TSADETL	REPORTING VIEW	RECEIVABLE_ACCOUNT_DETAIL	TRANSACTION_DESC	NA
TBRACCD_DETAIL_CODE	TSADETL	REPORTING VIEW	APPL_OF_PAY_DETAIL_ACCOUNTING APPLICATION_OF_PAYMENT APPL_OF_PAY_DETAIL_ACCOUNTING RECEIVABLE_SUMMARY APPLICATION_OF_PAYMENT RECEIVABLE_ACCOUNT_DETAIL	CHARGE_DETAIL_CODE CHARGE_DETAIL_CODE PAY_DETAIL_CODE DETAIL_CODE PAY_DETAIL_CODE DETAIL_CODE	NA
TBRACCD_DOCUMENT_NUMBER	TSADETL	REPORTING VIEW	RECEIVABLE_ACCOUNT_DETAIL	DOCUMENT_NUMBER	NA
TBRACCD_DUE_DATE	TSADETL	REPORTING VIEW	RECEIVABLE_ACCOUNT_DETAIL	DUE_DATE	NA
TBRACCD_EFFECTIVE_DATE	TSADETL	REPORTING VIEW	RECEIVABLE_ACCOUNT_DETAIL	EFFECTIVE_DATE	NA
TBRACCD_ENTRY_DATE	TSADETL	REPORTING VIEW	RECEIVABLE_ACCOUNT_DETAIL	ENTRY_DATE	NA
TBRACCD_FEED_DATE	TSADETL	REPORTING VIEW	RECEIVABLE_ACCOUNT_DETAIL	POSTING_DATE	NA
TBRACCD_FEED_DOC_CODE	TSADETL	REPORTING VIEW	RECEIVABLE_ACCOUNT_DETAIL	POSTING_DOCUMENT	NA
TBRACCD_FOREIGN_AMOUNT	TSADETF				NA
TBRACCD_INVOICE_NUMBER	TSADETL	REPORTING VIEW	RECEIVABLE_ACCOUNT_DETAIL	INVOICE_NUMBER	NA
TBRACCD_PAYMENT_ID	TSADETL	REPORTING VIEW	RECEIVABLE_ACCOUNT_DETAIL	CREDIT_CARD_NUMBER	NA
TBRACCD_PERIOD	TSADETL	REPORTING VIEW	RECEIVABLE_ACCOUNT_DETAIL	AID_ENROLLMENT_PERIOD
TBRACCD_PIDM	NA	REPORTING VIEW	RECEIVABLE_ACCOUNT RECEIVABLE_ACCOUNT_DETAIL	ACCOUNT_UID ACCOUNT_UID	NA
TBRACCD_RECEIPT_NUMBER	TSADETL	REPORTING VIEW	RECEIVABLE_ACCOUNT_DETAIL	RECEIPT_NUMBER	NA
TBRACCD_REFUND_IND	TSADETC	REPORTING VIEW	RECEIVABLE_ACCOUNT_DETAIL	REFUND
TBRACCD_SESSION_NUMBER	TSADETL	REPORTING VIEW	APPLICATION_OF_PAYMENT RECEIVABLE_ACCOUNT_DETAIL	CASHIER_SESSION_NUMBER CASHIER_SESSION_NUMBER	NA
TBRACCD_SRCE_CODE	TSADETL	REPORTING VIEW	RECEIVABLE_ACCOUNT_DETAIL	SOURCE	NA
TBRACCD_STATEMENT_DATE	TBD	REPORTING VIEW	RECEIVABLE_ACCOUNT_DETAIL	STATEMENT_DATE
TBRACCD_STSP_KEY_SEQUENCE	TSADETL	REPORTING VIEW	RECEIVABLE_ACCOUNT_DETAIL	STUDY_PATH
TBRACCD_TAX_AMOUNT	TSADETL	REPORTING VIEW	RECEIVABLE_ACCOUNT_DETAIL	TAX_AMOUNT	NA
TBRACCD_TAX_FUTURE_IND	TSADETL	REPORTING VIEW	RECEIVABLE_ACCOUNT_DETAIL	TAX_FUTURE_ITEM	NA
TBRACCD_TAX_REPT_BOX	TSADETL	REPORTING VIEW	RECEIVABLE_ACCOUNT_DETAIL	TAX_DOCUMENT_BOX_NUMBER	NA
TBRACCD_TAX_REPT_YEAR	TSADETL	REPORTING VIEW	RECEIVABLE_ACCOUNT_DETAIL	TAX_YEAR	NA
TBRACCD_TERM_CODE	TSADETL	REPORTING VIEW	RECEIVABLE_SUMMARY RECEIVABLE_ACCOUNT_DETAIL	ACADEMIC_PERIOD ACADEMIC_PERIOD	NA
TBRACCD_TRANS_DATE	TSADETL	REPORTING VIEW	RECEIVABLE_ACCOUNT_DETAIL	TRANSACTION_DATE	NA
TBRACCD_TRAN_NUMBER	TSADETL	REPORTING VIEW	RECEIVABLE_ACCOUNT_DETAIL	TRANSACTION_NUMBER	NA
TBRACCD_TRAN_NUMBER_PAID	TSADETL	REPORTING VIEW	RECEIVABLE_ACCOUNT_DETAIL	TRAN_NUMBER_PAID	NA
TBRACCD_USER	TSADETL	REPORTING VIEW	RECEIVABLE_ACCOUNT_DETAIL RECEIVABLE_ACCOUNT_DETAIL APPLICATION_OF_PAYMENT	ACCOUNT_DETAIL_USER_ID POST_CASHIER POST_CASHIER	NA

Ver: 8.5