* id description date staffid

* announcementid name message showtousers showtostaff showname dateadded userid

* id name id_criteria type apply_for from_time lever_bonus approver url_file create_time id_admin status

* id id_bonus_discipline from_time staff_id department_id lever_bonus formality formality_value description

* id id_contact name address phone_number voucher status complete datecreator order_number channel_id channel first_name last_name email company phonenumber city state country zip billing_street billing_city billing_state billing_country billing_zip shipping_street shipping_city shipping_state shipping_country shipping_zip userid notes reason admin_action discount discount_type total sub_total discount_total invoice number_invoice stock_export_number create_invoice stock_export customers_pay amount_returned tax seller staff_note payment_note allowed_payment_modes warehouse_id shipping payment_method_title discount_type_str discount_percent adjustment currency terms shipping_tax enable duedate shipping_tax_json discount_voucher original_order_id return_reason approve_status process_invoice stock_import_number fee_for_return_order hash estimate_id add_discount

* id product_id quantity classify cart_id product_name prices long_description sku percent_discount prices_discount tax tax_id tax_rate tax_name unit_id unit_name

* id name group_id

* id name group_id staffid status

* id staff_id date type_check type route_point_id workplace_id

* userid company vat phonenumber country city zip state address website datecreated active leadid billing_street billing_city billing_state billing_zip billing_country shipping_street shipping_city shipping_state shipping_zip shipping_country longitude latitude default_language default_currency show_primary_contact stripe_id registration_confirmed addedfrom woo_customer_id woo_channel_id client_type

* id action date ip contact_id lead_id description opt_in_purpose_description purpose_id staff_name

* id name description date_created last_updated

* id userid is_primary firstname lastname email phonenumber title datecreated password new_pass_key new_pass_key_requested email_verified_at email_verification_key email_verification_sent_at last_ip last_login last_password_change active profile_image direction invoice_emails estimate_emails credit_note_emails contract_emails task_emails project_emails ticket_emails

* id permission_id userid

* id content description subject client datestart dateend contract_type project_id addedfrom dateadded isexpirynotified contract_value trash not_visible_to_client hash signed signature marked_as_signed acceptance_firstname acceptance_lastname acceptance_email acceptance_date acceptance_ip short_link last_sent_at contacts_sent_to last_sign_reminder_at

* id name

* id content contract_id staffid dateadded

* id contractid old_start_date new_start_date old_end_date new_end_date old_value new_value date_renewed renewed_by renewed_by_staff_id is_on_old_expiry_notified

* country_id iso2 short_name long_name iso3 numcode un_member calling_code cctld

* id clientid deleted_customer_name number prefix number_format datecreated date adminnote terms clientnote currency subtotal total_tax total adjustment addedfrom status project_id discount_percent discount_total discount_type billing_street billing_city billing_state billing_zip billing_country shipping_street shipping_city shipping_state shipping_zip shipping_country include_shipping show_shipping_on_credit_note show_quantity_as reference_no

* id credit_note_id staff_id refunded_on payment_mode note amount created_at

* id invoice_id credit_id staff_id date date_applied amount

* id symbol name decimal_separator thousand_separator placement isdefault

* id from_currency_id from_currency_name from_currency_rate to_currency_id to_currency_name to_currency_rate date_updated

* id from_currency_id from_currency_name from_currency_rate to_currency_id to_currency_name to_currency_rate date

* id name

* staff_id customer_id date_assigned

* id groupid customer_id

* id fieldto name slug required type options display_inline field_order active show_on_pdf show_on_ticket_form only_admin show_on_table show_on_client_portal disalow_client_to_edit bs_column default_value

* id relid fieldid fieldto value

* id off_reason off_type break_date timekeeping department position add_from repeat_by_year

* departmentid name imap_username email email_from_header host password encryption folder delete_after_import calendar_id hidefromclient manager_id parent_id

* dismissedannouncementid announcementid staff userid

* emailtemplateid type slug language name subject message fromname fromemail plaintext active order

* id mail_id file_name file_type file_path

* id rel_type rel_id template_id company_name company_email company_cc error_message mail_subject content date added_staff_id status opened date_opened system_template_id system_template_slug trigger_id send_rel_type send_rel_id

* id mail_id client_id lead_id status error_message date mail_address mail_company

* id template_slug status

* id template_name template_content template_subject status date added_staff_id is_public

* id setting_name template_id client_groups lead_statuses lead_sources leads clients sending_date status send_status sending_hour not_clients

* id trigger_name template_id rel_type options staff_active client_active status sending_hour

* id trigger_id trigger_rel_id send_rel_type send_rel_id mail_id date

* id sent datesend clientid deleted_customer_name project_id number prefix number_format hash datecreated date expirydate currency subtotal total_tax total adjustment addedfrom status clientnote adminnote discount_percent discount_total discount_type invoiceid invoiced_date terms reference_no sale_agent billing_street billing_city billing_state billing_zip billing_country shipping_street shipping_city shipping_state shipping_zip shipping_country include_shipping show_shipping_on_estimate show_quantity_as pipeline_order is_expiry_notified acceptance_firstname acceptance_lastname acceptance_email acceptance_date acceptance_ip signature short_link

* id email submission last_status_change date_estimated from_form_id assigned status default_language date_added

* id form_key type name form_data recaptcha status submit_btn_name submit_btn_bg_color submit_btn_text_color success_submit_msg submit_action submit_redirect_url language dateadded notify_type notify_ids responsible notify_request_submitted

* id name statusorder color flag

* eventid title description userid start end public color isstartnotified reminder_before reminder_before_type

* id category currency amount tax tax2 reference_no note expense_name clientid project_id billable invoiceid paymentmode date recurring_type repeat_every recurring cycles total_cycles custom_recurring last_recurring_date create_invoice_billable send_invoice_to_customer recurring_from dateadded addedfrom vendor

* id name description

* id staffid email_userid description datetime

* id userid mail_engine email_protocol smtp_encryption smtp_host smtp_port email smtp_username smtp_password email_charset active

