Sales Order
The name of the service data object used to integrate quotes and sales orders.
QName: {http://xmlns.oracle.com/apps/crmCommon/orders/salesOrdersService/}SalesOrderHeader
Logical Business Objects
-
CRM : Common CRM : Sales Transaction
Relationships
The following table describes how this service data object is related to other service data objects or business object services.
| Relationship Type | Object or Service |
|---|---|
|
Handled by |
Attributes
The following table describes attributes in the service data object.
| Name | Type | Description |
|---|---|---|
|
AccountBasedQuoteFlag |
boolean |
Indicates if this quote / order record is account based quote or not. |
|
ActiveVersionFlag |
boolean |
The active version flag. |
|
BUOrgId |
long |
The business unit (Internal Organization) to which this Quote / Order belongs. |
|
ContractEndDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
The latest end date for all the line items within the quote |
|
ContractStartDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
The earliest start date for all the items within the quote |
|
CurrencyCode |
string |
The currency code. This attribute is used by CRM Extensibility framework. |
|
DeleteFlag |
boolean |
This flag controls if the user has access to delete the record |
|
Description |
string |
The free text description of the record. |
|
ExpirationDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
The expiration date of the quote or order. |
|
ExternalHostName |
string |
The name of the CPQ site |
|
ExternalProcessName |
string |
The name of the process for a CPQ site |
|
ExternalQuoteNumber |
string |
Identifier from source system that created this Quote |
|
ExternalReferenceNumber |
string |
The identifier for the external quote/order. |
|
ExternalSystemReferenceCode |
string |
The external reference(Third party) type for the quote or order. Big machines will pass BMQUOTE. |
|
LastOptySyncDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
The last opportunity sync date for the quote to identify the active version of the quote for the opportunity. |
|
LastUpdateDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
The date when the record was last updated. |
|
Name |
string |
Stores the quote/order name. |
|
ObjectVersionNumber |
int |
The number used to implement locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to determine whether another session has updated the row. |
|
OptyId |
long |
The unique identifier of the opportunity. |
|
OrderHeaderId |
long |
The unique identifier for the quote or order.
|
|
OrderHeaderNumber |
string |
Order Header Number for the Quote or Order. This is a public surrogate key. |
|
OrderTotal |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
The total amount. |
|
Owner |
string |
The quote owner. |
|
OwnerResourcePartyId |
long |
The resource identifier of the owner party |
|
OwnerResourcePartyName |
string |
The party name of the owner |
|
PlacedOnDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
The date on which the order was placed. |
|
ProposalExistFlag |
boolean |
Identifies the associated proposal for the quote. Valid values are Y or N. |
|
QuoteTypeCategory |
string |
If renewal process is set is this quote a renewal subscription or expansion to a subscription. |
|
RenewalProcess |
string |
The renewal process that will be used to renew the Quotes and Orders |
|
SalesAccountUniqueName |
string |
Name of the customer account |
|
SoldContactPartyId |
long |
The customer contact party identifier. |
|
SoldCustomerPartyId |
long |
The customer party identifier. |
|
SoldCustomerPartyUniqueName |
string |
Customer Party Unique Name |
|
SoldPartySiteId |
long |
The customer address identifier. |
|
Status |
string |
The status of the record. |
|
TotalMonthlyRecurringRevenue |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
The total monthly recurring revenue for the quote |
|
TotalMonthlyUsageRevenue |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
The total monthly usage revenue for the quote |
|
TotalNonRecurringRevenue |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
The total nonrecurring revenue for the quote. |
|
TotalRecurringRevenue |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
The total recurring revenue for the quote |
|
TotalUsageRevenue |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
The total usage revenue for the quote |
|
UpdateFlag |
boolean |
This flag controls if the user has access to update the record |
|
VersionNumber |
long |
The version number of the quote/order. |
|
WinStatusCode |
string |
The lookup code for lookup type=ORA_ZCA_WIN_STATUS. |