Products and the descriptions
Product IDs are Unique, and are more unique if they include the Manufacture then Product Number, this way two identical product numbers from differing manufactures are not in interference
a Product gets placed onto a Price List, and a Product can Exist on more than One Price List and the sales price can be calculated from Markup of Current Cost, or Percent of List
Bulk editing the Product table requires that new entry products are entered in Draft or they will not import
When Customer Assets are Indexed Against Products, Then Under a Product you can find all the asset locations a product is used within your operation or your customers operations.
Each of these customer assets can have a Risk or Failure Mode Effect Analysis attachments to the customer asset.
The History of Customer Returns can be tracked under Return Material Authorizations