Database
Payroll
Transactions
Loan
LoanInstallment

LoanInstallment

Documentation for the LoanInstallment database schema.

Fields

FieldData TypeUsage
companyIdObjectIdUnique reference to company.
loanIdObjectIdUnique reference to loan.
employeeIdObjectIdUnique reference to employee.
attendanceIdObjectIdUnique reference to attendance.
monthNumberStores the month data.
yearNumberStores the year data.
installmentNumberNumberStores the installment number data.
deductionAmountNumberMonetary or numeric value.
balanceAfterPaymentNumberStores the balance after payment data.
statusStringTimestamp/Date for status.
remarksStringDetailed notes or remarks.
isActiveBooleanActive status flag.
isDeletedBooleanStores the is deleted data.
deletedByObjectIdStores the deleted by data.
deletedTimeDateTimestamp/Date for deletedTime.