* id rel_id rel_type file_name filetype visible_to_customer attachment_key external external_link thumbnail_link staffid contact_id task_comment_id dateadded

* id name builder staff_id identifier is_shared

* filter_id staff_id identifier view

* questionid rel_id rel_type question required question_order

* boxid boxtype questionid

* questionboxdescriptionid description boxid questionid

* resultid boxid boxdescriptionid rel_id rel_type questionid answer resultsetid

* id clientid contact_id lead_id request_type status request_date request_from description

* id subject description start_date end_date goal_type contract_type achievement notify_when_fail notify_when_achieve notified staff_id

* id rel_type rel_document customer_code customer_name to_ address description staff_id date_c date_add goods_delivery_code warehouse_id total_money approval addedfrom total_discount after_discount invoice_id project type department requester invoice_no pr_order_id type_of_delivery additional_discount sub_total delivery_status shipping_fee

* id goods_delivery_id commodity_code commodity_name warehouse_id unit_id quantities unit_price total_money note discount discount_money available_quantity tax_id total_after_discount expiry_date lot_number guarantee_period tax_rate tax_name sub_total packing_qty serial_number

* id rel_id rel_type type

* id supplier_code supplier_name deliver_name buyer_id description pr_order_id date_c date_add goods_receipt_code warehouse_id total_tax_money total_goods_money value_of_inventory total_money addedfrom approval project type department requester expiry_date invoice_no

* id goods_receipt_id commodity_code commodity_name warehouse_id unit_id quantities unit_price tax tax_money goods_money date_manufacture expiry_date note discount discount_money lot_number tax_rate sub_total tax_name serial_number

* id goods_receipt_id goods_id old_quantity quantity date_add commodity_id warehouse_id note status purchase_price price expiry_date lot_number from_stock_name to_stock_name serial_number

* id group_name meta

* id group_name meta staffid

* allocation_id staff_id asset_name assets_amount status_allocation

* type_id type_name allowance_val taxable

* id name group_id status

* id name job_position content

* id staffid dependent_name relationship dependent_bir start_month end_month dependent_iden reason status status_comment

* id staff_id admin_id programe_id training_programs_name training_places training_time_from training_time_to date_create training_result degree notes

* id group_name meta staffid

* job_id job_name description

* position_id position_name job_position_description job_p_id position_code department_id

* training_process_id job_position_id training_name training_type description date_add position_training_id mint_point additional_training staff_id time_to_start time_to_end

* salary_scale_id job_position_id rel_type rel_id value

* articleanswerid articleid answer ip date

* articleid articlegroup subject description slug active datecreated article_order staff_article question_answers file_name curator benchmark score

* groupid name group_slug description active color group_order

* id staffid staff_name department_name role_name email dateoff approval

* training_id subject training_type slug description viewdescription datecreated redirect_url send onlyforloggedin fromname iprestrict active hash mint_point

* questionid rel_id rel_type question required question_order point

* id rel_name option_name status people_handle_id procedure_retire_id

* id name_procedure_retire department datecreator

* id rel_id option_name status staffid

* id rel_name people_handle_id

* option_id option_name option_val auto

* boxid boxtype questionid

* questionboxdescriptionid description boxid questionid correct

* resultid boxid boxdescriptionid rel_id rel_type questionid answer resultsetid

* resultsetid trainingid ip useragent date staff_id

* id staffid firstname lastname birthday gender staff_identifi creator

* form_id form_name salary_val tax

* id_contract contract_code name_contract staff start_valid end_valid contract_status sign_day staff_delegate hourly_or_month content hash signature signer staff_signature staff_sign_day

* contract_detail_id staff_contract_id type rel_type rel_value since_date contract_note

* id_contracttype name_contracttype description duration unit insurance

* id training_process_id staffid training_type date_add training_name jp_interview_training_id

* id name

* id rel_id rel_type date view_ip

* id name workplace_address latitude longitude default

* id internal_delivery_name description staff_id date_c date_add internal_delivery_code approval addedfrom total_amount datecreated

* id internal_delivery_id commodity_code from_stock_name to_stock_name unit_id available_quantity quantities unit_price into_money note commodity_name serial_number

* id commodity_id commodity_code commodity_name inventory_number_min inventory_number_max

* id warehouse_id commodity_id inventory_number date_manufacture expiry_date lot_number purchase_price

* id invoiceid amount paymentmode paymentmethod date daterecorded note transactionid

* id sent datesend clientid deleted_customer_name number prefix number_format datecreated date duedate currency subtotal total_tax total adjustment addedfrom hash status clientnote adminnote last_overdue_reminder last_due_reminder cancel_overdue_reminders allowed_payment_modes token discount_percent discount_total discount_type recurring recurring_type custom_recurring cycles total_cycles is_recurring_from last_recurring_date terms sale_agent billing_street billing_city billing_state billing_zip billing_country shipping_street shipping_city shipping_state shipping_zip shipping_country include_shipping show_shipping_on_invoice show_quantity_as project_id subscription_id short_link shipping_fee

* id rel_id rel_type description long_description qty rate unit item_order wh_delivered_quantity

* id description long_description rate tax tax2 unit group_id commodity_code commodity_barcode unit_id sku_code sku_name purchase_price can_be_sold can_be_purchased can_be_manufacturing can_be_inventory sub_group active parent_id attributes parent_attributes from_vendor_item guarantee profif_ratio long_descriptions without_checking_warehouse series_id warehouse_id origin color_id style_id model_id size_id commodity_type commodity_name color

* id name commodity_group_code order display note

* id vendor_id description long_description rate tax tax2 unit group_id commodity_code commodity_barcode unit_id sku_code sku_name sub_group active parent attributes parent_attributes commodity_type origin commodity_name series_id long_descriptions share_status

* id itemid rel_id rel_type taxrate taxname

* articleanswerid articleid answer ip date

* articleid articlegroup subject description slug active datecreated article_order staff_article question_answers file_name curator benchmark score

* groupid name group_slug description active color group_order

* id hash name title company description country zip city state address assigned dateadded from_form_id status source lastcontact dateassigned last_status_change addedfrom email website leadorder phonenumber date_converted lost junk last_lead_status is_imported_from_email_integration email_integration_uid is_public default_language client_id lead_value vat

