The Payment Schedule Detail Object

This item maps to the PaymentScheduleDetail 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 Detail appears in the Payment Schedule group in the right-click context menu.

Properties

The Payment Schedule Detail 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 Detail` object (alphabetical listing)
Property	Details
`Actual/Fixed Amount`	Type: `money`. Maps to `PaymentScheduleDetail.ActualAmount` in the compliance database.
`Actual/Fixed Amount Currency Rate ID`	Type: `int`. Stores the `ActualAmountRateID` as a foreign key to the `currencyrate` table in the compliance database.
`Budgeted Amount`	Type: `money`. Maps to `PaymentScheduleDetail.BudgetedAmount` in the compliance database.
`Budgeted Amount Currency Rate ID`	Type: `int`. Stores the `BudgetedAmountRateID` as a foreign key to the `currencyrate` table in the compliance database.
`Estimated Amount`	Type: `money`. Maps to `PaymentScheduleDetail.EstimatedAmount` in the compliance database.
`Estimated Amount Currency Rate ID`	Type: `int`. Stores the `EstimatedAmountRateID` as a foreign key to the `currencyrate` table in the compliance database.
`Installment Covered`	Type: `nvarchar`. Maximum: 50. Maps to `PaymentScheduleDetail.PeriodCovered` in the compliance database.
`Installment End Date`	Type: `datetime`. Mandatory: adapters must provide values for this column. Maps to `PaymentScheduleDetail.PeriodEndDate` in the compliance database.
`Installment Start Date`	Type: `datetime`. Mandatory: adapters must provide values for this column. Maps to `PaymentScheduleDetail.PeriodStartDate` in the compliance database. It is used (perhaps in conjunction with other properties) as a key for matching existing records there.
`Installment Status`	Type: `int`. Values of `Installment Status` must match those stored in the `PaymentScheduledetailPaymentStatus` table of the compliance database.
`Notes`	Type: `ntext`. Maps to `PaymentScheduleDetail.Notes` in the compliance database.
`Obligated to Pay`	Type: `bit`. Maps to `PaymentScheduleDetail.Obligated` in the compliance database.
`Payment Date`	Type: `datetime`. Maps to `PaymentScheduleDetail.PaymentDate` in the compliance database.
`Payment Schedule ID`	Type: `int`. Mandatory: adapters must provide values for this column. Stores the `PaymentScheduleID` as a foreign key to the `PaymentSchedule` table in the compliance database. It is used (perhaps in conjunction with other properties) as a key for matching existing records there.
`Quantity`	Type: `int`. Maps to `PaymentScheduleDetail.Quantity` in the compliance database.
`Software Assurance Unit Price`	Type: `money`. Maps to `PaymentScheduleDetail.SoftwareAssuranceUnitPrice` in the compliance database.
`Software Assurance Unit Price Rate ID`	Type: `int`. Stores the `SoftwareAssuranceUnitPriceRateID` as a foreign key to the `currencyrate` table in the compliance database.
`Unit Price`	Type: `money`. Maps to `PaymentScheduleDetail.UnitPrice` in the compliance database.
`Unit Price Currency Rate ID`	Type: `int`. Stores the `UnitPriceRateID` as a foreign key to the `currencyrate` table in the compliance database.

Data model version 13.2

FlexNet Manager Suite (On-Premises)

2023 R1