SalSalaryPfEsiMonthlyDetails
Documentation for the SalSalaryPfEsiMonthlyDetails database schema.
Fields
| Field | Data Type | Usage |
|---|---|---|
| transactionId | String | Unique reference to transaction. |
| employeeId | ObjectId | Unique reference to employee. |
| monthId | ObjectId | Unique reference to month. |
| yearId | ObjectId | Unique reference to year. |
| transactionDate | Date | Timestamp/Date for transactionDate. |
| 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. |
| esiGross | Decimal128 | Stores the esi gross data. |
| esi | Decimal128 | Stores the esi data. |
| esiEmployerContribution | Decimal128 | Stores the esi employer contribution data. |
| updatedDateId | ObjectId | Unique reference to updated Date. |