PurchaseData Table

FlexNet Manager Suite (Cloud)

The Purchases table will store all purchase information that is required for the External Consumption Fact.

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

Database Column

Details

PurchasesDataID

Type: integer. Generated ID

A unique identifier for this purchase information.

SnapshotID

Type: integer. Key

The snapshot to which this purchase data pertains. Reference to the snapshot dimension.

SoftwareLicenseID

Type: integer. Key

The license to which these purchases pertain. Reference to software license dimension.

LocationID

Type: integer. Key

The location which has made these purchases.

CorporateUnitID

Type: integer. Key

The corporate unit which has made these purchases.

CostCenterID

Type: integer. Key

The cost center which has made these purchases.

CategoryID

Type: integer. Key

The category which classifies this license purchases.

PurchasedCount

Type: integer. Nullable

The number of license entitlements purchased.

PurchasedCost

Type: currency. Nullable

The purchase cost for these license entitlements.

LastPurchaseDate

Type: datetime. Nullable

The last date on which a purchase of entitlements for this license was made.

FlexNet Manager Suite (Cloud)

Current