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.
See also
प्रतिक्रिया
https://aka.ms/ContentUserFeedback.
जल्द आ रहा है: 2024 के दौरान हम सामग्री के लिए फीडबैक तंत्र के रूप में GitHub मुद्दों को चरणबद्ध तरीके से समाप्त कर देंगे और इसे एक नई फीडबैक प्रणाली से बदल देंगे. अधिक जानकारी के लिए, देखें:के लिए प्रतिक्रिया सबमिट करें और देखें