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

Source Column Source Form Local Source Target Type Target Target Column Local Target Calculation Formula
TRRACCD_ACCT_FEED_IND FRIAPPL NO

REPORTING VIEW

GRANT_APPLIED_PAYMENTS

GRANT_RECEIVABLE_ACCT_DETAIL

ACCOUNT_POSTING_STATUS

ACCOUNT_POSTING_STATUS

NO

NO

NA
TRRACCD_ACTUAL_COST_AMT NA NO

REPORTING VIEW

GRANT_APPLIED_PAYMENTS

GRANT_RECEIVABLE_ACCT_DETAIL

ACCOUNT_ACTUAL_COST_AMOUNT

ACCOUNT_ACTUAL_COST_AMOUNT

NO

NO

NA
TRRACCD_AMOUNT FRAAREV NO

REPORTING VIEW

GRANT_RECEIVABLE_ACCT_DETAIL

GRANT_APPLIED_PAYMENTS

ACCOUNT_AMOUNT

ACCOUNT_AMOUNT

NO

NO

NA
TRRACCD_BALANCE FRAAREV NO

REPORTING VIEW

GRANT_RECEIVABLE_ACCT_DETAIL

GRANT_APPLIED_PAYMENTS

ACCOUNT_BALANCE

ACCOUNT_BALANCE

NO

NO

NA
TRRACCD_BILL_DATE NA NO

REPORTING VIEW

GRANT_APPLIED_PAYMENTS

GRANT_RECEIVABLE_ACCT_DETAIL

BILL_DATE

BILL_DATE

NO

NO

NA
TRRACCD_BILL_INV_ADJ_NO FRAAREV NO

REPORTING VIEW

GRANT_APPLIED_PAYMENTS

GRANT_RECEIVABLE_ACCT_DETAIL

ADJUSTED_BILLED_INVOICE_NUMBER

ADJUSTED_BILLED_INVOICE_NUMBER

NO

NO

NA
TRRACCD_BILL_INV_SEQ_NO FRAAREV NO

REPORTING VIEW

GRANT_APPLIED_PAYMENTS

GRANT_RECEIVABLE_ACCT_DETAIL

BILLED_INVOICE_NUMBER

BILLED_INVOICE_NUMBER

NO

NO

NA
TRRACCD_COAS_CODE NA NO

REPORTING VIEW

GRANT_RECEIVABLE_ACCT_DETAIL

ACCOUNT_CHART_OF_ACCOUNTS

NO

NA
TRRACCD_CSHR_END_DATE NA NO

REPORTING VIEW

GRANT_RECEIVABLE_ACCT_DETAIL

CASHIER_END_DATE

NO

NA
TRRACCD_DESC NA NO

REPORTING VIEW

GRANT_RECEIVABLE_ACCT_DETAIL

TRANSACTION_DESC

NO

NA
TRRACCD_DETAIL_CODE FRAAREV NO

REPORTING VIEW

GRANT_RECEIVABLE_ACCT_DETAIL

DETAIL_CODE

NO

NA
TRRACCD_EFFECTIVE_DATE FRAAREV NO

REPORTING VIEW

GRANT_APPLIED_PAYMENTS

GRANT_RECEIVABLE_ACCT_DETAIL

EFFECTIVE_DATE

EFFECTIVE_DATE

NO

NO

NA
TRRACCD_ENTRY_DATE NA NO

REPORTING VIEW

GRANT_APPLIED_PAYMENTS

GRANT_RECEIVABLE_ACCT_DETAIL

ENTRY_DATE

ENTRY_DATE

NO

NO

NA
TRRACCD_FEED_DATE FRAAREV NO

REPORTING VIEW

GRANT_RECEIVABLE_ACCT_DETAIL

GRANT_APPLIED_PAYMENTS

POSTING_DATE

POSTING_DATE

NO

NO

NA
TRRACCD_FEED_DOC_CODE FRAAREV NO

