Composite View Source: TBRACCD

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

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

Ver: