MSDSACK FILE
Material Sfty Data Sht Acknwld
The Material Safety Data Sheet Acknowledgement (MSDS) file contains MSDS
acknowledgements by item and ship-to customer.
REFERENCED BY
BL92.1 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5
OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8
OE11.9 OE110 OE113 OE114 OE129 OE14.4
OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7
OE510 OE810 OE920 WH20.2 WH20.7 WH225
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MSA-COMPANY Numeric 4
Company This field contains the company number.
MSA-ITEM Alpha 32
Item This field contains the item
identifier.
MSA-CUSTOMER Alpha 9 (Right Justified)
Customer This field contains the number that
represents a customer.
MSA-SHIP-TO Numeric 4
Ship-to This field contains the number
representing the ship-to customer.
MSA-ACK-DATE Numeric 8 (yyyymmdd)
Date This field contains the last date an
MSDS document was sent to this customer
for this item. The date defaults from
the shipment date or when WH225 (MSDS
Listing) was run.
MSDSACK FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MSASET1 COMPANY This path is used to verify whether BL92.1 OE10.1
ITEM this MSDS item has had an OE10.2 OE10.3
CUSTOMER acknowledgement sent within a year. This OE10.4 OE10.5
SHIP-TO is the most used path. OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 WH20.2
WH20.7 WH225
MSDSACK FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Iccompany ICCOMPANY Required
MSA-COMPANY -> ICC-COMPANY
Itemmast ITEMMAST Required
ICC-ITEM-GROUP -> ITE-ITEM-GROUP
MSA-ITEM -> ITE-ITEM
Oecompany OECOMPANY Required
MSA-COMPANY -> OEC-COMPANY
Shipto SHIPTO Required
MSA-COMPANY -> SHP-COMPANY
MSA-CUSTOMER -> SHP-CUSTOMER
MSA-SHIP-TO -> SHP-SHIP-TO
|