QuoteDetail (Quote Product) Entity Metadata

[Applies to: Microsoft Dynamics CRM 2011]

The following information is for the quote detail (quote product) entity in a default, uncustomized installation of Microsoft Dynamics CRM. The schema name and early bound class for this entity is QuoteDetail.

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 quote detail (quote product) entity.

 

Metadata property Value

EntityLogicalName

quotedetail

DisplayName

Quote Product

DisplayCollectionName

Quote Products

OTC

1085

OwnershipType

None

IsCustomizable

True

IsIntersect

False

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

IsAvailableOffline

True

IsChildEntity

True

IsConnectionsEnabled

canmodifyconnectionsettings

IsCustomEntity

False

IsDocumentManagementEnabled

False

IsDuplicateDetectionEnabled

False

IsEnabledForCharts

True

IsImportable

True

IsMailMergeEnabled

False

IsManaged

True

IsMappable

True

IsReadingPaneEnabled

True

IsRenameable

True

IsValidForAdvancedFind

True

IsValidForQueue

False

IsVisibleInMobile

False

PrimaryIdAttribute

quotedetailid

PrimaryNameAttribute

productidname

ReportViewName

FilteredQuoteDetail

RecurrenceBaseEntityLogicalName

Description

Product line item in a quote. The details include such information as product ID, description, quantity, and cost.

Privilege Metadata

There is no privilege metadata for the quote detail (quote product) entity.

Attribute Metadata

The following table shows the attribute metadata for the quote detail (quote product) entity.

 

LogicalName SchemaName DisplayName Type RequiredLevel IsCustomizable IsValidForCreate IsValidForRead IsValidForUpdate IsCustomAttribute CanBeSecuredForCreate CanBeSecuredForRead CanBeSecuredForUpdate IsAuditEnabled IsManaged IsPrimaryId IsPrimaryName IsRenameable IsSecured IsValidForAdvancedFind Description DeprecatedVersion

baseamount

BaseAmount

Amount

Money

None

True

False

True

False

False

False

False

False

True

True

False

False

True

False

True

Subtotal of the quote product before discounts are applied and taxes are added.

baseamount_base

BaseAmount_Base

Amount (Base)

Money

None

True

False

True

False

False

False

False

False

True

True

False

False

True

False

True

Base currency equivalent of the subtotal of the quote product before discounts are applied and taxes are added.

createdby

CreatedBy

Created By

Lookup

None

True

False

True

False

False

False

False

False

False

True

False

False

True

False

True

Unique identifier of the user who created the quote product.

createdon

CreatedOn

Created On

DateTime

None

True

False

True

False

False

False

False

False

False

True

False

False

True

False

True

Date and time when the quote product was created.

createdonbehalfby

CreatedOnBehalfBy

Created By (Delegate)

Lookup

None

True

False

True

False

False

False

False

False

False

True

False

False

True

False

True

Unique identifier of the delegate user who created the quotedetail.

description

Description

Description

Memo

None

True

True

True

True

False

False

False

False

True

True

False

False

True

False

True

Description of the quote product.

exchangerate

ExchangeRate

Exchange Rate

Decimal

None

True

False

True

False

False

False

False

False

True

True

False

False

True

False

True

Exchange rate for the currency associated with the quote detail with respect to the base currency.

extendedamount

ExtendedAmount

Extended Amount

Money

None

True

False

True

False

False

False

False

False

True

True

False

False

True

False

True

Subtotal of the quote product after discounts are applied and taxes are added.

extendedamount_base

ExtendedAmount_Base

Extended Amount (Base)

Money

None

True

False

True

False

False

False

False

False

True

True

False

False

True

False

True

Base currency equivalent of the subtotal of the quote product after discounts are applied and taxes are added.

importsequencenumber

ImportSequenceNumber

Import Sequence Number

Integer

None

True

True

True

False

False

False

False

False

True

True

False

False

True

False

True

Unique identifier of the data import or data migration that created this record.

