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.