Sales Lead Territories

The lead territory associated view object contains information such as lead, territory version, and access level code.

Data Store Key : CrmAnalyticsAM.CrmExtractAM.MklBiccExtractAM.LeadTerritoryAssocExtractPVO

Primary Keys : LeadTerritoryId

Initial Extract Date : CreationDate

Incremental Extract Date : LastUpdateDate

Attributes

This table provides the list of exposed attributes and their descriptions.

Name	Description
AccessLevelCode	The attribute that determines the access type granted to the lead territory.
CreatedBy	The user who created the lead territory association row.
CreationDate	The date and time when the lead territory association row was created.
LastUpdateDate	The date and time when the lead territory association row was last updated.
LastUpdateLogin	The session login associated to the user who last updated the lead territory association row.
LastUpdatedBy	The user who last updated the lead territory association row.
LeadEffectiveDate	The effective date associated with the lead territory association row.
LeadId	The identifier of the lead in the lead territory association. This is a foreign key of the Lead view object.
LeadStatusCd	The lead status code associated with the lead territory association row.
LeadTerritoryId	The unique identifier of the territory for a sales lead. This is a primary key of the Lead Territory Association view object.
TerritoryId	The unique identifier of the territory for a sales lead.
TerritoryVersionId	The unique identifier of the territory version.
UserLastUpdateDate	The date and time at which the lead territory associated row was last updated. This value is different from LAST_UPDATE_DATE if the update originally happened in a different database.