Adventure Works DW - Table - dbo

Table properties

name	value
name	dbo_FactInternetSales
data source view	Adventure Works DW
case sensitive	False
display expression
friendly name	FactInternetSales
db schema name	dbo
db table name	FactInternetSales
type	Table

Columns

name	nulls	caption	data type	ordinal	unique	max length	is logical	db column name	computed column expression
ProductKey	False	ProductKey	Int32	0	False			ProductKey
OrderDateKey	False	OrderDateKey	Int32	1	False			OrderDateKey
DueDateKey	False	DueDateKey	Int32	2	False			DueDateKey
ShipDateKey	False	ShipDateKey	Int32	3	False			ShipDateKey
CustomerKey	False	CustomerKey	Int32	4	False			CustomerKey
PromotionKey	False	PromotionKey	Int32	5	False			PromotionKey
CurrencyKey	False	CurrencyKey	Int32	6	False			CurrencyKey
SalesTerritoryKey	False	SalesTerritoryKey	Int32	7	False			SalesTerritoryKey
SalesOrderNumber	False	SalesOrderNumber	String	8	False	20		SalesOrderNumber
SalesOrderLineNumber	False	SalesOrderLineNumber	Byte	9	False			SalesOrderLineNumber
RevisionNumber	True	RevisionNumber	Byte	10	False			RevisionNumber
OrderQuantity	True	OrderQuantity	Int16	11	False			OrderQuantity
UnitPrice	True	UnitPrice	Decimal	12	False			UnitPrice
ExtendedAmount	True	ExtendedAmount	Decimal	13	False			ExtendedAmount
UnitPriceDiscountPct	True	UnitPriceDiscountPct	Double	14	False			UnitPriceDiscountPct
DiscountAmount	True	DiscountAmount	Double	15	False			DiscountAmount
ProductStandardCost	True	ProductStandardCost	Decimal	16	False			ProductStandardCost
TotalProductCost	True	TotalProductCost	Decimal	17	False			TotalProductCost
SalesAmount	True	SalesAmount	Decimal	18	False			SalesAmount
TaxAmt	True	TaxAmt	Decimal	19	False			TaxAmt
Freight	True	Freight	Decimal	20	False			Freight
CarrierTrackingNumber	True	CarrierTrackingNumber	String	21	False	25		CarrierTrackingNumber
CustomerPONumber	True	CustomerPONumber	String	22	False	25		CustomerPONumber
SalesOrderDesc	True	SalesOrderDesc	String	23	False	19	True	SalesOrderDesc	show/hide CONVERT ( CHAR ( 10 ), SalesOrderNumber ) + 'Line ' + CONVERT ( CHAR ( 4 ), SalesOrderLineNumber )

References

parent column	child column	relation name	nested
dbo_DimCurrency.	dbo_FactInternetSales.	FK_FactInternetSales_DimCurrency	False
dbo_DimCustomer.	dbo_FactInternetSales.	FK_FactInternetSales_DimCustomer	False
dbo_DimProduct.	dbo_FactInternetSales.	FK_FactInternetSales_DimProduct	False
dbo_DimPromotion.	dbo_FactInternetSales.	FK_FactInternetSales_DimPromotion	False
dbo_DimSalesTerritory.	dbo_FactInternetSales.	FK_FactInternetSales_DimSalesTerritory	False
dbo_DimTime.	dbo_FactInternetSales.	FK_FactInternetSales_DimTime2	False
dbo_DimTime.	dbo_FactInternetSales.	FK_FactInternetSales_DimTime	False
dbo_DimTime.	dbo_FactInternetSales.	FK_FactInternetSales_DimTime1	False

Referenced by

parent column	child column	relation name	nested
dbo_DimCurrency.	dbo_FactInternetSales.	FK_FactInternetSales_DimCurrency	False
dbo_DimCustomer.	dbo_FactInternetSales.	FK_FactInternetSales_DimCustomer	False
dbo_DimProduct.	dbo_FactInternetSales.	FK_FactInternetSales_DimProduct	False
dbo_DimPromotion.	dbo_FactInternetSales.	FK_FactInternetSales_DimPromotion	False
dbo_DimSalesTerritory.	dbo_FactInternetSales.	FK_FactInternetSales_DimSalesTerritory	False
dbo_DimTime.	dbo_FactInternetSales.	FK_FactInternetSales_DimTime2	False
dbo_DimTime.	dbo_FactInternetSales.	FK_FactInternetSales_DimTime	False
dbo_DimTime.	dbo_FactInternetSales.	FK_FactInternetSales_DimTime1	False

Foreign key graph

dbo_DimCurrencydbo_DimCustomerdbo_DimProductdbo_DimPromotiondbo_DimSalesTerritorydbo_DimTimedbo_DimTimedbo_DimTimedbo_FactInternetSales dbo_FactInternetSalesReason

Dependency graph

Adventure Works DWdbo_FactInternetSales

Objects that dbo_FactInternetSales depends on

name	object type	level
Adventure Works DW	DataSourceView	1

Table - dbo_FactInternetSales

Table properties

Columns

References

Referenced by

Foreign key graph

Dependency graph

Objects that dbo_FactInternetSales depends on