ACMILESTN

Activity Milestones

This file contains milestone information from the AC16 (Milestone) forms. It includes activity, account category, milestone type, and the current balance for the activity.
UPDATED BY
AC10.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MLS-ACTIVITY
Element: Activity
Alpha 15
Required key. This is the activity for the milestone information.
MLS-ACCT-CATEGORY
Element: Acct Category
Alpha 5
This is the account category for the milestone information.
MLS-MILESTN-TYPE
Element: Milestone Type
Numeric 1
Required. This field indicates the type of milestone this is: days, date, percent complete, or manual. Manual milestones are tracked by the manager.
1 = Days
2 = Date
3 = % Complete
4 = Manual
MLS-BALANCE
Element: Balance
Signed 18.2
This is the current balance for the activity.
MLS-MILE-PCT-BAL
Element: Mile Pct Bal
Signed 7.4
MLS-MILESTONE-CAT
Element: Milestone Cat
Alpha 1

B = Billing
R = Revenue


ACMILESTN FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MLSSET1 ACTIVITY
MILESTONE-CAT
AC10.1
MLSSET2 MILESTN-TYPE
ACTIVITY
MILESTONE-CAT
KeyChange


ACMILESTN FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Accntract ACCNTRACT
Valid When MLS-MILESTONE-CAT ="R"
MLS-ACTIVITY->CNT-ACTIVITY
  CNT-CONTRACT


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

Home
Contact Us



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