Updated: 2009-09-21
Version: Control 4.4
Table Purpose, Usage, and Notes
This table is …
Information on Table Data
- ClassTypeIDs Stores in Table:
- xxxxx -
- xxxxx -
Table Structure
| ~ Table.FieldName | ~ Data Type | ~ Description | ~ Links To | ||||
| PartInfoTemplate.ClassTypeID | int | Identifier for the Type of Object | |||||
| PartInfoTemplate.ID | int | Primary Key for the Table | |||||
| PartInfoTemplate.IsActive | bit | Indicates if Enabled. 1Record is Active, 0Record is Not Active | |||||
| PartInfoTemplate.IsSystem | bit | Used to Mark Required Records | |||||
| PartInfoTemplate.ModifiedByComputer | varchar(25) | HostName of computer that last modified this record | |||||
| PartInfoTemplate.ModifiedByUser | varchar(25) | Windows User who last modified this record | |||||
| PartInfoTemplate.ModifiedDate | datetime | DateTime this Record was last modified | |||||
| PartInfoTemplate.PartType | int | ||||||
| PartInfoTemplate.SeqID | int | ||||||
| PartInfoTemplate.StoreID | int | Not Used. | |||||
| PartInfoTemplate.Tags | text | ||||||
| PartInfoTemplate.TemplateName | varchar(50) | ||||||
| PartInfoTemplate.TemplateTypes | text | ||||||
| PartInfoTemplate.TemplateXML | text | ||||||
| PartInventoryConversion.ClassTypeID | int | Identifier for the Type of Object | |||||
| PartInventoryConversion.ConsumptionFormula | text | ||||||
| PartInventoryConversion.ConversionFormula | text | Expresson to convert this to standard units | |||||
| PartInventoryConversion.ID | int | Primary Key Field | |||||
| PartInventoryConversion.InclusionFormula | text | ||||||
| PartInventoryConversion.IsActive | bit | Indicates if Enabled. 1Record is Active, 0Record is Not Active | |||||
| PartInventoryConversion.IsAutomatic | bit | ||||||
| PartInventoryConversion.IsDefault | bit | 1 Default Unit for Part, 0 Not | |||||
| PartInventoryConversion.IsSystem | bit | Used to Mark Required Records | |||||
| PartInventoryConversion.ModifiedByComputer | nvarchar(25) | HostName of computer that last modified this record | |||||
| PartInventoryConversion.ModifiedByUser | nvarchar(25) | Windows User who last modified this record | |||||
| PartInventoryConversion.ModifiedDate | datetime | DateTime this Record was last modified | |||||
| PartInventoryConversion.PartID | int | ID of Part | Part.ID | ||||
| PartInventoryConversion.SeqID | int | ||||||
| PartInventoryConversion.StoreID | int | Not Used. | |||||
| PartInventoryConversion.UnitID | int | Enumated Value identifying the Unit | |||||
| PartInventoryConversion.UnitType | int |
Related Tables
You could leave a comment if you were logged in.