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 [KEY]	Long	False		System generated non-nullable primary key of the Parent Activity.
ActivityNumber [KEY]	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 [KEY]	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.
ActivityLastUpdateDate	Datetime	False		The date and time when the opportunity was last updated.

Pseudo-Columns

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


Name	Type	Description
Finder	String	Input specifying the Finder type.
ContactIDAttr	String	The contact ID related to the activities.
AccountIdAttr	String	Finds the account ID related to the call reports.
LeadIdAttr	String	Finds the lead ID related to the call reports.
OpportunityIdAttr	String	Finds the opportunity ID related to the call reports.
ParentActivityIdAttr	String	The parent activity ID related to the call reports.
EndDtRFAttr	String	The appointment end date.
StartDtRFAttr	String	The appointment start date.
DateRange	String	The date range within which you want search for appointments.
Bind_CurrentDate	String	Finds the date used to locate completed activities.
Bind_RecurSeriesType_BV	String	The recurring type code of an appointment.
Bind_TaskActFuncCd_BV	String	The activities with a function code of task.
Bind_TaskStatus_BV	String	The status of the tasks.
Bind_UserResourceId	String	Finds the resource ID of the user.
Bind_Subject	String	Open activities owned by a specified user.
Bind_LoggedInUserId_BV	String	The ID of the user who is logged into the application.
Bind_TaskStatus_Cancel_BV	String	The tasks with a cancelled status.
Bind_TaskPriority_BV	String	The priority of the task.
Bind_CurrentUPTZDate	String	The date used to locate the Tasks whose due date is before the current date.

ODBC Driver for Oracle Sales

ActivityContacts

Columns

Pseudo-Columns