PurchaseType_CODE Table

FlexNet Manager Suite 2020 R1 (On-Premises)

PurchaseType CODE is a dimension table storing purchase type information.

Table 1. Database columns for PurchaseType_CODE table

Database Column

Details
PurchaseTypeID

Type: integer. Key

A unique identifier for purchase order detail type. Possible values and the corresponding default strings are:

  • 1 = NotSet
  • 2 = Software
  • 3 = Hardware
  • 4 = Service
  • 5 = Other
  • 6 = Software Upgrade
  • 7 = Software Maintenance
  • 8 = DiskKit
  • 9 = Hardware Maintenance
  • 10 = Software Baseline
  • 11 = Software Subscription
PurchaseType_en

Type: text (max 1000 characters)

Purchase Type of the purchase in English.
PurchaseType_de

Type: text (max 1000 characters)

Purchase Type of the purchase in German.
PurchaseType_fr

Type: text (max 1000 characters)

Purchase Type of the purchase in French.
PurchaseType_ja

Type: text (max 1000 characters)

Purchase Type of the purchase in Japanese.
PurchaseType_es

Type: text (max 1000 characters)

Purchase Type of the purchase in Spanish.

FlexNet Manager Suite (On-Premises)

2020 R1