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.