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 |
|
|
Contains |
|
|
Contains |
|
|
Contains |
|
|
Contains |
|
|
Contains |
|
|
Contains |
|
|
Contains |
|
|
Contains |
|
|
Contains |
|
|
Contains |
|
|
Contains |
|
|
Contains |
|
|
Contains |
|
|
Contains |
|
|
Contains |
|
|
Contains |
|
|
Contains |
|
|
Contains |
|
|
Contains |
|
|
Contains |
|
|
Contains |
|
|
Contained by |
|
|
Contained by |
|
|
Contained by |
|
|
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 |
|---|---|---|
|
AdditionalOrganizationName |
The additional name associated with the organization. |
|
|
AdditionalPartyId |
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 |
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 |
The classification code assigned to the organization. |
|
|
Comments |
string |
The comments for the record. |
|
ContactPreference |
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 |
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 |
The electronic data interchange information for the organization. |
|
|
Eft |
The electronic file transfer information for the organization. |
|
|
|
The email address associated with the record. |
|
|
EmailAddress |
string |
The email address associated with the record. |
|
EmailDomain |
The e-mail domain information for the organization. |
|
|
EmployeesTotal |
decimal |
The total number of employees. |
|
FinancialProfile |
The financial profile information of the organization. |
|
|
FinancialReport |
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 |
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 |
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 |
The identifier for the record from the original system. |
|
|
PartyId |
long |
The unique identifier of the contact party.
|
|
PartyName |
string |
The name of the party. |
|
PartyNumber |
string |
The unique identification number for the party. |
|
PartyPreference |
The preference information of the organization. |
|
|
PartySite |
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 |
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 |
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 |
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 |
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 |
The web information related to the record. |
|
|
YearEstablished |
int |
The year when the organization began doing business. |