DimCustomer.BKCustomerSalesTerritoryId

Metadata hierarchy: MDWT_Adventure_Works_Demo » MDWT_AdventureWorksDW » DimCustomer

Attribute DimCustomer.BKCustomerSalesTerritoryId

Property NameValue
CommentsCustomer Sales Territory assigned at time of first order - does not seem to ever change.
DescriptionNatural key for the customer's current sales territory
Display NameBKCustomerSalesTerritoryId
ETL RulesJoin on Customer.SalesTerritoryID= SalesTerritory.SalesTerritoryID
Is Audit Subsystem
SCD Type1
Source Datatypeint
Source Field NameTerritoryID
Source SchemaSales
Source SystemAW
Source TableCustomer
Table Type
Used in schemas
View Name

Also Found In

  • A list tables where this item is also located can be found here.

    • More information about the source and ETL of this column can be found in:

  • Package: DimCustomer