| Table Name: | N_Product |
| Table Number: | 5400 |
| Group: | Configuration |
| Description: | N_Product objects contain a product, properties and a collection of N_Option objects. N_Product objects are typically attached to N_Job objects |
| Flags: | CACHEOBJIDS |
| Baseline/Custom: | Baseline |
| Field Name | Common Type | Database Type | Generic Field ID | Array Size | Default | Flags | Comment | Field Used in Views |
|---|---|---|---|---|---|---|---|---|
| dev | LONG | int | 151 | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | ||
| N_Cost | DECIMAL | decimal (19,4) | ALLOW_NULL, CURRENCY | The cost of the product | Search (2) | |||
| N_ImageFileName | CHAR | varchar | 255 | ALLOW_NULL | Path and file name of a bitmap file associated with this product | Search (2) | ||
| N_ImageURL | CHAR | varchar | 255 | ALLOW_NULL | URL of a GIF associated with this product | Search (2) | ||
| N_ModificationDate | CLK_TIME | datetime | ALLOW_NULL | The date on which this information was last modified | Search (2) | |||
| N_OptionTreeId | LONG | int | DIRECT, ALLOW_NULL | The option category tree the configuration product uses. Reserved;obsolete | ||||
| N_TemplateId | LONG | int | DIRECT, ALLOW_NULL | The ID of the template associated with this product. Reserved;obsolete | ||||
| objid | LONG | int | 3 | DIRECT | Internal record number | Search (2) |
| Relation | Type | Target Object | Inverse Relation | Comment | Flags | MTM Table | Used in Views | Set Name | Type ID Stored in | Objid Stored In |
|---|---|---|---|---|---|---|---|---|---|---|
| Exclusive Set Relations | ||||||||||
| N_Product2mod_level | OTOP | mod_level | part_info2N_Product | Related part revision | Search (2) | |||||
| n_prod2N_CategoryMembers | OTM | N_CategoryMembers | n_catmems2N_Product | Category members the product belongs to | member_of | N_ItemTypeId | N_ItemId | |||
| n_prod2N_CategoryTrees | MTO | N_CategoryTrees | n_catrees2N_Product | The category tree used by the product | Search (2) | |||||
| n_prod2N_Functions | OTM | N_Functions | n_functn2N_Product | Related functions for the product | function_for | N_ItemTypeId | N_ItemId | |||
| n_prod2N_PackageMembers | OTM | N_PackageMembers | n_pkgmems2N_Product | Package members for the product | member_of | N_ItemTypeId | N_ItemId | |||
| n_prod2N_Properties | OTM | N_Properties | n_propts2N_Product | Properties for the product | extension_of | N_ItemTypeId | N_ItemId | |||
| n_prod2N_Templates | MTO | N_Templates | n_templ2N_Product | The template used by the product | Search (2) | |||||
| n_prod2NRW_RuleEventInfo | OTM | NRW_RuleEventInfo | nrw_ruleevnt2N_Product | Rule event information for the product | event_on | N_ItemTypeId | N_ItemId | |||
| n_prod2NRW_RuleInstances | OTM | NRW_RuleInstances | nrw_ruleinst2N_Product | Rule instance information for the product | ruleinst_for | N_ItemTypeId | N_ItemId | |||
| Index Name | Fields | Flags |
|---|---|---|
| I5400 | N_Product2mod_level | UNIQUE |
| Index Name | Fields | Additional Information |
|---|---|---|
| I5400 | N_Product2mod_level | nonclustered, unique located on PRIMARY |
| objindex | objid | clustered, unique located on PRIMARY |
| p2ct | n_prod2N_CategoryTrees | nonclustered located on PRIMARY |
| p2ml | N_Product2mod_level | nonclustered located on PRIMARY |
| p2t | n_prod2N_Templates | nonclustered located on PRIMARY |
| View ID | View Name | Tables |
|---|---|---|
| 5402 | N_Products | mod_level, N_CategoryTrees, N_Product, N_Templates, part_num, price_inst, price_prog, price_qty |
| 5437 | NWS_Products | mod_level, N_CategoryTrees, N_Product, N_Templates, part_num |
| N_Product | |||