ADO.NET Provider for Sage Intacct

Build 26.0.9655

LoanScheduleEntry

Represents individual entries within a loan repayment schedule, capturing the scheduled date, payment breakdown, and pre- and post-payment balances.

Columns

Name Type ReadOnly Description
id String True

The unique identifier of the loan schedule entry record.

interestAmount Decimal False

The portion of the scheduled payment allocated to interest for this entry.

key [KEY] String True

The system-assigned key that uniquely identifies the loan schedule entry record.

loanSchedule_Id String True

The Id of the loan schedule associated with this entry.

loanSchedule_Key String False

The system-assigned key of the loan schedule associated with this entry.

paymentAmount Decimal False

The total payment amount scheduled for this entry.

postPaymentBalance Decimal False

The outstanding loan balance after the payment for this entry is applied.

prePaymentBalance Decimal False

The outstanding loan balance before the payment for this entry is applied.

principalAmount Decimal False

The portion of the scheduled payment allocated to principal for this entry.

scheduleDate Date False

The date on which this scheduled payment is due.

scheduleKey Int True

The system-assigned key of the loan schedule associated with this entry.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9655