Updated: 2009-09-17



Version: Control 4.4



Table Purpose, Usage, and Notes 



The IOTemplate (Input/Output Template) Table is used to store all pricing forms and product layouts.



Information on Table Data 
  * ClassTypeIDs Stores in Table:
    * 15000 - Pricing Forms (Input Templates)
    * 15010 - Product Layouts (Output Templates)
  * The template type is also stored as a separate field called TemplateType which use the following enumerated values:
    * 1  Pricing Form Template
    * 2  Product Layout



Table Structure 



||~ Table.FieldName ||~ Data Type ||~ Description ||~ Links To ||
|| IOTemplate.CategoryID || int || ID of the Category || [[sql_structure_-_pricingelement_table]].ID \\ where ClassTypeID  15001 (Input Template Category) or ClassTypeID  15011 (Output Template Category) \\  ||
|| IOTemplate.ClassTypeID || int || Identifier for the Type of Object ||   ||
|| IOTemplate.ID || int || Primary Key Field ||  ||
|| IOTemplate.IsActive || bit || Indicates if Enabled.  1Record is Active, 0Record is Not Active ||   ||
|| IOTemplate.IsSystem || bit || Used to Mark Required Records ||   ||
|| IOTemplate.ModifiedByComputer || nvarchar(25) || HostName of computer that last modified this record ||   ||
|| IOTemplate.ModifiedByUser || nvarchar(25) || Windows User who last modified this record ||   ||
|| IOTemplate.ModifiedDate || datetime || DateTime this Record was last modified ||   ||
|| IOTemplate.SeqID || int ||  ||   ||
|| IOTemplate.StoreID || int || Not Used. ||   ||
|| IOTemplate.Template || text || Text version of the template ||  ||
|| IOTemplate.TemplateName || nvarchar(30) || Name of the Template ||  ||
|| IOTemplate.TemplateType || int || Enumerated Type of this Template \\   1  Pricing Form Template \\   2  Product Layout ||  ||
|| IOTemplate.TextFormat || int ||  ||   ||
Related Tables