Contract Table

FlexNet Manager Suite (Cloud)

The Contract table contains a list of all the contracts in the system.

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

Database Column

Details

ContractID

Type: integer. Key. Generated ID

A unique identifier for the contract.

ContractNo

Type: text (max 60 characters)

The contract number assigned by the operator.

ContractName

Type: text (max 100 characters)

A contract name assigned by the operator.

ContractTypeID

Type: integer. Key

Identifies the type of contract. Foreign key to the ContractType table.

ContractStatusID

Type: integer

Identifies the status of the contract. Foreign key to the ContractStatus table.

NeverExpires

Type: boolean

If set to True, this contract never expires. If False, the contract expires at the date specified in the EndDate field.

StartDate

Type: datetime. Nullable

The start date of the contract.

EndDate

Type: datetime. Nullable

The end date of the contract.

PreExpiryDate

Type: datetime. Nullable

The date at which a contract should be reviewed prior to its expiry date.

RenewalDate

Type: datetime. Nullable

The date at which a contract is due to be renewed.

Price

Type: currency. Nullable

The price of the contract.

PriceRateID

Type: integer. Nullable

The currency rate to be applied to the above contract price. Foreign key to the CurrencyRate table.

PeriodTypeID

Type: integer. Nullable

The frequency with which the period payments are applicable. Foreign key to the PeriodType table.

BuyoutCost

Type: currency. Nullable

The buyout cost of the contract.

BuyoutCostRateID

Type: integer. Nullable

The currency rate to be applied to the above buyout cost. Foreign key to the CurrencyRate table.

ManagerID

Type: integer. Key. Nullable

The person who manages the contract. Foreign key to the ComplianceUser table.

Comments

Type: text. Nullable

Comments recorded about the contract.

PeriodicPayment

Type: currency. Nullable

The price of periodic payments associated with this contract.

PeriodicPaymentRateID

Type: integer. Nullable

The currency rate to be applied to the periodic payments figure above. Foreign key to the CurrencyRate table.

VendorID

Type: integer. Key. Nullable

The vendor with which the contract agreement has been made. Foreign key to the Vendor table.

MasterContractID

Type: integer. Key. Nullable

The contract that is the parent of this contract. Foreign key to another contract in this Contract table.

LocationID

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

Any enterprise location associated with this contract. Foreign key to the GroupEx table.

BusinessUnitID

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

Any enterprise corporate unit associated with this contract. Foreign key to the GroupEx table.

CostCenterID

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

Any enterprise cost center associated with this contract. Foreign key to the GroupEx table.

CategoryID

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

Any category used in this enterprise that is associated with this contract. Foreign key to the GroupEx table.

LicenseDowngradeEnabled

Type: boolean

If this field is set to True, licenses can inherit downgrade rights from this contract. If False (the default), licenses cannot inherit downgrade rights.

LicenseDowngradeToVersion

Type: boolean

If this field is set to True, any license inheriting downgrade rights from this contract can cover all previous releases (with the same edition) of the primary application. If False, licenses inheriting downgrade rights may not downgrade to earlier versions.

LicenseDowngradeToEdition

Type: boolean

If this field is set to True, any license inheriting downgrade rights from this contract can cover all lower editions of this version of the primary application. If False, licenses inheriting downgrade rights may not downgrade to lower editions.

LicenseUpgradeEnabled

Type: boolean

If this field is set to True, licenses can inherit upgrade rights from this contract. If False (the default), licenses cannot inherit upgrade rights.

LicenseUpgradeToVersion

Type: boolean

If this field is set to True, any license inheriting upgrade rights from this contract can cover all later releases (with the same edition) of the primary application. If False, licenses inheriting upgrade rights may not upgrade to later versions.

LicenseUpgradeUntil ContractExpiry

Type: boolean

If this field is set to True, any license inheriting upgrade rights from this contract can cover all later releases (with the same edition) of the primary application, as long as they were released before the expiry date (EndDate) of the contract. If False, licenses inheriting upgrade rights do not take the application release date into consideration.

GrantSecondUseToLicense

Type: boolean

If this field is set to True, licenses can inherit the right of second use from this contract. If False (the default), licenses cannot inherit the right of second use.

SecondUsageWorkLaptop

Type: boolean

If this field is set to True, any license inheriting from this contract will confer the right of second use on a work laptop. If False, licenses inheriting from this contract will not confer the right of second use.

SecondUsageAtHome

Type: boolean

If this field is set to True, any license inheriting from this contract will confer the right of second use on a home computer, for the same end-user as the primary end-user of the license entitlement consumed at work. If False, licenses inheriting from this contract will not confer the right of second use on a home computer.

GrantVirtualInstallsTo License

Type: boolean

If this field is set to True, licenses can inherit the virtual machine licensing rights from this contract. If False (the default), licenses cannot inherit virtual machine licensing rights.

