invoicedetail EntityType
Description: Line item in an invoice containing detailed billing information for a product.
Entity Set path: [organization URI]/api/data/v8.0/invoicedetails
Base Type: crmbaseentity EntityType
Display Name: Invoice Product
Primary Key: invoicedetailid
Primary Name Attribute: productidname
Properties
Single-valued navigation properties
Collection-valued navigation properties
Operations bound to invoicedetail
Operations using the invoicedetail entity type.
Properties
Properties represent fields of data stored in the entity. Some properties are not writable.
| Name | Type | Details |
|---|---|---|
_createdby_value |
Edm.Guid |
Description: Shows who created the record. Computed property Read-only property |
_createdonbehalfby_value |
Edm.Guid |
Description: Shows who created the record on behalf of another user. Computed property Read-only property |
_invoiceid_value |
Edm.Guid |
Description: Unique identifier of the invoice associated with the invoice product line item. Computed property Read-only property |
_modifiedby_value |
Edm.Guid |
Description: Shows who last updated the record. Computed property Read-only property |
_modifiedonbehalfby_value |
Edm.Guid |
Description: Shows who last updated the record on behalf of another user. Computed property Read-only property |
_ownerid_value |
Edm.Guid |
Description: Unique identifier of the user or team who owns the invoice detail. Read-only property |
_productid_value |
Edm.Guid |
Description: Choose the product to include on the invoice. Computed property Read-only property |
_salesrepid_value |
Edm.Guid |
Description: Choose the user responsible for the sale of the invoice product. Computed property Read-only property |
_transactioncurrencyid_value |
Edm.Guid |
Description: Choose the local currency for the record to make sure budgets are reported in the correct currency. Computed property Read-only property |
_uomid_value |
Edm.Guid |
Description: Choose the unit of measurement for the base unit quantity for this purchase, such as each or dozen. Computed property Read-only property |
actualdeliveryon |
Edm.DateTimeOffset |
Description: Enter the date when the invoiced product was delivered to the customer. Display Name: Delivered On |
baseamount |
Edm.Decimal |
Description: Shows the total price of the invoice product, based on the price per unit, volume discount, and quantity. Display Name: Amount |
baseamount_base |
Edm.Decimal |
Description: Shows the Amount field converted to the system's default base currency. The calculation uses the exchange rate specified in the Currencies area. Display Name: Amount (Base) Read-only property |
createdon |
Edm.DateTimeOffset |
Description: Shows the date and time when the record was created. The date and time are displayed in the time zone selected in Microsoft Dynamics CRM options. Display Name: Created On Read-only property |
description |
Edm.String |
Description: Type additional information to describe the product line item of the invoice. Display Name: Description |
exchangerate |
Edm.Decimal |
Description: Shows the conversion rate of the record's currency. The exchange rate is used to convert all money fields in the record from the local currency to the system's default currency. Display Name: Exchange Rate Read-only property |
extendedamount |
Edm.Decimal |
Description: Shows the total amount due for the invoice product, based on the sum of the unit price, quantity, discounts, and tax. Display Name: Extended Amount |
extendedamount_base |
Edm.Decimal |
Description: Shows the Extended Amount field converted to the system's default base currency. The calculation uses the exchange rate specified in the Currencies area. Display Name: Extended Amount (Base) Read-only property |
importsequencenumber |
Edm.Int32 |
Description: Unique identifier of the data import or data migration that created this record. Display Name: Import Sequence Number |
invoicedetailid |
Edm.Guid |
Description: Unique identifier of the invoice product line item. Display Name: Invoice Product |
invoiceispricelocked |
Edm.Boolean |
Description: Information about whether invoice product pricing is locked. Default Options: 1 : Yes Display Name: Invoice Is Price Locked Read-only property |
invoicestatecode |
Edm.Int32 |
Description: Status of the invoice product. Default Options: 0 : Active Display Name: Invoice Status Read-only property |
iscopied |
Edm.Boolean |
Description: Select whether the invoice product is copied from another item or data source. Default Options: 1 : Yes Display Name: Copied |
ispriceoverridden |
Edm.Boolean |
Description: Select whether the price per unit is fixed at the value in the specified price list or can be overridden by users who have edit rights to the invoice product. Default Options: 1 : Override Price Display Name: Pricing |
isproductoverridden |
Edm.Boolean |
Description: Select whether the product exists in the Microsoft Dynamics CRM product catalog or is a write-in product specific to the parent invoice. Default Options: 1 : Write In Display Name: Select Product |
lineitemnumber |
Edm.Int32 |
Description: Type the line item number for the invoice product to easily identify the product in the invoice and make sure it's listed in the correct order. Display Name: Line Item Number |
manualdiscountamount |
Edm.Decimal |
Description: Type the manual discount amount for the invoice product to deduct any negotiated or other savings from the product total. Display Name: Manual Discount |
manualdiscountamount_base |
Edm.Decimal |
Description: Shows the Manual Discount field converted to the system's default base currency for reporting purposes. The calculation uses the exchange rate specified in the Currencies area. Display Name: Manual Discount (Base) Read-only property |
modifiedon |
Edm.DateTimeOffset |
Description: Shows the date and time when the record was last updated. The date and time are displayed in the time zone selected in Microsoft Dynamics CRM options. Display Name: Modified On Read-only property |
overriddencreatedon |
Edm.DateTimeOffset |
Description: Date and time that the record was migrated. Display Name: Record Created On |
owningbusinessunit |
Edm.Guid |
Description: Unique identifier of the business unit that owns the invoice product line item. Display Name: Owning Business Unit Read-only property |
owninguser |
Edm.Guid |
Description: Unique identifier of the user who owns the invoice product line item. Display Name: Owning User Read-only property |
parentbundleid |
Edm.Guid |
Description: Choose the parent bundle associated with this product Display Name: Parent Bundle |
priceperunit |
Edm.Decimal |
Description: Type the price per unit of the invoice product. The default is the value in the price list specified on the parent invoice for existing products. Display Name: Price Per Unit |
priceperunit_base |
Edm.Decimal |
Description: Shows the Price Per Unit field converted to the system's default base currency for reporting purposes. The calculation uses the exchange rate specified in the Currencies area. Display Name: Price Per Unit (Base) Read-only property |
pricingerrorcode |
Edm.Int32 |
Description: Pricing error for the invoice product line item. Default Options: 0 : None Display Name: Pricing Error |
productassociationid |
Edm.Guid |
Description: Unique identifier of the product line item association with bundle in the invoice Display Name: Bundle Item Association |
productdescription |
Edm.String |
Description: Type a name or description to identify the type of write-in product included in the invoice. Display Name: Write-In Product |
producttypecode |
Edm.Int32 |
Description: Product Type Default Options: 1 : Product Display Name: Product type |
propertyconfigurationstatus |
Edm.Int32 |
Description: Status of the property configuration. Default Options: 0 : Edit Display Name: Property Configuration |
quantity |
Edm.Decimal |
Description: Type the amount or quantity of the product included in the invoice's total amount due. Display Name: Quantity |
quantitybackordered |
Edm.Decimal |
Description: Type the amount or quantity of the product that is back ordered for the invoice. Display Name: Quantity Back Ordered |
quantitycancelled |
Edm.Decimal |
Description: Type the amount or quantity of the product that was canceled for the invoice line item. Display Name: Quantity Canceled |
quantityshipped |
Edm.Decimal |
Description: Type the amount or quantity of the product that was shipped. Display Name: Quantity Shipped |
sequencenumber |
Edm.Int32 |
Description: Shows the ID of the data that maintains the sequence. Display Name: Sequence Number |
shippingtrackingnumber |
Edm.String |
Description: Type a tracking number for shipment of the invoiced product. Display Name: Shipment Tracking Number |
shipto_city |
Edm.String |
Description: Type the city for the customer's shipping address. Display Name: Ship To City |
shipto_country |
Edm.String |
Description: Type the country or region for the customer's shipping address. Display Name: Ship To Country/Region |
shipto_fax |
Edm.String |
Description: Type the fax number for the customer's shipping address. Display Name: Ship To Fax |
shipto_freighttermscode |
Edm.Int32 |
Description: Select the freight terms to make sure shipping orders are processed correctly. Default Options: 1 : FOB Display Name: Freight Terms |
shipto_line1 |
Edm.String |
Description: Type the first line of the customer's shipping address. Display Name: Ship To Street 1 |
shipto_line2 |
Edm.String |
Description: Type the second line of the customer's shipping address. Display Name: Ship To Street 2 |
shipto_line3 |
Edm.String |
Description: Type the third line of the shipping address. Display Name: Ship To Street 3 |
shipto_name |
Edm.String |
Description: Type a name for the customer's shipping address, such as "Headquarters" or "Field office", to identify the address. Display Name: Ship To Name |
shipto_postalcode |
Edm.String |
Description: Type the ZIP Code or postal code for the shipping address. Display Name: Ship To ZIP/Postal Code |
shipto_stateorprovince |
Edm.String |
Description: Type the state or province for the shipping address. Display Name: Ship To State/Province |
shipto_telephone |
Edm.String |
Description: Type the phone number for the customer's shipping address. Display Name: Ship To Phone |
tax |
Edm.Decimal |
Description: Type the tax amount for the invoice product. Display Name: Tax |
tax_base |
Edm.Decimal |
Description: Shows the Tax field converted to the system's default base currency for reporting purposes. The calculation uses the exchange rate specified in the Currencies area. Display Name: Tax (Base) Read-only property |
timezoneruleversionnumber |
Edm.Int32 |
Description: For internal use only. Display Name: Time Zone Rule Version Number |
utcconversiontimezonecode |
Edm.Int32 |
Description: Time zone code that was in use when the record was created. Display Name: UTC Conversion Time Zone Code |
versionnumber |
Edm.Int64 |
Description: Version number of the invoice product line item. Display Name: Version Number Read-only property |
volumediscountamount |
Edm.Decimal |
Description: Shows the discount amount per unit if a specified volume is purchased. Configure volume discounts in the Product Catalog in the Settings area. Display Name: Volume Discount Read-only property |
volumediscountamount_base |
Edm.Decimal |
Description: Shows the Volume Discount field converted to the system's default base currency for reporting purposes. The calculation uses the exchange rate specified in the Currencies area. Display Name: Volume Discount (Base) Read-only property |
willcall |
Edm.Boolean |
Description: Select whether the invoice product should be shipped to the specified address or held until the customer calls with further pick up or delivery instructions. Default Options: 1 : Will Call Display Name: Ship To |
Single-valued navigation properties
Single-valued navigation properties represent lookup fields where a single entity can be referenced.
| Name | Type | Partner |
|---|---|---|
createdby |
lk_invoicedetailbase_createdby |
|
createdonbehalfby |
lk_invoicedetail_createdonbehalfby |
|
invoiceid |
invoice_details |
|
modifiedby |
lk_invoicedetailbase_modifiedby |
|
modifiedonbehalfby |
lk_invoicedetail_modifiedonbehalfby |
|
parentbundleid_invoicedetail |
invoicedetail_parent_invoicedetail |
|
productassociationid_productassociation |
productAssociation_invoice_details |
|
productid |
product_invoice_details |
|
salesrepid |
system_user_invoicedetail |
|
transactioncurrencyid |
transactioncurrency_invoicedetail |
|
uomid |
unit_of_measurement_invoice_details |
Collection-valued navigation properties
Collection-valued navigation properties represent collections of entities which may represent either a one-to-many (1:N) or many-to-many (N:N) relationship between the entities.
| Name | Type | Partner |
|---|---|---|
InvoiceDetail_AsyncOperations |
regardingobjectid_invoicedetail |
|
InvoiceDetail_BulkDeleteFailures |
regardingobjectid_invoicedetail |
|
invoicedetail_parent_invoicedetail |
parentbundleid_invoicedetail |
Operations bound to invoicedetail
The following operations are bound to the invoicedetail entity type.
| Name | Bound to |
|---|---|
Entity |
Operations using the invoicedetail entity type.
The following operations use the invoicedetail entity type in a parameter or return type.
| Name | How used | Description |
|---|---|---|
entity Parameter |
Retrieve all the property instances (dynamic property instances) for a product added to an opportunity, quote, order, or invoice. |
請參閱
其他資源
Web API Action Reference
Web API Function Reference
Web API Query Function Reference
Web API EnumType Reference
Web API ComplexType Reference
Web API Metadata EntityType Reference
Microsoft Dynamics CRM 2016 and Microsoft Dynamics CRM Online
Send comments about this topic to Microsoft.
© 2015 Microsoft. All rights reserved.