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

Ver: 8.3