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

2021 R1