Property |
Value |
Database schema name |
dbo |
Database table name |
FactResellerSales |
Friendly name |
Reseller Sales Facts |
Table name |
dbo_FactResellerSales |
Table type |
Table |
Is loaded |
|
Relation name |
Child (foreign key) columns |
Parent name |
Parent type |
Parent (primary key) columns |
FK_FactResellerSales_DimSalesTerritory |
SalesTerritoryKey |
DimSalesTerritory |
Table |
SalesTerritoryKey |
FK_FactResellerSales_DimReseller |
ResellerKey |
DimReseller |
Table |
ResellerKey |
FK_FactResellerSales_DimPromotion |
PromotionKey |
DimPromotion |
Table |
PromotionKey |
FK_FactResellerSales_DimProduct |
ProductKey |
DimProduct |
Table |
ProductKey |
FK_FactResellerSales_DimEmployee |
EmployeeKey |
DimEmployee |
Table |
EmployeeKey |
FK_FactResellerSales_DimDate1 |
DueDateKey |
DimDate |
Table |
DateKey |
FK_FactResellerSales_DimDate |
OrderDateKey |
DimDate |
Table |
DateKey |
FK_FactResellerSales_DimDate2 |
ShipDateKey |
DimDate |
Table |
DateKey |
FK_FactResellerSales_DimCurrency |
CurrencyKey |
Currency |
View |
CurrencyKey |
Total: 9 parent relationship(s)
Name |
Type |
Computed column expression |
ProductKey |
System.Int32 |
|
OrderDateKey |
System.Int32 |
|
DueDateKey |
System.Int32 |
|
ShipDateKey |
System.Int32 |
|
ResellerKey |
System.Int32 |
|
EmployeeKey |
System.Int32 |
|
PromotionKey |
System.Int32 |
|
CurrencyKey |
System.Int32 |
|
SalesTerritoryKey |
System.Int32 |
|
SalesOrderNumber |
System.String |
|
SalesOrderLineNumber |
System.Byte |
|
RevisionNumber |
System.Byte |
|
OrderQuantity |
System.Int16 |
|
UnitPrice |
System.Decimal |
|
ExtendedAmount |
System.Decimal |
|
UnitPriceDiscountPct |
System.Double |
|
DiscountAmount |
System.Double |
|
ProductStandardCost |
System.Decimal |
|
TotalProductCost |
System.Decimal |
|
SalesAmount |
System.Decimal |
|
TaxAmt |
System.Decimal |
|
Freight |
System.Decimal |
|
CarrierTrackingNumber |
System.String |
|
CustomerPONumber |
System.String |
|
SalesOrderDesc |
System.String |
CONVERT ( CHAR ( 10 ), SalesOrderNumber ) + 'Line ' +
CONVERT ( CHAR ( 4 ), SalesOrderLineNumber ) |
OrderDate |
System.DateTime |
|
DueDate |
System.DateTime |
|
ShipDate |
System.DateTime |
|
Total: 28 column(s)