SoftwareItem¶
Software items hold customer specific information about software objects.
Fields¶
Field | Type | Description |
---|---|---|
Active | bit | Mark the Item as active. Inactive items can be hidden from most lists. |
AdditionalInfoLink | nvarchar | Can contain a link to additional information |
AdministratorNotes | nvarchar | Remarks that can only be read by a small group of users |
ConsumedUnits | decimal | A universal field that can contain a number |
Created | datetime2 | Date/Time the item got created |
CreatedByRbacUserID | bigint | RBAC user that created the item |
CustomField1 | nvarchar | Custom field 1, not used by OctoSAM. |
CustomField2 | nvarchar | Custom field 2, not used by OctoSAM. |
CustomField3 | nvarchar | Custom field 3, not used by OctoSAM. |
CustomField4 | nvarchar | Custom field 4, not used by OctoSAM. |
CustomField5 | nvarchar | Custom field 5, not used by OctoSAM. |
CustomField6 | nvarchar | Custom field 6, not used by OctoSAM. |
Description | nvarchar | Description of the item. Can be html formatted. |
Enabled | bit | If not enabled, the Item cannot be edited. |
EndDate | datetime2 | End date of the software item |
ExtraData | nvarchar | Extra data for this software item |
Guid | uniqueidentifier | Unique ID of the item, can be used for export/import or for the web UI. |
ID | bigint | Internal ID for the SoftwareItem entity (Primary Key) |
InitialCost | decimal | Initial Cost |
InitialCostCurrencyID | bigint | Internal ID that references the Currency entity (Foreign Key) |
LastModification | datetime2 | Date/Time the item was last modified |
LastModifiedByRbacUserID | bigint | RBAC user that last modified the item |
Name | nvarchar | Name of the software Item |
Notes | nvarchar | Remarks that are visible to all users that have read access to the item |
OwnerNotes | nvarchar | Remarks that can only be read by software package owners |
PrintableName | nvarchar | Name of this item for reports and queries |
RecurringCost | decimal | Recurring Cost |
RecurringCostCurrencyID | bigint | Internal ID that references the Currency entity (Foreign Key) |
Res1 | nvarchar | Reserved for future use |
Res2 | nvarchar | Reserved for future use |
SiteUniqueID | nvarchar | A site defined unique id for each item. Must be unique if not empty. |
SoftwareInstallationApproval | bit | Installation approval logic is active for this software item |
SoftwarePublisherID | bigint | Internal ID that references the SoftwarePublisher entity (Foreign Key) |
Spla | bit | True, if the Software Item describes a Microsoft SPLA item |
StartDate | datetime2 | Start date of the software item |
Units | decimal | A universal field that can contain a number |
Version | nvarchar | Version of the software item |
Visible | bit | Item is visible |
VisibleStartDate | datetime2 | Item becomes automatically visible after this date |