| Table Name: | N_Templates |
| Table Number: | 5420 |
| Group: | Configuration |
| Description: | Stores default properties or event procedures that are identical for all the products or options based on it. These can be overridden on an individual basis |
| Flags: | |
| 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_EffectiveDate | CLK_TIME | datetime | ALLOW_NULL | The first date on which the information should be used | ||||
| N_ExpirationDate | CLK_TIME | datetime | ALLOW_NULL | Last date when the information should be used | ||||
| N_ItemTypeId | LONG | int | DIRECT, ALLOW_NULL | Item type from N_ItemType table. It is used in conjunction with the N_ItemId field to identify to the item | ||||
| N_ModificationDate | CLK_TIME | datetime | ALLOW_NULL | Date and time when the information was last modified | ||||
| N_TemplateName | CHAR | varchar | 50 | ALLOW_NULL | The name of the template | |||
| objid | LONG | int | 3 | DIRECT | Internal record number | Search (4) |
| 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_templ2N_AttributeDefinition | OTM | N_AttributeDefinition | def2N_Templates | Attribute Definition that may acquire the Template | ||||||
| n_templ2N_Functions | OTM | N_Functions | n_functn2N_Templates | Functions using the template | function_for | N_ItemTypeId | N_ItemId | |||
| n_templ2N_Option | OTM | N_Option | n_optn2N_Templates | Options using the template | ||||||
| n_templ2N_Packages | OTM | N_Packages | n_pkg2N_Templates | Packages using the template | ||||||
| n_templ2N_Product | OTM | N_Product | n_prod2N_Templates | Products using the template | ||||||
| n_templ2N_Properties | OTM | N_Properties | n_propts2N_Templates | Properties using the template | extension_of | N_ItemTypeId | N_ItemId | |||
| n_templ2NRW_RuleEventInfo | OTM | NRW_RuleEventInfo | nrw_ruleevnt2N_Templates | Rule event information for the template | event_on | N_ItemTypeId | N_ItemId | |||
| n_templ2NRW_RuleInstances | OTM | NRW_RuleInstances | nrw_ruleinst2N_Templates | Rule instance information for the template | ruleinst_for | N_ItemTypeId | N_ItemId | |||
| Index Name | Fields | Flags |
|---|---|---|
| I5420 | N_ItemTypeId:N_TemplateName | UNIQUE |
| Index Name | Fields | Additional Information |
|---|---|---|
| I5420 | N_ItemTypeId, N_TemplateName | nonclustered, unique located on PRIMARY |
| itid | N_ItemTypeId | nonclustered located on PRIMARY |
| objindex | objid | clustered, unique located on PRIMARY |
| tn | N_TemplateName | 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 |
| 5429 | N_Options | mod_level, N_CategoryTrees, N_Option, N_Templates, part_num, price_inst, price_prog, price_qty |
| 5436 | NWS_Options | mod_level, N_CategoryTrees, N_Option, N_Templates, part_num |
| 5437 | NWS_Products | mod_level, N_CategoryTrees, N_Product, N_Templates, part_num |
| N_Templates | |||