ProductAssociation table/entity reference
Note
Unsure about table vs. entity? See Developers: Understand terminology in Microsoft Dataverse.
Instance of a product added to a bundle or kit.
Added by: Product Management Solution
Messages
| Message | Web API Operation | SDK class or method |
|---|---|---|
| Create | POST /productassociations See Create |
CreateRequest or Create |
| CreateMultiple | CreateMultiple | CreateMultipleRequest |
| Delete | DELETE /productassociations(productassociationid) See Delete |
DeleteRequest or Delete |
| Retrieve | GET /productassociations(productassociationid) See Retrieve |
RetrieveRequest or Retrieve |
| RetrieveMultiple | GET /productassociations See Query Data |
RetrieveMultipleRequest or RetrieveMultiple |
| SetState | PATCH /productassociations(productassociationid) Update statecode and statuscode properties. |
SetStateRequest |
| Update | PATCH /productassociations(productassociationid) See Update |
UpdateRequest or Update |
| UpdateMultiple | UpdateMultiple | UpdateMultipleRequest |
Properties
| Property | Value |
|---|---|
| CollectionSchemaName | ProductAssociations |
| DisplayCollectionName | Product Associations |
| DisplayName | Product Association |
| EntitySetName | productassociations |
| IsBPFEntity | False |
| LogicalCollectionName | productassociations |
| LogicalName | productassociation |
| OwnershipType | OrganizationOwned |
| PrimaryIdAttribute | productassociationid |
| PrimaryNameAttribute | productidname |
| SchemaName | ProductAssociation |
Writable columns/attributes
These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.
- AssociatedProduct
- DMTImportState
- ImportSequenceNumber
- OverriddenCreatedOn
- ProductAssociationId
- ProductId
- ProductIsRequired
- PropertyCustomizationStatus
- Quantity
- statecode
- statuscode
- TimeZoneRuleVersionNumber
- TransactionCurrencyId
- UoMId
- UTCConversionTimeZoneCode
AssociatedProduct
| Property | Value |
|---|---|
| Description | Select a product to add to the bundle or kit. |
| DisplayName | Associated Product |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | associatedproduct |
| RequiredLevel | SystemRequired |
| Targets | product |
| Type | Lookup |
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 |
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 |
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 |
ProductAssociationId
| Property | Value |
|---|---|
| Description | Shows the unique identifier of the product association. |
| DisplayName | Product Association ID |
| IsValidForForm | False |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | productassociationid |
| RequiredLevel | SystemRequired |
| Type | Uniqueidentifier |
ProductId
| Property | Value |
|---|---|
| Description | Select a bundle or a kit. |
| DisplayName | Product |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | productid |
| RequiredLevel | SystemRequired |
| Targets | product |
| Type | Lookup |
ProductIsRequired
| Property | Value |
|---|---|
| Description | Select whether the associated product is required or optional. |
| DisplayName | Required/Optional |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | productisrequired |
| RequiredLevel | ApplicationRequired |
| Type | Picklist |
ProductIsRequired Choices/Options
| Value | Label | Description |
|---|---|---|
| 0 | Optional | |
| 1 | Required |
PropertyCustomizationStatus
| Property | Value |
|---|---|
| Description | Shows whether the item has properties that can be customized. |
| DisplayName | Property Customization |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | propertycustomizationstatus |
| RequiredLevel | SystemRequired |
| Type | Picklist |
PropertyCustomizationStatus Choices/Options
| Value | Label | Description |
|---|---|---|
| 0 | Not Available | |
| 1 | Available |
Quantity
| Property | Value |
|---|---|
| Description | Type the quantity of the products added to the bundle or kit. |
| DisplayName | Quantity |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | quantity |
| MaxValue | 100000000000 |
| MinValue | 0 |
| Precision | 5 |
| RequiredLevel | ApplicationRequired |
| Type | Decimal |
statecode
| Property | Value |
|---|---|
| Description | Shows whether the associated product is active or inactive. |
| DisplayName | Status |
| IsValidForCreate | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | statecode |
| RequiredLevel | SystemRequired |
| Type | State |
statecode Choices/Options
| Value | Label | DefaultStatus | InvariantName |
|---|---|---|---|
| 0 | Active | 1 | Active |
| 1 | Inactive | 2 | Inactive |
| 2 | Draft | 0 | Draft |
| 3 | Under Revision | 3 | Under Revision |
statuscode
| Property | Value |
|---|---|
| Description | Select the associated product's status. |
| 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 | Inactive | 1 |
| 3 | DraftActive | 3 |
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 | Shows the currency associated with the record. |
| DisplayName | Currency |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | transactioncurrencyid |
| RequiredLevel | None |
| Targets | transactioncurrency |
| Type | Lookup |
UoMId
| Property | Value |
|---|---|
| Description | Shows the unit of the product association. |
| DisplayName | Unit |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | uomid |
| RequiredLevel | ApplicationRequired |
| Targets | uom |
| Type | Lookup |
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 |
Read-only columns/attributes
These columns/attributes return false for both IsValidForCreate or IsValidForUpdate. Listed by SchemaName.
- AssociatedProductIdName
- CreatedBy
- CreatedByName
- CreatedByYomiName
- CreatedOn
- CreatedOnBehalfBy
- CreatedOnBehalfByName
- CreatedOnBehalfByYomiName
- ExchangeRate
- ModifiedBy
- ModifiedByName
- ModifiedByYomiName
- ModifiedOn
- ModifiedOnBehalfBy
- ModifiedOnBehalfByName
- ModifiedOnBehalfByYomiName
- OrganizationId
- OrganizationIdName
- ProductIdName
- TransactionCurrencyIdName
- UoMIdName
- VersionNumber
AssociatedProductIdName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | associatedproductidname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
CreatedBy
| Property | Value |
|---|---|
| Description | Shows who created the record. |
| DisplayName | Created By |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | createdby |
| RequiredLevel | None |
| Targets | systemuser |
| Type | Lookup |
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 | SystemRequired |
| 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 | Shows who created the record on behalf of another user. |
| 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 | SystemRequired |
| Type | String |
ExchangeRate
| Property | Value |
|---|---|
| Description | 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. |
| DisplayName | Exchange Rate |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | exchangerate |
| MaxValue | 100000000000 |
| MinValue | 0.000000000001 |
| Precision | 12 |
| RequiredLevel | None |
| Type | Decimal |
ModifiedBy
| Property | Value |
|---|---|
| Description | Shows who last updated the record. |
| DisplayName | Modified By |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | modifiedby |
| RequiredLevel | None |
| Targets | systemuser |
| Type | Lookup |
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 | SystemRequired |
| 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 | Shows who created the record on behalf of another user. |
| 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 | SystemRequired |
| 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 |
ProductIdName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | productidname |
| 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 |
UoMIdName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | uomidname |
| MaxLength | 100 |
| RequiredLevel | ApplicationRequired |
| 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.
- productAssociation_quote_details
- productAssociation_opportunity_product
- productAssociation_invoice_details
- productAssociation_salesorder_details
productAssociation_quote_details
Added by: Sales Solution
Same as the productAssociation_quote_details many-to-one relationship for the quotedetail table/entity.
| Property | Value |
|---|---|
| ReferencingEntity | quotedetail |
| ReferencingAttribute | productassociationid |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | productAssociation_quote_details |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: Restrict Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
productAssociation_opportunity_product
Added by: Sales Solution
Same as the productAssociation_opportunity_product many-to-one relationship for the opportunityproduct table/entity.
| Property | Value |
|---|---|
| ReferencingEntity | opportunityproduct |
| ReferencingAttribute | productassociationid |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | productAssociation_opportunity_product |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: Restrict Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
productAssociation_invoice_details
Added by: Sales Solution
Same as the productAssociation_invoice_details many-to-one relationship for the invoicedetail table/entity.
| Property | Value |
|---|---|
| ReferencingEntity | invoicedetail |
| ReferencingAttribute | productassociationid |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | productAssociation_invoice_details |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: Restrict Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
productAssociation_salesorder_details
Added by: Sales Solution
Same as the productAssociation_salesorder_details many-to-one relationship for the salesorderdetail table/entity.
| Property | Value |
|---|---|
| ReferencingEntity | salesorderdetail |
| ReferencingAttribute | productassociationid |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | productAssociation_salesorder_details |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: Restrict Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
Many-To-One Relationships
Each Many-To-One relationship is defined by a corresponding One-To-Many relationship with the related table. Listed by SchemaName.
- Product_ProductAssociation_AssocProd
- Product_ProductAssociation_Prod
- unit_of_measurement_productassociation
Product_ProductAssociation_AssocProd
See the Product_ProductAssociation_AssocProd one-to-many relationship for the product table/entity.
Product_ProductAssociation_Prod
See the Product_ProductAssociation_Prod one-to-many relationship for the product table/entity.
unit_of_measurement_productassociation
See the unit_of_measurement_productassociation one-to-many relationship for the uom table/entity.