Campus Wide Access | Enterprise Information Technology Services

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