Updated: 2009-09-21

Version: Control 4.4

Table Purpose, Usage, and Notes

This table is …

Information on Table Data

  • ClassTypeIDs Stores in Table:
    • 2500 - Service Contract Type

Table Structure

~ Table.FieldName ~ Data Type ~ Description ~ Links To
ServiceContractType.ClassTypeID int Identifier for the Type of Object
ServiceContractType.ContractTypeName varchar(50)
ServiceContractType.Description text
ServiceContractType.ID int Primary Key for the Table
ServiceContractType.IsActive bit Indicates if Enabled. 1Record is Active, 0Record is Not Active
ServiceContractType.IsSystem bit Used to Mark Required Records
ServiceContractType.ModifiedByComputer varchar(25) HostName of computer that last modified this record
ServiceContractType.ModifiedByUser varchar(25) Windows User who last modified this record
ServiceContractType.ModifiedDate datetime DateTime this Record was last modified
ServiceContractType.RenewalPeriod int
ServiceContractType.SeqID int
ServiceContractType.StoreID int Not Used.

Related Tables

You could leave a comment if you were logged in.