| Reporting View | Description | Key & Frequency | Recommended 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 | | |