LicenseSimulationLicenseDetails Table

LicenseSimulationLicenseDetails stores properties associated with each license included in a simulation scenario. The LicenseSimulationScenario associated with each record could be an original snapshot of data, or a user modifiable scenario.

Note: To cater for multi-tenant mode, this table may contain data for multiple tenants. Access requires that the database TenantID has been set in the SQL Server connection context information. That setting filters an underlying table to produce this view of data for the single, selected tenant.
Table 1. Database columns for LicenseSimulationLicenseDetails table

Database Column

Details

LicenseSimulation LicenseDetailsID

Type: integer. Key. Generated ID

A unique identifier for a license item that is part of a simulation scenario.

OriginalLicense SimulationLicense DetailsID

Type: integer. Key. Nullable

The original version of this license, that has not been modified by a simulation user.

LicenseSimulation ScenarioID

Type: integer. Key

The simulation scenario this softare license is part of. Foreign key to the LicenseSimulationScenario table.

SoftwareLicenseID

Type: integer. Key

The software license for this simulation license. Foreign key to the SoftwareLicense table.

UnitPrice

Type: currency. Nullable

The unit price associated with this license.

UnitPriceRateID

Type: integer. Nullable

The rate for the total value. Foreign key to the CurrencyRate table.

LicenseSimulation ChangeTypeID

Type: integer

Tracks the state of the softare license, as it gets modified by the simulation user. Foreign key to the LicenseSimulationChangeType table.