SoftwareSku Table
SoftwareSku
defines all software SKU (stock-keeping unit) numbers.
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 |
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. |
Description
|
Type: text (max 256 characters). Key. Nullable The description of the SKU. |
ProductMetric
|
Type: text (max 32 characters). Key. Nullable The Product Metric of the SKU. |
LicenseType
|
Type: text (max 100 characters). Key. Nullable The License Type of the SKU. |
LicenseGroup
|
Type: text (max 16 characters). Key. Nullable The License Group of the SKU. |
LanguageCode
|
Type: text (max 40 characters). Key. Nullable The Language Code of the SKU. |
SKUPurchaseType
|
Type: text (max 16 characters). Key. Nullable The Purchase type of the SKU. |