ContractType_CODE Table

ContractType CODE is a dimension table storing contract type information.

Table 1. Database columns for ContractType_CODE table

Database Column

Details

ContractTypeID

Type: integer. Key

A unique identifier for Contract type. 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
ContractType_en

Type: text (max 1000 characters)

Contract Type of the Contract in English.

ContractType_de

Type: text (max 1000 characters)

Contract Type of the Contract in German.

ContractType_fr

Type: text (max 1000 characters)

Contract Type of the Contract in French.

ContractType_ja

Type: text (max 1000 characters)

Contract Type of the Contract in Japanese.

ContractType_es

Type: text (max 1000 characters)

Contract Type of the Contract in Spanish.