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.