แก้ไข

แชร์ผ่าน

Product table/entity reference (Microsoft Dynamics 365)

  • บทความ

Information about products and their pricing information.

Messages

The following table lists the messages for the Product table. Messages represent operations that can be performed on the table. They may also be events.

Name
Is Event?		 Web API Operation SDK for .NET
AddProductToKit
Event: True		 AddProductToKitRequest
AddSubstituteProduct
Event: False		 AddSubstituteProductRequest
Associate
Event: True		 Associate records Associate records
CloneProduct
Event: True		 CloneProduct action CloneProductRequest
ConvertKitToProduct
Event: False		 ConvertKitToProductRequest
ConvertProductToKit
Event: False		 ConvertProductToKitRequest
Create
Event: True		 POST /products
See Create		 Create records
CreateMultiple
Event: True		 CreateMultiple CreateMultipleRequest
Delete
Event: True		 DELETE /products(productid)
See Delete		 Delete records
Disassociate
Event: True		 Disassociate records Disassociate records
PublishProductHierarchy
Event: False		 PublishProductHierarchy action PublishProductHierarchyRequest
RemoveSubstituteProduct
Event: False		 RemoveSubstituteProductRequest
Retrieve
Event: True		 GET /products(productid)
See Retrieve		 Retrieve records
RetrieveMultiple
Event: True		 GET /products
See Query data		 Query data
RevertProduct
Event: False		 RevertProduct action RevertProductRequest
SetState
Event: True		 PATCH /products(productid)
Update the statecode and statuscode properties.		 SetStateRequest
Update
Event: True		 PATCH /products(productid)
See Update		 Update records
UpdateMultiple
Event: True		 UpdateMultiple UpdateMultipleRequest
Upsert
Event: False		 PATCH /products(productid)
See Upsert a table row		 UpsertRequest
UpsertMultiple
Event: False		 UpsertMultiple UpsertMultipleRequest

Properties

The following table lists selected properties for the Product table.

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

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
RequiredLevel None
Type Money
ImeMode Disabled
IsBaseCurrency False
MaxValue 1000000000000
MinValue 0
Precision 2
PrecisionSource 1 (Organization.PricingDecimalPrecision)

DefaultUoMId

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

DefaultUoMScheduleId

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

Description

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

DMTImportState

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

EntityImage

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

ImportSequenceNumber

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

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
GlobalChoiceName product_iskit
DefaultValue False
True Label Yes
False Label No

IsReparented

Property Value
Description
DisplayName Is Reparented
IsValidForForm True
IsValidForRead True
LogicalName isreparented
RequiredLevel None
Type Boolean
GlobalChoiceName isreparented
DefaultValue False
True Label Yes
False Label No

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
GlobalChoiceName product_isstockitem
DefaultValue False
True Label Yes
False Label No

msdyn_gdproptout

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
GlobalChoiceName msdyn_product_msdyn_gdproptout
DefaultValue False
True Label Yes
False Label No

Name

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

OverriddenCreatedOn

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

ParentProductId

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

Price

Property Value
Description List price for the product item. Used in price calculations.
DisplayName List Price
IsValidForForm True
IsValidForRead True
LogicalName price
RequiredLevel None
Type Money
ImeMode Disabled
IsBaseCurrency False
MaxValue 1000000000000
MinValue 0
Precision 2
PrecisionSource 1 (Organization.PricingDecimalPrecision)

PriceLevelId

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

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
LogicalName productid
RequiredLevel SystemRequired
Type Uniqueidentifier

ProductNumber

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

ProductStructure

Property Value
Description Product Structure.
DisplayName Product Structure
IsValidForForm True
IsValidForRead True
LogicalName productstructure
RequiredLevel SystemRequired
Type Picklist
DefaultFormValue 1
GlobalChoiceName product_productstructure

ProductStructure Choices/Options

Value Label
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
DefaultFormValue 1
GlobalChoiceName product_producttypecode

ProductTypeCode Choices/Options

Value Label
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
IsValidForForm True
IsValidForRead True
LogicalName producturl
RequiredLevel None
Type String
Format Url
FormatName Url
ImeMode Inactive
IsLocalizable False
MaxLength 255

QuantityDecimal

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

