The Contract Object

This item maps to the Contract object in the FlexNet Manager Suite compliance database. It supports the addition of custom properties through the Business Importer.

Behavior in the Business Adapter Studio

When you create new objects in the Business Adapter Studio, the Contract appears in the Contract group in the right-click context menu.

Properties

The Contract object exposes the following properties in the data model for the Business Importer and the Business Adapter Studio.

Table 1. Data model properties for `Contract` object (alphabetical listing)
Property	Details
`Category ID`	Type: `varchar`. Maximum: 128. Stores the `categoryID` as a foreign key to the `category` table in the compliance database.
`Comments`	Type: `ntext`. Maps to `Contract.Comments` in the compliance database.
`Contract Description`	Type: `nvarchar`. Maximum: 100. Mandatory: adapters must provide values for this column. Maps to `Contract.ContractName` in the compliance database.
`Contract No`	Type: `nvarchar`. Maximum: 60. Mandatory: adapters must provide values for this column. Maps to `Contract.ContractNo` in the compliance database.
`Contract Status`	Type: `nvarchar`. Maximum: 1000. Values of `Contract Status` must match those stored in the `ContractStatus` table of the compliance database.
`Contract Type`	Type: `nvarchar`. Maximum: 1000. Values of `Contract Type` must match those stored in the `ContractType` table of the compliance database.
`Corporate Unit ID`	Type: `varchar`. Maximum: 128. Stores the `businessunitID` as a foreign key to the `CorporateUnit` table in the compliance database.
`Cost Center ID`	Type: `varchar`. Maximum: 128. Stores the `costcenterID` as a foreign key to the `costcenter` table in the compliance database.
`Evergreen`	Type: `bit`. Maps to `Contract.NeverExpires` in the compliance database.
`Expiry Date`	Type: `datetime`. Maps to `Contract.EndDate` in the compliance database.
`Global Amount`	Type: `money`. Maps to `Contract.TotalValue` in the compliance database.
`Global Amount Currency Rate ID`	Type: `int`. Stores the `TotalValueRateID` as a foreign key to the `currencyrate` table in the compliance database.
`Last Renewed Date`	Type: `datetime`. Maps to `Contract.LastRenewedDate` in the compliance database.
`Location ID`	Type: `varchar`. Maximum: 128. Stores the `locationID` as a foreign key to the `location` table in the compliance database.
`Master Contract ID`	Type: `int`. Stores the `MasterContractID` as a foreign key to the `Contract` table in the compliance database.
`Monthly Amount`	Type: `money`. Maps to `Contract.MonthlyValue` in the compliance database.
`Monthly Amount Currency Rate ID`	Type: `int`. Stores the `MonthlyValueRateID` as a foreign key to the `currencyrate` table in the compliance database.
`Next Renewal Date`	Type: `datetime`. Maps to `Contract.RenewalDate` in the compliance database.
`Previous Contract ID`	Type: `int`. Stores the `PreviousContractID` as a foreign key to the `Contract` table in the compliance database.
`Review Date`	Type: `datetime`. Maps to `Contract.PreExpiryDate` in the compliance database.
`Start Date`	Type: `datetime`. Maps to `Contract.StartDate` in the compliance database.
`Vendor ID`	Type: `int`. Stores the `VendorID` as a foreign key to the `Vendor` table in the compliance database.

Data model version 13.2

FlexNet Manager Suite (On-Premises)

2023 R1