title | description | ms.date | ms.topic | ms.assetid | author | ms.author | search.audienceType | |
---|---|---|---|---|---|---|---|---|
Order (SalesOrder) entity reference (Dynamics 365 Customer Engagement) | Microsoft Docs |
Includes schema information and supported messages for the Order (SalesOrder) entity. |
08/30/2022 |
reference |
3948cc48-07c8-7f60-0608-71c37158ad7c |
KumarVivek |
matp |
|
Quote that has been accepted.
Added by: Sales Solution
Message | SDK class or method |
---|---|
Assign | xref:Microsoft.Crm.Sdk.Messages.AssignRequest |
Associate | xref:Microsoft.Xrm.Sdk.Messages.AssociateRequest or xref:Microsoft.Xrm.Sdk.IOrganizationService.Associate* |
CalculatePrice | xref:Microsoft.Crm.Sdk.Messages.CalculatePriceRequest |
CancelContract | xref:Microsoft.Crm.Sdk.Messages.CancelContractRequest |
CancelSalesOrder | xref:Microsoft.Crm.Sdk.Messages.CancelSalesOrderRequest |
ConvertSalesOrderToInvoice | xref:Microsoft.Crm.Sdk.Messages.ConvertSalesOrderToInvoiceRequest |
Create | xref:Microsoft.Xrm.Sdk.Messages.CreateRequest or xref:Microsoft.Xrm.Sdk.IOrganizationService.Create* |
Delete | xref:Microsoft.Xrm.Sdk.Messages.DeleteRequest or xref:Microsoft.Xrm.Sdk.IOrganizationService.Delete* |
Disassociate | xref:Microsoft.Xrm.Sdk.Messages.DisassociateRequest or xref:Microsoft.Xrm.Sdk.IOrganizationService.Disassociate* |
FulfillSalesOrder | xref:Microsoft.Crm.Sdk.Messages.FulfillSalesOrderRequest |
GenerateSalesOrderFromOpportunity | xref:Microsoft.Crm.Sdk.Messages.GenerateSalesOrderFromOpportunityRequest |
GetQuantityDecimal | xref:Microsoft.Crm.Sdk.Messages.GetQuantityDecimalRequest |
GetSalesOrderProductsFromOpportunity | xref:Microsoft.Crm.Sdk.Messages.GetSalesOrderProductsFromOpportunityRequest |
GrantAccess | xref:Microsoft.Crm.Sdk.Messages.GrantAccessRequest |
LockSalesOrderPricing | xref:Microsoft.Crm.Sdk.Messages.LockSalesOrderPricingRequest |
ModifyAccess | xref:Microsoft.Crm.Sdk.Messages.ModifyAccessRequest |
Retrieve | xref:Microsoft.Xrm.Sdk.Messages.RetrieveRequest or xref:Microsoft.Xrm.Sdk.IOrganizationService.Retrieve* |
RetrieveMultiple | xref:Microsoft.Xrm.Sdk.Messages.RetrieveMultipleRequest or xref:Microsoft.Xrm.Sdk.IOrganizationService.RetrieveMultiple* |
RetrievePrincipalAccess | xref:Microsoft.Crm.Sdk.Messages.RetrievePrincipalAccessRequest |
RetrieveSharedPrincipalsAndAccess | xref:Microsoft.Crm.Sdk.Messages.RetrieveSharedPrincipalsAndAccessRequest |
RevokeAccess | xref:Microsoft.Crm.Sdk.Messages.RevokeAccessRequest |
Rollup | xref:Microsoft.Crm.Sdk.Messages.RollupRequest |
SetState | xref:Microsoft.Crm.Sdk.Messages.SetStateRequest |
Update | xref:Microsoft.Xrm.Sdk.Messages.UpdateRequest or xref:Microsoft.Xrm.Sdk.IOrganizationService.Update* |
Property | Value |
---|---|
CollectionSchemaName | SalesOrders |
DisplayCollectionName | Orders |
DisplayName | Order |
EntitySetName | salesorders |
IsBPFEntity | False |
LogicalCollectionName | salesorders |
LogicalName | salesorder |
OwnershipType | UserOwned |
PrimaryIdAttribute | salesorderid |
PrimaryNameAttribute | name |
SchemaName | SalesOrder |
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
- 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
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
Added by: Active Solution Solution
Property | Value |
---|---|
Description | |
DisplayName | Customer Type |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | customeridtype |
RequiredLevel | ApplicationRequired |
Type | EntityName |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
Value | Label | Description |
---|---|---|
1 | FOB | |
2 | No Charge |
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 |
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 |
Value | Label | Description |
---|---|---|
1 | Yes | |
0 | No |
DefaultValue: 0
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 |
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 |
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 |
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 |
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 |
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 |
Property | Value |
---|---|
Description | Owner Id |
DisplayName | Owner |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | ownerid |
RequiredLevel | SystemRequired |
Targets | systemuser,team |
Type | Owner |
Added by: Active Solution Solution
Property | Value |
---|---|
Description | Owner Id Type |
DisplayName | |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owneridtype |
RequiredLevel | SystemRequired |
Type | EntityName |
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 |
Value | Label | Description |
---|---|---|
1 | Net 30 | |
2 | 2% 10, Net 30 | |
3 | Net 45 | |
4 | Net 60 |
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 |
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 |
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 |
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 |
Value | Label | Description |
---|---|---|
1 | Default Value |
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 |
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 |
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 |
Property | Value |
---|---|
Description | Unique identifier of the order. |
DisplayName | Order |
IsValidForForm | False |
IsValidForRead | True |
IsValidForUpdate | False |
LogicalName | salesorderid |
RequiredLevel | SystemRequired |
Type | Uniqueidentifier |
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 |
Value | Label | Description |
---|---|---|
1 | Airborne | |
2 | DHL | |
3 | FedEx | |
4 | UPS | |
5 | Postal Mail | |
6 | Full Load | |
7 | Will Call |
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 |
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 |
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 |
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 |
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 |
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 |
Value | Label | Description |
---|---|---|
1 | Default Value |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
Property | Value |
---|---|
Description | Contains the id of the stage where the entity is located. |
DisplayName | Stage Id |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | stageid |
RequiredLevel | None |
Type | Uniqueidentifier |
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 |
Value | Label | DefaultStatus | InvariantName |
---|---|---|---|
0 | Active | 1 | Active |
1 | Submitted | 3 | Submitted |
2 | Canceled | 4 | Canceled |
3 | Fulfilled | 100001 | Fulfilled |
4 | Invoiced | 100003 | Invoiced |
Property | Value |
---|---|
Description | Select the order's status. |
DisplayName | Status Reason |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | statuscode |
RequiredLevel | None |
Type | Status |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 | Traversed Path |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | traversedpath |
MaxLength | 1250 |
RequiredLevel | None |
Type | String |
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 |
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 |
Value | Label | Description |
---|---|---|
1 | Will Call | |
0 | Address |
DefaultValue: 0
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
- 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
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 |
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | accountidname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | accountidyominame |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
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 |
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 |
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 |
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | contactidname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | contactidyominame |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
Property | Value |
---|---|
Description | Shows who created the record. |
DisplayName | Created By |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | createdby |
RequiredLevel | None |
Targets | systemuser |
Type | Lookup |
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | createdbyname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | createdbyyominame |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
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 |
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 |
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | createdonbehalfbyname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | createdonbehalfbyyominame |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | customeridname |
MaxLength | 160 |
RequiredLevel | ApplicationRequired |
Type | String |
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | customeridyominame |
MaxLength | 450 |
RequiredLevel | ApplicationRequired |
Type | String |
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 |
Property | Value |
---|---|
Description | |
DisplayName | |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | entityimage_timestamp |
MaxValue | 9223372036854775807 |
MinValue | -9223372036854775808 |
RequiredLevel | None |
Type | BigInt |
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Url |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | entityimage_url |
MaxLength | 200 |
RequiredLevel | None |
Type | String |
Property | Value |
---|---|
Description | |
DisplayName | |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | entityimageid |
RequiredLevel | None |
Type | Uniqueidentifier |
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 |
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 |
Property | Value |
---|---|
Description | Shows who last updated the record. |
DisplayName | Modified By |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | modifiedby |
RequiredLevel | None |
Targets | systemuser |
Type | Lookup |
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | modifiedbyname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | modifiedbyyominame |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
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 |
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 |
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | modifiedonbehalfbyname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | modifiedonbehalfbyyominame |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
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 |
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | opportunityidname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
Property | Value |
---|---|
Description | Name of the owner |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owneridname |
MaxLength | 100 |
RequiredLevel | SystemRequired |
Type | String |
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 |
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 |
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 |
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 |
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | pricelevelidname |
MaxLength | 100 |
RequiredLevel | SystemRequired |
Type | String |
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | quoteidname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
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 |
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 |
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | slainvokedidname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | slaname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
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 |
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 |
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 |
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 |
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 |
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 |
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | transactioncurrencyidname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
Property | Value |
---|---|
Description | Version Number |
DisplayName | Version Number |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | versionnumber |
MaxValue | 9223372036854775807 |
MinValue | -9223372036854775808 |
RequiredLevel | None |
Type | BigInt |
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
Added by: System Solution Solution
Same as the SalesOrder_ActivityPointers many-to-one relationship for the activitypointer entity.
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 |
Added by: System Solution Solution
Same as the SalesOrder_SyncErrors many-to-one relationship for the syncerror entity.
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 |
Added by: System Solution Solution
Same as the salesorder_activity_parties many-to-one relationship for the activityparty entity.
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 |
Added by: System Solution Solution
Same as the SalesOrder_AsyncOperations many-to-one relationship for the asyncoperation entity.
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 |
Added by: System Solution Solution
Same as the SalesOrder_MailboxTrackingFolder many-to-one relationship for the mailboxtrackingfolder entity.
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 |
Added by: System Solution Solution
Same as the SalesOrder_ProcessSessions many-to-one relationship for the processsession entity.
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 |
Added by: System Solution Solution
Same as the SalesOrder_BulkDeleteFailures many-to-one relationship for the bulkdeletefailure entity.
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 |
Added by: System Solution Solution
Same as the salesorder_principalobjectattributeaccess many-to-one relationship for the principalobjectattributeaccess entity.
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 |
Added by: System Solution Solution
Same as the SalesOrder_Appointments many-to-one relationship for the appointment entity.
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 |
Added by: System Solution Solution
Same as the SalesOrder_Emails many-to-one relationship for the email entity.
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 |
Added by: System Solution Solution
Same as the SalesOrder_Faxes many-to-one relationship for the fax entity.
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 |
Added by: System Solution Solution
Same as the SalesOrder_Letters many-to-one relationship for the letter entity.
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 |
Added by: System Solution Solution
Same as the SalesOrder_Phonecalls many-to-one relationship for the phonecall entity.
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 |
Added by: System Solution Solution
Same as the SalesOrder_Tasks many-to-one relationship for the task entity.
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 |
Added by: System Solution Solution
Same as the SalesOrder_RecurringAppointmentMasters many-to-one relationship for the recurringappointmentmaster entity.
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 |
Added by: System Solution Solution
Same as the SalesOrder_SocialActivities many-to-one relationship for the socialactivity entity.
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 |
Added by: System Solution Solution
Same as the salesorder_connections1 many-to-one relationship for the connection entity.
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 |
Added by: System Solution Solution
Same as the salesorder_connections2 many-to-one relationship for the connection entity.
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 |
Added by: System Solution Solution
Same as the SalesOrder_Annotation many-to-one relationship for the annotation entity.
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 |
Added by: Service Solution
Same as the SalesOrder_ServiceAppointments many-to-one relationship for the serviceappointment entity.
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 |
Same as the lk_opportunitysalesprocess_salesorderid many-to-one relationship for the opportunitysalesprocess entity.
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 |
Same as the order_details many-to-one relationship for the salesorderdetail entity.
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 |
Same as the order_invoices many-to-one relationship for the invoice entity.
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 |
Same as the SalesOrder_OrderClose many-to-one relationship for the orderclose entity.
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 |
Added by: System Solution Solution
Same as the slakpiinstance_salesorder many-to-one relationship for the slakpiinstance entity.
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 |
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
Added by: System Solution Solution
See the lk_salesorderbase_createdby one-to-many relationship for the systemuser entity.
Added by: System Solution Solution
See the lk_salesorder_createdonbehalfby one-to-many relationship for the systemuser entity.
Added by: System Solution Solution
See the lk_salesorderbase_modifiedby one-to-many relationship for the systemuser entity.
Added by: System Solution Solution
See the lk_salesorder_modifiedonbehalfby one-to-many relationship for the systemuser entity.
Added by: System Solution Solution
See the system_user_orders one-to-many relationship for the systemuser entity.
Added by: System Solution Solution
See the team_orders one-to-many relationship for the team entity.
Added by: System Solution Solution
See the business_unit_orders one-to-many relationship for the businessunit entity.
Added by: System Solution Solution
See the processstage_salesorders one-to-many relationship for the processstage entity.
Added by: System Solution Solution
See the transactioncurrency_salesorder one-to-many relationship for the transactioncurrency entity.
Added by: System Solution Solution
See the order_customer_accounts one-to-many relationship for the account entity.
Added by: System Solution Solution
See the order_customer_contacts one-to-many relationship for the contact entity.
See the opportunity_sales_orders one-to-many relationship for the opportunity entity.
Added by: Product Management Solution
See the price_level_orders one-to-many relationship for the pricelevel entity.
See the quote_orders one-to-many relationship for the quote entity.
Added by: System Solution Solution
See the manualsla_salesorder one-to-many relationship for the sla entity.
Added by: System Solution Solution
See the sla_salesorder one-to-many relationship for the sla entity.
Added by: Marketing Solution
See the campaign_orders one-to-many relationship for the campaign entity.
Relationship details provided where the SalesOrder entity is the first entity in the relationship. Listed by SchemaName.
IntersectEntityName: contactorders
Property | Value |
---|---|
IntersectAttribute | salesorderid |
IsCustomizable | False |
LogicalName | salesorder |
NavigationPropertyName | contactorders_association |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
Property | Value |
---|---|
LogicalName | contact |
IntersectAttribute | contactid |
NavigationPropertyName | contactorders_association |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |