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