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 IT Asset Management 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.
`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.