PurchaseProgram Table

PurchaseProgram is a static table listing all known contract purchase programs.

Table 1. Database columns for PurchaseProgram table

Database Column

Details

PurchaseProgramID

Type: integer. Key. Generated ID

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

  • 1 = Microsoft Select Agreement
  • 2 = Microsoft Enterprise Agreement
  • 3 = Microsoft Open Agreement
  • 4 = Adobe Cumulative Licensing Program
  • 5 = Adobe Transactional Licensing Program
  • 6 = Adobe Site License Program
  • 7 = Acronis Licensing Program
  • 8 = Attachmate Volume Purchase Account
  • 9 = Business Objects Open Licensing Program
  • 10 = CA Master License Program
  • 11 = CA Open License Program
  • 12 = Citrix Easy Licensing Program
  • 13 = Citrix Enterprise License Program
  • 14 = Citrix Open Licensing Program
  • 15 = Citrix Premium Licensing Program
  • 16 = Corel Contractual License
  • 17 = Corel Transactional Licensing
  • 18 = IBM Passport Advantage
  • 19 = McAfee TSP Licensing Program
  • 20 = Novell Corporate License Agreement
  • 21 = Novell Master License Agreement
  • 22 = Novell Volume License Agreement
  • 23 = Symantec Elite
  • 24 = Symantec Express
  • 25 = Symantec Open Licensing Program
  • 26 = Symantec Rewards
  • 27 = Symantec Volume Licensing Program
  • 28 = Vmware Purchasing Program
  • 29 = Macromedia Volume License Program
  • 30 = Symantec Enterprise Option
  • 31 = Symantec Enterprise VPA.
  • 32 = Oracle Master Agreement
  • 33 = Oracle Unlimited Agreement
  • 34 = Oracle License and Services Agreement
  • 35 = Adobe Enterprise Term Licensing Agreement
  • 36 = Microsoft Products and Services Agreement
  • 37 = IBM Passport Advantage Express
  • 38 = IBM Enterprise License Agreement
  • 39 = IBM Enterprise Software and Services Option
Name

Type: text (max 100 characters). Key

The display name of the purchase program.

PublisherName

Type: text (max 64 characters). Key

The name of publisher under which this purchase program applies.

Code

Type: text (max 16 characters). Key

A short code used to represent this purchase program.