Product table/entity reference

Note

Unsure about table vs. entity? See Developers: Understand terminology in Microsoft Dataverse.

Information about products and their pricing information.

Added by: Product Management Solution

Messages

Message Web API Operation SDK class or method
Associate Associate and disassociate entities AssociateRequest or
Associate
CloneProduct CloneProductRequest
Create POST /products
See Create
CreateRequest or
Create
CreateMultiple CreateMultiple CreateMultipleRequest
Delete DELETE /products(productid)
See Delete
DeleteRequest or
Delete
Disassociate Associate and disassociate entities DisassociateRequest or
Disassociate
PublishProductHierarchy PublishProductHierarchyRequest
Retrieve GET /products(productid)
See Retrieve
RetrieveRequest or
Retrieve
RetrieveMultiple GET /products
See Query Data
RetrieveMultipleRequest or
RetrieveMultiple
RevertProduct RevertProductRequest
SetState PATCH /products(productid)
Update statecode and statuscode properties.
SetStateRequest
Update PATCH /products(productid)
See Update
UpdateRequest or
Update
UpdateMultiple UpdateMultiple UpdateMultipleRequest

Properties

Property Value
CollectionSchemaName Products
DisplayCollectionName Products
DisplayName Product
EntitySetName products
IsBPFEntity False
LogicalCollectionName products
LogicalName product
OwnershipType OrganizationOwned
PrimaryIdAttribute productid
PrimaryNameAttribute name
SchemaName Product

Writable columns/attributes

These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.

CurrentCost

Property Value
Description Current cost for the product item. Used in price calculations.
DisplayName Current Cost
IsValidForForm True
IsValidForRead True
LogicalName currentcost
MaxValue 1000000000000
MinValue 0
Precision 2
PrecisionSource 1
RequiredLevel None
Type Money

DefaultUoMId

Property Value
Description Default unit for the product.
DisplayName Default Unit
IsValidForForm True
IsValidForRead True
LogicalName defaultuomid
RequiredLevel ApplicationRequired
Targets uom
Type Lookup

DefaultUoMScheduleId

Property Value
Description Default unit group for the product.
DisplayName Unit Group
IsValidForForm True
IsValidForRead True
LogicalName defaultuomscheduleid
RequiredLevel ApplicationRequired
Targets uomschedule
Type Lookup

Description

Property Value
Description Description of the product.
DisplayName Description
Format TextArea
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName description
MaxLength 2000
RequiredLevel None
Type Memo

DMTImportState

Property Value
Description Internal Use Only
DisplayName Internal Use Only
Format None
IsValidForForm False
IsValidForRead False
LogicalName dmtimportstate
MaxValue 2147483647
MinValue -2147483648
RequiredLevel None
Type Integer

EntityImage

Added by: Active Solution Solution

Property Value
Description Shows the default image for the record.
DisplayName Entity Image
IsPrimaryImage True
IsValidForForm False
IsValidForRead True
LogicalName entityimage
MaxHeight 144
MaxWidth 144
RequiredLevel None
Type Image

ImportSequenceNumber

Property Value
Description Sequence number of the import that created this record.
DisplayName Import Sequence Number
Format None
IsValidForForm False
IsValidForRead True
IsValidForUpdate False
LogicalName importsequencenumber
MaxValue 2147483647
MinValue -2147483648
RequiredLevel None
Type Integer

IsKit

Property Value
Description Information that specifies whether the product is a kit.
DisplayName Is Kit
IsValidForForm True
IsValidForRead True
LogicalName iskit
RequiredLevel None
Type Boolean

IsKit Choices/Options

Value Label Description
1 Yes
0 No

DefaultValue: 0

IsReparented

Added by: Product Management Patch Solution

Property Value
Description
DisplayName Is Reparented
IsValidForForm True
IsValidForRead True
LogicalName isreparented
RequiredLevel None
Type Boolean

IsReparented Choices/Options

Value Label Description
1 Yes
0 No

DefaultValue: 0

IsStockItem

