Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

MAJORCL


                              MAJORCL FILE

                              Major Class

The Major Class file contains the major class codes which are entered on Item
Master records. There are three different types of major classes: inventory,
sales, and purchasing.

REFERENCED BY

BL05.1    BL09.1    BL120     BL122     BL130     BL20.1
BL20.3    BL205     BL21.2    BL21.5    BL243     BL29.1
BL29.2    BL41.1    BL45.2    BL46.2    BL47.2    BL48.2
BL520     BL820     BL85.3    BL92.1    IC00.1    IC11.1
IC205     IC206     IC207     IC210     IC211     IC212
IC213     IC236     IC30.1    IC330     IC811     PO04.2
PO100     PO150     PO204     PO213     PO223     PO23.5
PO25.6    PO25.7    PO253     PO254     PO275     PO276
PO277     PO280     PO36.2    PO536     PO54.1    PO54.2
PO54.3    PO54.4    PO550     POA2.3    POIJ.1    RQ04.1
RQ10.1    RQ10.3    RQ11.1    RQ204     RQ250     RQ35.1
RQ500     RQID.1    RQIF.1    RQIJ.1    WH140     WH20.2
WH20.7

UPDATED BY

IC05.1    IC06.1    IC07.1    IC39.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

MAJ-ITEM-GROUP         Alpha 5                                   IC05.1  IC06.1
Element: Item Group    This field contains the identifier for    IC07.1  IC39.1
                       a group of items that can be shared by
                       one or more companies.

MAJ-CLASS-TYPE         Alpha 1                                   IC05.1  IC06.1
Element: Class Type    This field indicates which group of       IC07.1  IC39.1
                       classes is assigned to this record.
                       I = Inventory Class
                       P = Purchasing Class
                       S = Sales Class
                       F = Freight Class

MAJ-MAJOR-CLASS        Alpha 4                                   IC05.1  IC06.1
Element: Major Class   This field contains a classification      IC07.1  IC39.1
                       for a group of items within the class
                       type.

MAJ-DESCRIPTION        Alpha 30  (Lower Case)                    BL243   IC05.1
Element: Description   This field contains the description of    IC06.1  IC07.1
                       the major class.                          IC39.1

MAJ-ACTIVE-STATUS      Alpha 1                                   IC05.1  IC06.1
Element: Active Status This field contains the status of the     IC07.1  IC39.1
                       major class which controls the use of
                       the major class.
                       A = Active
                       I = Inactive

                         MAJORCL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

MAJSET1   ITEM-GROUP                                             BL05.1  BL09.1
          CLASS-TYPE                                             BL120   BL122
          MAJOR-CLASS                                            BL130   BL20.1
                                                                 BL20.3  BL205
                                                                 BL21.2  BL21.5
                                                                 BL243   BL29.1
                                                                 BL29.2  BL41.1
                                                                 BL45.2  BL46.2
                                                                 BL47.2  BL48.2
                                                                 BL520   BL820
                                                                 BL85.3  BL92.1
                                                                 IC00.1  IC05.1
                                                                 IC06.1  IC07.1
                                                                 IC11.1  IC205
                                                                 IC206   IC207
                                                                 ...

                         MAJORCL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Itemgroup      ITEMGROUP    Required

                            MAJ-ITEM-GROUP     -> ITG-ITEM-GROUP

                         MAJORCL FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Itemmast       ITEMMAST

                            MAJ-ITEM-GROUP     -> ITE-ITEM-GROUP
                            MAJ-MAJOR-CLASS    -> ITE-PURCH-MAJCL
                                                  ITE-PURCH-MINCL
                                                  ITE-ITEM

Itemsales      ITEMMAST

                            MAJ-ITEM-GROUP     -> ITE-ITEM-GROUP
                            MAJ-MAJOR-CLASS    -> ITE-SALES-MAJCL
                                                  ITE-SALES-MINCL
                                                  ITE-ITEM

Minorclass     MINORCL      Delete Restricted

                            MAJ-ITEM-GROUP     -> MIN-ITEM-GROUP
                            MAJ-CLASS-TYPE     -> MIN-CLASS-TYPE
                            MAJ-MAJOR-CLASS    -> MIN-MAJOR-CLASS
                                                  MIN-MINOR-CLASS