JDBC Driver for Microsoft Dynamics CRM

Build 22.0.8462

SalesOrderDetail

This is a table representing the SalesOrderDetail entities in Dynamics CRM.

Columns

Name Type ReadOnly Description
Id [KEY] String False

Unique identifier of the sales order detail.

BaseAmount Double True

Price of the order product before discounts are applied and taxes are added.

BaseAmount_Base Double True

Base currency equivalent of the price of the order product before discounts are applied and taxes are added.

CreatedBy_Id String True

Unique identifier of the user who created the order product.

CreatedBy_LogicalName String True

CreatedBy_Name String True

CreatedOn Datetime True

Date and time when the order product was created.

CreatedOnBehalfBy_Id String True

Unique identifier of the delegate user who created the salesorderdetail.

CreatedOnBehalfBy_LogicalName String True

CreatedOnBehalfBy_Name String True

Description String False

Description of the order product.

ExchangeRate Double True

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

ExtendedAmount Double True

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

ExtendedAmount_Base Double True

Base currency equivalent of the subtotal of the order 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.

IsCopied Boolean False

Information that specifies whether the line was copied from a quote.

IsPriceOverridden Boolean False

Information that specifies whether to override product catalog pricing.

IsProductOverridden Boolean False

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

LineItemNumber Integer False

Line item number for the order product.

ManualDiscountAmount Double False

Customized discount amount for the order product.

ManualDiscountAmount_Base Double True

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

ModifiedBy_Id String True

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

ModifiedBy_LogicalName String True

ModifiedBy_Name String True

ModifiedOn Datetime True

Date and time when the order product was last modified.

ModifiedOnBehalfBy_Id String True

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

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 sales order detail.

OwnerId_LogicalName String True

OwnerId_Name String True

OwningBusinessUnit String True

Unique identifier of the business unit that owns the order product.

OwningUser String True

Unique identifier of the user who owns the order product.

PricePerUnit Double False

Price per unit for the order product.

PricePerUnit_Base Double True

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

PricingErrorCode String False

Pricing error for the order product.

ProductDescription String False

Product description for the order product.

ProductId_Id String False

Unique identifier of the product associated with the order product.

ProductId_LogicalName String False

ProductId_Name String False

Quantity Double False

Quantity specified for the order product.

QuantityBackordered Double False

Quantity that has been backordered for the order product.

QuantityCancelled Double False

Quantity that was canceled for the order product.

QuantityShipped Double False

Quantity shipped for the product specified on the order.

RequestDeliveryBy Datetime False

Requested delivery date for the order product.

SalesOrderDetailId String False

Unique identifier of the product specified in the order.

SalesOrderId_Id String False

Unique identifier of the order that is associated with the order product.

SalesOrderId_LogicalName String False

SalesOrderId_Name String False

SalesOrderIsPriceLocked Boolean True

Information that specifies whether the order product pricing is locked.

SalesOrderStateCode String True

Status of the order product.

SalesRepId_Id String False

Unique identifier of the salesperson associated with the order 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 order product.

Tax_Base Double True

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

TimeZoneRuleVersionNumber Integer False

For internal use only.

TransactionCurrencyId_Id String True

Unique identifier of the currency associated with the sales order detail.

TransactionCurrencyId_LogicalName String True

TransactionCurrencyId_Name String True

UoMId_Id String False

Unique identifier for the unit that is associated with the order 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 order product.

VolumeDiscountAmount_Base Double True

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

WillCall Boolean False

Specifies whether the customer will call for the ordered products or the products are to be shipped.

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