PunchPendingReport
Documentation for the PunchPendingReport database schema.
Fields
| Field | Data Type | Usage |
|---|---|---|
| companyId | ObjectId | Unique reference to company. |
| branchId | ObjectId | Unique reference to branch. |
| month | Number | Stores the month data. |
| min | Number | Stores the min data. |
| max | Number | Stores the max data. |
| year | Number | Stores the year data. |
| unitId | ObjectId | Unique reference to unit. |
| unitCode | String | Stores the unit code data. |
| unitName | String | The name or title of the punchpendingreport. |
| clientName | String | The name or title of the punchpendingreport. |
| navisionCode | String | Stores the navision code data. |
| openDate | Date | Timestamp/Date for openDate. |
| closeDate | Date | Timestamp/Date for closeDate. |
| branchName | String | The name or title of the punchpendingreport. |
| state | String | Timestamp/Date for state. |
| region | String | Stores the region data. |
| company | String | Stores the company data. |
| status | String | Timestamp/Date for status. |
| prevMonthTotalEmployees | Number | Stores the prev month total employees data. |
| currMonthPunched | Number | Stores the curr month punched data. |
| remainingEmployees | Number | Stores the remaining employees data. |
| calculatedAt | Date | Timestamp/Date for calculatedAt. |
| createdBy | ObjectId | Timestamp/Date for createdBy. |
| updatedBy | ObjectId | Timestamp/Date for updatedBy. |