SoftwareSku Table

SoftwareSku defines all software SKU (stock-keeping unit) numbers.

Table 1. Database columns for SoftwareSku table

Database Column

Details

SoftwareSkuID

Type: integer. Key. Generated ID

A unique identifier for a software SKU.

SKUFactoryUID

Type: text (max 30 characters). Key

A FlexNet Manager Suite factory unique ID for this SKU.

SKU

Type: text (max 100 characters). Key

Holds the SKU value.

SKUDefinition

Type: text

Encrypted data that describes this SKU.

SoftwareLicense DefinitionID

Type: integer. Key

SKU license definition. Used to create new licenses and link them to applications. Foreign key to the SoftwareLicenseDefinition table.

SoftwareSkuTypeID

Type: integer. Key

For internal use only. A numerical representation of the type of SKU.

MaintenanceTypeID

Type: integer

For internal use only. A numerical representation of the maintenance type (if any) of the SKU.

Version

Type: integer. Key

The current version of the SKU definition.

PreviousVersion

Type: integer. Key. Nullable

The version of the SKU definition prior to the current version.

CreationDate

Type: datetime

The date that this SKU definition was created.

UpdatedDate

Type: datetime. Nullable

The date that this SKU definition was last updated.

SKUPrefixLength

Type: integer. Key. Nullable

The location of the % wildcard.