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 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
OE111 OE113 OE116 OE129 OE13.2 OE13.3
OE13.5 OE13.6 OE14.4 OE30.1 OE30.2 OE30.3
OE30.4 OE30.5 OE30.6 OE30.7 OE30.9 OE510
OE530 OE810 OE830 WH20.2 WH20.7 WH225
UPDATED BY
BL92.1 OE114 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 OE114
Element: Company 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 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
MSA-ITEM Alpha 32 BL92.1 OE114
Element: Item Number This field contains the item WH130 WH132
identifier. 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-CUSTOMER Alpha 9 (Right Justified) BL92.1 OE114
Element: Customer NumbeThis field contains the number that WH130 WH132
represents a customer. 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-SHIP-TO Numeric 4 BL92.1 OE114
Element: Ship-to Code This field contains the number WH130 WH132
representing the ship to customer. 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-ACK-DATE Numeric 8 (yyyymmdd) BL92.1 OE114
Element: AcknowledgemenThis field contains the last date an WH130 WH132
MSDS document was sent to this customer WH190 WH30.1
for this item. The date defaults from WH30.2 WH30.3
the shipment date or when WH225 (MSDS WH30.4 WH31.1
Listing) was run. 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-DOCUMENT Alpha 30 BL92.1 OE114
Element: Msds Document The document number from the most WH130 WH132
recent MSDS that was received. 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-MSDS-VERSION Alpha 4 BL92.1 OE114
Element: Msds Version The version number of the most recent WH130 WH132
MSDS that was received. 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-LOCATION Alpha 5 BL92.1 OE114
Element: Location Code This field contains a valid stocking WH130 WH132
location within the company inventory. 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-SHIPMENT-NBR Numeric 10 BL92.1 OE114
Element: Shipment NumbeThis field contains the shipment WH130 WH132
number. One order can have several WH190 WH30.1
shipment numbers if the items of the WH30.2 WH30.3
order were not shipped at the same time. 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
MSDSACK FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MSASET1 COMPANY This path is used to verify whether BL120 BL122
ITEM this MSDS item has had an acknowledgment BL130 BL20.1
CUSTOMER sent within a year. This is the most BL20.3 BL21.2
SHIP-TO used path. BL21.5 BL29.1
BL29.2 BL520
BL820 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 OE111
OE113 OE114
OE116 OE129
...
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
|