* id active email imap_server password check_every responsible lead_source lead_status encryption folder last_run notify_lead_imported notify_lead_contact_more_times notify_type notify_ids mark_public only_loop_on_unseen_emails delete_after_import create_task_if_customer

* id name

* id name statusorder color isdefault

* id leadid description additional_data date staffid full_name custom_activity

* id subject body dateadded leadid emailid

* id staff_id value datecreated add_from

* id engine email cc bcc message alt_message status date headers attachments

* leave_id id_staff leave_date leave_year accumulated_leave seniority_leave borrow_leave actual_leave expected_leave

* version

* id name description description_visible_to_customer start_date due_date project_id color milestone_order datecreated hide_from_customer

* id module_name installed_version active

* id postid commentid userid dateliked

* postid creator datecreated visibility content pinned datepinned

* id content userid postid dateadded

* id postid userid dateliked

* id rel_id rel_type description date_contacted addedfrom dateadded

* id isread isread_inline date description fromuserid fromclientid from_fullname touserid fromcompany link additional_data

* id name circulation okr_superior your_target okr_cross display creator datecreator change person_assigned status progress recently_checkin upcoming_checkin confidence_level type category department approval_status

* id okrs_id main_results target achieved progress confidence_level unit answer evaluation_criteria comment type recently_checkin upcoming_checkin editor created_date key_results_id complete_okrs

* id okrs_id main_results key_results_id target achieved progress confidence_level unit answer evaluation_criteria comment type recently_checkin upcoming_checkin editor created_date progress_total complete_okrs

* id okrs_id main_results target plan results unit datecreator progress achieved confidence_level tasks

* id okrs_id main_results target plan results unit editor date_edit status progress achieved confidence_level

* id name circulation okr_superior your_target okr_cross display editor date_edit change person_assigned type category department

* id rel_id rel_type staffid approve note date approve_action reject_action approve_value reject_value staff_approve action sender date_send notification_recipient approval_deadline

* id name department okrs setting choose_when_approving notification_recipient number_day_approval

* id category

* id name_circulation from_date to_date

* id group_criteria name scores

* id question

* id unit

* id cart_id payment_id payment_name customer_pay datecreator

* id m_date_report m_total_diesel m_total_pertrol m_total_other m_total_by_cash m_total_by_mpesa m_total_by_card m_total_by_invoice m_total_amount m_total_quantity date_time_transaction list_customer_report_id

* id create_customer_report_id date_add attendant_name shift_type date_report total_diesel total_pertrol total_other_product total_by_cash total_by_mpesa total_by_card total_by_invoice total_sales list_customer_report_id

* id ser_no authorized_by date time transaction_id receipt pay_mode nozzle product quantity total_sale ref_slip_no date_add version customer_id payment_id shift_type date_time_transaction

* id name_discount client price product_id product_quality total_product date_apply voucher_coupon order_number total_order discount tax total_after channel_id

* id name regular_price sale_price date_on_sale_from date_on_sale_to short_description stock_quantity sku type date_sync stock_quantity_history order_id chanel company description

* id name_channel consumer_key consumer_secret url

* id channel_id customer_group customer group_product_id datecreator

* id order_id staff_id refunded_on payment_mode note amount created_at

* id store sync_omni_sales_products time1 sync_omni_sales_inventorys time2 price_crm_woo time3 sync_omni_sales_description time4 sync_omni_sales_images time5 sync_omni_sales_orders time6 product_info_enable_disable time7 product_info_image_enable_disable time8 datecreator

* id staff_id shift_code granted_amount incurred_amount closing_amount status created_at order_value

* id shift_id action granted_amount current_amount customer_amount balance_amount created_at staff_id customer_id type order_value

* id name_trade_discount start_time end_time group_clients clients group_items items formal discount voucher channel store minimum_order_value

* id name value autoload

* id reference invoice_id amount fee payment_gateway created_at

* id name description show_on_pdf invoices_only expenses_only selected_by_default active

* id project_id staff_id

* questionid rel_id rel_type question required question_order point

* id discussion_id discussion_type parent created modified content staff_id contact_id fullname file_name file_mime_type

* id project_id subject description show_to_customer datecreated last_activity staff_id contact_id

* id name description status clientid billing_type start_date deadline project_created date_finished progress progress_from_tasks project_cost project_rate_per_hour estimated_hours addedfrom contact_notification notify_contacts

* id project_id staff_id contact_id fullname visible_to_customer description_key additional_data dateadded

* id file_name original_file_name subject description filetype dateadded last_activity project_id visible_to_customer staffid contact_id external external_link thumbnail_link

* id project_id staff_id

* id project_id content staff_id

* id project_id name value

* id subject content addedfrom datecreated total subtotal total_tax adjustment discount_percent discount_total discount_type show_quantity_as currency open_till date rel_id rel_type assigned hash proposal_to project_id country zip state city address email phone allow_comments status estimate_id invoice_id date_converted pipeline_order is_expiry_notified acceptance_firstname acceptance_lastname acceptance_email acceptance_date acceptance_ip signature short_link processing

* id content proposalid staffid dateadded

* option_id option_name option_val auto

* id rel_id rel_type staffid date note

* id rel_id rel_type staffid approve note date approve_action reject_action approve_value reject_value staff_approve action sender date_send

* id name related setting

* id content rel_type rel_id staffid dateadded

* id userid is_primary firstname lastname email phonenumber title datecreated password new_pass_key new_pass_key_requested email_verified_at email_verification_key email_verification_sent_at last_ip last_login last_password_change active profile_image direction invoice_emails estimate_emails credit_note_emails contract_emails task_emails project_emails ticket_emails

* id contract_number contract_name content vendor pur_order contract_value start_date end_date buyer time_payment add_from signed note signer signed_date signed_status service_category project payment_terms payment_amount payment_cycle department

* id invoice_id debit_id staff_id date_applied date amount

* id debit_note_id staff_id refunded_on payment_mode note amount created_at

