* id payable_no source_type source_id source_no payee_type payee_name title amount paid_amount currency exchange_rate status due_date paid_at paid_by payment_note note created_by created_at updated_at

* id employee_id leave_year period_start period_end expired_hours expired_days hourly_wage daily_salary settlement_amount status settled_by settled_at note created_at updated_at

* id form_type form_id applicant_id current_approver_id status created_at updated_at step_name sort_order

* id module_type record_id approver_id approval_level action_status comments approved_at

* id role_key role_name description sort_order is_active created_at updated_at

* id form_type max_approver_id enabled created_at

* id request_no employee_id attendance_date makeup_type requested_clock_in requested_clock_out reason status manager_approver_id approved_by approved_at rejected_by rejected_at approval_note attendance_record_id created_at updated_at

* id employee_id attendance_date clock_in clock_out work_hours status ip_address device_info created_at updated_at

* id work_start_time work_end_time late_grace_minutes early_leave_grace_minutes updated_by created_at updated_at setting_key setting_value setting_label

* id user_id username table_name record_id action old_data new_data created_at

* id calibration_no customer_id product_id serial_number send_date return_date certificate_no expire_date calibration_vendor status note created_by created_at updated_at

* id customer_id follow_date follow_type subject content next_followup_date created_by_user_id created_by_name created_at

* id company_name customer_code category tax_id phone email country city website address remark business_card contact_name department title tel ext mobile contact_title contact_phone contact_email status customer_tags customer_level customer_source owner_user_id owner_name last_visit_date next_followup_date created_by_user_id created_by_name notes created_at updated_at

* id name sort_order created_at code status updated_at

* id department_id feature_code allowed can_view can_add can_edit can_delete can_approve created_by created_at updated_at

* id employee_no name english_name quote_owner_code department_id position email tel ext mobile hire_date resign_date status emergency_contact emergency_phone address photo_path note user_id created_by created_at updated_at sort_order manager_id position_id gender birthday id_no line_id nationality blood_type bank_name bank_account insurance_no labor_insurance_mode labor_fixed_deduction health_insurance_mode health_fixed_deduction health_dependents annual_leave_policy annual_leave_extra_days annual_leave_extra_note

* id employee_id role_key is_active created_at updated_at role_id

* id employee_id transaction_type hours source_type source_id note created_at

* id employee_id feature_code allowed created_by created_at updated_at

* id employee_id labor_insurance_mode labor_fixed_deduction health_insurance_mode health_fixed_deduction health_dependents change_reason note created_by created_at

* id employee_id year annual_leave_days used_leave_days remaining_leave_days updated_at imported_used_hours imported_used_days imported_note imported_updated_at imported_updated_by

* id employee_id effective_date base_salary meal_allowance change_reason note created_by created_at

* id employee_id base_salary meal_allowance default_work_days is_active note created_at updated_at

* id feature_code feature_name feature_group sort_order is_active created_at updated_at feature_color mobile_visible dashboard_visible

* id category_key category_name icon_class sort_order is_active created_at updated_at

* feature_code category_id sort_order icon_class show_sidebar show_mobile dashboard_visible updated_at

* id year_sheet payable_no source_no payee_name project_no customer invoice_no invoice_date currency amount paid_amount status note created_by imported_at

* id year_sheet project_no company_name quotation_no invoice_no invoice_date due_date currency amount paid_amount status applicant note imported_at

* id currency rate_to_twd note updated_by updated_at

* id application_no applicant_user_id applicant_employee_id applicant_name department_id department_name period_start period_end apply_date status total_amount note submitted_at admin_review_by admin_review_at admin_review_note gm_approve_by gm_approve_at gm_approve_note paid_at paid_by created_by created_at updated_at

* id application_id action action_by action_at note

* id application_id expense_date description local_currency exchange_rate category local_amount amount_twd remark_no note sort_order created_at

* id item_id application_id file_path file_name uploaded_by uploaded_at

* id category_name sort_order icon category_status category_color homepage_visible mobile_visible

* id item_name qty created_at

* id receipt_no project_no purchase_order_no item_name qty location status created_at updated_at

* id product_id type qty before_stock after_stock customer_name serial_number location note created_by created_at project_id transaction_type

* id invoice_request_no applicant_id project_no customer_name invoice_type billing_percent amount description status manager_approver_id admin_issuer_id invoice_no invoice_file issued_at project_billing_completed created_at updated_at

* id employee_id leave_type start_date start_time end_date end_time days reason status approved_by approved_at rejected_reason created_at leave_type_id hours

* id employee_id leave_type start_date start_time end_date end_time days reason status approved_by approved_at rejected_reason created_at leave_type_id hours

* id name is_annual_leave deduct_annual_leave is_active sort_order

* id employee_id overtime_date end_date start_time end_time hours day_type ot_134_hours ot_167_hours ot_200_hours ot_267_hours reason status approved_by approved_at rejected_reason created_at

* id bracket_type salary_min insured_amount effective_year created_at

* id holiday_date holiday_name holiday_type created_at

* id payroll_month employee_id base_salary meal_allowance total_salary work_days is_full_month calc_start_date calc_end_date payable_salary labor_insured_amount health_insured_amount overtime_133_hours overtime_166_hours overtime_200_hours overtime_267_hours overtime_pay paid_leave_hours personal_leave_hours sick_leave_half_hours personal_leave_deduction sick_leave_deduction labor_insurance_mode health_insurance_mode labor_deduction health_dependents health_deduction net_salary note status created_by created_at updated_at

* id department_id name level_no created_at

* id position_id feature_code allowed created_by created_at updated_at

