|
|
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
BR405 BR450 BR205
UPDATED BY
AC300 AC310 BR05.2 BR05.3 BR05.4 BR05.5
BR120 BR122 BR130 BR20.1 BR20.2 BR20.3
BR20.4 BR20.5 BR530 AC10.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 15.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 15.2 BR05.2 BR05.3
Element: Milestone Pct BR05.4 BR05.5
MLX-STATUS Numeric 1 AC300 BR05.2
Element: Milestone StatThis is the milestone status, BR05.3 BR05.4
indicating whether the milestone is BR05.5 BR120
open, to be billed, billed, or on hold. BR122 BR130
BR20.1 BR20.2
1 = To Process BR20.3 BR20.4
2 = Processed BR20.5 BR530
3 = Hold
MLX-MILESTONE-CAT Alpha 1 BR05.2 BR05.3
Element: Milestone Cat B = Billing BR05.4 BR05.5
R = Revenue
ACMILESTNX FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MLXSET1 ACTIVITY AC10.1 AC300
MILESTONE-CAT AC310 BR05.2
MILESTONE BR05.3 BR05.4
BR05.5 BR120
BR122 BR130
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR405
BR450 BR530
MLXSET2 ACTIVITY KeyChange BR205
MILESTONE-CAT
MILESTONE
STATUS
|