* id vendorid deleted_vendor_name number prefix number_format datecreated date adminnote terms vendornote currency subtotal total_tax total adjustment addedfrom status discount_percent discount_total discount_type billing_street billing_city billing_state billing_zip billing_country shipping_street shipping_city shipping_state shipping_zip shipping_country include_shipping show_shipping_on_debit_note show_quantity_as reference_no

* id sent datesend vendor deleted_vendor_name pur_request number prefix number_format hash datecreated date expirydate currency subtotal total_tax total adjustment addedfrom status vendornote adminnote discount_percent discount_total discount_type invoiceid invoiced_date terms reference_no buyer billing_street billing_city billing_state billing_zip billing_country shipping_street shipping_city shipping_state shipping_zip shipping_country include_shipping show_shipping_on_estimate show_quantity_as pipeline_order is_expiry_notified acceptance_firstname acceptance_lastname acceptance_email acceptance_date acceptance_ip signature make_a_contract currency_rate from_currency to_currency shipping_fee

* id pur_estimate item_code unit_id unit_price quantity into_money tax total total_money discount_money discount_% tax_value tax_rate tax_name item_name

* id number invoice_number invoice_date subtotal tax_rate tax total contract vendor transactionid transaction_date payment_request_status payment_status vendor_note adminnote terms add_from date_add pur_order recurring recurring_type cycles total_cycles last_recurring_date is_recurring_from duedate add_from_type currency discount_total discount_percent currency_rate from_currency to_currency shipping_fee

* id pur_invoice item_code description unit_id unit_price quantity into_money tax total discount_percent discount_money total_money tax_value tax_rate tax_name item_name

* id pur_invoice amount paymentmode date daterecorded note transactionid approval_status requester

* id pur_order_name vendor estimate pur_order_number order_date status approve_status datecreated days_owed delivery_date subtotal total_tax total addedfrom vendornote terms discount_percent discount_total discount_type buyer status_goods number expense_convert hash clients delivery_status type project pur_request department tax_order_rate tax_order_amount sale_invoice currency order_status shipping_note currency_rate from_currency to_currency shipping_fee

* id pur_order item_code description unit_id unit_price quantity into_money tax total discount_% discount_money total_money tax_value tax_rate tax_name item_name wh_quantity_received

* id pur_order amount paymentmode date daterecorded note transactionid

* id pur_rq_code pur_rq_name rq_description requester department request_date status status_goods hash type project number from_items subtotal total_tax total sale_invoice compare_note send_to_vendors currency currency_rate from_currency to_currency sale_estimate

* prd_id pur_request item_code unit_id unit_price quantity into_money inventory_quantity item_text tax tax_rate tax_value total tax_name

* unit_id unit_name

* userid company vat phonenumber country city zip state address website datecreated active leadid billing_street billing_city billing_state billing_zip billing_country shipping_street shipping_city shipping_state shipping_zip shipping_country longitude latitude default_language default_currency show_primary_contact stripe_id registration_confirmed addedfrom category bank_detail payment_terms vendor_code return_within_day return_order_fee return_policies

* staff_id vendor_id date_assigned

* id category_name description

* id vendor group_items items add_from datecreate

* questionboxdescriptionid description boxid questionid correct

* id name meta

* criteria_id criteria_type criteria_title group_criteria description add_from add_date score_des1 score_des2 score_des3 score_des4 score_des5

* position_id position_name position_description

* set_id send_to email_to add_from add_date subject content order

* id staffid firstname lastname birthday gender staff_identifi creator datecreator

* id rel_id rel_type item_id

* id description date isnotified rel_id staff rel_type notify_by_email creator

* roleid name permissions

* id rel_type rel_id description additional_data staffid full_name date

* id channel status

* id group_product_id product_id sales_channel_id prices department pre_order_product_st_id customer_group customer

* id rel_id rel_type staffid approve note date approve_action reject_action approve_value reject_value staff_approve action sender date_send agent_id type

* id name related setting type agent_id

* id agent_id name email vat phonenumber country city zip state address website created_at created_by group street

* id name description agent_id

* id agent_id rel_type rel_document customer_code customer_name to_ address description staff_id date_c date_add goods_delivery_code warehouse_id total_money approval addedfrom total_discount after_discount invoice_id type invoice_no pr_order_id type_of_delivery additional_discount sub_total delivery_status shipping_fee

* id goods_delivery_id commodity_code commodity_name warehouse_id unit_id quantities unit_price total_money note discount discount_money available_quantity tax_id total_after_discount expiry_date lot_number guarantee_period tax_rate tax_name sub_total serial_number

* id rel_id rel_type type

* id agent_id supplier_code supplier_name deliver_name buyer_id description pr_order_id date_c date_add goods_receipt_code warehouse_id total_tax_money total_goods_money value_of_inventory total_money addedfrom approval type requester

* id goods_receipt_id commodity_code commodity_name warehouse_id unit_id quantities unit_price tax tax_money goods_money date_manufacture expiry_date note discount discount_money lot_number tax_rate sub_total tax_name serial_number

* id agent_id goods_receipt_id goods_id old_quantity quantity date_add commodity_id warehouse_id note status purchase_price price expiry_date lot_number from_stock_name to_stock_name serial_number

* id warehouse_id commodity_id inventory_number date_manufacture expiry_date agent_id lot_number purchase_price

* id program_id agent_id status note

* id name value agent_id

* id name from_date to_date indefinite created_by created_at descriptions active agent agent_group product product_group discount_type agent_group_can_view agent_can_view

* id from_amount to_amount discount program_id product_group product

* id order_name agent_id order_number order_date status approve_status datecreated delivery_date subtotal total_tax total addedfrom vendornote terms discount_percent discount_total discount_type buyer number hash delivery_status type currency order_status shipping_note currency_rate from_currency to_currency shipping_fee invoice_id stock_export_id status_goods

* id pur_order item_code description unit_id unit_price quantity into_money tax total discount_% discount_money total_money tax_value tax_rate tax_name item_name program_id wh_quantity_received

