ContractType Table

ContractType is a static table listing all contract types in the system.

Table 1. Database columns for ContractType table

Database Column

Details
ContractTypeID

Type: integer. Key. Generated ID

A unique identifier for each ContractType. Possible values and the corresponding default strings are:

  • 1 = General
  • 2 = Lease
  • 3 = Hardware Maintenance and Support
  • 4 = Software License
  • 5 = Software Maintenance and Support
  • 6 = Blanket purchase
  • 7 = Consulting services
  • 8 = Insurance
  • 9 = Rent
  • 10 = Subscription
  • 11 = Microsoft Business and Services Agreement
  • 12 = Microsoft Select License Agreement
  • 13 = Microsoft Select Plus Agreement
  • 14 = Microsoft Select License Enrollment
  • 15 = Microsoft Select Plus Affiliate
  • 16 = Microsoft Enterprise Agreement
  • 17 = Microsoft Enterprise Subscription Agreement.
ContractTypeResourceName

Type: text (max 256 characters). Key

The unique name of the localizable resource string representing a contract type. Foreign key to the ComplianceResourceString table.
ContractTypeDefaultValue

Type: text (max 100 characters)

The text to display if the type resource string has no translation.
XMLFile

Type: text. Nullable

The layout of the property dialog for this type of computer, stored in XML format.
PathResourceName

Type: text (max 256 characters)

The unique name of the localizable resource string representing the parent contract type under which this contract type should be displayed. Foreign key to the ComplianceResourceString table.
PathDefaultValue

Type: text (max 256 characters)

The default parent contract type text to display if the resource string has no translation.
PurchaseProgramID

Type: integer. Nullable

The default purchase program for this contract type.
CanCreate

Type: boolean

Whether the end-user can manually create contracts of this type.