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. ||   ||