| Table Name: | N_ItemTypesEx |
| Table Number: | 5438 |
| Group: | Configuration |
| Description: | Extension item types. This object type has the same schema as N_ItemTypes and holds the records that were removed from N_ItemTypes (Global, Application, Workshop, Product Category Tree, Category tree, Product Category, Option Category) |
| 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 | Type of the external item instance; i.e., 0=Global, 1=Application, 2=Workshop, 3=Product Category Tree, 4=Category tree, 5=Product Category, 6=Option Category | ||||
| N_ItemTypeName | CHAR | varchar | 50 | ALLOW_NULL | The type of the item; e.g., Global, Application, Workshop, etc etc | |||
| N_ModificationDate | CLK_TIME | datetime | ALLOW_NULL | Date and time when the information was last modified | ||||
| objid | LONG | int | 3 | DIRECT | Internal record number |
| 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_xitmtyp2N_CategoryTrees | OTM | N_CategoryTrees | n_categorytrees2N_ItemTypesEx | For a tree of an N_ExtItemType the N_ExtItemType | member_of | N_ItemTypeId | N_ItemId | |||
| n_xitmtyp2N_Functions | OTM | N_Functions | n_functn2N_ItemTypesEx | Functions for the extension item type | function_for | N_ItemTypeId | N_ItemId | |||
| n_xitmtyp2NRW_RuleEventInfo | OTM | NRW_RuleEventInfo | nrw_ruleevnt2N_ItemTypesEx | Rule event information for the extension item type | event_on | N_ItemTypeId | N_ItemId | |||
| n_xitmtyp2NRW_RuleInstances | OTM | NRW_RuleInstances | nrw_ruleinst2N_ItemTypesEx | Rule instance information for the external item instance | ruleinst_for | N_ItemTypeId | N_ItemId | |||
| n_xitmtyp2NWS_Trees | OTM | NWS_Trees | nws_trees2N_ItemTypesEx | For a folder of an N_ExtItemType the N_ExtItemType | member_of | N_ItemTypeId | N_ItemId | |||
| Index Name | Fields | Flags |
|---|---|---|
| I5438 | N_ItemTypeId | UNIQUE |
| Index Name | Fields | Additional Information |
|---|---|---|
| I5438 | N_ItemTypeId | nonclustered, unique located on PRIMARY |
| objindex | objid | clustered, unique located on PRIMARY |
| View ID | View Name | Tables |
|---|
| N_ItemTypesEx | |||