Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACMILESTNX


                            ACMILESTNX FILE

                       Activity Milestones Detail

This file contains detailed milestone information from the AC16 (Milestone)
forms. It includes activity, milestone and description, milestone date,
milestone number of days, percent complete, billable percentage, billable
amount, and billing, revenue, and milestone status.

REFERENCED BY

BR19.1    BR405     BR450     BR205

UPDATED BY

AC300     AC310     BR02.3    BR05.2    BR05.3    BR05.4
BR05.5    BR120     BR121     BR122     BR123     BR130
BR140     BR151     BR152     BR156     BR20.1    BR20.2
BR20.3    BR20.4    BR20.5    BR420     BR46.1    BR46.2
BR46.4    BR521     BR530     AC10.1    BR00.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

MLX-MILESTONE          Alpha 3                                   BR05.2  BR05.3
Element: Milestone     Required key. This is the unique          BR05.4  BR05.5
                       milestone identifier for milestone
                       billing.

MLX-DESCRIPTION        Alpha 30  (Lower Case)                    BR05.2  BR05.3
Milestone              Required. This is the milestone           BR05.4  BR05.5
Description            description.

MLX-DATE               Numeric 8  (yyyymmdd)                     BR05.2  BR05.3
Element: Date          Optional. This is the milestone date      BR05.4  BR05.5
                       for milestone billing. If the milestone
                       type is Date, a date is required in this
                       field.

MLX-DAYS               Numeric 4                                 BR05.2  BR05.3
Element: Days          Optional. This field contains the         BR05.4  BR05.5
                       milestone number of days for milestone
                       billing. If the milestone type is Days,
                       a number of days (from the activity
                       start date or the last billing date) is
                       required.

MLX-PERC-COMPLETE      Signed 7.3                                BR05.2  BR05.3
Element: Percent CompleOptional. This field contains the         BR05.4  BR05.5
                       percent complete milestone for milestone
                       billing. If the milestone type is
                       Percent Complete, a percentage of
                       completion is required in this field.

MLX-BUDGET-TYPE        Alpha 1                                   BR05.4
Element: Budget Type   This field indicates the budget type:
                       Amount or Units.

MLX-BILL-AMOUNT        Signed 18.2                               BR05.2  BR05.3
Element: Billable AmounRequired. This is the amount to bill      BR05.4  BR05.5
                       for the milestone. If you entered a
                       percentage in the Billable Percentage
                       field, the billable amount for this
                       field is calculated automatically.

MLX-MILESTONE-PCT      Signed 18.2                               BR05.2  BR05.3
Element: Intl Amt                                                BR05.4  BR05.5

MLX-STATUS             Numeric 1                                 AC300   BR02.3
Element: Milestone StatThis is the milestone status,             BR05.2  BR05.3
                       indicating whether the milestone is       BR05.4  BR05.5
                       open, to be billed, billed, or on hold.   BR120   BR121
                                                                 BR122   BR123
                       1 = To Process                            BR130   BR140
                       2 = Processed                             BR151   BR152
                       3 = Hold                                  BR156   BR20.1
                                                                 BR20.2  BR20.3
                                                                 BR20.4  BR20.5
                                                                 BR420   BR46.1
                                                                 BR46.2  BR46.4
                                                                 BR521   BR530

MLX-MILESTONE-CAT      Alpha 1                                   BR05.2  BR05.3
Element: Milestone Cat This field identifies whether this is a   BR05.4  BR05.5
                       billing or revenue milestone.
                       B = Billing
                       R = Revenue

                         ACMILESTNX FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

MLXSET1   ACTIVITY                                               AC10.1  AC300
          MILESTONE-CAT                                          AC310   BR00.1
          MILESTONE                                              BR02.3  BR05.2
                                                                 BR05.3  BR05.4
                                                                 BR05.5  BR120
                                                                 BR121   BR122
                                                                 BR123   BR130
                                                                 BR140   BR151
                                                                 BR152   BR156
                                                                 BR19.1  BR20.1
                                                                 BR20.2  BR20.3
                                                                 BR20.4  BR20.5
                                                                 BR405   BR420
                                                                 BR450   BR46.1
                                                                 BR46.2  BR46.4
                                                                 ...

MLXSET2   ACTIVITY      KeyChange                                BR205
          MILESTONE-CAT
          MILESTONE
          STATUS