Parties
The party view object stores basic information about parties. Although a record in the view represents a unique party, multiple parties can have the same name with unique party identifier. The parties can be Organization, Person, or Group.
Data Store Key : CrmAnalyticsAM.CrmExtractAM.HzBiccExtractAM.PartyExtractPVO
Primary Keys : PartyId
Initial Extract Date : CreationDate
Incremental Extract Date : LastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| Address1 | First line of the identifying address. |
| Address2 | Second line of the identifying address. |
| Address3 | Third line of the identifying address. |
| Address4 | Fourth line of the identifying address. |
| AnalysisFy | Fiscal year that financial information is based on. |
| Attribute1 | A segment for the Party descriptive flexfield. |
| Attribute10 | A segment for the Party descriptive flexfield. |
| Attribute11 | A segment for the Party descriptive flexfield. |
| Attribute12 | A segment for the Party descriptive flexfield. |
| Attribute13 | A segment for the Party descriptive flexfield. |
| Attribute14 | A segment for the Party descriptive flexfield. |
| Attribute15 | A segment for the Party descriptive flexfield. |
| Attribute16 | A segment for the Party descriptive flexfield. |
| Attribute17 | A segment for the Party descriptive flexfield. |
| Attribute18 | A segment for the Party descriptive flexfield. |
| Attribute19 | A segment for the Party descriptive flexfield. |
| Attribute2 | A segment for the Party descriptive flexfield. |
| Attribute20 | A segment for the Party descriptive flexfield. |
| Attribute21 | A segment for the Party descriptive flexfield. |
| Attribute22 | A segment for the Party descriptive flexfield. |
| Attribute23 | A segment for the Party descriptive flexfield. |
| Attribute24 | A segment for the Party descriptive flexfield. |
| Attribute25 | A segment for the Party descriptive flexfield. |
| Attribute26 | A segment for the Party descriptive flexfield. |
| Attribute27 | A segment for the Party descriptive flexfield. |
| Attribute28 | A segment for the Party descriptive flexfield. |
| Attribute29 | A segment for the Party descriptive flexfield. |
| Attribute3 | A segment for the Party descriptive flexfield. |
| Attribute30 | A segment for the Party descriptive flexfield. |
| Attribute4 | A segment for the Party descriptive flexfield. |
| Attribute5 | A segment for the Party descriptive flexfield. |
| Attribute6 | A segment for the Party descriptive flexfield. |
| Attribute7 | A segment for the Party descriptive flexfield. |
| Attribute8 | A segment for the Party descriptive flexfield. |
| Attribute9 | A segment for the Party descriptive flexfield. |
| AttributeCategory | The context name for the Party descriptive flexfield. |
| AttributeDate1 | A date segment for the Party descriptive flexfield. |
| AttributeDate10 | A date segment for the Party descriptive flexfield. |
| AttributeDate11 | A date segment for the Party descriptive flexfield. |
| AttributeDate12 | A date segment for the Party descriptive flexfield. |
| AttributeDate2 | A date segment for the Party descriptive flexfield. |
| AttributeDate3 | A date segment for the Party descriptive flexfield. |
| AttributeDate4 | A date segment for the Party descriptive flexfield. |
| AttributeDate5 | A date segment for the Party descriptive flexfield. |
| AttributeDate6 | A date segment for the Party descriptive flexfield. |
| AttributeDate7 | A date segment for the Party descriptive flexfield. |
| AttributeDate8 | A date segment for the Party descriptive flexfield. |
| AttributeDate9 | A date segment for the Party descriptive flexfield. |
| AttributeNumber1 | A number segment for the Party descriptive flexfield. |
| AttributeNumber10 | A number segment for the Party descriptive flexfield. |
| AttributeNumber11 | A number segment for the Party descriptive flexfield. |
| AttributeNumber12 | A number segment for the Party descriptive flexfield. |
| AttributeNumber2 | A number segment for the Party descriptive flexfield. |
| AttributeNumber3 | A number segment for the Party descriptive flexfield. |
| AttributeNumber4 | A number segment for the Party descriptive flexfield. |
| AttributeNumber5 | A number segment for the Party descriptive flexfield. |
| AttributeNumber6 | A number segment for the Party descriptive flexfield. |
| AttributeNumber7 | A number segment for the Party descriptive flexfield. |
| AttributeNumber8 | A number segment for the Party descriptive flexfield. |
| AttributeNumber9 | A number segment for the Party descriptive flexfield. |
| CategoryCode | The user-definable code indicates the category of the party. A list of valid category codes is defined using the lookup CUSTOMER_CATEGORY. Review and update the codes using the Setup and Maintenance work area, Manage Trading Community Common Lookups task. |
| CeoName | The name of the party's chief executive officer. |
| CertReasonCode | The code indicating the reason for the organization party's current certification level assignment. A list of valid certification reason codes are defined using the lookup HZ_PARTY_CERT_REASON. Review and update the codes using the Setup and Maintenance work area, Manage Trading Community Common Lookups task. |
| CertificationLevel | The certification level of the organization party. A list of valid certification level codes is defined using the lookup HZ_PARTY_CERT_LEVEL. Review and update the codes using the Setup and Maintenance work area, Manage Trading Community Common Lookups task. |
| City | The city of the identifying address. |
| Comments | It's a denormalization column stores the description for a group. |
| Country | The country of the identifying address |
| County | The county of the Identifying address |
| CreatedBy | The user who created the record. |
| CreatedByModule | The module through which the record was created. |
| CreationDate | The date and time of creating the record. |
| CurrFyPotentialRevenue | The organization's potential revenue for this fiscal year. |
| DateOfBirth | A denormalization column of person stores the date the person was born. |
| DunsNumberC | Stores the DUNS_NUMBER in VARCHAR format which the value isn't restricted to nine digit Duns Number. |
| EmailAddress | The email address of the party associated with. |
| EmployeesTotal | The total number of employees in the organization. |
| FiscalYearendMonth | The month in which fiscal year ends for the organization. |
| Gender | A denormalization column of person stores the gender such as male, female, or unknown of the person. |
| GroupType | The the group type code of the party. |
| GsaIndicatorFlag | Indicates if this is a US federal agency supported by the General Services Administration (GSA). Y for organizations served by the GSA, N for organizations that aren't served by the GSA. |
| HomeCountry | The home country of the organization. |
| HqBranchInd | The status of this site, such as HQ, a branch, or a single location. A list of accepted values are defined in the lookup type HQ_BRANCH_IND. |
| IdenAddrLocationId | The unique identifier of the location of the identifying address. |
| IdenAddrPartySiteId | The unique identifier of the party site of the identifying address. |
| InternalFlag | This a denormalization column. For person, the internal flag indicates whether the person is internal or external to the user's organization. For organization, the internal flag indicates whether this is an internal organization or external organization. |
| JgzzFiscalCode | The taxpayer identification number, often unique identifier of person or organization. Can be SSN or income taxpayer ID in US, fiscal code or NIF in Europe. |
| LanguageName | The standard name for a language, example US. |
| LastUpdateDate | The date and time of last update of the record. |
| LastUpdateLogin | The login of the user who last updated the record. |
| LastUpdatedBy | The user who last updated the record. |
| MaritalStatus | A denormalization column of person stores the marital status of the person. |
| MasterPartyId | The unique identifier of the master party associated with the nonduplicate record which provides the link between survivor and victim records. |
| MissionStatement | Corporate charter of organization |
| NextFyPotentialRevenue | The organization's potential revenue for its next fiscal year. |
| ObjectType | The object type for internal use. |
| OrigSystemReference | The customer identifier from foreign system. May not be unique. |
| PartyId | The unique identifier of party. This is the primary key of the party view. |
| PartyName | The name of this party. |
| PartyNumber | The unique identification number for this party. |
| PartyType | The type of the party, such as Person, Organization, Group. |
| PartyUniqueName | This is a derived column. For Organization, it's concatenation of unique_name_alias and suffix. For Person, it's concatenation of person_name and suffix. |
| PersonAcademicTitle | The academic title that's part of a person's name, such as Dr. John Smith. |
| PersonFirstName | The first name of the person. |
| PersonLastName | The last or surname of the person. |
| PersonLastNamePrefix | The prefix for the last name of a person. |
| PersonMiddleName | The middle name of the person. |
| PersonNameSuffix | The suffix for the name of a person. |
| PersonPreNameAdjunct | The preferred name adjacency of a person, such as Mr. or Herr. |
| PersonPreviousLastName | The previous last or surname of a person. |
| PersonSecondLastName | The second last name for a person. |
| PersonTitle | A professional or family title. For example, Don or The Right Honorable. |
| PersonalAddressFlag | Indicates whether the primary address is the personal address of the contact. |
| PersonalEmailFlag | Indicates whether the primary E-mail is the personal E-mail address of the contact. |
| PersonalPhoneFlag | Indicates whether the primary phone is the personal phone of the contact. |
| PostalCode | The postal code of the identifying address. |
| PrefFunctionalCurrency | The default currency code for this person or organization. |
| PreferredContactMethod | How a person prefers to be contacted. Validated against lookup HZ_PREFERRED_CONTACT_METHOD. |
| PreferredContactPersonId | The unique identifier of the preferred contact person for this party. |
| PreferredName | The preferred name for this party. |
| PreferredNameId | The ID of the preferred name for the party. If NULL, the profile name, the name contained in the profile, will be used as the preferred name. By default the value is NULL. |
| PrimaryEmailContactPtId | The unique identifier of the primary E-mail. |
| PrimaryPhoneAreaCode | The phone area code of the party. |
| PrimaryPhoneContactPtId | The unique identifier of the primary phone. |
| PrimaryPhoneCountryCode | The phone country code of the party. For example, 33 for France. |
| PrimaryPhoneExtension | The phone extension code of the party. |
| PrimaryPhoneLineType | The type of the phone line of the party. For example, general, fax, inbound or outbound. |
| PrimaryPhoneNumber | The primary phone number of the party. The number should not include country code, area code, or extension. |
| PrimaryPhonePurpose | Contact point phone purpose type, such as business or personal |
| PrimaryUrlContactPtId | The unique identifier of the primary uniform resource locator. |
| Province | The province of the Identifying address. |
| SalesAccountId | The unique identifier of the sales account. |
| Salutation | A phrase used to address a party in any correspondence. |
| SicCode | The standard Industry Classification (SIC) code of the party. |
| SicCodeType | The version of Standard Industry Classification (SIC) code of the party. |
| State | The state of the identifying address. |
| Status | The status of the record. |
| ThirdPartyFlag | Indicates whether the party is a third party. Tracks if a party has a direct relationship with the organization using Oracle Receivables or through a third party. Y for a third party relationship, N for a direct relationship. If Oracle Service is installed, the Third Party field in the Customers window is mandatory. |
| TradingPartnerIdentifier | The FSIO related trading partner codes. |
| Url | The uniform resource locator or a website containing information about the party. |
| UserGuid | The global unique identifier of the user. |
| UserLastUpdateDate | The date and time when the record was last updated. This value is different from LAST_UPDATE_DATE if the update originally happened in a different database such as a different mobile database or the server). |
| ValidatedFlag | Indicates whether the party was validated. Y for a validated party, N for a party that isn't validated. |
| YearEstablished | The year that the organization began doing business |