ACMILESTN – Activity Milestones
- System
- AC Billing Revenue (BR)
- Prefix
MLS- Primary key
ACTIVITY,MILESTONE-CAT- Fields
- 6
- Updated by
- 7 programs
- Referenced by
- 26 programs
ACMILESTN is the Activity Milestones table in Lawson AC Billing Revenue (prefix MLS). It is indexed by ACTIVITY, MILESTONE-CAT (MLSSET1); alternate indexes: MLSSET2. It is related 1:M to ACCNTRACT. It is updated by AC10.1, AC300, BR00.1, BR05.2, BR05.3, BR05.4 and BR05.5 and referenced by BR02.3, BR10.1, BR10.2, BR120, BR121, BR122, BR123, BR130 and 18 more. The table has 6 fields, 2 indexes and 1 documented relation.
About ACMILESTN
This file contains milestone information from the AC16 (Milestone) forms. It includes activity, account category, milestone type, and the current balance for the activity.
Fields (6)
Column = COBOL field name without the MLS- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#MLS-ACTIVITY PKACTIVITY | Alpha 15 | Required key. This is the activity for the milestone information. | BR05.2, BR05.3, BR05.4, BR05.5 |
#MLS-ACCT-CATEGORYACCT_CATEGORY | Alpha 5 | This is the account category for the milestone information. | BR05.2, BR05.3, BR05.4, BR05.5 |
#MLS-MILESTN-TYPE SET2MILESTN_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.
| BR05.2, BR05.3, BR05.4, BR05.5 |
#MLS-BALANCEBALANCE | Signed 18.2 | This is the current balance for the activity. | BR05.2, BR05.3, BR05.4, BR05.5 |
#MLS-MILE-PCT-BALMILE_PCT_BAL | Signed 7.4 | — | BR05.2, BR05.3, BR05.4, BR05.5 |
#MLS-MILESTONE-CAT PKMILESTONE_CAT | Alpha 1 | —
| BR05.2, BR05.3, BR05.4, BR05.5 |
Indexes (2)
Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
MLSSET1 |
| Primary | AC10.1, AC300, BR00.1, BR02.3, BR05.1, BR05.2, BR05.3, BR05.4 +22 more (list truncated in source) | |
MLSSET2 |
| KeyChange | BR05.2, BR05.3, BR05.4, BR05.5 |
Relations
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map | ||||||
|---|---|---|---|---|---|---|---|---|---|---|
| Accntract | ACCNTRACT | Valid When MLS-MILESTONE-CAT = "R" |
|
Programs
Updated by (7)
- AC10.1 Activity
- AC300 Activity Group Purge
- BR00.1 Activity Billing
- BR05.2 Days Milestones
- BR05.3 Date Milestones
- BR05.4 Percent Complete Milestones
- BR05.5 Manual Milestones
Referenced by (26)
- BR02.3 Retainer Invoice Entry
- BR10.1 Contract Parameters
- BR10.2 Contract Detail
- BR120 Invoice Calculation
- BR121 Invoice Print and Interface
- BR122 Online batch invoice process
- BR123 Product Invoice Cancel
- BR130 Revenue Calculation
- BR140 Billing and Revenue Backout
- BR151 Product Invoicing
- BR152 Maintenance Invoicing
- BR156 Maintenance Quote
- BR19.1 Single Invoice Calculation
- BR20.1 Invoice Edit Contract
- BR20.2 Invoice Edit Line
- BR20.3 Invoice Edit Activity
- BR20.4 Invoice Edit Activity and Account Category
- BR20.5 Invoice Edit Transaction
- BR205 Milestone Listing
- BR22.1 Contract Change Orders
- BR405 Milestone Analysis
- BR420 Billing Invoice Report
- BR450 Activity Aging
- BR521 Billing Import
- BR530 Revenue Import
- ML40.7 Ledger Totals