PurchaseOrderDetailType Table

PurchaseOrderDetailType is a static table listing the possible types of purchase order line item.

Table 1. Database columns for PurchaseOrderDetailType table

Database Column

Details

PurchaseOrderDetailTypeID

Type: integer. Key. Generated ID

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

  • 1 = Not set
  • 2 = Software
  • 3 = Hardware
  • 4 = Service
  • 5 = Other
  • 6 = Software upgrade
  • 7 = Software maintenance
  • 8 = Disk kit
  • 9 = Hardware maintenance
  • 10 = Software Baseline
  • 11 = Software subscription.
ResourceName

Type: text (max 256 characters). Key

The unique name of the localizable resource string representing a purchase order line item type. Foreign key to the ComplianceResourceString table.

DefaultValue

Type: text (max 100 characters)

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