Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST


Finance Composite View Meta Data Reports

Target Reports:

Composite ViewDescription
AF_ACCOUNT_ATTRIBUTES_ODS
Source composite view contains all the attributes (sets, types, values) associated with an account code.
AF_ACCOUNT_HIERARCHY
Source composite view contains the account hierarchy.
AF_ACCOUNT_INDEX
Source composite view contains account index.
AF_ACCOUNT_TYPE_ATTRIBUTES_ODS
Source composite view contains all the attributes (sets, types, values) associated with an account type code.
AF_ACTIVITY_ATTRIBUTES_ODS
Source composite view contains all the attributes (sets, types, values) associated with an activity code.
AF_ATTRIBUTE_SETS_ODS
Source composite view contains all the attributes (types, values) associated with a chart of accounts code and set code.
AF_BUDGET_AVAILABILITY_LEDGER
Source composite view contains detailed information on available budget.
AF_BUDGET_DETAIL
Source composite view contains detailed budget information, including change history.
AF_CHART_ATTRIBUTES_ODS
Source composite view contains all the attributes (sets, types, values) associated with a chart of accounts code.
AF_CHECKS
Source composite view contains information about a processed check from accounts payable.
AF_ENCUMBRANCE
Source composite view contains general information on encumbrance item.
AF_ENCUMBRANCE_ACCOUNTING
Source composite view contains information on detailed encumbrance accounting.
AF_ENCUMBRANCE_LEDGER
Source composite view contains encumbrance ledger information.
AF_ENDOWMENT
Source composite view contains endowment funds and their associated information including associated pool.
AF_ENDOWMENT_ATTRIBUTES
Source composite view contains information on the user defined attributes for endowments.
AF_ENDOWMENT_DIST
Source composite view contains endowment distribution and its associated information.
AF_ENDOWMENT_MARKET_VALUES
Source composite view contains information on the purchase price for endowment pools by period and actual valuation and unitization dates.
AF_ENDOWMENT_UNITS
Source composite view contains endowment fund unitization history.
AF_FISCAL_PERIOD
This view returns rows of fiscal periods for each fiscal year.1 row per fiscal year per fiscal period.
AF_FIXED_ASSET_ADJUSTMENT
Source composite view contains detailed information on the adjustments of fixed assets.
AF_FIXED_ASSET_ATTRIBUTES
Source composite view contains detailed information on fixed assets user defined attributes.
AF_FIXED_ASSET_DEPRECIATION
Source composite view contains detailed information on fixed assets depreciation and capitalization information.
AF_FIXED_ASSET_FUNDING_SOURCE
Source composite view contains detailed information on fixed assets fund source accounting.
AF_FIXED_ASSET_ITEM
Source composite view contains detailed information on fixed assets items.
AF_FUND_ATTRIBUTES_ODS
Source composite view contains all the attributes (sets, types, values) associated with a fund code.
AF_FUND_HIERARCHY
Source composite view contains the fund hierarchy.
AF_FUND_TYPE_ATTRIBUTES_ODS
Source composite view contains all the attributes (sets, types, values) associated with a fund type code.
AF_GENERAL_LEDGER
Source composite view contains general ledger information.
AF_GRANT
Source composite view contains grants and their associated information.
AF_GRANT_ATTRIBUTES_ODS
Source composite view contains all the user defined attributes associated with a grant code.
AF_GRANT_BILLING_DETAIL
Source composite view contains research accounting billing transaction details.
AF_GRANT_FUND
Source composite view contains funds assigned to grants and their associated information.
AF_GRANT_LEDGER
Source composite view contains detailed grant activity information by grant period.
AF_INVOICE
Source composite view contains information on invoices.
AF_INVOICE_ACCOUNTING
Source composite view contains accounting information for an invoice.
AF_INVOICE_CHECK
Source composite view contains check information for invoices.
AF_INVOICE_ITEM
Source composite view contains item level detailed information on invoices.
AF_INVOICE_TAX_RATE
Source composite view contains tax rate information for invoices.
AF_LOCATION_ATTRIBUTES_ODS
Source composite view contains all the attributes (sets, types, values) associated with a location code.
AF_LOCATION_HIERARCHY
Source composite view contains the location hierarchy.
AF_OPERATING_LEDGER
Source composite view contains detailed information for the operating ledger.
AF_ORGANIZATION_ATTRIBUTES_ODS
Source composite view contains all the attributes (sets, types, values) associated with an organization code.
AF_ORGANIZATION_HIERARCHY
Source composite view contains the organization hierarchy.
AF_PROGRAM_ATTRIBUTES_ODS
Source composite view contains all the attributes (sets, types, values) associated with a program code.
AF_PROGRAM_HIERARCHY
Source composite view contains the program hierarchy.
AF_PROPOSAL
Source composite view contains information for each proposal.
AF_PURCHASE_ORDER
Source composite view contains cumulative information for purchase orders.
AF_PURCHASE_ORDER_ACCOUNTING
Source composite view contains cumulative accounting information for purchase orders.
AF_PURCHASE_ORDER_ITEM
Source composite view contains the cumulative line item detail for each purchase order.
AF_PURCHASE_ORDER_TAX_RATE
Source composite view contains cumulative tax rate information for purchase orders.
AF_RECEIVED_ITEM
Source composite view contains information on received/returned items.
AF_RETURNED_ITEM
Contains returned purchase order item information.
AF_TEXT
Source composite view contains detailed information on text lines associated with documents/entities.
AF_TRANSACTION_HISTORY
Source composite view contains all source detail transactions used to update the ledgers.
AF_VALIDATION
Source composite view contains a number of the source systems' validation table records. This view was meant to be used with reporting tools to create list of values as well as for cleansing purposes in the Enterprise Data Warehouse.
AF_VENDOR
Source composite view contains information on all vendors.

