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


Finance Reporting View Meta Data Reports

Target Reports:

Reporting ViewDescriptionKey & FrequencyRecommended Search Columns
ACCOUNT_ATTRIBUTES
Contains a list of all the set codes, attribute types, attribute values, and attribute values begin and end date associated with an account.One row per chart of accounts per account code per attribute type per attribute value per set code.VALUE
CHART_OF_ACCOUNTS, ACCOUNT, ATTRIBUTE_TYPE, ATTRIBUTE_VALUE
ATTRIBUTE_TYPE, ATTRIBUTE_VALUE, CHART_OF_ACCOUNTS
ACCOUNT_HIERARCHY
Contains a list of all general ledger and operating ledger accounts with associated hierarchy levels, account type, internal account type, account class and account pool. Used to support roll up reporting.One row per chart of accounts per account.CHART_OF_ACCOUNTS, ACCOUNT
ACCOUNT_HIERARCHY_FISCAL
Contains a list of all general ledger and operating ledger accounts with associated hierarchy levels, account type, internal account type, account class and account pool. Used to support roll up reporting by fiscal year and fiscal period.One row per chart of accounts per account per fiscal year per fiscal period.CHART_OF_ACCOUNTS, FISCAL_YEAR, FISCAL_PERIOD, ACCOUNT
ACCOUNT_INDEX
Contains a list of all account index codes with their associated chart of accounts, effective dates, next change dates, fund codes, organization codes, account codes, program codes, activity codes, location codes, and override indicators.One row per chart of accounts per account index per effective date per next change date.CHART_OF_ACCOUNTS, ACCOUNT_INDEX, EFFECTIVE_DATE
CHART_OF_ACCOUNTS, ORGANIZATION_CODE
CHART_OF_ACCOUNTS, PROGRAM
CHART_OF_ACCOUNTS, FUND
CHART_OF_ACCOUNTS, LOCATION
ACCOUNT_TYPE_ATTRIBUTES
Contains a list of all the set codes, attribute types, attribute values, and attribute values begin and end date, associated with an account type code.One row per chart of accounts per account type code per attribute type per attribute value per set code.VALUE
CHART_OF_ACCOUNTS, ACCOUNT_TYPE, ATTRIBUTE_TYPE, ATTRIBUTE_VALUE
ATTRIBUTE_TYPE, ATTRIBUTE_VALUE, CHART_OF_ACCOUNTS
ACTIVITY_ATTRIBUTES
Contains a list of all the set codes, attribute types, attribute values, and attribute values begin and end date associated with an activity code.One row per chart of accounts per activity code per attribute type per attribute value per set code.VALUE
CHART_OF_ACCOUNTS, ACTIVITY, ATTRIBUTE_TYPE, ATTRIBUTE_VALUE
ATTRIBUTE_TYPE, ATTRIBUTE_VALUE, CHART_OF_ACCOUNTS
ATTRIBUTE_SETS
Contains a list of all the set codes, attribute types, attribute values, and attribute values begin and end date associated with a chart of accounts code.One row per chart of accounts per set code per attribute type per attribute value.VALUE
CHART_OF_ACCOUNTS, SET_CODE, ATTRIBUTE_TYPE, ATTRIBUTE_VALUE
ATTRIBUTE_TYPE, ATTRIBUTE_VALUE, CHART_OF_ACCOUNTS
BUDGET_AVAILABILITY_LEDGER
Contains summary and current amounts for adopted budget, budget adjustments, encumbrances, budget reservations, and remaining balances by budget control keys of fund, organization code, account, and program for a fiscal year and period. Additional reporting can be by financial manager or the various hierarchy levels of the fund, organization code, account, and program.One row per chart of accounts per fiscal year and period per fund per organization code per account per program per commitment type.CHART_OF_ACCOUNTS, FISCAL_YEAR
FISCAL_PERIOD
CHART_OF_ACCOUNTS, ORGANIZATION_CODE
CHART_OF_ACCOUNTS, PROGRAM
CHART_OF_ACCOUNTS, FISCAL_YEAR, FISCAL_PERIOD, FUND, ORGANIZATION_CODE, ACCOUNT, PROGRAM
CHART_OF_ACCOUNTS, FISCAL_YEAR, FUND, ORGANIZATION_CODE, ACCOUNT, PROGRAM, FISCAL_PERIOD, COMMITMENT_TYPE
CHART_OF_ACCOUNTS, FUND
CHART_OF_ACCOUNTS, ACCOUNT
BUDGET_DETAIL
Contains budget detail for a selected accounting distribution combination by budget id and budget phase. Additional reporting can be at the various hierarchy levels for fund, organization code, account, program and location.One row per budget ID per budget phase per budgeted line item ( chart of accounts, fund, organization code, account, program, activity, location).BUDGET_IDENTIFIER, BUDGET_PHASE, CHART_OF_ACCOUNTS, FUND, ORGANIZATION_CODE, ACCOUNT, PROGRAM, ACTIVITY, LOCATION
CHART_OF_ACCOUNTS, ORGANIZATION_CODE
CHART_OF_ACCOUNTS, PROGRAM
CHART_OF_ACCOUNTS, FUND
CHART_OF_ACCOUNTS, ACCOUNT
CHART_OF_ACCOUNTS, LOCATION
BUDGET_REQUEST_TEXT
Contains text lines associated with budget line item requests.One row per budget line item per each line of text.BUDGET_LINE_ITEM_ID
CHART_ATTRIBUTES
Contains a list of all the attribute types, attribute values, and attribute values begin and end date associated with a chart of accounts code.One row per chart of accounts per attribute type per attribute value.VALUE
CHART_OF_ACCOUNTS, ATTRIBUTE_TYPE, ATTRIBUTE_VALUE
ATTRIBUTE_TYPE, ATTRIBUTE_VALUE, CHART_OF_ACCOUNTS
ENCUMBRANCE
Contains encumbrance document number, type of encumbrance, encumbrance status, encumbrance posted date, encumbrance last change document, completion indicator, and approval indicator for the financial commitment.One row per encumbrance document number.ENCUMBRANCE_NUMBER
ENCUMBRANCE_TYPE
ENCUMBRANCE_ACCOUNTING
Contains encumbrance document number, item, sequence number, accounting distribution, and encumbrance status for the financial commitment.One row per encumbrance document number per item per sequence number.ENCUMBRANCE_NUMBER, ITEM, SEQUENCE_NUMBER
CHART_OF_ACCOUNTS, FISCAL_YEAR, FUND, ORGANIZATION_CODE
CHART_OF_ACCOUNTS, ORGANIZATION_CODE
CHART_OF_ACCOUNTS, PROGRAM
CHART_OF_ACCOUNTS, FUND
CHART_OF_ACCOUNTS, ACCOUNT
CHART_OF_ACCOUNTS, LOCATION
ENCUMBRANCE_LEDGER
Contains encumbrance ledger posted amounts for initial commitments, current adjustments, and current liquidations by fiscal year and period for each individual encumbrance document number and accounting distribution.One row per encumbrance document number per item per sequence number for each fiscal year and period.ENCUMBRANCE_NUMBER, ITEM, SEQUENCE_NUMBER, FISCAL_YEAR, FISCAL_PERIOD
FISCAL_YEAR, FISCAL_PERIOD
ENCUMBRANCE_TEXT
Contains text lines associated with general encumbrances. .One row per encumbrance document number per each line of text.ENCUMBRANCE_NUMBER
ENDOWMENT_ATTRIBUTES
Contains endowment user defined attributes assigned to an endowment fund used to meet external and or internal reporting requirements.One row per chart of accounts per endowment fund per attribute table per attribute value.CHART_OF_ACCOUNTS, FUND
ENDOWMENT_DISTRIBUTION
Contains historical distributed spendable income for endowments. Additional reporting by income accounting distribution, unrealized gain and loss accounting distribution, and gain and loss accounting distribution with each of their distribution frequencies.One row per document number per submission number per chart of accounts per endowment fund.DOCUMENT_NUMBER, SUBMISSION_NUMBER, CHART_OF_ACCOUNTS, FUND
CHART_OF_ACCOUNTS, FUND
CHART_OF_ACCOUNTS, ENDOWMENT_POOL, FUND
INCOME_CR_CHART, INCOME_CR_FUND
ENDOWMENT_SUMMARIZED_UNITS
Contains summarized purchased endowment units and book value for each endowment fund within a pool that had purchased units during the unitization period. An aggregation of the purchased endowment units and book value is represented from the first unitzation period to the reportable unitization period along with its current market value and market purchase unit price.One row per chart of accounts per endowment pool per endowment fund per unitization period end date.CHART_OF_ACCOUNTS, FUND
CHART_OF_ACCOUNTS, ENDOWMENT_POOL
CHART_OF_ACCOUNTS, ENDOWMENT_POOL, FUND
ENDOWMENT_UNITS
Contains gifts that were added to endowed funds at the document level and unitized.One row per chart of accounts per endowment pool per endowment fund per organization code per account per program per unitization period end date.VALUE
CHART_OF_ACCOUNTS, FUND
ENTITY_UID
CHART_OF_ACCOUNTS, ENDOWMENT_POOL, FUND
INCOME_CR_CHART, INCOME_CR_FUND
FIXED_ASSET_ACCOUNTING_HISTORY
Contains historical detail of the accounting impact by any adjustment or depreciation to a fixed asset including the original capitalization and or depreciation accounting as well as any adjustment amounts. .One row per fixed asset origination tag, per change sequence number, per sequence number.VALUE
ORIGINATION_TAG_NUMBER, SEQUENCE_NUMBER
FIXED_ASSET_ACCOUNTING_SOURCE
Contains current detail of the accounting impact by the last adjustment or depreciation to a fixed asset listing all accounting element columns. Additional reporting can be by financial manager or the various hierarchy levels of the depreciation fund, organization code, account, program and location. .One row per fixed asset origination tag number, per sequence number.VALUE
ORIGINATION_TAG_NUMBER, SEQUENCE_NUMBER
CHART_OF_ACCOUNTS, PROGRAM
CHART_OF_ACCOUNTS, FUND
CHART_OF_ACCOUNTS, LOCATION
CHART_OF_ACCOUNTS, ACCOUNT
FIXED_ASSET_ADJUSTMENT
Contains all asset adjustments information by adjustment document number. This includes the type of adjustment, depreciation adjustment date, transaction date, disposal, net book value amount, fiscal year, fiscal period, transaction amount, distribution percent, transaction amount, and transaction amount adjusted.One row per adjustment document number per item number per sequence number per accounting sequence number.DOCUMENT, ACCOUNT_ITEM, SEQUENCE_NUMBER, ACCOUNTING_SEQUENCE_NUMBER
ORIGINATION_TAG_NUMBER
FIXED_ASSET_ADJUSTMENT_TEXT
Contains text lines associated with fixed asset adjustment documents.One row per document number per each line of text.DOCUMENT, SEQUENCE_NUMBER
FIXED_ASSET_ATTRIBUTES
Contains asset item user defined values used to meet external and or internal reporting requirements.One row per fixed asset item per attribute table per attribute value.VALUE
ORIGINATION_TAG_NUMBER
FIXED_ASSET_DEPRECIATED_ITEM
Contains asset depreciation controls and summarized information like depreciation start date, asset type, useful life, remaining useful life, depreciation method, depreciation frequency, last depreciation date, depreciation amounts (total, net, old), and salvage amount.One row per asset origination tag number.ORIGINATION_TAG_NUMBER
FIXED_ASSET_FUNDING_SOURCE
Contains funding source accounting distribution information at the time the fixed asset item was acquired as well as an original document tag number if used. Additional reporting can be by financial manager and or the various hierarchy levels of the fund, organization code, account, program, and location.One row per fixed asset origination tag number per sequence number.ORIGINATION_TAG_NUMBER, SEQUENCE_NUMBER
SUBORDINATE_TAG_NUMBER
CHART_OF_ACCOUNTS, PROGRAM
CHART_OF_ACCOUNTS, ORGANIZATION_CODE
CHART_OF_ACCOUNTS, FUND
CHART_OF_ACCOUNTS, LOCATION
CHART_OF_ACCOUNTS, ACCOUNT
FIXED_ASSET_ITEM
Contains general information about the fixed asset item including acquisition details and current values such as capitalization date, capitalization amount, last adjustment date, asset type, asset description, normal useful life, various amounts, disposal method, disposal date, purchase order, invoice, vendor name, transfer date, chart of accounts, responsible organization code, responsible location, responsible person name, and grant.One row per fixed asset origination tag number.PERSON_UID
ORIGINATION_TAG_NUMBER
GRANT_ID
FIXED_ASSET_TEXT
Contains text lines associated with fixed asset items.One row per fixed asset item per each line of text.ORIGINATION_TAG_NUMBER
FOAPAL_NO_ATTRIBUTES
Contains a list of all accounting distribution elements that are not associated with a set code, or an attribute type, and/or an attribute value. This is used for exception reporting to assist in attaching reporting attributes to the various accounting distribution elements.One row per chart of accounts per accounting distribution element.CHART_OF_ACCOUNTS
FUND_ATTRIBUTES
Contains a list of all the set codes, attribute types, attribute values, and attribute values begin and end date associated with a fund.One row per chart of accounts per fund code per attribute type per attribute value per set code.CHART_OF_ACCOUNTS, FUND, ATTRIBUTE_TYPE, ATTRIBUTE_VALUE
ATTRIBUTE_TYPE, ATTRIBUTE_VALUE, CHART_OF_ACCOUNTS
FUND_HIERARCHY
Contains a list of all funds with associated hierarchy levels, fund type, internal fund type, fund pool, financial manager, termination date, and expenditure end dates. Used to support roll up reporting.One row per chart of accounts per fund.CHART_OF_ACCOUNTS
CHART_OF_ACCOUNTS, FUND
FUND_HIERARCHY_FISCAL
Contains a list of all funds with associated hierarchy levels, fund type, internal fund type, fund pool, financial manager, termination date, and expenditure end dates. Used to support roll up reporting by fiscal year and fiscal period.One row per chart of accounts per fund per fiscal year per fiscal period.CHART_OF_ACCOUNTS, FISCAL_YEAR, FISCAL_PERIOD
CHART_OF_ACCOUNTS, FISCAL_YEAR, FISCAL_PERIOD, FUND
FUND_TEXT
Contains text lines associated with a fund.One row per fund per line of text. Note: This is not chart specific because of the way SCT Banner has designed this table. Thus, multi-chart environments cannot show the fund description as the description cannot be extracted without a chart of accounts.FUND
FUND_TYPE_ATTRIBUTES
Contains a list of all the set codes, attribute types, attribute values, and attribute values begin and end date associated with a fund type.One row per chart of accounts per fund type code per attribute type per attribute value per set code.VALUE
CHART_OF_ACCOUNTS, FUND_TYPE, ATTRIBUTE_TYPE, ATTRIBUTE_VALUE
ATTRIBUTE_TYPE, ATTRIBUTE_VALUE, CHART_OF_ACCOUNTS
GENERAL_LEDGER
Contains general ledger account/fund information for each fiscal year and period with period beginning and ending balances, and current actuals. Additional reporting can be by financial manager or the various hierarchy levels of the fund and account.One row per chart of accounts per fiscal year per fund per account per fiscal period.CHART_OF_ACCOUNTS, FISCAL_YEAR
FISCAL_PERIOD
CHART_OF_ACCOUNTS, FISCAL_YEAR, FISCAL_PERIOD, FUND, ACCOUNT
CHART_OF_ACCOUNTS, ACCOUNT
CHART_OF_ACCOUNTS, FUND
GRANT_APPLIED_PAYMENTS
Contains grant billing details for payments that have been applied against charges. Reporting can be by grant or letter or credit, various dates, payment transaction number, charge transaction number, posting document, post cashier session, and withholding information.Multiple rows per grant ID per payment transaction number.GRANT_ID, ACCOUNT_TRANSACTION_NUMBER
APPLIED_GRANT_ID
GRANT_ATTRIBUTES
Contains grant user defined values used to meet external and or internal reporting requirements.One row per grant ID per attribute table per attribute value.GRANT_ID, ATTRIBUTE_TABLE
GRANT_BILLING_DETAIL
Contains details for billed and unbilled grant transactions. Reporting can be by grant, letter of credit, payment management system code, billing account distribution or document key, billing period date, and billing run and hold or release dates.One row per document per document type per sequence number per item per submission number per fund per account class per account per reversal indicator.BILL_DOCUMENT, BILL_DOCUMENT_TYPE, BILL_SEQUENCE_NUMBER, BILL_ITEM, BILL_SUBMISSION_NUMBER, BILL_REVERSAL_IND, ACCOUNT_CLASS, BILL_FUND, BILL_ACCOUNT
BILL_GRANT_ID
BILL_STATUS, BILL_GRANT_ID
GRANT_ID
CHART_OF_ACCOUNTS
CHART_OF_ACCOUNTS, FUND
CHART_OF_ACCOUNTS, ACCOUNT
GRANT_DEFERRED_COST
Contains details behind the postings for grant deferred costs of indirect cost, cost share and revenue. The source document information and posting document information that supports the calculations of the costs.Multiple rows per grant ID.CHART_OF_ACCOUNTS, LOCATION
CHART_OF_ACCOUNTS, ORGANIZATION_CODE
CHART_OF_ACCOUNTS, PROGRAM
CHART_OF_ACCOUNTS, ACCOUNT_INDEX
CHART_OF_ACCOUNTS, FUND
GRANT_ID
GRANT_EVENT
Contains information about grant events and the data used to construct the event for a grant such as billing requirements or reminders associated with a grant. Reportable fields are event type and frequency, start and end date for generated events, number of days for a reminder notice, billing format, payment method and person responsible for the first grant event status period.One row per grant ID per grant event.GRANT_ID
GRANT_ID, GRANT_EVENT
GRANT_EVENT_STATUS
Contains information about grant event periods and their statuses. Reportable fields are event type, event due date, event status and status date, person responsible for the event, and person who approved the event.One row per grant ID per grant event per grant event sequence number.GRANT_ID
GRANT_ID, GRANT_EVENT
GRANT_ID, GRANT_EVENT, EVENT_SEQUENCE_NUMBER
RESPONSIBLE_PERSON_UID
GRANT_FUND
Contains all fund information associated to a grant as well as the general grant information. Multiple funds can be associated to one grant at any one point in time and/or over a period of time. Also lists grant indirect cost and cost share codes versus fund indirect cost and cost share codes.One row per grant ID per chart of accounts per fund.CHART_OF_ACCOUNTS, FUND
GRANT_ID, CHART_OF_ACCOUNTS, FUND
AGENCY_UID
CHART_OF_ACCOUNTS, ORGANIZATION_CODE
GRANT_FUND_SLOT
Uses data from the GRANT_FUND reporting view. Displays up to 10 fund codes assigned to a grant listed in order of descending termination date.One row per grant ID.GRANT_ID
ACTIVITY_DATE
GRANT_LEDGER
Contains grant ledger information representing inception to date amounts as well as current period amounts for adopted budgets, budget adjustments, actual activity, encumbrances, budget reservations, and remaining balance for each unique combination of accounting distribution. Additional reporting can be by financial manager or the various hierarchy levels of the fund, organization code, account, program, and location.One row per chart of accounts per grant ID per grant year per grant period per fund per organization code per account per program per activity per location.GRANT_ID
CHART_OF_ACCOUNTS, ORGANIZATION_CODE
CHART_OF_ACCOUNTS, PROGRAM
CHART_OF_ACCOUNTS, FUND
CHART_OF_ACCOUNTS, ACCOUNT
CHART_OF_ACCOUNTS, LOCATION
CHART_OF_ACCOUNTS, FISCAL_YEAR
FISCAL_PERIOD
CHART_OF_ACCOUNTS, GRANT_YEAR, GRANT_PERIOD, GRANT_ID, FUND, ORGANIZATION_CODE, ACCOUNT, PROGRAM, ACTIVITY, LOCATION
CHART_OF_ACCOUNTS, FISCAL_YEAR, FISCAL_PERIOD, FUND, ORGANIZATION_CODE, ACCOUNT, PROGRAM, ACTIVITY, LOCATION
CHART_OF_ACCOUNTS, GRANT_ID
GRANT_PERSONNEL
Contains information about personnel associated to the grant, each person's contact information.One row per grant ID per personnel type per personnel UID.PHONE_SEQ_NUMBER
PHONE_TYPE, PHONE_SEQ_NUMBER
ADDRESS_TYPE
GRANT_ID
CHART_OF_ACCOUNTS
GRANT_ID, PERSONNEL_TYPE, PERSONNEL_UID
PERSONNEL_UID, GRANT_ID
GRANT_RECEIVABLE_ACCT_DETAIL
Contains detail receivable account transaction information for all grant charges and payments. .One row per grant ID per transaction number.GRANT_ID, ACCOUNT_TRANSACTION_NUMBER
CHART_OF_ACCOUNTS, FUND
GRANT_TEXT
Contains text lines associated with a grant.One row per grant ID per each line of text.GRANT_ID
GRANT_VIEW
Contains information defining the grant itself. The principal investigator, federal ID, sponsor number, agency and agency information with hierarchy data, various amounts, responsible organization with hierarchy data, various dates, letter of credit number, payment management system code, location, type of grant, indirect cost and cost share codes.One row per grant ID.CHART_OF_ACCOUNTS, RESPONSIBLE_ORGANIZATION_CODE
CHART_OF_ACCOUNTS, LOCATION
GRANT_ID
AGENCY_UID
AGENCY_UID_LEVEL_1
AGENCY_UID_LEVEL_2
AGENCY_UID_LEVEL_3
AGENCY_UID_LEVEL_4
INVOICE
Contains general invoice and vendor information including invoice type, purchase order, vendor, vendor invoice number, third party information, one time vendor information, invoice date, payment due date, transaction date, cancel date, open paid indicator, and total approved amount.One row per invoice.INVOICE
ADDRESS_TYPE
INVOICE_ACCOUNTING
Contains general invoice accounting data including, purchase order, fiscal year/period, accounting distribution, bank, and approved amount. Additional reporting can be by financial manager or the various hierarchy levels of the fund, organization code, account, program, and location.One row per invoice per item per sequence number.INVOICE, ITEM, SEQUENCE_NUMBER
CHART_OF_ACCOUNTS, FISCAL_YEAR, FISCAL_PERIOD
CHART_OF_ACCOUNTS, ORGANIZATION_CODE
CHART_OF_ACCOUNTS, PROGRAM
CHART_OF_ACCOUNTS, FUND
CHART_OF_ACCOUNTS, ACCOUNT
CHART_OF_ACCOUNTS, LOCATION
INVOICE_ACCOUNTING_TAX_RATE
Contains tax rates, amounts, and rebates as it relates to the invoice accounting level. This includes who the tax should be paid to.One row per invoice per item per sequence number per tax rate.INVOICE, ITEM, SEQUENCE_NUMBER
INVOICE_CHECK
Contains check payment information for each invoice including bank information, check type, check date, check net amount, cancel indicator, cancel date, and reconciliation date.One row for invoice per check number per bank.CHECK_NUMBER, BANK
INVOICE, CHECK_NUMBER, BANK
INVOICE_ITEM
Contains invoice items with purchase order, and commodity information. This includes each base and converted amount for unit price, taxes, discounts and additional charges as well as approved quantity.One row per invoice per invoice item.INVOICE, ITEM
INVOICE_ITEM_ACCOUNTING
Contains general invoice commodity level accounting data including, purchase order, fiscal year/period, accounting distribution, bank, and approved amount. Additional reporting can be by financial manager or the various hierarchy levels of the fund, organization code, account, program, and location.One invoice per item per sequence numberINVOICE, ITEM, SEQUENCE_NUMBER
CHART_OF_ACCOUNTS, FISCAL_YEAR, FISCAL_PERIOD
CHART_OF_ACCOUNTS, LOCATION
CHART_OF_ACCOUNTS, ORGANIZATION_CODE
CHART_OF_ACCOUNTS, PROGRAM
CHART_OF_ACCOUNTS, ACCOUNT
CHART_OF_ACCOUNTS, FUND
INVOICE_TAX_RATE
Contains tax rates, amounts, and rebates as it relates to the invoice item level. This includes who the tax should be paid to.One row per invoice per item per per tax rate.INVOICE, ITEM
INVOICE_TAX_RATE_SLOT
Uses data from the INVOICE_TAX_RATE reporting view. Displays the last 8 tax rates, amounts and rebates applied to each invoice item.One row per invoice per item listing up to 8 tax rates for each item.INVOICE, ITEM
ACTIVITY_DATE
INVOICE_TEXT
Contains text lines associated with invoices.One row per document number per each line of text.INVOICE
JOURNAL_VOUCHER_TEXT
Contains text lines associated with journal entries.One row per document number per each line of text.DOCUMENT
LOCATION_ATTRIBUTES
Contains a list of all the set codes, attribute types, attribute values, and attribute values begin and end date associated with a location.One row per chart of accounts per location code per attribute type per attribute value per set code.VALUE
CHART_OF_ACCOUNTS, LOCATION, ATTRIBUTE_TYPE, ATTRIBUTE_VALUE
ATTRIBUTE_TYPE, ATTRIBUTE_VALUE, CHART_OF_ACCOUNTS
LOCATION_HIERARCHY
Contains a list of all locations with associated hierarchy levels. Used to support roll up reporting.One row per chart of accounts per location.CHART_OF_ACCOUNTS, LOCATION
LOCATION_HIERARCHY_FISCAL
Contains a list of all locations with associated hierarchy levels. Used to support roll up reporting by fiscal year and fiscal period.One row per chart of accounts per location per fiscal year per fiscal period.CHART_OF_ACCOUNTS, FISCAL_YEAR, FISCAL_PERIOD, LOCATION
OPERATING_LEDGER
Contains summary and current amounts for adopted budget, budget adjustments, encumbrances, budget reservations, and remaining balances by accounting distribution for a fiscal year and period. Additional reporting can be by financial manager or the various hierarchy levels of the fund, organization code, account, program and location.One row per chart of accounts per fiscal year per fiscal period per fund per organization code per account per program per activity per location per commitment type. CHART_OF_ACCOUNTS, FISCAL_YEAR
FISCAL_PERIOD
CHART_OF_ACCOUNTS, PROGRAM
CHART_OF_ACCOUNTS, ORGANIZATION_CODE
CHART_OF_ACCOUNTS, FUND
CHART_OF_ACCOUNTS, LOCATION
CHART_OF_ACCOUNTS, FISCAL_YEAR, FISCAL_PERIOD, FUND, ORGANIZATION_CODE, ACCOUNT, PROGRAM, ACTIVITY, LOCATION
CHART_OF_ACCOUNTS, ACCOUNT
ORGANIZATION_ATTRIBUTES
Contains a list of all the set codes, attribute types, attribute values, and attribute values begin and end date associated with an organization code.One row per chart of accounts per organization code per attribute type per attribute value per set code.VALUE
CHART_OF_ACCOUNTS, ORGANIZATION_CODE, ATTRIBUTE_TYPE, ATTRIBUTE_VALUE
ATTRIBUTE_TYPE, ATTRIBUTE_VALUE, CHART_OF_ACCOUNTS
ORGANIZATION_HIERARCHY
Contains a list of all organization codes with associated hierarchy levels, organization pool, and financial manager. Used to support roll up reporting.One row per chart of accounts per organization code.CHART_OF_ACCOUNTS, ORGANIZATION_CODE
ORGANIZATION_HIERARCHY_FISCAL
Contains a list of all organization codes with associated hierarchy levels, organization pool, and financial manager. Used to support roll up reporting by fiscal year and fiscal period.One row per chart of accounts per organization code per fiscal year per fiscal period.CHART_OF_ACCOUNTS, FISCAL_YEAR, FISCAL_PERIOD, ORGANIZATION_CODE
PROGRAM_ATTRIBUTES
Contains a list of all the set codes, attribute types, attribute values, and attribute values begin and end date associated with a program.One row per chart of accounts per program per attribute type per attribute value per set code.VALUE
CHART_OF_ACCOUNTS, PROGRAM, ATTRIBUTE_TYPE, ATTRIBUTE_VALUE
ATTRIBUTE_TYPE, ATTRIBUTE_VALUE, CHART_OF_ACCOUNTS
PROGRAM_HIERARCHY
Contains a list of all programs with associated hierarchy levels. Used to support roll up reporting.One row per chart of accounts per program.CHART_OF_ACCOUNTS, PROGRAM
PROGRAM_HIERARCHY_FISCAL
Contains a list of all programs with associated hierarchy levels. Used to support roll up reporting by fiscal year and fiscal period.One row per chart of accounts per program per fiscal year per fiscal period.CHART_OF_ACCOUNTS, FISCAL_YEAR, FISCAL_PERIOD, PROGRAM
PROPOSAL
Contains proposal pre-award and grant award information. The principal investigator information, agency and agency information with hierarchy data, submission date, award/decline date, and responsible organization code.One row per grant proposal.CHART_OF_ACCOUNTS, ORGANIZATION_CODE
AGENCY_UID
AGENCY_UID_LEVEL_1
AGENCY_UID_LEVEL_2
AGENCY_UID_LEVEL_3
AGENCY_UID_LEVEL_4
GRANT_ID
PROPOSAL_CODE
PROPOSAL_TEXT
Contains text lines associated with grant proposals.One row per document number per each line of text.PROPOSAL_CODE
PURCHASE_ORDER
Contains current general purchase order and vendor information including type of purchase order, transaction date, vendor, buyer, organization hierarchy, shipping address, and blanket order information.One row per purchase order.CHART_OF_ACCOUNTS, ORGANIZATION_CODE
PURCHASE_ORDER
PURCHASE_ORDER_ACCOUNTING
Contains current general purchase order accounting data including fiscal year/period, accounting distribution, and amounts. Additional reporting can be by financial manager or the various hierarchy levels of the fund, organization code, account, program, and location.One row per purchase order per item per sequence number.CHART_OF_ACCOUNTS, ACCOUNT
CHART_OF_ACCOUNTS, FUND
CHART_OF_ACCOUNTS, LOCATION
CHART_OF_ACCOUNTS, ORGANIZATION_CODE
CHART_OF_ACCOUNTS, PROGRAM
PURCHASE_ORDER, ITEM, SEQUENCE_NUMBER
PURCHASE_ORDER_ITEM
Contains current purchase order items with commodity information. This includes the requisition, bid, and each base and converted amount for unit price, taxes, discounts, and additional charges as well as quantity.One row per purchase order per item.PURCHASE_ORDER, ITEM
PURCHASE_ORDER_ITEM_ACCOUNTING
Contains current general purchase order commodity level accounting data including fiscal year/period, accounting distribution, and amounts. Additional reporting can be by financial manager or the various hierarchy levels of the fund, organization code, account, program, and location.One purchase order per item per sequence numberCHART_OF_ACCOUNTS, LOCATION
CHART_OF_ACCOUNTS, ORGANIZATION_CODE
PURCHASE_ORDER, ITEM, SEQUENCE_NUMBER
CHART_OF_ACCOUNTS, PROGRAM
CHART_OF_ACCOUNTS, ACCOUNT
CHART_OF_ACCOUNTS, FUND
PURCHASE_ORDER_ITEM_SUMMARY
Contains received purchase order item summary information.One row per purchase order per item received.PURCHASE_ORDER, ITEM
PURCHASE_ORDER_ITEM_TEXT
Contains text lines associated with purchase order items.One row per document number per item per each line of text.CLAUSE, CLAUSE_SEQUENCE_NUMBER
PURCHASE_ORDER_TAX_RATE
Contains current tax rates and amounts for each purchase order item. This includes who the tax should be paid to.One row per purchase order per item per priority per tax rate.PURCHASE_ORDER, ITEM, PRIORITY, TAX_RATE
PURCHASE_ORDER_TEXT
Contains text lines associated with purchase orders.One row per document number per each line of text.CLAUSE, CLAUSE_SEQUENCE_NUMBER
RECEIVED_ITEM
Contains received purchase order item information including packing slip, receiving method, carrier, received date, quantity received, and quantity rejected.One row per receiver document per packing slip per purchase order per item.RECEIVER_DOCUMENT, PURCHASE_ORDER, PACKING_SLIP_KEY, ITEM
PURCHASE_ORDER, ITEM
RECEIVED_DATE
COMMODITY
RETURN_DOCUMENT, PURCHASE_ORDER, ITEM, RETURN_SEQUENCE_NUMBER
RETURN_REASON
RECEIVED_ITEM_TEXT
Contains text lines associated with purchase order received items.One row per document number per each line of text.DOCUMENT
RETURNED_ITEM
Contains returned purchase order item information.One row per returned document per returned document sequence number.RETURN_DOCUMENT, PURCHASE_ORDER, ITEM, RETURN_SEQUENCE_NUMBER
PURCHASE_ORDER, ITEM
VENDOR_UID, RETURN_REASON
RETURN_REASON
COMMODITY
RETURNED_ITEM_TEXT
Contains text lines associated with purchase order returns.One row per document number per each line of text.DOCUMENT
TRANSACTION_HISTORY
Contains source transaction accounting distirbution history and ledger posting detail information. This includes the type of document, ledger indicator, which ledger field updated, rule process, rule class, document reference number, bank, vendor, budget period, and accounting distribution. Additional reporting can be by financial manager or the various hierarchy levels of the fund, organization code, account, program, and location. Used to reconcile the various ledgers and provide detail financial activity.Multiple rows for each source financial transaction.CHART_OF_ACCOUNTS, ACCOUNT_INDEX
CHART_OF_ACCOUNTS, ORGANIZATION_CODE
CHART_OF_ACCOUNTS, PROGRAM
CHART_OF_ACCOUNTS, FUND
CHART_OF_ACCOUNTS, LOCATION
DOCUMENT, DOCUMENT_TYPE, SUBMISSION_NUMBER, ITEM, SEQUENCE_NUMBER, SERIAL_NUMBER, REVERSAL_IND, LEDGER_IND
CHART_OF_ACCOUNTS, FISCAL_YEAR, LEDGER_IND, POSTING_PERIOD, FUND, ORGANIZATION_CODE, ACCOUNT, PROGRAM, ACTIVITY, LOCATION, TRANSACTION_DATE
ENCUMBRANCE_NUMBER, ENCUMBRANCE_ITEM_NUMBER, ENCUMBRANCE_SEQ_NUMBER, LEDGER_IND
CHART_OF_ACCOUNTS, FISCAL_YEAR, LEDGER_IND, POSTING_PERIOD, ACCOUNT_INDEX, TRANSACTION_DATE
CHART_OF_ACCOUNTS, FISCAL_YEAR, LEDGER_IND, POSTING_PERIOD, FIELD_CODE, FUND, ACCOUNT, ORGANIZATION_CODE, ACTUAL_FUND_TYPE_LEVEL_2
CHART_OF_ACCOUNTS, FISCAL_YEAR, LEDGER_IND, POSTING_PERIOD, DETAIL_POSTING_PROCESS, RULE_CLASS, BANK
CHART_OF_ACCOUNTS, FISCAL_YEAR, ACTIVITY_DATE, LEDGER_IND, DETAIL_USER_ID
CHART_OF_ACCOUNTS, FISCAL_YEAR, TRANSACTION_DATE
FISCAL_YEAR_HEADER, TRANSACTION_DATE, CHART_OF_ACCOUNTS
VENDOR
Contains vendor maintenance information including ID, name, contact name, federal tax indicator, federal tax ID number, order/remittance addresses and phone numbers.One row per vendor.ADDRESS_TYPE
PHONE_TYPE
VENDOR_UID
VENDOR_TAXABLE_REPORTING
Contains taxable income paid to a vendor that is reportable to a federal government such as tax id, name, address, reportable amount, income type, souce of income document, check number, bank, any monies withheld for federal or state.One row per vendor uid per vendor tax id per tax year per check number per bank code per document.VENDOR_UID
TAX_YEAR, VENDOR_UID
TAX_YEAR, PAYER_TAX_ID
VENDOR_UID, VENDOR_TAX_ID, TAX_YEAR, CHECK_NUMBER, BANK, DOCUMENT, PAYER_TAX_ID
VENDOR_TEXT
Contains text lines associated with vendors.One row per vendor per each line of text.VENDOR_UID
VENDOR_TYPE
Contains a list of all associated vendor types for the vendor.One row per vendor per vendor type.VENDOR_UID
VENDOR_TYPE, VENDOR_UID

