* id employee_id event_type event_time method note terminal_ip terminal_device created_by latitude longitude accuracy created_at photo_path

* id company_id employee_id period_year period_month locked_by locked_at

* id company_id type_key label color sort_order

* id user_id action entity entity_id details ip created_at

* id company_id name condition_type condition_value reward_type reward_value reward_label is_active sort_order created_at

* id company_id token status kind label email contract_type job_title work_place work_place_loc work_address date_from date_to hourly_rate hours_week hours_year payday supervisor department_id calendar_id sign_date data_json submitted_at submitted_ip expires_at employee_id user_id created_by created_at updated_at

* id company_id period_year period_month status closed_by closed_at

* id name ico email pn_prefix pn_digits pn_next created_at logo_path theme capture_photo dic street city zip phone cssz_vs cssz_vs_from cssz_office tax_office tax_office_ws databox bank_account bank_code contact_person contact_email legal_form registry_text representative acting_rule ares_updated_at shift_lock_hours shift_horizon_days

* id company_id name contract_types default_for file_path original_name placeholders_json created_by created_at updated_at

* id company_id action filename xml created_by created_at submitted_at submitted_by note

* id registration_id employee_id start_date rel

* id company_id label field_type sort_order created_at

* id company_id name code created_at

* id user_id department_id calendar_id position contract_type vacation_entitlement pin_hash qr_token created_at photo_path

* id employee_id field_id value

* id company_id report_type period_year period_month reference status file_name payload summary_json created_by created_at submitted_at

* id holiday_date name

* id company_id email role token status invited_by created_at accepted_at

* id company_id period_year period_month kind guid filename xml summary_json created_by created_at submitted_at submitted_by note

* id employee_id type date_from date_to days status reason approved_by created_at

* id company_id employee_id exam_type work_category exam_date valid_until result provider note created_at

* id company_id user_id title body link is_read created_at

* id company_id employee_id item_id assigned_date replace_due size quantity returned_date note created_at

* id company_id name category lifetime_months note created_at

* id user_id token expires_at used created_at

* id company_id employee_id name birth_number birth_date order_no ztpp valid_from valid_to is_active

* id company_id employee_id wage_type base_wage personal_bonus avg_earning meal_allowance birth_number birth_date birth_place birth_surname birth_country education cz_isco is_manager work_mode continuous_op work_place work_municode pension_type pension_from pension_early pension_reduced_age health_restriction health_restriction_from citizenship gender street city zip country health_insurer si_participation hi_participation hi_state_insured tax_declaration credit_taxpayer credit_disability credit_student contract_start contract_end contract_signed weekly_hours payout_method bank_account bank_code note updated_at ik_mpsv id_ppv

* id company_id period_year period_month status calculated_at approved_at approved_by closed_at note created_at

* id rate_year rate_key rate_value label unit rate_group sort_order

* id company_id employee_id kind label amount taxable insurable valid_from valid_to is_active note

* id company_id period_id employee_id worked_minutes planned_minutes overtime_minutes night_minutes weekend_minutes holiday_minutes vacation_days sick_days unpaid_days base_amount overtime_amount night_amount weekend_amount holiday_amount vacation_amount sick_amount personal_amount bonus_amount other_earnings gross_wage si_base hi_base si_employee hi_employee hi_surcharge si_employer hi_employer tax_base tax_advance tax_credits tax_after_credit child_credit tax_final tax_bonus withholding_tax deductions meal_amount net_wage payout employer_cost detail_json created_at updated_at

* id payslip_id section label quantity unit rate amount sort_order

* id company_id name cz_isco created_at

* id setting_key setting_value

* id company_id name start_time end_time color slots weekdays department_id sort_order is_active created_at

* id company_id first_name last_name personal_number email password_hash role is_active created_at deleted_at

* id company_id name work_start work_end hours_mon hours_tue hours_wed hours_thu hours_fri hours_sat hours_sun created_at

* id employee_id work_date shift_type_id planned_start planned_end note created_by created_at

vyberte tabulku attendance attendance_locks attendance_types audit_log bonus_rules candidate_forms closures companies contract_templates cssz_registrations cssz_registration_items custom_field_defs departments employees employee_custom_values gov_reports holidays invitations jmhz_reports leaves medical_exams notifications oopp_assignments oopp_items password_resets payroll_children payroll_employees payroll_periods payroll_rates payroll_recurring payslips payslip_items positions settings shift_types users work_calendars work_schedules . vyberte sloupec
Zobrazit

kritéria

Řadit	Vzestupně	Sestupně
Přidat jako	AND	OR
Op	= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL REGEXP REGEXP ^...$ NOT REGEXP	Text Další sloupec
	vyberte tabulku attendance attendance_locks attendance_types audit_log bonus_rules candidate_forms closures companies contract_templates cssz_registrations cssz_registration_items custom_field_defs departments employees employee_custom_values gov_reports holidays invitations jmhz_reports leaves medical_exams notifications oopp_assignments oopp_items password_resets payroll_children payroll_employees payroll_periods payroll_rates payroll_recurring payslips payslip_items positions settings shift_types users work_calendars work_schedules .	vyberte sloupec