|
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 IC209 IC330 PO30.1 POIE.1 WH140
UPDATED BY
IC09.1 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: Active Status This field is used to limit the usage
of specific hazard codes.
A = Active
I = Inactive
HAZ-USED-FL Alpha 1 IC09.1 IC11.1
Element: Used Fl This field indicates whether the code 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 IC11.1 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
|