{$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

You could leave a comment if you were logged in.