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.

Field / column	Type	Description & values	Updated by
`MLS-ACTIVITY` PK ACTIVITY	Alpha 15	Required key. This is the activity for the milestone information.	BR05.2, BR05.3, BR05.4, BR05.5
`MLS-ACCT-CATEGORY` ACCT_CATEGORY	Alpha 5	This is the account category for the milestone information.	BR05.2, BR05.3, BR05.4, BR05.5
`MLS-MILESTN-TYPE` MILESTN_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` BALANCE	Signed 18.2	This is the current balance for the activity.	BR05.2, BR05.3, BR05.4, BR05.5
`MLS-MILE-PCT-BAL` MILE_PCT_BAL	Signed 7.4	—	BR05.2, BR05.3, BR05.4, BR05.5
`MLS-MILESTONE-CAT` PK MILESTONE_CAT	Alpha 1	— `B` Billing `R` Revenue	BR05.2, BR05.3, BR05.4, BR05.5

Indexes (2)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`MLSSET1`	`ACTIVITY`, `MILESTONE-CAT`	Primary		AC10.1, AC300, BR00.1, BR02.3, BR05.1, BR05.2, BR05.3, BR05.4 +22 more (list truncated in source)
`MLSSET2`	`MILESTN-TYPE`, `ACTIVITY`, `MILESTONE-CAT`	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"	`MLS-ACTIVITY` → `CNT-ACTIVITY`, → `CNT-CONTRACT`

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