View Name:N_Products
View Number:5402
Group:Configuration
Description:Configuration product view which assembles product, part, version, and pricing information
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline
select * from table_N_Products
Keyboard shortcuts available

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
objidN_ProductobjidThe product's associated N_Product internal record number 
N_ItemIdN_ProductobjidThe product's associated N_Product internal record number 
N_TemplateIdN_TemplatesobjidThe ID of the template associated with the product 
N_OptionTreeIdN_CategoryTreesobjidThe ID of the category tree associated with the product 
N_Partnumberpart_numpart_numberThe product's associated part number/name 
N_Descriptionpart_numdescriptionThe product's description 
N_CostN_ProductN_CostThe cost of the product 
N_ImageFileNameN_ProductN_ImageFileNamePath and file name of a bitmap file associated with the product 
N_ModificationDateN_ProductN_ModificationDateThe date on which the product information was last modified 
N_Revisionp_ml(mod_level)mod_levelName of the product's part revision 
N_PartnumObjidpart_numobjidThe product's Part_num internal record number 
N_ModLevelObjidp_ml(mod_level)objidThe product's mod_level internal record number 
N_PriceQtyObjidprice_qtyobjidPrice_qty internal record number 
N_PriceQtyprice_qtypriced_qtyThe quantity of the priced part being quoted. Default=1 
N_PriceQtyContextc_ml(mod_level)objidThe internal record number of the context part's mod_level 
N_ProgNameprice_progname Name of the pricing program (price book) 
N_PriceInstObjidprice_instobjidPrice_inst internal record number 3 (UNIQUE)
N_ListPriceprice_instpriceList price of the product 
N_EffectiveDateprice_insteffective_dateEffective date of the list price of the product 
N_ExpirationDateprice_instexpire_dateExpiration date of the list price of the product 
N_PricebookObjidprice_progobjidPrice_prog internal record number 
N_ImageURLN_ProductN_ImageURLURL of a GIF associated with this product 
N_Domainpart_numdomainName of the domain for the part num. See object prt_domain 

Joins:

Join FromJoin To
p_ml(mod_level).part_info2part_num(part_num).part_num2mod_level
(N_Product).N_Product2mod_levelp_ml(mod_level).part_info2N_Product
(price_inst).price_inst2price_prog(price_prog).price_prog2price_inst
(price_inst).price_inst2price_qty(price_qty).price_qty2price_inst
(price_qty).priced_part2mod_levelp_ml(mod_level).priced_part2price_qty
(price_qty).context_part2mod_levelc_ml(mod_level).context_part2price_qty
(N_Product).n_prod2N_TemplatesOUTER (N_Templates).n_templ2N_Product
(N_Product).n_prod2N_CategoryTreesOUTER (N_CategoryTrees).n_catrees2N_Product
My Recent Objects
N_Products      
       
       
Quick Links
act_entry case contact employee
rol_contct site site_view user