RETURN TO COMPOSITE VIEW REPORTS LIST
Reporting View Source: FRRBDET Finance Composite View Reports
SGHE Operational Data Store Composite View Source: FRRBDET

Source Column Source Form Target Type Target Target Column Calculation Formula
FRRBDET_ACCI_CODE NA COMPOSITE VIEW

AF_GRANT_BILLING_DETAIL

BILL_ACCOUNT_INDEX

NA
FRRBDET_ACCT_CODE FRABDCN COMPOSITE VIEW

AF_GRANT_BILLING_DETAIL

BILL_ACCOUNT

NA
FRRBDET_ACTV_CODE NA COMPOSITE VIEW

AF_GRANT_BILLING_DETAIL

BILL_ACTIVITY

NA
FRRBDET_ALTERNATE_FUND NA COMPOSITE VIEW

AF_GRANT_BILLING_DETAIL

BILL_ALTERNATE_FUND

NA
FRRBDET_BILLING_ADJUSTED_DATE NA COMPOSITE VIEW

AF_GRANT_BILLING_DETAIL

BILL_ADJUSTED_DATE

NA
FRRBDET_BILLING_PERIOD_DATE FRABDCN COMPOSITE VIEW

AF_GRANT_BILLING_DETAIL

BILL_PERIOD_DATE

NA
FRRBDET_BILL_INV_ADJ_NO NA COMPOSITE VIEW

AF_GRANT_BILLING_DETAIL

BILL_ADJUSTED_INVOICE_NUMBER

NA
FRRBDET_BILL_INV_SEQ_NO NA COMPOSITE VIEW

AF_GRANT_BILLING_DETAIL

BILL_INVOICE_NUMBER

NA
FRRBDET_BILL_RUN_DATE NA COMPOSITE VIEW

AF_GRANT_BILLING_DETAIL

BILL_RUN_DATE

NA
FRRBDET_BILL_STATUS NA COMPOSITE VIEW

AF_GRANT_BILLING_DETAIL

BILL_STATUS

NA
FRRBDET_BILL_TRAN_NUMBER NA COMPOSITE VIEW

AF_GRANT_BILLING_DETAIL

BILL_TRAN_NUMBER

NA
FRRBDET_COAS_CODE FRABDCN COMPOSITE VIEW

AF_GRANT_BILLING_DETAIL

BILL_CHART_OF_ACCOUNTS

NA
FRRBDET_DOC_CODE FRABDCN COMPOSITE VIEW

AF_GRANT_BILLING_DETAIL

BILL_DOCUMENT

NA
FRRBDET_DOC_SEQ_CODE NA COMPOSITE VIEW

AF_GRANT_BILLING_DETAIL

BILL_DOCUMENT_TYPE

NA
FRRBDET_FED_SHARE_AMT NA COMPOSITE VIEW

AF_GRANT_BILLING_DETAIL

FEDERAL_SHARE_AMOUNT

NA
FRRBDET_FUND_CODE FRABDCN COMPOSITE VIEW

AF_GRANT_BILLING_DETAIL

BILL_FUND

NA
FRRBDET_GRNT_CODE FRABDCN COMPOSITE VIEW

AF_GRANT_BILLING_DETAIL

BILL_GRANT_ID

NA
FRRBDET_HOLD_DATE FRABDCN COMPOSITE VIEW

AF_GRANT_BILLING_DETAIL

BILL_HOLD_DATE

NA
FRRBDET_ITEM_NUM FRABDCN COMPOSITE VIEW

AF_GRANT_BILLING_DETAIL

BILL_ITEM

NA
FRRBDET_LOCN_CODE NA COMPOSITE VIEW

AF_GRANT_BILLING_DETAIL

BILL_LOCATION

NA
FRRBDET_ORGN_CODE NA COMPOSITE VIEW

AF_GRANT_BILLING_DETAIL

BILL_ORGANIZATION

NA
FRRBDET_PROG_CODE NA COMPOSITE VIEW

AF_GRANT_BILLING_DETAIL

BILL_PROGRAM

NA
FRRBDET_RELEASE_DATE FRABDCN COMPOSITE VIEW

AF_GRANT_BILLING_DETAIL

HOLD_RELEASE_DATE

NA
FRRBDET_REVERSAL_IND NA COMPOSITE VIEW

AF_GRANT_BILLING_DETAIL

BILL_REVERSAL_IND

NA
FRRBDET_SEQ_NUM FRABDCN COMPOSITE VIEW

AF_GRANT_BILLING_DETAIL

BILL_SEQUENCE_NUMBER

NA
FRRBDET_SUBMISSION_NUMBER NA COMPOSITE VIEW

AF_GRANT_BILLING_DETAIL

BILL_SUBMISSION_NUMBER

NA
FRRBDET_TRANS_AMT FRABDCN COMPOSITE VIEW

AF_GRANT_BILLING_DETAIL

BILL_TRANSACTION_AMOUNT

NA
FRRBDET_TRANS_DATE FRABDCN COMPOSITE VIEW

AF_GRANT_BILLING_DETAIL

BILL_TRANSACTION_DATE

NA
FRRBDET_TRANS_DESC FRABDCN COMPOSITE VIEW

AF_GRANT_BILLING_DETAIL

BILL_TRANSACTION_DESC

NA


Ver: 3.1