ACCATSUM – Account Category Summary

System
Activity Management (AC)
Prefix
SRS
Primary key
STRUCTURE, SUM-ACCT-CAT
Fields
10
Updated by
18 programs
Referenced by
470 programs

ACCATSUM is the Account Category Summary table in Lawson Activity Management (prefix SRS). It is indexed by STRUCTURE, SUM-ACCT-CAT (SRSSET1); alternate indexes: SRSSET2, SRSSET3 and SRSSET4. It is related 1:1 to ACCTSUMBOD and STRUCTURE and 1:M to ACCATMXVAL, ACCATMXVDT, ACCATSUMX and MXLISTMBR. It is updated by AC08.1, AC08.2, AC08.3, AC08.4, AC08.5, AC08.6, AC08.7, AC108 and 10 more and referenced by AC00.1, AC00.2, AC00.3, AC01.1, AC02.1, AC05.1, AC05.2, AC05.3 and 462 more. The table has 10 fields, 4 indexes and 6 documented relations.

About ACCATSUM

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

Fields (10)

Column = COBOL field name without the SRS- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#SRS-STRUCTURE PK
STRUCTURE		Alpha 15The name of the category structure.AC08.1, AC08.4, AC08.6, AC558
#SRS-SUM-ACCT-CAT PK
SUM_ACCT_CAT		Alpha 5The name of the summary account category.AC08.1, AC08.6, AC558
#SRS-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)This field displays the description.AC08.1, AC08.6, AC558
#SRS-DEPTH
DEPTH		Numeric 2The level depth of the summary account category.AC08.1, AC08.6, AC558
#SRS-SEQ-NUMBER SET2
SEQ_NUMBER		Numeric 6The 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
PARENT_SUM_CAT		Alpha 5Identifies 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 SET2
CATEGORY_TYPE		Alpha 1The 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
BUD_FLAG		Alpha 1Budget edit flag for summary account categories.
  • D Detail
  • N No Edit
  • S Summary
AC08.1, AC08.6, AC558
#SRS-OBJ-ID SET4
OBJ_ID		Numeric 12This 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
DETAIL		Alpha 1—AC08.3, AC08.5, AC08.7, AC108, AC558, AC708

Indexes (4)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
SRSSET1
  1. STRUCTURE
  2. SUM-ACCT-CAT
PrimaryAC00.1, AC00.2, AC00.3, AC01.1, AC02.1, AC05.2, AC05.3, AC08.1 +22 more (list truncated in source)
SRSSET2
  1. STRUCTURE
  2. CATEGORY-TYPE
  3. SEQ-NUMBER
  4. SUM-ACCT-CAT
KeyChangeAC08.1, AC08.6, AC208, AC295, AC297, AC400, AC410, AC420 +17 more
SRSSET3
  1. SUM-ACCT-CAT
  2. STRUCTURE
AC01.1, AC05.1, AC105, AC112, AC113, AC120, AC121, AC123 +22 more (list truncated in source)
SRSSET4
  1. OBJ-ID
  2. STRUCTURE
  3. SUM-ACCT-CAT
KeyChangeAC01.1, AC105, AC112, AC113, AC120, AC121, AC123, AC128 +22 more (list truncated in source)

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
ACCTSUMBODSTRUCTUREACCATMXVALACCATMXVDTACCATSUMXMXLISTMBRACCATSUM

One to one (2) — lookups and parents

RelationTableRulesConditionField map
AcctsumbodACCTSUMBODNot Required, Delete Cascades
SRS-STRUCTURE→YAF-STRUCTURE
SRS-SUM-ACCT-CAT→YAF-SUM-ACCT-CAT
StructureSTRUCTURERequired
SRS-STRUCTURE→SRE-STRUCTURE

One to many (4) — child tables

RelationTableRulesConditionField map
AccatmxvalACCATMXVAL
SRS-OBJ-ID→AJB-OBJ-ID
—→AJB-MATRIX-CAT
AccatmxvdtACCATMXVDT
SRS-OBJ-ID→MXB-OBJ-ID
—→MXB-MATRIX-CAT
—→MXB-EFFECTIVE-DATE
AccatsumxACCATSUMX
SRS-STRUCTURE→SRX-STRUCTURE
SRS-SUM-ACCT-CAT→SRX-SUM-ACCT-CAT
—→SRX-ACCT-CATEGORY
MxlistmbrMXLISTMBR
"ACCAT"→MLM-OBJ-TYPE
SRS-OBJ-ID→MLM-OBJ-ID
—→MLM-MATRIX-LIST

Programs

Updated by (18)

Referenced by (470)