MAJCUSTCL – Major Customer Class

System: Accounts Receivable (AR)
Prefix: MJC
Primary key: MAJOR-CLASS
Fields: 4
Updated by: 7 programs
Referenced by: 3 programs

MAJCUSTCL is the Major Customer Class table in Lawson Accounts Receivable (prefix MJC). It is indexed by MAJOR-CLASS (MJCSET1). It is related 1:M to MINCUSTCL. It is updated by AR05.1, AR09.1, AR10.1, AR301, AR501, AR550 and TX140 and referenced by AR08.1, AR205 and AR210. The table has 4 fields, 1 index and 1 documented relation.

About MAJCUSTCL

The AR Major Customer Class file holds all customer major classes. Every major class must have at least one minor class (minor classes are kept in the AR Minor Customer Class file). Every customer must belong to one major and minor class. These classes are used for reporting selection criteria.

Fields (4)

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

Field / column	Type	Description & values	Updated by
`MJC-MAJOR-CLASS` PK MAJOR_CLASS	Alpha 4	This is the user-defined major customer class.	AR05.1
`MJC-DESC` DESC	Alpha 30 (Lower Case)	This is the major customer class description.	AR05.1
`MJC-ACTIVE-STATUS` ACTIVE_STATUS	Alpha 1	Active Status flag indicates whether or not a particular customer major class is active. Valid values are: `A` Active `I` Inactive	AR05.1
`MJC-USED-FL` USED_FL	Alpha 1	This is the used flag for the major customer class. If this class has been used, the class may not be deleted. Valid values are: `N` No; Class has not been used `Y` Yes; Class has been used	AR05.1, AR09.1, AR10.1, AR301, AR501, AR550, TX140

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
`MJCSET1`	`MAJOR-CLASS`	Primary		AR05.1, AR08.1, AR09.1, AR10.1, AR205, AR210, AR301, AR501 +2 more

Relations

One to many (1) — child tables

Relation	Table	Rules	Condition	Field map
Mincustclass	MINCUSTCL	Delete Cascades		`MJC-MAJOR-CLASS` → `MNC-MAJOR-CLASS`, → `MNC-MINOR-CLASS`

Programs

Updated by (7)

AR05.1 Customer Class
AR09.1 Customer Group Address
AR10.1 Customer
AR301 Customer Purge
AR501 Customer Conversion
AR550 Customer Interface
TX140 Vertex Geocode Update

Referenced by (3)

AR08.1 Customer Defaults
AR205 Customer Class Listing
AR210 Customer Listing