MAJORCL

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 IC10.1 IC10.2 IC11.1 IC120 IC125
IC134 IC135 IC138 IC140 IC141 IC142
IC145 IC150 IC151 IC152 IC210 IC211
IC212 IC213 IC219 IC220 IC223 IC225
IC226 IC227 IC228 IC230 IC231 IC232
IC233 IC234 IC235 IC238 IC239 IC247
IC295 IC30.1 IC330 IC46.1 IC511 IC512
IC55.1 IC59.1 IC70.1 IC811 IC83.1 PO04.2
PO100 PO150 PO204 PO213 PO22.2 PO22.3
PO22.4 PO22.5 PO223 PO23.5 PO25.6 PO25.7
PO253 PO254 PO26.4 PO26.5 PO275 PO276
PO277 PO28.2 PO280 PO36.2 PO536 PO54.1
PO54.2 PO54.3 PO54.4 PO550 POIJ.1 RQ04.1
RQ10.1 RQ10.3 RQ10.4 RQ11.1 RQ250 RQ260
RQ35.1 RQ500 RQID.1 RQIF.1 RQIJ.1 WH140
WH20.2 WH20.7 IC205 IC206 IC207 IC236
POA2.3 RQ204


UPDATED BY
IC00.1 IC05.1 IC06.1 IC07.1 IC39.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MAJ-ITEM-GROUP
Element: Item Group
Alpha 5
This field contains the identifier for a group of items that can be shared by one or more companies.
IC05.1 IC06.1
IC07.1 IC39.1
MAJ-CLASS-TYPE
Element: Class Type
Alpha 1
This field indicates which group of classes is assigned to this record.
I = Inventory Class
P = Purchasing Class
S = Sales Class
F = Freight Class
IC05.1 IC06.1
IC07.1 IC39.1
MAJ-MAJOR-CLASS
Element: Major Class
Alpha 4
This field contains a classification for a group of items within the class type.
IC05.1 IC06.1
IC07.1 IC39.1
MAJ-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
This field contains the description of the major class.
IC05.1 IC06.1
IC07.1 IC235
IC39.1
MAJ-ACTIVE-STATUS
Element: Active Status
Alpha 1
This field contains the status of the major class which controls the use of the major class.
A = Active
I = Inactive
IC05.1 IC06.1
IC07.1 IC39.1


MAJORCL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MAJSET1 ITEM-GROUP
CLASS-TYPE
MAJOR-CLASS
...
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 IC152
IC205 IC206
IC207 IC210
IC211 IC212
IC213 IC219
IC220 IC223


MAJORCL FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Itemgroup ITEMGROUP Required
MAJ-ITEM-GROUP->ITG-ITEM-GROUP


MAJORCL FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED 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


File created: Thu Jun 09 11:17:26 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.