MAJORCL – Major Class
- System
- Inventory Control (IC)
- Prefix
MAJ- Primary key
ITEM-GROUP,CLASS-TYPE,MAJOR-CLASS- Fields
- 5
- Updated by
- 4 programs
- Referenced by
- 101 programs
MAJORCL is the Major Class table in Lawson Inventory Control (prefix MAJ). It is indexed by ITEM-GROUP, CLASS-TYPE, MAJOR-CLASS (MAJSET1). It is related 1:1 to ITEMGROUP and 1:M to ITEMMAST and MINORCL. It is updated by IC05.1, IC06.1, IC07.1 and IC39.1 and referenced by DR100, IC00.1, IC10.1, IC10.2, IC11.1, IC120, IC125, IC134 and 93 more. The table has 5 fields, 1 index and 4 documented relations.
About MAJORCL
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.
Fields (5)
Column = COBOL field name without the MAJ- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#MAJ-ITEM-GROUP PKITEM_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 PKCLASS_TYPE | Alpha 1 | This field indicates which group of classes is assigned to this record.
| IC05.1, IC06.1, IC07.1, IC39.1 |
#MAJ-MAJOR-CLASS PKMAJOR_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-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | This field contains the description of the major class. | IC05.1, IC06.1, IC07.1, IC235, IC39.1 |
#MAJ-ACTIVE-STATUSACTIVE_STATUS | Alpha 1 | This field contains the status of the major class which controls the use of the major class.
| IC05.1, IC06.1, IC07.1, IC39.1 |
Indexes (1)
Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
MAJSET1 |
| Primary | DR100, IC00.1, IC05.1, IC06.1, IC07.1, IC10.1, IC10.2, IC11.1 +22 more (list truncated in source) |
Relations
One to one (1) — lookups and parents
| Relation | Table | Rules | Condition | Field map | |||
|---|---|---|---|---|---|---|---|
| Itemgroup | ITEMGROUP | Required |
|
One to many (3) — child tables
| Relation | Table | Rules | Condition | Field map | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Itemmast | ITEMMAST |
| ||||||||||||||
| Itemsales | ITEMMAST |
| ||||||||||||||
| Minorclass | MINORCL | Delete Restricted |
|
Programs
Updated by (4)
Referenced by (101)
- DR100 Distribution Requirements Report
- IC00.1 Corporate Item Group
- IC10.1 Item Formats
- IC10.2 Item Master and Location
- IC11.1 Item Master
- IC120 Economic Order Quantity and Reorder Calculation
- IC125 Standard Cost Valuation
- IC134 Inventory Turnover
- IC135 Inventory Turnover by Issues
- IC138 Bin Replenishment Report
- IC140 Vendor Reorder Advice
- IC141 Location Replenishment Report
- IC142 Replenishment by Requisition PO's
- IC145 Stock Status Report
- IC150 Movement Analysis - Cost
- IC151 Movement Analysis - Sales
- IC152 Movement Analysis - GMROI
- IC205 Sales Class Listing
- IC206 Inventory Class Listing
- IC207 Purchase Class Listing
- IC210 Item Master Listing
- IC211 Item Location Listing
- IC212 Item Comments Listing
- IC213 Item Substitutes Listing
- IC219 Forecast Listing
- IC220 Transaction History Report
- IC223 Availability Report
- IC225 Inventory Reorder Advice
- IC226 Leadtime Review Report
- IC227 Potential Obsolete
- IC228 Potential Overstock
- IC230 Lot Status Report
- IC231 Issue Summary Report
- IC232 Serial Status Report
- IC233 Inventory Valuation
- IC234 Period End Valuation
- IC235 Market Inventory Valuation
- IC236 Freight Class Listing
- IC238 Bin Stock on Hand Report
- IC239 Forecast Variance
- IC247 IFRS FIFO Period End Valuation
- IC295 Count Control Status
- IC30.1 Item Search
- IC330 Item Mass Change
- IC46.1 Inventory Status
- IC511 Item Master-Item Location Extr
- IC512 Item Audit Extract
- IC55.1 Transaction History Inquiry
- IC59.1 Create Label Entry
- IC70.1 Select IDs
- IC811 Item Master Load
- IC83.1 Par Location Counts
- PO04.2 Buyer Purchasing Class
- PO100 Purchase Order Interface from Lawson Applications
- PO150 Bid Load to Contract or Catalog
- PO204 Buyer Master Listing
- PO213 Vendor Item Listing
- PO22.2 Mass Cancel or Delete Purchase Orders
- PO22.3 Mass Cancel or Delete Purchase Orders
- PO22.4 Mass Cancel or Delete Purchase Order Lines
- PO22.5 Purchase Order Line Inquiry
- PO223 Buyer Expediting Report
- PO23.5 Worksheet Filter
- PO25.6 Vendor Agreement Line
- PO25.7 Service Agreement Line
- PO253 Item Receipt Volume Report
- PO254 PO Inquiry Report
- PO26.4 Vendor Agreement Line Price Breaks
- PO26.5 Vendor Agreement Line Price Breaks
- PO275 Delivery Date Analysis
- PO276 Deliver Quantity Analysis
- PO277 Deliver Quality Analysis
- PO28.2 Vendor Agreement Line Detail List
- PO280 Purchases By Class
- PO36.2 Vendor Agreement Import Manual Input
- PO536 Vendor Price Agreement Load
- PO54.1 Purchase Order Inquiry
- PO54.2 Purchase Order Inquiry
- PO54.3 Purchase Order Inquiry
- PO54.4 Purchase Order Inquiry
- PO550 Bid Creation
- POA2.3 Define Product Dimension
- POIJ.1 Invoke for POPLIUPD
- RQ04.1 Requesters
- RQ10.1 Requisition
- RQ10.3 Select and Copy
- RQ10.4 Requisition Line Entry Detail
- RQ10.5 Substitutes
- RQ11.1 Kit Accessories
- RQ204 Requester Listing
- RQ250 Item Catalog
- RQ260 Requisitioned Items Report
- RQ35.1 Requisition Returns
- RQ500 Requisition Interface
- RQ94.1 Requester Audit Inquiry
- RQID.1 RQRQHUPD Invoke Object
- RQIF.1 RQRLNUPD Invoke Object
- RQIJ.1 Requisition Copy
- WH140 Bill Of Lading Print
- WH20.2 Nonstock and Special Allocation
- WH20.7 Substitute Location