Loan/Advance Register

Borrower

Overview

This entity stores the distinct type of borrowers for a better classification.

Navigation

General Ledger ► Sub Ledgers ► Loan/Advance Register ► Borrower

Borrower Screen Fields

Fields

Description

Code

Unique identifier. System generated.

Is On Freebalance Payroll

False (Default)

Borrower Type

Classification of the borrower according type.

Workflow Status

Workflow status of the Borrower

Associated Institution

Institution of the Associated borrower

Borrower Status

It's a read-only field that will be manipulated through the workflow.

 

Generic Borrower

Overview

This entity will store information for those persons outside FB Payroll that could be applicable to obtain a Loan.

Navigation

General Ledger ► Sub Ledgers ► Loan/Advance Register ► Generic Borrower

Generic Borrower Screen Fields

Fields

Description

Code

Unique identifier. System generated.

First Name

First name of the borrower

Last Name

Last name of the borrower

Employee Code

Employee code of the generic borrower.

Personal Identification Number

Unique person Identifier

Date Of Birth

Generic borrower date of birth.

Place Of Birth

Generic borrower Place of Birth

Gender

Generic borrower Gender

Associated Institution Code

Institution code associated with Generic borrower

Designation

Designation of the borrower

Vacated Date

Vacated date of the borrower

 

Loan

Overview

This feature stores the general header information related to Loans.

Navigation

General Ledger ► Sub Ledgers ► Loan/Advance Register ► Loan

Loan Screen Fields

FieldsDescription
CodeManual or automatically generated, depending on paramater configuration, unique identifier.
Workflow StatusThe workflow process status of the Loan, automatically generated and updated.
Loan TypeReference to Loan Type, in order to classify the entered loans. Drop down list to select loan type.
BorrowerThe employee or entity acting as the borrower, look up functionality is available to select borrower.
LanguageAllows to select country specific language to apply for Purpose attribute.
PurposePurpose, terms and references of the current loan.
Annual Interest RateInterest rate applicable on the current loan.
Total Principal AmountThe total principal amount of the current loan.
Start DateStart date of loan.
Number of RepaymentsQuantity of repayments to cancel the loan.
Expected End DateEnd date of loan. Calculated by the system, this is a read-only field.
Special ConditionsSpecial conditions of the current loan.
Outstanding BalanceOutstanding balance of the loan, not editable. Calculated and updated from transactions of the loan. Initial value = 0
Total Principal Paid AmountTotal principal amount paid.  Visible, not editable. Calculated and updated from transactions of the loan. Initial value = 0
Total Interest Paid AmountTotal interest paid amount. Visible, not editable. Calculated and updated from transactions of the loan. Initial value = 0
Type of Scheduled Repayment CalculationUsed to validate the type of the calculation method for the payment schedule.  Read-only, not editable field, value is taken from Loan type.
Created ByRead-only field, filled with logged in user automatically by the system
Creation DateRead-only. System date, automatically filled in the system.
Approved ByRead-only. Automatically filled by the system with user that approves record.
Approval DateRead-only field displays ystem date of approval of the record.
Principal Account Principal Account of the Loan Type.
Interest AccountInterest Account of the Loan Type.
Others AccountOthers Account of the Loan Type
Transaction ScheduleThis contains the transactions schedule for the current loan.  It is automatically generated and updated by the system.

 

Loan Type

Overview

This entity stores the distinct type of Loans.

Navigation

General Ledger ► Sub Ledgers ► Loan/Advance Register ► Loan Type

Loan Type Screen Fields

Fields

Description

Code

Unique identifier.

Active

Indicates if the loan type is “active” for registry of cases True = Active, False = Inactive.

Is Default Loan Type?

Indicates if the case type is the default type when creating a new instrument type entry.

Number Of Repayments

The total number of repayments for the actual type of loan

Deduction

Related deduction code for those employees on the payroll.

Calculation Method

Equal instalment  (Default)

Language

Country specific language

Name

Abbreviation of the loan type name.

Description

Full description of the loan type.

Principal Account

System will list the sub-ledgers with status Active = True and of type = 'Loan Register'.

Interest Account

System will list the sub-ledgers with status Active = True and of type = 'Loan Register'.

Others Account

System will list the sub-ledgers with status Active = True and of type = 'Loan Register'.