QuantityOnHand

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

Size

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

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
RequiredLevel None
Type Money
ImeMode Disabled
IsBaseCurrency False
MaxValue 1000000000000
MinValue 0
Precision 2
PrecisionSource 1 (Organization.PricingDecimalPrecision)

StateCode

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

StateCode Choices/Options

Value Details
0 Label: Active
DefaultStatus: 1
InvariantName: Active
1 Label: Retired
DefaultStatus: 2
InvariantName: Inactive
2 Label: Draft
DefaultStatus: 0
InvariantName: Draft
3 Label: Under Revision
DefaultStatus: 3
InvariantName: 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
DefaultFormValue -1
GlobalChoiceName product_statuscode

StatusCode Choices/Options

Value Details
0 Label: Draft
State:2
TransitionData: None
1 Label: Active
State:0
TransitionData: None
2 Label: Retired
State:1
TransitionData: None
3 Label: Under Revision
State:3
TransitionData: None

StockVolume

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

StockWeight

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

SubjectId

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

SupplierName

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

TimeZoneRuleVersionNumber

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

TransactionCurrencyId

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

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
IsValidForForm False
IsValidForRead True
LogicalName traversedpath
RequiredLevel None
Type String
Format Text
FormatName Text
ImeMode Auto
IsLocalizable False
MaxLength 1250

UTCConversionTimeZoneCode

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

ValidFromDate

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

ValidToDate

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

VendorID

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

VendorName

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

VendorPartNumber

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

Read-only columns/attributes

These columns/attributes return false for both IsValidForCreate and 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
Type Lookup
Targets systemuser

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
Type Lookup
Targets externalparty

CreatedOn

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

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
Type Lookup
Targets systemuser

CurrentCost_Base

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

EntityImage_Timestamp

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

EntityImage_URL

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

EntityImageId

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

ExchangeRate

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
RequiredLevel None
Type Decimal
ImeMode Disabled
MaxValue 100000000000
MinValue 1E-12
Precision 12
SourceTypeMask 0

HierarchyPath

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

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
Type Lookup
Targets systemuser

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
Type Lookup
Targets externalparty

ModifiedOn

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

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
Type Lookup
Targets systemuser

OrganizationId

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

Price_Base

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

StandardCost_Base

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

VersionNumber

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

Many-to-One relationships

These relationships are many-to-one. Listed by SchemaName.

lk_product_createdonbehalfby

One-To-Many Relationship: systemuser lk_product_createdonbehalfby

Property Value
ReferencedEntity systemuser
ReferencedAttribute systemuserid
ReferencingAttribute createdonbehalfby
ReferencingEntityNavigationPropertyName createdonbehalfby
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

lk_product_modifiedonbehalfby

One-To-Many Relationship: systemuser lk_product_modifiedonbehalfby

Property Value
ReferencedEntity systemuser
ReferencedAttribute systemuserid
ReferencingAttribute modifiedonbehalfby
ReferencingEntityNavigationPropertyName modifiedonbehalfby
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

lk_productbase_createdby

One-To-Many Relationship: systemuser lk_productbase_createdby

Property Value
ReferencedEntity systemuser
ReferencedAttribute systemuserid
ReferencingAttribute createdby
ReferencingEntityNavigationPropertyName createdby
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

lk_productbase_modifiedby

One-To-Many Relationship: systemuser lk_productbase_modifiedby

Property Value
ReferencedEntity systemuser
ReferencedAttribute systemuserid
ReferencingAttribute modifiedby
ReferencingEntityNavigationPropertyName modifiedby
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

organization_products

One-To-Many Relationship: organization organization_products

Property Value
ReferencedEntity organization
ReferencedAttribute organizationid
ReferencingAttribute organizationid
ReferencingEntityNavigationPropertyName organizationid
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

price_level_products

One-To-Many Relationship: pricelevel price_level_products

Property Value
ReferencedEntity pricelevel
ReferencedAttribute pricelevelid
ReferencingAttribute pricelevelid
ReferencingEntityNavigationPropertyName pricelevelid
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: Restrict
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

processstage_products

One-To-Many Relationship: processstage processstage_products

Property Value
ReferencedEntity processstage
ReferencedAttribute processstageid
ReferencingAttribute stageid
ReferencingEntityNavigationPropertyName stageid_processstage
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

