TABLES BY CATEGORY
AFNS
BASE SYSTEM TABLE NAMES
|
TABLE
CODE
|
CAS
ONLY* |
|
CHART OF ACCOUNTS TABLES: |
|
|
|
ACTIVITY |
ACT2
|
|
|
ACTIVITY INDEX |
ACTV
|
|
|
ACTIVITY ALLOCATION |
AALL
|
|
|
ACTIVITY CATEGORY |
ACAT
|
|
|
ACTIVITY CLASS |
ACLS
|
|
|
ACTIVITY GROUP |
AGRP
|
|
|
ACTIVITY TYPE |
ATYP
|
|
|
AGENCY |
AGC2
|
|
|
AGENCY INDEX |
AGCY
|
|
|
AGENCY ACCOUNT |
AACT
|
|
|
AGENCY CATEGORY |
AGCT
|
|
|
AGENCY CLASS |
AGCL
|
|
|
AGENCY GROUP |
AGGP
|
|
|
AGENCY TYPE |
AGTP
|
|
|
BALANCE SHEET ACCOUNT |
BAC2
|
|
|
BALANCE SHEET ACCOUNT INDEX |
BACC
|
|
|
BALANCE SHEET CATEGORY |
BCAT
|
|
|
BALANCE SHEET CLASS |
BCLS
|
|
|
BALANCE SHEET GROUP |
BGRP
|
|
|
FUNCTION |
FUNC
|
|
|
FUNCTION CATEGORY |
FCCA
|
|
|
FUNCTION CLASS |
FCCL
|
|
|
FUNCTION GROUP |
FCGR
|
|
|
FUNCTION TYPE |
FCTP
|
|
|
FUND |
FUN2
|
|
|
FUND INDEX |
FUND
|
|
|
FUND AGENCY |
FGY2
|
|
|
FUND AGENCY INDEX |
FAGY
|
|
|
FUND CATEGORY |
FCAT
|
|
|
FUND CLASS |
FCLS
|
|
|
FUND GROUP |
FDGP
|
|
|
FUND TYPE |
FTYP
|
|
|
GENERAL REPORTING CATEGORY |
GRPT
|
|
|
OBJECT |
OBJ2
|
|
|
OBJECT INDEX |
OBJT
|
|
|
OBJECT CATEGORY |
OCAT
|
|
|
OBJECT CLASS |
OCLS
|
|
|
OBJECT GROUP |
OGRP
|
|
|
OBJECT TYPE |
OTYP
|
|
AFNS
BASE SYSTEM TABLE NAMES
|
TABLE
CODE
|
CAS
ONLY* |
|
CHART OF ACCOUNTS TABLES (CONT’D): |
|
|
|
ORGANIZATION |
ORG2
|
|
|
ORGANIZATION INDEX |
ORGN
|
|
|
REVENUE CATEGORY |
RCAT
|
|
|
REVENUE CLASS |
RCLS
|
|
|
REVENUE GROUP |
RGRP
|
|
|
REVENUE SOURCE |
RSR2
|
|
|
REVENUE SOURCE INDEX |
RSRC
|
|
|
REVENUE TYPE |
RTYP
|
|
|
SUB-OBJECT |
SOBJ
|
|
|
SUB-ORGANIZATION |
SORG
|
|
|
SUB-REVENUE SOURCE |
SREV
|
|
|
BUDGETARY TABLES: |
|
|
|
ALLOTMENT INQUIRY |
ALLT
|
|
|
ALLOTMENT INQUIRY (EXTENDED) |
EALL
|
*
|
|
APPROPRIATION INQUIRY |
APP2
|
|
|
APPROPRIATION INDEX |
APPR
|
|
|
APPROPRIATION INQUIRY (EXTENDED) |
EAP2
|
*
|
|
APPROPRIATION INDEX (EXTENDED) |
EAPP
|
*
|
|
APPROPRIATION SUMMARY INQUIRY |
ASUM
|
|
|
BALANCE SHEET ACCOUNT BALANCE |
BBAL
|
|
|
EXPENSE BUDGET DETAIL INQUIRY |
EXPD
|
|
|
EXPENSE BUDGET DETAIL INQUIRY (EXTENDED) |
EEXD
|
*
|
|
EXPENSE BUDGET INQUIRY |
EXP2
|
|
|
EXPENSE BUDGET INDEX |
EXPB
|
|
|
EXPENSE BUDGET INQUIRY (EXTENDED) |
EEX2
|
*
|
|
EXPENSE BUDGET INDEX (EXTENDED) |
EEXP
|
*
|
|
EXPENSE BUDGET SUMMARY INQUIRY |
ESUM
|
|
|
EXPENSE BUDGET SUMMARY INQUIRY (EXTENDED) |
EESM
|
*
|
|
FUND BALANCE |
FBAL
|
|
|
OBLIGATION PLAN INQUIRY |
OBPL
|
*
|
|
REVENUE BUDGET INQUIRY |
REV2
|
|
|
REVENUE BUDGET INDEX |
REVB
|
|
|
REVENUE BUDGET REPORT SUMMARY INQUIRY |
RSUM
|