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
You could leave a comment if you were logged in.