Products
This class represents the products that are contained in a sales catalog.
Data Members
Data Member Name |
Data Type |
Default Value |
Description |
|---|---|---|---|
CatalogName |
nvarchar(255) |
Unknown |
Stores the name of the catalog that contains the product. |
cy_list_price |
money |
Null |
None. |
PrimaryParentCategory |
nvarchar(255) |
Unknown |
None. |
ProductId |
nvarchar(255) |
Unknown |
None. |
ProductNameCat |
nvarchar(400) |
Unknown |
Stores the catalog name concatenated with the product name and the variant name. |
VariantId |
nvarchar(255) |
Unknown |
None. |
IntroductionDate |
datetime |
Null |
The date the product was introduced. |
Name |
nvarchar(255) |
Null |
Stores the product name. |
Class Key
ProductsKey is composed of a single data member, ProductNameCat.
Relations
For a description of the relation type, see Data Warehouse Classes.
Relation Name |
Parent |
Child |
Type |
|---|---|---|---|
Category |
Category |
Products |
3 |
ProductsBasketRel |
Products |
Basket |
2 |
OrderFormLineItemsToProducts |
Products |
OrderFormLineItems |
2 |