wp_erp_acct_voucher_no
StaticStores erp acct voucher no data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | int(11) | NO |
| type | varchar(255) | YES |
| currency | varchar(50) | YES |
| editable | tinyint | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| bill_no | int(11) | YES |
| trn_no | int(11) | YES |
| trn_date | date | YES |
| particulars | varchar(255) | YES |
| debit | decimal(20,2) | YES |
| credit | decimal(20,2) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| trn_no | int(11) | YES |
| ledger_id | int(11) | YES |
| particulars | varchar(255) | YES |
| amount | decimal(20,2) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| voucher_no | int(11) | YES |
| vendor_id | int(11) | YES |
| vendor_name | varchar(255) | YES |
| address | varchar(255) | YES |
| trn_date | date | YES |
| due_date | date | YES |
| ref | varchar(255) | YES |
| amount | decimal(20,2) | YES |
| particulars | varchar(255) | YES |
| status | int(11) | YES |
| attachments | varchar(255) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| name | varchar(255) | YES |
| slug | varchar(255) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| name | varchar(255) | YES |
| sign | varchar(255) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| invoice_no | int(11) | YES |
| trn_no | int(11) | YES |
| trn_date | date | YES |
| particulars | varchar(255) | YES |
| debit | decimal(20,2) | YES |
| credit | decimal(20,2) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| trn_no | int(11) | YES |
| product_id | int(11) | YES |
| qty | int(11) | YES |
| unit_price | decimal(20,2) | YES |
| discount | decimal(20,2) | YES |
| tax | decimal(20,2) | YES |
| item_total | decimal(20,2) | YES |
| ecommerce_type | varchar(255) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| voucher_no | int(11) | YES |
| customer_id | int(11) | YES |
| customer_name | varchar(255) | YES |
| trn_date | date | YES |
| amount | decimal(20,2) | YES |
| particulars | varchar(255) | YES |
| attachments | varchar(255) | YES |
| status | int(11) | YES |
| trn_by | varchar(255) | YES |
| trn_by_ledger_id | int(11) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| voucher_no | int(11) | YES |
| invoice_no | int(11) | YES |
| amount | decimal(20,2) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| voucher_no | int(11) | YES |
| customer_id | int(11) | YES |
| customer_name | varchar(255) | YES |
| trn_date | date | YES |
| due_date | date | YES |
| billing_address | varchar(255) | YES |
| amount | decimal(20,2) | YES |
| discount | decimal(20,2) | YES |
| discount_type | varchar(255) | YES |
| tax | decimal(20,2) | YES |
| estimate | boolean | YES |
| attachments | varchar(255) | YES |
| status | int(11) | YES |
| particulars | varchar(255) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| trn_no | int(11) | YES |
| ledger_id | int(11) | YES |
| particulars | varchar(255) | YES |
| debit | decimal(20,2) | YES |
| credit | decimal(20,2) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| trn_date | date | YES |
| ref | varchar(255) | YES |
| voucher_no | int(11) | YES |
| voucher_amount | decimal(20,2) | YES |
| particulars | varchar(255) | YES |
| attachments | varchar(255) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| name | varchar(255) | YES |
| slug | varchar(255) | YES |
| chart_id | int(11) | YES |
| parent_id | int(11) | YES |
| system | tinyint(1) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| ledger_id | int(11) | YES |
| trn_no | int(11) | YES |
| particulars | varchar(255) | YES |
| debit | decimal(20,2) | YES |
| credit | decimal(20,2) | YES |
| trn_date | date | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| ledger_id | int(11) | YES |
| short_code | varchar(255) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| chart_id | int(11) | YES |
| category_id | int(11) | YES |
| name | varchar(255) | YES |
| slug | varchar(255) | YES |
| code | int(11) | YES |
| unused | tinyint(1) | YES |
| system | tinyint(1) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| ledger_id | int(11) | YES |
| name | varchar(255) | YES |
| balance | decimal(20,2) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| voucher_no | int(11) | YES |
| trn_date | date | YES |
| amount | decimal(20,2) | YES |
| ac_from | int(11) | YES |
| ac_to | int(11) | YES |
| particulars | varchar(255) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| financial_year_id | int(11) | YES |
| chart_id | int(11) | YES |
| ledger_id | int(11) | YES |
| type | varchar(50) | YES |
| debit | decimal(20,2) | YES |
| credit | decimal(20,2) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| name | VARCHAR(255) | YES |
| start_date | date | YES |
| end_date | date | YES |
| description | varchar(255) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| voucher_no | int(11) | YES |
| vendor_id | int(11) | YES |
| vendor_name | varchar(255) | YES |
| trn_date | date | YES |
| amount | decimal(20,2) | YES |
| trn_by | varchar(255) | YES |
| trn_by_ledger_id | int(11) | YES |
| particulars | varchar(255) | YES |
| attachments | varchar(255) | YES |
| status | int(11) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| voucher_no | int(11) | YES |
| bill_no | int(11) | YES |
| amount | decimal(20,2) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| voucher_no | int(11) | YES |
| vendor_id | int(11) | YES |
| vendor_name | varchar(255) | YES |
| trn_date | date | YES |
| amount | decimal(20,2) | YES |
| trn_by | varchar(255) | YES |
| trn_by_ledger_id | int(11) | YES |
| particulars | varchar(255) | YES |
| attachments | varchar(255) | YES |
| status | int(11) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| voucher_no | int(11) | YES |
| purchase_no | int(11) | YES |
| amount | decimal(20,2) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| people_id | varchar(255) | YES |
| trn_no | int(11) | YES |
| trn_date | date | YES |
| trn_by | varchar(255) | YES |
| voucher_type | varchar(255) | YES |
| particulars | varchar(255) | YES |
| debit | decimal(20,2) | YES |
| credit | decimal(20,2) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| people_id | varchar(255) | YES |
| voucher_no | int(11) | YES |
| amount | decimal(20,2) | YES |
| trn_date | date | YES |
| trn_by | varchar(255) | YES |
| particulars | varchar(255) | YES |
| voucher_type | varchar(255) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| name | varchar(255) | YES |
| parent | int(11) | NO |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| name | varchar(255) | YES |
| slug | varchar(255) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| name | varchar(255) | YES |
| product_type_id | int(11) | YES |
| category_id | int(11) | YES |
| tax_cat_id | int(11) | YES |
| vendor | int(11) | YES |
| cost_price | decimal(20,2) | YES |
| sale_price | decimal(20,2) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| product_id | int(11) | YES |
| trn_no | int(11) | YES |
| stock_in | int(11) | YES |
| stock_out | int(11) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| voucher_no | int(11) | YES |
| vendor_id | int(11) | YES |
| vendor_name | varchar(255) | YES |
| trn_date | date | YES |
| due_date | date | YES |
| amount | decimal(20,2) | YES |
| ref | varchar(255) | YES |
| status | int(11) | YES |
| purchase_order | boolean | YES |
| attachments | varchar(255) | YES |
| particulars | varchar(255) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| purchase_no | int(11) | YES |
| trn_no | int(11) | YES |
| trn_date | date | YES |
| particulars | varchar(255) | YES |
| debit | decimal(20,2) | YES |
| credit | decimal(20,2) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| trn_no | int(11) | YES |
| product_id | int(11) | YES |
| qty | int(11) | YES |
| price | decimal(20,2) | YES |
| amount | decimal(20,2) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| name | varchar(100) | YES |
| description | varchar(255) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| tax_rate_name | varchar(255) | YES |
| tax_number | varchar(100) | YES |
| default | boolean | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| tax_id | int(11) | YES |
| component_name | varchar(255) | YES |
| tax_cat_id | int(11) | YES |
| agency_id | int(11) | YES |
| tax_rate | decimal(20,2) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| name | varchar(255) | YES |
| ecommerce_type | varchar(255) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| voucher_no | int(11) | YES |
| trn_date | date | YES |
| particulars | varchar(255) | YES |
| amount | decimal(20,2) | YES |
| voucher_type | varchar(255) | YES |
| trn_by | int(11) | YES |
| agency_id | int(11) | YES |
| ledger_id | int(11) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| agency_id | int(11) | YES |
| trn_no | int(11) | YES |
| trn_date | date | YES |
| particulars | varchar(255) | YES |
| debit | decimal(10, 2) | YES |
| credit | decimal(10, 2) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| invoice_details_id | int(11) | YES |
| agency_id | int(11) | YES |
| tax_rate | decimal(20,2) | YES |
| tax_amount | decimal(20,2) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| type_name | varchar(255) | YES |
| slug | varchar(255) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| name | varchar(255) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| voucher_no | int(11) | YES |
| people_id | int(11) | YES |
| people_name | varchar(255) | YES |
| address | varchar(255) | YES |
| trn_date | date | YES |
| amount | decimal(20,2) | YES |
| ref | varchar(255) | YES |
| check_no | varchar(255) | YES |
| particulars | varchar(255) | YES |
| status | int(11) | YES |
| trn_by | int(11) | YES |
| trn_by_ledger_id | int(11) | YES |
| attachments | varchar(255) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| trn_no | int(11) | YES |
| ledger_id | int(11) | YES |
| particulars | varchar(255) | YES |
| amount | decimal(20,2) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
| trn_no | int(11) | YES |
| check_no | varchar(255) | YES |
| voucher_type | varchar(255) | YES |
| amount | decimal(20,2) | YES |
| bank | varchar(255) | YES |
| name | varchar(255) | YES |
| pay_to | varchar(255) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS `wp_erp_acct_voucher_no` ( `id` int(11) NOT NULL AUTO_INCREMENT, `type` varchar(255) DEFAULT NULL, `currency` varchar(50) DEFAULT NULL, `editable` tinyint DEFAULT 0, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;", "CREATE TABLE IF NOT EXISTS `wp_erp_acct_bill_account_details` ( `id` int(11) NOT NULL AUTO_INCREMENT, `bill_no` int(11) DEFAULT NULL, `trn_no` int(11) DEFAULT NULL, `trn_date` date DEFAULT NULL, `particulars` varchar(255) DEFAULT NULL, `debit` decimal(20,2) DEFAULT 0, `credit` decimal(20,2) DEFAULT 0, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;", "CREATE TABLE IF NOT EXISTS `wp_erp_acct_bill_details` ( `id` int(11) NOT NULL AUTO_INCREMENT, `trn_no` int(11) DEFAULT NULL, `ledger_id` int(11) DEFAULT NULL, `particulars` varchar(255) DEFAULT NULL, `amount` decimal(20,2) DEFAULT 0, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;", "CREATE TABLE IF NOT EXISTS `wp_erp_acct_bills` ( `id` int(11) NOT NULL AUTO_INCREMENT, `voucher_no` int(11) DEFAULT NULL, `vendor_id` int(11) DEFAULT NULL, `vendor_name` varchar(255) DEFAULT NULL, `address` varchar(255) DEFAULT NULL, `trn_date` date DEFAULT NULL, `due_date` date DEFAULT NULL, `ref` varchar(255) DEFAULT NULL, `amount` decimal(20,2) DEFAULT 0, `particulars` varchar(255) DEFAULT NULL, `status` int(11) DEFAULT NULL, `attachments` varchar(255) DEFAULT NULL, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;", "CREATE TABLE IF NOT EXISTS `wp_erp_acct_chart_of_accounts` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `slug` varchar(255) DEFAULT NULL, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;", "CREATE TABLE IF NOT EXISTS `wp_erp_acct_currency_info` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `sign` varchar(255) DEFAULT NULL, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate", "CREATE TABLE IF NOT EXISTS `wp_erp_acct_invoice_account_details` ( `id` int(11) NOT NULL AUTO_INCREMENT, `invoice_no` int(11) DEFAULT NULL, `trn_no` int(11) DEFAULT NULL, `trn_date` date DEFAULT NULL, `particulars` varchar(255) DEFAULT NULL, `debit` decimal(20,2) DEFAULT 0, `credit` decimal(20,2) DEFAULT 0, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;", "CREATE TABLE IF NOT EXISTS `wp_erp_acct_invoice_details` ( `id` int(11) NOT NULL AUTO_INCREMENT, `trn_no` int(11) DEFAULT NULL, `product_id` int(11) DEFAULT NULL, `qty` int(11) DEFAULT NULL, `unit_price` decimal(20,2) DEFAULT 0, `discount` decimal(20,2) DEFAULT 0, `tax` decimal(20,2) DEFAULT 0, `item_total` decimal(20,2) DEFAULT 0, `ecommerce_type` varchar(255) DEFAULT NULL, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;", "CREATE TABLE IF NOT EXISTS `wp_erp_acct_invoice_receipts` ( `id` int(11) NOT NULL AUTO_INCREMENT, `voucher_no` int(11) DEFAULT NULL, `customer_id` int(11) DEFAULT NULL, `customer_name` varchar(255) DEFAULT NULL, `trn_date` date DEFAULT NULL, `amount` decimal(20,2) DEFAULT 0, `particulars` varchar(255) DEFAULT NULL, `attachments` varchar(255) DEFAULT NULL, `status` int(11) DEFAULT NULL, `trn_by` varchar(255) DEFAULT NULL, `trn_by_ledger_id` int(11) DEFAULT NULL, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;", "CREATE TABLE IF NOT EXISTS `wp_erp_acct_invoice_receipts_details` ( `id` int(11) NOT NULL AUTO_INCREMENT, `voucher_no` int(11) DEFAULT NULL, `invoice_no` int(11) DEFAULT NULL, `amount` decimal(20,2) DEFAULT 0, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;", "CREATE TABLE IF NOT EXISTS `wp_erp_acct_invoices` ( `id` int(11) NOT NULL AUTO_INCREMENT, `voucher_no` int(11) DEFAULT NULL, `customer_id` int(11) DEFAULT NULL, `customer_name` varchar(255) DEFAULT NULL, `trn_date` date DEFAULT NULL, `due_date` date DEFAULT NULL, `billing_address` varchar(255) DEFAULT NULL, `amount` decimal(20,2) DEFAULT 0, `discount` decimal(20,2) DEFAULT 0, `discount_type` varchar(255) DEFAULT NULL, `tax` decimal(20,2) DEFAULT 0, `estimate` boolean DEFAULT NULL, `attachments` varchar(255) DEFAULT NULL, `status` int(11) DEFAULT NULL, `particulars` varchar(255) DEFAULT NULL, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;", "CREATE TABLE IF NOT EXISTS `wp_erp_acct_journal_details` ( `id` int(11) NOT NULL AUTO_INCREMENT, `trn_no` int(11) DEFAULT NULL, `ledger_id` int(11) DEFAULT NULL, `particulars` varchar(255) DEFAULT NULL, `debit` decimal(20,2) DEFAULT 0, `credit` decimal(20,2) DEFAULT 0, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;", "CREATE TABLE IF NOT EXISTS `wp_erp_acct_journals` ( `id` int(11) NOT NULL AUTO_INCREMENT, `trn_date` date DEFAULT NULL, `ref` varchar(255) DEFAULT NULL, `voucher_no` int(11) DEFAULT NULL, `voucher_amount` decimal(20,2) DEFAULT 0, `particulars` varchar(255) DEFAULT NULL, `attachments` varchar(255) DEFAULT NULL, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;", "CREATE TABLE IF NOT EXISTS `wp_erp_acct_ledger_categories` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `slug` varchar(255) DEFAULT NULL, `chart_id` int(11) DEFAULT NULL, `parent_id` int(11) DEFAULT NULL, `system` tinyint(1) DEFAULT NULL, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;", "CREATE TABLE IF NOT EXISTS `wp_erp_acct_ledger_details` ( `id` int(11) NOT NULL AUTO_INCREMENT, `ledger_id` int(11) DEFAULT NULL, `trn_no` int(11) DEFAULT NULL, `particulars` varchar(255) DEFAULT NULL, `debit` decimal(20,2) DEFAULT 0, `credit` decimal(20,2) DEFAULT 0, `trn_date` date DEFAULT NULL, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;", "CREATE TABLE IF NOT EXISTS `wp_erp_acct_ledger_settings` ( `id` int(11) NOT NULL AUTO_INCREMENT, `ledger_id` int(11) DEFAULT NULL, `short_code` varchar(255) DEFAULT NULL, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;", "CREATE TABLE IF NOT EXISTS `wp_erp_acct_ledgers` ( `id` int(11) NOT NULL AUTO_INCREMENT, `chart_id` int(11) DEFAULT NULL, `category_id` int(11) DEFAULT NULL, `name` varchar(255) DEFAULT NULL, `slug` varchar(255) DEFAULT NULL, `code` int(11) DEFAULT NULL, `unused` tinyint(1) DEFAULT NULL, `system` tinyint(1) DEFAULT NULL, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;", "CREATE TABLE IF NOT EXISTS `wp_erp_acct_cash_at_banks` ( `id` int(11) NOT NULL AUTO_INCREMENT, `ledger_id` int(11) DEFAULT NULL, `name` varchar(255) DEFAULT NULL, `balance` decimal(20,2) DEFAULT 0, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;", "CREATE TABLE IF NOT EXISTS `wp_erp_acct_transfer_voucher` ( `id` int(11) NOT NULL AUTO_INCREMENT, `voucher_no` int(11) DEFAULT NULL, `trn_date` date DEFAULT NULL, `amount` decimal(20,2) DEFAULT 0, `ac_from` int(11) DEFAULT NULL, `ac_to` int(11) DEFAULT NULL, `particulars` varchar(255) DEFAULT NULL, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;", "CREATE TABLE IF NOT EXISTS `wp_erp_acct_opening_balances` ( `id` int(11) NOT NULL AUTO_INCREMENT, `financial_year_id` int(11) DEFAULT NULL, `chart_id` int(11) DEFAULT NULL, `ledger_id` int(11) DEFAULT NULL, `type` varchar(50) DEFAULT NULL, `debit` decimal(20,2) DEFAULT 0, `credit` decimal(20,2) DEFAULT 0, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;", "CREATE TABLE IF NOT EXISTS `wp_erp_acct_financial_years` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` VARCHAR(255) DEFAULT NULL, `start_date` date DEFAULT NULL, `end_date` date DEFAULT NULL, `description` varchar(255) DEFAULT NULL, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;", "CREATE TABLE IF NOT EXISTS `wp_erp_acct_pay_bill` ( `id` int(11) NOT NULL AUTO_INCREMENT, `voucher_no` int(11) DEFAULT NULL, `vendor_id` int(11) DEFAULT NULL, `vendor_name` varchar(255) DEFAULT NULL, `trn_date` date DEFAULT NULL, `amount` decimal(20,2) DEFAULT 0, `trn_by` varchar(255) DEFAULT NULL, `trn_by_ledger_id` int(11) DEFAULT NULL, `particulars` varchar(255) DEFAULT NULL, `attachments` varchar(255) DEFAULT NULL, `status` int(11) DEFAULT NULL, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;", "CREATE TABLE IF NOT EXISTS `wp_erp_acct_pay_bill_details` ( `id` int(11) NOT NULL AUTO_INCREMENT, `voucher_no` int(11) DEFAULT NULL, `bill_no` int(11) DEFAULT NULL, `amount` decimal(20,2) DEFAULT 0, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;", "CREATE TABLE IF NOT EXISTS `wp_erp_acct_pay_purchase` ( `id` int(11) NOT NULL AUTO_INCREMENT, `voucher_no` int(11) DEFAULT NULL, `vendor_id` int(11) DEFAULT NULL, `vendor_name` varchar(255) DEFAULT NULL, `trn_date` date DEFAULT NULL, `amount` decimal(20,2) DEFAULT 0, `trn_by` varchar(255) DEFAULT NULL, `trn_by_ledger_id` int(11) DEFAULT NULL, `particulars` varchar(255) DEFAULT NULL, `attachments` varchar(255) DEFAULT NULL, `status` int(11) DEFAULT NULL, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;", "CREATE TABLE IF NOT EXISTS `wp_erp_acct_pay_purchase_details` ( `id` int(11) NOT NULL AUTO_INCREMENT, `voucher_no` int(11) DEFAULT NULL, `purchase_no` int(11) DEFAULT NULL, `amount` decimal(20,2) DEFAULT 0, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;", "CREATE TABLE IF NOT EXISTS `wp_erp_acct_people_account_details` ( `id` int(11) NOT NULL AUTO_INCREMENT, `people_id` varchar(255) DEFAULT NULL, `trn_no` int(11) DEFAULT NULL, `trn_date` date DEFAULT NULL, `trn_by` varchar(255) DEFAULT NULL, `voucher_type` varchar(255) DEFAULT NULL, `particulars` varchar(255) DEFAULT NULL, `debit` decimal(20,2) DEFAULT 0, `credit` decimal(20,2) DEFAULT 0, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;", "CREATE TABLE IF NOT EXISTS `wp_erp_acct_people_trn` ( `id` int(11) NOT NULL AUTO_INCREMENT, `people_id` varchar(255) DEFAULT NULL, `voucher_no` int(11) DEFAULT NULL, `amount` decimal(20,2) DEFAULT 0, `trn_date` date DEFAULT NULL, `trn_by` varchar(255) DEFAULT NULL, `particulars` varchar(255) DEFAULT NULL, `voucher_type` varchar(255) DEFAULT NULL, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;", "CREATE TABLE IF NOT EXISTS `wp_erp_acct_product_categories` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `parent` int(11) NOT NULL, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;", "CREATE TABLE IF NOT EXISTS `wp_erp_acct_product_types` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `slug` varchar(255) DEFAULT NULL, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;", "CREATE TABLE IF NOT EXISTS `wp_erp_acct_products` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `product_type_id` int(11) DEFAULT NULL, `category_id` int(11) DEFAULT NULL, `tax_cat_id` int(11) DEFAULT NULL, `vendor` int(11) DEFAULT NULL, `cost_price` decimal(20,2) DEFAULT 0, `sale_price` decimal(20,2) DEFAULT 0, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;", "CREATE TABLE IF NOT EXISTS `wp_erp_acct_product_details` ( `id` int(11) NOT NULL AUTO_INCREMENT, `product_id` int(11) DEFAULT NULL, `trn_no` int(11) DEFAULT NULL, `stock_in` int(11) DEFAULT NULL, `stock_out` int(11) DEFAULT NULL, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;", "CREATE TABLE IF NOT EXISTS `wp_erp_acct_purchase` ( `id` int(11) NOT NULL AUTO_INCREMENT, `voucher_no` int(11) DEFAULT NULL, `vendor_id` int(11) DEFAULT NULL, `vendor_name` varchar(255) DEFAULT NULL, `trn_date` date DEFAULT NULL, `due_date` date DEFAULT NULL, `amount` decimal(20,2) DEFAULT 0, `ref` varchar(255) DEFAULT NULL, `status` int(11) DEFAULT NULL, `purchase_order` boolean DEFAULT NULL, `attachments` varchar(255) DEFAULT NULL, `particulars` varchar(255) DEFAULT NULL, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;", "CREATE TABLE IF NOT EXISTS `wp_erp_acct_purchase_account_details` ( `id` int(11) NOT NULL AUTO_INCREMENT, `purchase_no` int(11) DEFAULT NULL, `trn_no` int(11) DEFAULT NULL, `trn_date` date DEFAULT NULL, `particulars` varchar(255) DEFAULT NULL, `debit` decimal(20,2) DEFAULT 0, `credit` decimal(20,2) DEFAULT 0, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;", "CREATE TABLE IF NOT EXISTS `wp_erp_acct_purchase_details` ( `id` int(11) NOT NULL AUTO_INCREMENT, `trn_no` int(11) DEFAULT NULL, `product_id` int(11) DEFAULT NULL, `qty` int(11) DEFAULT NULL, `price` decimal(20,2) DEFAULT 0, `amount` decimal(20,2) DEFAULT 0, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;", "CREATE TABLE IF NOT EXISTS `wp_erp_acct_tax_categories` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(100) DEFAULT NULL, `description` varchar(255) DEFAULT NULL, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;", "CREATE TABLE IF NOT EXISTS `wp_erp_acct_taxes` ( `id` int(11) NOT NULL AUTO_INCREMENT, `tax_rate_name` varchar(255) DEFAULT NULL, `tax_number` varchar(100) DEFAULT NULL, `default` boolean DEFAULT NULL, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;", "CREATE TABLE IF NOT EXISTS `wp_erp_acct_tax_cat_agency` ( `id` int(11) NOT NULL AUTO_INCREMENT, `tax_id` int(11) DEFAULT NULL, `component_name` varchar(255) DEFAULT NULL, `tax_cat_id` int(11) DEFAULT NULL, `agency_id` int(11) DEFAULT NULL, `tax_rate` decimal(20,2) DEFAULT 0, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;", "CREATE TABLE IF NOT EXISTS `wp_erp_acct_tax_agencies` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `ecommerce_type` varchar(255) DEFAULT NULL, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;", "CREATE TABLE IF NOT EXISTS `wp_erp_acct_tax_pay` ( `id` int(11) NOT NULL AUTO_INCREMENT, `voucher_no` int(11) DEFAULT NULL, `trn_date` date DEFAULT NULL, `particulars` varchar(255) DEFAULT NULL, `amount` decimal(20,2) DEFAULT 0, `voucher_type` varchar(255) DEFAULT NULL, `trn_by` int(11) DEFAULT NULL, `agency_id` int(11) DEFAULT NULL, `ledger_id` int(11) DEFAULT NULL, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;", "CREATE TABLE IF NOT EXISTS `wp_erp_acct_tax_agency_details` ( `id` int(11) NOT NULL AUTO_INCREMENT, `agency_id` int(11) DEFAULT NULL, `trn_no` int(11) DEFAULT NULL, `trn_date` date DEFAULT NULL, `particulars` varchar(255) DEFAULT NULL, `debit` decimal(10, 2) DEFAULT 0, `credit` decimal(10, 2) DEFAULT 0, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;", "CREATE TABLE IF NOT EXISTS `wp_erp_acct_invoice_details_tax` ( `id` int(11) NOT NULL AUTO_INCREMENT, `invoice_details_id` int(11) DEFAULT NULL, `agency_id` int(11) DEFAULT NULL, `tax_rate` decimal(20,2) DEFAULT 0, `tax_amount` decimal(20,2) DEFAULT 0, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;", "CREATE TABLE IF NOT EXISTS `wp_erp_acct_trn_status_types` ( `id` int(11) NOT NULL AUTO_INCREMENT, `type_name` varchar(255) DEFAULT NULL, `slug` varchar(255) DEFAULT NULL, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;", "CREATE TABLE IF NOT EXISTS `wp_erp_acct_payment_methods` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;", "CREATE TABLE IF NOT EXISTS `wp_erp_acct_expenses` ( `id` int(11) NOT NULL AUTO_INCREMENT, `voucher_no` int(11) DEFAULT NULL, `people_id` int(11) DEFAULT NULL, `people_name` varchar(255) DEFAULT NULL, `address` varchar(255) DEFAULT NULL, `trn_date` date DEFAULT NULL, `amount` decimal(20,2) DEFAULT 0, `ref` varchar(255) DEFAULT NULL, `check_no` varchar(255) DEFAULT NULL, `particulars` varchar(255) DEFAULT NULL, `status` int(11) DEFAULT NULL, `trn_by` int(11) DEFAULT NULL, `trn_by_ledger_id` int(11) DEFAULT NULL, `attachments` varchar(255) DEFAULT NULL, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;", "CREATE TABLE IF NOT EXISTS `wp_erp_acct_expense_details` ( `id` int(11) NOT NULL AUTO_INCREMENT, `trn_no` int(11) DEFAULT NULL, `ledger_id` int(11) DEFAULT NULL, `particulars` varchar(255) DEFAULT NULL, `amount` decimal(20,2) DEFAULT 0, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;", "CREATE TABLE IF NOT EXISTS `wp_erp_acct_expense_checks` ( `id` int(11) NOT NULL AUTO_INCREMENT, `trn_no` int(11) DEFAULT NULL, `check_no` varchar(255) DEFAULT NULL, `voucher_type` varchar(255) DEFAULT NULL, `amount` decimal(20,2) DEFAULT 0, `bank` varchar(255) DEFAULT NULL, `name` varchar(255) DEFAULT NULL, `pay_to` varchar(255) DEFAULT NULL, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;", ]; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; foreach ( $table_schema as $table ) { dbDelta( $table );Safe to delete?
If you have uninstalled ERP: Complete HR, Recruitment, Accounting & CRM Suite with WooCommerce CRM Support, this table is generally safe to remove. However, always back up your database first.
Note: Some plugins share tables or are dependencies of other plugins. Verify nothing else depends on this table before dropping it.
How to remove this table
DROP TABLE IF EXISTS `wp_erp_acct_voucher_no`;
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