Reference

The additional reference attributes such as how many times this customer was used as a reference, the opportunities in which they were involved, and associations to case studies and collateral for that reference.

QName: {http://xmlns.oracle.com/apps/sales/baseSales/references/referenceService/}Reference

Logical Business Objects

  • CRM : Sales : Sales Reference Customer

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

Appointment Transient

Contains

Reference Supported Activity

Contains

Classification Assignment

Contains

Referable Product

Contains

Note

Handled by

Sales Reference Customer

Attributes

The following table describes attributes in the service data object.

Name Type Description

Address1

string

The first line of the address.

Appointment

Appointment Transient

Indicates the label for the component showing the list of appointments created for the sales reference customer.

City

string

The name of the city.

ClassCode

string

Indicates the reference primary industry code.

CodeAssignment

Classification Assignment

The classification code assigned to a trading community member.

CodeAssignmentId

long

Indicates the identifier for the reference primary industry record in the Code Assignments table.

Comments

string

The comments for the record.

Country

string

The name of the country.

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.

CurrentFyPotentialRevenue

decimal

The organization's potential revenue for the fiscal year.

CustomerContactPartyId

long

The party ID of the contact that maps to the sales reference customer organization.

CustomerContactRelationId

long

The reference customer contact relationship identifier that is used to identify the customer contact for the reference customer.

DUNSNumberC

string

The nine-digit identification number that is assigned to business entities by Dun and Bradstreet.

EffectiveEndDate

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

The date at the end of the date range within which the row is effective.

EffectiveStartDate

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

The date at the beginning of the date range within which the row is effective.

EmployeesTotal

decimal

The total number of employees.

EndDate

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

Indicates the date till which the entity is active. This date is inclusive and the status of the entity is dependent on this.

FiscalYearendMonth

string

The month when the fiscal year ends for the organization.

IncorpYear

int

The year the business was incorporated.

IndustryName

string

Indicates the reference primary industry name.

IntContactPartyId

long

The party ID of the internal contact that maps to the deploying organization.

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.

NextFyPotentialRevenue

decimal

The organization's potential revenue for next fiscal year.

Note

Note

The note data object that captures comments, information, or instructions for an Oracle Fusion Applications business object.

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.

OrganizationProfileId

long

The unique identifier for organization profiles which is a system-generated primary key.

OrganizationSize

string

The size of an organization based on revenue and number of employees.

PartyId

long

The unique identifier of the contact party.
  • Primary Key

PartyName

string

The name of the party.

PartyName1

string

The reference customer contact name.

PartyName2

string

The reference internal contact name.

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.

PostalCode

string

The postal code element of the address.

PreferredContactPersonId

long

The PARTY_ID of a preferred contact for a given party. There should be a valid relationship.

PreferredFunctionalCurrency

string

The preferred functional currency for the person or organization. The denormalized value of the PREF_FUNCTIONAL_CURRENCY in HZ_PERSON_PROFILES/HZ_ORGANIZATION_PROFILES.

PublicPrivateOwnershipFlag

boolean

Indicates the ownership of the organization, where Y signifies private ownership and N signifies public ownership.

ReferableProduct

Referable Product

The product purchased by a reference customer where the customer agreed to endorse it as part of a reference program.

ReferenceRankNumber

string

The ranking number for a reference.

ReferenceSuppActivity

Reference Supported Activity

The activity type in which the reference customer agreed to engage.

ReferenceTypeCode

string

The level at which a reference is participating in the reference customer program.

RelationshipRecId

long

The sequence-generated unique identifier of the relationship record.

StartDate

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

Indicates the date from which this entity is active. This date is inclusive and the status of an entity is dependent on this.

State

string

The name of the state.

Status

string

The status of the record.

StatusCode

string

The pre-defined code used to indicate the status.

SubjectId

long

The attribute points to reference customer contact party identifier.

URL

string

The destination URL associated with a specific Google AdWords ad.

UserLastUpdateDate

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

The date and time when the row was last updated.