• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
Enterprise Data Warehouse
Logo, Texas A&M University System, Office of Information Technology
  • Home
  • About
    • Governance
    • Security
      • Quarterly User Review Process
      • Quarterly User Review Form
      • Authorized Security Requesters
  • Documentation
  • Report Inventory
    • All Commonly Used Reports
    • Reports Grouped by Process
  • Universes
    • HCM Universes
    • Financial Universes
    • Payroll Universes
    • Historic BPP Universes
  • Training
  • Data Status
    • Academic Data Status
    • Budget Load Status
    • Data Load Status
    • Payroll Data Status
  • Office of Information Technology
    • Services
    • Contact the Office of Information Technology
    • Search OIT
Home / Universes / Financial Universes / Financial Account Transaction Detail

Financial Account Transaction Detail

Purpose

The purpose of the Financial Account Transaction Detail Universe is to provide access to the detail financial transactions that occur in FAMIS. These detail transactions are commonly found on “Screen 23” in FAMIS.

Grain

A record is kept in this universe for every detail transaction record that occurs in FAMIS. Just as in FAMIS, for journal entries and budget transfers, two transactions are kept – one for each side of the transaction.

Since the data in this universe has a record (row) for every transaction detail record, data in this universe can be reported by Bank and Vendor. These dimensions are not available with the regular SL-SA account summary.

Measures

This universe provides four measures. In FAMIS, all transaction amounts are placed in single “amount” column. However, for this universe, the amount on the FAMIS transaction has been placed in the appropriate measure “bucket” based on the transaction code. The measure are:

  • Budget – Amounts from FAMIS transactions with a T-code = ’02X’
  • Actuals – Amounts from FAMIS transactions with a T-code = ’03X’ or ’04X’ or ’06X’
  • Encumbrances – Amounts from FAMIS transactions with a T-code = ’05X’. Encumbrances also include liquidations amounts that are reference on 04X and 06X transactions
  • Begin Bal (098) – Amounts from FAMIS transactions with a T-code of ‘098’

Revenues, Expenses, Fund Additions, Deductions, and Balance Sheet items

Please note that this universe contains transactions against SL’s and GL’s and also against all the subcode types. Most likely you will be reporting on only one of these types. Please be sure to limit your query to your scope.

Also note that revenues, fund additions, fund balances and liabilities are all kept a POSITIVE number. This is different from FAMIS.

Filters

Filters are predefined limiting criteria that allow you to select a subset of the data in the universe. This universe has the following filters defined:

  • Non-Voucher Transactions – Includes only transactions that DID NOT originate from the FAMIS AP system. Excludes transactions 046, 047, 048, and 068 and also budget and encumbrance transactions.
  • Voucher Transactions – Includes only transactions that originated from the FAMIS AP system. Includes only Transactions 046, 047, 048, and 068.
  • Revenue – Includes only Revenue Subcodes from SL accounts (0001 – 0999)
  • Expense – Includes only Expense Subcodes from SL accounts (1000 – 9999)
  • Non Zero Actuals – Includes only transactions where the measure “Actuals” is not zero. Effectively excludes Budget and encumbrance transactions.

Dimensions

This universe contains links to the following dimensions. Any attribute in these dimensions can be used to sort, filter, subset, or include on the report or graph.

  • Time
  • Member
  • Organization
  • Account Attributes
  • GL Account Attributes
  • Subcode / Category
  • Sponsor
  • Vendor
  • Bank Attributes

Primary Sidebar

Related

  • Financial Budget Detail
  • Financial Fixed Assets
  • Financial GL Account Snapshot
  • Financial SL-GL Balances
  • Financial SL-GL Combined
  • Financial SL-SA Account Summary
  • Financial Voucher
  • Financial Account Transaction Detail

Copyright © 2025 Texas A&M University System All rights reserved.

301 Tarrow Street, College Station, TX 77840 | MAP | Phone: (979) 458-7700 | email: support@tamus.edu
State of Texas | Texas Homeland Security | Texas Veterans Portal | Statewide Search | Risk, Fraud & Misconduct Hotline | Privacy | Web Accessibility | State Link Policy | Campus Carry

Texas A&M University System