Go To View:  RETURN TO REPORTING VIEW REPORTS LIST
Composite View Source: TBRACCD Accounts Receivable Reporting View Meta Data Reports
Banner Operational Data Store Reporting View Source: TBRACCD - NULL

Source Column Source Form Local Source Target Type Target Target Column Local Target Calculation Formula
TBRACCD_ACCT_FEED_IND TSADETL NO

REPORTING VIEW

RECEIVABLE_ACCOUNT_DETAIL

ACCOUNT_POSTING_STATUS

NO

NA
TBRACCD_ACTIVITY_DATE TBD NO

REPORTING VIEW

RECEIVABLE_ACCOUNT_DETAIL

ACCOUNT_DETAIL_ACTIVITY_DATE

NO

 
TBRACCD_AIDY_CODE TSADETL NO

REPORTING VIEW

RECEIVABLE_ACCOUNT_DETAIL

AID_YEAR

NO

 
TBRACCD_AMOUNT TSADETL NO

REPORTING VIEW

RECEIVABLE_ACCOUNT_DETAIL

AMOUNT

NO

NA
TBRACCD_BALANCE TSADETL NO

REPORTING VIEW

RECEIVABLE_ACCOUNT_DETAIL

BALANCE

NO

NA
TBRACCD_BILL_DATE TSADETL NO

REPORTING VIEW

RECEIVABLE_ACCOUNT_DETAIL

BILL_DATE

NO

NA
TBRACCD_CPDT_IND TSADETL NO

REPORTING VIEW

RECEIVABLE_ACCOUNT_DETAIL

CONTRACT_PYMT_TRANSACTION_IND

NO

 
TBRACCD_CRN TBD NO

REPORTING VIEW

RECEIVABLE_ACCOUNT_DETAIL

COURSE_REFERENCE_NUMBER

NO

 
TBRACCD_CROSSREF_DCAT_CODE TSADETL NO

REPORTING VIEW

RECEIVABLE_ACCOUNT_DETAIL

CROSSREF_CATEGORY

NO

NA
TBRACCD_CROSSREF_DETAIL_CODE TSADETL NO

REPORTING VIEW

RECEIVABLE_ACCOUNT_DETAIL

CROSSREF_DETAIL_CODE

NO

NA
TBRACCD_CROSSREF_NUMBER TSADETL NO

REPORTING VIEW

RECEIVABLE_ACCOUNT_DETAIL

CROSSREF_NUMBER

NO

NA
TBRACCD_CROSSREF_PIDM NA NO

REPORTING VIEW

RECEIVABLE_ACCOUNT_DETAIL

CROSSREF_ENTITY_UID

NO

NA
TBRACCD_CROSSREF_SRCE_CODE TSADETL NO

REPORTING VIEW

RECEIVABLE_ACCOUNT_DETAIL

CROSSREF_SOURCE

NO

NA
TBRACCD_CSHR_END_DATE TSADETL NO

REPORTING VIEW

RECEIVABLE_ACCOUNT_DETAIL

APPLICATION_OF_PAYMENT

CASHIER_END_DATE

CASHIER_END_DATE

NO

NO

NA
TBRACCD_CURR_CODE TSADETF NO         NA
TBRACCD_DATA_ORIGIN TSADETL NO

REPORTING VIEW

RECEIVABLE_ACCOUNT_DETAIL

ACCOUNT_DETAIL_DATA_ORIGIN

NO

 
TBRACCD_DESC TSADETL NO

REPORTING VIEW

RECEIVABLE_ACCOUNT_DETAIL

TRANSACTION_DESC

NO

NA
TBRACCD_DETAIL_CODE TSADETL NO

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

NO

NO

NO

NO

NO

NO

NA
TBRACCD_DOCUMENT_NUMBER TSADETL NO

REPORTING VIEW

RECEIVABLE_ACCOUNT_DETAIL

DOCUMENT_NUMBER

NO

NA
TBRACCD_DUE_DATE TSADETL NO

REPORTING VIEW

RECEIVABLE_ACCOUNT_DETAIL

DUE_DATE

NO

NA
TBRACCD_EFFECTIVE_DATE TSADETL NO

REPORTING VIEW

RECEIVABLE_ACCOUNT_DETAIL

EFFECTIVE_DATE

NO

NA
TBRACCD_ENTRY_DATE TSADETL NO

REPORTING VIEW

RECEIVABLE_ACCOUNT_DETAIL

ENTRY_DATE

NO

NA
TBRACCD_FEED_DATE TSADETL NO

REPORTING VIEW

RECEIVABLE_ACCOUNT_DETAIL

POSTING_DATE

NO

NA
TBRACCD_FEED_DOC_CODE TSADETL NO

REPORTING VIEW

RECEIVABLE_ACCOUNT_DETAIL

POSTING_DOCUMENT

NO

NA
TBRACCD_FOREIGN_AMOUNT TSADETF NO         NA
TBRACCD_INVOICE_NUMBER TSADETL NO

