Invoice Product (InvoiceDetail) entity reference
Line item in an invoice containing detailed billing information for a product.
Added by: Sales Solution
Messages
| Message | SDK class or method |
|---|---|
| CalculatePrice | CalculatePriceRequest |
| Create | CreateRequest or Create |
| Delete | DeleteRequest or Delete |
| Retrieve | RetrieveRequest or Retrieve |
| RetrieveMultiple | RetrieveMultipleRequest or RetrieveMultiple |
| Update | UpdateRequest or Update |
Properties
| Property | Value |
|---|---|
| CollectionSchemaName | InvoiceDetails |
| DisplayCollectionName | Invoice Products |
| DisplayName | Invoice Product |
| EntitySetName | invoicedetails |
| IsBPFEntity | False |
| LogicalCollectionName | invoicedetails |
| LogicalName | invoicedetail |
| OwnershipType | UserOwned |
| PrimaryIdAttribute | invoicedetailid |
| PrimaryNameAttribute | invoicedetailname |
| SchemaName | InvoiceDetail |
Writable attributes
These attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.
- ActualDeliveryOn
- BaseAmount
- Description
- ExtendedAmount
- ImportSequenceNumber
- InvoiceDetailId
- InvoiceDetailName
- InvoiceId
- IsCopied
- IsPriceOverridden
- IsProductOverridden
- LineItemNumber
- ManualDiscountAmount
- OverriddenCreatedOn
- ParentBundleId
- ParentBundleIdRef
- PricePerUnit
- PricingErrorCode
- ProductAssociationId
- ProductDescription
- ProductId
- ProductName
- ProductTypeCode
- PropertyConfigurationStatus
- Quantity
- QuantityBackordered
- QuantityCancelled
- QuantityShipped
- SalesOrderDetailId
- SalesRepId
- SequenceNumber
- ShippingTrackingNumber
- ShipTo_City
- ShipTo_Country
- ShipTo_Fax
- ShipTo_FreightTermsCode
- ShipTo_Line1
- ShipTo_Line2
- ShipTo_Line3
- ShipTo_Name
- ShipTo_PostalCode
- ShipTo_StateOrProvince
- ShipTo_Telephone
- Tax
- TimeZoneRuleVersionNumber
- TransactionCurrencyId
- UoMId
- UTCConversionTimeZoneCode
- WillCall
ActualDeliveryOn
| Property | Value |
|---|---|
| DateTimeBehavior | UserLocal |
| Description | Enter the date when the invoiced product was delivered to the customer. |
| DisplayName | Delivered On |
| Format | DateOnly |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | actualdeliveryon |
| RequiredLevel | None |
| Type | DateTime |
BaseAmount
| Property | Value |
|---|---|
| Description | Shows the total price of the invoice product, based on the price per unit, volume discount, and quantity. |
| DisplayName | Amount |
| IsValidForCreate | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | baseamount |
| MaxValue | 922337203685477 |
| MinValue | -922337203685477 |
| Precision | 2 |
| PrecisionSource | 2 |
| RequiredLevel | None |
| Type | Money |
Description
| Property | Value |
|---|---|
| Description | Type additional information to describe the product line item of the invoice. |
| DisplayName | Description |
| Format | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | description |
| MaxLength | 2000 |
| RequiredLevel | None |
| Type | Memo |
ExtendedAmount
| Property | Value |
|---|---|
| Description | Shows the total amount due for the invoice product, based on the sum of the unit price, quantity, discounts, and tax. |
| DisplayName | Extended Amount |
| IsValidForCreate | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | extendedamount |
| MaxValue | 922337203685477 |
| MinValue | -922337203685477 |
| Precision | 2 |
| PrecisionSource | 2 |
| RequiredLevel | None |
| Type | Money |
ImportSequenceNumber
| Property | Value |
|---|---|
| Description | Sequence number of the import that created this record. |
| DisplayName | Import Sequence Number |
| Format | None |
| IsValidForForm | False |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | importsequencenumber |
| MaxValue | 2147483647 |
| MinValue | -2147483648 |
| RequiredLevel | None |
| Type | Integer |
InvoiceDetailId
| Property | Value |
|---|---|
| Description | Unique identifier of the invoice product line item. |
| DisplayName | Invoice Product |
| IsValidForForm | False |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | invoicedetailid |
| RequiredLevel | SystemRequired |
| Type | Uniqueidentifier |
InvoiceDetailName
Added by: Sales Patch Solution
| Property | Value |
|---|---|
| Description | Invoice Detail Name. Added for 1:n Referential relationship |
| DisplayName | Name |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | invoicedetailname |
| MaxLength | 100 |
| RequiredLevel | ApplicationRequired |
| Type | String |
InvoiceId
| Property | Value |
|---|---|
| Description | Unique identifier of the invoice associated with the invoice product line item. |
| DisplayName | Invoice ID |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | invoiceid |
| RequiredLevel | SystemRequired |
| Targets | invoice |
| Type | Lookup |
IsCopied
| Property | Value |
|---|---|
| Description | Select whether the invoice product is copied from another item or data source. |
| DisplayName | Copied |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | iscopied |
| RequiredLevel | None |
| Type | Boolean |
IsCopied Choices/Options
| Value | Label | Description |
|---|---|---|
| 1 | Yes | |
| 0 | No |
DefaultValue: 0
IsPriceOverridden
| Property | Value |
|---|---|
| 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. |
| DisplayName | Pricing |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | ispriceoverridden |
| RequiredLevel | None |
| Type | Boolean |
IsPriceOverridden Choices/Options
| Value | Label | Description |
|---|---|---|
| 1 | Override Price | |
| 0 | Use Default |
DefaultValue: 0
IsProductOverridden
| Property | Value |
|---|---|
| Description | Select whether the product exists in the Microsoft Dynamics 365 product catalog or is a write-in product specific to the parent invoice. |
| DisplayName | Select Product |
| IsValidForForm | True |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | isproductoverridden |
| RequiredLevel | None |
| Type | Boolean |
IsProductOverridden Choices/Options
| Value | Label | Description |
|---|---|---|
| 1 | Write In | |
| 0 | Existing |
DefaultValue: 0
LineItemNumber
| Property | Value |
|---|---|
| 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. |
| DisplayName | Line Item Number |
| Format | None |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | lineitemnumber |
| MaxValue | 1000000000 |
| MinValue | 0 |
| RequiredLevel | None |
| Type | Integer |
ManualDiscountAmount
| Property | Value |
|---|---|
| Description | Type the manual discount amount for the invoice product to deduct any negotiated or other savings from the product total. |
| DisplayName | Manual Discount |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | manualdiscountamount |
| MaxValue | 1000000000000 |
| MinValue | 0 |
| Precision | 2 |
| PrecisionSource | 2 |
| RequiredLevel | None |
| Type | Money |
OverriddenCreatedOn
| Property | Value |
|---|---|
| DateTimeBehavior | UserLocal |
| Description | Date and time that the record was migrated. |
| DisplayName | Record Created On |
| Format | DateOnly |
| IsValidForForm | False |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | overriddencreatedon |
| RequiredLevel | None |
| Type | DateTime |
ParentBundleId
| Property | Value |
|---|---|
| Description | Choose the parent bundle associated with this product |
| DisplayName | Parent Bundle |
| IsValidForForm | True |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | parentbundleid |
| RequiredLevel | None |
| Type | Uniqueidentifier |
ParentBundleIdRef
Added by: Sales Patch Solution
| Property | Value |
|---|---|
| Description | Choose the parent bundle associated with this product |
| DisplayName | Parent bundle product |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | parentbundleidref |
| RequiredLevel | None |
| Targets | invoicedetail |
| Type | Lookup |
PricePerUnit
| Property | Value |
|---|---|
| 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. |
| DisplayName | Price Per Unit |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | priceperunit |
| MaxValue | 922337203685477 |
| MinValue | -922337203685477 |
| Precision | 2 |
| PrecisionSource | 1 |
| RequiredLevel | None |
| Type | Money |
PricingErrorCode
| Property | Value |
|---|---|
| Description | Pricing error for the invoice product line item. |
| DisplayName | Pricing Error |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | pricingerrorcode |
| RequiredLevel | None |
| Type | Picklist |
PricingErrorCode Choices/Options
| Value | Label | Description |
|---|---|---|
| 0 | None | |
| 1 | Detail Error | |
| 2 | Missing Price Level | |
| 3 | Inactive Price Level | |
| 4 | Missing Quantity | |
| 5 | Missing Unit Price | |
| 6 | Missing Product | |
| 7 | Invalid Product | |
| 8 | Missing Pricing Code | |
| 9 | Invalid Pricing Code | |
| 10 | Missing UOM | |
| 11 | Product Not In Price Level | |
| 12 | Missing Price Level Amount | |
| 13 | Missing Price Level Percentage | |
| 14 | Missing Price | |
| 15 | Missing Current Cost | |
| 16 | Missing Standard Cost | |
| 17 | Invalid Price Level Amount | |
| 18 | Invalid Price Level Percentage | |
| 19 | Invalid Price | |
| 20 | Invalid Current Cost | |
| 21 | Invalid Standard Cost | |
| 22 | Invalid Rounding Policy | |
| 23 | Invalid Rounding Option | |
| 24 | Invalid Rounding Amount | |
| 25 | Price Calculation Error | |
| 26 | Invalid Discount Type | |
| 27 | Discount Type Invalid State | |
| 28 | Invalid Discount | |
| 29 | Invalid Quantity | |
| 30 | Invalid Pricing Precision | |
| 31 | Missing Product Default UOM | |
| 32 | Missing Product UOM Schedule | |
| 33 | Inactive Discount Type | |
| 34 | Invalid Price Level Currency | |
| 35 | Price Attribute Out Of Range | |
| 36 | Base Currency Attribute Overflow | |
| 37 | Base Currency Attribute Underflow |
ProductAssociationId
| Property | Value |
|---|---|
| Description | Unique identifier of the product line item association with bundle in the invoice |
| DisplayName | Bundle Item Association |
| IsValidForForm | True |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | productassociationid |
| RequiredLevel | None |
| Type | Uniqueidentifier |
ProductDescription
| Property | Value |
|---|---|
| Description | Type a name or description to identify the type of write-in product included in the invoice. |
| DisplayName | Write-In Product |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | productdescription |
| MaxLength | 500 |
| RequiredLevel | None |
| Type | String |
ProductId
| Property | Value |
|---|---|
| Description | Choose the product to include on the invoice. |
| DisplayName | Existing Product |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | productid |
| RequiredLevel | None |
| Targets | product |
| Type | Lookup |
ProductName
| Property | Value |
|---|---|
| Description | Calculated field that will be populated by name and description of the product. |
| DisplayName | Product Name |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | productname |
| MaxLength | 500 |
| RequiredLevel | None |
| Type | String |
ProductTypeCode
| Property | Value |
|---|---|
| Description | Product Type |
| DisplayName | Product type |
| IsValidForForm | True |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | producttypecode |
| RequiredLevel | SystemRequired |
| Type | Picklist |
ProductTypeCode Choices/Options
| Value | Label | Description |
|---|---|---|
| 1 | Product | |
| 2 | Bundle | |
| 3 | Required Bundle Product | |
| 4 | Optional Bundle Product | |
| 5 | Project-based Service |
PropertyConfigurationStatus
| Property | Value |
|---|---|
| Description | Status of the property configuration. |
| DisplayName | Property Configuration |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | propertyconfigurationstatus |
| RequiredLevel | SystemRequired |
| Type | Picklist |
PropertyConfigurationStatus Choices/Options
| Value | Label | Description |
|---|---|---|
| 0 | Edit | |
| 1 | Rectify | |
| 2 | Not Configured |
Quantity
| Property | Value |
|---|---|
| Description | Type the amount or quantity of the product included in the invoice's total amount due. |
| DisplayName | Quantity |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | quantity |
| MaxValue | 100000000000 |
| MinValue | -100000000000 |
| Precision | 5 |
| RequiredLevel | ApplicationRequired |
| Type | Decimal |
QuantityBackordered
| Property | Value |
|---|---|
| Description | Type the amount or quantity of the product that is back ordered for the invoice. |
| DisplayName | Quantity Back Ordered |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | quantitybackordered |
| MaxValue | 1000000000 |
| MinValue | 0 |
| Precision | 5 |
| RequiredLevel | None |
| Type | Decimal |
QuantityCancelled
| Property | Value |
|---|---|
| Description | Type the amount or quantity of the product that was canceled for the invoice line item. |
| DisplayName | Quantity Canceled |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | quantitycancelled |
| MaxValue | 1000000000 |
| MinValue | 0 |
| Precision | 5 |
| RequiredLevel | None |
| Type | Decimal |
QuantityShipped
| Property | Value |
|---|---|
| Description | Type the amount or quantity of the product that was shipped. |
| DisplayName | Quantity Shipped |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | quantityshipped |
| MaxValue | 1000000000 |
| MinValue | -1000000000 |
| Precision | 5 |
| RequiredLevel | None |
| Type | Decimal |
SalesOrderDetailId
Added by: Sales Patch Solution
| Property | Value |
|---|---|
| Description | Unique identifier for Order Line associated with Invoice Line. |
| DisplayName | Order Product Id |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | salesorderdetailid |
| RequiredLevel | None |
| Targets | salesorderdetail |
| Type | Lookup |
SalesRepId
| Property | Value |
|---|---|
| Description | Choose the user responsible for the sale of the invoice product. |
| DisplayName | Salesperson |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | salesrepid |
| RequiredLevel | None |
| Targets | systemuser |
| Type | Lookup |
SequenceNumber
| Property | Value |
|---|---|
| Description | Shows the ID of the data that maintains the sequence. |
| DisplayName | Sequence Number |
| Format | None |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | sequencenumber |
| MaxValue | 2147483647 |
| MinValue | -2147483648 |
| RequiredLevel | None |
| Type | Integer |
ShippingTrackingNumber
| Property | Value |
|---|---|
| Description | Type a tracking number for shipment of the invoiced product. |
| DisplayName | Shipment Tracking Number |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | shippingtrackingnumber |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
ShipTo_City
| Property | Value |
|---|---|
| Description | Type the city for the customer's shipping address. |
| DisplayName | Ship To City |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | shipto_city |
| MaxLength | 80 |
| RequiredLevel | None |
| Type | String |
ShipTo_Country
| Property | Value |
|---|---|
| Description | Type the country or region for the customer's shipping address. |
| DisplayName | Ship To Country/Region |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | shipto_country |
| MaxLength | 80 |
| RequiredLevel | None |
| Type | String |
ShipTo_Fax
| Property | Value |
|---|---|
| Description | Type the fax number for the customer's shipping address. |
| DisplayName | Ship To Fax |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | shipto_fax |
| MaxLength | 50 |
| RequiredLevel | None |
| Type | String |
ShipTo_FreightTermsCode
| Property | Value |
|---|---|
| Description | Select the freight terms to make sure shipping orders are processed correctly. |
| DisplayName | Freight Terms |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | shipto_freighttermscode |
| RequiredLevel | None |
| Type | Picklist |
ShipTo_FreightTermsCode Choices/Options
| Value | Label | Description |
|---|---|---|
| 1 | FOB | |
| 2 | No Charge |
ShipTo_Line1
| Property | Value |
|---|---|
| Description | Type the first line of the customer's shipping address. |
| DisplayName | Ship To Street 1 |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | shipto_line1 |
| MaxLength | 250 |
| RequiredLevel | None |
| Type | String |
ShipTo_Line2
| Property | Value |
|---|---|
| Description | Type the second line of the customer's shipping address. |
| DisplayName | Ship To Street 2 |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | shipto_line2 |
| MaxLength | 250 |
| RequiredLevel | None |
| Type | String |
ShipTo_Line3
| Property | Value |
|---|---|
| Description | Type the third line of the shipping address. |
| DisplayName | Ship To Street 3 |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | shipto_line3 |
| MaxLength | 250 |
| RequiredLevel | None |
| Type | String |
ShipTo_Name
| Property | Value |
|---|---|
| Description | Type a name for the customer's shipping address, such as "Headquarters" or "Field office", to identify the address. |
| DisplayName | Ship To Name |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | shipto_name |
| MaxLength | 200 |
| RequiredLevel | None |
| Type | String |
ShipTo_PostalCode
| Property | Value |
|---|---|
| Description | Type the ZIP Code or postal code for the shipping address. |
| DisplayName | Ship To ZIP/Postal Code |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | shipto_postalcode |
| MaxLength | 20 |
| RequiredLevel | None |
| Type | String |
ShipTo_StateOrProvince
| Property | Value |
|---|---|
| Description | Type the state or province for the shipping address. |
| DisplayName | Ship To State/Province |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | shipto_stateorprovince |
| MaxLength | 50 |
| RequiredLevel | None |
| Type | String |
ShipTo_Telephone
| Property | Value |
|---|---|
| Description | Type the phone number for the customer's shipping address. |
| DisplayName | Ship To Phone |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | shipto_telephone |
| MaxLength | 50 |
| RequiredLevel | None |
| Type | String |
Tax
| Property | Value |
|---|---|
| Description | Type the tax amount for the invoice product. |
| DisplayName | Tax |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | tax |
| MaxValue | 1000000000000 |
| MinValue | -1000000000000 |
| Precision | 2 |
| PrecisionSource | 2 |
| RequiredLevel | None |
| Type | Money |
TimeZoneRuleVersionNumber
| Property | Value |
|---|---|
| Description | For internal use only. |
| DisplayName | Time Zone Rule Version Number |
| Format | None |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | timezoneruleversionnumber |
| MaxValue | 2147483647 |
| MinValue | -1 |
| RequiredLevel | None |
| Type | Integer |
TransactionCurrencyId
| Property | Value |
|---|---|
| Description | Choose the local currency for the record to make sure budgets are reported in the correct currency. |
| DisplayName | Currency |
| IsValidForForm | True |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | transactioncurrencyid |
| RequiredLevel | None |
| Targets | transactioncurrency |
| Type | Lookup |
UoMId
| Property | Value |
|---|---|
| Description | Choose the unit of measurement for the base unit quantity for this purchase, such as each or dozen. |
| DisplayName | Unit |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | uomid |
| RequiredLevel | None |
| Targets | uom |
| Type | Lookup |
UTCConversionTimeZoneCode
| Property | Value |
|---|---|
| Description | Time zone code that was in use when the record was created. |
| DisplayName | UTC Conversion Time Zone Code |
| Format | None |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | utcconversiontimezonecode |
| MaxValue | 2147483647 |
| MinValue | -1 |
| RequiredLevel | None |
| Type | Integer |
WillCall
| Property | Value |
|---|---|
| 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. |
| DisplayName | Ship To |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | willcall |
| RequiredLevel | None |
| Type | Boolean |
WillCall Choices/Options
| Value | Label | Description |
|---|---|---|
| 1 | Will Call | |
| 0 | Address |
DefaultValue: 0
Read-only attributes
These attributes return false for both IsValidForCreate or IsValidForUpdate. Listed by SchemaName.
- BaseAmount_Base
- CreatedBy
- CreatedByName
- CreatedByYomiName
- CreatedOn
- CreatedOnBehalfBy
- CreatedOnBehalfByName
- CreatedOnBehalfByYomiName
- ExchangeRate
- ExtendedAmount_Base
- InvoiceIdName
- InvoiceIsPriceLocked
- InvoiceStateCode
- ManualDiscountAmount_Base
- ModifiedBy
- ModifiedByName
- ModifiedByYomiName
- ModifiedOn
- ModifiedOnBehalfBy
- ModifiedOnBehalfByName
- ModifiedOnBehalfByYomiName
- OwnerId
- OwnerIdName
- OwnerIdType
- OwnerIdYomiName
- OwningBusinessUnit
- OwningTeam
- OwningUser
- PricePerUnit_Base
- ProductIdName
- SalesOrderDetailIdName
- SalesRepIdName
- SalesRepIdYomiName
- Tax_Base
- TransactionCurrencyIdName
- UoMIdName
- VersionNumber
- VolumeDiscountAmount
- VolumeDiscountAmount_Base
BaseAmount_Base
| Property | Value |
|---|---|
| Description | Value of the Amount in base currency. |
| DisplayName | Amount (Base) |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | baseamount_base |
| MaxValue | 922337203685477 |
| MinValue | -922337203685477 |
| Precision | 4 |
| PrecisionSource | 2 |
| RequiredLevel | None |
| Type | Money |
CreatedBy
| Property | Value |
|---|---|
| Description | Shows who created the record. |
| DisplayName | Created By |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | createdby |
| RequiredLevel | None |
| Targets | systemuser |
| Type | Lookup |
CreatedByName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdbyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
CreatedByYomiName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdbyyominame |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
CreatedOn
| Property | Value |
|---|---|
| DateTimeBehavior | UserLocal |
| Description | Date and time when the record was created. |
| DisplayName | Created On |
| Format | DateAndTime |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | createdon |
| RequiredLevel | None |
| Type | DateTime |
CreatedOnBehalfBy
| Property | Value |
|---|---|
| Description | Shows who created the record on behalf of another user. |
| DisplayName | Created By (Delegate) |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | createdonbehalfby |
| RequiredLevel | None |
| Targets | systemuser |
| Type | Lookup |
CreatedOnBehalfByName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdonbehalfbyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
CreatedOnBehalfByYomiName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdonbehalfbyyominame |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
ExchangeRate
Added by: Active Solution Solution
| Property | Value |
|---|---|
| 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. |
| DisplayName | Exchange Rate |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | exchangerate |
| MaxValue | 100000000000 |
| MinValue | 0.0000000001 |
| Precision | 10 |
| RequiredLevel | None |
| Type | Decimal |
ExtendedAmount_Base
| Property | Value |
|---|---|
| Description | Value of the Extended Amount in base currency. |
| DisplayName | Extended Amount (Base) |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | extendedamount_base |
| MaxValue | 922337203685477 |
| MinValue | -922337203685477 |
| Precision | 4 |
| PrecisionSource | 2 |
| RequiredLevel | None |
| Type | Money |
InvoiceIdName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | invoiceidname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
InvoiceIsPriceLocked
| Property | Value |
|---|---|
| Description | Information about whether invoice product pricing is locked. |
| DisplayName | Invoice Is Price Locked |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | invoiceispricelocked |
| RequiredLevel | ApplicationRequired |
| Type | Boolean |
InvoiceIsPriceLocked Choices/Options
| Value | Label | Description |
|---|---|---|
| 1 | Yes | |
| 0 | No |
DefaultValue: 0
InvoiceStateCode
| Property | Value |
|---|---|
| Description | Status of the invoice product. |
| DisplayName | Invoice Status |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | invoicestatecode |
| RequiredLevel | SystemRequired |
| Type | Picklist |
InvoiceStateCode Choices/Options
| Value | Label | Description |
|---|
ManualDiscountAmount_Base
| Property | Value |
|---|---|
| Description | Value of the Manual Discount in base currency. |
| DisplayName | Manual Discount (Base) |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | manualdiscountamount_base |
| MaxValue | 922337203685477 |
| MinValue | -922337203685477 |
| Precision | 4 |
| PrecisionSource | 2 |
| RequiredLevel | None |
| Type | Money |
ModifiedBy
| Property | Value |
|---|---|
| Description | Shows who last updated the record. |
| DisplayName | Modified By |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | modifiedby |
| RequiredLevel | None |
| Targets | systemuser |
| Type | Lookup |
ModifiedByName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedbyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
ModifiedByYomiName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedbyyominame |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
ModifiedOn
| Property | Value |
|---|---|
| DateTimeBehavior | UserLocal |
| Description | Date and time when the record was modified. |
| DisplayName | Modified On |
| Format | DateAndTime |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | modifiedon |
| RequiredLevel | None |
| Type | DateTime |
ModifiedOnBehalfBy
| Property | Value |
|---|---|
| Description | Shows who last updated the record on behalf of another user. |
| DisplayName | Modified By (Delegate) |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | modifiedonbehalfby |
| RequiredLevel | None |
| Targets | systemuser |
| Type | Lookup |
ModifiedOnBehalfByName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedonbehalfbyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
ModifiedOnBehalfByYomiName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedonbehalfbyyominame |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
OwnerId
| Property | Value |
|---|---|
| Description | Owner Id |
| DisplayName | Owner |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | ownerid |
| RequiredLevel | ApplicationRequired |
| Targets | systemuser,team |
| Type | Owner |
OwnerIdName
| Property | Value |
|---|---|
| Description | Name of the owner |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owneridname |
| MaxLength | 100 |
| RequiredLevel | SystemRequired |
| Type | String |
OwnerIdType
| Property | Value |
|---|---|
| Description | Owner Id Type |
| DisplayName | |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owneridtype |
| RequiredLevel | SystemRequired |
| Type | EntityName |
OwnerIdYomiName
| Property | Value |
|---|---|
| Description | Yomi name of the owner |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owneridyominame |
| MaxLength | 100 |
| RequiredLevel | SystemRequired |
| Type | String |
OwningBusinessUnit
| Property | Value |
|---|---|
| Description | Unique identifier for the business unit that owns the record |
| DisplayName | Owning Business Unit |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owningbusinessunit |
| RequiredLevel | ApplicationRequired |
| Targets | |
| Type | Lookup |
OwningTeam
| Property | Value |
|---|---|
| Description | Unique identifier for the team that owns the record. |
| DisplayName | Owning Team |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owningteam |
| RequiredLevel | None |
| Targets | team |
| Type | Lookup |
OwningUser
| Property | Value |
|---|---|
| Description | Unique identifier for the user that owns the record. |
| DisplayName | Owning User |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owninguser |
| RequiredLevel | ApplicationRequired |
| Targets | |
| Type | Lookup |
PricePerUnit_Base
| Property | Value |
|---|---|
| Description | Value of the Price Per Unit in base currency. |
| DisplayName | Price Per Unit (Base) |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | priceperunit_base |
| MaxValue | 922337203685477 |
| MinValue | -922337203685477 |
| Precision | 4 |
| PrecisionSource | 1 |
| RequiredLevel | None |
| Type | Money |
ProductIdName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | productidname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
SalesOrderDetailIdName
Added by: Sales Patch Solution
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | salesorderdetailidname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
SalesRepIdName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | salesrepidname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
SalesRepIdYomiName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | salesrepidyominame |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
Tax_Base
| Property | Value |
|---|---|
| Description | Value of the Tax in base currency. |
| DisplayName | Tax (Base) |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | tax_base |
| MaxValue | 922337203685477 |
| MinValue | -922337203685477 |
| Precision | 4 |
| PrecisionSource | 2 |
| RequiredLevel | None |
| Type | Money |
TransactionCurrencyIdName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | transactioncurrencyidname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
UoMIdName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | uomidname |
| MaxLength | 100 |
| RequiredLevel | SystemRequired |
| Type | String |
VersionNumber
| Property | Value |
|---|---|
| Description | Version Number |
| DisplayName | Version Number |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | versionnumber |
| MaxValue | 9223372036854775807 |
| MinValue | -9223372036854775808 |
| RequiredLevel | None |
| Type | BigInt |
VolumeDiscountAmount
| Property | Value |
|---|---|
| Description | Shows the discount amount per unit if a specified volume is purchased. Configure volume discounts in the Product Catalog in the Settings area. |
| DisplayName | Volume Discount |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | volumediscountamount |
| MaxValue | 922337203685477 |
| MinValue | 0 |
| Precision | 2 |
| PrecisionSource | 2 |
| RequiredLevel | None |
| Type | Money |
VolumeDiscountAmount_Base
| Property | Value |
|---|---|
| Description | Value of the Volume Discount in base currency. |
| DisplayName | Volume Discount (Base) |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | volumediscountamount_base |
| MaxValue | 922337203685477 |
| MinValue | -922337203685477 |
| Precision | 4 |
| PrecisionSource | 2 |
| RequiredLevel | None |
| Type | Money |
One-To-Many Relationships
Listed by SchemaName.
- InvoiceDetail_SyncErrors
- InvoiceDetail_AsyncOperations
- invoicedetail_MailboxTrackingFolders
- InvoiceDetail_ProcessSessions
- InvoiceDetail_BulkDeleteFailures
- invoicedetail_principalobjectattributeaccess
- InvoiceDetail_Dynamicpropertyinstance
- invoicedetail_parent_invoicedetail
- invoicedetail_parentref_invoicedetail
InvoiceDetail_SyncErrors
Added by: System Solution Solution
Same as the InvoiceDetail_SyncErrors many-to-one relationship for the syncerror entity.
| Property | Value |
|---|---|
| ReferencingEntity | syncerror |
| ReferencingAttribute | regardingobjectid |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | InvoiceDetail_SyncErrors |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: Cascade Delete: Cascade Merge: Cascade Reparent: Cascade Share: Cascade Unshare: Cascade |
InvoiceDetail_AsyncOperations
Added by: System Solution Solution
Same as the InvoiceDetail_AsyncOperations many-to-one relationship for the asyncoperation entity.
| Property | Value |
|---|---|
| ReferencingEntity | asyncoperation |
| ReferencingAttribute | regardingobjectid |
| IsHierarchical | False |
| IsCustomizable | False |
| ReferencedEntityNavigationPropertyName | InvoiceDetail_AsyncOperations |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
invoicedetail_MailboxTrackingFolders
Added by: System Solution Solution
Same as the invoicedetail_MailboxTrackingFolders many-to-one relationship for the mailboxtrackingfolder entity.
| Property | Value |
|---|---|
| ReferencingEntity | mailboxtrackingfolder |
| ReferencingAttribute | regardingobjectid |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | invoicedetail_MailboxTrackingFolders |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
InvoiceDetail_ProcessSessions
Added by: System Solution Solution
Same as the InvoiceDetail_ProcessSessions many-to-one relationship for the processsession entity.
| Property | Value |
|---|---|
| ReferencingEntity | processsession |
| ReferencingAttribute | regardingobjectid |
| IsHierarchical | False |
| IsCustomizable | False |
| ReferencedEntityNavigationPropertyName | InvoiceDetail_ProcessSessions |
| AssociatedMenuConfiguration | Behavior: UseCollectionName Group: Details Label: Order: 110 |
| CascadeConfiguration | Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
InvoiceDetail_BulkDeleteFailures
Added by: System Solution Solution
Same as the InvoiceDetail_BulkDeleteFailures many-to-one relationship for the bulkdeletefailure entity.
| Property | Value |
|---|---|
| ReferencingEntity | bulkdeletefailure |
| ReferencingAttribute | regardingobjectid |
| IsHierarchical | False |
| IsCustomizable | False |
| ReferencedEntityNavigationPropertyName | InvoiceDetail_BulkDeleteFailures |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
invoicedetail_principalobjectattributeaccess
Added by: System Solution Solution
Same as the invoicedetail_principalobjectattributeaccess many-to-one relationship for the principalobjectattributeaccess entity.
| Property | Value |
|---|---|
| ReferencingEntity | principalobjectattributeaccess |
| ReferencingAttribute | objectid |
| IsHierarchical | False |
| IsCustomizable | False |
| ReferencedEntityNavigationPropertyName | invoicedetail_principalobjectattributeaccess |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
InvoiceDetail_Dynamicpropertyinstance
Same as the InvoiceDetail_Dynamicpropertyinstance many-to-one relationship for the dynamicpropertyinstance entity.
| Property | Value |
|---|---|
| ReferencingEntity | dynamicpropertyinstance |
| ReferencingAttribute | regardingobjectid |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | InvoiceDetail_Dynamicpropertyinstance |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: Cascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: Cascade Unshare: NoCascade |
invoicedetail_parent_invoicedetail
Same as the invoicedetail_parent_invoicedetail many-to-one relationship for the invoicedetail entity.
| Property | Value |
|---|---|
| ReferencingEntity | invoicedetail |
| ReferencingAttribute | parentbundleid |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | invoicedetail_parent_invoicedetail |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
invoicedetail_parentref_invoicedetail
Added by: Sales Patch Solution
Same as the invoicedetail_parentref_invoicedetail many-to-one relationship for the invoicedetail entity.
| Property | Value |
|---|---|
| ReferencingEntity | invoicedetail |
| ReferencingAttribute | parentbundleidref |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | invoicedetail_parentref_invoicedetail |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
Many-To-One Relationships
Each Many-To-One relationship is defined by a corresponding One-To-Many relationship with the related entity. Listed by SchemaName.
- lk_invoicedetailbase_createdby
- lk_invoicedetail_createdonbehalfby
- lk_invoicedetailbase_modifiedby
- lk_invoicedetail_modifiedonbehalfby
- user_invoicedetail
- team_invoicedetail
- transactioncurrency_invoicedetail
- invoice_details
- invoicedetail_parent_invoicedetail
- product_invoice_details
- system_user_invoicedetail
- unit_of_measurement_invoice_details
- productAssociation_invoice_details
- msdyn_salesorderdetail_invoicedetail
- invoicedetail_parentref_invoicedetail
lk_invoicedetailbase_createdby
Added by: System Solution Solution
See the lk_invoicedetailbase_createdby one-to-many relationship for the systemuser entity.
lk_invoicedetail_createdonbehalfby
Added by: System Solution Solution
See the lk_invoicedetail_createdonbehalfby one-to-many relationship for the systemuser entity.
lk_invoicedetailbase_modifiedby
Added by: System Solution Solution
See the lk_invoicedetailbase_modifiedby one-to-many relationship for the systemuser entity.
lk_invoicedetail_modifiedonbehalfby
Added by: System Solution Solution
See the lk_invoicedetail_modifiedonbehalfby one-to-many relationship for the systemuser entity.
user_invoicedetail
Added by: System Solution Solution
See the user_invoicedetail one-to-many relationship for the systemuser entity.
team_invoicedetail
Added by: System Solution Solution
See the team_invoicedetail one-to-many relationship for the team entity.
transactioncurrency_invoicedetail
Added by: System Solution Solution
See the transactioncurrency_invoicedetail one-to-many relationship for the transactioncurrency entity.
invoice_details
See the invoice_details one-to-many relationship for the invoice entity.
invoicedetail_parent_invoicedetail
See the invoicedetail_parent_invoicedetail one-to-many relationship for the invoicedetail entity.
product_invoice_details
Added by: Product Management Solution
See the product_invoice_details one-to-many relationship for the product entity.
system_user_invoicedetail
Added by: System Solution Solution
See the system_user_invoicedetail one-to-many relationship for the systemuser entity.
unit_of_measurement_invoice_details
Added by: Product Management Solution
See the unit_of_measurement_invoice_details one-to-many relationship for the uom entity.
productAssociation_invoice_details
Added by: Product Management Solution
See the productAssociation_invoice_details one-to-many relationship for the productassociation entity.
msdyn_salesorderdetail_invoicedetail
See the msdyn_salesorderdetail_invoicedetail one-to-many relationship for the salesorderdetail entity.
invoicedetail_parentref_invoicedetail
See the invoicedetail_parentref_invoicedetail one-to-many relationship for the invoicedetail entity.