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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#MSE-CONTRACT PK
CONTRACT		Alpha 15Activity 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 1This 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 15Activities 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 4Identifies 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 15The 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 4A 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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
MSESET1
  1. CONTRACT
  2. MAINT-SCHEDULE
PrimaryBR02.3, BR10.9, BR120, BR121, BR122, BR123, BR124, BR140 +22 more (list truncated in source)

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
ACACTIVITYACCNTRACTACCNTRPCDACCUSTDTLACPRODHDRACPRODLSTACSRVCLOCARCOMPCUSTDESCACCNTRCMTXACMNTSCHACMNTSCHXACMNTHDR

One to one (9) — lookups and parents

RelationTableRulesConditionField map
AcactivityACACTIVITYNot Required
MSE-REV-ACTIVITY→ACV-ACTIVITY
AccntractACCNTRACTRequired
MSE-CONTRACT→CNT-CONTRACT
AccntrpcdACCNTRPCDNot Required
MSE-CONTRACT→CNP-CONTRACT
AccustdtlACCUSTDTLNot Required
CNT-COMPANY→CMB-COMPANY
CNT-CUSTOMER→CMB-CUSTOMER
AcprodhdrACPRODHDRNot Required
MSE-CONTRACT→AHR-CONTRACT
AcprodlstACPRODLSTRequired
MSE-PRODUCT-LIST→BRP-PRODUCT-LIST
AcsrvclocACSRVCLOCNot Required
CNT-COMPANY→ASV-COMPANY
CNT-CUSTOMER→ASV-CUSTOMER
MSE-SERVICE-LOC→ASV-SERVICE-LOC
ArcompARCOMPRequired
CNT-COMPANY→ACO-COMPANY
CustdescCUSTDESCRequired
ACO-CUST-GROUP→CUD-CUST-GROUP
CNT-CUSTOMER→CUD-CUSTOMER

One to many (3) — child tables

RelationTableRulesConditionField map
AccntrcmtxACCNTRCMTX
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
AcmntschACMNTSCH
MSE-CONTRACT→MSC-CONTRACT
MSE-MAINT-SCHEDULE→MSC-MAINT-SCHEDULE
—→MSC-PRODUCT
—→MSC-PROD-VERSION
—→MSC-OBJ-ID
AcmntschxACMNTSCHX
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)

Referenced by (25)