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.

JDBC Driver for Oracle Sales

ActivityContacts

Columns