PODetailProcess Table

PODetailProcess records the processing steps taken when applying upgrades to software installations. The newly-purchased upgrade license is linked here to the original license being upgraded.

Note: To cater for multi-tenant mode, this table may contain data for multiple tenants. Access requires that the database TenantID has been set in the SQL Server connection context information. That setting filters an underlying table to produce this view of data for the single, selected tenant.
Table 1. Database columns for PODetailProcess table

Database Column

Details

PurchaseOrderDetailID

Type: integer. Key

The purchase order line that defines this upgrade. Foreign key to the PurchaseOrderDetail table.

FromSoftwareLicenseID

Type: integer. Key. Nullable

The original software license to which an upgrade is being applied. Foreign key to the SoftwareLicense table.

ToSoftwareLicenseID

Type: integer. Key. Nullable

The upgrade license referenced in the PO line and permitting the installation of the software upgrade. Foreign key to the SoftwareLicense table.

ProcessActionID

Type: integer

The processing action taken with respect to this upgrade. Defaults to Defer. Foreign key to the ProcessAction table.

ProcessStateID

Type: integer. Key

The resulting process state of the upgrade. Foreign key to the ProcessState table.

CreationDate

Type: datetime

The date this record was created.