Source Reports:

CONSTANT
FABCHKS
FABINCK
FABINVH
FARINTX
FARINVA
FARINVC
FBBBLIN
FBRAUDT
FFBADJH
FFBMAST
FFRADJA
FFRADJD
FFRFUSN
FFRMASA
FFRMASF
FFVACON
FFVACQM
FFVDISP
FFVSDAT
FFVTTST
FGBBAVL
FGBENCD
FGBENCH
FGBENCP
FGBGENL
FGBOPAL
FGBTRND
FGBTRNH
FNBDSTH
FNBUNTH
FNREUSN
FNRUCTR
FNVENDW
FNVPOOL
FNVSDAT
FOBTEXT
FPBPOHD
FPBRCDT
FPBRCHD
FPBRTRN
FPRAGRD
FPRBIDD
FPRPODA
FPRPODT
FPRPOTX
FPRRCDT
FPRREQD
FPRRTRN
FRBGBIL
FRBGRNT
FRBPROP
FRRBDET
FRRGLOC
FRRGRNL
FRRGRPI
FRRGUSN
FRRMEML
FRRPLOC
FRRPRPI
FRVBASI
FRVCFDA
FRVCSTA
FRVCSTD
FRVCSTR
FRVFUND
FRVINDA
FRVINDD
FRVINDR
FRVPMSC
FRVSDAT
FTRACTA
FTRACVA
FTRATTS
FTRATTV
FTRATYA
FTRFNDA
FTRFTYA
FTRLCNA
FTRORGA
FTRPRGA
FTVACCI
FTVACCT
FTVACTV
FTVASTY
FTVATTS
FTVATTT
FTVATYP
FTVBUYR
FTVCOAS
FTVCOMM
FTVDEPR
FTVDISC
FTVDTYP
FTVFMGR
FTVFOBS
FTVFSPD
FTVFSYR
FTVFTRM
FTVFTYP
FTVFUND
FTVLOCN
FTVOBPH
FTVOBUD
FTVORGN
FTVPCLS
FTVPROG
FTVPROJ
FTVRCMT
FTVRRSN
FTVRUCL
FTVSDAT
FTVSHIP
FTVTGRP
FTVTRAT
FTVUOMS
FTVVEND
FTVVENT
FTVVTYP
FUNCTION
NA


Ver: 8.1