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

Fields:

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

Joins:

Join FromJoin To
n_o(N_Option).N_Option2mod_levelml(mod_level).part_info2N_Option
ml(mod_level).part_info2part_numpn(part_num).part_num2mod_level
n_o(N_Option).n_optn2N_CategoryTreesOUTER (N_CategoryTrees).n_catrees2N_Option
n_o(N_Option).n_optn2N_TemplatesOUTER (N_Templates).n_templ2N_Option
My Recent Objects
NWS_Options