SalaryEmployeeArrearDetailsMaster
Documentation for the SalaryEmployeeArrearDetailsMaster database schema.
Fields
| Field | Data Type | Usage |
|---|---|---|
| ilId | String | Unique reference to il. |
| arrearId | ObjectId | Unique reference to arrear. |
| monthId | ObjectId | Unique reference to month. |
| yearId | ObjectId | Unique reference to year. |
| financialYearId | ObjectId | Unique reference to financial Year. |
| providentFundGross | Decimal128 | Unique reference to provident Fund Gross. |
| providentFund | Decimal128 | Unique reference to provident Fund. |
| voluntaryProvidentFund | Decimal128 | Unique reference to voluntary Provident Fund. |
| account1 | Decimal128 | Stores the account1 data. |
| account10 | Decimal128 | Stores the account10 data. |
| account2 | Decimal128 | Stores the account2 data. |
| account21 | Decimal128 | Stores the account21 data. |
| account22 | Decimal128 | Stores the account22 data. |
| esiGross | Decimal128 | Stores the esi gross data. |
| esi | Decimal128 | Stores the esi data. |
| esiEmployer | Decimal128 | Stores the esi employer data. |
| earningGross | Decimal128 | Stores the earning gross data. |
| deductionGross | Decimal128 | Stores the deduction gross data. |
| totalEarnings | Decimal128 | Stores the total earnings data. |
| totalDeductions | Decimal128 | Stores the total deductions data. |
| netPay | Decimal128 | Stores the net pay data. |
| numberOfDays | Decimal128 | Stores the number of days data. |
| salaryProcessed | Boolean | Stores the salary processed data. |
| remarks | String | Detailed notes or remarks. |
| insertedUserId | ObjectId | Unique reference to inserted User. |
| updatedUserId | ObjectId | Unique reference to updated User. |
| insertedDateId | ObjectId | Unique reference to inserted Date. |
| updatedDateId | ObjectId | Unique reference to updated Date. |