Lawson Insight Technical Documentation

                             ACSUMBAL FILE

REFERENCED BY

ACTA.1

UPDATED BY

AC121     AC123     AC127     AC20.1    AC20.2    AC20.3
AC20.4    AC20.5    AC20.6    AC20.7    AC22.1    AC300
AC310     ACDR.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

SMB-ACTIVITY-GRP       Alpha 15                                  AC121   AC123
Element: Activity GroupThe activity group is the overall         AC127   AC20.1
                       project.                                  AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC20.6  AC20.7
                                                                 AC22.1  ACDR.1

SMB-ACTIVITY           Alpha 15                                  AC121   AC123
Element: Activity      Activities are the processes or           AC127   AC20.1
                       procedures that produce work. Cost        AC20.2  AC20.3
                       objects (products, services, customers,   AC20.4  AC20.5
                       and so on) are the reasons for            AC20.6  AC20.7
                       performing the activity.                  AC22.1  ACDR.1


SMB-SUM-ACCT-CAT       Alpha 5                                   AC121   AC123
Element: Sum Acct Cat  The name of the summary account           AC127   AC20.1
                       category.                                 AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC20.6  AC20.7
                                                                 AC22.1  ACDR.1

SMB-FISCAL-YEAR        Numeric 4                                 AC121   AC123
Element: Fiscal Year   This is the current fiscal year.  This    AC127   AC20.1
                       field is updated by Period Closing        AC20.2  AC20.3
                       (GL199).                                  AC20.4  AC20.5
                                                                 AC20.6  AC20.7
                                                                 AC22.1  ACDR.1

SMB-BEGIN-BAL-AMT      Signed 18.2                               AC121   AC123
Element: Intl Amt                                                AC127   AC20.1
                                                                 AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC20.6  AC20.7
                                                                 AC22.1  AC300
                                                                 ACDR.1

SMB-BEGIN-BAL-UNIT     Signed 17.2                               AC121   AC123
Element: Balance Unit                                            AC127   AC20.1
                                                                 AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC20.6  AC20.7
                                                                 AC22.1  AC300
                                                                 ACDR.1

SMB-BALANCE-AMT        Signed 18.2                               AC121   AC123
Element: Intl Amt                                                AC127   AC20.1
                                                                 AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC20.6  AC20.7
                                                                 AC22.1  AC300
                                                                 ACDR.1

SMB-BALANCE-UNIT       Signed 17.2                               AC121   AC123
Element: Balance Unit                                            AC127   AC20.1
                                                                 AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC20.6  AC20.7
                                                                 AC22.1  AC300
                                                                 ACDR.1

SMB-PERIOD-AMT         Signed 18.2 Occurs 13 Times               AC121   AC123
Element: Intl Amt                                                AC127   AC20.1
                                                                 AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC20.6  AC20.7
                                                                 AC22.1  AC300
                                                                 ACDR.1

SMB-PERIOD-UNIT        Signed 15.2 Occurs 13 Times               AC121   AC123
Element: Unit                                                    AC127   AC20.1
                                                                 AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC20.6  AC20.7
                                                                 AC22.1  AC300
                                                                 ACDR.1

SMB-BUDGET-NBR         Numeric 3                                 AC121   AC123
Element: Budget Number The Budget Number field contains the      AC127   AC20.1
                       budget number.                            AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC20.6  AC20.7
                                                                 AC22.1  ACDR.1

                         ACSUMBAL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

SMBSET1   ACTIVITY-GRP                                           AC121   AC123
          ACTIVITY                                               AC127   AC20.1
          SUM-ACCT-CAT                                           AC20.2  AC20.3
          BUDGET-NBR                                             AC20.4  AC20.5
          FISCAL-YEAR                                            AC20.6  AC20.7
                                                                 AC22.1  AC300
                                                                 AC310   ACDR.1
                                                                 ACTA.1

SMBSET2   ACTIVITY-GRP                                           AC121   AC123
          ACTIVITY                                               AC127   AC20.1
          SUM-ACCT-CAT                                           AC20.2  AC20.3
          BUDGET-NBR                                             AC20.4  AC20.5
          FISCAL-YEAR*                                           AC20.6  AC20.7
                                                                 AC22.1  ACDR.1
                                                                 ACTA.1