TDV Adapter for Oracle Sales

Build 22.0.8462

ActivityContacts

Table used to capture the contacts associated to the activity.

Columns

Name Type ReadOnly References Description
AccountId Long False

null

ActivityContactId [KEY] Long False

This is the surrogate primary key added for BI and Outlook.

ActivityId Long False

System generated non-nullable primary key of the Parent Activity.

ActivityNumber String False

Affinity String False

Contact Affinity

AttendeeFlag Bool False

Flag to Check If the Contact Attended the Activity

BuyingRole String False

Contact Buying Role

ConflictId Long False

null

ContactAccount String False

Holds the Account Name that the Contact is associated to

ContactAccountId Long False

Holds the Id of the Account that the Contact is associated to

ContactAccountType String False

null

ContactCustomer String False

null

ContactEmail String False

Holds Email Id of the contact

ContactId Long False

Id of contact associated with the activity.

ContactJobTitle String False

Holds the Job Title of the Contact

ContactLovSwitcher String False

null

ContactName String False

Contact Name

ContactPartyNumber String False

Holds Party Number of the contact

ContactPhone String False

Holds Phone Number of the contact

CorpCurrencyCode String False

Holds Corporate Currency Code from profile

CreatedBy String False

System attribute to capture the user Id of the activity contact creator. This is defaulted by the system.

CreationDate Datetime False

System attribute to capture the date and time the activity contact was created. This is defaulted by the system.

CurcyConvRateType String False

Holds Currency Conversion Rate Type from profile

CurrencyCode String False

Holds currency code of a record

DoNotCallFlag Bool False

Flag to check if this contact can be contacted through Call

DoNotContactFlag Bool False

Flag to check if this contact can be contacted

DoNotEmailFlag Bool False

Flag to check if this contact can be contacted through Email

EmailContactPreferenceFlag String False

null

ExternalContactEmail String False

Indicates the Email address of an external contact.

ExternalContactFlag Bool False

Indicates that the contact does not exist in Oracle Sales.

ExternalContactName String False

Indicates the name of an external contact.

LastUpdateDate Datetime False

System attribute to capture the date and time the activity contact was last updated. This is defaulted by the system.

LastUpdateLogin String False

System attribute to capture the Id of the user who last updated the activity contact. This is defaulted by the system.

LastUpdatedBy String False

System attribute to capture the ID of the user who last updated the activity contact. This is defaulted by the system.

Name String False

null

PhoneContactPreferenceFlag String False

null

PrimaryContactFlag Bool False

This used of enable/disable PrimaryContactFlag for a contact.

PrimaryFormattedAddress String False

Holds Primary Address of the contact

RecurSeriesId Long False

null

RelationshipId Long False

Id of the relationship of the contact.

UpgSourceObjectId Long False

null

UpgSourceObjectType String False

null

UserLastUpdateDate Datetime False

Attribute to capture when the record was last updated by a user in disconnect mode.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462