Trading Community Organization Details

Organization details.

QName: {http://xmlns.oracle.com/apps/cdm/foundation/parties/organizationService/}OrganizationParty

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

Account

Contains

Address

Contains

Additional Account Name

Contains

Electronic Data Interchange

Contains

Electronic File Transfer

Contains

Source System Reference

Contains

E-Mail

Contains

Web

Contains

Credit Rating

Contains

Phone

Contains

Contact Preference

Contains

Additional Identifier

Contains

Telex

Contains

Classification Assignment

Contains

Financial Profile

Contains

Relationship

Contains

Instant Messaging

Contains

Usage Assignment

Contains

Certification

Contains

Preference

Contains

E-Mail Domain

Contains

Financial Report

Contained by

Sales Party

Contained by

Sales Party Resource

Contained by

My Sales Account

Contained by

Sales Account

Contained by

Sales Party Territory

Handled by

Trading Community Organization

Handled by

Company and User Registration

Handled by

Sales Account Service

Handled by

Sales Party

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

AdditionalOrganizationName

Additional Account Name

The additional name associated with the organization.

AdditionalPartyId

Additional Identifier

The additional identifier for the organization.

Address1

string

The first line of the address.

Address2

string

The second line of the address.

Address3

string

The third line of the address.

Address4

string

The fourth line of the address.

AnalysisFy

string

The fiscal year that the financial information is based on.

CategoryCode

string

The user-definable category. Lookup type is CUSTOMER_CATEGORY.

CeoName

string

The name of the chief executive officer. It is the denormalized value of the CEO_NAME in HZ_ORGANIZATION_PROFILES.

CertReasonCode

string

The reason for the organization party's current certification level assignment as indicated by the HZ_PARTY_CERT_REASON lookup type.

Certification

Certification

The certification information associated with the organization.

CertificationLevel

string

The certification level the organization party as indicated in the HZ_PARTY_CERT_LEVEL lookup type.

City

string

The name of the city.

CodeAssignment

Classification Assignment

The classification code assigned to the organization.

Comments

string

The comments for the record.

ContactPreference

Contact Preference

The contact preference associated with the record.

Country

string

The name of the country.

County

string

The name of the county.

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.

CreditRating

Credit Rating

The credit rating information for the organization.

CurrentFiscalYearPotentialRevenueAmount

{http://xmlns.oracle.com/adf/svc/types/}AmountType

The organization's potential revenue this fiscal year.

DUNSNumberC

string

The nine-digit identification number that is assigned to business entities by Dun and Bradstreet.

Edi

Electronic Data Interchange

The electronic data interchange information for the organization.

Eft

Electronic File Transfer

The electronic file transfer information for the organization.

Email

E-Mail

The email address associated with the record.

EmailAddress

string

The email address associated with the record.

EmailDomain

E-Mail Domain

The e-mail domain information for the organization.

EmployeesTotal

decimal

The total number of employees.

FinancialProfile

Financial Profile

The financial profile information of the organization.

FinancialReport

Financial Report

The financial report information of the organization.

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.

GroupType

string

The lookup for group type.

HQBranchIndicator

string

The status of this site. Identifies if the location is the headquarters, 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.

InstantMessaging

Instant Messaging

The instant messaging information related to the record.

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.

LanguageName

string

The standard name for a language.

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.

MissionStatement

string

The corporate charter of organization.

NextFyPotentialRevenueAmount

{http://xmlns.oracle.com/adf/svc/types/}AmountType

The organization's potential revenue for the next fiscal year.

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.

OrganizationProfile

Account

The organization's profile information.

OrganizationSize

string

The size of an organization based on revenue, number of employees etc.

OrigSystemReference

string

The identifier for the record from the original system.

OriginalSystemReference

Source System Reference

The identifier for the record from the original system.

PartyId

long

The unique identifier of the contact party.
  • Primary Key

PartyName

string

The name of the party.

PartyNumber

string

The unique identification number for the party.

PartyPreference

Preference

The preference information of the organization.

PartySite

Address

The address information for the organization.

PartyType

string

The party type of the contact. The party type can only be Person, Organization, or Group.

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.

PartyUsageAssignment

Usage Assignment

The party usage assignment information for the organization.

PersonSecondLastName

string

The second last name for a person. In some cultures it is not uncommon to have double last names. It is used in the same way the field PERSON_SECOND_LAST_NAME in HZ_PERSON_PROFILES is used.

Phone

Phone

The phone information for the entity.

PostalCode

string

The postal code element of the address.

PreferredContactMethod

string

The preferred contact method for a person or organization. It is validated against lookup HZ_PREFERRED_CONTACT_METHOD.

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.

PrimaryEmailContactPointId

long

The unique identifier of the primary e-mail.

PrimaryPhoneAreaCode

string

The area code within a country code.

PrimaryPhoneContactPointId

long

The unique identifier of this contact point.

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.

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.

PrimaryURLContactPointId

long

The unique identifier of the primary uniform resource locator.

PrincipalName

string

The name of the highest ranking person in the company. Set this attribute in Organization Profile.

Province

string

The name of the province.

Relationship

Relationship

The relationship information for the organization.

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.

SourceSystem

string

The source system name where the record originated.

SourceSystemReferenceValue

string

The identifier for the record from an external source system.

SourceSystemUpdateDate

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

The date on which the record was last updated in the source system.

State

string

The name of the state.

Status

string

The status of the record.

Telex

Telex

The Telex information associated with the organization.

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, the Third Party field in the Customers window is mandatory.

TradingPartnerIdentifier

string

Stores the FSIO related trading partner codes. This column will store alpha numeric values. It also takes care of the "Fed vs. Non-Fed" attribute requirement.

URL

string

The destination URL associated with a specific Google AdWords ad.

ValidatedFlag

boolean

Indicates whether the entity was validated. If the value is Y then the entity was validated.

Web

Web

The web information related to the record.

YearEstablished

int

The year when the organization began doing business.