Property Value
Description Information about whether the product is a stock item.
DisplayName Stock Item
IsValidForForm True
IsValidForRead True
LogicalName isstockitem
RequiredLevel None
Type Boolean

IsStockItem Choices/Options

Value Label Description
1 Yes
0 No

DefaultValue: 0

msdyn_gdproptout

Added by: Predictive Opportunity Scoring Solution

Property Value
Description Describes whether product is opted out or not
DisplayName GDPR Optout
IsValidForForm True
IsValidForRead True
LogicalName msdyn_gdproptout
RequiredLevel None
Type Boolean

msdyn_gdproptout Choices/Options

Value Label Description
1 Yes
0 No

DefaultValue: 0

Name

Property Value
Description Name of the product.
DisplayName Name
FormatName Text
IsLocalizable True
IsValidForForm True
IsValidForRead True
LogicalName name
MaxLength 100
RequiredLevel ApplicationRequired
Type String

OverriddenCreatedOn

Property Value
DateTimeBehavior UserLocal
Description Date and time that the record was migrated.
DisplayName Record Created On
Format DateOnly
IsValidForForm False
IsValidForRead True
IsValidForUpdate False
LogicalName overriddencreatedon
RequiredLevel None
Type DateTime

ParentProductId

Property Value
Description Specifies the parent product family hierarchy.
DisplayName Parent
IsValidForForm True
IsValidForRead True
LogicalName parentproductid
RequiredLevel None
Targets product
Type Lookup

Price

Property Value
Description List price for the product item. Used in price calculations.
DisplayName List Price
IsValidForForm True
IsValidForRead True
LogicalName price
MaxValue 1000000000000
MinValue 0
Precision 2
PrecisionSource 1
RequiredLevel None
Type Money

PriceLevelId

Property Value
Description Select the default price list for the product.
DisplayName Default Price List
IsValidForCreate False
IsValidForForm True
IsValidForRead True
LogicalName pricelevelid
RequiredLevel Recommended
Targets pricelevel
Type Lookup

ProcessId

Property Value
Description Contains the id of the process associated with the entity.
DisplayName Process Id
IsValidForForm False
IsValidForRead True
LogicalName processid
RequiredLevel None
Type Uniqueidentifier

ProductId

Property Value
Description Unique identifier of the product.
DisplayName Product
IsValidForForm False
IsValidForRead True
IsValidForUpdate False
LogicalName productid
RequiredLevel SystemRequired
Type Uniqueidentifier

ProductNumber

Property Value
Description User-defined product ID.
DisplayName Product ID
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName productnumber
MaxLength 100
RequiredLevel SystemRequired
Type String

ProductStructure

Property Value
Description Product Structure.
DisplayName Product Structure
IsValidForForm True
IsValidForRead True
IsValidForUpdate False
LogicalName productstructure
RequiredLevel SystemRequired
Type Picklist

ProductStructure Choices/Options

Value Label Description
1 Product
2 Product Family
3 Product Bundle

ProductTypeCode

Property Value
Description Type of product.
DisplayName Product Type
IsValidForForm True
IsValidForRead True
LogicalName producttypecode
RequiredLevel None
Type Picklist

ProductTypeCode Choices/Options

Value Label Description
1 Sales Inventory
2 Miscellaneous Charges
3 Services
4 Flat Fees

ProductUrl

Property Value
Description URL for the Website associated with the product.
DisplayName URL
FormatName Url
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName producturl
MaxLength 255
RequiredLevel None
Type String

QuantityDecimal

Property Value
Description Number of decimal places that can be used in monetary amounts for the product.
DisplayName Decimals Supported
Format None
IsValidForForm True
IsValidForRead True
LogicalName quantitydecimal
MaxValue 5
MinValue 0
RequiredLevel ApplicationRequired
Type Integer

QuantityOnHand

Property Value
Description Quantity of the product in stock.
DisplayName Quantity On Hand
IsValidForForm True
IsValidForRead True
LogicalName quantityonhand
MaxValue 1000000000
MinValue 0
Precision 2
RequiredLevel None
Type Decimal

