Product table/entity reference
Note
Unsure about table vs. entity? See Developers: Understand terminology in Microsoft Dataverse.
Information about products and their pricing information.
Added by: Product Management Solution
Messages
Message | Web API Operation | SDK class or method |
---|---|---|
Associate | Associate and disassociate entities | AssociateRequest or Associate |
CloneProduct | CloneProductRequest | |
Create | POST /products See Create |
CreateRequest or Create |
CreateMultiple | CreateMultiple | CreateMultipleRequest |
Delete | DELETE /products(productid) See Delete |
DeleteRequest or Delete |
Disassociate | Associate and disassociate entities | DisassociateRequest or Disassociate |
PublishProductHierarchy | PublishProductHierarchyRequest | |
Retrieve | GET /products(productid) See Retrieve |
RetrieveRequest or Retrieve |
RetrieveMultiple | GET /products See Query Data |
RetrieveMultipleRequest or RetrieveMultiple |
RevertProduct | RevertProductRequest | |
SetState | PATCH /products(productid) Update statecode and statuscode properties. |
SetStateRequest |
Update | PATCH /products(productid) See Update |
UpdateRequest or Update |
UpdateMultiple | UpdateMultiple | UpdateMultipleRequest |
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 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_gdproptout
- 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 |
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
IsReparented
Added by: Product Management Patch Solution
Property | Value |
---|---|
Description | |
DisplayName | Is Reparented |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | isreparented |
RequiredLevel | None |
Type | Boolean |
IsReparented 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
msdyn_gdproptout
Added by: Predictive Opportunity Scoring Solution
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 |
msdyn_gdproptout 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 |
LogicalName | parentproductid |
RequiredLevel | None |
Targets | product |
Type | Lookup |
Price
Property | Value |
---|---|
Description | List price for the product item. Used in price calculations. |
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 | (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 |
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 | (Deprecated) 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 columns/attributes
These columns/attributes return false for both IsValidForCreate or IsValidForUpdate. Listed by SchemaName.
- CreatedBy
- CreatedByExternalParty
- CreatedByExternalPartyName
- CreatedByExternalPartyYomiName
- CreatedByName
- CreatedByYomiName
- CreatedOn
- CreatedOnBehalfBy
- CreatedOnBehalfByName
- CreatedOnBehalfByYomiName
- CurrentCost_Base
- DefaultUoMIdName
- DefaultUoMScheduleIdName
- EntityImage_Timestamp
- EntityImage_URL
- EntityImageId
- ExchangeRate
- HierarchyPath
- ModifiedBy
- ModifiedByExternalParty
- ModifiedByExternalPartyName
- ModifiedByExternalPartyYomiName
- ModifiedByName
- ModifiedByYomiName
- ModifiedOn
- ModifiedOnBehalfBy
- ModifiedOnBehalfByName
- ModifiedOnBehalfByYomiName
- OrganizationId
- OrganizationIdName
- ParentProductIdName
- Price_Base
- PriceLevelIdName
- StandardCost_Base
- SubjectIdName
- TransactionCurrencyIdName
- 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 |
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.000000000001 |
Precision | 12 |
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_parent_product
- Product_ProductAssociation_AssocProd
- Product_ProductAssociation_Prod
- product_ProductSubstitute_substitutedproductid
- product_ProductSubstitute_productid
- product_price_levels
- opportunity_products
- product_invoice_details
- product_order_details
- product_quote_details
product_parent_product
Same as the product_parent_product many-to-one relationship for the product table/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 table/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 table/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 table/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 table/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 table/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 |
opportunity_products
Added by: Sales Solution
Same as the opportunity_products many-to-one relationship for the opportunityproduct table/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 table/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 table/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 table/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 table. Listed by SchemaName.
- price_level_products
- product_parent_product
- unit_of_measurement_products
- unit_of_measurement_schedule_products
price_level_products
See the price_level_products one-to-many relationship for the pricelevel table/entity.
product_parent_product
See the product_parent_product one-to-many relationship for the product table/entity.
unit_of_measurement_products
See the unit_of_measurement_products one-to-many relationship for the uom table/entity.
unit_of_measurement_schedule_products
See the unit_of_measurement_schedule_products one-to-many relationship for the uomschedule table/entity.
Many-To-Many Relationships
Relationship details provided where the Product table is the first table in the relationship. Listed by SchemaName.
- campaignproduct_association
- leadproduct_association
- productsalesliterature_association
- competitorproduct_association
campaignproduct_association
See the campaignproduct_association many-to-many relationship for the campaign table/entity.
leadproduct_association
See the leadproduct_association many-to-many relationship for the lead table/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 table/entity.
See also
प्रतिक्रिया
https://aka.ms/ContentUserFeedback.
जल्द आ रहा है: 2024 के दौरान हम सामग्री के लिए फीडबैक तंत्र के रूप में GitHub मुद्दों को चरणबद्ध तरीके से समाप्त कर देंगे और इसे एक नई फीडबैक प्रणाली से बदल देंगे. अधिक जानकारी के लिए, देखें:के लिए प्रतिक्रिया सबमिट करें और देखें