| Table Name: | N_Functions |
| Table Number: | 5410 |
| Group: | Configuration |
| Description: | Contains all the functions that modify behavior of the ClearConfigurator application. For example, the proposal script or job upload script would reside in this table. Also contains the product and option rules |
| 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_FunctionName | CHAR | varchar | 80 | ALLOW_NULL | The name of the function | |||
| N_ItemId | LONG | int | DIRECT, ALLOW_NULL | Used by the 'function_for' Exclusive Relations set. Contains the objid of the related object. See N_ItemTypeId field for the type identification of the related object | ||||
| N_ItemTypeId | LONG | int | DIRECT, ALLOW_NULL | Used by the 'function_for' Exclusive Relations set. Contains the object type_id of the related object See N_ItemId for the related object type | ||||
| N_ModificationDate | CLK_TIME | datetime | ALLOW_NULL | Date and time when the information was last modified | ||||
| N_SourceCode | CHAR | text | ALLOW_NULL | SalesBasic source code for the function | ||||
| 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_functn2N_Attachments | MTO | N_Attachments | n_attach2N_Functions | For a function of an attachment the attachment | function_for | N_ItemTypeId | N_ItemId | |||
| n_func2N_BreakPoints | OTM | N_BreakPoints | n_brkpnt2N_Functions | Breakpoints associated with the function | ||||||
| n_functn2N_Competitors | MTO | N_Competitors | n_compet2N_Functions | For a function of a competitor the competitor | function_for | N_ItemTypeId | N_ItemId | |||
| n_functn2N_ItemTypesEx | MTO | N_ItemTypesEx | n_xitmtyp2N_Functions | For a function of an ExtItemInst the ExtItemInst | function_for | N_ItemTypeId | N_ItemId | |||
| n_functn2N_Option | MTO | N_Option | n_optn2N_Functions | For a function of an option the option | function_for | N_ItemTypeId | N_ItemId | |||
| n_functn2N_Packages | MTO | N_Packages | n_pkg2N_Functions | For a function of a package the package | function_for | N_ItemTypeId | N_ItemId | |||
| n_functn2N_Product | MTO | N_Product | n_prod2N_Functions | For a function of a product the product | function_for | N_ItemTypeId | N_ItemId | |||
| n_functn2N_Templates | MTO | N_Templates | n_templ2N_Functions | For a function of a template the template | function_for | N_ItemTypeId | N_ItemId | |||
| n_func2N_Watches | OTM | N_Watches | n_wtch2N_Functions | Watches associated with the function | ||||||
| n_func2NWS_FolderMembers | OTM | NWS_FolderMembers | n_fldrmems2N_Functions | For a folder member of type function the function | member_of | N_ItemTypeId | N_ItemId | |||
| Index Name | Fields | Flags |
|---|---|---|
| I5410 | N_ItemId:N_ItemTypeId:N_FunctionName | UNIQUE |
| Index Name | Fields | Additional Information |
|---|---|---|
| fn | N_FunctionName | nonclustered located on PRIMARY |
| I5410 | N_ItemId, N_ItemTypeId, N_FunctionName | nonclustered, unique located on PRIMARY |
| itid | N_ItemTypeId, N_ItemId | nonclustered located on PRIMARY |
| objindex | objid | clustered, unique located on PRIMARY |
| View ID | View Name | Tables |
|---|
| N_Functions | |||