CoverInstallsOnVirtual Machines

Type: boolean

If this field is set to True, any license inheriting virtual machine rights from this contract may be used to account for installations on virtual machines. If False, licenses inheriting virtual machine rights may only account for installations on physical machines.

LimitNumberOfVirtual Installs

Type: boolean

If this field is set to True, there is a limit to the number of virtual machine installations that may be covered by any license inheriting virtual machine rights from this contract. If this field is False, one license entitlement may cover any use on virtual machines (typically within one host computer).

NumberOfAllowedVirtual Installs

Type: integer. Nullable

If this contracts confers the right for an inheriting license to cover installations on virtual machines, this field specifies how many installations per host are allowed before an additional license entitlement (or point) is consumed.

LimitVirtualInstalls IncludesHost

Type: boolean

If this field is True, the host operating system installations are included in the overall count of operating systems on the host when there is a limit on the number of allowed virtual installs for each license. If False, the host operating system is not considered when determining virtual install limits.

UseHostProcessor Information

Type: boolean

If virtual installs are allowed, this field controls whether host information is used by an inheriting license when calculating the license points consumed.

GrantLimitPointsToLicense

Type: boolean

If this field is set to True, licenses can inherit the right of multiple use from this contract. If False (the default), licenses cannot inherit the right of multiple use.

LimitNumberOf ApplicationsEach LicensePointCovers

Type: boolean

If this field is set to True, there is a limit, for any inheriting license, to the number of application installations allowed per license entitlement (or point). If this bit is False (the default), an inheriting license entitles you to any number of installations of software linked to this license on the one computer.

NumberOfApplication InstallsAllowedPer LicensePoint

Type: integer. Nullable

Where the previous field is set to True, this column defines the limited number of application installations allowed per entitlement (or point).

LimitNumberOfComputers UserLicenseCanBe InstalledOn

Type: boolean

If this field is set to True, there is a limit, for an inheriting user-based license, to the number of computers that an end-user can use per entitlement (or point) consumed. If this field is False (the default), a single end-user is entitled to install related software for his/her own use on any number of computers.

NumberOfComputers AllowedPerUserLicense Point

Type: integer. Nullable

Where the previous field is set to True, this column defines the limited number of application installations an end-user is allowed per entitlement (or point).

InitialPlatformQuantity

Type: integer. Nullable

The number of desktops covered by the Microsoft Enterprise Agreement platform license at the start of the agreement.

PurchaseProgramID

Type: integer. Nullable

Identifies the purchase program of contract. Foreign key to the PurchaseProgram table.

MSSelectApplication LevelID

Type: integer. Nullable

Identifies the Microsoft Select level for applications. Foreign key to the MSSelectLevel table.

MSSelectSystemLevelID

Type: integer. Nullable

Identifies the Microsoft Select level for systems. Foreign key to the MSSelectLevel table.

MSSelectServerLevelID

Type: integer. Nullable

Identifies the Microsoft Select level for servers. Foreign key to the MSSelectLevel table.

CreationUser

Type: text (max 128 characters). Nullable

The operator who created the record.

CreationDate

Type: datetime

The date the record was created.

UpdatedUser

Type: text (max 128 characters). Nullable

The operator who last updated the record.

UpdatedDate

Type: datetime. Nullable

The date the record was last updated.

TotalValue

Type: currency. Nullable

The total value of the contract.

TotalValueRateID

Type: integer. Nullable

The rate for the total value. Foreign key to the CurrencyRate table.

MonthlyValue

Type: currency. Nullable

The cost of the contract per month.

MonthlyValueRateID

Type: integer. Nullable

The rate for the monthly cost. Foreign key to the CurrencyRate table.

ProjectID

Type: integer. Key. Nullable

A project for the Contract. Foreign key to the Project table.

SecurityTypeID

Type: integer. Nullable

The type of security to use when determining which operators have access to the contract. Foreign key to the SecurityType table.

PreviousContractID

Type: integer. Key. Nullable

A link to a contract that this contract has replaced. Foreign key to the Contract table.

ContractStateID

Type: integer. Nullable

The state of the contract. Foreign key to the ContractState table.

LastRenewedDate

Type: datetime. Nullable

The date when the contract was last renewed.

LicenseConsumptionEnabled

Type: boolean

If this field is set to True, licenses can inherit consumption rules from this contract. If False (the default), licenses cannot inherit consumption rules.

LicenseMobilityEnabled

Type: boolean

If this field is set to True, licenses can inherit mobility rights from this contract. If False (the default), licenses cannot inherit mobility rights.

ProcessorLimitsEnabled

Type: boolean

If this field is set to True, licenses can inherit rights related to processor limits from this contract. If False (the default), licenses cannot inherit rigts related to processor limits.

FlexNet Manager Suite (Cloud)

Current