Revenue Territories

The revenue territories view object contains information about revenue territory, territory based assignment indicator, manual assignment indicator, summary revenue indicator, and so on.

Data Store Key : CrmAnalyticsAM.CrmExtractAM.MooBiccExtractAM.RevenueTerritoryExtractPVO

Primary Keys : RevnTerrId

Initial Extract Date : CreationDate

Incremental Extract Date : LastUpdateDate

Attributes

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

Name	Description
AsgnTerrBasedFlag	Indicates if the territory is added to the territory team by territory based assignment.
CreatedBy	The user who created the revenue territory row.
CreationDate	The date and time when the revenue territory row was created.
LastUpdateDate	The date and time when the revenue territory row was last updated.
LastUpdateLogin	The session login associated to the user who last updated the revenue territory row.
LastUpdatedBy	The user who last updated the revenue territory row.
LockAssignmentFlag	Indicates if the territory is added to the territory team by manual territory assignment.
RevnId	The identifier of the revenue in the revenue territory. This is a foreign key to the Revenues view object.
RevnTerrId	The unique identifier of the revenue territory. This is a primary key of the Revenue Territories view object.
SumRevnFlag	Indicates if the revenue is a summary revenue or not of revenue territory row.
TerritoryId	The unique identifier of the territory.
TerritoryVersionId	The identifier of the territory version in the revenue territory. This is a foreign key to the Territories view object.
UserLastUpdateDate	The date and time of last update date of revenue territory row. This value is different from LAST_UPDATE_DATE if the update originally happened in a different database.