AmoAdventureWorks - Table

Table properties

name	nulls	caption	data type	ordinal	unique	auto increment	auto increment seed	auto increment step	max length
GeographyKey	False	GeographyKey	Int32	0	True	True	0	1
City	True	City	String	1	False				30
StateProvinceCode	True	StateProvinceCode	String	2	False				3
StateProvinceName	True	StateProvinceName	String	3	False				50
CountryRegionCode	True	CountryRegionCode	String	4	False				3
EnglishCountryRegionName	True	EnglishCountryRegionName	String	5	False				50
SpanishCountryRegionName	True	SpanishCountryRegionName	String	6	False				50
FrenchCountryRegionName	True	FrenchCountryRegionName	String	7	False				50
PostalCode	True	PostalCode	String	8	False				15
SalesTerritoryKey	True	SalesTerritoryKey	Int32	9	False

parent column	child column	relation name	nested

name	object type	level
AdventureWorksDW	DataSourceView	1
AmoAdventureWorks	Database	2