Even if a data element has been selected in the prior step an entry does not

Even if a data element has been selected in the prior

This preview shows page 24 - 27 out of 38 pages.

Last Updated: 11/02/2006 Page 24 of 38
Image of page 24
Financial Data Warehouse Training Guide Ledger Data Extracts The Budget Ledger Extracts are run against the budget ledger data for any month or sequence of months in the current or a prior fiscal year. Data elements included in the extract are selected by the user from a list of values. Possible elements include the agency, the account type, the fund, the fiscal period, the transaction line description, the organization, the object code, the posting date, the transaction amount, the transaction code and/or the transaction number. Many additional data elements are available. Those listed are the default values. Last Updated: 11/02/2006 Page 25 of 38
Image of page 25
Financial Data Warehouse Training Guide Data elements that may be used as search criteria include the fund, the agency, the organization, and the account type as the default search criteria elements. Additional search elements include the appropriation unit, the budget year, the transaction line description, the object code, the posting date, the revenue source code, the transaction amount, the transaction code, the transaction date, and/or the transaction number. The General Ledger Extracts are run against the general ledger data for any month or sequence of months in the current or a prior fiscal year. Data elements included in the extract are selected by the user from a list of values. Possible elements include the agency, account type, the fund, the fiscal period, the transaction line description, the organization, the object code, posting date, sub-object code, the transaction amount, the transaction code, the transaction number, the vendor name, and the vendor number. Many additional data elements are available. Those listed are the default values. Data elements that may be used as search criteria include the fund, the agency, the organization, and the account type as the default search criteria elements. Additional elements include the activity code, the appropriation unit, the balance sheet account, the budget year, the transaction line description, the object code, the posting date, the reference transaction code, the reference transaction number, the revenue source code, the sub-object, the sub-revenue source code, the transaction amount, the transaction code, the transaction date, the transaction number, the vendor name, and/or the vendor number. Many other data elements are available. Fixed Assets Custom Query Fixed Assets Custom Query is designed to provide an easy, intuitive method to select data elements to include in an extract, enter various search criteria, extract the data in a format that is compatible with Microsoft EXCEL, and download the extract to your PC.
Image of page 26
Image of page 27

You've reached the end of your free preview.

Want to read all 38 pages?

  • Spring '18
  • Dr. Moez
  • Fiscal Year, Purchase order

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture