SpecialLoanMaster
Documentation for the SpecialLoanMaster database schema.
Fields
| Field | Data Type | Usage |
|---|---|---|
| companyId | ObjectId | Unique reference to company. |
| unitId | ObjectId | Unique reference to unit. |
| designationId | ObjectId | Unique reference to designation. |
| loanCode | String | Stores the loan code data. |
| headId | ObjectId | Unique reference to head. |
| orderNumber | String | Stores the order number data. |
| allotmentDate | Date | Timestamp/Date for allotmentDate. |
| loanType | String | Stores the loan type data. |
| loanAmount | Number | Monetary or numeric value. |
| balanceAmount | Number | Monetary or numeric value. |
| numberOfInstallments | Number | Stores the number of installments data. |
| installmentAmount | Number | Monetary or numeric value. |
| remainingInstallments | Number | Stores the remaining installments data. |
| date | Date | Timestamp/Date for date. |
| effectiveDate | Date | Timestamp/Date for effectiveDate. |
| 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. |
| insertedBy | ObjectId | Stores the inserted by data. |
| updatedBy | ObjectId | Timestamp/Date for updatedBy. |
| insertedDate | Date | Timestamp/Date for insertedDate. |
| updatedDate | Date | Timestamp/Date for updatedDate. |