PaymentSchedule Table
PaymentSchedule
contains details of the payment schedules managed by FlexNet Manager Suite.
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.
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 |
PaymentScheduleTypeID
|
Type: integer Identifies the type of this payment schedule. Foreign key to the |
PaymentScheduleTermID
|
Type: integer Identifies the term of payment for this payment schedule. Foreign key to the |
PaymentScheduleCategoryID
|
Type: integer Identifies the category of this payment schedule. Foreign key to the |
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 |
IncludeNewAssetsAnd Licenses
|
Type: boolean If this field is set to |
LeaseTerminationDate
|
Type: datetime. Nullable The termination date of this payment schedule’s lease. Only applicable if the payment
schedule type is |
LeaseTerminationReason
|
Type: text (max 100 characters). Nullable The reason this payment schedule’s lease was terminated. Only applicable if the payment schedule type is |
LeaseNumber
|
Type: text (max 150 characters). Nullable The number of this payment schedule’s lease. Only applicable if the payment schedule type is |
BuyoutCost
|
Type: currency. Nullable The buyout cost for this payment schedule’s lease. Only applicable if the payment schedule type is |
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 |
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. |