SalaryMandate
Documentation for the SalaryMandate database schema.
Fields
| Field | Data Type | Usage |
|---|---|---|
| salaryProcessIds | ObjectId | Unique reference to salary Processs. |
| companyId | ObjectId | Unique reference to company. |
| companyName | String | The name or title of the salarymandate. |
| processType | String | Stores the process type data. |
| isVoucher | Boolean | Stores the is voucher data. |
| month | String | Stores the month data. |
| year | String | Stores the year data. |
| mandateData | ObjectId | Timestamp/Date for mandateData. |
| debitAccountNo | ObjectId | Stores the debit account no data. |
| beneficiaryName | ObjectId | The name or title of the salarymandate. |
| beneficiaryAccountNo | ObjectId | Stores the beneficiary account no data. |
| ifscCode | ObjectId | Stores the ifsc code data. |
| amount | ObjectId | Monetary or numeric value. |
| remarks | ObjectId | Detailed notes or remarks. |
| empCode | ObjectId | Stores the emp code data. |
| unitCode | ObjectId | Stores the unit code data. |
| unitName | ObjectId | The name or title of the salarymandate. |
| clientName | ObjectId | The name or title of the salarymandate. |
| branchName | ObjectId | The name or title of the salarymandate. |
| bankName | ObjectId | The name or title of the salarymandate. |
| processingDate | ObjectId | Timestamp/Date for processingDate. |
| salaryProcessId | ObjectId | Unique reference to salary Process. |
| totalAmount | Number | Monetary or numeric value. |
| totalRecords | Number | Stores the total records data. |
| bankWiseData | ObjectId | Timestamp/Date for bankWiseData. |
| records | ObjectId | Stores the records data. |
| processGroups | ObjectId | Stores the process groups data. |
| groupId | ObjectId | Unique reference to group. |
| processName | ObjectId | The name or title of the salarymandate. |
| recordCount | Boolean | Stores the record count data. |
| emailSent | Boolean | Primary email address. |
| emailSentDate | String | Primary email address. |
| emailRecipient | String | Primary email address. |
| emailSubject | String | Primary email address. |
| emailTransactionType | String | Primary email address. |
| filesGenerated | Boolean | Timestamp/Date for filesGenerated. |
| excel | Boolean | Stores the excel data. |
| mandatePDF | Boolean | Timestamp/Date for mandatePDF. |
| employeePDF | Boolean | Stores the employee p d f data. |
| summaryExcel | Boolean | Stores the summary excel data. |
| transferred | Boolean | Stores the transferred data. |
| transferDate | Date | Timestamp/Date for transferDate. |
| transferRemarks | String | Detailed notes or remarks. |
| status | String | Timestamp/Date for status. |
| createdBy | ObjectId | Timestamp/Date for createdBy. |
| updatedBy | ObjectId | Timestamp/Date for updatedBy. |
| isDeleted | Boolean | Stores the is deleted data. |
| deletedBy | ObjectId | Stores the deleted by data. |
| deletedTime | Date | Timestamp/Date for deletedTime. |