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 BR120 BR121 BR122 BR123 BR130
BR140 BR151 BR152 BR156 BR19.1 BR20.1
BR20.2 BR20.3 BR20.4 BR20.5 BR405 BR420
BR521 BR530 ML40.7 BR22.1


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

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 11:10:56 2016

Home
Contact Us



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