SalariesEmployeePayrollStatements
Generated schema file.
Columns
| Name | Type | References | |
| TargetDate | Date | ||
| Id [KEY] | Integer | ||
| CompanyId | Integer | ||
| EmployeeId | Integer | ||
| EmployeeName | String | ||
| EmployeeDisplayName | String | ||
| EmployeeNum | String | ||
| PayDate | Datetime | ||
| StartDate | Datetime | ||
| ClosingDate | Datetime | ||
| VariablePayStartDate | String | ||
| VariablePayClosingDate | String | ||
| Fixed | Boolean | ||
| CalcStatus | String | ||
| CalculatedAt | Datetime | ||
| PayCalcType | String | ||
| BasicPayAmount | String | ||
| WorkDays | String | ||
| NormalWorkTime | String | ||
| NormalWorkDays | String | ||
| WorkMinsByPaidHoliday | String | ||
| NumPaidHolidays | String | ||
| IsBoardMember | Boolean | ||
| TotalAttendanceDeductionAmount | String | ||
| TotalAllowanceAmount | String | ||
| TotalDeductionAmount | String | ||
| NetPaymentAmount | String | ||
| GrossPaymentAmount | String | ||
| TotalWorkedDaysCount | String | ||
| TotalTaxablePaymentAmount | String | ||
| TotalExpenseAmount | String | ||
| TotalTransferAmount | String | ||
| TotalAnnualPaymentAmount | String | ||
| Payments | String | ||
| Deductions | String | ||
| Attendances | String | ||
| OvertimePays | String | ||
| Remark | String |