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