This data object is used to return all notes payable notes that have been setup in the Fusion business system.

This information can be found in the Notes Payable application within Fusion.

URL

/frw/NotesPayable

Field Details…

SQL Field Name Column Description
AddDate This field displays the date on which the note was added.
AddUser This field displays the user name that added the record.
BalloonAmount This field displays the balloon amount of a note.
BalloonMethod This field displays whether or not a balloon payment is the final payment or a separate payment.
Branch This field displays the branch code associated with the given note.
BranchName This field displays the name of the branch associated with the given note.
DaysinYear This field displays the Days in Year speficied for the note.  Potential values are 360 or Calendar.
Description This field displays the description of a given note.
FirstPaymentDate This field displays the date on which the first payment is due for the given note.
BillingRateFrequency This field displays how often a note is billed.
Inactive This field displays whether or not a given Note is set to inactive.
InterestRate This field displays the interest rate associated with a note.
LastPayment This field displays the amount of last payment for a note.
LastPaymentDate This field displays the date on which the last payment was made for the given note.
LastUpdate This field displays the date on which the note was last updated.
UpdateUser This field displays the user name of the individual who made the last update to the note.
Lender This field displays the lendor assigned to the given note.
MaturityDate This field displays the maturity date assigned to the given note.
NextPaymentDate This field displays the date on which the next payment is due for the given note.
NoteDate This field displays the date on which the note was issued.
NoteNumber This field displays the note number of the given note.
NoteType This  field displays the given notes type (Fixed, Fixed Principle, Variable).
NotesPayableGroup This field displays the notes payable group attached to the given note.  The group assigned to the note determines the accounting when payments are posted.
PaidInterest This field displays the total amount of interest paid on a note.
PaidOff This field displays whether or not the given note is paid off.
PaidPrincipal This field displays the value paid for principal on a note.
Payment This field displays the amount to be paid each payment for the given note.
PaymentsMade This field displays the number of payments made on a note.
TotalInterest This field displays the total amount of interest to be paid on a note.
TotalPayments This field displays the number of payments to be made on a note.
TotalPrincipal This field displays the total principal amount to be paid on a note.


Accounting Notes Payable Detail


This data object is used to return unit and control number detail attached to a note.

This is found within the Notes Payable program within the Fusion business system.

URL

/frw/NotesPayableDetail

Field Details…

SQL Field Name Column Description
AddDate This field displays the date the note detail item was added.
AddUser This field displays the user who added the note detail item.
AllocationAmount This field displays the allocation amount of the note detail item.
AllocationPercentage This field displays the allocation percentage of the note detail item.
CONTROL This field displays the control number of the note detail item. Note, if the Unit number is filled in, then this field will be blank.
Description This field displays the description of the note associated with the detail item.
LastPaymentDate This field displays the date on which the given note detail item was last paid.
LastUpdate This field displays the date the given record was last updated.
UpdateUser This field displays the user who last updated the note detail item.
LocationBranch This field displays the branch the given note detail item is located.
Make This field displays the Unit’s make.
Model This field displays the Unit’s model.
NoteNumber This field displays the note number of the detail item.
NoteType This field displays the note type of the detail item.
OverrideNotesPayableGroup This field displays the override notes payable group if any, associated with the note detail item.
PaidInterest This field displays the amount of interest that has been applied to the given note detail item.
PaidOff This field displays whether or not the given note detail item has been paid off.
PaidPrincipal This field displays the amount of principal that has been applied to the given note detail item.
PaymentsMade This field displays the number of payments that have been applied to the given note detail item.
UnitNumber This field displays the Unit number of the note detail item.