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

Source Column Source Form Target Type Target Target Column Calculation Formula
TRRACCD_ACCT_FEED_IND FRIAPPL COMPOSITE VIEW

AT_GRANT_ACCOUNT_DETAIL

ACCOUNT_POSTING_STATUS

NA
TRRACCD_ACTUAL_COST_AMT NA COMPOSITE VIEW

AT_GRANT_ACCOUNT_DETAIL

ACCOUNT_ACTUAL_COST_AMOUNT

NA
TRRACCD_AMOUNT FRAAREV COMPOSITE VIEW

AT_GRANT_ACCOUNT_DETAIL

ACCOUNT_AMOUNT

NA
TRRACCD_BALANCE FRAAREV COMPOSITE VIEW

AT_GRANT_ACCOUNT_DETAIL

ACCOUNT_BALANCE

NA
TRRACCD_BILL_DATE NA COMPOSITE VIEW

AT_GRANT_ACCOUNT_DETAIL

BILL_DATE

NA
TRRACCD_BILL_INV_ADJ_NO FRAAREV COMPOSITE VIEW

AT_GRANT_ACCOUNT_DETAIL

ADJUSTED_BILLED_INVOICE_NUMBER

NA
TRRACCD_BILL_INV_SEQ_NO FRAAREV COMPOSITE VIEW

AT_GRANT_ACCOUNT_DETAIL

BILLED_INVOICE_NUMBER

NA
TRRACCD_COAS_CODE NA COMPOSITE VIEW

AT_GRANT_ACCOUNT_DETAIL

ACCOUNT_CHART_OF_ACCOUNTS

NA
TRRACCD_CSHR_END_DATE NA COMPOSITE VIEW

AT_GRANT_ACCOUNT_DETAIL

CASHIER_END_DATE

NA
TRRACCD_DESC NA COMPOSITE VIEW

AT_GRANT_ACCOUNT_DETAIL

TRANSACTION_DESC

NA
TRRACCD_DETAIL_CODE FRAAREV COMPOSITE VIEW

AT_GRANT_ACCOUNT_DETAIL

DETAIL_CODE

NA
TRRACCD_EFFECTIVE_DATE FRAAREV COMPOSITE VIEW

AT_GRANT_ACCOUNT_DETAIL

EFFECTIVE_DATE

NA
TRRACCD_ENTRY_DATE NA COMPOSITE VIEW

AT_GRANT_ACCOUNT_DETAIL

AT_ACCOUNT_DETAIL

ENTRY_DATE

ENTRY_DATE

NA
TRRACCD_FEED_DATE FRAAREV COMPOSITE VIEW

AT_GRANT_ACCOUNT_DETAIL

POSTING_DATE

NA
TRRACCD_FEED_DOC_CODE FRAAREV COMPOSITE VIEW

AT_GRANT_ACCOUNT_DETAIL

POSTING_DOCUMENT

NA
TRRACCD_FUND_CODE NA COMPOSITE VIEW

AT_GRANT_ACCOUNT_DETAIL

ACCOUNT_FUND

NA
TRRACCD_GRNT_CODE FRAAREV COMPOSITE VIEW

AT_GRANT_ACCOUNT_DETAIL

GRANT_ID

NA
TRRACCD_PAID_INV_ADJ_NO FRAAREV COMPOSITE VIEW

AT_GRANT_ACCOUNT_DETAIL

ADJUSTED_PAID_INVOICE_NUMBER

NA
TRRACCD_PAID_INV_SEQ_NO FRAAREV COMPOSITE VIEW

AT_GRANT_ACCOUNT_DETAIL

PAID_INVOICE_NUMBER

NA
TRRACCD_PAYMENT_ID FRAAREV COMPOSITE VIEW

AT_GRANT_ACCOUNT_DETAIL

PAYMENT_REFERENCE_NUMBER

NA
TRRACCD_REBILL_IND FRAAREV COMPOSITE VIEW

AT_GRANT_ACCOUNT_DETAIL

REBILL_IND

NA
TRRACCD_RUCL_CODE NA       NA
TRRACCD_SESSION_NUMBER NA COMPOSITE VIEW

AT_GRANT_ACCOUNT_DETAIL

CASHIER_SESSION_NUMBER

NA
TRRACCD_SRCE_CODE NA COMPOSITE VIEW

AT_GRANT_ACCOUNT_DETAIL

SOURCE

NA
TRRACCD_TRANS_DATE FRAAREV COMPOSITE VIEW

AT_GRANT_ACCOUNT_DETAIL

TRANSACTION_DATE

NA
TRRACCD_TRAN_NUMBER FRAAREV COMPOSITE VIEW

AT_GRANT_ACCOUNT_DETAIL

ACCOUNT_TRANSACTION_NUMBER

NA
TRRACCD_TRAN_NUMBER_PAID FRIAPPL COMPOSITE VIEW

AT_GRANT_ACCOUNT_DETAIL

TRANSACTION_NUMBER_PAID

NA
TRRACCD_USER_ID FRIAPPL COMPOSITE VIEW

AT_GRANT_ACCOUNT_DETAIL

POST_CASHIER

NA
TRRACCD_WITHHOLDING_AMT FRAAREV COMPOSITE VIEW

AT_GRANT_ACCOUNT_DETAIL

WITHHOLDING_AMOUNT

NA
TRRACCD_WITHHOLDING_IND NA COMPOSITE VIEW

AT_GRANT_ACCOUNT_DETAIL

WITHHOLDING_IND

NA


Ver: 8.0