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	Sales Account
Contained by	Trading Community Organization Details
Handled by	Trading Community Organization
Handled by	Sales Account Service
Handled by	Sales Party
Handled by	Company and User Registration
Handled by	Sales Party Resource Service
Handled by	Sales Party Territory service
Handled by	Partner Service

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. Primary Key
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.