ACCATSUM

Account Category Summary

This file maintains the summary account categories assigned to the category structure. This file is added and maintained via AC08.1 (Category Structure).

REFERENCED BY
AC20.1 AC20.2 AC20.3 AC20.4 AC20.5 AC20.6
AC20.7 AC40.1 AC40.4 AC41.1 AC41.4 AC42.1
AC45.4 AC46.1 ACAC.1 ACDR.1 AP125 AP126
AP131 AP170 AP193 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.7 AP21.1 AP23.1 AP25.1
AP25.2 AP26.1 AP27.1 AP30.2 AP30.4 AP520
API1.1 API2.1 BR00.2 BR00.3 BR02.3 BR122
BR123 BR41.1 BR41.4 BR420 BR43.1 BRIP.1
CB10.1 CB15.1 CB15.2 CB150 CB191 CB20.1
CB30.1 CB45.1 CB46.1 CB500 CB543 CB544
CB55.1 CB554 CX100 CX20.1 CX20.2 CX20.4
CX20.5 CX220 CX30.1 CX300 CX506 CXCP.1
EE11.1 EE135 EE20.3 EE35.1 EE35.2 EE520
GL146 GL165 GL170 GL197 GL40.1 GL40.2
GL40.3 GL40.7 GL40.8 GL44.1 GL45.1 GL70.1
GL70.2 GL70.3 GL70.5 GL70.6 GL75.1 GL76.1
DR100 IC140 IC66.1 IC83.1 EX545 IFEB.1
MA180 MA41.1 MA41.2 MA41.4 MA41.7 MA42.2
MA43.2 MA43.7 MA44.1 MA44.2 MA530 MA531
MA60.2 MA60.3 MA60.5 MA61.1 MA65.1 MA66.2
MA67.2 MA67.3 MA68.2 MA68.3 MA68.5 MA70.1
MA75.1 MA80.1 MAI1.1 PD10.1 PD10.2 PD130
PD20.1 PD20.2 PD20.3 PO100 PO101 PO122
PO131 PO136 PO150 PO190 PO20.1 PO20.6
PO20.9 PO21.1 PO21.2 PO21.3 PO21.4 PO21.5
PO22.1 PO22.3 PO22.4 PO23.1 PO24.1 PO25.1
PO25.5 PO25.6 PO25.7 PO26.2 PO26.3 PO26.4
PO26.5 PO26.6 PO26.7 PO26.9 PO27.2 PO28.2
PO29.1 PO30.1 PO30.2 PO30.3 PO30.4 PO300
PO31.1 PO31.2 PO32.2 PO32.4 PO33.1 PO34.1
PO35.1 PO36.1 PO36.2 PO38.1 PO39.1 PO39.2
PO44.1 PO50.1 PO52.1 PO520 PO536 PO54.5
POCP.1 POI3.1 POID.1 POIG.1 POII.1 POIJ.1
POIK.1 RQ10.1 RQ10.2 RQ10.4 RQ12.1 RQ13.1
RQ13.2 RQ35.1 RQ500 RQIF.1 WH130 WH132
WH190 WH20.2 WH20.7 WH222 WH30.1 WH30.2
WH30.3 WH30.4 WH31.1 WH31.2 WH31.3 WH31.4
WH32.1 WH32.2 WH32.3 WH32.4 WH32.5 WH33.1
WH33.2 WH33.3 WH33.4 WH33.5 WH33.6 WH33.8
WH33.9 WH34.1 WH34.2 WH34.3 WH34.4 WH40.1
WH40.2 WH520 WH830 ZW130 AC01.1 AC105
AC127 AC16.1 AC16.3 AC16.4 AC16.7 AC16.8
AC16.9 AC21.5 AC22.1 AC34.1 AC35.1 AC36.1
AC55.1 AC58.2 ACBC.1 ACDL.1 ACDM.2 ACDM.3
ATVW.1 BR01.1 BR01.2 BR03.1 BR03.2 BR03.3
BR18.2 BR254 SN02.1 AC208 AC05.1


