Penn State University
Good evening, today is May 2, 2025
Welcome to Computer Integrated Manufacturing Unit in FAME
 
FAME
 


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

 
 
CIMLAB

 

 

 

 

 

 

 

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

You are now at the FAME>CIMLAB>Control Schema>Database>PRODUCT Table