Table Crm_Sales_Person_Target_Lines

Entity

Entity: Crm.SalesForce.SalesPersonTargetLines

Detail records (lines) of targets for sales persons. Entity: Crm_Sales_Person_Target_Lines

Owner Tables Hierarchy

Summary

Name	Type	Description
Bonus_Program_Id	`uniqueidentifier`	Bonus program Id when the target type is BONUS, NULL otherwise
Period_Date	`datetime` Readonly	Calculated date representation of the target period (used for grouping, filtering and other auxiliary purposes)
Period_Month	`tinyint`	Month of the period in which the target must be fulfilled (the period is determined by specifying a month and an year)
Period_Year	`smallint`	Year of the period in which the target must be fulfilled (the period is determined by specifying a month and an year)
Product_Group_Id	`uniqueidentifier`	Product group for which the target is defined
Promotional_Package_Id	`uniqueidentifier`	Promotional Package Id when the target type is PROMO, NULL otherwise
Row_Version	`timestamp`
Sales_Person_Id	`uniqueidentifier`	Sales person to whom the target is assigned
Sales_Person_Target_Id	`uniqueidentifier`
Sales_Person_Target_Line_Id	`uniqueidentifier` `PK`
Target_Amount	`decimal(18, 2)`	Target amount to be fulfilled by the specified sales person. Deprecated - use Target_Value
Target_Amount_Currency_Id	`uniqueidentifier`	Deprecated - use currency in document header
Target_Type	`nvarchar(5)` Allowed: `SALES`, `BONUS`, `PROMO`, `LOCNT`	Type of target. Defines the meaning of Target_Value. SALES-sales amount, BONUS-count of bonus progs, PACK-count of promo packs
Target_Value	`decimal(9, 2)`	Value of target. Meaning depends on target type
Target_Weight	`decimal(5, 2)`	Relative weight of target, comparatively to other targets

Columns

Bonus_Program_Id

Bonus program Id when the target type is BONUS, NULL otherwise

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	11
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	Crm_Bonus_Programs
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	yes
Type	uniqueidentifier (Allows NULL)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Bonus_Program_Id - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	`NULL`	yes	no

Period_Date

Calculated date representation of the target period (used for grouping, filtering and other auxiliary purposes)

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	14
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	yes
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	datetime
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Period_Date - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
GreaterThanOrLessThan	None	no	no

Period_Month

Month of the period in which the target must be fulfilled (the period is determined by specifying a month and an year)

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	4
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	tinyint
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Period_Month - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
GreaterThanOrLessThan	None	no	no

Period_Year

Year of the period in which the target must be fulfilled (the period is determined by specifying a month and an year)

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	5
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	smallint
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Period_Year - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
GreaterThanOrLessThan	None	no	no

Product_Group_Id

Product group for which the target is defined

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	3
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	Gen_Product_Groups
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	yes
Type	uniqueidentifier (Allows NULL)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Product_Group_Id - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	`NULL`	yes	no

Promotional_Package_Id

Promotional Package Id when the target type is PROMO, NULL otherwise

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	12
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	Crm_Promotional_Packages
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	yes
Type	uniqueidentifier (Allows NULL)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Promotional_Package_Id - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	`NULL`	yes	no

Row_Version

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	13
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	timestamp
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	no

Sales_Person_Id

Sales person to whom the target is assigned

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	2
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	Crm_Sales_Persons
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	yes
Type	uniqueidentifier
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Sales_Person_Id - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	`NULL`	no	no

Sales_Person_Target_Id

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	no
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	1
Ownership Reference	yes
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	Crm_Sales_Person_Targets
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	yes
Type	uniqueidentifier
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Sales_Person_Target_Id - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	`NULL`	no	no

Sales_Person_Target_Line_Id

Property	Value
Auto Complete	no
Data Filter	no
Default Value	NewGuid
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	0
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	yes (order: 1)
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	yes
Type	uniqueidentifier
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	no

Sales_Person_Target_Line_Id - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	`NULL`	no	yes

Target_Amount

Target amount to be fulfilled by the specified sales person. Deprecated - use Target_Value

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	6
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	decimal(18, 2) (Allows NULL)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	no

Target_Amount_Currency_Id

Deprecated - use currency in document header

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	7
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	Gen_Currencies
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	yes
Type	uniqueidentifier (Allows NULL)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Target_Amount_Currency_Id - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	`NULL`	yes	no

Target_Type

Type of target. Defines the meaning of Target_Value. SALES-sales amount, BONUS-count of bonus progs, PACK-count of promo packs

Property	Value
Allowed Values	`SALES`, `BONUS`, `PROMO`, `LOCNT`
Auto Complete	no
Data Filter	no
Default Value	SALES
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	5
Order	8
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	yes
Type	nvarchar(5)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Target_Type - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	`NULL`	no	no

Target_Value

Value of target. Meaning depends on target type

Property	Value
Auto Complete	no
Data Filter	no
Default Value	0
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	9
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	decimal(9, 2)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Target_Weight

Relative weight of target, comparatively to other targets

Property	Value
Auto Complete	no
Data Filter	no
Default Value	1
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	10
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	decimal(5, 2)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Table of Contents