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     PO221     PO30.1    RQ120
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   IC811
                                                                 PO221   PO30.1
                                                                 RQ120   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