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 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 IC231 IC232 IC233 IC234
IC235 IC236 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 POA2.3 POIJ.1 RQ04.1
RQ10.1 RQ10.3 RQ10.4 RQ10.5 RQ11.1 RQ204
RQ250 RQ260 RQ35.1 RQ500 RQ94.1 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
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 02:19:11 2016

Home
Contact Us



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