Table of Contents

Table Crm_Sales_Order_Promotional_Packages

Entity

Entity: Crm.Sales.SalesOrderPromotionalPackages

Sales Order Promotional Packages represent promotional bundles or offers applied within a Sales Order. This data type defines the promotional packages included in a sales order, consisting of a predefined combination of products or services offered under special commercial conditions, such as bundled pricing, discounts, or promotional rules. Promotional packages are used to apply, track, and analyze promotions in sales orders, ensuring consistent pricing, correct fulfillment, and accurate reporting of promotion-driven sales. Entity: Crm_Sales_Order_Promotional_Packages

Owner Tables Hierarchy

Summary

Name Type Description
Line_Number int Consecutive line number of the package, unique within the document.
Number_Of_Packages int Number of packages sold
Promotional_Package_Id uniqueidentifier The type of promotional package sold
Row_Version timestamp
Sales_Order_Id uniqueidentifier
Sales_Order_Promotional_Package_Id uniqueidentifier PK

Columns

Line_Number

Consecutive line number of the package, unique within the document.

Property Value
Auto Complete no
Autoincrement 1
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 int
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Line_Number - Supported Filters

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

Number_Of_Packages

Number of packages sold

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 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 int
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Promotional_Package_Id

The type of promotional package sold

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

Promotional_Package_Id - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL 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

Sales_Order_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 yes
Pasword no
Picture no
Primary Key no
Readonly no
Referenced Table Crm_Sales_Orders
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_Order_Id - Supported Filters

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

Sales_Order_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

Sales_Order_Promotional_Package_Id - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no yes
GreaterThanOrLessThan None no yes
Suggest improvement to this page