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