SalaryEmployeeMaster
Documentation for the SalaryEmployeeMaster database schema.
Fields
| Field | Data Type | Usage |
|---|---|---|
| mpanyId | ObjectId | Unique reference to mpany. |
| month | String | Stores the month data. |
| voucherVerified | Boolean | Stores the voucher verified data. |
| voucherBranchVerified | Boolean | Stores the voucher branch verified data. |
| voucherBillingVerified | Boolean | Stores the voucher billing verified data. |
| voucherAccountsVerified | Boolean | Stores the voucher accounts verified data. |
| year | String | Stores the year data. |
| employeeId | ObjectId | Unique reference to employee. |
| headId | ObjectId | Unique reference to head. |
| payAmount | Number | Monetary or numeric value. |
| bankId | ObjectId | Unique reference to bank. |
| accountNumber | String | Stores the account number data. |
| unitId | ObjectId | Unique reference to unit. |
| departmentId | ObjectId | Unique reference to department. |
| designationId | ObjectId | Unique reference to designation. |
| remarks | String | Detailed notes or remarks. |
| insertedUserId | ObjectId | Unique reference to inserted User. |
| updatedUserId | ObjectId | Unique reference to updated User. |
| referenceNumber | String | Stores the reference number data. |
| ifscCode | String | Stores the ifsc code data. |
| recalculateHead | Boolean | Timestamp/Date for recalculateHead. |
| voucherType | String | Stores the voucher type data. |
| insertDate | Date | Timestamp/Date for insertDate. |
| financialYearId | ObjectId | Unique reference to financial Year. |
| esiGross | Number | Stores the esi gross data. |
| esi | Number | Stores the esi data. |
| esiEmployer | Number | Stores the esi employer data. |
| pfGross | Number | Stores the pf gross data. |
| pf | Number | Stores the pf data. |
| epf | Number | Stores the epf data. |
| totalDeductions | Number | Stores the total deductions data. |
| netPay | Number | Stores the net pay data. |
| deductionHeadId | ObjectId | Unique reference to deduction Head. |
| transactionDate | Date | Timestamp/Date for transactionDate. |
| mandateAmount | Number | Timestamp/Date for mandateAmount. |
| stopVoucher | Boolean | Stores the stop voucher data. |
| paymentDate | Date | Timestamp/Date for paymentDate. |
| stopVoucherType | String | Stores the stop voucher type data. |
| holdDate | Date | Timestamp/Date for holdDate. |
| holdRemarks | String | Detailed notes or remarks. |
| otherDeductions | Number | Stores the other deductions data. |
| isDeleted | Boolean | Stores the is deleted data. |
| status | Boolean | Timestamp/Date for status. |
| deletedBy | ObjectId | Stores the deleted by data. |
| deletedTime | Date | Timestamp/Date for deletedTime. |