* id agent_id inv_number sent datesend clientid deleted_customer_name number prefix number_format datecreated date duedate currency subtotal total_tax total adjustment addedfrom hash status clientnote adminnote last_overdue_reminder last_due_reminder cancel_overdue_reminders allowed_payment_modes token discount_percent discount_total discount_type recurring recurring_type custom_recurring cycles total_cycles is_recurring_from last_recurring_date terms seller billing_street billing_city billing_state billing_zip billing_country shipping_street shipping_city shipping_state shipping_zip shipping_country include_shipping show_shipping_on_invoice show_quantity_as short_link shipping_fee currency_rate from_currency to_currency

* id sale_invoice item_code description unit_id unit_price quantity into_money tax total discount_percent discount_money total_money tax_value tax_rate tax_name item_name

* id sale_invoice amount paymentmode date daterecorded note transactionid requester

* warehouse_id warehouse_code warehouse_name warehouse_address order display note agent_id city state zip_code country

* id rel_id rel_type scheduled_at contacts cc attach_pdf template

* serviceid name

* id ip_address timestamp data

* id name meta

* id training_type position_training

* id name meta

* file_id contact_id

* id shift_type_name color time_start time_end time_start_work time_end_work start_lunch_break_time end_lunch_break_time description datecreated add_from

* id type rel_type value

* staffid email firstname lastname facebook linkedin phonenumber skype password datecreated profile_image last_ip last_login last_activity last_password_change new_pass_key new_pass_key_requested admin role active default_language direction media_path_slug is_not_staff hourly_rate two_factor_auth_enabled two_factor_auth_code two_factor_auth_code_requested email_signature birthday birthplace sex marital_status nation religion identification days_for_identity home_town resident current_address literacy orther_infor job_position workplace place_of_issue account_number name_account issue_bank records_received Personal_tax_code google_auth_secret team_manage staff_identifi status_work date_update token epf_no social_security_no

* staffdepartmentid staffid departmentid

* staff_id feature capability

* id description warehouse_id date_stock_take stock_take_code date_add hour_add staff_id approval addedfrom

* id stock_take_id commodity_code commodity_name unit_id unit_price quantity_stock_take quantity_accounting_book quantity_change handling reason approval

* id name description description_in_item clientid date terms currency tax_id stripe_tax_id tax_id_2 stripe_tax_id_2 stripe_plan_id stripe_subscription_id next_billing_cycle ends_at status quantity project_id hash created created_from date_subscribed in_test_environment last_sent_at

* rel_id rel_type tag_id tag_order

* id name

* id name description priority dateadded startdate duedate datefinished addedfrom is_added_from_contact status recurring_type repeat_every recurring is_recurring_from cycles total_cycles custom_recurring last_recurring_date rel_id rel_type is_public billable billed invoice_id hourly_rate milestone kanban_order milestone_order visible_to_client deadline_notified

* id task_id start_time end_time staff_id hourly_rate note

* id description

* id staffid taskid assigned_from is_assigned_from_contact

* id taskid description finished dateadded addedfrom finished_from list_order assigned

* id content taskid staffid contact_id file_id dateadded

* id staffid taskid

* id name taxrate

* id name type addedfrom content

* ticketid adminreplying userid contactid merged_ticket_id email name department priority status service ticketkey subject message admin date project_id lastreply clientread adminread assigned staff_id_replying cc

* id date email_to name subject message email status

* id name message

* priorityid name

* ticketstatusid name isdefault statuscolor statusorder

* id ticketid replyid file_name filetype dateadded

* id ticketid userid contactid name email date message attachment admin

* id additional_day status timekeeping_type timekeeping_value approver creator old_timekeeping time_in time_out overtime_setting reason

* id rel_id rel_type staffid approve note date approve_action reject_action approve_value reject_value staff_approve action sender date_send notification_recipient approval_deadline

* id name related setting choose_when_approving notification_recipient number_day_approval departments job_positions

* id staffid year total remain accumulated days_off type_of_leave

* id requisition_leave used_to amoun_of_money request_date advance_payment_reason

* id month_latch

* id staff_id date_work value type add_from

* id sent staffid date type

* option_id option_name option_val auto

* id staff_id subject start_time end_time reason received_date amount_received approver_id followers_id rel_type status place_of_business type_of_leave according_to_the_plan handover_recipients datecreated number_of_days number_of_leaving_day type_of_leave_text

* id staffid route_point_id date_work order

* id name route_point_address latitude longitude distance related_to related_id default

* id staff_id date_work shift datecreated add_from

* id shift_symbol time_start_work time_end_work start_lunch_break_time end_lunch_break_time late_latency_allowed description

* staff_identifi time type

* id staff_id date_work value type add_from overtime_setting relate_id relate_type latch

* id type_name slug symbol date_creator

* id ip enable date_creator

* id name workplace_address latitude longitude distance default

* id staffid workplace_id datecreator

* todoid description staffid dateadded finished datefinished item_order

* id uid rel_id rel_type date email opened date_opened subject

* id training_process_id staffid training_type date_add training_name

* id name meta staffid

* id reference invoice_id amount created_at attempt_reference

* key_id user_id user_agent last_ip last_login staff

* umeta_id staff_id client_id contact_id meta_key meta_value

* id customer_id server_address port username password description creator creator_name visibility share_in_projects last_updated last_updated_from date_created

* id rel_id rel_type date view_ip

* warehouse_id warehouse_code warehouse_name warehouse_address order display note city state zip_code country

* body_type_id body_code body_name order display note

* color_id color_code color_name color_hex order display note

* commodity_type_id commondity_code commondity_name order display note

* size_type_id size_code size_name size_symbol order display note

* style_type_id style_code style_barcode style_name order display note

* unit_type_id unit_code unit_name unit_symbol order display note

* id form_key lead_source lead_status notify_lead_imported notify_type notify_ids responsible name form_data recaptcha submit_btn_name submit_btn_text_color submit_btn_bg_color success_submit_msg submit_action lead_name_prefix submit_redirect_url language allow_duplicate mark_public track_duplicate_field track_duplicate_field_and create_task_on_duplicate dateadded

