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 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 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
|
