MCP Server for Oracle Sales

Build 25.0.9440

SalesLeadTerritories

The sales lead territories resource is used to view the associated sales lead territories.

Columns

Name Type References Description
LeadTerritoryId [KEY] Long LeadTerritoryId
LeadId [KEY] String

SalesLeads.LeadId

LeadId
ConflictId Long ConflictId
CreatedBy String CreatedBy
CreationDate Datetime CreationDate
LastUpdateDate Datetime LastUpdateDate
LastUpdateLogin String LastUpdateLogin
LastUpdatedBy String LastUpdatedBy
Name String Name
OwnerPartyNumber String OwnerPartyNumber
PartnerPartyId Long PartnerPartyId
PartnerPartyName String PartnerPartyName
PartyId Long PartyId
PartyName String PartyName
TerritoryId Long TerritoryId
TerritoryNumber String TerritoryNumber
TerritoryVersionId Long TerritoryVersionId
TypeCode String TypeCode

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.
LeadNumber String Finds the leads with the specified lead number.

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