Product entity reference

Information about products and their pricing information.

Added by: Product Management Solution

Messages

Message SDK class or method
Associate AssociateRequest or
Associate
CloneProduct CloneProductRequest
Create CreateRequest or
Create
Delete DeleteRequest or
Delete
Disassociate DisassociateRequest or
Disassociate
PublishProductHierarchy PublishProductHierarchyRequest
Retrieve RetrieveRequest or
Retrieve
RetrieveMultiple RetrieveMultipleRequest or
RetrieveMultiple
RevertProduct RevertProductRequest
SetState SetStateRequest
Update UpdateRequest or
Update

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 attributes

These 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

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

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
IsValidForUpdate False
LogicalName parentproductid
RequiredLevel None
Targets product
Type Lookup

Price

Property Value
Description List price of the product.
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 Stage Id
IsValidForForm False
IsValidForRead True
LogicalName stageid
RequiredLevel None
Type Uniqueidentifier

StandardCost

Property Value
Description Standard cost of the product.
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 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 attributes

These 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.0000000001
Precision 10
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_SyncErrors

Added by: System Solution Solution

Same as the Product_SyncErrors many-to-one relationship for the syncerror entity.

Property Value
ReferencingEntity syncerror
ReferencingAttribute regardingobjectid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName Product_SyncErrors
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: Cascade
Delete: Cascade
Merge: Cascade
Reparent: Cascade
Share: Cascade
Unshare: Cascade

Product_SharepointDocumentLocation

Added by: System Solution Solution

Same as the Product_SharepointDocumentLocation many-to-one relationship for the sharepointdocumentlocation entity.

Property Value
ReferencingEntity sharepointdocumentlocation
ReferencingAttribute regardingobjectid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName Product_SharepointDocumentLocation
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: Cascade
Merge: Cascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

Product_AsyncOperations

Added by: System Solution Solution

Same as the Product_AsyncOperations many-to-one relationship for the asyncoperation entity.

Property Value
ReferencingEntity asyncoperation
ReferencingAttribute regardingobjectid
IsHierarchical False
IsCustomizable False
ReferencedEntityNavigationPropertyName Product_AsyncOperations
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

product_MailboxTrackingFolders

Added by: System Solution Solution

Same as the product_MailboxTrackingFolders many-to-one relationship for the mailboxtrackingfolder entity.

Property Value
ReferencingEntity mailboxtrackingfolder
ReferencingAttribute regardingobjectid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName product_MailboxTrackingFolders
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

Product_ProcessSessions

Added by: System Solution Solution

Same as the Product_ProcessSessions many-to-one relationship for the processsession entity.

Property Value
ReferencingEntity processsession
ReferencingAttribute regardingobjectid
IsHierarchical False
IsCustomizable False
ReferencedEntityNavigationPropertyName Product_ProcessSessions
AssociatedMenuConfiguration Behavior: UseCollectionName
Group: Details
Label:
Order: 110
CascadeConfiguration Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

Product_BulkDeleteFailures

Added by: System Solution Solution

Same as the Product_BulkDeleteFailures many-to-one relationship for the bulkdeletefailure entity.

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

product_principalobjectattributeaccess

Added by: System Solution Solution

Same as the product_principalobjectattributeaccess many-to-one relationship for the principalobjectattributeaccess entity.

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

product_connections1

Added by: System Solution Solution

Same as the product_connections1 many-to-one relationship for the connection entity.

Property Value
ReferencingEntity connection
ReferencingAttribute record1id
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName product_connections1
AssociatedMenuConfiguration Behavior: UseCollectionName
Group: Details
Label:
Order: 100
CascadeConfiguration Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

product_connections2

Added by: System Solution Solution

Same as the product_connections2 many-to-one relationship for the connection entity.

Property Value
ReferencingEntity connection
ReferencingAttribute record2id
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName product_connections2
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order: 100
CascadeConfiguration Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

Product_Annotation

Added by: System Solution Solution

Same as the Product_Annotation many-to-one relationship for the annotation entity.

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

Product_DynamicProperty

Same as the Product_DynamicProperty many-to-one relationship for the dynamicproperty entity.

Property Value
ReferencingEntity dynamicproperty
ReferencingAttribute regardingobjectid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName Product_DynamicProperty
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

Product_DynamicPropertyAssociation

Same as the Product_DynamicPropertyAssociation many-to-one relationship for the dynamicpropertyassociation entity.

Property Value
ReferencingEntity dynamicpropertyassociation
ReferencingAttribute regardingobjectid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName Product_DynamicPropertyAssociation
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

product_parent_product

Same as the product_parent_product many-to-one relationship for the product 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 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 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 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 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 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

product_contract_line_items

Added by: Service Solution

Same as the product_contract_line_items many-to-one relationship for the contractdetail entity.

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

product_incidents

Added by: Service Solution

Same as the product_incidents many-to-one relationship for the incident entity.

Property Value
ReferencingEntity incident
ReferencingAttribute productid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName product_incidents
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: Restrict
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 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 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 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 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 entity. Listed by SchemaName.

lk_productbase_createdby

Added by: System Solution Solution

See the lk_productbase_createdby one-to-many relationship for the systemuser entity.

lk_product_createdonbehalfby

Added by: System Solution Solution

See the lk_product_createdonbehalfby one-to-many relationship for the systemuser entity.

lk_productbase_modifiedby

Added by: System Solution Solution

See the lk_productbase_modifiedby one-to-many relationship for the systemuser entity.

lk_product_modifiedonbehalfby

Added by: System Solution Solution

See the lk_product_modifiedonbehalfby one-to-many relationship for the systemuser entity.

organization_products

Added by: System Solution Solution

See the organization_products one-to-many relationship for the organization entity.

processstage_products

Added by: System Solution Solution

See the processstage_products one-to-many relationship for the processstage entity.

transactioncurrency_product

Added by: System Solution Solution

See the transactioncurrency_product one-to-many relationship for the transactioncurrency entity.

price_level_products

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

product_parent_product

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

subject_products

Added by: System Solution Solution

See the subject_products one-to-many relationship for the subject entity.

unit_of_measurement_products

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

unit_of_measurement_schedule_products

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

Many-To-Many Relationships

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

campaignproduct_association

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

product_entitlement_association

IntersectEntityName: entitlementproducts

Table 1

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

Table 2

Property Value
LogicalName entitlement
IntersectAttribute entitlementid
NavigationPropertyName product_entitlement_association
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:

product_entitlementtemplate_association

IntersectEntityName: entitlementtemplateproducts

Table 1

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

Table 2

Property Value
LogicalName entitlementtemplate
IntersectAttribute entitlementtemplateid
NavigationPropertyName product_entitlementtemplate_association
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:

leadproduct_association

See the leadproduct_association many-to-many relationship for the lead 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 entity.

See also

About the Entity Reference
Web API EntityType Reference