* id rel_id rel_type staffid date note

* id rel_id rel_type staffid approve note date approve_action reject_action approve_value reject_value staff_approve action sender date_send

* id name related setting

* id name

* id custom_fields_id warehouse_id

* id rel_id rel_type description additional_data date staffid full_name

* id commodity_id warehouse_id inventory_manage_id serial_number is_used

* id type addfrom reason time date_create status warehouses

* id items unit current_number updates_number loss_adjustment expiry_date lot_number commodity_name serial_number

* id name brand_id

* id cart_id shipment_number planned_shipping_date shipment_status datecreated goods_delivery_id shipment_hash order_id

* id rel_id rel_type return_type company_id company_name email phonenumber order_number order_date number_of_item order_total order_return_number order_return_name fee_return_order refund_loyaty_point subtotal total_amount discount_total additional_discount adjustment_amount total_after_discount return_policies_information admin_note approval datecreated staff_id receipt_delivery_id return_reason receipt_delivery_type currency status

* id order_return_id staff_id refunded_on payment_mode note amount created_at

* id order_return_id rel_type_detail_id commodity_code commodity_name quantity unit_id unit_price sub_total tax_id tax_rate tax_name total_amount discount discount_total total_after_discount reason_return

* id delivery_note_id packing_list_number packing_list_name width height lenght weight volume clientid subtotal total_amount discount_total additional_discount total_after_discount billing_street billing_city billing_state billing_zip billing_country shipping_street shipping_city shipping_state shipping_zip shipping_country client_note admin_note approval datecreated staff_id type_of_packing_list delivery_status shipping_fee

* id packing_list_id delivery_detail_id commodity_code commodity_name quantity unit_id unit_price sub_total tax_id tax_rate tax_name total_amount discount discount_total total_after_discount serial_number

* id name model_id

* id sub_group_code sub_group_name order display note group_id

* id name ip url port token

* id group_product_id product_id woocommere_store_id prices

* id shift_code shift_name shift_type department position add_from staff date_create from_date to_date shifts_detail type_shiftwork

* id staff_id date shift_id work_shift_id

* id staff_id day_name shift_id work_shift_id

* id staff_id number shift_id work_shift_id

* id functionality hook created_at subscribe_id

