ACMILESTNX

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.
UPDATED BY
AC10.1 AC300 BR00.1 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 BR205
BR405 BR420 BR450 BR46.1 BR46.2 BR46.4
BR521 BR530

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MLX-ACTIVITY
Element: Activity
Alpha 15
Required key. This is the activity for the detailed milestone information.
BR05.2 BR05.3
BR05.4 BR05.5
MLX-MILESTONE
Element: Milestone
Alpha 3
Required key. This is the unique milestone identifier for milestone billing.
BR05.2 BR05.3
BR05.4 BR05.5
MLX-DESCRIPTION
Milestone
Description
Alpha 30 (Lower Case)
Required. This is the milestone description.
BR05.2 BR05.3
BR05.4 BR05.5
MLX-DATE
Element: Date
Numeric 8 (yyyymmdd)
Optional. This is the milestone date for milestone billing. If the milestone type is Date, a date is required in this field.
BR05.2 BR05.3
BR05.4 BR05.5
MLX-DAYS
Element: Days
Numeric 4
Optional. This field contains the 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.
BR05.2 BR05.3
BR05.4 BR05.5
MLX-PERC-COMPLETE
Element: Percent Complete
Signed 7.3
Optional. This field contains the percent complete milestone for milestone billing. If the milestone type is Percent Complete, a percentage of completion is required in this field.
BR05.2 BR05.3
BR05.4 BR05.5
MLX-BUDGET-TYPE
Element: Budget Type
Alpha 1
This field indicates the budget type: Amount or Units.
BR05.4
MLX-BILL-AMOUNT
Element: Billable Amount
Signed 18.2
Required. This is the amount to bill for the milestone. If you entered a percentage in the Billable Percentage field, the billable amount for this field is calculated automatically.
BR05.2 BR05.3
BR05.4 BR05.5
MLX-MILESTONE-PCT
Element: Intl Amt
Signed 18.2
BR05.2 BR05.3
BR05.4 BR05.5
MLX-STATUS
Element: Milestone Status
Numeric 1
This is the milestone status, indicating whether the milestone is open, to be billed, billed, or on hold.
1 = To Process
2 = Processed
3 = Hold
AC300 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
MLX-MILESTONE-CAT
Element: Milestone Cat
Alpha 1
This field identifies whether this is a billing or revenue milestone.
B = Billing
R = Revenue
BR05.2 BR05.3
BR05.4 BR05.5


ACMILESTNX FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MLXSET1 ACTIVITY
MILESTONE-CAT
MILESTONE
...
AC10.1 AC300
BR00.1 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 BR521
MLXSET2 ACTIVITY
MILESTONE-CAT
MILESTONE
STATUS
KeyChange
BR205


File created: Thu Jun 09 11:10:56 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.