HAZARD – Hazard Code

System
Inventory Control (IC)
Prefix
HAZ
Primary key
ITEM-GROUP, HAZARD-CODE
Fields
5
Updated by
4 programs
Referenced by
10 programs

HAZARD is the Hazard Code table in Lawson Inventory Control (prefix HAZ). It is indexed by ITEM-GROUP, HAZARD-CODE (HAZSET1). It is related 1:1 to ITEMGROUP. It is updated by IC09.1, IC10.2, IC11.1 and IC811 and referenced by IC00.1, IC110, IC209, IC330, IC511, IC512, PO30.1, PO30.4 and 2 more. The table has 5 fields, 1 index and 1 documented relation.

About HAZARD

The Hazard Code file contains valid hazard codes that can be attached to an Item Master record to identify the item as hazardous.

Fields (5)

Column = COBOL field name without the HAZ- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
HAZ-ITEM-GROUP PK
ITEM_GROUP
Alpha 5This field contains the identifier for a group of items that can be shared by one or more companies.IC09.1
HAZ-HAZARD-CODE PK
HAZARD_CODE
Alpha 8This field contains a short code describing why an item can be hazardous.IC09.1
HAZ-DESCRIPTION
DESCRIPTION
Alpha 30 (Lower Case)This field contains the description of the hazard code.IC09.1
HAZ-ACTIVE-STATUS
ACTIVE_STATUS
Alpha 1This field is used to limit the usage of specific hazard codes.
  • A Active
  • I Inactive
IC09.1
HAZ-USED-FL
USED_FL
Alpha 1This field indicates whether the code has been used on the Item Master file. Once a code has been used, it cannot be deleted, only made inactive.
  • N No
  • Y Yes
IC09.1, IC10.2, IC11.1, IC811

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
HAZSET1ITEM-GROUP, HAZARD-CODEPrimaryIC00.1, IC09.1, IC10.1, IC10.2, IC11.1, IC110, IC209, IC330 +7 more

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
ItemgroupITEMGROUPRequiredHAZ-ITEM-GROUPITG-ITEM-GROUP

Programs

Updated by (4)

Referenced by (10)