SSIS Components for Oracle Sales

Build 25.0.9434

SalesLeadContacts

The sales lead contacts resource is used to capture a contact associated with the sales lead.

Columns

Name Type ReadOnly References Description
LeadMemberId [KEY] Long False

Primary Key for Lead Contact

LeadId [KEY] String False

SalesLeads.LeadId

LeadId

AccountName String True

AccountName

City String True

City associated with the identifying address associated with this lead contact.

ConflictId Long False

ConflictId

ContactDoNotCallFlag Bool True

Do not call flag set at person level for the sales lead contact.

ContactDoNotContactFlag Bool True

Do not contact flag set at person level for the sales lead contact.

ContactDoNotMailFlag Bool True

Do not mail flag set at person level for the sales lead contact.

ContactJobTitle String False

ContactJobTitle

CreatedBy String True

Indicates the user who created this record.

CreationDate Datetime True

Indicates the date and time when this record is created.

EmailAddress String False

Email address associated with the sales lead contact.

EmailPreference String True

Indicates if the lead contact has an email preference of do not email, ok to email, or no value.

FormattedPhoneNumber String False

Stores formatted phone number of the lead contact.

JobTitle String True

Job title of the sales lead contact.

LastUpdateDate Datetime True

System field that indicates the date and time of the last update of the row.

LastUpdateLogin String True

Who column: indicates the session login associated to the user who last updated the row.

LastUpdatedBy String True

System field that indicates the user who last updated the row.

LeadNumber String False

LeadNumber

OrgContactId Long True

Organization Contact Identifier of the sales lead contact

PartyId Long False

Party identifier of the lead contact.

PartyName String True

Party name of the lead contact.

PartyNumber String False

Party Number of the sales lead contact

PartyType String True

Indicates the type of the party recorded as lead contact. Possible values are person, organization or group.

PartyUsageCode String False

Party usage recorded for this lead contact in the customer master.

PersonFirstName String True

First name of the lead contact.

PersonLastName String True

Last name or surname of this lead contact.

PersonTitle String True

Title asscoaited with the lead contact. This is not the same as the job title.

PhonePreference String True

Indicates whether the lead contact has a phone preference of do not call, ok to call, or no value.

PostalCode String True

Postal code part of the identifying address associated with this lead contact.

PrimaryCustomerId Long True

PrimaryCustomerId

PrimaryFlag Bool False

Indicates whether this lead contact is primary. Primary lead contact is also the lead owner.

RelationshipId Long False

Relationship identifier for this lead contact. This represents the relation of this lead contact with lead customer.

Role String False

Role of lead contact in the context of this lead.

State String True

State part of the identifying address associated with this lead contact.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
Finder String

Input specifying the Finder type.

ContactId String

The unique identifier of the Contact.

SysEffectiveDate String

SysEffectiveDate.

ResourcePartyIdRest String

The unique identifier of the Resource.

RestCreationDateLower String

Finds the leads that are created before the date specified.

RestCreationDateUpper String

Finds the leads with the specified creation date.

RestRecordSet String

Finds the leads with the specified record set value.

RestStatusCode String

Finds the leads with the specified status code.

Name String

Finds the leads with the specified name.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434