'PRODUCT' Table

The ‘Product’ table is linked to the Material
table through its ‘Material_ID’ field. This relation has been
created to identify the material availability and other information
regarding the material required to make a manufacturability decision.
The ‘Product_ID’ field links this table to the two tables
discussed in separate sections, which contain the process plan information
regarding that product.
The ‘Design_Specs’ field would provide an
OLE link to a Pro_Engineering (Release 18i) file containing the product
design. Apart from providing all the information regarding a product
in a table, this field can potentially be used later to link to any
application for ‘re-designing’ of the part, or for feature
extraction purposes.
The ‘In Hand’ field provides information
regarding the available inventory of finished product and the ‘Produced_Qty’
indicates the total number of units manufactured during a particular
time period. The number of units of material required for producing
an unit of the part is also contained in this table.