 |
Lawson Insight Technical Documentation |
|
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
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 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 Numeric 4 WH130 WH132
Company This field contains the company number. 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 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
MSA-ITEM Alpha 32 WH130 WH132
Item Number This field contains the item WH190 WH30.1
identifier. WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
MSA-CUSTOMER Alpha 9 (Right Justified) WH130 WH132
Customer Number This field contains the number that WH190 WH30.1
represents a customer. WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
MSA-SHIP-TO Numeric 4 WH130 WH132
Ship-to Code This field contains the number WH190 WH30.1
representing the ship to customer. WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
MSA-ACK-DATE Numeric 8 (yyyymmdd) WH130 WH132
Acknowledgement Date This field contains the last date an WH190 WH30.1
MSDS document was sent to this customer WH30.2 WH30.3
for this item. The date defaults from WH30.4 WH31.1
the shipment date or when WH225 (MSDS WH31.2 WH31.3
Listing) was run. WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
MSA-MSDS-DOCUMENT Alpha 30 WH130 WH132
Msds Document The document number from the most WH190 WH30.1
recent MSDS that was received. WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
MSA-MSDS-VERSION Alpha 4 WH130 WH132
Msds Version The version number of the most recent WH190 WH30.1
MSDS that was received. WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
MSA-LOCATION Alpha 5 WH130 WH132
Location Code This field contains a valid stocking WH190 WH30.1
location within the company inventory. WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
MSA-SHIPMENT-NBR Numeric 10 WH130 WH132
Shipment Number This field contains the shipment WH190 WH30.1
number. One order can have several WH30.2 WH30.3
shipment numbers if the items of the WH30.4 WH31.1
order were not shipped at the same time. WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 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 This path is used to verify whether WH130 WH132
ITEM this MSDS item has had an acknowledgment WH190 WH20.2
CUSTOMER sent within a year. This is the most WH20.7 WH225
SHIP-TO used path. WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
...
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
|