SalesOrderDetail (Order Product) Entity Metadata
[Applies to: Microsoft Dynamics CRM 2011]
The following information is for the sales order detail (order product) entity in a default, uncustomized installation of Microsoft Dynamics CRM. The schema name and early bound class for this entity is SalesOrderDetail.
To view the entity metadata for your organization, install the Metadata Browser solution described in Browse the Metadata for Your Organization.
In This Topic
Entity Metadata
Privilege Metadata
Attribute Metadata
One-to-Many Relationships
Many-to-Many Relationships
Many-to-One Relationships
Entity Metadata
The following table shows the metadata for the sales order detail (order product) entity.
Entity metadata property | Value |
---|---|
EntityLogicalName |
salesorderdetail |
DisplayName |
Order Product |
DisplayCollectionName |
Order Products |
OTC |
1089 |
OwnershipType |
None |
IsCustomizable |
True |
IsAvailableOffline |
True |
AutoRouteToOwnerQueue |
False |
CanBeInManyToMany |
True |
CanBePrimaryEntityInRelationship |
True |
CanBeRelatedEntityInRelationship |
True |
CanCreateAttributes |
True |
CanCreateCharts |
True |
CanCreateForms |
True |
CanCreateViews |
True |
CanModifyAdditionalSettings |
True |
CanTriggerWorkflow |
True |
IsActivity |
False |
IsActivityParty |
False |
IsAuditEnabled |
False |
IsChildEntity |
True |
IsConnectionsEnabled |
canmodifyconnectionsettings |
IsCustomEntity |
False |
IsDocumentManagementEnabled |
False |
IsDuplicateDetectionEnabled |
False |
IsEnabledForCharts |
True |
IsImportable |
True |
IsIntersect |
False |
IsMailMergeEnabled |
False |
IsManaged |
True |
IsMappable |
True |
IsReadingPaneEnabled |
True |
IsRenameable |
True |
IsValidForAdvancedFind |
True |
IsValidForQueue |
False |
IsVisibleInMobile |
False |
PrimaryIdAttribute |
salesorderdetailid |
PrimaryNameAttribute |
productidname |
ReportViewName |
FilteredSalesOrderDetail |
RecurrenceBaseEntityLogicalName |
|
Description |
Line item in a sales order. |
Privilege Metadata
The is no privilege metadata for the sales order detail (order product) entity.
Attribute Metadata
The following table shows the attribute metadata for the sales order detail (order product) entity.
LogicalName | SchemaName | DisplayName | Type | RequiredLevel | IsValidForCreate | IsValidForRead | IsValidForUpdate | CanBeSecuredForCreate | CanBeSecuredForRead | CanBeSecuredForUpdate | IsAuditEnabled | IsCustomAttribute | IsCustomizable | IsManaged | IsPrimaryId | IsPrimaryName | IsRenameable | IsSecured | IsValidForAdvancedFind | Description | DeprecatedVersion |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
baseamount |
BaseAmount |
Amount |
Money |
None |
False |
True |
False |
False |
False |
False |
True |
False |
True |
True |
False |
False |
True |
False |
True |
Price of the order product before discounts are applied and taxes are added. |
|
baseamount_base |
BaseAmount_Base |
Amount (Base) |
Money |
None |
False |
True |
False |
False |
False |
False |
True |
False |
True |
True |
False |
False |
True |
False |
True |
Base currency equivalent of the price of the order product before discounts are applied and taxes are added. |
|
createdby |
CreatedBy |
Created By |
Lookup |
None |
False |
True |
False |
False |
False |
False |
False |
False |
True |
True |
False |
False |
True |
False |
True |
Unique identifier of the user who created the order product. |
|
createdon |
CreatedOn |
Created On |
DateTime |
None |
False |
True |
False |
False |
False |
False |
False |
False |
True |
True |
False |
False |
True |
False |
True |
Date and time when the order product was created. |
|
createdonbehalfby |
CreatedOnBehalfBy |
Created By (Delegate) |
Lookup |
None |
False |
True |
False |
False |
False |
False |
False |
False |
True |
True |
False |
False |
True |
False |
True |
Unique identifier of the delegate user who created the salesorderdetail. |
|
description |
Description |
Description |
Memo |
None |
True |
True |
True |
False |
False |
False |
True |
False |
True |
True |
False |
False |
True |
False |
True |
Description of the order product. |
|
exchangerate |
ExchangeRate |
Exchange Rate |
Decimal |
None |
False |
True |
False |
False |
False |
False |
True |
False |
True |
True |
False |
False |
True |
False |
True |
Exchange rate for the currency associated with the sales order detail with respect to the base currency. |
|
extendedamount |
ExtendedAmount |
Extended Amount |
Money |
None |
False |
True |
False |
False |
False |
False |
True |
False |
True |
True |
False |
False |
True |
False |
True |
Subtotal of the order product after discounts are applied and taxes are added. |
|
extendedamount_base |
ExtendedAmount_Base |
Extended Amount (Base) |
Money |
None |
False |
True |
False |
False |
False |
False |
True |
False |
True |
True |
False |
False |
True |
False |
True |
Base currency equivalent of the subtotal of the order product after discounts are applied and taxes are added. |
|
importsequencenumber |
ImportSequenceNumber |
Import Sequence Number |
Integer |
None |
True |
True |
False |
False |
False |
False |
True |
False |
True |
True |
False |
False |
True |
False |
True |
Unique identifier of the data import or data migration that created this record. |
|
iscopied |
IsCopied |
Copied |
Boolean |
None |
True |
True |
True |
False |
False |
False |
True |
False |
True |
True |
False |
False |
True |
False |
True |
Information that specifies whether the line was copied from a quote. |
|
ispriceoverridden |
IsPriceOverridden |
Pricing |
Boolean |
None |
True |
True |
True |
False |
False |
False |
True |
False |
True |
True |
False |
False |
True |
False |
True |
Information that specifies whether to override product catalog pricing. |
|
isproductoverridden |
IsProductOverridden |
Select Product |
Boolean |
None |
True |
True |
True |
False |
False |
False |
True |
False |
True |
True |
False |
False |
True |
False |
True |
Information that specifies whether the product is a write-in product or an existing product. |
|
lineitemnumber |
LineItemNumber |
Line Item Number |
Integer |
None |
True |
True |
True |
False |
False |
False |
True |
False |
True |
True |
False |
False |
True |
False |
True |
Line item number for the order product. |
|
manualdiscountamount |
ManualDiscountAmount |
Manual Discount |
Money |
None |
True |
True |
True |
False |
False |
False |
True |
False |
True |
True |
False |
False |
True |
False |
True |
Customized discount amount for the order product. |
|
manualdiscountamount_base |
ManualDiscountAmount_Base |
Manual Discount (Base) |
Money |
None |
False |
True |
False |
False |
False |
False |
True |
False |
True |
True |
False |
False |
True |
False |
True |
Base currency equivalent of the customized discount amount for the order product. |
|
modifiedby |
ModifiedBy |
Modified By |
Lookup |
None |
False |
True |
False |
False |
False |
False |
False |
False |
True |
True |
False |
False |
True |
False |
True |
Unique identifier of the user who last modified the order product. |
|
modifiedon |
ModifiedOn |
Modified On |
DateTime |
None |
False |
True |
False |
False |
False |
False |
False |
False |
True |
True |
False |
False |
True |
False |
True |
Date and time when the order product was last modified. |
|
modifiedonbehalfby |
ModifiedOnBehalfBy |
Modified By (Delegate) |
Lookup |
None |
False |
True |
False |
False |
False |
False |
False |
False |
True |
True |
False |
False |
True |
False |
True |
Unique identifier of the delegate user who last modified the salesorderdetail. |
|
overriddencreatedon |
OverriddenCreatedOn |
Record Created On |
DateTime |
None |
True |
True |
False |
False |
False |
False |
True |
False |
True |
True |
False |
False |
True |
False |
True |
Date and time that the record was migrated. |
|
ownerid |
OwnerId |
Owner |
Owner |
ApplicationRequired |
False |
True |
False |
False |
False |
False |
True |
False |
True |
True |
False |
False |
False |
False |
False |
Unique identifier of the user or team who owns the sales order detail. |
|
owningbusinessunit |
OwningBusinessUnit |
Owning Business Unit |
Uniqueidentifier |
ApplicationRequired |
False |
True |
False |
False |
False |
False |
False |
False |
False |
True |
False |
False |
False |
False |
False |
Unique identifier of the business unit that owns the order product. |
|
owninguser |
OwningUser |
Owning User |
Uniqueidentifier |
ApplicationRequired |
False |
True |
False |
False |
False |
False |
False |
False |
False |
True |
False |
False |
False |
False |
False |
Unique identifier of the user who owns the order product. |
|
priceperunit |
PricePerUnit |
Price Per Unit |
Money |
None |
True |
True |
True |
False |
False |
False |
True |
False |
True |
True |
False |
False |
True |
False |
True |
Price per unit for the order product. |
|
priceperunit_base |
PricePerUnit_Base |
Price Per Unit (Base) |
Money |
None |
False |
True |
False |
False |
False |
False |
True |
False |
True |
True |
False |
False |
True |
False |
True |
Base currency equivalent of the price per unit for the order product. |
|
pricingerrorcode |
PricingErrorCode |
Pricing Error |
Picklist |
None |
True |
True |
True |
False |
False |
False |
True |
False |
True |
True |
False |
False |
False |
False |
False |
Pricing error for the order product. |
|
productdescription |
ProductDescription |
Write-In Product |
String |
None |
True |
True |
True |
False |
False |
False |
True |
False |
True |
True |
False |
False |
True |
False |
True |
Product description for the order product. |
|
productid |
ProductId |
Existing Product |
Lookup |
None |
True |
True |
True |
False |
False |
False |
True |
False |
True |
True |
False |
False |
True |
False |
True |
Unique identifier of the product associated with the order product. |
|
quantity |
Quantity |
Quantity |
Decimal |
ApplicationRequired |
True |
True |
True |
False |
False |
False |
True |
False |
True |
True |
False |
False |
True |
False |
True |
Quantity specified for the order product. |
|
quantitybackordered |
QuantityBackordered |
Quantity Back Ordered |
Decimal |
None |
True |
True |
True |
False |
False |
False |
True |
False |
True |
True |
False |
False |
True |
False |
True |
Quantity that has been backordered for the order product. |
|
quantitycancelled |
QuantityCancelled |
Quantity Canceled |
Decimal |
None |
True |
True |
True |
False |
False |
False |
True |
False |
True |
True |
False |
False |
True |
False |
True |
Quantity that was canceled for the order product. |
|
quantityshipped |
QuantityShipped |
Quantity Shipped |
Decimal |
None |
True |
True |
True |
False |
False |
False |
True |
False |
True |
True |
False |
False |
True |
False |
True |
Quantity shipped for the product specified on the order. |
|
requestdeliveryby |
RequestDeliveryBy |
Requested Delivery Date |
DateTime |
None |
True |
True |
True |
False |
False |
False |
True |
False |
True |
True |
False |
False |
True |
False |
True |
Requested delivery date for the order product. |
|
salesorderdetailid |
SalesOrderDetailId |
Order Product |
Uniqueidentifier |
SystemRequired |
True |
True |
False |
False |
False |
False |
False |
False |
True |
True |
True |
False |
True |
False |
False |
Unique identifier of the product specified in the order. |
|
salesorderid |
SalesOrderId |
Order |
Lookup |
SystemRequired |
True |
True |
True |
False |
False |
False |
True |
False |
True |
True |
False |
False |
False |
False |
False |
Unique identifier of the order that is associated with the order product. |
|
salesorderispricelocked |
SalesOrderIsPriceLocked |
Order Is Price Locked |
Boolean |
ApplicationRequired |
False |
True |
False |
False |
False |
False |
True |
False |
True |
True |
False |
False |
False |
False |
False |
Information that specifies whether the order product pricing is locked. |
|
salesorderstatecode |
SalesOrderStateCode |
Order Status |
Picklist |
SystemRequired |
False |
True |
False |
False |
False |
False |
True |
False |
True |
True |
False |
False |
False |
False |
False |
Status of the order product. |
|
salesrepid |
SalesRepId |
Salesperson |
Lookup |
None |
True |
True |
True |
False |
False |
False |
True |
False |
True |
True |
False |
False |
True |
False |
True |
Unique identifier of the salesperson associated with the order product. |
|
shipto_addressid |
ShipTo_AddressId |
Ship To Address ID |
Uniqueidentifier |
None |
True |
True |
True |
False |
False |
False |
False |
False |
False |
True |
False |
False |
False |
False |
False |
Unique identifier of the shipping address. |
|
shipto_city |
ShipTo_City |
Ship To City |
String |
None |
True |
True |
True |
False |
False |
False |
True |
False |
True |
True |
False |
False |
True |
False |
True |
City name in the shipping address. |
|
shipto_contactname |
ShipTo_ContactName |
Ship To Contact Name |
String |
None |
True |
True |
True |
False |
False |
False |
True |
False |
True |
True |
False |
False |
True |
False |
True |
Contact name for the shipping address. |
|
shipto_country |
ShipTo_Country |
Ship To Country/Region |
String |
None |
True |
True |
True |
False |
False |
False |
True |
False |
True |
True |
False |
False |
True |
False |
True |
Country/region name in the shipping address. |
|
shipto_fax |
ShipTo_Fax |
Ship To Fax |
String |
None |
True |
True |
True |
False |
False |
False |
True |
False |
True |
True |
False |
False |
True |
False |
True |
Fax number for the shipping address. |
|
shipto_freighttermscode |
ShipTo_FreightTermsCode |
Freight Terms |
Picklist |
None |
True |
True |
True |
False |
False |
False |
True |
False |
True |
True |
False |
False |
True |
False |
True |
Freight terms for the shipping address. |
|
shipto_line1 |
ShipTo_Line1 |
Ship To Street 1 |
String |
None |
True |
True |
True |
False |
False |
False |
True |
False |
True |
True |
False |
False |
True |
False |
True |
First line for entering shipping address information. |
|
shipto_line2 |
ShipTo_Line2 |
Ship To Street 2 |
String |
None |
True |
True |
True |
False |
False |
False |
True |
False |
True |
True |
False |
False |
True |
False |
True |
Second line for entering shipping address information. |
|
shipto_line3 |
ShipTo_Line3 |
Ship To Street 3 |
String |
None |
True |
True |
True |
False |
False |
False |
True |
False |
True |
True |
False |
False |
True |
False |
True |
Third line for entering shipping address information. |
|
shipto_name |
ShipTo_Name |
Ship To Name |
String |
None |
True |
True |
True |
False |
False |
False |
True |
False |
True |
True |
False |
False |
True |
False |
True |
Name to enter for the shipping address. |
|
shipto_postalcode |
ShipTo_PostalCode |
Ship To ZIP/Postal Code |
String |
None |
True |
True |
True |
False |
False |
False |
True |
False |
True |
True |
False |
False |
True |
False |
True |
ZIP Code or postal code in the shipping address. |
|
shipto_stateorprovince |
ShipTo_StateOrProvince |
Ship To State/Province |
String |
None |
True |
True |
True |
False |
False |
False |
True |
False |
True |
True |
False |
False |
True |
False |
True |
State or province in the shipping address. |
|
shipto_telephone |
ShipTo_Telephone |
Ship To Phone |
String |
None |
True |
True |
True |
False |
False |
False |
True |
False |
True |
True |
False |
False |
True |
False |
True |
Telephone number associated with the shipping address. |
|
tax |
Tax |
Tax |
Money |
None |
True |
True |
True |
False |
False |
False |
True |
False |
True |
True |
False |
False |
True |
False |
True |
Tax amount for the order product. |
|
tax_base |
Tax_Base |
Tax (Base) |
Money |
None |
False |
True |
False |
False |
False |
False |
True |
False |
True |
True |
False |
False |
True |
False |
True |
Base currency equivalent of the tax amount for the order product. |
|
timezoneruleversionnumber |
TimeZoneRuleVersionNumber |
Time Zone Rule Version Number |
Integer |
None |
True |
True |
True |
False |
False |
False |
False |
False |
True |
True |
False |
False |
False |
False |
False |
For internal use only. |
|
transactioncurrencyid |
TransactionCurrencyId |
Currency |
Lookup |
None |
False |
True |
False |
False |
False |
False |
True |
False |
True |
True |
False |
False |
True |
False |
True |
Unique identifier of the currency associated with the sales order detail. |
|
uomid |
UoMId |
Unit |
Lookup |
None |
True |
True |
True |
False |
False |
False |
True |
False |
True |
True |
False |
False |
True |
False |
True |
Unique identifier for the unit that is associated with the order product. |
|
utcconversiontimezonecode |
UTCConversionTimeZoneCode |
UTC Conversion Time Zone Code |
Integer |
None |
True |
True |
True |
False |
False |
False |
False |
False |
True |
True |
False |
False |
False |
False |
False |
Time zone code that was in use when the record was created. |
|
versionnumber |
VersionNumber |
Version Number |
BigInt |
None |
False |
True |
False |
False |
False |
False |
False |
False |
False |
True |
False |
False |
False |
False |
False |
Version number of the sales order detail. |
|
volumediscountamount |
VolumeDiscountAmount |
Volume Discount |
Money |
None |
False |
True |
False |
False |
False |
False |
True |
False |
True |
True |
False |
False |
True |
False |
True |
Volume discount amount for the order product. |
|
volumediscountamount_base |
VolumeDiscountAmount_Base |
Volume Discount (Base) |
Money |
None |
False |
True |
False |
False |
False |
False |
True |
False |
True |
True |
False |
False |
True |
False |
True |
Base currency equivalent of the volume discount amount for the order product. |
|
willcall |
WillCall |
Ship To |
Boolean |
None |
True |
True |
True |
False |
False |
False |
True |
False |
True |
True |
False |
False |
True |
False |
True |
Specifies whether the customer will call for the ordered products or the products are to be shipped. |
One-to-Many Relationships
The following table shows the entities that are the referencing entity in a one-to-many relationship with the sales order detail (order product) entity.
Relationship schema name | Referencing entity |
---|---|
SalesOrderDetail_AsyncOperations |
asyncoperation |
SalesOrderDetail_BulkDeleteFailures |
bulkdeletefailure |
salesorderdetail_principalobjectattributeaccess |
principalobjectattributeaccess |
SalesOrderDetail_ProcessSessions |
processsession |
userentityinstancedata_salesorderdetail |
userentityinstancedata |
Many-to-Many Relationships
There are no many-to-many relationships for the sales order detail (order product) entity.
Many-to-One Relationships
The following table shows the entities that are the referenced entity in a many-to-one relationship with the sales order detail (order product) entity.
Relationship schema name | Referencing entity |
---|---|
product_order_details |
product |
order_details |
salesorder |
lk_salesorderdetail_createdonbehalfby |
systemuser |
system_user_salesorderdetail |
systemuser |
lk_salesorderdetailbase_createdby |
systemuser |
lk_salesorderdetailbase_modifiedby |
systemuser |
lk_salesorderdetail_modifiedonbehalfby |
systemuser |
transactioncurrency_salesorderdetail |
transactioncurrency |
unit_of_measurement_order_details |
uom |
See Also
Reference
EntityMetadata
AttributeMetadata
OneToManyRelationshipMetadata
ManyToManyRelationshipMetadata
Concepts
SalesOrderDetail (Order Product) Entity Messages and Methods
SalesOrderDetail (Order Product) Entity Privileges
Microsoft Dynamics CRM 2011
Send comments about this topic to Microsoft.
© 2013 Microsoft Corporation. All rights reserved.