|
|
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 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 IC235 IC236 IC238 IC239 IC295
IC30.1 IC330 IC46.1 IC530 IC55.1 IC59.1
IC70.1 IC811 IC83.1 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 OE111 OE113
OE114 OE116 OE129 OE13.2 OE13.3 OE13.5
OE14.4 OE289 OE30.1 OE30.2 OE30.3 OE30.4
OE30.5 OE30.6 OE30.7 OE30.9 OE510 OE530
OE810 OE830 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 RQIF.1 SA04.1 SA80.3
SA90.3 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. IC235 IC39.1
OE289 SA04.1
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 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
DR100 IC00.1
IC05.1 IC06.1
IC07.1 IC10.1
IC10.2 IC11.1
...
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
|