Size

Property Value
Description Product size.
DisplayName Size
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName size
MaxLength 200
RequiredLevel None
Type String

StageId

Property Value
Description Contains the id of the stage where the entity is located.
DisplayName (Deprecated) Stage Id
IsValidForForm False
IsValidForRead True
LogicalName stageid
RequiredLevel None
Type Uniqueidentifier

StandardCost

Property Value
Description Standard cost for the product item. Used in price calculations.
DisplayName Standard Cost
IsValidForForm True
IsValidForRead True
LogicalName standardcost
MaxValue 1000000000000
MinValue 0
Precision 2
PrecisionSource 1
RequiredLevel None
Type Money

StateCode

Property Value
Description Status of the product.
DisplayName Status
IsValidForForm True
IsValidForRead True
LogicalName statecode
RequiredLevel SystemRequired
Type State

StateCode Choices/Options

Value Label DefaultStatus InvariantName
0 Active 1 Active
1 Retired 2 Inactive
2 Draft 0 Draft
3 Under Revision 3 Under Revision

StatusCode

Property Value
Description Reason for the status of the product.
DisplayName Status Reason
IsValidForForm True
IsValidForRead True
LogicalName statuscode
RequiredLevel None
Type Status

StatusCode Choices/Options

Value Label State
0 Draft 2
1 Active 0
2 Retired 1
3 Under Revision 3

StockVolume

Property Value
Description Stock volume of the product.
DisplayName Stock Volume
IsValidForForm True
IsValidForRead True
LogicalName stockvolume
MaxValue 1000000000
MinValue 0
Precision 2
RequiredLevel None
Type Decimal

StockWeight

Property Value
Description Stock weight of the product.
DisplayName Stock Weight
IsValidForForm True
IsValidForRead True
LogicalName stockweight
MaxValue 1000000000
MinValue 0
Precision 2
RequiredLevel None
Type Decimal

SubjectId

Property Value
Description Select a category for the product.
DisplayName Subject
IsValidForForm True
IsValidForRead True
LogicalName subjectid
RequiredLevel None
Targets subject
Type Lookup

SupplierName

Property Value
Description Name of the product's supplier.
DisplayName Supplier Name
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName suppliername
MaxLength 100
RequiredLevel None
Type String

TimeZoneRuleVersionNumber

Property Value
Description For internal use only.
DisplayName Time Zone Rule Version Number
Format None
IsValidForForm False
IsValidForRead True
LogicalName timezoneruleversionnumber
MaxValue 2147483647
MinValue -1
RequiredLevel None
Type Integer

TransactionCurrencyId

Property Value
Description Unique identifier of the currency associated with the product.
DisplayName Currency
IsValidForForm True
IsValidForRead True
LogicalName transactioncurrencyid
RequiredLevel None
Targets transactioncurrency
Type Lookup

TraversedPath

Property Value
Description A comma separated list of string values representing the unique identifiers of stages in a Business Process Flow Instance in the order that they occur.
DisplayName (Deprecated) Traversed Path
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName traversedpath
MaxLength 1250
RequiredLevel None
Type String

UTCConversionTimeZoneCode

Property Value
Description Time zone code that was in use when the record was created.
DisplayName UTC Conversion Time Zone Code
Format None
IsValidForForm False
IsValidForRead True
LogicalName utcconversiontimezonecode
MaxValue 2147483647
MinValue -1
RequiredLevel None
Type Integer

ValidFromDate

Property Value
DateTimeBehavior DateOnly
Description Date from which this product is valid.
DisplayName Valid From
Format DateOnly
IsValidForForm True
IsValidForRead True
LogicalName validfromdate
RequiredLevel None
Type DateTime

ValidToDate

Property Value
DateTimeBehavior DateOnly
Description Date to which this product is valid.
DisplayName Valid To
Format DateOnly
IsValidForForm True
IsValidForRead True
LogicalName validtodate
RequiredLevel None
Type DateTime

