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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
MSASET1
  1. COMPANY
  2. ITEM
  3. CUSTOMER
  4. SHIP-TO
PrimaryWH130, WH132, WH190, WH20.2, WH20.7, WH225, WH30.1, WH30.2 +22 more (list truncated in source)

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
ICCOMPANYITEMMASTOECOMPANYSHIPTOWHSHIPMENTMSDSACK

One to one (5) — lookups and parents

RelationTableRulesConditionField map
IccompanyICCOMPANYRequired
MSA-COMPANY→ICC-COMPANY
ItemmastITEMMASTRequired
ICC-ITEM-GROUP→ITE-ITEM-GROUP
MSA-ITEM→ITE-ITEM
OecompanyOECOMPANYRequired
MSA-COMPANY→OEC-COMPANY
ShiptoSHIPTORequired
MSA-COMPANY→SHP-COMPANY
MSA-CUSTOMER→SHP-CUSTOMER
MSA-SHIP-TO→SHP-SHIP-TO
WhshipmentWHSHIPMENTRequired
MSA-COMPANY→WHS-COMPANY
MSA-LOCATION→WHS-LOCATION
MSA-SHIPMENT-NBR→WHS-SHIPMENT-NBR

Programs

Updated by (25)

Referenced by (3)