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.