Database reference - AmoAdventureWorks

Table - FactResellerSales

Table properties

name	value
name	FactResellerSales
data source view	AdventureWorksDW
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	auto increment	auto increment seed	auto increment step	datetime mode	max length	is logical	db column name	computed column expression
ProductKey	False	ProductKey	Int32	0	False
OrderDateKey	False	OrderDateKey	Int32	1	False
DueDateKey	False	DueDateKey	Int32	2	False
ShipDateKey	False	ShipDateKey	Int32	3	False
ResellerKey	False	ResellerKey	Int32	4	False
EmployeeKey	False	EmployeeKey	Int32	5	False
PromotionKey	False	PromotionKey	Int32	6	False
CurrencyKey	False	CurrencyKey	Int32	7	False
SalesTerritoryKey	False	SalesTerritoryKey	Int32	8	False
SalesOrderNumber	False	SalesOrderNumber	String	9	False					20
SalesOrderLineNumber	False	SalesOrderLineNumber	Byte	10	False
RevisionNumber	True	RevisionNumber	Byte	11	False
OrderQuantity	True	OrderQuantity	Int16	12	False
UnitPrice	True	UnitPrice	Decimal	13	False
ExtendedAmount	True	ExtendedAmount	Decimal	14	False
UnitPriceDiscountPct	True	UnitPriceDiscountPct	Double	15	False
DiscountAmount	True	DiscountAmount	Double	16	False
ProductStandardCost	True	ProductStandardCost	Decimal	17	False
TotalProductCost	True	TotalProductCost	Decimal	18	False
SalesAmount	True	SalesAmount	Decimal	19	False
TaxAmt	True	TaxAmt	Decimal	20	False
Freight	True	Freight	Decimal	21	False
CarrierTrackingNumber	True	CarrierTrackingNumber	String	22	False					25
CustomerPONumber	True	CustomerPONumber	String	23	False					25

References

parent column	child column	relation name	nested
DimCurrency.	FactResellerSales.	FK_FactResellerSales_CurrencyKey	False
DimProduct.	FactResellerSales.	FK_FactResellerSales_ProductKey	False
DimReseller.	FactResellerSales.	FK_FactResellerSales_ResellerKey	False
DimTime.	FactResellerSales.	FK_FactResellerSales_DueDateKey	False
DimTime.	FactResellerSales.	FK_FactResellerSales_ShipDateKey	False
DimTime.	FactResellerSales.	FK_FactResellerSales_OrderDateKey	False

Objects that FactResellerSales depends on

name	object type	level
AdventureWorksDW	DataSourceView	1
AmoAdventureWorks	Database	2

Documentation generated by SqlSpec