Account
The trading community member of type organization and its profile information.
QName: {http://xmlns.oracle.com/apps/cdm/foundation/parties/organizationService/}OrganizationProfile
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 |
Trading Community Organization Profile Additional Information |
|
Contained by |
|
|
Contained by |
|
|
Handled by |
|
|
Handled by |
|
|
Handled by |
|
|
Handled by |
|
|
Handled by |
|
|
Handled by |
|
|
Handled by |
Attributes
The following table describes attributes in the service data object.
| Name | Type | Description |
|---|---|---|
|
Alias |
string |
The organization alias name. |
|
AnalysisFy |
string |
The fiscal year that the financial information is based on. |
|
BankCode |
string |
Identifies bank in several countries, typically for regulatory purposes. |
|
BankOrBranchNumber |
string |
Stores the bank number for banks and branch number for bank branches, primarily ABA number for US bank branches. |
|
BranchCode |
string |
Identifies bank branch in several countries, typically for regulatory purposes. |
|
BranchFlag |
boolean |
Indicates if this is a branch location. Y for branch locations, N for all other locations. |
|
BusinessReport |
{http://xmlns.oracle.com/adf/svc/types/}base64Binary-DataHandler |
The Dun and Bradstreet business information report. |
|
BusinessScope |
string |
The physical class of business in which a business participates. For example, local, national, or international. |
|
CeoName |
string |
The name of the chief executive officer. It is the denormalized value of the CEO_NAME in HZ_ORGANIZATION_PROFILES. |
|
CeoTitle |
string |
The formal title of the chief executive officer. |
|
CertReasonCode |
string |
The reason for the organization party's current certification level assignment as indicated by the HZ_PARTY_CERT_REASON lookup type. |
|
CertificationLevel |
string |
The certification level the organization party as indicated in the HZ_PARTY_CERT_LEVEL lookup type. |
|
Comments |
string |
The comments for the record. |
|
CongDistCode |
string |
The U.S. congressional district. |
|
ContentSourceNumber |
string |
Not Used. |
|
ControlYr |
decimal |
The year when current ownership gained control. |
|
CorpCurrencyCode |
string |
The corporate currency code associated with the record. This attribute is used by CRM Extensibility framework. |
|
CorporationClass |
string |
The taxation classification for corporation entities. For example, Chapter S in the US. |
|
CreatedBy |
string |
The user who created the record. |
|
CreatedByModule |
string |
The module that 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. |
|
CurrentFiscalYearPotentialRevenueAmount |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
The current fiscal year's potential revenue amount. |
|
DUNSNumberC |
string |
The nine-digit identification number that is assigned to business entities by Dun and Bradstreet. |
|
DataCloudStatus |
string |
Specifies the enrichment status of the person. |
|
DbRating |
string |
The Dun and Bradstreet credit rating. |
|
Disadv8aInd |
string |
Indicates if this company is considered disadvantaged by the US government under title 8A. If the value is True, then the company is a title 8A disadvantaged firm. |
|
DisplayedDUNSPartyIdentifier |
long |
The Dun and Bradstreet does not maintain data for the branch offices of companies that are located outside of North America. Data is only maintained for the company's headquarters. If the data pertains only to a company's headquarters, this column stores the headquarters' PARTY_ID. If the data pertains to a branch office, this column stores the branch's PARTY_ID. |
|
DoNotConfuseWith |
string |
Indicates the existence of similarly named business. |
|
DomesticUltimateDUNSNumberC |
string |
DUNS Number for the Domestic Ultimate, which is the highest family member in the same country as this business entity. A subject may be its own Domestic Ultimate. |
|
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. |
|
EffectiveLatestChange |
string |
Not Used. |
|
EffectiveSequence |
int |
Not Used. |
|
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. |
|
EmployeesAtPrimaryAddress |
string |
The number of employees at the referenced address. |
|
EmployeesAtPrimaryAddressEstimation |
string |
Qualifies calculation of employees at the primary address as estimated. |
|
EmployeesAtPrimaryAddressMinimum |
string |
Qualifies calculation of employees at the primary address as minimum. |
|
EmployeesAtPrimaryAddressText |
string |
The number of employees at the referenced address which cannot be mapped to a number. |
|
EmployeesTotal |
decimal |
The total number of employees. |
|
EnquiryDUNS |
string |
The identifier used to query the Dun and Bradstreet data. If a location is a branch, then in some countries the headquarters DUNS number is used to do the query. Otherwise it is the same as the DUNS number. |
|
ExportInd |
string |
Indicates if this company is an exporter. If the value is True, then the company is an exporter. |
|
FiscalYearendMonth |
string |
The month when the fiscal year ends for the organization. |
|
GSAIndicatorFlag |
boolean |
Indicates if this is a US federal agency supported by the General Services Administration (GSA). If the value is True, then the organization is served by the GSA. |
|
GlobalUltimateDUNSNumberC |
string |
DUNS Number for the Global Ultimate, which is the highest family member in the same country as this business entity as you walk up this branch of the tree. A case may be its own ultimate. |
|
GrowthStrategyDescription |
string |
The growth strategy description. |
|
HQBranchIndicator |
string |
The status of this site. Identifies if the location is the HQ, a branch, or a single location. |
|
HomeCountry |
string |
The home country associated with the party. |
|
IdenAddrLocationId |
long |
The unique identifier of the location of the identifying address. |
|
IdenAddrPartySiteId |
long |
The unique identifier of the party site of the identifying address. |
|
ImportInd |
string |
Indicates if this company is an importer. If the value is True, then the company is an importer. |
|
IncorpYear |
int |
The year that the business was incorporated. |
|
InternalFlag |
boolean |
The denormalized value of the INTERNAL_FLAG in HZ_PERSON_PROFILES/HZ_ORGANIZATION_PROFILES. |
|
JgzzFiscalCode |
string |
The taxpayer identification number. It can be the unique identifier of the person or organization. It can also be the SSN or income taxpayer ID in US, fiscal code or NIF in Europe. |
|
LaborSurplusInd |
string |
Indicates if this company operates in an area with a labor surplus. If the value is True, then the area has a labor surplus. |
|
LastEnrichmentDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
Specifies date this person was last enriched in DaaS. |
|
LastSourceUpdateDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
The date on which the record was last updated by the source system. |
|
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. |
|
LastUpdateSourceSystem |
string |
The source system that last updated this record. |
|
LastUpdatedBy |
string |
The user who last updated the record. |
|
LegalStatus |
string |
The legal structure, such as partnership, corporation, and so on. |
|
LineOfBusiness |
string |
The type of business activities performed at this site. |
|
LocalActivityCode |
string |
The local activity classification code. |
|
LocalActivityCodeType |
string |
The local activity classification code type identifier. |
|
LocalBusIdenType |
string |
The lookup that represents most common business identifier in a country. For example, Chamber of Commerce Number in Italy, Government Registration Number in Taiwan. |
|
LocalBusIdentifier |
string |
The primary identifier assigned to businesses by government agency, Chamber of Commerce, or other authority. Generally used outside the US. |
|
MinorityOwnedInd |
string |
Indicates if this company is primarily owned by ethnic or racial minorities. If the value is True, then the company is a minority-owned firm. |
|
MinorityOwnedType |
string |
The type of minority-owned firm. |
|
MissionStatement |
string |
The corporate charter of organization. |
|
NextFyPotentialRevenueAmount |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
The organization's potential revenue for next fiscal year. |
|
OobInd |
string |
Indicates if this organization is out of business. If the value is True, then the organization is out of business. |
|
OrgInformation |
Trading Community Organization Profile Additional Information |
The organization's information. |
|
OrganizationName |
string |
The name of the party when the party type is Organization. |
|
OrganizationProfileId |
long |
The unique identifier for organization profiles. This attribute is system-generated and is a primary key.
|
|
OrganizationSize |
string |
The size of an organization based on revenue, number of employees etc. |
|
OrganizationType |
string |
Not used in Fusion V1. |
|
OrigSystem |
string |
The source system name. |
|
OrigSystemReference |
string |
The identifier for the record from the original system. |
|
ParentDUNSNumberC |
string |
Parent is a corporation that owns more than 50% of another corporation's capital stock. The parent company can also be a subsidiary of another corporation. If the parent also has branches, then it is a headquarters as well as being a parent company. A headquarters is a business establishment that has branches or divisions reporting to it, and is financially responsible for those branches or divisions. If the headquarters has more than 50% of capital stock owned by another corporation, it also will be a subsidiary. If it owns more than 50% of capital stock of another corporation, then it is also a parent. |
|
ParentSubInd |
string |
The lookup that indicates if the organization is a parent or subsidiary location. |
|
PartyId |
long |
The unique identifier of the contact party. |
|
PartyNumber |
string |
The unique identification number for the party. |
|
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. |
|
PreferredContactEmailAddress |
string |
The e-mail address of the primary contact person of the organization. |
|
PreferredContactFormattedPhoneNumber |
string |
The formatted phone number of the primary contact person of the organization. |
|
PreferredContactMethod |
string |
The preferred contact method for a person or organization. It is validated against lookup HZ_PREFERRED_CONTACT_METHOD. |
|
PreferredContactName |
string |
The name of the primary contact person of the organization. |
|
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. |
|
PreferredName |
string |
The denormalized value of the PARTY_NAME field in HZ_ADDTNL_PARTY_NAMES identified by PREFERRED_NAME_ID. |
|
PreferredNameId |
long |
The foreign key to PARTY_NAME_ID in HZ_ADDTNL_PARTY_NAMES. It contains the ID of the referred name for the party. If it is NULL the Profile Name will be used as preferred name. By default the value is NULL. |
|
PrimaryAddressCity |
string |
The city of the identifying address. |
|
PrimaryAddressCountry |
string |
The country listed in the TERRITORY_CODE column of the FND_TERRITORY table, for the identifying address. |
|
PrimaryAddressCounty |
string |
The county of the identifying address. |
|
PrimaryAddressLine1 |
string |
The first line of the identifying address. |
|
PrimaryAddressLine2 |
string |
The second line of the identifying address. |
|
PrimaryAddressLine3 |
string |
The third line of the identifying address. |
|
PrimaryAddressLine4 |
string |
The fourth line of the identifying address. |
|
PrimaryAddressPostalCode |
string |
The postal code of the identifying address. |
|
PrimaryAddressProvince |
string |
The province of the identifying address. |
|
PrimaryAddressState |
string |
The state of the identifying address. |
|
PrimaryEmailAddress |
string |
The e-mail address of the organization. |
|
PrimaryEmailId |
long |
The primary e-mail contact point ID of the organization. |
|
PrimaryFormattedPhoneNumber |
string |
The primary telephone number of the organization formatted in the local format. |
|
PrimaryLanguage |
string |
The standard name for a language. |
|
PrimaryPhoneAreaCode |
string |
The area code within a country code. |
|
PrimaryPhoneCountryCode |
string |
The international country code for a telephone number. For example, it is 33 for France. |
|
PrimaryPhoneExtension |
string |
The additional number required after initial connection to an internal telephone system. |
|
PrimaryPhoneId |
long |
The primary contact point phone ID of the organization. |
|
PrimaryPhoneLineType |
string |
The lookup code for the type of phone line. For example, general, fax, inbound or outbound, and so on. |
|
PrimaryPhoneNumber |
string |
The telephone number in local format. The number should not include country code, area code, or extension. |
|
PrimaryPhonePurpose |
string |
The contact point type, such as business or personal. |
|
PrimaryURL |
string |
The uniform resource locator. |
|
PrimaryWebId |
long |
The unique identifier of the primary uniform resource locator. |
|
PrincipalName |
string |
The name of the highest ranking person in the company. |
|
PrincipalTitle |
string |
The title of the highest ranking person in the company. |
|
Pronunciation |
string |
The organization's pronunciation. |
|
PublicPrivateOwnershipFlag |
boolean |
Indicates if the organization is privately owned. If the value is True, then the organization is privately owned. |
|
RegistrationType |
string |
The lookup for the type of registration, such as nonprofit. |
|
RentOwnInd |
string |
Indicates if this company owns or rents its place of business. Lookup of values for rent, own, lease, and so on. |
|
RequestId |
long |
A system-generated read-only attribute used by the application framework. |
|
SICCode |
string |
The Standard Industry Classification (SIC) code. |
|
SICCodeType |
string |
The version of Standard Industry Classification (SIC) code. |
|
SeblUserKeyLoc |
string |
The location of account. This is optional part of the user primary key. |
|
SmallBusInd |
string |
Indicates if this company is considered to be a small business. If the value is True, then the company is considered a small business. |
|
Status |
string |
The status of the record. |
|
StockSymbol |
string |
The corporate stock symbol, such as ORCL. |
|
SuffixOverriddenFlag |
boolean |
Indicates if the suffix is overridden by the user. If the value is True, then the suffix is overridden by user. The default value is False. |
|
ThirdPartyFlag |
boolean |
Tracks if a party has a direct relationship with the organization using Oracle Receivables or through a third party vendor. Y for a third party relationship, N for a direct relationship. If Oracle Service is installed, then the Third Party field in the Customers window is mandatory. |
|
TotalEmployeesEstimatedIndicator |
string |
The lookup that indicates whether the employee total is estimated. A for estimated, N for not estimated or actual. |
|
TotalEmployeesInd |
string |
The lookup that indicates whether subsidiaries are included in the calculation of total employees A for totals without subsidiaries, B for totals with subsidiaries. |
|
TotalEmployeesMinimumIndicator |
string |
The lookup that indicates whether the number is a minimum, maximum, or average number of total employees. A for minimum, B for maximum, and C for average. |
|
TotalEmployeesText |
string |
The total number of personnel employed if cannot be mapped to numeric field. |
|
TotalPaymentAmount |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
The total number of payment experiences. |
|
TradingPartnerIdentifier |
string |
The column to store the FSIO related trading partner codes. This column stores alpha numeric values. It also takes care of the "Fed vs. Non-Fed" attribute requirement. |
|
UniqueNameAlias |
string |
The name as captured by the users to internally identify the organization. |
|
UniqueNameSuffix |
string |
Captures system generated or manually overridden suffix. |
|
ValidatedFlag |
boolean |
Indicates whether the entity was validated. If the value is Y then the entity was validated. |
|
WomanOwnedInd |
string |
Indicates if this company is primarily owned by women. If the value is True, then the company is a woman-owned firm. |
|
YearEstablished |
int |
The year when the organization began doing business. |