Skip to content

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