Contract Table

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 master 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.
`UUID`	Type: unique identifier The UUID of the contract for external reference.