REPORTING VIEW

GRANT_APPLIED_PAYMENTS

GRANT_RECEIVABLE_ACCT_DETAIL

POSTING_DOCUMENT

POSTING_DOCUMENT

NO

NO

NA
TRRACCD_FUND_CODE NA NO

REPORTING VIEW

GRANT_RECEIVABLE_ACCT_DETAIL

ACCOUNT_FUND

NO

NA
TRRACCD_GRNT_CODE FRAAREV NO

REPORTING VIEW

GRANT_RECEIVABLE_ACCT_DETAIL

GRANT_ID

NO

NA
TRRACCD_PAID_INV_ADJ_NO FRAAREV NO

REPORTING VIEW

GRANT_RECEIVABLE_ACCT_DETAIL

GRANT_APPLIED_PAYMENTS

ADJUSTED_PAID_INVOICE_NUMBER

ADJUSTED_PAID_INVOICE_NUMBER

NO

NO

NA
TRRACCD_PAID_INV_SEQ_NO FRAAREV NO

REPORTING VIEW

GRANT_APPLIED_PAYMENTS

GRANT_RECEIVABLE_ACCT_DETAIL

PAID_INVOICE_NUMBER

PAID_INVOICE_NUMBER

NO

NO

NA
TRRACCD_PAYMENT_ID FRAAREV NO

REPORTING VIEW

GRANT_RECEIVABLE_ACCT_DETAIL

GRANT_APPLIED_PAYMENTS

PAYMENT_REFERENCE_NUMBER

PAYMENT_REFERENCE_NUMBER

NO

NO

NA
TRRACCD_REBILL_IND FRAAREV NO

REPORTING VIEW

GRANT_APPLIED_PAYMENTS

GRANT_RECEIVABLE_ACCT_DETAIL

REBILL_IND

REBILL_IND

NO

NO

NA
TRRACCD_SESSION_NUMBER NA NO

REPORTING VIEW

GRANT_RECEIVABLE_ACCT_DETAIL

CASHIER_SESSION_NUMBER

NO

NA
TRRACCD_SRCE_CODE NA NO

REPORTING VIEW

GRANT_RECEIVABLE_ACCT_DETAIL

SOURCE

NO

NA
TRRACCD_TRANS_DATE FRAAREV NO

REPORTING VIEW

GRANT_RECEIVABLE_ACCT_DETAIL

GRANT_APPLIED_PAYMENTS

TRANSACTION_DATE

TRANSACTION_DATE

NO

NO

NA
TRRACCD_TRAN_NUMBER FRAAREV NO

REPORTING VIEW

GRANT_RECEIVABLE_ACCT_DETAIL

GRANT_APPLIED_PAYMENTS

ACCOUNT_TRANSACTION_NUMBER

ACCOUNT_TRANSACTION_NUMBER

NO

NO

NA
TRRACCD_TRAN_NUMBER_PAID FRIAPPL NO

REPORTING VIEW

GRANT_RECEIVABLE_ACCT_DETAIL

TRANSACTION_NUMBER_PAID

NO

NA
TRRACCD_USER_ID FRIAPPL NO

REPORTING VIEW

GRANT_APPLIED_PAYMENTS

GRANT_RECEIVABLE_ACCT_DETAIL

POST_CASHIER

POST_CASHIER

NO

NO

NA
TRRACCD_WITHHOLDING_AMT FRAAREV NO

REPORTING VIEW

GRANT_APPLIED_PAYMENTS

GRANT_RECEIVABLE_ACCT_DETAIL

WITHHOLDING_AMOUNT

WITHHOLDING_AMOUNT

NO

NO

NA
TRRACCD_WITHHOLDING_IND NA NO

REPORTING VIEW

GRANT_APPLIED_PAYMENTS

GRANT_RECEIVABLE_ACCT_DETAIL

WITHHOLDING_IND

WITHHOLDING_IND

NO

NO

NA


Ver: 9.2