wp_erp_ac_chart_classes

Column Definitions

CREATE TABLE Statement

CREATE TABLE IF NOT EXISTS `wp_erp_ac_chart_classes` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(100) DEFAULT NULL, PRIMARY KEY (`id`) ) $collate;", "CREATE TABLE IF NOT EXISTS `wp_erp_ac_chart_types` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(60) NOT NULL DEFAULT '', `class_id` tinyint(3) NOT NULL, PRIMARY KEY (`id`), KEY `class_id` (`class_id`) ) $collate;", "CREATE TABLE IF NOT EXISTS `wp_erp_ac_journals` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `ledger_id` int(11) unsigned NOT NULL, `transaction_id` bigint(20) unsigned NOT NULL, `type` varchar(20) DEFAULT NULL, `debit` DECIMAL(13,4) unsigned DEFAULT NULL, `credit` DECIMAL(13,4) unsigned DEFAULT NULL, PRIMARY KEY (`id`), KEY `ledger_id` (`ledger_id`), KEY `transaction_id` (`transaction_id`) ) $collate;", "CREATE TABLE IF NOT EXISTS `wp_erp_ac_ledger` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `code` varchar(10) DEFAULT NULL, `name` varchar(100) DEFAULT NULL, `description` text, `parent` int(11) unsigned NOT NULL DEFAULT '0', `type_id` int(3) unsigned NOT NULL DEFAULT '0', `currency` varchar(10) DEFAULT '', `tax` bigint(20) DEFAULT NULL, `cash_account` tinyint(2) unsigned NOT NULL DEFAULT '0', `reconcile` tinyint(2) unsigned NOT NULL DEFAULT '0', `system` tinyint(2) unsigned NOT NULL DEFAULT '0', `active` tinyint(2) unsigned NOT NULL DEFAULT '1', `created_by` bigint(20) DEFAULT 0, PRIMARY KEY (`id`), KEY `code` (`code`), KEY `type_id` (`type_id`), KEY `parent` (`parent`) ) $collate;", "CREATE TABLE IF NOT EXISTS `wp_erp_ac_banks` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `ledger_id` int(10) unsigned DEFAULT NULL, `account_number` varchar(20) DEFAULT NULL, `bank_name` varchar(30) DEFAULT NULL, PRIMARY KEY (`id`), KEY `ledger_id` (`ledger_id`) ) $collate;", "CREATE TABLE IF NOT EXISTS `wp_erp_ac_transactions` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `type` varchar(10) DEFAULT NULL, `form_type` varchar(20) DEFAULT NULL, `status` varchar(20) DEFAULT NULL, `user_id` bigint(20) unsigned DEFAULT NULL, `billing_address` tinytext, `ref` varchar(50) DEFAULT NULL, `summary` text, `issue_date` date DEFAULT NULL, `due_date` date DEFAULT NULL, `currency` varchar(10) DEFAULT NULL, `conversion_rate` decimal(2,2) unsigned DEFAULT NULL, `sub_total` DECIMAL(13,4) DEFAULT '0.00', `total` DECIMAL(13,4) DEFAULT '0.00', `due` DECIMAL(13,4) unsigned DEFAULT '0.00', `trans_total` DECIMAL(13,4) DEFAULT '0.00', `files` varchar(255) DEFAULT NULL, `parent` bigint(20) unsigned NOT NULL DEFAULT '0', `created_by` int(11) unsigned DEFAULT NULL, `created_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `user_id` (`user_id`), KEY `type` (`type`), KEY `status` (`status`), KEY `issue_date` (`issue_date`) ) $collate;", "CREATE TABLE IF NOT EXISTS `wp_erp_ac_transaction_items` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `transaction_id` bigint(20) unsigned DEFAULT NULL, `journal_id` bigint(20) unsigned DEFAULT NULL, `product_id` int(10) unsigned DEFAULT NULL, `description` text, `qty` tinyint(5) unsigned NOT NULL DEFAULT '1', `unit_price` DECIMAL(13,4) unsigned NOT NULL DEFAULT '0.00', `discount` tinyint(3) unsigned NOT NULL DEFAULT '0', `tax` tinyint(3) unsigned NOT NULL DEFAULT '0', `tax_rate` DECIMAL(13,4) NOT NULL, `tax_journal` BIGINT(20) NOT NULL, `line_total` DECIMAL(13,4) unsigned NOT NULL DEFAULT '0.00', `order` tinyint(3) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `transaction_id` (`transaction_id`), KEY `journal_id` (`journal_id`), KEY `product_id` (`product_id`) ) $collate;", "CREATE TABLE IF NOT EXISTS `wp_erp_ac_payments` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `transaction_id` int(11) NOT NULL, `parent` int(11) NOT NULL, `child` int(11) NOT NULL, PRIMARY KEY (`id`) ) $collate;", "CREATE TABLE IF NOT EXISTS `wp_erp_ac_tax` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `tax_number` varchar(255) DEFAULT NULL, `is_compound` varchar(5) DEFAULT NULL, `created_by` bigint(20) unsigned NOT NULL, PRIMARY KEY (`id`) ) $collate;", "CREATE TABLE IF NOT EXISTS `wp_erp_ac_tax_items` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `tax_id` bigint(20) NOT NULL, `component_name` varchar(255) DEFAULT NULL, `agency_name` varchar(255) DEFAULT NULL, `tax_rate` float NOT NULL, PRIMARY KEY (`id`) ) $collate;", ]; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; foreach ( $table_schema as $table ) { dbDelta( $table );

Safe to delete?

How to remove this table

DROP TABLE IF EXISTS `wp_erp_ac_chart_classes`;

Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.

Other tables from ERP: Complete HR, Recruitment, Accounting & CRM Suite with WooCommerce CRM Support