MSDSACK FILE
Material Sfty Data Sht Acknwld
The Material Safety Data Sheet Acknowledgment (MSDS) file contains MSDS
acknowledgments by item and ship-to customer.
REFERENCED BY
WH225
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MSA-COMPANY Numeric 4
Company This field contains the company number.
MSA-ITEM Alpha 32
Item Number This field contains the item
identifier.
MSA-CUSTOMER Alpha 9 (Right Justified)
Customer Number This field contains the number that
represents a customer.
MSA-SHIP-TO Numeric 4
Ship-to Code This field contains the number
representing the ship to customer.
MSA-ACK-DATE Numeric 8 (yyyymmdd)
Acknowledgement 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.
MSA-MSDS-DOCUMENT Alpha 30
Msds Document The document number from the most
recent MSDS that was received.
MSA-MSDS-VERSION Alpha 4
Msds Version The version number of the most recent
MSDS that was received.
MSA-LOCATION Alpha 5
Location Code This field contains a valid stocking
location within the company inventory.
MSA-SHIPMENT-NBR Numeric 10
Shipment Number This field contains the shipment
number. One order can have several
shipment numbers if the items of the
order were not shipped at the same time.
MSDSACK FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MSASET1 COMPANY This path is used to verify whether WH225
ITEM this MSDS item has had an acknowledgment
CUSTOMER sent within a year. This is the most
SHIP-TO used path.
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
Whshipment WHSHIPMENT Required
MSA-COMPANY -> WHS-COMPANY
MSA-LOCATION -> WHS-LOCATION
MSA-SHIPMENT-NBR -> WHS-SHIPMENT-NBR
|
