dbo.FactSalesQuota
| Documentation | AdventureWorksDW |
| Schema | dbo |
| Name | FactSalesQuota |
| Module | Sales Quotas |
Columns
| Key | Name | Data type | Null | Attributes | References | Description | ||
|---|---|---|---|---|---|---|---|---|
| 1 | SalesQuotaKey | int | Identity | |||||
| Identity |
||||||||
| 2 | EmployeeKey | int | dbo.DimEmployee | |||||
| References: dbo.DimEmployee | ||||||||
| 3 | DateKey | int | dbo.DimDate | |||||
| References: dbo.DimDate | ||||||||
| 4 | CalendarYear | smallint | ||||||
| 5 | CalendarQuarter | tinyint | ||||||
| 6 | SalesAmountQuota | money | ||||||
| 7 | Date | datetime | ||||||
Relations
| Foreign table | Primary table | Join | Title / Name / Description | |
|---|---|---|---|---|
| dbo.FactSalesQuota | dbo.DimDate | dbo.FactSalesQuota.DateKey = dbo.DimDate.DateKey | FK_FactSalesQuota_DimDate | |
|
dbo.FactSalesQuota.DateKey = dbo.DimDate.DateKey Name: FK_FactSalesQuota_DimDate |
||||
| dbo.FactSalesQuota | dbo.DimEmployee | dbo.FactSalesQuota.EmployeeKey = dbo.DimEmployee.EmployeeKey | FK_FactSalesQuota_DimEmployee | |
|
dbo.FactSalesQuota.EmployeeKey = dbo.DimEmployee.EmployeeKey Name: FK_FactSalesQuota_DimEmployee |
||||
Unique keys
| Key name | Columns | Description | |
|---|---|---|---|
| PK_FactSalesQuota_SalesQuotaKey | SalesQuotaKey |
Uses
| Name |
|---|
|
dbo.FactSalesQuota
|
Exported: 2019-02-04 22:31, Last imported: 2019-02-04 21:58