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
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 IC46.1 IC530 IC55.1
IC59.1 IC70.1 IC811 IC83.1 PO04.2 PO100
PO150 PO204 PO213 PO223 PO23.5 PO25.6
PO25.7 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) IC05.1 IC06.1
Element: Description This field contains the description of IC07.1 IC39.1
the major class.
MAJ-ACTIVE-STATUS Alpha 1 IC05.1 IC06.1
Element: 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
|