Export (0) Print
Expand All

InvoiceDetail (Invoice Product) Entity Metadata

[Applies to: Microsoft Dynamics CRM 2011]

The following information is for the invoice detail (invoice product) entity in a default, uncustomized installation of Microsoft Dynamics CRM. The schema name and early bound class for this entity is InvoiceDetail.

To view the entity metadata for your organization, install the Metadata Browser solution described in Browse the Metadata for Your Organization.

Entity Metadata

The following table shows the metadata for the invoice detail (invoice product) entity.

 

Entity metadata property Value

OTC

1091

EntityLogicalName

invoicedetail

DisplayName

Invoice Product

OwnershipType

None

IsCustomizable

True

Description

Line item in an invoice containing detailed billing information for a product.

IsAvailableOffline

True

IsAuditEnabled

False

AutoRouteToOwnerQueue

False

CanBeInManyToMany

True

CanBePrimaryEntityInRelationship

True

CanBeRelatedEntityInRelationship

True

CanCreateAttributes

True

CanCreateCharts

True

CanCreateForms

True

CanCreateViews

True

CanModifyAdditionalSettings

True

CanTriggerWorkflow

True

IsActivity

False

IsActivityParty

False

IsChildEntity

True

IsConnectionsEnabled

canmodifyconnectionsettings

IsCustomEntity

False

IsDocumentManagementEnabled

False

IsDuplicateDetectionEnabled

False

IsEnabledForCharts

True

IsImportable

True

IsIntersect

False

IsMailMergeEnabled

False

IsManaged

True

IsMappable

True

IsReadingPaneEnabled

True

IsRenameable

True

IsValidForAdvancedFind

True

IsValidForQueue

False

IsVisibleInMobile

False

PrimaryIdAttribute

invoicedetailid

PrimaryNameAttribute

productidname

ReportViewName

FilteredInvoiceDetail

RecurrenceBaseEntityLogicalName

DisplayCollectionName

Invoice Products

Attribute Metadata

The following table shows the attribute metadata for the invoice detail (invoice product) entity.

 

EntityLogicalName IsCustomizableEntity IsIntersect LogicalName Description Type SchemaName IsCustomAttribute IsCustomizable RequiredLevel IsValidForCreate IsValidForRead IsValidForUpdate CanBeSecuredForCreate CanBeSecuredForRead CanBeSecuredForUpdate IsAuditEnabled IsManaged IsPrimaryId IsPrimaryName IsRenameable IsSecured IsValidForAdvancedFind DisplayName

invoicedetail

yes

no

actualdeliveryon

Date on which the product on the invoice is delivered.

DateTime

ActualDeliveryOn

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Delivered On

invoicedetail

yes

no

baseamount

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

Money

BaseAmount

False

True

None

False

True

False

False

False

False

True

True

False

False

True

False

True

Amount

invoicedetail

yes

no

baseamount_base

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

Money

BaseAmount_Base

False

True

None

False

True

False

False

False

False

True

True

False

False

True

False

True

Amount (Base)

invoicedetail

yes

no

createdby

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

Lookup

CreatedBy

False

True

None

False

True

False

False

False

False

False

True

False

False

True

False

True

Created By

invoicedetail

yes

no

createdon

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

DateTime

CreatedOn

False

True

None

False

True

False

False

False

False

False

True

False

False

True

False

True

Created On

invoicedetail

yes

no

createdonbehalfby

Unique identifier of the delegate user who created the invoicedetail.

Lookup

CreatedOnBehalfBy

False

True

None

False

True

False

False

False

False

False

True

False

False

True

False

True

Created By (Delegate)

invoicedetail

yes

no

description

Description of the invoice product line item.

Memo

Description

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Description

invoicedetail

yes

no

exchangerate

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

Decimal

ExchangeRate

False

True

None

False

True

False

False

False

False

True

True

False

False

True

False

True

Exchange Rate

invoicedetail

yes

no

extendedamount

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

Money

ExtendedAmount

False

True

None

False

True

False

False

False

False

True

True

False

False

True

False

True

Extended Amount

invoicedetail

yes

no

extendedamount_base

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

Money

ExtendedAmount_Base

False

True

None

False

True

False

False

False

False

True

True

False

False

True

False

True

Extended Amount (Base)

invoicedetail

yes

no

importsequencenumber

Unique identifier of the data import or data migration that created this record.

Integer

ImportSequenceNumber

False

True

None

True

True

False

False

False

False

True

True

False

False

True

False

True

Import Sequence Number

invoicedetail

yes

no

invoicedetailid

Unique identifier of the invoice product line item.

Uniqueidentifier

InvoiceDetailId

False

True

SystemRequired

True

True

False

False

False

False

False

True

True

False

True

False

False

Invoice Product

