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
BR205 BR405 BR450
UPDATED BY
AC300 AC310 BR05.2 BR05.3 BR05.4 BR05.5
BR120 BR130 BR20.1 BR20.2 BR20.3 BR20.4
BR20.5 BR21.1 AC10.1 BR00.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MLX-ACTIVITY Alpha 15 BR05.2 BR05.3
Activity Required key. This is the activity for BR05.4 BR05.5
the detailed milestone information.
MLX-MILESTONE Alpha 3 BR05.2 BR05.3
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
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
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
Percent Complete Optional. 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
Budget Type This field indicates the budget type:
Amount or Units.
MLX-BILL-AMOUNT Signed 15.2 BR05.2 BR05.3
Billable Amount Required. 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 15.2 BR05.2 BR05.3
Milestone Pct BR05.4 BR05.5
MLX-STATUS Numeric 1 AC300 BR05.2
Milestone Status This is the milestone status, BR05.3 BR05.4
indicating whether the milestone is BR05.5 BR120
open, to be billed, billed, or on hold. BR130 BR20.1
BR20.2 BR20.3
1 = To Process BR20.4 BR20.5
2 = Processed BR21.1
3 = Hold
MLX-MILESTONE-CAT Alpha 1 BR05.2 BR05.3
Milestone Cat BR05.4 BR05.5
ACMILESTNX FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MLXSET1 ACTIVITY AC10.1 AC300
MILESTONE-CAT AC310 BR00.1
MILESTONE BR05.2 BR05.3
BR05.4 BR05.5
BR120 BR130
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR205
BR21.1 BR405
BR450
MLXSET2 ACTIVITY KeyChange BR405
MILESTONE-CAT
MILESTONE
STATUS
|
