Lawson Insight Technical Documentation |
|
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
|