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
| BR19.1 | BR405 | BR450 | BR205 |
| 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 | AC10.1 | BR00.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 |
|
| NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MLXSET1 |
ACTIVITY MILESTONE-CAT MILESTONE |
|
| ||||||||||||||||||||||||||||||||||||
| MLXSET2 |
ACTIVITY MILESTONE-CAT MILESTONE STATUS |
|
| ||||||||||||||||||||||||||||||||||||
All trademarks and registered trademarks are the property of their
respective owners.