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
AC00.1 AC00.2 AC00.3 AC01.1 AC02.1 AC05.2
AC05.3 AC05.1 AC10.1 AC105 AC112 AC113
AC120 AC121 AC123 AC127 AC128 AC130
AC135 AC145 AC147 AC16.1 AC16.3 AC16.4
AC16.7 AC16.8 AC16.9 AC160 AC165 AC169
AC190 AC191 AC196 AC197 AC198 AC20.1
AC20.2 AC20.3 AC20.4 AC20.5 AC20.6 AC20.7
AC200 AC203 AC206 AC207 AC208 AC21.5
AC210 AC213 AC218 AC22.1 AC220 AC225
AC240 AC246 AC247 AC256 AC261 AC265
AC290 AC297 AC298 AC30.3 AC310 AC311
AC32.1 AC34.1 AC346 AC35.1 AC36.1 AC37.1
AC40.1 AC40.4 AC400 AC401 AC41.1 AC41.4
AC410 AC412 AC42.1 AC420 AC421 AC440
AC45.4 AC46.1 AC460 AC471 AC472 AC473
AC480 AC490 AC493 AC494 AC527 AC540
AC55.1 AC58.2 AC580 AC583 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 AC95.2 AC95.4 AC95.6
AC97.1 AC97.2 AC97.4 AC97.6 ACAC.1 ACBC.1
ACBD.2 ACDL.1 ACDM.2 ACDM.3 ACDR.1 ACVW.1
ATVW.1 SE90.1 AP125 AP126 AP131 AP170
AP193 AP20.1 AP20.2 AP20.3 AP20.4 AP20.5
AP20.7 AP21.1 AP211 AP23.1 AP25.1 AP25.2
AP26.1 AP27.1 AP30.2 AP30.4 AP510 AP520
API1.1 API2.1 ARLL.1 BR02.3 BR120 BR121
BR122 BR123 BR130 BR131 BR140 BR142
BR145 BR151 BR152 BR153 BR154 BR155
BR156 BR157 BR165 BR18.2 BR19.2 BR190
BR20.1 BR20.2 BR20.3 BR20.4 BR20.5 BR20.9
BR200 BR202 BR204 BR205 BR210 BR212
BR215 BR220 BR245 BR251 BR252 BR253
BR254 BR265 BR300 BR400 BR405 BR41.1
BR41.4 BR420 BR422 BR43.1 BR430 BR450
BR521 BR530 BR580 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 GL299 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
IC12.1 IC140 IC141 IC142 IC145 IC243
IC330 IC64.1 IC64.2 IC64.3 IC64.4 IC64.5
IC64.6 IC64.7 IC64.8 IC64.9 IC66.1 IC83.1
EX545 IFEB.1 MX123 MX500 MA180 MA278
MA41.1 MA41.2 MA41.4 MA41.7 MA42.2 MA43.2
MA43.7 MA44.1 MA44.2 MA53.1 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 PD570 PO04.1 PO04.2
PO10.1 PO10.2 PO100 PO101 PO115 PO120
PO122 PO131 PO132 PO136 PO15.1 PO15.2
PO15.4 PO150 PO17.1 PO190 PO20.1 PO20.6
PO20.9 PO204 PO21.1 PO21.2 PO21.3 PO21.4
PO21.5 PO22.1 PO22.3 PO22.4 PO220 PO222
PO224 PO225 PO229 PO23.1 PO230 PO234
PO24.1 PO25.1 PO25.5 PO25.6 PO25.7 PO251
PO26.2 PO26.3 PO26.4 PO26.5 PO26.6 PO26.7
PO26.9 PO27.2 PO27.3 PO27.4 PO275 PO276
PO277 PO28.2 PO280 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 RQ01.1 RQ10.1
RQ10.2 RQ10.3 RQ10.4 RQ10.5 RQ11.1 RQ12.1
RQ13.1 RQ13.2 RQ35.1 RQ44.1 RQ500 RQ810
RQIB.1 RQIF.1 RQII.1 RQIJ.1 SN02.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 BR124 BR42.2
MX202 MX223


UPDATED BY
AC08.1 AC08.2 AC08.3 AC08.4 AC08.5 AC08.6
AC08.7 AC108 AC558 AC708 AC295 BR00.2
BR00.3 BR01.1 BR01.2 BR03.1 BR03.2 BR03.3

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
...
AC00.1 AC00.2
AC00.3 AC01.1
AC02.1 AC05.2
AC05.3 AC08.1
AC08.2 AC08.3
AC08.4 AC08.5
AC08.6 AC08.7
AC10.1 AC105
AC108 AC112
AC113 AC120
AC121 AC123
AC127 AC128
AC130 AC135
AC145 AC147
AC16.1 AC16.3
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
Acctsumbod ACCTSUMBOD Not Required, Delete Cascades
SRS-STRUCTURE->YAF-STRUCTURE
SRS-SUM-ACCT-CAT->YAF-SUM-ACCT-CAT
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 02:02:54 2016

Home
Contact Us



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