CREATE TABLE Devices (
	DeviceID COUNTER UNIQUE PRIMARY KEY, 
	SystemID int NULL ,
	DeviceReportedName varchar (50) NULL ,
	DeviceAssignedName varchar (50) NULL ,
	DeviceIPMain varchar (50) NULL ,
	DeviceType int NULL ,
	ShortDescription varchar (60) NULL ,
	LongDescription memo NULL ,
	Location varchar (50) NULL ,
	DeviceTZ int NULL ,
	AdminName varchar (50) NULL ,
	AdminOfficePhone varchar (16) NULL ,
	AdminMobilePhone varchar (16) NULL ,
	AdminHomePhone varchar (50) NULL ,
	AdminEMail varchar (50) NULL ,
	AdminPager varchar (50) NULL ,
	Status int NULL ,
	AutoCreated int NULL ,
	DateCreated datetime NULL ,
	DateLastSeen datetime NULL ,
	DatePurchased datetime NULL ,
	DateRetired datetime NULL ,
	RecordStatus int NULL 
) 