'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.

 

 

 

 

 

 

 

The Harold & Inge Marcus Department of
Industrial & Manufacturing Engineering
310 Leonhard Building
University Park, PA 16802