Updated: 2009-09-21
Version: Control 4.4
Table Purpose, Usage, and Notes
This table is used to store individual variable values linked to transdetail records. For example, in order to show the Height variable value on a report, you must save the variable's value in this table.
Information on Table Data
- ClassTypeIDs Stores in Table:
- 14030 - Transaction Detail Parameter
Table Structure
~ Table.FieldName | ~ Data Type | ~ Description | ~ Links To | ||||
TransDetailParam.BlobType | int | ||||||
TransDetailParam.ClassTypeID | int | Identifier for the Type of Object | |||||
TransDetailParam.FormattedText | text | ||||||
TransDetailParam.ID | int | Primary Key for the Table | |||||
TransDetailParam.IsActive | bit | Not Used for This Table | |||||
TransDetailParam.IsSystem | bit | Used to Mark Required Records | |||||
TransDetailParam.ListID | int | ||||||
TransDetailParam.ListValue | int | ||||||
TransDetailParam.ModifiedByComputer | nvarchar(25) | HostName of computer that last modified this record | |||||
TransDetailParam.ModifiedByUser | nvarchar(25) | Windows User who last modified this record | |||||
TransDetailParam.ModifiedDate | datetime | DateTime this Record was last modified | |||||
TransDetailParam.Overridden | bit | ||||||
TransDetailParam.ParameterClassTypeID | int | ||||||
TransDetailParam.ParameterID | int | ||||||
TransDetailParam.ParameterName | nvarchar(25) | ||||||
TransDetailParam.ParentClassTypeID | int | ||||||
TransDetailParam.ParentID | int | TransDetail.ID | |||||
TransDetailParam.SeqID | int | ||||||
TransDetailParam.StoreID | int | Not Used. | |||||
TransDetailParam.TransactionType | int | ||||||
TransDetailParam.TransHeaderClassTypeID | int | ||||||
TransDetailParam.TransHeaderID | int | ||||||
TransDetailParam.Units | int | ||||||
TransDetailParam.ValueAsBinary | image | ||||||
TransDetailParam.ValueAsBlob | image | ||||||
TransDetailParam.ValueAsDateTime | datetime | ||||||
TransDetailParam.ValueAsFloat | float | ||||||
TransDetailParam.ValueAsInteger | int | ||||||
TransDetailParam.ValueAsStr25 | nvarchar(25) | ||||||
TransDetailParam.ValueAsString | text | ||||||
TransDetailParam.ValueType | int | ||||||
TransDetailParam.VariableID | int |
Related Tables
You could leave a comment if you were logged in.