* id sku model category_id brand supplier name_tw name_en name_cn description_tw description_en description_cn spec_tw spec_en spec_cn unit currency sale_price cost_price stock_qty safety_stock status image_path catalog_path remark created_at updated_at

* id name sort_order created_at

* id product_id serial_type serial_number sensor_serial_id sensor_serial_number status location customer_name note assembled_at created_by void_reason void_by void_at created_at updated_at

* id project_name project_manager start_date end_date status created_at customer_id quotation_id

* id request_no applicant_id customer_name order_no quotation_no project_name amount payment_terms description status admin_reviewer_id reviewed_by reviewed_at project_no reject_reason created_at updated_at apply_date category_code customer_id quotation_id order_amount currency owner note order_file quote_file cost_file project_case_id

* id project_id step_name approver status comment approved_at created_at

* id project_no apply_date category_code project_name customer_id quotation_id order_no order_amount currency exchange_rate owner status total_cost invoice_percent_done order_file quote_file cost_file note created_by closed_at created_at updated_at

* category_code category_name sort_order is_active

* id project_id category_code amount percent currency note created_by created_at updated_at

* id project_id cost_date department item_name amount note created_by created_at

* id project_id receivable_schedule_id invoice_date invoice_percent amount invoice_no application_no status note created_by created_at application_status applicant applicant_employee_id submitted_at admin_checked_by admin_checked_at admin_checked_note gm_approved_by gm_approved_at gm_approved_note issued_by issued_at issued_note rejected_by rejected_at rejected_note due_date currency exchange_rate invoice_amount tax_amount total_amount paid_amount updated_at

* id request_no applicant_id customer_name order_no project_name amount description status admin_reviewer_id project_no created_at updated_at

* id project_id quotation_item_id product_id item_name model description qty unit unit_price discount_rate amount currency category_code sort_order created_at updated_at

* id invoice_id project_id payment_date currency payment_amount payment_method reference_no note created_by created_at

* id project_id order_id schedule_name billing_type percent amount currency exchange_rate base_date_type offset_days expected_due_date invoice_id status note created_by created_at updated_at

* id purchase_order_no purchase_request_id project_no supplier_name amount delivery_date payment_terms status created_at updated_at currency exchange_rate

* id request_no project_id applicant_id project_no project_name supplier_name item_summary amount currency exchange_rate negotiated_amount delivery_date payment_terms remark quote_file required_date negotiation_notes status manager_approver_id gm_approver_id gm_approved_at gm_comment admin_handler_id admin_negotiator_id purchase_order_no ordered_at created_at updated_at

* id quote_no customer_id quote_date valid_until currency tax_rate discount_amount subtotal tax_amount total_amount status note terms created_by created_at updated_at project_id parent_quotation_id version_no is_latest revision_reason replaced_by_id

* id quotation_id product_id product_name model description qty unit unit_price discount_rate category_code line_total sort_order

* id case_no case_date customer_id product_id serial_number subject problem_description solution status priority assigned_to note created_by created_at updated_at

* id shipment_no customer_id customer_name contact shipping_address order_no project_no project_id shipment_date items status remark created_by created_at updated_at

* id shipment_id finished_serial_id product_id serial_number cell_serial_number created_at

* id username password password_hash name role status created_at

* id user_id feature_key sort_order created_at

* id setting_key setting_value setting_label created_at updated_at

選擇資料表 accounts_payable annual_leave_settlements approval_items approval_records approval_roles approval_rules attendance_makeup_requests attendance_records attendance_settings audit_logs calibrations crm_customer_followups customers departments department_feature_permissions employees employee_approval_roles employee_comp_leave_balances employee_feature_permissions employee_insurance_history employee_leave_balances employee_salary_history employee_salary_settings erp_features erp_feature_categories erp_feature_menu_settings excel_ap_history excel_ar_history exchange_rates expense_applications expense_approval_logs expense_items expense_item_receipts feature_categories inventory inventory_receipts inventory_transactions invoice_applications leave_applications leave_applications_backup_before_clean leave_types overtime_applications payroll_brackets payroll_holidays payroll_records positions position_feature_permissions products product_categories product_serials projects project_applications project_approvals project_cases project_categories project_category_allocations project_costs project_invoices project_no_applications project_order_items project_payments project_receivable_schedules purchase_orders purchase_requests quotations quotation_items service_cases shipments shipment_items users user_quick_features workflow_settings . 選擇欄位
顯示

準則

排序	遞增	遞減
加入為	AND	OR
Op	= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL REGEXP REGEXP ^...$ NOT REGEXP	文字 另一個欄位
	選擇資料表 accounts_payable annual_leave_settlements approval_items approval_records approval_roles approval_rules attendance_makeup_requests attendance_records attendance_settings audit_logs calibrations crm_customer_followups customers departments department_feature_permissions employees employee_approval_roles employee_comp_leave_balances employee_feature_permissions employee_insurance_history employee_leave_balances employee_salary_history employee_salary_settings erp_features erp_feature_categories erp_feature_menu_settings excel_ap_history excel_ar_history exchange_rates expense_applications expense_approval_logs expense_items expense_item_receipts feature_categories inventory inventory_receipts inventory_transactions invoice_applications leave_applications leave_applications_backup_before_clean leave_types overtime_applications payroll_brackets payroll_holidays payroll_records positions position_feature_permissions products product_categories product_serials projects project_applications project_approvals project_cases project_categories project_category_allocations project_costs project_invoices project_no_applications project_order_items project_payments project_receivable_schedules purchase_orders purchase_requests quotations quotation_items service_cases shipments shipment_items users user_quick_features workflow_settings .	選擇欄位