MSDSACK

Material Sfty Data Sht Acknwld

The Material Safety Data Sheet Acknowledgment (MSDS) file contains MSDS acknowledgments by item and ship-to customer.

REFERENCED BY
WH20.2 WH20.7 WH225


UPDATED BY
WH130 WH132 WH190 WH30.1 WH30.2 WH30.3
WH30.4 WH31.1 WH31.2 WH31.3 WH31.4 WH32.1
WH32.2 WH32.3 WH32.4 WH32.5 WH33.5 WH34.1
WH34.2 WH34.3 WH34.4 WH40.1 WH40.2 WH520
WH830

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MSA-COMPANY
Element: Company		Numeric 4
This field contains the company number.
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH32.5
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
MSA-ITEM
Element: Item		Alpha 32
This field contains the item identifier.
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH32.5
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
MSA-CUSTOMER
Element: Customer		Alpha 9 (Right Justified)
This field contains the number that represents a customer.
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH32.5
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
MSA-SHIP-TO
Element: Ship To		Numeric 4
This field contains the number representing the ship to customer.
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH32.5
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
MSA-ACK-DATE
Element: Ack Date		Numeric 8 (yyyymmdd)
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.
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH32.5
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
MSA-MSDS-DOCUMENT
Element: Msds Document		Alpha 30
The document number from the most recent MSDS that was received.
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH32.5
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
MSA-MSDS-VERSION
Element: Msds Version		Alpha 4
The version number of the most recent MSDS that was received.
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH32.5
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
MSA-LOCATION
Element: Location		Alpha 5
This field contains a valid stocking location within the company inventory.
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH32.5
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
MSA-SHIPMENT-NBR
Element: Shipment Nbr		Numeric 10
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.
WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH32.5
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830


MSDSACK FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MSASET1 COMPANY
ITEM
CUSTOMER
SHIP-TO
...
WH130 WH132
WH190 WH20.2
WH20.7 WH225
WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
WH32.5 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3


MSDSACK FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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

File created: Thu Jun 09 02:33:41 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.