SalSalaryMaster
Documentation for the SalSalaryMaster database schema.
Fields
| Field | Data Type | Usage |
|---|---|---|
| companyId | ObjectId | Unique reference to company. |
| salaryId | String | Unique reference to salary. |
| salaryCode | String | Stores the salary code data. |
| date | Date | Timestamp/Date for date. |
| monthId | ObjectId | Unique reference to month. |
| yearId | ObjectId | Unique reference to year. |
| financialYearId | ObjectId | Unique reference to financial Year. |
| employeeId | ObjectId | Unique reference to employee. |
| locationId | ObjectId | Unique reference to location. |
| departmentId | ObjectId | Unique reference to department. |
| designationId | ObjectId | Unique reference to designation. |
| natureId | ObjectId | Unique reference to nature. |
| costOfCompany | Decimal128 | Stores the cost of company data. |
| grossTotal | Decimal128 | Stores the gross total data. |
| netPay | Decimal128 | Stores the net pay data. |
| stopSalary | Boolean | Stores the stop salary data. |
| accountTransaction | Boolean | Stores the account transaction data. |
| remarks | String | Detailed notes or remarks. |
| createdUserId | ObjectId | Unique reference to created User. |
| updatedUserId | ObjectId | Unique reference to updated User. |
| createdDateId | Date | Unique reference to created Date. |
| updatedDateId | Date | Unique reference to updated Date. |