Lawson Insight Technical Documentation

                             ACMILESTN FILE

                          Activity Milestones

This file contains milestone information from the AC16 (Milestone) forms. It
includes activity, account category, milestone type, and the current balance
for the activity.

REFERENCED BY

BR02.3    BR10.1    BR10.2    BR120     BR121     BR122
BR123     BR130     BR140     BR151     BR152     BR156
BR19.1    BR20.1    BR20.2    BR20.3    BR20.4    BR20.5
BR205     BR22.1    BR405     BR420     BR450     BR521
BR530     PW110

UPDATED BY

AC300     AC310     BR05.2    BR05.3    BR05.4    BR05.5
AC10.1    BR00.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

MLS-ACTIVITY           Alpha 15                                  BR05.2  BR05.3
Element: Activity      Required key. This is the activity for    BR05.4  BR05.5
                       the milestone information.

MLS-ACCT-CATEGORY      Alpha 5                                   BR05.2  BR05.3
Element: Acct Category This is the account category for the      BR05.4  BR05.5
                       milestone information.

MLS-MILESTN-TYPE       Numeric 1                                 BR05.2  BR05.3
Element: Milestone TypeRequired. This field indicates the type   BR05.4  BR05.5
                       of milestone this is: days, date,
                       percent complete, or manual. Manual
                       milestones are tracked by the manager.
                       1 = Days
                       2 = Date
                       3 = % Complete
                       4 = Manual

MLS-BALANCE            Signed 18.2                               BR05.2  BR05.3
Element: Balance       This is the current balance for the       BR05.4  BR05.5
                       activity.

MLS-MILE-PCT-BAL       Signed 7.4                                BR05.2  BR05.3
Element: Mile Pct Bal                                            BR05.4  BR05.5

MLS-MILESTONE-CAT      Alpha 1                                   BR05.2  BR05.3
Element: Milestone Cat B = Billing                               BR05.4  BR05.5
                       R = Revenue

                         ACMILESTN FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

MLSSET1   ACTIVITY                                               AC10.1  AC300
          MILESTONE-CAT                                          AC310   BR00.1
                                                                 BR02.3  BR05.1
                                                                 BR05.2  BR05.3
                                                                 BR05.4  BR05.5
                                                                 BR10.1  BR10.2
                                                                 BR120   BR121
                                                                 BR122   BR123
                                                                 BR130   BR140
                                                                 BR151   BR152
                                                                 BR156   BR19.1
                                                                 BR20.1  BR20.2
                                                                 BR20.3  BR20.4
                                                                 BR20.5  BR205
                                                                 BR22.1  BR405
                                                                 ...

MLSSET2   MILESTN-TYPE  KeyChange                                BR05.2  BR05.3
          ACTIVITY                                               BR05.4  BR05.5
          MILESTONE-CAT

                         ACMILESTN FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Accntract      ACCNTRACT
                            Valid When MLS-MILESTONE-CAT = "R"

                            MLS-ACTIVITY         -> CNT-ACTIVITY
                                                    CNT-CONTRACT

Acmilestnx     ACMILESTNX

                            MLS-ACTIVITY         -> MLX-ACTIVITY
                            MLS-ACCT-CATEGORY    -> MLX-MILESTONE-CAT
                                                    MLX-MILESTONE