|
|
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 BL205 BL243 BL41.1 BL45.2
BL46.2 BL47.2 BL48.2 BL85.3 BL92.1 DR100
IC00.1 IC10.1 IC10.2 IC11.1 IC120 IC125
IC134 IC135 IC138 IC140 IC141 IC142
IC145 IC150 IC151 IC152 IC16.3 IC205
IC206 IC207 IC210 IC211 IC212 IC213
IC219 IC220 IC223 IC225 IC226 IC227
IC228 IC230 IC232 IC236 IC238 IC239
IC295 IC30.1 IC530 IC70.1 IC811 MA04.2
MA204 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5
OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8
OE11.9 OE110 OE113 OE114 OE129 OE14.4
OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7
OE289 OE510 OE810 OE920 PO20.1 PO213
PO22.3 PO280 PO31.1 PO550 PO821 POA2.1
RQ04.1 RQ10.1 RQ204 RQ250 SA04.1 SA80.3
SA90.3 SAA2.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
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) BL243 IC05.1
Description This field contains the description of IC06.1 IC07.1
the major class. IC39.1 OE289
SA04.1
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 BL05.1 BL09.1
CLASS-TYPE BL205 BL243
MAJOR-CLASS BL41.1 BL45.2
BL46.2 BL47.2
BL48.2 BL85.3
BL92.1 DR100
IC00.1 IC05.1
IC06.1 IC07.1
IC10.1 IC10.2
IC11.1 IC120
IC125 IC134
IC135 IC138
IC140 IC141
IC142 IC145
IC150 IC151
...
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
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
|