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
BR00.1 BR10.1 BR10.2 BR120 BR130 BR205
BR405 BR450 BR530
UPDATED BY
AC300 AC310 BR05.2 BR05.3 BR05.4 BR05.5
AC10.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 17.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
BR05.1 BR05.2
BR05.3 BR05.4
BR05.5 BR10.1
BR10.2 BR120
BR130 BR205
BR405 BR450
BR530
MLSSET2 MILESTN-TYPE 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
|