PurchaseOrderStatus Table

FlexNet Manager Suite 2020 R1 (On-Premises)

PurchaseOrderStatus is a static table listing the possible states for purchase orders, broadly tracking the associated business processes.

Table 1. Database columns for PurchaseOrderStatus table

Database Column

Details

PurchaseOrderStatusID

Type: integer. Key. Generated ID

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

  • 1 = New
  • 2 = Completed
  • 3 = Cancelled
  • 4 = Sent to approver
  • 5 = Sent to vendor
  • 6 = Item received.
ResourceName

Type: text (max 256 characters). Key

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

DefaultValue

Type: text (max 100 characters)

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

FlexNet Manager Suite (On-Premises)

2020 R1