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
AC108 AC121 AC123 AC127 AC20.1 AC20.2
AC20.3 AC20.4 AC20.5 AC20.6 AC20.7 AC22.1
AC256 AC40.1 AC40.4 AC400 AC41.1 AC41.4
AC42.1 AC420 AC46.1 AC473 AC58.2 ACAC.1
ACBC.1 ACDL.1 ACDM.3 ACDR.1 AP125 AP126
AP25.1 AP25.2 AP26.1 AP27.1 AP30.2 AP520
BR00.2 BR00.3 BR01.1 BR01.2 BR02.3 BR03.1
BR03.2 BR03.3 BR120 BR121 BR122 BR140
BR18.2 BR190 BR20.1 BR20.2 BR20.3 BR20.4
BR20.5 BR20.9 BR41.1 BR41.4 BR420 BR43.1
BR521 CB10.1 CB15.1 CB15.2 CB191 CB20.1
CB30.1 CB500 EE135 EE20.3 EE35.1 EE35.2
EE520 GL146 GL165 GL170 GL197 GL199
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 MA65.1 AC208 AC05.1 BR19.2 BR42.2
UPDATED BY
AC08.1 AC08.4 AC08.6 AC08.2 AC558
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
Record Sequence The sequence number of the summary AC558
Number 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: Budget Budget edit flag for summary account AC558
categories.
D = Detail
N = No Edit
S = Summary
ACCATSUM FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
SRSSET1 STRUCTURE AC08.1 AC08.2
SUM-ACCT-CAT AC08.3 AC08.4
AC08.5 AC08.6
AC08.7 AC108
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC22.1 AC256
AC40.1 AC40.4
AC400 AC41.1
AC41.4 AC42.1
AC420 AC46.1
AC473 AC558
...
SRSSET2 STRUCTURE KeyChange AC08.1 AC08.6
CATEGORY-TYPE AC208 ACBC.1
SEQ-NUMBER
SUM-ACCT-CAT
SRSSET3 SUM-ACCT-CAT AC05.1 AC400
STRUCTURE AC420 BR120
BR19.2 BR190
BR20.9 BR42.2
BR521
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
Accatsumx ACCATSUMX
SRS-STRUCTURE -> SRX-STRUCTURE
SRS-SUM-ACCT-CAT -> SRX-SUM-ACCT-CAT
SRX-ACCT-CATEGORY
|