VendorID

Property Value
Description Unique identifier of vendor supplying the product.
DisplayName Vendor ID
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName vendorid
MaxLength 100
RequiredLevel None
Type String

VendorName

Property Value
Description Name of the product vendor.
DisplayName Vendor
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName vendorname
MaxLength 100
RequiredLevel None
Type String

VendorPartNumber

Property Value
Description Unique part identifier in vendor catalog of this product.
DisplayName Vendor Name
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName vendorpartnumber
MaxLength 100
RequiredLevel None
Type String

Read-only columns/attributes

These columns/attributes return false for both IsValidForCreate or IsValidForUpdate. Listed by SchemaName.

CreatedBy

Property Value
Description Unique identifier of the user who created the product.
DisplayName Created By
IsValidForForm True
IsValidForRead True
LogicalName createdby
RequiredLevel None
Targets systemuser
Type Lookup

CreatedByExternalParty

Property Value
Description Shows the external party who created the record.
DisplayName Created By (External Party)
IsValidForForm True
IsValidForRead True
LogicalName createdbyexternalparty
RequiredLevel None
Targets externalparty
Type Lookup

CreatedByExternalPartyName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName createdbyexternalpartyname
MaxLength 100
RequiredLevel None
Type String

CreatedByExternalPartyYomiName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName createdbyexternalpartyyominame
MaxLength 100
RequiredLevel None
Type String

CreatedByName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName createdbyname
MaxLength 100
RequiredLevel None
Type String

CreatedByYomiName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName createdbyyominame
MaxLength 100
RequiredLevel None
Type String

CreatedOn

Property Value
DateTimeBehavior UserLocal
Description Date and time when the record was created.
DisplayName Created On
Format DateAndTime
IsValidForForm True
IsValidForRead True
LogicalName createdon
RequiredLevel None
Type DateTime

CreatedOnBehalfBy

Property Value
Description Unique identifier of the delegate user who created the product.
DisplayName Created By (Delegate)
IsValidForForm True
IsValidForRead True
LogicalName createdonbehalfby
RequiredLevel None
Targets systemuser
Type Lookup

CreatedOnBehalfByName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName createdonbehalfbyname
MaxLength 100
RequiredLevel None
Type String

CreatedOnBehalfByYomiName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName createdonbehalfbyyominame
MaxLength 100
RequiredLevel None
Type String

CurrentCost_Base

Property Value
Description Value of the Current Cost in base currency.
DisplayName Current Cost (Base)
IsValidForForm True
IsValidForRead True
LogicalName currentcost_base
MaxValue 922337203685477
MinValue -922337203685477
Precision 4
PrecisionSource 1
RequiredLevel None
Type Money

DefaultUoMIdName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName defaultuomidname
MaxLength 100
RequiredLevel SystemRequired
Type String

DefaultUoMScheduleIdName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName defaultuomscheduleidname
MaxLength 100
RequiredLevel SystemRequired
Type String

EntityImage_Timestamp

Property Value
Description
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName entityimage_timestamp
MaxValue 9223372036854775807
MinValue -9223372036854775808
RequiredLevel None
Type BigInt

EntityImage_URL

Property Value
Description
DisplayName
FormatName Url
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName entityimage_url
MaxLength 200
RequiredLevel None
Type String

EntityImageId

Property Value
Description
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName entityimageid
RequiredLevel None
Type Uniqueidentifier

ExchangeRate

Added by: Active Solution Solution

Property Value
Description Exchange rate for the currency associated with the product with respect to the base currency.
DisplayName Exchange Rate
IsValidForForm True
IsValidForRead True
LogicalName exchangerate
MaxValue 100000000000
MinValue 0.000000000001
Precision 12
RequiredLevel None
Type Decimal

HierarchyPath

Property Value
Description Hierarchy path of the product.
DisplayName Hierarchy Path
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName hierarchypath
MaxLength 450
RequiredLevel None
Type String

