productsubstitute EntityType

Information about the selling relationship between two products, including the relationship type, such as up-sell, cross-sell, substitute, or accessory.

Entity Set Path
[organization URI]/api/data/v9.0/productsubstitutes
Base Type
Display Name
Product Relationship
Primary Key
Primary Key Attribute
Operations Supported


Properties represent fields of data stored in the entity.Some properties are read-only.

Name Type Details
createdon Edm.DateTimeOffset

Date and time when the record was created.

Display Name: Created On

Read Only
direction Edm.Int32

Select whether the relationship is unidirectional or bidirectional.

Display Name: Direction

Default Options
Value Label
0 Uni-Directional
1 Bi-Directional
exchangerate Edm.Decimal

Shows the conversion rate of the record's currency. The exchange rate is used to convert all money fields in the record from the local currency to the system's default currency.

Display Name: Exchange Rate

Read Only
importsequencenumber Edm.Int32

Sequence number of the import that created this record.

Display Name: Import Sequence Number

modifiedon Edm.DateTimeOffset

Date and time when the record was modified.

Display Name: Modified On

Read Only
name Edm.String


Display Name: name

overriddencreatedon Edm.DateTimeOffset

Date and time that the record was migrated.

Display Name: Record Created On

productsubstituteid Edm.Guid

Shows the unique identifier of the product relationship.

Display Name: Product Relationship ID

salesrelationshiptype Edm.Int32

Select the type of the product relationship.

Display Name: Sales Relationship Type

Default Options
Value Label
0 Up-sell
1 Cross-sell
2 Accessory
3 Substitute
statecode Edm.Int32

Select the product relationship's status.

Display Name: Status

Read Only
Default Options
Value Label
0 Active
1 Inactive
statuscode Edm.Int32

Shows whether the product relationship is active or inactive.

Display Name: Status Reason

Default Options
Value Label
1 Active
2 Inactive
timezoneruleversionnumber Edm.Int32

For internal use only.

Display Name: Time Zone Rule Version Number

utcconversiontimezonecode Edm.Int32

Time zone code that was in use when the record was created.

Display Name: UTC Conversion Time Zone Code

versionnumber Edm.Int64

Version Number

Display Name: Version Number

Read Only

Lookup Properties

Lookup properties are read-only, computed properties which contain entity primary key Edm.Guid data for one or more corresponding single-valued navigation properties. More information: Lookup properties and Retrieve data about lookup properties.

Name Single-valued navigation property Description
_createdby_value createdby

Shows who created the record.

_createdonbehalfby_value createdonbehalfby

Shows who created the record on behalf of another user.

_modifiedby_value modifiedby

Shows who last updated the record.

_modifiedonbehalfby_value modifiedonbehalfby

Shows who created the record on behalf of another user.

_organizationid_value organizationid

Unique identifier for the organization

_productid_value productid

Shows the product that the relationship is defined for.

_substitutedproductid_value substitutedproductid

Select the related product that the relationship needs to be defined for.

_transactioncurrencyid_value transactioncurrencyid

Shows the currency associated with the record.

Single-valued navigation properties

Single-valued navigation properties represent lookup fields where a single entity can be referenced. Each single-valued navigation property has a corresponding partner collection-valued navigation property on the related entity.

Name Type Partner
createdby systemuser lk_ProductSubstitute_createdby
createdonbehalfby systemuser lk_ProductSubstitute_createdonbehalfby
modifiedby systemuser lk_ProductSubstitute_modifiedby
modifiedonbehalfby systemuser lk_ProductSubstitute_modifiedonbehalfby
organizationid organization organization_ProductSubstitute
productid product product_ProductSubstitute_productid
substitutedproductid product product_ProductSubstitute_substitutedproductid
transactioncurrencyid transactioncurrency transactioncurrency_ProductSubstitute

Collection-valued navigation properties

Collection-valued navigation properties represent collections of entities which may represent either a one-to-many (1:N) or many-to-many (N:N) relationship between the entities.

Name Type Partner
ProductSubstitute_AsyncOperations asyncoperation regardingobjectid_productsubstitute
ProductSubstitute_BulkDeleteFailures bulkdeletefailure regardingobjectid_productsubstitute
productsubstitute_MailboxTrackingFolders mailboxtrackingfolder regardingobjectid_productsubstitute
ProductSubstitute_PrincipalObjectAttributeAccess principalobjectattributeaccess objectid_productsubstitute
ProductSubstitute_ProcessSession processsession regardingobjectid_productsubstitute
ProductSubstitute_SyncErrors syncerror regardingobjectid_productsubstitute_syncerror


The following solutions include the productsubstitute entity type.

Name Description
Product Management Dynamics 365 workload for product management.

See also