product_parent_product

One-To-Many Relationship: product product_parent_product

Property Value
ReferencedEntity product
ReferencedAttribute productid
ReferencingAttribute parentproductid
ReferencingEntityNavigationPropertyName parentproductid
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

subject_products

One-To-Many Relationship: subject subject_products

Property Value
ReferencedEntity subject
ReferencedAttribute subjectid
ReferencingAttribute subjectid
ReferencingEntityNavigationPropertyName subjectid
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: Restrict
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

transactioncurrency_product

One-To-Many Relationship: transactioncurrency transactioncurrency_product

Property Value
ReferencedEntity transactioncurrency
ReferencedAttribute transactioncurrencyid
ReferencingAttribute transactioncurrencyid
ReferencingEntityNavigationPropertyName transactioncurrencyid
IsHierarchical
CascadeConfiguration Archive: Restrict
Assign: NoCascade
Delete: Restrict
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

unit_of_measurement_products

One-To-Many Relationship: uom unit_of_measurement_products

Property Value
ReferencedEntity uom
ReferencedAttribute uomid
ReferencingAttribute defaultuomid
ReferencingEntityNavigationPropertyName defaultuomid
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: Restrict
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

unit_of_measurement_schedule_products

One-To-Many Relationship: uomschedule unit_of_measurement_schedule_products

Property Value
ReferencedEntity uomschedule
ReferencedAttribute uomscheduleid
ReferencingAttribute defaultuomscheduleid
ReferencingEntityNavigationPropertyName defaultuomscheduleid
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: Restrict
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

One-to-Many relationships

These relationships are one-to-many. Listed by SchemaName.

msdyn_product_msdyn_customerasset_Product

Many-To-One Relationship: msdyn_customerasset msdyn_product_msdyn_customerasset_Product

Property Value
ReferencingEntity msdyn_customerasset
ReferencingAttribute msdyn_product
ReferencedEntityNavigationPropertyName msdyn_product_msdyn_customerasset_Product
IsCustomizable True
AssociatedMenuConfiguration AvailableOffline: True
Behavior: UseCollectionName
Group: Details
Label:
MenuId: null
Order: 10000
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

opportunity_products

Many-To-One Relationship: opportunityproduct opportunity_products

Property Value
ReferencingEntity opportunityproduct
ReferencingAttribute productid
ReferencedEntityNavigationPropertyName opportunity_products
IsCustomizable True
AssociatedMenuConfiguration AvailableOffline: True
Behavior: DoNotDisplay
Group: Details
Label:
MenuId: null
Order:
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

Product_Annotation

Many-To-One Relationship: annotation Product_Annotation

Property Value
ReferencingEntity annotation
ReferencingAttribute objectid
ReferencedEntityNavigationPropertyName Product_Annotation
IsCustomizable False
AssociatedMenuConfiguration AvailableOffline: True
Behavior: DoNotDisplay
Group: Details
Label:
MenuId: null
Order:
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

Product_AsyncOperations

Many-To-One Relationship: asyncoperation Product_AsyncOperations

Property Value
ReferencingEntity asyncoperation
ReferencingAttribute regardingobjectid
ReferencedEntityNavigationPropertyName Product_AsyncOperations
IsCustomizable False
AssociatedMenuConfiguration AvailableOffline: True
Behavior: DoNotDisplay
Group: Details
Label:
MenuId: null
Order:
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

Product_BulkDeleteFailures

Many-To-One Relationship: bulkdeletefailure Product_BulkDeleteFailures

Property Value
ReferencingEntity bulkdeletefailure
ReferencingAttribute regardingobjectid
ReferencedEntityNavigationPropertyName Product_BulkDeleteFailures
IsCustomizable False
AssociatedMenuConfiguration AvailableOffline: True
Behavior: DoNotDisplay
Group: Details
Label:
MenuId: null
Order:
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

product_connections1

Many-To-One Relationship: connection product_connections1

Property Value
ReferencingEntity connection
ReferencingAttribute record1id
ReferencedEntityNavigationPropertyName product_connections1
IsCustomizable True
AssociatedMenuConfiguration AvailableOffline: True
Behavior: UseCollectionName
Group: Details
Label:
MenuId: null
Order: 100
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

