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.
See also
Commentaires
https://aka.ms/ContentUserFeedback.
Bientôt disponible : Tout au long de 2024, nous allons supprimer progressivement GitHub Issues comme mécanisme de commentaires pour le contenu et le remplacer par un nouveau système de commentaires. Pour plus d’informations, consultezEnvoyer et afficher des commentaires pour