PaymentSchedule Table

FlexNet Manager Suite 2020 R1 (On-Premises)

PaymentSchedule contains details of the payment schedules managed by FlexNet Manager Suite.

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

Database Column

Details

PaymentScheduleID

Type: integer. Key. Generated ID

A unique identifier for a payment schedule.

ContractID

Type: integer. Key

Identifies a contract to which this payment schedule applies. Foreign key to the Contract table.

PaymentScheduleTypeID

Type: integer

Identifies the type of this payment schedule. Foreign key to the PaymentScheduleType table.

PaymentScheduleTermID

Type: integer

Identifies the term of payment for this payment schedule. Foreign key to the PaymentScheduleTerm table.

PaymentScheduleCategoryID

Type: integer

Identifies the category of this payment schedule. Foreign key to the PaymentScheduleCategory table.

Description

Type: text (max 100 characters)

Name of this payment schedule.

StartDate

Type: datetime

The date on which this payment schedule starts.

EndDate

Type: datetime. Nullable

The date on which this payment schedule ends.

PeriodTypeID

Type: integer

Identifies the period type of this payment schedule. Foreign key to the PeriodType table.

IncludeNewAssetsAnd Licenses

Type: boolean

If this field is set to True, then when a new asset or license is linked to the contract associated with this payment schedule, the item will also be linked to this payment schedule. If False, new items linked to the related contract are not automatically linked to the payment schedule (although a manual link can still be made).

LeaseTerminationDate

Type: datetime. Nullable

The termination date of this payment schedule’s lease. Only applicable if the payment schedule type is Lease.

LeaseTerminationReason

Type: text (max 100 characters). Nullable

The reason this payment schedule’s lease was terminated. Only applicable if the payment schedule type is Lease.

LeaseNumber

Type: text (max 150 characters). Nullable

The number of this payment schedule’s lease. Only applicable if the payment schedule type is Lease.

BuyoutCost

Type: currency. Nullable

The buyout cost for this payment schedule’s lease. Only applicable if the payment schedule type is Lease.

BuyoutCostRateID

Type: integer. Nullable

Identifies the currency rate to be applied to this payment schedule’s lease buyout cost. Only applicable if the payment schedule type is Lease. Foreign key to the CurrencyRate table.

PreviousPurchases

Type: integer. Nullable

In the case of a Microsoft Enterprise Agreement renewal, the number of desktops covered by the associated platform license at the end of the previous Microsoft EA.

Comment

Type: text. Nullable

Operator’s comments about this payment schedule.

CreationUser

Type: text (max 128 characters). Nullable

The operator who created the record.

CreationDate

Type: datetime

The date the payment schedule was created.

UpdatedUser

Type: text (max 128 characters). Nullable

The operator to make the last change to this record.

UpdatedDate

Type: datetime

The date the last change was made to this payment schedule record.

FlexNet Manager Suite (On-Premises)

2020 R1