SalesOrder Entity Reference
Quote that has been accepted.
Added by: Sales Solution
Messages
Message | Web API Operation | SDK Assembly |
---|---|---|
Assign | PATCH [org URI]/api/data/v9.0/salesorders(salesorderid) Update ownerid property. |
AssignRequest |
Associate | Associate and disassociate entities | AssociateRequest or Associate |
CalculatePrice | CalculatePrice Action | CalculatePriceRequest |
CancelContract | Microsoft.Dynamics.CRM.CancelContract | CancelContractRequest |
CancelSalesOrder | Microsoft.Dynamics.CRM.CancelSalesOrder | CancelSalesOrderRequest |
ConvertSalesOrderToInvoice | Microsoft.Dynamics.CRM.ConvertSalesOrderToInvoice | ConvertSalesOrderToInvoiceRequest |
Create | POST [org URI]/api/data/v9.0/salesorders See Create |
CreateRequest or Create |
Delete | DELETE [org URI]/api/data/v9.0/salesorders(salesorderid) See Delete |
DeleteRequest or Delete |
Disassociate | Associate and disassociate entities | DisassociateRequest or Disassociate |
FulfillSalesOrder | Microsoft.Dynamics.CRM.FulfillSalesOrder | FulfillSalesOrderRequest |
GenerateSalesOrderFromOpportunity | Microsoft.Dynamics.CRM.GenerateSalesOrderFromOpportunity | GenerateSalesOrderFromOpportunityRequest |
GetQuantityDecimal | Microsoft.Dynamics.CRM.GetQuantityDecimal | GetQuantityDecimalRequest |
GetSalesOrderProductsFromOpportunity | Microsoft.Dynamics.CRM.GetSalesOrderProductsFromOpportunity | GetSalesOrderProductsFromOpportunityRequest |
GrantAccess | GrantAccess Action | GrantAccessRequest |
LockSalesOrderPricing | Microsoft.Dynamics.CRM.LockSalesOrderPricing | LockSalesOrderPricingRequest |
ModifyAccess | ModifyAccess Action | ModifyAccessRequest |
msdyn_CreateContractSpecificPriceList | Microsoft.Dynamics.CRM.msdyn_CreateContractSpecificPriceList | Type generated by CrmSvcUtil.exe or use OrganizationRequest setting the required parameters for the message. |
msdyn_createinvoicefrominvoiceschedule | Microsoft.Dynamics.CRM.msdyn_createinvoicefrominvoiceschedule | Type generated by CrmSvcUtil.exe or use OrganizationRequest setting the required parameters for the message. |
msdyn_GetContractBillingRadialGaugeData | Microsoft.Dynamics.CRM.msdyn_GetContractBillingRadialGaugeData | Type generated by CrmSvcUtil.exe or use OrganizationRequest setting the required parameters for the message. |
msdyn_GetContractDetailedTransactions | Microsoft.Dynamics.CRM.msdyn_GetContractDetailedTransactions | Type generated by CrmSvcUtil.exe or use OrganizationRequest setting the required parameters for the message. |
msdyn_GetContractEffortRadialGaugeData | Microsoft.Dynamics.CRM.msdyn_GetContractEffortRadialGaugeData | Type generated by CrmSvcUtil.exe or use OrganizationRequest setting the required parameters for the message. |
msdyn_GetContractLines | Microsoft.Dynamics.CRM.msdyn_GetContractLines | Type generated by CrmSvcUtil.exe or use OrganizationRequest setting the required parameters for the message. |
msdyn_GetProjectsForContract | Microsoft.Dynamics.CRM.msdyn_GetProjectsForContract | Type generated by CrmSvcUtil.exe or use OrganizationRequest setting the required parameters for the message. |
msdyn_NewInvoiceContract | Microsoft.Dynamics.CRM.msdyn_NewInvoiceContract | Type generated by CrmSvcUtil.exe or use OrganizationRequest setting the required parameters for the message. |
msdyn_ProjectServiceCreateInvoiceAsynchronous | Microsoft.Dynamics.CRM.msdyn_ProjectServiceCreateInvoiceAsynchronous | Type generated by CrmSvcUtil.exe or use OrganizationRequest setting the required parameters for the message. |
msdyn_UpdateProjectContractLineDetailPrices | Microsoft.Dynamics.CRM.msdyn_UpdateProjectContractLineDetailPrices | Type generated by CrmSvcUtil.exe or use OrganizationRequest setting the required parameters for the message. |
Retrieve | GET [org URI]/api/data/v9.0/salesorders(salesorderid) See Retrieve |
RetrieveRequest or Retrieve |
RetrieveMultiple | GET [org URI]/api/data/v9.0/salesorders See Query Data |
RetrieveMultipleRequest or RetrieveMultiple |
RetrievePrincipalAccess | RetrievePrincipalAccess Function | RetrievePrincipalAccessRequest |
RetrieveSharedPrincipalsAndAccess | RetrieveSharedPrincipalsAndAccess Function | RetrieveSharedPrincipalsAndAccessRequest |
RevokeAccess | RevokeAccess Action | RevokeAccessRequest |
Rollup | Rollup Function | RollupRequest |
SetState | PATCH [org URI]/api/data/v9.0/salesorders(salesorderid) Update statecode and statuscode properties. |
SetStateRequest |
Update | PATCH [org URI]/api/data/v9.0/salesorders(salesorderid) See Update |
UpdateRequest or Update |
Entity Properties
Property | Value |
---|---|
CollectionSchemaName | SalesOrders |
DisplayCollectionName | Orders |
DisplayName | Order |
EntitySetName | salesorders |
IsBPFEntity | False |
LogicalCollectionName | salesorders |
LogicalName | salesorder |
OwnershipType | UserOwned |
PrimaryIdAttribute | salesorderid |
PrimaryNameAttribute | name |
SchemaName | SalesOrder |
Writable attributes
These attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.
- BillTo_AddressId
- BillTo_City
- BillTo_ContactName
- BillTo_Country
- BillTo_Fax
- BillTo_Line1
- BillTo_Line2
- BillTo_Line3
- BillTo_Name
- BillTo_PostalCode
- BillTo_StateOrProvince
- BillTo_Telephone
- CampaignId
- CustomerId
- CustomerIdType
- DateFulfilled
- Description
- DiscountAmount
- DiscountPercentage
- EmailAddress
- EntityImage
- FreightAmount
- FreightTermsCode
- ImportSequenceNumber
- IsPriceLocked
- LastBackofficeSubmit
- LastOnHoldTime
- msdyn_Account
- msdyn_AccountManagerId
- msdyn_ContractOrganizationalUnitId
- msdyn_ordertype
- msdyn_PSAState
- msdyn_PSAStatusReason
- Name
- OpportunityId
- OrderNumber
- OverriddenCreatedOn
- OwnerId
- OwnerIdType
- PaymentTermsCode
- PriceLevelId
- PricingErrorCode
- PriorityCode
- ProcessId
- QuoteId
- RequestDeliveryBy
- SalesOrderId
- ShippingMethodCode
- 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
- SLAId
- StageId
- StateCode
- StatusCode
- SubmitDate
- SubmitStatus
- SubmitStatusDescription
- TimeZoneRuleVersionNumber
- TotalAmount
- TotalAmountLessFreight
- TotalDiscountAmount
- TotalLineItemAmount
- TotalLineItemDiscountAmount
- TotalTax
- TransactionCurrencyId
- TraversedPath
- UTCConversionTimeZoneCode
- WillCall
BillTo_AddressId
Property | Value |
---|---|
Description | Unique identifier of the billing address. |
DisplayName | Bill To Address ID |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | billto_addressid |
RequiredLevel | None |
Type | Uniqueidentifier |
BillTo_City
Property | Value |
---|---|
Description | Type the city for the customer's billing address. |
DisplayName | Bill To City |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | billto_city |
MaxLength | 80 |
RequiredLevel | None |
Type | String |
BillTo_ContactName
Property | Value |
---|---|
Description | Type the primary contact name at the customer's billing address. |
DisplayName | Bill To Contact Name |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | billto_contactname |
MaxLength | 150 |
RequiredLevel | None |
Type | String |
BillTo_Country
Property | Value |
---|---|
Description | Type the country or region for the customer's billing address. |
DisplayName | Bill To Country/Region |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | billto_country |
MaxLength | 80 |
RequiredLevel | None |
Type | String |
BillTo_Fax
Property | Value |
---|---|
Description | Type the fax number for the customer's billing address. |
DisplayName | Bill To Fax |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | billto_fax |
MaxLength | 50 |
RequiredLevel | None |
Type | String |
BillTo_Line1
Property | Value |
---|---|
Description | Type the first line of the customer's billing address. |
DisplayName | Bill To Street 1 |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | billto_line1 |
MaxLength | 250 |
RequiredLevel | None |
Type | String |
BillTo_Line2
Property | Value |
---|---|
Description | Type the second line of the customer's billing address. |
DisplayName | Bill To Street 2 |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | billto_line2 |
MaxLength | 250 |
RequiredLevel | None |
Type | String |
BillTo_Line3
Property | Value |
---|---|
Description | Type the third line of the billing address. |
DisplayName | Bill To Street 3 |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | billto_line3 |
MaxLength | 250 |
RequiredLevel | None |
Type | String |
BillTo_Name
Property | Value |
---|---|
Description | Type a name for the customer's billing address, such as "Headquarters" or "Field office", to identify the address. |
DisplayName | Bill To Name |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | billto_name |
MaxLength | 200 |
RequiredLevel | None |
Type | String |
BillTo_PostalCode
Property | Value |
---|---|
Description | Type the ZIP Code or postal code for the billing address. |
DisplayName | Bill To ZIP/Postal Code |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | billto_postalcode |
MaxLength | 20 |
RequiredLevel | None |
Type | String |
BillTo_StateOrProvince
Property | Value |
---|---|
Description | Type the state or province for the billing address. |
DisplayName | Bill To State/Province |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | billto_stateorprovince |
MaxLength | 50 |
RequiredLevel | None |
Type | String |
BillTo_Telephone
Property | Value |
---|---|
Description | Type the phone number for the customer's billing address. |
DisplayName | Bill To Phone |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | billto_telephone |
MaxLength | 50 |
RequiredLevel | None |
Type | String |
CampaignId
Added by: Marketing Sales Solution
Property | Value |
---|---|
Description | Shows the campaign that the order was created from. |
DisplayName | Source Campaign |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | campaignid |
RequiredLevel | None |
Targets | campaign |
Type | Lookup |
CustomerId
Property | Value |
---|---|
Description | Select the customer account or contact to provide a quick link to additional customer details, such as account information, activities, and opportunities. |
DisplayName | Customer |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | customerid |
RequiredLevel | ApplicationRequired |
Targets | account,contact |
Type | Customer |
CustomerIdType
Added by: Active Solution Solution
Property | Value |
---|---|
Description | |
DisplayName | Customer Type |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | customeridtype |
RequiredLevel | ApplicationRequired |
Type | EntityName |
DateFulfilled
Property | Value |
---|---|
DateTimeBehavior | UserLocal |
Description | Enter the date that all or part of the order was shipped to the customer. |
DisplayName | Date Fulfilled |
Format | DateOnly |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | datefulfilled |
RequiredLevel | None |
Type | DateTime |
Description
Property | Value |
---|---|
Description | Type additional information to describe the order, such as the products or services offered or details about the customer's product preferences. |
DisplayName | Description |
Format | Text |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | description |
MaxLength | 2000 |
RequiredLevel | None |
Type | Memo |
DiscountAmount
Property | Value |
---|---|
Description | Type the discount amount for the order if the customer is eligible for special savings. |
DisplayName | Order Discount Amount |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | discountamount |
MaxValue | 1000000000000 |
MinValue | 0 |
Precision | 2 |
PrecisionSource | 2 |
RequiredLevel | None |
Type | Money |
DiscountPercentage
Property | Value |
---|---|
Description | Type the discount rate that should be applied to the Detail Amount field to include additional savings for the customer in the order. |
DisplayName | Order Discount (%) |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | discountpercentage |
MaxValue | 100 |
MinValue | 0 |
Precision | 2 |
RequiredLevel | None |
Type | Decimal |
EmailAddress
Property | Value |
---|---|
Description | The primary email address for the entity. |
DisplayName | Email Address |
FormatName | |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | emailaddress |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
EntityImage
Added by: Active Solution Solution
Property | Value |
---|---|
Description | The default image for the entity. |
DisplayName | Entity Image |
IsPrimaryImage | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | entityimage |
MaxHeight | 144 |
MaxWidth | 144 |
RequiredLevel | None |
Type | Image |
FreightAmount
Property | Value |
---|---|
Description | Type the cost of freight or shipping for the products included in the order for use in calculating the Total Amount field. |
DisplayName | Freight Amount |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | freightamount |
MaxValue | 1000000000000 |
MinValue | 0 |
Precision | 2 |
PrecisionSource | 2 |
RequiredLevel | None |
Type | Money |
FreightTermsCode
Property | Value |
---|---|
Description | Select the freight terms to make sure shipping charges are processed correctly. |
DisplayName | Freight Terms |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | freighttermscode |
RequiredLevel | None |
Type | Picklist |
FreightTermsCode Options
Value | Label |
---|---|
1 | FOB |
2 | No Charge |
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 |
IsPriceLocked
Property | Value |
---|---|
Description | Select whether prices specified on the invoice are locked from any further updates. |
DisplayName | Prices Locked |
IsValidForCreate | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | ispricelocked |
RequiredLevel | ApplicationRequired |
Type | Boolean |
IsPriceLocked Options
Value | Label |
---|---|
1 | Yes |
0 | No |
DefaultValue: False
LastBackofficeSubmit
Property | Value |
---|---|
DateTimeBehavior | UserLocal |
Description | Enter the date and time when the order was last submitted to an accounting or ERP system for processing. |
DisplayName | Last Submitted to Back Office |
Format | DateOnly |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | lastbackofficesubmit |
RequiredLevel | None |
Type | DateTime |
LastOnHoldTime
Property | Value |
---|---|
DateTimeBehavior | UserLocal |
Description | Contains the date time stamp of the last on hold time. |
DisplayName | Last On Hold Time |
Format | DateAndTime |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | lastonholdtime |
RequiredLevel | None |
Type | DateTime |
msdyn_Account
Added by: Field Service Solution
Property | Value |
---|---|
Description | Customer Account associated with this Order |
DisplayName | Potential Customer |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | msdyn_account |
RequiredLevel | None |
Targets | account |
Type | Lookup |
msdyn_AccountManagerId
Added by: Project Service Automation Solution
Property | Value |
---|---|
Description | User responsible for managing the account referenced by this contract. |
DisplayName | Account Manager |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | msdyn_accountmanagerid |
RequiredLevel | Recommended |
Targets | systemuser |
Type | Lookup |
msdyn_ContractOrganizationalUnitId
Added by: Project Service Automation Solution
Property | Value |
---|---|
Description | Organizational unit responsible for this contract. |
DisplayName | Contracting Unit |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | msdyn_contractorganizationalunitid |
RequiredLevel | Recommended |
Targets | msdyn_organizationalunit |
Type | Lookup |
msdyn_ordertype
Added by: Project Service Automation Solution
Property | Value |
---|---|
Description | Internal use only |
DisplayName | Order Type |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | msdyn_ordertype |
RequiredLevel | Recommended |
Type | Picklist |
msdyn_ordertype Options
Value | Label |
---|---|
192350000 | Item based |
192350001 | Work based |
690970002 | Service-Maintenance Based |
msdyn_PSAState
Added by: Project Service Automation Solution
Property | Value |
---|---|
Description | Shows the current state of the project contract. |
DisplayName | Contract Status |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | msdyn_psastate |
RequiredLevel | ApplicationRequired |
Type | Picklist |
msdyn_PSAState Options
Value | Label |
---|---|
192350000 | Draft |
192350001 | On hold |
192350002 | Active |
192350003 | Closed |
msdyn_PSAStatusReason
Added by: Project Service Automation Solution
Property | Value |
---|---|
Description | Shows the reason for the project contract status. |
DisplayName | Contract Status Reason |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | msdyn_psastatusreason |
RequiredLevel | ApplicationRequired |
Type | Picklist |
msdyn_PSAStatusReason Options
Value | Label |
---|---|
192350000 | Draft |
192350001 | In review |
192350002 | On hold |
192350003 | Confirmed |
192350004 | Completed |
192350005 | Lost |
192350006 | Abandoned |
Name
Property | Value |
---|---|
Description | Type a descriptive name for the order. |
DisplayName | Name |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | name |
MaxLength | 300 |
RequiredLevel | ApplicationRequired |
Type | String |
OpportunityId
Property | Value |
---|---|
Description | Choose the related opportunity so that the data for the order and opportunity are linked for reporting and analytics. |
DisplayName | Opportunity |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | opportunityid |
RequiredLevel | None |
Targets | opportunity |
Type | Lookup |
OrderNumber
Property | Value |
---|---|
Description | Shows the order number for customer reference and to use in search. The number cannot be modified. |
DisplayName | Order ID |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
IsValidForUpdate | False |
LogicalName | ordernumber |
MaxLength | 100 |
RequiredLevel | SystemRequired |
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 |
OwnerId
Property | Value |
---|---|
Description | Owner Id |
DisplayName | Owner |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | ownerid |
RequiredLevel | SystemRequired |
Targets | systemuser,team |
Type | Owner |
OwnerIdType
Added by: Active Solution Solution
Property | Value |
---|---|
Description | Owner Id Type |
DisplayName | |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owneridtype |
RequiredLevel | SystemRequired |
Type | EntityName |
PaymentTermsCode
Property | Value |
---|---|
Description | Select the payment terms to indicate when the customer needs to pay the total amount. |
DisplayName | Payment Terms |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | paymenttermscode |
RequiredLevel | None |
Type | Picklist |
PaymentTermsCode Options
Value | Label |
---|---|
1 | Net 30 |
2 | 2% 10, Net 30 |
3 | Net 45 |
4 | Net 60 |
PriceLevelId
Property | Value |
---|---|
Description | Choose the price list associated with this record to make sure the products associated with the campaign are offered at the correct prices. |
DisplayName | Price List |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | pricelevelid |
RequiredLevel | ApplicationRequired |
Targets | pricelevel |
Type | Lookup |
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 |
PriorityCode
Property | Value |
---|---|
Description | Select the priority so that preferred customers or critical issues are handled quickly. |
DisplayName | Priority |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | prioritycode |
RequiredLevel | None |
Type | Picklist |
PriorityCode Options
Value | Label |
---|---|
1 | Default Value |
ProcessId
Property | Value |
---|---|
Description | Contains the id of the process associated with the entity. |
DisplayName | Process Id |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | processid |
RequiredLevel | None |
Type | Uniqueidentifier |
QuoteId
Property | Value |
---|---|
Description | Choose the related quote so that order data and quote data are linked for reporting and analytics. |
DisplayName | Quote |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | quoteid |
RequiredLevel | None |
Targets | quote |
Type | Lookup |
RequestDeliveryBy
Property | Value |
---|---|
DateTimeBehavior | UserLocal |
Description | Enter the delivery date requested by the customer for all products in the order. |
DisplayName | Requested Delivery Date |
Format | DateOnly |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | requestdeliveryby |
RequiredLevel | None |
Type | DateTime |
SalesOrderId
Property | Value |
---|---|
Description | Unique identifier of the order. |
DisplayName | Order |
IsValidForForm | False |
IsValidForRead | True |
IsValidForUpdate | False |
LogicalName | salesorderid |
RequiredLevel | SystemRequired |
Type | Uniqueidentifier |
ShippingMethodCode
Property | Value |
---|---|
Description | Select a shipping method for deliveries sent to this address. |
DisplayName | Shipping Method |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | shippingmethodcode |
RequiredLevel | None |
Type | Picklist |
ShippingMethodCode Options
Value | Label |
---|---|
1 | Airborne |
2 | DHL |
3 | FedEx |
4 | UPS |
5 | Postal Mail |
6 | Full Load |
7 | Will Call |
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 | Ship To Freight Terms |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | shipto_freighttermscode |
RequiredLevel | None |
Type | Picklist |
ShipTo_FreightTermsCode Options
Value | Label |
---|---|
1 | Default Value |
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 |
SLAId
Property | Value |
---|---|
Description | Choose the service level agreement (SLA) that you want to apply to the sales order record. |
DisplayName | SLA |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | slaid |
RequiredLevel | None |
Targets | sla |
Type | Lookup |
StageId
Property | Value |
---|---|
Description | Contains the id of the stage where the entity is located. |
DisplayName | (Deprecated) Stage Id |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | stageid |
RequiredLevel | None |
Type | Uniqueidentifier |
StateCode
Property | Value |
---|---|
Description | Shows whether the order is active, submitted, fulfilled, canceled, or invoiced. Only active orders can be edited. |
DisplayName | Status |
IsValidForCreate | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | statecode |
RequiredLevel | SystemRequired |
Type | State |
StateCode Options
Value | Label | DefaultStatus | InvariantName |
---|---|---|---|
0 | Active | 1 | Active |
1 | Submitted | 3 | Submitted |
2 | Canceled | 4 | Canceled |
3 | Fulfilled | 100001 | Fulfilled |
4 | Invoiced | 100003 | Invoiced |
StatusCode
Property | Value |
---|---|
Description | Select the order's status. |
DisplayName | Status Reason |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | statuscode |
RequiredLevel | None |
Type | Status |
StatusCode Options
Value | Label | State |
---|---|---|
1 | New | 0 |
2 | Pending | 0 |
3 | In Progress | 1 |
4 | No Money | 2 |
100001 | Complete | 3 |
100002 | Partial | 3 |
100003 | Invoiced | 4 |
690970000 | On hold | 0 |
SubmitDate
Property | Value |
---|---|
DateTimeBehavior | UserLocal |
Description | Enter the date when the order was submitted to the fulfillment or shipping center. |
DisplayName | Date Submitted |
Format | DateOnly |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | submitdate |
RequiredLevel | None |
Type | DateTime |
SubmitStatus
Property | Value |
---|---|
Description | Type the code for the submitted status in the fulfillment or shipping center system. |
DisplayName | Submitted Status |
Format | None |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | submitstatus |
MaxValue | 1000000000 |
MinValue | 0 |
RequiredLevel | None |
Type | Integer |
SubmitStatusDescription
Property | Value |
---|---|
Description | Type additional details or notes about the order for the fulfillment or shipping center. |
DisplayName | Submitted Status Description |
Format | Text |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | submitstatusdescription |
MaxLength | 2000 |
RequiredLevel | None |
Type | Memo |
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 |
TotalAmount
Property | Value |
---|---|
Description | Shows the total amount due, calculated as the sum of the products, discounts, freight, and taxes for the order. |
DisplayName | Total Amount |
IsValidForCreate | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | totalamount |
MaxValue | 922337203685477 |
MinValue | -922337203685477 |
Precision | 2 |
PrecisionSource | 2 |
RequiredLevel | None |
Type | Money |
TotalAmountLessFreight
Property | Value |
---|---|
Description | Shows the total product amount for the order, minus any discounts. This value is added to freight and tax amounts in the calculation for the total amount due for the order. |
DisplayName | Total Pre-Freight Amount |
IsValidForCreate | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | totalamountlessfreight |
MaxValue | 922337203685477 |
MinValue | -922337203685477 |
Precision | 2 |
PrecisionSource | 2 |
RequiredLevel | None |
Type | Money |
TotalDiscountAmount
Property | Value |
---|---|
Description | Shows the total discount amount, based on the discount price and rate entered on the order. |
DisplayName | Total Discount Amount |
IsValidForCreate | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | totaldiscountamount |
MaxValue | 922337203685477 |
MinValue | -922337203685477 |
Precision | 2 |
PrecisionSource | 2 |
RequiredLevel | None |
Type | Money |
TotalLineItemAmount
Property | Value |
---|---|
Description | Shows the sum of all existing and write-in products included on the order, based on the specified price list and quantities. |
DisplayName | Total Detail Amount |
IsValidForCreate | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | totallineitemamount |
MaxValue | 922337203685477 |
MinValue | -922337203685477 |
Precision | 2 |
PrecisionSource | 2 |
RequiredLevel | None |
Type | Money |
TotalLineItemDiscountAmount
Property | Value |
---|---|
Description | Shows the total of the Manual Discount amounts specified on all products included in the order. This value is reflected in the Detail Amount field on the order and is added to any discount amount or rate specified on the order. |
DisplayName | Total Line Item Discount Amount |
IsValidForCreate | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | totallineitemdiscountamount |
MaxValue | 922337203685477 |
MinValue | -922337203685477 |
Precision | 2 |
PrecisionSource | 2 |
RequiredLevel | None |
Type | Money |
TotalTax
Property | Value |
---|---|
Description | Shows the Tax amounts specified on all products included in the order, included in the Total Amount due calculation for the order. |
DisplayName | Total Tax |
IsValidForCreate | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | totaltax |
MaxValue | 922337203685477 |
MinValue | -922337203685477 |
Precision | 2 |
PrecisionSource | 2 |
RequiredLevel | None |
Type | Money |
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 | ApplicationRequired |
Targets | transactioncurrency |
Type | Lookup |
TraversedPath
Property | Value |
---|---|
Description | A comma separated list of string values representing the unique identifiers of stages in a Business Process Flow Instance in the order that they occur. |
DisplayName | (Deprecated) Traversed Path |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | traversedpath |
MaxLength | 1250 |
RequiredLevel | None |
Type | String |
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 products included in the order 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.
- AccountId
- AccountIdName
- AccountIdYomiName
- BillTo_Composite
- CampaignIdName
- ContactId
- ContactIdName
- ContactIdYomiName
- CreatedBy
- CreatedByName
- CreatedByYomiName
- CreatedOn
- CreatedOnBehalfBy
- CreatedOnBehalfByName
- CreatedOnBehalfByYomiName
- CustomerIdName
- CustomerIdYomiName
- DiscountAmount_Base
- EntityImage_Timestamp
- EntityImage_URL
- EntityImageId
- ExchangeRate
- FreightAmount_Base
- ModifiedBy
- ModifiedByName
- ModifiedByYomiName
- ModifiedOn
- ModifiedOnBehalfBy
- ModifiedOnBehalfByName
- ModifiedOnBehalfByYomiName
- msdyn_AccountManagerIdName
- msdyn_AccountManagerIdYomiName
- msdyn_AccountName
- msdyn_AccountYomiName
- msdyn_ContractOrganizationalUnitIdName
- msdyn_TotalChargeableCostRollup
- msdyn_totalchargeablecostrollup_Base
- msdyn_TotalChargeableCostRollup_Date
- msdyn_TotalChargeableCostRollup_State
- msdyn_TotalNonchargeableCostRollup
- msdyn_totalnonchargeablecostrollup_Base
- msdyn_TotalNonchargeableCostRollup_Date
- msdyn_TotalNonchargeableCostRollup_State
- OnHoldTime
- OpportunityIdName
- OwnerIdName
- OwnerIdYomiName
- OwningBusinessUnit
- OwningTeam
- OwningUser
- PriceLevelIdName
- QuoteIdName
- ShipTo_Composite
- SLAInvokedId
- SLAInvokedIdName
- SLAName
- TotalAmount_Base
- TotalAmountLessFreight_Base
- TotalDiscountAmount_Base
- TotalLineItemAmount_Base
- TotalLineItemDiscountAmount_Base
- TotalTax_Base
- TransactionCurrencyIdName
- VersionNumber
AccountId
Property | Value |
---|---|
Description | Shows the parent account related to the record. This information is used to link the sales order to the account selected in the Customer field for reporting and analytics. |
DisplayName | Account |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | accountid |
RequiredLevel | None |
Targets | account |
Type | Lookup |
AccountIdName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | accountidname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
AccountIdYomiName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | accountidyominame |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
BillTo_Composite
Property | Value |
---|---|
Description | Shows the complete Bill To address. |
DisplayName | Bill To Address |
Format | TextArea |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | billto_composite |
MaxLength | 1000 |
RequiredLevel | None |
Type | Memo |
CampaignIdName
Added by: Marketing Sales Solution
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | campaignidname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
ContactId
Property | Value |
---|---|
Description | Shows the parent contact related to the record. This information is used to link the contract to the contact selected in the Customer field for reporting and analytics. |
DisplayName | Contact |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | contactid |
RequiredLevel | None |
Targets | contact |
Type | Lookup |
ContactIdName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | contactidname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
ContactIdYomiName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | contactidyominame |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
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 |
CustomerIdName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | customeridname |
MaxLength | 160 |
RequiredLevel | ApplicationRequired |
Type | String |
CustomerIdYomiName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | customeridyominame |
MaxLength | 450 |
RequiredLevel | ApplicationRequired |
Type | String |
DiscountAmount_Base
Property | Value |
---|---|
Description | Value of the Order Discount Amount in base currency. |
DisplayName | Order Discount Amount (Base) |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | discountamount_base |
MaxValue | 922337203685477 |
MinValue | -922337203685477 |
Precision | 4 |
PrecisionSource | 2 |
RequiredLevel | None |
Type | Money |
EntityImage_Timestamp
Property | Value |
---|---|
Description | |
DisplayName | |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | entityimage_timestamp |
MaxValue | 9223372036854775807 |
MinValue | -9223372036854775808 |
RequiredLevel | None |
Type | BigInt |
EntityImage_URL
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Url |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | entityimage_url |
MaxLength | 200 |
RequiredLevel | None |
Type | String |
EntityImageId
Property | Value |
---|---|
Description | |
DisplayName | |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | entityimageid |
RequiredLevel | None |
Type | Uniqueidentifier |
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 |
FreightAmount_Base
Property | Value |
---|---|
Description | Value of the Freight Amount in base currency. |
DisplayName | Freight Amount (Base) |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | freightamount_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_AccountManagerIdName
Added by: Project Service Automation Solution
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | msdyn_accountmanageridname |
MaxLength | 200 |
RequiredLevel | None |
Type | String |
msdyn_AccountManagerIdYomiName
Added by: Project Service Automation Solution
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | msdyn_accountmanageridyominame |
MaxLength | 200 |
RequiredLevel | None |
Type | String |
msdyn_AccountName
Added by: Field Service Solution
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | msdyn_accountname |
MaxLength | 160 |
RequiredLevel | None |
Type | String |
msdyn_AccountYomiName
Added by: Field Service Solution
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | msdyn_accountyominame |
MaxLength | 160 |
RequiredLevel | None |
Type | String |
msdyn_ContractOrganizationalUnitIdName
Added by: Project Service Automation Solution
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | msdyn_contractorganizationalunitidname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
msdyn_TotalChargeableCostRollup
Added by: Project Service Automation Solution
Property | Value |
---|---|
Description | Value of the estimated chargeable cost. |
DisplayName | Total Chargeable Cost |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | msdyn_totalchargeablecostrollup |
MaxValue | 922337203685477 |
MinValue | -922337203685477 |
Precision | 4 |
PrecisionSource | 2 |
RequiredLevel | None |
Type | Money |
msdyn_totalchargeablecostrollup_Base
Added by: Project Service Automation Solution
Property | Value |
---|---|
Description | Value of the Total Chargeable Cost in base currency. |
DisplayName | Total Chargeable Cost (Base) |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | msdyn_totalchargeablecostrollup_base |
MaxValue | 922337203685477 |
MinValue | -922337203685477 |
Precision | 4 |
PrecisionSource | 2 |
RequiredLevel | None |
Type | Money |
msdyn_TotalChargeableCostRollup_Date
Added by: Active Solution Solution
Property | Value |
---|---|
DateTimeBehavior | UserLocal |
Description | Last Updated time of rollup field Total Chargeable Cost. |
DisplayName | Total Chargeable Cost (Last Updated On) |
Format | DateAndTime |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | msdyn_totalchargeablecostrollup_date |
RequiredLevel | None |
Type | DateTime |
msdyn_TotalChargeableCostRollup_State
Added by: Active Solution Solution
Property | Value |
---|---|
Description | State of rollup field Total Chargeable Cost. |
DisplayName | Total Chargeable Cost (State) |
Format | None |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | msdyn_totalchargeablecostrollup_state |
MaxValue | 2147483647 |
MinValue | -2147483648 |
RequiredLevel | None |
Type | Integer |
msdyn_TotalNonchargeableCostRollup
Added by: Project Service Automation Solution
Property | Value |
---|---|
Description | Total estimated cost that will not be charged to the customer. |
DisplayName | Total Non-chargeable Cost |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | msdyn_totalnonchargeablecostrollup |
MaxValue | 922337203685477 |
MinValue | -922337203685477 |
Precision | 4 |
PrecisionSource | 2 |
RequiredLevel | None |
Type | Money |
msdyn_totalnonchargeablecostrollup_Base
Added by: Project Service Automation Solution
Property | Value |
---|---|
Description | Value of the Total Non-chargeable Cost in base currency. |
DisplayName | Total Non-chargeable Cost (Base) |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | msdyn_totalnonchargeablecostrollup_base |
MaxValue | 922337203685477 |
MinValue | -922337203685477 |
Precision | 4 |
PrecisionSource | 2 |
RequiredLevel | None |
Type | Money |
msdyn_TotalNonchargeableCostRollup_Date
Added by: Active Solution Solution
Property | Value |
---|---|
DateTimeBehavior | UserLocal |
Description | Last Updated time of rollup field Total Non-chargeable Cost. |
DisplayName | Total Non-chargeable Cost (Last Updated On) |
Format | DateAndTime |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | msdyn_totalnonchargeablecostrollup_date |
RequiredLevel | None |
Type | DateTime |
msdyn_TotalNonchargeableCostRollup_State
Added by: Active Solution Solution
Property | Value |
---|---|
Description | State of rollup field Total Non-chargeable Cost. |
DisplayName | Total Non-chargeable Cost (State) |
Format | None |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | msdyn_totalnonchargeablecostrollup_state |
MaxValue | 2147483647 |
MinValue | -2147483648 |
RequiredLevel | None |
Type | Integer |
OnHoldTime
Property | Value |
---|---|
Description | Shows the duration in minutes for which the order was on hold. |
DisplayName | On Hold Time (Minutes) |
Format | None |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | onholdtime |
MaxValue | 2147483647 |
MinValue | -2147483648 |
RequiredLevel | None |
Type | Integer |
OpportunityIdName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | opportunityidname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
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 |
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 | None |
Targets | businessunit |
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 | None |
Targets | systemuser |
Type | Lookup |
PriceLevelIdName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | pricelevelidname |
MaxLength | 100 |
RequiredLevel | SystemRequired |
Type | String |
QuoteIdName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | quoteidname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
ShipTo_Composite
Property | Value |
---|---|
Description | Shows the complete Ship To address. |
DisplayName | Ship To Address |
Format | TextArea |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | shipto_composite |
MaxLength | 1000 |
RequiredLevel | None |
Type | Memo |
SLAInvokedId
Property | Value |
---|---|
Description | Last SLA that was applied to this sales order. This field is for internal use only. |
DisplayName | Last SLA applied |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | slainvokedid |
RequiredLevel | None |
Targets | sla |
Type | Lookup |
SLAInvokedIdName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | slainvokedidname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
SLAName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | slaname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
TotalAmount_Base
Property | Value |
---|---|
Description | Value of the Total Amount in base currency. |
DisplayName | Total Amount (Base) |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | totalamount_base |
MaxValue | 922337203685477 |
MinValue | -922337203685477 |
Precision | 4 |
PrecisionSource | 2 |
RequiredLevel | None |
Type | Money |
TotalAmountLessFreight_Base
Property | Value |
---|---|
Description | Value of the Total Pre-Freight Amount in base currency. |
DisplayName | Total Pre-Freight Amount (Base) |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | totalamountlessfreight_base |
MaxValue | 922337203685477 |
MinValue | -922337203685477 |
Precision | 4 |
PrecisionSource | 2 |
RequiredLevel | None |
Type | Money |
TotalDiscountAmount_Base
Property | Value |
---|---|
Description | Value of the Total Discount Amount in base currency. |
DisplayName | Total Discount Amount (Base) |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | totaldiscountamount_base |
MaxValue | 922337203685477 |
MinValue | -922337203685477 |
Precision | 4 |
PrecisionSource | 2 |
RequiredLevel | None |
Type | Money |
TotalLineItemAmount_Base
Property | Value |
---|---|
Description | Value of the Total Detail Amount in base currency. |
DisplayName | Total Detail Amount (Base) |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | totallineitemamount_base |
MaxValue | 922337203685477 |
MinValue | -922337203685477 |
Precision | 4 |
PrecisionSource | 2 |
RequiredLevel | None |
Type | Money |
TotalLineItemDiscountAmount_Base
Property | Value |
---|---|
Description | Value of the Total Line Item Discount Amount in base currency. |
DisplayName | Total Line Item Discount Amount (Base) |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | totallineitemdiscountamount_base |
MaxValue | 922337203685477 |
MinValue | -922337203685477 |
Precision | 4 |
PrecisionSource | 2 |
RequiredLevel | None |
Type | Money |
TotalTax_Base
Property | Value |
---|---|
Description | Value of the Total Tax in base currency. |
DisplayName | Total Tax (Base) |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | totaltax_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 |
VersionNumber
Property | Value |
---|---|
Description | Version Number |
DisplayName | Version Number |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | versionnumber |
MaxValue | 9223372036854775807 |
MinValue | -9223372036854775808 |
RequiredLevel | None |
Type | BigInt |
One-To-Many Relationships
Listed by SchemaName.
- SalesOrder_ActivityPointers
- SalesOrder_SyncErrors
- salesorder_activity_parties
- SalesOrder_AsyncOperations
- SalesOrder_MailboxTrackingFolder
- SalesOrder_ProcessSessions
- SalesOrder_BulkDeleteFailures
- salesorder_principalobjectattributeaccess
- SalesOrder_Appointments
- SalesOrder_Emails
- SalesOrder_Faxes
- SalesOrder_Letters
- SalesOrder_Phonecalls
- SalesOrder_Tasks
- SalesOrder_RecurringAppointmentMasters
- SalesOrder_SocialActivities
- salesorder_connections1
- salesorder_connections2
- SalesOrder_Annotation
- SalesOrder_ServiceAppointments
- lk_opportunitysalesprocess_salesorderid
- order_details
- order_invoices
- SalesOrder_OrderClose
- slakpiinstance_salesorder
- msdyn_playbookinstance_salesorder
- salesorder_msdyn_bookingalerts
- msdyn_salesorder_msdyn_actual_SalesContract
- salesorder_msdyn_approvals
- bpf_salesorder_OpportunitySalesProcess
- msdyn_salesorder_msdyn_contractlinescheduleofvalue_contract
- msdyn_salesorder_msdyn_fact_SalesContract
- msdyn_salesorder_msdyn_invoicelinetransaction_SalesContract
- msdyn_salesorder_msdyn_journalline_SalesContract
- msdyn_salesorder_msdyn_orderlinetransaction_SalesContract
- msdyn_salesorder_msdyn_orderpricelist_Contract
- msdyn_salesorder_msdyn_project_salesorderid
- msdyn_salesorder_msdyn_orderinvoicingdate_Order
- msdyn_salesorder_msdyn_orderinvoicingsetup_Order
- msdyn_salesorder_msdyn_orderinvoicingsetupdate_Order
SalesOrder_ActivityPointers
Added by: System Solution Solution
Same as activitypointer entity SalesOrder_ActivityPointers Many-To-One relationship.
Property | Value |
---|---|
ReferencingEntity | activitypointer |
ReferencingAttribute | regardingobjectid |
IsHierarchical | False |
IsCustomizable | False |
ReferencedEntityNavigationPropertyName | SalesOrder_ActivityPointers |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: NoCascade Delete: RemoveLink Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
SalesOrder_SyncErrors
Added by: System Solution Solution
Same as syncerror entity SalesOrder_SyncErrors Many-To-One relationship.
Property | Value |
---|---|
ReferencingEntity | syncerror |
ReferencingAttribute | regardingobjectid |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | SalesOrder_SyncErrors |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: Cascade Delete: Cascade Merge: Cascade Reparent: Cascade Share: Cascade Unshare: Cascade |
salesorder_activity_parties
Added by: System Solution Solution
Same as activityparty entity salesorder_activity_parties Many-To-One relationship.
Property | Value |
---|---|
ReferencingEntity | activityparty |
ReferencingAttribute | partyid |
IsHierarchical | False |
IsCustomizable | False |
ReferencedEntityNavigationPropertyName | salesorder_activity_parties |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
SalesOrder_AsyncOperations
Added by: System Solution Solution
Same as asyncoperation entity SalesOrder_AsyncOperations Many-To-One relationship.
Property | Value |
---|---|
ReferencingEntity | asyncoperation |
ReferencingAttribute | regardingobjectid |
IsHierarchical | False |
IsCustomizable | False |
ReferencedEntityNavigationPropertyName | SalesOrder_AsyncOperations |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
SalesOrder_MailboxTrackingFolder
Added by: System Solution Solution
Same as mailboxtrackingfolder entity SalesOrder_MailboxTrackingFolder Many-To-One relationship.
Property | Value |
---|---|
ReferencingEntity | mailboxtrackingfolder |
ReferencingAttribute | regardingobjectid |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | SalesOrder_MailboxTrackingFolder |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: Cascade Delete: Cascade Merge: Cascade Reparent: Cascade Share: Cascade Unshare: Cascade |
SalesOrder_ProcessSessions
Added by: System Solution Solution
Same as processsession entity SalesOrder_ProcessSessions Many-To-One relationship.
Property | Value |
---|---|
ReferencingEntity | processsession |
ReferencingAttribute | regardingobjectid |
IsHierarchical | False |
IsCustomizable | False |
ReferencedEntityNavigationPropertyName | SalesOrder_ProcessSessions |
AssociatedMenuConfiguration | Behavior: UseCollectionName Group: Details Label: Order: 110 |
CascadeConfiguration | Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
SalesOrder_BulkDeleteFailures
Added by: System Solution Solution
Same as bulkdeletefailure entity SalesOrder_BulkDeleteFailures Many-To-One relationship.
Property | Value |
---|---|
ReferencingEntity | bulkdeletefailure |
ReferencingAttribute | regardingobjectid |
IsHierarchical | False |
IsCustomizable | False |
ReferencedEntityNavigationPropertyName | SalesOrder_BulkDeleteFailures |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
salesorder_principalobjectattributeaccess
Added by: System Solution Solution
Same as principalobjectattributeaccess entity salesorder_principalobjectattributeaccess Many-To-One relationship.
Property | Value |
---|---|
ReferencingEntity | principalobjectattributeaccess |
ReferencingAttribute | objectid |
IsHierarchical | False |
IsCustomizable | False |
ReferencedEntityNavigationPropertyName | salesorder_principalobjectattributeaccess |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
SalesOrder_Appointments
Added by: System Solution Solution
Same as appointment entity SalesOrder_Appointments Many-To-One relationship.
Property | Value |
---|---|
ReferencingEntity | appointment |
ReferencingAttribute | regardingobjectid |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | SalesOrder_Appointments |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: Cascade Delete: Cascade Merge: NoCascade Reparent: Cascade Share: Cascade Unshare: Cascade |
SalesOrder_Emails
Added by: System Solution Solution
Same as email entity SalesOrder_Emails Many-To-One relationship.
Property | Value |
---|---|
ReferencingEntity | |
ReferencingAttribute | regardingobjectid |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | SalesOrder_Emails |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: Cascade Delete: Cascade Merge: NoCascade Reparent: Cascade Share: Cascade Unshare: Cascade |
SalesOrder_Faxes
Added by: System Solution Solution
Same as fax entity SalesOrder_Faxes Many-To-One relationship.
Property | Value |
---|---|
ReferencingEntity | fax |
ReferencingAttribute | regardingobjectid |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | SalesOrder_Faxes |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: Cascade Delete: Cascade Merge: NoCascade Reparent: Cascade Share: Cascade Unshare: Cascade |
SalesOrder_Letters
Added by: System Solution Solution
Same as letter entity SalesOrder_Letters Many-To-One relationship.
Property | Value |
---|---|
ReferencingEntity | letter |
ReferencingAttribute | regardingobjectid |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | SalesOrder_Letters |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: Cascade Delete: Cascade Merge: NoCascade Reparent: Cascade Share: Cascade Unshare: Cascade |
SalesOrder_Phonecalls
Added by: System Solution Solution
Same as phonecall entity SalesOrder_Phonecalls Many-To-One relationship.
Property | Value |
---|---|
ReferencingEntity | phonecall |
ReferencingAttribute | regardingobjectid |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | SalesOrder_Phonecalls |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: Cascade Delete: Cascade Merge: NoCascade Reparent: Cascade Share: Cascade Unshare: Cascade |
SalesOrder_Tasks
Added by: System Solution Solution
Same as task entity SalesOrder_Tasks Many-To-One relationship.
Property | Value |
---|---|
ReferencingEntity | task |
ReferencingAttribute | regardingobjectid |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | SalesOrder_Tasks |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: Cascade Delete: Cascade Merge: NoCascade Reparent: Cascade Share: Cascade Unshare: Cascade |
SalesOrder_RecurringAppointmentMasters
Added by: System Solution Solution
Same as recurringappointmentmaster entity SalesOrder_RecurringAppointmentMasters Many-To-One relationship.
Property | Value |
---|---|
ReferencingEntity | recurringappointmentmaster |
ReferencingAttribute | regardingobjectid |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | SalesOrder_RecurringAppointmentMasters |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: Cascade Delete: Cascade Merge: NoCascade Reparent: Cascade Share: Cascade Unshare: Cascade |
SalesOrder_SocialActivities
Added by: System Solution Solution
Same as socialactivity entity SalesOrder_SocialActivities Many-To-One relationship.
Property | Value |
---|---|
ReferencingEntity | socialactivity |
ReferencingAttribute | regardingobjectid |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | SalesOrder_SocialActivities |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: Cascade Delete: Cascade Merge: NoCascade Reparent: Cascade Share: Cascade Unshare: Cascade |
salesorder_connections1
Added by: System Solution Solution
Same as connection entity salesorder_connections1 Many-To-One relationship.
Property | Value |
---|---|
ReferencingEntity | connection |
ReferencingAttribute | record1id |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | salesorder_connections1 |
AssociatedMenuConfiguration | Behavior: UseCollectionName Group: Details Label: Order: 100 |
CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
salesorder_connections2
Added by: System Solution Solution
Same as connection entity salesorder_connections2 Many-To-One relationship.
Property | Value |
---|---|
ReferencingEntity | connection |
ReferencingAttribute | record2id |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | salesorder_connections2 |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: 100 |
CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
SalesOrder_Annotation
Added by: System Solution Solution
Same as annotation entity SalesOrder_Annotation Many-To-One relationship.
Property | Value |
---|---|
ReferencingEntity | annotation |
ReferencingAttribute | objectid |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | SalesOrder_Annotation |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: Cascade Delete: Cascade Merge: NoCascade Reparent: Cascade Share: Cascade Unshare: Cascade |
SalesOrder_ServiceAppointments
Added by: Service Solution
Same as serviceappointment entity SalesOrder_ServiceAppointments Many-To-One relationship.
Property | Value |
---|---|
ReferencingEntity | serviceappointment |
ReferencingAttribute | regardingobjectid |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | SalesOrder_ServiceAppointments |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: Cascade Delete: RemoveLink Merge: NoCascade Reparent: Cascade Share: Cascade Unshare: Cascade |
lk_opportunitysalesprocess_salesorderid
Same as opportunitysalesprocess entity lk_opportunitysalesprocess_salesorderid Many-To-One relationship.
Property | Value |
---|---|
ReferencingEntity | opportunitysalesprocess |
ReferencingAttribute | salesorderid |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | salesorder_opportunitysalesprocess |
AssociatedMenuConfiguration | Behavior: UseCollectionName Group: Details Label: Order: |
CascadeConfiguration | Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
order_details
Same as salesorderdetail entity order_details Many-To-One relationship.
Property | Value |
---|---|
ReferencingEntity | salesorderdetail |
ReferencingAttribute | salesorderid |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | order_details |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
order_invoices
Same as invoice entity order_invoices Many-To-One relationship.
Property | Value |
---|---|
ReferencingEntity | invoice |
ReferencingAttribute | salesorderid |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | order_invoices |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: NoCascade Delete: Restrict Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
SalesOrder_OrderClose
Same as orderclose entity SalesOrder_OrderClose Many-To-One relationship.
Property | Value |
---|---|
ReferencingEntity | orderclose |
ReferencingAttribute | salesorderid |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | SalesOrder_OrderClose |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: Cascade Delete: Cascade Merge: NoCascade Reparent: Cascade Share: Cascade Unshare: Cascade |
slakpiinstance_salesorder
Added by: System Solution Solution
Same as slakpiinstance entity slakpiinstance_salesorder Many-To-One relationship.
Property | Value |
---|---|
ReferencingEntity | slakpiinstance |
ReferencingAttribute | regarding |
IsHierarchical | False |
IsCustomizable | False |
ReferencedEntityNavigationPropertyName | slakpiinstance_salesorder |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
msdyn_playbookinstance_salesorder
Added by: Playbook Solution
Same as msdyn_playbookinstance entity msdyn_playbookinstance_salesorder Many-To-One relationship.
Property | Value |
---|---|
ReferencingEntity | msdyn_playbookinstance |
ReferencingAttribute | regarding |
IsHierarchical | False |
IsCustomizable | False |
ReferencedEntityNavigationPropertyName | msdyn_playbookinstance_salesorder |
AssociatedMenuConfiguration | Behavior: UseCollectionName Group: Details Label: Order: |
CascadeConfiguration | Assign: Cascade Delete: Cascade Merge: NoCascade Reparent: Cascade Share: Cascade Unshare: Cascade |
salesorder_msdyn_bookingalerts
Added by: Active Solution Solution
Same as msdyn_bookingalert entity salesorder_msdyn_bookingalerts Many-To-One relationship.
Property | Value |
---|---|
ReferencingEntity | msdyn_bookingalert |
ReferencingAttribute | regardingobjectid |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | salesorder_msdyn_bookingalerts |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: Cascade Delete: Cascade Merge: NoCascade Reparent: Cascade Share: Cascade Unshare: Cascade |
msdyn_salesorder_msdyn_actual_SalesContract
Added by: Universal Resource Scheduling Solution
Same as msdyn_actual entity msdyn_salesorder_msdyn_actual_SalesContract Many-To-One relationship.
Property | Value |
---|---|
ReferencingEntity | msdyn_actual |
ReferencingAttribute | msdyn_salescontract |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | msdyn_salesorder_msdyn_actual_SalesContract |
AssociatedMenuConfiguration | Behavior: UseCollectionName Group: Details Label: Order: 10000 |
CascadeConfiguration | Assign: NoCascade Delete: Restrict Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
salesorder_msdyn_approvals
Added by: Active Solution Solution
Same as msdyn_approval entity salesorder_msdyn_approvals Many-To-One relationship.
Property | Value |
---|---|
ReferencingEntity | msdyn_approval |
ReferencingAttribute | regardingobjectid |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | salesorder_msdyn_approvals |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: Cascade Delete: Cascade Merge: NoCascade Reparent: Cascade Share: Cascade Unshare: Cascade |
bpf_salesorder_OpportunitySalesProcess
Added by: Project Service Automation Solution
Same as opportunitysalesprocess entity bpf_salesorder_OpportunitySalesProcess Many-To-One relationship.
Property | Value |
---|---|
ReferencingEntity | opportunitysalesprocess |
ReferencingAttribute | bpf_salesorderid |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | bpf_salesorder_OpportunitySalesProcess |
AssociatedMenuConfiguration | Behavior: UseLabel Group: Details Label: salesorder Order: 10000 |
CascadeConfiguration | Assign: NoCascade Delete: RemoveLink Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
msdyn_salesorder_msdyn_contractlinescheduleofvalue_contract
Added by: Project Service Automation Solution
Same as msdyn_contractlinescheduleofvalue entity msdyn_salesorder_msdyn_contractlinescheduleofvalue_contract Many-To-One relationship.
Property | Value |
---|---|
ReferencingEntity | msdyn_contractlinescheduleofvalue |
ReferencingAttribute | msdyn_contract |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | msdyn_salesorder_msdyn_contractlinescheduleofvalue_contract |
AssociatedMenuConfiguration | Behavior: UseCollectionName Group: Details Label: Order: 10000 |
CascadeConfiguration | Assign: NoCascade Delete: RemoveLink Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
msdyn_salesorder_msdyn_fact_SalesContract
Added by: Project Service Automation Solution
Same as msdyn_fact entity msdyn_salesorder_msdyn_fact_SalesContract Many-To-One relationship.
Property | Value |
---|---|
ReferencingEntity | msdyn_fact |
ReferencingAttribute | msdyn_salescontract |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | msdyn_salesorder_msdyn_fact_SalesContract |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: 10000 |
CascadeConfiguration | Assign: NoCascade Delete: Restrict Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
msdyn_salesorder_msdyn_invoicelinetransaction_SalesContract
Added by: Project Service Automation Solution
Same as msdyn_invoicelinetransaction entity msdyn_salesorder_msdyn_invoicelinetransaction_SalesContract Many-To-One relationship.
Property | Value |
---|---|
ReferencingEntity | msdyn_invoicelinetransaction |
ReferencingAttribute | msdyn_salescontract |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | msdyn_salesorder_msdyn_invoicelinetransaction_SalesContract |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: 10000 |
CascadeConfiguration | Assign: NoCascade Delete: Restrict Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
msdyn_salesorder_msdyn_journalline_SalesContract
Added by: Project Service Automation Solution
Same as msdyn_journalline entity msdyn_salesorder_msdyn_journalline_SalesContract Many-To-One relationship.
Property | Value |
---|---|
ReferencingEntity | msdyn_journalline |
ReferencingAttribute | msdyn_salescontract |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | msdyn_salesorder_msdyn_journalline_SalesContract |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: 10000 |
CascadeConfiguration | Assign: NoCascade Delete: Restrict Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
msdyn_salesorder_msdyn_orderlinetransaction_SalesContract
Added by: Project Service Automation Solution
Same as msdyn_orderlinetransaction entity msdyn_salesorder_msdyn_orderlinetransaction_SalesContract Many-To-One relationship.
Property | Value |
---|---|
ReferencingEntity | msdyn_orderlinetransaction |
ReferencingAttribute | msdyn_salescontract |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | msdyn_salesorder_msdyn_orderlinetransaction_SalesContract |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: 10000 |
CascadeConfiguration | Assign: NoCascade Delete: Restrict Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
msdyn_salesorder_msdyn_orderpricelist_Contract
Added by: Project Service Automation Solution
Same as msdyn_orderpricelist entity msdyn_salesorder_msdyn_orderpricelist_Contract Many-To-One relationship.
Property | Value |
---|---|
ReferencingEntity | msdyn_orderpricelist |
ReferencingAttribute | msdyn_contract |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | msdyn_salesorder_msdyn_orderpricelist_Contract |
AssociatedMenuConfiguration | Behavior: UseCollectionName Group: Details Label: Order: 10000 |
CascadeConfiguration | Assign: Cascade Delete: Cascade Merge: NoCascade Reparent: Cascade Share: Cascade Unshare: Cascade |
msdyn_salesorder_msdyn_project_salesorderid
Added by: Project Service Automation Solution
Same as msdyn_project entity msdyn_salesorder_msdyn_project_salesorderid Many-To-One relationship.
Property | Value |
---|---|
ReferencingEntity | msdyn_project |
ReferencingAttribute | msdyn_salesorderid |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | msdyn_salesorder_msdyn_project_salesorderid |
AssociatedMenuConfiguration | Behavior: UseCollectionName Group: Details Label: Order: 10000 |
CascadeConfiguration | Assign: NoCascade Delete: RemoveLink Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
msdyn_salesorder_msdyn_orderinvoicingdate_Order
Added by: Field Service Solution
Same as msdyn_orderinvoicingdate entity msdyn_salesorder_msdyn_orderinvoicingdate_Order Many-To-One relationship.
Property | Value |
---|---|
ReferencingEntity | msdyn_orderinvoicingdate |
ReferencingAttribute | msdyn_order |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | msdyn_salesorder_msdyn_orderinvoicingdate_Order |
AssociatedMenuConfiguration | Behavior: UseCollectionName Group: Details Label: Order: 10000 |
CascadeConfiguration | Assign: Cascade Delete: Cascade Merge: NoCascade Reparent: Cascade Share: Cascade Unshare: Cascade |
msdyn_salesorder_msdyn_orderinvoicingsetup_Order
Added by: Field Service Solution
Same as msdyn_orderinvoicingsetup entity msdyn_salesorder_msdyn_orderinvoicingsetup_Order Many-To-One relationship.
Property | Value |
---|---|
ReferencingEntity | msdyn_orderinvoicingsetup |
ReferencingAttribute | msdyn_order |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | msdyn_salesorder_msdyn_orderinvoicingsetup_Order |
AssociatedMenuConfiguration | Behavior: UseCollectionName Group: Details Label: Order: 10000 |
CascadeConfiguration | Assign: Cascade Delete: Cascade Merge: NoCascade Reparent: Cascade Share: Cascade Unshare: Cascade |
msdyn_salesorder_msdyn_orderinvoicingsetupdate_Order
Added by: Field Service Solution
Same as msdyn_orderinvoicingsetupdate entity msdyn_salesorder_msdyn_orderinvoicingsetupdate_Order Many-To-One relationship.
Property | Value |
---|---|
ReferencingEntity | msdyn_orderinvoicingsetupdate |
ReferencingAttribute | msdyn_order |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | msdyn_salesorder_msdyn_orderinvoicingsetupdate_Order |
AssociatedMenuConfiguration | Behavior: UseCollectionName Group: Details Label: Order: 10000 |
CascadeConfiguration | Assign: NoCascade Delete: RemoveLink 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_salesorderbase_createdby
- lk_salesorder_createdonbehalfby
- lk_salesorderbase_modifiedby
- lk_salesorder_modifiedonbehalfby
- system_user_orders
- team_orders
- business_unit_orders
- processstage_salesorders
- transactioncurrency_salesorder
- order_customer_accounts
- order_customer_contacts
- opportunity_sales_orders
- price_level_orders
- quote_orders
- manualsla_salesorder
- sla_salesorder
- campaign_orders
- msdyn_accountmanager_salesorder
- msdyn_organizationalunit_salesorder
- msdyn_account_salesorder_Account
lk_salesorderbase_createdby
Added by: System Solution Solution
See systemuser Entity lk_salesorderbase_createdby One-To-Many relationship.
lk_salesorder_createdonbehalfby
Added by: System Solution Solution
See systemuser Entity lk_salesorder_createdonbehalfby One-To-Many relationship.
lk_salesorderbase_modifiedby
Added by: System Solution Solution
See systemuser Entity lk_salesorderbase_modifiedby One-To-Many relationship.
lk_salesorder_modifiedonbehalfby
Added by: System Solution Solution
See systemuser Entity lk_salesorder_modifiedonbehalfby One-To-Many relationship.
system_user_orders
Added by: System Solution Solution
See systemuser Entity system_user_orders One-To-Many relationship.
team_orders
Added by: System Solution Solution
See team Entity team_orders One-To-Many relationship.
business_unit_orders
Added by: System Solution Solution
See businessunit Entity business_unit_orders One-To-Many relationship.
processstage_salesorders
Added by: System Solution Solution
See processstage Entity processstage_salesorders One-To-Many relationship.
transactioncurrency_salesorder
Added by: System Solution Solution
See transactioncurrency Entity transactioncurrency_salesorder One-To-Many relationship.
order_customer_accounts
Added by: System Solution Solution
See account Entity order_customer_accounts One-To-Many relationship.
order_customer_contacts
Added by: System Solution Solution
See contact Entity order_customer_contacts One-To-Many relationship.
opportunity_sales_orders
See opportunity Entity opportunity_sales_orders One-To-Many relationship.
price_level_orders
Added by: Product Management Solution
See pricelevel Entity price_level_orders One-To-Many relationship.
quote_orders
See quote Entity quote_orders One-To-Many relationship.
manualsla_salesorder
Added by: System Solution Solution
See sla Entity manualsla_salesorder One-To-Many relationship.
sla_salesorder
Added by: System Solution Solution
See sla Entity sla_salesorder One-To-Many relationship.
campaign_orders
Added by: Marketing Solution
See campaign Entity campaign_orders One-To-Many relationship.
msdyn_accountmanager_salesorder
Added by: System Solution Solution
See systemuser Entity msdyn_accountmanager_salesorder One-To-Many relationship.
msdyn_organizationalunit_salesorder
Added by: Universal Resource Scheduling Solution
See msdyn_organizationalunit Entity msdyn_organizationalunit_salesorder One-To-Many relationship.
msdyn_account_salesorder_Account
Added by: System Solution Solution
See account Entity msdyn_account_salesorder_Account One-To-Many relationship.
Many-To-Many Relationships
Relationship details provided where the SalesOrder entity is the first entity in the relationship. Listed by SchemaName.
contactorders_association
IntersectEntityName: contactorders
Entity 1
Property | Value |
---|---|
IntersectAttribute | salesorderid |
IsCustomizable | False |
LogicalName | salesorder |
NavigationPropertyName | contactorders_association |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
Entity 2
Property | Value |
---|---|
LogicalName | contact |
IntersectAttribute | contactid |
NavigationPropertyName | contactorders_association |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
See also
About the Entity Reference
Programming reference for Dynamics 365 Customer Engagement
Web API Reference
Microsoft.Dynamics.CRM.salesorder
Feedback
Submit and view feedback for