EntitlementTransaction Table

FlexNet Manager Suite (Cloud)

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 (Cloud)

Current