ispriceoverridden

IsPriceOverridden

Price Overridden

Boolean

None

True

True

True

True

False

False

False

False

True

True

False

False

True

False

True

Information about whether to override product catalog pricing.

isproductoverridden

IsProductOverridden

Select Product

Boolean

None

True

True

True

True

False

False

False

False

True

True

False

False

True

False

True

Information about whether the product is a write-in product or an existing product.

lineitemnumber

LineItemNumber

Line Item Number

Integer

None

True

True

True

True

False

False

False

False

True

True

False

False

True

False

True

Line item number for the quote product.

manualdiscountamount

ManualDiscountAmount

Manual Discount

Money

None

True

True

True

True

False

False

False

False

True

True

False

False

True

False

True

Customized discount amount for the quote product.

manualdiscountamount_base

ManualDiscountAmount_Base

Manual Discount (Base)

Money

None

True

False

True

False

False

False

False

False

True

True

False

False

True

False

True

Base currency equivalent of the customized discount amount for the quote product.

modifiedby

ModifiedBy

Modified By

Lookup

None

True

False

True

False

False

False

False

False

False

True

False

False

True

False

True

Unique identifier of the user who last modified the quote product.

modifiedon

ModifiedOn

Modified On

DateTime

None

True

False

True

False

False

False

False

False

False

True

False

False

True

False

True

Date and time when the quote product was last modified.

modifiedonbehalfby

ModifiedOnBehalfBy

Modified By (Delegate)

Lookup

None

True

False

True

False

False

False

False

False

False

True

False

False

True

False

True

Unique identifier of the delegate user who last modified the quotedetail.

overriddencreatedon

OverriddenCreatedOn

Record Created On

DateTime

None

True

True

True

False

False

False

False

False

True

True

False

False

True

False

True

Date and time that the record was migrated.

ownerid

OwnerId

Owner

Owner

ApplicationRequired

True

False

True

False

False

False

False

False

True

True

False

False

False

False

False

Unique identifier of the user or team who owns the quote detail.

owningbusinessunit

OwningBusinessUnit

Owning Business Unit

Uniqueidentifier

ApplicationRequired

False

False

True

False

False

False

False

False

False

True

False

False

False

False

False

Unique identifier of the business unit that owns the quote detail.

owninguser

OwningUser

Owning User

Uniqueidentifier

ApplicationRequired

False

False

True

False

False

False

False

False

False

True

False

False

False

False

False

Unique identifier of the user who owns the quote detail.

priceperunit

PricePerUnit

Price Per Unit

Money

None

True

True

True

True

False

False

False

False

True

True

False

False

True

False

True

Price per unit for the quote product.

priceperunit_base

PricePerUnit_Base

Price Per Unit (Base)

Money

None

True

False

True

False

False

False

False

False

True

True

False

False

True

False

True

Base currency equivalent of the price per unit for the quote product.

pricingerrorcode

PricingErrorCode

Pricing Error

Picklist

None

True

True

True

True

False

False

False

False

True

True

False

False

False

False

False

Pricing error for the quote product.

productdescription

ProductDescription

Write-In Product

String

None

True

True

True

True

False

False

False

False

True

True

False

False

True

False

True

Product description for the quote product.

productid

ProductId

Existing Product

Lookup

None

True

True

True

True

False

False

False

False

True

True

False

False

True

False

True

Unique identifier of the product associated with the quote product.

quantity

Quantity

Quantity

Decimal

ApplicationRequired

True

True

True

True

False

False

False

False

True

True

False

False

True

False

True

Product quantity specified for the quote product.

quotedetailid

QuoteDetailId

Quote Product

Uniqueidentifier

SystemRequired

True

True

True

False

False

False

False

False

False

True

True

False

True

False

False

Unique identifier of the product line item in the quote.

quoteid

QuoteId

Quote

Lookup

SystemRequired

True

True

True

True

False

False

False

False

True

True

False

False

False

False

