Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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 |
|---|---|---|
AddProductToKitEvent: True |
AddProductToKitRequest | |
AddSubstituteProductEvent: False |
AddSubstituteProductRequest | |
AssociateEvent: True |
Associate records | Associate records |
CloneProductEvent: True |
CloneProduct action | CloneProductRequest |
ConvertKitToProductEvent: False |
ConvertKitToProductRequest | |
ConvertProductToKitEvent: False |
ConvertProductToKitRequest | |
CreateEvent: True |
POST /productsSee Create |
Create records |
CreateMultipleEvent: True |
CreateMultiple | CreateMultipleRequest |
DeleteEvent: True |
DELETE /products(productid)See Delete |
Delete records |
DisassociateEvent: True |
Disassociate records | Disassociate records |
PublishProductHierarchyEvent: False |
PublishProductHierarchy action | PublishProductHierarchyRequest |
RemoveSubstituteProductEvent: False |
RemoveSubstituteProductRequest | |
RetrieveEvent: True |
GET /products(productid)See Retrieve |
Retrieve records |
RetrieveMultipleEvent: True |
GET /productsSee Query data |
Query data |
RevertProductEvent: False |
RevertProduct action | RevertProductRequest |
SetStateEvent: True |
PATCH /products(productid)Update the statecode and statuscode properties. |
SetStateRequest |
UpdateEvent: True |
PATCH /products(productid)See Update |
Update records |
UpdateMultipleEvent: True |
UpdateMultiple | UpdateMultipleRequest |
UpsertEvent: False |
PATCH /products(productid)See Upsert a table row |
UpsertRequest |
UpsertMultipleEvent: 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
- DefaultUoMId
- DefaultUoMScheduleId
- Description
- DMTImportState
- EntityImage
- ImportSequenceNumber
- IsKit
- IsReparented
- IsStockItem
- msdyn_AlsoKnownAs
- msdyn_gdproptout
- msdyn_scopes
- Name
- OverriddenCreatedOn
- ParentProductId
- Price
- PriceLevelId
- ProcessId
- ProductId
- ProductNumber
- ProductStructure
- ProductTypeCode
- ProductUrl
- QuantityDecimal
- QuantityOnHand
- Size
- StageId
- StandardCost
- StateCode
- StatusCode
- StockVolume
- StockWeight
- SubjectId
- SupplierName
- TimeZoneRuleVersionNumber
- TransactionCurrencyId
- TraversedPath
- UTCConversionTimeZoneCode
- ValidFromDate
- ValidToDate
- VendorID
- VendorName
- VendorPartNumber
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 | 1048576 |
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_AlsoKnownAs
| Property | Value |
|---|---|
| Description | Alternate name/description for product |
| DisplayName | Also Known As |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_alsoknownas |
| RequiredLevel | None |
| Type | Memo |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 2000 |
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 |
msdyn_scopes
| Property | Value |
|---|---|
| Description | Different scopes that the product belongs to |
| DisplayName | Scopes |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_scopes |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | True |
| MaxLength | 2000 |
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
- CreatedByExternalParty
- CreatedOn
- CreatedOnBehalfBy
- CurrentCost_Base
- EntityImage_Timestamp
- EntityImage_URL
- EntityImageId
- ExchangeRate
- HierarchyPath
- ModifiedBy
- ModifiedByExternalParty
- ModifiedOn
- ModifiedOnBehalfBy
- OrganizationId
- Price_Base
- StandardCost_Base
- VersionNumber
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
- lk_product_modifiedonbehalfby
- lk_productbase_createdby
- lk_productbase_modifiedby
- organization_products
- price_level_products
- processstage_products
- product_parent_product
- subject_products
- transactioncurrency_product
- unit_of_measurement_products
- unit_of_measurement_schedule_products
lk_product_createdonbehalfby
One-To-Many Relationship: systemuser lk_product_createdonbehalfby
| Property | Value |
|---|---|
| ReferencedEntity | systemuser |
| ReferencedAttribute | systemuserid |
| ReferencingAttribute | createdonbehalfby |
| ReferencingEntityNavigationPropertyName | createdonbehalfby |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: NoCascadeMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: 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: NoCascadeAssign: NoCascadeDelete: NoCascadeMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: 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: NoCascadeAssign: NoCascadeDelete: NoCascadeMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: 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: NoCascadeAssign: NoCascadeDelete: NoCascadeMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
organization_products
One-To-Many Relationship: organization organization_products
| Property | Value |
|---|---|
| ReferencedEntity | organization |
| ReferencedAttribute | organizationid |
| ReferencingAttribute | organizationid |
| ReferencingEntityNavigationPropertyName | organizationid |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: NoCascadeMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: 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: NoCascadeAssign: NoCascadeDelete: RestrictMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
processstage_products
One-To-Many Relationship: processstage processstage_products
| Property | Value |
|---|---|
| ReferencedEntity | processstage |
| ReferencedAttribute | processstageid |
| ReferencingAttribute | stageid |
| ReferencingEntityNavigationPropertyName | stageid_processstage |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: NoCascadeMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: 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: NoCascadeAssign: NoCascadeDelete: CascadeMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
subject_products
One-To-Many Relationship: subject subject_products
| Property | Value |
|---|---|
| ReferencedEntity | subject |
| ReferencedAttribute | subjectid |
| ReferencingAttribute | subjectid |
| ReferencingEntityNavigationPropertyName | subjectid |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: RestrictMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
transactioncurrency_product
One-To-Many Relationship: transactioncurrency transactioncurrency_product
| Property | Value |
|---|---|
| ReferencedEntity | transactioncurrency |
| ReferencedAttribute | transactioncurrencyid |
| ReferencingAttribute | transactioncurrencyid |
| ReferencingEntityNavigationPropertyName | transactioncurrencyid |
| IsHierarchical | |
| CascadeConfiguration | Archive: RestrictAssign: NoCascadeDelete: RestrictMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: 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: NoCascadeAssign: NoCascadeDelete: RestrictMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: 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: NoCascadeAssign: NoCascadeDelete: RestrictMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
One-to-Many relationships
These relationships are one-to-many. Listed by SchemaName.
- msdyn_product_msdyn_customerasset_Product
- msdyn_productmap_msdyn_productid_product
- opportunity_products
- Product_Annotation
- Product_AsyncOperations
- Product_BulkDeleteFailures
- product_connections1
- product_connections2
- product_contract_line_items
- Product_DynamicProperty
- Product_DynamicPropertyAssociation
- product_incidents
- product_invoice_details
- product_MailboxTrackingFolders
- product_order_details
- product_parent_product
- product_price_levels
- product_principalobjectattributeaccess
- Product_ProcessSessions
- Product_ProductAssociation_AssocProd
- Product_ProductAssociation_Prod
- product_ProductSubstitute_productid
- product_ProductSubstitute_substitutedproductid
- product_quote_details
- Product_SharepointDocumentLocation
- Product_SyncErrors
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: UseCollectionNameGroup: DetailsLabel: MenuId: null Order: 10000 QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
msdyn_productmap_msdyn_productid_product
Many-To-One Relationship: msdyn_productmap msdyn_productmap_msdyn_productid_product
| Property | Value |
|---|---|
| ReferencingEntity | msdyn_productmap |
| ReferencingAttribute | msdyn_productid |
| ReferencedEntityNavigationPropertyName | msdyn_productmap_msdyn_productid_product |
| IsCustomizable | False |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: UseCollectionNameGroup: DetailsLabel: 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: DoNotDisplayGroup: DetailsLabel: 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: DoNotDisplayGroup: DetailsLabel: 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: DoNotDisplayGroup: DetailsLabel: 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: DoNotDisplayGroup: DetailsLabel: 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: UseCollectionNameGroup: DetailsLabel: 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: DoNotDisplayGroup: DetailsLabel: 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: DoNotDisplayGroup: DetailsLabel: 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: DoNotDisplayGroup: DetailsLabel: 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: DoNotDisplayGroup: DetailsLabel: 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: DoNotDisplayGroup: DetailsLabel: 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: DoNotDisplayGroup: DetailsLabel: 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: DoNotDisplayGroup: DetailsLabel: 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: DoNotDisplayGroup: DetailsLabel: 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: DoNotDisplayGroup: DetailsLabel: 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: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: CRMProductPriceLevel.RetrieveByObjectViewId: 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: DoNotDisplayGroup: DetailsLabel: 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: UseCollectionNameGroup: DetailsLabel: 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: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: 10000 QueryApi: CRMProduct.RetrieveByObjectViewId: 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: DoNotDisplayGroup: DetailsLabel: 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: UseCollectionNameGroup: DetailsLabel: MenuId: null Order: 10000 QueryApi: CRMProduct.RetrieveSubstitutesViewId: 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: UseCollectionNameGroup: DetailsLabel: 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: DoNotDisplayGroup: DetailsLabel: 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: DoNotDisplayGroup: DetailsLabel: 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: DoNotDisplayGroup: DetailsLabel: 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
- competitorproduct_association
- leadproduct_association
- msdyn_product_knowledgearticle
- product_entitlement_association
- product_entitlementtemplate_association
- product_knowledgebaserecord
- productsalesliterature_association
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: DoNotDisplayGroup: DetailsLabel: 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: UseCollectionNameGroup: DetailsLabel: MenuId: null Order: QueryApi: CRMProduct.RetrieveByObjectViewId: 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: DoNotDisplayGroup: DetailsLabel: 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: UseCollectionNameGroup: DetailsLabel: 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: DoNotDisplayGroup: DetailsLabel: 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: DoNotDisplayGroup: DetailsLabel: 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: UseCollectionNameGroup: DetailsLabel: 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: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: CRMProduct.RetrieveByObjectViewId: f8de15f4-4c76-4a21-94c9-a38fcafdb73d |
See also
Dataverse table/entity reference
Dataverse Web API Reference