MINCUSTCL – Minor Customer Class
- System
- Accounts Receivable (AR)
- Prefix
MNC- Primary key
MAJOR-CLASS,MINOR-CLASS- Fields
- 4
- Updated by
- 8 programs
- Referenced by
- 2 programs
MINCUSTCL is the Minor Customer Class table in Lawson Accounts Receivable (prefix MNC). It is indexed by MAJOR-CLASS, MINOR-CLASS (MNCSET1). It is related 1:1 to MAJCUSTCL. It is updated by AR05.1, AR08.1, AR09.1, AR10.1, AR301, AR501, AR550 and TX140 and referenced by AR205 and AR210. The table has 4 fields, 1 index and 1 documented relation.
About MINCUSTCL
The AR Minor Customer Class file holds all customer minor classes. Every minor class must belong to one customer major class (major classes are kept in the AR Major Customer file). Many minor classes can have the same major class. 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 MNC- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
MNC-MAJOR-CLASS PKMAJOR_CLASS | Alpha 4 | This is the major customer class. | AR05.1 |
MNC-MINOR-CLASS PKMINOR_CLASS | Alpha 4 | This is the minor customer class. | AR05.1 |
MNC-DESCDESC | Alpha 30 (Lower Case) | This is the minor customer class description. | AR05.1 |
MNC-USED-FLUSED_FL | Alpha 1 | This is the minor customer class used flag. If this minor class has been used, it may not be deleted. Valid values are:
| AR08.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 |
|---|---|---|---|---|
MNCSET1 | MAJOR-CLASS, MINOR-CLASS | Primary | AR05.1, AR08.1, AR09.1, AR10.1, AR205, AR210, AR301, AR501 +2 more |
Relations
One to one (1) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Majcustclass | MAJCUSTCL | Required | MNC-MAJOR-CLASS → MJC-MAJOR-CLASS |
Programs
Updated by (8)
- AR05.1 Customer Class
- AR08.1 Customer Defaults
- AR09.1 Customer Group Address
- AR10.1 Customer
- AR301 Customer Purge
- AR501 Customer Conversion
- AR550 Customer Interface
- TX140 Vertex Geocode Update