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.