Lawson Insight Technical Documentation |
|
ACMILESTN
ACMILESTN FILE
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
BR130 BR19.1 BR20.1 BR20.2 BR20.3 BR20.4
BR20.5 BR205 BR405 BR420 BR450 BR521
BR530
UPDATED BY
AC300 AC310 BR05.2 BR05.3 BR05.4 BR05.5
AC10.1 BR00.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MLS-ACTIVITY Alpha 15 BR05.2 BR05.3
Element: Activity Required key. This is the activity for BR05.4 BR05.5
the milestone information.
MLS-ACCT-CATEGORY Alpha 5 BR05.2 BR05.3
Element: Account CategoThis is the account category for the BR05.4 BR05.5
milestone information.
MLS-MILESTN-TYPE Numeric 1 BR05.2 BR05.3
Element: Milestone TypeRequired. This field indicates the type BR05.4 BR05.5
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 Signed 18.2 BR05.2 BR05.3
Element: Balance This is the current balance for the BR05.4 BR05.5
activity.
MLS-MILE-PCT-BAL Signed 7.4 BR05.2 BR05.3
Element: Mile Pct Bal BR05.4 BR05.5
MLS-MILESTONE-CAT Alpha 1 BR05.2 BR05.3
Element: Milestone Cat B = Billing BR05.4 BR05.5
R = Revenue
ACMILESTN FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MLSSET1 ACTIVITY AC10.1 AC300
MILESTONE-CAT AC310 BR00.1
BR02.3 BR05.1
BR05.2 BR05.3
BR05.4 BR05.5
BR10.1 BR10.2
BR120 BR121
BR122 BR130
BR19.1 BR20.1
BR20.2 BR20.3
BR20.4 BR20.5
BR205 BR405
BR420 BR450
BR521 BR530
MLSSET2 MILESTN-TYPE KeyChange BR05.2 BR05.3
ACTIVITY BR05.4 BR05.5
MILESTONE-CAT
ACMILESTN FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Accntract ACCNTRACT
Valid When MLS-MILESTONE-CAT = "R"
MLS-ACTIVITY -> CNT-ACTIVITY
CNT-CONTRACT
Acmilestnx ACMILESTNX
MLS-ACTIVITY -> MLX-ACTIVITY
MLS-ACCT-CATEGORY -> MLX-MILESTONE-CAT
MLX-MILESTONE
|