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 |
|
|
Contains |
|
|
Contains |
|
|
Contains |
|
|
Contains |
|
|
Handled by |
Attributes
The following table describes attributes in the service data object.
| Name | Type | Description |
|---|---|---|
|
Address1 |
string |
The first line of the address. |
|
Appointment |
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 |
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 |
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.
|
|
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 |
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 |
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. |