Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                              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
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
Hazard Code          This field contains a short code
                     describing why an item can be hazardous.

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

HAZ-ACTIVE-STATUS    Alpha 1                                     IC09.1
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
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