ModifiedBy

Property Value
Description Unique identifier of the user who last modified the product.
DisplayName Modified By
IsValidForForm True
IsValidForRead True
LogicalName modifiedby
RequiredLevel None
Targets systemuser
Type Lookup

ModifiedByExternalParty

Property Value
Description Shows the external party who modified the record.
DisplayName Modified By (External Party)
IsValidForForm True
IsValidForRead True
LogicalName modifiedbyexternalparty
RequiredLevel None
Targets externalparty
Type Lookup

ModifiedByExternalPartyName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName modifiedbyexternalpartyname
MaxLength 100
RequiredLevel None
Type String

ModifiedByExternalPartyYomiName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName modifiedbyexternalpartyyominame
MaxLength 100
RequiredLevel None
Type String

ModifiedByName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName modifiedbyname
MaxLength 100
RequiredLevel None
Type String

ModifiedByYomiName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName modifiedbyyominame
MaxLength 100
RequiredLevel None
Type String

ModifiedOn

Property Value
DateTimeBehavior UserLocal
Description Date and time when the record was modified.
DisplayName Modified On
Format DateAndTime
IsValidForForm True
IsValidForRead True
LogicalName modifiedon
RequiredLevel None
Type DateTime

ModifiedOnBehalfBy

Property Value
Description Unique identifier of the delegate user who last modified the product.
DisplayName Modified By (Delegate)
IsValidForForm True
IsValidForRead True
LogicalName modifiedonbehalfby
RequiredLevel None
Targets systemuser
Type Lookup

ModifiedOnBehalfByName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName modifiedonbehalfbyname
MaxLength 100
RequiredLevel None
Type String

ModifiedOnBehalfByYomiName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName modifiedonbehalfbyyominame
MaxLength 100
RequiredLevel None
Type String

OrganizationId

Property Value
Description Unique identifier for the organization
DisplayName Organization Id
IsValidForForm False
IsValidForRead True
LogicalName organizationid
RequiredLevel SystemRequired
Targets organization
Type Lookup

OrganizationIdName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName organizationidname
MaxLength 100
RequiredLevel SystemRequired
Type String

ParentProductIdName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName parentproductidname
MaxLength 100
RequiredLevel None
Type String

Price_Base

Property Value
Description Value of the List Price in base currency.
DisplayName List Price (Base)
IsValidForForm True
IsValidForRead True
LogicalName price_base
MaxValue 922337203685477
MinValue -922337203685477
Precision 4
PrecisionSource 1
RequiredLevel None
Type Money

PriceLevelIdName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName pricelevelidname
MaxLength 100
RequiredLevel SystemRequired
Type String

StandardCost_Base

Property Value
Description Value of the Standard Cost in base currency.
DisplayName Standard Cost (Base)
IsValidForForm True
IsValidForRead True
LogicalName standardcost_base
MaxValue 922337203685477
MinValue -922337203685477
Precision 4
PrecisionSource 1
RequiredLevel None
Type Money

SubjectIdName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName subjectidname
MaxLength 100
RequiredLevel None
Type String

TransactionCurrencyIdName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName transactioncurrencyidname
MaxLength 100
RequiredLevel None
Type String

VersionNumber

Property Value
Description Version Number
DisplayName Version Number
IsValidForForm False
IsValidForRead True
LogicalName versionnumber
MaxValue 9223372036854775807
MinValue -9223372036854775808
RequiredLevel None
Type BigInt

One-To-Many Relationships

Listed by SchemaName.

product_parent_product

Same as the product_parent_product many-to-one relationship for the product table/entity.

Property Value
ReferencingEntity product
ReferencingAttribute parentproductid
IsHierarchical True
IsCustomizable True
ReferencedEntityNavigationPropertyName product_parent_product
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

Product_ProductAssociation_AssocProd

Same as the Product_ProductAssociation_AssocProd many-to-one relationship for the productassociation table/entity.

