SalesOrder (Order) Entity OptionSet Attribute Metadata
[Applies to: Microsoft Dynamics CRM 2011]
The sales order (order) entity contains a number of attributes with the underlying type of OptionSetMetadata. This includes attributes of type PicklistAttributeMetadata, StateAttributeMetadata, and StatusAttributeMetadata. This topic shows the values for these attributes in a default, uncustomized installation of Microsoft Dynamics CRM. For information on how to generate and use enumerations for these values in your code, see Helper Code: Enumerations for Option Sets.
OptionSet Values
The following table lists the attributes and option set values for the sales order (order) entity.
| LogicalName | Type | OptionValue | OptionDescription |
|---|---|---|---|
freighttermscode |
Picklist |
1 |
FOB |
Picklist |
2 |
No Charge |
|
paymenttermscode |
Picklist |
1 |
Net 30 |
Picklist |
2 |
2% 10, Net 30 |
|
Picklist |
3 |
Net 45 |
|
Picklist |
4 |
Net 60 |
|
pricingerrorcode |
Picklist |
0 |
None |
Picklist |
1 |
Detail Error |
|
Picklist |
2 |
Missing Price Level |
|
Picklist |
3 |
Inactive Price Level |
|
Picklist |
4 |
Missing Quantity |
|
Picklist |
5 |
Missing Unit Price |
|
Picklist |
6 |
Missing Product |
|
Picklist |
7 |
Invalid Product |
|
Picklist |
8 |
Missing Pricing Code |
|
Picklist |
9 |
Invalid Pricing Code |
|
Picklist |
10 |
Missing UOM |
|
Picklist |
11 |
Product Not In Price Level |
|
Picklist |
12 |
Missing Price Level Amount |
|
Picklist |
13 |
Missing Price Level Percentage |
|
Picklist |
14 |
Missing Price |
|
Picklist |
15 |
Missing Current Cost |
|
Picklist |
16 |
Missing Standard Cost |
|
Picklist |
17 |
Invalid Price Level Amount |
|
Picklist |
18 |
Invalid Price Level Percentage |
|
Picklist |
19 |
Invalid Price |
|
Picklist |
20 |
Invalid Current Cost |
|
Picklist |
21 |
Invalid Standard Cost |
|
Picklist |
22 |
Invalid Rounding Policy |
|
Picklist |
23 |
Invalid Rounding Option |
|
Picklist |
24 |
Invalid Rounding Amount |
|
Picklist |
25 |
Price Calculation Error |
|
Picklist |
26 |
Invalid Discount Type |
|
Picklist |
27 |
Discount Type Invalid State |
|
Picklist |
28 |
Invalid Discount |
|
Picklist |
29 |
Invalid Quantity |
|
Picklist |
30 |
Invalid Pricing Precision |
|
Picklist |
31 |
Missing Product Default UOM |
|
Picklist |
32 |
Missing Product UOM Schedule |
|
Picklist |
33 |
Inactive Discount Type |
|
Picklist |
34 |
Invalid Price Level Currency |
|
Picklist |
35 |
Price Attribute Out Of Range |
|
Picklist |
36 |
Base Currency Attribute Overflow |
|
Picklist |
37 |
Base Currency Attribute Underflow |
|
prioritycode |
Picklist |
1 |
Default Value |
shippingmethodcode |
Picklist |
1 |
Airborne |
Picklist |
2 |
DHL |
|
Picklist |
3 |
FedEx |
|
Picklist |
4 |
UPS |
|
Picklist |
5 |
Postal Mail |
|
Picklist |
6 |
Full Load |
|
Picklist |
7 |
Will Call |
|
shipto_freighttermscode |
Picklist |
1 |
Default Value |
statecode |
State |
0 |
Active |
State |
1 |
Submitted |
|
State |
2 |
Canceled |
|
State |
3 |
Fulfilled |
|
State |
4 |
Invoiced |
|
statuscode |
Status |
1 |
New |
Status |
2 |
Pending |
|
Status |
3 |
In Progress |
|
Status |
4 |
No Money |
|
Status |
100001 |
Complete |
|
Status |
100002 |
Partial |
|
Status |
100003 |
Invoiced |
Statecode to Statuscode Mapping
The following table shows the mapping between the default statecode and statuscode picklist values.
| State | State value | Status | Status value |
|---|---|---|---|
Active |
0 |
New |
1 |
Active |
0 |
Pending |
2 |
Submitted |
1 |
In Progress |
3 |
Canceled |
2 |
No Money |
4 |
Fulfilled |
3 |
Complete |
100001 |
Fulfilled |
3 |
Partial |
100002 |
Invoiced |
4 |
Invoiced |
100003 |
See Also
Concepts
Quote, Order and Invoice Entities
SalesOrder (Order) Entity Metadata
SalesOrder (Order) Entity Messages and Methods
Microsoft Dynamics CRM 2011
Send comments about this topic to Microsoft.
© 2013 Microsoft Corporation. All rights reserved.