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
You could leave a comment if you were logged in.