Order Product (SalesOrderDetail) entity reference
Line item in a sales order.
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 | SalesOrderDetails |
| DisplayCollectionName | Order Products |
| DisplayName | Order Product |
| 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
- 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
- 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 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 order 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 order. |
| 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 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 |
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 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 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 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 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 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 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 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
- ManualDiscountAmount_Base
- ModifiedBy
- ModifiedByName
- ModifiedByYomiName
- ModifiedOn
- ModifiedOnBehalfBy
- ModifiedOnBehalfByName
- ModifiedOnBehalfByYomiName
- 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 |
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 Choices/Options
| Value | Label | Description |
|---|---|---|
| 1 | Yes | |
| 0 | No |
DefaultValue: 0
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 Choices/Options
| Value | Label | Description |
|---|
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
SalesOrderDetail_SyncErrors
Added by: System Solution Solution
Same as the SalesOrderDetail_SyncErrors many-to-one relationship for the syncerror entity.
| 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 the SalesOrderDetail_AsyncOperations many-to-one relationship for the asyncoperation entity.
| 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 the salesorderdetail_MailboxTrackingFolders many-to-one relationship for the mailboxtrackingfolder entity.
| 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 the SalesOrderDetail_ProcessSessions many-to-one relationship for the processsession entity.
| 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 the SalesOrderDetail_BulkDeleteFailures many-to-one relationship for the bulkdeletefailure entity.
| 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 the salesorderdetail_principalobjectattributeaccess many-to-one relationship for the principalobjectattributeaccess entity.
| 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 the SalesOrderDetail_Dynamicpropertyinstance many-to-one relationship for the dynamicpropertyinstance entity.
| 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 the salesorderdetail_parent_salesorderdetail many-to-one relationship for the salesorderdetail entity.
| 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 the msdyn_salesorderdetail_invoicedetail many-to-one relationship for the invoicedetail entity.
| 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 the salesorderdetail_parentref_salesorderdetail many-to-one relationship for the salesorderdetail entity.
| 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 |
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
lk_salesorderdetailbase_createdby
Added by: System Solution Solution
See the lk_salesorderdetailbase_createdby one-to-many relationship for the systemuser entity.
lk_salesorderdetail_createdonbehalfby
Added by: System Solution Solution
See the lk_salesorderdetail_createdonbehalfby one-to-many relationship for the systemuser entity.
lk_salesorderdetailbase_modifiedby
Added by: System Solution Solution
See the lk_salesorderdetailbase_modifiedby one-to-many relationship for the systemuser entity.
lk_salesorderdetail_modifiedonbehalfby
Added by: System Solution Solution
See the lk_salesorderdetail_modifiedonbehalfby one-to-many relationship for the systemuser entity.
user_salesorderdetail
Added by: System Solution Solution
See the user_salesorderdetail one-to-many relationship for the systemuser entity.
team_salesorderdetail
Added by: System Solution Solution
See the team_salesorderdetail one-to-many relationship for the team entity.
transactioncurrency_salesorderdetail
Added by: System Solution Solution
See the transactioncurrency_salesorderdetail one-to-many relationship for the transactioncurrency entity.
product_order_details
Added by: Product Management Solution
See the product_order_details one-to-many relationship for the product entity.
order_details
See the order_details one-to-many relationship for the salesorder entity.
salesorderdetail_parent_salesorderdetail
See the salesorderdetail_parent_salesorderdetail one-to-many relationship for the salesorderdetail entity.
system_user_salesorderdetail
Added by: System Solution Solution
See the system_user_salesorderdetail one-to-many relationship for the systemuser entity.
unit_of_measurement_order_details
Added by: Product Management Solution
See the unit_of_measurement_order_details one-to-many relationship for the uom entity.
productAssociation_salesorder_details
Added by: Product Management Solution
See the productAssociation_salesorder_details one-to-many relationship for the productassociation entity.
msdyn_quotedetail_salesorderdetail
See the msdyn_quotedetail_salesorderdetail one-to-many relationship for the quotedetail entity.
salesorderdetail_parentref_salesorderdetail
See the salesorderdetail_parentref_salesorderdetail one-to-many relationship for the salesorderdetail entity.