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

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

Microsoft Dynamics CRM 2011
Send comments about this topic to Microsoft.
© 2013 Microsoft Corporation. All rights reserved.
Show: