Loans
Provides a listing of loans set up in the Loan Management System.
| Field Name |
Description |
Loan number ![]() |
Specifies the number for a Loan. ![]() |
| Type |
Specifies the Loan type code |
| Customer |
Specifies a Customer id for a receivable Loan. |
| Vendor |
Specifies a Vendor id for a payable Loan. |
| Name |
Specifies the name of the borrower or lender associated with the Loan. |
| Status |
Specifies the status of the Loan (e.g., Active, Pending, etc.) |
| Relation |
Specifies the relation with the Loan or existing Loan. |
| Created by |
Specifies the user who created the Loan. |
| Created date and time |
Specifies the date and time the loan was created. |
Loan Interest
| Field Name |
Description |
Beginning date ![]() |
Specifies the date the Loan started. ![]() |
| Ending date |
Specifies the date the loan ends. |
| Int type day count |
Specifies the number of days used to calculate interest. Options: |
|
Term |
|
Daily - 360 |
|
Daily - 365 |
|
Term - Daily |
| Payment frequency |
Specifies how often the loan payment will be due. Options: |
|
Monthly |
|
Semi-monthly |
|
Quarterly |
|
Yearly |
|
Weekly |
|
Bi-weekly |
|
none |
| Terms to maturity |
Specifies the number of payments based on the frequency type. |
| Credit type |
Specifies how the loan repayment will be distributed. Options: |
|
Normal |
|
Actual payment |
|
Add-on |
|
Addon - with payoff |
|
Custom |
|
End of Term |
|
Fixed principal repayment |
|
Normal - no early payoff |
|
Flat rate |
|
Add on - special |
| Term type |
Specifies how the loan amortization schedule will be generated and how interest will be calculated. Options: |
|
Normal |
|
Grade |
|
Interest only |
|
Add Int to First Pmt |
|
Add interest to Loan |
| Due day (o for EOM) |
Specifies what day of the month the loan payment is due in the due month. Defaults to loan type setup. May be changed. If the loan payment is due at the end of the month, enter zero (0). The due day can vary based on the payment frequency. |
| First payment due date |
Specifies the date the first payment is due. System populated based on payment frequency and due day; can be changed. |
Loan amortization schedule
Open the Loan payment schedule for the loan.
- Turn on Manual - options are Yes or No.
Amortization schedule tab
| Field Name |
Description |
Pmt Nbr![]() |
Specifies the number assigned by the system, for the payment, based on total terms for the loan.![]() |
| Due date |
Specifies the date the payment is due. |
| Beg loan amount |
Amount in monetary standard (national currency). |
| Principal Issued |
Specifies the principal amount of the original loan. |
| Interest |
Specifies the amount of interest that is to be repaid for the payment due date. |
| Principal |
Specifies the amount of the original issue that is to be repaid for the payment due date. |
| Paid add principal |
Specifies an amount paid in addition to the scheduled payment, that has been applied directly to the principal owed. |
| End loan amount |
Amount in monetary standard (national currency). |
| Unpaid Principal |
Specifies the amount of principal which remains due after a payment has been posted for the payment date. |
| Unpaid Interest |
Specifies the amount of interest which remains due after a payment has been posted for the payment date. |
| Unpaid Late Interest |
Specifies the amount of interest, calculated on the principal, the remains due after a payment has been posted for the payment date. |
| Unpaid Late Int on Int |
Specifies the amount of late interest, calculated o interest, which remains due after a payment has been posted for the payment date. |
| Unpaid Charges |
Specifies the amount of charges which remains due after a payment has been posted for the payment date. |
| Unpaid Int on Charges |
Specifies the amount of interest on charges which remains due after a payment has been posted for the payment date. |
| Unpaid Late Fee |
Specifies the amount of late fees which remains due after a payment has been posted for the payment date. |
Actual schedule tab
| Field Name |
Description |
Paid date![]() |
Specifies the date the payment was made.![]() |
| Prin Beg Amt |
Specifies the loan amount, principal only, as of the paid date. |
| Prin End Amt |
Specifies the loan amount, principal only, after principal paid has been deducted. |
| Paid add principal |
Specifies an amount paid in addition to the scheduled payment, that has been applied directly to the principal owed. |
| Prin Paid Reg TD |
Specifies the amount of principal paid based on the transaction date. |
| Prin WO |
Specifies the amount of principal that has been adjusted on the loan. This amount will not be paid. |
| Prin Issued |
Specifies the amount of the loan given, to the borrower, or by the lender. |
| Prin Capitalized |
Specifies an amount of interest previous capitalized and added to the balance of the loan. |
| Interest |
Specifies the amount of interest that was paid on the payment date. |
| Interest WO |
Specifies the amount of interest that has been adjusted on the loan. This amount will not be paid. |
| Interest Capitalized |
Specifies an amount of interest that is capitalized. |
| Late Fee Paid |
Specifies the amount paid for fees/charges/assessments/expenses added to the loan due to a payment not being made on time. |
| Late Fee WO |
Specifies the amount of late fees/charges/assessments/expenses that has been adjusted on the loan. This amount will not be paid. |
| Late int on int paid |
Specifies the amount being paid for interest that has been calculated on a late interest payment. |
| Late Int on Int WO |
Specifies the amount of late interest that has been adjusted on the loan. This amount will not be paid. |
| Escrow Paid |
Specifies the amount of paid escrow. |
| Escrow WO |
Specifies the amount of escrow that has been adjusted on the loan. This amount will not be paid. |
| Charges paid |
Specifies the amount paid for fees/charges/assessments/expenses on the loan. |
| Charges WO |
Specifies the amount that has been adjusted for fees/charges/assessments/expenses on the loan. This amount will not be paid. |
| Int on Charges WO |
Specifies the amount being paid for interest on fees/charges/assessments/expenses on the loan. |
| Fee paid |
Specifies the amount paid for fees/charges/assessments/expenses on the loan that are not principal or interest. |
| Fee WO |
Specifies the amount that has been adjusted for fees/charges/assessments/expenses on the loan. This amount will not be paid. |
| Pen Int Paid |
Specifies the amount paid for interest that was charged on fees/charges/assessments/expenses on the loan. |
| Pen Int WO |
Specifies the amount of fees/charges/assessments/expenses interest that has been adjusted on the loan. This amount will not be paid. |
| Total |
Specifies the sum of all amounts on the line. |
Owed Schedule tab
| Field Name |
Description |
Pmt Nbr ![]() |
Specifies the number assigned by the system, for the payment, based on total terms for the loan.![]() |
| Due date |
Specifies the date the payment was made. |
| Principal |
Specifies the loan amount, principal only, after principal paid has been deducted. |
| Fee |
Amount in monetary standard (national currency). |
| Late Fee |
Amount in monetary standard (national currency). |
| Penalty Interest |
Amount in monetary standard (national currency). |
| Interest |
Amount in monetary standard (national currency). |
| Late Interest |
Amount in monetary standard (national currency). |
| Escrow |
Amount in monetary standard (national currency). |
| Charges |
Amount in monetary standard (national currency). |
| Int on Int |
Amount in monetary standard (national currency). |
| Owed total |
Amount in monetary standard (national currency). |
Loan transactions
Displays all transactions for the loan by date with Payment type, Amount, Description, and batch number.
| Field Name |
Description |
Transaction date ![]() |
Specifies the date of the transaction shown.![]() |
| Payment type |
Specifies the payment type of the transaction shown. |
| Transaction amount |
Specifies the transaction amount of the transaction shown. |
| Transaction description |
Specifies the transaction description of the transaction shown. |
| Batch number |
Specifies the batch number for the transaction shown. |
Totals
Displays totals for all types of transactions for the loan by Payment Type for Month Date, Year to Date, Last Year, Life to Date, Date of Last Transaction, and Amount of Last Transaction.
| Field Name |
Description |
Transaction description ![]() |
Specifies the description of the transaction shown.![]() |
| Month to date amount |
Specifies the total activity for the current month for this transaction type. |
| Year to date amount |
Specifies the total activity for the current calendar year through today for this transaction type. |
| Last year total |
Specifies the total activity for the last calendar year for this transaction type. |
| Life to date |
Specifies the total activity for the life of the loan through today for this transaction type. |
| Date of last trans |
Specifies the date of the last entry for this transaction type. |
| Amount of last trans |
Specifies the amount of the last entry for this transaction type. |
Ownership
Displays the owners of loans and their percentage of ownership.
| Field Name |
Description |
Loan ![]() |
Specifies the loan for which ownership is being displayed.![]() |
| Lender/Borrower |
Specifies the lender or borrower for this loan. |
| Owner code |
Specifies an owner of the loan who has a financial share in the proceeds. |
| % Ownership |
Specifies the percent of ownership of the loan this owner has for their share. The total ownership for all owners must be 100%. |
Post to AP
Posts the transaction to the Accounts Payable. Loan must be in an ACTIVE status for posting to AP.
Payment
Loan payments
| Field Name |
Description |
Loan number ![]() |
Specifies the number for a loan.![]() |
| Type |
Specifies the loan type code. |
| Customer |
Specifies a customer ID for a receivable loan. |
| Vendor |
Specifies a vendor ID for a payable loan. |
| Name |
Specifies the name of the borrower or lender associated with the loan. |
| Status |
Specifies the status of the loan. |
| Relation |
Specifies the relation of the loan or existing loan. |
| Created By |
Specifies the User ID that created the record. |
| Created date and time |
Specifies the date and time the record was created. |
| Modified by |
Specifies the User ID that last modified the record. |
| Modified date and time |
Specifies the date and time the record was last modified. |