{"table_name":"erp_user_leaves","full_table_name":"wp_erp_user_leaves","description":"Stores erp user leaves data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE `wp_erp_user_leaves` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `user_id` int(11) DEFAULT NULL, `request_id` int(11) DEFAULT NULL, `title` varchar(255) DEFAULT NULL, `date` date DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;\", \"CREATE TABLE `wp_erp_holidays_indv` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `holiday_id` int(11) DEFAULT NULL, `title` varchar(255) DEFAULT NULL, `date` date DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;\", \"CREATE TABLE `wp_erp_hr_holiday` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `title` varchar(200) NOT NULL, `start` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `end` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `description` text NOT NULL, `range_status` varchar(5) NOT NULL, `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL, PRIMARY KEY (`id`) ) $charset_collate;\", \"CREATE TABLE `wp_erp_hr_work_exp` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `employee_id` int(11) DEFAULT NULL, `company_name` varchar(100) DEFAULT NULL, `job_title` varchar(100) DEFAULT NULL, `from` date DEFAULT NULL, `to` date DEFAULT NULL, `description` text, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `employee_id` (`employee_id`) ) $charset_collate;\", \"CREATE TABLE `wp_erp_hr_education` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `employee_id` int(11) unsigned DEFAULT NULL, `school` varchar(100) DEFAULT NULL, `degree` varchar(100) DEFAULT NULL, `field` varchar(100) DEFAULT NULL, `result` varchar(50) DEFAULT NULL, `result_type` enum('grade', 'percentage') DEFAULT NULL, `finished` int(4) unsigned DEFAULT NULL, `notes` text, `interest` text, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `employee_id` (`employee_id`) ) $charset_collate;\", \"CREATE TABLE `wp_erp_hr_dependents` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `employee_id` int(11) DEFAULT NULL, `name` varchar(100) DEFAULT NULL, `relation` varchar(100) DEFAULT NULL, `dob` date DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `employee_id` (`employee_id`) ) $charset_collate;\", \"CREATE TABLE `wp_erp_hr_employee_performance` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `employee_id` int(11) unsigned DEFAULT NULL, `reporting_to` int(11) unsigned DEFAULT NULL, `job_knowledge` varchar(100) DEFAULT NULL, `work_quality` varchar(100) DEFAULT NULL, `attendance` varchar(100) DEFAULT NULL, `communication` varchar(100) DEFAULT NULL, `dependablity` varchar(100) DEFAULT NULL, `reviewer` int(11) unsigned DEFAULT NULL, `comments` text, `completion_date` datetime DEFAULT NULL, `goal_description` text, `employee_assessment` text, `supervisor` int(11) unsigned DEFAULT NULL, `supervisor_assessment` text, `type` text, `performance_date` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `employee_id` (`employee_id`) ) $charset_collate;\", \"CREATE TABLE `wp_erp_hr_announcement` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `user_id` bigint(20) unsigned NOT NULL, `post_id` bigint(11) NOT NULL, `status` varchar(30) NOT NULL, `email_status` varchar(30) NOT NULL, PRIMARY KEY (id), KEY `user_id` (`user_id`), KEY `post_id` (`post_id`), KEY `status` (`status`) ) $charset_collate;\", \"CREATE TABLE `wp_erp_peoples` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `user_id` bigint(20) unsigned DEFAULT '0', `first_name` varchar(60) DEFAULT NULL, `last_name` varchar(60) DEFAULT NULL, `company` varchar(60) DEFAULT NULL, `email` varchar(100) DEFAULT NULL, `phone` varchar(20) DEFAULT NULL, `mobile` varchar(20) DEFAULT NULL, `other` varchar(50) DEFAULT NULL, `website` varchar(100) DEFAULT NULL, `fax` varchar(20) DEFAULT NULL, `notes` text, `street_1` varchar(255) DEFAULT NULL, `street_2` varchar(255) DEFAULT NULL, `city` varchar(80) DEFAULT NULL, `state` varchar(50) DEFAULT NULL, `postal_code` varchar(10) DEFAULT NULL, `country` varchar(20) DEFAULT NULL, `currency` varchar(5) DEFAULT NULL, `life_stage` VARCHAR(100) DEFAULT NULL, `contact_owner` bigint(20) DEFAULT NULL, `hash` VARCHAR(40) DEFAULT NULL, `created_by` BIGINT(20) DEFAULT NULL, `created` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `user_id` (`user_id`), KEY `first_name` (`first_name`), KEY `last_name` (`last_name`), KEY `email` (`email`) ) $charset_collate;\", \"CREATE TABLE `wp_erp_peoplemeta` ( `meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `erp_people_id` bigint(20) DEFAULT NULL, `meta_key` varchar(255) DEFAULT NULL, `meta_value` longtext, PRIMARY KEY (`meta_id`), KEY `erp_people_id` (`erp_people_id`), KEY `meta_key` (`meta_key`(191)) ) $charset_collate;\", \"CREATE TABLE `wp_erp_people_types` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(20) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) ) $charset_collate;\", \"CREATE TABLE `wp_erp_people_type_relations` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `people_id` bigint(20) unsigned DEFAULT NULL, `people_types_id` int(11) unsigned DEFAULT NULL, `deleted_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `people_id` (`people_id`), KEY `people_types_id` (`people_types_id`) ) $charset_collate;\", \"CREATE TABLE `wp_erp_audit_log` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `component` varchar(50) NOT NULL DEFAULT '', `sub_component` varchar(50) NOT NULL DEFAULT '', `data_id` bigint(20) DEFAULT NULL, `old_value` longtext, `new_value` longtext, `message` longtext, `changetype` varchar(10) DEFAULT NULL, `created_by` bigint(20) unsigned DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `component` (`component`), KEY `sub_component` (`sub_component`), KEY `changetype` (`changetype`), KEY `created_by` (`created_by`) ) $charset_collate;\", \"CREATE TABLE `wp_erp_crm_customer_companies` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `customer_id` bigint(20) DEFAULT NULL, `company_id` bigint(50) DEFAULT NULL, PRIMARY KEY (`id`), KEY `customer_id` (`customer_id`), KEY `company_id` (`company_id`) ) $charset_collate;\", \"CREATE TABLE wp_erp_crm_customer_activities ( id int(11) unsigned NOT NULL AUTO_INCREMENT, `user_id` int(11) DEFAULT NULL, `type` varchar(255) DEFAULT NULL, `message` longtext, email_subject text, log_type varchar(255) DEFAULT NULL, `start_date` datetime DEFAULT NULL, end_date datetime DEFAULT NULL, created_by int(11) DEFAULT NULL, extra longtext, sent_notification tinyint(4) DEFAULT '0', done_at datetime DEFAULT NULL, created_at datetime DEFAULT NULL, updated_at datetime DEFAULT NULL, PRIMARY KEY (id), KEY `user_id` (`user_id`), KEY `type` (`type`), KEY log_type (log_type), KEY created_by (created_by) ) $charset_collate;\", \"CREATE TABLE `wp_erp_crm_activities_task` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `activity_id` int(11) DEFAULT NULL, `user_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`), KEY `activity_id` (`activity_id`), KEY `user_id` (`user_id`) ) $charset_collate;\", \"CREATE TABLE `wp_erp_crm_contact_group` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `description` text, `private` TINYINT(1) DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;\", \"CREATE TABLE `wp_erp_crm_contact_subscriber` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `user_id` int(11) DEFAULT NULL, `group_id` int(11) DEFAULT NULL, `status` varchar(25) DEFAULT NULL, `subscribe_at` datetime DEFAULT NULL, `unsubscribe_at` datetime DEFAULT NULL, `hash` VARCHAR(40) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `user_group` (`user_id`,`group_id`), KEY `status` (`status`), KEY `hash` (`hash`) ) $charset_collate;\", \"CREATE TABLE `wp_erp_crm_save_search` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `user_id` int(11) DEFAULT NULL, `type` VARCHAR(255) DEFAULT NULL, `global` tinyint(4) DEFAULT '0', `search_name` text, `search_val` text, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;\", \"CREATE TABLE `wp_erp_crm_save_email_replies` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` text, `subject` text, `template` longtext, PRIMARY KEY (`id`) ) $charset_collate;\", \"CREATE TABLE `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 `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 `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 `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 `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 `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 `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 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 decimal(10,2) DEFAULT NULL, unit_price decimal(20,2) DEFAULT 0, discount decimal(20,2) DEFAULT 0, shipping decimal(20,2) DEFAULT 0, tax decimal(20,2) DEFAULT 0, tax_cat_id int(11) DEFAULT NULL, 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 `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, `transaction_charge` decimal(20,2) DEFAULT 0, `ref` varchar(255) DEFAULT NULL, `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 `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 `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, `shipping` decimal(20,2) DEFAULT 0, `shipping_tax` decimal(20,2) DEFAULT 0, `tax` decimal(20,2) DEFAULT 0, `tax_zone_id` int(11) DEFAULT NULL, `estimate` boolean DEFAULT NULL, `attachments` varchar(255) DEFAULT NULL, `status` int(11) DEFAULT NULL, `particulars` varchar(255) DEFAULT NULL, `additional_notes` TEXT NULL 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 `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 `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 `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 `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 `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 `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 `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 `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 NULL, 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 `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 `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 `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, ref 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 `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 `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, transaction_charge decimal(20,2) DEFAULT 0, ref 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 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, tax_cat_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 `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 `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 `wp_erp_acct_people_trn_details` ( id int(11) NOT NULL AUTO_INCREMENT, people_id varchar(255) DEFAULT NULL, voucher_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 `wp_erp_acct_product_categories` ( id int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, parent int(11) NOT NULL 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 `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 `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 `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 `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, billing_address varchar(255) DEFAULT NULL, trn_date date DEFAULT NULL, due_date date DEFAULT NULL, amount decimal(20,2) DEFAULT 0, tax decimal(20,2) DEFAULT NULL , tax_zone_id integer DEFAULT NULL, 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 `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 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 decimal(10,2) DEFAULT NULL, price decimal(20,2) DEFAULT 0, amount decimal(20,2) DEFAULT 0, tax decimal(20,2) DEFAULT NULL, tax_cat_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 wp_erp_acct_purchase_details_tax ( id int(20) UNSIGNED NOT NULL AUTO_INCREMENT, invoice_details_id int(20) NOT NULL, agency_id int(20) DEFAULT NULL, tax_rate decimal(20,2) NOT NULL, created_at datetime DEFAULT NULL, created_by int(20) DEFAULT NULL, updated_at datetime DEFAULT NULL, updated_by int(20) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;\", \"CREATE TABLE `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 `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 `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 `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 `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 `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(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 `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 `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 wp_erp_acct_synced_taxes ( id int NOT NULL AUTO_INCREMENT, system_id bigint NOT NULL, sync_id bigint DEFAULT NULL, sync_slug varchar(100) DEFAULT NULL, sync_type varchar(100) DEFAULT NULL, sync_source varchar(100) DEFAULT NULL, PRIMARY KEY (id), KEY system_id (system_id), KEY sync_id (sync_id), KEY sync_slug (sync_slug), KEY sync_type (sync_type), KEY sync_source (sync_source) ) $charset_collate;\", \"CREATE TABLE `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 `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, transaction_charge decimal(20,2) DEFAULT 0, 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 `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 `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 ) { $erp_table_created = dbDelta( $table );","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"user_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"request_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"title","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"date","type":"date","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":true,"primary_key":false},{"name":"holiday_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"title","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"date","type":"date","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":true,"primary_key":false},{"name":"title","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"start","type":"timestamp","nullable":false,"primary_key":false},{"name":"end","type":"timestamp","nullable":false,"primary_key":false},{"name":"description","type":"text","nullable":false,"primary_key":false},{"name":"range_status","type":"varchar(5)","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":false,"primary_key":false},{"name":"employee_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"company_name","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"job_title","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"from","type":"date","nullable":true,"primary_key":false},{"name":"to","type":"date","nullable":true,"primary_key":false},{"name":"description","type":"text","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":true,"primary_key":false},{"name":"employee_id","type":"int(11) unsigned","nullable":true,"primary_key":false},{"name":"school","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"degree","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"field","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"result","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"result_type","type":"enum('grade', 'percentage')","nullable":true,"primary_key":false},{"name":"finished","type":"int(4) unsigned","nullable":true,"primary_key":false},{"name":"notes","type":"text","nullable":true,"primary_key":false},{"name":"interest","type":"text","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":true,"primary_key":false},{"name":"employee_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"name","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"relation","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"dob","type":"date","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":true,"primary_key":false},{"name":"employee_id","type":"int(11) unsigned","nullable":true,"primary_key":false},{"name":"reporting_to","type":"int(11) unsigned","nullable":true,"primary_key":false},{"name":"job_knowledge","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"work_quality","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"attendance","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"communication","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"dependablity","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"reviewer","type":"int(11) unsigned","nullable":true,"primary_key":false},{"name":"comments","type":"text","nullable":true,"primary_key":false},{"name":"completion_date","type":"datetime","nullable":true,"primary_key":false},{"name":"goal_description","type":"text","nullable":true,"primary_key":false},{"name":"employee_assessment","type":"text","nullable":true,"primary_key":false},{"name":"supervisor","type":"int(11) unsigned","nullable":true,"primary_key":false},{"name":"supervisor_assessment","type":"text","nullable":true,"primary_key":false},{"name":"type","type":"text","nullable":true,"primary_key":false},{"name":"performance_date","type":"datetime","nullable":true,"primary_key":false},{"name":"user_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"post_id","type":"bigint(11)","nullable":false,"primary_key":false},{"name":"status","type":"varchar(30)","nullable":false,"primary_key":false},{"name":"email_status","type":"varchar(30)","nullable":false,"primary_key":false},{"name":"user_id","type":"bigint(20) unsigned","nullable":true,"primary_key":false},{"name":"first_name","type":"varchar(60)","nullable":true,"primary_key":false},{"name":"last_name","type":"varchar(60)","nullable":true,"primary_key":false},{"name":"company","type":"varchar(60)","nullable":true,"primary_key":false},{"name":"email","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"phone","type":"varchar(20)","nullable":true,"primary_key":false},{"name":"mobile","type":"varchar(20)","nullable":true,"primary_key":false},{"name":"other","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"website","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"fax","type":"varchar(20)","nullable":true,"primary_key":false},{"name":"notes","type":"text","nullable":true,"primary_key":false},{"name":"street_1","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"street_2","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"city","type":"varchar(80)","nullable":true,"primary_key":false},{"name":"state","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"postal_code","type":"varchar(10)","nullable":true,"primary_key":false},{"name":"country","type":"varchar(20)","nullable":true,"primary_key":false},{"name":"currency","type":"varchar(5)","nullable":true,"primary_key":false},{"name":"life_stage","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"contact_owner","type":"bigint(20)","nullable":true,"primary_key":false},{"name":"hash","type":"VARCHAR(40)","nullable":true,"primary_key":false},{"name":"created_by","type":"BIGINT(20)","nullable":true,"primary_key":false},{"name":"created","type":"datetime","nullable":true,"primary_key":false},{"name":"erp_people_id","type":"bigint(20)","nullable":true,"primary_key":false},{"name":"meta_key","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"meta_value","type":"longtext","nullable":true,"primary_key":false},{"name":"name","type":"varchar(20)","nullable":true,"primary_key":false},{"name":"people_id","type":"bigint(20) unsigned","nullable":true,"primary_key":false},{"name":"people_types_id","type":"int(11) unsigned","nullable":true,"primary_key":false},{"name":"deleted_at","type":"datetime","nullable":true,"primary_key":false},{"name":"component","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"sub_component","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"data_id","type":"bigint(20)","nullable":true,"primary_key":false},{"name":"old_value","type":"longtext","nullable":true,"primary_key":false},{"name":"new_value","type":"longtext","nullable":true,"primary_key":false},{"name":"message","type":"longtext","nullable":true,"primary_key":false},{"name":"changetype","type":"varchar(10)","nullable":true,"primary_key":false},{"name":"created_by","type":"bigint(20) unsigned","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":true,"primary_key":false},{"name":"customer_id","type":"bigint(20)","nullable":true,"primary_key":false},{"name":"company_id","type":"bigint(50)","nullable":true,"primary_key":false},{"name":"user_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"type","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"message","type":"longtext","nullable":true,"primary_key":false},{"name":"email_subject","type":"text","nullable":true,"primary_key":false},{"name":"log_type","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"start_date","type":"datetime","nullable":true,"primary_key":false},{"name":"end_date","type":"datetime","nullable":true,"primary_key":false},{"name":"created_by","type":"int(11)","nullable":true,"primary_key":false},{"name":"extra","type":"longtext","nullable":true,"primary_key":false},{"name":"sent_notification","type":"tinyint(4)","nullable":true,"primary_key":false},{"name":"done_at","type":"datetime","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":true,"primary_key":false},{"name":"activity_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"user_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"description","type":"text","nullable":true,"primary_key":false},{"name":"private","type":"TINYINT(1)","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":true,"primary_key":false},{"name":"user_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"group_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"status","type":"varchar(25)","nullable":true,"primary_key":false},{"name":"subscribe_at","type":"datetime","nullable":true,"primary_key":false},{"name":"unsubscribe_at","type":"datetime","nullable":true,"primary_key":false},{"name":"hash","type":"VARCHAR(40)","nullable":true,"primary_key":false},{"name":"user_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"type","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"global","type":"tinyint(4)","nullable":true,"primary_key":false},{"name":"search_name","type":"text","nullable":true,"primary_key":false},{"name":"search_val","type":"text","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":true,"primary_key":false},{"name":"name","type":"text","nullable":true,"primary_key":false},{"name":"subject","type":"text","nullable":true,"primary_key":false},{"name":"template","type":"longtext","nullable":true,"primary_key":false},{"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":"decimal(10,2)","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":"shipping","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"tax","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"tax_cat_id","type":"int(11)","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":"transaction_charge","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"ref","type":"varchar(255)","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":"shipping","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"shipping_tax","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"tax","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"tax_zone_id","type":"int(11)","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":"additional_notes","type":"TEXT","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":"ref","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":"transaction_charge","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"ref","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":"tax_cat_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":"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":"people_id","type":"varchar(255)","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":"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":"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":"billing_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":"amount","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"tax","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"tax_zone_id","type":"integer","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":"decimal(10,2)","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":"tax","type":"decimal(20,2)","nullable":true,"primary_key":false},{"name":"tax_cat_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":"invoice_details_id","type":"int(20)","nullable":false,"primary_key":false},{"name":"agency_id","type":"int(20)","nullable":true,"primary_key":false},{"name":"tax_rate","type":"decimal(20,2)","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false},{"name":"created_by","type":"int(20)","nullable":true,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":true,"primary_key":false},{"name":"updated_by","type":"int(20)","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(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":"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":"system_id","type":"bigint","nullable":false,"primary_key":false},{"name":"sync_id","type":"bigint","nullable":true,"primary_key":false},{"name":"sync_slug","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"sync_type","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"sync_source","type":"varchar(100)","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":"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":"transaction_charge","type":"decimal(20,2)","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":"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/"}}