LicenseComplianceHistory

History of license compliance changes.

erDiagram
    Currency ||--o{ LicenseComplianceHistory : "InitialCostCurrencyID"
    Currency ||--o{ LicenseComplianceHistory : "RecurringCostCurrencyID"

Fields

Field	Type	Description
ComplianceChangeDetected	datetime	Date/Time when the compliance change was detected
ComplianceQueryGuid	guid	Unique identifier for the compliance query
ComplianceQueryPath	string	Path to the compliance query
ConsumedUnits	decimal	Number of consumed units
ConsumedUnitsWarningUnitThreshold	decimal	Threshold for warning on consumed units
Created	datetime	Date/Time when the record was created
CreatedBy	string	User who created the record
ExtraData	string	Additional data related to the compliance history
ID	numeric	Internal ID for the LicenseComplianceHistory entity (Primary Key)
InitialCost	decimal	Initial cost of the license
InitialCostCurrencyID	numeric	Internal ID that references the Currency entity (Foreign Key)
LastRefresh	datetime	Date/Time when the record was last refreshed
Machines	numeric	Number of machines associated with the license
ManualChange	boolean	Indicates if the change was made manually
Notes	string	Additional notes related to the license compliance
RecurringCost	decimal	Recurring cost of the license
RecurringCostCurrencyID	numeric	Internal ID that references the Currency entity (Foreign Key)
SoftwareItemGuid	guid	Unique identifier for the software item
SoftwareItemName	string	Name of the software item
TotalInitialCost	decimal	Total initial cost of the license
TotalRecurringCost	decimal	Total recurring cost of the license
Units	decimal	Number of units
Users	numeric	Number of users

References

Column Name	Referenced Table	Description
InitialCostCurrencyID	Currency	Lookup table for currencies
RecurringCostCurrencyID	Currency	Lookup table for currencies