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

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MLX-ACTIVITY
Element: Activity
Alpha 15
Required key. This is the activity for the detailed milestone information.
MLX-MILESTONE
Element: Milestone
Alpha 3
Required key. This is the unique milestone identifier for milestone billing.
MLX-DESCRIPTION
Milestone
Description
Alpha 30 (Lower Case)
Required. This is the milestone description.
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.
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.
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.
MLX-BUDGET-TYPE
Element: Budget Type
Alpha 1
This field indicates the budget type: Amount or Units.
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.
MLX-MILESTONE-PCT
Element: Intl Amt
Signed 18.2
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
MLX-MILESTONE-CAT
Element: Milestone Cat
Alpha 1
This field identifies whether this is a billing or revenue milestone.
B = Billing
R = Revenue


ACMILESTNX FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MLXSET1 ACTIVITY
MILESTONE-CAT
MILESTONE
AC10.1
MLXSET2 ACTIVITY
MILESTONE-CAT
MILESTONE
STATUS
KeyChange


File created: Wed Jun 08 20:48:20 2016

Home
Contact Us



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