product_connections2

Many-To-One Relationship: connection product_connections2

Property Value
ReferencingEntity connection
ReferencingAttribute record2id
ReferencedEntityNavigationPropertyName product_connections2
IsCustomizable True
AssociatedMenuConfiguration AvailableOffline: True
Behavior: DoNotDisplay
Group: Details
Label:
MenuId: null
Order: 100
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

product_contract_line_items

Many-To-One Relationship: contractdetail product_contract_line_items

Property Value
ReferencingEntity contractdetail
ReferencingAttribute productid
ReferencedEntityNavigationPropertyName product_contract_line_items
IsCustomizable True
AssociatedMenuConfiguration AvailableOffline: True
Behavior: DoNotDisplay
Group: Details
Label:
MenuId: null
Order:
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

Product_DynamicProperty

Many-To-One Relationship: dynamicproperty Product_DynamicProperty

Property Value
ReferencingEntity dynamicproperty
ReferencingAttribute regardingobjectid
ReferencedEntityNavigationPropertyName Product_DynamicProperty
IsCustomizable True
AssociatedMenuConfiguration AvailableOffline: True
Behavior: DoNotDisplay
Group: Details
Label:
MenuId: null
Order:
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

Product_DynamicPropertyAssociation

Many-To-One Relationship: dynamicpropertyassociation Product_DynamicPropertyAssociation

Property Value
ReferencingEntity dynamicpropertyassociation
ReferencingAttribute regardingobjectid
ReferencedEntityNavigationPropertyName Product_DynamicPropertyAssociation
IsCustomizable True
AssociatedMenuConfiguration AvailableOffline: True
Behavior: DoNotDisplay
Group: Details
Label:
MenuId: null
Order:
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

product_incidents

Many-To-One Relationship: incident product_incidents

Property Value
ReferencingEntity incident
ReferencingAttribute productid
ReferencedEntityNavigationPropertyName product_incidents
IsCustomizable True
AssociatedMenuConfiguration AvailableOffline: True
Behavior: DoNotDisplay
Group: Details
Label:
MenuId: null
Order:
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

product_invoice_details

Many-To-One Relationship: invoicedetail product_invoice_details

Property Value
ReferencingEntity invoicedetail
ReferencingAttribute productid
ReferencedEntityNavigationPropertyName product_invoice_details
IsCustomizable True
AssociatedMenuConfiguration AvailableOffline: True
Behavior: DoNotDisplay
Group: Details
Label:
MenuId: null
Order:
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

product_MailboxTrackingFolders

Many-To-One Relationship: mailboxtrackingfolder product_MailboxTrackingFolders

Property Value
ReferencingEntity mailboxtrackingfolder
ReferencingAttribute regardingobjectid
ReferencedEntityNavigationPropertyName product_MailboxTrackingFolders
IsCustomizable True
AssociatedMenuConfiguration AvailableOffline: True
Behavior: DoNotDisplay
Group: Details
Label:
MenuId: null
Order:
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

product_order_details

Many-To-One Relationship: salesorderdetail product_order_details

Property Value
ReferencingEntity salesorderdetail
ReferencingAttribute productid
ReferencedEntityNavigationPropertyName product_order_details
IsCustomizable True
AssociatedMenuConfiguration AvailableOffline: True
Behavior: DoNotDisplay
Group: Details
Label:
MenuId: null
Order:
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

product_parent_product

Many-To-One Relationship: product product_parent_product

Property Value
ReferencingEntity product
ReferencingAttribute parentproductid
ReferencedEntityNavigationPropertyName product_parent_product
IsCustomizable True
AssociatedMenuConfiguration AvailableOffline: True
Behavior: DoNotDisplay
Group: Details
Label:
MenuId: null
Order:
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

product_price_levels

Many-To-One Relationship: productpricelevel product_price_levels

Property Value
ReferencingEntity productpricelevel
ReferencingAttribute productid
ReferencedEntityNavigationPropertyName product_price_levels
IsCustomizable False
AssociatedMenuConfiguration AvailableOffline: True
Behavior: DoNotDisplay
Group: Details
Label:
MenuId: null
Order:
QueryApi: CRMProductPriceLevel.RetrieveByObject
ViewId: f4d79a29-8f34-40e3-8802-bb631ee8eace

