Lawson Insight Technical Documentation

                              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

DR100     IC00.1    IC10.1    IC10.2    IC11.1    IC120
IC125     IC134     IC135     IC138     IC140     IC141
IC142     IC145     IC150     IC151     IC152     IC205
IC206     IC207     IC210     IC211     IC212     IC213
IC219     IC220     IC223     IC225     IC226     IC227
IC228     IC230     IC232     IC236     IC238     IC239
IC295     IC30.1    IC330     IC530     IC59.1    IC70.1
IC811     IC83.1    PO04.2    PO204     PO213     PO23.5
PO254     PO275     PO276     PO277     PO280     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     RQIF.1    WH140     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
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
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
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)                      IC05.1  IC06.1
Description          This field contains the description of      IC07.1  IC39.1
                     the major class.

MAJ-ACTIVE-STATUS    Alpha 1                                     IC05.1  IC06.1
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                                             DR100   IC00.1
          CLASS-TYPE                                             IC05.1  IC06.1
          MAJOR-CLASS                                            IC07.1  IC10.1
                                                                 IC10.2  IC11.1
                                                                 IC120   IC125
                                                                 IC134   IC135
                                                                 IC138   IC140
                                                                 IC141   IC142
                                                                 IC145   IC150
                                                                 IC151   IC152
                                                                 IC205   IC206
                                                                 IC207   IC210
                                                                 IC211   IC212
                                                                 IC213   IC219
                                                                 IC220   IC223
                                                                 ...

                         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