EntitlementTransaction Table

FlexNet Manager Suite 2020 R1 (On-Premises)

EntitlementTransaction is a table listing all of the recommendations that have been made to link entitlements to licenses.

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 `EntitlementTransaction` table
Database Column	Details
`EntitlementTransactionID`	Type: integer. Key. Generated ID A unique identifier for this transaction.
`Entitlement RecommendationID`	Type: integer. Key. Nullable The recommendation this transaction is related to if any. Foreign key to the `EntitlementRecommendation` table.
`SoftwareLicenseID`	Type: integer. Key. Nullable The license affected by this recommendation. If a new license is being created from a recommendation but the recommendation is pending, the value of this field is null. The license identified depends on the EntitlementTransactionType. For a recommendation, this could be the license being updated (the “from” license) or it could be the new license (the “to” license). Foreign key to the `SoftwareLicense` table.
`PurchaseOrderDetailID`	Type: integer. Key. Nullable The purchase order line associated with this transaction. Foreign key to the `PurchaseOrderDetail` table.
`Adjustment`	Type: integer. Nullable The (potentially partial) amount of the purchased license quantity that is being applied to the license.
`OtherCandidates`	Type: boolean. Nullable Whether there were other licenses which could have been recommended.
`EntitlementTransaction TypeID`	Type: integer. Nullable The type of the transaction. Foreign key to the `EntitlementTransactionType` table.
`Entitlement RecommendationStateID`	Type: integer. Key. Nullable The state that the transaction is in. Foreign key to the `EntitlementRecommendationState` table.
`IsDeferred`	Type: boolean Flags the entitlement transaction whether it is deferred for later processing.
`TransactionUser`	Type: text (max 128 characters). Nullable The operator who last updated the record.
`TransactionDate`	Type: datetime. Nullable The date the record was last updated.
`PreviousMaintenance Definition`	Type: text. Nullable Encrypted XML definition of the maintenance previously applied to the license associated with this transaction.
`PreviousMaintenance ContractID`	Type: integer. Nullable The ID of the contract previously giving maintenance to the license associated with this transaction. Foreign key to the `Contract` table.
`LicenseNameMatched`	Type: boolean Indicates whether or not there was a license name match.
`PrimaryApplicationMatched`	Type: boolean Indicates whether or not there was a primary application match.
`AnyApplicationMatched`	Type: boolean Indicates whether or not there was a match on any application.
`MaintenanceSettings Matched`	Type: boolean Indicates whether or not there was a match based on maintenance settings.
`EnterpriseGroupMatched`	Type: boolean Indicates whether or not there was a match based on enterprise groups.
`NumberOfVersionsDifferent`	Type: integer Indicated the number of versions between the version being upgraded to from the version being upgraded from.
`EntitlementTransaction StateID`	Type: integer The state of the transaction. Foreign key to the `EntitlementTransactionState` table.
`AdjustmentDefault`	Type: integer. Nullable The default amount of the purchased license quantity that is being applied to the license.
`AllowMaintenanceGap`	Type: boolean Will determine if the end users will be alerted about a gap in maintenance for this purchase. If this is set to 0, then an alert will be generated if a gap is detected. if it is set to 1, then no alert will be generated.

FlexNet Manager Suite (On-Premises)

2020 R1