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