View Name:N_Options
View Number:5429
Group:Configuration
Description:Configuration option view which assembles option, part, version, and cost information
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline
select * from table_N_Options
Keyboard shortcuts available

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
objidN_OptionobjidThe option's associated N_Option internal record number 
N_ItemIdN_OptionobjidThe option's associated N_Option internal record number 
N_TemplateIdN_TemplatesobjidThe ID of the template associated with the option 
N_OptionTreeIdN_CategoryTreesobjidThe ID of the category tree associated with the option 
N_Partnumberpart_numpart_numberThe option's associated part number/name 
N_Descriptionpart_numdescriptionThe option's description 
N_CostN_OptionN_CostThe cost of the option 
N_ImageFileNameN_OptionN_ImageFileNamePath and file name of an image file associated with the option 
N_ModificationDateN_OptionN_ModificationDateThe date on which the option information was last modified 
N_Revisionp_ml(mod_level)mod_levelName of the option's part revision 
N_PartnumObjidpart_numobjidThe option's Part_num internal record number 
N_ModLevelObjidp_ml(mod_level)objidThe option'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 option 
N_EffectiveDateprice_insteffective_dateEffective date of the list price of the option 
N_ExpirationDateprice_instexpire_dateExpiration date of the list price of the option 
N_PricebookObjidprice_progobjidPrice_prog internal record number 
N_ImageURLN_OptionN_ImageURLURL of a GIF associated with this option 
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_Option).N_Option2mod_levelp_ml(mod_level).part_info2N_Option
(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_Option).n_optn2N_TemplatesOUTER (N_Templates).n_templ2N_Option
(N_Option).n_optn2N_CategoryTreesOUTER (N_CategoryTrees).n_catrees2N_Option
My Recent Objects
N_Options      
       
       
Quick Links
act_entry case contact employee
rol_contct site site_view user