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
 |