Tableau Connector for Oracle Sales

Build 24.0.9062

Accounts

The sales team member resource represents a resource party and is assigned to a sales account team. A sales account team member has a defined access role for the sales account.

Columns

Name Type ReadOnly References Description
PartyNumber [KEY] String False

The unique alternate identifier for the account party. You can update the value if the profile option HZ_GENERATE_PARTY_NUMBER is set to True. The default value is a concatenation of the value specified in the profile option ZCA_PUID_PREFIX and a unique system generated sequence number.

AnalysisFiscalYear String False

The fiscal year used as the source for financial information.

AssignmentExceptionFlag Boolean False

Indicates whether the sales account had the required dimensions to allow assignment manager to assign territories to the sales account. If the value is True, then the sales account has the dimensions. The default value is False.

BusinessReport String False

The Dun & Bradstreet business information report.

BusinessScope String False

The class of business to which the account belongs, such as local, national, or international.

CEOName String False

The name of the organization's chief executive officer.

CEOTitle String False

The formal title of the chief executive officer.

CertificationLevel String False

The certification level the organization. A list of valid certification level codes is defined using the lookup HZ_PARTY_CERT_LEVEL. Review the Review and update the codes using the Setup and Maintenance work area, Manage Trading Community Common Lookups task.

CertificationReasonCode String False

The reason for the contact's current certification level assignment. A list of valid certification reason codes are defined using the lookup HZ_PARTY_CERT_REASON. Review and update the codes using the Setup and Maintenance work area, Manage Trading Community Common Lookups task.

Comments String False

The corporate charter of the organization.

CongressionalDistrictCode String False

The U.S. Congressional district code for the account.

ControlYear Long False

The year when current ownership gained control of the organization.

CorpCurrencyCode String False

The corporate currency code associated with the account. This attribute is used by CRM Extensibility framework. A list of accepted values is defined in the lookup ZCA_COMMON_CORPORATE_CURRENCY. Review and update the profile option using the Setup and Maintenance work area, Manage Trading Community Common Lookups task.

CorporationClass String False

The taxation classification for corporation entities such as Chapter S in the US.

CreatedBy String False

The user who created the account record.

CreatedByModule String False

The module that created the account record.

CreationDate Datetime False

The date when the record was created.

CurrencyCode String False

The currency code. This attribute is used by CRM Extensibility framework. A list of valid values are defined in the lookup ZCA_COMMON_CORPORATE_CURRENCY. Review and update the profile option using the Setup and Maintenance work area, Manage Currency Profile Options task.

CurrentFiscalYearPotentialRevenueAmount Decimal False

The estimated revenues that can be earned by the organization during its current fiscal year.

DeleteFlag Boolean False

Indicates if the account can be deleted.

DisadvantageIndicator String False

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.

DomesticUltimateDUNSNumber String False

The DUNS Number for the Domestic Ultimate. A Domestic Ultimate is the highest member of the same country in the organization's hierarchy. An organization can be its own Domestic Ultimate.

DoNotConfuseWith String False

Indicates that there is an organization that is similarly named.

DUNSCreditRating String False

The Dun & Bradstreet credit rating.

DUNSNumber String False

The DUNS Number in freeform text format. The value not restricted to nine digit number.

EmailAddress String False

The e-mail address of the contact point for the organization.

EmailFormat String False

The preferred format for e-mail addressed to this organization, such as HTML or ASCII.

EmployeesAtPrimaryAddress String False

The qualifier to calculate the estimated number of employees at the primary address. A list of valid qualifier codes are defined using the lookup EMP_AT_PRIMARY_ADR_EST_IND. Review and update the codes using the Setup and Maintenance work area, Manage Trading Community Common Lookups task.

EmployeesAtPrimaryAddressEstimation String False

The estimated minimum number of employees at the primary address. A list of accepted values are defined in the lookup type EMP_AT_PRIMARY_ADR_MIN_IND. Review and update the values using the Setup and Maintenance work area, Manage Trading Community Common Lookups task.

