Table Crm_Promotional_Packages

Entity

Promotional packages are packages of products, which are sold together at a special pricing and discount conditions. Entity: Crm_Promotional_Packages

Summary

Name	Type	Description
Active	`bit`	Package status: 1 = the offer is available for new documents; 0 = otherwise
Campaign_Id	`uniqueidentifier`	Тhe marketing campaign to which the current definition belongs.
Document_Amount_Type_Id	`uniqueidentifier`	The document amount type that is used as а category. When specified, triggers the recording of the applied discount amount from the promotional package in the Document Distributed Amounts panel in sales orders.
Enterprise_Company_Id	`uniqueidentifier`	When not NULL, indicates that the package is valid only for the specified enterprise company.
Enterprise_Company_Location_Id	`uniqueidentifier`
Promotional_Package_Code	`nvarchar(20)`	Unique code of the promotional package
Promotional_Package_Id	`uniqueidentifier` `PK`
Promotional_Package_Name	`nvarchar(254)`
Row_Version	`timestamp`
Valid_For_Customer_Filter_XML	`nvarchar(max)`	When not NULL, the package is valid only for the customers, that match the filter
Valid_For_Customer_Id	`uniqueidentifier`	When not NULL, the package is valid only for the specified customer
Valid_For_Distribution_Channel_Filter_XML	`nvarchar(max)`	When not NULL, the package is valid only if the specified distribution channel of the sales order fits in the filter criteria.
Valid_For_Distribution_Channel_Id	`uniqueidentifier`	When not NULL, the package is valid only for the specified distribution channel of the sales order
Valid_For_Price_List_Id	`uniqueidentifier`	When not NULL, the package is valid only for the specified price list
Valid_For_Ship_To_Customer_Filter_XML	`nvarchar(max)`	When not NULL, specifies validity condition for the Ship To Customer of the sales document.
Valid_For_Ship_To_Customer_Id	`uniqueidentifier`	When not NULL, specifies that the package is valid only when the sales document is for the specified Ship To Customer.
Valid_For_Target_Group_Id	`uniqueidentifier`	When not NULL, the package is valid only for the specified customer target group
Valid_From_Date	`date`	When not NULL specifies the first date when the package is valid for offering. The date is compared against the document date
Valid_To_Date	`date`	When not NULL specifies the last date (inclusive) when the package is valid. The date is compared against the document date

Columns

Active

Package status: 1 = the offer is available for new documents; 0 = otherwise

Property	Value
Auto Complete	no
Data Filter	no
Default Value	True
Enter Stop	no
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
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	bit
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Active - Supported Filters

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

Campaign_Id

Тhe marketing campaign to which the current definition belongs.

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	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	Crm_Campaigns
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

Campaign_Id - Supported Filters

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

Document_Amount_Type_Id

The document amount type that is used as а category. When specified, triggers the recording of the applied discount amount from the promotional package in the Document Distributed Amounts panel in sales orders.

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	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	Gen_Document_Amount_Types
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

Document_Amount_Type_Id - Supported Filters

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

Enterprise_Company_Id

When not NULL, indicates that the package is valid only for the specified enterprise company.

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	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	Gen_Enterprise_Companies
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

Enterprise_Company_Id - Supported Filters

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

Enterprise_Company_Location_Id

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	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	Cm_Company_Locations
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

Enterprise_Company_Location_Id - Supported Filters

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

Promotional_Package_Code

Unique code of the promotional package

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	20
Order	1
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	yes
Summary Type	None
Supports EQUALS_IN	no
Type	nvarchar(20)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Promotional_Package_Code - Supported Filters

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

Promotional_Package_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	2147483647
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

Promotional_Package_Id - Supported Filters

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

Promotional_Package_Name

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	254
Order	2
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	yes
Summary Type	None
Supports EQUALS_IN	no
Type	nvarchar(254)
UI Memo Editor	no
UI Width	Long
User Login	no
Visible	yes

Promotional_Package_Name - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	`NULL`	no	no
Like	None	no	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	2147483647
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

Valid_For_Customer_Filter_XML

When not NULL, the package is valid only for the customers, that match the filter

Property	Value
Auto Complete	no
Data Filter	yes
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	2147483647
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	nvarchar(max) (Allows NULL)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Valid_For_Customer_Id

When not NULL, the package is valid only for the specified customer

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	7
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	Crm_Customers
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

Valid_For_Customer_Id - Supported Filters

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

Valid_For_Distribution_Channel_Filter_XML

When not NULL, the package is valid only if the specified distribution channel of the sales order fits in the filter criteria.

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

Valid_For_Distribution_Channel_Id

When not NULL, the package is valid only for the specified distribution channel of the sales order

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	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	Crm_Distribution_Channels
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

Valid_For_Distribution_Channel_Id - Supported Filters

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

Valid_For_Price_List_Id

When not NULL, the package is valid only for the specified price list

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	6
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	Crm_Price_Lists
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

Valid_For_Price_List_Id - Supported Filters

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

Valid_For_Ship_To_Customer_Filter_XML

When not NULL, specifies validity condition for the Ship To Customer of the sales document.

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

Valid_For_Ship_To_Customer_Id

When not NULL, specifies that the package is valid only when the sales document is for the specified Ship To Customer.

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	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	Crm_Customers
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

Valid_For_Ship_To_Customer_Id - Supported Filters

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

Valid_For_Target_Group_Id

When not NULL, the package is valid only for the specified customer target group

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	8
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	Crm_Target_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

Valid_For_Target_Group_Id - Supported Filters

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

Valid_From_Date

When not NULL specifies the first date when the package is valid for offering. The date is compared against the document date

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	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	date (Allows NULL)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Valid_From_Date - Supported Filters

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

Valid_To_Date

When not NULL specifies the last date (inclusive) when the package is valid. The date is compared against the document date

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	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	date (Allows NULL)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Valid_To_Date - Supported Filters

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

Table of Contents