UPDATED BY
AC08.1 AC08.2 AC08.3 AC08.4 AC08.5 AC08.6
AC08.7 AC108 AC112 AC113 AC120 AC121
AC123 AC128 AC135 AC145 AC147 AC160
AC165 AC169 AC190 AC191 AC196 AC197
AC198 AC200 AC203 AC206 AC207 AC210
AC213 AC218 AC220 AC225 AC240 AC246
AC247 AC256 AC261 AC265 AC290 AC295
AC297 AC298 AC30.3 AC310 AC311 AC32.1
AC346 AC400 AC401 AC410 AC412 AC420
AC421 AC440 AC460 AC471 AC472 AC473
AC480 AC490 AC493 AC494 AC527 AC558
AC580 AC583 AC708 AC90.1 AC90.2 AC90.4
AC90.6 AC90.8 AC92.1 AC92.2 AC92.4 AC92.6
AC93.1 AC93.2 AC93.4 AC94.1 AC94.2 AC94.4
AC94.6 AC95.1 AC97.1 AC97.2 SE90.1 AP211
ARLL.1 BR120 BR121 BR124 BR130 BR131
BR140 BR142 BR145 BR151 BR152 BR153
BR154 BR155 BR156 BR157 BR165 BR19.2
BR190 BR20.9 BR200 BR202 BR204 BR205
BR210 BR212 BR215 BR220 BR245 BR251
BR252 BR253 BR265 BR300 BR400 BR405
BR42.2 BR422 BR430 BR450 BR521 BR530
BR580 GL299 MX123 MX202 MX223 MX500

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
SRS-STRUCTURE
Element: Structure
Alpha 15
The name of the category structure.
AC08.1 AC08.4
AC08.6 AC558
SRS-SUM-ACCT-CAT
Element: Sum Acct Cat
Alpha 5
The name of the summary account category.
AC08.1 AC08.6
AC558
SRS-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
This field displays the description.
AC08.1 AC08.6
AC558
SRS-DEPTH
Element: Depth
Numeric 2
The level depth of the summary account category.
AC08.1 AC08.6
AC558
SRS-SEQ-NUMBER
Element: Seq Number
Numeric 6
The sequence number of the summary account category. Used to maintain the order of summary accounts within the category structure.
AC08.1 AC08.6
AC558
SRS-PARENT-SUM-CAT
Element: Parent Sum Cat
Alpha 5
Identifies the parent summary account category of summary account categories at a depth > 1. If a summary category is located at level 1, there will be no parent.
AC08.1 AC08.6
AC558
SRS-CATEGORY-TYPE
Element: Category Type
Alpha 1
The summary account category type controls the types of account categories that can be assigned to any summary account category. Valid types include: A - Accrual C - Costs P - Pass Thru R - Revenue F - Fee
R = Revenue
C = Cost
P = Pass Thru
A = Accrual
AC08.1 AC08.6
AC558
SRS-BUD-FLAG
Element: Bud Flag
Alpha 1
Budget edit flag for summary account categories.
D = Detail
N = No Edit
S = Summary
AC08.1 AC08.6
AC558
SRS-OBJ-ID
Element: Obj Id
Numeric 12
This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.
AC08.1 AC08.4
AC08.6 AC558
AC708
SRS-DETAIL
Element: Detail
Alpha 1
AC08.3 AC08.5
AC08.7 AC108
AC558 AC708


ACCATSUM FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
SRSSET1 STRUCTURE
SUM-ACCT-CAT
...
AC01.1 AC08.1
AC08.2 AC08.3
AC08.4 AC08.5
AC08.6 AC08.7
AC105 AC108
AC112 AC113
AC120 AC121
AC123 AC127
AC128 AC135
AC145 AC147
AC16.1 AC16.3
AC16.4 AC16.7
AC16.8 AC16.9
AC160 AC165
AC169 AC190
SRSSET2 STRUCTURE
CATEGORY-TYPE
SEQ-NUMBER
SUM-ACCT-CAT
KeyChange
AC08.1 AC08.6
AC208 AC295
AC297 AC400
AC410 AC420
AC480 AC494
AC90.1 AC90.2
AC90.4 AC90.6
AC90.8 AC92.1
AC92.2 AC92.4
AC92.6 AC94.1
AC94.2 AC94.4
AC94.6 AC97.2
ACBC.1
SRSSET3 SUM-ACCT-CAT
STRUCTURE
...
AC01.1 AC05.1
AC105 AC112
AC113 AC120
AC121 AC123
AC128 AC135
AC145 AC147
AC16.3 AC16.8
AC16.9 AC160
AC165 AC169
AC190 AC191
AC196 AC197
AC198 AC200
AC203 AC206
AC207 AC210
AC213 AC218
SRSSET4 OBJ-ID
STRUCTURE
SUM-ACCT-CAT
KeyChange
...
AC01.1 AC105
AC112 AC113
AC120 AC121
AC123 AC128
AC135 AC145
AC147 AC16.3
AC16.4 AC160
AC165 AC169
AC190 AC191
AC196 AC197
AC198 AC200
AC203 AC206
AC207 AC210
AC213 AC218
AC220 AC225


ACCATSUM FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Structure STRUCTURE Required
SRS-STRUCTURE->SRE-STRUCTURE


ACCATSUM FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Accatmxval ACCATMXVAL
SRS-OBJ-ID->AJB-OBJ-ID
  AJB-MATRIX-CAT
Accatmxvdt ACCATMXVDT
SRS-OBJ-ID->MXB-OBJ-ID
  MXB-MATRIX-CAT
  MXB-EFFECTIVE-DATE
Accatsumx ACCATSUMX
SRS-STRUCTURE->SRX-STRUCTURE
SRS-SUM-ACCT-CAT->SRX-SUM-ACCT-CAT
  SRX-ACCT-CATEGORY
Mxlistmbr MXLISTMBR
"ACCAT"->MLM-OBJ-TYPE
SRS-OBJ-ID->MLM-OBJ-ID
  MLM-MATRIX-LIST


File created: Thu Jun 09 11:03:58 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.