EmployeesAtPrimaryAddressMinimum String False

The qualifier to qualify calculation of employees at the primary address as minimum.

EmployeesAtPrimaryAddressText String False

The number of employees at the referenced address in text format.

EmployeesTotal Long False

The total number of employees in the organization.

ExistingCustomerFlag Boolean False

Indicates if there is an existing selling or billing relationship with the sales account. If the value is true, then there is an existing relationship with the sales account. The default value is False.

ExistingCustomerFlagLastUpdateDate Date False

The date when the existing customer flag was last updated.

ExportIndicator String False

Indicates whether the organization is an exporter. If the value is Y, then the organization is an exporter. The default value is N.

FavoriteAccountFlag Boolean False

Indicates if the account is a favorite.

FaxAreaCode String False

The area code for the fax number.

FaxCountryCode String False

The international country code for a fax number, such as 33 for France.

FaxExtension String False

The extension to the fax number of the organization.

FaxNumber String False

The fax number of the organization in the local format. The number should not include area code, country code, or extension.

FiscalYearendMonth String False

The last month of a fiscal year for the organization. The list of accepted values is defined in the lookup type MONTH.

FormattedFaxNumber String False

The formatted phone number of the organization.

FormattedPhoneNumber String False

The formatted phone number of the organization.

GeneralServicesAdministrationFlag Boolean False

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.

GlobalUltimateDUNSNumber String False

The DUNS Number for the Global Ultimate. A Global Ultimate is the highest member in the organization's hierarchy. An organization can be its own Global Ultimate.

GrowthStrategyDescription String False

The user-defined description of growth strategy.

HomeCountry String False

The home country of the organization.

HQBranchIndicator String False

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.

ImportIndicator String False

Indicates whether the organization is an importer. If the value is Y, then the organization is an importer. The default value is N.

IndustryCode String False

The Industry classification code. The classification codes are defined for every classification category as specified in IndustryCodeType attribute. Review and update the codes using the Setup and Maintenance work area, Manage Classification Categories task.

IndustryCodeType String False

The industry classification category code type. It is defaulted to the value of profile option MOT_INDUSTRY_CLASS_CATEGORY. Review and update the codes using the Setup and Maintenance work area, Manage Classification Categories task.

LaborSurplusIndicator String False

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.

LastAssignmentDateTime Datetime False

The date when the Sales Account Territory Assignment was last run by Assignment Manager.

LastEnrichmentDate Date False

The date when the record was last enriched.

LastUpdateDate Datetime False

The date when the record was last updated.

LastUpdatedBy String False

The user who last updated the record.

LastUpdateLogin String False

The login of the user who last updated the record.

LegalStatus String False

The legal structure of the organization such as partnership, corporation, and so on.

LineOfBusiness String False

The type of business activities performed at this site.

LocalActivityCode String False

The local activity classification code.

LocalActivityCodeType String False

The local activity classification code type identifier.

LocalBusinessIdentifier String False

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.

LocalBusinessIdentifierType String False

The lookup that represents most common business identifier 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.

MinorityOwnedIndicator String False

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. company is primarily owned by ethnic or racial minorities. The default value is N.

MinorityOwnedType String False

The type of minority-owned firm.

MissionStatement String False

The corporate charter of organization in user-defined text format.

NamedFlag Boolean False

Indicates if the sales account is a named sales account. If the value is True, then the account is a named account. The default value is False.

NextFiscalYearPotentialRevenueAmount Decimal False

The estimated revenue of the organization to be earned during its next fiscal year.

OrganizationName String False

The name of the account.

OrganizationSize String False

The size of the organization based on its revenue, number of employees, and so on.

OrganizationType String False

The type of the organization.

OutOfBusinessIndicator String False

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.

OwnerEmailAddress String False