invoicedetail

yes

no

invoiceid

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

Lookup

InvoiceId

False

True

SystemRequired

True

True

True

False

False

False

True

True

False

False

False

False

False

Invoice ID

invoicedetail

yes

no

invoiceispricelocked

Information about whether invoice product pricing is locked.

Boolean

InvoiceIsPriceLocked

False

True

ApplicationRequired

False

True

False

False

False

False

True

True

False

False

False

False

False

Invoice Is Price Locked

invoicedetail

yes

no

invoicestatecode

Status of the invoice product.

Picklist

InvoiceStateCode

False

True

SystemRequired

False

True

False

False

False

False

True

True

False

False

False

False

False

Invoice Status

invoicedetail

yes

no

iscopied

Information about whether the invoice line item is copied.

Boolean

IsCopied

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Copied

invoicedetail

yes

no

ispriceoverridden

Information about whether to override product catalog pricing.

Boolean

IsPriceOverridden

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Pricing

invoicedetail

yes

no

isproductoverridden

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

Boolean

IsProductOverridden

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Select Product

invoicedetail

yes

no

lineitemnumber

Line item number of the invoice product.

Integer

LineItemNumber

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Line Item Number

invoicedetail

yes

no

manualdiscountamount

Customized discount amount for the invoice product line item.

Money

ManualDiscountAmount

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Manual Discount

invoicedetail

yes

no

manualdiscountamount_base

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

Money

ManualDiscountAmount_Base

False

True

None

False

True

False

False

False

False

True

True

False

False

True

False

True

Manual Discount (Base)

invoicedetail

yes

no

modifiedby

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

Lookup

ModifiedBy

False

True

None

False

True

False

False

False

False

False

True

False

False

True

False

True

Modified By

invoicedetail

yes

no

modifiedon

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

DateTime

ModifiedOn

False

True

None

False

True

False

False

False

False

False

True

False

False

True

False

True

Modified On

invoicedetail

yes

no

modifiedonbehalfby

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

Lookup

ModifiedOnBehalfBy

False

True

None

False

True

False

False

False

False

False

True

False

False

True

False

True

Modified By (Delegate)

invoicedetail

yes

no

overriddencreatedon

Date and time that the record was migrated.

DateTime

OverriddenCreatedOn

False

True

None

True

True

False

False

False

False

True

True

False

False

True

False

True

Record Created On

invoicedetail

yes

no

ownerid

Unique identifier of the user or team who owns the invoice detail.

Owner

OwnerId

False

True

ApplicationRequired

False

True

False

False

False

False

True

True

False

False

False

False

False

Owner

invoicedetail

yes

no

owningbusinessunit

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

Uniqueidentifier

OwningBusinessUnit

False

False

ApplicationRequired

False

True

False

False

False

False

False

True

False

False

False

False

False

Owning Business Unit

invoicedetail

yes

no

owninguser

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

Uniqueidentifier

OwningUser

False

False

ApplicationRequired

False

True

False

False

False

False

False

True

False

False

False

False

False

Owning User

invoicedetail

yes

no

priceperunit

Price per unit for the invoice product line item.

Money

PricePerUnit

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Price Per Unit

invoicedetail

yes

no

priceperunit_base

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

Money

PricePerUnit_Base

False

True

None

False

True

False

False

False

False

True

True

False

False

True

False

True

Price Per Unit (Base)

invoicedetail

yes

no

pricingerrorcode

Pricing error for the invoice product line item.

Picklist

PricingErrorCode

False

True

None

True

True

True

False

False

False

True

True

False

False

False

False

False

Pricing Error

invoicedetail

yes

no

productdescription

Product description for the invoice product line item.

String

ProductDescription

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Write-In Product

invoicedetail

yes

no

productid

Product identifier for the invoice product line item.

Lookup

ProductId

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Existing Product

invoicedetail

yes

no

quantity

Product quantity specified for the invoice product line item.

Decimal

Quantity

False

True

ApplicationRequired

True

True

True

False

False

False

True

True

False

False

True

False

True

Quantity

invoicedetail

yes

no

quantitybackordered

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

Decimal

QuantityBackordered

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Quantity Back Ordered

invoicedetail

yes

no

quantitycancelled

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

Decimal

QuantityCancelled

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Quantity Canceled

invoicedetail

yes

no

quantityshipped

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

Decimal

QuantityShipped

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Quantity Shipped

invoicedetail

yes

no

salesrepid

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

Lookup

SalesRepId

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Salesperson

invoicedetail

yes

no

shippingtrackingnumber

Tracking number for shipping the invoiced product line item.

String

ShippingTrackingNumber

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Shipment Tracking Number

invoicedetail

yes

no

shipto_city

City name in the shipping address.

String

ShipTo_City

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Ship To City

