ReconcileSoftwareLicenseGroupPointsConsumedData Table

FlexNet Manager Suite (Cloud)

This serves as a staging table for SoftwareLicenseGroupPointsConsumed during reconciliation process.

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 ReconcileSoftwareLicenseGroupPointsConsumedData table

Database Column

Details

SoftwareLicenseID

Type: integer. Key

The license that owns the pre-calculated totals for a group. Foreign key to the SoftwareLicense table.

GroupTypeID

Type: integer. Key

Type of the group(Location, Cost center, etc)

GroupExID

Type: text (max 128 characters). Key. Nullable

The group where the local and rolledup values are calculated. Foreign key to the GroupEx table.

RolledUpNumberConsumed

Type: integer

The sum of points consumed of the current group and of all its child groups.

LocalNumberConsumed

Type: integer

The sum of points consumed of the current group

RolledUpNumberUsed

Type: integer

The sum of used points f the current group and of all its child groups.

LocalNumberUsed

Type: integer

The sum of used points of the current group

RolledUpNumberPurchased

Type: integer

The rolled up purchase counts of the license.

LocalNumberPurchased

Type: integer

The local purchase counts of the license

RolledUpNumberCalculated

Type: integer

The sum of points calculated for the current group and of all its child groups.

LocalNumberCalculated

Type: integer

The sum of points calculated for the current group.

FlexNet Manager Suite (Cloud)

Current