Microsoft Office Tutorials and References
In Depth Information
Table 1-3. Tables to create
Table Name
Column Name
Data Type
Key
Dim_Customer
CustomerID
Int, not null
PK
AccountNumber
Nvarchar(50), null
CustomerType
Nvarchar(3), null
Dim_DateTime
DateKey
Int, not null
PK
FullDate
Date, not null
DayNumberOfMonth
Tinyint, not null
DayNumberOfYear
Tinyint, not null
MonthNumberOfYear
Tinyint, not null
MonthName
Nvarchar(10), not null
Quarter
Tinyint, not null
Year
Smallint, not null
Dim_SalesOrderHeader
SalesOrderHeaderID
Int, not null
PK
OrderDate
Datetime, null
DueDate
Datetime, null
Status
Tinyint, null
Dim_SalesPerson
SalesPersonID
Int, not null
PK, FK (to SalesPersonID in
Dim_SalesTerritoryHistory,
Dim_Store tables)
SalesQuota
Money, null
Bonus
Money, null
CommisionPct
Money, null
SalesYTD
Money, null
SalesLastYear
Money, null
TerritoryID
Int, null
FK (to TerritoryID in
Dim_SalesTerritory table)
Dim_SalesTerritory
TerritoryID
Int, no null
PK
Name
Nvarchar(50), null
CountryRegionCode
Nvarchar(3), null
Group
Nvarchar(50), null
SalesYTD
Money, null
SalesLastYear
Money, null
CostYTD
Money, null
CostLastYear
Money, null
continued )
 
 
Search JabSto ::




Custom Search