Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

HAZARD


                              HAZARD FILE

                              Hazard Code

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

REFERENCED BY

IC00.1    IC110     IC209     IC330     PO30.1    POIE.1
WH140

UPDATED BY

IC09.1    IC10.2    IC11.1    IC811

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

HAZ-ITEM-GROUP         Alpha 5                                   IC09.1
Element: Item Group    This field contains the identifier for
                       a group of items that can be shared by
                       one or more companies.

HAZ-HAZARD-CODE        Alpha 8                                   IC09.1
Element: Hazard Code   This field contains a short code
                       describing why an item can be hazardous.

HAZ-DESCRIPTION        Alpha 30  (Lower Case)                    IC09.1
Element: Description   This field contains the description of
                       the hazard code.

HAZ-ACTIVE-STATUS      Alpha 1                                   IC09.1
Element: Status        This field is used to limit the usage
                       of specific hazard codes.
                       A = Active
                       I = Inactive

HAZ-USED-FL            Alpha 1                                   IC09.1  IC10.2
Element: Used          This field indicates whether the code     IC11.1  IC811
                       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

                         HAZARD FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

HAZSET1   ITEM-GROUP                                             IC00.1  IC09.1
          HAZARD-CODE                                            IC10.1  IC10.2
                                                                 IC11.1  IC110
                                                                 IC209   IC330
                                                                 IC811   PO30.1
                                                                 POIE.1  WH140

                         HAZARD FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Itemgroup      ITEMGROUP    Required

                            HAZ-ITEM-GROUP    -> ITG-ITEM-GROUP