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

BR120     BR205     BR405     BR450

UPDATED BY

AC300     AC310     BR05.1    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
Activity             Required key. This is the activity for      BR05.4  BR05.5
                     the milestone information.

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

MLS-MILESTN-TYPE     Numeric 1                                   BR05.2  BR05.3
Milestone Type       Required. 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 17.2                                 BR05.2  BR05.3
Balance              This is the current balance for the         BR05.4  BR05.5
                     activity.

MLS-MILE-PCT-BAL     Signed 15.2                                 BR05.2  BR05.3
Mile Pct Bal                                                     BR05.4  BR05.5

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

                         ACMILESTN FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

MLSSET1   ACTIVITY                                               AC10.1  AC300
          MILESTONE-CAT                                          AC310   BR00.1
                                                                 BR05.1  BR05.2
                                                                 BR05.3  BR05.4
                                                                 BR05.5  BR120
                                                                 BR205   BR405
                                                                 BR450

MLSSET2   MILESTN-TYPE                                           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