Property |
Value |
Database schema name |
dbo |
Database table name |
FactInternetSales |
Friendly name |
Internet Sales Facts |
Table name |
dbo_FactInternetSales |
Table type |
Table |
Is loaded |
|
Relation name |
Child (foreign key) columns |
Parent name |
Parent type |
Parent (primary key) columns |
FK_FactInternetSales_DimSalesTerritory |
SalesTerritoryKey |
DimSalesTerritory |
Table |
SalesTerritoryKey |
FK_FactInternetSales_DimPromotion |
PromotionKey |
DimPromotion |
Table |
PromotionKey |
FK_FactInternetSales_DimProduct |
ProductKey |
DimProduct |
Table |
ProductKey |
FK_FactInternetSales_DimCustomer |
CustomerKey |
DimCustomer |
Table |
CustomerKey |
FK_FactInternetSales_DimDate2 |
ShipDateKey |
DimDate |
Table |
DateKey |
FK_FactInternetSales_DimDate1 |
DueDateKey |
DimDate |
Table |
DateKey |
FK_FactInternetSales_DimDate |
OrderDateKey |
DimDate |
Table |
DateKey |
FK_FactInternetSales_DimCurrency |
CurrencyKey |
Currency |
View |
CurrencyKey |
Total: 8 parent relationship(s)
Relation name |
Parent (primary key) columns |
Child name |
Child type |
Child (foreign key) columns |
FK_FactInternetSalesReason_FactInternetSales |
SalesOrderNumber, SalesOrderLineNumber |
FactInternetSalesReason |
Table |
SalesOrderNumber, SalesOrderLineNumber |
Total: 1 child relationship(s)
Name |
Type |
Computed column expression |
ProductKey |
System.Int32 |
|
OrderDateKey |
System.Int32 |
|
DueDateKey |
System.Int32 |
|
ShipDateKey |
System.Int32 |
|
CustomerKey |
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: 27 column(s)