Account
An organization account 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 the bank in several countries, typically for regulatory purposes. |
BankOrBranchNumber |
string |
Stores bank number for banks and branch number for bank branches. Primarily stores ABA number for US bank branches. |
BranchCode |
string |
Identifies the bank branch in several countries, typically for regulatory purposes. |
BranchFlag |
boolean |
Indicates if this is a branch location. If the value is True, then this is a branch location. |
BusinessReport |
{http://xmlns.oracle.com/adf/svc/types/}base64Binary-DataHandler |
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 code for the account. |
ContentSourceNumber |
string |
The content source number is not used. |
ControlYr |
decimal |
The year when current ownership gained control of the organization. |
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 such as 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 estimated revenues that can be earned by the organization during its current fiscal year. |
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 & Bradstreet credit rating. |
Disadv8aInd |
string |
Indicates whether the organization is considered disadvantaged by the US government under Title 8A. If the value is Yes, the organization is considered disadvantaged under Title 8A. The default value is No. |
DisplayedDUNSPartyIdentifier |
long |
Dun and Bradstreet does not maintain data for the branch offices of companies that are located beyond North America. Data is only maintained for the company headquarters. If the data pertains only to company headquarters, the headquarters PARTY_ID is stored. If the data pertains to a branch office, the branch PARTY_ID is stored. |
DoNotConfuseWith |
string |
Indicates existence of similarly named businesses. |
DomesticUltimateDUNSNumberC |
string |
DUNS Number for the Domestic Ultimate, which is the highest family member in the same country as the business entity. A subject can 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 |
The effective latest change is not used. |
EffectiveSequence |
int |
The effective sequence is 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 |
Indicates the calculation of employees at the primary address as estimated. |
EmployeesAtPrimaryAddressMinimum |
string |
Indicates the calculation of employees at the primary address as minimum. |
EmployeesAtPrimaryAddressText |
string |
The number of employees at the referenced address that 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 whether the organization is an exporter. If the value is Y, then the organization is an exporter. The default value is N. |
FiscalYearendMonth |
string |
The month when the fiscal year ends for the organization. |
GSAIndicatorFlag |
boolean |
Indicates whether organization is a US federal agency supported by the General Services Administration (GSA). If the value is Y, then the organization is supported by GSA. The default value is N. If this attribute is not explicitly mentioned in the payload while creating an account, then the value of this attribute is set to null. |
GlobalUltimateDUNSNumberC |
string |
DUNS Number for the Global Ultimate, which is the highest family member in the same country as the business entity as you proceed further on this branch of the tree. A case can be its own ultimate. |
GrowthStrategyDescription |
string |
The description of the growth strategy. |
HQBranchIndicator |
string |
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. |
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 whether the organization is an importer. If the value is Y, then the organization is an importer. The default value is N. |
IncorpYear |
int |
The year that the business was formally 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 whether the organization operates in an area with a labor surplus. If the value is Y, then the organization operates in an area with a labor surplus. The default value is N. |
LastEnrichmentDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
The date when the person was last enriched in DaaS. |
LastSourceUpdateDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
The date when 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 the record. |
LastUpdatedBy |
string |
The user who last updated the record. |
LegalStatus |
string |
The legal structure of the organization 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 most common business identifiers in a country such as Chamber of Commerce Number in Italy, Government Registration Number in Taiwan. A list of accepted values are defined in the lookup type LOCAL_BUS_IDEN_TYPE. |
LocalBusIdentifier |
string |
The primary identifier assigned to a businesses by a government agency such as Chamber of Commerce, or other authority. It is often used by countries other than USA. |
MinorityOwnedInd |
string |
Indicates whether the organization is primarily owned by ethnic or racial minorities. If the value is Y, then the organization is owned by ethnic or racial minorities. The default value is N. |
MinorityOwnedType |
string |
The type of minority-owned firm. |
MissionStatement |
string |
The corporate charter of organization in user-defined text format. |
NextFyPotentialRevenueAmount |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
The estimated revenues that can be earned by the organization during its next fiscal year. |
OobInd |
string |
Indicates whether the organization is out of business. If the value is Y, then the organization is out of business. The default value is N. |
OrgInformation |
Trading Community Organization Profile Additional Information |
The information of the organization. |
OrganizationName |
string |
The name of the party when the party type is Organization. |
OrganizationProfileId |
long |
The unique identifier of the organization profile.
|
OrganizationSize |
string |
Size of an organization based on revenue, number of employees, and so on. |
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 percent capital stock of another corporation. The parent company can also be a subsidiary of another corporation. If the parent also has branches, then it is headquarters and also parent company. 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 percent of capital stock owned by another corporation, then it is also a subsidiary. If it owns more than 50 percent of capital stock of another corporation, then it is also a parent. |
ParentSubInd |
string |
Indicates whether the organization is a parent or subsidiary. |
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 formatted in the local format of the organization. |
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 primary 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 organization. |
Pronunciation |
string |
The pronunciation of the organization. |
PublicPrivateOwnershipFlag |
boolean |
Indicator to specify if the organization is privately owned. Y stands for a privately owned organization and N stands for a publicly owned organization. |
RegistrationType |
string |
Indicates the registration type of the organization. |
RentOwnInd |
string |
Indicates if this account owns or rents the place of business. A list of valid values for rent, own, and lease are defined in the lookup OWN_RENT_IND. |
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 the standard industry classification (SIC) code. |
SeblUserKeyLoc |
string |
The location of the account, optional part of the user primary key. |
SmallBusInd |
string |
Indicates whether the organization is considered as a small business. If the value is Y, then the organization is considered as a small business. The default value is N. |
Status |
string |
The status of the record. |
StockSymbol |
string |
The corporate stock symbol such as ORCL. |
SuffixOverriddenFlag |
boolean |
Indicator to specify that the attribute has Y if the suffix is overridden by user and N otherwise. Default value is N. |
ThirdPartyFlag |
boolean |
Indicator that tracks if a party has a direct relationship with the organization using Oracle Receivables or through a third party vendor. Y stands for a third party relationship, N stands for a direct relationship. If Oracle Service is installed, the third party field in the Customers window is required. |
TotalEmployeesEstimatedIndicator |
string |
Indicates if the employee total is estimated. The accepted values are defined in the lookup type TOTAL_EMP_EST_IND. |
TotalEmployeesInd |
string |
Indicates if subsidiaries are included in the calculation of total employees. The accepted values are defined in the lookup type TOTAL_EMPLOYEES_INDICATOR. |
TotalEmployeesMinimumIndicator |
string |
Indicates if the number is a minimum, maximum, or average number of total employees. The accepted values are defined in the lookup type TOTAL_EMP_MIN_IND. |
TotalEmployeesText |
string |
The total number of employees in text format. |
TotalPaymentAmount |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
The total number of payment experiences. |
TradingPartnerIdentifier |
string |
One column to store the FSIO related trading partner codes. It stores alpha numeric values and also addresses the Fed vs. Non-Fed attribute requirement. |
UniqueNameAlias |
string |
The name as identified by the users to internally recognize the organization. |
UniqueNameSuffix |
string |
Identifies 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 whether the organization is primarily owned by women. If the value is Y, then the organization is primarily owned by women. The default value is N. |
YearEstablished |
int |
The year when the organization began doing business. |