Adventure Works DW - Table - dbo

Table properties

name	value
name	dbo_FactResellerSales
data source view	Adventure Works DW
case sensitive	False
display expression
friendly name	FactResellerSales
db schema name	dbo
db table name	FactResellerSales
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
ResellerKey	False	ResellerKey	Int32	4	False			ResellerKey
EmployeeKey	False	EmployeeKey	Int32	5	False			EmployeeKey
PromotionKey	False	PromotionKey	Int32	6	False			PromotionKey
CurrencyKey	False	CurrencyKey	Int32	7	False			CurrencyKey
SalesTerritoryKey	False	SalesTerritoryKey	Int32	8	False			SalesTerritoryKey
SalesOrderNumber	False	SalesOrderNumber	String	9	False	20		SalesOrderNumber
SalesOrderLineNumber	False	SalesOrderLineNumber	Byte	10	False			SalesOrderLineNumber
RevisionNumber	True	RevisionNumber	Byte	11	False			RevisionNumber
OrderQuantity	True	OrderQuantity	Int16	12	False			OrderQuantity
UnitPrice	True	UnitPrice	Decimal	13	False			UnitPrice
ExtendedAmount	True	ExtendedAmount	Decimal	14	False			ExtendedAmount
UnitPriceDiscountPct	True	UnitPriceDiscountPct	Double	15	False			UnitPriceDiscountPct
DiscountAmount	True	DiscountAmount	Double	16	False			DiscountAmount
ProductStandardCost	True	ProductStandardCost	Decimal	17	False			ProductStandardCost
TotalProductCost	True	TotalProductCost	Decimal	18	False			TotalProductCost
SalesAmount	True	SalesAmount	Decimal	19	False			SalesAmount
TaxAmt	True	TaxAmt	Decimal	20	False			TaxAmt
Freight	True	Freight	Decimal	21	False			Freight
CarrierTrackingNumber	True	CarrierTrackingNumber	String	22	False	25		CarrierTrackingNumber
CustomerPONumber	True	CustomerPONumber	String	23	False	25		CustomerPONumber
SalesOrderDesc	True	SalesOrderDesc	String	24	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_FactResellerSales.	FK_FactResellerSales_DimCurrency	False
dbo_DimEmployee.	dbo_FactResellerSales.	FK_FactResellerSales_DimEmployee	False
dbo_DimProduct.	dbo_FactResellerSales.	FK_FactResellerSales_DimProduct	False
dbo_DimPromotion.	dbo_FactResellerSales.	FK_FactResellerSales_DimPromotion	False
dbo_DimReseller.	dbo_FactResellerSales.	FK_FactResellerSales_DimReseller	False
dbo_DimSalesTerritory.	dbo_FactResellerSales.	FK_FactResellerSales_DimSalesTerritory	False
dbo_DimTime.	dbo_FactResellerSales.	FK_FactResellerSales_DimTime1	False
dbo_DimTime.	dbo_FactResellerSales.	FK_FactResellerSales_DimTime2	False
dbo_DimTime.	dbo_FactResellerSales.	FK_FactResellerSales_DimTime	False

Foreign key graph

dbo_DimCurrencydbo_DimEmployeedbo_DimProductdbo_DimPromotiondbo_DimResellerdbo_DimSalesTerritorydbo_DimTimedbo_DimTimedbo_DimTimedbo_FactResellerSales

Dependency graph

Adventure Works DWdbo_FactResellerSales

Objects that dbo_FactResellerSales depends on

name	object type	level
Adventure Works DW	DataSourceView	1

Table - dbo_FactResellerSales

Table properties

Columns

References

Foreign key graph

Dependency graph

Objects that dbo_FactResellerSales depends on