| 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 |