JDBC Driver for Microsoft Dynamics CRM

Build 22.0.8462

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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462