product_principalobjectattributeaccess

Many-To-One Relationship: principalobjectattributeaccess product_principalobjectattributeaccess

Property Value
ReferencingEntity principalobjectattributeaccess
ReferencingAttribute objectid
ReferencedEntityNavigationPropertyName product_principalobjectattributeaccess
IsCustomizable False
AssociatedMenuConfiguration AvailableOffline: True
Behavior: DoNotDisplay
Group: Details
Label:
MenuId: null
Order:
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

Product_ProcessSessions

Many-To-One Relationship: processsession Product_ProcessSessions

Property Value
ReferencingEntity processsession
ReferencingAttribute regardingobjectid
ReferencedEntityNavigationPropertyName Product_ProcessSessions
IsCustomizable False
AssociatedMenuConfiguration AvailableOffline: True
Behavior: UseCollectionName
Group: Details
Label:
MenuId: null
Order: 110
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

Product_ProductAssociation_AssocProd

Many-To-One Relationship: productassociation Product_ProductAssociation_AssocProd

Property Value
ReferencingEntity productassociation
ReferencingAttribute associatedproduct
ReferencedEntityNavigationPropertyName Product_ProductAssociation_AssocProd
IsCustomizable True
AssociatedMenuConfiguration AvailableOffline: True
Behavior: DoNotDisplay
Group: Details
Label:
MenuId: null
Order: 10000
QueryApi: CRMProduct.RetrieveByObject
ViewId: ff3ab78d-fbfa-45ef-bf83-d672eb5bb553

Product_ProductAssociation_Prod

Many-To-One Relationship: productassociation Product_ProductAssociation_Prod

Property Value
ReferencingEntity productassociation
ReferencingAttribute productid
ReferencedEntityNavigationPropertyName Product_ProductAssociation_Prod
IsCustomizable True
AssociatedMenuConfiguration AvailableOffline: True
Behavior: DoNotDisplay
Group: Details
Label:
MenuId: null
Order: 10000
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

product_ProductSubstitute_productid

Many-To-One Relationship: productsubstitute product_ProductSubstitute_productid

Property Value
ReferencingEntity productsubstitute
ReferencingAttribute productid
ReferencedEntityNavigationPropertyName product_ProductSubstitute_productid
IsCustomizable True
AssociatedMenuConfiguration AvailableOffline: True
Behavior: UseCollectionName
Group: Details
Label:
MenuId: null
Order: 10000
QueryApi: CRMProduct.RetrieveSubstitutes
ViewId: 21bfc518-b51e-4c08-baef-682aefc09e76

product_ProductSubstitute_substitutedproductid

Many-To-One Relationship: productsubstitute product_ProductSubstitute_substitutedproductid

Property Value
ReferencingEntity productsubstitute
ReferencingAttribute substitutedproductid
ReferencedEntityNavigationPropertyName product_ProductSubstitute_substitutedproductid
IsCustomizable True
AssociatedMenuConfiguration AvailableOffline: True
Behavior: UseCollectionName
Group: Details
Label:
MenuId: null
Order: 10000
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

product_quote_details

Many-To-One Relationship: quotedetail product_quote_details

Property Value
ReferencingEntity quotedetail
ReferencingAttribute productid
ReferencedEntityNavigationPropertyName product_quote_details
IsCustomizable True
AssociatedMenuConfiguration AvailableOffline: True
Behavior: DoNotDisplay
Group: Details
Label:
MenuId: null
Order:
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

Product_SharepointDocumentLocation

Many-To-One Relationship: sharepointdocumentlocation Product_SharepointDocumentLocation

Property Value
ReferencingEntity sharepointdocumentlocation
ReferencingAttribute regardingobjectid
ReferencedEntityNavigationPropertyName Product_SharepointDocumentLocation
IsCustomizable True
AssociatedMenuConfiguration AvailableOffline: True
Behavior: DoNotDisplay
Group: Details
Label:
MenuId: null
Order:
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

Product_SyncErrors

Many-To-One Relationship: syncerror Product_SyncErrors

