Updated: 2009-11-23
Version: Control 4.4
Table Purpose, Usage, and Notes
This table is used to store Sales Goal information.
Information on Table Data
- ClassTypeIDs Stores in Table:
- 12053 - Sales Goal Month
- 12054 - Sales Goal Year
Table Structure
~ Table.FieldName | ~ Data Type | ~ Description | ~ Links To | ||||
SalesGoal.ClassTypeID | int | Identifier for the Type of Object | |||||
SalesGoal.Goal | float | Monetary value. | |||||
SalesGoal.GoalMonth | int | Goal month. NULL if ClassTypeID 12054 (Sales Goal Year) | |||||
SalesGoal.GoalYear | int | Goal year. | |||||
SalesGoal.ID | int | Primary Key for the Table | |||||
SalesGoal.IsActive | bit | Indicates if Enabled. 1Record is Active, 0Record is Not Active | |||||
SalesGoal.IsSystem | bit | Used to Mark Required Records | |||||
SalesGoal.ModifiedByComputer | varchar(25) | HostName of computer that last modified this record | |||||
SalesGoal.ModifiedByUser | varchar(25) | Windows User who last modified this record | |||||
SalesGoal.ModifiedDate | datetime | DateTime this Record was last modified | |||||
SalesGoal.SeqID | int | ||||||
SalesGoal.StoreID | int | Not Used. |
You could leave a comment if you were logged in.