QuoteDetail
This is a table representing the QuoteDetail entities in Dynamics CRM.
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | String | False |
Unique identifier of the quote detail. |
| BaseAmount | Double | True |
Subtotal of the quote product before discounts are applied and taxes are added. |
| BaseAmount_Base | Double | True |
Base currency equivalent of the subtotal of the quote product before discounts are applied and taxes are added. |
| CreatedBy_Id | String | True |
Unique identifier of the user who created the quote product. |
| CreatedBy_LogicalName | String | True | |
| CreatedBy_Name | String | True | |
| CreatedOn | Datetime | True |
Date and time when the quote product was created. |
| CreatedOnBehalfBy_Id | String | True |
Unique identifier of the delegate user who created the quotedetail. |
| CreatedOnBehalfBy_LogicalName | String | True | |
| CreatedOnBehalfBy_Name | String | True | |
| Description | String | False |
Description of the quote product. |
| ExchangeRate | Double | True |
Exchange rate for the currency associated with the quote detail with respect to the base currency. |
| ExtendedAmount | Double | True |
Subtotal of the quote product after discounts are applied and taxes are added. |
| ExtendedAmount_Base | Double | True |
Base currency equivalent of the subtotal of the quote product after discounts are applied and taxes are added. |
| ImportSequenceNumber | Integer | False |
Unique identifier of the data import or data migration that created this record. |
| IsPriceOverridden | Boolean | False |
Information about whether to override product catalog pricing. |
| IsProductOverridden | Boolean | False |
Information about whether the product is a write-in product or an existing product. |
| LineItemNumber | Integer | False |
Line item number for the quote product. |
| ManualDiscountAmount | Double | False |
Customized discount amount for the quote product. |
| ManualDiscountAmount_Base | Double | True |
Base currency equivalent of the customized discount amount for the quote product. |
| ModifiedBy_Id | String | True |
Unique identifier of the user who last modified the quote product. |
| ModifiedBy_LogicalName | String | True | |
| ModifiedBy_Name | String | True | |
| ModifiedOn | Datetime | True |
Date and time when the quote product was last modified. |
| ModifiedOnBehalfBy_Id | String | True |
Unique identifier of the delegate user who last modified the quotedetail. |
| ModifiedOnBehalfBy_LogicalName | String | True | |
| ModifiedOnBehalfBy_Name | String | True | |
| OverriddenCreatedOn | Datetime | False |
Date and time that the record was migrated. |
| OwnerId_Id | String | True |
Unique identifier of the user or team who owns the quote detail. |
| OwnerId_LogicalName | String | True | |
| OwnerId_Name | String | True | |
| OwningBusinessUnit | String | True |
Unique identifier of the business unit that owns the quote detail. |
| OwningUser | String | True |
Unique identifier of the user who owns the quote detail. |
| PricePerUnit | Double | False |
Price per unit for the quote product. |
| PricePerUnit_Base | Double | True |
Base currency equivalent of the price per unit for the quote product. |
| PricingErrorCode | String | False |
Pricing error for the quote product. |
| ProductDescription | String | False |
Product description for the quote product. |
| ProductId_Id | String | False |
Unique identifier of the product associated with the quote product. |
| ProductId_LogicalName | String | False | |
| ProductId_Name | String | False | |
| Quantity | Double | False |
Product quantity specified for the quote product. |
| QuoteDetailId | String | False |
Unique identifier of the product line item in the quote. |
| QuoteId_Id | String | False |
Unique identifier of the quote for the quote product. |
| QuoteId_LogicalName | String | False | |
| QuoteId_Name | String | False | |
| QuoteStateCode | String | True |
Status of the quote product. |
| RequestDeliveryBy | Datetime | False |
Requested delivery date for the quote product. |
| SalesRepId_Id | String | False |
Unique identifier of the salesperson associated with the quote product. |
| SalesRepId_LogicalName | String | False | |
| SalesRepId_Name | String | False | |
| ShipTo_AddressId | String | False |
Unique identifier of the shipping address. |
| ShipTo_City | String | False |
City name in the shipping address. |
| ShipTo_ContactName | String | False |
Contact name for the shipping address. |
| ShipTo_Country | String | False |
Country/region name in the shipping address. |
| ShipTo_Fax | String | False |
Fax number for the shipping address. |
| ShipTo_FreightTermsCode | String | False |
Freight terms for the shipping address. |
| ShipTo_Line1 | String | False |
First line for entering shipping address information. |
| ShipTo_Line2 | String | False |
Second line for entering shipping address information. |
| ShipTo_Line3 | String | False |
Third line for entering shipping address information. |
| ShipTo_Name | String | False |
Name to enter for the shipping address. |
| ShipTo_PostalCode | String | False |
ZIP Code or postal code in the shipping address. |
| ShipTo_StateOrProvince | String | False |
State or province in the shipping address. |
| ShipTo_Telephone | String | False |
Telephone number associated with the shipping address. |
| Tax | Double | False |
Tax amount for the quote product. |
| Tax_Base | Double | True |
Base currency equivalent of the tax amount for the quote product. |
| TimeZoneRuleVersionNumber | Integer | False |
For internal use only. |
| TransactionCurrencyId_Id | String | True |
Unique identifier of the currency associated with the quote detail. |
| TransactionCurrencyId_LogicalName | String | True | |
| TransactionCurrencyId_Name | String | True | |
| UoMId_Id | String | False |
Unique identifier of the unit that is associated with the quote product. |
| UoMId_LogicalName | String | False | |
| UoMId_Name | String | False | |
| UTCConversionTimeZoneCode | Integer | False |
Time zone code that was in use when the record was created. |
| VolumeDiscountAmount | Double | True |
Volume discount amount for the quote product. |
| VolumeDiscountAmount_Base | Double | True |
Base currency equivalent of the volume discount amount for the quote product. |
| WillCall | Boolean | False |
Information about whether the customer will call for the quoted products or the products are to be shipped. |