The e-mail address of the employee resource that owns and manages the sales account. The owner is a valid employee resource defined within Sales Cloud.

OwnerName String False

The name of the employee resource that owns and manages the sales account.

OwnerPartyId Long False

The unique identifier of a valid employee resource who owns and manages the sales account.

OwnerPartyNumber String False

The party number of a valid employee resource who owns and manages the sales account.

ParentAccountName String False

The name of the parent account in the hierarchy.

ParentAccountPartyId Long False

The party Id of the parent account within the hierarchy. To assign a parent account to a sales account, you must provide the parent account's party ID, party number, or source system reference.

ParentAccountPartyNumber String False

The party number of the parent account within the hierarchy.

ParentAccountSourceSystem String False

The source system of the parent account within the hierarchy.

ParentAccountSourceSystemReferenceValue String False

The source system reference of the parent account within the hierarchy.

ParentDUNSNumber String False

The DUNS Number of the organization or the parent entity that owns a majority stake of the organization's capital stock. The parent entity can be a subsidiary of another corporation. If the parent also has branches, then it is regarded as headquarters as well as 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.

ParentOrSubsidiaryIndicator String False

Title:

PartyId Long False

Title:

PartyStatus String False

Title:

PartyUniqueName String False

Title:

PhoneAreaCode String False

Title:

PhoneCountryCode String False

Title:

PhoneExtension String False

Title:

PhoneNumber String False

Title:

PreferredContactMethod String False

Title:

PreferredFunctionalCurrency String False

Title:

PrimaryContactEmail String False

Title:

PrimaryContactName String False

Title:

PrimaryContactPartyId Long False

Title:

PrimaryContactPartyNumber String False

Title:

PrimaryContactPhone String False

Title:

PrimaryContactSourceSystem String False

Title:

PrimaryContactSourceSystemReferenceValue String False

Title:

PrincipalName String False

Title:

PrincipalTitle String False

Title:

PublicPrivateOwnershipFlag Boolean False

Title:

RecordSet String False

Title:

RegistrationType String False

Title:

RentOrOwnIndicator String False

Title:

SalesProfileStatus String False

Title:

SmallBusinessIndicator String False

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.

SourceSystem String False

The name of external source system where the account party is imported from. The values configured in setup task Trading Community Source System.

SourceSystemReferenceValue String False

The unique identifier for the account party from the external source system specified in the attribute SourceSystem.

StockSymbol String False

The corporate stock symbol of the organization as listed in stock exchanges.

TaxpayerIdentificationNumber String False

The taxpayer identification number that is often a unique identifier of the organization, such as income taxpayer Id in USA and fiscal code or NIF in Europe.

TotalEmployeesEstimatedIndicator String False

Indicates if the employee total is estimated. The accepted values are defined in the lookup type TOTAL_EMP_EST_IND.

TotalEmployeesIndicator String False

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 False

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 False

The total number of employees in text format.

Type String False

The account type that defines if the account is a sales account or a prospect or any other party type. The accepted values are defined in the lookup type ZCA_ACCOUNT_TYPE. It is defaulted to ZCA_CUSTOMER if no value is provided.

UniqueNameSuffix String False

The suffix used to generate the attribute PartyUniqueName. The suffix is concatenated to the OrganizationName attribute to generate the PartyUniqueName. The primary address is defaulted as the suffix.

UpdateFlag Boolean False

Indicates if the record can be updated.

URL String False

WomanOwnedIndicator String False

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 False

The year that the organization started it business operations.

YearIncorporated Int False

The year that the business was formally incorporated.

OrganizationProfileId Long False

The unique identifier of the organization.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
Finder String

Input specifying the Finder type.

FocusPartyId String

The unique identifier of the child account to be returned at the top by the Direct Accounts finder.

ParentPartyId String

The unique identifier of the account used to search the direct child accounts.

BindUserPartyId String

The unique identifier of the party. Used in MyAccounts finder.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062