Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACMILESTN


                             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

BR00.1    BR10.1    BR10.2    BR120     BR130     BR205
BR405     BR450     BR530

UPDATED BY

AC300     AC310     BR05.2    BR05.3    BR05.4    BR05.5
AC10.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: Account CategoThis 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 17.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
                                                                 BR05.1  BR05.2
                                                                 BR05.3  BR05.4
                                                                 BR05.5  BR10.1
                                                                 BR10.2  BR120
                                                                 BR130   BR205
                                                                 BR405   BR450
                                                                 BR530

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