#
# TABLE STRUCTURE FOR: acc_coa
#

DROP TABLE IF EXISTS `acc_coa`;

CREATE TABLE `acc_coa` (
  `HeadCode` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `HeadName` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `PHeadName` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `HeadLevel` int(11) NOT NULL,
  `IsActive` tinyint(1) NOT NULL,
  `IsTransaction` tinyint(1) NOT NULL,
  `IsGL` tinyint(1) NOT NULL,
  `HeadType` char(1) COLLATE utf8_unicode_ci NOT NULL,
  `IsBudget` tinyint(1) NOT NULL,
  `IsDepreciation` tinyint(1) NOT NULL,
  `DepreciationRate` decimal(18,2) NOT NULL,
  `CreateBy` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `CreateDate` datetime NOT NULL,
  `UpdateBy` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `UpdateDate` datetime NOT NULL,
  PRIMARY KEY (`HeadName`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('4021403', 'AC', 'Repair and Maintenance', '3', '1', '1', '0', 'E', '0', '0', '0.00', 'admin', '2015-10-15 19:33:55', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('50202', 'Account Payable', 'Current Liabilities', '2', '1', '0', '1', 'L', '0', '0', '0.00', 'admin', '2015-10-15 19:50:43', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('10203', 'Account Receivable', 'الأصول المتداولة', '2', '1', '0', '0', 'A', '0', '0', '0.00', '', '2015-10-15 00:00:00', 'admin', '2013-09-18 15:29:35');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('1020201', 'Advance', 'Advance, Deposit And Pre-payments', '3', '1', '0', '1', 'A', '0', '0', '0.00', 'Zoherul', '2015-05-31 13:29:12', 'admin', '2015-12-31 16:46:32');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('102020103', 'Advance House Rent', 'Advance', '4', '1', '1', '0', 'A', '0', '0', '0.00', 'admin', '2016-10-02 16:55:38', 'admin', '2016-10-02 16:57:32');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('10202', 'Advance, Deposit And Pre-payments', 'الأصول المتداولة', '2', '1', '0', '0', 'A', '0', '0', '0.00', '', '2015-10-15 00:00:00', 'admin', '2015-12-31 16:46:24');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('4020602', 'Advertisement and Publicity', 'Promonational Expence', '3', '1', '1', '0', 'E', '0', '0', '0.00', 'admin', '2015-10-15 18:51:44', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('1010410', 'Air Cooler', 'Others Assets', '3', '1', '1', '0', 'A', '0', '0', '0.00', 'admin', '2016-05-23 12:13:55', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('4020603', 'AIT Against Advertisement', 'Promonational Expence', '3', '1', '1', '0', 'E', '0', '0', '0.00', 'admin', '2015-10-15 18:52:09', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('1010204', 'Attendance Machine', 'Office Equipment', '3', '1', '1', '0', 'A', '0', '0', '0.00', 'admin', '2015-10-15 15:49:31', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('40216', 'Audit Fee', 'Other Expenses', '2', '1', '1', '1', 'E', '0', '0', '0.00', 'admin', '2017-07-18 12:54:30', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('102010202', 'Bank AlFalah', 'Cash At Bank', '4', '1', '1', '1', 'A', '0', '0', '0.00', 'admin', '2015-10-15 15:32:37', 'admin', '2015-10-15 15:32:52');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('4021002', 'Bank Charge', 'Financial Expenses', '3', '1', '1', '0', 'E', '0', '0', '0.00', 'admin', '2015-10-15 19:21:03', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('30203', 'Bank Interest', 'ايرادات اخرى', '2', '1', '1', '1', 'I', '0', '0', '0.00', 'Obaidul', '2015-01-03 14:49:54', 'admin', '2016-09-25 11:04:19');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('1010104', 'Book Shelf', 'Furniture & Fixturers', '3', '1', '1', '0', 'A', '0', '0', '0.00', 'admin', '2015-10-15 15:46:11', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('1010407', 'Books and Journal', 'Others Assets', '3', '1', '1', '0', 'A', '0', '0', '0.00', 'admin', '2016-03-27 10:45:37', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('10201020301', 'Branch 1', 'Standard Bank', '5', '1', '1', '1', 'A', '0', '0', '0.00', '2', '2018-07-19 13:44:33', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('4020604', 'Business Development Expenses', 'Promonational Expence', '3', '1', '1', '0', 'E', '0', '0', '0.00', 'admin', '2015-10-15 18:52:29', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('4020606', 'Campaign Expenses', 'Promonational Expence', '3', '1', '1', '0', 'E', '0', '0', '0.00', 'admin', '2015-10-15 18:52:57', 'admin', '2016-09-19 14:52:48');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('4020502', 'Campus Rent', 'House Rent', '3', '1', '1', '0', 'E', '0', '0', '0.00', 'admin', '2015-10-15 18:46:53', 'admin', '2017-04-27 17:02:39');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('40212', 'Car Running Expenses', 'Other Expenses', '2', '1', '0', '1', 'E', '0', '0', '0.00', 'admin', '2015-10-15 19:28:43', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('1020102', 'Cash At Bank', 'النقد وما يعادله', '3', '1', '0', '0', 'A', '0', '0', '0.00', '2', '2018-07-19 13:43:59', 'admin', '2015-10-15 15:32:42');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('1020101', 'Cash In Hand', 'النقد وما يعادله', '3', '1', '1', '1', 'A', '0', '0', '0.00', '2', '2018-07-31 12:56:28', 'admin', '2016-05-23 12:05:43');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('30101', 'Cash Sale', 'ايرادات المتجر', '1', '1', '1', '1', 'I', '0', '0', '0.00', '2', '2018-07-08 07:51:26', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('1020101000001', 'Cash-CW3-Yemen W3', 'Cash In Hand', '4', '1', '1', '0', 'A', '0', '0', '0.00', '1', '2026-01-30 00:21:41', '', '0000-00-00 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('1020101000002', 'Cash-zxzx-المخزن الرائيسي', 'Cash In Hand', '4', '1', '1', '0', 'A', '0', '0', '0.00', '1', '2026-02-26 00:45:04', '', '0000-00-00 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('1020301000001', 'cc-1-فواز عبدالله علي قاسم', 'Customer Receivable', '4', '1', '1', '0', 'A', '0', '0', '0.00', '1', '2026-01-30 02:45:11', '', '0000-00-00 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('1020301000002', 'cc-2-فواز عبدالله', 'Customer Receivable', '4', '1', '1', '0', 'A', '0', '0', '0.00', '1', '2026-02-26 00:39:10', '', '0000-00-00 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('1010207', 'CCTV', 'Office Equipment', '3', '1', '1', '0', 'A', '0', '0', '0.00', 'admin', '2015-10-15 15:51:24', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('102020102', 'CEO Current A/C', 'Advance', '4', '1', '1', '0', 'A', '0', '0', '0.00', 'admin', '2016-09-25 11:54:54', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('1010101', 'Class Room Chair', 'Furniture & Fixturers', '3', '1', '1', '0', 'A', '0', '0', '0.00', 'admin', '2015-10-15 15:45:29', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('4021407', 'Close Circuit Cemera', 'Repair and Maintenance', '3', '1', '1', '0', 'E', '0', '0', '0.00', 'admin', '2015-10-15 19:35:35', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('4020601', 'Commision on Admission', 'Promonational Expence', '3', '1', '1', '0', 'E', '0', '0', '0.00', 'admin', '2015-10-15 18:51:21', 'admin', '2016-09-19 14:42:54');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('1010206', 'Computer', 'Office Equipment', '3', '1', '1', '0', 'A', '0', '0', '0.00', 'admin', '2015-10-15 15:51:09', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('4021410', 'Computer (R)', 'Repair and Maintenance', '3', '1', '1', '0', 'E', '0', '0', '0.00', 'Zoherul', '2016-03-24 12:38:52', 'Zoherul', '2016-03-24 12:41:40');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('1010102', 'Computer Table', 'Furniture & Fixturers', '3', '1', '1', '0', 'A', '0', '0', '0.00', 'admin', '2015-10-15 15:45:44', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('301020401', 'Continuing Registration fee - UoL (Income)', 'Registration Fee (UOL) Income', '4', '1', '1', '0', 'I', '0', '0', '0.00', 'admin', '2015-10-15 17:40:40', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('4020904', 'Contratuall Staff Salary', 'Salary & Allowances', '3', '1', '1', '0', 'E', '0', '0', '0.00', 'admin', '2015-10-15 19:12:34', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('403', 'Cost of Sale', 'المصروفات', '0', '1', '1', '0', 'E', '0', '0', '0.00', '2', '2018-07-08 10:37:16', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('4020709', 'Cultural Expense', 'Miscellaneous Expenses', '3', '1', '1', '0', 'E', '0', '0', '0.00', 'nasmud', '2017-04-29 12:45:10', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('502', 'Current Liabilities', 'الإلتزامات', '1', '1', '0', '0', 'L', '0', '0', '0.00', 'anwarul', '2014-08-30 13:18:20', 'admin', '2015-10-15 19:49:21');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('1020301', 'Customer Receivable', 'Account Receivable', '3', '1', '0', '1', 'A', '0', '0', '0.00', 'admin', '2015-10-15 15:34:31', 'admin', '2018-07-07 12:31:42');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('40100002', 'cw-Chichawatni', 'Store Expenses', '2', '1', '1', '0', 'E', '0', '0', '0.00', '2', '2018-08-02 16:30:41', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('40100003', 'CW3-Yemen W3', 'Store Expenses', '2', '1', '1', '0', 'E', '0', '0', '0.00', '1', '2026-01-30 00:21:41', '', '0000-00-00 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('1020202', 'Deposit', 'Advance, Deposit And Pre-payments', '3', '1', '0', '0', 'A', '0', '0', '0.00', 'admin', '2015-10-15 15:40:42', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('4020605', 'Design & Printing Expense', 'Promonational Expence', '3', '1', '1', '0', 'E', '0', '0', '0.00', 'admin', '2015-10-15 18:55:00', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('4020404', 'Dish Bill', 'Utility Expenses', '3', '1', '1', '0', 'E', '0', '0', '0.00', 'admin', '2015-10-15 18:58:21', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('40215', 'Dividend', 'Other Expenses', '2', '1', '1', '1', 'E', '0', '0', '0.00', 'admin', '2016-09-25 14:07:55', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('4020403', 'Drinking Water Bill', 'Utility Expenses', '3', '1', '1', '0', 'E', '0', '0', '0.00', 'admin', '2015-10-15 18:58:10', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('1010211', 'DSLR Camera', 'Office Equipment', '3', '1', '1', '0', 'A', '0', '0', '0.00', 'admin', '2015-10-15 15:53:17', 'admin', '2016-01-02 16:23:25');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('4020908', 'Earned Leave', 'Salary & Allowances', '3', '1', '1', '0', 'E', '0', '0', '0.00', 'admin', '2015-10-15 19:13:38', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('4020607', 'Education Fair Expenses', 'Promonational Expence', '3', '1', '1', '0', 'E', '0', '0', '0.00', 'admin', '2015-10-15 18:53:42', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('1010602', 'Electric Equipment', 'Electrical Equipment', '3', '1', '1', '0', 'A', '0', '0', '0.00', 'admin', '2016-03-27 10:44:51', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('1010203', 'Electric Kettle', 'Office Equipment', '3', '1', '1', '0', 'A', '0', '0', '0.00', 'admin', '2015-10-15 15:49:07', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('10106', 'Electrical Equipment', 'الأصول الغير متداولة', '2', '1', '0', '1', 'A', '0', '0', '0.00', 'admin', '2016-03-27 10:43:44', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('4020407', 'Electricity Bill', 'Utility Expenses', '3', '1', '1', '0', 'E', '0', '0', '0.00', 'admin', '2015-10-15 18:59:31', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('10202010501', 'employ', 'Salary', '5', '1', '0', '0', 'A', '0', '0', '0.00', 'admin', '2018-07-05 11:47:10', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('40201', 'Entertainment', 'Other Expenses', '2', '1', '1', '1', 'E', '0', '0', '0.00', 'admin', '2013-07-08 16:21:26', 'anwarul', '2013-07-17 14:21:47');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('4020903', 'Faculty,Staff Salary & Allowances', 'Salary & Allowances', '3', '1', '1', '0', 'E', '0', '0', '0.00', 'admin', '2015-10-15 19:12:21', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('4021404', 'Fax Machine', 'Repair and Maintenance', '3', '1', '1', '0', 'E', '0', '0', '0.00', 'admin', '2015-10-15 19:34:15', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('4020905', 'Festival & Incentive Bonus', 'Salary & Allowances', '3', '1', '1', '0', 'E', '0', '0', '0.00', 'admin', '2015-10-15 19:12:48', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('1010103', 'File Cabinet', 'Furniture & Fixturers', '3', '1', '1', '0', 'A', '0', '0', '0.00', 'admin', '2015-10-15 15:46:02', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('40210', 'Financial Expenses', 'Other Expenses', '2', '1', '0', '1', 'E', '0', '0', '0.00', 'anwarul', '2013-08-20 12:24:31', 'admin', '2015-10-15 19:20:36');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('1010403', 'Fire Extingushier', 'Others Assets', '3', '1', '1', '0', 'A', '0', '0', '0.00', 'admin', '2016-03-27 10:39:32', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('4021408', 'Furniture', 'Repair and Maintenance', '3', '1', '1', '0', 'E', '0', '0', '0.00', 'admin', '2015-10-15 19:35:47', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('10101', 'Furniture & Fixturers', 'الأصول الغير متداولة', '2', '1', '0', '1', 'A', '0', '0', '0.00', 'anwarul', '2013-08-20 16:18:15', 'anwarul', '2013-08-21 13:35:40');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('4020406', 'Gas Bill', 'Utility Expenses', '3', '1', '1', '0', 'E', '0', '0', '0.00', 'admin', '2015-10-15 18:59:20', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('20201', 'General Reserve', 'Reserve & Surplus', '2', '1', '1', '0', 'L', '0', '0', '0.00', 'admin', '2016-09-25 14:07:12', 'admin', '2016-10-02 17:48:49');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('10105', 'Generator', 'الأصول الغير متداولة', '2', '1', '1', '1', 'A', '0', '0', '0.00', 'Zoherul', '2016-02-27 16:02:35', 'admin', '2016-05-23 12:05:18');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('4021414', 'Generator Repair', 'Repair and Maintenance', '3', '1', '1', '0', 'E', '0', '0', '0.00', 'Zoherul', '2016-06-16 10:21:05', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('40213', 'Generator Running Expenses', 'Other Expenses', '2', '1', '0', '1', 'E', '0', '0', '0.00', 'admin', '2015-10-15 19:29:29', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('10103', 'Groceries and Cutleries', 'الأصول الغير متداولة', '2', '1', '1', '1', 'A', '0', '0', '0.00', '2', '2018-07-12 10:02:55', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('1010408', 'Gym Equipment', 'Others Assets', '3', '1', '1', '0', 'A', '0', '0', '0.00', 'admin', '2016-03-27 10:46:03', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('4020907', 'Honorarium', 'Salary & Allowances', '3', '1', '1', '0', 'E', '0', '0', '0.00', 'admin', '2015-10-15 19:13:26', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('40205', 'House Rent', 'Other Expenses', '2', '1', '0', '1', 'E', '0', '0', '0.00', 'anwarul', '2013-08-24 10:26:56', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('40100001', 'HP-Hasilpur', 'Academic Expenses', '2', '1', '1', '0', 'E', '0', '0', '0.00', '2', '2018-07-29 03:44:23', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('4020702', 'HR Recruitment Expenses', 'Miscellaneous Expenses', '3', '1', '1', '0', 'E', '0', '0', '0.00', 'admin', '2016-09-25 12:55:49', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('4020703', 'Incentive on Admission', 'Miscellaneous Expenses', '3', '1', '1', '0', 'E', '0', '0', '0.00', 'admin', '2016-09-25 12:56:09', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('30204', 'Income from Photocopy & Printing', 'ايرادات اخرى', '2', '1', '1', '1', 'I', '0', '0', '0.00', 'Zoherul', '2015-07-14 10:29:54', 'admin', '2016-09-25 11:04:28');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('5020302', 'Income Tax Payable', 'Liabilities for Expenses', '3', '1', '0', '1', 'L', '0', '0', '0.00', 'admin', '2016-09-19 11:18:17', 'admin', '2016-09-28 13:18:35');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('102020302', 'Insurance Premium', 'Prepayment', '4', '1', '1', '0', 'A', '0', '0', '0.00', 'admin', '2016-09-19 13:10:57', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('4021001', 'Interest on Loan', 'Financial Expenses', '3', '1', '1', '0', 'E', '0', '0', '0.00', 'admin', '2015-10-15 19:20:53', 'admin', '2016-09-19 14:53:34');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('4020401', 'Internet Bill', 'Utility Expenses', '3', '1', '1', '0', 'E', '0', '0', '0.00', 'admin', '2015-10-15 18:56:55', 'admin', '2015-10-15 18:57:32');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('10107', 'Inventory', 'الأصول الغير متداولة', '1', '1', '0', '0', 'A', '0', '0', '0.00', '2', '2018-07-07 15:21:58', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('10205010101', 'Jahangir', 'Hasan', '1', '1', '0', '0', 'A', '0', '0', '0.00', '2', '2018-07-07 10:40:56', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('1010210', 'LCD TV', 'Office Equipment', '3', '1', '1', '0', 'A', '0', '0', '0.00', 'admin', '2015-10-15 15:52:27', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('30103', 'Lease Sale', 'ايرادات المتجر', '1', '1', '1', '1', 'I', '0', '0', '0.00', '2', '2018-07-08 07:51:52', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('50203', 'Liabilities for Expenses', 'Current Liabilities', '2', '1', '0', '0', 'L', '0', '0', '0.00', 'admin', '2015-10-15 19:50:59', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('4020707', 'Library Expenses', 'Miscellaneous Expenses', '3', '1', '1', '0', 'E', '0', '0', '0.00', 'admin', '2017-01-10 15:34:54', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('4021409', 'Lift', 'Repair and Maintenance', '3', '1', '1', '0', 'E', '0', '0', '0.00', 'admin', '2015-10-15 19:36:12', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('50101', 'Long Term Borrowing', 'Non Current Liabilities', '2', '1', '0', '1', 'L', '0', '0', '0.00', 'admin', '2013-07-04 12:32:26', 'admin', '2015-10-15 19:47:40');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('4020608', 'Marketing & Promotion Exp.', 'Promonational Expence', '3', '1', '1', '0', 'E', '0', '0', '0.00', 'admin', '2015-10-15 18:53:59', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('4020901', 'Medical Allowance', 'Salary & Allowances', '3', '1', '1', '0', 'E', '0', '0', '0.00', 'admin', '2015-10-15 19:11:33', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('1010411', 'Metal Ditector', 'Others Assets', '3', '1', '1', '0', 'A', '0', '0', '0.00', 'Zoherul', '2016-08-22 10:55:22', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('4021413', 'Micro Oven', 'Repair and Maintenance', '3', '1', '1', '0', 'E', '0', '0', '0.00', 'Zoherul', '2016-05-12 14:53:51', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('30202', 'Miscellaneous (Income)', 'ايرادات اخرى', '2', '1', '1', '1', 'I', '0', '0', '0.00', 'anwarul', '2014-02-06 15:26:31', 'admin', '2016-09-25 11:04:35');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('4020909', 'Miscellaneous Benifit', 'Salary & Allowances', '3', '1', '1', '0', 'E', '0', '0', '0.00', 'admin', '2015-10-15 19:13:53', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('4020701', 'Miscellaneous Exp', 'Miscellaneous Expenses', '3', '1', '1', '0', 'E', '0', '0', '0.00', 'admin', '2016-09-25 12:54:39', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('40207', 'Miscellaneous Expenses', 'Other Expenses', '2', '1', '0', '1', 'E', '0', '0', '0.00', 'anwarul', '2014-04-26 16:49:56', 'admin', '2016-09-25 12:54:19');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('1010401', 'Mobile Phone', 'Others Assets', '3', '1', '1', '0', 'A', '0', '0', '0.00', 'admin', '2016-01-29 10:43:30', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('102020101', 'Mr Ashiqur Rahman', 'Advance', '4', '1', '1', '0', 'A', '0', '0', '0.00', 'admin', '2015-12-31 16:47:23', 'admin', '2016-09-25 11:55:13');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('1010212', 'Network Accessories', 'Office Equipment', '3', '1', '1', '0', 'A', '0', '0', '0.00', 'admin', '2016-01-02 16:23:32', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('4020408', 'News Paper Bill', 'Utility Expenses', '3', '1', '1', '0', 'E', '0', '0', '0.00', 'admin', '2016-01-02 15:55:57', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('501', 'Non Current Liabilities', 'الإلتزامات', '1', '1', '0', '0', 'L', '0', '0', '0.00', 'anwarul', '2014-08-30 13:18:20', 'admin', '2015-10-15 19:49:21');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('1010404', 'Office Decoration', 'Others Assets', '3', '1', '1', '0', 'A', '0', '0', '0.00', 'admin', '2016-03-27 10:40:02', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('10102', 'Office Equipment', 'الأصول الغير متداولة', '2', '1', '0', '1', 'A', '0', '0', '0.00', 'anwarul', '2013-12-06 18:08:00', 'admin', '2015-10-15 15:48:21');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('4021401', 'Office Repair & Maintenance', 'Repair and Maintenance', '3', '1', '1', '0', 'E', '0', '0', '0.00', 'admin', '2015-10-15 19:33:15', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('30201', 'Office Stationary (Income)', 'ايرادات اخرى', '2', '1', '1', '1', 'I', '0', '0', '0.00', 'anwarul', '2013-07-17 15:21:06', 'admin', '2016-09-25 11:04:50');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('402', 'Other Expenses', 'المصروفات', '1', '1', '0', '0', 'E', '0', '0', '0.00', '2', '2018-07-07 14:00:16', 'admin', '2015-10-15 18:37:42');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('40211', 'Others (Non Academic Expenses)', 'Other Expenses', '2', '1', '0', '1', 'E', '0', '0', '0.00', 'Obaidul', '2014-12-03 16:05:42', 'admin', '2015-10-15 19:22:09');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('30205', 'Others (Non-Academic Income)', 'ايرادات اخرى', '2', '1', '0', '1', 'I', '0', '0', '0.00', 'admin', '2015-10-15 17:23:49', 'admin', '2015-10-15 17:57:52');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('10104', 'Others Assets', 'الأصول الغير متداولة', '2', '1', '0', '1', 'A', '0', '0', '0.00', 'admin', '2016-01-29 10:43:16', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('4020910', 'Outstanding Salary', 'Salary & Allowances', '3', '1', '1', '0', 'E', '0', '0', '0.00', 'Zoherul', '2016-04-24 11:56:50', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('4021405', 'Oven', 'Repair and Maintenance', '3', '1', '1', '0', 'E', '0', '0', '0.00', 'admin', '2015-10-15 19:34:31', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('4021412', 'PABX-Repair', 'Repair and Maintenance', '3', '1', '1', '0', 'E', '0', '0', '0.00', 'Zoherul', '2016-04-24 14:40:18', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('4020902', 'Part-time Staff Salary', 'Salary & Allowances', '3', '1', '1', '0', 'E', '0', '0', '0.00', 'admin', '2015-10-15 19:12:06', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('1010202', 'Photocopy & Fax Machine', 'Office Equipment', '3', '1', '1', '0', 'A', '0', '0', '0.00', 'admin', '2015-10-15 15:47:27', 'admin', '2016-05-23 12:14:40');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('4021411', 'Photocopy Machine Repair', 'Repair and Maintenance', '3', '1', '1', '0', 'E', '0', '0', '0.00', 'Zoherul', '2016-04-24 12:40:02', 'admin', '2017-04-27 17:03:17');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('3020503', 'Practical Fee', 'Others (Non-Academic Income)', '3', '1', '1', '1', 'I', '0', '0', '0.00', 'admin', '2017-07-22 18:00:37', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('1020203', 'Prepayment', 'Advance, Deposit And Pre-payments', '3', '1', '0', '1', 'A', '0', '0', '0.00', 'admin', '2015-10-15 15:40:51', 'admin', '2015-12-31 16:49:58');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('1010201', 'Printer', 'Office Equipment', '3', '1', '1', '0', 'A', '0', '0', '0.00', 'admin', '2015-10-15 15:47:15', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('40202', 'Printing and Stationary', 'Other Expenses', '2', '1', '1', '1', 'E', '0', '0', '0.00', 'admin', '2013-07-08 16:21:45', 'admin', '2016-09-19 14:39:32');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('3020502', 'Professional Training Course(Oracal-1)', 'Others (Non-Academic Income)', '3', '1', '1', '0', 'I', '0', '0', '0.00', 'nasim', '2017-06-22 13:28:05', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('30207', 'Professional Training Course(Oracal)', 'ايرادات اخرى', '2', '1', '0', '1', 'I', '0', '0', '0.00', 'nasim', '2017-06-22 13:24:16', 'nasim', '2017-06-22 13:25:56');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('1010208', 'Projector', 'Office Equipment', '3', '1', '1', '0', 'A', '0', '0', '0.00', 'admin', '2015-10-15 15:51:44', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('40206', 'Promonational Expence', 'Other Expenses', '2', '1', '0', '1', 'E', '0', '0', '0.00', 'anwarul', '2013-07-11 13:48:57', 'anwarul', '2013-07-17 14:23:03');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('40214', 'Repair and Maintenance', 'Other Expenses', '2', '1', '0', '1', 'E', '0', '0', '0.00', 'admin', '2015-10-15 19:32:46', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('202', 'Reserve & Surplus', 'حقوق الملكية', '1', '1', '0', '1', 'L', '0', '0', '0.00', 'admin', '2016-09-25 14:06:34', 'admin', '2016-10-02 17:48:57');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('20102', 'Retained Earnings', 'Share Holders Equity', '2', '1', '1', '1', 'L', '0', '0', '0.00', 'admin', '2016-05-23 11:20:40', 'admin', '2016-09-25 14:05:06');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('4020708', 'River Cruse', 'Miscellaneous Expenses', '3', '1', '1', '0', 'E', '0', '0', '0.00', 'admin', '2017-04-24 15:35:25', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('102020105', 'Salary', 'Advance', '4', '1', '0', '0', 'A', '0', '0', '0.00', 'admin', '2018-07-05 11:46:44', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('40209', 'Salary & Allowances', 'Other Expenses', '2', '1', '0', '1', 'E', '0', '0', '0.00', 'anwarul', '2013-12-12 11:22:58', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('404', 'Sale Discount', 'المصروفات', '1', '1', '1', '0', 'E', '0', '0', '0.00', '2', '2018-07-19 10:15:11', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('1010406', 'Security Equipment', 'Others Assets', '3', '1', '1', '0', 'A', '0', '0', '0.00', 'admin', '2016-03-27 10:41:30', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('20101', 'Share Capital', 'Share Holders Equity', '2', '1', '0', '1', 'L', '0', '0', '0.00', 'anwarul', '2013-12-08 19:37:32', 'admin', '2015-10-15 19:45:35');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('201', 'Share Holders Equity', 'حقوق الملكية', '1', '1', '0', '0', 'L', '0', '0', '0.00', '', '2015-10-15 00:00:00', 'admin', '2015-10-15 19:43:51');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('50201', 'Short Term Borrowing', 'Current Liabilities', '2', '1', '0', '1', 'L', '0', '0', '0.00', 'admin', '2015-10-15 19:50:30', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('5020200001', 'Smart Power & Techologies', 'Account Payable', '3', '1', '1', '0', 'L', '0', '0', '0.00', 'admin', '2016-09-25 11:45:12', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('40208', 'Software Development Expenses', 'Other Expenses', '2', '1', '0', '1', 'E', '0', '0', '0.00', 'anwarul', '2013-11-21 14:13:01', 'admin', '2015-10-15 19:02:51');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('4020906', 'Special Allowances', 'Salary & Allowances', '3', '1', '1', '0', 'E', '0', '0', '0.00', 'admin', '2015-10-15 19:13:13', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('50102', 'Sponsors Loan', 'Non Current Liabilities', '2', '1', '0', '1', 'L', '0', '0', '0.00', 'admin', '2015-10-15 19:48:02', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('4020706', 'Sports Expense', 'Miscellaneous Expenses', '3', '1', '1', '0', 'E', '0', '0', '0.00', 'nasmud', '2016-11-09 13:16:53', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('102010203', 'Standard Bank', 'Cash At Bank', '4', '1', '1', '1', 'A', '0', '0', '0.00', 'admin', '2015-10-15 15:33:33', 'admin', '2015-10-15 15:33:48');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('102010204', 'State Bank', 'Cash At Bank', '4', '1', '1', '1', 'A', '0', '0', '0.00', 'admin', '2015-12-31 16:44:14', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('401', 'Store Expenses', 'المصروفات', '1', '1', '0', '0', 'E', '0', '0', '0.00', '2', '2018-07-07 13:38:59', 'admin', '2015-10-15 17:58:46');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('3020501', 'Students Info. Correction Fee', 'Others (Non-Academic Income)', '3', '1', '1', '0', 'I', '0', '0', '0.00', 'admin', '2015-10-15 17:24:45', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('1010601', 'Sub Station', 'Electrical Equipment', '3', '1', '1', '0', 'A', '0', '0', '0.00', 'admin', '2016-03-27 10:44:11', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('5020200008', 'sup-1-Yemen w3', 'Account Payable', '3', '1', '1', '0', 'L', '0', '0', '0.00', '1', '2026-01-30 00:22:41', '', '0000-00-00 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('5020200006', 'sup-4-Eco star', 'Account Payable', '3', '1', '1', '0', 'L', '0', '0', '0.00', '2', '2018-07-27 10:15:58', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('5020200007', 'sup-5-New', 'Account Payable', '3', '1', '1', '0', 'L', '0', '0', '0.00', '2', '2018-08-02 16:23:42', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('5020200002', 'sup-5-Sharif', 'Account Payable', '3', '1', '1', '0', 'L', '0', '0', '0.00', '2', '2018-07-12 10:04:21', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('5020200003', 'sup-6-Talha', 'Account Payable', '3', '1', '1', '0', 'L', '0', '0', '0.00', '2', '2018-07-14 10:16:52', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('5020200004', 'sup-7-MS. Tel&Co.', 'Account Payable', '3', '1', '1', '0', 'L', '0', '0', '0.00', '2', '2018-07-19 05:06:18', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('5020200005', 'sup-8-july', 'Account Payable', '3', '1', '1', '0', 'L', '0', '0', '0.00', '2', '2018-07-27 09:41:53', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('4020704', 'TB Care Expenses', 'Miscellaneous Expenses', '3', '1', '1', '0', 'E', '0', '0', '0.00', 'admin', '2016-10-08 13:03:04', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('30206', 'TB Care Income', 'ايرادات اخرى', '2', '1', '1', '1', 'I', '0', '0', '0.00', 'admin', '2016-10-08 13:00:56', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('4020501', 'TDS on House Rent', 'House Rent', '3', '1', '1', '0', 'E', '0', '0', '0.00', 'admin', '2015-10-15 18:44:07', 'admin', '2016-09-19 14:40:16');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('502030201', 'TDS Payable House Rent', 'Income Tax Payable', '4', '1', '1', '0', 'L', '0', '0', '0.00', 'admin', '2016-09-19 11:19:42', 'admin', '2016-09-28 13:19:37');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('502030203', 'TDS Payable on Advertisement Bill', 'Income Tax Payable', '4', '1', '1', '0', 'L', '0', '0', '0.00', 'admin', '2016-09-28 13:20:51', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('502030202', 'TDS Payable on Salary', 'Income Tax Payable', '4', '1', '1', '0', 'L', '0', '0', '0.00', 'admin', '2016-09-28 13:20:17', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('4021402', 'Tea Kettle', 'Repair and Maintenance', '3', '1', '1', '0', 'E', '0', '0', '0.00', 'admin', '2015-10-15 19:33:45', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('4020402', 'Telephone Bill', 'Utility Expenses', '3', '1', '1', '0', 'E', '0', '0', '0.00', 'admin', '2015-10-15 18:57:59', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('1010209', 'Telephone Set & PABX', 'Office Equipment', '3', '1', '1', '0', 'A', '0', '0', '0.00', 'admin', '2015-10-15 15:51:57', 'admin', '2016-10-02 17:10:40');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('102020104', 'Test', 'Advance', '4', '1', '1', '0', 'A', '0', '0', '0.00', 'admin', '2018-07-05 11:42:48', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('40203', 'Travelling & Conveyance', 'Other Expenses', '2', '1', '1', '1', 'E', '0', '0', '0.00', 'admin', '2013-07-08 16:22:06', 'admin', '2015-10-15 18:45:13');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('4021406', 'TV', 'Repair and Maintenance', '3', '1', '1', '0', 'E', '0', '0', '0.00', 'admin', '2015-10-15 19:35:07', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('1010205', 'UPS', 'Office Equipment', '3', '1', '1', '0', 'A', '0', '0', '0.00', 'admin', '2015-10-15 15:50:38', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('40204', 'Utility Expenses', 'Other Expenses', '2', '1', '0', '1', 'E', '0', '0', '0.00', 'anwarul', '2013-07-11 16:20:24', 'admin', '2016-01-02 15:55:22');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('4020503', 'VAT on House Rent Exp', 'House Rent', '3', '1', '1', '0', 'E', '0', '0', '0.00', 'admin', '2015-10-15 18:49:22', 'admin', '2016-09-25 14:00:52');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('5020301', 'VAT Payable', 'Liabilities for Expenses', '3', '1', '0', '1', 'L', '0', '0', '0.00', 'admin', '2015-10-15 19:51:11', 'admin', '2016-09-28 13:23:53');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('1010409', 'Vehicle A/C', 'Others Assets', '3', '1', '1', '0', 'A', '0', '0', '0.00', 'Zoherul', '2016-05-12 12:13:21', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('1010405', 'Voltage Stablizer', 'Others Assets', '3', '1', '1', '0', 'A', '0', '0', '0.00', 'admin', '2016-03-27 10:40:59', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('1010105', 'Waiting Sofa - Steel', 'Furniture & Fixturers', '3', '1', '1', '0', 'A', '0', '0', '0.00', 'admin', '2015-10-15 15:46:29', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('4020405', 'WASA Bill', 'Utility Expenses', '3', '1', '1', '0', 'E', '0', '0', '0.00', 'admin', '2015-10-15 18:58:51', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('1010402', 'Water Purifier', 'Others Assets', '3', '1', '1', '0', 'A', '0', '0', '0.00', 'admin', '2016-01-29 11:14:11', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('4020705', 'Website Development Expenses', 'Miscellaneous Expenses', '3', '1', '1', '0', 'E', '0', '0', '0.00', 'admin', '2016-10-15 12:42:47', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('40100004', 'zxzx-المخزن الرائيسي', 'Store Expenses', '2', '1', '1', '0', 'E', '0', '0', '0.00', '1', '2026-02-26 00:45:04', '', '0000-00-00 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('101', 'الأصول الغير متداولة', 'الاصول', '1', '1', '0', '0', 'A', '0', '0', '0.00', '1', '2026-03-04 23:48:37', 'admin', '2015-10-15 15:29:11');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('102', 'الأصول المتداولة', 'الاصول', '1', '1', '0', '0', 'A', '0', '0', '0.00', '1', '2026-03-04 23:48:09', 'admin', '2018-07-07 11:23:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('5', 'الإلتزامات', 'COA', '0', '1', '0', '0', 'L', '0', '0', '0.00', '1', '2026-02-26 21:39:47', 'admin', '2015-10-15 19:46:54');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('1', 'الاصول', 'COA', '0', '1', '0', '0', 'A', '0', '0', '0.00', '1', '2026-02-26 21:37:43', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('3', 'الايرادات', 'COA', '0', '1', '0', '0', 'I', '0', '0', '0.00', '1', '2026-02-26 21:41:06', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('4', 'المصروفات', 'COA', '0', '1', '0', '0', 'E', '0', '0', '0.00', '1', '2026-02-26 21:40:23', '', '2015-10-15 00:00:00');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('10201', 'النقد وما يعادله', 'الأصول المتداولة', '2', '1', '0', '0', 'A', '0', '0', '0.00', '1', '2026-03-04 23:47:44', 'admin', '2015-10-15 15:57:55');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('302', 'ايرادات اخرى', 'الايرادات', '1', '1', '0', '0', 'I', '0', '0', '0.00', '1', '2026-03-04 23:49:06', 'admin', '2016-09-25 11:04:09');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('301', 'ايرادات المتجر', 'الايرادات', '1', '1', '0', '0', 'I', '0', '0', '0.00', '1', '2026-03-04 23:49:27', 'admin', '2015-09-17 17:00:02');
INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`) VALUES ('2', 'حقوق الملكية', 'COA', '0', '1', '0', '0', 'L', '0', '0', '0.00', '1', '2026-02-26 21:38:59', '', '2015-10-15 00:00:00');


#
# TABLE STRUCTURE FOR: acc_customer_income
#

DROP TABLE IF EXISTS `acc_customer_income`;

CREATE TABLE `acc_customer_income` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Customer_Id` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `VNo` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `Date` date NOT NULL,
  `Amount` decimal(10,2) NOT NULL,
  UNIQUE KEY `ID` (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

#
# TABLE STRUCTURE FOR: acc_glsummarybalance
#

DROP TABLE IF EXISTS `acc_glsummarybalance`;

CREATE TABLE `acc_glsummarybalance` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `COAID` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Debit` decimal(18,2) DEFAULT NULL,
  `Credit` decimal(18,2) DEFAULT NULL,
  `FYear` int(11) DEFAULT NULL,
  `CreateBy` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `CreateDate` datetime DEFAULT NULL,
  UNIQUE KEY `ID` (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

#
# TABLE STRUCTURE FOR: acc_income_expence
#

DROP TABLE IF EXISTS `acc_income_expence`;

CREATE TABLE `acc_income_expence` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `VNo` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `Student_Id` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `Date` date NOT NULL,
  `Paymode` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `Perpose` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `Narration` text COLLATE utf8_unicode_ci NOT NULL,
  `StoreID` int(11) NOT NULL,
  `COAID` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `Amount` decimal(10,2) NOT NULL,
  `IsApprove` tinyint(4) NOT NULL,
  `CreateBy` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `CreateDate` datetime NOT NULL,
  UNIQUE KEY `ID` (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

#
# TABLE STRUCTURE FOR: acc_temp
#

DROP TABLE IF EXISTS `acc_temp`;

CREATE TABLE `acc_temp` (
  `COAID` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `Name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `Debit` decimal(18,2) NOT NULL,
  `Credit` decimal(18,2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

#
# TABLE STRUCTURE FOR: acc_transaction
#

DROP TABLE IF EXISTS `acc_transaction`;

CREATE TABLE `acc_transaction` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `VNo` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Vtype` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `VDate` date DEFAULT NULL,
  `COAID` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `Narration` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `Debit` decimal(18,2) DEFAULT NULL,
  `Credit` decimal(18,2) DEFAULT NULL,
  `StoreID` int(11) NOT NULL,
  `IsPosted` char(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `CreateBy` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `CreateDate` datetime DEFAULT NULL,
  `UpdateBy` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `UpdateDate` datetime DEFAULT NULL,
  `IsAppove` char(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  UNIQUE KEY `ID` (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=361 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `acc_transaction` (`ID`, `VNo`, `Vtype`, `VDate`, `COAID`, `Narration`, `Debit`, `Credit`, `StoreID`, `IsPosted`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`, `IsAppove`) VALUES ('357', '20260301030626', 'PO', '2026-03-01', '10107', 'PO Receive Receive No 20260301030717', '3300.00', '0.00', '1', '1', '1', '2026-03-01 00:00:00', NULL, NULL, '1');
INSERT INTO `acc_transaction` (`ID`, `VNo`, `Vtype`, `VDate`, `COAID`, `Narration`, `Debit`, `Credit`, `StoreID`, `IsPosted`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`, `IsAppove`) VALUES ('358', '20260303213642', 'PO', '2026-03-03', '10107', 'PO Receive Receive No 20260303221518', '33000.00', '0.00', '2', '1', '1', '2026-03-03 00:00:00', NULL, NULL, '1');
INSERT INTO `acc_transaction` (`ID`, `VNo`, `Vtype`, `VDate`, `COAID`, `Narration`, `Debit`, `Credit`, `StoreID`, `IsPosted`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`, `IsAppove`) VALUES ('359', '20260303213642', 'PO', '2026-03-05', '10107', 'PO Receive Receive No 20260305220102', '11000.00', '0.00', '2', '1', '1', '2026-03-05 00:00:00', NULL, NULL, '1');
INSERT INTO `acc_transaction` (`ID`, `VNo`, `Vtype`, `VDate`, `COAID`, `Narration`, `Debit`, `Credit`, `StoreID`, `IsPosted`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`, `IsAppove`) VALUES ('360', '20260303213642', 'PO', '2026-03-05', '10107', 'PO Receive Receive No 20260305220141', '9900.00', '0.00', '2', '1', '1', '2026-03-05 00:00:00', NULL, NULL, '1');


#
# TABLE STRUCTURE FOR: accesslog
#

DROP TABLE IF EXISTS `accesslog`;

CREATE TABLE `accesslog` (
  `sl_no` bigint(20) NOT NULL AUTO_INCREMENT,
  `action_page` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `action_done` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `remarks` text COLLATE utf8_unicode_ci NOT NULL,
  `user_name` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `entry_date` datetime DEFAULT NULL,
  UNIQUE KEY `SerialNo` (`sl_no`)
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `accesslog` (`sl_no`, `action_page`, `action_done`, `remarks`, `user_name`, `entry_date`) VALUES ('1', 'Store', 'create', 'Store ID :1', '1', '2026-01-30 00:21:41');
INSERT INTO `accesslog` (`sl_no`, `action_page`, `action_done`, `remarks`, `user_name`, `entry_date`) VALUES ('2', 'Supplier', 'create', 'Supplier ID :1', '1', '2026-01-30 00:22:41');
INSERT INTO `accesslog` (`sl_no`, `action_page`, `action_done`, `remarks`, `user_name`, `entry_date`) VALUES ('3', 'Product', 'create', 'product ID :1', '1', '2026-01-30 02:22:43');
INSERT INTO `accesslog` (`sl_no`, `action_page`, `action_done`, `remarks`, `user_name`, `entry_date`) VALUES ('4', 'purchase order', 'create', 'Orde Id-20260130023334 total amount-3035.00', '1', '2026-01-30 02:33:36');
INSERT INTO `accesslog` (`sl_no`, `action_page`, `action_done`, `remarks`, `user_name`, `entry_date`) VALUES ('5', 'Customer', 'create', '27', '1', '2026-01-30 02:45:12');
INSERT INTO `accesslog` (`sl_no`, `action_page`, `action_done`, `remarks`, `user_name`, `entry_date`) VALUES ('6', 'Customer', 'create', '28', '1', '2026-02-26 00:39:10');
INSERT INTO `accesslog` (`sl_no`, `action_page`, `action_done`, `remarks`, `user_name`, `entry_date`) VALUES ('7', 'leases', 'create', 'Lease Id-11', '1', '2026-02-26 00:40:41');
INSERT INTO `accesslog` (`sl_no`, `action_page`, `action_done`, `remarks`, `user_name`, `entry_date`) VALUES ('8', 'Stockmovment', 'create', 'Stockmovment ID :1', '1', '2026-02-26 00:43:07');
INSERT INTO `accesslog` (`sl_no`, `action_page`, `action_done`, `remarks`, `user_name`, `entry_date`) VALUES ('9', 'Store', 'create', 'Store ID :2', '1', '2026-02-26 00:45:04');
INSERT INTO `accesslog` (`sl_no`, `action_page`, `action_done`, `remarks`, `user_name`, `entry_date`) VALUES ('10', 'Stockmovment', 'create', 'Stockmovment ID :2', '1', '2026-02-26 00:46:08');
INSERT INTO `accesslog` (`sl_no`, `action_page`, `action_done`, `remarks`, `user_name`, `entry_date`) VALUES ('11', 'Product', 'create', 'product ID :2', '1', '2026-02-26 01:45:05');
INSERT INTO `accesslog` (`sl_no`, `action_page`, `action_done`, `remarks`, `user_name`, `entry_date`) VALUES ('12', 'User', 'create', 'User ID :2', '1', '2026-02-26 04:04:13');
INSERT INTO `accesslog` (`sl_no`, `action_page`, `action_done`, `remarks`, `user_name`, `entry_date`) VALUES ('13', 'Role Permission', 'create', 'Role id :485', '1', '2026-02-26 05:10:39');
INSERT INTO `accesslog` (`sl_no`, `action_page`, `action_done`, `remarks`, `user_name`, `entry_date`) VALUES ('14', 'Stockmovment', 'create', 'Stockmovment ID :3', '1', '2026-03-01 03:04:39');
INSERT INTO `accesslog` (`sl_no`, `action_page`, `action_done`, `remarks`, `user_name`, `entry_date`) VALUES ('15', 'purchase order', 'create', 'Orde Id-20260301030626 total amount-3300.00', '1', '2026-03-01 03:06:26');
INSERT INTO `accesslog` (`sl_no`, `action_page`, `action_done`, `remarks`, `user_name`, `entry_date`) VALUES ('16', 'purchase order receive', 'create', 'Order Id- total amount-3300.00', '1', '2026-03-01 03:07:17');
INSERT INTO `accesslog` (`sl_no`, `action_page`, `action_done`, `remarks`, `user_name`, `entry_date`) VALUES ('17', 'leases', 'create', 'Lease Id-12', '1', '2026-03-01 03:11:59');
INSERT INTO `accesslog` (`sl_no`, `action_page`, `action_done`, `remarks`, `user_name`, `entry_date`) VALUES ('18', 'Sales', 'create', 'invoice_no-1000 total amount-4500.00', '1', '2026-03-01 03:12:59');
INSERT INTO `accesslog` (`sl_no`, `action_page`, `action_done`, `remarks`, `user_name`, `entry_date`) VALUES ('19', 'Sales', 'create', 'invoice_no-1000 total amount-2700.00', '1', '2026-03-01 03:14:16');
INSERT INTO `accesslog` (`sl_no`, `action_page`, `action_done`, `remarks`, `user_name`, `entry_date`) VALUES ('20', 'purchase order', 'create', 'Orde Id-20260303213642 total amount-55000.00', '2', '2026-03-03 21:36:42');
INSERT INTO `accesslog` (`sl_no`, `action_page`, `action_done`, `remarks`, `user_name`, `entry_date`) VALUES ('21', 'Role Permission', 'create', 'Role id :497', '1', '2026-03-03 22:14:13');
INSERT INTO `accesslog` (`sl_no`, `action_page`, `action_done`, `remarks`, `user_name`, `entry_date`) VALUES ('22', 'purchase order receive', 'create', 'Order Id- total amount-33000.00', '1', '2026-03-03 22:15:19');
INSERT INTO `accesslog` (`sl_no`, `action_page`, `action_done`, `remarks`, `user_name`, `entry_date`) VALUES ('23', 'purchase order receive', 'create', 'Order Id- total amount-11000.00', '1', '2026-03-05 22:01:02');
INSERT INTO `accesslog` (`sl_no`, `action_page`, `action_done`, `remarks`, `user_name`, `entry_date`) VALUES ('24', 'purchase order receive', 'create', 'Order Id- total amount-9900.00', '1', '2026-03-05 22:01:41');
INSERT INTO `accesslog` (`sl_no`, `action_page`, `action_done`, `remarks`, `user_name`, `entry_date`) VALUES ('25', 'purchase order', 'delete', 'Orde Id-20260130023334', '1', '2026-03-05 22:04:23');
INSERT INTO `accesslog` (`sl_no`, `action_page`, `action_done`, `remarks`, `user_name`, `entry_date`) VALUES ('26', 'Stockmovment', 'create', 'Stockmovment ID :4', '1', '2026-03-05 22:27:03');
INSERT INTO `accesslog` (`sl_no`, `action_page`, `action_done`, `remarks`, `user_name`, `entry_date`) VALUES ('27', 'User Role', 'update', 'Role id :', '1', '2026-03-05 22:39:13');
INSERT INTO `accesslog` (`sl_no`, `action_page`, `action_done`, `remarks`, `user_name`, `entry_date`) VALUES ('28', 'User', 'create', 'User ID :3', '1', '2026-03-06 21:37:52');
INSERT INTO `accesslog` (`sl_no`, `action_page`, `action_done`, `remarks`, `user_name`, `entry_date`) VALUES ('29', 'User Role', 'update', 'Role id :', '1', '2026-03-06 21:39:27');
INSERT INTO `accesslog` (`sl_no`, `action_page`, `action_done`, `remarks`, `user_name`, `entry_date`) VALUES ('30', 'Role Permission', 'create', 'Role id :509', '1', '2026-03-06 21:46:19');
INSERT INTO `accesslog` (`sl_no`, `action_page`, `action_done`, `remarks`, `user_name`, `entry_date`) VALUES ('31', 'Role Permission', 'create', 'Role id :521', '1', '2026-03-06 22:18:09');
INSERT INTO `accesslog` (`sl_no`, `action_page`, `action_done`, `remarks`, `user_name`, `entry_date`) VALUES ('32', 'Role Permission', 'create', 'Role id :534', '1', '2026-03-06 22:18:38');
INSERT INTO `accesslog` (`sl_no`, `action_page`, `action_done`, `remarks`, `user_name`, `entry_date`) VALUES ('33', 'Role Permission', 'create', 'Role id :547', '1', '2026-03-06 22:19:12');
INSERT INTO `accesslog` (`sl_no`, `action_page`, `action_done`, `remarks`, `user_name`, `entry_date`) VALUES ('34', 'Role Permission', 'create', 'Role id :560', '1', '2026-03-06 22:19:25');
INSERT INTO `accesslog` (`sl_no`, `action_page`, `action_done`, `remarks`, `user_name`, `entry_date`) VALUES ('35', 'Store', 'update', 'Store ID :2', '1', '2026-03-06 22:20:10');
INSERT INTO `accesslog` (`sl_no`, `action_page`, `action_done`, `remarks`, `user_name`, `entry_date`) VALUES ('36', 'Warehouse', 'create', 'Warehouse ID :1', '1', '2026-03-06 22:26:38');
INSERT INTO `accesslog` (`sl_no`, `action_page`, `action_done`, `remarks`, `user_name`, `entry_date`) VALUES ('37', 'leases', 'create', 'Lease Id-13', '1', '2026-03-06 22:29:50');


#
# TABLE STRUCTURE FOR: country_state_city
#

DROP TABLE IF EXISTS `country_state_city`;

CREATE TABLE `country_state_city` (
  `id` int(11) NOT NULL,
  `name` varchar(30) NOT NULL,
  `text` varchar(30) NOT NULL,
  `parent_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `country_state_city` (`id`, `name`, `text`, `parent_id`) VALUES ('1', 'test', 'sdfsdf', '1');


#
# TABLE STRUCTURE FOR: customer
#

DROP TABLE IF EXISTS `customer`;

CREATE TABLE `customer` (
  `customer_id` int(11) NOT NULL AUTO_INCREMENT,
  `customer_code` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `store_id` int(11) NOT NULL COMMENT 'This is Store ID',
  `customer_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `customer_phone` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `customer_address` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `customer_cnic` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `job_designation` varchar(120) COLLATE utf8_unicode_ci DEFAULT NULL,
  `business_address` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `type` int(11) NOT NULL,
  `createby` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `createdate` datetime NOT NULL,
  `updateby` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `updatedate` datetime NOT NULL,
  `isactive` tinyint(1) NOT NULL,
  PRIMARY KEY (`customer_id`),
  UNIQUE KEY `customer_code_unique` (`customer_code`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `customer` (`customer_id`, `customer_code`, `store_id`, `customer_name`, `customer_phone`, `customer_address`, `customer_cnic`, `job_designation`, `business_address`, `type`, `createby`, `createdate`, `updateby`, `updatedate`, `isactive`) VALUES ('27', 'cc-1', '1', 'فواز عبدالله علي قاسم', '773388888', '', '18', 'معلم', '', '1', '1', '2026-01-30 02:45:11', '', '0000-00-00 00:00:00', '1');
INSERT INTO `customer` (`customer_id`, `customer_code`, `store_id`, `customer_name`, `customer_phone`, `customer_address`, `customer_cnic`, `job_designation`, `business_address`, `type`, `createby`, `createdate`, `updateby`, `updatedate`, `isactive`) VALUES ('28', 'cc-2', '1', 'فواز عبدالله', '773388888', '', '3444', '', '', '1', '1', '2026-02-26 00:39:10', '', '0000-00-00 00:00:00', '1');


#
# TABLE STRUCTURE FOR: customer_gurrantor_map
#

DROP TABLE IF EXISTS `customer_gurrantor_map`;

CREATE TABLE `customer_gurrantor_map` (
  `rowid` bigint(20) NOT NULL AUTO_INCREMENT,
  `lease_id` int(11) NOT NULL,
  `customer_id` int(11) NOT NULL,
  `gurrantor_id` int(11) NOT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `lease_id` (`lease_id`,`customer_id`,`gurrantor_id`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

#
# TABLE STRUCTURE FOR: employee
#

DROP TABLE IF EXISTS `employee`;

CREATE TABLE `employee` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `image` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `employeeno` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `store_id` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `designation` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `CardNo` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `department` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `isactive` tinyint(1) NOT NULL,
  `createby` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `createdate` datetime NOT NULL,
  `updateby` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `updatedate` datetime NOT NULL,
  PRIMARY KEY (`employeeno`),
  UNIQUE KEY `ID` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

#
# TABLE STRUCTURE FOR: gurrantor
#

DROP TABLE IF EXISTS `gurrantor`;

CREATE TABLE `gurrantor` (
  `gurrantor_id` int(11) NOT NULL AUTO_INCREMENT,
  `gurrantor_code` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `store_id` int(11) NOT NULL,
  `gurrantor_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `gurrantor_phone` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `gurrantor_address` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `gurrantor_cnic` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `job_designation` varchar(120) COLLATE utf8_unicode_ci NOT NULL,
  `business_address` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `createby` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `createdate` datetime NOT NULL,
  `updateby` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `updatedate` datetime NOT NULL,
  `isactive` tinyint(1) NOT NULL,
  PRIMARY KEY (`gurrantor_id`),
  UNIQUE KEY `gurrantor_code_unique` (`gurrantor_code`)
) ENGINE=InnoDB AUTO_INCREMENT=81 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

#
# TABLE STRUCTURE FOR: language
#

DROP TABLE IF EXISTS `language`;

CREATE TABLE `language` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `phrase` varchar(100) NOT NULL,
  `english` varchar(255) NOT NULL,
  `arabic` text DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=447 DEFAULT CHARSET=utf8;

INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('2', 'login', 'Login', 'دخول');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('3', 'email', 'Email Address', 'الايميل');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('4', 'password', 'Password', 'كلمة المرور');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('5', 'reset', 'Reset', 'استعادة');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('6', 'dashboard', 'Dashboard', 'لوحة التحكم');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('7', 'home', 'Home', 'الرائيسية');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('8', 'profile', 'Profile', 'البروفايل');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('9', 'profile_setting', 'Profile Setting', 'اعداد البروفايل');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('10', 'firstname', 'First Name', 'الاسم الاول');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('11', 'lastname', 'Last Name', 'اللقب');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('12', 'about', 'About', 'من نحن');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('13', 'preview', 'Preview', 'التالي');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('14', 'image', 'Image', 'صورة');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('15', 'save', 'Save', 'حفظ');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('16', 'upload_successfully', 'Upload Successfully!', 'تحميل بنجاح');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('17', 'user_added_successfully', 'User Added Successfully!', 'اضافة مستخدم بنجاح');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('18', 'please_try_again', 'Please Try Again...', 'حاولم مرةاخرى');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('19', 'inbox_message', 'Inbox Messages', 'صندوق الرسائل');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('20', 'sent_message', 'Sent Message', 'ارسال رسالة');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('21', 'message_details', 'Message Details', 'تفاصيل الرسالة');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('22', 'new_message', 'New Message', 'رسالة جديدة');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('23', 'receiver_name', 'Receiver Name', 'اسم المستقبل');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('24', 'sender_name', 'Sender Name', 'اسم المرسل');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('25', 'subject', 'Subject', 'الموضوع');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('26', 'message', 'Message', 'الرسالة');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('27', 'message_sent', 'Message Sent!', 'رسائل مرسلة');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('28', 'ip_address', 'IP Address', 'عنوان الايبي');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('29', 'last_login', 'Last Login', 'ولوج مسبق');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('30', 'last_logout', 'Last Logout', 'آخر تسجيل خروج');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('31', 'status', 'Status', 'الحالة');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('32', 'delete_successfully', 'Delete Successfully!', 'حذف بنجاح');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('33', 'send', 'Send', 'ارسال');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('34', 'date', 'Date', 'التاريخ');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('35', 'action', 'Action', 'اجراء');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('36', 'sl_no', 'SL No.', '');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('37', 'are_you_sure', 'Are You Sure ? ', 'هل انت متاكد');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('38', 'application_setting', 'Application Setting', 'إعدادات التطبيق');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('39', 'application_title', 'Application Title', 'عنوان التطبيق');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('40', 'address', 'Address', 'العنوان');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('41', 'phone', 'Phone', 'موبايل');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('42', 'favicon', 'Favicon', 'مفضلة');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('43', 'logo', 'Logo', 'شعار');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('44', 'language', 'Language', 'اللغة');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('45', 'left_to_right', 'Left To Right', 'من الشمال الى اليمين');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('46', 'right_to_left', 'Right To Left', 'من اليمين الى الشمال');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('47', 'footer_text', 'Footer Text', 'نص الفوتر');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('48', 'site_align', 'Application Alignment', 'اتجاه التطبيق');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('49', 'welcome_back', 'Welcome Back!', 'مرحباً بعودتكم');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('50', 'please_contact_with_admin', 'Please Contact With Admin', 'تواصل مع المسئول');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('51', 'incorrect_email_or_password', 'Incorrect Email/Password', 'بريد إلكتروني أو كلمة مرور غير صحيحة');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('52', 'select_option', 'Select Option', 'الخيار');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('53', 'ftp_setting', 'Data Synchronize [FTP Setting]', 'اعدادات بروتوكول نقل الملفات (FTP)');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('54', 'hostname', 'Host Name', 'اسم المضيف');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('55', 'username', 'User Name', 'اسم المستخدم');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('56', 'ftp_port', 'FTP Port', 'بورت  بروتوكول نقل الملفات (FTP)');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('57', 'ftp_debug', 'FTP Debug', 'تصحيح أخطاء بروتوكول نقل الملفات (FTP)');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('58', 'project_root', 'Project Root', 'جذر المشروع');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('59', 'update_successfully', 'Update Successfully', 'تم التعديل بنجاح');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('60', 'save_successfully', 'Save Successfully!', 'تم الحفظ بنجاح');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('61', 'delete_successfully', 'Delete Successfully!', 'تم الحذف بنجاح');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('62', 'internet_connection', 'Internet Connection', 'الاتصال بالانترنت');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('63', 'ok', 'Ok', 'موافق');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('64', 'not_available', 'Not Available', 'غير ممكن');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('65', 'available', 'Available', 'ممكن');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('66', 'outgoing_file', 'ملف صادر', 'ملف صادر');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('67', 'incoming_file', 'Incoming File', 'ملف وارد');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('68', 'data_synchronize', 'Data Synchronize', 'مزامنة البيانات');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('69', 'unable_to_upload_file_please_check_configuration', 'Unable to upload file! please check configuration', 'تعذر تحميل الملف! يرجى التحقق من الإعدادات');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('70', 'please_configure_synchronizer_settings', 'Please configure synchronizer settings', 'يرجى ضبط إعدادات المزامنة');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('71', 'download_successfully', 'Download Successfully', 'التحميل بنجاح');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('72', 'unable_to_download_file_please_check_configuration', 'Unable to download file! please check configuration', 'تعذر تنزيل الملف، يرجى التحقق من الإعدادات');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('73', 'data_import_first', 'Data Import First', 'استيراد البيانات أولاً');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('74', 'data_import_successfully', 'Data Import Successfully!', 'تم استيراد البيانات بنجاح');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('75', 'unable_to_import_data_please_check_config_or_sql_file', 'Unable to import data! please check configuration / SQL file.', 'تعذر استيراد البيانات، يرجى التحقق من ملف الإعدادات أو ملف SQL');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('76', 'download_data_from_server', 'Download Data from Server', 'تنزيل البيانات من الخادم');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('77', 'data_import_to_database', 'Data Import To Database', 'استيراد البيانات إلى قاعدة البيانات');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('79', 'data_upload_to_server', 'Data Upload to Server', 'تحميل البيانات إلى الخادم');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('80', 'please_wait', 'Please Wait...', 'انتظر من فضلك');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('81', 'ooops_something_went_wrong', ' Ooops something went wrong...', 'عفوًا، حدث خطأ ما');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('82', 'module_permission_list', 'Module Permission List', 'قائمة أذونات الوحدات النمطية');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('83', 'user_permission', 'User Permission', 'اذونات المستخدم');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('84', 'add_module_permission', 'Add Module Permission', 'اضافة نمط صلاحيات');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('85', 'module_permission_added_successfully', 'Module Permission Added Successfully!', 'تمت إضافة إذن الوحدة بنجاح');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('86', 'update_module_permission', 'Update Module Permission', 'تحديث أذونات المودل');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('87', 'download', 'Download', 'تحميل');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('88', 'module_name', 'Module Name', 'اسم النمط');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('89', 'create', 'Create', 'انشاء');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('90', 'read', 'Read', 'قراءة');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('91', 'update', 'Update', 'تعديل');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('92', 'delete', 'Delete', 'حذف');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('93', 'module_list', 'Module List', 'قائمة الوحدات النمطية');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('94', 'add_module', 'Add Module', 'إضافة وحدة نمطية');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('95', 'directory', 'Module Direcotory', 'دليل');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('96', 'description', 'Description', 'وصف');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('97', 'image_upload_successfully', 'Image Upload Successfully!', 'تحميل الصورة بنجاح');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('98', 'module_added_successfully', 'Module Added Successfully', 'اضافة النمط بنجاج');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('99', 'inactive', 'Inactive', 'غير نشط');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('100', 'active', 'Active', 'نشيط');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('101', 'user_list', 'User List', 'قائمة المستخدمين');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('102', 'see_all_message', 'See All Messages', 'عرض جميع الرسائل');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('103', 'setting', 'Setting', 'اعدادات');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('104', 'logout', 'Logout', 'خروج');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('105', 'admin', 'Admin', 'مسؤل');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('106', 'add_user', 'Add User', 'إضافة  مستخدم');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('107', 'user', 'User', 'المستخدم');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('108', 'module', 'Module', 'وحدة نمطية');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('109', 'new', 'New', 'جديد');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('110', 'inbox', 'Inbox', 'صندوق الوارد');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('111', 'sent', 'Sent', 'ارسال');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('112', 'synchronize', 'Synchronize', 'تزامن');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('113', 'data_synchronizer', 'Data Synchronizer', 'مزامِن البيانات');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('114', 'module_permission', 'Module Permission', 'صلاحيات الوحدات النمطية');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('115', 'backup_now', 'Backup Now!', 'النسخ الاحتياطي الآن');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('116', 'restore_now', 'Restore Now!', 'استعادة الآن');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('117', 'backup_and_restore', 'Backup and Restore', 'النسخ الاحتياطي والاستعادة');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('118', 'captcha', 'Captcha Word', 'كابتشا');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('119', 'database_backup', 'Database Backup', 'نسخة احتياطية من قاعدة البيانات');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('120', 'restore_successfully', 'Restore Successfully', 'تمت الاستعادة بنجاح');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('121', 'backup_successfully', 'Backup Successfully', 'تم النسخ الاحتياطي بنجاح');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('122', 'filename', 'File Name', 'اسم الملف');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('123', 'file_information', 'File Information', 'معلومات الملف');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('124', 'size', 'size', 'حجم');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('125', 'backup_date', 'Backup Date', 'تاريخ النسخ الاحتياطي');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('126', 'overwrite', 'Overwrite', 'الكتابة فوق');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('127', 'invalid_file', 'Invalid File!', 'ملف غير صالح');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('128', 'invalid_module', 'Invalid Module', 'وحدة غير صالحة');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('129', 'remove_successfully', 'Remove Successfully!', 'تمت الإزالة بنجاح');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('130', 'install', 'Install', 'تثبيت');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('131', 'uninstall', 'Uninstall', 'الغاء التثبيت');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('132', 'tables_are_not_available_in_database', 'Tables are not available in database.sql', 'لجداول غير متوفرة في قاعدة البيانات');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('133', 'no_tables_are_registered_in_config', 'No tables are registerd in config.php', 'لا توجد جداول مسجلة في الإعدادات');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('134', 'enquiry', 'Enquiry', 'سؤال');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('135', 'read_unread', 'Read/Unread', 'المقروء  وغير المقروء');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('136', 'enquiry_information', 'Enquiry Information', 'معلومات الاستفسار');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('137', 'user_agent', 'User Agent', 'وكيل المستخدم');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('138', 'checked_by', 'Checked By', 'تم التحقق بواسطة');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('139', 'new_enquiry', 'New Enquiry', 'استفسار جديد');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('140', 'role', 'Role', 'دور');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('141', 'add_role', 'Add Role', 'إضافة  دور');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('142', 'role_list', 'Role List', 'قائمة الادوار');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('143', 'name', 'Name', 'الاسم');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('144', 'isactive', 'Is Active', 'نشط');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('145', 'set', 'Set', 'تعيين');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('146', 'store', 'Store', 'المتجر');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('147', 'add_store', 'Add Store', 'اضافة متجر');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('148', 'list_store', 'Store List', 'قائمة المتاجر');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('149', 'store_name', 'Store Name', 'اسم المتجر');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('150', 'store_code', 'Store Code', 'كود المتجر');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('151', 'store_address', 'Store Address', 'عنوان المتجر');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('152', 'store_phone', 'Store Phone', 'تلفون المتجر');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('153', 'user_role', 'User Role', 'دور المستخدم');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('154', 'add_user_role', 'Add User Role', 'إضافة  صلاحيات مستخدم');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('155', 'user_role_list', 'User Role List', 'ادوار المستخدمين');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('156', 'role_name', 'Role Name', 'اسم الدور');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('157', 'user_type', 'User Type', 'نوع المستخدم');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('158', 'super_admin', 'Super Admin', 'المدير');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('159', 'sl', 'SL', '');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('160', 'user_name', 'User Name', 'اسم المستخدم');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('161', 'create_user_role', 'Create User Role', 'اضافة دور للمستخدم');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('162', 'role_permission', 'Role Permission', 'صلاحيات الادوار');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('163', 'add_role_permission', 'Add Role Permission', 'إضافة  صلاحيات الادوار');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('164', 'role_permission_list', 'Role Permission List', 'قائمة الصلاحيات');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('165', 'permission_error', 'You Have No Permission', 'ليس لديك صلاحيات');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('166', 'employee', 'Employee', 'الموظف');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('167', 'add', 'Add ', 'اضف');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('168', 'list', 'List', 'القائمة');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('169', 'designation', 'Designation', 'المسمى الوظيفي');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('170', 'cardno', 'NID', 'رقم البطاقة');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('171', 'department', 'Department', 'القسم');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('172', 'customer', 'Customer', 'العميل');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('173', 'customer_code', 'Customer Code', 'كود العميل');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('174', 'customer_name', 'Customer Name', 'اسم العميل');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('175', 'business_address', 'Business Address', 'العنوان التجاري');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('176', 'customer_cnic', 'Customer CNIC', 'بطاقة هوية العميل');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('177', 'product_name', 'Product Name', 'اسم المنتج');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('178', 'product_category', 'Product Category', 'صنف المنتج');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('179', 'product', 'Product', 'المنتج');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('180', 'product_details', 'Product Details', 'تفاصيل المنتج');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('181', 'price', 'Price', 'السعر');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('182', 'category', 'Category', 'التصنيف');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('183', 'category_name', 'Category Name', 'اسم الصنف');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('184', 'supplier', 'Supplier', 'المورد');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('185', 'supplier_name', 'Supplier Name', 'اسم المورد');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('186', 'purchase_order', 'Puchase Order', 'أمر شراء');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('187', 'stock_ctn', 'Stock Qty', 'كمية المخزون');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('188', 'quantity', 'Qty', 'الكمية');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('189', 'total', 'Total', 'الاجمالي');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('190', 'grand_total', 'Grand Total', 'المجموع الإجمالي');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('191', 'add_new_item', 'Add New Product', 'إضافة صنف جديد');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('192', 'submit_and_add_another', 'Submit and Another', 'حفظ واخرى');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('193', 'submit', 'Submit ', 'حفظ');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('194', 'order_no', 'Order NO', 'رقم الطلب');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('195', 'warehouse', 'Warehouse', 'مستودع');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('196', 'assign_role', 'Assign Role', 'تعيين الدور');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('197', 'add_warehouse', 'Add Warehouse', 'اضافة مستودع');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('198', 'list_warehouse', 'Warehouse list', 'قائمة المستودعات');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('199', 'warehouse_name', 'Warehouse Name', 'اسم المستودع');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('200', 'warehouse_code', 'Warehouse code', 'كود المستودع');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('201', 'warehouse_phone', 'Warehouse Phone', 'موبايل المستودع');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('202', 'warehouse_address', 'Warehouse Address', 'عنوان المستودع');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('203', 'check_receive', 'Check Receive', 'استلام الشيك');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('204', 'receive', 'Receive', 'استلام');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('205', 'order_qty', 'Order QTY', 'كمية الطلب');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('206', 'receive_quantity', 'Receive QTY', 'كمية الاستلام');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('207', 'order_date', 'Order Date', 'تاريخ  الطلب');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('208', 'storewarehouse', 'Store/warehouse', 'مستودع/متجر');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('209', 'successfully_approved', 'Successfully Approved', 'تمت الموافقة بنجاح');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('210', 'disapprove', 'Disapprove', 'عدم الموافقة');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('211', 'approved', 'Approve', 'موافقة');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('212', 'receive_list', 'Receive List', 'قائمة الاستلامات');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('213', 'voucher_no', 'Voucher No', 'رقم القسيمة');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('214', 'purchase_price', 'Purchase Price', 'سعر الشراء');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('215', 'minimum_price', 'Minimum Price', 'الحد الأدنى للسعر');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('216', 'retail_price', 'Retail Price', 'سعر التجزئة');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('217', 'block_price', 'Block Price', 'سعر الكتلة');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('218', 'a', 'A', 'ال');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('219', 'in', 'In A', 'في');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('220', 'receive_qty', 'Receive QTY', 'كمية الاستلام');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('221', 'sale', 'Sales', 'المبيعات');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('222', 'cashsale', 'Cash Sale', 'المبيعات النقدية');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('223', 'invoice_id', 'Invoice ID', 'رقم الفاتورة');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('224', 'sales_man', 'Sales Man', 'بائع');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('225', 'total_amount', 'Total Amount', 'المبلغ الإجمالي');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('226', 'paid_amount', 'Paid Amount', 'المبلغ المدفوع');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('227', 'remaining_amnt', 'Remainig Amount', 'المبلغ المتبقي');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('228', 'lease', 'Lease', 'إيجار');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('229', 'pakage_code', 'Package  Code', 'كود الحزمة');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('230', 'pakage_name', 'Package Name', 'اسم الحزمة');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('231', 'duration', 'Duration', 'المدة الزمنية');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('232', 'advance', 'Advance', 'مقدم/سلفة');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('233', 'markup', 'Markup', 'هامش الربح');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('234', 'update_lease', 'Lease Update', 'تحديث عقد الإيجار');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('235', 'inquiry_officer', 'Inquiry Officer', 'مسؤول التحقيق');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('236', 'lease_package', 'Lease Package', 'حزمة التأجير');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('237', 'payment', 'Receiving ', 'المقبوضات/الاستلامات');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('238', 'invoice_no', 'Invoice No', 'رقم الفاتورة');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('239', 'due_amnt', 'Due Amount', 'المبلغ المستحق');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('240', 'cash_sale_list', 'Cash Sale List', 'قائمة المبيعات النقدية');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('241', 'credit_sale_list', 'Credit Sale List', 'قائمة مبيعات الدين/ السلفة');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('242', 'lease_sale_list', 'Lease Sale List', 'قائمة بيع الإيجار');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('243', 'to', 'To', 'الى');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('244', 'advance_amount', 'Advance amount', 'المبلغ المدفوع مقدماً');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('245', 'gurrantor_name', 'Gurrantor  Name', 'اسم الضامن');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('246', 'gurrantor_code', 'Gurrantor  Code', 'رمز الضامن');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('247', 'gurrantor_phone', 'Gurrantor  Phone', 'موبايل الضامن');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('248', 'gurrantor_address', 'Gurrantor Address', 'عنوان الضامن');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('249', 'gurrantor_cnic', 'Gurrantor  CNIC', 'بطاقة الهوية الوطنية للضامن');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('250', 'stockmovment', 'Stock Movement', 'حركة المخزون');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('251', 'proposal_code', 'Proposal Code', 'رمز الاقتراح');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('252', 'issue_code', 'Issue Code', 'رمز الإصدار');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('253', 'issue_date', 'Issue Date', 'تاريخ الاصدار');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('254', 'for_store', 'For Store', 'الى متجر');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('255', 'from_store', 'From Store', 'من متجر');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('256', 'issue_by', 'Issue By', 'صادر عن');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('257', 'product_code', 'Product Code', 'كود المنتج');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('258', 'proposal_qty', 'Proposal QTY', 'الكمية المقترحة');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('259', 'please_choose_another_p_code', 'Please another Product Code!!!', 'الرجاء اختيار رمز بريدي آخر');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('260', 'proposal_datetime', 'Proposal Date', 'تاريخ تقديم الاقتراح');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('261', 'product_info', 'Product Info', 'بيانات المنتج');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('262', 'category_list', 'Category List', 'قائمة التصنيفات');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('263', 'add_product', 'Add Product', 'إضافة  منتج');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('264', 'product_list', 'Product List', 'قائمة المنتجات');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('265', 'model_name', 'Model Name', 'اسم النموذج');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('266', 'model', 'Model', 'نموذج');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('267', 'add_model', 'Add Model', 'إضافة نموذج');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('268', 'brand', 'Brand', 'الماركة');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('269', 'brand_name', 'Brand Name', 'اسم الماركة الاول');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('270', 'brand_list', 'Brand List', 'اسم الماركة الاخير');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('271', 'unit_name', 'Unit Name', 'اسم وحدة القياس');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('272', 'unit', 'Unit of Measurement', 'الوحدة');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('273', 'add_unit', 'Add Unit', 'إضافة  وحدة');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('274', 'unit_list', 'Unit List', 'قائمة الوحدات');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('275', 'pur_price', 'Pur Price', 'السعر الحالي');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('276', 'min_price', 'Min Price', 'اقل سعر');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('277', 'retprice', 'Retl Price', 'سعر التجزئة');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('278', 'bl_price', 'BL Price', 'سعر بوليصة الشحن');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('279', 'cash', 'Cash', 'نقداً');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('280', 'credit', 'Credit', 'دين/سلفة');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('281', 'customer_type', 'Customer Type', 'نوع العميل');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('282', 'code', 'Code', 'كود');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('283', 'cnic', 'CNIC', 'رقم الهوية الوطنية');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('284', 'um', 'U/M', '');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('285', 'contact', 'Contact#', 'للتواصل');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('286', 'package_amount', 'Package Amount', 'مبلغ الباقة');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('287', 'recovery_received', 'Recovery Received', 'تم استلام المبلغ المسترجع');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('288', 'require_install', 'Require Installment', 'يتطلب التثبيت');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('289', 'installment_amount', 'Installment Amount', 'المبلغ المثبت');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('290', 'over_due_amount', 'Over Due Amount', 'المبلغ المستحق');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('291', 'final_settlement', 'Final Settlement Amount', 'التسوية النهائية');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('292', 'final_settlement_discount', 'Final Settlement Discount', 'خصم التسوية النهائية');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('293', 'receive_amnt', 'Receive Amount', 'استلام المبلغ');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('294', 'credit_receive', 'Credit Receive', 'استلام الدين/ السلفة');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('295', 'add_recovery_receiving', 'Add Recovery Receiving', 'إضافة استلام الاسترداد');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('296', 'add_credit_receiving', 'Add Credit Receiving', 'إضافة استلام الائتمان');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('297', 'report', 'Report', 'تقرير');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('298', 'recovery', 'Recovery', 'استعادة');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('299', 'surplus', 'Surplus', 'فائض');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('300', 'deficit', 'Deficit', 'العجز');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('301', 'recovery_summary_report', 'Recovery Summary Report', 'تقرير ملخص الاسترداد');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('302', 'ac_wise_achivement', 'A/C Wise Achievement', 'إنجاز حكيم');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('303', 'amount_wise_achivement', 'Amount Wise Achievement', 'الإنجاز حسب الكمية');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('304', 'remaning_ac', 'Remaining A/C', 'الحساب المتبقي');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('305', 'remaning_amount', 'Remaining Amount', 'المبلغ المتبقي');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('306', 'target', 'Target', 'هدف');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('307', 'achievement', 'Achievement', 'إنجاز');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('308', 'remaining', 'Remaining', 'المبلغ المتبقي');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('309', 'account', 'Account', 'حساب');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('310', 'amount', 'Amount', 'المبلغ');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('311', 'branches', 'Branches', 'الفروع');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('312', 'search', 'Search', 'بحث');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('313', 'supplier_code', 'Supplier Code', 'كود المورد');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('314', 'recovery_summary_report_datewise', 'Datewise Recovery Summary  ', 'تقرير ملخص الاسترداد حسب التاريخ');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('315', 'proposed_by', 'Proposed By', 'مقترح من قبل');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('316', 'overdue_analysis', 'Over Due Analysis', 'تحليل متأخر');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('317', 'gurrantor', 'Gurrantor', 'الضامن');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('318', 'g_contact', 'G Contact', 'تلفون الضامن');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('319', 'install_no', '# of Installment', 'رقم التثبيت');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('320', 'lease_amount', 'Lease Amount', 'مبلغ الإيجار');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('321', 'installment_amnt', 'Installment Amount', 'المبلغ المثبت');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('322', 'total_receive', 'Total Receive', 'إجمالي_الاستلام');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('323', 'branch_wise_ov_du_analisis', 'Branch Wise Due Analysis', 'تحليل فرعي');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('324', 'over_due', 'Over Due', 'متأخر');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('325', 'days', 'Days', 'ايام');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('326', 'last_payment_date', 'Last Payment Date', 'تاريخ آخر دفعة');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('327', 'location', 'Location', 'موقع');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('328', 'discount', 'Disc', 'تخفيض');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('329', 'creditsale', 'Credit Sale', 'بيع دين');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('330', 'leasesale', 'Lease Sale', 'بيع الإيجار');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('331', 'oreder_list', 'Order List', 'قائمة الطلبات');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('332', 'store_procedure', 'Store Procedure', 'إجراء مخزن');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('333', 'stock', 'Stock', 'المخزون');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('334', 'inqty', 'In QTY', 'بالكمية');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('335', 'outqty', 'Out Qty', 'الناتج');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('336', 'select', 'Select', 'اختار');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('337', 'contact_per_name', 'Contact Person ', 'جهة اتصال لكل اسم');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('338', 'c_p_contact', 'Person Contact#', 'جهة الاتصال');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('339', 'remark', 'Remark', 'ملاحظة');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('340', 'return', 'Return', 'المرتجع');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('341', 'please_input_correct_invoice_no', 'Please Input a correct invoice number', 'يرجى إدخال رقم الفاتورة الصحيح');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('342', 'sales_return_form', 'Sales Return Form', 'نموذج إرجاع المبيعات');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('343', 'sale_qty', 'Sales Qty', 'كمية البيع');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('344', 'return_qty', 'Return Qty', 'كمية المرتجع');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('345', 'reason', 'Reason', 'سبب');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('346', 'purchase_qty', 'Purchase Qty', 'كمية الشراء');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('347', 'purchase_return', 'Purchase Return', 'مرتجع المشتريات');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('348', 'return_date', 'Return Date', 'تاريخ الإرجاع');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('349', 'sale_return_list', 'Sales Return List', 'قائمة المرتجعات');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('350', 'purchase_return_list', 'Purchase Return List', 'قائمة مرتجع المشتريات');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('351', 'sales_return_view', 'Sales Return view', 'عرض مرتجع المبيعات');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('352', 'purchase_return_view', 'Purchase Return veiw', 'مراجعة عملية الشراء والإرجاع');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('353', 'reports', 'Reports', 'تقارير');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('354', 'test', '', 'اختبار');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('355', 'recovery_list', 'Recovery List', 'قائمة الاسترداد');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('356', 'find', 'Find', 'بجـث');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('357', 'accounts', 'Accounts', 'الحسابات');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('358', 'c_o_a', 'Chart of Accounts', 'دليل الحسابات');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('359', 'customer_transaction', 'Customer Transaction', 'معاملة العميل');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('360', 'money_receipt', 'Money Receipt', 'إيصال نقدي');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('361', 'debit_voucher', 'Debit Voucher', 'قسيمة مدين');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('362', 'receive_by', 'Received By', 'الاستلام بواسطة');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('363', 'credit_voucher', 'Credit Voucher', 'قسيمة دائن');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('364', 'contra_voucher', 'Contra voucher', 'قسيمة معاكسة');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('365', 'journal_voucher', 'Journal Voucher', 'قسيمة دفتر اليومية');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('366', 'voucher_approval', 'Voucher Approval', 'الموافقة على القسيمة');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('367', 'check_status', 'Check Status', 'تحقق من الحالة');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('368', 'account_report', 'Account Reports', 'تقرير الحسابات');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('369', 'voucher_report', 'Voucher Report', 'تقرير القسيمة');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('370', 'cash_book', 'Cash book', 'دفتر النقدية');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('371', 'bank_book', 'Bank Book', 'دفتر البنك');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('372', 'income_expense', 'Income Expense', 'الدخل/المصروفات');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('373', 'general_ledger', 'General Ledger', 'دفتر الأستاذ العام');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('374', 'trial_balance', 'Trial Balance', 'ميزان المراجعة');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('375', 'profit_loss', 'Profit Loss', 'الربح/الخسارة');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('376', 'receipt_payment', 'Receipt Payment', 'إيصال مدفوعات');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('377', 'all_voucher', 'All Voucher', 'جميع القسائم');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('378', 'cash_flow', 'Cash Flow', 'التدفق النقدي');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('379', 'stmt_of_financial_position', 'Stmt of Financial Position', 'بيان الوضع المالي');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('380', 'stmt_changes_equity', 'Stmt of Change Equity', 'تغييرات بيان حقوق الملكية');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('381', 'coa_print', 'Coa Print', 'طباعة شهادة المطابقة');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('382', 'stock_qty', 'Stock Qty', 'كمية المخزون');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('383', 'stock_value', 'Avg. Price', 'قيمة المخزون');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('384', 'add_more', 'Add more', 'إضافة المزيد');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('385', 'debit', 'Debit', 'مدين');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('386', 'issue_qty', 'Issue Qty', 'كمية الاصدار');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('387', 'update_debit_voucher', 'Update Debit Voucher', 'تحديث قسيمة المدين');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('388', 'update_credit_voucher', 'Update Debit Voucher', 'تحديث قسيمة الدائن');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('389', 'total_advance_amount', 'Total Advance Amount', 'إجمالي مبلغ الدفعة المقدمة');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('390', 'total_package_amount', 'Total Package Amount', 'إجمالي مبلغ الباقة');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('391', 'u_pack_price', 'Unit Package Price', 'سعر العبوة');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('392', 'total_pack_price', 'Total Package Price', 'سعر العبوة الإجمالي');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('393', 'from_date', 'From Date', 'من تاريخ');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('394', 'to_date', 'To Date', 'حتى تاريخ');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('395', 'gurrantor1', 'Gurrantor 1', 'الضامن 1');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('396', 'gurrantor2', 'Gurrantor 2', 'الضامن 2');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('397', 'customer_recovery', 'Customer Overdue Recovery', 'استرداد  العملاء');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('398', 'stock_analysis_report', 'Stock Analysis Report', 'تقرير تحليل المخزون');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('399', 'lease_package_pricing', 'Lease Package Pricing', 'تسعير باقات التأجير');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('400', 'cash_price', 'Cash Price', 'السعر النقدي');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('401', 'package', 'Package', 'حزمة');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('402', 'lease_price', 'Lease Price', 'سعر الإيجار');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('403', 'monthly_installment', 'Monthly Installment', 'القسط الشهري');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('404', 'recovery_report', 'Recovery Report', 'تقرير الاسترداد');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('405', 'stock_report', 'Stock Report', 'تقرير المخزون');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('406', 'lease_and_recovery_report', 'Lease & Recovery Report', 'تقرير التأجير والاسترداد');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('407', 'stock_history', 'Stock History', 'تاريخ المخزون');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('408', 'sales_return', 'Sales Return', 'المبلغ المسترجع');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('409', 'balance_qty', 'Balance Qty', 'كمية الرصيد');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('410', 'sale_price', 'Sale Price', 'سعر البيع');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('411', 'general_ledger_of', 'general ledger of', 'دفتر الأستاذ العام لـ');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('412', 'store_stock_history', 'Store Stock History', 'سجل مخزون المتجر');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('413', 'po_no', 'PO No', 'رقم نقطة البيع');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('414', 'store_ledger', 'Store Ledger', 'دفتر الأستاذ');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('415', 'recovery_list_rpt', 'Recovery List Report', 'تقرير قائمة الاسترداد');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('416', 'store_isssue', 'Store Issue', 'إصدار المتجر');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('417', 'store_receive', 'Store Receive', 'المعاد للمخزن');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('418', 'sales_amount', 'Sales Amount', 'مبلغ البيع');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('419', 'total_payable', 'Total Payable', 'إجمالي المبلغ المستحق');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('420', 'total_receivable', 'Total Receivable', 'إجمالي المستحقات');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('421', 'total_bank', 'Total Bank', 'اجمالي البنك');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('422', 'total_cash', 'Total Cash', 'اجمالي النقد');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('423', 'no_customer', '# of Customer', 'لا يوجد عميل');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('424', 'monthly_sales_performance', 'Monthly Sales Performance', 'الأداء الشهري للمبيعات');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('425', 'over_due_analysis', 'Over Due Analysis', 'تحليل متأخر');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('426', 'products', 'Products', 'المنتجات');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('427', 'stores', 'Stores', 'المخازن');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('428', 'customers', 'Customers', 'العملاء');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('429', 'users', 'Users', 'المستخدم');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('430', 'qty', 'Qty', 'الكمية');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('431', 'value', 'Value', 'القيمة');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('432', 'backup', 'Backup', 'نسخة احتياطي');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('433', 'receive_date', 'Receive Date', 'تاريخ الاستلام');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('434', 'customer_and_address', 'Customer & Address#', 'عنوان العميل');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('435', 'gurrantor_and_contact', 'Gurrantor & Contact#', 'الضامن ومعلومات الاتصال');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('436', 'lease_date', 'Lease Date', 'تاريخ الايجار');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('437', 'remaining_amount', 'Remaining Amount', 'المبلغ المتبقي');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('438', 'last_payment', 'Last Payment', 'آخر دفعة');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('439', 'overdue_amount', 'Over Due Amount', 'المبلغ المستحق');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('440', 'lease_from', 'Lease From', 'إيجار من');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('441', 'amount_greater_than', 'Amount Greater Than', 'الملبغ اكبر من');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('442', 'lease_to', 'Lease To', 'تأجير لـ');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('443', 'amount_less_than', 'Amount less Than', 'المبلغ اقل من');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('444', 'amount_equal', 'Amount Equal', 'المبلغ يساوي');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('445', 'check_all_product', 'Check All Products', 'فحص كل المنتجات');
INSERT INTO `language` (`id`, `phrase`, `english`, `arabic`) VALUES ('446', 'check_all_store', 'Check All Stores', 'فحص المتجر كاملاً');


#
# TABLE STRUCTURE FOR: lease
#

DROP TABLE IF EXISTS `lease`;

CREATE TABLE `lease` (
  `lease_id` int(11) NOT NULL AUTO_INCREMENT,
  `package_code` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
  `package_name` varchar(120) COLLATE utf8_unicode_ci NOT NULL,
  `lease_duration` int(11) NOT NULL,
  `advance` decimal(2,2) NOT NULL,
  `markup` decimal(2,2) NOT NULL,
  `grace_period` tinyint(2) NOT NULL COMMENT 'if customer wants to settle within the grace period then he will not be charged for the current month''s lease',
  `isactive` tinyint(1) NOT NULL,
  `createby` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `createdate` datetime NOT NULL,
  `updateby` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `updatedate` datetime NOT NULL,
  PRIMARY KEY (`lease_id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `lease` (`lease_id`, `package_code`, `package_name`, `lease_duration`, `advance`, `markup`, `grace_period`, `isactive`, `createby`, `createdate`, `updateby`, `updatedate`) VALUES ('11', 'xxx665', 'سلفة رمضان', '4', '0.99', '0.00', '0', '1', '1', '2026-02-26 00:40:40', '', '0000-00-00 00:00:00');
INSERT INTO `lease` (`lease_id`, `package_code`, `package_name`, `lease_duration`, `advance`, `markup`, `grace_period`, `isactive`, `createby`, `createdate`, `updateby`, `updatedate`) VALUES ('12', 'xxx665', 'قرض مؤجل', '4', '0.99', '0.03', '0', '1', '1', '2026-03-01 03:11:59', '', '0000-00-00 00:00:00');
INSERT INTO `lease` (`lease_id`, `package_code`, `package_name`, `lease_duration`, `advance`, `markup`, `grace_period`, `isactive`, `createby`, `createdate`, `updateby`, `updatedate`) VALUES ('13', 'xxx665', 'سلفة رمضان', '4', '0.99', '0.00', '0', '1', '1', '2026-03-06 22:29:50', '', '0000-00-00 00:00:00');


#
# TABLE STRUCTURE FOR: lease_product_map
#

DROP TABLE IF EXISTS `lease_product_map`;

CREATE TABLE `lease_product_map` (
  `row_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `lease_id` int(11) NOT NULL,
  `product_id` bigint(20) NOT NULL,
  PRIMARY KEY (`row_id`),
  KEY `fk_lease_id1` (`lease_id`),
  KEY `fk_prod_id1` (`product_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `lease_product_map` (`row_id`, `lease_id`, `product_id`) VALUES ('1', '12', '1');
INSERT INTO `lease_product_map` (`row_id`, `lease_id`, `product_id`) VALUES ('2', '12', '2');


#
# TABLE STRUCTURE FOR: lease_store_map
#

DROP TABLE IF EXISTS `lease_store_map`;

CREATE TABLE `lease_store_map` (
  `row_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `lease_id` int(11) NOT NULL,
  `store_id` int(11) NOT NULL,
  PRIMARY KEY (`row_id`),
  KEY `fk_store_lease_id1` (`lease_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `lease_store_map` (`row_id`, `lease_id`, `store_id`) VALUES ('1', '13', '2');


#
# TABLE STRUCTURE FOR: message
#

DROP TABLE IF EXISTS `message`;

CREATE TABLE `message` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sender_id` int(11) NOT NULL,
  `receiver_id` int(11) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `message` text NOT NULL,
  `datetime` datetime NOT NULL,
  `sender_status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '0=unseen, 1=seen, 2=delete',
  `receiver_status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '0=unseen, 1=seen, 2=delete',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

INSERT INTO `message` (`id`, `sender_id`, `receiver_id`, `subject`, `message`, `datetime`, `sender_status`, `receiver_status`) VALUES ('1', '1', '2', 'كيف ياابو ليان', '<p xss=removed>هذه الرسالة تنبيهية</p>', '2026-03-06 09:31:57', '1', '0');


#
# TABLE STRUCTURE FOR: module
#

DROP TABLE IF EXISTS `module`;

CREATE TABLE `module` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `description` text DEFAULT NULL,
  `image` varchar(255) NOT NULL,
  `directory` varchar(100) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;

INSERT INTO `module` (`id`, `name`, `description`, `image`, `directory`, `status`) VALUES ('1', 'الحسابات', 'Accounting', '', 'accounts', '1');
INSERT INTO `module` (`id`, `name`, `description`, `image`, `directory`, `status`) VALUES ('3', 'إدارة المتجر', 'Store Management System', 'application/modules/store/assets/images/thumbnail.jpg', 'store', '1');
INSERT INTO `module` (`id`, `name`, `description`, `image`, `directory`, `status`) VALUES ('6', 'إدارة العملاء', 'Customer Information', 'application/modules/customer/assets/images/thumbnail.jpg', 'customer', '1');
INSERT INTO `module` (`id`, `name`, `description`, `image`, `directory`, `status`) VALUES ('7', 'ادارة المنتجات', 'Product Information', 'application/modules/product/assets/images/thumbnail.jpg', 'product', '1');
INSERT INTO `module` (`id`, `name`, `description`, `image`, `directory`, `status`) VALUES ('9', 'ادارة الموردون', 'supplier Information', 'application/modules/supplier/assets/images/thumbnail.jpg', 'supplier', '1');
INSERT INTO `module` (`id`, `name`, `description`, `image`, `directory`, `status`) VALUES ('10', 'اوامر الشراء', 'purchase_order Information', 'application/modules/purchase_order/assets/images/thumbnail.jpg', 'purchase_order', '1');
INSERT INTO `module` (`id`, `name`, `description`, `image`, `directory`, `status`) VALUES ('12', 'sale Management', 'sale Information', 'application/modules/sale/assets/images/thumbnail.jpg', 'sale', '1');
INSERT INTO `module` (`id`, `name`, `description`, `image`, `directory`, `status`) VALUES ('13', 'lease Management', 'lease Information', 'application/modules/lease/assets/images/thumbnail.jpg', 'lease', '1');
INSERT INTO `module` (`id`, `name`, `description`, `image`, `directory`, `status`) VALUES ('14', 'Receiving', 'payment Management System', 'application/modules/payment/assets/images/thumbnail.jpg', 'payment', '1');
INSERT INTO `module` (`id`, `name`, `description`, `image`, `directory`, `status`) VALUES ('17', 'stockmovment Management', 'stockmovment Information', 'application/modules/stockmovment/assets/images/thumbnail.jpg', 'stockmovment', '1');
INSERT INTO `module` (`id`, `name`, `description`, `image`, `directory`, `status`) VALUES ('18', 'Return', 'return Information', 'application/modules/return/assets/images/thumbnail.jpg', 'return', '1');
INSERT INTO `module` (`id`, `name`, `description`, `image`, `directory`, `status`) VALUES ('19', 'Reports', 'Reports Information', 'application/modules/reports/assets/images/thumbnail.jpg', 'reports', '1');
INSERT INTO `module` (`id`, `name`, `description`, `image`, `directory`, `status`) VALUES ('20', 'Warehouse', 'Warehouses Information', 'application/modules/warehouse/assets/images/thumbnail.jpg', 'warehouse', '1');


#
# TABLE STRUCTURE FOR: payment_collection
#

DROP TABLE IF EXISTS `payment_collection`;

CREATE TABLE `payment_collection` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `sale_id` bigint(20) NOT NULL,
  `invoice_no` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `customer_id` int(11) NOT NULL,
  `receive_amnt` float NOT NULL,
  `due_amnt` float DEFAULT NULL,
  `receive_by` int(11) NOT NULL,
  `receive_date` date NOT NULL,
  `is_installment` int(11) NOT NULL DEFAULT 0,
  `updateby` int(11) NOT NULL,
  `updatedate` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `payment_collection` (`id`, `sale_id`, `invoice_no`, `customer_id`, `receive_amnt`, `due_amnt`, `receive_by`, `receive_date`, `is_installment`, `updateby`, `updatedate`) VALUES ('1', '20260301031258', '1000', '27', '4500', NULL, '1', '2026-03-01', '0', '0', '0000-00-00 00:00:00');
INSERT INTO `payment_collection` (`id`, `sale_id`, `invoice_no`, `customer_id`, `receive_amnt`, `due_amnt`, `receive_by`, `receive_date`, `is_installment`, `updateby`, `updatedate`) VALUES ('2', '20260301031416', '1000', '27', '2700', NULL, '1', '2026-03-01', '0', '0', '0000-00-00 00:00:00');


#
# TABLE STRUCTURE FOR: product
#

DROP TABLE IF EXISTS `product`;

CREATE TABLE `product` (
  `product_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `product_code` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `product_name` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `category` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `brand` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `unit` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `model` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `product_details` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
  `purchase_price` float NOT NULL DEFAULT 0,
  `minimum_price` float NOT NULL DEFAULT 0,
  `retail_price` float NOT NULL DEFAULT 0,
  `block_price` float NOT NULL DEFAULT 0,
  `isactive` tinyint(1) NOT NULL,
  `createby` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `createdate` datetime NOT NULL,
  `updateby` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `updatedate` datetime NOT NULL,
  PRIMARY KEY (`product_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `product` (`product_id`, `product_code`, `product_name`, `category`, `brand`, `unit`, `model`, `product_details`, `purchase_price`, `minimum_price`, `retail_price`, `block_price`, `isactive`, `createby`, `createdate`, `updateby`, `updatedate`) VALUES ('1', 'pro-1001', 'سيارة-كيا-موديل 2015', '3', '1', '1', '1', 'نضيف', '1100', '1000', '900', '0', '1', '1', '2026-01-30 02:22:42', '', '0000-00-00 00:00:00');
INSERT INTO `product` (`product_id`, `product_code`, `product_name`, `category`, `brand`, `unit`, `model`, `product_details`, `purchase_price`, `minimum_price`, `retail_price`, `block_price`, `isactive`, `createby`, `createdate`, `updateby`, `updatedate`) VALUES ('2', 'pro-1002', 'مواد غذائية-هائل سعيد-لا يوجد موديل', '1', '2', '2', '2', 'سكر السعيد', '1000', '900', '830', '0', '1', '1', '2026-02-26 01:45:05', '', '0000-00-00 00:00:00');


#
# TABLE STRUCTURE FOR: product_brand
#

DROP TABLE IF EXISTS `product_brand`;

CREATE TABLE `product_brand` (
  `brand_id` int(11) NOT NULL AUTO_INCREMENT,
  `brand_name` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `isactive` tinyint(1) NOT NULL,
  PRIMARY KEY (`brand_id`),
  UNIQUE KEY `brand_name_unique` (`brand_name`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `product_brand` (`brand_id`, `brand_name`, `isactive`) VALUES ('1', 'كيا', '1');
INSERT INTO `product_brand` (`brand_id`, `brand_name`, `isactive`) VALUES ('2', 'هائل سعيد', '1');


#
# TABLE STRUCTURE FOR: product_category
#

DROP TABLE IF EXISTS `product_category`;

CREATE TABLE `product_category` (
  `category_id` int(11) NOT NULL AUTO_INCREMENT,
  `category_name` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `isactive` tinyint(1) NOT NULL,
  PRIMARY KEY (`category_id`),
  UNIQUE KEY `category_name_unique` (`category_name`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `product_category` (`category_id`, `category_name`, `isactive`) VALUES ('1', 'مواد غذائية', '1');
INSERT INTO `product_category` (`category_id`, `category_name`, `isactive`) VALUES ('2', 'مواد استهلاكية', '1');
INSERT INTO `product_category` (`category_id`, `category_name`, `isactive`) VALUES ('3', 'سيارة', '1');


#
# TABLE STRUCTURE FOR: product_model
#

DROP TABLE IF EXISTS `product_model`;

CREATE TABLE `product_model` (
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
  `model_name` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `isactive` tinyint(1) NOT NULL,
  PRIMARY KEY (`model_id`),
  UNIQUE KEY `model_name_unique` (`model_name`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `product_model` (`model_id`, `model_name`, `isactive`) VALUES ('1', 'موديل 2015', '1');
INSERT INTO `product_model` (`model_id`, `model_name`, `isactive`) VALUES ('2', 'لا يوجد موديل', '1');


#
# TABLE STRUCTURE FOR: product_unit
#

DROP TABLE IF EXISTS `product_unit`;

CREATE TABLE `product_unit` (
  `unit_id` int(11) NOT NULL AUTO_INCREMENT,
  `unit_name` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `isactive` tinyint(1) NOT NULL,
  PRIMARY KEY (`unit_id`),
  UNIQUE KEY `unit_name_unique` (`unit_name`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `product_unit` (`unit_id`, `unit_name`, `isactive`) VALUES ('1', 'اللون ابيض', '1');
INSERT INTO `product_unit` (`unit_id`, `unit_name`, `isactive`) VALUES ('2', '10 كيلو', '1');


#
# TABLE STRUCTURE FOR: purchase_order
#

DROP TABLE IF EXISTS `purchase_order`;

CREATE TABLE `purchase_order` (
  `po_no` bigint(20) NOT NULL,
  `store_id` int(11) DEFAULT NULL,
  `warehouse_id` int(11) DEFAULT NULL,
  `createby` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `createdate` datetime NOT NULL,
  `isapproved` tinyint(1) DEFAULT NULL,
  `supplier_id` int(11) NOT NULL,
  `total_amnt` float NOT NULL,
  `updateby` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `updatedate` datetime DEFAULT NULL,
  PRIMARY KEY (`po_no`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `purchase_order` (`po_no`, `store_id`, `warehouse_id`, `createby`, `createdate`, `isapproved`, `supplier_id`, `total_amnt`, `updateby`, `updatedate`) VALUES ('20260301030626', '0', '0', '1', '2026-03-01 03:06:26', '1', '1', '3300', NULL, NULL);
INSERT INTO `purchase_order` (`po_no`, `store_id`, `warehouse_id`, `createby`, `createdate`, `isapproved`, `supplier_id`, `total_amnt`, `updateby`, `updatedate`) VALUES ('20260303213642', '0', '0', '2', '2026-03-03 21:36:42', '1', '1', '55000', NULL, NULL);


#
# TABLE STRUCTURE FOR: purchase_order_details
#

DROP TABLE IF EXISTS `purchase_order_details`;

CREATE TABLE `purchase_order_details` (
  `row_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `po_no` bigint(20) NOT NULL,
  `product_id` bigint(20) NOT NULL,
  `order_qty` int(11) NOT NULL,
  `product_rate` float NOT NULL,
  `discount` float NOT NULL,
  `store_id` int(11) NOT NULL,
  PRIMARY KEY (`row_id`),
  KEY `fk_po_no1` (`po_no`)
) ENGINE=InnoDB AUTO_INCREMENT=991226819451673 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `purchase_order_details` (`row_id`, `po_no`, `product_id`, `order_qty`, `product_rate`, `discount`, `store_id`) VALUES ('196873854733966', '20260301030626', '1', '3', '1100', '0', '1');
INSERT INTO `purchase_order_details` (`row_id`, `po_no`, `product_id`, `order_qty`, `product_rate`, `discount`, `store_id`) VALUES ('427681145679354', '20260303213642', '1', '50', '1100', '0', '2');


#
# TABLE STRUCTURE FOR: purchase_receive
#

DROP TABLE IF EXISTS `purchase_receive`;

CREATE TABLE `purchase_receive` (
  `receive_id` bigint(20) NOT NULL,
  `po_no` bigint(20) NOT NULL,
  `store_id` int(11) NOT NULL,
  `receive_by` int(11) NOT NULL,
  `receive_date` date NOT NULL,
  `supplier_id` int(11) NOT NULL,
  `voucher_no` int(11) NOT NULL,
  `warehouse_id` int(11) NOT NULL,
  `updateby` int(11) NOT NULL,
  `updatedate` datetime NOT NULL,
  PRIMARY KEY (`receive_id`),
  KEY `fk_po_no` (`po_no`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `purchase_receive` (`receive_id`, `po_no`, `store_id`, `receive_by`, `receive_date`, `supplier_id`, `voucher_no`, `warehouse_id`, `updateby`, `updatedate`) VALUES ('20260301030717', '20260301030626', '0', '1', '2026-03-01', '1', '1000', '0', '0', '0000-00-00 00:00:00');
INSERT INTO `purchase_receive` (`receive_id`, `po_no`, `store_id`, `receive_by`, `receive_date`, `supplier_id`, `voucher_no`, `warehouse_id`, `updateby`, `updatedate`) VALUES ('20260303221518', '20260303213642', '0', '1', '2026-03-03', '1', '1001', '0', '0', '0000-00-00 00:00:00');
INSERT INTO `purchase_receive` (`receive_id`, `po_no`, `store_id`, `receive_by`, `receive_date`, `supplier_id`, `voucher_no`, `warehouse_id`, `updateby`, `updatedate`) VALUES ('20260305220102', '20260303213642', '0', '1', '2026-03-05', '1', '1002', '0', '0', '0000-00-00 00:00:00');
INSERT INTO `purchase_receive` (`receive_id`, `po_no`, `store_id`, `receive_by`, `receive_date`, `supplier_id`, `voucher_no`, `warehouse_id`, `updateby`, `updatedate`) VALUES ('20260305220141', '20260303213642', '0', '1', '2026-03-05', '1', '1003', '0', '0', '0000-00-00 00:00:00');


#
# TABLE STRUCTURE FOR: purchase_receive_details
#

DROP TABLE IF EXISTS `purchase_receive_details`;

CREATE TABLE `purchase_receive_details` (
  `receive_id` bigint(20) NOT NULL,
  `product_id` bigint(20) NOT NULL,
  `receive_qty` int(11) NOT NULL,
  `product_rate` float NOT NULL,
  `store_id` int(11) NOT NULL,
  `discount` float NOT NULL,
  KEY `fk_receive_id` (`receive_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `purchase_receive_details` (`receive_id`, `product_id`, `receive_qty`, `product_rate`, `store_id`, `discount`) VALUES ('20260301030717', '1', '3', '1100', '1', '0');
INSERT INTO `purchase_receive_details` (`receive_id`, `product_id`, `receive_qty`, `product_rate`, `store_id`, `discount`) VALUES ('20260303221518', '1', '30', '1100', '2', '0');
INSERT INTO `purchase_receive_details` (`receive_id`, `product_id`, `receive_qty`, `product_rate`, `store_id`, `discount`) VALUES ('20260305220102', '1', '10', '1100', '2', '0');
INSERT INTO `purchase_receive_details` (`receive_id`, `product_id`, `receive_qty`, `product_rate`, `store_id`, `discount`) VALUES ('20260305220141', '1', '9', '1100', '2', '0');


#
# TABLE STRUCTURE FOR: purchase_return
#

DROP TABLE IF EXISTS `purchase_return`;

CREATE TABLE `purchase_return` (
  `preturn_id` int(11) NOT NULL AUTO_INCREMENT,
  `store_id` int(11) NOT NULL,
  `warehouse_id` int(11) NOT NULL,
  `supplier_id` int(11) NOT NULL,
  `po_no` bigint(20) NOT NULL,
  `return_date` date NOT NULL,
  `totalamount` float NOT NULL,
  `totaldiscount` float NOT NULL,
  `return_reason` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
  `createby` int(11) NOT NULL,
  `createdate` datetime NOT NULL,
  `updateby` int(11) NOT NULL,
  `updatedate` datetime NOT NULL,
  PRIMARY KEY (`preturn_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `purchase_return` (`preturn_id`, `store_id`, `warehouse_id`, `supplier_id`, `po_no`, `return_date`, `totalamount`, `totaldiscount`, `return_reason`, `createby`, `createdate`, `updateby`, `updatedate`) VALUES ('1', '0', '0', '1', '20260301030626', '2026-03-04', '1100', '0', 'لا يوجد سبب', '1', '2026-03-04 05:32:27', '0', '0000-00-00 00:00:00');


#
# TABLE STRUCTURE FOR: purchase_return_details
#

DROP TABLE IF EXISTS `purchase_return_details`;

CREATE TABLE `purchase_return_details` (
  `preturn_id` int(11) NOT NULL,
  `product_id` bigint(20) NOT NULL,
  `qty` int(11) NOT NULL,
  `product_rate` float NOT NULL,
  `store_id` int(11) NOT NULL,
  `discount` float DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `purchase_return_details` (`preturn_id`, `product_id`, `qty`, `product_rate`, `store_id`, `discount`) VALUES ('1', '1', '1', '1100', '1', NULL);


#
# TABLE STRUCTURE FOR: recovery_list
#

DROP TABLE IF EXISTS `recovery_list`;

CREATE   VIEW `recovery_list` AS select `sales_parent`.`remaining_amnt` - sum(`payment_collection`.`receive_amnt`) AS `over_due`,`sales_parent`.`store_id` AS `store_id`,`sales_parent`.`invoice_no` AS `invoice_no`,`sales_parent`.`customer_id` AS `customer_id`,`sales_parent`.`sales_date` AS `sales_date`,`sales_parent`.`lease_id` AS `lease_id`,`sales_parent`.`installment_amnt` AS `installment_amnt`,`sales_parent`.`gurrantor_1` AS `gurrantor_1`,`sales_parent`.`remaining_amnt` AS `remaining_amnt`,`sales_parent`.`package_price` AS `package_price`,`sales_parent`.`advance_amnt` AS `advance_amnt`,sum(`payment_collection`.`receive_amnt`) AS `receive_amnt`,`payment_collection`.`receive_date` AS `receive_date`,`payment_collection`.`is_installment` AS `is_installment`,`lease`.`lease_duration` AS `lease_duration`,`lease`.`advance` AS `advance`,`lease`.`markup` AS `markup` from ((`sales_parent` join `payment_collection`) join `lease`) where `sales_parent`.`invoice_no` = `payment_collection`.`invoice_no` and `sales_parent`.`lease_id` = `lease`.`lease_id` and `payment_collection`.`is_installment` = 1 group by `sales_parent`.`invoice_no`;

utf8mb4_general_ci;

#
# TABLE STRUCTURE FOR: role_permission
#

DROP TABLE IF EXISTS `role_permission`;

CREATE TABLE `role_permission` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `fk_module_id` int(11) NOT NULL,
  `role_id` int(11) NOT NULL,
  `create` tinyint(1) DEFAULT NULL,
  `read` tinyint(1) DEFAULT NULL,
  `update` tinyint(1) DEFAULT NULL,
  `delete` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_module_id` (`fk_module_id`),
  KEY `fk_user_id` (`role_id`)
) ENGINE=InnoDB AUTO_INCREMENT=573 DEFAULT CHARSET=utf8;

INSERT INTO `role_permission` (`id`, `fk_module_id`, `role_id`, `create`, `read`, `update`, `delete`) VALUES ('178', '3', '1', '0', '0', '0', '0');
INSERT INTO `role_permission` (`id`, `fk_module_id`, `role_id`, `create`, `read`, `update`, `delete`) VALUES ('179', '4', '1', '0', '0', '0', '0');
INSERT INTO `role_permission` (`id`, `fk_module_id`, `role_id`, `create`, `read`, `update`, `delete`) VALUES ('180', '5', '1', '0', '0', '0', '0');
INSERT INTO `role_permission` (`id`, `fk_module_id`, `role_id`, `create`, `read`, `update`, `delete`) VALUES ('181', '6', '1', '0', '0', '0', '0');
INSERT INTO `role_permission` (`id`, `fk_module_id`, `role_id`, `create`, `read`, `update`, `delete`) VALUES ('182', '7', '1', '0', '0', '0', '0');
INSERT INTO `role_permission` (`id`, `fk_module_id`, `role_id`, `create`, `read`, `update`, `delete`) VALUES ('183', '8', '1', '0', '0', '0', '0');
INSERT INTO `role_permission` (`id`, `fk_module_id`, `role_id`, `create`, `read`, `update`, `delete`) VALUES ('184', '9', '1', '0', '0', '0', '0');
INSERT INTO `role_permission` (`id`, `fk_module_id`, `role_id`, `create`, `read`, `update`, `delete`) VALUES ('185', '10', '1', '0', '0', '0', '0');
INSERT INTO `role_permission` (`id`, `fk_module_id`, `role_id`, `create`, `read`, `update`, `delete`) VALUES ('186', '11', '1', '0', '0', '0', '0');
INSERT INTO `role_permission` (`id`, `fk_module_id`, `role_id`, `create`, `read`, `update`, `delete`) VALUES ('187', '12', '1', '0', '0', '0', '0');
INSERT INTO `role_permission` (`id`, `fk_module_id`, `role_id`, `create`, `read`, `update`, `delete`) VALUES ('188', '13', '1', '0', '0', '0', '0');
INSERT INTO `role_permission` (`id`, `fk_module_id`, `role_id`, `create`, `read`, `update`, `delete`) VALUES ('189', '14', '1', '0', '0', '0', '0');
INSERT INTO `role_permission` (`id`, `fk_module_id`, `role_id`, `create`, `read`, `update`, `delete`) VALUES ('521', '13', '2', '0', '0', '0', '0');
INSERT INTO `role_permission` (`id`, `fk_module_id`, `role_id`, `create`, `read`, `update`, `delete`) VALUES ('522', '7', '2', '0', '0', '0', '0');
INSERT INTO `role_permission` (`id`, `fk_module_id`, `role_id`, `create`, `read`, `update`, `delete`) VALUES ('523', '10', '2', '1', '1', '1', '1');
INSERT INTO `role_permission` (`id`, `fk_module_id`, `role_id`, `create`, `read`, `update`, `delete`) VALUES ('524', '14', '2', '0', '0', '0', '0');
INSERT INTO `role_permission` (`id`, `fk_module_id`, `role_id`, `create`, `read`, `update`, `delete`) VALUES ('525', '19', '2', '0', '0', '0', '0');
INSERT INTO `role_permission` (`id`, `fk_module_id`, `role_id`, `create`, `read`, `update`, `delete`) VALUES ('526', '18', '2', '1', '1', '1', '1');
INSERT INTO `role_permission` (`id`, `fk_module_id`, `role_id`, `create`, `read`, `update`, `delete`) VALUES ('527', '12', '2', '1', '1', '1', '1');
INSERT INTO `role_permission` (`id`, `fk_module_id`, `role_id`, `create`, `read`, `update`, `delete`) VALUES ('528', '17', '2', '1', '1', '1', '1');
INSERT INTO `role_permission` (`id`, `fk_module_id`, `role_id`, `create`, `read`, `update`, `delete`) VALUES ('529', '9', '2', '0', '0', '0', '0');
INSERT INTO `role_permission` (`id`, `fk_module_id`, `role_id`, `create`, `read`, `update`, `delete`) VALUES ('530', '20', '2', '1', '1', '1', '1');
INSERT INTO `role_permission` (`id`, `fk_module_id`, `role_id`, `create`, `read`, `update`, `delete`) VALUES ('531', '6', '2', '0', '0', '0', '0');
INSERT INTO `role_permission` (`id`, `fk_module_id`, `role_id`, `create`, `read`, `update`, `delete`) VALUES ('532', '3', '2', '1', '1', '1', '1');
INSERT INTO `role_permission` (`id`, `fk_module_id`, `role_id`, `create`, `read`, `update`, `delete`) VALUES ('533', '1', '2', '0', '0', '0', '0');
INSERT INTO `role_permission` (`id`, `fk_module_id`, `role_id`, `create`, `read`, `update`, `delete`) VALUES ('534', '13', '4', '0', '0', '0', '0');
INSERT INTO `role_permission` (`id`, `fk_module_id`, `role_id`, `create`, `read`, `update`, `delete`) VALUES ('535', '7', '4', '1', '1', '1', '0');
INSERT INTO `role_permission` (`id`, `fk_module_id`, `role_id`, `create`, `read`, `update`, `delete`) VALUES ('536', '10', '4', '1', '1', '1', '1');
INSERT INTO `role_permission` (`id`, `fk_module_id`, `role_id`, `create`, `read`, `update`, `delete`) VALUES ('537', '14', '4', '1', '1', '1', '0');
INSERT INTO `role_permission` (`id`, `fk_module_id`, `role_id`, `create`, `read`, `update`, `delete`) VALUES ('538', '19', '4', '1', '1', '1', '0');
INSERT INTO `role_permission` (`id`, `fk_module_id`, `role_id`, `create`, `read`, `update`, `delete`) VALUES ('539', '18', '4', '1', '1', '1', '1');
INSERT INTO `role_permission` (`id`, `fk_module_id`, `role_id`, `create`, `read`, `update`, `delete`) VALUES ('540', '12', '4', '1', '1', '1', '1');
INSERT INTO `role_permission` (`id`, `fk_module_id`, `role_id`, `create`, `read`, `update`, `delete`) VALUES ('541', '17', '4', '1', '0', '0', '0');
INSERT INTO `role_permission` (`id`, `fk_module_id`, `role_id`, `create`, `read`, `update`, `delete`) VALUES ('542', '9', '4', '0', '0', '0', '0');
INSERT INTO `role_permission` (`id`, `fk_module_id`, `role_id`, `create`, `read`, `update`, `delete`) VALUES ('543', '20', '4', '0', '1', '0', '0');
INSERT INTO `role_permission` (`id`, `fk_module_id`, `role_id`, `create`, `read`, `update`, `delete`) VALUES ('544', '6', '4', '0', '0', '0', '0');
INSERT INTO `role_permission` (`id`, `fk_module_id`, `role_id`, `create`, `read`, `update`, `delete`) VALUES ('545', '3', '4', '0', '0', '0', '0');
INSERT INTO `role_permission` (`id`, `fk_module_id`, `role_id`, `create`, `read`, `update`, `delete`) VALUES ('546', '1', '4', '0', '0', '0', '0');
INSERT INTO `role_permission` (`id`, `fk_module_id`, `role_id`, `create`, `read`, `update`, `delete`) VALUES ('547', '13', '5', '1', '1', '1', '1');
INSERT INTO `role_permission` (`id`, `fk_module_id`, `role_id`, `create`, `read`, `update`, `delete`) VALUES ('548', '7', '5', '0', '0', '0', '0');
INSERT INTO `role_permission` (`id`, `fk_module_id`, `role_id`, `create`, `read`, `update`, `delete`) VALUES ('549', '10', '5', '0', '0', '0', '0');
INSERT INTO `role_permission` (`id`, `fk_module_id`, `role_id`, `create`, `read`, `update`, `delete`) VALUES ('550', '14', '5', '0', '0', '0', '0');
INSERT INTO `role_permission` (`id`, `fk_module_id`, `role_id`, `create`, `read`, `update`, `delete`) VALUES ('551', '19', '5', '0', '0', '0', '0');
INSERT INTO `role_permission` (`id`, `fk_module_id`, `role_id`, `create`, `read`, `update`, `delete`) VALUES ('552', '18', '5', '0', '0', '0', '0');
INSERT INTO `role_permission` (`id`, `fk_module_id`, `role_id`, `create`, `read`, `update`, `delete`) VALUES ('553', '12', '5', '1', '1', '1', '1');
INSERT INTO `role_permission` (`id`, `fk_module_id`, `role_id`, `create`, `read`, `update`, `delete`) VALUES ('554', '17', '5', '0', '0', '0', '0');
INSERT INTO `role_permission` (`id`, `fk_module_id`, `role_id`, `create`, `read`, `update`, `delete`) VALUES ('555', '9', '5', '0', '0', '0', '0');
INSERT INTO `role_permission` (`id`, `fk_module_id`, `role_id`, `create`, `read`, `update`, `delete`) VALUES ('556', '20', '5', '0', '1', '0', '0');
INSERT INTO `role_permission` (`id`, `fk_module_id`, `role_id`, `create`, `read`, `update`, `delete`) VALUES ('557', '6', '5', '0', '0', '0', '0');
INSERT INTO `role_permission` (`id`, `fk_module_id`, `role_id`, `create`, `read`, `update`, `delete`) VALUES ('558', '3', '5', '0', '0', '0', '0');
INSERT INTO `role_permission` (`id`, `fk_module_id`, `role_id`, `create`, `read`, `update`, `delete`) VALUES ('559', '1', '5', '0', '0', '0', '0');
INSERT INTO `role_permission` (`id`, `fk_module_id`, `role_id`, `create`, `read`, `update`, `delete`) VALUES ('560', '13', '3', '0', '0', '0', '0');
INSERT INTO `role_permission` (`id`, `fk_module_id`, `role_id`, `create`, `read`, `update`, `delete`) VALUES ('561', '7', '3', '0', '1', '0', '0');
INSERT INTO `role_permission` (`id`, `fk_module_id`, `role_id`, `create`, `read`, `update`, `delete`) VALUES ('562', '10', '3', '1', '1', '1', '1');
INSERT INTO `role_permission` (`id`, `fk_module_id`, `role_id`, `create`, `read`, `update`, `delete`) VALUES ('563', '14', '3', '0', '0', '0', '0');
INSERT INTO `role_permission` (`id`, `fk_module_id`, `role_id`, `create`, `read`, `update`, `delete`) VALUES ('564', '19', '3', '0', '0', '0', '0');
INSERT INTO `role_permission` (`id`, `fk_module_id`, `role_id`, `create`, `read`, `update`, `delete`) VALUES ('565', '18', '3', '0', '0', '0', '0');
INSERT INTO `role_permission` (`id`, `fk_module_id`, `role_id`, `create`, `read`, `update`, `delete`) VALUES ('566', '12', '3', '1', '1', '1', '1');
INSERT INTO `role_permission` (`id`, `fk_module_id`, `role_id`, `create`, `read`, `update`, `delete`) VALUES ('567', '17', '3', '1', '1', '1', '0');
INSERT INTO `role_permission` (`id`, `fk_module_id`, `role_id`, `create`, `read`, `update`, `delete`) VALUES ('568', '9', '3', '0', '0', '0', '0');
INSERT INTO `role_permission` (`id`, `fk_module_id`, `role_id`, `create`, `read`, `update`, `delete`) VALUES ('569', '20', '3', '0', '1', '0', '0');
INSERT INTO `role_permission` (`id`, `fk_module_id`, `role_id`, `create`, `read`, `update`, `delete`) VALUES ('570', '6', '3', '0', '1', '0', '1');
INSERT INTO `role_permission` (`id`, `fk_module_id`, `role_id`, `create`, `read`, `update`, `delete`) VALUES ('571', '3', '3', '0', '0', '0', '0');
INSERT INTO `role_permission` (`id`, `fk_module_id`, `role_id`, `create`, `read`, `update`, `delete`) VALUES ('572', '1', '3', '1', '1', '0', '0');


#
# TABLE STRUCTURE FOR: sale_details
#

DROP TABLE IF EXISTS `sale_details`;

CREATE TABLE `sale_details` (
  `sale_id` bigint(20) NOT NULL,
  `product_id` int(11) NOT NULL,
  `qty` int(11) NOT NULL,
  `sell_price` float NOT NULL,
  `lease_unit_price` float DEFAULT NULL,
  `sale_type_id` tinyint(4) DEFAULT NULL,
  UNIQUE KEY `sale_id` (`sale_id`,`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `sale_details` (`sale_id`, `product_id`, `qty`, `sell_price`, `lease_unit_price`, `sale_type_id`) VALUES ('20260301031258', '1', '5', '900', NULL, '1');
INSERT INTO `sale_details` (`sale_id`, `product_id`, `qty`, `sell_price`, `lease_unit_price`, `sale_type_id`) VALUES ('20260301031416', '1', '3', '900', NULL, '1');


#
# TABLE STRUCTURE FOR: sale_type
#

DROP TABLE IF EXISTS `sale_type`;

CREATE TABLE `sale_type` (
  `sale_type_id` tinyint(4) NOT NULL AUTO_INCREMENT,
  `sale_type` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `shortcode` varchar(3) COLLATE utf8_unicode_ci NOT NULL,
  `createby` int(11) NOT NULL,
  `createdate` datetime NOT NULL,
  `updateby` int(11) NOT NULL,
  `upadatedate` datetime NOT NULL,
  `isactive` tinyint(1) NOT NULL DEFAULT 1,
  PRIMARY KEY (`sale_type_id`),
  UNIQUE KEY `shortcode` (`shortcode`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `sale_type` (`sale_type_id`, `sale_type`, `shortcode`, `createby`, `createdate`, `updateby`, `upadatedate`, `isactive`) VALUES ('1', 'Cash Sale', 'CS', '0', '2015-10-15 00:00:00', '0', '2015-10-15 00:00:00', '1');
INSERT INTO `sale_type` (`sale_type_id`, `sale_type`, `shortcode`, `createby`, `createdate`, `updateby`, `upadatedate`, `isactive`) VALUES ('2', 'Partial Cash Sale', 'PS', '0', '2015-10-15 00:00:00', '0', '2015-10-15 00:00:00', '1');
INSERT INTO `sale_type` (`sale_type_id`, `sale_type`, `shortcode`, `createby`, `createdate`, `updateby`, `upadatedate`, `isactive`) VALUES ('3', 'Lease Sale', 'LS', '0', '2015-10-15 00:00:00', '0', '2015-10-15 00:00:00', '1');


#
# TABLE STRUCTURE FOR: sales_parent
#

DROP TABLE IF EXISTS `sales_parent`;

CREATE TABLE `sales_parent` (
  `sale_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `sale_type_id` tinyint(4) NOT NULL,
  `store_id` int(11) NOT NULL,
  `invoice_no` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `customer_id` int(11) NOT NULL,
  `salesman` int(11) NOT NULL,
  `sales_date` date NOT NULL,
  `sales_time` time NOT NULL,
  `lease_id` int(11) DEFAULT NULL,
  `gurrantor_1` int(11) DEFAULT NULL,
  `gurrantor_2` int(11) DEFAULT NULL,
  `inquiry_officer` int(11) DEFAULT NULL,
  `total_amnt` float DEFAULT NULL,
  `package_price` float DEFAULT NULL,
  `advance_amnt` int(11) DEFAULT NULL,
  `remaining_amnt` float DEFAULT NULL,
  `installment_amnt` float DEFAULT NULL,
  `is_lease_settled` tinyint(1) NOT NULL DEFAULT 0,
  `updateby` int(11) NOT NULL,
  `updatedate` datetime NOT NULL,
  PRIMARY KEY (`sale_id`),
  UNIQUE KEY `invoice_no` (`invoice_no`),
  KEY `sale_type_id` (`sale_type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

#
# TABLE STRUCTURE FOR: sales_return
#

DROP TABLE IF EXISTS `sales_return`;

CREATE TABLE `sales_return` (
  `sreturn_id` int(11) NOT NULL AUTO_INCREMENT,
  `customer_id` int(11) NOT NULL,
  `store_id` int(11) NOT NULL,
  `sale_type_id` tinyint(1) DEFAULT NULL,
  `invoice_no` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `return_date` date NOT NULL,
  `totalamount` float NOT NULL,
  `totaldiscount` float NOT NULL,
  `return_reason` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
  `createby` int(11) NOT NULL,
  `createdate` datetime NOT NULL,
  `updateby` int(11) NOT NULL,
  `updatedate` datetime NOT NULL,
  PRIMARY KEY (`sreturn_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

#
# TABLE STRUCTURE FOR: sales_return_details
#

DROP TABLE IF EXISTS `sales_return_details`;

CREATE TABLE `sales_return_details` (
  `sreturn_id` int(11) NOT NULL,
  `product_id` bigint(20) NOT NULL,
  `qty` int(11) NOT NULL,
  `product_rate` float NOT NULL,
  `discount` float DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

#
# TABLE STRUCTURE FOR: sec_role
#

DROP TABLE IF EXISTS `sec_role`;

CREATE TABLE `sec_role` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `isactive` tinyint(1) NOT NULL,
  `createby` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `createdate` datetime NOT NULL,
  `updateby` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `updatedate` datetime DEFAULT NULL,
  PRIMARY KEY (`name`),
  UNIQUE KEY `ID` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `sec_role` (`id`, `name`, `isactive`, `createby`, `createdate`, `updateby`, `updatedate`) VALUES ('5', 'Pricing User', '1', '2', '2018-05-15 03:23:45', '', NULL);
INSERT INTO `sec_role` (`id`, `name`, `isactive`, `createby`, `createdate`, `updateby`, `updatedate`) VALUES ('4', 'Purchase User', '1', '2', '2018-05-15 03:23:32', '', NULL);
INSERT INTO `sec_role` (`id`, `name`, `isactive`, `createby`, `createdate`, `updateby`, `updatedate`) VALUES ('2', 'Store Admin', '1', '2', '2018-05-15 03:22:59', '', NULL);
INSERT INTO `sec_role` (`id`, `name`, `isactive`, `createby`, `createdate`, `updateby`, `updatedate`) VALUES ('3', 'Store User', '1', '2', '2018-05-15 03:23:22', '', NULL);
INSERT INTO `sec_role` (`id`, `name`, `isactive`, `createby`, `createdate`, `updateby`, `updatedate`) VALUES ('1', 'Super Admin', '1', '2', '2018-05-15 03:22:44', '', NULL);


#
# TABLE STRUCTURE FOR: sec_userrole
#

DROP TABLE IF EXISTS `sec_userrole`;

CREATE TABLE `sec_userrole` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `roleid` int(11) NOT NULL,
  `createby` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `createdate` datetime NOT NULL,
  UNIQUE KEY `ID` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `sec_userrole` (`id`, `user_id`, `roleid`, `createby`, `createdate`) VALUES ('2', '6', '3', '2', '2018-05-15 03:33:39');
INSERT INTO `sec_userrole` (`id`, `user_id`, `roleid`, `createby`, `createdate`) VALUES ('26', '2', '4', '1', '2026-03-05 10:39:13');
INSERT INTO `sec_userrole` (`id`, `user_id`, `roleid`, `createby`, `createdate`) VALUES ('27', '2', '2', '1', '2026-03-05 10:39:13');
INSERT INTO `sec_userrole` (`id`, `user_id`, `roleid`, `createby`, `createdate`) VALUES ('29', '3', '5', '1', '2026-03-06 09:39:27');
INSERT INTO `sec_userrole` (`id`, `user_id`, `roleid`, `createby`, `createdate`) VALUES ('30', '3', '3', '1', '2026-03-06 09:39:27');


#
# TABLE STRUCTURE FOR: setting
#

DROP TABLE IF EXISTS `setting`;

CREATE TABLE `setting` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `address` text DEFAULT NULL,
  `email` varchar(50) DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `logo` varchar(50) DEFAULT NULL,
  `favicon` varchar(100) DEFAULT NULL,
  `language` varchar(100) DEFAULT NULL,
  `site_align` varchar(50) DEFAULT NULL,
  `footer_text` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

INSERT INTO `setting` (`id`, `title`, `address`, `email`, `phone`, `logo`, `favicon`, `language`, `site_align`, `footer_text`) VALUES ('2', 'مخازن يمن دبليو ثري', 'صنعاء شارع النصر المدينة السكنية', 'info@yemenw3.com', '773381661', 'assets/img/icons/logo.png', 'assets/img/icons/m.png', 'arabic', 'RTL', '2026©Copyright');


#
# TABLE STRUCTURE FOR: stock_movement
#

DROP TABLE IF EXISTS `stock_movement`;

CREATE TABLE `stock_movement` (
  `movement_id` int(11) NOT NULL AUTO_INCREMENT,
  `proposal_code` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `issue_code` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `for_store_id` int(11) NOT NULL,
  `from_store_id` int(11) NOT NULL,
  `for_warehouse` int(11) DEFAULT NULL,
  `from_warehouse` int(11) DEFAULT NULL,
  `proposal_datetime` date NOT NULL,
  `proposal_by` int(11) NOT NULL,
  `issue_datetime` date NOT NULL,
  `issue_by` int(11) NOT NULL,
  `proposal_remarks` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `issue_remarks` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `receive_by` int(11) NOT NULL,
  `receive_datetime` date NOT NULL,
  `receive_remarks` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `is_approved` tinyint(1) NOT NULL DEFAULT 0,
  `is_proposed` tinyint(1) DEFAULT NULL,
  `is_issued` tinyint(1) DEFAULT NULL,
  `is_received` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`movement_id`),
  UNIQUE KEY `proposal_code_unique` (`proposal_code`),
  UNIQUE KEY `issue_code_unique` (`issue_code`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `stock_movement` (`movement_id`, `proposal_code`, `issue_code`, `for_store_id`, `from_store_id`, `for_warehouse`, `from_warehouse`, `proposal_datetime`, `proposal_by`, `issue_datetime`, `issue_by`, `proposal_remarks`, `issue_remarks`, `receive_by`, `receive_datetime`, `receive_remarks`, `is_approved`, `is_proposed`, `is_issued`, `is_received`) VALUES ('1', 'p-0001', NULL, '1', '1', NULL, NULL, '2026-02-26', '1', '0000-00-00', '0', NULL, NULL, '0', '0000-00-00', NULL, '0', NULL, NULL, NULL);
INSERT INTO `stock_movement` (`movement_id`, `proposal_code`, `issue_code`, `for_store_id`, `from_store_id`, `for_warehouse`, `from_warehouse`, `proposal_datetime`, `proposal_by`, `issue_datetime`, `issue_by`, `proposal_remarks`, `issue_remarks`, `receive_by`, `receive_datetime`, `receive_remarks`, `is_approved`, `is_proposed`, `is_issued`, `is_received`) VALUES ('2', 'p-2', NULL, '1', '2', NULL, NULL, '2026-02-26', '1', '0000-00-00', '0', NULL, NULL, '0', '0000-00-00', NULL, '0', NULL, NULL, NULL);
INSERT INTO `stock_movement` (`movement_id`, `proposal_code`, `issue_code`, `for_store_id`, `from_store_id`, `for_warehouse`, `from_warehouse`, `proposal_datetime`, `proposal_by`, `issue_datetime`, `issue_by`, `proposal_remarks`, `issue_remarks`, `receive_by`, `receive_datetime`, `receive_remarks`, `is_approved`, `is_proposed`, `is_issued`, `is_received`) VALUES ('3', 'p-3', NULL, '1', '1', NULL, NULL, '2026-03-01', '1', '0000-00-00', '0', NULL, NULL, '0', '0000-00-00', NULL, '0', NULL, NULL, NULL);
INSERT INTO `stock_movement` (`movement_id`, `proposal_code`, `issue_code`, `for_store_id`, `from_store_id`, `for_warehouse`, `from_warehouse`, `proposal_datetime`, `proposal_by`, `issue_datetime`, `issue_by`, `proposal_remarks`, `issue_remarks`, `receive_by`, `receive_datetime`, `receive_remarks`, `is_approved`, `is_proposed`, `is_issued`, `is_received`) VALUES ('4', 'p-4', NULL, '1', '2', NULL, NULL, '2026-03-05', '1', '0000-00-00', '0', NULL, NULL, '0', '0000-00-00', NULL, '0', NULL, NULL, NULL);


#
# TABLE STRUCTURE FOR: stock_movement_details
#

DROP TABLE IF EXISTS `stock_movement_details`;

CREATE TABLE `stock_movement_details` (
  `movement_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `proposal_qty` int(11) NOT NULL,
  `issue_qty` int(11) NOT NULL,
  `received_qty` int(11) NOT NULL,
  KEY `stock_movement_details_ibfk_1` (`movement_id`),
  CONSTRAINT `stock_movement_details_ibfk_1` FOREIGN KEY (`movement_id`) REFERENCES `stock_movement` (`movement_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `stock_movement_details` (`movement_id`, `product_id`, `proposal_qty`, `issue_qty`, `received_qty`) VALUES ('1', '0', '14', '0', '0');
INSERT INTO `stock_movement_details` (`movement_id`, `product_id`, `proposal_qty`, `issue_qty`, `received_qty`) VALUES ('1', '0', '11', '0', '0');
INSERT INTO `stock_movement_details` (`movement_id`, `product_id`, `proposal_qty`, `issue_qty`, `received_qty`) VALUES ('2', '0', '5', '0', '0');
INSERT INTO `stock_movement_details` (`movement_id`, `product_id`, `proposal_qty`, `issue_qty`, `received_qty`) VALUES ('3', '1', '7', '0', '0');
INSERT INTO `stock_movement_details` (`movement_id`, `product_id`, `proposal_qty`, `issue_qty`, `received_qty`) VALUES ('4', '1', '2', '0', '0');


#
# TABLE STRUCTURE FOR: stoere_overdue
#

DROP TABLE IF EXISTS `stoere_overdue`;

CREATE   VIEW `stoere_overdue` AS select `sales_parent`.`store_id` AS `store_id`,`sales_parent`.`invoice_no` AS `invoice_no`,`sales_parent`.`customer_id` AS `customer_id`,`sales_parent`.`sales_date` AS `sales_date`,`sales_parent`.`lease_id` AS `lease_id`,`sales_parent`.`installment_amnt` AS `installment_amnt`,`sales_parent`.`package_price` AS `package_price`,`sales_parent`.`advance_amnt` AS `advance_amnt`,`payment_collection`.`receive_amnt` AS `receive_amnt`,`payment_collection`.`receive_date` AS `receive_date`,`payment_collection`.`is_installment` AS `is_installment`,`lease`.`lease_duration` AS `lease_duration`,`lease`.`advance` AS `advance`,`lease`.`markup` AS `markup` from ((`sales_parent` join `payment_collection`) join `lease`) where `sales_parent`.`invoice_no` = `payment_collection`.`invoice_no` and `sales_parent`.`lease_id` = `lease`.`lease_id`;

utf8mb4_general_ci;

#
# TABLE STRUCTURE FOR: store
#

DROP TABLE IF EXISTS `store`;

CREATE TABLE `store` (
  `store_id` int(11) NOT NULL AUTO_INCREMENT,
  `store_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `store_code` varchar(3) COLLATE utf8_unicode_ci NOT NULL,
  `store_phone` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `store_address` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `createby` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `createdate` datetime NOT NULL,
  `updateby` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `updatedate` datetime DEFAULT NULL,
  `isactive` tinyint(1) NOT NULL,
  PRIMARY KEY (`store_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `store` (`store_id`, `store_name`, `store_code`, `store_phone`, `store_address`, `createby`, `createdate`, `updateby`, `updatedate`, `isactive`) VALUES ('1', 'Yemen W3', 'CW3', '773381661', 'ssssssssssssssss', '1', '2026-01-30 00:21:41', NULL, NULL, '1');
INSERT INTO `store` (`store_id`, `store_name`, `store_code`, `store_phone`, `store_address`, `createby`, `createdate`, `updateby`, `updatedate`, `isactive`) VALUES ('2', 'متجر الشرعبي', 'zxz', '773381667', 'hgu', '1', '2026-03-06 22:20:10', NULL, NULL, '1');


#
# TABLE STRUCTURE FOR: supplier
#

DROP TABLE IF EXISTS `supplier`;

CREATE TABLE `supplier` (
  `supplier_id` int(11) NOT NULL AUTO_INCREMENT,
  `supplier_code` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `supplier_name` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `address` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `phone` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `contact_per_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `c_p_contact` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `isactive` tinyint(1) NOT NULL,
  `createby` int(11) NOT NULL,
  `createdate` datetime NOT NULL,
  `updateby` int(11) NOT NULL,
  `updatedate` datetime NOT NULL,
  PRIMARY KEY (`supplier_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `supplier` (`supplier_id`, `supplier_code`, `supplier_name`, `address`, `phone`, `email`, `contact_per_name`, `c_p_contact`, `isactive`, `createby`, `createdate`, `updateby`, `updatedate`) VALUES ('1', 'sup-1', 'Yemen w3', 'sanaa', '773381661', 'info@yemenw3.com', '773381661', '773381661', '1', '1', '2026-01-30 00:22:41', '0', '0000-00-00 00:00:00');


#
# TABLE STRUCTURE FOR: synchronizer_setting
#

DROP TABLE IF EXISTS `synchronizer_setting`;

CREATE TABLE `synchronizer_setting` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `hostname` varchar(100) NOT NULL,
  `username` varchar(100) NOT NULL,
  `password` varchar(100) NOT NULL,
  `port` varchar(10) NOT NULL,
  `debug` varchar(10) NOT NULL,
  `project_root` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

INSERT INTO `synchronizer_setting` (`id`, `hostname`, `username`, `password`, `port`, `debug`, `project_root`) VALUES ('8', '70.35.198.200', 'spreadcargo', '123123123123', '21', 'true', './public_html/');


#
# TABLE STRUCTURE FOR: test
#

DROP TABLE IF EXISTS `test`;

CREATE TABLE `test` (
  `test_id` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`test_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

#
# TABLE STRUCTURE FOR: tmp_store_stock
#

DROP TABLE IF EXISTS `tmp_store_stock`;

CREATE TABLE `tmp_store_stock` (
  `StoreID` int(11) NOT NULL,
  `Stock_Date` datetime NOT NULL,
  `ProdID` bigint(20) NOT NULL,
  `InQty` int(11) NOT NULL,
  `OutQty` int(11) NOT NULL,
  `category_id` varchar(11) COLLATE utf8_unicode_ci NOT NULL,
  `brand_id` varchar(11) COLLATE utf8_unicode_ci NOT NULL,
  `model_id` varchar(11) COLLATE utf8_unicode_ci NOT NULL,
  `Remarks` varchar(50) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

#
# TABLE STRUCTURE FOR: treeview_items
#

DROP TABLE IF EXISTS `treeview_items`;

CREATE TABLE `treeview_items` (
  `id` int(11) NOT NULL,
  `name` varchar(200) NOT NULL,
  `text` varchar(200) NOT NULL,
  `parent_id` varchar(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

#
# TABLE STRUCTURE FOR: user
#

DROP TABLE IF EXISTS `user`;

CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `firstname` varchar(50) DEFAULT NULL,
  `lastname` varchar(50) DEFAULT NULL,
  `about` text DEFAULT NULL,
  `email` varchar(100) NOT NULL,
  `password` varchar(32) NOT NULL,
  `password_reset_token` varchar(20) DEFAULT NULL,
  `image` varchar(100) DEFAULT NULL,
  `last_login` datetime DEFAULT NULL,
  `last_logout` datetime DEFAULT NULL,
  `ip_address` varchar(14) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `is_admin` tinyint(4) NOT NULL DEFAULT 0,
  `store_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

INSERT INTO `user` (`id`, `firstname`, `lastname`, `about`, `email`, `password`, `password_reset_token`, `image`, `last_login`, `last_logout`, `ip_address`, `status`, `is_admin`, `store_id`) VALUES ('1', NULL, NULL, NULL, 'admin@admin.com', '0192023a7bbd73250516f069df18b500', NULL, NULL, '2026-03-07 22:59:02', '2026-03-06 21:47:00', '127.0.0.1', '1', '1', NULL);
INSERT INTO `user` (`id`, `firstname`, `lastname`, `about`, `email`, `password`, `password_reset_token`, `image`, `last_login`, `last_logout`, `ip_address`, `status`, `is_admin`, `store_id`) VALUES ('2', 'Abolayan', 'Ali', '', 'abolayan@admin.com', '202cb962ac59075b964b07152d234b70', NULL, '', '2026-03-03 21:35:32', '2026-03-03 22:10:32', '127.0.0.1', '1', '0', '2');
INSERT INTO `user` (`id`, `firstname`, `lastname`, `about`, `email`, `password`, `password_reset_token`, `image`, `last_login`, `last_logout`, `ip_address`, `status`, `is_admin`, `store_id`) VALUES ('3', 'ali', 'ali', '', 'admin@mail.com', '202cb962ac59075b964b07152d234b70', NULL, '', '2026-03-06 21:47:10', '2026-03-06 22:03:37', '127.0.0.1', '1', '0', '2');


#
# TABLE STRUCTURE FOR: warehouse
#

DROP TABLE IF EXISTS `warehouse`;

CREATE TABLE `warehouse` (
  `warehouse_id` int(11) NOT NULL AUTO_INCREMENT,
  `warehouse_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `warehouse_code` varchar(3) COLLATE utf8_unicode_ci NOT NULL,
  `warehouse_phone` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `warehouse_address` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `createby` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `createdate` datetime NOT NULL,
  `updateby` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `updatedate` datetime NOT NULL,
  `isactive` tinyint(1) NOT NULL,
  PRIMARY KEY (`warehouse_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `warehouse` (`warehouse_id`, `warehouse_name`, `warehouse_code`, `warehouse_phone`, `warehouse_address`, `createby`, `createdate`, `updateby`, `updatedate`, `isactive`) VALUES ('1', 'مستودع السلام', 'xxx', '7766555444', 'شارع النصر', '1', '2026-03-06 22:26:38', '', '0000-00-00 00:00:00', '1');