{"table_name":"erp_acct_voucher_no","full_table_name":"wp_erp_acct_voucher_no","description":"Stores erp acct voucher no data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"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 );","columns":[{"name":"id","type":"int(11)","nullable":false,"primary_key":true},{"name":"type","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"currency","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"editable","type":"tinyint","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"bill_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"trn_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"trn_date","type":"date","nullable":true,"primary_key":false},{"name":"particulars","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"debit","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"credit","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"trn_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"ledger_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"particulars","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"amount","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"voucher_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"vendor_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"vendor_name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"address","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"trn_date","type":"date","nullable":true,"primary_key":false},{"name":"due_date","type":"date","nullable":true,"primary_key":false},{"name":"ref","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"amount","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"particulars","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"status","type":"int(11)","nullable":true,"primary_key":false},{"name":"attachments","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"slug","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"sign","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"invoice_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"trn_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"trn_date","type":"date","nullable":true,"primary_key":false},{"name":"particulars","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"debit","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"credit","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"trn_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"product_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"qty","type":"int(11)","nullable":true,"primary_key":false},{"name":"unit_price","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"discount","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"tax","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"item_total","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"ecommerce_type","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"voucher_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"customer_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"customer_name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"trn_date","type":"date","nullable":true,"primary_key":false},{"name":"amount","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"particulars","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"attachments","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"status","type":"int(11)","nullable":true,"primary_key":false},{"name":"trn_by","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"trn_by_ledger_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"voucher_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"invoice_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"amount","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"voucher_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"customer_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"customer_name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"trn_date","type":"date","nullable":true,"primary_key":false},{"name":"due_date","type":"date","nullable":true,"primary_key":false},{"name":"billing_address","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"amount","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"discount","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"discount_type","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"tax","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"estimate","type":"boolean","nullable":true,"primary_key":false},{"name":"attachments","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"status","type":"int(11)","nullable":true,"primary_key":false},{"name":"particulars","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"trn_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"ledger_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"particulars","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"debit","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"credit","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"trn_date","type":"date","nullable":true,"primary_key":false},{"name":"ref","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"voucher_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"voucher_amount","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"particulars","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"attachments","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"slug","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"chart_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"parent_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"system","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"ledger_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"trn_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"particulars","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"debit","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"credit","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"trn_date","type":"date","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"ledger_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"short_code","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"chart_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"category_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"slug","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"code","type":"int(11)","nullable":true,"primary_key":false},{"name":"unused","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"system","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"ledger_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"balance","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"voucher_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"trn_date","type":"date","nullable":true,"primary_key":false},{"name":"amount","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"ac_from","type":"int(11)","nullable":true,"primary_key":false},{"name":"ac_to","type":"int(11)","nullable":true,"primary_key":false},{"name":"particulars","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"financial_year_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"chart_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"ledger_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"type","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"debit","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"credit","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"name","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"start_date","type":"date","nullable":true,"primary_key":false},{"name":"end_date","type":"date","nullable":true,"primary_key":false},{"name":"description","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"voucher_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"vendor_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"vendor_name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"trn_date","type":"date","nullable":true,"primary_key":false},{"name":"amount","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"trn_by","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"trn_by_ledger_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"particulars","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"attachments","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"status","type":"int(11)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"voucher_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"bill_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"amount","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"voucher_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"vendor_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"vendor_name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"trn_date","type":"date","nullable":true,"primary_key":false},{"name":"amount","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"trn_by","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"trn_by_ledger_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"particulars","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"attachments","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"status","type":"int(11)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"voucher_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"purchase_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"amount","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"people_id","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"trn_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"trn_date","type":"date","nullable":true,"primary_key":false},{"name":"trn_by","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"voucher_type","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"particulars","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"debit","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"credit","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"people_id","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"voucher_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"amount","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"trn_date","type":"date","nullable":true,"primary_key":false},{"name":"trn_by","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"particulars","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"voucher_type","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"parent","type":"int(11)","nullable":false,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"slug","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"product_type_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"category_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"tax_cat_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"vendor","type":"int(11)","nullable":true,"primary_key":false},{"name":"cost_price","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"sale_price","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"product_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"trn_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"stock_in","type":"int(11)","nullable":true,"primary_key":false},{"name":"stock_out","type":"int(11)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"voucher_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"vendor_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"vendor_name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"trn_date","type":"date","nullable":true,"primary_key":false},{"name":"due_date","type":"date","nullable":true,"primary_key":false},{"name":"amount","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"ref","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"status","type":"int(11)","nullable":true,"primary_key":false},{"name":"purchase_order","type":"boolean","nullable":true,"primary_key":false},{"name":"attachments","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"particulars","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"purchase_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"trn_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"trn_date","type":"date","nullable":true,"primary_key":false},{"name":"particulars","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"debit","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"credit","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"trn_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"product_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"qty","type":"int(11)","nullable":true,"primary_key":false},{"name":"price","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"amount","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"name","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"description","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"tax_rate_name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"tax_number","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"default","type":"boolean","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"tax_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"component_name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"tax_cat_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"agency_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"tax_rate","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"ecommerce_type","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"voucher_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"trn_date","type":"date","nullable":true,"primary_key":false},{"name":"particulars","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"amount","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"voucher_type","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"trn_by","type":"int(11)","nullable":true,"primary_key":false},{"name":"agency_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"ledger_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"agency_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"trn_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"trn_date","type":"date","nullable":true,"primary_key":false},{"name":"particulars","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"debit","type":"decimal(10, 2)","nullable":true,"primary_key":false},{"name":"credit","type":"decimal(10, 2)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"invoice_details_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"agency_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"tax_rate","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"tax_amount","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"type_name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"slug","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"voucher_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"people_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"people_name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"address","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"trn_date","type":"date","nullable":true,"primary_key":false},{"name":"amount","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"ref","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"check_no","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"particulars","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"status","type":"int(11)","nullable":true,"primary_key":false},{"name":"trn_by","type":"int(11)","nullable":true,"primary_key":false},{"name":"trn_by_ledger_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"attachments","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"trn_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"ledger_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"particulars","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"amount","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"trn_no","type":"int(11)","nullable":true,"primary_key":false},{"name":"check_no","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"voucher_type","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"amount","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"bank","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"pay_to","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"created_at","type":"date","nullable":true,"primary_key":false},{"name":"created_by","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"date","nullable":true,"primary_key":false},{"name":"updated_by","type":"varchar(50)","nullable":true,"primary_key":false}],"plugin":{"slug":"erp","name":"ERP: Complete HR, Recruitment, Accounting & CRM Suite with WooCommerce CRM Support","active_installs":5000,"version":"1.17.5","wp_org_url":"https://wordpress.org/plugins/erp/"}}