seleccionar tabla tblactivity_log tblannouncements tblbonus_discipline tblbonus_discipline_detail tblcart tblcart_detailt tblchecklist tblchecklist_allocation tblcheck_in_out tblclients tblconsents tblconsent_purposes tblcontacts tblcontact_permissions tblcontracts tblcontracts_types tblcontract_comments tblcontract_renewals tblcountries tblcreditnotes tblcreditnote_refunds tblcredits tblcurrencies tblcurrency_rates tblcurrency_rate_logs tblcustomers_groups tblcustomer_admins tblcustomer_groups tblcustomfields tblcustomfieldsvalues tblday_off tbldepartments tbldismissed_announcements tblemailtemplates tblemail_template_manage_mail_attachments tblemail_template_manage_mail_logs tblemail_template_manage_sending_logs tblemail_template_manage_system_templates tblemail_template_manage_templates tblemail_template_manage_timer tblemail_template_manage_triggers tblemail_template_manage_trigger_logs tblestimates tblestimate_requests tblestimate_request_forms tblestimate_request_status tblevents tblexpenses tblexpenses_categories tblextended_email_log_activity tblextended_email_settings tblfiles tblfilters tblfilter_defaults tblform_questions tblform_question_box tblform_question_box_description tblform_results tblgdpr_requests tblgoals tblgoods_delivery tblgoods_delivery_detail tblgoods_delivery_invoices_pr_orders tblgoods_receipt tblgoods_receipt_detail tblgoods_transaction_detail tblgroup_checklist tblgroup_checklist_allocation tblhr_allocation_asset tblhr_allowance_type tblhr_checklist_allocation tblhr_contract_template tblhr_dependent_person tblhr_education tblhr_group_checklist_allocation tblhr_job_p tblhr_job_position tblhr_jp_interview_training tblhr_jp_salary_scale tblhr_knowedge_base_article_feedback tblhr_knowledge_base tblhr_knowledge_base_groups tblhr_list_staff_quitting_work tblhr_position_training tblhr_position_training_question_form tblhr_procedure_retire tblhr_procedure_retire_manage tblhr_procedure_retire_of_staff tblhr_procedure_retire_of_staff_by_id tblhr_profile_option tblhr_p_t_form_question_box tblhr_p_t_form_question_box_description tblhr_p_t_form_results tblhr_p_t_surveyresultsets tblhr_rec_transfer_records tblhr_salary_form tblhr_staff_contract tblhr_staff_contract_detail tblhr_staff_contract_type tblhr_training_allocation tblhr_type_of_trainings tblhr_views_tracking tblhr_workplace tblinternal_delivery_note tblinternal_delivery_note_detail tblinventory_commodity_min tblinventory_manage tblinvoicepaymentrecords tblinvoices tblitemable tblitems tblitems_groups tblitems_of_vendor tblitem_tax tblknowedge_base_article_feedback tblknowledge_base tblknowledge_base_groups tblleads tblleads_email_integration tblleads_sources tblleads_status tbllead_activity_log tbllead_integration_emails tblleave_of_the_year tblmail_queue tblmanage_leave tblmigrations tblmilestones tblmodules tblnewsfeed_comment_likes tblnewsfeed_posts tblnewsfeed_post_comments tblnewsfeed_post_likes tblnotes tblnotifications tblokrs tblokrs_checkin tblokrs_checkin_log tblokrs_key_result tblokrs_key_result_log tblokrs_log tblokr_approval_details tblokr_approval_setting tblokr_setting_category tblokr_setting_circulation tblokr_setting_evaluation_criteria tblokr_setting_question tblokr_setting_unit tblomni_cart_payment tblomni_create_customer_report tblomni_create_customer_report_detail tblomni_customer_report tblomni_log_discount tblomni_log_sync_woo tblomni_master_channel_woocommere tblomni_pre_order_product_setting tblomni_refunds tblomni_setting_woo_store tblomni_shift tblomni_shift_history tblomni_trade_discount tbloptions tblpayment_attempts tblpayment_modes tblpinned_projects tblposition_training_question_form tblprojectdiscussioncomments tblprojectdiscussions tblprojects tblproject_activity tblproject_files tblproject_members tblproject_notes tblproject_settings tblproposals tblproposal_comments tblpurchase_option tblpur_activity_log tblpur_approval_details tblpur_approval_setting tblpur_comments tblpur_contacts tblpur_contracts tblpur_debits tblpur_debits_refunds tblpur_debit_notes tblpur_estimates tblpur_estimate_detail tblpur_invoices tblpur_invoice_details tblpur_invoice_payment tblpur_orders tblpur_order_detail tblpur_order_payment tblpur_request tblpur_request_detail tblpur_unit tblpur_vendor tblpur_vendor_admin tblpur_vendor_cate tblpur_vendor_items tblp_t_form_question_box_description tblrecords_meta tblrec_criteria tblrec_job_position tblrec_set_transfer_record tblrec_transfer_records tblrelated_items tblreminders tblroles tblsales_activity tblsales_channel tblsales_channel_detailt tblsa_approval_details tblsa_approval_setting tblsa_clients tblsa_client_groups tblsa_goods_delivery tblsa_goods_delivery_detail tblsa_goods_delivery_invoices_pr_orders tblsa_goods_receipt tblsa_goods_receipt_detail tblsa_goods_transaction_detail tblsa_inventory_manage tblsa_join_program_request tblsa_options tblsa_programs tblsa_program_detail tblsa_pur_orders tblsa_pur_order_detail tblsa_sale_invoices tblsa_sale_invoice_details tblsa_sale_invoice_payment tblsa_warehouse tblscheduled_emails tblservices tblsessions tblsetting_asset_allocation tblsetting_training tblsetting_transfer_records tblshared_customer_files tblshift_type tblspam_filters tblstaff tblstaff_departments tblstaff_permissions tblstock_take tblstock_take_detail tblsubscriptions tbltaggables tbltags tbltasks tbltaskstimers tbltasks_checklist_templates tbltask_assigned tbltask_checklist_items tbltask_comments tbltask_followers tbltaxes tbltemplates tbltickets tbltickets_pipe_log tbltickets_predefined_replies tbltickets_priorities tbltickets_status tblticket_attachments tblticket_replies tbltimesheets_additional_timesheet tbltimesheets_approval_details tbltimesheets_approval_setting tbltimesheets_day_off tbltimesheets_go_bussiness_advance_payment tbltimesheets_latch_timesheet tbltimesheets_leave tbltimesheets_log_send_notify tbltimesheets_option tbltimesheets_requisition_leave tbltimesheets_route tbltimesheets_route_point tbltimesheets_shiftwork_sc tbltimesheets_shift_sc tbltimesheets_timekeeper_data tbltimesheets_timesheet tbltimesheets_type_of_leave tbltimesheets_valid_ip tbltimesheets_workplace tbltimesheets_workplace_assign tbltodos tbltracked_mails tbltraining_allocation tbltransfer_records_reception tbltwocheckout_log tbluser_auto_login tbluser_meta tblvault tblviews_tracking tblwarehouse tblware_body_type tblware_color tblware_commodity_type tblware_size_type tblware_style_type tblware_unit_type tblweb_to_lead tblwh_activity_log tblwh_approval_details tblwh_approval_setting tblwh_brand tblwh_custom_fields tblwh_goods_delivery_activity_log tblwh_inventory_serial_numbers tblwh_loss_adjustment tblwh_loss_adjustment_detail tblwh_model tblwh_omni_shipments tblwh_order_returns tblwh_order_returns_refunds tblwh_order_return_details tblwh_packing_lists tblwh_packing_list_details tblwh_series tblwh_sub_group tblwoocommere_store tblwoocommere_store_detailt tblwork_shift tblwork_shift_detail tblwork_shift_detail_day_name tblwork_shift_detail_number_day tblzapier_hooks . seleccionar columna
Mostrar

criterio

