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.

REFERENCED BY
BR02.3 BR10.1 BR10.2 BR120 BR121 BR122
BR123 BR130 BR140 BR151 BR152 BR156
BR19.1 BR20.1 BR20.2 BR20.3 BR20.4 BR20.5
BR205 BR22.1 BR405 BR420 BR450 BR521
BR530 ML40.7


UPDATED BY
AC300 BR05.2 BR05.3 BR05.4 BR05.5 AC10.1
BR00.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MLS-ACTIVITY
Element: Activity
Alpha 15
Required key. This is the activity for the milestone information.
BR05.2 BR05.3
BR05.4 BR05.5
MLS-ACCT-CATEGORY
Element: Acct Category
Alpha 5
This is the account category for the milestone information.
BR05.2 BR05.3
BR05.4 BR05.5
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
BR05.2 BR05.3
BR05.4 BR05.5
MLS-BALANCE
Element: Balance
Signed 18.2
This is the current balance for the activity.
BR05.2 BR05.3
BR05.4 BR05.5
MLS-MILE-PCT-BAL
Element: Mile Pct Bal
Signed 7.4
BR05.2 BR05.3
BR05.4 BR05.5
MLS-MILESTONE-CAT
Element: Milestone Cat
Alpha 1

B = Billing
R = Revenue
BR05.2 BR05.3
BR05.4 BR05.5


ACMILESTN FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MLSSET1 ACTIVITY
MILESTONE-CAT
...
AC10.1 AC300
BR00.1 BR02.3
BR05.1 BR05.2
BR05.3 BR05.4
BR05.5 BR10.1
BR10.2 BR120
BR121 BR122
BR123 BR130
BR140 BR151
BR152 BR156
BR19.1 BR20.1
BR20.2 BR20.3
BR20.4 BR20.5
BR205 BR22.1
BR405 BR420
MLSSET2 MILESTN-TYPE
ACTIVITY
MILESTONE-CAT
KeyChange
BR05.2 BR05.3
BR05.4 BR05.5


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: Thu Jun 09 02:11:06 2016

Home
Contact Us



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