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

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