Product entity reference
Information about products and their pricing information.
Added by: Product Management Solution
Messages
Message | SDK class or method |
---|---|
Associate | AssociateRequest or Associate |
CloneProduct | CloneProductRequest |
Create | CreateRequest or Create |
Delete | DeleteRequest or Delete |
Disassociate | DisassociateRequest or Disassociate |
PublishProductHierarchy | PublishProductHierarchyRequest |
Retrieve | RetrieveRequest or Retrieve |
RetrieveMultiple | RetrieveMultipleRequest or RetrieveMultiple |
RevertProduct | RevertProductRequest |
SetState | SetStateRequest |
Update | UpdateRequest or Update |
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 attributes
These attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.
- CurrentCost
- DefaultUoMId
- DefaultUoMScheduleId
- Description
- DMTImportState
- EntityImage
- ImportSequenceNumber
- IsKit
- IsStockItem
- 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
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
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 |
IsValidForUpdate | False |
LogicalName | parentproductid |
RequiredLevel | None |
Targets | product |
Type | Lookup |
Price
Property | Value |
---|---|
Description | List price of the product. |
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 | Stage Id |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | stageid |
RequiredLevel | None |
Type | Uniqueidentifier |
StandardCost
Property | Value |
---|---|
Description | Standard cost of the product. |
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 | 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 attributes
These 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.0000000001 |
Precision | 10 |
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_SyncErrors
- Product_SharepointDocumentLocation
- Product_AsyncOperations
- product_MailboxTrackingFolders
- Product_ProcessSessions
- Product_BulkDeleteFailures
- product_principalobjectattributeaccess
- product_connections1
- product_connections2
- Product_Annotation
- Product_DynamicProperty
- Product_DynamicPropertyAssociation
- product_parent_product
- Product_ProductAssociation_AssocProd
- Product_ProductAssociation_Prod
- product_ProductSubstitute_substitutedproductid
- product_ProductSubstitute_productid
- product_price_levels
- product_contract_line_items
- product_incidents
- opportunity_products
- product_invoice_details
- product_order_details
- product_quote_details
Product_SyncErrors
Added by: System Solution Solution
Same as the Product_SyncErrors many-to-one relationship for the syncerror entity.
Property | Value |
---|---|
ReferencingEntity | syncerror |
ReferencingAttribute | regardingobjectid |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | Product_SyncErrors |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: Cascade Delete: Cascade Merge: Cascade Reparent: Cascade Share: Cascade Unshare: Cascade |
Product_SharepointDocumentLocation
Added by: System Solution Solution
Same as the Product_SharepointDocumentLocation many-to-one relationship for the sharepointdocumentlocation entity.
Property | Value |
---|---|
ReferencingEntity | sharepointdocumentlocation |
ReferencingAttribute | regardingobjectid |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | Product_SharepointDocumentLocation |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: Cascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
Product_AsyncOperations
Added by: System Solution Solution
Same as the Product_AsyncOperations many-to-one relationship for the asyncoperation entity.
Property | Value |
---|---|
ReferencingEntity | asyncoperation |
ReferencingAttribute | regardingobjectid |
IsHierarchical | False |
IsCustomizable | False |
ReferencedEntityNavigationPropertyName | Product_AsyncOperations |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
product_MailboxTrackingFolders
Added by: System Solution Solution
Same as the product_MailboxTrackingFolders many-to-one relationship for the mailboxtrackingfolder entity.
Property | Value |
---|---|
ReferencingEntity | mailboxtrackingfolder |
ReferencingAttribute | regardingobjectid |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | product_MailboxTrackingFolders |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
Product_ProcessSessions
Added by: System Solution Solution
Same as the Product_ProcessSessions many-to-one relationship for the processsession entity.
Property | Value |
---|---|
ReferencingEntity | processsession |
ReferencingAttribute | regardingobjectid |
IsHierarchical | False |
IsCustomizable | False |
ReferencedEntityNavigationPropertyName | Product_ProcessSessions |
AssociatedMenuConfiguration | Behavior: UseCollectionName Group: Details Label: Order: 110 |
CascadeConfiguration | Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
Product_BulkDeleteFailures
Added by: System Solution Solution
Same as the Product_BulkDeleteFailures many-to-one relationship for the bulkdeletefailure entity.
Property | Value |
---|---|
ReferencingEntity | bulkdeletefailure |
ReferencingAttribute | regardingobjectid |
IsHierarchical | False |
IsCustomizable | False |
ReferencedEntityNavigationPropertyName | Product_BulkDeleteFailures |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
product_principalobjectattributeaccess
Added by: System Solution Solution
Same as the product_principalobjectattributeaccess many-to-one relationship for the principalobjectattributeaccess entity.
Property | Value |
---|---|
ReferencingEntity | principalobjectattributeaccess |
ReferencingAttribute | objectid |
IsHierarchical | False |
IsCustomizable | False |
ReferencedEntityNavigationPropertyName | product_principalobjectattributeaccess |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
product_connections1
Added by: System Solution Solution
Same as the product_connections1 many-to-one relationship for the connection entity.
Property | Value |
---|---|
ReferencingEntity | connection |
ReferencingAttribute | record1id |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | product_connections1 |
AssociatedMenuConfiguration | Behavior: UseCollectionName Group: Details Label: Order: 100 |
CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
product_connections2
Added by: System Solution Solution
Same as the product_connections2 many-to-one relationship for the connection entity.
Property | Value |
---|---|
ReferencingEntity | connection |
ReferencingAttribute | record2id |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | product_connections2 |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: 100 |
CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
Product_Annotation
Added by: System Solution Solution
Same as the Product_Annotation many-to-one relationship for the annotation entity.
Property | Value |
---|---|
ReferencingEntity | annotation |
ReferencingAttribute | objectid |
IsHierarchical | False |
IsCustomizable | False |
ReferencedEntityNavigationPropertyName | Product_Annotation |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
Product_DynamicProperty
Same as the Product_DynamicProperty many-to-one relationship for the dynamicproperty entity.
Property | Value |
---|---|
ReferencingEntity | dynamicproperty |
ReferencingAttribute | regardingobjectid |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | Product_DynamicProperty |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
Product_DynamicPropertyAssociation
Same as the Product_DynamicPropertyAssociation many-to-one relationship for the dynamicpropertyassociation entity.
Property | Value |
---|---|
ReferencingEntity | dynamicpropertyassociation |
ReferencingAttribute | regardingobjectid |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | Product_DynamicPropertyAssociation |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
product_parent_product
Same as the product_parent_product many-to-one relationship for the product 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 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 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 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 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 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 |
product_contract_line_items
Added by: Service Solution
Same as the product_contract_line_items many-to-one relationship for the contractdetail entity.
Property | Value |
---|---|
ReferencingEntity | contractdetail |
ReferencingAttribute | productid |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | product_contract_line_items |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: NoCascade Delete: Restrict Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
product_incidents
Added by: Service Solution
Same as the product_incidents many-to-one relationship for the incident entity.
Property | Value |
---|---|
ReferencingEntity | incident |
ReferencingAttribute | productid |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | product_incidents |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: NoCascade Delete: Restrict 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 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 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 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 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 entity. Listed by SchemaName.
- lk_productbase_createdby
- lk_product_createdonbehalfby
- lk_productbase_modifiedby
- lk_product_modifiedonbehalfby
- organization_products
- processstage_products
- transactioncurrency_product
- price_level_products
- product_parent_product
- subject_products
- unit_of_measurement_products
- unit_of_measurement_schedule_products
lk_productbase_createdby
Added by: System Solution Solution
See the lk_productbase_createdby one-to-many relationship for the systemuser entity.
lk_product_createdonbehalfby
Added by: System Solution Solution
See the lk_product_createdonbehalfby one-to-many relationship for the systemuser entity.
lk_productbase_modifiedby
Added by: System Solution Solution
See the lk_productbase_modifiedby one-to-many relationship for the systemuser entity.
lk_product_modifiedonbehalfby
Added by: System Solution Solution
See the lk_product_modifiedonbehalfby one-to-many relationship for the systemuser entity.
organization_products
Added by: System Solution Solution
See the organization_products one-to-many relationship for the organization entity.
processstage_products
Added by: System Solution Solution
See the processstage_products one-to-many relationship for the processstage entity.
transactioncurrency_product
Added by: System Solution Solution
See the transactioncurrency_product one-to-many relationship for the transactioncurrency entity.
price_level_products
See the price_level_products one-to-many relationship for the pricelevel entity.
product_parent_product
See the product_parent_product one-to-many relationship for the product entity.
subject_products
Added by: System Solution Solution
See the subject_products one-to-many relationship for the subject entity.
unit_of_measurement_products
See the unit_of_measurement_products one-to-many relationship for the uom entity.
unit_of_measurement_schedule_products
See the unit_of_measurement_schedule_products one-to-many relationship for the uomschedule entity.
Many-To-Many Relationships
Relationship details provided where the Product entity is the first entity in the relationship. Listed by SchemaName.
- campaignproduct_association
- product_entitlement_association
- product_entitlementtemplate_association
- leadproduct_association
- productsalesliterature_association
- competitorproduct_association
campaignproduct_association
See the campaignproduct_association many-to-many relationship for the campaign entity.
product_entitlement_association
IntersectEntityName: entitlementproducts
Table 1
Property | Value |
---|---|
IntersectAttribute | productid |
IsCustomizable | False |
LogicalName | product |
NavigationPropertyName | product_entitlement_association |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
Table 2
Property | Value |
---|---|
LogicalName | entitlement |
IntersectAttribute | entitlementid |
NavigationPropertyName | product_entitlement_association |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
product_entitlementtemplate_association
IntersectEntityName: entitlementtemplateproducts
Table 1
Property | Value |
---|---|
IntersectAttribute | productid |
IsCustomizable | False |
LogicalName | product |
NavigationPropertyName | product_entitlementtemplate_association |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
Table 2
Property | Value |
---|---|
LogicalName | entitlementtemplate |
IntersectAttribute | entitlementtemplateid |
NavigationPropertyName | product_entitlementtemplate_association |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
leadproduct_association
See the leadproduct_association many-to-many relationship for the lead 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 entity.