invoicedetail

yes

no

shipto_country

Country/region name in the shipping address.

String

ShipTo_Country

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Ship To Country/Region

invoicedetail

yes

no

shipto_fax

Fax number for the shipping address.

String

ShipTo_Fax

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Ship To Fax

invoicedetail

yes

no

shipto_freighttermscode

Freight terms for the shipping address.

Picklist

ShipTo_FreightTermsCode

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Freight Terms

invoicedetail

yes

no

shipto_line1

First line for entering shipping address information.

String

ShipTo_Line1

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Ship To Street 1

invoicedetail

yes

no

shipto_line2

Second line for entering shipping address information.

String

ShipTo_Line2

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Ship To Street 2

invoicedetail

yes

no

shipto_line3

Third line for entering shipping address information.

String

ShipTo_Line3

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Ship To Street 3

invoicedetail

yes

no

shipto_name

Name to enter for the shipping address.

String

ShipTo_Name

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Ship To Name

invoicedetail

yes

no

shipto_postalcode

ZIP Code or postal code in the shipping address.

String

ShipTo_PostalCode

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Ship To ZIP/Postal Code

invoicedetail

yes

no

shipto_stateorprovince

State or province in the shipping address.

String

ShipTo_StateOrProvince

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Ship To State/Province

invoicedetail

yes

no

shipto_telephone

Telephone number associated with the shipping address.

String

ShipTo_Telephone

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Ship To Phone

invoicedetail

yes

no

tax

Tax amount for the invoice product line item.

Money

Tax

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Tax

invoicedetail

yes

no

tax_base

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

Money

Tax_Base

False

True

None

False

True

False

False

False

False

True

True

False

False

True

False

True

Tax (Base)

invoicedetail

yes

no

timezoneruleversionnumber

For internal use only.

Integer

TimeZoneRuleVersionNumber

False

True

None

True

True

True

False

False

False

False

True

False

False

False

False

False

Time Zone Rule Version Number

invoicedetail

yes

no

transactioncurrencyid

Unique identifier of the currency associated with the invoice detail.

Lookup

TransactionCurrencyId

False

True

None

False

True

False

False

False

False

True

True

False

False

True

False

True

Currency

invoicedetail

yes

no

uomid

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

Lookup

UoMId

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Unit

invoicedetail

yes

no

utcconversiontimezonecode

Time zone code that was in use when the record was created.

Integer

UTCConversionTimeZoneCode

False

True

None

True

True

True

False

False

False

False

True

False

False

False

False

False

UTC Conversion Time Zone Code

invoicedetail

yes

no

versionnumber

Version number of the invoice product line item.

BigInt

VersionNumber

False

False

None

False

True

False

False

False

False

False

True

False

False

False

False

False

Version Number

invoicedetail

yes

no

volumediscountamount

Volume discount amount for the invoice product line item.

Money

VolumeDiscountAmount

False

True

None

False

True

False

False

False

False

True

True

False

False

True

False

True

Volume Discount

invoicedetail

yes

no

volumediscountamount_base

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

Money

VolumeDiscountAmount_Base

False

True

None

False

True

False

False

False

False

True

True

False

False

True

False

True

Volume Discount (Base)

invoicedetail

yes

no

willcall

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

Boolean

WillCall

False

True

None

True

True

True

False

False

False

True

True

False

False

True

False

True

Ship To

One-to-Many Relationships

The following table shows the entities that are the referencing entity in a one-to-many relationship with the invoice detail (invoice product) entity.

 

Relationship schema name Referencing Entity

InvoiceDetail_AsyncOperations

asyncoperation

InvoiceDetail_BulkDeleteFailures

bulkdeletefailure

invoicedetail_principalobjectattributeaccess

principalobjectattributeaccess

InvoiceDetail_ProcessSessions

processsession

userentityinstancedata_invoicedetail

userentityinstancedata

Many-to-Many Relationships

This entity has no default many-to-many relationships.

Many-to-One Relationships

The following table shows the entities that are the referenced entity in a many-to-one relationship with the invoice detail (invoice product) entity.

 

Relationship schema name Referenced Entity

invoice_details

invoice

product_invoice_details

product

lk_invoicedetail_modifiedonbehalfby

systemuser

lk_invoicedetail_createdonbehalfby

systemuser

lk_invoicedetailbase_createdby

systemuser

lk_invoicedetailbase_modifiedby

systemuser

system_user_invoicedetail

systemuser

transactioncurrency_invoicedetail

transactioncurrency

unit_of_measurement_invoice_details

uom

See Also

Microsoft Dynamics CRM 2011
Send comments about this topic to Microsoft.
© 2013 Microsoft Corporation. All rights reserved.

Community Additions

Show:
© 2014 Microsoft