Updated: 2009-09-21

Version: Control 4.4

Table Purpose, Usage, and Notes

This table is …

Information on Table Data

Table Structure

~ Table.FieldName ~ Data Type ~ Description ~ Links To
Country.AddressFormatString nvarchar(30)
Country.AreaCodeDigits int
Country.ClassTypeID int Identifier for the Type of Object
Country.Country nvarchar(40)
Country.CountryCode int
Country.CountryShortName nvarchar(15)
Country.ID int Primary Key for the Table
Country.IsActive bit Indicates if Enabled. 1Record is Active, 0Record is Not Active
Country.IsSystem bit Used to Mark Required Records
Country.ModifiedByComputer nvarchar(50) HostName of computer that last modified this record
Country.ModifiedByUser nvarchar(50) Windows User who last modified this record
Country.ModifiedDate datetime DateTime this Record was last modified
Country.ParentClassTypeID int
Country.ParentID int ID of Category/Group Above
Country.PhoneFormatString nvarchar(30)
Country.PhoneTemplate nvarchar(50)
Country.SeqID int
Country.StoreID int Not Used.
Country.TranslationLanguage nvarchar(30)
Country.ZipMaxDigits int
Country.ZipShortDigits int

Related Tables