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