Ordenar	Ascendente	Descendente
Agregar "as"	AND	OR
Op	= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL REGEXP REGEXP ^...$ NOT REGEXP	Texto Otra columna
	seleccionar tabla tblactivity_log tblannouncements tblbonus_discipline tblbonus_discipline_detail tblcart tblcart_detailt tblchecklist tblchecklist_allocation tblcheck_in_out tblclients tblconsents tblconsent_purposes tblcontacts tblcontact_permissions tblcontracts tblcontracts_types tblcontract_comments tblcontract_renewals tblcountries tblcreditnotes tblcreditnote_refunds tblcredits tblcurrencies tblcurrency_rates tblcurrency_rate_logs tblcustomers_groups tblcustomer_admins tblcustomer_groups tblcustomfields tblcustomfieldsvalues tblday_off tbldepartments tbldismissed_announcements tblemailtemplates tblemail_template_manage_mail_attachments tblemail_template_manage_mail_logs tblemail_template_manage_sending_logs tblemail_template_manage_system_templates tblemail_template_manage_templates tblemail_template_manage_timer tblemail_template_manage_triggers tblemail_template_manage_trigger_logs tblestimates tblestimate_requests tblestimate_request_forms tblestimate_request_status tblevents tblexpenses tblexpenses_categories tblextended_email_log_activity tblextended_email_settings tblfiles tblfilters tblfilter_defaults tblform_questions tblform_question_box tblform_question_box_description tblform_results tblgdpr_requests tblgoals tblgoods_delivery tblgoods_delivery_detail tblgoods_delivery_invoices_pr_orders tblgoods_receipt tblgoods_receipt_detail tblgoods_transaction_detail tblgroup_checklist tblgroup_checklist_allocation tblhr_allocation_asset tblhr_allowance_type tblhr_checklist_allocation tblhr_contract_template tblhr_dependent_person tblhr_education tblhr_group_checklist_allocation tblhr_job_p tblhr_job_position tblhr_jp_interview_training tblhr_jp_salary_scale tblhr_knowedge_base_article_feedback tblhr_knowledge_base tblhr_knowledge_base_groups tblhr_list_staff_quitting_work tblhr_position_training tblhr_position_training_question_form tblhr_procedure_retire tblhr_procedure_retire_manage tblhr_procedure_retire_of_staff tblhr_procedure_retire_of_staff_by_id tblhr_profile_option tblhr_p_t_form_question_box tblhr_p_t_form_question_box_description tblhr_p_t_form_results tblhr_p_t_surveyresultsets tblhr_rec_transfer_records tblhr_salary_form tblhr_staff_contract tblhr_staff_contract_detail tblhr_staff_contract_type tblhr_training_allocation tblhr_type_of_trainings tblhr_views_tracking tblhr_workplace tblinternal_delivery_note tblinternal_delivery_note_detail tblinventory_commodity_min tblinventory_manage tblinvoicepaymentrecords tblinvoices tblitemable tblitems tblitems_groups tblitems_of_vendor tblitem_tax tblknowedge_base_article_feedback tblknowledge_base tblknowledge_base_groups tblleads tblleads_email_integration tblleads_sources tblleads_status tbllead_activity_log tbllead_integration_emails tblleave_of_the_year tblmail_queue tblmanage_leave tblmigrations tblmilestones tblmodules tblnewsfeed_comment_likes tblnewsfeed_posts tblnewsfeed_post_comments tblnewsfeed_post_likes tblnotes tblnotifications tblokrs tblokrs_checkin tblokrs_checkin_log tblokrs_key_result tblokrs_key_result_log tblokrs_log tblokr_approval_details tblokr_approval_setting tblokr_setting_category tblokr_setting_circulation tblokr_setting_evaluation_criteria tblokr_setting_question tblokr_setting_unit tblomni_cart_payment tblomni_create_customer_report tblomni_create_customer_report_detail tblomni_customer_report tblomni_log_discount tblomni_log_sync_woo tblomni_master_channel_woocommere tblomni_pre_order_product_setting tblomni_refunds tblomni_setting_woo_store tblomni_shift tblomni_shift_history tblomni_trade_discount tbloptions tblpayment_attempts tblpayment_modes tblpinned_projects tblposition_training_question_form tblprojectdiscussioncomments tblprojectdiscussions tblprojects tblproject_activity tblproject_files tblproject_members tblproject_notes tblproject_settings tblproposals tblproposal_comments tblpurchase_option tblpur_activity_log tblpur_approval_details tblpur_approval_setting tblpur_comments tblpur_contacts tblpur_contracts tblpur_debits tblpur_debits_refunds tblpur_debit_notes tblpur_estimates tblpur_estimate_detail tblpur_invoices tblpur_invoice_details tblpur_invoice_payment tblpur_orders tblpur_order_detail tblpur_order_payment tblpur_request tblpur_request_detail tblpur_unit tblpur_vendor tblpur_vendor_admin tblpur_vendor_cate tblpur_vendor_items tblp_t_form_question_box_description tblrecords_meta tblrec_criteria tblrec_job_position tblrec_set_transfer_record tblrec_transfer_records tblrelated_items tblreminders tblroles tblsales_activity tblsales_channel tblsales_channel_detailt tblsa_approval_details tblsa_approval_setting tblsa_clients tblsa_client_groups tblsa_goods_delivery tblsa_goods_delivery_detail tblsa_goods_delivery_invoices_pr_orders tblsa_goods_receipt tblsa_goods_receipt_detail tblsa_goods_transaction_detail tblsa_inventory_manage tblsa_join_program_request tblsa_options tblsa_programs tblsa_program_detail tblsa_pur_orders tblsa_pur_order_detail tblsa_sale_invoices tblsa_sale_invoice_details tblsa_sale_invoice_payment tblsa_warehouse tblscheduled_emails tblservices tblsessions tblsetting_asset_allocation tblsetting_training tblsetting_transfer_records tblshared_customer_files tblshift_type tblspam_filters tblstaff tblstaff_departments tblstaff_permissions tblstock_take tblstock_take_detail tblsubscriptions tbltaggables tbltags tbltasks tbltaskstimers tbltasks_checklist_templates tbltask_assigned tbltask_checklist_items tbltask_comments tbltask_followers tbltaxes tbltemplates tbltickets tbltickets_pipe_log tbltickets_predefined_replies tbltickets_priorities tbltickets_status tblticket_attachments tblticket_replies tbltimesheets_additional_timesheet tbltimesheets_approval_details tbltimesheets_approval_setting tbltimesheets_day_off tbltimesheets_go_bussiness_advance_payment tbltimesheets_latch_timesheet tbltimesheets_leave tbltimesheets_log_send_notify tbltimesheets_option tbltimesheets_requisition_leave tbltimesheets_route tbltimesheets_route_point tbltimesheets_shiftwork_sc tbltimesheets_shift_sc tbltimesheets_timekeeper_data tbltimesheets_timesheet tbltimesheets_type_of_leave tbltimesheets_valid_ip tbltimesheets_workplace tbltimesheets_workplace_assign tbltodos tbltracked_mails tbltraining_allocation tbltransfer_records_reception tbltwocheckout_log tbluser_auto_login tbluser_meta tblvault tblviews_tracking tblwarehouse tblware_body_type tblware_color tblware_commodity_type tblware_size_type tblware_style_type tblware_unit_type tblweb_to_lead tblwh_activity_log tblwh_approval_details tblwh_approval_setting tblwh_brand tblwh_custom_fields tblwh_goods_delivery_activity_log tblwh_inventory_serial_numbers tblwh_loss_adjustment tblwh_loss_adjustment_detail tblwh_model tblwh_omni_shipments tblwh_order_returns tblwh_order_returns_refunds tblwh_order_return_details tblwh_packing_lists tblwh_packing_list_details tblwh_series tblwh_sub_group tblwoocommere_store tblwoocommere_store_detailt tblwork_shift tblwork_shift_detail tblwork_shift_detail_day_name tblwork_shift_detail_number_day tblzapier_hooks .	seleccionar columna