Territory Coverages
The territory coverages view object contains information about coverage type, coverage number, address fields of the address dimension, customer size, sales channel code, inventory item identifier, territory dimension code, territory version identifier, auxiliary codes and so on.
Data Store Key : CrmAnalyticsAM.CrmExtractAM.MotBiccExtractAM.TerritoryCoverageExtractPVO
Primary Keys : CoverageId
Initial Extract Date : CreationDate
Incremental Extract Date : LastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| AccountId | The identifier for the customer for the customer inclusion or exclusion. |
| AccountTypeCode | The code for the account type in the territory coverage. |
| AccountTypeHighCode | The account type high code. This is deprecated. |
| AddressCity | The city of the address dimension in the territory coverage. |
| AddressCountry | The country of the address dimension in the territory coverage. |
| AddressCounty | The county of the address dimension in the territory coverage. |
| AddressElementAttribute1 | The additional attribute 1 of the address dimension in the territory coverage. |
| AddressElementAttribute2 | The additional attribute 2 of the address dimension in the territory coverage. |
| AddressElementAttribute3 | The additional attribute 3 of the address dimension in the territory coverage. |
| AddressElementAttribute4 | The additional attribute 4 of the address dimension in the territory coverage. |
| AddressElementAttribute5 | The additional attribute 5 of the address dimension in the territory coverage. |
| AddressPostalCode | The postal code of the address dimension in the territory coverage. |
| AddressProvince | The province of the address dimension in the territory coverage. |
| AddressState | The state of the address dimension in the territory coverage. |
| Auxiliary1Code | The auxiliary 1 code in the territory coverage. |
| Auxiliary1HighCode | The auxiliary 1 high code in the territory coverage. This column is deprecated. |
| Auxiliary2Code | The auxiliary 2 code in the territory coverage. |
| Auxiliary2HighCode | The auxiliary 2 high code in the territory coverage. This column is deprecated. |
| Auxiliary3Code | The auxiliary 3 code in the territory coverage. |
| Auxiliary3HighCode | The auxiliary 3 high code in the territory coverage. This column is deprecated. |
| BusinessUnitHighId | The identifier for the business unit high code in the territory coverage. This column is deprecated. |
| BusinessUnitId | The identifier for the business unit in the territory coverage. |
| CoverageId | The unique identifier of the territory coverage rule. This is a primary key of the Territory Coverages view object. |
| CoverageNumber | The public unique identifier of the territory coverage rule. |
| CoverageTypeCode | The code for the territory coverage type. If the territory coverage model is sales account centric, the accepted values are: REGULAR for coverage based on sales account dimensionality or named accounts, INCLUSION for manually included account coverage and EXCLUSION for manually excluded account coverage. If the territory coverage model is partner centric, the accepted values are: PARTNER_REGULAR for coverage based on partner dimensionality, PARTNER_INCLUSION for manually included partner coverage and PARTNER_EXCLUSION for manually excluded partner coverage. In case of inheritance, if the coverage is for a recipient territory, then the accepted value is INHERITANCE_OVERRIDE which indicates that the coverage overrides some of the inherited dimensionality. |
| CreatedBy | The user who created the territory coverage row. |
| CreationDate | The date and time when the territory coverage row was created. |
| CustomerSizeCode | The code for the customer size in the territory coverage. A list of accepted values is defined in the lookup type HZ_ORGANIZATION_SIZE. The list of accepted values is: VERY_SMALL, SMALL, MEDIUM, LARGE and VERY_LARGE. |
| CustomerSizeHighCode | The high code for the customer size in the territory coverage. This column is deprecated. |
| GeographyHighId | The identifier for the higher geography in the range, in the territory coverage. |
| GeographyId | The identifier for the geography in the territory coverage. |
| IncludeHierarchyFlag | Indicates whether the dimension member is included along with its hierarchy or not. The default value is true. |
| IndustryCode | The code for the industry in the territory coverage. |
| IndustryHighCode | The higher code for the industry in the territory coverage. This column is deprecated. |
| InventoryItemHighId | The identifier for the higher inventory item in the territory coverage. This column is deprecated. |
| InventoryItemId | The identifier for the inventory item in the territory coverage. |
| InventoryOrgId | The identifier for the inventory organization in the territory coverage. |
| LastUpdateDate | The date and time when the territory coverage row was last updated. |
| LastUpdateLogin | The session login associated to the user who last updated the territory coverage row. |
| LastUpdatedBy | The user who last updated the territory coverage row. |
| OrganizationTypeCode | The code for the organization type in the territory coverage. |
| OrganizationTypeHighCode | The higher code for the organization type in the territory coverage. This column is deprecated. |
| PartnerId | The identifier of the partner inclusion or exclusion. |
| ProductGroupHighId | The higher identifier for the product group in the territory coverage. This column is deprecated. |
| ProductGroupId | The identifier for the product group in the territory coverage. |
| RuleId | The unique identifier of territory rule. This is a foreign key to the Territory Rules view object. |
| SalesChannelCode | The code for the sales channel in the territory coverage. |
| SalesChannelHighCode | The higher code for the sales channel in the territory coverage. This column is deprecated. |
| SubSalesChannelCode | The code for the sub sales channel in the territory coverage. |
| SubSalesChannelHighCode | The higher code for the sub sales channel in the territory coverage. |
| TerrDimensionCode | The code indicating the territory dimension, such as Acct, Aux 1, Aux 2, Aux 3, Geo, or Prod. |
| TerritoryVersionId | The unique identifier of territory version. This is a foreign key to the Territory Versions view object. |