{$page} 



Updated: 2009-09-09



Version: Control 4.4



Table Purpose, Usage, and Notes 



This table is ...



This table is only used for Orders, Estimate, and Recurring Orders.  Bill, PO, and RD UDFs are not currently supported.



Information on Table Data 
  * ClassTypeIDs Stores in Table:
    * 10002 - TransHeader UDFs



Table Structure 



||~ Table.FieldName ||~ Data Type ||~ Description ||~ Links To ||
|| TransHeaderUserField.ClassTypeID || int || Identifier for the Type of Object ||   ||
|| TransHeaderUserField.ID || int || Primary Key for the Table || TransHeader.ID  ||
|| TransHeaderUserField.IsActive || bit || Not Used for This Table ||   ||
|| TransHeaderUserField.IsSystem || bit || Used to Mark Required Records ||   ||
|| TransHeaderUserField.ModifiedByComputer || nvarchar(25) || HostName of computer that last modified this record ||   ||
|| TransHeaderUserField.ModifiedByUser || nvarchar(25) || Windows User who last modified this record ||   ||
|| TransHeaderUserField.ModifiedDate || datetime || DateTime this Record was last modified ||   ||
|| TransHeaderUserField.SeqID || int ||  ||   ||
|| TransHeaderUserField.StoreID || int || Not Used. ||   ||
Additional Fields are added at the end of all UDF tables based on the UDFs created by the user.  The basic data types of these UDFs are: \\ ||~ UDF Type ||~ SQL Data Type ||
|| Numeric || float ||
|| String, Editbox, Drop-Down || Text ||
|| Date, Time, DateTime || datetime ||
|| Yes/No || nvarchar(1) ||
Related Tables 



See Also 
  * Backlinks [[include_pagepage_componentbacklinks]]