AmoAdventureWorks - Table

Table properties

name	value
name	DimReseller
data source view	AdventureWorksDW
case sensitive	False
display expression
friendly name	DimReseller
db schema name	dbo
db table name	DimReseller
type	Table

Columns

name	nulls	caption	data type	ordinal	unique	auto increment	auto increment seed	auto increment step	max length	is logical	db column name	computed column expression
ResellerKey	False	ResellerKey	Int32	0	True	True	0	1
GeographyKey	True	GeographyKey	Int32	1	False
ResellerAlternateKey	True	ResellerAlternateKey	String	2	False				15
Phone	True	Phone	String	3	False				25
BusinessType	False	BusinessType	String	4	False				20
ResellerName	False	ResellerName	String	5	False				50
NumberEmployees	True	NumberEmployees	Int32	6	False
OrderFrequency	True	OrderFrequency	String	7	False				1
OrderMonth	True	OrderMonth	Byte	8	False
FirstOrderYear	True	FirstOrderYear	Int32	9	False
LastOrderYear	True	LastOrderYear	Int32	10	False
ProductLine	True	ProductLine	String	11	False				50
AddressLine1	True	AddressLine1	String	12	False				60
AddressLine2	True	AddressLine2	String	13	False				60
AnnualSales	True	AnnualSales	Decimal	14	False
BankName	True	BankName	String	15	False				50
MinPaymentType	True	MinPaymentType	Byte	16	False
MinPaymentAmount	True	MinPaymentAmount	Decimal	17	False
AnnualRevenue	True	AnnualRevenue	Decimal	18	False
YearOpened	True	YearOpened	Int32	19	False
OrderFrequencyDesc	True	OrderFrequencyDesc	String	20	False				9	True	OrderFrequencyDesc	show/hide CASE WHEN OrderFrequency = 'A' THEN 'Annual' WHEN OrderFrequency = 'S' THEN 'Bi-Annual' ELSE 'Quarterly' END
OrderMonthDesc	True	OrderMonthDesc	String	21	False				13	True	OrderMonthDesc	show/hide CASE WHEN OrderMonth = '1' THEN 'January' WHEN OrderMonth = '2' THEN 'February' WHEN OrderMonth = '3' THEN 'March' WHEN OrderMonth = '4' THEN 'April' WHEN OrderMonth = '5' THEN 'May' WHEN OrderMonth = '6' THEN 'June' WHEN OrderMonth = '7' THEN 'July' WHEN OrderMonth = '8' THEN 'August' WHEN OrderMonth = '9' THEN 'September' WHEN OrderMonth = '10' THEN 'October' WHEN OrderMonth = '11' THEN 'November' WHEN OrderMonth = '12' THEN 'December' ELSE 'Never Ordered' END

Referenced by

parent column	child column	relation name	nested

Objects that DimReseller depends on

name	object type	level
AdventureWorksDW	DataSourceView	1
AmoAdventureWorks	Database	2

Table - DimReseller

Table properties

Columns

Referenced by

Objects that DimReseller depends on