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.
See also
प्रतिक्रिया
https://aka.ms/ContentUserFeedback.
जल्द आ रहा है: 2024 के दौरान हम सामग्री के लिए फीडबैक तंत्र के रूप में GitHub मुद्दों को चरणबद्ध तरीके से समाप्त कर देंगे और इसे एक नई फीडबैक प्रणाली से बदल देंगे. अधिक जानकारी के लिए, देखें:के लिए प्रतिक्रिया सबमिट करें और देखें