Lawson Insight Technical Documentation |
|
MSDSACK
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
BL120 BL122 BL130 BL20.1 BL20.3 BL21.2
BL21.5 BL29.1 BL29.2 BL520 BL820 WH20.2
WH20.7 WH225
UPDATED BY
BL92.1 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 BL92.1 WH130
Element: Company This field contains the company number. 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
MSA-ITEM Alpha 32 BL92.1 WH130
Element: Item This field contains the item WH132 WH190
identifier. 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-CUSTOMER Alpha 9 (Right Justified) BL92.1 WH130
Element: Customer This field contains the number that WH132 WH190
represents a customer. 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-SHIP-TO Numeric 4 BL92.1 WH130
Element: Ship To This field contains the number WH132 WH190
representing the ship to customer. 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-ACK-DATE Numeric 8 (yyyymmdd) BL92.1 WH130
Element: Ack Date This field contains the last date an WH132 WH190
MSDS document was sent to this customer WH30.1 WH30.2
for this item. The date defaults from WH30.3 WH30.4
the shipment date or when WH225 (MSDS WH31.1 WH31.2
Listing) was run. 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-DOCUMENT Alpha 30 BL92.1 WH130
Element: Msds Document The document number from the most WH132 WH190
recent MSDS that was received. 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-MSDS-VERSION Alpha 4 BL92.1 WH130
Element: Msds Version The version number of the most recent WH132 WH190
MSDS that was received. 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-LOCATION Alpha 5 BL92.1 WH130
Element: Location This field contains a valid stocking WH132 WH190
location within the company inventory. 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-SHIPMENT-NBR Numeric 10 BL92.1 WH130
Element: Shipment Nbr This field contains the shipment WH132 WH190
number. One order can have several WH30.1 WH30.2
shipment numbers if the items of the WH30.3 WH30.4
order were not shipped at the same time. 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
MSDSACK FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MSASET1 COMPANY BL120 BL122
ITEM BL130 BL20.1
CUSTOMER BL20.3 BL21.2
SHIP-TO BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
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
...
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
|