ERP: Complete HR, Recruitment, Accounting & CRM Suite with WooCommerce CRM Support
Self-hosted ERP for WordPress with HR, CRM, accounting, and recruitment. Run your business from one dashboard and keep your data yours.
102 database tables
| Table Name | Description | Method |
|---|---|---|
| wp_erp_ac_banks | Stores erp ac banks data created by this plugin. | Static |
| wp_erp_ac_chart_classes | Stores erp ac chart classes data created by this plugin. | Static |
| wp_erp_ac_ledger | Stores erp ac ledger data created by this plugin. | Static |
| wp_erp_ac_payments | Stores erp ac payments data created by this plugin. | Static |
| wp_erp_ac_tax | Stores erp ac tax data created by this plugin. | Static |
| wp_erp_ac_tax_items | Stores erp ac tax items data created by this plugin. | Static |
| wp_erp_ac_transaction_items | Stores erp ac transaction items data created by this plugin. | Static |
| wp_erp_ac_transactions | Stores erp ac transactions data created by this plugin. | Static |
| wp_erp_acct_bill_account_details | Stores erp acct bill account details data created by this plugin. | Static |
| wp_erp_acct_bill_details | Stores erp acct bill details data created by this plugin. | Static |
| wp_erp_acct_bills | Stores erp acct bills data created by this plugin. | Static |
| wp_erp_acct_cash_at_banks | Stores erp acct cash at banks data created by this plugin. | Static |
| wp_erp_acct_chart_of_accounts | Stores erp acct chart of accounts data created by this plugin. | Static |
| wp_erp_acct_currency_info | Stores erp acct currency info data created by this plugin. | Static |
| wp_erp_acct_expense_checks | Stores erp acct expense checks data created by this plugin. | Static |
| wp_erp_acct_expense_details | Stores erp acct expense details data created by this plugin. | Static |
| wp_erp_acct_expenses | Stores erp acct expenses data created by this plugin. | Static |
| wp_erp_acct_financial_years | Stores erp acct financial years data created by this plugin. | Static |
| wp_erp_acct_invoice_account_details | Stores erp acct invoice account details data created by this plugin. | Static |
| wp_erp_acct_invoice_details | Stores erp acct invoice details data created by this plugin. | Static |
| wp_erp_acct_invoice_details_tax | Stores erp acct invoice details tax data created by this plugin. | Static |
| wp_erp_acct_invoice_receipts | Stores erp acct invoice receipts data created by this plugin. | Static |
| wp_erp_acct_invoice_receipts_details | Stores erp acct invoice receipts details data created by this plugin. | Static |
| wp_erp_acct_invoices | Stores erp acct invoices data created by this plugin. | Static |
| wp_erp_acct_journal_details | Stores erp acct journal details data created by this plugin. | Static |
| wp_erp_acct_journals | Stores erp acct journals data created by this plugin. | Static |
| wp_erp_acct_ledger_categories | Stores erp acct ledger categories data created by this plugin. | Static |
| wp_erp_acct_ledger_details | Stores erp acct ledger details data created by this plugin. | Static |
| wp_erp_acct_ledger_settings | Stores erp acct ledger settings data created by this plugin. | Static |
| wp_erp_acct_ledgers | Stores erp acct ledgers data created by this plugin. | Static |
| wp_erp_acct_opening_balances | Stores erp acct opening balances data created by this plugin. | Static |
| wp_erp_acct_pay_bill | Stores erp acct pay bill data created by this plugin. | Static |
| wp_erp_acct_pay_bill_details | Stores erp acct pay bill details data created by this plugin. | Static |
| wp_erp_acct_pay_purchase | Stores erp acct pay purchase data created by this plugin. | Static |
| wp_erp_acct_pay_purchase_details | Stores erp acct pay purchase details data created by this plugin. | Static |
| wp_erp_acct_payment_methods | Stores erp acct payment methods data created by this plugin. | Static |
| wp_erp_acct_people_account_details | Stores erp acct people account details data created by this plugin. | Static |
| wp_erp_acct_people_trn | Stores erp acct people trn data created by this plugin. | Static |
| wp_erp_acct_people_trn_details | Stores erp acct people trn details data created by this plugin. | Static |
| wp_erp_acct_product_categories | Stores product records and related data. | Static |
| wp_erp_acct_product_details | Stores product records and related data. | Static |
| wp_erp_acct_product_types | Stores product records and related data. | Static |
| wp_erp_acct_products | Stores product records and related data. | Static |
| wp_erp_acct_purchase | Stores erp acct purchase data created by this plugin. | Static |
| wp_erp_acct_purchase_account_details | Stores erp acct purchase account details data created by this plugin. | Static |
| wp_erp_acct_purchase_details | Stores erp acct purchase details data created by this plugin. | Static |
| wp_erp_acct_purchase_details_tax | Stores erp acct purchase details tax data created by this plugin. | Static |
| wp_erp_acct_synced_taxes | Stores erp acct synced taxes data created by this plugin. | Static |
| wp_erp_acct_tax_agencies | Stores erp acct tax agencies data created by this plugin. | Static |
| wp_erp_acct_tax_agency_details | Stores erp acct tax agency details data created by this plugin. | Static |
| wp_erp_acct_tax_cat_agency | Stores erp acct tax cat agency data created by this plugin. | Static |
| wp_erp_acct_tax_categories | Stores erp acct tax categories data created by this plugin. | Static |
| wp_erp_acct_tax_pay | Stores erp acct tax pay data created by this plugin. | Static |
| wp_erp_acct_taxes | Stores erp acct taxes data created by this plugin. | Static |
| wp_erp_acct_transfer_voucher | Stores erp acct transfer voucher data created by this plugin. | Static |
| wp_erp_acct_trn_status_types | Stores analytics or statistics data. | Static |
| wp_erp_acct_voucher_no | Stores erp acct voucher no data created by this plugin. | Static |
| wp_erp_audit_log | A logging table that records activity, events, or audit history. | Static |
| wp_erp_company_locations | Stores erp company locations data created by this plugin. | Static |
| wp_erp_crm_activities_task | Stores erp crm activities task data created by this plugin. | Static |
| wp_erp_crm_contact_group | Stores erp crm contact group data created by this plugin. | Static |
| wp_erp_crm_contact_subscriber | Stores erp crm contact subscriber data created by this plugin. | Static |
| wp_erp_crm_customer_activities | Stores erp crm customer activities data created by this plugin. | Static |
| wp_erp_crm_customer_companies | Stores erp crm customer companies data created by this plugin. | Static |
| wp_erp_crm_save_email_replies | Stores erp crm save email replies data created by this plugin. | Static |
| wp_erp_crm_save_search | Stores erp crm save search data created by this plugin. | Static |
| wp_erp_holidays_indv | Stores erp holidays indv data created by this plugin. | Static |
| wp_erp_hr_announcement | Stores erp hr announcement data created by this plugin. | Static |
| wp_erp_hr_dependents | Stores erp hr dependents data created by this plugin. | Static |
| wp_erp_hr_depts | Stores erp hr depts data created by this plugin. | Static |
| wp_erp_hr_designations | Stores erp hr designations data created by this plugin. | Static |
| wp_erp_hr_education | Stores erp hr education data created by this plugin. | Static |
| wp_erp_hr_employee_history | Stores erp hr employee history data created by this plugin. | Static |
| wp_erp_hr_employee_notes | Stores erp hr employee notes data created by this plugin. | Static |
| wp_erp_hr_employee_performance | Stores erp hr employee performance data created by this plugin. | Static |
| wp_erp_hr_employees | Stores erp hr employees data created by this plugin. | Static |
| wp_erp_hr_financial_years | Stores erp hr financial years data created by this plugin. | Static |
| wp_erp_hr_financial_years_new | Stores erp hr financial years new data created by this plugin. | Static |
| wp_erp_hr_holiday | Stores erp hr holiday data created by this plugin. | Static |
| wp_erp_hr_leave_approval_status | Stores analytics or statistics data. | Static |
| wp_erp_hr_leave_approval_status_new | Stores analytics or statistics data. | Static |
| wp_erp_hr_leave_encashment_requests | Stores erp hr leave encashment requests data created by this plugin. | Static |
| wp_erp_hr_leave_encashment_requests_new | Stores erp hr leave encashment requests new data created by this plugin. | Static |
| wp_erp_hr_leave_entitlements | Stores erp hr leave entitlements data created by this plugin. | Static |
| wp_erp_hr_leave_entitlements_new | Stores erp hr leave entitlements new data created by this plugin. | Static |
| wp_erp_hr_leave_policies | Stores erp hr leave policies data created by this plugin. | Static |
| wp_erp_hr_leave_policies_segregation | Stores erp hr leave policies segregation data created by this plugin. | Static |
| wp_erp_hr_leave_policies_segregation_new | Stores erp hr leave policies segregation new data created by this plugin. | Static |
| wp_erp_hr_leave_request_details | Stores erp hr leave request details data created by this plugin. | Static |
| wp_erp_hr_leave_request_details_new | Stores erp hr leave request details new data created by this plugin. | Static |
| wp_erp_hr_leave_requests | Stores erp hr leave requests data created by this plugin. | Static |
| wp_erp_hr_leave_requests_new | Stores erp hr leave requests new data created by this plugin. | Static |
| wp_erp_hr_leaves | Stores erp hr leaves data created by this plugin. | Static |
| wp_erp_hr_leaves_new | Stores erp hr leaves new data created by this plugin. | Static |
| wp_erp_hr_leaves_unpaid | Stores erp hr leaves unpaid data created by this plugin. | Static |
| wp_erp_hr_leaves_unpaid_new | Stores erp hr leaves unpaid new data created by this plugin. | Static |
| wp_erp_hr_work_exp | Stores erp hr work exp data created by this plugin. | Static |
| wp_erp_people_type_relations | Stores erp people type relations data created by this plugin. | Static |
| wp_erp_people_types | Stores erp people types data created by this plugin. | Static |
| wp_erp_peoplemeta | Stores erp peoplemeta data created by this plugin. | Static |
| wp_erp_peoples | Stores erp peoples data created by this plugin. | Static |
| wp_erp_user_leaves | Stores erp user leaves data created by this plugin. | Static |
Core Table Usage
This plugin stores data in WordPress core tables rather than creating its own. These records may become orphaned if the plugin is uninstalled without a proper cleanup routine.
wp_optionsOption key:
blog_charsetOption key:erp-company-fieldsOption key:erp-contact-fieldsOption key:erp-customer-fieldsOption key:erp-employee-fieldsOption key:erp-vendor-fieldsOption key:erp_ac_paymentOption key:erp_ac_th_separatorOption key:erp_acct_new_ledgersOption key:erp_countryOption key:erp_currencyOption key:erp_debug_modeOption key:erp_email_background_colorOption key:erp_email_base_colorOption key:erp_email_body_background_colorOption key:erp_email_settings_approved-leave-requestOption key:erp_email_settings_employee-welcomeOption key:erp_email_settings_govt-holiday-reminderOption key:erp_email_settings_hiring-anniversary-wishOption key:erp_email_settings_new-contact-assignedOption key:erp_email_settings_new-leave-requestOption key:erp_email_settings_new-task-assignedOption key:erp_email_settings_rejected-leave-requestOption key:erp_email_settings_transectional-emailOption key:erp_email_settings_transectional-email-estimateOption key:erp_email_settings_transectional-email-pay-purchaseOption key:erp_email_settings_transectional-email-paymentsOption key:erp_email_settings_transectional-email-purchaseOption key:erp_email_settings_transectional-email-purchase-orderOption key:erp_email_text_colorOption key:erp_gmail_authenticated_emailOption key:erp_modulesOption key:erp_settings_erp-crm_email_connect_gmailOption key:erp_settings_erp-crm_email_connect_imapOption key:erp_settings_erp-crm_subscriptionOption key:erp_settings_erp-email_generalOption key:erp_settings_erp-email_imapOption key:erp_settings_erp-email_mailgunOption key:erp_settings_erp-email_smtpOption key:erp_settings_erp-email_wpmailOption key:erp_settings_erp-integrationOption key:erp_settings_generalOption key:gen_financial_monthOption key:logoOption key:pdf-notice-dismissedOption key:policy_migrate_data_1_6_0Option key:role_based_login_redirectionOption key:wp_erp_db_versionOption key:wp_erp_install_dateOption key:wp_erp_versionOption key:wperp_offer_noticewp_postmetawp_usermeta