RETURN TO 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.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_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
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.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.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.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, ACCOUNT
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, PROGRAM
CHART_OF_ACCOUNTS, ORGANIZATION_CODE
CHART_OF_ACCOUNTS, FUND
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).CHART_OF_ACCOUNTS, ACCOUNT
BUDGET_IDENTIFIER, BUDGET_PHASE, CHART_OF_ACCOUNTS, FUND, ORGANIZATION_CODE, ACCOUNT, PROGRAM, ACTIVITY, LOCATION
CHART_OF_ACCOUNTS, LOCATION
CHART_OF_ACCOUNTS, PROGRAM
CHART_OF_ACCOUNTS, ORGANIZATION_CODE
CHART_OF_ACCOUNTS, FUND
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.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_ACCOUNTING
Contains encumbrance document number, item, sequence number, accounting distirbution, and encumbrance status for the financial commitment.One row per encumbrance document number per item per sequence number.ENCUMBRANCE_NUMBER, ITEM, SEQUENCE_NUMBER
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 encumbance document number per item per sequence number for each fiscal year and period.ENCUMBRANCE_NUMBER, ITEM, SEQUENCE_NUMBER, FISCAL_YEAR, FISCAL_PERIOD
ENCUMBRANCE_TEXT
Contains text lines associated with general encumbrances. One row per encumbrance document number per each line of text.
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.CHART_OF_ACCOUNTS, FUND
CHART_OF_ACCOUNTS, ENDOWMENT_POOL, FUND
DOCUMENT_NUMBER, SUBMISSION_NUMBER, CHART_OF_ACCOUNTS, 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.CHART_OF_ACCOUNTS, FUND
ENTITY_UID
CHART_OF_ACCOUNTS, ENDOWMENT_POOL, 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.ORIGINATION_TAG_NUMBER
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.CHART_OF_ACCOUNTS, ACCOUNT
CHART_OF_ACCOUNTS, LOCATION
CHART_OF_ACCOUNTS, PROGRAM
CHART_OF_ACCOUNTS, FUND
ORIGINATION_TAG_NUMBER
ORIGINATION_TAG_NUMBER, SEQUENCE_NUMBER
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_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.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.CHART_OF_ACCOUNTS, ACCOUNT
CHART_OF_ACCOUNTS, LOCATION
CHART_OF_ACCOUNTS, PROGRAM
ORIGINATION_TAG_NUMBER, SEQUENCE_NUMBER
CHART_OF_ACCOUNTS, ORGANIZATION_CODE
CHART_OF_ACCOUNTS, FUND
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.ORIGINATION_TAG_NUMBER
GRANT_ID
PERSON_UID
FIXED_ASSET_TEXT
Contains text lines associated with fixed asset items.One row per fixed asset item per each line of text.ENTITY_UID
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, 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_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.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, ACCOUNT
FISCAL_YEAR, FISCAL_PERIOD, CHART_OF_ACCOUNTS, FUND, 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
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
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.CHART_OF_ACCOUNTS, ACCOUNT
CHART_OF_ACCOUNTS, FUND
CHART_OF_ACCOUNTS, LOCATION
CHART_OF_ACCOUNTS, ORGANIZATION_CODE
CHART_OF_ACCOUNTS, PROGRAM
GRANT_ID
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
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
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 hierachy 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, ORGANIZATION_CODE
AGENCY_UID
AGENCY_UID_LEVEL_1
AGENCY_UID_LEVEL_2
AGENCY_UID_LEVEL_3
AGENCY_UID_LEVEL_4
GRANT_ID
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.ADDRESS_TYPE
INVOICE
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.CHART_OF_ACCOUNTS, ACCOUNT
CHART_OF_ACCOUNTS, FUND
CHART_OF_ACCOUNTS, LOCATION
CHART_OF_ACCOUNTS, ORGANIZATION_CODE
CHART_OF_ACCOUNTS, PROGRAM
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.INVOICE, CHECK_NUMBER, BANK
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_TAX_RATE
Contains tax rates, amounts, and rebates as it relates to the invoice at an item or 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_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 and item. One row per invoice per item listing up to 8 tax rates for each item.INVOICE, ITEM
ACTIVITY_DATE
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.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
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, ACCOUNT
CHART_OF_ACCOUNTS, LOCATION
CHART_OF_ACCOUNTS, FISCAL_YEAR, FISCAL_PERIOD, FUND, ORGANIZATION_CODE, ACCOUNT, PROGRAM, ACTIVITY, LOCATION
CHART_OF_ACCOUNTS, PROGRAM
CHART_OF_ACCOUNTS, ORGANIZATION_CODE
CHART_OF_ACCOUNTS, FUND
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.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
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.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
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
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_SUMMARY
Contains received purchase order item summary information.One row per purchase order per item received.PURCHASE_ORDER, ITEM
PURCHASE_ORDER_TAX_RATE
Contains current tax rates and amounts for each purchase order item. TThis 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
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
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
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
CHART_OF_ACCOUNTS, FUND
CHART_OF_ACCOUNTS, LOCATION
CHART_OF_ACCOUNTS, ORGANIZATION_CODE
CHART_OF_ACCOUNTS, PROGRAM
CHART_OF_ACCOUNTS, ACCOUNT_INDEX
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_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:

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
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
FTVDTYP
FTVFMGR
FTVFOBS
FTVFTRM
FTVFTYP
FTVFUND
FTVLOCN
FTVOBPH
FTVOBUD
FTVORGN
FTVPROG
FTVPROJ
FTVRCMT
FTVRRSN
FTVRUCL
FTVSDAT
FTVSHIP
FTVTGRP
FTVTRAT
FTVUOMS
FTVVEND
FTVVENT
FTVVTYP


Ver: 3.1