ODBC Driver for Oracle Sales

Build 24.0.9062

PartnerContacts

Usage information for the operation PartnerContacts.rsd.

Columns

Name Type ReadOnly References Description
PartyId [KEY] Long False

AcademicTitle String False

AddrElementAttribute1 String False

AddrElementAttribute2 String False

AddrElementAttribute3 String False

AddrElementAttribute4 String False

AddrElementAttribute5 String False

AddressLineFour String False

AddressLineOne String False

AddressLineThree String False

AddressLineTwo String False

Building String False

CertificationLevel String False

CertificationReasonCode String False

City String False

Comments String False

ContactName String False

Country String False

County String False

CreateUserAccountFlag Bool False

CreatedBy String False

CreationDate Datetime False

DateOfBirth Date False

DateOfDeath Date False

DeceasedFlag Bool False

DeclaredEthnicity String False

Department String False

DepartmentCode String False

DoNotCallFlag Bool False

DoNotContactFlag Bool False

DoNotEmailFlag Bool False

DoNotMailFlag Bool False

EmailAddress String False

FavoriteContactFlag Bool False

FirstName String False

FloorNumber String False

FormattedAddress String False

FormattedMobileNumber String False

FormattedWorkPhoneNumber String False

Gender String False

Initials String False

JobTitle String False

JobTitleCode String False

LastName String False

LastNamePrefix String False

LastUpdateDate Datetime False

LastUpdateLogin String False

LastUpdatedBy String False

Latitude Double False

Longitude Double False

Mailstop String False

ManagerName String False

ManagerPartyId Long False

ManagerPartyNumber String False

MaritalStatus String False

MaritalStatusEffectiveDate Date False

MiddleName String False

MobileAreaCode String False

MobileCountryCode String False

MobileExtension String False

MobileNumber String False

NameSuffix String False

NamedFlag Bool False

PartnerCompanyNumber String False

PartnerName String False

PartnerPartyId Long False

PartyNumber String False

PersonPreNameAdjunct String False

PlaceOfBirth String False

PostalCode String False

PostalPlus4Code String False

PreferredContactMethod String False

PreferredFunctionalCurrency String False

PreviousLastName String False

PrimaryAddressId Long False

PrimaryContactPartyId Long False

PrimaryFlag Bool False

Province String False

RentOrOwnIndicator String False

RoleCode String False

RoleId Long False

RoleName String False

SalesAffinityCode String False

SalesBuyingRoleCode String False

Salutation String False

SecondLastName String False

SourceSystem String False

SourceSystemReferenceValue String False

State String False

Title String False

Type String False

Username String False

WorkPhoneAreaCode String False

WorkPhoneCountryCode String False

WorkPhoneExtension String False

WorkPhoneNumber String False

isSelfRegistration String False

Pseudo-Columns

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

Name Type Description
Finder String

Input specifying the Finder type.

BindSourceSystem String

The name of the external source system of the partner contact.

BindSourceSystemReferenceValue String

The identifier of the partner contact record from the external source system.

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