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. |