-- phpMyAdmin SQL Dump
-- version 5.0.2
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: May 23, 2021 at 10:30 AM
-- Server version: 10.4.14-MariaDB
-- PHP Version: 7.4.10

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `restaurant`
--

-- --------------------------------------------------------

--
-- Table structure for table `ledger`
--

CREATE TABLE `ledger` (
  `id` int(20) NOT NULL,
  `parent_head_id` int(5) NOT NULL,
  `sub_head_id` int(3) DEFAULT NULL,
  `ledger_title` varchar(50) CHARACTER SET utf8 NOT NULL,
  `is_bank_account` int(1) DEFAULT NULL,
  `bank_name` text CHARACTER SET utf8 DEFAULT NULL,
  `branch_address` varchar(100) DEFAULT NULL,
  `bank_account_name` varchar(30) DEFAULT NULL,
  `bank_account_no` varchar(50) DEFAULT NULL,
  `opening_balance` varchar(20) NOT NULL DEFAULT '0',
  `date` date DEFAULT NULL,
  `date_time` datetime DEFAULT NULL,
  `remarks` varchar(100) DEFAULT NULL,
  `by` varchar(20) DEFAULT NULL,
  `type` int(20) DEFAULT NULL,
  `wire` varchar(50) DEFAULT NULL,
  `permission` int(11) DEFAULT NULL,
  `c_s_id` varchar(20) DEFAULT NULL,
  `ware` int(20) NOT NULL DEFAULT 0,
  `trans_w_l` int(11) DEFAULT NULL,
  `up_wire` int(11) DEFAULT NULL,
  `fixed` int(11) DEFAULT NULL,
  `sup` varchar(5) DEFAULT NULL,
  `cus` varchar(5) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `model` int(2) DEFAULT NULL,
  `trace` int(11) DEFAULT 0 COMMENT 'trash',
  `accounts_id` text DEFAULT NULL,
  `agent_id` int(11) NOT NULL,
  `agent_commission` float NOT NULL,
  `contract_ref` int(11) NOT NULL,
  `vat_reg_no` varchar(255) NOT NULL,
  `payroll_ref` int(11) DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1 COMMENT '1=Active; 2 = Inactive',
  `vatcode` int(11) NOT NULL,
  `code` int(11) NOT NULL,
  `foreign_name` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ledger`
--

INSERT INTO `ledger` (`id`, `parent_head_id`, `sub_head_id`, `ledger_title`, `is_bank_account`, `bank_name`, `branch_address`, `bank_account_name`, `bank_account_no`, `opening_balance`, `date`, `date_time`, `remarks`, `by`, `type`, `wire`, `permission`, `c_s_id`, `ware`, `trans_w_l`, `up_wire`, `fixed`, `sup`, `cus`, `phone`, `model`, `trace`, `accounts_id`, `agent_id`, `agent_commission`, `contract_ref`, `vat_reg_no`, `payroll_ref`, `status`, `vatcode`, `code`, `foreign_name`) VALUES
(192, 13, 0, 'Cash', 0, 'null', 'null', 'null', 'null', '0', '2016-03-22', '0000-00-00 00:00:00', 'null', 'admin', 1, '', 0, '0', 0, 0, 0, 0, '', '', '0', 0, 0, '1000020501', 384, 0, 0, '', NULL, 1, 0, 0, ''),
(1160, 512, NULL, 'Computer Softwares ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-13 19:05:26', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100001011', 0, 0, 0, '', NULL, 1, 0, 0, 'Computer Softwares '),
(1161, 512, NULL, 'Computer Softwares Accumulated Amortization ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-13 19:06:10', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100001012', 0, 0, 0, '', NULL, 1, 0, 0, 'Computer Softwares Accumulated Amortization '),
(1162, 515, NULL, 'Office Furniture ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-13 19:11:41', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '1000010201011', 0, 0, 0, '', NULL, 1, 0, 0, 'Office Furniture '),
(1163, 515, NULL, 'Hotel Furniture', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-13 19:12:37', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '1000010201012', 0, 0, 0, '', NULL, 1, 0, 0, 'Hotel Furniture'),
(1164, 515, NULL, 'Furniture & Fittings', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-13 19:13:04', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '1000010201013', 0, 0, 0, '', NULL, 1, 0, 0, 'Furniture & Fittings'),
(1165, 515, NULL, 'Office Furniture Accumulated Dep', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-13 19:13:33', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '1000010201014', 0, 0, 0, '', NULL, 1, 0, 0, 'Office Furniture Accumulated Dep'),
(1166, 515, NULL, 'Hotel Furniture Accumulated Dep', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-13 19:14:16', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '1000010201015', 0, 0, 0, '', NULL, 1, 0, 0, 'Hotel Furniture Accumulated Dep'),
(1167, 515, NULL, 'Furniture & Fittings Accumulated Dep', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-13 19:14:45', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '1000010201016', 0, 0, 0, '', NULL, 1, 0, 0, 'Furniture & Fittings Accumulated Dep'),
(1168, 517, NULL, 'Computer & Accessories', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-13 19:17:46', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '1000010202011', 0, 0, 0, '', NULL, 1, 0, 0, 'Computer & Accessories'),
(1169, 517, NULL, 'Printer & Scanner', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-13 19:18:25', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '1000010202012', 0, 0, 0, '', NULL, 1, 0, 0, 'Printer & Scanner'),
(1170, 517, NULL, 'Computer & Accessories Accumulated Dep', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-13 19:19:34', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '1000010202013', 0, 0, 0, '', NULL, 1, 0, 0, 'Computer & Accessories Accumulated Dep'),
(1171, 517, NULL, 'Printer & Scanner Accumulated Dep', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-13 19:20:14', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '1000010202014', 0, 0, 0, '', NULL, 1, 0, 0, 'Printer & Scanner Accumulated Dep'),
(1172, 518, NULL, 'Air Conditoner', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-13 19:28:50', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '10000102031', 0, 0, 0, '', NULL, 1, 0, 0, 'Air Conditoner'),
(1173, 518, NULL, 'Air Conditioner Accumulated Dep ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-13 19:30:29', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '10000102032', 0, 0, 0, '', NULL, 1, 0, 0, 'Air Conditioner Accumulated Dep '),
(1174, 519, NULL, 'Electrical Equipements & Installation ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-13 19:34:08', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '10000102041', 0, 0, 0, '', NULL, 1, 0, 0, 'Electrical Equipements & Installation '),
(1175, 519, NULL, 'Electrical Equipements & Installation Accumulated ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-13 19:34:48', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '10000102042', 0, 0, 0, '', NULL, 1, 0, 0, 'Electrical Equipements & Installation Accumulated Dep '),
(1176, 520, NULL, 'Motor Vehicles', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-13 19:36:09', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '10000102051', 0, 0, 0, '', NULL, 1, 0, 0, 'Motor Vehicles'),
(1177, 520, NULL, 'Motor Vehicles Accumulated Dep ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-13 19:36:53', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '10000102052', 0, 0, 0, '', NULL, 1, 0, 0, 'Motor Vehicles Accumulated Dep '),
(1178, 521, NULL, 'Plant & Machinery', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-13 19:38:22', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '10000102061', 0, 0, 0, '', NULL, 1, 0, 0, 'Plant & Machinery'),
(1179, 521, NULL, 'Plant & Machinery Accumulated Dep', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-13 19:38:44', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '10000102062', 0, 0, 0, '', NULL, 1, 0, 0, 'Plant & Machinery Accumulated Dep'),
(1180, 522, NULL, 'Accessories & Tools ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-13 19:39:39', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '10000102071', 0, 0, 0, '', NULL, 1, 0, 0, 'Accessories & Tools '),
(1181, 522, NULL, 'Accessories & Tools Accumulated Dep ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-13 19:40:00', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '10000102072', 0, 0, 0, '', NULL, 1, 0, 0, 'Accessories & Tools Accumulated Dep '),
(1182, 524, NULL, 'Projects in Progress', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-13 19:42:42', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '10000103011', 0, 0, 0, '', NULL, 1, 0, 0, 'Projects in Progress'),
(1183, 524, NULL, 'Water Bottled Factory (For Water & Juices) ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-13 19:43:49', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '10000103012', 0, 0, 0, '', NULL, 1, 0, 0, 'Water Bottled Factory (For Water & Juices) '),
(1184, 526, NULL, 'Furniture, Fixture, Equipment & Décor ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-13 19:46:25', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '10000104011', 0, 0, 0, '', NULL, 1, 0, 0, 'Furniture, Fixture, Equipment & Décor '),
(1185, 527, NULL, 'Other Investments ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-13 19:47:56', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100001051', 0, 0, 0, '', NULL, 1, 0, 0, 'Other Investments '),
(1186, 530, NULL, 'Electrical Goods', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-13 19:51:59', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '10000201011', 0, 0, 0, '', NULL, 1, 0, 0, 'Electrical Goods'),
(1187, 530, NULL, 'Plumbing Goods', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-13 19:52:35', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '10000201012', 0, 0, 0, '', NULL, 1, 0, 0, 'Plumbing Goods'),
(1188, 530, NULL, 'Fire & Safety', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-13 19:53:02', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '10000201013', 0, 0, 0, '', NULL, 1, 0, 0, 'Fire & Safety'),
(1189, 530, NULL, 'Hardware Goods', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-13 19:53:23', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '10000201014', 0, 0, 0, '', NULL, 1, 0, 0, 'Hardware Goods'),
(1190, 530, NULL, 'Guest Amenities', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-13 19:54:20', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '10000201015', 0, 0, 0, '', NULL, 1, 0, 0, 'Guest Amenities'),
(1191, 530, NULL, 'Cleaning Goods', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-13 19:54:42', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '10000201016', 0, 0, 0, '', NULL, 1, 0, 0, 'Cleaning Goods'),
(1192, 530, NULL, 'Printing & Stationary', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-13 19:55:14', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '10000201017', 0, 0, 0, '', NULL, 1, 0, 0, 'Printing & Stationary'),
(1193, 530, NULL, 'Pest Control Goods', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-13 19:56:51', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '10000201018', 0, 0, 0, '', NULL, 1, 0, 0, 'Pest Control Goods'),
(1194, 530, NULL, 'General Goods', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-13 19:57:15', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '10000201019', 0, 0, 0, '', NULL, 1, 0, 0, 'General Goods'),
(1195, 531, NULL, 'Intermediary W. H Transfer', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-13 20:00:12', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '10000201021', 0, 0, 0, '', NULL, 1, 0, 0, 'Intermediary W. H Transfer'),
(1196, 531, NULL, 'Goods In Transit (Foreign)', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-13 20:00:37', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '10000201022', 0, 0, 0, '', NULL, 1, 0, 0, 'Goods In Transit (Foreign)'),
(1197, 533, NULL, 'Provision for Inventory', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 10:50:46', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '1000020103011', 0, 0, 0, '', NULL, 1, 0, 0, 'Provision for Inventory'),
(1198, 536, NULL, 'Accounts Receivable', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 10:54:40', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '1000020201011', 0, 0, 0, '', NULL, 1, 0, 0, 'Accounts Receivable'),
(1199, 536, NULL, 'Allowance for Doubtful Debts', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 10:55:08', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '1000020201012', 0, 0, 0, '', NULL, 1, 0, 0, 'Allowance for Doubtful Debts'),
(1200, 539, NULL, 'Rent Receivables', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 10:58:00', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '1000020301011', 0, 0, 0, '', NULL, 1, 0, 0, 'Rent Receivables'),
(1201, 539, NULL, 'Shop Rent Receivables', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 10:58:37', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '1000020301012', 0, 0, 0, '', NULL, 1, 0, 0, 'Shop Rent Receivables'),
(1202, 539, NULL, 'Receivable from Sundry Parties', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 10:59:18', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '1000020301013', 0, 0, 0, '', NULL, 1, 0, 0, 'Receivable from Sundry Parties'),
(1203, 539, NULL, 'Due from Najat Ajaj Al- Hujaili Factory (For W & J', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 10:59:52', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '1000020301014', 0, 0, 0, '', NULL, 1, 0, 0, 'Due from Najat Ajaj Al- Hujaili Factory (For W & J)'),
(1204, 539, NULL, 'Loan Receivable', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 11:00:51', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '1000020301015', 0, 0, 0, '', NULL, 1, 0, 0, 'Loan Receivable'),
(1205, 540, NULL, 'Najat Al Hujaili (Water Factory)', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 11:06:38', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '1000020301021', 0, 0, 0, '', NULL, 1, 0, 0, 'Najat Al Hujaili (Water Factory)'),
(1206, 540, NULL, 'Nuzal Al safa (Due From Asso)', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 11:07:49', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '1000020301022', 0, 0, 0, '', NULL, 1, 0, 0, 'Nuzal Al safa (Due From Asso)'),
(1207, 540, NULL, 'Reyan Al Kausar (Due from Asso)', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 11:08:42', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '1000020301023', 0, 0, 0, '', NULL, 1, 0, 0, 'Reyan Al Kausar (Due from Asso)'),
(1208, 543, NULL, 'Advance Payment to Suppliers', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 11:14:29', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '1000020401011', 0, 0, 0, '', NULL, 1, 0, 0, 'Advance Payment to Suppliers'),
(1209, 543, NULL, 'Advance Against Salary', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 11:19:03', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '1000020401012', 0, 0, 0, '', NULL, 1, 0, 0, 'Advance Against Salary'),
(1210, 543, NULL, 'Advance to Others', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 11:20:10', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '1000020401013', 0, 0, 0, '', NULL, 1, 0, 0, 'Advance to Others'),
(1211, 543, NULL, 'Advance for Capital Expenditure', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 11:20:33', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '1000020401014', 0, 0, 0, '', NULL, 1, 0, 0, 'Advance for Capital Expenditure'),
(1212, 543, NULL, 'Advance for Revenue Expenditure', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 11:20:58', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '1000020401015', 0, 0, 0, '', NULL, 1, 0, 0, 'Advance for Revenue Expenditure'),
(1213, 543, NULL, 'Advance for Stores & Spares', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 11:21:30', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '1000020401016', 0, 0, 0, '', NULL, 1, 0, 0, 'Advance for Stores & Spares'),
(1214, 543, NULL, 'Staff Loan against Salary', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 11:21:59', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '1000020401017', 0, 0, 0, '', NULL, 1, 0, 0, 'Staff Loan against Salary'),
(1215, 543, NULL, 'Staff Advances', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 11:22:28', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '1000020401018', 0, 0, 0, '', NULL, 1, 0, 0, 'Staff Advances'),
(1216, 548, NULL, 'Security Deposits', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 11:24:37', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '1000020402011', 0, 0, 0, '', NULL, 1, 0, 0, 'Security Deposits'),
(1217, 549, NULL, 'Local Guest ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 11:26:19', '', '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '4000010101011', 0, 0, 0, '', NULL, 1, 0, 0, 'Local Guest '),
(1218, 549, NULL, 'Umrah Guest ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 11:26:57', '', '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '4000010101012', 0, 0, 0, '', NULL, 1, 0, 0, 'Umrah Guest '),
(1219, 549, NULL, 'Hajj Guest ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 11:27:30', '', '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '4000010101013', 0, 0, 0, '', NULL, 1, 0, 0, 'Hajj Guest '),
(1220, 551, NULL, 'Prepaid building Rent', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 11:27:50', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '1000020403011', 0, 0, 0, '', NULL, 1, 0, 0, 'Prepaid building Rent'),
(1221, 549, NULL, 'Allotment  ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 11:28:22', '', '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '4000010101014', 0, 0, 0, '', NULL, 1, 0, 0, 'Allotment  '),
(1222, 551, NULL, 'Prepaid Insurance', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 11:28:58', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '1000020403012', 0, 0, 0, '', NULL, 1, 0, 0, 'Prepaid Insurance'),
(1223, 551, NULL, 'Debit Vat', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 11:29:32', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '1000020403013', 0, 0, 0, '', NULL, 1, 0, 0, 'Debit Vat'),
(1224, 551, NULL, 'Other Prepaid Expenses', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 11:29:58', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '1000020403014', 0, 0, 0, '', NULL, 1, 0, 0, 'Other Prepaid Expenses'),
(1225, 555, NULL, 'Cash In Hand', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 11:33:33', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '1000020501011', 0, 0, 0, '', NULL, 1, 0, 0, 'Cash In Hand'),
(1226, 556, NULL, 'Shop Revenue ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 11:34:27', '', '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '4000010102011', 0, 0, 0, '', NULL, 1, 0, 0, 'Shop Revenue '),
(1227, 558, NULL, 'Cash At Bank', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 11:35:25', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '1000020502011', 0, 0, 0, '', NULL, 1, 0, 0, 'Cash At Bank'),
(1228, 556, NULL, 'Utility Receipts ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 11:35:42', '', '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '4000010102012', 0, 0, 0, '', NULL, 1, 0, 0, 'Utility Receipts '),
(1229, 556, NULL, 'Wastage sale ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 11:36:47', '', '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '4000010102013', 0, 0, 0, '', NULL, 1, 0, 0, 'Wastage sale '),
(1230, 562, NULL, 'Short Term Investment', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 11:53:55', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '1000020601011', 0, 0, 0, '', NULL, 1, 0, 0, 'Short Term Investment'),
(1231, 565, NULL, 'Profit on Sale of Fixed Assets ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 11:54:03', '', '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '4000020101011', 0, 0, 0, '', NULL, 1, 0, 0, 'Profit on Sale of Fixed Assets '),
(1232, 565, NULL, 'Profit on Sale of Scrap ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 11:55:18', '', '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '4000020101012', 0, 0, 0, '', NULL, 1, 0, 0, 'Profit on Sale of Scrap '),
(1233, 565, NULL, 'Discount Received ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 11:56:13', '', '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '4000020101013', 0, 0, 0, '', NULL, 1, 0, 0, 'Discount Received '),
(1234, 568, NULL, 'Notes Receivable', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 11:56:25', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '1000020701011', 0, 0, 0, '', NULL, 1, 0, 0, 'Notes Receivable'),
(1235, 565, NULL, 'Commission Received ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 11:56:49', '', '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '4000020101014', 0, 0, 0, '', NULL, 1, 0, 0, 'Commission Received '),
(1236, 573, NULL, 'Long Term Loan from Bank.', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:03:50', '', '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '2000010101011', 0, 0, 0, '', NULL, 1, 0, 0, 'Long Term Loan from Bank.'),
(1237, 578, NULL, 'Trade Payables', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:07:28', '', '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '2000020101011', 0, 0, 0, '', NULL, 1, 0, 0, 'Trade Payables'),
(1238, 581, NULL, 'Electrical Goods ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:09:38', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '3000010101011', 0, 0, 0, '', NULL, 1, 0, 0, 'Electrical Goods '),
(1239, 582, NULL, 'Accounts Payable', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:10:27', '', '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '2000020101021', 0, 0, 0, '', NULL, 1, 0, 0, 'Accounts Payable'),
(1240, 581, NULL, 'Plumbing Goods ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:11:52', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '3000010101012', 0, 0, 0, '', NULL, 1, 0, 0, 'Plumbing Goods '),
(1241, 581, NULL, 'Fire & Safety ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:12:27', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '3000010101013', 0, 0, 0, '', NULL, 1, 0, 0, 'Fire & Safety '),
(1242, 581, NULL, 'Hardware Goods ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:13:11', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '3000010101014', 0, 0, 0, '', NULL, 1, 0, 0, 'Hardware Goods '),
(1243, 585, NULL, 'Payable to Others', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:13:13', '', '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '2000020201011', 0, 0, 0, '', NULL, 1, 0, 0, 'Payable to Others'),
(1244, 581, NULL, 'Guest Amenities ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:13:42', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '3000010101015', 0, 0, 0, '', NULL, 1, 0, 0, 'Guest Amenities '),
(1245, 581, NULL, 'Cleaning Goods ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:14:34', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '3000010101016', 0, 0, 0, '', NULL, 1, 0, 0, 'Cleaning Goods '),
(1246, 581, NULL, 'Printing & Stationary ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:15:05', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '3000010101017', 0, 0, 0, '', NULL, 1, 0, 0, 'Printing & Stationary '),
(1247, 588, NULL, 'Short Term Loan from Bank.', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:15:38', '', '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '2000020301011', 0, 0, 0, '', NULL, 1, 0, 0, 'Short Term Loan from Bank.'),
(1248, 581, NULL, 'Pest Control Goods ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:15:41', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '3000010101018', 0, 0, 0, '', NULL, 1, 0, 0, 'Pest Control Goods '),
(1249, 581, NULL, 'General Goods ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:16:11', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '3000010101019', 0, 0, 0, '', NULL, 1, 0, 0, 'General Goods '),
(1250, 590, NULL, ' Discount Allowed ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:19:09', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '3000010102011', 0, 0, 0, '', NULL, 1, 0, 0, ' Discount Allowed '),
(1251, 579, NULL, ' Stock Adjustment ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:20:57', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '300001011', 0, 0, 0, '', NULL, 1, 0, 0, ' Stock Adjustment '),
(1252, 594, NULL, 'Sharika Malim', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:23:50', '', '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '2000020301021', 0, 0, 0, '', NULL, 1, 0, 0, 'Sharika Malim'),
(1253, 596, NULL, ' Salary  ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:24:40', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '3000020101011', 0, 0, 0, '', NULL, 1, 0, 0, ' Salary  '),
(1254, 596, NULL, ' Wages  ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:25:08', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '3000020101012', 0, 0, 0, '', NULL, 1, 0, 0, ' Wages  '),
(1255, 596, NULL, ' Housing Allowance ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:25:36', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '3000020101013', 0, 0, 0, '', NULL, 1, 0, 0, ' Housing Allowance '),
(1256, 599, NULL, 'Unearned revenue For Umrah', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:26:06', '', '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '2000020401011', 0, 0, 0, '', NULL, 1, 0, 0, 'Unearned revenue For Umrah'),
(1257, 596, NULL, ' Transportation allowance ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:26:23', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '3000020101014', 0, 0, 0, '', NULL, 1, 0, 0, ' Transportation allowance '),
(1258, 599, NULL, 'Unearned revenue For Hajj', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:26:41', '', '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '2000020401012', 0, 0, 0, '', NULL, 1, 0, 0, 'Unearned revenue For Hajj'),
(1259, 596, NULL, ' Ticket Allowance ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:26:49', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '3000020101015', 0, 0, 0, '', NULL, 1, 0, 0, ' Ticket Allowance '),
(1260, 599, NULL, 'Unearned revenue For Allotment', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:27:06', '', '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '2000020401013', 0, 0, 0, '', NULL, 1, 0, 0, 'Unearned revenue For Allotment'),
(1261, 596, NULL, ' Iqama Renewal Charges ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:27:21', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '3000020101016', 0, 0, 0, '', NULL, 1, 0, 0, ' Iqama Renewal Charges '),
(1262, 599, NULL, 'Other Unearned Revenues', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:27:32', '', '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '2000020401014', 0, 0, 0, '', NULL, 1, 0, 0, 'Other Unearned Revenues'),
(1263, 596, NULL, ' Profession Change Charges ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:27:43', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '3000020101017', 0, 0, 0, '', NULL, 1, 0, 0, ' Profession Change Charges '),
(1264, 600, NULL, 'End of Service Benefit Provision ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:29:40', '', '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '2000020401021', 0, 0, 0, '', NULL, 1, 0, 0, 'End of Service Benefit Provision '),
(1265, 596, NULL, ' Sponsership Transfer Charges ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:29:44', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '3000020101018', 0, 0, 0, '', NULL, 1, 0, 0, ' Sponsership Transfer Charges '),
(1266, 596, NULL, ' Extend of Visitor Visa Charges ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:30:43', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '3000020101019', 0, 0, 0, '', NULL, 1, 0, 0, ' Extend of Visitor Visa Charges '),
(1267, 596, NULL, ' Exit Re-entry Visa Charges ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:31:04', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '30000201010110', 0, 0, 0, '', NULL, 1, 0, 0, ' Exit Re-entry Visa Charges '),
(1268, 596, NULL, ' Insurance Expenses (GOSI) ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:31:25', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '30000201010111', 0, 0, 0, '', NULL, 1, 0, 0, ' Insurance Expenses (GOSI) '),
(1269, 596, NULL, ' Insurance Expenses (BUPA) ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:31:54', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '30000201010112', 0, 0, 0, '', NULL, 1, 0, 0, ' Insurance Expenses (BUPA) '),
(1270, 596, NULL, ' Food Allowance ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:32:21', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '30000201010113', 0, 0, 0, '', NULL, 1, 0, 0, ' Food Allowance '),
(1271, 601, NULL, 'Credit VAT', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:32:27', '', '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '2000020401031', 0, 0, 0, '', NULL, 1, 0, 0, 'Credit VAT'),
(1272, 596, NULL, ' Uniform Expenses ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:32:52', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '30000201010114', 0, 0, 0, '', NULL, 1, 0, 0, ' Uniform Expenses '),
(1273, 601, NULL, 'Service Taxes Payable', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:32:59', '', '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '2000020401032', 0, 0, 0, '', NULL, 1, 0, 0, 'Service Taxes Payable'),
(1274, 596, NULL, ' Medical Insurance ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:33:18', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '30000201010115', 0, 0, 0, '', NULL, 1, 0, 0, ' Medical Insurance '),
(1275, 601, NULL, 'VAT Amount Adjustment', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:33:26', '', '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '2000020401033', 0, 0, 0, '', NULL, 1, 0, 0, 'VAT Amount Adjustment'),
(1276, 596, NULL, ' Life Insurance  ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:33:39', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '30000201010116', 0, 0, 0, '', NULL, 1, 0, 0, ' Life Insurance  '),
(1277, 596, NULL, ' Worker\'s Compensation ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:34:06', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '30000201010117', 0, 0, 0, '', NULL, 1, 0, 0, ' Worker\'s Compensation '),
(1278, 596, NULL, ' Unclaimed Salary, Wages & Bonus ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:34:30', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '30000201010118', 0, 0, 0, '', NULL, 1, 0, 0, ' Unclaimed Salary, Wages & Bonus '),
(1279, 596, NULL, ' Staff Welfare Expenses ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:34:59', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '30000201010119', 0, 0, 0, '', NULL, 1, 0, 0, ' Staff Welfare Expenses '),
(1280, 602, NULL, 'Dividends Payable', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:35:02', '', '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '2000020401041', 0, 0, 0, '', NULL, 1, 0, 0, 'Dividends Payable'),
(1281, 603, NULL, ' Office furniture Dep Exp ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:36:42', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '3000020101021', 0, 0, 0, '', NULL, 1, 0, 0, ' Office furniture Dep Exp '),
(1282, 603, NULL, ' Hotel Furniture Dep Exp ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:37:05', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '3000020101022', 0, 0, 0, '', NULL, 1, 0, 0, ' Hotel Furniture Dep Exp '),
(1283, 603, NULL, ' Furniture & Fixture Dep Exp ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:37:23', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '3000020101023', 0, 0, 0, '', NULL, 1, 0, 0, ' Furniture & Fixture Dep Exp '),
(1284, 603, NULL, ' Computer & Accessories Dep Exp ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:37:45', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '3000020101024', 0, 0, 0, '', NULL, 1, 0, 0, ' Computer & Accessories Dep Exp '),
(1285, 603, NULL, ' Printer & Scanner Dep Exp ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:38:07', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '3000020101025', 0, 0, 0, '', NULL, 1, 0, 0, ' Printer & Scanner Dep Exp '),
(1286, 603, NULL, ' Air Conditioner Dep Exp ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:38:40', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '3000020101026', 0, 0, 0, '', NULL, 1, 0, 0, ' Air Conditioner Dep Exp '),
(1287, 603, NULL, ' Electrical Eqipments & Installation Dep Exp ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:39:00', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '3000020101027', 0, 0, 0, '', NULL, 1, 0, 0, ' Electrical Eqipments & Installation Dep Exp '),
(1288, 603, NULL, ' Motor Vehicles Dep Exp ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:39:21', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '3000020101028', 0, 0, 0, '', NULL, 1, 0, 0, ' Motor Vehicles Dep Exp '),
(1289, 603, NULL, ' Plant & Machinery Dep Exp ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:39:47', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '3000020101029', 0, 0, 0, '', NULL, 1, 0, 0, ' Plant & Machinery Dep Exp '),
(1290, 605, NULL, ' Computer Software Amortization Exp ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:41:06', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '3000020101031', 0, 0, 0, '', NULL, 1, 0, 0, ' Computer Software Amortization Exp '),
(1291, 606, NULL, ' Compliance Expenses ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:41:57', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '3000020101041', 0, 0, 0, '', NULL, 1, 0, 0, ' Compliance Expenses '),
(1292, 606, NULL, ' Certification Charges ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:42:18', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '3000020101042', 0, 0, 0, '', NULL, 1, 0, 0, ' Certification Charges '),
(1293, 606, NULL, ' Consultancy fee ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:42:45', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '3000020101043', 0, 0, 0, '', NULL, 1, 0, 0, ' Consultancy fee '),
(1294, 608, NULL, ' Electricity Bill  ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:44:06', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '3000020101051', 0, 0, 0, '', NULL, 1, 0, 0, ' Electricity Bill  '),
(1295, 608, NULL, ' Water Bill  ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:44:29', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '3000020101052', 0, 0, 0, '', NULL, 1, 0, 0, ' Water Bill  '),
(1296, 608, NULL, ' Consultancy fee ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:44:56', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '3000020101053', 0, 0, 0, '', NULL, 1, 0, 0, ' Consultancy fee '),
(1297, 608, NULL, ' Postal Charges ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:48:13', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '3000020101054', 0, 0, 0, '', NULL, 1, 0, 0, ' Postal Charges '),
(1298, 608, NULL, ' Internet Charges ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:48:34', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '3000020101055', 0, 0, 0, '', NULL, 1, 0, 0, ' Internet Charges '),
(1299, 607, NULL, 'Liabilities For Expenses', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:50:06', '', '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '20000205011', 0, 0, 0, '', NULL, 1, 0, 0, 'Liabilities For Expenses'),
(1300, 608, NULL, ' Telecom Expenses ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:51:05', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '3000020101056', 0, 0, 0, '', NULL, 1, 0, 0, ' Telecom Expenses '),
(1301, 607, NULL, 'Electricity Bill Payable', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:51:18', '', '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '20000205012', 0, 0, 0, '', NULL, 1, 0, 0, 'Electricity Bill Payable'),
(1302, 608, NULL, ' Printing & Stationary ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:51:28', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '3000020101057', 0, 0, 0, '', NULL, 1, 0, 0, ' Printing & Stationary '),
(1303, 607, NULL, 'Water Bill Payable', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:51:53', '', '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '20000205013', 0, 0, 0, '', NULL, 1, 0, 0, 'Water Bill Payable'),
(1304, 608, NULL, ' Advertisement Expenses ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:52:05', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '3000020101058', 0, 0, 0, '', NULL, 1, 0, 0, ' Advertisement Expenses '),
(1305, 607, NULL, 'Medical Insurance', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:52:28', '', '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '20000205014', 0, 0, 0, '', NULL, 1, 0, 0, 'Medical Insurance'),
(1306, 608, NULL, ' License & Other Fee ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:52:34', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '3000020101059', 0, 0, 0, '', NULL, 1, 0, 0, ' License & Other Fee '),
(1307, 608, NULL, ' Membership & Subscription ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:52:56', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '30000201010510', 0, 0, 0, '', NULL, 1, 0, 0, ' Membership & Subscription '),
(1308, 607, NULL, 'Life Insurance ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:53:16', '', '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '20000205015', 0, 0, 0, '', NULL, 1, 0, 0, 'Life Insurance '),
(1309, 608, NULL, ' Loss on Sale of Assets ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:53:17', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '30000201010511', 0, 0, 0, '', NULL, 1, 0, 0, ' Loss on Sale of Assets '),
(1310, 608, NULL, ' Office Expenses ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:53:36', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '30000201010512', 0, 0, 0, '', NULL, 1, 0, 0, ' Office Expenses '),
(1311, 608, NULL, ' Reservation expenses ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:53:54', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '30000201010513', 0, 0, 0, '', NULL, 1, 0, 0, ' Reservation expenses '),
(1312, 607, NULL, 'Worker\'s Compensation', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:54:00', '', '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '20000205016', 0, 0, 0, '', NULL, 1, 0, 0, 'Worker\'s Compensation'),
(1313, 608, NULL, ' Fuel & oil Expenses-Vehicle ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:54:25', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '30000201010514', 0, 0, 0, '', NULL, 1, 0, 0, ' Fuel & oil Expenses-Vehicle '),
(1314, 607, NULL, 'Accrued Expense', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:54:41', '', '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '20000205017', 0, 0, 0, '', NULL, 1, 0, 0, 'Accrued Expense'),
(1315, 608, NULL, ' Fuel & oil Expenses-Laundry ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:54:48', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '30000201010515', 0, 0, 0, '', NULL, 1, 0, 0, ' Fuel & oil Expenses-Laundry '),
(1316, 608, NULL, ' Laundry Supplies ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:55:08', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '30000201010516', 0, 0, 0, '', NULL, 1, 0, 0, ' Laundry Supplies '),
(1317, 608, NULL, ' Contract Cleaning Expenses ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:55:29', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '30000201010517', 0, 0, 0, '', NULL, 1, 0, 0, ' Contract Cleaning Expenses '),
(1318, 608, NULL, ' Removal of Waste Material ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:55:50', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '30000201010518', 0, 0, 0, '', NULL, 1, 0, 0, ' Removal of Waste Material '),
(1319, 608, NULL, ' Entertainment Expenses ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:56:12', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '30000201010519', 0, 0, 0, '', NULL, 1, 0, 0, ' Entertainment Expenses '),
(1320, 608, NULL, ' Conveyance Expenses ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:56:32', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '30000201010520', 0, 0, 0, '', NULL, 1, 0, 0, ' Conveyance Expenses '),
(1321, 607, NULL, 'Consultancy fee', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:57:08', '', '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '20000205018', 0, 0, 0, '', NULL, 1, 0, 0, 'Consultancy fee'),
(1322, 608, NULL, ' Irrecoverable Bad Debt Expenses ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:57:42', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '30000201010521', 0, 0, 0, '', NULL, 1, 0, 0, ' Irrecoverable Bad Debt Expenses '),
(1323, 608, NULL, ' Government Fees ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:58:07', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '30000201010522', 0, 0, 0, '', NULL, 1, 0, 0, ' Government Fees '),
(1324, 608, NULL, ' Travelling Expenses ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:58:29', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '30000201010523', 0, 0, 0, '', NULL, 1, 0, 0, ' Travelling Expenses '),
(1325, 607, NULL, 'Unclaimed Salary, Wages & Bonus', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:59:07', '', '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '20000205019', 0, 0, 0, '', NULL, 1, 0, 0, 'Unclaimed Salary, Wages & Bonus'),
(1326, 609, NULL, ' Building Lease Rent ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 12:59:33', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '3000020101061', 0, 0, 0, '', NULL, 1, 0, 0, ' Building Lease Rent '),
(1327, 610, NULL, ' Machinery Maintenance ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 13:00:34', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '3000020101071', 0, 0, 0, '', NULL, 1, 0, 0, ' Machinery Maintenance '),
(1328, 610, NULL, ' Repair & Other Maintenance ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 13:00:54', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '3000020101072', 0, 0, 0, '', NULL, 1, 0, 0, ' Repair & Other Maintenance '),
(1329, 610, NULL, ' Electrical Maintenance ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 13:01:13', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '3000020101073', 0, 0, 0, '', NULL, 1, 0, 0, ' Electrical Maintenance '),
(1330, 607, NULL, 'Postal Charges', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 13:01:25', '', '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002050110', 0, 0, 0, '', NULL, 1, 0, 0, 'Postal Charges'),
(1331, 610, NULL, ' Vehicle Maintenance ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 13:01:55', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '3000020101074', 0, 0, 0, '', NULL, 1, 0, 0, ' Vehicle Maintenance '),
(1332, 607, NULL, 'House Rent Payable -Staff', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 13:03:45', '', '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002050111', 0, 0, 0, '', NULL, 1, 0, 0, 'House Rent Payable -Staff'),
(1333, 610, NULL, ' Elevators Maintenance ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 13:04:01', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '3000020101075', 0, 0, 0, '', NULL, 1, 0, 0, ' Elevators Maintenance '),
(1334, 610, NULL, ' Pest Control Maintenance ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 13:04:32', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '3000020101076', 0, 0, 0, '', NULL, 1, 0, 0, ' Pest Control Maintenance '),
(1335, 610, NULL, ' Fire & Safety Maintenance ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 13:05:01', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '3000020101077', 0, 0, 0, '', NULL, 1, 0, 0, ' Fire & Safety Maintenance '),
(1336, 611, NULL, ' W.HTransfer  Difference ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 13:05:56', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '3000020101081', 0, 0, 0, '', NULL, 1, 0, 0, ' W.HTransfer  Difference '),
(1337, 607, NULL, 'Other Payables', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 13:06:08', '', '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002050112', 0, 0, 0, '', NULL, 1, 0, 0, 'Other Payables'),
(1338, 611, NULL, ' Sales Additional Charge ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 13:06:15', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '3000020101082', 0, 0, 0, '', NULL, 1, 0, 0, ' Sales Additional Charge '),
(1339, 611, NULL, ' Cost Difference ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 13:06:39', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '3000020101083', 0, 0, 0, '', NULL, 1, 0, 0, ' Cost Difference '),
(1340, 607, NULL, 'Bonus Payable', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 13:07:10', '', '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002050113', 0, 0, 0, '', NULL, 1, 0, 0, 'Bonus Payable'),
(1341, 611, NULL, ' POS Surplus ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 13:07:17', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '3000020101084', 0, 0, 0, '', NULL, 1, 0, 0, ' POS Surplus '),
(1342, 611, NULL, ' POS Shortage ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 13:07:38', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '3000020101085', 0, 0, 0, '', NULL, 1, 0, 0, ' POS Shortage '),
(1343, 607, NULL, 'Salary Payable', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 13:08:00', '', '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002050114', 0, 0, 0, '', NULL, 1, 0, 0, 'Salary Payable'),
(1344, 607, NULL, 'Wages Payable', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 13:09:42', '', '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002050115', 0, 0, 0, '', NULL, 1, 0, 0, 'Wages Payable'),
(1345, 611, NULL, ' Missing Or Damage Items ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 13:10:12', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '3000020101086', 0, 0, 0, '', NULL, 1, 0, 0, ' Missing Or Damage Items '),
(1346, 611, NULL, ' Composite items  Difference ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 13:10:54', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '3000020101087', 0, 0, 0, '', NULL, 1, 0, 0, ' Composite items  Difference '),
(1347, 611, NULL, ' Fractions Difference ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 13:11:38', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '3000020101088', 0, 0, 0, '', NULL, 1, 0, 0, ' Fractions Difference '),
(1348, 611, NULL, ' Outgoing Diff ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 13:12:03', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '3000020101089', 0, 0, 0, '', NULL, 1, 0, 0, ' Outgoing Diff '),
(1349, 612, NULL, ' Government Fine ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 13:23:31', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '3000020101091', 0, 0, 0, '', NULL, 1, 0, 0, ' Government Fine '),
(1350, 615, NULL, ' Commission Paid ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 13:59:57', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '3000020201011', 0, 0, 0, '', NULL, 1, 0, 0, ' Commission Paid '),
(1351, 615, NULL, 'Advertisement expenses ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 14:01:52', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '3000020201012', 0, 0, 0, '', NULL, 1, 0, 0, 'Advertisement expenses ');
INSERT INTO `ledger` (`id`, `parent_head_id`, `sub_head_id`, `ledger_title`, `is_bank_account`, `bank_name`, `branch_address`, `bank_account_name`, `bank_account_no`, `opening_balance`, `date`, `date_time`, `remarks`, `by`, `type`, `wire`, `permission`, `c_s_id`, `ware`, `trans_w_l`, `up_wire`, `fixed`, `sup`, `cus`, `phone`, `model`, `trace`, `accounts_id`, `agent_id`, `agent_commission`, `contract_ref`, `vat_reg_no`, `payroll_ref`, `status`, `vatcode`, `code`, `foreign_name`) VALUES
(1352, 615, NULL, ' Selling Aids ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 14:03:15', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '3000020201013', 0, 0, 0, '', NULL, 1, 0, 0, ' Selling Aids '),
(1353, 615, NULL, ' Point of Sale materials ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 14:03:42', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '3000020201014', 0, 0, 0, '', NULL, 1, 0, 0, ' Point of Sale materials '),
(1354, 616, NULL, ' Zakat Tax ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 14:05:08', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '3000020201021', 0, 0, 0, '', NULL, 1, 0, 0, ' Zakat Tax '),
(1355, 618, NULL, ' Interest And Financial Charges ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 14:07:00', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '30000203011', 0, 0, 0, '', NULL, 1, 0, 0, ' Interest And Financial Charges '),
(1356, 618, NULL, ' Bank Interest  ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 14:07:19', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '30000203012', 0, 0, 0, '', NULL, 1, 0, 0, ' Bank Interest  '),
(1357, 618, NULL, ' Bank Charges ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 14:07:38', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '30000203013', 0, 0, 0, '', NULL, 1, 0, 0, ' Bank Charges '),
(1358, 618, NULL, ' Interest on loan ', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-14 14:08:10', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '30000203014', 0, 0, 0, '', NULL, 1, 0, 0, ' Interest on loan '),
(1359, 578, NULL, 'A2Z', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-15', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'A2Z'),
(1360, 652, NULL, 'Local Agent', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-15 13:08:04', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '1000020201021', 1, 0, 0, '', NULL, 1, 0, 0, 'Local Agent'),
(1361, 653, NULL, 'Sales Refund', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-15 14:52:52', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 3, 0, '3000020101101', 0, 0, 0, '', NULL, 1, 0, 0, 'Sales Refund'),
(1363, 549, NULL, 'Reservation Unearned Revenue', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-15 14:25:35', '', '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 3, 0, '4000010101015', 0, 0, 0, '', NULL, 1, 0, 0, 'Reservation Unearned Revenue'),
(1364, 654, NULL, 'Room Cancelation Charge', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-15 16:36:09', '', '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '400002021', 0, 0, 0, '', NULL, 1, 0, 0, ''),
(1365, 607, NULL, 'Advance Payable', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-15 18:03:10', '', '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002050116', 0, 0, 0, '', NULL, 1, 0, 0, ''),
(1366, 558, NULL, 'City Bank1000020502012', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-15', '2021-03-15 18:41:48', NULL, '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '1000020502012', 0, 0, 0, '', NULL, 1, 0, 0, ''),
(1367, 616, NULL, 'Purchase Tax', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-16 18:44:21', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '3000020201022', 0, 0, 0, '', NULL, 1, 0, 0, 'Purchase Tax'),
(1368, 653, NULL, 'Purchase Expenses', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-16 18:45:25', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '3000020101102', 0, 0, 0, '', NULL, 1, 0, 0, 'Purchase Expenses'),
(1369, 653, NULL, 'Others Purchase Charge', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-16 18:46:03', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '3000020101103', 0, 0, 0, '', NULL, 1, 0, 0, 'Others Purchase Charge'),
(1370, 578, NULL, 'Marad Sami', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Marad Sami'),
(1371, 578, NULL, 'Sulaimaan Sayedi Al Tejari', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Sulaimaan Sayedi Al Tejari'),
(1372, 578, NULL, 'Al Harbi', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Al Harbi'),
(1373, 578, NULL, 'Madina Center', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Madina Center'),
(1374, 578, NULL, 'Agriculture Yasmeen', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Agriculture Yasmeen'),
(1375, 578, NULL, 'Markaz Bissam Rahili', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Markaz Bissam Rahili'),
(1376, 578, NULL, 'Lexan Brass', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, ''),
(1377, 578, NULL, 'Al Sehemi Shop', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Al Sehemi Shop'),
(1378, 578, NULL, 'Joood for Trading', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Joood for Trading'),
(1379, 578, NULL, 'Sama Al Madinah', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Sama Al Madinah'),
(1380, 578, NULL, 'Ohud Aduwa Electric & Building Materials', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Ohud Aduwa Electric & Building Materials'),
(1381, 578, NULL, 'Markaz Abu Hamza Lilmuaad AL Binai', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Markaz Abu Hamza Lilmuaad AL Binai'),
(1382, 578, NULL, 'Al Matjar Al Watani', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Al Matjar Al Watani'),
(1383, 578, NULL, 'MSC Al Mousa Specialised Cables', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'MSC Al Mousa Specialised Cables'),
(1384, 578, NULL, 'Al Madinah Trading Center', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Al Madinah Trading Center'),
(1385, 578, NULL, 'Local Vendor', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Local Vendor'),
(1386, 578, NULL, 'Mahal Kharbai Al Jowharah', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Mahal Kharbai Al Jowharah'),
(1387, 578, NULL, 'Masna Queen Lil Balastic', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Masna Queen Lil Balastic'),
(1388, 578, NULL, 'Al Harbi Al Mawad AL Binai Wal Sabbak Wal Kharbai', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Al Harbi Al Mawad AL Binai Wal Sabbak Wal Kharbai'),
(1389, 578, NULL, 'Ameed Trad. Est.', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Ameed Trad. Est.'),
(1390, 578, NULL, 'Adwah Al Amal', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Adwah Al Amal'),
(1391, 578, NULL, 'Al Harthy Lighting & Electricity', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Al Harthy Lighting & Electricity'),
(1392, 578, NULL, 'Al Hazmi Accessories', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Al Hazmi Accessories'),
(1393, 578, NULL, 'Ghazi Al Raddadi Trading Est.', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Ghazi Al Raddadi Trading Est.'),
(1394, 578, NULL, 'Mahal Anzama Al Tarkibaat', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Mahal Anzama Al Tarkibaat'),
(1395, 578, NULL, 'Saad Al Raddaadi Est', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Saad Al Raddaadi Est'),
(1396, 578, NULL, 'Hab Al Reeh', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Hab Al Reeh'),
(1397, 578, NULL, 'Nebris Digital', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Nebris Digital'),
(1398, 578, NULL, 'Markaz Saadi', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Markaz Saadi'),
(1399, 578, NULL, 'Star Accessories', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Star Accessories'),
(1400, 578, NULL, 'No Vendor', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'No Vendor'),
(1401, 578, NULL, 'Anas Center', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Anas Center'),
(1402, 578, NULL, 'Smart Vision Systems', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Smart Vision Systems'),
(1403, 578, NULL, 'SKR Medical Desert Est.', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'SKR Medical Desert Est.'),
(1404, 578, NULL, 'Al Fahd Refrigeration Store', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Al Fahd Refrigeration Store'),
(1405, 578, NULL, 'Marad Al Maha', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Marad Al Maha'),
(1406, 578, NULL, 'Markaz Gheel Bawazir Lil Tagfizaat', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Markaz Gheel Bawazir Lil Tagfizaat'),
(1407, 578, NULL, 'Heba ', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Heba '),
(1408, 578, NULL, 'Mosassa Shareef Galib Mohammed Sind', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Mosassa Shareef Galib Mohammed Sind'),
(1409, 578, NULL, 'Al Orfali', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Al Orfali'),
(1410, 578, NULL, 'Maktab Daaralzamaan Linashar Wataizia', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Maktab Daaralzamaan Linashar Wataizia'),
(1411, 578, NULL, 'Ameer Lil Malabis Al Jahaza', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Ameer Lil Malabis Al Jahaza'),
(1412, 578, NULL, 'Maktab Ateebee', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Maktab Ateebee'),
(1413, 578, NULL, 'Al Sabbagh', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Al Sabbagh'),
(1414, 578, NULL, 'Limasaat Al Imran', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Limasaat Al Imran'),
(1415, 578, NULL, 'Mohammed Sulaiman A. Al Johani Trading Company Ltd', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Mohammed Sulaiman A. Al Johani Trading Company Ltd'),
(1416, 578, NULL, 'Al Saghyir Trading & Contracting Co.', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Al Saghyir Trading & Contracting Co.'),
(1417, 578, NULL, 'Mosasaa Galib Mohammed Al Harbi Lil Tijaria', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Mosasaa Galib Mohammed Al Harbi Lil Tijaria'),
(1418, 578, NULL, 'Asia Sat', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Asia Sat'),
(1419, 578, NULL, 'Al Kaser ICE Est.', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Al Kaser ICE Est.'),
(1420, 578, NULL, 'Alwan Alkhaleej United Est. International Car Pain', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Alwan Alkhaleej United Est. International Car Paints'),
(1421, 578, NULL, 'Al Harbi Liasaas Al Fanadik', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Al Harbi Liasaas Al Fanadik'),
(1422, 578, NULL, 'Gaaz Al Ambaria', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Gaaz Al Ambaria'),
(1423, 578, NULL, 'Rukan Al Riyadh', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Rukan Al Riyadh'),
(1424, 578, NULL, 'Summer Trading', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Summer Trading'),
(1425, 578, NULL, 'Alruwda Stationery', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Alruwda Stationery'),
(1426, 578, NULL, 'Al Jazeera Paints', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Al Jazeera Paints'),
(1427, 578, NULL, 'Al Mulla Est. For Trading', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Al Mulla Est. For Trading'),
(1428, 578, NULL, 'United Pharmacy', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'United Pharmacy'),
(1429, 578, NULL, 'Markaz Al Madinah Lil Hidayah', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Markaz Al Madinah Lil Hidayah'),
(1430, 578, NULL, 'Ameer For Readymade Cloths', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Ameer For Readymade Cloths'),
(1431, 578, NULL, 'Al Jazeera (Electronics)', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Al Jazeera (Electronics)'),
(1432, 578, NULL, 'Markaz Aamir ', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Markaz Aamir '),
(1433, 578, NULL, 'Badr Saud A. Rahman Al-Hazmi Trading Est.', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Badr Saud A. Rahman Al-Hazmi Trading Est.'),
(1434, 578, NULL, 'Mosassa Ibne Saad Lil Tijari', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Mosassa Ibne Saad Lil Tijari'),
(1435, 578, NULL, 'Emaar Al Jazeera', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Emaar Al Jazeera'),
(1436, 578, NULL, 'Markaz Alhamdaan Lildihanath Al Amreki', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Markaz Alhamdaan Lildihanath Al Amreki'),
(1437, 578, NULL, 'Al Ahmadi Shop', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Al Ahmadi Shop'),
(1438, 578, NULL, 'Al-Harbi Est.', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Al-Harbi Est.'),
(1439, 578, NULL, 'Bin Saleh Shop', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Bin Saleh Shop'),
(1440, 578, NULL, 'Taiba Electronics', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Taiba Electronics'),
(1441, 578, NULL, 'Markaz Al Imaan', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Markaz Al Imaan'),
(1442, 578, NULL, 'Kirtasia Miasin Al Madina Jomla', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Kirtasia Miasin Al Madina Jomla'),
(1443, 578, NULL, 'Mousa I. Al Kaltham & Sons Co.', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Mousa I. Al Kaltham & Sons Co.'),
(1444, 578, NULL, 'Brik M.Al-Lahebi Shops', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Brik M.Al-Lahebi Shops'),
(1445, 578, NULL, 'Al Madina Gift Center', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Al Madina Gift Center'),
(1446, 578, NULL, 'Amjad Al Falah Trading Est', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Amjad Al Falah Trading Est'),
(1447, 578, NULL, 'Sharika Khidmatal Mahduda', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Sharika Khidmatal Mahduda'),
(1448, 578, NULL, 'Magbool Qibl Al-Awfi Est', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Magbool Qibl Al-Awfi Est'),
(1449, 578, NULL, 'Fary Mosassa Bin Maazi Lil Tijaree', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Fary Mosassa Bin Maazi Lil Tijaree'),
(1450, 578, NULL, 'Al Shareef GhalibMuhammad Sanad', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Al Shareef GhalibMuhammad Sanad'),
(1451, 578, NULL, 'Mosassa Madinah Araadi', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Mosassa Madinah Araadi'),
(1452, 578, NULL, 'Mosassa Al Harbi Lil Haddaad Walmanyoom', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Mosassa Al Harbi Lil Haddaad Walmanyoom'),
(1453, 578, NULL, 'Marat Taibat', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Marat Taibat'),
(1454, 578, NULL, 'Al Nakhba Lil Tijaria', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Al Nakhba Lil Tijaria'),
(1455, 578, NULL, 'Mahalaat Abu Yousuf', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Mahalaat Abu Yousuf'),
(1456, 578, NULL, 'Dar Al-Falah Stationery', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Dar Al-Falah Stationery'),
(1457, 578, NULL, 'Abdullah Sayid Cooling Center', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Abdullah Sayid Cooling Center'),
(1458, 578, NULL, 'Help Center', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Help Center'),
(1459, 578, NULL, 'Mosassa Hussain Liltijarah', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Mosassa Hussain Liltijarah'),
(1460, 578, NULL, 'Bareek Al-Harbi Lil Electroniyaat', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Bareek Al-Harbi Lil Electroniyaat'),
(1461, 578, NULL, 'Mosassa Nahar Al Jahni LilKhaya Wal Jaharaat Al Ta', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Mosassa Nahar Al Jahni LilKhaya Wal Jaharaat Al Tayah'),
(1462, 578, NULL, 'Mosassa Ahmed Al Aamir', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Mosassa Ahmed Al Aamir'),
(1463, 578, NULL, 'AL-Zugheibi Est', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'AL-Zugheibi Est'),
(1464, 578, NULL, 'Maraz Al Riyan', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Maraz Al Riyan'),
(1465, 578, NULL, 'Al-Qaseem Maintenance & General Trading Est.', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Al-Qaseem Maintenance & General Trading Est.'),
(1466, 578, NULL, 'Dallah Co.', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Dallah Co.'),
(1467, 578, NULL, 'Mosassa Abdulillah Abu Taqila lilmuqawilat', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Mosassa Abdulillah Abu Taqila lilmuqawilat'),
(1468, 578, NULL, 'Al Suhaili', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Al Suhaili'),
(1469, 578, NULL, 'Johnson Controls', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Johnson Controls'),
(1470, 578, NULL, 'khalid Furniture', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'khalid Furniture'),
(1471, 578, NULL, 'Moared Alsafa For Trading Est.', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Moared Alsafa For Trading Est.'),
(1472, 578, NULL, 'AZOZ Center', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'AZOZ Center'),
(1473, 578, NULL, 'Markaz Al Madinah', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Markaz Al Madinah'),
(1474, 578, NULL, 'Abdullah Ayed Bin Sawerah AL-Rashidi Trading Est.', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Abdullah Ayed Bin Sawerah AL-Rashidi Trading Est.'),
(1475, 578, NULL, 'Masna Al Dameel', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Masna Al Dameel'),
(1476, 578, NULL, 'Markaz Al Tajeen', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Markaz Al Tajeen'),
(1477, 578, NULL, 'Al Nazmatul Ar Kamiatul Dakikat ', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Al Nazmatul Ar Kamiatul Dakikat '),
(1478, 578, NULL, 'Sharika Al Masian Tijari', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Sharika Al Masian Tijari'),
(1479, 578, NULL, 'Abu Turkey Center', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Abu Turkey Center'),
(1480, 578, NULL, 'Al Mahary Lil Bataria', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Al Mahary Lil Bataria'),
(1481, 578, NULL, 'Mosassa Al Jahani', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Mosassa Al Jahani'),
(1482, 578, NULL, 'Raghad', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Raghad'),
(1483, 578, NULL, 'United Alwan Alkhaleej', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'United Alwan Alkhaleej'),
(1484, 578, NULL, 'Al Ahmadi Center', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Al Ahmadi Center'),
(1485, 578, NULL, 'The World of Electricity', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'The World of Electricity'),
(1486, 578, NULL, 'Jndelh Company With Limited Liability', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Jndelh Company With Limited Liability'),
(1487, 578, NULL, 'Rukan Al Riyadh Al Alamiah', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Rukan Al Riyadh Al Alamiah'),
(1488, 578, NULL, 'Mahal Al Rahili Lil Sabaaka Wal Kharbai', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Mahal Al Rahili Lil Sabaaka Wal Kharbai'),
(1489, 578, NULL, 'Manafee Al-Madinah For Trading', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Manafee Al-Madinah For Trading'),
(1490, 578, NULL, 'Al Kamal Electronics Workshop', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Al Kamal Electronics Workshop'),
(1491, 578, NULL, 'Est. Rafat Muhammad Zayn Yusuf Musa Building Mater', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Est. Rafat Muhammad Zayn Yusuf Musa Building Materials'),
(1492, 578, NULL, 'Badr For Ind. Equipment', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Badr For Ind. Equipment'),
(1493, 578, NULL, 'OHOD ELECTRIC', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'OHOD ELECTRIC'),
(1494, 578, NULL, 'Local Taxi ', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Local Taxi '),
(1495, 578, NULL, 'Decoraat Al Osseilan', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Decoraat Al Osseilan'),
(1496, 578, NULL, 'Al SilSila Al Dahbiya', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Al SilSila Al Dahbiya'),
(1497, 578, NULL, 'Markaz Bin Amroo', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Markaz Bin Amroo'),
(1498, 578, NULL, 'Al Nahas Electronics Center', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Al Nahas Electronics Center'),
(1499, 578, NULL, 'Abu Wahil', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Abu Wahil'),
(1500, 578, NULL, 'Masdar Hardware', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Masdar Hardware'),
(1501, 578, NULL, 'Imdadat Al-Dhiyafah  Trading Est', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Imdadat Al-Dhiyafah  Trading Est'),
(1502, 578, NULL, 'Badr Est.', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Badr Est.'),
(1503, 578, NULL, 'Hussain Ateya Al Jihani Trading Est.', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Hussain Ateya Al Jihani Trading Est.'),
(1504, 578, NULL, 'Mamlaket Al Bonyan Est.', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Mamlaket Al Bonyan Est.'),
(1505, 578, NULL, 'Mahalaat Al Masawee', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Mahalaat Al Masawee'),
(1506, 578, NULL, 'Majdaf Trading Company', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Majdaf Trading Company'),
(1507, 578, NULL, 'Jarir.Com', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Jarir.Com'),
(1508, 578, NULL, 'Ebn Abbas Est.', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Ebn Abbas Est.'),
(1509, 578, NULL, 'Markaz Taiba Lataqniyaah LilZajaaj', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Markaz Taiba Lataqniyaah LilZajaaj'),
(1510, 578, NULL, 'Makbas Nawaaf Lilhadeed Al Maadni', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Makbas Nawaaf Lilhadeed Al Maadni'),
(1511, 578, NULL, 'Mafrooshaat Abu Bissaam', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Mafrooshaat Abu Bissaam'),
(1512, 578, NULL, 'Sera Digital Co.', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Sera Digital Co.'),
(1513, 578, NULL, 'Universal Ink\'s', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Universal Ink\'s'),
(1514, 578, NULL, 'Al-Anwar', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Al-Anwar'),
(1515, 578, NULL, 'Est of Hamed A.Al-Saati For Trading', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Est of Hamed A.Al-Saati For Trading'),
(1516, 578, NULL, 'Faisal Masharee LilMahrookaat', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Faisal Masharee LilMahrookaat'),
(1517, 578, NULL, 'Muwassasat At-Tawasil Al Munir At Tijariya', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Muwassasat At-Tawasil Al Munir At Tijariya'),
(1518, 578, NULL, 'Sarika Amsayaan Al Tijaria', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Sarika Amsayaan Al Tijaria'),
(1519, 578, NULL, 'Mosassa Tashkeel Al Saqaf Al Tijaria', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Mosassa Tashkeel Al Saqaf Al Tijaria'),
(1520, 578, NULL, 'Mosassa Ghalib Mohammed Al Harbi Liltajarah', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Mosassa Ghalib Mohammed Al Harbi Liltajarah'),
(1521, 578, NULL, 'Mahatta Al Burj', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Mahatta Al Burj'),
(1522, 578, NULL, 'Noor Al-Madinah Electric', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Noor Al-Madinah Electric'),
(1523, 578, NULL, 'Al Mashry Center', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Al Mashry Center'),
(1524, 578, NULL, 'Printers Center', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Printers Center'),
(1525, 578, NULL, 'Branch Al Harbi Est.', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200002010101', 0, 0, 0, '', NULL, 1, 0, 0, 'Branch Al Harbi Est.'),
(1526, 576, NULL, 'Heirs of Syed Habib Mahmood Ahmed (Rawdah)', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '20000201', 0, 0, 0, '', NULL, 1, 0, 0, 'Heirs of Syed Habib Mahmood Ahmed (Rawdah)'),
(1527, 576, NULL, 'Heirs of Effat Abbas Atiah (Golden)', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '20000201', 0, 0, 0, '', NULL, 1, 0, 0, 'Heirs of Effat Abbas Atiah (Golden)'),
(1528, 576, NULL, 'Amer Al Luhaigq (Wardah)', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '20000201', 0, 0, 0, '', NULL, 1, 0, 0, 'Amer Al Luhaigq (Wardah)'),
(1529, 576, NULL, 'Sons Of Prince Ahmed Bin Abdul Aziz Al Saud (Tower', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '20000201', 0, 0, 0, '', NULL, 1, 0, 0, 'Sons Of Prince Ahmed Bin Abdul Aziz Al Saud (Tower)'),
(1530, 576, NULL, 'Yahya Ibrahim Al-Yahya (Al Safa Center)', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '20000201', 0, 0, 0, '', NULL, 1, 0, 0, 'Yahya Ibrahim Al-Yahya (Al Safa Center)'),
(1531, 576, NULL, 'The State Real Estate Authority (Jawharat - Lulu)', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '20000201', 0, 0, 0, '', NULL, 1, 0, 0, 'The State Real Estate Authority (Jawharat - Lulu)'),
(1532, 576, NULL, 'Ibrahim Suleiman Ibrahim Fakih (Ghadeer - Suite)', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '20000201', 0, 0, 0, '', NULL, 1, 0, 0, 'Ibrahim Suleiman Ibrahim Fakih (Ghadeer - Suite)'),
(1533, 576, NULL, 'Amnih Saeid (Manar)', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '20000201', 0, 0, 0, '', NULL, 1, 0, 0, 'Amnih Saeid (Manar)'),
(1534, 576, NULL, 'Abbas Qamqamji (Safa Maasi)', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '20000201', 0, 0, 0, '', NULL, 1, 0, 0, 'Abbas Qamqamji (Safa Maasi)'),
(1535, 576, NULL, 'Waqf Alsuwdan - Saleh Al-Hujaili (Zubair)', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '20000201', 0, 0, 0, '', NULL, 1, 0, 0, 'Waqf Alsuwdan - Saleh Al-Hujaili (Zubair)'),
(1536, 576, NULL, 'Waqf Al Marrakshi/Eimad Al Daeis (Raihan Al Kausar', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '20000201', 0, 0, 0, '', NULL, 1, 0, 0, 'Waqf Al Marrakshi/Eimad Al Daeis (Raihan Al Kausar)'),
(1537, 576, NULL, 'Saudi Electricity Company', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '20000201', 0, 0, 0, '', NULL, 1, 0, 0, 'Saudi Electricity Company'),
(1538, 576, NULL, 'Saudi Water Company', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '20000201', 0, 0, 0, '', NULL, 1, 0, 0, 'Saudi Water Company'),
(1539, 576, NULL, 'Saudi Telecom Company', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '20000201', 0, 0, 0, '', NULL, 1, 0, 0, 'Saudi Telecom Company'),
(1540, 574, NULL, 'Accumulated Depreciation', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-18 12:05:05', '', '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '200001021', 0, 0, 0, '', NULL, 1, 0, 0, 'Accumulated Depreciation'),
(1541, 581, NULL, 'Depreciation Expenses', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-18 12:07:07', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '30000101010110', 0, 0, 0, '', NULL, 1, 0, 0, ''),
(1542, 581, NULL, 'Loss on sales in fixed assets', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-03-18 12:07:53', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '30000101010111', 0, 0, 0, '', NULL, 1, 0, 0, 'Loss on sales in fixed assets'),
(1543, 536, NULL, 'Abdul Aziz/Pakistan', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Abdul Aziz/Pakistan'),
(1544, 536, NULL, 'Abdul Majeed / Al Duha', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Abdul Majeed / Al Duha'),
(1545, 536, NULL, 'Abdul Majid', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Abdul Majid'),
(1546, 536, NULL, 'Abdul Malik /Huzaifa', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Abdul Malik /Huzaifa'),
(1547, 536, NULL, 'Abdul Mazid /Personal', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Abdul Mazid /Personal'),
(1548, 536, NULL, 'Abdullah /Hotel Mahbub Al Tayyaba', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Abdullah /Hotel Mahbub Al Tayyaba'),
(1549, 536, NULL, 'Abdullah Al Ghamdi-Malek Boshir', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Abdullah Al Ghamdi-Malek Boshir');
INSERT INTO `ledger` (`id`, `parent_head_id`, `sub_head_id`, `ledger_title`, `is_bank_account`, `bank_name`, `branch_address`, `bank_account_name`, `bank_account_no`, `opening_balance`, `date`, `date_time`, `remarks`, `by`, `type`, `wire`, `permission`, `c_s_id`, `ware`, `trans_w_l`, `up_wire`, `fixed`, `sup`, `cus`, `phone`, `model`, `trace`, `accounts_id`, `agent_id`, `agent_commission`, `contract_ref`, `vat_reg_no`, `payroll_ref`, `status`, `vatcode`, `code`, `foreign_name`) VALUES
(1550, 536, NULL, 'Abdur Rashid ', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Abdur Rashid '),
(1551, 536, NULL, 'Abdur Rashid Kerala', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Abdur Rashid Kerala'),
(1552, 536, NULL, 'Abrar Air Travels/Sayedur Rahman', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Abrar Air Travels/Sayedur Rahman'),
(1553, 536, NULL, 'Abu Atia-Chaina', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Abu Atia-Chaina'),
(1554, 536, NULL, 'Abu Belal Travels-Muhammad Ismail', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Abu Belal Travels-Muhammad Ismail'),
(1555, 536, NULL, 'Abu Turki Diyar Masi', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Abu Turki Diyar Masi'),
(1556, 536, NULL, 'Adnan/Owais', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Adnan/Owais'),
(1557, 536, NULL, 'Adom Al Ghat-Ibrahim Abu Rayan', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Adom Al Ghat-Ibrahim Abu Rayan'),
(1558, 536, NULL, 'Ahmad Muhammad Khalil', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Ahmad Muhammad Khalil'),
(1559, 536, NULL, 'Air Usman Travels/Muhammad Anowar', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Air Usman Travels/Muhammad Anowar'),
(1560, 536, NULL, 'Ajwa International Tours & Travels-Moham', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Ajwa International Tours & Travels-Moham'),
(1561, 536, NULL, 'Al Affan Tours & Travels-Ershad', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Al Affan Tours & Travels-Ershad'),
(1562, 536, NULL, 'Al Arabian Hajj umrah Tours / Abdul Kari', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Al Arabian Hajj umrah Tours / Abdul Kari'),
(1563, 536, NULL, 'Al Baraka/Abdul Aziz', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Al Baraka/Abdul Aziz'),
(1564, 536, NULL, 'Al Baraka-Nafesi/Humayon', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Al Baraka-Nafesi/Humayon'),
(1565, 536, NULL, 'Al Bosra International Tours & Travels-I', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Al Bosra International Tours & Travels-I'),
(1566, 536, NULL, 'Al Ebrar Travels/Sadiq', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Al Ebrar Travels/Sadiq'),
(1567, 536, NULL, 'AL FAIZI TOURS AND TRAVELS', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'AL FAIZI TOURS AND TRAVELS'),
(1568, 536, NULL, 'Al Falah Tours & Travels', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Al Falah Tours & Travels'),
(1569, 536, NULL, 'Al Hadaya Group Yaseen', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Al Hadaya Group Yaseen'),
(1570, 536, NULL, 'Al Hayat Global Group-Mr Naqibullah', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Al Hayat Global Group-Mr Naqibullah'),
(1571, 536, NULL, 'Al Heremain-Md Faiz', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Al Heremain-Md Faiz'),
(1572, 536, NULL, 'Al Hunain Shahzad Yaseen', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Al Hunain Shahzad Yaseen'),
(1573, 536, NULL, 'Al Imam Hajj Kafela-Nejam', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Al Imam Hajj Kafela-Nejam'),
(1574, 536, NULL, 'Al Kabir Tours & Travels/Hyder', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Al Kabir Tours & Travels/Hyder'),
(1575, 536, NULL, 'Al Kabir/Abdur Rahman', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Al Kabir/Abdur Rahman'),
(1576, 536, NULL, 'Al Kazi Tours & Travels/ muhammad Hussai', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Al Kazi Tours & Travels/ muhammad Hussai'),
(1577, 536, NULL, 'Al Madina Tours @ Travels/Md Abdullah ', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Al Madina Tours @ Travels/Md Abdullah '),
(1578, 536, NULL, 'Al Makka Travels/Muwazzam', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Al Makka Travels/Muwazzam'),
(1579, 536, NULL, 'Al malik tours / yaseen ', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Al malik tours / yaseen '),
(1580, 536, NULL, 'Al Miqat Tours-Muhammad Jamil', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Al Miqat Tours-Muhammad Jamil'),
(1581, 536, NULL, 'Al Munazah Tours & Travels PVT.LTD.', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Al Munazah Tours & Travels PVT.LTD.'),
(1582, 536, NULL, 'Al Noor Tours & Travels / Nayeem', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Al Noor Tours & Travels / Nayeem'),
(1583, 536, NULL, 'Al Qayyum Tours & Travels', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Al Qayyum Tours & Travels'),
(1584, 536, NULL, 'AL Qubrah Tours Kalkatta', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'AL Qubrah Tours Kalkatta'),
(1585, 536, NULL, 'Al Sada Tours/Ayyub', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Al Sada Tours/Ayyub'),
(1586, 536, NULL, 'Al Safa Tours & Travels', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Al Safa Tours & Travels'),
(1587, 536, NULL, 'Al Safeer Tours & Travels-Ali Hussain Bo', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Al Safeer Tours & Travels-Ali Hussain Bo'),
(1588, 536, NULL, 'Al Taif tour and Travels / Awais', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Al Taif tour and Travels / Awais'),
(1589, 536, NULL, 'Al Taqwa/Abdus Samad', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Al Taqwa/Abdus Samad'),
(1590, 536, NULL, 'Al Tawakal Tours & Travels-Rana Ataullah', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Al Tawakal Tours & Travels-Rana Ataullah'),
(1591, 536, NULL, 'Al Yasir-Shahed', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Al Yasir-Shahed'),
(1592, 536, NULL, 'Al Zahir Travels& Tours-Mazhar', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Al Zahir Travels& Tours-Mazhar'),
(1593, 536, NULL, 'AL Zowar Company', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'AL Zowar Company'),
(1594, 536, NULL, 'Ali Nawaz', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Ali Nawaz'),
(1595, 536, NULL, 'Ali Raza', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Ali Raza'),
(1596, 536, NULL, 'Alif International Tours & Travels-Mr Ha', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Alif International Tours & Travels-Mr Ha'),
(1597, 536, NULL, 'Allied Tours & Travels-Fayyaz Ahmed', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Allied Tours & Travels-Fayyaz Ahmed'),
(1598, 536, NULL, 'ALTWAFUQ TRAVELS/Faisal', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'ALTWAFUQ TRAVELS/Faisal'),
(1599, 536, NULL, 'Ameena Tours & Travels/Siraz pk', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Ameena Tours & Travels/Siraz pk'),
(1600, 536, NULL, 'Ameena Tours/Mubarak', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Ameena Tours/Mubarak'),
(1601, 536, NULL, 'An Nahian Hajj Kafela-Mr Ismail', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'An Nahian Hajj Kafela-Mr Ismail'),
(1602, 536, NULL, 'Anam Bd-Durrat Eliyas', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Anam Bd-Durrat Eliyas'),
(1603, 536, NULL, 'Ansari Tours & Travels-Muhammad Qasim', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Ansari Tours & Travels-Muhammad Qasim'),
(1604, 536, NULL, 'Anwar Pakistan-Kidmat Indian', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Anwar Pakistan-Kidmat Indian'),
(1605, 536, NULL, 'Arabia Originals Tours & Travels', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Arabia Originals Tours & Travels'),
(1606, 536, NULL, 'Arjumand Tours & Travels Pvt Ltd', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Arjumand Tours & Travels Pvt Ltd'),
(1607, 536, NULL, 'Arjuwan Al Madina/Akram', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Arjuwan Al Madina/Akram'),
(1608, 536, NULL, 'Arshad Arif Travels', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Arshad Arif Travels'),
(1609, 536, NULL, 'As Safa Wal Marwah Tours / MD Suhail', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'As Safa Wal Marwah Tours / MD Suhail'),
(1610, 536, NULL, 'As Sunnah Tours & Travels/ Syed Saqib', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'As Sunnah Tours & Travels/ Syed Saqib'),
(1611, 536, NULL, 'Asad Bati-Pakistan', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Asad Bati-Pakistan'),
(1612, 536, NULL, 'Asdaf Umrah Services-M. Aslam Tahiri', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Asdaf Umrah Services-M. Aslam Tahiri'),
(1613, 536, NULL, 'Ashiq Kerala', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Ashiq Kerala'),
(1614, 536, NULL, 'Ashraf Abdullha / Afghani', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Ashraf Abdullha / Afghani'),
(1615, 536, NULL, 'Ashwak Shakeel', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Ashwak Shakeel'),
(1616, 536, NULL, 'At Tawhid Travels-Abdur Rahman', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'At Tawhid Travels-Abdur Rahman'),
(1617, 536, NULL, 'Awaits Tours & Travels-Akhil Pk', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Awaits Tours & Travels-Akhil Pk'),
(1618, 536, NULL, 'AWIS VHIA /BARIK', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'AWIS VHIA /BARIK'),
(1619, 536, NULL, 'Ayesha Tours', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Ayesha Tours'),
(1620, 536, NULL, 'Ayesha Tours Hajj & Umrah-Sayed Azhar', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Ayesha Tours Hajj & Umrah-Sayed Azhar'),
(1621, 536, NULL, 'Baleeno Travel--Farhan', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Baleeno Travel--Farhan'),
(1622, 536, NULL, 'Bangladesh Hajje Baitullah Tours & Trave', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Bangladesh Hajje Baitullah Tours & Trave'),
(1623, 536, NULL, 'Basalama Tours & Travels', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Basalama Tours & Travels'),
(1624, 536, NULL, 'Basma Amar / Waqas', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Basma Amar / Waqas'),
(1625, 536, NULL, 'Basra Travels & Tours International-Mr M', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Basra Travels & Tours International-Mr M'),
(1626, 536, NULL, 'Binnoria Hajj & Umrah/Md Fazal', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Binnoria Hajj & Umrah/Md Fazal'),
(1627, 536, NULL, 'Belal Tasrir', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Belal Tasrir'),
(1628, 536, NULL, 'Chatta Group', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Chatta Group'),
(1629, 536, NULL, 'Complimentary Rooms', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Complimentary Rooms'),
(1630, 536, NULL, 'Danish Tours & Travels', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Danish Tours & Travels'),
(1631, 536, NULL, 'Default Agent For Local', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Default Agent For Local'),
(1632, 536, NULL, 'Default Agent For Reservation', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Default Agent For Reservation'),
(1633, 536, NULL, 'Diyar Al Masy//Usman', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Diyar Al Masy//Usman'),
(1634, 536, NULL, 'Dua Al Madinah', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Dua Al Madinah'),
(1635, 536, NULL, 'Duhar Novabgonj Hajj Kafela/Moulana Ibra', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Duhar Novabgonj Hajj Kafela/Moulana Ibra'),
(1636, 536, NULL, 'Dunia Aviation/Yassen', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Dunia Aviation/Yassen'),
(1637, 536, NULL, 'Ehsan Travel maksud ', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Ehsan Travel maksud '),
(1638, 536, NULL, 'Ehsan-Masarat/Personal', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Ehsan-Masarat/Personal'),
(1639, 536, NULL, 'Eklas Tours & Travels/Sapeer', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Eklas Tours & Travels/Sapeer'),
(1640, 536, NULL, 'Ershad /Personal', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Ershad /Personal'),
(1641, 536, NULL, 'Etemad Tours & Travels-Mr Rapiq', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Etemad Tours & Travels-Mr Rapiq'),
(1642, 536, NULL, 'Ethmar Tours & Travels-Mr Zia', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Ethmar Tours & Travels-Mr Zia'),
(1643, 536, NULL, 'Ethmar Travels & Tours', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Ethmar Travels & Tours'),
(1644, 536, NULL, 'Etlala Makka-Gukzar Pk', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Etlala Makka-Gukzar Pk'),
(1645, 536, NULL, 'Funadiq.com / Munib', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Funadiq.com / Munib'),
(1646, 536, NULL, 'Ghulam Murthoza-Binham Personal', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Ghulam Murthoza-Binham Personal'),
(1647, 536, NULL, 'Ghulam Murtoza', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Ghulam Murtoza'),
(1648, 536, NULL, 'Global Travels', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Global Travels'),
(1649, 536, NULL, 'Globex Tours and Travels / Jamsheed', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Globex Tours and Travels / Jamsheed'),
(1650, 536, NULL, 'Gowher-Khasmiri', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Gowher-Khasmiri'),
(1651, 536, NULL, 'Great Air Travels-Mr Arjuman', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Great Air Travels-Mr Arjuman'),
(1652, 536, NULL, 'Gul Foraz. Shahed pakistam', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Gul Foraz. Shahed pakistam'),
(1653, 536, NULL, 'Gul Zada Tours & Travels-Rhased', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Gul Zada Tours & Travels-Rhased'),
(1654, 536, NULL, 'Gulam Nabi ', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Gulam Nabi '),
(1655, 536, NULL, 'Habibi Travels Waseem', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Habibi Travels Waseem'),
(1656, 536, NULL, 'Hadi-Masarat/Parvez', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Hadi-Masarat/Parvez'),
(1657, 536, NULL, 'Hamza Bina/Ejab Chowdury', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Hamza Bina/Ejab Chowdury'),
(1658, 536, NULL, 'Hassan Mahboob / F J Travels', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Hassan Mahboob / F J Travels'),
(1659, 536, NULL, 'Hatim E Khaba/Qury Shaheb', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Hatim E Khaba/Qury Shaheb'),
(1660, 536, NULL, 'Hemad Travels/Waqas', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Hemad Travels/Waqas'),
(1661, 536, NULL, 'Heramain Syed', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Heramain Syed'),
(1662, 536, NULL, 'Heremain-Mr Safat', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Heremain-Mr Safat'),
(1663, 536, NULL, 'Hermein Tugarvi Dr Jafar', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Hermein Tugarvi Dr Jafar'),
(1664, 536, NULL, 'HNH Travels-Anas', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'HNH Travels-Anas'),
(1665, 536, NULL, 'Ibrahim Mansur-Hotel Andulus ', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Ibrahim Mansur-Hotel Andulus '),
(1666, 536, NULL, 'Ibrahim/Karacy', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Ibrahim/Karacy'),
(1667, 536, NULL, 'Idris Muhammad', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Idris Muhammad'),
(1668, 536, NULL, 'Ifrha Tours & Travels/Irfan', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Ifrha Tours & Travels/Irfan'),
(1669, 536, NULL, 'Iqbal Sait', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Iqbal Sait'),
(1670, 536, NULL, 'Irfan / Pakistan', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Irfan / Pakistan'),
(1671, 536, NULL, 'IRFAN-CASH', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'IRFAN-CASH'),
(1672, 536, NULL, 'Irfan-Max-Personal', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Irfan-Max-Personal'),
(1673, 536, NULL, 'J K TOUTS & TRAVELS/TARAQ', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'J K TOUTS & TRAVELS/TARAQ'),
(1674, 536, NULL, 'J Y Overseas & Hajj Kafela/-Md.Anowar Ct', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'J Y Overseas & Hajj Kafela/-Md.Anowar Ct'),
(1675, 536, NULL, 'Johdo Taqwa Catering Service-Mr Abid', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Johdo Taqwa Catering Service-Mr Abid'),
(1676, 536, NULL, 'Jonaki Travels-Wazedur Rahamn', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Jonaki Travels-Wazedur Rahamn'),
(1677, 536, NULL, 'Junaid Tour and Travels', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Junaid Tour and Travels'),
(1678, 536, NULL, 'K.M Tours & Travels-Mr Zubair', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'K.M Tours & Travels-Mr Zubair'),
(1679, 536, NULL, 'Kamal wafa Usman', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Kamal wafa Usman'),
(1680, 536, NULL, 'Karwan Hanifi or Babul Adil ', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Karwan Hanifi or Babul Adil '),
(1681, 536, NULL, 'Kawan-Safina-E-Raza Travels', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Kawan-Safina-E-Raza Travels'),
(1682, 536, NULL, 'Kawser Aziz-Kashmir', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Kawser Aziz-Kashmir'),
(1683, 536, NULL, 'Khadem Al Madina/Abdul Munayem', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Khadem Al Madina/Abdul Munayem'),
(1684, 536, NULL, 'Khidmat Travels Turist-UK/Aftab Ahmed Ch', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Khidmat Travels Turist-UK/Aftab Ahmed Ch'),
(1685, 536, NULL, 'KZ GROUP/Awais', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'KZ GROUP/Awais'),
(1686, 536, NULL, 'Labbaik Overseas Ltd-Md Kawsar', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Labbaik Overseas Ltd-Md Kawsar'),
(1687, 536, NULL, 'Lahore Travels-Ch Akhter Ali', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Lahore Travels-Ch Akhter Ali'),
(1688, 536, NULL, 'Lala International-Pakistan/Maqsud', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Lala International-Pakistan/Maqsud'),
(1689, 536, NULL, 'Latip Tours & Travels/ MD Munir', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Latip Tours & Travels/ MD Munir'),
(1690, 536, NULL, 'Luck Umrah Tours/Farhan', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Luck Umrah Tours/Farhan'),
(1691, 536, NULL, 'M ROHAN TRAVELS & TOURS/NAVED', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'M ROHAN TRAVELS & TOURS/NAVED'),
(1692, 536, NULL, 'M.JAHID TRAVELS/ IMRAN', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'M.JAHID TRAVELS/ IMRAN'),
(1693, 536, NULL, 'Madani Travels-Madani', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Madani Travels-Madani'),
(1694, 536, NULL, 'Madanion Al Madina-Mr Nijam Uddin', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Madanion Al Madina-Mr Nijam Uddin'),
(1695, 536, NULL, 'Madina Tours & Travels/Sayed Ali', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Madina Tours & Travels/Sayed Ali'),
(1696, 536, NULL, 'Makka Tours & Travels-Haji Imran Malek', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Makka Tours & Travels-Haji Imran Malek'),
(1697, 536, NULL, 'Malik Riyaz-Pakistan/Selim', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Malik Riyaz-Pakistan/Selim'),
(1698, 536, NULL, 'Manzoor', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Manzoor'),
(1699, 536, NULL, 'Manzoor / Pakistan ', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Manzoor / Pakistan '),
(1700, 536, NULL, 'Maqsum Bhai-Pakistan', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Maqsum Bhai-Pakistan'),
(1701, 536, NULL, 'Marhaba Tours & Travels/Tayyab ', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Marhaba Tours & Travels/Tayyab '),
(1702, 536, NULL, 'MAWAQET HAJJ & UMRAH-Mr Muhi', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'MAWAQET HAJJ & UMRAH-Mr Muhi'),
(1703, 536, NULL, 'Max travels -Mr Imran', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Max travels -Mr Imran'),
(1704, 536, NULL, 'Max travels Abdul mannan', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Max travels Abdul mannan'),
(1705, 536, NULL, 'MD.Rana Zapor', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'MD.Rana Zapor'),
(1706, 536, NULL, 'Meezab Group', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Meezab Group'),
(1707, 536, NULL, 'Mezaab-E-Kaaba', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Mezaab-E-Kaaba'),
(1708, 536, NULL, 'Mohammad Abid \\ Umal qura Tours & Travls', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Mohammad Abid \\ Umal qura Tours & Travls'),
(1709, 536, NULL, 'Mohammed Ashfaq Ahmed', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Mohammed Ashfaq Ahmed'),
(1710, 536, NULL, 'Mohsin ', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Mohsin '),
(1711, 536, NULL, 'Mohsin / Hyderabad ', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Mohsin / Hyderabad '),
(1712, 536, NULL, 'Monir Ahmed-Parsonal-Latip Travels', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Monir Ahmed-Parsonal-Latip Travels'),
(1713, 536, NULL, 'Mudaccir / Azowar', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Mudaccir / Azowar'),
(1714, 536, NULL, 'Mudaccir-Mubin', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Mudaccir-Mubin'),
(1715, 536, NULL, 'Muhammad Nasir', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Muhammad Nasir'),
(1716, 536, NULL, 'Muqeem Travels / Mujeeb', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Muqeem Travels / Mujeeb'),
(1717, 536, NULL, 'Musa Ishaque Corporation-Mr Soaib', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Musa Ishaque Corporation-Mr Soaib'),
(1718, 536, NULL, 'Nafam Group Hajj & Umrah Specialist--Md ', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Nafam Group Hajj & Umrah Specialist--Md '),
(1719, 536, NULL, 'Nasir ', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Nasir '),
(1720, 536, NULL, 'Nasir Diyer Al Masi', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Nasir Diyer Al Masi'),
(1721, 536, NULL, 'Nass Tours & Travels-Rameej Muhammad Ali', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Nass Tours & Travels-Rameej Muhammad Ali'),
(1722, 536, NULL, 'Nesar/Al Arooz-Pakistan', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Nesar/Al Arooz-Pakistan'),
(1723, 536, NULL, 'New World Travel & Tours-Md Belal', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'New World Travel & Tours-Md Belal'),
(1724, 536, NULL, 'Omar Faruk Travels-Kolkata-Sahin Rahman', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Omar Faruk Travels-Kolkata-Sahin Rahman'),
(1725, 536, NULL, 'Parabath Tours & Travels/Rahmatul Bary ', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Parabath Tours & Travels/Rahmatul Bary '),
(1726, 536, NULL, 'Parvez-Personal/Pakistan', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Parvez-Personal/Pakistan'),
(1727, 536, NULL, 'Parviz India', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Parviz India'),
(1728, 536, NULL, 'Professor Ahmed Ali', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Professor Ahmed Ali'),
(1729, 536, NULL, 'Qawafil Al Zowar-Esham', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Qawafil Al Zowar-Esham'),
(1730, 536, NULL, 'Qunain Travels/Hafej Khasem', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Qunain Travels/Hafej Khasem'),
(1731, 536, NULL, 'Qury Ataullah', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Qury Ataullah'),
(1732, 536, NULL, 'Rahath Tours ', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Rahath Tours '),
(1733, 536, NULL, 'Raja al madina-Mr Irfan', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Raja al madina-Mr Irfan'),
(1734, 536, NULL, 'Rawdat Al Molaby Group/Sherif Al-Shishta', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Rawdat Al Molaby Group/Sherif Al-Shishta'),
(1735, 536, NULL, 'Reduwan', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Reduwan'),
(1736, 536, NULL, 'Ridwan Travels/Razaul Karim', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Ridwan Travels/Razaul Karim'),
(1737, 536, NULL, 'Riyad Malih-Libia', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Riyad Malih-Libia'),
(1738, 536, NULL, 'Riyaz Tours And Travels', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Riyaz Tours And Travels'),
(1739, 536, NULL, 'Royal Blue Travels/Tanveer', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Royal Blue Travels/Tanveer'),
(1740, 536, NULL, 'Sahara Hajj Umrah Serviseas-/Basit', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Sahara Hajj Umrah Serviseas-/Basit'),
(1741, 536, NULL, 'Sahriar Abdul Halim', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Sahriar Abdul Halim'),
(1742, 536, NULL, 'Saik-Personal-Pakistan', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Saik-Personal-Pakistan'),
(1743, 536, NULL, 'Sajjed (Bd)0088', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Sajjed (Bd)0088'),
(1744, 536, NULL, 'Sami rajpoot traevels-Iftikhar', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Sami rajpoot traevels-Iftikhar');
INSERT INTO `ledger` (`id`, `parent_head_id`, `sub_head_id`, `ledger_title`, `is_bank_account`, `bank_name`, `branch_address`, `bank_account_name`, `bank_account_no`, `opening_balance`, `date`, `date_time`, `remarks`, `by`, `type`, `wire`, `permission`, `c_s_id`, `ware`, `trans_w_l`, `up_wire`, `fixed`, `sup`, `cus`, `phone`, `model`, `trace`, `accounts_id`, `agent_id`, `agent_commission`, `contract_ref`, `vat_reg_no`, `payroll_ref`, `status`, `vatcode`, `code`, `foreign_name`) VALUES
(1745, 536, NULL, 'Sartaj Ahmed-Pakistan', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Sartaj Ahmed-Pakistan'),
(1746, 536, NULL, 'Sharika Binham/Mesbha', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Sharika Binham/Mesbha'),
(1747, 536, NULL, 'Sharika Eliyas', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Sharika Eliyas'),
(1748, 536, NULL, 'Sharika Muhajjor Rommal/Yaqub Afgany', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Sharika Muhajjor Rommal/Yaqub Afgany'),
(1749, 536, NULL, 'Sherag Al Madina Tours & Travel/ Shahid', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Sherag Al Madina Tours & Travel/ Shahid'),
(1750, 536, NULL, 'Siddik Ibrahim', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Siddik Ibrahim'),
(1751, 536, NULL, 'Sidra Tours & Travels', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Sidra Tours & Travels'),
(1752, 536, NULL, 'Sky World', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Sky World'),
(1753, 536, NULL, 'SN Tours & Travels/MD,Shah Alam', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'SN Tours & Travels/MD,Shah Alam'),
(1754, 536, NULL, 'Subhan Travels-Akhil Pk', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Subhan Travels-Akhil Pk'),
(1755, 536, NULL, 'Subidha Tours & Travels/Riduwan', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Subidha Tours & Travels/Riduwan'),
(1756, 536, NULL, 'Sukkur travel/Belal Jatoi', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Sukkur travel/Belal Jatoi'),
(1757, 536, NULL, 'Sumaira Aviation/Sazzad', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Sumaira Aviation/Sazzad'),
(1758, 536, NULL, 'Supreme Travels / Viqar', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Supreme Travels / Viqar'),
(1759, 536, NULL, 'Taiba Ghufran Travels & Tours-Mr Ghufran', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Taiba Ghufran Travels & Tours-Mr Ghufran'),
(1760, 536, NULL, 'Taibah Borshad Tours & Travels-Selim', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Taibah Borshad Tours & Travels-Selim'),
(1761, 536, NULL, 'Tamanna Travels-Md Mamun Vai', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Tamanna Travels-Md Mamun Vai'),
(1762, 536, NULL, 'Tasfique Travels-Mr Samrat', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Tasfique Travels-Mr Samrat'),
(1763, 536, NULL, 'Tayyab Pakistan', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Tayyab Pakistan'),
(1764, 536, NULL, 'Techno Travels & Tours-Shah Alam', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Techno Travels & Tours-Shah Alam'),
(1765, 536, NULL, 'The Heaven Tours & Travels-Aziz Bhai', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'The Heaven Tours & Travels-Aziz Bhai'),
(1766, 536, NULL, 'The Rafi Travels & Tours-Abdul Halim Raf', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'The Rafi Travels & Tours-Abdul Halim Raf'),
(1767, 536, NULL, 'Tilal khan', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Tilal khan'),
(1768, 536, NULL, 'Tour D Care/ Belal Vai', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Tour D Care/ Belal Vai'),
(1769, 536, NULL, 'Travel Brand Shahzad', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Travel Brand Shahzad'),
(1770, 536, NULL, 'Travel Brand Shahzad /Personal', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Travel Brand Shahzad /Personal'),
(1771, 536, NULL, 'Tripshop', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Tripshop'),
(1772, 536, NULL, 'Tofazzol Hossain', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Tofazzol Hossain'),
(1773, 536, NULL, 'UFA Enterprises-Md Ezaz', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'UFA Enterprises-Md Ezaz'),
(1774, 536, NULL, 'U-Travels-Mr Farhan', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'U-Travels-Mr Farhan'),
(1775, 536, NULL, 'Wadiyar Al Madina/Zulpiqar', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Wadiyar Al Madina/Zulpiqar'),
(1776, 536, NULL, 'Wahid Tours & Travels', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Wahid Tours & Travels'),
(1777, 536, NULL, 'Waqar e madinah', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Waqar e madinah'),
(1778, 536, NULL, 'Waqas International Travel (Pvt) Ltd-Sai', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Waqas International Travel (Pvt) Ltd-Sai'),
(1779, 536, NULL, 'Wasim Bakar-India', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Wasim Bakar-India'),
(1780, 536, NULL, 'Wat-World Aviation Travels & Tours-Rana ', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Wat-World Aviation Travels & Tours-Rana '),
(1781, 536, NULL, 'Welfare Tours & Travels/Hamidul Islam', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Welfare Tours & Travels/Hamidul Islam'),
(1782, 536, NULL, 'Yamany International/Abu Bokkor', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Yamany International/Abu Bokkor'),
(1783, 536, NULL, 'Yanus personal', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Yanus personal'),
(1784, 536, NULL, 'Yaqoob Hussain International', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Yaqoob Hussain International'),
(1785, 536, NULL, 'Yaseen Parsonal Al Hunain', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Yaseen Parsonal Al Hunain'),
(1786, 536, NULL, 'Yaseen Travels ', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Yaseen Travels '),
(1787, 536, NULL, 'Yaseen/Nawabsah', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Yaseen/Nawabsah'),
(1788, 536, NULL, 'Yasir Travels-Sajed', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Yasir Travels-Sajed'),
(1789, 536, NULL, 'Shop', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Shop'),
(1790, 536, NULL, 'Rent Receivables', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-18', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'Rent Receivables'),
(1791, 652, NULL, 'Test Name', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-20', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020102', 0, 0, 0, '', NULL, 1, 0, 0, 'Test Customer Name'),
(1792, 654, NULL, 'Test charge 2', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-21', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '400002021', 0, 0, 0, '', NULL, 1, 0, 0, 'Test charge 2'),
(1793, 654, NULL, 'Charge details 1', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-21', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '400002022', 0, 0, 0, '', NULL, 1, 0, 0, 'Charge details 1'),
(1794, 654, NULL, 'charge 3', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-21', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '400002023', 0, 0, 0, '', NULL, 1, 0, 0, 'charge 3'),
(1795, 654, NULL, 'charge 4', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-21', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '400002024', 0, 0, 0, '', NULL, 1, 0, 0, 'charge 4'),
(1796, 536, NULL, 'test customer', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-21', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '100002020101', 0, 0, 0, '', NULL, 1, 0, 0, 'test customer'),
(1797, 536, NULL, 'test customer 2', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-21', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '1000020201013', 0, 0, 0, '', NULL, 1, 0, 0, 'test customer 2'),
(1798, 536, NULL, 'test customer 3', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-21', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '1000020201014', 0, 0, 0, '', NULL, 1, 0, 0, 'test customer 3'),
(1799, 536, NULL, 'test 4', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-21', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '1000020201015', 0, 0, 0, '', NULL, 1, 0, 0, 'test 4'),
(1800, 578, NULL, 'test vendor 1', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-21', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '2000020101012', 0, 0, 0, '', NULL, 1, 0, 0, 'test vendor 1'),
(1801, 578, NULL, 'test vendor 2', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-21', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '2000020101013', 0, 0, 0, '', NULL, 1, 0, 0, 'test vendor 2'),
(1802, 654, NULL, 'Laundry', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-21', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '400002025', 0, 0, 0, '', NULL, 1, 0, 0, 'Laundry'),
(1803, 654, NULL, 'Electricity Charge', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-23', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '400002026', 0, 0, 0, '', NULL, 1, 0, 0, 'Electricity Charge'),
(1804, 654, NULL, 'Water Charge', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-23', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '400002027', 0, 0, 0, '', NULL, 1, 0, 0, 'Water Charge'),
(1805, 654, NULL, 'Laundry', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-23', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '400002028', 0, 0, 0, '', NULL, 1, 0, 0, 'Laundry'),
(1806, 654, NULL, 'Swimming Pool', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-23', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '400002029', 0, 0, 0, '', NULL, 1, 0, 0, 'Swimming Pool'),
(1807, 654, NULL, 'Parking', NULL, NULL, NULL, NULL, NULL, '0', '2021-03-23', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '4000020210', 0, 0, 0, '', NULL, 1, 0, 0, 'Parking'),
(1808, 77, NULL, 'Goods Supplier', NULL, NULL, NULL, NULL, NULL, '0', '2021-04-15', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '20000201011', 0, 0, 0, '', NULL, 1, 0, 0, 'Goods Supplier'),
(1809, 578, NULL, 'Test Vendor (Trade)', NULL, NULL, NULL, NULL, NULL, '0', '2021-04-16', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '2000020101014', 0, 0, 0, '', NULL, 1, 0, 0, 'Test Vendor (Trade)'),
(1810, 578, NULL, 'test 5-01-posting ledger', NULL, NULL, NULL, NULL, NULL, '0', '2021-04-22', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '2000020101015', 0, 0, 0, '', NULL, 1, 0, 0, 'test 5-01-posting ledger'),
(1811, 578, NULL, 'Abdul Karim-Vendor', NULL, NULL, NULL, NULL, NULL, '0', '2021-04-24', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '2000020101016', 0, 0, 0, '', NULL, 1, 0, 0, 'Abdul Karim-Vendor'),
(1812, 652, NULL, 'Acc Demo Agent Cash', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-04-28 12:58:44', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '1000020201022', 500, 0, 0, '', NULL, 1, 0, 0, 'Acc Demo Agent Cash'),
(1813, 652, NULL, 'Acc Demo Agent Credit', NULL, NULL, NULL, NULL, NULL, '0', NULL, '2021-04-28 12:59:07', '', '1', 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '1000020201023', 501, 0, 0, '', NULL, 1, 0, 0, 'Acc Demo Agent Credit'),
(1814, 654, NULL, 'Parking Bill Test', NULL, NULL, NULL, NULL, NULL, '0', '2021-04-28', NULL, NULL, '1', 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '4000020211', 0, 0, 0, '', NULL, 1, 0, 0, 'Parking Bill Test');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `ledger`
--
ALTER TABLE `ledger`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `ledger`
--
ALTER TABLE `ledger`
  MODIFY `id` int(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1815;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
