| 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 |
(double-click a column header to select column text)
View Field Name | Table Name | Field Name | Comment | Generic Field Id |
|---|---|---|---|---|
| N_Cost | N_Product | N_Cost | The cost of the product | |
| N_Description | part_num | description | The product's description | |
| N_Domain | part_num | domain | Name of the domain for the part num. See object prt_domain | |
| N_EffectiveDate | price_inst | effective_date | Effective date of the list price of the product | |
| N_ExpirationDate | price_inst | expire_date | Expiration date of the list price of the product | |
| N_ImageFileName | N_Product | N_ImageFileName | Path and file name of a bitmap file associated with the product | |
| N_ImageURL | N_Product | N_ImageURL | URL of a GIF associated with this product | |
| N_ItemId | N_Product | objid | The product's associated N_Product internal record number | |
| N_ListPrice | price_inst | price | List price of the product | |
| N_ModificationDate | N_Product | N_ModificationDate | The date on which the product information was last modified | |
| N_ModLevelObjid | p_ml(mod_level) | objid | The product's mod_level internal record number | |
| N_OptionTreeId | N_CategoryTrees | objid | The ID of the category tree associated with the product | |
| N_Partnumber | part_num | part_number | The product's associated part number/name | |
| N_PartnumObjid | part_num | objid | The product's Part_num internal record number | |
| N_PricebookObjid | price_prog | objid | Price_prog internal record number | |
| N_PriceInstObjid | price_inst | objid | Price_inst internal record number | 3 (UNIQUE) |
| N_PriceQty | price_qty | priced_qty | The quantity of the priced part being quoted. Default=1 | |
| N_PriceQtyContext | c_ml(mod_level) | objid | The internal record number of the context part's mod_level | |
| N_PriceQtyObjid | price_qty | objid | Price_qty internal record number | |
| N_ProgName | price_prog | name | Name of the pricing program (price book) | |
| N_Revision | p_ml(mod_level) | mod_level | Name of the product's part revision | |
| N_TemplateId | N_Templates | objid | The ID of the template associated with the product | |
| objid | N_Product | objid | The product's associated N_Product internal record number |
Join From | Join To |
|---|---|
| p_ml(mod_level).part_info2part_num | (part_num).part_num2mod_level |
| (N_Product).N_Product2mod_level | p_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_level | p_ml(mod_level).priced_part2price_qty |
| (price_qty).context_part2mod_level | c_ml(mod_level).context_part2price_qty |
| (N_Product).n_prod2N_Templates | OUTER (N_Templates).n_templ2N_Product |
| (N_Product).n_prod2N_CategoryTrees | OUTER (N_CategoryTrees).n_catrees2N_Product |
| N_Products | |||