Table of Contents

Table Crm_Product_Distribution_Channels

Entity

Entity: Crm.Marketing.ProductDistributionChannels

Channel assignments (listing) for products. Entity: Crm_Product_Distribution_Channels

Owner Tables Hierarchy

Summary

Name Type Description
Distribution_Channel_Id uniqueidentifier The distribution channel in which the product is listed
From_Date date When the product was listed. NULL-the product was not yet listed. The data is for informational purposes only and does not affect the listing status of the product (Is_Active does)
Is_Active bit Is this product listing active? 1=Yes, 0=No
Minimal_Sales_Price_Per_Lot decimal(18, 4) Minimal allowed price for sales of this product through this channel. The price is for one standard lot and in the costing currency of the product. The minimum is enforced upon planning and/or releasing a document. NULL means that there is no minimal sales price enforcement.
Minimal_Sales_Quantity_Base decimal(18, 3) Minimal base quantity of the current product that has to be specified in any sale for this distribution channel.
Product_Distribution_Channel_Id uniqueidentifier PK Product, listed at distribution channel
Product_Id uniqueidentifier The listed product
Row_Version timestamp
To_Date date When the product was de-listed. NULL=unknown or the product was not de-listed. The data is for informational purposes only and does not affect the listing status of the product (Is_Active does)

Columns

Distribution_Channel_Id

The distribution channel in which the product is listed

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

Distribution_Channel_Id - Supported Filters

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

From_Date

When the product was listed. NULL-the product was not yet listed. The data is for informational purposes only and does not affect the listing status of the product (Is_Active does)

Property Value
Auto Complete no
Data Filter no
Default Value CurrentDate
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 date (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

From_Date - Supported Filters

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

Is_Active

Is this product listing active? 1=Yes, 0=No

Property Value
Auto Complete no
Data Filter no
Default Value True
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 bit
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Is_Active - Supported Filters

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

Minimal_Sales_Price_Per_Lot

Minimal allowed price for sales of this product through this channel. The price is for one standard lot and in the costing currency of the product. The minimum is enforced upon planning and/or releasing a document. NULL means that there is no minimal sales price enforcement.

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Format N2
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 decimal(18, 4) (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Minimal_Sales_Quantity_Base

Minimal base quantity of the current product that has to be specified in any sale for this distribution channel.

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

Product_Distribution_Channel_Id

Product, listed at distribution channel

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

Product_Distribution_Channel_Id - Supported Filters

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

Product_Id

The listed product

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

Product_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

To_Date

When the product was de-listed. NULL=unknown or the product was not de-listed. The data is for informational purposes only and does not affect the listing status of the product (Is_Active does)

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

To_Date - Supported Filters

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