Sales Account

An object used to store sales account profile attributes. A sales account is a sales party with usage as sales account.

QName: {http://xmlns.oracle.com/apps/crmCommon/salesParties/salesPartiesService/}SalesAccount

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

Contains

Sales Account Contact

Contains

Sales Account Resource

Contains

Contact

Contains

Sales Account Territory

Contains

Household

Contains

Trading Community Organization Details

Contains

Account

Contains

Asset

Contains

Trading Community Person Details

Contains

Sales Account Contact Point

Contained by

Sales Party

Handled by

Sales Account Service

Handled by

Sales Party

Attributes

The following table describes attributes in the service data object.

Name Type Description

AccountDirectorId

long

The identifier for the sales account owner.

Asset

Asset

Represents the products owned by customer.

AssgnExceptionFlag

boolean

The indicator shows whether the sales account has the required dimensions to allow the assignment manager to assign territories to the sales account.

AttributeCategory

string

A segment of the user descriptive flex field.

ClassCategory

string

The label displaying the classification category.

ClassCategory1

string

The label displaying the classification category.

ClassCode

string

The label displaying the classification code.

CodeAssignmentId

long

The label displaying the classification code assignment identifier for a sales party.

CorpCurrencyCode

string

The corporate currency code associated with the record. This attribute is used by CRM Extensibility framework.

CpdrfLastUpd

string

The standard replication column.

CpdrfVerPillar

int

The standard replication column.

CpdrfVerSor

int

The standard replication column.

CreatedBy

string

The user who created the record.

CreationDate

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

The date when the record was created.

CurcyConvRateType

string

The currency conversion rate associated with the record. This attribute is used by CRM Extensibility framework.

CurrencyCode

string

The currency code. This attribute is used by CRM Extensibility framework.

DeleteCustomerKey

string

The label for a transient attribute for delete operations in a web services call. If set to Y in WS payload, then sales account profile, its party usage, contact relationships, hierarchies and TCA party will be deleted. If set to N in the payload, then only sales account profile will be deleted.

EndDateActive

{http://xmlns.oracle.com/adf/svc/types/}date-Date

The date after which the record becomes inactive.

ExistingFlag

boolean

The indicator shows whether there is an existing selling or billing relationship with the sales account.

ExistingFlgLastUpdDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

The date when the existing flag was last modified.

Group

Household

The group associated to the sales account.

InternalStatus

string

The label displaying the internal status of a sales account to track if its active or inactive. Values for InternalStatus are active and inactive.

LastAssignedDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

The date indicates when the sales account territory assignment was last run by assignment manager.

LastUpdateDate

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

The date when the record was last updated.

LastUpdateLogin

string

The login of the user who last updated the record.

LastUpdatedBy

string

The user who last updated the record.

Meaning

string

The label displaying the classification category meaning.

NamedAccountFlag

boolean

The indicator shows whether a sales account is a named sales account.

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.

OrganizationD

Account

The organization associated to the sales account.

OrganizationParty

Trading Community Organization Details

The organization associated to the sales account.

PartyId

long

The unique identifier of the contact party.

PartyName

string

The name of the party.

PartyNumber

string

The unique identification number for the party.

PartyType

string

The party type of the contact. The party type can only be Person, Organization, or Group.

PartyUniqueName

string

This is a derived column. For Organization, it is concatenation of unique_name_alias and suffix. For Person, it is concatenation of person_name and suffix.

PartyUniqueName1

string

The label displaying the unique name of a sales party.

PersonD

Contact

The person associated to the sales account.

PersonParty

Trading Community Person Details

The person associated to the sales account.

PrimaryFlag

boolean

The label indicating whether an account is designated primary for a sales party with multiple sales accounts. Values for PrimaryFlag are yes and no.

Rating

int

Indicates the user's favorite rating for the sales account. Users can select a number between 1 to 5 to set or update the favorite rating for the sales account.

SalesAccountContactPoints

Sales Account Contact Point

The contact points associated to the sales account.

SalesAccountContacts

Sales Account Contact

The contacts associated to the sales account.

SalesAccountId

long

The label displaying the internal identifier of a sales party.
  • Primary Key

SalesAccountName

string

Indicates the name of the sales account.

SalesAccountNameSuffix

string

The suffix of the sales account name.

SalesAccountResource

Sales Account Resource

The resources associated to the sales account.

SalesAccountStatus

string

The status value reflecting the current state of the sales account. Values for status are active and inactive.

SalesAccountTerritory

Sales Account Territory

The territories associated to the sales account.

SalesAccountType

string

Type of account, contact or household. For example, customer or prospect.

SalesAccountUniqueName

string

Indicates the sales account unique name.

SellToPartySiteId

long

Indicates the party site id which has usage as SELL_TO.

StartDateActive

{http://xmlns.oracle.com/adf/svc/types/}date-Date

The date on which the record becomes active.

Status

string

The status of the record.

Status1

string

The label displaying the status of a sales account. Sample values for status are active and inactive.

UpdateRating

int

Indicates the user's favorite rating for the sales account. Users can pass a number between 1 to 5 to query sales accounts for which they have given one-star favorite rating to 5-star favorite rating.

UserLastUpdateDate

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

The date and time when the row was last updated.

UserSalesAccountId

long

Identifier of the user who has marked this customer account as a favorite.

ViewApplicationId

long

The label displaying view application.