The Payment Schedule Object

This item maps to the paymentschedule object in the FlexNet Manager Suite compliance database.

Behavior in the Business Adapter Studio

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

Properties

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

Table 1. Data model properties for Payment Schedule object (alphabetical listing)

Property

Details

Buyout Cost

Type: money.

Maps to paymentschedule.BuyoutCost in the compliance database.

Buyout Cost Currency Rate ID

Type: int.

Stores the BuyoutCostRateID as a foreign key to the currencyrate table in the compliance database.

Contract ID

Type: int. Mandatory: adapters must provide values for this column.

Stores the contractid as a foreign key to the contract table in the compliance database.

It is used (perhaps in conjunction with other properties) as a key for matching existing records there.

End Date

Type: datetime.

Maps to paymentschedule.enddate in the compliance database.

Frequency

Type: nvarchar. Maximum: 1000.

Values of Frequency must match those stored in the PeriodType table of the compliance database.

Lease Number

Type: nvarchar. Maximum: 150.

Maps to paymentschedule.LeaseNumber in the compliance database.

Lease Termination Date

Type: datetime.

Maps to paymentschedule.LeaseTerminationDate in the compliance database.

Lease Termination Reason

Type: nvarchar. Maximum: 100.

Maps to paymentschedule.LeaseTerminationReason in the compliance database.

Link to New Assets and Licenses attached to Contract

Type: bit. Mandatory: adapters must provide values for this column.

Maps to paymentschedule.includenewassetsandlicenses in the compliance database.

Name

Type: nvarchar. Maximum: 100. Mandatory: adapters must provide values for this column.

Maps to paymentschedule.description in the compliance database.

It is used (perhaps in conjunction with other properties) as a key for matching existing records there.

Notes

Type: ntext.

Maps to paymentschedule.Comment in the compliance database.

Payment Schedule Metric

Values of Payment Schedule Metric must match those stored in the PaymentScheduleCategory table of the compliance database.

Payment Schedule Term

Values of Payment Schedule Term must match those stored in the PaymentScheduleTerm table of the compliance database.

Payment Schedule Type

Values of Payment Schedule Type must match those stored in the PaymentScheduleType table of the compliance database.

Start Date

Type: datetime. Mandatory: adapters must provide values for this column.

Maps to paymentschedule.startdate in the compliance database.

Data model version 13.2

2021 R1