text: -- phpMyAdmin SQL Dump
  -- version 4.4.14
  -- http://www.phpmyadmin.net
  --
  -- Host: 127.0.0.1
  -- Generation Time: May 09, 2017 at 01:43 PM
  -- Server version: 5.6.26
  -- PHP Version: 5.5.28
  
  SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  SET time_zone = "+00:00";
  
  
  /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  /*!40101 SET NAMES utf8mb4 */;
  
  --
  -- Database: `iclouderp_v3_4`
  --
  TRUNCATE `erp_account_settings`;
  TRUNCATE `erp_adjustments`;
  TRUNCATE `erp_bom`;
  TRUNCATE `erp_bom_items`;
  TRUNCATE `erp_brands`;
  TRUNCATE `erp_calendar`;
  TRUNCATE `erp_captcha`;
  TRUNCATE `erp_categories`;
  TRUNCATE `erp_combine_items`;
  TRUNCATE `erp_combo_items`;
  TRUNCATE `erp_companies`;
  TRUNCATE `erp_condition_tax`;
  TRUNCATE `erp_convert`;
  TRUNCATE `erp_convert_items`;
  TRUNCATE `erp_costing`;
  TRUNCATE `erp_currencies`;
  TRUNCATE `erp_customer_groups`;
  TRUNCATE `erp_date_format`;
  TRUNCATE `erp_deliveries`;
  TRUNCATE `erp_delivery_items`;
  TRUNCATE `erp_deposits`;
  TRUNCATE `erp_documents`;
  TRUNCATE `erp_document_photos`;
  TRUNCATE `erp_employee_salary_tax`;
  TRUNCATE `erp_employee_salary_tax_small_taxpayers`;
  TRUNCATE `erp_employee_salary_tax_small_taxpayers_trigger`;
  TRUNCATE `erp_employee_salary_tax_trigger`;
  TRUNCATE `erp_employee_type`;
  TRUNCATE `erp_enter_using_stock`;
  TRUNCATE `erp_enter_using_stock_items`;
  TRUNCATE `erp_expenses`;
  TRUNCATE `erp_expenses_audit`;
  TRUNCATE `erp_expense_categories`;
  TRUNCATE `erp_gift_cards`;
  TRUNCATE `erp_gift_cards_audit`;
  TRUNCATE `erp_gl_charts`;
  TRUNCATE `erp_gl_charts_tax`;
  TRUNCATE `erp_gl_sections`;
  TRUNCATE `erp_gl_trans`;
  TRUNCATE `erp_gl_trans_audit`;
  TRUNCATE `erp_groups`;
  TRUNCATE `erp_group_areas`;
  TRUNCATE `erp_inventory_valuation_details`;
  TRUNCATE `erp_loans`;
  TRUNCATE `erp_login_attempts`;
  TRUNCATE `erp_marchine`;
  TRUNCATE `erp_marchine_logs`;
  TRUNCATE `erp_migrations`;
  TRUNCATE `erp_notifications`;
  TRUNCATE `erp_order_ref`;
  TRUNCATE `erp_pack_lists`;
  TRUNCATE `erp_payments`;
  TRUNCATE `erp_payments_audit`;
  TRUNCATE `erp_payment_term`;
  TRUNCATE `erp_paypal`;
  TRUNCATE `erp_permissions`;
  TRUNCATE `erp_pos_register`;
  TRUNCATE `erp_pos_settings`;
  TRUNCATE `erp_price_groups`;
  TRUNCATE `erp_products`;
  TRUNCATE `erp_product_note`;
  TRUNCATE `erp_product_photos`;
  TRUNCATE `erp_product_prices`;
  TRUNCATE `erp_product_variants`;
  TRUNCATE `erp_purchases`;
  TRUNCATE `erp_purchases_audit`;
  TRUNCATE `erp_purchases_order`;
  TRUNCATE `erp_purchases_order_audit`;
  TRUNCATE `erp_purchases_request`;
  TRUNCATE `erp_purchase_items`;
  TRUNCATE `erp_purchase_items_audit`;
  TRUNCATE `erp_purchase_order_items`;
  TRUNCATE `erp_purchase_request_items`;
  TRUNCATE `erp_purchase_tax`;
  TRUNCATE `erp_purchasing_taxes`;
  TRUNCATE `erp_quotes`;
  TRUNCATE `erp_quote_items`;
  TRUNCATE `erp_recieved_transfers`;
  TRUNCATE `erp_recieved_transfer_items`;
  TRUNCATE `erp_related_products`;
  TRUNCATE `erp_return_items`;
  TRUNCATE `erp_return_purchases`;
  TRUNCATE `erp_return_purchase_items`;
  TRUNCATE `erp_return_sales`;
  TRUNCATE `erp_return_tax_back`;
  TRUNCATE `erp_return_tax_front`;
  TRUNCATE `erp_return_value_added_tax`;
  TRUNCATE `erp_return_value_added_tax_back`;
  TRUNCATE `erp_return_withholding_tax`;
  TRUNCATE `erp_return_withholding_tax_back`;
  TRUNCATE `erp_return_withholding_tax_front`;
  TRUNCATE `erp_revenues`;
  TRUNCATE `erp_salary_tax`;
  TRUNCATE `erp_salary_tax_back`;
  TRUNCATE `erp_salary_tax_front`;
  TRUNCATE `erp_sales`;
  TRUNCATE `erp_sales_audit`;
  TRUNCATE `erp_sales_types`;
  TRUNCATE `erp_sale_areas`;
  TRUNCATE `erp_sale_dev_items`;
  TRUNCATE `erp_sale_dev_items_audit`;
  TRUNCATE `erp_sale_items`;
  TRUNCATE `erp_sale_items_audit`;
  TRUNCATE `erp_sale_order`;
  TRUNCATE `erp_sale_order_audit`;
  TRUNCATE `erp_sale_order_items`;
  TRUNCATE `erp_sale_order_items_audit`;
  TRUNCATE `erp_sale_tax`;
  TRUNCATE `erp_serial`;
  TRUNCATE `erp_sessions`;
  TRUNCATE `erp_settings`;
  TRUNCATE `erp_skrill`;
  TRUNCATE `erp_stock_counts`;
  TRUNCATE `erp_stock_count_items`;
  TRUNCATE `erp_subcategories`;
  TRUNCATE `erp_suspended`;
  TRUNCATE `erp_suspended_bills`;
  TRUNCATE `erp_suspended_items`;
  TRUNCATE `erp_suspend_layout`;
  TRUNCATE `erp_taxation_type_of_account`;
  TRUNCATE `erp_taxation_type_of_product`;
  TRUNCATE `erp_tax_exchange_rate`;
  TRUNCATE `erp_tax_purchase_vat`;
  TRUNCATE `erp_tax_rates`;
  TRUNCATE `erp_transfers`;
  TRUNCATE `erp_transfer_items`;
  TRUNCATE `erp_units`;
  TRUNCATE `erp_users`;
  TRUNCATE `erp_user_logins`;
  TRUNCATE `erp_variants`;
  TRUNCATE `erp_warehouses`;
  TRUNCATE `erp_warehouses_products`;
  TRUNCATE `erp_warehouses_products_variants`;
  
  --
  -- Dumping data for table `erp_companies`
  --
  
  INSERT INTO `erp_companies` (`id`, `code`, `group_id`, `group_name`, `customer_group_id`, `customer_group_name`, `price_group_id`, `name`, `company`, `company_kh`, `name_kh`, `vat_no`, `group_areas_id`, `address`, `address_kh`, `sale_man`, `city`, `state`, `postal_code`, `country`, `contact_person`, `phone`, `email`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `invoice_footer`, `payment_term`, `logo`, `award_points`, `deposit_amount`, `status`, `posta_card`, `gender`, `attachment`, `date_of_birth`, `start_date`, `end_date`, `credit_limited`, `business_activity`, `group`, `village`, `street`, `sangkat`, `district`, `period`, `amount`) VALUES(1, 'COM1', NULL, 'biller', NULL, NULL, NULL, 'ABC Company', 'ABC Company', NULL, NULL, '12346756892', NULL, 'PP', NULL, NULL, 'phnom penh', '', NULL, 'Cambodia', 'owner', '012334345', 'iclouderp@gmail.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'logo.png', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
  INSERT INTO `erp_companies` (`id`, `code`, `group_id`, `group_name`, `customer_group_id`, `customer_group_name`, `price_group_id`, `name`, `company`, `company_kh`, `name_kh`, `vat_no`, `group_areas_id`, `address`, `address_kh`, `sale_man`, `city`, `state`, `postal_code`, `country`, `contact_person`, `phone`, `email`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `invoice_footer`, `payment_term`, `logo`, `award_points`, `deposit_amount`, `status`, `posta_card`, `gender`, `attachment`, `date_of_birth`, `start_date`, `end_date`, `credit_limited`, `business_activity`, `group`, `village`, `street`, `sangkat`, `district`, `period`, `amount`) VALUES(2, 'CUS01', 3, 'customer', 1, '', NULL, 'General Customer', 'General Customer', NULL, 'អតិថិជន', '22323452345', 0, 'PP', NULL, NULL, 'phnom penh', '', NULL, 'Cambodia', 'owner', '012334345', 'iclouderp@gmail.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'logo.png', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
  INSERT INTO `erp_companies` (`id`, `code`, `group_id`, `group_name`, `customer_group_id`, `customer_group_name`, `price_group_id`, `name`, `company`, `company_kh`, `name_kh`, `vat_no`, `group_areas_id`, `address`, `address_kh`, `sale_man`, `city`, `state`, `postal_code`, `country`, `contact_person`, `phone`, `email`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `invoice_footer`, `payment_term`, `logo`, `award_points`, `deposit_amount`, `status`, `posta_card`, `gender`, `attachment`, `date_of_birth`, `start_date`, `end_date`, `credit_limited`, `business_activity`, `group`, `village`, `street`, `sangkat`, `district`, `period`, `amount`) VALUES(3, 'SUP01', 4, 'supplier', NULL, '', NULL, 'General Supplier', 'General Supplier', NULL, NULL, '13241436245', NULL, 'pp', NULL, NULL, 'phnom penh', '', NULL, 'Cambodia', 'owner', '012334345', 'iclouderp@gmail.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'logo.png', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
  
  --
  -- Dumping data for table `erp_currencies`
  --
  
  INSERT INTO `erp_currencies` (`id`, `code`, `name`, `in_out`, `rate`, `auto_update`) VALUES(1, 'USD', 'US Dollar', 1, '1.0000', 0);
  INSERT INTO `erp_currencies` (`id`, `code`, `name`, `in_out`, `rate`, `auto_update`) VALUES(2, 'KHM', 'Riel In', 1, '4000.0000', 0);
  INSERT INTO `erp_currencies` (`id`, `code`, `name`, `in_out`, `rate`, `auto_update`) VALUES(3, 'KHM_o', 'Riel Out', 0, '4050.0000', 0);
  
  
  --
  -- Dumping data for table `erp_customer_groups`
  --
  
  INSERT INTO `erp_customer_groups` (`id`, `name`, `percent`, `makeup_cost`) VALUES(1, 'General', 0, 0);
  INSERT INTO `erp_customer_groups` (`id`, `name`, `percent`, `makeup_cost`) VALUES(2, 'Reseller', -5, 0);
  INSERT INTO `erp_customer_groups` (`id`, `name`, `percent`, `makeup_cost`) VALUES(3, 'Distributor', -15, 0);
  INSERT INTO `erp_customer_groups` (`id`, `name`, `percent`, `makeup_cost`) VALUES(4, 'New Customer (+10)', 10, 0);
  INSERT INTO `erp_customer_groups` (`id`, `name`, `percent`, `makeup_cost`) VALUES(5, 'Makeup (+10)', 10, 1);
  
  --
  -- Dumping data for table `erp_date_format`
  --
  
  INSERT INTO `erp_date_format` (`id`, `js`, `php`, `sql`) VALUES(1, 'mm-dd-yyyy', 'm-d-Y', '%m-%d-%Y');
  INSERT INTO `erp_date_format` (`id`, `js`, `php`, `sql`) VALUES(2, 'mm/dd/yyyy', 'm/d/Y', '%m/%d/%Y');
  INSERT INTO `erp_date_format` (`id`, `js`, `php`, `sql`) VALUES(3, 'mm.dd.yyyy', 'm.d.Y', '%m.%d.%Y');
  INSERT INTO `erp_date_format` (`id`, `js`, `php`, `sql`) VALUES(4, 'dd-mm-yyyy', 'd-m-Y', '%d-%m-%Y');
  INSERT INTO `erp_date_format` (`id`, `js`, `php`, `sql`) VALUES(5, 'dd/mm/yyyy', 'd/m/Y', '%d/%m/%Y');
  INSERT INTO `erp_date_format` (`id`, `js`, `php`, `sql`) VALUES(6, 'dd.mm.yyyy', 'd.m.Y', '%d.%m.%Y');
  INSERT INTO `erp_date_format` (`id`, `js`, `php`, `sql`) VALUES(7, 'yyyy-mm-dd', 'Y-m-d', '%Y-%m-%d');
  
  --
  -- Dumping data for table `erp_gl_charts`
  --
  
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(100100, 'Cash', 100100, 10, 0, 0, '', 1, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(100101, 'Petty Cash', 100100, 10, 0, 0, '', 1, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(100102, 'Cash on Hand', 100100, 10, 0, 0, '', 1, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(100103, 'ANZ Bank', 100100, 10, 0, 0, '', 1, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(100104, 'Wing Account', 100100, 10, 0, 0, '', 1, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(100105, 'Visa', 100100, 10, 0, 0, '', 1, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(100106, 'Chequing Bank Account', 100100, 10, 0, 0, '', 1, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(100200, 'Account Receivable', 0, 10, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(100400, 'Other Current Assets', 0, 10, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(100410, 'Prepaid Expense', 100400, 10, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(100420, 'Supplier Deposit', 100400, 10, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(100430, 'Inventory', 100400, 10, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(100440, 'Deferred Tax Asset', 100400, 10, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(100441, 'VAT Input', 100440, 10, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(100442, 'VAT Credit Carried Forward', 100440, 10, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(100500, 'Cash Advance', 100400, 10, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(100501, 'Loan to Related Parties', 100400, 10, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(100502, 'Staff Advance Cash', 100400, 10, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(101005, 'Own Invest', 0, 80, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(110200, 'Property, Plant and Equipment', 0, 11, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(110201, 'Furniture', 110200, 11, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(110202, 'Office Equipment', 110200, 11, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(110203, 'Machineries', 110200, 11, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(110204, 'Leasehold Improvement', 110200, 11, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(110205, 'IT Equipment & Computer', 110200, 11, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(110206, 'Vehicle', 110200, 11, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(110250, 'Less Total Accumulated Depreciation', 110200, 11, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(110251, 'Less Acc. Dep. of Furniture', 110250, 11, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(110252, 'Less Acc. Dep. of Office Equipment', 110250, 11, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(110253, 'Less Acc. Dep. of Machineries', 110250, 11, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(110254, 'Less Acc. Dep. of Leasehold Improvement', 110250, 11, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(110255, 'Less Acc. Dep. of IT Equipment & Computer', 110250, 11, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(110256, 'Less Acc. Dep of Vehicle', 110250, 11, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(201100, 'Accounts Payable', 0, 20, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(201200, 'Other Current Liabilities', 0, 20, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(201201, 'Salary Payable', 201200, 20, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(201202, 'OT Payable', 201200, 20, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(201203, 'Allowance Payable', 201200, 20, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(201204, 'Bonus Payable', 201200, 20, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(201205, 'Commission Payable', 201200, 20, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(201206, 'Interest Payable', 201200, 20, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(201207, 'Loan from Related Parties', 201200, 20, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(201208, 'Customer Deposit', 201200, 20, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(201209, 'Accrued Expense', 201200, 20, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(201400, 'Deferred Tax Liabilities', 0, 20, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(201401, 'Salary Tax Payable', 201400, 20, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(201402, 'Withholding Tax Payable', 201400, 20, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(201403, 'VAT Payable', 201400, 20, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(201404, 'Profit Tax Payable', 201400, 20, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(201405, 'Prepayment Profit Tax Payable', 201400, 20, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(201406, 'Fringe Benefit Tax Payable', 201400, 20, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(201407, 'VAT Output', 201400, 20, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(300000, 'Capital Stock', 0, 30, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(300100, 'Paid-in Capital', 300000, 30, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(300101, 'Additional Paid-in Capital', 300000, 30, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(300200, 'Retained Earnings', 0, 30, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(300300, 'Opening Balance', 0, 30, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(400000, 'Sale Revenue', 0, 40, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(400001, 'Utilities', 0, 60, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(410101, 'Income', 400000, 40, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(410102, 'Sale Discount', 400000, 40, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(410103, 'Other Income', 400000, 40, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(410104, 'Income Restaurant', 400000, 40, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(410105, 'Income Phone', 400000, 40, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(500000, 'Cost of Goods Sold', 0, 50, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(500101, 'COMS', 500000, 50, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(500102, 'Freight Expense', 500000, 60, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(500103, 'Wages & Salaries', 500000, 60, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(500104, 'Cost Restaurant', 500000, 50, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(500105, 'Cost Phones', 500000, 50, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(500106, 'Purchase Discount', 500000, 50, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(500107, 'Inventory Adjustment', 500000, 50, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(500108, 'Cost of Variance', 500000, 50, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(500109, 'Using Stock', 500101, 50, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(600000, 'Expenses', 0, 60, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(601100, 'Staff Cost', 600000, 60, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(601101, 'Salary Expense', 601100, 60, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(601102, 'OT', 601100, 60, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(601103, 'Allowance ', 601100, 60, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(601104, 'Bonus', 601100, 60, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(601105, 'Commission', 601100, 60, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(601106, 'Training/Education', 601100, 60, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(601107, 'Compensation', 601100, 60, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(601108, 'Other Staff Relation', 601100, 60, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(601200, 'Administration Cost', 600000, 60, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(601201, 'Rental Expense', 601200, 60, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(601202, 'Utilities', 601200, 60, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(601203, 'Marketing & Advertising', 601200, 60, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(601204, 'Repair & Maintenance', 601200, 60, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(601205, 'Customer Relation', 601200, 60, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(601206, 'Transportation', 601200, 60, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(601207, 'Communication', 601200, 60, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(601208, 'Insurance Expense', 601200, 60, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(601209, 'Professional Fee', 601200, 60, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(601210, 'Depreciation Expense', 601200, 60, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(601211, 'Amortization Expense', 601200, 60, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(601212, 'Stationery', 601200, 60, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(601213, 'Office Supplies', 601200, 60, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(601214, 'Donation', 601200, 60, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(601215, 'Entertainment Expense', 601200, 60, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(601216, 'Travelling & Accomodation', 601200, 60, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(601217, 'Service Computer Expenses', 601200, 60, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(601218, 'Interest Expense', 601200, 60, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(601219, 'Bank Charge', 601200, 60, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(601220, 'Miscellaneous Expense', 601200, 60, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(601221, 'Canteen Supplies', 601200, 60, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(601222, 'Registration Expenses', 601200, 60, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(710300, 'Other Income', 0, 70, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(710301, 'Interest Income', 710300, 70, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(710302, 'Other Revenue & Gain', 710300, 70, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(801300, 'Other Expenses', 0, 80, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(801301, 'Other Expense & Loss', 801300, 80, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(801302, 'Bad Dept Expense', 801300, 80, 0, 0, '', NULL, '0.00');
  INSERT INTO `erp_gl_charts` (`accountcode`, `accountname`, `parent_acc`, `sectionid`, `account_tax_id`, `acc_level`, `lineage`, `bank`, `value`) VALUES(801303, 'Tax & Duties Expense', 801300, 80, 0, 0, '', NULL, '0.00');
  
  --
  -- Dumping data for table `erp_gl_charts_tax`
  --
  
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(1, 'B1', 'Sales of manufactured products', 'ការលក់ផលិតផល', 30);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(2, 'B2', 'Sales of goods', 'ការលក់ទំនិញ', 30);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(3, 'B3', 'Sales/Supply of services', 'ការផ្គត់ផ្គង់សេវា', 30);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(4, 'A2', 'Freehold Land', 'ដីធ្លីរបស់សហគ្រាស', 10);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(5, 'A3', 'Improvements and preparation of land', 'ការរៀបចំតុបតែងលំអរដីរបស់សហគ្រាស', 10);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(6, 'A4', 'Freehold buildings', 'សំណង់ងគាររបស់សហគ្រាស', 10);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(7, 'B4', 'Costs of pruducts sold of production enterprises(TOP 01/V)', 'ថៃ្លដើមផលិតផលបានលក់របស់សហគ្រាសផលិតកម្ម​(TOP 01/V)', 30);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(8, 'A5', 'Freehold buildings on leasehold land', 'សំណង់អាគារលើដីធ្លីក្រោមភតិសន្យា', 10);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(9, 'B5', 'Costs of goods sold of​​​​ non- production enterprises (TOP 01/VI)', 'ថៃ្លដើម ទំនិញបានលក់របស់សហគ្រាសក្រៅពីផលិតកម្ម(TOP 0', 30);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(10, 'A6', 'Non-current assets in progress', 'ទ្រព្យសកម្មរយះពេលវែងកំពុងដំណើរការ', 10);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(11, 'A7', 'Plant and equipemt', 'រោងចក្រ​​​(ក្រៅពីអគារ)និងបរិក្ខារ', 10);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(12, 'B5a', 'Costs of services supplied', 'ថៃ្លដើមសេវាបានផ្គត់ផ្គង់', 30);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(13, 'A8', 'Goodwill', 'កេរ្តិ៍ឈ្មោះ/មូលនិធិពាណិជ្ជកម្ម', 10);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(14, 'A9', 'Preliminary and formation expenses', 'ចំណាយបង្កើតសហគ្រាសដំបូង', 10);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(15, 'B8', 'Grant/subsidy', 'ឧបត្ថម្ភកធន', 70);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(16, 'A10', 'Leasehold assets and lease premiums', 'ទ្រព្យសកម្មក្រោមភតិសន្យា​​ និង​បុព្វលាភនៃការប្រើប្', 10);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(17, 'A11', 'Investment in other enterprise', 'វិនិយោគក្នុងសហគ្រាសដទៃ', 10);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(18, 'B9', 'Dividend received or receivable', 'ចំណូលពីភាគលាភបានទទួល​ ឬ ត្រូវទទួល', 70);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(19, 'B10', 'Interest received or receivable', 'ចំំណូលពីការប្រាក់បានទទួល ឬ ត្រូវទទួល', 70);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(20, 'A29', 'Capital/ Share capital', 'មូលធន/ មូលធនភាគហ៊ុន', 30);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(21, 'A12', 'Other non-current assets', 'ទ្រព្យសកម្មរយ:ពេលវែងផ្សេងៗ', 10);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(22, 'B11', 'Royalty received or receivable', 'ចំណូលពីសួយសារបានទទួល ឬ ត្រូវទទួល', 70);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(23, 'A30', 'Share premium', 'តម្លៃលើសនៃការលក់ប័ណ្ណភាគហ៊ុន', 30);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(24, 'B12', 'Rental received or receivable', 'ចំណូលពីការជួលបានទទួល ឬ ត្រូវទទួល', 70);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(25, 'A31', 'Legal capital reserves', 'មូលធនបំរុងច្បាប់', 30);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(26, 'A14', 'Stock of raw materials and supplies', 'ស្តូកវត្ធុធាតុដើម និងសំភារ:ផ្គត់ផ្គង់', 11);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(27, 'A32', 'Reserves revaluation surplus of assets', 'លំអៀងលើសការវាយតំលៃឡើងវិញនូវទ្រព្យសកម្ម', 30);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(28, 'A33', 'Other capital reserves', 'មូលធនបំរុងផ្សេងៗ', 30);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(29, 'A15', 'Stock of goods', 'ស្តុកទំនិញ', 11);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(30, 'B13', 'Gain from disposal of fixed assets (captital gain)', 'ផលចំណេញ/តំលៃលើសពីការលក់ទ្រព្យសកម្មរយះពេលវែង', 70);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(31, 'A34', 'Profit and loss brought forward', 'លទ្ធផលចំណេញ/ ខាត យោងពីមុន', 30);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(32, 'A16', 'Stock of finished goods', 'ស្តុកផលិតផលសម្រាច', 11);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(33, 'A35', 'Profit and loss for the period', 'លទ្ធផងចំណេញ/ ខាត នៃកាលបរិច្ឆេត', 30);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(34, 'B14', 'Gain from disposal of securities', 'ផលចំណេញពីការលក់មូលប័ត្រ/សញ្ញាប័ណ្ណ', 70);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(35, 'A37', 'Loan from related parties', 'បំណុលភាគីជាប់ទាក់ទិន', 21);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(36, 'A38', 'Loan from banks and other external parties', 'បំណុលធនាគារ និងបំណុលភាគីមិនជាប់ទាក់ទិនផ្សេងៗ', 21);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(37, 'B15', 'Share of profit from joint venture', 'ភាគចំណេញពីប្រតិបត្តិការរួមគ្នា', 70);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(38, 'A17', 'Products in progress', 'ផលិតផលកំពុងផលិត', 11);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(39, 'A39', 'Provision for charges and contigencies', 'សវិធានធនសំរាប់បន្ទុក និង​ហានិភ័យ', 21);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(40, 'B16', 'Realised exchange gain', 'ផលចំណេញពីការប្តូរប្រាក់សំរេចបាន', 70);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(41, 'A40', 'Other non-current liabilities', 'បំណុលរយៈពេលវែងផ្សេងៗ', 21);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(42, 'A18', 'Account receivevable/trade debtors', 'គណនីត្រូវទទួល​ /អតិថិជន', 11);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(43, 'B17', 'Unrealised exchange gain', 'ផលចំណេញពីការប្តូរប្រាក់មិនទាន់សំរេចបាន', 70);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(44, 'A42', 'Bank overdraft', 'សាច់ប្រាក់ដកពីធនាគារលើសប្រាក់បញ្ជី (ឥណទានរិបារូប៍រ', 20);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(45, 'A19', 'Other account receivables', 'គណនីទទួលផ្សេងៗ', 11);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(46, 'B18', 'Other revenues', 'ចំណូលដ៏ទៃទៀត', 70);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(47, 'A43', 'Short-term borrowing-current portion of interest bearing borrowing', 'ចំណែកចរន្តនៃបំណុលមានការប្រាក់', 20);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(48, 'A20', 'Prepaid expenses', 'ចំណាយបានកត់ត្រាមុន', 11);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(49, 'B20', 'Salaries expenses', 'ចំណាយបៀវត្ស', 60);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(50, 'A44', 'Accounts payble to relate parties', 'គណនីត្រូវសងបុគ្គលជាប់ទាក់ទិន (ភាគីសម្ព័ន្ធញាត្តិ)', 20);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(51, 'A45', 'Other accounts payable', 'គណនីត្រូវសងផ្សេងៗ', 20);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(52, 'A21', 'Cash on hand and at banks', 'សាច់ប្រាក់នៅក្នុងបេឡា និងនៅធនាគា', 11);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(53, 'B21', 'Fuel, gas,electricity and water expenses', 'ចំណាយប្រេង ឧស្មន័ អគ្គីសនី និងទឹក', 60);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(54, 'A46', 'Unearned revenue, accruals and other current liabilities', 'ចំណូលកត់មុន គណនីចំណាយបង្ករ និងបំណុលរយោៈពេលខ្លីផ្សេ', 20);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(55, 'A47', 'Provision for changes and contigencies', 'សវិធានធនសំរាប់បន្ទុក និង​ហានិភ័យ', 20);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(56, 'B22', 'Travelling and accommodation expenses', 'ចំណាយធើ្វដំណើរ និងចំណាយស្នាក់នៅ', 60);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(57, 'A48', 'Profit tax payable', 'ពន្ធលើប្រាក់ចំណេញត្រូវបង់', 20);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(58, 'A49', 'Other taxes payable', 'ពន្ទ-អាករផ្សេងៗត្រូវបង់', 20);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(59, 'B23', 'Transporttation expenses', 'ចំណាយដឹកជញ្ជូន', 60);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(60, 'A50', 'Differences arissing from currency translation in liabilities', 'លំអៀងពីការប្តូរប្រាក់នៃទ្រព្យសកម្ម', 20);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(61, 'B24', 'Rental expenses', 'ចំណាយលើការជួល', 60);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(62, 'B25', 'Repair anmaintenance expenses', 'ចំណាយលើការថែទាំ និងជួសជុល', 60);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(63, 'B26', 'Entertament expenses', 'ចំណាយលើការកំសាន្តសប្យាយ', 60);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(64, 'A22', 'Prepayment of profit tax credit', 'ឥណទានប្រាក់រំដោះពន្ធលើប្រាក់ចំណេញ', 11);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(65, 'B27', 'Commission, advertising, and selling expenses', 'ចំណាយកំរៃជើងសារ ផ្សាយពាណិ្ជកម្ម និងចំណាយការលក់', 60);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(66, 'A23', 'Value added tax credit', 'ឥណទានអាករលើតម្លៃបន្ថែម', 11);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(67, 'B28', 'Other taxes expenses', 'ចំណាយបង់ពន្ធ និងអាករផេ្សងៗ', 60);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(68, 'B29', 'Donation expenses', 'ចំណាយលើអំណោយ', 60);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(69, 'A24', 'Other taxes credit', 'ឥណទានពន្ធ-អាករដដៃទៀត', 11);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(70, 'B30', 'Management, consultant, other technical, and other similar services expenses', 'ចំណាយសេវាគ្រប់គ្រង ពិគ្រោះយោបល់ បចេ្វកទេស និងសេវាប', 60);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(71, 'A25', 'Other current assets', 'ទ្រព្យសកម្មពេលខ្លីផ្សេងៗ', 11);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(72, 'B31', 'Royalty expenses', 'ចំណាយលើសួយសារ', 60);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(73, 'B32', 'Bad debts written off expenses', 'ចំណាយលើបំណុលទារមិនបាន', 60);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(74, 'A26', 'Diffference arising from currency translation in assets', 'លំអៀងពីការប្តូរទ្រព្យសកម្ម', 11);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(75, 'B33', 'Armortisation/depletion and depreciation expenses', 'ចំណាយរំលស់', 60);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(76, 'B34', 'Increase /(decrease) in expenses', 'ការកើនឡើង /​ (ថយចុះ) សំវិធានធន', 60);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(77, 'B35', 'Loss on siposal of fixed assets', 'ខាតពីការលក់ទ្រព្យសកម្មរយះពេលវែង', 60);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(78, 'B36', 'Realised exchange loss', 'ខាតពីការប្តូរប្រាក់សំរេចបាន', 60);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(79, 'B37', 'Unrealised exchange loss', 'ខាតពីការប្តូរប្រាក់មិនទាន់សំរេចបាន', 60);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(80, 'B38', 'Other expenses', 'ចំណាយផេ្សងៗ', 60);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(81, 'B40', 'Interest expenses paid to residents', 'ចំណាយការប្រាក់បង់អោយនិវាសនជន', 60);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(82, 'B41', 'Interest expenses paid to non-residents', 'ចំណាយការប្រាក់បង់អោយអនិវាសនជន', 60);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(83, 'A1', 'Non-current assets/ fixed assets', 'ទ្រព្យសកម្មរយៈពេលេវែង', 10);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(84, 'A13', 'Current assets', 'ទ្រព្យសកម្មរយៈពេលខ្លី', 11);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(85, 'A28', 'Equity', 'មូលនិធិ/ ទុនម្ចាស់ទ្រព្យ ', 30);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(86, 'A36', 'Non-current liabilities', 'បំណុលរយៈពេលវែង', 21);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(87, 'A41', 'Current liabilities', 'បំណុលរយៈពេលខ្លី', 20);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(88, 'B0', 'Operating revenue', 'ចំណូលប្រតិបត្តិការ', 30);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(89, 'B7', 'Other revenue', 'ចំណូលផ្សេងៗ', 70);
  INSERT INTO `erp_gl_charts_tax` (`account_tax_id`, `accountcode`, `accountname`, `accountname_kh`, `sectionid`) VALUES(90, 'B19', 'Operating expenses', 'ចំណាយប្រតិបតិ្តការ', 60);
  
  --
  -- Dumping data for table `erp_gl_sections`
  --
  
  INSERT INTO `erp_gl_sections` (`sectionid`, `sectionname`, `sectionname_kh`, `AccountType`, `description`, `pandl`, `order_stat`) VALUES(10, 'CURRENT ASSETS', 'ទ្រព្យសកម្មរយះពេលខ្លី', 'AS', 'CURRENT ASSETS', 0, 10);
  INSERT INTO `erp_gl_sections` (`sectionid`, `sectionname`, `sectionname_kh`, `AccountType`, `description`, `pandl`, `order_stat`) VALUES(11, 'FIXED ASSETS', 'ទ្រព្យសកម្មរយះពេលវែង', 'AS', 'FIXED ASSETS', 0, 11);
  INSERT INTO `erp_gl_sections` (`sectionid`, `sectionname`, `sectionname_kh`, `AccountType`, `description`, `pandl`, `order_stat`) VALUES(20, 'CURRENT LIABILITIES', 'បំណុលរយះពេលខ្លី', 'LI', 'CURRENT LIABILITIES', 0, 20);
  INSERT INTO `erp_gl_sections` (`sectionid`, `sectionname`, `sectionname_kh`, `AccountType`, `description`, `pandl`, `order_stat`) VALUES(21, 'NON-CURRENT LIABILITIES', 'បំណុលរយះពេលវែង', 'LI', 'NON-CURRENT LIABILITIES', 0, 21);
  INSERT INTO `erp_gl_sections` (`sectionid`, `sectionname`, `sectionname_kh`, `AccountType`, `description`, `pandl`, `order_stat`) VALUES(30, 'EQUITY AND RETAINED EARNING', 'មូលនិធិ/ទុនម្ចាស់ទ្រព្យ', 'EQ', 'EQUITY AND RETAINED EARNING', 0, 30);
  INSERT INTO `erp_gl_sections` (`sectionid`, `sectionname`, `sectionname_kh`, `AccountType`, `description`, `pandl`, `order_stat`) VALUES(40, 'INCOME', 'ចំណូលប្រតិបត្តិការ', 'RE', 'INCOME', 1, 40);
  INSERT INTO `erp_gl_sections` (`sectionid`, `sectionname`, `sectionname_kh`, `AccountType`, `description`, `pandl`, `order_stat`) VALUES(50, 'COST OF GOODS SOLD', 'ចំណាយថ្លៃដើម', 'CO', 'COST OF GOODS SOLD', 1, 50);
  INSERT INTO `erp_gl_sections` (`sectionid`, `sectionname`, `sectionname_kh`, `AccountType`, `description`, `pandl`, `order_stat`) VALUES(60, 'OPERATING EXPENSES', 'ចំណាយប្រតិបត្តិការ', 'EX', 'OPERATING EXPENSES', 1, 60);
  INSERT INTO `erp_gl_sections` (`sectionid`, `sectionname`, `sectionname_kh`, `AccountType`, `description`, `pandl`, `order_stat`) VALUES(70, 'OTHER INCOME', 'ចំណូលផ្សេងៗ', 'OI', 'OTHER INCOME', 1, 70);
  INSERT INTO `erp_gl_sections` (`sectionid`, `sectionname`, `sectionname_kh`, `AccountType`, `description`, `pandl`, `order_stat`) VALUES(80, 'OTHER EXPENSE', 'ចំណាយផ្សេងៗ', 'OX', 'OTHER EXPENSE', 1, 80);
  INSERT INTO `erp_gl_sections` (`sectionid`, `sectionname`, `sectionname_kh`, `AccountType`, `description`, `pandl`, `order_stat`) VALUES(90, 'GAIN & LOSS', 'ចំណេញខាត', 'GL', 'GAIN & LOSS', 1, 90);
  
  --
  -- Dumping data for table `erp_groups`
  --
  
  INSERT INTO `erp_groups` (`id`, `name`, `description`) VALUES(1, 'owner', 'Owner');
  INSERT INTO `erp_groups` (`id`, `name`, `description`) VALUES(2, 'admin', 'Administrator');
  INSERT INTO `erp_groups` (`id`, `name`, `description`) VALUES(3, 'customer', 'Customer');
  INSERT INTO `erp_groups` (`id`, `name`, `description`) VALUES(4, 'supplier', 'Supplier');
  INSERT INTO `erp_groups` (`id`, `name`, `description`) VALUES(5, 'cashier', 'Cashier');
  INSERT INTO `erp_groups` (`id`, `name`, `description`) VALUES(6, 'stock', 'Stocker');
  INSERT INTO `erp_groups` (`id`, `name`, `description`) VALUES(7, 'manager', 'Manager');
  
  --
  -- Dumping data for table `erp_order_ref`
  --
  
  INSERT INTO `erp_order_ref` (`ref_id`, `biller_id`, `date`, `so`, `qu`, `po`, `to`, `pos`, `do`, `pay`, `re`, `ex`, `sp`, `pp`, `sl`, `tr`, `rep`, `con`, `pj`, `sd`, `es`, `esr`, `sao`, `poa`, `pq`) VALUES(1, 1, '2017-01-01', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1);
  INSERT INTO `erp_order_ref` (`ref_id`, `biller_id`, `date`, `so`, `qu`, `po`, `to`, `pos`, `do`, `pay`, `re`, `ex`, `sp`, `pp`, `sl`, `tr`, `rep`, `con`, `pj`, `sd`, `es`, `esr`, `sao`, `poa`, `pq`) VALUES(2, 1, '2017-02-01', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1);
  INSERT INTO `erp_order_ref` (`ref_id`, `biller_id`, `date`, `so`, `qu`, `po`, `to`, `pos`, `do`, `pay`, `re`, `ex`, `sp`, `pp`, `sl`, `tr`, `rep`, `con`, `pj`, `sd`, `es`, `esr`, `sao`, `poa`, `pq`) VALUES(3, 1, '2017-03-01', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1);
  INSERT INTO `erp_order_ref` (`ref_id`, `biller_id`, `date`, `so`, `qu`, `po`, `to`, `pos`, `do`, `pay`, `re`, `ex`, `sp`, `pp`, `sl`, `tr`, `rep`, `con`, `pj`, `sd`, `es`, `esr`, `sao`, `poa`, `pq`) VALUES(4, 1, '2017-04-01', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1);
  INSERT INTO `erp_order_ref` (`ref_id`, `biller_id`, `date`, `so`, `qu`, `po`, `to`, `pos`, `do`, `pay`, `re`, `ex`, `sp`, `pp`, `sl`, `tr`, `rep`, `con`, `pj`, `sd`, `es`, `esr`, `sao`, `poa`, `pq`) VALUES(5, 1, '2017-05-01', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1);
  INSERT INTO `erp_order_ref` (`ref_id`, `biller_id`, `date`, `so`, `qu`, `po`, `to`, `pos`, `do`, `pay`, `re`, `ex`, `sp`, `pp`, `sl`, `tr`, `rep`, `con`, `pj`, `sd`, `es`, `esr`, `sao`, `poa`, `pq`) VALUES(6, 1, '2017-06-01', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1);
  INSERT INTO `erp_order_ref` (`ref_id`, `biller_id`, `date`, `so`, `qu`, `po`, `to`, `pos`, `do`, `pay`, `re`, `ex`, `sp`, `pp`, `sl`, `tr`, `rep`, `con`, `pj`, `sd`, `es`, `esr`, `sao`, `poa`, `pq`) VALUES(7, 1, '2017-07-01', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1);
  INSERT INTO `erp_order_ref` (`ref_id`, `biller_id`, `date`, `so`, `qu`, `po`, `to`, `pos`, `do`, `pay`, `re`, `ex`, `sp`, `pp`, `sl`, `tr`, `rep`, `con`, `pj`, `sd`, `es`, `esr`, `sao`, `poa`, `pq`) VALUES(8, 1, '2017-08-01', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1);
  INSERT INTO `erp_order_ref` (`ref_id`, `biller_id`, `date`, `so`, `qu`, `po`, `to`, `pos`, `do`, `pay`, `re`, `ex`, `sp`, `pp`, `sl`, `tr`, `rep`, `con`, `pj`, `sd`, `es`, `esr`, `sao`, `poa`, `pq`) VALUES(9, 1, '2017-09-01', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1);
  INSERT INTO `erp_order_ref` (`ref_id`, `biller_id`, `date`, `so`, `qu`, `po`, `to`, `pos`, `do`, `pay`, `re`, `ex`, `sp`, `pp`, `sl`, `tr`, `rep`, `con`, `pj`, `sd`, `es`, `esr`, `sao`, `poa`, `pq`) VALUES(10, 1, '2017-10-01', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1);
  INSERT INTO `erp_order_ref` (`ref_id`, `biller_id`, `date`, `so`, `qu`, `po`, `to`, `pos`, `do`, `pay`, `re`, `ex`, `sp`, `pp`, `sl`, `tr`, `rep`, `con`, `pj`, `sd`, `es`, `esr`, `sao`, `poa`, `pq`) VALUES(11, 1, '2017-11-01', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1);
  INSERT INTO `erp_order_ref` (`ref_id`, `biller_id`, `date`, `so`, `qu`, `po`, `to`, `pos`, `do`, `pay`, `re`, `ex`, `sp`, `pp`, `sl`, `tr`, `rep`, `con`, `pj`, `sd`, `es`, `esr`, `sao`, `poa`, `pq`) VALUES(12, 1, '2017-12-01', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1);
  INSERT INTO `erp_order_ref` (`ref_id`, `biller_id`, `date`, `so`, `qu`, `po`, `to`, `pos`, `do`, `pay`, `re`, `ex`, `sp`, `pp`, `sl`, `tr`, `rep`, `con`, `pj`, `sd`, `es`, `esr`, `sao`, `poa`, `pq`) VALUES(13, 1, '2018-01-01', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1);
  INSERT INTO `erp_order_ref` (`ref_id`, `biller_id`, `date`, `so`, `qu`, `po`, `to`, `pos`, `do`, `pay`, `re`, `ex`, `sp`, `pp`, `sl`, `tr`, `rep`, `con`, `pj`, `sd`, `es`, `esr`, `sao`, `poa`, `pq`) VALUES(14, 1, '2018-02-01', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1);
  INSERT INTO `erp_order_ref` (`ref_id`, `biller_id`, `date`, `so`, `qu`, `po`, `to`, `pos`, `do`, `pay`, `re`, `ex`, `sp`, `pp`, `sl`, `tr`, `rep`, `con`, `pj`, `sd`, `es`, `esr`, `sao`, `poa`, `pq`) VALUES(15, 1, '2018-03-01', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1);
  INSERT INTO `erp_order_ref` (`ref_id`, `biller_id`, `date`, `so`, `qu`, `po`, `to`, `pos`, `do`, `pay`, `re`, `ex`, `sp`, `pp`, `sl`, `tr`, `rep`, `con`, `pj`, `sd`, `es`, `esr`, `sao`, `poa`, `pq`) VALUES(16, 1, '2018-04-01', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1);
  INSERT INTO `erp_order_ref` (`ref_id`, `biller_id`, `date`, `so`, `qu`, `po`, `to`, `pos`, `do`, `pay`, `re`, `ex`, `sp`, `pp`, `sl`, `tr`, `rep`, `con`, `pj`, `sd`, `es`, `esr`, `sao`, `poa`, `pq`) VALUES(17, 1, '2018-05-01', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1);
  INSERT INTO `erp_order_ref` (`ref_id`, `biller_id`, `date`, `so`, `qu`, `po`, `to`, `pos`, `do`, `pay`, `re`, `ex`, `sp`, `pp`, `sl`, `tr`, `rep`, `con`, `pj`, `sd`, `es`, `esr`, `sao`, `poa`, `pq`) VALUES(18, 1, '2018-06-01', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1);
  INSERT INTO `erp_order_ref` (`ref_id`, `biller_id`, `date`, `so`, `qu`, `po`, `to`, `pos`, `do`, `pay`, `re`, `ex`, `sp`, `pp`, `sl`, `tr`, `rep`, `con`, `pj`, `sd`, `es`, `esr`, `sao`, `poa`, `pq`) VALUES(19, 1, '2018-07-01', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1);
  INSERT INTO `erp_order_ref` (`ref_id`, `biller_id`, `date`, `so`, `qu`, `po`, `to`, `pos`, `do`, `pay`, `re`, `ex`, `sp`, `pp`, `sl`, `tr`, `rep`, `con`, `pj`, `sd`, `es`, `esr`, `sao`, `poa`, `pq`) VALUES(20, 1, '2018-08-01', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1);
  INSERT INTO `erp_order_ref` (`ref_id`, `biller_id`, `date`, `so`, `qu`, `po`, `to`, `pos`, `do`, `pay`, `re`, `ex`, `sp`, `pp`, `sl`, `tr`, `rep`, `con`, `pj`, `sd`, `es`, `esr`, `sao`, `poa`, `pq`) VALUES(21, 1, '2018-09-01', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1);
  INSERT INTO `erp_order_ref` (`ref_id`, `biller_id`, `date`, `so`, `qu`, `po`, `to`, `pos`, `do`, `pay`, `re`, `ex`, `sp`, `pp`, `sl`, `tr`, `rep`, `con`, `pj`, `sd`, `es`, `esr`, `sao`, `poa`, `pq`) VALUES(22, 1, '2018-10-01', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1);
  INSERT INTO `erp_order_ref` (`ref_id`, `biller_id`, `date`, `so`, `qu`, `po`, `to`, `pos`, `do`, `pay`, `re`, `ex`, `sp`, `pp`, `sl`, `tr`, `rep`, `con`, `pj`, `sd`, `es`, `esr`, `sao`, `poa`, `pq`) VALUES(23, 1, '2018-11-01', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1);
  INSERT INTO `erp_order_ref` (`ref_id`, `biller_id`, `date`, `so`, `qu`, `po`, `to`, `pos`, `do`, `pay`, `re`, `ex`, `sp`, `pp`, `sl`, `tr`, `rep`, `con`, `pj`, `sd`, `es`, `esr`, `sao`, `poa`, `pq`) VALUES(24, 1, '2018-12-01', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1);
  
  --
  -- Dumping data for table `erp_payment_term`
  --
  
  INSERT INTO `erp_payment_term` (`id`, `description`, `due_day`, `due_day_for_discount`, `discount`) VALUES(1, 'Net 20 Days', 20, 5, '0');
  INSERT INTO `erp_payment_term` (`id`, `description`, `due_day`, `due_day_for_discount`, `discount`) VALUES(2, 'Net 1 Month', 30, 0, '0');
  INSERT INTO `erp_payment_term` (`id`, `description`, `due_day`, `due_day_for_discount`, `discount`) VALUES(3, 'Net 7 Days', 7, 7, '0');
  INSERT INTO `erp_payment_term` (`id`, `description`, `due_day`, `due_day_for_discount`, `discount`) VALUES(4, 'Case On Hand', 0, 0, '0');
  
  --
  -- Dumping data for table `erp_price_groups`
  --
  
  INSERT INTO `erp_price_groups` (`id`, `name`) VALUES(1, 'Price A');
  INSERT INTO `erp_price_groups` (`id`, `name`) VALUES(2, 'Price B');
  
  --
  -- Dumping data for table `erp_suspended`
  --
  
  INSERT INTO `erp_suspended` (`id`, `name`, `description`, `floor`, `ppl_number`, `status`, `startdate`, `enddate`, `note`, `customer_id`, `inactive`) VALUES(1, 'Room 01', 'Room 01', '0', 4, 0, NULL, NULL, NULL, NULL, NULL);
  INSERT INTO `erp_suspended` (`id`, `name`, `description`, `floor`, `ppl_number`, `status`, `startdate`, `enddate`, `note`, `customer_id`, `inactive`) VALUES(2, 'Room 02', 'Room 02', '0', 4, 0, NULL, NULL, NULL, NULL, NULL);
  INSERT INTO `erp_suspended` (`id`, `name`, `description`, `floor`, `ppl_number`, `status`, `startdate`, `enddate`, `note`, `customer_id`, `inactive`) VALUES(3, 'Room 03', 'Room 03', '0', 2, 0, NULL, NULL, NULL, NULL, NULL);
  INSERT INTO `erp_suspended` (`id`, `name`, `description`, `floor`, `ppl_number`, `status`, `startdate`, `enddate`, `note`, `customer_id`, `inactive`) VALUES(4, 'Room 04', 'Room 04', '0', 2, 0, NULL, NULL, NULL, NULL, NULL);
  
  --
  -- Dumping data for table `erp_tax_rates`
  --
  
  INSERT INTO `erp_tax_rates` (`id`, `name`, `code`, `rate`, `type`) VALUES(1, 'No Tax', 'NT', '0.0000', '2');
  INSERT INTO `erp_tax_rates` (`id`, `name`, `code`, `rate`, `type`) VALUES(2, 'VAT @10%', 'VAT10', '10.0000', '1');
  INSERT INTO `erp_tax_rates` (`id`, `name`, `code`, `rate`, `type`) VALUES(3, 'GST @6%', 'GST', '6.0000', '1');
  INSERT INTO `erp_tax_rates` (`id`, `name`, `code`, `rate`, `type`) VALUES(4, 'VAT @20%', 'VT20', '20.0000', '1');
  INSERT INTO `erp_tax_rates` (`id`, `name`, `code`, `rate`, `type`) VALUES(5, 'TAX @10%', 'TAX', '10.0000', '1');
  
  --
  -- Dumping data for table `erp_users`
  --
  
  INSERT INTO `erp_users` (`id`, `last_ip_address`, `ip_address`, `username`, `password`, `salt`, `email`, `activation_code`, `forgotten_password_code`, `forgotten_password_time`, `remember_code`, `created_on`, `last_login`, `active`, `first_name`, `last_name`, `company`, `phone`, `avatar`, `gender`, `group_id`, `warehouse_id`, `biller_id`, `company_id`, `show_cost`, `show_price`, `award_points`, `view_right`, `edit_right`, `allow_discount`, `annualLeave`, `sickday`, `speacialLeave`, `othersLeave`, `first_name_kh`, `last_name_kh`, `nationality_kh`, `race_kh`, `pos_layout`, `pack_id`, `sales_standard`, `sales_combo`, `sales_digital`, `sales_service`, `sales_category`, `purchase_standard`, `purchase_combo`, `purchase_digital`, `purchase_service`, `purchase_category`, `date_of_birth`, `nationality`, `position`, `salary`, `spouse`, `number_of_child`, `employeed_date`, `last_paid`, `address`, `note`, `emergency_contact`, `emp_code`, `allowance`, `emp_type`, `tax_salary_type`, `hide_row`, `emp_group`) VALUES(1, 0x3a3a31, 0x0000, 'owner', '06e6c33bfa4496ceceb8eff15f40ec726d8d2336', '', 'owner@cloudnet.com.kh', '', '', NULL, '078c30f596fa50aa383a756752d503275fdc59c8', 1351661704, 1494651471, 1, 'Own', 'Owner', 'ABC Shop', '012345678', '', 'male', 1, '', NULL, NULL, 0, 0, 146056, 0, 0, 0, 0, 0, NULL, NULL, '', '', '', '', NULL, '5', NULL, NULL, NULL, 1, '', NULL, NULL, NULL, NULL, '', '1970-01-01', 'Khmer', '', '0.0000', '', 0, '2016-05-01', '2016-12-09', '', '', '', '0012', '0.0000', '', '', 0, NULL);
  
  --
  -- Dumping data for table `erp_settings`
  --
  
  INSERT INTO `erp_settings` (`setting_id`, `logo`, `logo2`, `site_name`, `language`, `default_warehouse`, `accounting_method`, `default_currency`, `default_tax_rate`, `rows_per_page`, `version`, `default_tax_rate2`, `dateformat`, `sales_prefix`, `quote_prefix`, `purchase_prefix`, `transfer_prefix`, `delivery_prefix`, `payment_prefix`, `return_prefix`, `expense_prefix`, `transaction_prefix`, `item_addition`, `theme`, `product_serial`, `default_discount`, `product_discount`, `discount_method`, `tax1`, `tax2`, `overselling`, `restrict_user`, `restrict_calendar`, `timezone`, `iwidth`, `iheight`, `twidth`, `theight`, `watermark`, `reg_ver`, `allow_reg`, `reg_notification`, `auto_reg`, `protocol`, `mailpath`, `smtp_host`, `smtp_user`, `smtp_pass`, `smtp_port`, `smtp_crypto`, `corn`, `customer_group`, `default_email`, `mmode`, `bc_fix`, `auto_detect_barcode`, `captcha`, `reference_format`, `racks`, `attributes`, `product_expiry`, `purchase_decimals`, `decimals`, `qty_decimals`, `decimals_sep`, `thousands_sep`, `invoice_view`, `default_biller`, `envato_username`, `purchase_code`, `rtl`, `each_spent`, `ca_point`, `each_sale`, `sa_point`, `update`, `sac`, `display_all_products`, `display_symbol`, `symbol`, `item_slideshow`, `barcode_separator`, `remove_expired`, `sale_payment_prefix`, `purchase_payment_prefix`, `sale_loan_prefix`, `auto_print`, `returnp_prefix`, `alert_day`, `convert_prefix`, `purchase_serial`, `enter_using_stock_prefix`, `enter_using_stock_return_prefix`, `supplier_deposit_prefix`, `sale_order_prefix`, `boms_method`, `separate_code`, `show_code`, `bill_to`, `show_po`, `show_company_code`, `purchase_order_prefix`, `credit_limit`, `purchase_request_prefix`, `acc_cate_separate`) VALUES(1, '', 'header_logo.png', 'iCloudERP Software', 'english', 1, 2, 'USD', 1, 10, '3.4', 1, 5, 'SALE', 'QUOTE', 'PO', 'TR', 'DO', 'IPAY', 'RE', 'EX', 'J', 0, 'default', 0, 1, 1, 1, 1, 1, 1, 1, 0, 'Asia/Phnom_Penh', 800, 800, 60, 60, 0, 0, 0, 0, NULL, 'smtp', '/usr/sbin/sendmail', 'icloud-erp.info', 'crm@icloud-erp.info', '6ZkVZzoC5mbvi/2YeDv/w7rHvQpOqS2yiy1gf3HIeG7glZblVFxsP5aC8yCFVz18CDoaJjCNI/sZWbJ+xcgR8Q==', '465', 'ssl', '0000-00-00 00:00:00', 1, 'iclouderp@gmail.com', 0, 4, 0, 0, 1, 1, 0, 0, 2, 2, 2, '.', ',', 0, 1, 'cloud-net', '53d35644-a36e-45cd-b7ee-8dde3a08f83d', 0, '10.0000', 1, '100.0000', 1, 0, 0, 0, 0, 'B', 0, '_', 0, 'RV', 'PV', 'LOAN', 0, 'PRE', 7, 'CON', 0, 'ES', 'ESR', 'SDE', 'SAO', 0, 1, 1, 0, 0, 1, 'PAO', 0, 'PQ', 1);
  
  --
  -- Dumping data for table `erp_account_settings`
  --
  
  INSERT INTO `erp_account_settings` (`id`, `biller_id`, `default_open_balance`, `default_sale`, `default_sale_discount`, `default_sale_tax`, `default_sale_freight`, `default_sale_deposit`, `default_receivable`, `default_purchase`, `default_purchase_discount`, `default_purchase_tax`, `default_purchase_freight`, `default_purchase_deposit`, `default_payable`, `default_stock`, `default_stock_adjust`, `default_cost`, `default_payroll`, `default_cash`, `default_credit_card`, `default_gift_card`, `default_cheque`, `default_loan`, `default_retained_earnings`, `default_cost_variant`) VALUES(1, 1, '300300', '410101', '410102', '201407', '601206', '201208', '100200', '100430', '500106', '100441', '601206', '100420', '201100', '100430', '500107', '500101', '201201', '100102', '100105', '201208', '100104', '100501', '300200', '500108');
  
  --
  -- Dumping data for table `erp_pos_settings`
  --
  
  INSERT INTO `erp_pos_settings` (`pos_id`, `cat_limit`, `pro_limit`, `default_category`, `default_customer`, `default_biller`, `display_time`, `cf_title1`, `cf_title2`, `cf_value1`, `cf_value2`, `receipt_printer`, `cash_drawer_codes`, `focus_add_item`, `add_manual_product`, `customer_selection`, `add_customer`, `toggle_category_slider`, `toggle_subcategory_slider`, `show_search_item`, `product_unit`, `cancel_sale`, `suspend_sale`, `print_items_list`, `print_bill`, `finalize_sale`, `today_sale`, `open_hold_bills`, `close_register`, `keyboard`, `pos_printers`, `java_applet`, `product_button_color`, `tooltips`, `paypal_pro`, `stripe`, `rounding`, `char_per_line`, `pin_code`, `purchase_code`, `envato_username`, `version`, `show_item_img`, `pos_layout`, `display_qrcode`, `show_suspend_bar`, `show_payment_noted`, `payment_balance`, `authorize`, `show_product_code`, `auto_delivery`, `in_out_rate`, `discount`) VALUES(1, 22, 30, 2, 2, 1, '1', 'GST Reg', 'VAT Reg', '123456789', '987654321', 'BIXOLON SRP-350II', 'x1C', 'Ctrl+F3', 'Ctrl+Shift+M', 'Ctrl+Shift+C', 'Ctrl+Shift+A', 'Ctrl+F11', 'Ctrl+F12', 'F1', 'F2', 'F4', 'F7', 'F9', 'F3', 'F8', 'Ctrl+F1', 'Ctrl+F2', 'Ctrl+F10', 0, 'BIXOLON SRP-350II, BIXOLON SRP-350II', 0, 'warning', 0, 0, 0, 0, 42, '', 'cloud-net', '53d35644-a36e-45cd-b7ee-8dde3a08f83d', '3.3', 1, 0, 0, 1, 1, 1, 0, 0, 0, 0, '0.0000');
  
  --
  -- Dumping data for table `erp_variants`
  --
  
  INSERT INTO `erp_variants` (`id`, `name`) VALUES(1, 'Smale');
  INSERT INTO `erp_variants` (`id`, `name`) VALUES(2, 'Midduim');
  INSERT INTO `erp_variants` (`id`, `name`) VALUES(3, 'Big');
  INSERT INTO `erp_variants` (`id`, `name`) VALUES(4, 'White');
  INSERT INTO `erp_variants` (`id`, `name`) VALUES(5, 'Red');
  INSERT INTO `erp_variants` (`id`, `name`) VALUES(6, 'Blue');
  INSERT INTO `erp_variants` (`id`, `name`) VALUES(7, 'Black');
  INSERT INTO `erp_variants` (`id`, `name`) VALUES(8, 'Gold');
  INSERT INTO `erp_variants` (`id`, `name`) VALUES(9, 'Each');
  INSERT INTO `erp_variants` (`id`, `name`) VALUES(10, 'Box');
  INSERT INTO `erp_variants` (`id`, `name`) VALUES(11, 'Case');
  INSERT INTO `erp_variants` (`id`, `name`) VALUES(12, 'G');
  INSERT INTO `erp_variants` (`id`, `name`) VALUES(13, 'Kg');
  INSERT INTO `erp_variants` (`id`, `name`) VALUES(14, 'Ton');
  
  --
  -- Dumping data for table `erp_warehouses`
  --
  
  INSERT INTO `erp_warehouses` (`id`, `code`, `name`, `address`, `map`, `phone`, `email`) VALUES(1, 'pp', 'Phnom Penh', 'Phnom Penh', NULL, '012345678', 'test_pp@gmail.com');
  INSERT INTO `erp_warehouses` (`id`, `code`, `name`, `address`, `map`, `phone`, `email`) VALUES(2, 'sr', 'Siem Reap', 'Siem Reap', NULL, '02346346666', 'test_sr@gmail.com');
  
  --
  -- Dumping data for table `erp_categories`
  --
  
  INSERT INTO `erp_categories` (`id`, `brand_id`, `code`, `name`, `image`, `jobs`, `auto_delivery`, `ac_sale`, `ac_cost`, `ac_stock`, `ac_stock_adj`, `ac_wip`, `ac_cost_variant`, `ac_purchase`) VALUES(1, NULL, 'C1', 'PHONES', '8db1201e6403b9f084501262acd7aec5.png', 0, 1, '410105', '500105', '100430', '500107', NULL, '500108', '500105');
  INSERT INTO `erp_categories` (`id`, `brand_id`, `code`, `name`, `image`, `jobs`, `auto_delivery`, `ac_sale`, `ac_cost`, `ac_stock`, `ac_stock_adj`, `ac_wip`, `ac_cost_variant`, `ac_purchase`) VALUES(2, NULL, 'C2', 'CLOTHS', 'b642d29abbf65c063f1d5b4c7abb278c.png', 0, 1, '410101', '500000', '100430', '500107', NULL, '500108', '500000');
  INSERT INTO `erp_categories` (`id`, `brand_id`, `code`, `name`, `image`, `jobs`, `auto_delivery`, `ac_sale`, `ac_cost`, `ac_stock`, `ac_stock_adj`, `ac_wip`, `ac_cost_variant`, `ac_purchase`) VALUES(3, NULL, 'C3', 'RESTAURENT', '0384325d02e0e902f06434537ff1fec7.png', 1, 1, '410104', '500104', '100430', '500107', NULL, '500108', '500104');
  INSERT INTO `erp_categories` (`id`, `brand_id`, `code`, `name`, `image`, `jobs`, `auto_delivery`, `ac_sale`, `ac_cost`, `ac_stock`, `ac_stock_adj`, `ac_wip`, `ac_cost_variant`, `ac_purchase`) VALUES(4, NULL, 'C4', 'WATCHES', '57ce387cf52db6829c0722e63002061c.png', 0, 1, '410101', '500000', '100430', '500107', NULL, '500108', '500000');
  INSERT INTO `erp_categories` (`id`, `brand_id`, `code`, `name`, `image`, `jobs`, `auto_delivery`, `ac_sale`, `ac_cost`, `ac_stock`, `ac_stock_adj`, `ac_wip`, `ac_cost_variant`, `ac_purchase`) VALUES(5, NULL, 'C5', 'MARTS', 'dbeb8a87db7520ea18c1771ae61e7492.png', 0, 1, '410104', '500104', '100430', '500107', NULL, '500108', '500104');
  
  
  --
  -- Dumping data for table `erp_product_variants`
  --
  
  INSERT INTO `erp_product_variants` (`id`, `product_id`, `name`, `cost`, `price`, `quantity`, `qty_unit`, `currentcy_code`) VALUES(1, 1, 'Each', '0.0000', '1.0000', NULL, '1.0000', NULL);
  INSERT INTO `erp_product_variants` (`id`, `product_id`, `name`, `cost`, `price`, `quantity`, `qty_unit`, `currentcy_code`) VALUES(2, 1, 'Box', '0.0000', '11.0000', NULL, '12.0000', NULL);
  INSERT INTO `erp_product_variants` (`id`, `product_id`, `name`, `cost`, `price`, `quantity`, `qty_unit`, `currentcy_code`) VALUES(3, 1, 'Case', '0.0000', '20.0000', NULL, '24.0000', NULL);
  INSERT INTO `erp_product_variants` (`id`, `product_id`, `name`, `cost`, `price`, `quantity`, `qty_unit`, `currentcy_code`) VALUES(4, 2, 'Each', '0.0000', '1.5000', NULL, '1.0000', NULL);
  INSERT INTO `erp_product_variants` (`id`, `product_id`, `name`, `cost`, `price`, `quantity`, `qty_unit`, `currentcy_code`) VALUES(5, 2, 'Box', '0.0000', '15.0000', NULL, '12.0000', NULL);
  INSERT INTO `erp_product_variants` (`id`, `product_id`, `name`, `cost`, `price`, `quantity`, `qty_unit`, `currentcy_code`) VALUES(6, 2, 'Case', '0.0000', '28.0000', NULL, '24.0000', NULL);
  
  --
  -- Dumping data for table `erp_subcategories`
  --
  
  INSERT INTO `erp_subcategories` (`id`, `category_id`, `code`, `name`, `image`) VALUES(1, 1, 'C1S1', 'APPLE', '5a8a254b12e106951cdbb4971e743596.jpg');
  INSERT INTO `erp_subcategories` (`id`, `category_id`, `code`, `name`, `image`) VALUES(2, 1, 'C1S2', 'SAMSUNG', 'c66c5948e219ea0f727c60b28893445a.gif');
  INSERT INTO `erp_subcategories` (`id`, `category_id`, `code`, `name`, `image`) VALUES(3, 1, 'C1S3', 'HUAWEI', '98682c77d3a98be2066486968b634563.jpg');
  INSERT INTO `erp_subcategories` (`id`, `category_id`, `code`, `name`, `image`) VALUES(4, 1, 'C1S4', 'SONY', '523dcc23fcbf929637cbcd6ec3ac8970.gif');
  INSERT INTO `erp_subcategories` (`id`, `category_id`, `code`, `name`, `image`) VALUES(5, 1, 'C1S5', 'ACCESSORY', 'no_image.png');
  INSERT INTO `erp_subcategories` (`id`, `category_id`, `code`, `name`, `image`) VALUES(6, 2, 'C2S1', 'MEN', 'no_image.png');
  INSERT INTO `erp_subcategories` (`id`, `category_id`, `code`, `name`, `image`) VALUES(7, 2, 'C2S2', 'WOMEN', 'no_image.png');
  INSERT INTO `erp_subcategories` (`id`, `category_id`, `code`, `name`, `image`) VALUES(8, 2, 'C2S3', 'CHILDREN', 'no_image.png');
  INSERT INTO `erp_subcategories` (`id`, `category_id`, `code`, `name`, `image`) VALUES(9, 2, 'C2S4', 'BABY', 'no_image.png');
  INSERT INTO `erp_subcategories` (`id`, `category_id`, `code`, `name`, `image`) VALUES(10, 4, 'C4S1', 'VERSACE', 'bfdfa43e39eb7a21bd4e07e96ba2a803.jpg');
  INSERT INTO `erp_subcategories` (`id`, `category_id`, `code`, `name`, `image`) VALUES(11, 4, 'C4S2', 'HERBELIN', '7acb8930d0f28bd463350f5c0569e824.jpg');
  INSERT INTO `erp_subcategories` (`id`, `category_id`, `code`, `name`, `image`) VALUES(12, 4, 'C4S3', 'ROAMER', 'a7bd9dbb52fad62bfd6c1c7f66c660e5.jpg');
  INSERT INTO `erp_subcategories` (`id`, `category_id`, `code`, `name`, `image`) VALUES(13, 4, 'C4S4', 'ADIDAS', '16668eb4e418e5bb328dbfd388f11ac5.jpg');
  INSERT INTO `erp_subcategories` (`id`, `category_id`, `code`, `name`, `image`) VALUES(14, 4, 'C4S5', 'BOSS', 'd79a16a026348e013607e7f00c39f64f.jpg');
  INSERT INTO `erp_subcategories` (`id`, `category_id`, `code`, `name`, `image`) VALUES(15, 4, 'C4S6', 'LACOSTE', 'c7b79c0c1f070d4b333e54628a566e04.jpg');
  INSERT INTO `erp_subcategories` (`id`, `category_id`, `code`, `name`, `image`) VALUES(16, 3, 'C3S1', 'BREAKFAST', 'no_image.png');
  INSERT INTO `erp_subcategories` (`id`, `category_id`, `code`, `name`, `image`) VALUES(17, 3, 'C3S2', 'LUNCH', 'no_image.png');
  INSERT INTO `erp_subcategories` (`id`, `category_id`, `code`, `name`, `image`) VALUES(18, 3, 'C3S3', 'COFFEE', 'no_image.png');
  INSERT INTO `erp_subcategories` (`id`, `category_id`, `code`, `name`, `image`) VALUES(19, 3, 'C3S4', 'COCK DRINKS', 'no_image.png');
  INSERT INTO `erp_subcategories` (`id`, `category_id`, `code`, `name`, `image`) VALUES(20, 5, 'C5S1', 'ACHOHAL', 'no_image.png');
  INSERT INTO `erp_subcategories` (`id`, `category_id`, `code`, `name`, `image`) VALUES(21, 5, 'C5S2', 'CIGARETTES', 'no_image.png');
  INSERT INTO `erp_subcategories` (`id`, `category_id`, `code`, `name`, `image`) VALUES(22, 5, 'C5S3', 'SNACKS', 'no_image.png');
  INSERT INTO `erp_subcategories` (`id`, `category_id`, `code`, `name`, `image`) VALUES(23, 5, 'C5S4', 'FRUITE', 'no_image.png');
  INSERT INTO `erp_subcategories` (`id`, `category_id`, `code`, `name`, `image`) VALUES(24, 5, 'C5S5', 'SOFT DRINK', 'no_image.png');
  INSERT INTO `erp_subcategories` (`id`, `category_id`, `code`, `name`, `image`) VALUES(25, 5, 'C5S6', 'OTHER', 'no_image.png');
  
  
  --
  -- Dumping data for table `erp_products`
  --
  
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(1, 'B-S001', NULL, 'Tiger Beer', '1', '0.0000', '0.0000', '10', 'no_image.png', 5, NULL, '', '', '', '', '', '', NULL, 1, 1, '', NULL, 'code128', NULL, '', 0, 'standard', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(2, 'B-S002', NULL, 'ABC Beer', '1', '0.0000', '0.0000', '20', 'no_image.png', 5, NULL, '', '', '', '', '', '', NULL, 1, 1, '', NULL, 'code128', NULL, '', 0, 'standard', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(3, 'B-COMBO', NULL, 'Mix Beers', '1', NULL, '6.5000', '0', 'no_image.png', 5, NULL, '', '', '', '', '', '', NULL, 1, 0, '', NULL, 'code128', NULL, '', 0, 'combo', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(4, 'PH001', NULL, 'iPhone 6s (128GB)', '1', '780.0000', '850.0000', '10', 'c20d5dbbbef011cc98211af9c8751617.jpg', 1, 1, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(5, 'PH002', NULL, 'iPhone 6s (64GB)', '1', '750.0000', '850.0000', '10', '04b6aec1436d6558854b01ae052bab5b.jpg', 1, 1, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(6, 'PH003', NULL, 'iPhone 6 plus (128GB)', '1', '600.0000', '650.0000', '10', 'bc04b018a9e0b96f93e708b245dcfacb.jpg', 1, 1, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(7, 'PH004', NULL, 'iPhone 6 plus (64GB)', '1', '550.0000', '610.0000', '10', '6ab4bcc03e7e652c0c1b831da06570df.jpg', 1, 0, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(8, 'PH005', NULL, 'iPhone 6 plus (32GB)', '1', '480.0000', '530.0000', '10', '71f7a8300d0ead77f1e29df087b5cd3a.jpg', 1, 0, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(9, 'PH006', NULL, 'iPhone 6 (64GB)', '1', '650.0000', '700.0000', '10', '8dd639ece7ac4cec5bb573ca7212a7bc.jpg', 1, 1, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(10, 'PH007', NULL, 'iPhone 6 (32GB)', '1', '580.0000', '610.0000', '10', '89372cf04ec54321dabd7af2e884f38f.jpg', 1, 1, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(11, 'PH008', NULL, 'iPhone 5s', '1', '400.0000', '420.0000', '10', 'e0ef7562920be28b12c0e83ccf89d1f3.jpg', 1, 1, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(12, 'PH009', NULL, 'iPhone 6 Plus (16G)', '1', '650.0000', '720.0000', '10', 'e1ebed159ca5eb9dd0baaf41602218f3.jpg', 1, 1, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(13, 'PH010', NULL, 'iPhone 6 (16G)', '1', '570.0000', '610.0000', '10', 'a5fc29016916380dfee9b94759834837.jpg', 1, 1, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(14, 'PH011', NULL, 'iPhone 6s (16G)', '1', '700.0000', '730.0000', '10', '98dd9fc0103970a091e5a9c7fd3921c5.jpg', 1, 1, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(15, 'PH012', NULL, 'Galaxy S6 edge', '1', '550.0000', '605.0000', '10', 'a335081875d7008a6f6838eeddaba33d.jpg', 1, 2, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(16, 'PH013', NULL, 'Galaxy S6', '1', '450.0000', '505.0000', '10', 'ce0476a1e6e20a436859c228fa9cd70c.jpg', 1, 2, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(17, 'PH014', NULL, 'Galaxy S6 edge Plus', '1', '680.0000', '720.0000', '10', 'c0c4a01fc9b49d3b85c2761b882596e3.jpg', 1, 2, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(18, 'PH015', NULL, 'Galaxy Note5', '1', '600.0000', '620.0000', '10', '1cb4df20ef51c2d6f19c3a0d6f3d7225.jpg', 1, 2, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(19, 'PH016', NULL, 'Note5 Duos (32G)', '1', '600.0000', '635.0000', '10', '57dd01b951a3e843c239a163e46c449f.jpg', 1, 2, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(20, 'PH017', NULL, 'Galaxy S6 edged Plus dual', '1', '700.0000', '725.0000', '10', 'f6df19bcd7362d8510b4c4314beb75de.jpg', 1, 2, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(21, 'PH018', NULL, 'Galaxy A8', '1', '420.0000', '450.0000', '10', 'dd6282419aaffa4ca975f3d9367f3791.jpg', 1, 2, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(22, 'PH019', NULL, 'Galaxy S6 Duos Sim', '1', '500.0000', '535.0000', '10', 'd22ebede249a11ea2600ed91edf66b4c.jpg', 1, 2, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(23, 'PH020', NULL, 'P8 Max', '1', '510.0000', '540.0000', '10', '9e1d98718657899e06e0cb31e7d678ac.jpg', 1, 3, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(24, 'PH021', NULL, 'G7 Plus', '1', '250.0000', '330.0000', '10', '9c675bfe2ba049b066d864621e3cdda7.jpg', 1, 3, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(25, 'PH022', NULL, 'Huawei P8 16G', '1', '400.0000', '435.0000', '10', '7cb83383075bfa49ac1af84cc59995d0.jpg', 1, 3, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(26, 'PH023', NULL, 'Ascend Mate7', '1', '400.0000', '420.0000', '10', 'a7962e6d0f3c092d2ca46661a573ff38.jpg', 1, 3, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(27, 'PH024', NULL, 'Ascend Mate7 Gold', '1', '400.0000', '420.0000', '10', 'ce750c30f46edd273d80f010eea72649.jpg', 1, 3, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(28, 'PH025', NULL, 'MediaPad X2', '1', '310.0000', '339.0000', '10', 'c2885dd503a4b96bc0805cca6e2aec1d.jpg', 1, 3, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(29, 'PH026', NULL, 'MediaPad M1', '1', '200.0000', '227.0000', '10', 'cff0db6d376198f4ad66f96a89da4434.jpg', 1, 3, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(30, 'PH027', NULL, 'Huawei TalkBand B2', '1', '106.0000', '155.0000', '10', '140f82f687457d4dcf807d206af7a809.jpg', 1, 3, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(31, 'PH028', NULL, 'P8 Lite', '1', '190.0000', '210.0000', '10', '10015979c85b41098d95987c21323217.jpg', 1, 3, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(32, 'PH029', NULL, 'G Play Mini', '1', '140.0000', '165.0000', '10', 'f51691eac29e428115157ceaa8647480.jpg', 1, 3, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(33, 'PH030', NULL, 'Xperia Z 5', '1', '500.0000', '670.0000', '10', 'f08d4f4b8f6f978ffc86b5fdb95e7b3b.jpg', 1, 4, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(34, 'PH031', NULL, 'Xperia Z3 Plus', '1', '500.0000', '575.0000', '10', 'f02ae5891400d36f7026a4e5ff413e58.jpg', 1, 4, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(35, 'PH032', NULL, 'Xperia Z3 Plus Dual', '1', '570.0000', '595.0000', '10', '778ffe9a8e65e3a7aecf13b10ed8056a.jpg', 1, 4, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(36, 'PH033', NULL, 'Xperia C5 Ultra Dual', '1', '315.0000', '345.0000', '10', '4238df8e6c61dc55bb972a12711bb7c5.jpg', 1, 4, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(37, 'PH034', NULL, 'Xperia Z3', '1', '400.0000', '435.0000', '10', 'bf6f05335ad59e4889e61890dd33057f.jpg', 1, 4, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(38, 'PH035', NULL, 'Xperia Z2', '1', '310.0000', '355.0000', '10', '314aafb299537cb2d923a89324394794.jpg', 1, 4, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(39, 'PH036', NULL, 'M4 Aqua Dual', '1', '200.0000', '260.0000', '10', '4e6b3376f392fb6c42fac118e478a0ec.jpg', 1, 4, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(40, 'PH037', NULL, 'Xperia C4 Dual', '1', '280.0000', '315.0000', '10', '5d654de9418cd349b8e5f6aca6f5c7ec.jpg', 1, 4, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(41, 'PH038', NULL, 'Hornor 6 Plus', '1', '310.0000', '368.0000', '10', '9e91c9ef4f98896702300fa3e5867eb7.jpg', 1, 4, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(42, 'WC001', NULL, 'Men`s Aventura Chronograph', '1', '172.5000', '230.0000', '10', '8abd8528312d7a29cdab0b186a1c827d.jpg', 4, 10, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(43, 'WC002', NULL, 'Ladie`s Miami', '1', '90.0000', '210.0000', '10', '97a3f0518636efbcf4f66881389a8976.jpg', 4, 10, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(44, 'WC003', NULL, 'Man`s Manhattan Gronograph', '1', '200.0000', '220.0000', '10', 'be1fae48ffbaf438ad7eacc6a5befae4.jpg', 4, 10, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(45, 'WC004', NULL, 'Ladies Sertie', '1', '160.0000', '170.0000', '10', 'bfafdf3d482ba0818c035d99e4683bc9.jpg', 4, 10, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(46, 'WC005', NULL, 'Men`s Cosmopolitan Chronograph', '1', '90.0000', '92.0000', '10', '09468660aa5d42e246672adb43cec250.jpg', 4, 10, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(47, 'WC006', NULL, 'Ladies` Logo', '1', '150.0000', '160.0000', '10', '13f9132827b7dfa1f4f750012c0ea41e.jpg', 4, 10, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(48, 'WC007', NULL, 'Ladies` Logo', '1', '110.0000', '130.0000', '10', 'ebe93301d4a95da3b334abe593c0e647.jpg', 4, 10, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(49, 'WC008', NULL, 'Men`s Aventura Chronograph', '1', '190.0000', '200.0000', '10', 'dff324e4d18433f8bdc6aefc9e850f08.jpg', 4, 10, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(50, 'WC009', NULL, 'Men`s Manhattan', '1', '190.0000', '200.0000', '10', '1502e6d1435e4183b7bae58c2ac11f9d.jpg', 4, 10, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(51, 'WC010', NULL, 'Men`s Newport Marine Chronograph', '1', '650.0000', '670.0000', '10', 'b06e71416e350dc7959ca380554418f4.jpg', 4, 11, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(52, 'WC011', NULL, 'Men`s Odyssee Chronograph', '1', '760.0000', '775.0000', '10', '339631467c9724e94644ab410d43365f.jpg', 4, 11, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(53, 'WC012', NULL, 'Ladies` Ambassador', '1', '170.0000', '182.5000', '10', '017a776ebe45edfd40b75380cd25d906.jpg', 4, 11, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(54, 'WC013', NULL, 'Ladies` Perle', '1', '575.0000', '695.0000', '10', '7ab3618d01fae5111cf6fbce156f0d07.jpg', 4, 11, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(55, 'WC014', NULL, 'Men`s Odyssee', '1', '625.0000', '645.0000', '10', 'a64876b7a68eebd176aeca02169a4054.jpg', 4, 11, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(56, 'WC015', NULL, 'Men`s Inspiration Lyre', '1', '390.0000', '410.0000', '10', '06106d8bfe44795704026e01d112f019.jpg', 4, 11, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(57, 'WC016', NULL, 'Ladies` Feminines', '1', '760.0000', '399.0000', '10', '1fd3cf9404ea0902b4305ba4c181e11c.jpg', 4, 11, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(58, 'WC017', NULL, 'Ladies` Newport Trophy Ceramic Chronograph', '1', '380.0000', '405.0000', '10', 'b6eeaa382ce4ac7958d291cbb3ceb0e1.jpg', 4, 11, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(59, 'WC018', NULL, 'Men`s Ceraline Saphira Ceramic', '1', '300.0000', '325.0000', '10', '252e03302bd36b8c8c15f94abfcce05b.jpg', 4, 12, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(60, 'WC019', NULL, 'Men`s Superior Moonphase', '1', '320.0000', '345.0000', '10', '44f6e586236dfda86284da057e9eb15a.jpg', 4, 12, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(61, 'WC020', NULL, 'Men`s Superior Chronograph', '1', '340.0000', '365.0000', '10', 'e5be592dea2eea6c042e92df4be745b1.jpg', 4, 12, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(62, 'WC021', NULL, 'Men`s Superior Chronograph', '1', '315.0000', '335.0000', '10', 'a80345c8baa8977e45de39cb25cc6f5c.jpg', 4, 12, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(63, 'WC022', NULL, 'Unisex Ceraline Saphira Square Ceramic', '1', '400.0000', '415.0000', '10', '158842105929687249e9e418f2b98b1a.jpg', 4, 12, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(64, 'WC023', NULL, 'Ladies` Ceraline Saphira Square Ceramic', '1', '460.0000', '430.0000', '10', 'e27537e25864db083e4d55796f78739b.jpg', 4, 12, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(65, 'WC025', NULL, 'Ladies` Ceraline Pure', '1', '100.0000', '127.0000', '10', 'c53f70054f0b05602c4d0f26d2138890.jpg', 4, 12, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(66, 'WC026', NULL, 'Men`s Classic Line', '1', '170.0000', '195.0000', '10', '8273814e4169d5b4c980ee2a7fddacf7.jpg', 4, 12, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(67, 'WC027', NULL, 'Men`s Newburgh Chronograph', '1', '60.0000', '73.0000', '10', '24a48d00269f2093e961e60fd3908d97.jpg', 4, 13, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(68, 'WC028', NULL, 'Men`s Amsterdam', '1', '70.0000', '84.0000', '10', 'f42032b1982b4b371ef4a0e7123b98e2.jpg', 4, 13, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(69, 'WC029', NULL, 'Men`s Chronograph', '1', '90.0000', '108.0000', '10', 'c1a699a4dc8c04a73c8c3ad8ce5f4004.jpg', 4, 13, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(70, 'WC030', NULL, 'Unisex Superstar', '1', '77.5000', '92.0000', '10', '07656d240c9271ad86550bd353165f1c.jpg', 4, 13, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(71, 'WC031', NULL, 'Unisex Brisbane', '1', '55.0000', '60.0000', '10', 'ef09a057efde7eb9fec3512ec003ffb5.jpg', 4, 13, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(72, 'WC032', NULL, 'Unisex Brisbane', '1', '10.0000', '60.0000', '10', 'bbab9e21cb046369600f06798901beba.jpg', 4, 13, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(73, 'WC033', NULL, 'Unisex Santiago XL', '1', '50.0000', '57.0000', '10', '167a4c5682591df1877e1b45880713f8.jpg', 4, 13, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(74, 'WC034', NULL, 'Unisex Santiago Country Colours', '1', '39.0000', '44.0000', '10', '5fc504a9fbc4e39f3d63f3cfb35077ea.jpg', 4, 13, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(75, 'WC035', NULL, 'Men`s Manchester', '1', '55.0000', '66.0000', '10', 'b8fbd14860f37b1bbbe2640c5fbfdb76.jpg', 4, 13, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(76, 'WC036', NULL, 'Unisex Brisbane', '1', '55.0000', '60.0000', '10', '96095db1deb8321d755a241041c622a5.jpg', 4, 13, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(77, 'WC037', NULL, 'Unisex Brisbane Bracelet', '1', '55.0000', '59.0000', '10', '752fb25985c4bf572ef64006f140d690.jpg', 4, 13, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(78, 'WC038', NULL, 'Men`s Adelaide', '1', '80.0000', '89.0000', '10', '338c00fd701d2fe26f4a63b31688541e.jpg', 4, 15, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(79, 'WC039', NULL, 'Men`s Austin', '1', '85.0000', '99.0000', '10', '554d5c7b7b3eb9d83158a25f972dc92e.jpg', 4, 15, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(80, 'WC040', NULL, 'Men`s Seattle Chronograph', '1', '160.0000', '175.0000', '10', '388548a80d275000f3df93d4046219ad.jpg', 4, 15, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(81, 'WC041', NULL, 'Ladies', '1', '55.0000', '64.5000', '10', '33cd5a0caae90e70be6666898e20ea80.jpg', 4, 15, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(82, 'WC042', NULL, 'Men`s Montreal', '1', '80.0000', '99.5000', '10', '0873e3c0816a590f30dd620cac23ca2d.jpg', 4, 15, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(83, 'WC043', NULL, 'Unisex Goa', '1', '33.0000', '50.0000', '10', '1bee10dd657ce0c118111ebafa2625d9.jpg', 4, 15, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(84, 'WC044', NULL, 'Men`s Seattle', '1', '105.0000', '125.0000', '10', 'e7e6f2c324af7d03d4a94c7d88d0614e.jpg', 4, 15, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(85, 'WC045', NULL, 'Unisex 12.12', '1', '60.0000', '75.0000', '10', '97998a30ac3d40b2d9bf1e80f5abf853.jpg', 4, 15, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(86, 'CL001', NULL, 'Lindbergh Shirt with All Over Print Slim Fit', '1', '80.0000', '90.0000', '10', 'bb232011bbe12a71d1c8f43bf088b632.jpg', 2, 6, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(87, 'CL002', NULL, 'Lindbergh Shirt in Stretch Poplin Slim Fit', '1', '80.0000', '90.0000', '10', '20598bf20bf59bc0798107d845cecc4d.jpg', 2, 6, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(88, 'CL003', NULL, 'G-Star T-Shirt Hujan Raw Print', '1', '48.0000', '90.0000', '10', '2b17ed3878e68c4bef9bb0efba911ee8.jpg', 2, 6, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(89, 'CL004', NULL, 'adidas Originals Skinny Trackpants With Panels', '1', '50.0000', '73.0000', '10', '1389a15793aa232e5488569acb05e9ad.jpg', 2, 6, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(90, 'CL005', NULL, 'Jack Wills Shirt in Blue Check Poplin', '1', '157.0000', '107.0000', '10', '7f5a1ddb647f9059481647c827efc8c0.jpg', 2, 6, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(91, 'CL006', NULL, 'Lyle & Scott Zip Through Hoodie with Eagle Logo', '1', '110.0000', '135.0000', '10', '625ab746730c26cc6df54741864b286a.jpg', 2, 6, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(92, 'CL007', NULL, 'River Island Check Slim Fit Blazer', '1', '140.0000', '162.0000', '10', '78bc38d4e76a8657961fa6c87c161ae1.jpg', 2, 6, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(93, 'CL008', NULL, 'Lyle & Scott Shirt in Gingham Check', '1', '110.0000', '135.0000', '10', 'cd78200d8bede8033d9b5f62e01e2a8b.jpg', 2, 6, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(94, 'CL009', NULL, 'ASOS Holidays Sweater with Baubles', '1', '60.0000', '72.0000', '10', 'b1fb5dcc555668dfbe85805b76afde4f.jpg', 2, 7, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(95, 'CL010', NULL, 'ASOS TALL 3/4 Sleeve White Shirt', '1', '20.0000', '26.0000', '10', '0236de9306bd7f14afdd708d0edb88bc.jpg', 2, 7, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(96, 'CL011', NULL, 'AASOS Lace And Mix Velvet Body-Conscious Dress', '1', '60.0000', '72.0000', '10', 'c6147919279a774daeaff33f7958afed.jpg', 2, 7, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(97, 'CL012', NULL, 'ASOS Holidays Sweater With Embellished Snowflake', '1', '55.0000', '69.0000', '10', 'fb2b764eb5cea3626dfdd8a48b39d35f.jpg', 2, 7, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(98, 'CL014', NULL, 'Monki Shirt Dress With Tie Waist', '1', '55.0000', '63.0000', '10', '0846dd2d0fa0da1c5f9461d3b6bc4927.jpg', 2, 7, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(99, 'CL015', NULL, 'ASOS Slim A-Line Skirt in Metallic Flower Jacquard', '1', '65.0000', '81.0000', '10', '67534ce68a47347b2654871d7e5d28b3.jpg', 2, 7, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(100, 'CL016', NULL, 'Vila Chunky Long Sleeve Roll Neck Sweater', '1', '20.0000', '33.0000', '10', '8a61daa6a1b1cb7b057b76b9086b53ad.jpg', 2, 7, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(101, 'CL017', NULL, 'Chi Chi London Petite Rose Print Floral Prom Dress', '1', '75.0000', '99.0000', '10', '307f4fca32c41158e824ed3552bd667f.jpg', 2, 7, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(102, 'CL018', NULL, 'Baby Girls Princess Birthday Party White Formal Gown Dress with', '1', '4.0000', '6.2700', '10', 'c95788bd8f82e0bb5805a74cc2cca6ec.jpg', 2, 8, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(103, 'CL019', NULL, 'New Fashion Casual Kids Girls Short Cup Sleeve Elastic Waist Top And', '1', '6.0000', '7.7500', '10', '7ad13246d228813639006d669055a8e6.jpg', 2, 8, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(104, 'CL020', NULL, 'New Cute Kids Boys Two Pieces Clothing Sets Plaid Long Sleeve Shirt', '1', '5.0000', '6.6700', '10', '04f2d2f0787aa76463a9393635f88f20.jpg', 2, 8, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(105, 'CL021', NULL, 'Cute Girl (big) Bowknot Netting Patchwork Pageant Wedding', '1', '5.0000', '6.9100', '10', 'ac63e3d6ea2062bc6a35efe04a5edbf4.jpg', 2, 8, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(106, 'CL022', NULL, 'Fashion New Set Coats Jackets And Pants Clothes Children Age Sizes', '1', '5.0000', '6.2100', '10', 'a966891654925505dacbba07fe197877.jpg', 2, 8, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(107, 'CL023', NULL, 'New Cute Children Kids Two Pieces Fashion Solid Loose Fitting School', '1', '5.0000', '6.9100', '10', '253b677680ce83029e4f0b4a12445340.jpg', 2, 8, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(108, 'CL024', NULL, 'New Kids Girls Wear Sleeveless', '1', '3.0000', '4.5900', '10', 'ea7405d98434be6063f7fb61ac3f4ab7.jpg', 2, 8, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(109, 'CL025', NULL, 'New Kids Girls Wear Sleeveless O-Neck Stripe Korean Style Cute', '1', '2.0000', '3.0900', '10', '0a89b43b67ecc6e0f6fb2477abd88f2d.jpg', 2, 8, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(110, 'CL026', NULL, 'Children Boy Wear Short Sleeve', '1', '4.0000', '5.7500', '10', '27f0c8adae1daa5ceb0c1c8e7b46426c.jpg', 2, 8, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(111, 'CL027', NULL, 'Cartoon Baby Fleece LADYBIRD BEE Cosplay Costume Fancy Dress', '1', '4.0000', '7.3700', '10', '9099f09642f71b068b09e6be415b570f.jpg', 2, 9, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(112, 'CL028', NULL, 'Cute Baby Pullover 6M-18M Stripe Short Sleeve T-Shirt + Overalls Pants', '1', '4.0000', '6.0000', '10', 'f179c7191e26f72edbb0ab7ea9862fb7.jpg', 2, 9, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(113, 'CL029', NULL, 'Baby Winter Costume Hooded Snow Suit Baby Sleepsuit Rompers 6M-12M', '1', '9.0000', '11.5300', '10', 'ace333cb6ef5f96eca26c35d7117e3ae.jpg', 2, 9, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(114, 'CL030', NULL, 'Baby Infant Toddler Kid Summer Cartoon Pattern Suspenders Pants', '1', '2.5000', '5.0500', '10', 'c44459d3083dbcefe08362ca9fbbafbe.jpg', 2, 9, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(115, 'CL031', NULL, 'Baby Girl`s Summer Loose Short Sleeve Dresses Dot Pattern', '1', '4.0000', '5.5200', '10', '00c65e79779b381509e208dae8afd1bc.jpg', 2, 9, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(116, 'CL032', NULL, 'Baby Toddlers Summer Outfit Girl Angel Wings Top+ Ruffle Pants 6-24', '1', '4.0000', '6.1100', '10', 'b05d85d4b81455287e45e3da4426b742.jpg', 2, 9, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(117, 'CL033', NULL, 'Baby Toddler Winter Snow Suit Thermal Underwear', '1', '7.0000', '9.9100', '10', '480aec054400afb304af97602fbed2c7.jpg', 2, 9, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(118, 'CL034', NULL, 'Superman Suit Fancy Costume Jumpsuit for Baby Toddler Kid Boy', '1', '10.0000', '15.2100', '10', 'e01f5f3c263399f8adb7f26c4f59524a.jpg', 2, 9, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(119, 'FD001', NULL, 'Kelloggs Elevenses Raisin 6 X 45G', '1', '1.7000', '2.2900', '10', '542acb223cdde7038ae58ad4f8e7d0ee.jpg', 5, NULL, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(120, 'FD002', NULL, 'Nature Valley Peanuts Pumpkin Sunflower 150G', '1', '2.0000', '2.8900', '10', '8378e89ec294406e99dac831a19cbd41.jpg', 5, NULL, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(121, 'FD003', NULL, 'Cadbury`s Brunch Bars Raisin 6X32g', '1', '1.2000', '1.9900', '10', '48e4d0805665552a9a43451578bd09ee.jpg', 5, NULL, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(122, 'FD004', NULL, 'Go Ahead Raspberry Yoghurt Breaks Cereal Bars 5...', '1', '1.2000', '1.9900', '10', '35ce3968bfad41621742ffcaaea1f9e8.jpg', 5, NULL, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(123, 'FD005', NULL, 'Kelloggs Elevenses Chocolate Chip 6X45g', '1', '1.7000', '2.2900', '10', 'e80b7f8477bc1026ac870c87ef7a2979.jpg', 5, NULL, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(124, 'FD006', NULL, 'Nakd Strawberry Crunch 4X30g', '1', '1.7000', '2.4900', '10', 'dfc71203ef9fcf5dc715adbf376099bf.jpg', 5, NULL, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(125, 'FD007', NULL, 'Quaker Oats So Simple Maple And Pecan Crunchy', '1', '1.0000', '1.7900', '10', '5ffc9cfcc6437630d7da28ef9e044b13.jpg', 5, NULL, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(126, 'FD008', NULL, 'Tesco Original Porridge Pots 55Gge', '1', '20.0000', '39.0000', '10', 'e2ca269ea0e58e7aaab83382cfa98bd8.jpg', 5, NULL, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(127, 'FD009', NULL, 'Bol Singapore Noodles 380G', '1', '1.0000', '3.0000', '10', 'cd788fae573871e4e191023e54590310.jpg', 5, NULL, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(128, 'FD010', NULL, 'Bol Sri Lankan Lentil Sambar 380G', '1', '12.0000', '30.0000', '10', '6847e82420a4cf23c1c4d623f4fe8093.jpg', 5, NULL, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(129, 'FD011', NULL, 'Shore Lunch Soup Mix Classic Chicken Noodle', '1', '2.5000', '3.1100', '10', 'a8e60d97b0f971593105e9bbeed8195a.jpg', 5, NULL, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(130, 'FD012', NULL, 'Health Valley Organic Soup No Salt Added Vegetable', '1', '1.9000', '2.5400', '10', 'e832b56c4bea5a7c7e18ac9390c6bcbd.jpg', 5, NULL, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(131, 'FD013', NULL, 'Health Valley Organic Soup No Salt Added Tomato', '1', '1.9000', '2.3700', '10', '5221cdb7f8ff285c2804a1caf4aa229a.jpg', 5, NULL, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(132, 'FD014', NULL, 'Natural Value Paper Lunch Bags', '1', '1.5000', '2.1700', '10', 'c3b3ee2d3b640f0ed1290f4e04eb7fe7.jpg', 5, NULL, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(133, 'FD015', NULL, 'Health Valley Organic Soup No Salt Added Mushroom Barley', '1', '2.0000', '2.4600', '10', 'd6f4dd37c387ac5a9c3ffdf04d18c018.jpg', 5, NULL, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(134, 'FD016', NULL, 'Health Valley Organic Soup', '1', '2.0000', '2.4600', '10', '5c50b5593a16232bc55f113d3d3cc25f.jpg', 5, NULL, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(135, 'FD017', NULL, 'Mount Hagen Organic Fair Trade Instant Coffee', '1', '9.0000', '9.7900', '10', '872e4949716be481cbe3b7cc140548fa.jpg', 5, NULL, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(136, 'FD018', NULL, 'Pero Instant Natural Beverage', '1', '5.0000', '6.2900', '10', 'e0a193277fac14e9a6ed24345112560b.jpg', 5, NULL, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(137, 'FD019', NULL, 'First Colony Discoveries Organic Whole Bean Medium Roast Peruvian Andes Gold', '1', '14.0000', '15.3900', '10', '09825b204c4056580070e1752b3730f7.jpg', 5, NULL, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(138, 'FD020', NULL, 'Teeccino Chicory Herbal `Coffee` Ground Vanilla Nut', '1', '7.0000', '8.4900', '10', 'b44e176d212afb8a8192e4b9c6d9db28.jpg', 5, NULL, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(139, 'FD021', NULL, 'Dandy Blend Instant Herbal Beverage with Dandelion', '1', '24.0000', '29.6900', '10', 'f70c98481e853a3127a7b83c1f3076c8.jpg', 5, NULL, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(140, 'FD022', NULL, 'The Organic Coffee Co K-Cups French Roast', '1', '6.0000', '8.5900', '10', 'fab745de1e9149cfcfb5458ea8415d20.jpg', 5, NULL, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(141, 'FD023', NULL, 'Life Extension Rich Rewards Ground Coffee Decaf Roast', '1', '8.0000', '10.5000', '10', 'e04af78b26848d1f552ff16c9ba4c50a.jpg', 5, NULL, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(142, 'FD024', NULL, 'Teeccino Organic Herbal Coffee Alternative Chocolate', '1', '7.0000', '8.4900', '10', '605d731cc9f5b970f9fa0f5dadf8620e.jpg', 5, NULL, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(143, 'FD025', NULL, 'Vita Coco Pure Coconut Water', '1', '3.5000', '4.5900', '10', '8a9968950ec2280fc67c81ab6a6ff8ba.jpg', 5, NULL, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(144, 'FD026', NULL, 'Vita Coco Cafe Coconut Water Cafe Latte Mocha', '1', '1.9000', '2.5900', '10', '4471897c69edf6fcdd1c2dcaafa2a809.jpg', 5, NULL, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(145, 'FD027', NULL, 'Vita Coco Cafe Coconut Water Cafe Latte Espresso', '1', '1.9000', '2.5900', '10', 'ef3d100fdd347f219c7148125548ccc4.jpg', 5, NULL, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(146, 'FD028', NULL, 'Vita Coco Cafe Coconut Water Cafe Latte Vanilla', '1', '1.9000', '2.5900', '10', '93dd94525650ac00b25a0163a17f7eaf.jpg', 5, NULL, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(147, 'FD029', NULL, 'Vita Coco Cafe Coconut Water Cafe Latte Vanilla', '1', '14.0000', '15.2900', '10', '861deb17594cba50d2bb0ec9afce33c8.jpg', 5, NULL, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(148, 'FD030', NULL, 'ALO Coco Exposed', '1', '1.4000', '1.7900', '10', '55f07ee492df4525008b9143667e9617.jpg', 5, NULL, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(149, 'PH039', NULL, 'Viva Madrid Leather Sabio Serio iPhone 6 Case', '1', '27.0000', '29.0000', '10', '35649a2e92c5fc445cf9623bd922d3f5.jpg', 1, 5, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(150, 'PH040', NULL, 'VIVA MADRID Case', '1', '27.0000', '29.0000', '10', 'ca4a200adc0a0699aa2558d4b8524cb4.jpg', 1, 5, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(151, 'PH041', NULL, 'JBL Bluetooth Headphones E40BT Bluetooth', '1', '118.0000', '129.0000', '10', '2c81bb84dd86bf37e37bac57407a769e.jpg', 1, 5, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(152, 'PH042', NULL, 'Explorer 500 Bluetooth', '1', '80.0000', '95.0000', '10', '70efb615d9341904963969b24e22519c.jpg', 1, 5, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  INSERT INTO `erp_products` (`id`, `code`, `name_kh`, `name`, `unit`, `cost`, `price`, `alert_quantity`, `image`, `category_id`, `subcategory_id`, `cf1`, `cf2`, `cf3`, `cf4`, `cf5`, `cf6`, `quantity`, `tax_rate`, `track_quantity`, `details`, `warehouse`, `barcode_symbology`, `file`, `product_details`, `tax_method`, `type`, `supplier1`, `supplier1price`, `supplier2`, `supplier2price`, `supplier3`, `supplier3price`, `supplier4`, `supplier4price`, `supplier5`, `supplier5price`, `no`, `promotion`, `promo_price`, `start_date`, `end_date`, `supplier1_part_no`, `supplier2_part_no`, `supplier3_part_no`, `supplier4_part_no`, `supplier5_part_no`, `currentcy_code`, `inactived`, `brand_id`, `opening_stock`) VALUES(153, 'PH043', NULL, 'JBL Pulse Wireless Speaker Speakers', '1', '230.0000', '249.0000', '10', '6fea555b8d305b76b1f5db604f5fe052.jpg', 1, 5, '', '', '', '', '', '', NULL, 1, 1, NULL, NULL, 'code128', NULL, NULL, 0, 'standard', 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'USD', 0, NULL, NULL);
  
  
  /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  