Skip to Page Content
section image picture

Access Services

Query Tables for Financial Accounting

(follow this link to additional Accounting Query Information)

Table Name  (Owner.Name)

Content

QUERY.ACC_ACCOUNT

Account Number, Effective Dates, Associated Descriptions

QUERY.ACC_ACCOUNT_CURR

Account Number, Name, and Associated Descriptions for the Current Fiscal Year

QUERY.ACC_ACCOUNT_NEXT

Account Number, Name, and Associated Descriptions for the Next Fiscal Year

QUERY.ACC_ACCOUNT_ORG

Similar to QUERY.ACC_ACCOUNT, but also includesUGA Organizational Structure Information for the current fiscal year

QUERY.ACC_ACCOUNT_PREV

Account Number, Name, and Associated Descriptions for the Previous Fiscal Year

QUERY.ACC_ACCOUNTING_ME

Most recently completed Accounting Period date information (month-end dates)

QUERY.ACC_ACCOUNTING_PD

Accounting Period (YYYYMM), Associated Dates, Fiscal Year

QUERY.ACC_ACTUAL_TRANS

Account Number, Fiscal Year, Budgeted (Summary) Object Code, Detail Object Code, Accounting Period (YYYYMMnn), Transaction Reference Numbers, Amounts, and Descriptive Information

QUERY.ACC_DEPARTMENT

Department Number and Name

QUERY.ACC_DETAIL_OBJECT

Account Number, Fiscal Year, Budgeted (Summary) Object Code, Detail Object Code, Actual Revenue/Expense, Encumbrance

QUERY.ACC_DTLOBJ_HISTORY

Account Number, Accounting Period (YYYYMM), Fiscal Year, Budgeted (Summary) Object Code, Detail Object Code, Encumbrance and Actual Amounts 

QUERY.ACC_OBJECT_CURR

Object Code and Associated Descriptions for the Current Fiscal Year

QUERY.ACC_OBJECT_NEXT

Object Code and Associated Descriptions for the Next Fiscal Year

QUERY.ACC_OBJECT_PREV

Object Code and Associated Descriptions for the Previous Fiscal Year

QUERY.ACC_OPEN_ENCUMBER

Account Number, Fiscal Year, Budgeted (Summary) Object Code, Detail Object Code, Encumbrance Reference Numbers, Dates, Amounts, and Descriptive Information

QUERY.ACC_STAFFBEN_DED

Staff Benefits Deduction Information:  SSN, Name, Pay Type, Date, Payroll Account and Object, Deduction, Staff Benefits Account and Object, Employer Contribution

QUERY.ACC_SUM_OBJ_ORG

Similar to QUERY.ACC_SUMMARY_OBJECT, but
     1) does not include asset, liability, and reserve object codes,
     2) does include UGA Organizational Structure Information

QUERY.ACC_SUMMARY_OBJECT

Account Number, Fiscal Year, Budgeted (Summary) Object Code, Budget, Actual Revenue/Expense, Encumbrance, Budget Balance

QUERY.ACC_SUMOBJ_HISTORY

Account Number, Accounting Period (YYYYMM), Fiscal Year, Budgeted (Summary) Object Code, Budget, Encumbrance, and Actual Amounts 

QUERY.AP_VENDOR

Accounts Payable Vendor Number, Name, and Address