|
Financial Information Systems |
| a division of Enterprise Information Technology Services | |
Mrs. Sharon Burch, Interim Director
(706) 542-5305
Query Table - QUERY.ACC_ACTUAL_TRANS
| Column Name | Definition |
|---|---|
| ACCOUNT | Account Number |
| FUND | Fund Group Number |
| FUNCTION | Function Number |
| OPERATION | Operation Code |
| ACTIVITY | Activity Code |
| DEPARTMENT | Department Number |
| PROJECT | Project Number |
| FISCAL_YEAR | Fiscal Year (4 digits; FY 1999-2000 represented by 2000) |
| SUMMARY_OBJECT | Summary/Budgeted Object Code (Revenue or Expenditure) |
| DETAIL_OBJECT | Detail Object Code (Revenue or Expenditure) |
| ACCOUNTING_PERIOD | Calendar Year/Month (and optional sequence number) defining the Accounting Period (YYYYMMnn) |
| TRANSACTION_TYPE | Transaction Type Code |
| TRAN_TYPE_DESC | Transaction Type Description |
| REFERENCE_NUMBER | Transaction Document Reference Number |
| SEQUENCE_NUMBER | System-generated suffix appended to Reference Number to ensure uniqueness |
| ENCUMBRANCE_TYPE | Encumbrance Type Code: P=Purchase T=Travel H=Honorarium |
| ENCUMBRANCE_NUMBER | Encumbrance Document Number |
| ENCUMBRANCE_DETAIL | Alphabetic suffix appended to Encumbrance Number to support the association of multiple funding accounts or multiple recommended vendors |
| CHECK NUMBER | Accounts Payable Check Number (for payment transactions) |
| TRANSACTION_DESC | Transaction Description |
| TRANSACTION_DATE | Transaction Date (MM/DD/YYYY or YYYY-MM-DD) |
| GROSS_AMOUNT | Gross amount of Accounts Payable Check (before discount applied) |
| PER_DIEM | Unused; originally intended to flag payments associated with Per Diem reporting |
| EQUIPMENT_OBJECT | For transactions associated with liability accounts, the equipment object associated with the original (benefiting) account BEFORE it became a liability |
| DISCOUNT_AMOUNT | Discount associated with Accounts Payable Check (reduces Gross) |
| TRANSACTION_AMOUNT | Transaction Amount OR Net Amount of Accounts Payable Check (Gross minus Discount) |
| VENDOR_NUMBER | Vendor Number associated with Accounts Payable transaction |
| VENDOR_ADDRESS | Suffix appended to Vendor Number to support multiple "pay to" address requirements |
| VENDOR_INVOICE | Identifying reference number associated with Accounts Payable Vendor Invoice |
| TRAVEL_DSTRBN_SSN | Social Security Number of employee associated with Travel expenditure |
| PURCHASE_AUTHORITY | Delegated Purchase Authority Code assigned by Procurement to classify purchase payments for reporting |
| PURCHASE_AUTH_DESC | Delegated Purchase Authority Description classifying a purchase payment |
| BLANKET_PO | Code identifying a payment associated with a Blanket Purchase Order |
| BLANKET_PO_DESC | Characterization of Blanket Purchase |
| PAYMENT_TYPE | Code identifying the type of payment: Encumbered vs. Unencumbered Partial vs. Final Purchase vs. Travel vs. Honorarium |
| PAYMENT_TYPE_DESC | Payment Type Description |
| FREE_BAL_OVERRIDE | Code used to override the "free balance test" and authorize payment despite a lack of available funds in the associated account |
| FREE_BAL_OVER_DESC | Description of the "free balance test" specification |
| LEASE_PERIOD | Code identifying the period (month) associated with a lease payment |
| PAYMENT_LOCATION | Code used to identify the geographic location associated with a payment |
| PAYMENT_LOC_DESC | Description of the geographic location associated with a payment |
| PHYSICAL_PLANT_WO | Work Order Number associated with a Physical Plant-related transaction |
| PHYSICAL_PLANT_JV | Code used to specify the purpose of the Physical Plant Journal Voucher to the Cost Accounting system |
| PHYSICAL_PLANT_CC | Code identifying the Physical Plant Cost Center (Shop) associated with the transaction |
| BATCH_NUMBER | Identifying number used to group related transactions as they were recorded by the system |
| BATCH_SUFFIX | Suffix appended to Batch Number to ensure uniqueness |
| FREE_BAL_OVER_RSN | Code used to specify the reason for exercising the "free balance override" option |
| FB_OVER_RSN_DESC | Description of the reason for exercising the "free balance override" option |
| ACCOUNT_DESC | Account Description or Name |
| FUND_DESC | Fund Group Number Description |
| FUNC_ACTIVITY_DESC | Function/Activity Description |
| OPERATION_DESC | Operation Code Description |
| DEPARTMENT_DESC | Department Description or Name |
| PROJECT_DESC | Project Description or Name |
| AGENCY | Sponsoring Agency Code |
| AGENCY_DESC | Sponsoring Agency Description or Name |
| COLLEGE_DESC | College Description or Name |
| MAJ_FUNCTION_DESC | Major Function Type Description |
| FUND_BAL_FUND_NO | Fund Balance Fund Group Number for Restricted (Sponsored) Accounts |
| Access Services Enterprise Information Technology Services The University of Georgia |