{$page}

Updated: 2009-09-21

Version: Control 4.4

Table Purpose, Usage, and Notes

This table is …

Information on Table Data

  • ClassTypeIDs Stores in Table:
    • 4100 - Phone Number

Table Structure

~ Table.FieldName ~ Data Type ~ Description ~ Links To
PhoneNumber.AreaCode nvarchar(10)
PhoneNumber.ClassTypeID int Identifier for the Type of Object
PhoneNumber.CountryCode nvarchar(10)
PhoneNumber.Extension nvarchar(10)
PhoneNumber.FormattedText nvarchar(75)
PhoneNumber.ID int Primary Key for the Table
PhoneNumber.IsActive bit Indicates if Enabled. 1Record is Active, 0Record is Not Active
PhoneNumber.IsSystem bit Used to Mark Required Records
PhoneNumber.ModifiedByComputer nvarchar(25) HostName of computer that last modified this record
PhoneNumber.ModifiedByUser nvarchar(25) Windows User who last modified this record
PhoneNumber.ModifiedDate datetime DateTime this Record was last modified
PhoneNumber.ParentClassTypeID int
PhoneNumber.ParentID int ID of Category/Group Above
PhoneNumber.ParentStoreID int Not Used.
PhoneNumber.PhoneNumber nvarchar(25)
PhoneNumber.PhoneNumberIndex int
PhoneNumber.PhoneNumberTypeID int
PhoneNumber.PhoneNumberTypeText varchar(50)
PhoneNumber.SeqID int
PhoneNumber.StoreID int Not Used.

Related Tables

See Also

You could leave a comment if you were logged in.