SalesOrderDetail Entity Reference
Line item in a sales order.
Added by: Sales Solution
Messages
| Message | Web API Operation | SDK Assembly |
|---|---|---|
| CalculatePrice | CalculatePrice Action | CalculatePriceRequest |
| Create | POST [org URI]/api/data/v9.0/salesorderdetails See Create |
CreateRequest or Create |
| Delete | DELETE [org URI]/api/data/v9.0/salesorderdetails(salesorderdetailid) See Delete |
DeleteRequest or Delete |
| msdyn_CreateContractLineDetailsFromEstimate | Microsoft.Dynamics.CRM.msdyn_CreateContractLineDetailsFromEstimate | Type generated by CrmSvcUtil.exe or use OrganizationRequest setting the required parameters for the message. |
| msdyn_GenerateContractLineInvoiceSchedule | Microsoft.Dynamics.CRM.msdyn_GenerateContractLineInvoiceSchedule | Type generated by CrmSvcUtil.exe or use OrganizationRequest setting the required parameters for the message. |
| msdyn_GenerateContractLineScheduleOfValues | Microsoft.Dynamics.CRM.msdyn_GenerateContractLineScheduleOfValues | Type generated by CrmSvcUtil.exe or use OrganizationRequest setting the required parameters for the message. |
| msdyn_GetContractLineChargeability | Microsoft.Dynamics.CRM.msdyn_GetContractLineChargeability | Type generated by CrmSvcUtil.exe or use OrganizationRequest setting the required parameters for the message. |
| msdyn_GetProjectMapForContractLine | Microsoft.Dynamics.CRM.msdyn_GetProjectMapForContractLine | Type generated by CrmSvcUtil.exe or use OrganizationRequest setting the required parameters for the message. |
| Retrieve | GET [org URI]/api/data/v9.0/salesorderdetails(salesorderdetailid) See Retrieve |
RetrieveRequest or Retrieve |
| RetrieveMultiple | GET [org URI]/api/data/v9.0/salesorderdetails See Query Data |
RetrieveMultipleRequest or RetrieveMultiple |
| Update | PATCH [org URI]/api/data/v9.0/salesorderdetails(salesorderdetailid) See Update |
UpdateRequest or Update |
Entity Properties
| Property | Value |
|---|---|
| CollectionSchemaName | SalesOrderDetails |
| DisplayCollectionName | Order Lines |
| DisplayName | Order Line |
| EntitySetName | salesorderdetails |
| IsBPFEntity | False |
| LogicalCollectionName | salesorderdetails |
| LogicalName | salesorderdetail |
| OwnershipType | UserOwned |
| PrimaryIdAttribute | salesorderdetailid |
| PrimaryNameAttribute | salesorderdetailname |
| SchemaName | SalesOrderDetail |
Writable attributes
These attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.
- BaseAmount
- Description
- ExtendedAmount
- ImportSequenceNumber
- IsCopied
- IsPriceOverridden
- IsProductOverridden
- LineItemNumber
- ManualDiscountAmount
- msdyn_agreement
- msdyn_BillingMethod
- msdyn_BillingStartDate
- msdyn_BillingStatus
- msdyn_BudgetAmount
- msdyn_CostAmount
- msdyn_CostPricePerUnit
- msdyn_IncludeExpense
- msdyn_IncludeFee
- msdyn_IncludeMaterial
- msdyn_IncludeTime
- msdyn_invoicefrequency
- msdyn_LineType
- msdyn_Project
- msdyn_QuoteLine
- OverriddenCreatedOn
- ParentBundleId
- ParentBundleIdRef
- PricePerUnit
- PricingErrorCode
- ProductAssociationId
- ProductDescription
- ProductId
- ProductName
- ProductTypeCode
- PropertyConfigurationStatus
- Quantity
- QuantityBackordered
- QuantityCancelled
- QuantityShipped
- QuoteDetailId
- RequestDeliveryBy
- SalesOrderDetailId
- SalesOrderDetailName
- SalesOrderId
- SalesRepId
- SequenceNumber
- ShipTo_AddressId
- ShipTo_City
- ShipTo_ContactName
- ShipTo_Country
- ShipTo_Fax
- ShipTo_FreightTermsCode
- ShipTo_Line1
- ShipTo_Line2
- ShipTo_Line3
- ShipTo_Name
- ShipTo_PostalCode
- ShipTo_StateOrProvince
- ShipTo_Telephone
- SkipPriceCalculation
- Tax
- TimeZoneRuleVersionNumber
- TransactionCurrencyId
- UoMId
- UTCConversionTimeZoneCode
- WillCall
BaseAmount
| Property | Value |
|---|---|
| Description | Shows the total price of the order 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 order product, such as manufacturing details or acceptable substitutions. |
| 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 order 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 |
IsCopied
| Property | Value |
|---|---|
| Description | Select whether the invoice line item is copied from another item or data source. |
| DisplayName | Copied |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | iscopied |
| RequiredLevel | None |
| Type | Boolean |
IsCopied Options
| Value | Label |
|---|---|
| 1 | Yes |
| 0 | No |
DefaultValue: False
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 order product. |
| DisplayName | Pricing |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | ispriceoverridden |
| RequiredLevel | None |
| Type | Boolean |
IsPriceOverridden Options
| Value | Label |
|---|---|
| 1 | Override Price |
| 0 | Use Default |
DefaultValue: False
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 order. |
| DisplayName | Select Product |
| IsValidForForm | True |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | isproductoverridden |
| RequiredLevel | None |
| Type | Boolean |
IsProductOverridden Options
| Value | Label |
|---|---|
| 1 | Write In |
| 0 | Existing |
DefaultValue: False
LineItemNumber
| Property | Value |
|---|---|
| Description | Type the line item number for the order product to easily identify the product in the order and make sure it's listed in the correct sequence. |
| 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 order product to deduct any negotiated or other savings from the product total on the order. |
| DisplayName | Manual Discount |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | manualdiscountamount |
| MaxValue | 1000000000000 |
| MinValue | 0 |
| Precision | 2 |
| PrecisionSource | 2 |
| RequiredLevel | None |
| Type | Money |
msdyn_agreement
Added by: Field Service Solution
| Property | Value |
|---|---|
| Description | Select a Agreement for this order line |
| DisplayName | Agreement |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_agreement |
| RequiredLevel | None |
| Targets | msdyn_agreement |
| Type | Lookup |
msdyn_BillingMethod
Added by: Project Service Automation Solution
| Property | Value |
|---|---|
| Description | Billing method for the project contract line. Valid values are Time and Material and Fixed Price |
| DisplayName | Billing Method |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_billingmethod |
| RequiredLevel | None |
| Type | Picklist |
msdyn_BillingMethod Options
| Value | Label |
|---|---|
| 192350000 | Time and Material |
| 192350001 | Fixed Price |
msdyn_BillingStartDate
Added by: Project Service Automation Solution
| Property | Value |
|---|---|
| DateTimeBehavior | UserLocal |
| Description | Select the billing start date for the project contract line. |
| DisplayName | Billing Start Date |
| Format | DateOnly |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_billingstartdate |
| RequiredLevel | Recommended |
| Type | DateTime |
msdyn_BillingStatus
Added by: Project Service Automation Solution
| Property | Value |
|---|---|
| Description | Select the billing status for the project contract line. |
| DisplayName | Billing Status |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_billingstatus |
| RequiredLevel | None |
| Type | Picklist |
msdyn_BillingStatus Options
| Value | Label |
|---|---|
| 192350000 | Unbilled Sales Created |
| 192350001 | Customer Invoice Created |
| 192350002 | Customer Invoice Posted |
| 192350003 | Canceled |
| 192350004 | Ready to Invoice |
| 690970000 | Work order closed - posted |
msdyn_BudgetAmount
Added by: Project Service Automation Solution
| Property | Value |
|---|---|
| Description | Enter the amount the customer has set aside or is willing to pay for the project contract component. |
| DisplayName | Customer Budget |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_budgetamount |
| MaxValue | 922337203685477 |
| MinValue | -922337203685477 |
| Precision | 4 |
| PrecisionSource | 2 |
| RequiredLevel | None |
| Type | Money |
msdyn_CostAmount
Added by: Project Service Automation Solution
| Property | Value |
|---|---|
| Description | Shows the total cost price of the product based on the cost price per unit and quantity. |
| DisplayName | Cost Amount |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_costamount |
| MaxValue | 922337203685477 |
| MinValue | 0 |
| Precision | 4 |
| PrecisionSource | 2 |
| RequiredLevel | None |
| Type | Money |
msdyn_CostPricePerUnit
Added by: Project Service Automation Solution
| Property | Value |
|---|---|
| Description | Cost per unit of the product. The default is the cost price of the product. |
| DisplayName | Cost Per Unit |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_costpriceperunit |
| MaxValue | 922337203685477 |
| MinValue | 0 |
| Precision | 2 |
| PrecisionSource | 1 |
| RequiredLevel | None |
| Type | Money |
msdyn_IncludeExpense
Added by: Project Service Automation Solution
| Property | Value |
|---|---|
| Description | Select whether to include expenses in the project contract line. |
| DisplayName | Include Expense |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_includeexpense |
| RequiredLevel | None |
| Type | Boolean |
msdyn_IncludeExpense Options
| Value | Label |
|---|---|
| 1 | Yes |
| 0 | No |
DefaultValue: True
msdyn_IncludeFee
Added by: Project Service Automation Solution
| Property | Value |
|---|---|
| Description | Select whether to include fees in the project contract line. |
| DisplayName | Include Fee |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_includefee |
| RequiredLevel | None |
| Type | Boolean |
msdyn_IncludeFee Options
| Value | Label |
|---|---|
| 1 | Yes |
| 0 | No |
DefaultValue: True
msdyn_IncludeMaterial
Added by: Project Service Automation Solution
| Property | Value |
|---|---|
| Description | Select whether to include materials in the project contract line. |
| DisplayName | Include Material |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_includematerial |
| RequiredLevel | None |
| Type | Boolean |
msdyn_IncludeMaterial Options
| Value | Label |
|---|---|
| 1 | Yes |
| 0 | No |
DefaultValue: False
msdyn_IncludeTime
Added by: Project Service Automation Solution
| Property | Value |
|---|---|
| Description | Select whether to include time transactions in the project contract line. |
| DisplayName | Include Time |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_includetime |
| RequiredLevel | None |
| Type | Boolean |
msdyn_IncludeTime Options
| Value | Label |
|---|---|
| 1 | Yes |
| 0 | No |
DefaultValue: True
msdyn_invoicefrequency
Added by: Project Service Automation Solution
| Property | Value |
|---|---|
| Description | Select the frequency for the automatic invoice creation job to create the invoice. |
| DisplayName | Invoice Frequency |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_invoicefrequency |
| RequiredLevel | None |
| Targets | msdyn_invoicefrequency |
| Type | Lookup |
msdyn_LineType
Added by: Project Service Automation Solution
| Property | Value |
|---|---|
| Description | The field to distinguish the order lines to be of project service or field service |
| DisplayName | Line Type |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_linetype |
| RequiredLevel | None |
| Type | Picklist |
msdyn_LineType Options
| Value | Label |
|---|---|
| 690970000 | Project Service Line |
| 690970001 | Field Service Line |
msdyn_Project
Added by: Project Service Automation Solution
| Property | Value |
|---|---|
| Description | Select the project of the project contract line. |
| DisplayName | Project |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_project |
| RequiredLevel | None |
| Targets | msdyn_project |
| Type | Lookup |
msdyn_QuoteLine
Added by: Project Service Automation Solution
| Property | Value |
|---|---|
| Description | (Deprecated) Shows the quote line related to the project contract line. |
| DisplayName | (Deprecated) Quote Line |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_quoteline |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
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 | salesorderdetail |
| Type | Lookup |
PricePerUnit
| Property | Value |
|---|---|
| Description | Type the price per unit of the order product. The default is the value in the price list specified on the order 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 | Select the type of pricing error, such as a missing or invalid product, or missing quantity. |
| DisplayName | Pricing Error |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | pricingerrorcode |
| RequiredLevel | None |
| Type | Picklist |
PricingErrorCode Options
| Value | Label |
|---|---|
| 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 |
| 38 | Transaction currency is not set for the product price list item |
ProductAssociationId
| Property | Value |
|---|---|
| Description | Unique identifier of the product line item association with bundle in the sales order |
| 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 order. |
| 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 order to link the product's pricing and other information to the parent order. |
| 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 Options
| Value | Label |
|---|---|
| 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 Options
| Value | Label |
|---|---|
| 0 | Edit |
| 1 | Rectify |
| 2 | Not Configured |
Quantity
| Property | Value |
|---|---|
| Description | Type the amount or quantity of the product ordered by the customer. |
| 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 order. |
| 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. |
| 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 for the order. |
| DisplayName | Quantity Shipped |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | quantityshipped |
| MaxValue | 1000000000 |
| MinValue | -1000000000 |
| Precision | 5 |
| RequiredLevel | None |
| Type | Decimal |
QuoteDetailId
Added by: Sales Patch Solution
| Property | Value |
|---|---|
| Description | Unique identifier for Quote Line associated with Order Line. |
| DisplayName | Quote Product Id |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | quotedetailid |
| RequiredLevel | None |
| Targets | quotedetail |
| Type | Lookup |
RequestDeliveryBy
| Property | Value |
|---|---|
| DateTimeBehavior | UserLocal |
| Description | Enter the delivery date requested by the customer for the order product. |
| DisplayName | Requested Delivery Date |
| Format | DateOnly |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | requestdeliveryby |
| RequiredLevel | None |
| Type | DateTime |
SalesOrderDetailId
| Property | Value |
|---|---|
| Description | Unique identifier of the product specified in the order. |
| DisplayName | Order Product |
| IsValidForForm | False |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | salesorderdetailid |
| RequiredLevel | SystemRequired |
| Type | Uniqueidentifier |
SalesOrderDetailName
Added by: Sales Patch Solution
| Property | Value |
|---|---|
| Description | Sales Order Detail Name. Added for 1:n Referential relationship |
| DisplayName | Name |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | salesorderdetailname |
| MaxLength | 100 |
| RequiredLevel | ApplicationRequired |
| Type | String |
SalesOrderId
| Property | Value |
|---|---|
| Description | Shows the order for the product. The ID is used to link product pricing and other details to the total amounts and other information on the order. |
| DisplayName | Order |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | salesorderid |
| RequiredLevel | SystemRequired |
| Targets | salesorder |
| Type | Lookup |
SalesRepId
| Property | Value |
|---|---|
| Description | Choose the user responsible for the sale of the order 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 |
ShipTo_AddressId
| Property | Value |
|---|---|
| Description | Unique identifier of the shipping address. |
| DisplayName | Ship To Address ID |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | shipto_addressid |
| RequiredLevel | None |
| Type | Uniqueidentifier |
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_ContactName
| Property | Value |
|---|---|
| Description | Type the primary contact name at the customer's shipping address. |
| DisplayName | Ship To Contact Name |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | shipto_contactname |
| MaxLength | 150 |
| 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 Options
| Value | Label |
|---|---|
| 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 |
SkipPriceCalculation
Added by: Sales Patch Solution
| Property | Value |
|---|---|
| Description | Skip the price calculation. Used with bulk update and bulk insert operations. |
| DisplayName | Skip Price Calculation |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | skippricecalculation |
| RequiredLevel | None |
| Type | Picklist |
SkipPriceCalculation Options
| Value | Label |
|---|---|
| 0 | DoPriceCalcAlways |
| 1 | SkipPriceCalcOnCreate |
| 2 | SkipPriceCalcOnUpdate |
Tax
| Property | Value |
|---|---|
| Description | Type the tax amount for the order 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 order 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 Options
| Value | Label |
|---|---|
| 1 | Will Call |
| 0 | Address |
DefaultValue: False
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
- ManualDiscountAmount_Base
- ModifiedBy
- ModifiedByName
- ModifiedByYomiName
- ModifiedOn
- ModifiedOnBehalfBy
- ModifiedOnBehalfByName
- ModifiedOnBehalfByYomiName
- msdyn_agreementName
- msdyn_budgetamount_Base
- msdyn_costamount_Base
- msdyn_costpriceperunit_Base
- msdyn_invoicefrequencyName
- msdyn_ProjectName
- OwnerId
- OwnerIdName
- OwnerIdType
- OwnerIdYomiName
- OwningBusinessUnit
- OwningTeam
- OwningUser
- PricePerUnit_Base
- ProductIdName
- QuoteDetailIdName
- SalesOrderIdName
- SalesOrderIsPriceLocked
- SalesOrderStateCode
- 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 |
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 |
msdyn_agreementName
Added by: Field Service Solution
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | msdyn_agreementname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
msdyn_budgetamount_Base
Added by: Project Service Automation Solution
| Property | Value |
|---|---|
| Description | Value of the Budget Amount in base currency. |
| DisplayName | Budget Amount (Base) |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_budgetamount_base |
| MaxValue | 922337203685477 |
| MinValue | -922337203685477 |
| Precision | 4 |
| PrecisionSource | 2 |
| RequiredLevel | None |
| Type | Money |
msdyn_costamount_Base
Added by: Project Service Automation Solution
| Property | Value |
|---|---|
| Description | Value of the Cost Amount in base currency. |
| DisplayName | Cost Amount (Base) |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_costamount_base |
| MaxValue | 922337203685477 |
| MinValue | -922337203685477 |
| Precision | 4 |
| PrecisionSource | 2 |
| RequiredLevel | None |
| Type | Money |
msdyn_costpriceperunit_Base
Added by: Project Service Automation Solution
| Property | Value |
|---|---|
| Description | Value of the Cost Price Per Unit in base currency. |
| DisplayName | Cost Price Per Unit (Base) |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_costpriceperunit_base |
| MaxValue | 922337203685477 |
| MinValue | -922337203685477 |
| Precision | 2 |
| PrecisionSource | 1 |
| RequiredLevel | None |
| Type | Money |
msdyn_invoicefrequencyName
Added by: Project Service Automation Solution
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | msdyn_invoicefrequencyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
msdyn_ProjectName
Added by: Project Service Automation Solution
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | msdyn_projectname |
| MaxLength | 200 |
| 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 |
QuoteDetailIdName
Added by: Sales Patch Solution
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | quotedetailidname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
SalesOrderIdName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | salesorderidname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
SalesOrderIsPriceLocked
| Property | Value |
|---|---|
| Description | Tells whether product pricing is locked for the order. |
| DisplayName | Order Is Price Locked |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | salesorderispricelocked |
| RequiredLevel | ApplicationRequired |
| Type | Boolean |
SalesOrderIsPriceLocked Options
| Value | Label |
|---|---|
| 1 | Yes |
| 0 | No |
DefaultValue: False
SalesOrderStateCode
| Property | Value |
|---|---|
| Description | Shows the status of the order that the order detail is associated with. |
| DisplayName | Order Status |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | salesorderstatecode |
| RequiredLevel | SystemRequired |
| Type | Picklist |
SalesOrderStateCode Options
| Value | Label |
|---|
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.
- SalesOrderDetail_SyncErrors
- SalesOrderDetail_AsyncOperations
- salesorderdetail_MailboxTrackingFolders
- SalesOrderDetail_ProcessSessions
- SalesOrderDetail_BulkDeleteFailures
- salesorderdetail_principalobjectattributeaccess
- SalesOrderDetail_Dynamicpropertyinstance
- salesorderdetail_parent_salesorderdetail
- msdyn_salesorderdetail_invoicedetail
- salesorderdetail_parentref_salesorderdetail
- msdyn_salesorderdetail_msdyn_actual
- msdyn_salesorderdetail_msdyn_contractlineinvoic
- msdyn_salesorderdetail_msdyn_contractlineschedu
- msdyn_salesorderdetail_msdyn_fact
- msdyn_salesorderdetail_msdyn_invoicelinetransac
- msdyn_salesorderdetail_msdyn_journalline
- msdyn_salesorderdetail_msdyn_orderlineresourcec
- msdyn_salesorderdetail_msdyn_orderlinetransacti
- msdyn_salesorderdetail_msdyn_orderlinetranscat
- msdyn_salesorderdetail_msdyn_orderlinetransclas
SalesOrderDetail_SyncErrors
Added by: System Solution Solution
Same as syncerror entity SalesOrderDetail_SyncErrors Many-To-One relationship.
| Property | Value |
|---|---|
| ReferencingEntity | syncerror |
| ReferencingAttribute | regardingobjectid |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | SalesOrderDetail_SyncErrors |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: Cascade Delete: Cascade Merge: Cascade Reparent: Cascade Share: Cascade Unshare: Cascade |
SalesOrderDetail_AsyncOperations
Added by: System Solution Solution
Same as asyncoperation entity SalesOrderDetail_AsyncOperations Many-To-One relationship.
| Property | Value |
|---|---|
| ReferencingEntity | asyncoperation |
| ReferencingAttribute | regardingobjectid |
| IsHierarchical | False |
| IsCustomizable | False |
| ReferencedEntityNavigationPropertyName | SalesOrderDetail_AsyncOperations |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
salesorderdetail_MailboxTrackingFolders
Added by: System Solution Solution
Same as mailboxtrackingfolder entity salesorderdetail_MailboxTrackingFolders Many-To-One relationship.
| Property | Value |
|---|---|
| ReferencingEntity | mailboxtrackingfolder |
| ReferencingAttribute | regardingobjectid |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | salesorderdetail_MailboxTrackingFolders |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
SalesOrderDetail_ProcessSessions
Added by: System Solution Solution
Same as processsession entity SalesOrderDetail_ProcessSessions Many-To-One relationship.
| Property | Value |
|---|---|
| ReferencingEntity | processsession |
| ReferencingAttribute | regardingobjectid |
| IsHierarchical | False |
| IsCustomizable | False |
| ReferencedEntityNavigationPropertyName | SalesOrderDetail_ProcessSessions |
| AssociatedMenuConfiguration | Behavior: UseCollectionName Group: Details Label: Order: 110 |
| CascadeConfiguration | Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
SalesOrderDetail_BulkDeleteFailures
Added by: System Solution Solution
Same as bulkdeletefailure entity SalesOrderDetail_BulkDeleteFailures Many-To-One relationship.
| Property | Value |
|---|---|
| ReferencingEntity | bulkdeletefailure |
| ReferencingAttribute | regardingobjectid |
| IsHierarchical | False |
| IsCustomizable | False |
| ReferencedEntityNavigationPropertyName | SalesOrderDetail_BulkDeleteFailures |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
salesorderdetail_principalobjectattributeaccess
Added by: System Solution Solution
Same as principalobjectattributeaccess entity salesorderdetail_principalobjectattributeaccess Many-To-One relationship.
| Property | Value |
|---|---|
| ReferencingEntity | principalobjectattributeaccess |
| ReferencingAttribute | objectid |
| IsHierarchical | False |
| IsCustomizable | False |
| ReferencedEntityNavigationPropertyName | salesorderdetail_principalobjectattributeaccess |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
SalesOrderDetail_Dynamicpropertyinstance
Same as dynamicpropertyinstance entity SalesOrderDetail_Dynamicpropertyinstance Many-To-One relationship.
| Property | Value |
|---|---|
| ReferencingEntity | dynamicpropertyinstance |
| ReferencingAttribute | regardingobjectid |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | SalesOrderDetail_Dynamicpropertyinstance |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: Cascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: Cascade Unshare: NoCascade |
salesorderdetail_parent_salesorderdetail
Same as salesorderdetail entity salesorderdetail_parent_salesorderdetail Many-To-One relationship.
| Property | Value |
|---|---|
| ReferencingEntity | salesorderdetail |
| ReferencingAttribute | parentbundleid |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | salesorderdetail_parent_salesorderdetail |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
msdyn_salesorderdetail_invoicedetail
Added by: Sales Patch Solution
Same as invoicedetail entity msdyn_salesorderdetail_invoicedetail Many-To-One relationship.
| Property | Value |
|---|---|
| ReferencingEntity | invoicedetail |
| ReferencingAttribute | salesorderdetailid |
| IsHierarchical | False |
| IsCustomizable | False |
| ReferencedEntityNavigationPropertyName | msdyn_salesorderdetail_invoicedetail |
| AssociatedMenuConfiguration | Behavior: UseCollectionName Group: Details Label: Order: 10000 |
| CascadeConfiguration | Assign: NoCascade Delete: RemoveLink Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
salesorderdetail_parentref_salesorderdetail
Added by: Sales Patch Solution
Same as salesorderdetail entity salesorderdetail_parentref_salesorderdetail Many-To-One relationship.
| Property | Value |
|---|---|
| ReferencingEntity | salesorderdetail |
| ReferencingAttribute | parentbundleidref |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | salesorderdetail_parentref_salesorderdetail |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
msdyn_salesorderdetail_msdyn_actual
Added by: Project Service Automation Solution
Same as msdyn_actual entity msdyn_salesorderdetail_msdyn_actual Many-To-One relationship.
| Property | Value |
|---|---|
| ReferencingEntity | msdyn_actual |
| ReferencingAttribute | msdyn_salescontractlineid |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | msdyn_salesorderdetail_msdyn_actual |
| AssociatedMenuConfiguration | Behavior: UseCollectionName Group: Details Label: Order: 10000 |
| CascadeConfiguration | Assign: NoCascade Delete: RemoveLink Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
msdyn_salesorderdetail_msdyn_contractlineinvoic
Added by: Project Service Automation Solution
Same as msdyn_contractlineinvoiceschedule entity msdyn_salesorderdetail_msdyn_contractlineinvoic Many-To-One relationship.
| Property | Value |
|---|---|
| ReferencingEntity | msdyn_contractlineinvoiceschedule |
| ReferencingAttribute | msdyn_contractlineid |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | msdyn_salesorderdetail_msdyn_contractlineinvoic |
| AssociatedMenuConfiguration | Behavior: UseCollectionName Group: Details Label: Order: 10000 |
| CascadeConfiguration | Assign: NoCascade Delete: RemoveLink Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
msdyn_salesorderdetail_msdyn_contractlineschedu
Added by: Project Service Automation Solution
Same as msdyn_contractlinescheduleofvalue entity msdyn_salesorderdetail_msdyn_contractlineschedu Many-To-One relationship.
| Property | Value |
|---|---|
| ReferencingEntity | msdyn_contractlinescheduleofvalue |
| ReferencingAttribute | msdyn_contractlineid |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | msdyn_salesorderdetail_msdyn_contractlineschedu |
| AssociatedMenuConfiguration | Behavior: UseCollectionName Group: Details Label: Order: 10000 |
| CascadeConfiguration | Assign: Cascade Delete: Cascade Merge: NoCascade Reparent: Cascade Share: Cascade Unshare: Cascade |
msdyn_salesorderdetail_msdyn_fact
Added by: Project Service Automation Solution
Same as msdyn_fact entity msdyn_salesorderdetail_msdyn_fact Many-To-One relationship.
| Property | Value |
|---|---|
| ReferencingEntity | msdyn_fact |
| ReferencingAttribute | msdyn_salescontractlineid |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | msdyn_salesorderdetail_msdyn_fact |
| AssociatedMenuConfiguration | Behavior: UseCollectionName Group: Details Label: Order: 10000 |
| CascadeConfiguration | Assign: NoCascade Delete: RemoveLink Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
msdyn_salesorderdetail_msdyn_invoicelinetransac
Added by: Project Service Automation Solution
Same as msdyn_invoicelinetransaction entity msdyn_salesorderdetail_msdyn_invoicelinetransac Many-To-One relationship.
| Property | Value |
|---|---|
| ReferencingEntity | msdyn_invoicelinetransaction |
| ReferencingAttribute | msdyn_salescontractlineid |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | msdyn_salesorderdetail_msdyn_invoicelinetransac |
| AssociatedMenuConfiguration | Behavior: UseCollectionName Group: Details Label: Order: 10000 |
| CascadeConfiguration | Assign: NoCascade Delete: RemoveLink Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
msdyn_salesorderdetail_msdyn_journalline
Added by: Project Service Automation Solution
Same as msdyn_journalline entity msdyn_salesorderdetail_msdyn_journalline Many-To-One relationship.
| Property | Value |
|---|---|
| ReferencingEntity | msdyn_journalline |
| ReferencingAttribute | msdyn_salescontractlineid |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | msdyn_salesorderdetail_msdyn_journalline |
| AssociatedMenuConfiguration | Behavior: UseCollectionName Group: Details Label: Order: 10000 |
| CascadeConfiguration | Assign: NoCascade Delete: RemoveLink Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
msdyn_salesorderdetail_msdyn_orderlineresourcec
Added by: Project Service Automation Solution
Same as msdyn_orderlineresourcecategory entity msdyn_salesorderdetail_msdyn_orderlineresourcec Many-To-One relationship.
| Property | Value |
|---|---|
| ReferencingEntity | msdyn_orderlineresourcecategory |
| ReferencingAttribute | msdyn_contractlineid |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | msdyn_salesorderdetail_msdyn_orderlineresourcec |
| AssociatedMenuConfiguration | Behavior: UseCollectionName Group: Details Label: Order: 10000 |
| CascadeConfiguration | Assign: NoCascade Delete: RemoveLink Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
msdyn_salesorderdetail_msdyn_orderlinetransacti
Added by: Project Service Automation Solution
Same as msdyn_orderlinetransaction entity msdyn_salesorderdetail_msdyn_orderlinetransacti Many-To-One relationship.
| Property | Value |
|---|---|
| ReferencingEntity | msdyn_orderlinetransaction |
| ReferencingAttribute | msdyn_salescontractlineid |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | msdyn_salesorderdetail_msdyn_orderlinetransacti |
| AssociatedMenuConfiguration | Behavior: UseCollectionName Group: Details Label: Order: 10000 |
| CascadeConfiguration | Assign: Cascade Delete: Cascade Merge: NoCascade Reparent: Cascade Share: Cascade Unshare: Cascade |
msdyn_salesorderdetail_msdyn_orderlinetranscat
Added by: Project Service Automation Solution
Same as msdyn_orderlinetransactioncategory entity msdyn_salesorderdetail_msdyn_orderlinetranscat Many-To-One relationship.
| Property | Value |
|---|---|
| ReferencingEntity | msdyn_orderlinetransactioncategory |
| ReferencingAttribute | msdyn_contractlineid |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | msdyn_salesorderdetail_msdyn_orderlinetranscat |
| AssociatedMenuConfiguration | Behavior: UseCollectionName Group: Details Label: Order: 10000 |
| CascadeConfiguration | Assign: NoCascade Delete: RemoveLink Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
msdyn_salesorderdetail_msdyn_orderlinetransclas
Added by: Project Service Automation Solution
Same as msdyn_orderlinetransactionclassification entity msdyn_salesorderdetail_msdyn_orderlinetransclas Many-To-One relationship.
| Property | Value |
|---|---|
| ReferencingEntity | msdyn_orderlinetransactionclassification |
| ReferencingAttribute | msdyn_contractlineid |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | msdyn_salesorderdetail_msdyn_orderlinetransclas |
| AssociatedMenuConfiguration | Behavior: UseCollectionName Group: Details Label: Order: 10000 |
| CascadeConfiguration | Assign: Cascade Delete: Cascade Merge: NoCascade Reparent: Cascade Share: Cascade Unshare: Cascade |
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_salesorderdetailbase_createdby
- lk_salesorderdetail_createdonbehalfby
- lk_salesorderdetailbase_modifiedby
- lk_salesorderdetail_modifiedonbehalfby
- user_salesorderdetail
- team_salesorderdetail
- transactioncurrency_salesorderdetail
- product_order_details
- order_details
- salesorderdetail_parent_salesorderdetail
- system_user_salesorderdetail
- unit_of_measurement_order_details
- productAssociation_salesorder_details
- msdyn_quotedetail_salesorderdetail
- salesorderdetail_parentref_salesorderdetail
- msdyn_msdyn_invoicefrequency_salesorderdetail_invoicefrequency
- msdyn_msdyn_project_salesorderdetail_Project
- msdyn_msdyn_agreement_salesorderdetail_Agreement
lk_salesorderdetailbase_createdby
Added by: System Solution Solution
See systemuser Entity lk_salesorderdetailbase_createdby One-To-Many relationship.
lk_salesorderdetail_createdonbehalfby
Added by: System Solution Solution
See systemuser Entity lk_salesorderdetail_createdonbehalfby One-To-Many relationship.
lk_salesorderdetailbase_modifiedby
Added by: System Solution Solution
See systemuser Entity lk_salesorderdetailbase_modifiedby One-To-Many relationship.
lk_salesorderdetail_modifiedonbehalfby
Added by: System Solution Solution
See systemuser Entity lk_salesorderdetail_modifiedonbehalfby One-To-Many relationship.
user_salesorderdetail
Added by: System Solution Solution
See systemuser Entity user_salesorderdetail One-To-Many relationship.
team_salesorderdetail
Added by: System Solution Solution
See team Entity team_salesorderdetail One-To-Many relationship.
transactioncurrency_salesorderdetail
Added by: System Solution Solution
See transactioncurrency Entity transactioncurrency_salesorderdetail One-To-Many relationship.
product_order_details
Added by: Product Management Solution
See product Entity product_order_details One-To-Many relationship.
order_details
See salesorder Entity order_details One-To-Many relationship.
salesorderdetail_parent_salesorderdetail
See salesorderdetail Entity salesorderdetail_parent_salesorderdetail One-To-Many relationship.
system_user_salesorderdetail
Added by: System Solution Solution
See systemuser Entity system_user_salesorderdetail One-To-Many relationship.
unit_of_measurement_order_details
Added by: Product Management Solution
See uom Entity unit_of_measurement_order_details One-To-Many relationship.
productAssociation_salesorder_details
Added by: Product Management Solution
See productassociation Entity productAssociation_salesorder_details One-To-Many relationship.
msdyn_quotedetail_salesorderdetail
See quotedetail Entity msdyn_quotedetail_salesorderdetail One-To-Many relationship.
salesorderdetail_parentref_salesorderdetail
See salesorderdetail Entity salesorderdetail_parentref_salesorderdetail One-To-Many relationship.
msdyn_msdyn_invoicefrequency_salesorderdetail_invoicefrequency
Added by: Project Service Automation Solution
See msdyn_invoicefrequency Entity msdyn_msdyn_invoicefrequency_salesorderdetail_invoicefrequency One-To-Many relationship.
msdyn_msdyn_project_salesorderdetail_Project
Added by: Project Service Automation Solution
See msdyn_project Entity msdyn_msdyn_project_salesorderdetail_Project One-To-Many relationship.
msdyn_msdyn_agreement_salesorderdetail_Agreement
Added by: Field Service Solution
See msdyn_agreement Entity msdyn_msdyn_agreement_salesorderdetail_Agreement One-To-Many relationship.
See also
About the Entity Reference
Programming reference for Dynamics 365 Customer Engagement
Web API Reference
Microsoft.Dynamics.CRM.salesorderdetail
Commentaires
Envoyer et afficher des commentaires pour