|
|
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
AC216 AC416
UPDATED BY
AC10.1 AC115 AC16.2 AC16.3 AC16.4 AC16.5
AC300 AC310 AC701
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MLX-ACTIVITY Alpha 15 AC16.2 AC16.3
Activity Required key. This is the activity for AC16.4 AC16.5
the detailed milestone information.
MLX-ACCT-CATEGORY Alpha 5 AC16.2 AC16.3
Account Category This is the account category for the AC16.4 AC16.5
detailed milestone information.
MLX-MILESTONE Alpha 3 AC16.2 AC16.3
Milestone Required key. This is the unique AC16.4 AC16.5
milestone identifier for milestone
billing.
MLX-DESCRIPTION Alpha 30 (Lower Case) AC16.2 AC16.3
Milestone Required. This is the milestone AC16.4 AC16.5
Description description.
MLX-DATE Numeric 8 (yyyymmdd) AC16.2 AC16.3
Date Optional. This is the milestone date AC16.4 AC16.5
for milestone billing. If the milestone
type is Date, a date is required in this
field.
MLX-DAYS Numeric 4 AC16.2 AC16.3
Days Optional. This field contains the AC16.4 AC16.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 AC16.2 AC16.3
Percent Complete Optional. This field contains the AC16.4 AC16.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 AC16.4 AC701
Budget Type This field indicates the budget type:
Amount or Units.
MLX-BILL-AMOUNT Signed 15.2 AC16.2 AC16.3
Billable Amount Required. This is the amount to bill AC16.4 AC16.5
for the milestone. If you entered a
percentage in the Billable Percentage
field, the billable amount for this
field is calculated automatically.
MLX-STATUS Numeric 1 AC115 AC16.2
Milestone Status This is the milestone status, AC16.3 AC16.4
indicating whether the milestone is AC16.5
open, to be billed, billed, or on hold.
1 = Open
2 = To Bill
3 = Billed
4 = Hold
ACMILESTNX FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MLXSET1 ACTIVITY AC10.1 AC115
ACCT-CATEGORY AC16.2 AC16.3
MILESTONE AC16.4 AC16.5
AC216 AC300
AC310 AC416
AC701
MLXSET2 ACTIVITY KeyChange AC416
ACCT-CATEGORY
MILESTONE
STATUS
ACMILESTNX FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acactivity ACACTIVITY Required
MLX-ACTIVITY -> ACV-ACTIVITY
|