RETURN TO REPORTING VIEW REPORTS LIST
Composite View Source: TRRACCD Accounts Receivable Reporting View Meta Data Reports
SGHE Operational Data Store Reporting View Source: TRRACCD

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

REPORTING VIEW

GRANT_RECEIVABLE_ACCT_DETAIL

GRANT_APPLIED_PAYMENTS

ACCOUNT_POSTING_STATUS

ACCOUNT_POSTING_STATUS

NA
TRRACCD_ACTUAL_COST_AMT NA

REPORTING VIEW

GRANT_APPLIED_PAYMENTS

GRANT_RECEIVABLE_ACCT_DETAIL

ACCOUNT_ACTUAL_COST_AMOUNT

ACCOUNT_ACTUAL_COST_AMOUNT

NA
TRRACCD_AMOUNT FRAAREV

REPORTING VIEW

GRANT_APPLIED_PAYMENTS

GRANT_RECEIVABLE_ACCT_DETAIL

ACCOUNT_AMOUNT

ACCOUNT_AMOUNT

NA
TRRACCD_BALANCE FRAAREV

REPORTING VIEW

GRANT_APPLIED_PAYMENTS

GRANT_RECEIVABLE_ACCT_DETAIL

ACCOUNT_BALANCE

ACCOUNT_BALANCE

NA
TRRACCD_BILL_DATE NA

REPORTING VIEW

GRANT_APPLIED_PAYMENTS

GRANT_RECEIVABLE_ACCT_DETAIL

BILL_DATE

BILL_DATE

NA
TRRACCD_BILL_INV_ADJ_NO FRAAREV

REPORTING VIEW

GRANT_RECEIVABLE_ACCT_DETAIL

GRANT_APPLIED_PAYMENTS

ADJUSTED_BILLED_INVOICE_NUMBER

ADJUSTED_BILLED_INVOICE_NUMBER

NA
TRRACCD_BILL_INV_SEQ_NO FRAAREV

REPORTING VIEW

GRANT_RECEIVABLE_ACCT_DETAIL

GRANT_APPLIED_PAYMENTS

BILLED_INVOICE_NUMBER

BILLED_INVOICE_NUMBER

NA
TRRACCD_COAS_CODE NA

REPORTING VIEW

GRANT_RECEIVABLE_ACCT_DETAIL

ACCOUNT_CHART_OF_ACCOUNTS

NA
TRRACCD_CSHR_END_DATE NA

REPORTING VIEW

GRANT_RECEIVABLE_ACCT_DETAIL

CASHIER_END_DATE

NA
TRRACCD_DESC NA

REPORTING VIEW

GRANT_RECEIVABLE_ACCT_DETAIL

TRANSACTION_DESC

NA
TRRACCD_DETAIL_CODE FRAAREV

REPORTING VIEW

GRANT_RECEIVABLE_ACCT_DETAIL

DETAIL_CODE

NA
TRRACCD_EFFECTIVE_DATE FRAAREV

REPORTING VIEW

GRANT_RECEIVABLE_ACCT_DETAIL

GRANT_APPLIED_PAYMENTS

EFFECTIVE_DATE

EFFECTIVE_DATE

NA
TRRACCD_ENTRY_DATE NA

REPORTING VIEW

GRANT_RECEIVABLE_ACCT_DETAIL

GRANT_APPLIED_PAYMENTS

ENTRY_DATE

ENTRY_DATE

NA
TRRACCD_FEED_DATE FRAAREV

REPORTING VIEW

GRANT_APPLIED_PAYMENTS

GRANT_RECEIVABLE_ACCT_DETAIL

POSTING_DATE

POSTING_DATE

NA
TRRACCD_FEED_DOC_CODE FRAAREV

REPORTING VIEW

GRANT_RECEIVABLE_ACCT_DETAIL

GRANT_APPLIED_PAYMENTS

POSTING_DOCUMENT

POSTING_DOCUMENT

NA
TRRACCD_FUND_CODE NA

REPORTING VIEW

GRANT_RECEIVABLE_ACCT_DETAIL

ACCOUNT_FUND

NA
TRRACCD_GRNT_CODE FRAAREV

REPORTING VIEW

GRANT_RECEIVABLE_ACCT_DETAIL

GRANT_ID

NA
TRRACCD_PAID_INV_ADJ_NO FRAAREV

REPORTING VIEW

GRANT_RECEIVABLE_ACCT_DETAIL

GRANT_APPLIED_PAYMENTS

ADJUSTED_PAID_INVOICE_NUMBER

ADJUSTED_PAID_INVOICE_NUMBER

NA
TRRACCD_PAID_INV_SEQ_NO FRAAREV

REPORTING VIEW

GRANT_RECEIVABLE_ACCT_DETAIL

GRANT_APPLIED_PAYMENTS

PAID_INVOICE_NUMBER

PAID_INVOICE_NUMBER

NA
TRRACCD_PAYMENT_ID FRAAREV

REPORTING VIEW

GRANT_APPLIED_PAYMENTS

GRANT_RECEIVABLE_ACCT_DETAIL

PAYMENT_REFERENCE_NUMBER

PAYMENT_REFERENCE_NUMBER

NA
TRRACCD_REBILL_IND FRAAREV

REPORTING VIEW

GRANT_APPLIED_PAYMENTS

GRANT_RECEIVABLE_ACCT_DETAIL

REBILL_IND

REBILL_IND

NA
TRRACCD_RUCL_CODE NA       NA
TRRACCD_SESSION_NUMBER NA

REPORTING VIEW

GRANT_RECEIVABLE_ACCT_DETAIL

CASHIER_SESSION_NUMBER

NA
TRRACCD_SRCE_CODE NA

REPORTING VIEW

GRANT_RECEIVABLE_ACCT_DETAIL

SOURCE

NA
TRRACCD_TRANS_DATE FRAAREV

REPORTING VIEW

GRANT_APPLIED_PAYMENTS

GRANT_RECEIVABLE_ACCT_DETAIL

TRANSACTION_DATE

TRANSACTION_DATE

NA
TRRACCD_TRAN_NUMBER FRAAREV

REPORTING VIEW

GRANT_RECEIVABLE_ACCT_DETAIL

GRANT_APPLIED_PAYMENTS

ACCOUNT_TRANSACTION_NUMBER

ACCOUNT_TRANSACTION_NUMBER

NA
TRRACCD_TRAN_NUMBER_PAID FRIAPPL

REPORTING VIEW

GRANT_RECEIVABLE_ACCT_DETAIL

TRANSACTION_NUMBER_PAID

NA
TRRACCD_USER_ID FRIAPPL

REPORTING VIEW

GRANT_APPLIED_PAYMENTS

GRANT_RECEIVABLE_ACCT_DETAIL

POST_CASHIER

POST_CASHIER

NA
TRRACCD_WITHHOLDING_AMT FRAAREV

REPORTING VIEW

GRANT_APPLIED_PAYMENTS

GRANT_RECEIVABLE_ACCT_DETAIL

WITHHOLDING_AMOUNT

WITHHOLDING_AMOUNT

NA
TRRACCD_WITHHOLDING_IND NA

REPORTING VIEW

GRANT_RECEIVABLE_ACCT_DETAIL

GRANT_APPLIED_PAYMENTS

WITHHOLDING_IND

WITHHOLDING_IND

NA


Ver: 3.1