False

Unique identifier of the quote for the quote product.

quotestatecode

QuoteStateCode

Quote Status

Picklist

SystemRequired

True

False

True

False

False

False

False

False

True

True

False

False

False

False

False

Status of the quote product.

requestdeliveryby

RequestDeliveryBy

Requested Delivery Date

DateTime

None

True

True

True

True

False

False

False

False

True

True

False

False

True

False

True

Requested delivery date for the quote product.

salesrepid

SalesRepId

Salesperson

Lookup

None

True

True

True

True

False

False

False

False

True

True

False

False

True

False

True

Unique identifier of the salesperson associated with the quote product.

shipto_addressid

ShipTo_AddressId

Ship To Address ID

Uniqueidentifier

None

False

True

True

True

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

True

False

False

False

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

True

False

False

False

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

True

False

False

False

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

True

False

False

False

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

True

False

False

False

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

True

False

False

False

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

True

False

False

False

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

True

False

False

False

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

True

False

False

False

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

True

False

False

False

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

True

False

False

False

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

True

False

False

False

False

True

True

False

False

True

False

True

Telephone number associated with the shipping address.

tax

Tax

Tax

Money

None

True

True

True

True

False

False

False

False

True

True

False

False

True

False

True

Tax amount for the quote product.

tax_base

Tax_Base

Tax (Base)

Money

None

True

False

True

False

False

False

False

False

True

True

False

False

True

False

True

Base currency equivalent of the tax amount for the quote product.

timezoneruleversionnumber

TimeZoneRuleVersionNumber

Time Zone Rule Version Number

Integer

None

True

True

True

True

False

False

False

False

False

True

False

False

False

False

False

For internal use only.

transactioncurrencyid

TransactionCurrencyId

Currency

Lookup

None

True

False

True

False

False

False

False

False

True

True

False

False

True

False

True

Unique identifier of the currency associated with the quote detail.

uomid

UoMId

Unit

Lookup

None

True

True

True

True

False

False

False

False

True

True

False

False

True

False

True

Unique identifier of the unit that is associated with the quote product.

utcconversiontimezonecode

UTCConversionTimeZoneCode

UTC Conversion Time Zone Code

Integer

None

True

True

True

True

False

False

False

False

False

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

False

True

False

False

False

False

False

False

True

False

False

False

False

False

Version number of the quote detail.

volumediscountamount

VolumeDiscountAmount

Volume Discount

Money

None

True

False

True

False

False

False

False

False

True

True

False

False

True

False

True

Volume discount amount for the quote product.

volumediscountamount_base

VolumeDiscountAmount_Base

Volume Discount (Base)

Money

None

True

False

True

False

False

False

False

False

True

True

False

False

True

False

True

Base currency equivalent of the volume discount amount for the quote product.

willcall

WillCall

Ship To

Boolean

None

True

True

True

True

False

False

False

False

True

True

False

False

True

False

True

Information about whether the customer will call for the quoted 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 quote detail (quote product) entity.

 

Relationship schema name Referencing entity

QuoteDetail_AsyncOperations

asyncoperation

QuoteDetail_BulkDeleteFailures

bulkdeletefailure

quotedetail_principalobjectattributeaccess

principalobjectattributeaccess

QuoteDetail_ProcessSessions

processsession

userentityinstancedata_quotedetail

userentityinstancedata

Many-to-Many Relationships

There are no many-to-many relationships for the quote detail (quote 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 quote detail (quote product) entity.

 

Relationship schema name Referenced entity

product_quote_details

product

quote_details

quote

lk_quotedetailbase_createdby

systemuser

lk_quotedetailbase_modifiedby

systemuser

lk_quotedetail_createdonbehalfby

systemuser

system_user_quotedetail

systemuser

lk_quotedetail_modifiedonbehalfby

systemuser

transactioncurrency_quotedetail

transactioncurrency

unit_of_measurement_quote_details

uom

See Also

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

Community Additions

Show: