Updated: 2009-09-21

Version: Control 4.4

Table Purpose, Usage, and Notes

This table is …

Information on Table Data

  • ClassTypeIDs Stores in Table:
    • 10200 - Transaction Modifier

Table Structure

~ Table.FieldName ~ Data Type ~ Description ~ Links To
TransMod.ClassTypeID int Identifier for the Type of Object
TransMod.DiscountLevel float
TransMod.DiscountLevelOverridden bit
TransMod.FormattedText ntext
TransMod.GoodsItemClassTypeID int
TransMod.GoodsItemCode nvarchar(35) Modifier Code (text) for this TransMod
TransMod.GoodsItemID int ID of Modifier for this TransMod
TransMod.ID int Primary Key for the Table
TransMod.internalNotes text
TransMod.IsActive bit Not Used for This Table
TransMod.IsSystem bit Used to Mark Required Records
TransMod.List text
TransMod.ListID int
TransMod.MeAndSonsModifierPrice money
TransMod.ModifiedByComputer nvarchar(25) HostName of computer that last modified this record
TransMod.ModifiedByUser nvarchar(25) Windows User who last modified this record
TransMod.ModifiedDate datetime DateTime this Record was last modified
TransMod.ModifierCalcPrice money
TransMod.ModifierIsOverridden bit
TransMod.ModifierOverriddenPrice money
TransMod.ModifierPrice money
TransMod.ParentClassTypeID int
TransMod.ParentID int ID of Category/Group Above
TransMod.PartStr text
TransMod.PricingLevel float
TransMod.PricingLevelOverridden bit
TransMod.QuantityApplied float
TransMod.SeqID int
TransMod.SortOrder int
TransMod.StoreID int Not Used.
TransMod.TransactionType int
TransMod.TransHeaderClassTypeID int
TransMod.TransHeaderID int
TransMod.Units int
TransMod.UnitText nvarchar(8)
TransMod.ValueAsBinary Image
TransMod.ValueAsBlob Image
TransMod.ValueAsDatetime DateTime
TransMod.ValueAsFloat float
TransMod.ValueAsInteger int
TransMod.ValueAsString text
TransMod.ValueOverridden bit
TransMod.ValueType int

Related Tables

You could leave a comment if you were logged in.