| 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 |
(double-click a column header to select column text)
View Field Name | Table Name | Field Name | Comment | Generic Field Id |
|---|---|---|---|---|
| N_Cost | n_o(N_Option) | N_Cost | The cost of the option | |
| N_Description | pn(part_num) | description | Description of the option | |
| N_Domain | pn(part_num) | domain | Name of the domain for the part num. See object prt_domain | |
| N_ImageFileName | n_o(N_Option) | N_ImageFileName | Path and file name of a bitmap file associated with this product | |
| N_ImageURL | n_o(N_Option) | N_ImageURL | URL of a GIF associated with this option | |
| N_ModificationDate | n_o(N_Option) | N_ModificationDate | The date on which this information was last modified | |
| N_ModLevelObjid | ml(mod_level) | objid | The option's mod_level internal record number | |
| N_OptionTreeId | N_CategoryTrees | objid | The ID of the category tree associated with this product | |
| N_Partnumber | pn(part_num) | part_number | Part number/name of the option | |
| N_PartnumObjid | pn(part_num) | objid | Part_num internal record number | |
| N_Revision | ml(mod_level) | mod_level | Name of the option's part revision | |
| N_TemplateId | N_Templates | objid | The ID of the template associated with this option | |
| objid | n_o(N_Option) | objid | N_Option internal record number | 3 (UNIQUE) |
Join From | Join To |
|---|---|
| n_o(N_Option).N_Option2mod_level | ml(mod_level).part_info2N_Option |
| ml(mod_level).part_info2part_num | pn(part_num).part_num2mod_level |
| n_o(N_Option).n_optn2N_CategoryTrees | OUTER (N_CategoryTrees).n_catrees2N_Option |
| n_o(N_Option).n_optn2N_Templates | OUTER (N_Templates).n_templ2N_Option |
| NWS_Options | |||