quotedetail EntityType
Description: Product line item in a quote. The details include such information as product ID, description, quantity, and cost.
Entity Set path: [organization URI]/api/data/v8.0/quotedetails
Base Type: crmbaseentity EntityType
Display Name: Quote Product
Primary Key: quotedetailid
Primary Name Attribute: productidname
Properties
Single-valued navigation properties
Collection-valued navigation properties
Operations bound to quotedetail
Operations using the quotedetail entity type.
Properties
Properties represent fields of data stored in the entity. Some properties are not writable.
| Name | Type | Details |
|---|---|---|
_createdby_value |
Edm.Guid |
Description: Shows who created the record. Computed property Read-only property |
_createdonbehalfby_value |
Edm.Guid |
Description: Shows who created the record on behalf of another user. Computed property Read-only property |
_modifiedby_value |
Edm.Guid |
Description: Shows who last updated the record. Computed property Read-only property |
_modifiedonbehalfby_value |
Edm.Guid |
Description: Shows who last updated the record on behalf of another user. Computed property Read-only property |
_ownerid_value |
Edm.Guid |
Description: Unique identifier of the user or team who owns the quote detail. Read-only property |
_productid_value |
Edm.Guid |
Description: Choose the product to include on the quote to link the product's pricing and other information to the quote. Computed property Read-only property |
_quoteid_value |
Edm.Guid |
Description: Unique identifier of the quote for the quote product. Computed property Read-only property |
_salesrepid_value |
Edm.Guid |
Description: Choose the user responsible for the sale of the quote product. Computed property Read-only property |
_transactioncurrencyid_value |
Edm.Guid |
Description: Choose the local currency for the record to make sure budgets are reported in the correct currency. Computed property Read-only property |
_uomid_value |
Edm.Guid |
Description: Choose the unit of measurement for the base unit quantity for this purchase, such as each or dozen. Computed property Read-only property |
baseamount |
Edm.Decimal |
Description: Shows the total price of the quote product, based on the price per unit, volume discount, and quantity. Display Name: Amount |
baseamount_base |
Edm.Decimal |
Description: Shows the Amount field converted to the system's default base currency. The calculation uses the exchange rate specified in the Currencies area. Display Name: Amount (Base) Read-only property |
createdon |
Edm.DateTimeOffset |
Description: Shows the date and time when the record was created. The date and time are displayed in the time zone selected in Microsoft Dynamics CRM options. Display Name: Created On Read-only property |
description |
Edm.String |
Description: Type additional information to describe the quote product, such as manufacturing details or acceptable substitutions. Display Name: Description |
exchangerate |
Edm.Decimal |
Description: Shows the conversion rate of the record's currency. The exchange rate is used to convert all money fields in the record from the local currency to the system's default currency. Display Name: Exchange Rate Read-only property |
extendedamount |
Edm.Decimal |
Description: Shows the total amount due for the quote product, based on the sum of the unit price, quantity, discounts ,and tax. Display Name: Extended Amount |
extendedamount_base |
Edm.Decimal |
Description: Shows the Extended Amount field converted to the system's default base currency. The calculation uses the exchange rate specified in the Currencies area. Display Name: Extended Amount (Base) Read-only property |
importsequencenumber |
Edm.Int32 |
Description: Unique identifier of the data import or data migration that created this record. Display Name: Import Sequence Number |
ispriceoverridden |
Edm.Boolean |
Description: Select whether the price per unit is fixed at the value in the specified price list or can be overridden by users who have edit rights to the quote product. Default Options: 1 : Override Price Display Name: Price Overridden |
isproductoverridden |
Edm.Boolean |
Description: Select whether the product exists in the Microsoft Dynamics CRM product catalog or is a write-in product specific to the quote. Default Options: 1 : Write In Display Name: Select Product |
lineitemnumber |
Edm.Int32 |
Description: Type the line item number for the quote product to easily identify the product in the quote and make sure it's listed in the correct order. Display Name: Line Item Number |
manualdiscountamount |
Edm.Decimal |
Description: Type the manual discount amount for the quote product to deduct any negotiated or other savings from the product total on the quote. Display Name: Manual Discount |
manualdiscountamount_base |
Edm.Decimal |
Description: Shows the Manual Discount field converted to the system's default base currency for reporting purposes. The calculation uses the exchange rate specified in the Currencies area. Display Name: Manual Discount (Base) Read-only property |
modifiedon |
Edm.DateTimeOffset |
Description: Shows the date and time when the record was last updated. The date and time are displayed in the time zone selected in Microsoft Dynamics CRM options. Display Name: Modified On Read-only property |
overriddencreatedon |
Edm.DateTimeOffset |
Description: Date and time that the record was migrated. Display Name: Record Created On |
owningbusinessunit |
Edm.Guid |
Description: Unique identifier of the business unit that owns the quote detail. Display Name: Owning Business Unit Read-only property |
owninguser |
Edm.Guid |
Description: Unique identifier of the user who owns the quote detail. Display Name: Owning User Read-only property |
parentbundleid |
Edm.Guid |
Description: Choose the parent bundle associated with this product Display Name: Parent Bundle |
priceperunit |
Edm.Decimal |
Description: Type the price per unit of the quote product. The default is to the value in the price list specified on the quote for existing products. Display Name: Price Per Unit |
priceperunit_base |
Edm.Decimal |
Description: Shows the Price Per Unit field converted to the system's default base currency for reporting purposes. The calculation uses the exchange rate specified in the Currencies area. Display Name: Price Per Unit (Base) Read-only property |
pricingerrorcode |
Edm.Int32 |
Description: Select the type of pricing error, such as a missing or invalid product, or missing quantity. Default Options: 0 : None Display Name: Pricing Error |
productassociationid |
Edm.Guid |
Description: Unique identifier of the product line item association with bundle in the quote Display Name: Bundle Item Association |
productdescription |
Edm.String |
Description: Type a name or description to identify the type of write-in product included in the quote. Display Name: Write-In Product |
producttypecode |
Edm.Int32 |
Description: Product Type Default Options: 1 : Product Display Name: Product type |
propertyconfigurationstatus |
Edm.Int32 |
Description: Status of the property configuration. Default Options: 0 : Edit Display Name: Property Configuration |
quantity |
Edm.Decimal |
Description: Type the amount or quantity of the product requested by the customer. Display Name: Quantity |
quotedetailid |
Edm.Guid |
Description: Unique identifier of the product line item in the quote. Display Name: Quote Product |
quotestatecode |
Edm.Int32 |
Description: Status of the quote product. Default Options: 0 : Draft Display Name: Quote Status Read-only property |
requestdeliveryby |
Edm.DateTimeOffset |
Description: Enter the delivery date requested by the customer for the quote product. Display Name: Requested Delivery Date |
sequencenumber |
Edm.Int32 |
Description: Unique identifier of the data that maintains the sequence. Display Name: Sequence Number |
shipto_addressid |
Edm.Guid |
Description: Unique identifier of the shipping address. Display Name: Ship To Address ID |
shipto_city |
Edm.String |
Description: Type the city for the customer's shipping address. Display Name: Ship To City |
shipto_contactname |
Edm.String |
Description: Type the primary contact name at the customer's shipping address. Display Name: Ship To Contact Name |
shipto_country |
Edm.String |
Description: Type the country or region for the customer's shipping address. Display Name: Ship To Country/Region |
shipto_fax |
Edm.String |
Description: Type the fax number for the customer's shipping address. Display Name: Ship To Fax |
shipto_freighttermscode |
Edm.Int32 |
Description: Select the freight terms to make sure shipping orders are processed correctly. Default Options: 1 : FOB Display Name: Freight Terms |
shipto_line1 |
Edm.String |
Description: Type the first line of the customer's shipping address. Display Name: Ship To Street 1 |
shipto_line2 |
Edm.String |
Description: Type the second line of the customer's shipping address. Display Name: Ship To Street 2 |
shipto_line3 |
Edm.String |
Description: Type the third line of the shipping address. Display Name: Ship To Street 3 |
shipto_name |
Edm.String |
Description: Type a name for the customer's shipping address, such as "Headquarters" or "Field office", to identify the address. Display Name: Ship To Name |
shipto_postalcode |
Edm.String |
Description: Type the ZIP Code or postal code for the shipping address. Display Name: Ship To ZIP/Postal Code |
shipto_stateorprovince |
Edm.String |
Description: Type the state or province for the shipping address. Display Name: Ship To State/Province |
shipto_telephone |
Edm.String |
Description: Type the phone number for the customer's shipping address. Display Name: Ship To Phone |
tax |
Edm.Decimal |
Description: Type the tax amount for the quote product. Display Name: Tax |
tax_base |
Edm.Decimal |
Description: Shows the Tax field converted to the system's default base currency for reporting purposes. The calculation uses the exchange rate specified in the Currencies area. Display Name: Tax (Base) Read-only property |
timezoneruleversionnumber |
Edm.Int32 |
Description: For internal use only. Display Name: Time Zone Rule Version Number |
utcconversiontimezonecode |
Edm.Int32 |
Description: Time zone code that was in use when the record was created. Display Name: UTC Conversion Time Zone Code |
versionnumber |
Edm.Int64 |
Description: Version number of the quote detail. Display Name: Version Number Read-only property |
volumediscountamount |
Edm.Decimal |
Description: Shows the discount amount per unit if a specified volume is purchased. Configure volume discounts in the Product Catalog in the Settings area. Display Name: Volume Discount Read-only property |
volumediscountamount_base |
Edm.Decimal |
Description: Shows the discount amount per unit if a specified volume is purchased. Configure volume discounts in the Product Catalog in the Settings area. Display Name: Volume Discount (Base) Read-only property |
willcall |
Edm.Boolean |
Description: Select whether the quote product should be shipped to the specified address or held until the customer calls with further pick up or delivery instructions. Default Options: 1 : Will Call Display Name: Ship To |
Single-valued navigation properties
Single-valued navigation properties represent lookup fields where a single entity can be referenced.
| Name | Type | Partner |
|---|---|---|
createdby |
lk_quotedetailbase_createdby |
|
createdonbehalfby |
lk_quotedetail_createdonbehalfby |
|
modifiedby |
lk_quotedetailbase_modifiedby |
|
modifiedonbehalfby |
lk_quotedetail_modifiedonbehalfby |
|
parentbundleid_quotedetail |
quotedetail_parent_quotedetail |
|
productassociationid_productassociation |
productAssociation_quote_details |
|
productid |
product_quote_details |
|
quoteid |
quote_details |
|
salesrepid |
system_user_quotedetail |
|
transactioncurrencyid |
transactioncurrency_quotedetail |
|
uomid |
unit_of_measurement_quote_details |
Collection-valued navigation properties
Collection-valued navigation properties represent collections of entities which may represent either a one-to-many (1:N) or many-to-many (N:N) relationship between the entities.
| Name | Type | Partner |
|---|---|---|
QuoteDetail_AsyncOperations |
regardingobjectid_quotedetail |
|
QuoteDetail_BulkDeleteFailures |
regardingobjectid_quotedetail |
|
quotedetail_parent_quotedetail |
parentbundleid_quotedetail |
Operations bound to quotedetail
The following operations are bound to the quotedetail entity type.
| Name | Bound to |
|---|---|
Entity |
Operations using the quotedetail entity type.
The following operations use the quotedetail entity type in a parameter or return type.
| Name | How used | Description |
|---|---|---|
entity Parameter |
Retrieve all the property instances (dynamic property instances) for a product added to an opportunity, quote, order, or invoice. |
Voir aussi
Autres ressources
Web API Action Reference
Web API Function Reference
Web API Query Function Reference
Web API EnumType Reference
Web API ComplexType Reference
Web API Metadata EntityType Reference
Microsoft Dynamics CRM 2016 and Microsoft Dynamics CRM Online
Send comments about this topic to Microsoft.
© 2015 Microsoft. All rights reserved.