SpecialLoanInstallment
Documentation for the SpecialLoanInstallment database schema.
Fields
| Field | Data Type | Usage |
|---|---|---|
| companyId | ObjectId | Unique reference to company. |
| loanId | ObjectId | Unique reference to loan. |
| employeeId | ObjectId | Unique reference to employee. |
| salaryId | ObjectId | Unique reference to salary. |
| unitId | ObjectId | Unique reference to unit. |
| month | Number | Stores the month data. |
| year | Number | Stores the year data. |
| installmentNumber | Number | Stores the installment number data. |
| deductionAmount | Number | Monetary or numeric value. |
| balanceAfterPayment | Number | Stores the balance after payment data. |
| status | String | Timestamp/Date for status. |
| remarks | String | Detailed notes or remarks. |
| isActive | Boolean | Active status flag. |
| isDeleted | Boolean | Stores the is deleted data. |
| deletedBy | ObjectId | Stores the deleted by data. |
| deletedTime | Date | Timestamp/Date for deletedTime. |