REPORTING VIEW

RECEIVABLE_ACCOUNT_DETAIL

INVOICE_NUMBER

NO

NA
TBRACCD_PAYMENT_ID TSADETL NO

REPORTING VIEW

RECEIVABLE_ACCOUNT_DETAIL

CREDIT_CARD_NUMBER

NO

NA
TBRACCD_PERIOD TSADETL NO

REPORTING VIEW

RECEIVABLE_ACCOUNT_DETAIL

AID_ENROLLMENT_PERIOD

NO

 
TBRACCD_PIDM NA NO

REPORTING VIEW

RECEIVABLE_ACCOUNT

RECEIVABLE_ACCOUNT_DETAIL

ACCOUNT_UID

ACCOUNT_UID

NO

NO

NA
TBRACCD_RECEIPT_NUMBER TSADETL NO

REPORTING VIEW

RECEIVABLE_ACCOUNT_DETAIL

RECEIPT_NUMBER

NO

NA
TBRACCD_REFUND_IND TSADETC NO

REPORTING VIEW

RECEIVABLE_ACCOUNT_DETAIL

REFUND

NO

 
TBRACCD_SESSION_NUMBER TSADETL NO

REPORTING VIEW

APPLICATION_OF_PAYMENT

RECEIVABLE_ACCOUNT_DETAIL

CASHIER_SESSION_NUMBER

CASHIER_SESSION_NUMBER

NO

NO

NA
TBRACCD_SRCE_CODE TSADETL NO

REPORTING VIEW

RECEIVABLE_ACCOUNT_DETAIL

SOURCE

NO

NA
TBRACCD_STATEMENT_DATE TBD NO

REPORTING VIEW

RECEIVABLE_ACCOUNT_DETAIL

STATEMENT_DATE

NO

 
TBRACCD_STSP_KEY_SEQUENCE TSADETL NO

REPORTING VIEW

RECEIVABLE_ACCOUNT_DETAIL

STUDY_PATH

NO

 
TBRACCD_TAX_AMOUNT TSADETL NO

REPORTING VIEW

RECEIVABLE_ACCOUNT_DETAIL

TAX_AMOUNT

NO

NA
TBRACCD_TAX_FUTURE_IND TSADETL NO

REPORTING VIEW

RECEIVABLE_ACCOUNT_DETAIL

TAX_FUTURE_ITEM

NO

NA
TBRACCD_TAX_FUTURE_IND_PR TSADETL NO

REPORTING VIEW

RECEIVABLE_ACCOUNT_DETAIL

TAX_FUTURE_ITEM_PR

NO

NA
TBRACCD_TAX_FUTURE_IND_SG TSADETL NO

REPORTING VIEW

RECEIVABLE_ACCOUNT_DETAIL

TAX_FUTURE_ITEM_SG

NO

NA
TBRACCD_TAX_REPT_BOX TSADETL NO

REPORTING VIEW

RECEIVABLE_ACCOUNT_DETAIL

TAX_DOCUMENT_BOX_NUMBER

NO

NA
TBRACCD_TAX_REPT_BOX_PR TSADETL NO

REPORTING VIEW

RECEIVABLE_ACCOUNT_DETAIL

TAX_DOCUMENT_BOX_NUMBER_PR

NO

NA
TBRACCD_TAX_REPT_BOX_SG TSADETL NO

REPORTING VIEW

RECEIVABLE_ACCOUNT_DETAIL

TAX_DOCUMENT_BOX_NUMBER_SG

NO

NA
TBRACCD_TAX_REPT_YEAR TSADETL NO

REPORTING VIEW

RECEIVABLE_ACCOUNT_DETAIL

TAX_YEAR

NO

NA
TBRACCD_TERM_CODE TSADETL NO

REPORTING VIEW

RECEIVABLE_SUMMARY

RECEIVABLE_ACCOUNT_DETAIL

ACADEMIC_PERIOD

ACADEMIC_PERIOD

NO

NO

NA
TBRACCD_TRANS_DATE TSADETL NO

REPORTING VIEW

RECEIVABLE_ACCOUNT_DETAIL

TRANSACTION_DATE

NO

NA
TBRACCD_TRAN_NUMBER TSADETL NO

REPORTING VIEW

RECEIVABLE_ACCOUNT_DETAIL

TRANSACTION_NUMBER

NO

NA
TBRACCD_TRAN_NUMBER_PAID TSADETL NO

REPORTING VIEW

RECEIVABLE_ACCOUNT_DETAIL

TRAN_NUMBER_PAID

NO

NA
TBRACCD_USER TSADETL NO

REPORTING VIEW

RECEIVABLE_ACCOUNT_DETAIL

RECEIVABLE_ACCOUNT_DETAIL

APPLICATION_OF_PAYMENT

ACCOUNT_DETAIL_USER_ID

POST_CASHIER

POST_CASHIER

NO

NO

NO

NA


Ver: 9.2