Property Value
ReferencingEntity productassociation
ReferencingAttribute associatedproduct
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName Product_ProductAssociation_AssocProd
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order: 10000
CascadeConfiguration Assign: NoCascade
Delete: Restrict
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

Product_ProductAssociation_Prod

Same as the Product_ProductAssociation_Prod many-to-one relationship for the productassociation table/entity.

Property Value
ReferencingEntity productassociation
ReferencingAttribute productid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName Product_ProductAssociation_Prod
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order: 10000
CascadeConfiguration Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

product_ProductSubstitute_substitutedproductid

Same as the product_ProductSubstitute_substitutedproductid many-to-one relationship for the productsubstitute table/entity.

Property Value
ReferencingEntity productsubstitute
ReferencingAttribute substitutedproductid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName product_ProductSubstitute_substitutedproductid
AssociatedMenuConfiguration Behavior: UseCollectionName
Group: Details
Label:
Order: 10000
CascadeConfiguration Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

product_ProductSubstitute_productid

Same as the product_ProductSubstitute_productid many-to-one relationship for the productsubstitute table/entity.

Property Value
ReferencingEntity productsubstitute
ReferencingAttribute productid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName product_ProductSubstitute_productid
AssociatedMenuConfiguration Behavior: UseCollectionName
Group: Details
Label:
Order: 10000
CascadeConfiguration Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

product_price_levels

Same as the product_price_levels many-to-one relationship for the productpricelevel table/entity.

Property Value
ReferencingEntity productpricelevel
ReferencingAttribute productid
IsHierarchical False
IsCustomizable False
ReferencedEntityNavigationPropertyName product_price_levels
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

opportunity_products

Added by: Sales Solution

Same as the opportunity_products many-to-one relationship for the opportunityproduct table/entity.

Property Value
ReferencingEntity opportunityproduct
ReferencingAttribute productid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName opportunity_products
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: Cascade
Delete: Restrict
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

product_invoice_details

Added by: Sales Solution

Same as the product_invoice_details many-to-one relationship for the invoicedetail table/entity.

Property Value
ReferencingEntity invoicedetail
ReferencingAttribute productid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName product_invoice_details
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: Restrict
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

product_order_details

Added by: Sales Solution

Same as the product_order_details many-to-one relationship for the salesorderdetail table/entity.

Property Value
ReferencingEntity salesorderdetail
ReferencingAttribute productid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName product_order_details
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: Restrict
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

product_quote_details

Added by: Sales Solution

Same as the product_quote_details many-to-one relationship for the quotedetail table/entity.

Property Value
ReferencingEntity quotedetail
ReferencingAttribute productid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName product_quote_details
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: Restrict
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

Many-To-One Relationships

Each Many-To-One relationship is defined by a corresponding One-To-Many relationship with the related table. Listed by SchemaName.

price_level_products

See the price_level_products one-to-many relationship for the pricelevel table/entity.

product_parent_product

See the product_parent_product one-to-many relationship for the product table/entity.

unit_of_measurement_products

See the unit_of_measurement_products one-to-many relationship for the uom table/entity.

unit_of_measurement_schedule_products

See the unit_of_measurement_schedule_products one-to-many relationship for the uomschedule table/entity.

Many-To-Many Relationships

Relationship details provided where the Product table is the first table in the relationship. Listed by SchemaName.

campaignproduct_association

See the campaignproduct_association many-to-many relationship for the campaign table/entity.

leadproduct_association

See the leadproduct_association many-to-many relationship for the lead table/entity.

productsalesliterature_association

IntersectEntityName: productsalesliterature

Table 1

Property Value
IntersectAttribute productid
IsCustomizable False
LogicalName product
NavigationPropertyName productsalesliterature_association
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:

Table 2

Property Value
LogicalName salesliterature
IntersectAttribute salesliteratureid
NavigationPropertyName productsalesliterature_association
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:

competitorproduct_association

See the competitorproduct_association many-to-many relationship for the competitor table/entity.

Dataverse table/entity reference
Web API Reference