Marketing List Contact

The individual contacts that are selected in a marketing list.

QName: {http://xmlns.oracle.com/apps/marketing/coreMarketing/lists/listService/}MktListMember

Relationships

The following table describes how this service data object is related to other service data objects or business object services.

Relationship Type Object or Service

Contained by

Marketing List

Handled by

Marketing List Service

Attributes

The following table describes attributes in the service data object.

Name Type Description

CallListId

long

The call list contact id.

CallListMemberId

long

The call list contact id.
  • Primary Key

ContactId

long

The identifier of the contact person.

ContactPointId

long

The unique primary key identifier for the contact point.

ContactPointId1

long

The unique identifier for a contact point.

ContactPointType

string

The type of the contact point.

ContactPointType1

string

The type of the contact point, such as phone or e-mail.

ContactRelationshipId

long

The identifier of the contact relationship record in Trading Community Architecture (TCA).

CreatedBy

string

The user who created the record.

CreationDate

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

The date when the record was created.

Customer

string

The identifier of the customer party associated with this list member.

EmailAddress

string

The email address associated with the record.

EmailFormat

string

Indicates the preferred format for e-mail addressed to this address. For example, HTML or ASCII.

EmailRestrictions

string

Indicates whether the email address of the marketing list member has any contact restrictions.

LastUpdateDate

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

The date when the record was last updated.

LastUpdatedBy

string

The user who last updated the record.

ObjectId

long

The identifier of the object.

ObjectVersionNumber

int

The number used to implement locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to determine whether another session has updated the row.

PartyId

long

The unique identifier of the contact party.

PartyUniqueName

string

This is a derived column. For Organization, it is concatenation of unique_name_alias and suffix. For Person, it is concatenation of person_name and suffix.

PartyUsage

string

The party usage recorded for this party in the customer master.

PartyUsageCode

string

The usage context of a party's contact point.

PersonFirstName

string

The first name of a person. It is used in the same way the homonymous field in HZ_PERSON_PROFILES is used. It corresponds to the field Given Name in HL7.

PersonLastName

string

The last name of a person. It is used in the same way the homonymous field in HZ_PERSON_PROFILES is used. It corresponds to the field Family Name in HL7.

PhoneAreaCode

string

The area code prefix for the phone number.

PhoneCallingCalendar

string

The name or code for a calling calendar used with this telephone number. This attribute is no longer used.

PhoneCountryCode

string

The country code prefix for the phone number.

PhoneExtension

string

The additional number addressed after initial connection to an internal telephone system.

PhoneLineType

string

The lookup code for the type of phone line. For example, general, fax, inbound, or outbound.

PhoneNumber

string

The telephone number in the local format. The number should not include area code, country code, or extension.

PhoneRestrictions

string

Indicates whether there are any contact restrictions on the phone number associated with this list member.

RelationshipId

long

The relationship identifier for the record.

RelationshipId1

long

Relationship identifier for this list member. This identifier represents the relation between the customer and the contact.

UserLastUpdateDate

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

The date and time when the row was last updated.