Territory Hierarchies Column Flatten
The territory hierarchies column flattened view object contains information about the unique identifier of territory at each level, hierarchy start date, hierarchy end date, and last refresh date.
Data Store Key : CrmAnalyticsAM.CrmExtractAM.MotBiccExtractAM.TerritoryHierarchyColumnFlattenExtractPVO
Primary Keys : TerrHierarchyCfDnId
Initial Extract Date : CreationDate
Incremental Extract Date : LastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| BaseTerrId | The unique identifier of territory at the base level. |
| BaseTerrVerId | The unique identifier of territory version at the base level. |
| CreatedBy | The user who created the territory hierarchy column flat row. |
| CreationDate | The date and time when the territory hierarchy column flat row was created. |
| CurrentFlag | |
| FixedHierarchyLevel | The fixed hierarchy level of the territory. |
| HierarchyEndDate | The end date of the territory hierarchy. |
| HierarchyStartDate | The start date of the territory hierarchy. |
| LastRefreshDate | The date on which the last batch process was run. |
| LastUpdateDate | The date and time when the territory hierarchy column flat row was last updated. |
| LastUpdateLogin | The session login associated with the user who last updated the territory hierarchy column flat row. |
| LastUpdatedBy | The user who last updated the territory hierarchy column flat row. |
| Level10TerrId | The unique identifier of the territory at level 11. |
| Level10TerrVerId | The unique identifier of the territory version at level 11. |
| Level11TerrId | The unique identifier of the territory at level 12. |
| Level11TerrVerId | The unique identifier of the territory version at level 12. |
| Level12TerrId | The unique identifier of the territory at level 13. |
| Level12TerrVerId | The unique identifier of the territory version at level 13. |
| Level13TerrId | The unique identifier of the territory at level 14. |
| Level13TerrVerId | The unique identifier of the territory version at level 14. |
| Level14TerrId | The unique identifier of the territory at level 15. |
| Level14TerrVerId | The unique identifier of the territory version at level 15. |
| Level15TerrId | The unique identifier of the territory at level 16. |
| Level15TerrVerId | The unique identifier of the territory version at level 16. |
| Level16TerrId | The unique identifier of the territory at level 17. |
| Level16TerrVerId | The unique identifier of the territory version at level 17. |
| Level1TerrId | The unique identifier of the territory at level 2. |
| Level1TerrVerId | The unique identifier of the territory version at level 2. |
| Level2TerrId | The unique identifier of the territory at level 3. |
| Level2TerrVerId | The unique identifier of the territory version at level 3. |
| Level3TerrId | The unique identifier of the territory at level 4. |
| Level3TerrVerId | The unique identifier of the territory version at level 4. |
| Level4TerrId | The unique identifier of the territory at level 5. |
| Level4TerrVerId | The unique identifier of the territory version at level 5. |
| Level5TerrId | The unique identifier of the territory at level 6. |
| Level5TerrVerId | The unique identifier of the territory version at level 6. |
| Level6TerrId | The unique identifier of the territory at level 7. |
| Level6TerrVerId | The unique identifier of the territory version at level 7. |
| Level7TerrId | The unique identifier of the territory at level 8. |
| Level7TerrVerId | The unique identifier of the territory version at level 8. |
| Level8TerrId | The unique identifier of the territory at level 9. |
| Level8TerrVerId | The identifier of territory version at level 9 |
| Level9TerrId | The unique identifier of the territory at level 10. |
| Level9TerrVerId | The unique identifier of the territory version at level 10. |
| TerrHierarchyCfDnId | The unique identifier of the territory hierarchy column flat view. This is a primary key of the Territory Hierarchy Column Flat view object. |
| TopLevelTerrId | The unique identifier of the territory at the top level. |
| TopLevelTerrVerId | The unique identifier of the territory version at the top level. |