Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

STRUCTURE


                             STRUCTURE FILE

The category structure provides the ability to create a set of account
categories.  The category structure is assigned to an activity group.  All
account categories assigned to the structure are available for posting.  The
Category Structure is added and maintained via AC08.

The category structure includes summary accounts, making up to 9 levels of
summarization available in reports.  At summary level 1, a single summary
account category will represent each category type to used in the structure
(Costs, Revenue, Accrual, Fee and Pass Thru).

The detail account categories assigned to the category structure contain the
edit flags (billing, revenue, markup, etc.).  Posting activities requiring
parameters differnt than those in the category structure can be added using
the Account Category Assignment form (AC06).

REFERENCED BY

AC00.1    AC01.1    AC105     AC108     AC112     AC113
AC120     AC121     AC123     AC128     AC135     AC145
AC16.1    AC16.2    AC16.3    AC16.7    AC16.8    AC16.9
AC160     AC165     AC169     AC190     AC191     AC197
AC198     AC200     AC203     AC206     AC207     AC208
AC210     AC213     AC218     AC220     AC225     AC240
AC246     AC256     AC261     AC265     AC290     AC295
AC298     AC30.3    AC310     AC32.1    AC34.1    AC346
AC35.1    AC36.1    AC400     AC401     AC410     AC412
AC420     AC421     AC440     AC460     AC471     AC472
AC473     AC480     AC490     AC493     AC494     AC527
AC55.1    AC56.1    AC560     AC58.1    AC580     AC583
AC70.1    AC90.1    AC92.1    AC93.1    AC93.2    AC93.4
AC94.1    AC95.1    ACBC.1    ACDM.2    ACDM.3    ATVW.1
SE90.1    AP211     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    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     BR254
BR265     BR300     BR400     BR405     BR422     BR430
BR450     BR521     BR530     BR580     ET700     MX123
MX500     SN02.1

UPDATED BY

AC08.1    AC08.2    AC08.4    AC558

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

SRE-STRUCTURE          Alpha 15                                  AC08.2  AC08.4
Element: Structure     The name of the category structure.       AC558

SRE-DESCRIPTION        Alpha 30  (Lower Case)                    AC08.2  AC08.4
Element: Description   This field displays the description.      AC558

SRE-LAST-SEQ-NBR-A     Numeric 6                                 AC08.1  AC558
Element: Last Seq Nbr  Identifies the last sequence number
                       used.  Ensures the record is unique.

SRE-LAST-SEQ-NBR-C     Numeric 6                                 AC08.1  AC558
Element: Last Seq Nbr  Identifies the last sequence number
                       used.  Ensures the record is unique.

SRE-LAST-SEQ-NBR-P     Numeric 6                                 AC08.1  AC558
Element: Last Seq Nbr  Identifies the last sequence number
                       used.  Ensures the record is unique.

SRE-LAST-SEQ-NBR-R     Numeric 6                                 AC08.1  AC558
Element: Last Seq Nbr  Identifies the last sequence number
                       used.  Ensures the record is unique.

                         STRUCTURE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

SRESET1   STRUCTURE                                              AC00.1  AC01.1
                                                                 AC08.1  AC08.2
                                                                 AC08.3  AC08.4
                                                                 AC08.5  AC08.6
                                                                 AC08.7  AC105
                                                                 AC108   AC112
                                                                 AC113   AC120
                                                                 AC121   AC123
                                                                 AC128   AC135
                                                                 AC145   AC16.1
                                                                 AC16.2  AC16.3
                                                                 AC16.7  AC16.8
                                                                 AC16.9  AC160
                                                                 AC165   AC169
                                                                 AC190   AC191
                                                                 ...

                         STRUCTURE FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Accatsum       ACCATSUM

                            SRE-STRUCTURE    -> SRS-STRUCTURE
                                                SRS-SUM-ACCT-CAT

Accatsumx      ACCATSUMX

                            SRE-STRUCTURE    -> SRX-STRUCTURE
                                                SRX-ACCT-CATEGORY