VendorPurchaseData Table

FlexNet Manager Suite (Cloud)

Stores all of the vendor purchase information. Purchase records are scoped as per the scoping rules in FNMP.

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

Database Column

Details

VendorPurchaseID

Type: integer. Generated ID

Unique identifier for this vendor purchase.

VendorID

Type: integer. Key

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

PurchaseDateID

Type: integer. Key

The date to which this vendor purchase data pertains. Reference to the purchase date dimension.

LocationID

Type: integer. Key

The location where these purchases occurred.

CorporateUnitID

Type: integer. Key

The corporate unit where these purchases occurred.

CostCenterID

Type: integer. Key

The cost center where these purchases occurred.

CategoryID

Type: integer. Key

The category that classifies these purchases.

HardwareCost

Type: currency

The cost of hardware purchased from this vendor on this date.

HardwareMaintenanceCost

Type: currency

The cost of hardware maintenance purchased from this vendor on this date.

SoftwareCost

Type: currency

The cost of software purchased from this vendor on this date.

SoftwareMaintenanceCost

Type: currency

The cost of software maintenance purchased from this vendor on this date.

OtherCost

Type: currency

The cost of other items purchased from this vendor on this date.

FlexNet Manager Suite (Cloud)

Current