CcpSku

CCP SKU information.

erDiagram
    CcpEclass ||--o{ CcpSku : "CcpEclassID"
    CcpLanguage ||--o{ CcpSku : "CcpLanguageID"
    CcpLicenseMetric ||--o{ CcpSku : "CcpLicenseMetricID"
    CcpLicenseType ||--o{ CcpSku : "CcpLicenseTypeID"
    CcpManufacturer ||--o{ CcpSku : "CcpManufacturerID"
    CcpPlatform ||--o{ CcpSku : "CcpPlatformID"
    CcpProductFamily ||--o{ CcpSku : "CcpProductFamilyID"
    CcpSkuLicenseProgram ||--o{ CcpSku : "CcpSkuLicenseProgramID"
    CcpUnspsc ||--o{ CcpSku : "CcpUnspscID"

Fields

Field	Type	Description
ArticleNumber	numeric
ArticleText	string
CcpEclassID	numeric	Internal ID that references the CcpEclass entity (Foreign Key)
CcpIdentifier	string
CcpLanguageID	numeric	Internal ID that references the CcpLanguage entity (Foreign Key)
CcpLicenseMetricID	numeric	Internal ID that references the CcpLicenseMetric entity (Foreign Key)
CcpLicenseTypeID	numeric	Internal ID that references the CcpLicenseType entity (Foreign Key)
CcpManufacturerID	numeric	Internal ID that references the CcpManufacturer entity (Foreign Key)
CcpPlatformID	numeric	Internal ID that references the CcpPlatform entity (Foreign Key)
CcpProductFamilyID	numeric	Internal ID that references the CcpProductFamily entity (Foreign Key)
CcpSkuLicenseProgramID	numeric	Internal ID that references the CcpSkuLicenseProgram entity (Foreign Key)
CcpUnspscID	numeric	Internal ID that references the CcpUnspsc entity (Foreign Key)
Created	datetime
Eccn	string
Edition	string
EndOfLife	date
EndOfSupport	date
ID	numeric	Internal ID for the CcpSku entity (Primary Key)
LastCcpUpdate	datetime
Level	string
LicenseQuantity	numeric
Maintenance	string
MaintenanceDuration	numeric
Product	string
ProductVersionID	numeric
ReleaseDate	date
Rrp	decimal
Sku	string
Version	string

References

Column Name	Referenced Table	Description
CcpEclassID	CcpEclass	CCP Eclass information
CcpLanguageID	CcpLanguage	CCP Language codes
CcpLicenseMetricID	CcpLicenseMetric	CCP License Metric information
CcpLicenseTypeID	CcpLicenseType	CCP License Type information
CcpManufacturerID	CcpManufacturer	CCP Manufacturer information
CcpPlatformID	CcpPlatform	CCP Platform information
CcpProductFamilyID	CcpProductFamily	CCP Product Family information
CcpSkuLicenseProgramID	CcpSkuLicenseProgram	CCP SKU License Program information
CcpUnspscID	CcpUnspsc	CCP UNSPSC information