JDBC Driver for Microsoft Dynamics CRM

Build 24.0.9060

InvoiceDetail

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

Columns

Name Type ReadOnly Description
Id [KEY] String False

Unique identifier of the invoice product line item.

ActualDeliveryOn Datetime False

Date on which the product on the invoice is delivered.

BaseAmount Double True

Subtotal for the invoice product before discounts are applied and taxes are added.

BaseAmount_Base Double True

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

CreatedBy_Id String True

Unique identifier of the user who created the invoice product line item.

CreatedBy_LogicalName String True

CreatedBy_Name String True

CreatedOn Datetime True

Date and time when the invoice product line item was created.

CreatedOnBehalfBy_Id String True

Unique identifier of the delegate user who created the invoice detail.

CreatedOnBehalfBy_LogicalName String True

CreatedOnBehalfBy_Name String True

Description String False

Description of the invoice product line item.

ExchangeRate Double True

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

ExtendedAmount Double True

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

ExtendedAmount_Base Double True

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

InvoiceDetailId String False

Unique identifier of the invoice product line item.

InvoiceId_Id String False

Unique identifier of the invoice associated with the invoice product line item.

InvoiceId_LogicalName String False

InvoiceId_Name String False

InvoiceIsPriceLocked Boolean True

Information about whether invoice product pricing is locked.

InvoiceStateCode String True

Status of the invoice product.

IsCopied Boolean False

Information about whether the invoice line item is copied.

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 of the invoice product.

ManualDiscountAmount Double False

Customized discount amount for the invoice product line item.

ManualDiscountAmount_Base Double True

Base currency equivalent of the customized discount amount for the invoice product line item.

ModifiedBy_Id String True

Unique identifier of the user who last modified the invoice product line item.

ModifiedBy_LogicalName String True

ModifiedBy_Name String True

ModifiedOn Datetime True

Date and time when the invoice product line item was last modified.

ModifiedOnBehalfBy_Id String True

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

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 invoice detail.

OwnerId_LogicalName String True

OwnerId_Name String True

OwningBusinessUnit String True

Unique identifier of the business unit that owns the invoice product line item.

OwningUser String True

Unique identifier of the user who owns the invoice product line item.

PricePerUnit Double False

Price per unit for the invoice product line item.

PricePerUnit_Base Double True

Base currency equivalent of the price per unit for the invoice product line item.

PricingErrorCode String False

Pricing error for the invoice product line item.

ProductDescription String False

Product description for the invoice product line item.

ProductId_Id String False

Product identifier for the invoice product line item.

ProductId_LogicalName String False

ProductId_Name String False

Quantity Double False

Product quantity specified for the invoice product line item.

QuantityBackordered Double False

Product quantity that has been backordered for the invoice product line item.

QuantityCancelled Double False

Product quantity that was canceled for the invoice product line item.

QuantityShipped Double False

Product quantity shipped for the product line item specified on the invoice.

SalesRepId_Id String False

Unique identifier of the sales person associated with the invoice product line item.

SalesRepId_LogicalName String False

SalesRepId_Name String False

ShippingTrackingNumber String False

Tracking number for shipping the invoiced product line item.

ShipTo_City String False

City name in 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 invoice product line item.

Tax_Base Double True

Base currency equivalent of the tax amount for the invoice product line item.

TimeZoneRuleVersionNumber Integer False

For internal use only.

TransactionCurrencyId_Id String True

Unique identifier of the currency associated with the invoice detail.

TransactionCurrencyId_LogicalName String True

TransactionCurrencyId_Name String True

UoMId_Id String False

Unique identifier for unit that is associated with the invoice product line item.

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 invoice product line item.

VolumeDiscountAmount_Base Double True

Base currency equivalent of the volume discount amount for the invoice product line item.

WillCall Boolean False

Information about whether the customer will call for the invoiced products or the products are to be shipped.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060