| 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)