View Name:NWS_Products
View Number:5437
Group:Configuration
Description:Workshop product view which includes product, part, version, and costing information
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
objidn_p(N_Product)objidN_Product internal record number 3 (UNIQUE)
N_TemplateIdN_TemplatesobjidThe ID of the template associated with this product 
N_OptionTreeIdN_CategoryTreesobjidThe ID of the category tree associated with this product 
N_Partnumberpn(part_num)part_numberPart number/name 
N_Descriptionpn(part_num)descriptionDescription of the product 
N_ImageFileNamen_p(N_Product)N_ImageFileNamePath and file name of a bitmap file associated with the product 
N_ModificationDaten_p(N_Product)N_ModificationDateThe date on which the information was last modified 
N_Costn_p(N_Product)N_CostThe cost of the product 
N_PartNumObjidpn(part_num)objidPart_num internal record number 
N_ModLevelObjidml(mod_level)objidThe product's mod_level internal record number 
N_Revisionml(mod_level)mod_levelName of the product's part revision 
N_ImageURLn_p(N_Product)N_ImageURLURL of a GIF associated with this product 
N_Domainpn(part_num)domainName of the domain for the part num. See object prt_domain 

Joins:

Join FromJoin To
n_p(N_Product).N_Product2mod_levelml(mod_level).part_info2N_Product
ml(mod_level).part_info2part_numpn(part_num).part_num2mod_level
n_p(N_Product).n_prod2N_CategoryTreesOUTER (N_CategoryTrees).n_catrees2N_Product
n_p(N_Product).n_prod2N_TemplatesOUTER (N_Templates).n_templ2N_Product
My Recent Objects
NWS_Products