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