Property Value
ReferencingEntity syncerror
ReferencingAttribute regardingobjectid
ReferencedEntityNavigationPropertyName Product_SyncErrors
IsCustomizable True
AssociatedMenuConfiguration AvailableOffline: True
Behavior: DoNotDisplay
Group: Details
Label:
MenuId: null
Order:
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

Many-to-Many relationships

These relationships are many-to-many. Listed by SchemaName.

campaignproduct_association

See campaign campaignproduct_association Many-To-Many Relationship

Property Value
IntersectEntityName campaignitem
IsCustomizable False
SchemaName campaignproduct_association
IntersectAttribute entityid
NavigationPropertyName campaignproduct_association
AssociatedMenuConfiguration AvailableOffline: True
Behavior: DoNotDisplay
Group: Details
Label:
MenuId: null
Order:
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

competitorproduct_association

See competitor competitorproduct_association Many-To-Many Relationship

Property Value
IntersectEntityName competitorproduct
IsCustomizable False
SchemaName competitorproduct_association
IntersectAttribute productid
NavigationPropertyName competitorproduct_association
AssociatedMenuConfiguration AvailableOffline: True
Behavior: UseCollectionName
Group: Details
Label:
MenuId: null
Order:
QueryApi: CRMProduct.RetrieveByObject
ViewId: f8de15f4-4c76-4a21-94c9-a38fcafdb73d

leadproduct_association

See lead leadproduct_association Many-To-Many Relationship

Property Value
IntersectEntityName leadproduct
IsCustomizable False
SchemaName leadproduct_association
IntersectAttribute productid
NavigationPropertyName leadproduct_association
AssociatedMenuConfiguration AvailableOffline: True
Behavior: DoNotDisplay
Group: Details
Label:
MenuId: null
Order:
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

msdyn_product_knowledgearticle

See knowledgearticle msdyn_product_knowledgearticle Many-To-Many Relationship

Property Value
IntersectEntityName msdyn_product_knowledgearticle
IsCustomizable True
SchemaName msdyn_product_knowledgearticle
IntersectAttribute productid
NavigationPropertyName ``
AssociatedMenuConfiguration AvailableOffline: True
Behavior: UseCollectionName
Group: Details
Label:
MenuId: null
Order: 10000
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

product_entitlement_association

See entitlement product_entitlement_association Many-To-Many Relationship

Property Value
IntersectEntityName entitlementproducts
IsCustomizable False
SchemaName product_entitlement_association
IntersectAttribute productid
NavigationPropertyName product_entitlement_association
AssociatedMenuConfiguration AvailableOffline: True
Behavior: DoNotDisplay
Group: Details
Label:
MenuId: null
Order:
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

product_entitlementtemplate_association

See entitlementtemplate product_entitlementtemplate_association Many-To-Many Relationship

Property Value
IntersectEntityName entitlementtemplateproducts
IsCustomizable False
SchemaName product_entitlementtemplate_association
IntersectAttribute productid
NavigationPropertyName product_entitlementtemplate_association
AssociatedMenuConfiguration AvailableOffline: True
Behavior: DoNotDisplay
Group: Details
Label:
MenuId: null
Order:
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

product_knowledgebaserecord

See knowledgebaserecord product_knowledgebaserecord Many-To-Many Relationship

Property Value
IntersectEntityName msdyn_product_knowledgebaserecord
IsCustomizable True
SchemaName product_knowledgebaserecord
IntersectAttribute productid
NavigationPropertyName ``
AssociatedMenuConfiguration AvailableOffline: True
Behavior: UseCollectionName
Group: Details
Label:
MenuId: null
Order: 10000
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

productsalesliterature_association

See salesliterature productsalesliterature_association Many-To-Many Relationship

Property Value
IntersectEntityName productsalesliterature
IsCustomizable False
SchemaName productsalesliterature_association
IntersectAttribute productid
NavigationPropertyName productsalesliterature_association
AssociatedMenuConfiguration AvailableOffline: True
Behavior: DoNotDisplay
Group: Details
Label:
MenuId: null
Order:
QueryApi: CRMProduct.RetrieveByObject
ViewId: f8de15f4-4c76-4a21-94c9-a38fcafdb73d

See also

Dataverse table/entity reference
Dataverse Web API Reference