{$page} 



Updated: 2009-09-21



Version: Control 4.4



Table Purpose, Usage, and Notes 



This table is ...



Information on Table Data 
  * ClassTypeIDs Stores in Table:
    * 10400 - Transaction Variation
    * 11300 - PO Variation



Table Structure 



||~ Table.FieldName ||~ Data Type ||~ Description ||~ Links To ||
|| TransVariation.BasePrice || decimal(18, 4) ||  ||   ||
|| TransVariation.ClassTypeID || int || Identifier for the Type of Object ||   ||
|| TransVariation.CreatedDate || datetime ||  ||   ||
|| TransVariation.DiscountLevel || float ||  ||   ||
|| TransVariation.DiscountLevelOverridden || bit ||  ||   ||
|| TransVariation.DiscountPrice || decimal(18, 4) ||  ||   ||
|| TransVariation.HTMLLongFormat || text ||  ||   ||
|| TransVariation.HTMLShortFormat || text ||  ||   ||
|| TransVariation.ID || int || Primary Key for the Table ||   ||
|| TransVariation.IsActive || bit || Not Used for This Table ||   ||
|| TransVariation.IsSystem || bit || Used to Mark Required Records ||   ||
|| TransVariation.ModifiedByComputer || nvarchar(25) || HostName of computer that last modified this record ||   ||
|| TransVariation.ModifiedByUser || nvarchar(25) || Windows User who last modified this record ||   ||
|| TransVariation.ModifiedDate || datetime || DateTime this Record was last modified ||   ||
|| TransVariation.ModifierPrice || decimal(18, 4) ||  ||   ||
|| TransVariation.Notes || text ||  ||   ||
|| TransVariation.ParentClassTypeID || int ||  ||   ||
|| TransVariation.ParentID || int || ID of Category/Group Above ||   ||
|| TransVariation.PricingLevel || float ||  ||   ||
|| TransVariation.PricingLevelOverridden || bit ||  ||   ||
|| TransVariation.RawSubTotalPrice || decimal(18, 4) ||  ||   ||
|| TransVariation.RoundingPrice || decimal(18, 4) ||  ||   ||
|| TransVariation.SeqID || int ||  ||   ||
|| TransVariation.SonsBasePrice || decimal(18, 4) ||  ||   ||
|| TransVariation.SonsDiscountPrice || decimal(18, 4) ||  ||   ||
|| TransVariation.SonsModifierPrice || decimal(18, 4) ||  ||   ||
|| TransVariation.SonsRawSubTotalPrice || decimal(18, 4) ||  ||   ||
|| TransVariation.SonsRoundingPrice || decimal(18, 4) ||  ||   ||
|| TransVariation.SonsSubTotalPrice || decimal(18, 4) ||  ||   ||
|| TransVariation.SonsTaxablePrice || float ||  ||   ||
|| TransVariation.SonsTaxesPrice || decimal(18, 4) ||  ||   ||
|| TransVariation.SonsTotalPrice || decimal(18, 4) ||  ||   ||
|| TransVariation.SortIndex || int ||  ||   ||
|| TransVariation.StoreID || int || Not Used. ||   ||
|| TransVariation.SubTotalPrice || decimal(18, 4) ||  ||   ||
|| TransVariation.TaxablePrice || float ||  ||   ||
|| TransVariation.TaxesPrice || decimal(18, 4) ||  ||   ||
|| TransVariation.TotalPrice || decimal(18, 4) ||  ||   ||
|| TransVariation.TransactionType || int ||  ||   ||
|| TransVariation.VariationName || nvarchar(50) ||  ||   ||
Related Tables 



See Also 
  * Backlinks [[include_pagepage_componentbacklinks]]