Lawson Insight Technical Documentation |
|
ACCATSUM
ACCATSUM FILE
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
AC01.1 AC105 AC112 AC113 AC120 AC121
AC123 AC127 AC128 AC135 AC145 AC16.1
AC16.3 AC16.4 AC16.7 AC16.8 AC16.9 AC160
AC165 AC169 AC190 AC191 AC197 AC198
AC20.1 AC20.2 AC20.3 AC20.4 AC20.5 AC20.6
AC20.7 AC200 AC203 AC206 AC207 AC210
AC213 AC218 AC22.1 AC220 AC225 AC240
AC246 AC256 AC261 AC265 AC290 AC295
AC298 AC30.3 AC310 AC32.1 AC34.1 AC346
AC35.1 AC36.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 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 ACAC.1 ACBC.1
ACDL.1 ACDM.2 ACDM.3 ACDR.1 ATVW.1 SE90.1
AP125 AP126 AP170 AP193 AP211 AP25.1
AP25.2 AP26.1 AP27.1 AP30.2 AP520 AR21.2
AR237 AR239 AR250 AR257 AR27.2 AR29.1
AR296 AR30.5 AR32.1 AR33.2 AR38.5 AR39.3
AR39.4 AR42.1 AR42.2 AR42.7 AR43.1 AR502
AR503 AR55.1 AR560 AR575 AR800 AR91.1
ARLL.1 BR00.2 BR00.3 BR01.1 BR01.2 BR02.3
BR03.1 BR03.2 BR03.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 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 MX123 MX500 MA65.1
POIG.1 SB515 SN02.1 AC208 AC05.1 BR124
BR42.2 MX202 MX223
UPDATED BY
AC08.1 AC08.2 AC08.3 AC08.4 AC08.5 AC08.6
AC08.7 AC108 AC558 AC708
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
SRS-STRUCTURE Alpha 15 AC08.1 AC08.4
Element: Structure The name of the category structure. AC08.6 AC558
SRS-SUM-ACCT-CAT Alpha 5 AC08.1 AC08.6
Element: Sum Acct Cat The name of the summary account AC558
category.
SRS-DESCRIPTION Alpha 30 (Lower Case) AC08.1 AC08.6
Element: Description This field displays the description. AC558
SRS-DEPTH Numeric 2 AC08.1 AC08.6
Element: Depth The level depth of the summary account AC558
category.
SRS-SEQ-NUMBER Numeric 6 AC08.1 AC08.6
Element: Seq Number The sequence number of the summary AC558
account category. Used to maintain the
order of summary accounts within the
category structure.
SRS-PARENT-SUM-CAT Alpha 5 AC08.1 AC08.6
Element: Parent Sum CatIdentifies the parent summary account AC558
category of summary account categories
at a depth > 1. If a summary category
is located at level 1, there will be no
parent.
SRS-CATEGORY-TYPE Alpha 1 AC08.1 AC08.6
Element: Category Type The summary account category type AC558
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
SRS-BUD-FLAG Alpha 1 AC08.1 AC08.6
Element: Bud Flag Budget edit flag for summary account AC558
categories.
D = Detail
N = No Edit
S = Summary
SRS-OBJ-ID Numeric 12 AC08.1 AC08.4
Element: Obj Id This is the object identifier. It is AC08.6 AC558
used to relate commitments or posted AC708
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.
SRS-DETAIL Alpha 1 AC08.3 AC08.5
Element: Detail AC08.7 AC108
AC558 AC708
ACCATSUM FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
SRSSET1 STRUCTURE AC01.1 AC08.1
SUM-ACCT-CAT AC08.2 AC08.3
AC08.4 AC08.5
AC08.6 AC08.7
AC105 AC108
AC112 AC113
AC120 AC121
AC123 AC127
AC128 AC135
AC145 AC16.1
AC16.3 AC16.4
AC16.7 AC16.8
AC16.9 AC160
AC165 AC169
AC190 AC191
...
SRSSET2 STRUCTURE KeyChange AC08.1 AC08.6
CATEGORY-TYPE AC208 AC400
SEQ-NUMBER AC410 AC494
SUM-ACCT-CAT 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 ACBC.1
SRSSET3 SUM-ACCT-CAT AC01.1 AC05.1
STRUCTURE AC105 AC112
AC113 AC120
AC121 AC123
AC128 AC135
AC145 AC16.3
AC16.8 AC16.9
AC160 AC165
AC169 AC190
AC191 AC197
AC198 AC200
AC203 AC206
AC207 AC210
AC213 AC218
AC220 AC225
...
SRSSET4 OBJ-ID KeyChange AC01.1 AC105
STRUCTURE AC112 AC113
SUM-ACCT-CAT AC120 AC121
AC123 AC128
AC135 AC145
AC16.3 AC16.4
AC160 AC165
AC169 AC190
AC191 AC197
AC198 AC200
AC203 AC206
AC207 AC210
AC213 AC218
AC220 AC225
AC240 AC246
...
ACCATSUM FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Structure STRUCTURE Required
SRS-STRUCTURE -> SRE-STRUCTURE
ACCATSUM FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME 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
|