MSDSACK – Material Sfty Data Sht Acknwld

System
Warehouse (WH)
Prefix
MSA
Primary key
COMPANY, ITEM, CUSTOMER, SHIP-TO
Fields
9
Updated by
25 programs
Referenced by
3 programs

MSDSACK is the Material Sfty Data Sht Acknwld table in Lawson Warehouse (prefix MSA). It is indexed by COMPANY, ITEM, CUSTOMER, SHIP-TO (MSASET1). It is related 1:1 to ICCOMPANY, ITEMMAST, OECOMPANY, SHIPTO and WHSHIPMENT. It is updated by WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 and 17 more and referenced by WH20.2, WH20.7 and WH225. The table has 9 fields, 1 index and 5 documented relations.

About MSDSACK

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

Fields (9)

Column = COBOL field name without the MSA- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
MSA-COMPANY PK
COMPANY		Numeric 4This field contains the company number.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +17 more
MSA-ITEM PK
ITEM		Alpha 32This field contains the item identifier.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +17 more
MSA-CUSTOMER PK
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 +17 more
MSA-SHIP-TO PK
SHIP_TO		Numeric 4This field contains the number representing the ship to customer.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +17 more
MSA-ACK-DATE
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 +17 more
MSA-MSDS-DOCUMENT
MSDS_DOCUMENT		Alpha 30The document number from the most recent MSDS that was received.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +17 more
MSA-MSDS-VERSION
MSDS_VERSION		Alpha 4The version number of the most recent MSDS that was received.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +17 more
MSA-LOCATION
LOCATION		Alpha 5This field contains a valid stocking location within the company inventory.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +17 more
MSA-SHIPMENT-NBR
SHIPMENT_NBR		Numeric 10This 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 +17 more

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
MSASET1COMPANY, ITEM, CUSTOMER, SHIP-TOPrimaryWH130, WH132, WH190, WH20.2, WH20.7, WH225, WH30.1, WH30.2 +22 more (list truncated in source)

Relations

One to one (5) — lookups and parents

RelationTableRulesConditionField map
IccompanyICCOMPANYRequiredMSA-COMPANY → ICC-COMPANY
ItemmastITEMMASTRequiredICC-ITEM-GROUP → ITE-ITEM-GROUP, MSA-ITEM → ITE-ITEM
OecompanyOECOMPANYRequiredMSA-COMPANY → OEC-COMPANY
ShiptoSHIPTORequiredMSA-COMPANY → SHP-COMPANY, MSA-CUSTOMER → SHP-CUSTOMER, MSA-SHIP-TO → SHP-SHIP-TO
WhshipmentWHSHIPMENTRequiredMSA-COMPANY → WHS-COMPANY, MSA-LOCATION → WHS-LOCATION, MSA-SHIPMENT-NBR → WHS-SHIPMENT-NBR

Programs

Updated by (25)

Referenced by (3)