Lawson Insight Technical Documentation |
|
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
|