ACMNTHDR – Activity Maintenance Header

System: AC Billing Revenue (BR)
Prefix: MSE
Primary key: CONTRACT, MAINT-SCHEDULE
Fields: 13
Updated by: 5 programs
Referenced by: 25 programs

ACMNTHDR is the Activity Maintenance Header table in Lawson AC Billing Revenue (prefix MSE). It is indexed by CONTRACT, MAINT-SCHEDULE (MSESET1). It is related 1:1 to ACACTIVITY, ACCNTRACT, ACCNTRPCD, ACCUSTDTL, ACPRODHDR, ACPRODLST, ACSRVCLOC, ARCOMP and 1 more and 1:M to ACCNTRCMTX, ACMNTSCH and ACMNTSCHX. It is updated by BR155, BR51.1, BR52.2, BR52.4 and BR52.5 and referenced by BR02.3, BR10.9, BR120, BR121, BR122, BR123, BR124, BR140 and 17 more. The table has 13 fields, 1 index and 12 documented relations.

About ACMNTHDR

No description in the Lawson data dictionary.

Fields (13)

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

Field / column	Type	Description & values	Updated by
`MSE-CONTRACT` PK CONTRACT	Alpha 15	Activity Management contract.	BR155, BR51.1, BR52.2, BR52.4, BR52.5
`MSE-MAINT-SCHEDULE` PK MAINT_SCHEDULE	Alpha 15	—	BR155, BR51.1, BR52.2, BR52.4, BR52.5
`MSE-DESCRIPTION` DESCRIPTION	Alpha 30 (Lower Case)	This field displays the description.	BR155, BR51.1, BR52.2, BR52.4, BR52.5
`MSE-BEGIN-DATE` BEGIN_DATE	Numeric 8 (yyyymmdd)	The begin date for this effort period.	BR155, BR51.1, BR52.2, BR52.4, BR52.5
`MSE-END-DATE` END_DATE	Numeric 8 (yyyymmdd)	The end date for this effort period.	BR155, BR51.1, BR52.2, BR52.4, BR52.5
`MSE-STATUS` STATUS	Numeric 1	This field displays the status of the transaction. `1` Free ISP `2` Billable ISP `3` Renewal `4` Cancelled	BR155, BR51.1, BR52.2, BR52.4, BR52.5
`MSE-PRODUCT-LIST` PRODUCT_LIST	Alpha 10	—	BR155, BR51.1, BR52.2, BR52.4, BR52.5
`MSE-REV-ACTIVITY` REV_ACTIVITY	Alpha 15	Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.	BR155, BR51.1, BR52.2, BR52.4, BR52.5
`MSE-MAINT-RENEW-DT` MAINT_RENEW_DT	Numeric 8 (yyyymmdd)	This field displays the system date when this was created.	BR155, BR51.1, BR52.2, BR52.4, BR52.5
`MSE-DFLT-COMPANY` DFLT_COMPANY	Numeric 4	Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.	BR155, BR51.1, BR52.2, BR52.4, BR52.5
`MSE-DFLT-ACCT-UNIT` DFLT_ACCT_UNIT	Alpha 15	The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit.	BR155, BR51.1, BR52.2, BR52.4, BR52.5
`MSE-SERVICE-LOC` SERVICE_LOC	Numeric 4	A user defined code identifying a customer's service location.	BR155, BR51.1, BR52.2, BR52.4, BR52.5
`MSE-CUST-NAME` CUST_NAME	Derived	—	—

Indexes (1)

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
`MSESET1`	`CONTRACT`, `MAINT-SCHEDULE`	Primary		BR02.3, BR10.9, BR120, BR121, BR122, BR123, BR124, BR140 +22 more (list truncated in source)

Relations

One to one (9) — lookups and parents

Relation	Table	Rules	Field map
Acactivity	ACACTIVITY	Not Required	`MSE-REV-ACTIVITY` → `ACV-ACTIVITY`
Accntract	ACCNTRACT	Required	`MSE-CONTRACT` → `CNT-CONTRACT`
Accntrpcd	ACCNTRPCD	Not Required	`MSE-CONTRACT` → `CNP-CONTRACT`
Accustdtl	ACCUSTDTL	Not Required	`CNT-COMPANY` → `CMB-COMPANY`, `CNT-CUSTOMER` → `CMB-CUSTOMER`
Acprodhdr	ACPRODHDR	Not Required	`MSE-CONTRACT` → `AHR-CONTRACT`
Acprodlst	ACPRODLST	Required	`MSE-PRODUCT-LIST` → `BRP-PRODUCT-LIST`
Acsrvcloc	ACSRVCLOC	Not Required	`CNT-COMPANY` → `ASV-COMPANY`, `CNT-CUSTOMER` → `ASV-CUSTOMER`, `MSE-SERVICE-LOC` → `ASV-SERVICE-LOC`
Arcomp	ARCOMP	Required	`CNT-COMPANY` → `ACO-COMPANY`
Custdesc	CUSTDESC	Required	`ACO-CUST-GROUP` → `CUD-CUST-GROUP`, `CNT-CUSTOMER` → `CUD-CUSTOMER`

One to many (3) — child tables

Relation	Table	Field map
Accntrcmtx	ACCNTRCMTX	`MSE-CONTRACT` → `CXM-CONTRACT`, `MSE-MAINT-SCHEDULE` → `CXM-MAINT-SCHEDULE`, `Spaces` → `CXM-PRODUCT`, `Spaces` → `CXM-PROD-VERSION`, → `CXM-OBJ-ID`, → `CXM-COMMENT-TYPE`, → `CXM-DATE`, → `CXM-SEQ-NBR`
Acmntsch	ACMNTSCH	`MSE-CONTRACT` → `MSC-CONTRACT`, `MSE-MAINT-SCHEDULE` → `MSC-MAINT-SCHEDULE`, → `MSC-PRODUCT`, → `MSC-PROD-VERSION`, → `MSC-OBJ-ID`
Acmntschx	ACMNTSCHX	`MSE-CONTRACT` → `MSD-CONTRACT`, `MSE-MAINT-SCHEDULE` → `MSD-MAINT-SCHEDULE`, → `MSD-PRODUCT`, → `MSD-PROD-VERSION`, → `MSD-OBJ-ID`, → `MSD-TRAN-DATE`

Programs

Updated by (5)

BR155 Maintenance Schedule Copy
BR51.1 Product Contract
BR52.2 New Maintenance Schedule
BR52.4 Renew All
BR52.5 Product Maintenance Renewal

Referenced by (25)

BR02.3 Retainer Invoice Entry
BR10.9 Product Contract Parameters
BR120 Invoice Calculation
BR121 Invoice Print and Interface
BR122 Online batch invoice process
BR123 Product Invoice Cancel
BR124 Deferred Revenue Adjustment
BR140 Billing and Revenue Backout
BR151 Product Invoicing
BR152 Maintenance Invoicing
BR154 Maintenance Revenue Calculation
BR156 Maintenance Quote
BR157 Maintenance Cancel
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
BR252 Maintenance Schedule Listing
BR31.3 Maintenance Schedule Comments
BR31.4 Maintenance Product Comments
BR420 Billing Invoice Report
BR50.3 Define Product List
BR521 Billing Import
BRIP.1 Invoice Print Program