Sku (Internal)¶
OctoSAM internal query
Internal queries are advanced queries for analysis of the inner workings of the OctoSAM application. These queries are geared towards administrators with an in-depth knowledge of OctoSAM.
This query lists the CCP SKU catalog.
Fields¶
| Name | Type | Visible | Description |
|---|---|---|---|
| ID | numeric | false | OctoSAM internal ID of this entity |
| Article Number | numeric | true | |
| Sku | string | true | |
| Ccp Sku Manufacturer ID | numeric | false | |
| Manufacturer | string | true | Normalized manufacturer information. See field 'Raw Manufacturer' for scanned information |
| Article Text | string | true | |
| Ccp Sku Product Family ID | numeric | false | |
| Product Family | string | true | |
| Edition | string | true | |
| Level | string | true | |
| Ccp Sku License Program ID | numeric | false | |
| License Program | string | true | |
| Ccp Identifier | string | true | |
| Ccp Sku Language ID | numeric | false | |
| Language | string | true | |
| Ccp Sku License Type ID | numeric | false | |
| License Type | string | true | |
| Version | string | true | |
| Ccp Sku License Metric ID | numeric | false | |
| License Metric | string | true | |
| Ccp Sku Platform ID | numeric | false | |
| Platform | string | true | |
| Eccn | string | true | |
| Product Version ID | numeric | true | |
| Product | string | true | |
| End Of Support | date | true | |
| End Of Life | date | true | |
| Release Date | date | true | |
| License Quantity | numeric | true | |
| Maintenance | string | true | |
| Maintenance Duration | numeric | true | |
| Unspsc ID | numeric | true | |
| Unspsc Text | string | true | |
| Eclass ID | numeric | true | |
| Eclass Text | string | true | |
| Rrp | numeric | true | |
| Created | date | false | Date/Time this entity was created |
| Last Ccp Update | date | false | |
| Current Date Time | date | false | Date and time the query was run. For reference if you use and save query results. |
Main entities referenced from this query¶
Query information¶
| Property | Value | Description |
|---|---|---|
| Query Guid | e60621c8-6d8e-43bd-aca4-ffc72e6e9e78 | The internal id of the query. Must be unique |
| SupportsDesktop | true | If true, the query can be started from the OctoSAM Windows GUI |
| SupportsWeb | true | If true, the query can be started from the OctoSAM Web UI |
| LastUpdate | 2025-11-21 18:14:35 | Last change to this document |
| Build | 1.12.2.1 | OctoSAM build that last changed this document |