Source Reports:

FAB1099
FABBKTP
FABCHKS
FABINCK
FABINVH
FABRUIV
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
FOB1099
FOBCLAU
FOBTEXT
FORCLAU
FPBPOHD
FPBRCDT
FPBRCHD
FPBRTRN
FPRAGRD
FPRBIDD
FPRPODA
FPRPODT
FPRPOTX
FPRRCDT
FPRREQD
FPRRTRN
FRBEVNG
FRBGBIL
FRBGRNT
FRBPROP
FRRBDET
FRREVNG
FRRGLOC
FRRGRNH
FRRGRNL
FRRGRPI
FRRGUSN
FRRMEML
FRRPLOC
FRRPRPI
FRVBASI
FRVBFRM
FRVCFDA
FRVCSTA
FRVCSTD
FRVCSTR
FRVEVNT
FRVFUND
FRVINDA
FRVINDD
FRVINDR
FRVPMSC
FRVSDAT
FTRACTA
FTRACVA
FTRATTS
FTRATTV
FTRATYA
FTRFNDA
FTRFTYA
FTRLCNA
FTRORGA
FTRPRGA
FTVACCI
FTVACCT
FTVACTL
FTVACTV
FTVASTY
FTVATTS
FTVATTT
FTVATYP
FTVBUYR
FTVCOAS
FTVCOMM
FTVCTYP
FTVDEPR
FTVDISC
FTVDTYP
FTVFMGR
FTVFOBS
FTVFSPD
FTVFSYR
FTVFTRM
FTVFTYP
FTVFUND
FTVHRSN
FTVITYP
FTVLOCN
FTVOBPH
FTVOBUD
FTVORGN
FTVPCLS
FTVPROG
FTVPROJ
FTVRCMT
FTVRRSN
FTVRUCL
FTVSDAT
FTVSHIP
FTVTGRP
FTVTRAT
FTVUOMS
FTVVEND
FTVVENT
FTVVTYP
FUNCTION
NA
SPRADDR
SPRIDEN
STVCNTY
STVNATN
STVSTAT


Ver: 9.2