ACMILESTNX – Activity Milestones Detail

System
AC Billing Revenue (BR)
Prefix
MLX
Primary key
ACTIVITY, MILESTONE-CAT, MILESTONE
Fields
11
Updated by
28 programs
Referenced by
4 programs

ACMILESTNX is the Activity Milestones Detail table in Lawson AC Billing Revenue (prefix MLX). It is indexed by ACTIVITY, MILESTONE-CAT, MILESTONE (MLXSET1); alternate indexes: MLXSET2. It is updated by AC10.1, AC300, BR00.1, BR02.3, BR05.2, BR05.3, BR05.4, BR05.5 and 20 more and referenced by BR19.1, BR205, BR405 and BR450. The table has 11 fields, 2 indexes and 0 documented relations.

About ACMILESTNX

This file contains detailed milestone information from the AC16 (Milestone) forms. It includes activity, milestone and description, milestone date, milestone number of days, percent complete, billable percentage, billable amount, and billing, revenue, and milestone status.

Fields (11)

Column = COBOL field name without the MLX- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
MLX-ACTIVITY PK
ACTIVITY		Alpha 15Required key. This is the activity for the detailed milestone information.BR05.2, BR05.3, BR05.4, BR05.5
MLX-MILESTONE PK
MILESTONE		Alpha 3Required key. This is the unique milestone identifier for milestone billing.BR05.2, BR05.3, BR05.4, BR05.5
MLX-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)Required. This is the milestone description.BR05.2, BR05.3, BR05.4, BR05.5
MLX-DATE
DATE		Numeric 8 (yyyymmdd)Optional. This is the milestone date for milestone billing. If the milestone type is Date, a date is required in this field.BR05.2, BR05.3, BR05.4, BR05.5
MLX-DAYS
DAYS		Numeric 4Optional. This field contains the milestone number of days for milestone billing. If the milestone type is Days, a number of days (from the activity start date or the last billing date) is required.BR05.2, BR05.3, BR05.4, BR05.5
MLX-PERC-COMPLETE
PERC_COMPLETE		Signed 7.3Optional. This field contains the percent complete milestone for milestone billing. If the milestone type is Percent Complete, a percentage of completion is required in this field.BR05.2, BR05.3, BR05.4, BR05.5
MLX-BUDGET-TYPE
BUDGET_TYPE		Alpha 1This field indicates the budget type: Amount or Units.BR05.4
MLX-BILL-AMOUNT
BILL_AMOUNT		Signed 18.2Required. This is the amount to bill for the milestone. If you entered a percentage in the Billable Percentage field, the billable amount for this field is calculated automatically.BR05.2, BR05.3, BR05.4, BR05.5
MLX-MILESTONE-PCT
MILESTONE_PCT		Signed 18.2—BR05.2, BR05.3, BR05.4, BR05.5
MLX-STATUS
STATUS		Numeric 1This is the milestone status, indicating whether the milestone is open, to be billed, billed, or on hold.
  • 1 To Process
  • 2 Processed
  • 3 Hold
AC300, BR02.3, BR05.2, BR05.3, BR05.4, BR05.5, BR120, BR121 +18 more
MLX-MILESTONE-CAT PK
MILESTONE_CAT		Alpha 1This field identifies whether this is a billing or revenue milestone.
  • 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.

IndexKeysFlagsConditionUsed in
MLXSET1ACTIVITY, MILESTONE-CAT, MILESTONEPrimaryAC10.1, AC300, BR00.1, BR02.3, BR05.2, BR05.3, BR05.4, BR05.5 +22 more (list truncated in source)
MLXSET2ACTIVITY, MILESTONE-CAT, MILESTONE, STATUSKeyChangeBR205

Programs

Updated by (28)

Referenced by (4)