-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `ctgstall_pos_max_db`
--

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

--
-- Table structure for table `accounts_expense`
--

CREATE TABLE `accounts_expense` (
  `id` varchar(15) NOT NULL,
  `name` varchar(25) NOT NULL,
  `cash` int(10) NOT NULL,
  `bank` int(10) NOT NULL,
  `bank_id` int(5) NOT NULL,
  `cheque_no` varchar(15) NOT NULL,
  `cheque_date` varchar(20) NOT NULL,
  `sector` int(5) NOT NULL,
  `description` varchar(50) NOT NULL,
  `date` varchar(20) NOT NULL,
  `branch_id` int(2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `bank_name`
--

CREATE TABLE `bank_name` (
  `bank_id` int(5) NOT NULL,
  `bank_name` varchar(20) NOT NULL,
  `ac_no` varchar(30) NOT NULL,
  `balance` int(30) NOT NULL,
  `branch_id` int(2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `bank_name`
--

INSERT INTO `bank_name` (`bank_id`, `bank_name`, `ac_no`, `balance`, `branch_id`) VALUES
(1, 'City Bank', '178190000966', 100000, 0);

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

--
-- Table structure for table `bank_name_lc`
--

CREATE TABLE `bank_name_lc` (
  `bank_id` int(5) NOT NULL,
  `bank_name_lc` varchar(20) NOT NULL,
  `ac_no` varchar(30) NOT NULL,
  `balance` int(30) NOT NULL,
  `branch_id` int(2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `bank_statement`
--

CREATE TABLE `bank_statement` (
  `bank_statement_id` int(20) NOT NULL,
  `amount` int(20) NOT NULL,
  `ref` varchar(20) NOT NULL,
  `payment_type` varchar(20) NOT NULL,
  `reason` varchar(20) NOT NULL,
  `supplier_id` int(20) NOT NULL,
  `customer_id` int(20) NOT NULL,
  `bank_id` int(20) NOT NULL,
  `cheque_no` varchar(30) NOT NULL,
  `cheque_date` varchar(20) NOT NULL,
  `date` varchar(20) NOT NULL,
  `status` int(1) NOT NULL,
  `branch_id` int(2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `branch`
--

CREATE TABLE `branch` (
  `branch_id` int(2) NOT NULL,
  `branch_name` varchar(30) NOT NULL,
  `email` varchar(30) NOT NULL,
  `mobile` varchar(27) NOT NULL,
  `address` text NOT NULL,
  `website` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `branch`
--

INSERT INTO `branch` (`branch_id`, `branch_name`, `email`, `mobile`, `address`, `website`) VALUES
(1, 'Max Enterprise', 'rminhajur18@gmail.com', '0184-0284080, 01838-161444', '08, A b siddique market 4/a jubilee road chattogram', ''),
(2, 'Hasan Trading', 'rminhajur18@gmail.com', '0184-0284080, 01838-161444', '08, A b siddique market 4/a jubilee road chattogram', '');

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

--
-- Table structure for table `cash`
--

CREATE TABLE `cash` (
  `id` int(5) NOT NULL,
  `cash` int(20) NOT NULL,
  `branch_id` int(2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cash`
--

INSERT INTO `cash` (`id`, `cash`, `branch_id`) VALUES
(1, 6248599, 1);

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

--
-- Table structure for table `concern`
--

CREATE TABLE `concern` (
  `concern_id` int(2) NOT NULL,
  `concern` varchar(30) NOT NULL,
  `branch_id` int(2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `concern`
--

INSERT INTO `concern` (`concern_id`, `concern`, `branch_id`) VALUES
(1, 'Easynet', 1),
(2, 'E-Solution', 1);

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

--
-- Table structure for table `customer_setup`
--

CREATE TABLE `customer_setup` (
  `customer_id` int(50) NOT NULL,
  `customer_name` varchar(200) NOT NULL,
  `address` text NOT NULL,
  `district` varchar(200) NOT NULL,
  `mobile_no` varchar(200) NOT NULL,
  `opening_due` int(10) NOT NULL,
  `due` int(12) NOT NULL,
  `iscustomer` varchar(1) NOT NULL,
  `branch_id` int(2) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `customer_setup`
--

INSERT INTO `customer_setup` (`customer_id`, `customer_name`, `address`, `district`, `mobile_no`, `opening_due`, `due`, `iscustomer`, `branch_id`) VALUES
(1, 'Tasif Trading', 'CDA Market', 'Chattagram', '01837120851', 0, 47370, '', 1),
(2, 'HAMJA ELECTRONICS', 'AHMED LAL MIAH MARKET R BAZAR ', 'CHATTOGRAM', '01868562801', 0, 23000, '', 1),
(3, 'SHAH AMANAT ELECTRONICS', 'RIFLE CLUB ', 'CHATTPGRAM', '01716303351', 0, 70000, '', 1),
(4, 'BHAI BHAI ELECTRONICS', '14 NO MANNAN SHOPPING COMPLEX R BAZAR', 'CHATTOGRAM', '01825293039', 0, 14550, '', 1),
(5, 'ARFAT ELECTRINICS', '10 NO AHMED LAL MEAH MARKET R BAZAR ', 'CHATTOGRAM', '01723443746', 0, 0, '', 1),
(6, 'ABDULLAH ELECTRONICS', 'C D A MARKET R BAZAR', 'CHATTOGRAM', '', 0, 1500, '', 1),
(7, 'NAYEM ENTERPRISE', 'C D A MARKET RBAZAR', 'CHATTOGRAM', '', 0, 700, '', 1),
(13, 'UPAHAR GHAR', 'GOLAM RASUL MARKET', 'CHATTOGRAM', '', 0, 190898, '', 1),
(8, 'MAHIA ELECTRONICS', 'C D A MARKET R BAZAR', 'CHATTOGRAM', '', 0, 430750, '', 1),
(9, 'ICON ELECTRONICS', 'C D A MARKET RBAZAR', 'CHATTOGRAM', '', 0, 12704, '', 1),
(10, 'SHAH AMANAT ELECTRONICS-2', 'ROYEL TOWER', 'CHATTOGRAM', '', 0, 43650, '', 1),
(11, 'HABIB TRADING ', 'NWABPUR ', 'DHAKA', '', 0, 943300, '', 1),
(12, 'R S ELECTRONICS', 'C D A MARKET R BAZAR', 'CHATTOGRAM', '', 0, 100, '', 1),
(14, 'SEBA ELECTRONICS', 'C D A MARKET R BAZAR', 'CHATTOGRAM', '', 0, 0, '', 1),
(15, 'KAMAL ELECTRONICS', 'SALEH MORIUM MARKET R BAZAR', 'CHATTOGRAM', '', 0, 2500, '', 1),
(16, 'BISMILLAH ELECTRONICS', 'C D A MARKET R BAZAR', 'CHATTOGRAM', '', 0, 8150, '', 1),
(17, 'NUR AYESHA ENTERPRISE', 'ROYEL TOWER', 'CHATTOGRAM', '', 0, 29250, '', 1),
(18, 'ABSAR AND BROTHERS', 'C D A MARKET R BAZAR', 'CHATTOGRAM', '', 0, 17400, '', 1),
(20, 'IMTIAZ  ELECTRONICS', 'C D A MARKET R BAZAR', 'CHATTOGRAM', '', 0, 265550, '', 1),
(19, 'A G ELECTRONICS', 'C D A MARKET R BAZAR', 'CHATTOGRAM', '', 0, 0, '', 1),
(21, 'ZAM ZAM ELECTRONICS ', 'C D A MARKET R BAZAR', 'CHATTOGRAM', '', 0, 2400, '', 1),
(22, 'JUNAID STORE', 'C D A MARKET R BAZAR', 'CHATTOGRAM', '', 0, 14500, '', 1),
(24, 'SOHA ELECTRONICS', 'REAZUDDIN BAZAR', 'CHATTOGRAM', '', 0, 50400, '', 1),
(23, 'G M ELECTRONICS', 'C D A MARKET R BAZAR', 'CHATTOGRAM', '', 0, 0, '', 1),
(25, 'FAMAS ELECTRONICS', 'C D A MARKET R BAZAR', 'CHATTOGRAM', '', 0, 13950, '', 1),
(26, 'SHAH MOJIDIA ELECTRONICS', 'C D A MARKET R BAZAR', 'CHATTOGRAM', '', 0, 50, '', 1);

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

--
-- Table structure for table `cus_due_payment`
--

CREATE TABLE `cus_due_payment` (
  `cus_due_payment_id` int(11) NOT NULL,
  `customer_id` int(10) NOT NULL,
  `cash` int(20) NOT NULL,
  `bank` int(20) NOT NULL,
  `cheque_no` varchar(30) NOT NULL,
  `cheque_date` varchar(20) NOT NULL,
  `bank_id` int(5) NOT NULL,
  `invoice_no` varchar(15) NOT NULL,
  `date` varchar(20) NOT NULL,
  `branch_id` int(2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `cus_due_payment`
--

INSERT INTO `cus_due_payment` (`cus_due_payment_id`, `customer_id`, `cash`, `bank`, `cheque_no`, `cheque_date`, `bank_id`, `invoice_no`, `date`, `branch_id`) VALUES
(1, 2, 10800, 0, '', '', 0, 'INV0000000002', '2025-04-13', 0),
(2, 10, 62800, 0, '', '', 0, 'INV0000000007', '2025-04-15', 0),
(3, 3, 30000, 0, '', '', 0, 'INV0000000007', '2025-04-15', 0),
(4, 3, 30000, 0, '', '', 0, '1-INV0000000001', '2025-04-15', 0),
(5, 5, 27000, 0, '', '', 0, 'INV0000000007', '2025-04-15', 0),
(6, 7, 36900, 0, '', '', 0, 'INV0000000007', '2025-04-15', 0),
(7, 2, 22500, 0, '', '', 0, '1-INV0000000007', '2025-04-16', 0),
(8, 6, 133500, 0, '', '', 0, '1-INV0000000007', '2025-04-16', 0),
(9, 3, 22500, 0, '', '', 0, '1-INV0000000001', '2025-04-16', 0),
(10, 2, 22000, 0, '', '', 0, '1-INV0000000007', '2025-04-17', 0),
(11, 14, 39000, 0, '', '', 0, '1-INV0000000007', '2025-04-17', 0),
(12, 12, 21500, 0, '', '', 0, '1-INV0000000007', '2025-04-17', 0),
(13, 10, 33000, 0, '', '', 0, '1-INV0000000007', '2025-04-17', 0),
(14, 2, -22500, 0, '', '', 0, 'vul001', '2025-04-19', 0),
(15, 2, 8800, 0, '', '', 0, '1-INV0000000007', '2025-04-19', 0),
(16, 14, 26400, 0, '', '', 0, '1-INV0000000007', '2025-04-19', 0),
(17, 9, 15000, 0, '', '', 0, '1-INV0000000007', '2025-04-20', 0),
(18, 3, 20000, 0, '', '', 0, '1-INV0000000007', '2025-04-20', 0),
(19, 4, 20000, 0, '', '', 0, '1-INV0000000007', '2025-04-22', 0),
(20, 13, 40000, 0, '', '', 0, '1-INV0000000007', '2025-04-22', 0),
(21, 15, 129000, 0, '', '', 0, '1-INV0000000007', '2025-04-23', 0),
(22, 16, 15000, 0, '', '', 0, '1-INV0000000007', '2025-04-23', 0),
(23, 18, 38700, 0, '', '', 0, '1-INV0000000007', '2025-04-23', 0),
(24, 11, 200000, 0, '', '', 0, '1-INV0000000007', '2025-04-24', 0),
(25, 19, 52000, 0, '', '', 0, '1-INV0000000007', '2025-04-24', 0),
(26, 1, 5000, 0, '', '', 0, '1-INV0000000007', '2025-04-24', 0),
(27, 10, 5000, 0, '', '', 0, '1-INV0000000007', '2025-04-24', 0),
(28, 13, 15500, 0, '', '', 0, '1-INV0000000007', '2025-04-26', 0),
(29, 2, 12900, 0, '', '', 0, '1-INV0000000007', '2025-04-26', 0),
(30, 13, 2, 0, '', '', 0, '1-INV0000000007', '2025-04-26', 0),
(31, 13, 50000, 0, '', '', 0, '1-INV0000000007', '2025-04-26', 0),
(32, 18, 20000, 0, '', '', 0, '1-INV0000000007', '2025-04-27', 0),
(33, 16, 16500, 0, '', '', 0, '1-INV0000000007', '2025-04-27', 0),
(34, 18, 24400, 0, '', '', 0, '1-INV0000000007', '2025-04-29', 0),
(35, 9, 10000, 0, '', '', 0, '1-INV0000000007', '2025-04-29', 0),
(36, 12, 12900, 0, '', '', 0, '1-INV0000000007', '2025-04-29', 0),
(37, 10, 15000, 0, '', '', 0, '1-INV0000000007', '2025-04-29', 0),
(38, 1, 5600, 0, '', '', 0, '1-INV0000000007', '2025-04-29', 0),
(39, 21, 23700, 0, '', '', 0, '1-INV0000000007', '2025-04-29', 0),
(40, 3, 15000, 0, '', '', 0, '1-INV0000000007', '2025-04-30', 0),
(41, 10, 8000, 0, '', '', 0, '1-INV0000000007', '2025-04-30', 0),
(42, 13, 30000, 0, '', '', 0, '1-INV0000000007', '2025-05-04', 0),
(43, 14, 46200, 0, '', '', 0, '1-INV0000000007', '2025-05-04', 0),
(44, 2, 10600, 0, '', '', 0, '1-INV0000000007', '2025-05-05', 0),
(45, 23, 12600, 0, '', '', 0, '1-INV0000000007', '2025-05-05', 0),
(46, 20, 315000, 0, '', '', 0, '1-INV0000000007', '2025-05-05', 0),
(47, 18, 30000, 0, '', '', 0, '1-INV0000000007', '2025-05-05', 0),
(48, 9, 6600, 0, '', '', 0, '1-INV0000000007', '2025-05-05', 0),
(49, 22, 61200, 0, '', '', 0, '1-INV0000000007', '2025-05-05', 0),
(50, 10, 15000, 0, '', '', 0, '1-INV0000000007', '2025-05-06', 0),
(51, 1, 5000, 0, '', '', 0, '1-INV0000000007', '2025-05-06', 0),
(52, 3, 20000, 0, '', '', 0, '1-INV0000000007', '2025-05-06', 0),
(53, 8, 20000, 0, '', '', 0, '1-INV0000000007', '2025-05-07', 0),
(54, 18, 26500, 0, '', '', 0, '1-INV0000000007', '2025-05-07', 0),
(55, 14, 25200, 0, '', '', 0, '1-INV0000000007', '2025-05-10', 0),
(56, 17, 10000, 0, '', '', 0, '1-INV0000000007', '2025-05-10', 0),
(57, 18, 50000, 0, '', '', 0, '1-INV0000000007', '2025-05-10', 0),
(58, 10, 30000, 0, '', '', 0, '1-INV0000000007', '2025-05-10', 0),
(59, 1, 5600, 0, '', '', 0, '1-INV0000000007', '2025-05-10', 0),
(60, 18, 50000, 0, '', '', 0, '1-INV0000000007', '2025-05-11', 0),
(61, 2, 12600, 0, '', '', 0, '1-INV0000000007', '2025-05-11', 0),
(62, 14, 35600, 0, '', '', 0, '1-INV0000000007', '2025-05-11', 0),
(63, 10, 30000, 0, '', '', 0, '1-INV0000000007', '2025-05-11', 0),
(64, 3, 25000, 0, '', '', 0, '1-INV0000000007', '2025-05-11', 0),
(65, 24, 15000, 0, '', '', 0, '1-INV0000000007', '2025-05-11', 0),
(66, 10, 20000, 0, '', '', 0, '1-INV0000000007', '2025-05-14', 0),
(67, 11, 250000, 0, '', '', 0, '1-INV0000000007', '2025-05-14', 0),
(68, 4, 30000, 0, '', '', 0, '1-INV0000000007', '2025-05-14', 0),
(69, 20, 729000, 0, '', '', 0, '1-INV0000000007', '2025-05-14', 0),
(70, 15, 189000, 0, '', '', 0, '1-INV0000000007', '2025-05-14', 0),
(71, 19, 75000, 0, '', '', 0, '1-INV0000000007', '2025-05-14', 0),
(72, 22, 63000, 0, '', '', 0, '1-INV0000000007', '2025-05-14', 0),
(73, 20, 865050, 0, '', '', 0, '1-INV0000000007', '2025-05-14', 0),
(74, 16, 25000, 0, '', '', 0, '1-INV0000000007', '2025-05-14', 0),
(75, 8, 25000, 0, '', '', 0, '1-INV0000000007', '2025-05-14', 0),
(76, 12, 25200, 0, '', '', 0, '1-INV0000000007', '2025-05-14', 0),
(77, 24, 10200, 0, '', '', 0, '1-INV0000000007', '2025-05-14', 0),
(78, 13, 70000, 0, '', '', 0, '1-INV0000000007', '2025-05-14', 0),
(79, 3, 20000, 0, '', '', 0, '1-INV0000000007', '2025-05-15', 0),
(80, 8, 20000, 0, '', '', 0, '1-INV0000000007', '2025-05-15', 0),
(81, 18, 50000, 0, '', '', 0, '1-INV0000000007', '2025-05-15', 0),
(82, 25, 12450, 0, '', '', 0, '1-INV0000000007', '2025-05-15', 0),
(83, 2, 15000, 0, '', '', 0, '1-INV0000000007', '2025-05-18', 0),
(84, 10, 15000, 0, '', '', 0, '1-INV0000000007', '2025-05-18', 0),
(85, 18, 10000, 0, '', '', 0, '1-INV0000000007', '2025-05-19', 0),
(86, 16, 20000, 0, '', '', 0, '1-INV0000000007', '2025-05-19', 0),
(87, 2, 10500, 0, '', '', 0, '1-INV0000000007', '2025-05-19', 0),
(88, 17, 26400, 0, '', '', 0, '1-INV0000000007', '2025-05-19', 0),
(89, 10, 10000, 0, '', '', 0, '1-INV0000000007', '2025-05-19', 0),
(90, 1, 45000, 0, '', '', 0, '1-INV0000000007', '2025-05-19', 0),
(91, 2, 10000, 0, '', '', 0, '1-INV0000000007', '2025-05-19', 0),
(92, 15, 311000, 0, '', '', 0, '1-INV0000000007', '2025-05-19', 0),
(93, 25, 30000, 0, '', '', 0, '1-INV0000000007', '2025-05-19', 0),
(94, 8, 45000, 0, '', '', 0, '1-INV0000000007', '2025-05-19', 0),
(95, 7, 30000, 0, '', '', 0, '1-INV0000000007', '2025-05-19', 0),
(96, 18, 30000, 0, '', '', 0, '1-INV0000000007', '2025-05-20', 0),
(97, 9, 20000, 0, '', '', 0, '1-INV0000000007', '2025-05-21', 0),
(98, 22, 20000, 0, '', '', 0, '1-INV0000000007', '2025-05-21', 0),
(99, 12, 24900, 0, '', '', 0, '1-INV0000000007', '2025-05-21', 0),
(100, 10, 8000, 0, '', '', 0, '1-INV0000000007', '2025-05-21', 0),
(101, 25, 7350, 0, '', '', 0, '1-INV0000000007', '2025-05-24', 0),
(102, 3, 20000, 0, '', '', 0, '1-INV0000000007', '2025-05-24', 0),
(103, 1, 10000, 0, '', '', 0, '1-INV0000000007', '2025-05-24', 0),
(104, 18, 20000, 0, '', '', 0, '1-INV0000000007', '2025-05-25', 0),
(105, 9, 20000, 0, '', '', 0, '1-INV0000000007', '2025-05-25', 0),
(106, 20, 300000, 0, '', '', 0, '1-INV0000000007', '2025-05-26', 0),
(107, 10, 5000, 0, '', '', 0, '1-INV0000000007', '2025-05-26', 0),
(108, 22, 10000, 0, '', '', 0, '1-INV0000000007', '2025-05-26', 0),
(109, 7, 14900, 0, '', '', 0, '1-INV0000000007', '2025-05-28', 0),
(110, 18, 1000, 0, '', '', 0, '1-INV0000000007', '2025-05-29', 0),
(111, 18, 9000, 0, '', '', 0, '1-INV0000000007', '2025-05-29', 0),
(112, 16, 10000, 0, '', '', 0, '1-INV0000000007', '2025-06-02', 0),
(113, 1, 10000, 0, '', '', 0, '1-INV0000000007', '2025-06-02', 0),
(114, 4, 15000, 0, '', '', 0, '1-INV0000000007', '2025-06-05', 0),
(115, 22, 5000, 0, '', '', 0, '1-INV0000000007', '2025-06-05', 0),
(116, 13, 50000, 0, '', '', 0, '1-INV0000000007', '2025-06-21', 0),
(117, 18, 12500, 0, '', '', 0, '1-INV0000000007', '2025-06-21', 0),
(118, 17, 10000, 0, '', '', 0, '1-INV0000000007', '2025-06-21', 0),
(119, 3, 15000, 0, '', '', 0, '1-INV0000000007', '2025-06-21', 0),
(120, 20, 322000, 0, '', '', 0, '1-INV0000000007', '2025-06-22', 0),
(121, 4, 20000, 0, '', '', 0, '1-INV0000000007', '2025-06-23', 0),
(122, 16, 7200, 0, '', '', 0, '1-INV0000000007', '2025-06-23', 0),
(123, 9, 10000, 0, '', '', 0, '1-INV0000000007', '2025-06-23', 0),
(124, 1, 16880, 0, '', '', 0, '1-INV0000000007', '2025-06-23', 0),
(125, 22, 10000, 0, '', '', 0, '1-INV0000000007', '2025-06-25', 0),
(126, 18, 15000, 0, '', '', 0, '1-INV0000000007', '2025-06-28', 0),
(127, 3, 20000, 0, '', '', 0, '1-INV0000000007', '2025-06-28', 0),
(128, 11, 50000, 0, '', '', 0, '1-INV0000000007', '2025-06-29', 0),
(129, 13, 25000, 0, '', '', 0, '1-INV0000000007', '2025-06-29', 0),
(130, 18, 12900, 0, '', '', 0, '1-INV0000000007', '2025-07-02', 0),
(131, 26, 10000, 0, '', '', 0, '1-INV0000000007', '2025-07-02', 0),
(132, 8, 10000, 0, '', '', 0, '1-INV0000000007', '2025-07-02', 0),
(133, 1, 10000, 0, '', '', 0, '1-INV0000000007', '2025-07-02', 0),
(134, 3, 10000, 0, '', '', 0, '1-INV0000000007', '2025-07-07', 0),
(135, 26, 3900, 0, '', '', 0, '1-INV0000000007', '2025-07-07', 0),
(136, 14, 10000, 0, '', '', 0, '1-INV0000000007', '2025-07-07', 0),
(137, 17, 10000, 0, '', '', 0, '1-INV0000000007', '2025-07-08', 0),
(138, 14, 3950, 0, '', '', 0, '1-INV0000000007', '2025-07-08', 0),
(139, 22, 5000, 0, '', '', 0, '1-INV0000000007', '2025-07-09', 0),
(140, 4, 10000, 0, '', '', 0, '1-INV0000000007', '2025-07-12', 0),
(141, 2, 15000, 0, '', '', 0, '1-INV0000000007', '2025-07-13', 0),
(142, 3, 10000, 0, '', '', 0, '1-INV0000000007', '2025-07-13', 0),
(143, 20, 27900, 0, '', '', 0, '1-INV0000000007', '2025-07-13', 0),
(144, 22, 7000, 0, '', '', 0, '1-INV0000000007', '2025-07-16', 0),
(145, 2, 9800, 0, '', '', 0, '1-INV0000000007', '2025-07-16', 0),
(146, 8, 7000, 0, '', '', 0, '1-INV0000000007', '2025-07-16', 0),
(147, 10, 5000, 0, '', '', 0, '1-INV0000000007', '2025-07-22', 0),
(148, 9, 10800, 0, '', '', 0, '1-INV0000000007', '2025-07-22', 0),
(149, 13, 10000, 0, '', '', 0, '1-INV0000000007', '2025-07-22', 0),
(150, 3, 10000, 0, '', '', 0, '1-INV0000000007', '2025-07-23', 0),
(151, 22, 5000, 0, '', '', 0, '1-INV0000000007', '2025-07-23', 0),
(152, 4, 10000, 0, '', '', 0, '1-INV0000000007', '2025-07-23', 0);

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

--
-- Table structure for table `expense_sector`
--

CREATE TABLE `expense_sector` (
  `id` int(5) NOT NULL,
  `sector` varchar(20) NOT NULL,
  `branch_id` int(2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `expense_sector`
--

INSERT INTO `expense_sector` (`id`, `sector`, `branch_id`) VALUES
(1, 'Entertainment', 1),
(2, 'Staff Salary', 1),
(3, 'Service Charge', 1),
(4, 'Electric Bill', 1),
(5, 'House Rent', 1),
(6, 'Conveyance', 1),
(7, 'Transport Cost', 1),
(8, 'Travell Cost', 1),
(10, 'Stationary', 1),
(11, 'Other', 1),
(12, 'Daily Salary', 1),
(13, 'Commission', 1),
(14, 'Pickup', 1),
(15, 'Car', 1),
(16, 'Tampo', 1),
(17, 'Network Accessories', 1),
(18, 'T & T , Mobile bill', 1),
(19, 'Fuel Expense', 1),
(20, 'Electric Goods', 1),
(21, 'Paper Bill', 1),
(22, ' Assets for Easy net', 1),
(23, 'Dark Fiber Rent', 1),
(24, 'Feeding Alowance', 1),
(25, 'Miss Expense ', 1),
(26, 'IP Phone set', 1),
(27, 'Donation/ Gift', 1),
(28, 'Computer Accessories', 1);

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

--
-- Table structure for table `lc`
--

CREATE TABLE `lc` (
  `lc_id` int(12) NOT NULL,
  `product_id` int(12) NOT NULL,
  `quantity` int(12) NOT NULL,
  `buying_price` decimal(12,2) NOT NULL,
  `selling_price` decimal(12,2) NOT NULL,
  `lc_number` varchar(25) NOT NULL,
  `status` int(1) NOT NULL,
  `branch_id` int(2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `lc_taka`
--

CREATE TABLE `lc_taka` (
  `lc_taka_id` int(12) NOT NULL,
  `lc_balance` decimal(10,2) NOT NULL,
  `lc_margin_per` int(2) NOT NULL,
  `lc_margin` int(10) NOT NULL,
  `dollar_rate` decimal(5,2) NOT NULL,
  `lc_due` decimal(10,2) NOT NULL,
  `supplier_id` int(5) NOT NULL,
  `lc_number` varchar(25) NOT NULL,
  `farm_name` varchar(25) NOT NULL,
  `bank_id` int(5) NOT NULL,
  `date` varchar(20) NOT NULL,
  `first_time` int(1) NOT NULL,
  `status` int(1) NOT NULL,
  `branch_id` int(2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `loan_bank_name`
--

CREATE TABLE `loan_bank_name` (
  `loan_bank_name_id` int(2) NOT NULL,
  `loan_bank_name` varchar(50) NOT NULL,
  `ac_no` varchar(50) NOT NULL,
  `total_loan` int(30) NOT NULL,
  `branch_id` int(2) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `loan_list`
--

CREATE TABLE `loan_list` (
  `loan_list_id` int(50) NOT NULL,
  `loan_bank_id` int(2) NOT NULL,
  `withdraw` int(30) NOT NULL DEFAULT 0,
  `paid` int(30) NOT NULL DEFAULT 0,
  `date` varchar(20) NOT NULL,
  `branch_id` int(2) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `particulars`
--

CREATE TABLE `particulars` (
  `particulars_id` int(5) NOT NULL,
  `particulars` varchar(50) NOT NULL,
  `branch_id` int(2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `particulars`
--

INSERT INTO `particulars` (`particulars_id`, `particulars`, `branch_id`) VALUES
(1, 'Supplier Primary Due', 0),
(2, 'Customer Primary Due', 0),
(3, 'Supplier Due Paid', 0),
(4, 'Buy Product From Supplier', 0),
(5, 'Buy Product From Supplier In Due', 0),
(6, 'Customer Opening Due Payment', 0),
(7, 'Customer Due Payment', 0),
(8, 'Primary Balance', 0),
(9, 'Product Sale', 0),
(10, 'Expense', 0),
(11, 'Cash to Bank Transfer', 0),
(12, 'Bank to Cash Transfer', 0),
(13, 'Customer Check Bounce', 0),
(14, 'Bank Primary Balance', 0),
(15, 'Bank to Bank Transfer', 0),
(16, 'Internet Bill', 0),
(17, 'A M Computer', 0),
(18, 'National Electrics', 0),
(19, 'L B Trading Co', 0),
(20, 'Connection Fee', 0),
(21, 'Splice Bill', 0),
(23, 'Fooding Allowance ', 0),
(25, 'Conveyance', 0),
(26, 'Office Expense', 0),
(27, 'Network Accessories', 0),
(28, 'Office Rent', 0),
(29, 'Pop Rent', 0),
(30, 'Getco Online Ltd', 0),
(31, 'Ip hone Card sale', 0),
(32, 'Domain Hosting', 0),
(33, 'CCTV  Camera/ Account Payable', 0),
(34, 'Student collection', 0),
(35, 'Spayer zone', 0),
(36, 'Mr Nazmul Hoque', 0),
(37, 'Account Payable', 0),
(38, 'Vat & Tax', 0),
(39, 'Account Receivable ', 0),
(40, 'Labor  Bill', 0);

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

--
-- Table structure for table `present_stock`
--

CREATE TABLE `present_stock` (
  `present_stock_id` int(100) NOT NULL,
  `product_id` int(50) NOT NULL,
  `present_stock` decimal(50,3) NOT NULL,
  `branch_id` int(2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `present_stock`
--

INSERT INTO `present_stock` (`present_stock_id`, `product_id`, `present_stock`, `branch_id`) VALUES
(1, 1, 880.000, 1),
(2, 1, 820.000, 2),
(3, 2, 584.000, 1),
(4, 2, 0.000, 2),
(5, 3, 1064.000, 1),
(6, 3, 0.000, 2),
(7, 4, 3.000, 1),
(8, 4, 0.000, 2),
(9, 5, 4590.000, 1),
(10, 5, 0.000, 2),
(11, 6, 5670.000, 1),
(12, 6, 0.000, 2),
(13, 7, 0.000, 1),
(14, 7, 0.000, 2);

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

--
-- Table structure for table `product_setup`
--

CREATE TABLE `product_setup` (
  `product_id` int(11) NOT NULL,
  `barcode` varchar(25) NOT NULL,
  `product_name` varchar(200) NOT NULL,
  `buy_price` decimal(20,3) NOT NULL DEFAULT 0.000,
  `selling_price` decimal(20,3) NOT NULL DEFAULT 0.000,
  `unit_id` int(10) NOT NULL DEFAULT 0,
  `unit_type_id` int(10) NOT NULL,
  `per_sack_weight` int(10) NOT NULL,
  `stock_limit` int(5) NOT NULL,
  `branch_id` int(2) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `product_setup`
--

INSERT INTO `product_setup` (`product_id`, `barcode`, `product_name`, `buy_price`, `selling_price`, `unit_id`, `unit_type_id`, `per_sack_weight`, `stock_limit`, `branch_id`) VALUES
(1, 'DF5203', 'DEPENDER-DF5203', 1000.000, 1050.000, 0, 3, 0, 10, 0),
(2, 'KN2912', 'KENNEDE-KN2912', 2500.000, 2700.000, 0, 3, 0, 10, 0),
(3, 'KN2686', 'KENNEDE-KN2986', 4150.000, 4500.000, 0, 3, 0, 10, 0),
(4, 'KN2926', 'KENNEDE-KN2926', 3750.000, 4200.000, 0, 3, 0, 9, 0),
(5, 'JY2218', 'JYSUPER-JY2218', 900.000, 900.000, 0, 3, 0, 10, 0),
(6, 'WD-219', 'WD -219', 905.000, 950.000, 0, 3, 0, 0, 0),
(7, 'BAJAJ+15W', 'BAJAJ+15W', 3375.000, 3400.000, 0, 3, 0, 0, 0);

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

--
-- Table structure for table `sale`
--

CREATE TABLE `sale` (
  `sale_id` int(100) NOT NULL,
  `product_id` int(20) NOT NULL,
  `quantity` decimal(20,2) NOT NULL,
  `m_quantity` int(11) NOT NULL,
  `buy_price` decimal(20,2) NOT NULL,
  `selling_price` decimal(20,2) NOT NULL,
  `status` varchar(15) NOT NULL,
  `invoice_no` varchar(30) NOT NULL,
  `date` varchar(20) NOT NULL,
  `unit_id` int(10) NOT NULL,
  `carton` int(10) NOT NULL,
  `packate` int(10) NOT NULL,
  `transport_cost` int(5) NOT NULL,
  `user_id` int(12) NOT NULL,
  `branch_id` int(2) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `sale`
--

INSERT INTO `sale` (`sale_id`, `product_id`, `quantity`, `m_quantity`, `buy_price`, `selling_price`, `status`, `invoice_no`, `date`, `unit_id`, `carton`, `packate`, `transport_cost`, `user_id`, `branch_id`) VALUES
(3, 3, 15.00, 0, 4150.00, 4500.00, 'complete', '1-INV0000000001', '2025-04-13', 0, 0, 0, 0, 1, 1),
(4, 4, 6.00, 0, 3750.00, 4200.00, 'complete', '1-INV0000000001', '2025-04-13', 0, 0, 0, 0, 1, 1),
(5, 2, 4.00, 0, 2500.00, 2700.00, 'complete', '1-INV0000000002', '2025-04-13', 0, 0, 0, 0, 1, 1),
(7, 3, 6.00, 0, 4150.00, 4500.00, 'complete', '1-INV0000000003', '2025-04-14', 0, 0, 0, 0, 1, 1),
(8, 3, 30.00, 0, 4150.00, 4500.00, 'complete', '1-INV0000000004', '2025-04-14', 0, 0, 0, 0, 1, 1),
(12, 4, 3.00, 0, 3750.00, 4200.00, 'complete', '1-INV0000000005', '2025-04-14', 0, 0, 0, 0, 1, 1),
(11, 2, 4.00, 0, 2500.00, 2700.00, 'complete', '1-INV0000000005', '2025-04-14', 0, 0, 0, 0, 1, 1),
(13, 0, 0.00, 0, 0.00, 0.00, 'complete', '1-INV0000000005', '2025-04-14', 0, 0, 0, 0, 1, 1),
(14, 3, 3.00, 0, 4150.00, 4500.00, 'complete', '1-INV0000000005', '2025-04-14', 0, 0, 0, 0, 1, 1),
(15, 3, 15.00, 0, 4150.00, 4500.00, 'complete', '1-INV0000000006', '2025-04-14', 0, 0, 0, 0, 1, 1),
(16, 4, 9.00, 0, 3750.00, 4200.00, 'complete', '1-INV0000000006', '2025-04-14', 0, 0, 0, 0, 1, 1),
(30, 4, 6.00, 0, 3750.00, 4200.00, 'complete', '1-INV0000000009', '2025-04-14', 0, 0, 0, 0, 1, 1),
(61, 4, 3.00, 0, 3750.00, 4200.00, 'complete', '1-INV0000000021', '2025-04-19', 0, 0, 0, 0, 1, 1),
(29, 2, 4.00, 0, 2500.00, 2700.00, 'complete', '1-INV0000000009', '2025-04-14', 0, 0, 0, 0, 1, 1),
(42, 4, 6.00, 0, 3750.00, 4200.00, 'complete', '1-INV0000000012', '2025-04-16', 0, 0, 0, 0, 1, 1),
(60, 3, 6.00, 0, 4150.00, 4500.00, 'complete', '1-INV0000000021', '2025-04-19', 0, 0, 0, 0, 1, 1),
(32, 5, 30.00, 0, 900.00, 740.00, 'complete', '1-INV0000000010', '2025-04-15', 0, 0, 0, 0, 1, 1),
(31, 3, 6.00, 0, 4150.00, 4500.00, 'complete', '1-INV0000000009', '2025-04-14', 0, 0, 0, 0, 1, 1),
(37, 2, 8.00, 0, 2500.00, 2700.00, 'complete', '1-INV0000000011', '2025-04-16', 0, 0, 0, 0, 1, 1),
(41, 3, 9.00, 0, 4150.00, 4500.00, 'complete', '1-INV0000000012', '2025-04-16', 0, 0, 0, 0, 1, 1),
(43, 5, 30.00, 0, 900.00, 750.00, 'complete', '1-INV0000000013', '2025-04-16', 0, 0, 0, 0, 1, 1),
(44, 3, 2.00, 0, 4150.00, 4400.00, 'complete', '1-INV0000000014', '2025-04-16', 0, 0, 0, 0, 1, 1),
(45, 5, 30.00, 0, 900.00, 740.00, 'complete', '1-INV0000000014', '2025-04-16', 0, 0, 0, 0, 1, 1),
(62, 2, 4.00, 0, 2500.00, 2650.00, 'complete', '1-INV0000000022', '2025-04-19', 0, 0, 0, 0, 1, 1),
(56, 3, 90.00, 0, 4150.00, 4300.00, 'complete', '1-INV0000000019', '2025-04-19', 0, 0, 0, 0, 1, 1),
(55, 4, 30.00, 0, 3750.00, 4100.00, 'complete', '1-INV0000000019', '2025-04-19', 0, 0, 0, 0, 1, 1),
(50, 3, 6.00, 0, 4150.00, 4400.00, 'complete', '1-INV0000000016', '2025-04-17', 0, 0, 0, 0, 1, 1),
(51, 4, 3.00, 0, 3750.00, 4200.00, 'complete', '1-INV0000000016', '2025-04-17', 0, 0, 0, 0, 1, 1),
(53, 2, 4.00, 0, 2500.00, 2650.00, 'complete', '1-INV0000000017', '2025-04-17', 0, 0, 0, 0, 1, 1),
(54, 3, 6.00, 0, 4150.00, 4400.00, 'complete', '1-INV0000000018', '2025-04-19', 0, 0, 0, 0, 1, 1),
(58, 5, 30.00, 0, 900.00, 740.00, 'complete', '1-INV0000000020', '2025-04-19', 0, 0, 0, 0, 1, 1),
(63, 3, 18.00, 0, 4150.00, 4400.00, 'complete', '1-INV0000000023', '2025-04-19', 0, 0, 0, 0, 1, 1),
(64, 4, 6.00, 0, 3750.00, 4200.00, 'complete', '1-INV0000000023', '2025-04-19', 0, 0, 0, 0, 1, 1),
(65, 2, 8.00, 0, 2500.00, 2650.00, 'complete', '1-INV0000000023', '2025-04-19', 0, 0, 0, 0, 1, 1),
(66, 4, 6.00, 0, 3750.00, 4100.00, 'complete', '1-INV0000000024', '2025-04-21', 0, 0, 0, 0, 1, 1),
(67, 3, 15.00, 0, 4150.00, 4300.00, 'complete', '1-INV0000000024', '2025-04-21', 0, 0, 0, 0, 1, 1),
(68, 3, 30.00, 0, 4150.00, 4300.00, 'complete', '1-INV0000000025', '2025-04-21', 0, 0, 0, 0, 1, 1),
(69, 3, 9.00, 0, 4150.00, 4400.00, 'complete', '1-INV0000000026', '2025-04-21', 0, 0, 0, 0, 1, 1),
(70, 2, 4.00, 0, 2500.00, 2650.00, 'complete', '1-INV0000000027', '2025-04-21', 0, 0, 0, 0, 1, 1),
(71, 3, 3.00, 0, 4150.00, 4400.00, 'complete', '1-INV0000000027', '2025-04-21', 0, 0, 0, 0, 1, 1),
(72, 4, 3.00, 0, 3750.00, 4200.00, 'complete', '1-INV0000000027', '2025-04-21', 0, 0, 0, 0, 1, 1),
(73, 2, 4.00, 0, 2500.00, 2650.00, 'complete', '1-INV0000000028', '2025-04-22', 0, 0, 0, 0, 1, 1),
(74, 3, 9.00, 0, 4150.00, 4300.00, 'complete', '1-INV0000000029', '2025-04-23', 0, 0, 0, 0, 1, 1),
(75, 3, 3.00, 0, 4150.00, 4350.00, 'complete', '1-INV0000000030', '2025-04-23', 0, 0, 0, 0, 1, 1),
(76, 2, 20.00, 0, 2500.00, 2600.00, 'complete', '1-INV0000000031', '2025-04-23', 0, 0, 0, 0, 1, 1),
(95, 2, 16.00, 0, 2500.00, 2650.00, 'complete', '1-INV0000000041', '2025-04-29', 0, 0, 0, 0, 1, 1),
(94, 3, 18.00, 0, 4150.00, 4400.00, 'complete', '1-INV0000000041', '2025-04-29', 0, 0, 0, 0, 1, 1),
(84, 4, 6.00, 0, 3750.00, 4000.00, 'complete', '1-INV0000000033', '2025-04-26', 0, 0, 0, 0, 1, 1),
(85, 3, 3.00, 0, 4150.00, 4300.00, 'complete', '1-INV0000000034', '2025-04-27', 0, 0, 0, 0, 1, 1),
(83, 2, 8.00, 0, 2500.00, 2650.00, 'complete', '1-INV0000000033', '2025-04-26', 0, 0, 0, 0, 1, 1),
(86, 2, 4.00, 0, 2500.00, 2600.00, 'complete', '1-INV0000000035', '2025-04-27', 0, 0, 0, 0, 1, 1),
(87, 3, 30.00, 0, 4150.00, 4200.00, 'complete', '1-INV0000000036', '2025-04-27', 0, 0, 0, 0, 1, 1),
(89, 3, 30.00, 0, 4150.00, 4200.00, 'complete', '1-INV0000000037', '2025-04-28', 0, 0, 0, 0, 1, 1),
(90, 3, 150.00, 0, 4150.00, 4200.00, 'complete', '1-INV0000000038', '2025-04-28', 0, 0, 0, 0, 1, 1),
(92, 4, 6.00, 0, 3750.00, 4000.00, 'complete', '1-INV0000000039', '2025-04-28', 0, 0, 0, 0, 1, 1),
(93, 4, 3.00, 0, 3750.00, 4000.00, 'complete', '1-INV0000000040', '2025-04-29', 0, 0, 0, 0, 1, 1),
(96, 2, 4.00, 0, 2500.00, 2600.00, 'complete', '1-INV0000000042', '2025-04-29', 0, 0, 0, 0, 1, 1),
(97, 4, 3.00, 0, 3750.00, 4000.00, 'complete', '1-INV0000000042', '2025-04-29', 0, 0, 0, 0, 1, 1),
(98, 3, 3.00, 0, 4150.00, 4300.00, 'complete', '1-INV0000000042', '2025-04-29', 0, 0, 0, 0, 1, 1),
(99, 4, 6.00, 0, 3750.00, 3950.00, 'complete', '1-INV0000000043', '2025-04-29', 0, 0, 0, 0, 1, 1),
(101, 2, 4.00, 0, 2500.00, 2650.00, 'complete', '1-INV0000000044', '2025-04-30', 0, 0, 0, 0, 1, 1),
(102, 3, 9.00, 0, 4150.00, 4200.00, 'complete', '1-INV0000000045', '2025-04-30', 0, 0, 0, 0, 1, 1),
(103, 4, 6.00, 0, 3750.00, 3900.00, 'complete', '1-INV0000000045', '2025-04-30', 0, 0, 0, 0, 1, 1),
(104, 4, 6.00, 0, 3750.00, 4000.00, 'complete', '1-INV0000000046', '2025-04-30', 0, 0, 0, 0, 1, 1),
(105, 3, 11.00, 0, 4150.00, 4200.00, 'complete', '1-INV0000000047', '2025-04-30', 0, 0, 0, 0, 1, 1),
(106, 3, 3.00, 0, 4150.00, 4250.00, 'complete', '1-INV0000000048', '2025-04-30', 0, 0, 0, 0, 1, 1),
(107, 4, 3.00, 0, 3750.00, 4000.00, 'complete', '1-INV0000000048', '2025-04-30', 0, 0, 0, 0, 1, 1),
(108, 3, 3.00, 0, 4150.00, 4200.00, 'complete', '1-INV0000000049', '2025-05-04', 0, 0, 0, 0, 1, 1),
(109, 2, 8.00, 0, 2500.00, 2550.00, 'complete', '1-INV0000000050', '2025-05-04', 0, 0, 0, 0, 1, 1),
(110, 3, 3.00, 0, 4150.00, 4250.00, 'complete', '1-INV0000000050', '2025-05-04', 0, 0, 0, 0, 1, 1),
(115, 3, 3.00, 0, 4150.00, 4200.00, 'complete', '1-INV0000000052', '2025-05-08', 0, 0, 0, 0, 1, 1),
(114, 2, 8.00, 0, 2500.00, 2550.00, 'complete', '1-INV0000000051', '2025-05-07', 0, 0, 0, 0, 1, 1),
(113, 4, 12.00, 0, 3750.00, 4000.00, 'complete', '1-INV0000000051', '2025-05-07', 0, 0, 0, 0, 1, 1),
(116, 3, 6.00, 0, 4150.00, 4200.00, 'complete', '1-INV0000000053', '2025-05-10', 0, 0, 0, 0, 1, 1),
(117, 3, 6.00, 0, 4150.00, 4250.00, 'complete', '1-INV0000000054', '2025-05-10', 0, 0, 0, 0, 1, 1),
(118, 4, 6.00, 0, 3750.00, 4000.00, 'complete', '1-INV0000000054', '2025-05-10', 0, 0, 0, 0, 1, 1),
(119, 3, 15.00, 0, 4150.00, 4200.00, 'complete', '1-INV0000000055', '2025-05-10', 0, 0, 0, 0, 1, 1),
(120, 3, 18.00, 0, 4150.00, 4200.00, 'complete', '1-INV0000000056', '2025-05-10', 0, 0, 0, 0, 1, 1),
(121, 4, 9.00, 0, 3750.00, 4000.00, 'complete', '1-INV0000000056', '2025-05-10', 0, 0, 0, 0, 1, 1),
(122, 2, 16.00, 0, 2500.00, 2600.00, 'complete', '1-INV0000000056', '2025-05-10', 0, 0, 0, 0, 1, 1),
(123, 3, 6.00, 0, 4150.00, 4200.00, 'complete', '1-INV0000000057', '2025-05-10', 0, 0, 0, 0, 1, 1),
(124, 2, 4.00, 0, 2500.00, 2600.00, 'complete', '1-INV0000000057', '2025-05-10', 0, 0, 0, 0, 1, 1),
(125, 3, 120.00, 0, 4150.00, 4150.00, 'complete', '1-INV0000000058', '2025-05-11', 0, 0, 0, 0, 1, 1),
(126, 4, 60.00, 0, 3750.00, 3850.00, 'complete', '1-INV0000000058', '2025-05-11', 0, 0, 0, 0, 1, 1),
(127, 3, 30.00, 0, 4150.00, 4200.00, 'complete', '1-INV0000000059', '2025-05-11', 0, 0, 0, 0, 1, 1),
(128, 3, 6.00, 0, 4150.00, 4200.00, 'complete', '1-INV0000000060', '2025-05-11', 0, 0, 0, 0, 1, 1),
(134, 3, 6.00, 0, 4150.00, 4200.00, 'complete', '1-INV0000000064', '2025-05-11', 0, 0, 0, 0, 1, 1),
(130, 3, 6.00, 0, 4150.00, 4250.00, 'complete', '1-INV0000000062', '2025-05-11', 0, 0, 0, 0, 1, 1),
(131, 4, 6.00, 0, 3750.00, 4000.00, 'complete', '1-INV0000000062', '2025-05-11', 0, 0, 0, 0, 1, 1),
(132, 3, 3.00, 0, 4150.00, 4200.00, 'complete', '1-INV0000000063', '2025-05-11', 0, 0, 0, 0, 1, 1),
(133, 2, 4.00, 0, 2500.00, 2550.00, 'complete', '1-INV0000000063', '2025-05-11', 0, 0, 0, 0, 1, 1),
(135, 4, 6.00, 0, 3750.00, 4000.00, 'complete', '1-INV0000000065', '2025-05-11', 0, 0, 0, 0, 1, 1),
(136, 2, 20.00, 0, 2500.00, 2550.00, 'complete', '1-INV0000000065', '2025-05-11', 0, 0, 0, 0, 1, 1),
(137, 3, 15.00, 0, 4150.00, 4200.00, 'complete', '1-INV0000000066', '2025-05-11', 0, 0, 0, 0, 1, 1),
(138, 3, 3.00, 0, 4150.00, 4200.00, 'complete', '1-INV0000000067', '2025-05-14', 0, 0, 0, 0, 1, 1),
(139, 2, 4.00, 0, 2500.00, 2600.00, 'complete', '1-INV0000000068', '2025-05-14', 0, 0, 0, 0, 1, 1),
(140, 4, 3.00, 0, 3750.00, 4000.00, 'complete', '1-INV0000000068', '2025-05-14', 0, 0, 0, 0, 1, 1),
(141, 3, 3.00, 0, 4150.00, 4200.00, 'complete', '1-INV0000000068', '2025-05-14', 0, 0, 0, 0, 1, 1),
(142, 2, 4.00, 0, 2500.00, 2600.00, 'complete', '1-INV0000000069', '2025-05-14', 0, 0, 0, 0, 1, 1),
(143, 2, 4.00, 0, 2500.00, 2600.00, 'complete', '1-INV0000000070', '2025-05-14', 0, 0, 0, 0, 1, 1),
(144, 3, 3.00, 0, 4150.00, 4200.00, 'complete', '1-INV0000000071', '2025-05-14', 0, 0, 0, 0, 1, 1),
(158, 2, 4.00, 0, 2500.00, 2600.00, 'complete', '1-INV0000000077', '2025-05-14', 0, 0, 0, 0, 1, 1),
(157, 3, 3.00, 0, 4150.00, 4200.00, 'complete', '1-INV0000000077', '2025-05-14', 0, 0, 0, 0, 1, 1),
(147, 3, 15.00, 0, 4150.00, 4150.00, 'complete', '1-INV0000000073', '2025-05-14', 0, 0, 0, 0, 1, 1),
(148, 3, 30.00, 0, 4150.00, 4200.00, 'complete', '1-INV0000000074', '2025-05-14', 0, 0, 0, 0, 1, 1),
(152, 4, 3.00, 0, 3750.00, 3950.00, 'complete', '1-INV0000000075', '2025-05-14', 0, 0, 0, 0, 1, 1),
(151, 3, 9.00, 0, 4150.00, 4150.00, 'complete', '1-INV0000000075', '2025-05-14', 0, 0, 0, 0, 1, 1),
(156, 4, 63.00, 0, 3750.00, 3850.00, 'complete', '1-INV0000000076', '2025-05-14', 0, 0, 0, 0, 1, 1),
(155, 3, 150.00, 0, 4150.00, 4150.00, 'complete', '1-INV0000000076', '2025-05-14', 0, 0, 0, 0, 1, 1),
(161, 3, 6.00, 0, 4150.00, 4150.00, 'complete', '1-INV0000000080', '2025-05-15', 0, 0, 0, 0, 1, 1),
(160, 3, 3.00, 0, 4150.00, 4150.00, 'complete', '1-INV0000000079', '2025-05-15', 0, 0, 0, 0, 1, 1),
(162, 3, 9.00, 0, 4150.00, 4150.00, 'complete', '1-INV0000000081', '2025-05-15', 0, 0, 0, 0, 1, 1),
(163, 4, 6.00, 0, 3750.00, 3950.00, 'complete', '1-INV0000000081', '2025-05-15', 0, 0, 0, 0, 1, 1),
(164, 2, 8.00, 0, 2500.00, 2550.00, 'complete', '1-INV0000000081', '2025-05-15', 0, 0, 0, 0, 1, 1),
(165, 3, 9.00, 0, 4150.00, 4150.00, 'complete', '1-INV0000000082', '2025-05-15', 0, 0, 0, 0, 1, 1),
(166, 2, 8.00, 0, 2500.00, 2550.00, 'complete', '1-INV0000000082', '2025-05-15', 0, 0, 0, 0, 1, 1),
(167, 4, 3.00, 0, 3750.00, 4000.00, 'complete', '1-INV0000000083', '2025-05-15', 0, 0, 0, 0, 1, 1),
(168, 3, 45.00, 0, 4150.00, 4200.00, 'complete', '1-INV0000000084', '2025-05-15', 0, 0, 0, 0, 1, 1),
(169, 3, 3.00, 0, 4150.00, 4200.00, 'complete', '1-INV0000000085', '2025-05-15', 0, 0, 0, 0, 1, 1),
(170, 3, 3.00, 0, 4150.00, 4200.00, 'complete', '1-INV0000000086', '2025-05-15', 0, 0, 0, 0, 1, 1),
(171, 2, 4.00, 0, 2500.00, 2600.00, 'complete', '1-INV0000000086', '2025-05-15', 0, 0, 0, 0, 1, 1),
(172, 2, 8.00, 0, 2500.00, 2550.00, 'complete', '1-INV0000000087', '2025-05-18', 0, 0, 0, 0, 1, 1),
(173, 3, 3.00, 0, 4150.00, 4200.00, 'complete', '1-INV0000000087', '2025-05-18', 0, 0, 0, 0, 1, 1),
(174, 3, 150.00, 0, 4150.00, 4150.00, 'complete', '1-INV0000000088', '2025-05-18', 0, 0, 0, 0, 1, 1),
(175, 3, 30.00, 0, 4150.00, 4150.00, 'complete', '1-INV0000000089', '2025-05-18', 0, 0, 0, 0, 1, 1),
(176, 3, 6.00, 0, 4150.00, 4200.00, 'complete', '1-INV0000000090', '2025-05-18', 0, 0, 0, 0, 1, 1),
(177, 2, 8.00, 0, 2500.00, 2550.00, 'complete', '1-INV0000000090', '2025-05-18', 0, 0, 0, 0, 1, 1),
(178, 3, 6.00, 0, 4150.00, 4150.00, 'complete', '1-INV0000000091', '2025-05-18', 0, 0, 0, 0, 1, 1),
(179, 3, 15.00, 0, 4150.00, 4200.00, 'complete', '1-INV0000000092', '2025-05-18', 0, 0, 0, 0, 1, 1),
(180, 3, 3.00, 0, 4150.00, 4200.00, 'complete', '1-INV0000000093', '2025-05-19', 0, 0, 0, 0, 1, 1),
(185, 3, 9.00, 0, 4150.00, 4150.00, 'complete', '1-INV0000000095', '2025-05-19', 0, 0, 0, 0, 1, 1),
(184, 2, 4.00, 0, 2500.00, 2600.00, 'complete', '1-INV0000000094', '2025-05-19', 0, 0, 0, 0, 1, 1),
(183, 3, 3.00, 0, 4150.00, 4200.00, 'complete', '1-INV0000000094', '2025-05-19', 0, 0, 0, 0, 1, 1),
(186, 3, 3.00, 0, 4150.00, 4150.00, 'complete', '1-INV0000000096', '2025-05-19', 0, 0, 0, 0, 1, 1),
(187, 3, 9.00, 0, 4150.00, 4200.00, 'complete', '1-INV0000000097', '2025-05-20', 0, 0, 0, 0, 1, 1),
(188, 4, 3.00, 0, 3750.00, 4000.00, 'complete', '1-INV0000000098', '2025-05-20', 0, 0, 0, 0, 1, 1),
(189, 3, 6.00, 0, 4150.00, 4150.00, 'complete', '1-INV0000000099', '2025-05-20', 0, 0, 0, 0, 1, 1),
(190, 4, 6.00, 0, 3750.00, 3950.00, 'complete', '1-INV0000000100', '2025-05-20', 0, 0, 0, 0, 1, 1),
(191, 3, 3.00, 0, 4150.00, 4150.00, 'complete', '1-INV0000000101', '2025-06-21', 0, 0, 0, 0, 1, 1),
(192, 3, 6.00, 0, 4150.00, 4150.00, 'complete', '1-INV0000000102', '2025-06-21', 0, 0, 0, 0, 1, 1),
(193, 6, 15.00, 0, 905.00, 950.00, 'complete', '1-INV0000000103', '2025-06-24', 0, 0, 0, 0, 1, 1),
(194, 6, 15.00, 0, 905.00, 930.00, 'complete', '1-INV0000000104', '2025-06-24', 0, 0, 0, 0, 1, 1),
(195, 6, 30.00, 0, 905.00, 930.00, 'complete', '1-INV0000000105', '2025-06-24', 0, 0, 0, 0, 1, 1),
(196, 6, 15.00, 0, 905.00, 950.00, 'complete', '1-INV0000000106', '2025-06-25', 0, 0, 0, 0, 1, 1),
(198, 7, 24.00, 0, 3375.00, 3400.00, 'complete', '1-INV0000000107', '2025-06-25', 0, 0, 0, 0, 1, 1),
(199, 6, 15.00, 0, 905.00, 930.00, 'complete', '1-INV0000000108', '2025-06-26', 0, 0, 0, 0, 1, 1),
(200, 6, 30.00, 0, 905.00, 930.00, 'complete', '1-INV0000000109', '2025-07-01', 0, 0, 0, 0, 1, 1),
(201, 6, 15.00, 0, 905.00, 930.00, 'complete', '1-INV0000000110', '2025-07-01', 0, 0, 0, 0, 1, 1),
(203, 6, 15.00, 0, 905.00, 930.00, 'complete', '1-INV0000000111', '2025-07-22', 0, 0, 0, 0, 1, 1),
(204, 6, 15.00, 0, 905.00, 920.00, 'complete', '1-INV0000000112', '2025-07-23', 0, 0, 0, 0, 1, 1),
(205, 6, 15.00, 0, 905.00, 930.00, 'complete', '1-INV0000000113', '2025-07-23', 0, 0, 0, 0, 1, 1);

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

--
-- Table structure for table `sale_taka`
--

CREATE TABLE `sale_taka` (
  `sale_taka_id` int(50) NOT NULL,
  `invoice_no` varchar(30) NOT NULL,
  `have_to_pay` int(20) NOT NULL,
  `payment` int(20) NOT NULL,
  `beforedue` int(12) NOT NULL,
  `payment_type` int(20) NOT NULL,
  `cash` int(20) NOT NULL,
  `bank` int(20) NOT NULL,
  `vehicle_cost` int(5) NOT NULL,
  `beton` int(5) NOT NULL,
  `discount` int(5) NOT NULL,
  `due` int(20) NOT NULL,
  `tax` decimal(20,2) NOT NULL,
  `cheque_no` varchar(30) NOT NULL,
  `cheque_date` varchar(20) NOT NULL,
  `bank_id` int(5) NOT NULL,
  `date` varchar(20) NOT NULL,
  `customer_id` int(20) NOT NULL,
  `retail_name` varchar(20) NOT NULL,
  `retail_address` varchar(50) NOT NULL,
  `transport_name` varchar(50) NOT NULL,
  `v_plus_minus` varchar(1) NOT NULL,
  `posting_time_date` timestamp NOT NULL DEFAULT current_timestamp(),
  `branch_id` int(2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `sale_taka`
--

INSERT INTO `sale_taka` (`sale_taka_id`, `invoice_no`, `have_to_pay`, `payment`, `beforedue`, `payment_type`, `cash`, `bank`, `vehicle_cost`, `beton`, `discount`, `due`, `tax`, `cheque_no`, `cheque_date`, `bank_id`, `date`, `customer_id`, `retail_name`, `retail_address`, `transport_name`, `v_plus_minus`, `posting_time_date`, `branch_id`) VALUES
(2, '1-INV0000000001', 92700, 0, 0, 0, 0, 0, 0, 0, 0, 92700, 0.00, '', '', 0, '2025-04-13', 3, '', '', '', 'm', '2025-04-13 11:30:55', 1),
(3, '1-INV0000000002', 10800, 0, 0, 0, 0, 0, 0, 0, 0, 10800, 0.00, '', '', 0, '2025-04-13', 2, '', '', '', 'm', '2025-04-13 11:30:55', 1),
(5, '1-INV0000000003', 27000, 0, 0, 0, 0, 0, 0, 0, 0, 27000, 0.00, '', '', 0, '2025-04-14', 5, '', '', '', 'm', '2025-04-14 05:40:48', 1),
(6, '1-INV0000000004', 135000, 0, 0, 0, 0, 0, 0, 0, 0, 135000, 0.00, '', '', 0, '2025-04-14', 6, '', '', '', 'm', '2025-04-14 05:44:15', 1),
(7, '1-INV0000000005', 36900, 0, 0, 0, 0, 0, 0, 0, 0, 36900, 0.00, '', '', 0, '2025-04-14', 7, '', '', '', 'm', '2025-04-14 05:49:39', 1),
(8, '1-INV0000000006', 105300, 0, 0, 0, 0, 0, 0, 0, 0, 105300, 0.00, '', '', 0, '2025-04-14', 4, '', '', '', 'm', '2025-04-14 05:52:37', 1),
(14, '1-INV0000000009', 63000, 0, 0, 0, 0, 0, 0, 0, 0, 63000, 0.00, '', '', 0, '2025-04-14', 10, '', '', '', 'm', '2025-04-14 08:48:39', 1),
(15, '1-INV0000000010', 22200, 0, 200, 0, 0, 0, 0, 0, 0, 22200, 0.00, '', '', 0, '2025-04-15', 10, '', '', '', 'm', '2025-04-15 09:32:30', 1),
(20, '1-INV0000000011', 21600, 0, 0, 0, 0, 0, 0, 0, 0, 21600, 0.00, '', '', 0, '2025-04-16', 12, '', '', '', 'm', '2025-04-16 10:18:48', 1),
(22, '1-INV0000000012', 65700, 0, 32700, 0, 0, 0, 0, 0, 0, 65700, 0.00, '', '', 0, '2025-04-16', 3, '', '', '', 'm', '2025-04-16 13:34:57', 1),
(23, '1-INV0000000013', 22500, 0, 98400, 0, 0, 0, 0, 0, 0, 22500, 0.00, '', '', 0, '2025-04-16', 3, '', '', '', 'm', '2025-04-16 13:37:38', 1),
(24, '1-INV0000000014', 31000, 0, 0, 0, 0, 0, 0, 0, 0, 31000, 0.00, '', '', 0, '2025-04-16', 2, '', '', '', 'm', '2025-04-16 16:28:47', 1),
(26, '1-INV0000000016', 39000, 0, 0, 0, 0, 0, 0, 0, 0, 39000, 0.00, '', '', 0, '2025-04-17', 14, '', '', '', 'm', '2025-04-17 15:54:11', 1),
(28, '1-INV0000000017', 10600, 0, 0, 0, 0, 0, 0, 0, 0, 10600, 0.00, '', '', 0, '2025-04-17', 10, '', '', '', 'm', '2025-04-17 16:47:37', 1),
(29, '1-INV0000000018', 26400, 0, 0, 0, 0, 0, 0, 0, 0, 26400, 0.00, '', '', 0, '2025-04-19', 14, '', '', '', 'm', '2025-04-19 06:17:55', 1),
(30, '1-INV0000000019', 510000, 0, 756000, 0, 0, 0, 0, 0, 0, 510000, 0.00, '', '', 0, '2025-04-19', 11, '', '', '', 'm', '2025-04-19 09:33:33', 1),
(32, '1-INV0000000020', 22200, 0, 170400, 0, 0, 0, 0, 0, 0, 22200, 0.00, '', '', 0, '2025-04-19', 8, '', '', '', 'm', '2025-04-19 09:52:51', 1),
(33, '1-INV0000000021', 39600, 20000, 0, 0, 20000, 0, 0, 0, 0, 19600, 0.00, '', '', 0, '2025-04-19', 9, '', '', '', 'm', '2025-04-19 10:05:08', 1),
(34, '1-INV0000000022', 10600, 5600, 10600, 0, 5600, 0, 0, 0, 0, 5000, 0.00, '', '', 0, '2025-04-19', 10, '', '', '', 'm', '2025-04-19 11:04:28', 1),
(35, '1-INV0000000023', 125600, 70100, 30300, 0, 70100, 0, 0, 0, 0, 55500, 0.00, '', '', 0, '2025-04-19', 13, '', '', '', 'm', '2025-04-19 11:28:32', 1),
(36, '1-INV0000000024', 89100, 0, 1291800, 0, 0, 0, 0, 0, 0, 89100, 0.00, '', '', 0, '2025-04-21', 11, '', '', '', 'm', '2025-04-21 11:49:52', 1),
(37, '1-INV0000000025', 129000, 0, 0, 0, 0, 0, 0, 0, 0, 129000, 0.00, '', '', 0, '2025-04-21', 15, '', '', '', 'm', '2025-04-21 11:51:27', 1),
(38, '1-INV0000000026', 39600, 0, 0, 0, 0, 0, 0, 0, 0, 39600, 0.00, '', '', 0, '2025-04-21', 16, '', '', '', 'm', '2025-04-21 11:52:20', 1),
(39, '1-INV0000000027', 36400, 0, 0, 0, 0, 0, 0, 0, 0, 36400, 0.00, '', '', 0, '2025-04-21', 17, '', '', '', 'm', '2025-04-21 11:54:27', 1),
(40, '1-INV0000000028', 10600, 0, 21600, 0, 0, 0, 0, 0, 0, 10600, 0.00, '', '', 0, '2025-04-22', 1, '', '', '', 'm', '2025-04-22 07:48:31', 1),
(41, '1-INV0000000029', 38700, 0, 0, 0, 0, 0, 0, 0, 0, 38700, 0.00, '', '', 0, '2025-04-23', 18, '', '', '', 'm', '2025-04-23 06:07:47', 1),
(42, '1-INV0000000030', 13050, 0, 22700, 0, 0, 0, 0, 0, 0, 13050, 0.00, '', '', 0, '2025-04-23', 2, '', '', '', 'm', '2025-04-23 06:09:15', 1),
(43, '1-INV0000000031', 52000, 0, 0, 0, 0, 0, 0, 0, 0, 52000, 0.00, '', '', 0, '2025-04-23', 19, '', '', '', 'm', '2025-04-23 08:58:37', 1),
(47, '1-INV0000000033', 45200, 0, 0, 0, 0, 0, 0, 0, 0, 45200, 0.00, '', '', 0, '2025-04-26', 18, '', '', '', 'm', '2025-04-26 11:19:27', 1),
(48, '1-INV0000000034', 12900, 0, 100, 0, 0, 0, 0, 0, 0, 12900, 0.00, '', '', 0, '2025-04-27', 12, '', '', '', 'm', '2025-04-27 10:38:21', 1),
(49, '1-INV0000000035', 10400, 0, 22850, 0, 0, 0, 0, 0, 0, 10400, 0.00, '', '', 0, '2025-04-27', 2, '', '', '', 'm', '2025-04-27 15:08:14', 1),
(50, '1-INV0000000036', 126000, 0, 0, 0, 0, 0, 0, 0, 0, 126000, 0.00, '', '', 0, '2025-04-27', 15, '', '', '', 'm', '2025-04-27 15:11:30', 1),
(52, '1-INV0000000037', 126000, 252000, 126000, 0, 252000, 0, 0, 0, 0, -126000, 0.00, '', '', 0, '2025-04-28', 15, '', '', '', 'm', '2025-04-28 08:03:24', 1),
(53, '1-INV0000000038', 630000, 315000, 0, 0, 315000, 0, 0, 0, 0, 315000, 0.00, '', '', 0, '2025-04-28', 20, '', '', '', 'm', '2025-04-28 09:55:13', 1),
(55, '1-INV0000000039', 24000, 24000, 2400, 0, 24000, 0, 0, 0, 0, 0, 0.00, '', '', 0, '2025-04-28', 21, '', '', '', 'm', '2025-04-28 13:14:47', 1),
(56, '1-INV0000000040', 12000, 0, 4600, 0, 0, 0, 0, 0, 0, 12000, 0.00, '', '', 0, '2025-04-29', 9, '', '', '', 'm', '2025-04-29 07:26:21', 1),
(57, '1-INV0000000041', 121600, 0, 128298, 0, 0, 0, 0, 0, 0, 121600, 0.00, '', '', 0, '2025-04-29', 13, '', '', '', 'm', '2025-04-29 07:35:40', 1),
(58, '1-INV0000000042', 35300, 0, 10600, 0, 0, 0, 0, 0, 0, 35300, 0.00, '', '', 0, '2025-04-29', 10, '', '', '', 'm', '2025-04-29 11:06:06', 1),
(59, '1-INV0000000043', 23700, 0, 2400, 0, 0, 0, 0, 0, 0, 23700, 0.00, '', '', 0, '2025-04-29', 21, '', '', '', 'm', '2025-04-29 14:53:26', 1),
(61, '1-INV0000000044', 10600, 0, 21600, 0, 0, 0, 0, 0, 0, 10600, 0.00, '', '', 0, '2025-04-30', 1, '', '', '', 'm', '2025-04-30 12:26:29', 1),
(62, '1-INV0000000045', 61200, 0, 0, 0, 0, 0, 0, 0, 0, 61200, 0.00, '', '', 0, '2025-04-30', 22, '', '', '', 'm', '2025-04-30 12:28:12', 1),
(63, '1-INV0000000046', 24000, 0, 800, 0, 0, 0, 0, 0, 0, 24000, 0.00, '', '', 0, '2025-04-30', 18, '', '', '', 'm', '2025-04-30 12:29:34', 1),
(64, '1-INV0000000047', 46200, 0, 0, 0, 0, 0, 0, 0, 0, 46200, 0.00, '', '', 0, '2025-04-30', 14, '', '', '', 'm', '2025-04-30 15:30:02', 1),
(65, '1-INV0000000048', 24750, 0, 22900, 0, 0, 0, 0, 0, 0, 24750, 0.00, '', '', 0, '2025-04-30', 10, '', '', '', 'm', '2025-04-30 15:32:31', 1),
(66, '1-INV0000000049', 12600, 0, 0, 0, 0, 0, 0, 0, 0, 12600, 0.00, '', '', 0, '2025-05-04', 23, '', '', '', 'm', '2025-05-04 10:34:15', 1),
(67, '1-INV0000000050', 33150, 0, 24800, 0, 0, 0, 0, 0, 0, 33150, 0.00, '', '', 0, '2025-05-04', 18, '', '', '', 'm', '2025-05-04 11:18:24', 1),
(69, '1-INV0000000051', 68400, 0, 68600, 0, 0, 0, 0, 0, 0, 68400, 0.00, '', '', 0, '2025-05-07', 3, '', '', '', 'm', '2025-05-07 09:12:52', 1),
(70, '1-INV0000000052', 12600, 0, 22650, 0, 0, 0, 0, 0, 0, 12600, 0.00, '', '', 0, '2025-05-08', 2, '', '', '', 'm', '2025-05-08 06:14:53', 1),
(71, '1-INV0000000053', 25200, 0, 0, 0, 0, 0, 0, 0, 0, 25200, 0.00, '', '', 0, '2025-05-10', 14, '', '', '', 'm', '2025-05-10 10:03:43', 1),
(72, '1-INV0000000054', 49500, 0, 32650, 0, 0, 0, 0, 0, 0, 49500, 0.00, '', '', 0, '2025-05-10', 10, '', '', '', 'm', '2025-05-10 10:05:18', 1),
(73, '1-INV0000000055', 63000, 0, 0, 0, 0, 0, 0, 0, 0, 63000, 0.00, '', '', 0, '2025-05-10', 22, '', '', '', 'm', '2025-05-10 10:06:10', 1),
(74, '1-INV0000000056', 153200, 0, 1450, 0, 0, 0, 0, 0, 0, 153200, 0.00, '', '', 0, '2025-05-10', 18, '', '', '', 'm', '2025-05-10 10:08:34', 1),
(75, '1-INV0000000057', 35600, 0, 0, 0, 0, 0, 0, 0, 0, 35600, 0.00, '', '', 0, '2025-05-10', 14, '', '', '', 'm', '2025-05-10 15:43:52', 1),
(76, '1-INV0000000058', 729000, 0, 0, 0, 0, 0, 0, 0, 0, 729000, 0.00, '', '', 0, '2025-05-11', 20, '', '', '', 'm', '2025-05-11 07:22:01', 1),
(77, '1-INV0000000059', 126000, 0, 0, 0, 0, 0, 0, 0, 0, 126000, 0.00, '', '', 0, '2025-05-11', 15, '', '', '', 'm', '2025-05-11 08:45:21', 1),
(78, '1-INV0000000060', 25200, 0, 100, 0, 0, 0, 0, 0, 0, 25200, 0.00, '', '', 0, '2025-05-11', 12, '', '', '', 'm', '2025-05-11 08:46:20', 1),
(80, '1-INV0000000062', 49500, 0, 52150, 0, 0, 0, 0, 0, 0, 49500, 0.00, '', '', 0, '2025-05-11', 10, '', '', '', 'm', '2025-05-11 08:50:30', 1),
(81, '1-INV0000000063', 22800, 0, 172600, 0, 0, 0, 0, 0, 0, 22800, 0.00, '', '', 0, '2025-05-11', 8, '', '', '', 'm', '2025-05-11 08:52:04', 1),
(82, '1-INV0000000064', 25200, 0, 50400, 0, 0, 0, 0, 0, 0, 25200, 0.00, '', '', 0, '2025-05-11', 24, '', '', '', 'm', '2025-05-11 09:00:47', 1),
(83, '1-INV0000000065', 75000, 0, 0, 0, 0, 0, 0, 0, 0, 75000, 0.00, '', '', 0, '2025-05-11', 19, '', '', '', 'm', '2025-05-11 10:13:13', 1),
(84, '1-INV0000000066', 63000, 0, 126000, 0, 0, 0, 0, 0, 0, 63000, 0.00, '', '', 0, '2025-05-11', 15, '', '', '', 'm', '2025-05-11 10:16:05', 1),
(85, '1-INV0000000067', 12600, 0, 22650, 0, 0, 0, 0, 0, 0, 12600, 0.00, '', '', 0, '2025-05-14', 2, '', '', '', 'm', '2025-05-14 07:48:52', 1),
(86, '1-INV0000000068', 35000, 0, 71650, 0, 0, 0, 0, 0, 0, 35000, 0.00, '', '', 0, '2025-05-14', 10, '', '', '', 'm', '2025-05-14 07:51:58', 1),
(87, '1-INV0000000069', 10400, 0, 21600, 0, 0, 0, 0, 0, 0, 10400, 0.00, '', '', 0, '2025-05-14', 1, '', '', '', 'm', '2025-05-14 07:52:41', 1),
(88, '1-INV0000000070', 10400, 0, 35250, 0, 0, 0, 0, 0, 0, 10400, 0.00, '', '', 0, '2025-05-14', 2, '', '', '', 'm', '2025-05-14 08:12:29', 1),
(89, '1-INV0000000071', 12600, 0, 32000, 0, 0, 0, 0, 0, 0, 12600, 0.00, '', '', 0, '2025-05-14', 1, '', '', '', 'm', '2025-05-14 08:59:35', 1),
(91, '1-INV0000000073', 62250, 0, 8100, 0, 0, 0, 0, 0, 0, 62250, 0.00, '', '', 0, '2025-05-14', 16, '', '', '', 'm', '2025-05-14 09:24:46', 1),
(92, '1-INV0000000074', 126000, 0, 219898, 0, 0, 0, 0, 0, 0, 126000, 0.00, '', '', 0, '2025-05-14', 13, '', '', '', 'm', '2025-05-14 09:25:45', 1),
(94, '1-INV0000000075', 49200, 0, 944100, 0, 0, 0, 0, 0, 0, 49200, 0.00, '', '', 0, '2025-05-14', 11, '', '', '', 'm', '2025-05-14 09:47:16', 1),
(96, '1-INV0000000076', 865050, 0, 265050, 0, 0, 0, 0, 0, 0, 865050, 0.00, '', '', 0, '2025-05-14', 20, '', '', '', 'm', '2025-05-14 10:30:43', 1),
(97, '1-INV0000000077', 23000, 0, 195400, 0, 0, 0, 0, 0, 0, 23000, 0.00, '', '', 0, '2025-05-14', 8, '', '', '', 'm', '2025-05-14 12:57:32', 1),
(99, '1-INV0000000079', 12450, 0, 0, 0, 0, 0, 0, 0, 0, 12450, 0.00, '', '', 0, '2025-05-15', 25, '', '', '', 'm', '2025-05-15 07:55:53', 1),
(100, '1-INV0000000080', 24900, 0, 442400, 0, 0, 0, 0, 0, 0, 24900, 0.00, '', '', 0, '2025-05-15', 8, '', '', '', 'm', '2025-05-15 07:59:13', 1),
(101, '1-INV0000000081', 81450, 0, 54650, 0, 0, 0, 0, 0, 0, 81450, 0.00, '', '', 0, '2025-05-15', 18, '', '', '', 'm', '2025-05-15 08:02:59', 1),
(102, '1-INV0000000082', 57750, 0, 44600, 0, 0, 0, 0, 0, 0, 57750, 0.00, '', '', 0, '2025-05-15', 1, '', '', '', 'm', '2025-05-15 10:52:01', 1),
(103, '1-INV0000000083', 12000, 0, 102350, 0, 0, 0, 0, 0, 0, 12000, 0.00, '', '', 0, '2025-05-15', 1, '', '', '', 'm', '2025-05-15 10:53:29', 1),
(104, '1-INV0000000084', 189000, 0, 0, 0, 0, 0, 0, 0, 0, 189000, 0.00, '', '', 0, '2025-05-15', 15, '', '', '', 'm', '2025-05-15 10:56:05', 1),
(105, '1-INV0000000085', 12600, 0, 45650, 0, 0, 0, 0, 0, 0, 12600, 0.00, '', '', 0, '2025-05-15', 2, '', '', '', 'm', '2025-05-15 10:57:04', 1),
(106, '1-INV0000000086', 23000, 0, 0, 0, 0, 0, 0, 0, 0, 23000, 0.00, '', '', 0, '2025-05-15', 9, '', '', '', 'm', '2025-05-15 11:19:49', 1),
(107, '1-INV0000000087', 33000, 0, 447300, 0, 0, 0, 0, 0, 0, 33000, 0.00, '', '', 0, '2025-05-18', 8, '', '', '', 'm', '2025-05-18 12:08:49', 1),
(108, '1-INV0000000088', 622500, 0, 265050, 0, 0, 0, 0, 0, 0, 622500, 0.00, '', '', 0, '2025-05-18', 20, '', '', '', 'm', '2025-05-18 12:10:31', 1),
(109, '1-INV0000000089', 124500, 0, 189000, 0, 0, 0, 0, 0, 0, 124500, 0.00, '', '', 0, '2025-05-18', 15, '', '', '', 'm', '2025-05-18 12:12:46', 1),
(110, '1-INV0000000090', 45600, 0, 0, 0, 0, 0, 0, 0, 0, 45600, 0.00, '', '', 0, '2025-05-18', 7, '', '', '', 'm', '2025-05-18 12:14:49', 1),
(111, '1-INV0000000091', 24900, 0, 100, 0, 0, 0, 0, 0, 0, 24900, 0.00, '', '', 0, '2025-05-18', 12, '', '', '', 'm', '2025-05-18 12:16:42', 1),
(112, '1-INV0000000092', 63000, 0, 92000, 0, 0, 0, 0, 0, 0, 63000, 0.00, '', '', 0, '2025-05-18', 3, '', '', '', 'm', '2025-05-18 12:18:55', 1),
(113, '1-INV0000000093', 12600, 0, 22750, 0, 0, 0, 0, 0, 0, 12600, 0.00, '', '', 0, '2025-05-19', 2, '', '', '', 'm', '2025-05-19 11:18:00', 1),
(115, '1-INV0000000094', 23000, 0, 0, 0, 0, 0, 0, 0, 0, 23000, 0.00, '', '', 0, '2025-05-19', 17, '', '', '', 'm', '2025-05-19 11:20:56', 1),
(116, '1-INV0000000095', 37350, 0, 0, 0, 0, 0, 0, 0, 0, 37350, 0.00, '', '', 0, '2025-05-19', 25, '', '', '', 'm', '2025-05-19 11:22:04', 1),
(117, '1-INV0000000096', 12450, 0, 480300, 0, 0, 0, 0, 0, 0, 12450, 0.00, '', '', 0, '2025-05-19', 8, '', '', '', 'm', '2025-05-19 11:23:09', 1),
(118, '1-INV0000000097', 37800, 0, 35704, 0, 0, 0, 0, 0, 0, 37800, 0.00, '', '', 0, '2025-05-20', 9, '', '', '', 'm', '2025-05-20 08:55:34', 1),
(119, '1-INV0000000098', 12000, 0, 23000, 0, 0, 0, 0, 0, 0, 12000, 0.00, '', '', 0, '2025-05-20', 17, '', '', '', 'm', '2025-05-20 08:57:00', 1),
(120, '1-INV0000000099', 24900, 0, 0, 0, 0, 0, 0, 0, 0, 24900, 0.00, '', '', 0, '2025-05-20', 22, '', '', '', 'm', '2025-05-20 09:01:13', 1),
(121, '1-INV0000000100', 23700, 0, 24900, 0, 0, 0, 0, 0, 0, 23700, 0.00, '', '', 0, '2025-05-20', 22, '', '', '', 'm', '2025-05-20 09:12:30', 1),
(122, '1-INV0000000101', 12450, 0, 35350, 0, 0, 0, 0, 0, 0, 12450, 0.00, '', '', 0, '2025-06-21', 2, '', '', '', 'm', '2025-06-21 08:55:20', 1),
(123, '1-INV0000000102', 24900, 0, 49350, 0, 0, 0, 0, 0, 0, 24900, 0.00, '', '', 0, '2025-06-21', 1, '', '', '', 'm', '2025-06-21 08:58:20', 1),
(124, '1-INV0000000103', 14250, 0, 20300, 0, 0, 0, 0, 0, 0, 14250, 0.00, '', '', 0, '2025-06-24', 4, '', '', '', 'm', '2025-06-24 10:31:49', 1),
(125, '1-INV0000000104', 13950, 0, 13600, 0, 0, 0, 0, 0, 0, 13950, 0.00, '', '', 0, '2025-06-24', 22, '', '', '', 'm', '2025-06-24 10:33:40', 1),
(126, '1-INV0000000105', 27900, 0, 3600, 0, 0, 0, 0, 0, 0, 27900, 0.00, '', '', 0, '2025-06-24', 18, '', '', '', 'm', '2025-06-24 10:35:04', 1),
(127, '1-INV0000000106', 14250, 0, 25000, 0, 0, 0, 0, 0, 0, 14250, 0.00, '', '', 0, '2025-06-25', 17, '', '', '', 'm', '2025-06-25 06:27:33', 1),
(129, '1-INV0000000107', 81600, 81600, 265550, 0, 81600, 0, 0, 0, 0, 0, 0.00, '', '', 0, '2025-06-25', 20, '', '', '', 'm', '2025-06-25 09:06:57', 1),
(130, '1-INV0000000108', 13950, 0, 0, 0, 0, 0, 0, 0, 0, 13950, 0.00, '', '', 0, '2025-06-26', 26, '', '', '', 'm', '2025-06-26 07:56:55', 1),
(131, '1-INV0000000109', 27900, 0, 265550, 0, 0, 0, 0, 0, 0, 27900, 0.00, '', '', 0, '2025-07-01', 20, '', '', '', 'm', '2025-07-01 12:57:08', 1),
(132, '1-INV0000000110', 13950, 0, 0, 0, 0, 0, 0, 0, 0, 13950, 0.00, '', '', 0, '2025-07-01', 14, '', '', '', 'm', '2025-07-01 12:58:37', 1),
(134, '1-INV0000000111', 13950, 0, 0, 0, 0, 0, 0, 0, 0, 13950, 0.00, '', '', 0, '2025-07-22', 25, '', '', '', 'm', '2025-07-22 07:23:34', 1),
(135, '1-INV0000000112', 13800, 0, 3600, 0, 0, 0, 0, 0, 0, 13800, 0.00, '', '', 0, '2025-07-23', 18, '', '', '', 'm', '2025-07-23 06:40:34', 1),
(136, '1-INV0000000113', 13950, 0, 550, 0, 0, 0, 0, 0, 0, 13950, 0.00, '', '', 0, '2025-07-23', 22, '', '', '', 'm', '2025-07-23 06:43:24', 1);

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

--
-- Table structure for table `store`
--

CREATE TABLE `store` (
  `store_id` int(50) NOT NULL,
  `amount` decimal(20,2) NOT NULL,
  `wastage` decimal(20,2) NOT NULL,
  `supplier_id` int(10) NOT NULL,
  `chalan_no` varchar(20) NOT NULL,
  `stock_of` int(2) NOT NULL,
  `unit_id` int(10) NOT NULL,
  `date` varchar(20) NOT NULL,
  `status` varchar(10) NOT NULL,
  `branch_id` int(2) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `store`
--

INSERT INTO `store` (`store_id`, `amount`, `wastage`, `supplier_id`, `chalan_no`, `stock_of`, `unit_id`, `date`, `status`, `branch_id`) VALUES
(1, 260000.00, 0.00, 1, '560', 1, 0, '2025-04-12', '', 1);

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

--
-- Table structure for table `store_product`
--

CREATE TABLE `store_product` (
  `store_product_id` int(12) NOT NULL,
  `product_id` int(12) NOT NULL,
  `quantity` int(6) NOT NULL,
  `buying_price` decimal(12,2) NOT NULL,
  `selling_price` decimal(12,2) NOT NULL,
  `chalan_no` varchar(20) NOT NULL,
  `status` int(1) NOT NULL,
  `branch_id` int(2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `store_product`
--

INSERT INTO `store_product` (`store_product_id`, `product_id`, `quantity`, `buying_price`, `selling_price`, `chalan_no`, `status`, `branch_id`) VALUES
(1, 1, 100, 2600.00, 2800.00, '560', 2, 1);

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

--
-- Table structure for table `store_transfer`
--

CREATE TABLE `store_transfer` (
  `store_transfer_id` int(12) NOT NULL,
  `from_br` int(2) NOT NULL,
  `to_br` int(2) NOT NULL,
  `qty` int(12) NOT NULL,
  `date` date NOT NULL,
  `product_id` int(12) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `store_transfer`
--

INSERT INTO `store_transfer` (`store_transfer_id`, `from_br`, `to_br`, `qty`, `date`, `product_id`) VALUES
(1, 1, 2, 20, '2025-04-12', 1);

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

--
-- Table structure for table `supplier_payment`
--

CREATE TABLE `supplier_payment` (
  `supplier_payment_id` int(50) NOT NULL,
  `supplier_id` int(20) NOT NULL,
  `cash` int(20) NOT NULL,
  `bank` int(20) NOT NULL,
  `due` int(20) NOT NULL,
  `check_number` varchar(20) NOT NULL,
  `chalan_no` varchar(20) NOT NULL,
  `check_date` varchar(20) NOT NULL,
  `bank_id` int(3) NOT NULL,
  `sup_date` varchar(20) NOT NULL,
  `branch_id` int(2) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `supplier_payment`
--

INSERT INTO `supplier_payment` (`supplier_payment_id`, `supplier_id`, `cash`, `bank`, `due`, `check_number`, `chalan_no`, `check_date`, `bank_id`, `sup_date`, `branch_id`) VALUES
(1, 1, 0, 0, 260000, '', '560', '', 0, '2025-04-12', 1);

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

--
-- Table structure for table `supplier_setup`
--

CREATE TABLE `supplier_setup` (
  `supplier_id` int(50) NOT NULL,
  `supplier_name` varchar(200) NOT NULL,
  `address` text NOT NULL,
  `district` varchar(200) NOT NULL,
  `mobile_no` varchar(200) NOT NULL,
  `opening_due` int(10) NOT NULL,
  `due` int(12) NOT NULL,
  `iscustomer` varchar(1) NOT NULL,
  `branch_id` int(2) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `supplier_setup`
--

INSERT INTO `supplier_setup` (`supplier_id`, `supplier_name`, `address`, `district`, `mobile_no`, `opening_due`, `due`, `iscustomer`, `branch_id`) VALUES
(1, 'Habib Trading', 'Nowabpur', 'Dhaka', '01716067376', 0, 0, 'n', 1);

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

--
-- Table structure for table `sup_due_payment`
--

CREATE TABLE `sup_due_payment` (
  `sup_due_payment_id` int(11) NOT NULL,
  `supplier_id` int(10) NOT NULL,
  `cash` int(20) NOT NULL,
  `bank` int(20) NOT NULL,
  `cheque_no` varchar(30) NOT NULL,
  `cheque_date` varchar(20) NOT NULL,
  `bank_id` int(5) NOT NULL,
  `chalan_no` varchar(20) NOT NULL,
  `date` varchar(20) NOT NULL,
  `branch_id` int(2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `sup_due_payment`
--

INSERT INTO `sup_due_payment` (`sup_due_payment_id`, `supplier_id`, `cash`, `bank`, `cheque_no`, `cheque_date`, `bank_id`, `chalan_no`, `date`, `branch_id`) VALUES
(1, 1, 260000, 0, '', '', 0, '1-INV0000000018', '2025-04-24', 1);

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

--
-- Table structure for table `transaction`
--

CREATE TABLE `transaction` (
  `transaction_id` int(10) NOT NULL,
  `date` varchar(20) NOT NULL,
  `ref_id` varchar(20) NOT NULL,
  `customer_id` varchar(20) NOT NULL,
  `supplier_id` int(20) NOT NULL,
  `ledger` varchar(50) NOT NULL,
  `debit` int(20) NOT NULL,
  `credit` int(20) NOT NULL,
  `cheque_no` varchar(20) NOT NULL,
  `cheque_date` varchar(20) NOT NULL,
  `bank_id` int(10) NOT NULL,
  `hint` varchar(30) NOT NULL,
  `details` varchar(50) NOT NULL,
  `payment_type` varchar(5) NOT NULL,
  `branch_id` int(2) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `transaction`
--

INSERT INTO `transaction` (`transaction_id`, `date`, `ref_id`, `customer_id`, `supplier_id`, `ledger`, `debit`, `credit`, `cheque_no`, `cheque_date`, `bank_id`, `hint`, `details`, `payment_type`, `branch_id`) VALUES
(1, '2014-01-02', '', '', 1, '1', 0, 0, '', '', 0, 'supplier due', '', 'due', 1),
(2, '2014-01-02', '', '1', 0, '2', 0, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(3, '2014-01-02', '', '', 0, '14', 100000, 0, '', '', 1, '', '', 'bank', 0),
(5, '2025-04-12', '560', '', 1, '5', 0, 260000, '', '', 0, 'supplier due', '', 'due', 1),
(6, '2025-04-12', '1-BILL0000000001', '', 0, '40', 0, 500, '', '', 0, '40', 'manik', 'cash', 1),
(7, '2014-01-02', '', '2', 0, '2', 0, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(8, '2014-01-02', '', '3', 0, '2', 0, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(9, '2025-04-13', '1-INV0000000001', '3', 0, '9', 92700, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(10, '2025-04-13', '1-INV0000000002', '2', 0, '9', 10800, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(12, '2014-01-02', '', '4', 0, '2', 0, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(13, '2014-01-02', '', '5', 0, '2', 0, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(14, '2025-04-13', 'INV0000000002', '2', 0, '7', 10800, 0, '', '', 0, '7', '', 'cash', 1),
(15, '2014-01-02', '', '6', 0, '2', 0, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(16, '2014-01-02', '', '7', 0, '2', 0, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(17, '2025-04-14', '1-INV0000000003', '5', 0, '9', 27000, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(18, '2025-04-14', '1-INV0000000004', '6', 0, '9', 135000, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(19, '2025-04-14', '1-INV0000000005', '7', 0, '9', 36900, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(20, '2014-01-02', '', '8', 0, '2', 0, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(21, '2025-04-14', '1-INV0000000006', '4', 0, '9', 105300, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(26, '2014-01-02', '', '9', 0, '2', 0, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(30, '2025-04-15', 'INV0000000007', '10', 0, '7', 62800, 0, '', '', 0, '7', '', 'cash', 1),
(65, '2025-04-19', '1-INV0000000021', '9', 0, '9', 20000, 0, '', '', 0, 'sale permanent customer', '', 'cash', 1),
(28, '2014-01-02', '', '10', 0, '2', 0, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(29, '2025-04-14', '1-INV0000000009', '10', 0, '9', 63000, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(31, '2025-04-15', 'INV0000000007', '3', 0, '7', 30000, 0, '', '', 0, '7', '', 'cash', 1),
(32, '2025-04-15', '1-INV0000000010', '10', 0, '9', 22200, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(35, '2014-01-02', '', '11', 0, '2', 0, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(36, '2014-01-02', '', '12', 0, '2', 0, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(39, '2025-04-16', '1-INV0000000011', '12', 0, '9', 21600, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(42, '2025-04-15', 'INV0000000007', '5', 0, '7', 27000, 0, '', '', 0, '7', '', 'cash', 1),
(41, '2025-04-15', '1-INV00000000011', '3', 0, '7', 30000, 0, '', '', 0, '7', '', 'cash', 1),
(43, '2025-04-15', 'INV0000000007', '7', 0, '7', 36900, 0, '', '', 0, '7', '', 'cash', 1),
(44, '2025-04-16', '1-INV0000000007', '2', 0, '7', 22500, 0, '', '', 0, '7', '', 'cash', 1),
(45, '2025-04-16', '1-INV0000000007', '6', 0, '7', 133500, 0, '', '', 0, '7', '', 'cash', 1),
(46, '2025-04-16', '1-INV0000000012', '3', 0, '9', 65700, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(47, '2025-04-16', '1-INV0000000013', '3', 0, '9', 22500, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(48, '2025-04-16', '1-INV0000000014', '2', 0, '9', 31000, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(49, '2014-01-02', '', '13', 0, '2', 0, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(62, '2025-04-19', '1-INV0000000019', '11', 0, '9', 510000, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(52, '2014-01-02', '', '14', 0, '2', 0, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(53, '2025-04-17', '1-INV0000000016', '14', 0, '9', 39000, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(54, '2025-04-16', '1-INV00000000011', '3', 0, '7', 22500, 0, '', '', 0, '7', '', 'cash', 1),
(55, '2025-04-17', '1-INV0000000007', '2', 0, '7', 22000, 0, '', '', 0, '7', '', 'cash', 1),
(56, '2025-04-17', '1-INV0000000007', '14', 0, '7', 39000, 0, '', '', 0, '7', '', 'cash', 1),
(57, '2025-04-17', '1-INV0000000007', '12', 0, '7', 21500, 0, '', '', 0, '7', '', 'cash', 1),
(59, '2025-04-17', '1-INV0000000007', '10', 0, '7', 33000, 0, '', '', 0, '7', '', 'cash', 1),
(60, '2025-04-17', '1-INV0000000017', '10', 0, '9', 10600, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(61, '2025-04-19', '1-INV0000000018', '14', 0, '9', 26400, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(64, '2025-04-19', '1-INV0000000020', '8', 0, '9', 22200, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(66, '2025-04-19', '1-INV0000000021', '9', 0, '9', 19600, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(67, '2025-04-19', 'vul001', '2', 0, '7', -22500, 0, '', '', 0, '7', 'return entry', 'cash', 1),
(68, '2025-04-19', '1-INV0000000022', '10', 0, '9', 5600, 0, '', '', 0, 'sale permanent customer', '', 'cash', 1),
(69, '2025-04-19', '1-INV0000000022', '10', 0, '9', 5000, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(70, '2025-04-19', '1-INV0000000023', '13', 0, '9', 70100, 0, '', '', 0, 'sale permanent customer', '', 'cash', 1),
(71, '2025-04-19', '1-INV0000000023', '13', 0, '9', 55500, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(72, '2025-04-19', '1-INV0000000007', '2', 0, '7', 8800, 0, '', '', 0, '7', '', 'cash', 1),
(73, '2025-04-19', '1-INV0000000007', '14', 0, '7', 26400, 0, '', '', 0, '7', '', 'cash', 1),
(74, '2025-04-20', '1-INV0000000007', '9', 0, '7', 15000, 0, '', '', 0, '7', '', 'cash', 1),
(75, '2025-04-20', '1-INV0000000007', '3', 0, '7', 20000, 0, '', '', 0, '7', '', 'cash', 1),
(76, '2014-01-02', '', '15', 0, '2', 0, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(77, '2014-01-02', '', '16', 0, '2', 0, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(78, '2014-01-02', '', '17', 0, '2', 0, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(79, '2025-04-21', '1-INV0000000024', '11', 0, '9', 89100, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(80, '2025-04-21', '1-INV0000000025', '15', 0, '9', 129000, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(81, '2025-04-21', '1-INV0000000026', '16', 0, '9', 39600, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(82, '2025-04-21', '1-INV0000000027', '17', 0, '9', 36400, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(83, '2025-04-22', '1-INV0000000028', '1', 0, '9', 10600, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(84, '2014-01-02', '', '18', 0, '2', 0, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(85, '2025-04-22', '1-INV0000000007', '4', 0, '7', 20000, 0, '', '', 0, '7', '', 'cash', 1),
(86, '2025-04-22', '1-INV0000000007', '13', 0, '7', 40000, 0, '', '', 0, '7', '', 'cash', 1),
(87, '2025-04-23', '1-INV0000000029', '18', 0, '9', 38700, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(88, '2025-04-23', '1-INV0000000030', '2', 0, '9', 13050, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(89, '2014-01-02', '', '19', 0, '2', 0, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(90, '2025-04-23', '1-INV0000000031', '19', 0, '9', 52000, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(91, '2025-04-23', '1-INV0000000007', '15', 0, '7', 129000, 0, '', '', 0, '7', '', 'cash', 1),
(92, '2025-04-23', '1-INV0000000007', '16', 0, '7', 15000, 0, '', '', 0, '7', '', 'cash', 1),
(93, '2025-04-23', '1-INV0000000007', '18', 0, '7', 38700, 0, '', '', 0, '7', '', 'cash', 1),
(94, '2025-04-24', '1-INV0000000007', '11', 0, '7', 200000, 0, '', '', 0, '7', '', 'cash', 1),
(95, '2025-04-24', '1-INV0000000018', '', 1, '3', 0, 260000, '', '', 0, 'supplier due payment', '', 'cash', 1),
(96, '2025-04-24', '1-INV0000000007', '19', 0, '7', 52000, 0, '', '', 0, '7', '', 'cash', 1),
(97, '2025-04-24', '1-INV0000000007', '1', 0, '7', 5000, 0, '', '', 0, '7', '', 'cash', 1),
(98, '2025-04-24', '1-INV0000000007', '10', 0, '7', 5000, 0, '', '', 0, '7', '', 'cash', 1),
(99, '2025-04-26', '1-INV0000000007', '13', 0, '7', 15500, 0, '', '', 0, '7', '', 'cash', 1),
(100, '2025-04-26', '1-INV0000000007', '2', 0, '7', 12900, 0, '', '', 0, '7', '', 'cash', 1),
(122, '2025-04-29', '1-INV0000000041', '13', 0, '9', 121600, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(102, '2025-04-26', '1-INV0000000007', '13', 0, '7', 2, 0, '', '', 0, '7', '', 'cash', 1),
(106, '2025-04-26', '1-INV0000000033', '18', 0, '9', 45200, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(104, '2025-04-26', '1-INV0000000007', '13', 0, '7', 50000, 0, '', '', 0, '7', '', 'cash', 1),
(107, '2025-04-27', '1-INV0000000034', '12', 0, '9', 12900, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(108, '2025-04-27', '1-INV0000000035', '2', 0, '9', 10400, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(109, '2025-04-27', '1-INV0000000007', '18', 0, '7', 20000, 0, '', '', 0, '7', '', 'cash', 1),
(110, '2025-04-27', '1-INV0000000007', '16', 0, '7', 16500, 0, '', '', 0, '7', '', 'cash', 1),
(111, '2025-04-27', '1-INV0000000036', '15', 0, '9', 126000, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(112, '2014-01-02', '', '20', 0, '2', 0, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(113, '2014-01-02', '', '21', 0, '2', 0, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(115, '2025-04-28', '1-INV0000000037', '15', 0, '9', 252000, 0, '', '', 0, 'sale permanent customer', '', 'cash', 1),
(116, '2025-04-28', '1-INV0000000037', '15', 0, '9', -126000, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(117, '2025-04-28', '1-INV0000000038', '20', 0, '9', 315000, 0, '', '', 0, 'sale permanent customer', '', 'cash', 1),
(118, '2025-04-28', '1-INV0000000038', '20', 0, '9', 315000, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(120, '2025-04-28', '1-INV0000000039', '21', 0, '9', 24000, 0, '', '', 0, 'sale permanent customer', '', 'cash', 1),
(121, '2025-04-29', '1-INV0000000040', '9', 0, '9', 12000, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(123, '2025-04-29', '1-INV0000000042', '10', 0, '9', 35300, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(124, '2025-04-29', '1-INV0000000043', '21', 0, '9', 23700, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(125, '2025-04-29', '1-INV0000000007', '18', 0, '7', 24400, 0, '', '', 0, '7', '', 'cash', 1),
(126, '2025-04-29', '1-INV0000000007', '9', 0, '7', 10000, 0, '', '', 0, '7', '', 'cash', 1),
(127, '2025-04-29', '1-INV0000000007', '12', 0, '7', 12900, 0, '', '', 0, '7', '', 'cash', 1),
(128, '2025-04-29', '1-INV0000000007', '10', 0, '7', 15000, 0, '', '', 0, '7', '', 'cash', 1),
(129, '2025-04-29', '1-INV0000000007', '1', 0, '7', 5600, 0, '', '', 0, '7', '', 'cash', 1),
(130, '2025-04-29', '1-INV0000000007', '21', 0, '7', 23700, 0, '', '', 0, '7', '', 'cash', 1),
(131, '2014-01-02', '', '22', 0, '2', 0, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(133, '2025-04-30', '1-INV0000000044', '1', 0, '9', 10600, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(134, '2025-04-30', '1-INV0000000045', '22', 0, '9', 61200, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(135, '2025-04-30', '1-INV0000000046', '18', 0, '9', 24000, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(136, '2025-04-30', '1-INV0000000007', '3', 0, '7', 15000, 0, '', '', 0, '7', '', 'cash', 1),
(137, '2025-04-30', '1-INV0000000007', '10', 0, '7', 8000, 0, '', '', 0, '7', '', 'cash', 1),
(138, '2025-04-30', '1-INV0000000047', '14', 0, '9', 46200, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(139, '2025-04-30', '1-INV0000000048', '10', 0, '9', 24750, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(140, '2014-01-02', '', '23', 0, '2', 0, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(141, '2025-05-04', '1-INV0000000049', '23', 0, '9', 12600, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(142, '2025-05-04', '1-INV0000000050', '18', 0, '9', 33150, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(143, '2025-05-04', '1-INV0000000007', '13', 0, '7', 30000, 0, '', '', 0, '7', '', 'cash', 1),
(144, '2025-05-04', '1-INV0000000007', '14', 0, '7', 46200, 0, '', '', 0, '7', '', 'cash', 1),
(145, '2025-05-05', '1-INV0000000007', '2', 0, '7', 10600, 0, '', '', 0, '7', '', 'cash', 1),
(146, '2025-05-05', '1-INV0000000007', '23', 0, '7', 12600, 0, '', '', 0, '7', '', 'cash', 1),
(147, '2025-05-05', '1-INV0000000007', '20', 0, '7', 315000, 0, '', '', 0, '7', '', 'cash', 1),
(148, '2025-05-05', '1-INV0000000007', '18', 0, '7', 30000, 0, '', '', 0, '7', '', 'cash', 1),
(149, '2025-05-05', '1-INV0000000007', '9', 0, '7', 6600, 0, '', '', 0, '7', '', 'cash', 1),
(150, '2025-05-05', '1-INV0000000007', '22', 0, '7', 61200, 0, '', '', 0, '7', '', 'cash', 1),
(151, '2025-05-06', '1-INV0000000007', '10', 0, '7', 15000, 0, '', '', 0, '7', '', 'cash', 1),
(152, '2025-05-06', '1-INV0000000007', '1', 0, '7', 5000, 0, '', '', 0, '7', '', 'cash', 1),
(153, '2025-05-06', '1-INV0000000007', '3', 0, '7', 20000, 0, '', '', 0, '7', '', 'cash', 1),
(155, '2025-05-07', '1-INV0000000051', '3', 0, '9', 68400, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(156, '2025-05-07', '1-INV0000000007', '8', 0, '7', 20000, 0, '', '', 0, '7', '', 'cash', 1),
(157, '2025-05-07', '1-INV0000000007', '18', 0, '7', 26500, 0, '', '', 0, '7', '', 'cash', 1),
(158, '2025-05-08', '1-INV0000000052', '2', 0, '9', 12600, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(159, '2025-05-10', '1-INV0000000053', '14', 0, '9', 25200, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(160, '2025-05-10', '1-INV0000000054', '10', 0, '9', 49500, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(161, '2025-05-10', '1-INV0000000055', '22', 0, '9', 63000, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(162, '2025-05-10', '1-INV0000000056', '18', 0, '9', 153200, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(163, '2025-05-10', '1-INV0000000007', '14', 0, '7', 25200, 0, '', '', 0, '7', '', 'cash', 1),
(164, '2025-05-10', '1-INV0000000007', '17', 0, '7', 10000, 0, '', '', 0, '7', '', 'cash', 1),
(165, '2025-05-10', '1-INV0000000007', '18', 0, '7', 50000, 0, '', '', 0, '7', '', 'cash', 1),
(166, '2025-05-10', '1-INV0000000007', '10', 0, '7', 30000, 0, '', '', 0, '7', '', 'cash', 1),
(167, '2025-05-10', '1-INV0000000007', '1', 0, '7', 5600, 0, '', '', 0, '7', '', 'cash', 1),
(168, '2025-05-10', '1-INV0000000057', '14', 0, '9', 35600, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(169, '2025-05-11', '1-INV0000000058', '20', 0, '9', 729000, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(170, '2025-05-11', '1-INV0000000059', '15', 0, '9', 126000, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(171, '2014-01-02', '', '24', 0, '2', 0, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(172, '2025-05-11', '1-INV0000000060', '12', 0, '9', 25200, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(176, '2025-05-11', '1-INV0000000064', '24', 0, '9', 25200, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(174, '2025-05-11', '1-INV0000000062', '10', 0, '9', 49500, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(175, '2025-05-11', '1-INV0000000063', '8', 0, '9', 22800, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(177, '2025-05-11', '1-INV0000000065', '19', 0, '9', 75000, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(178, '2025-05-11', '1-INV0000000066', '15', 0, '9', 63000, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(179, '2025-05-11', '1-INV0000000007', '18', 0, '7', 50000, 0, '', '', 0, '7', '', 'cash', 1),
(180, '2025-05-11', '1-INV0000000007', '2', 0, '7', 12600, 0, '', '', 0, '7', '', 'cash', 1),
(181, '2025-05-11', '1-INV0000000007', '14', 0, '7', 35600, 0, '', '', 0, '7', '', 'cash', 1),
(182, '2025-05-11', '1-INV0000000007', '10', 0, '7', 30000, 0, '', '', 0, '7', '', 'cash', 1),
(183, '2025-05-11', '1-INV0000000007', '3', 0, '7', 25000, 0, '', '', 0, '7', '', 'cash', 1),
(184, '2025-05-11', '1-INV0000000007', '24', 0, '7', 15000, 0, '', '', 0, '7', '', 'cash', 1),
(185, '2025-05-14', '1-INV0000000067', '2', 0, '9', 12600, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(186, '2025-05-14', '1-INV0000000068', '10', 0, '9', 35000, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(187, '2025-05-14', '1-INV0000000069', '1', 0, '9', 10400, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(188, '2025-05-14', '1-INV0000000007', '10', 0, '7', 20000, 0, '', '', 0, '7', '', 'cash', 1),
(189, '2025-05-14', '1-INV0000000070', '2', 0, '9', 10400, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(190, '2025-05-14', '1-INV0000000071', '1', 0, '9', 12600, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(204, '2025-05-14', '1-INV0000000007', '20', 0, '7', 865050, 0, '', '', 0, '7', '', 'cash', 1),
(192, '2025-05-14', '1-INV0000000073', '16', 0, '9', 62250, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(193, '2025-05-14', '1-INV0000000074', '13', 0, '9', 126000, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(194, '2025-05-14', '1-INV0000000007', '11', 0, '7', 250000, 0, '', '', 0, '7', '', 'cash', 1),
(197, '2025-05-14', '1-INV0000000007', '20', 0, '7', 729000, 0, '', '', 0, '7', '', 'cash', 1),
(196, '2025-05-14', '1-INV0000000007', '4', 0, '7', 30000, 0, '', '', 0, '7', '', 'cash', 1),
(198, '2025-05-14', '1-INV0000000007', '15', 0, '7', 189000, 0, '', '', 0, '7', '', 'cash', 1),
(199, '2025-05-14', '1-INV0000000007', '19', 0, '7', 75000, 0, '', '', 0, '7', '', 'cash', 1),
(200, '2025-05-14', '1-INV0000000007', '22', 0, '7', 63000, 0, '', '', 0, '7', '', 'cash', 1),
(201, '2025-05-14', '1-INV0000000075', '11', 0, '9', 49200, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(203, '2025-05-14', '1-INV0000000076', '20', 0, '9', 865050, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(205, '2025-05-14', '1-INV0000000077', '8', 0, '9', 23000, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(206, '2025-05-14', '1-INV0000000007', '16', 0, '7', 25000, 0, '', '', 0, '7', '', 'cash', 1),
(207, '2025-05-14', '1-INV0000000007', '8', 0, '7', 25000, 0, '', '', 0, '7', '', 'cash', 1),
(208, '2025-05-14', '1-INV0000000007', '12', 0, '7', 25200, 0, '', '', 0, '7', '', 'cash', 1),
(209, '2025-05-14', '1-INV0000000007', '24', 0, '7', 10200, 0, '', '', 0, '7', '', 'cash', 1),
(210, '2025-05-14', '1-INV0000000007', '13', 0, '7', 70000, 0, '', '', 0, '7', '', 'cash', 1),
(214, '2025-05-15', '1-INV0000000080', '8', 0, '9', 24900, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(212, '2014-01-02', '', '25', 0, '2', 0, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(213, '2025-05-15', '1-INV0000000079', '25', 0, '9', 12450, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(215, '2025-05-15', '1-INV0000000081', '18', 0, '9', 81450, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(216, '2025-05-15', '1-INV0000000082', '1', 0, '9', 57750, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(217, '2025-05-15', '1-INV0000000083', '1', 0, '9', 12000, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(218, '2025-05-15', '1-INV0000000084', '15', 0, '9', 189000, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(219, '2025-05-15', '1-INV0000000085', '2', 0, '9', 12600, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(220, '2025-05-15', '1-INV0000000086', '9', 0, '9', 23000, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(221, '2025-05-15', '1-INV0000000007', '3', 0, '7', 20000, 0, '', '', 0, '7', '', 'cash', 1),
(222, '2025-05-15', '1-INV0000000007', '8', 0, '7', 20000, 0, '', '', 0, '7', '', 'cash', 1),
(223, '2025-05-15', '1-INV0000000007', '18', 0, '7', 50000, 0, '', '', 0, '7', '', 'cash', 1),
(224, '2025-05-15', '1-INV0000000007', '25', 0, '7', 12450, 0, '', '', 0, '7', '', 'cash', 1),
(225, '2025-05-18', '1-INV0000000007', '2', 0, '7', 15000, 0, '', '', 0, '7', '', 'cash', 1),
(226, '2025-05-18', '1-INV0000000007', '10', 0, '7', 15000, 0, '', '', 0, '7', '', 'cash', 1),
(227, '2025-05-18', '1-INV0000000087', '8', 0, '9', 33000, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(228, '2025-05-18', '1-INV0000000088', '20', 0, '9', 622500, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(229, '2025-05-18', '1-INV0000000089', '15', 0, '9', 124500, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(230, '2025-05-18', '1-INV0000000090', '7', 0, '9', 45600, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(231, '2025-05-18', '1-INV0000000091', '12', 0, '9', 24900, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(232, '2025-05-18', '1-INV0000000092', '3', 0, '9', 63000, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(233, '2025-05-19', '1-INV0000000007', '18', 0, '7', 10000, 0, '', '', 0, '7', '', 'cash', 1),
(234, '2025-05-19', '1-INV0000000007', '16', 0, '7', 20000, 0, '', '', 0, '7', '', 'cash', 1),
(235, '2025-05-19', '1-INV0000000007', '2', 0, '7', 10500, 0, '', '', 0, '7', '', 'cash', 1),
(236, '2025-05-19', '1-INV0000000007', '17', 0, '7', 26400, 0, '', '', 0, '7', '', 'cash', 1),
(237, '2025-05-19', '1-INV0000000007', '10', 0, '7', 10000, 0, '', '', 0, '7', '', 'cash', 1),
(238, '2025-05-19', '1-INV0000000007', '1', 0, '7', 45000, 0, '', '', 0, '7', '', 'cash', 1),
(239, '2025-05-19', '1-INV0000000007', '2', 0, '7', 10000, 0, '', '', 0, '7', '', 'cash', 1),
(240, '2025-05-19', '1-INV0000000093', '2', 0, '9', 12600, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(242, '2025-05-19', '1-INV0000000094', '17', 0, '9', 23000, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(243, '2025-05-19', '1-INV0000000095', '25', 0, '9', 37350, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(244, '2025-05-19', '1-INV0000000096', '8', 0, '9', 12450, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(245, '2025-05-19', '1-INV0000000007', '15', 0, '7', 311000, 0, '', '', 0, '7', '', 'cash', 1),
(246, '2025-05-19', '1-INV0000000007', '25', 0, '7', 30000, 0, '', '', 0, '7', '', 'cash', 1),
(247, '2025-05-19', '1-INV0000000007', '8', 0, '7', 45000, 0, '', '', 0, '7', '', 'cash', 1),
(248, '2025-05-19', '1-INV0000000007', '7', 0, '7', 30000, 0, '', '', 0, '7', '', 'cash', 1),
(249, '2025-05-20', '1-INV0000000097', '9', 0, '9', 37800, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(250, '2025-05-20', '1-INV0000000098', '17', 0, '9', 12000, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(251, '2025-05-20', '1-INV0000000099', '22', 0, '9', 24900, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(252, '2025-05-20', '1-INV0000000100', '22', 0, '9', 23700, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(253, '2025-05-20', '1-INV0000000007', '18', 0, '7', 30000, 0, '', '', 0, '7', '', 'cash', 1),
(254, '2025-05-21', '1-INV0000000007', '9', 0, '7', 20000, 0, '', '', 0, '7', '', 'cash', 1),
(255, '2025-05-21', '1-INV0000000007', '22', 0, '7', 20000, 0, '', '', 0, '7', '', 'cash', 1),
(256, '2025-05-21', '1-INV0000000007', '12', 0, '7', 24900, 0, '', '', 0, '7', '', 'cash', 1),
(257, '2025-05-21', '1-INV0000000007', '10', 0, '7', 8000, 0, '', '', 0, '7', '', 'cash', 1),
(258, '2025-05-24', '1-INV0000000007', '25', 0, '7', 7350, 0, '', '', 0, '7', '', 'cash', 1),
(259, '2025-05-24', '1-INV0000000007', '3', 0, '7', 20000, 0, '', '', 0, '7', '', 'cash', 1),
(260, '2025-05-24', '1-INV0000000007', '1', 0, '7', 10000, 0, '', '', 0, '7', '', 'cash', 1),
(261, '2025-05-25', '1-INV0000000007', '18', 0, '7', 20000, 0, '', '', 0, '7', '', 'cash', 1),
(262, '2025-05-25', '1-INV0000000007', '9', 0, '7', 20000, 0, '', '', 0, '7', '', 'cash', 1),
(263, '2025-05-26', '1-INV0000000007', '20', 0, '7', 300000, 0, '', '', 0, '7', '', 'cash', 1),
(264, '2025-05-26', '1-INV0000000007', '10', 0, '7', 5000, 0, '', '', 0, '7', '', 'cash', 1),
(265, '2025-05-26', '1-INV0000000007', '22', 0, '7', 10000, 0, '', '', 0, '7', '', 'cash', 1),
(266, '2025-05-28', '1-INV0000000007', '7', 0, '7', 14900, 0, '', '', 0, '7', '', 'cash', 1),
(267, '2025-05-29', '1-INV0000000007', '18', 0, '7', 1000, 0, '', '', 0, '7', '', 'cash', 1),
(268, '2025-05-29', '1-INV0000000007', '18', 0, '7', 9000, 0, '', '', 0, '7', '', 'cash', 1),
(269, '2025-06-02', '1-INV0000000007', '16', 0, '7', 10000, 0, '', '', 0, '7', '', 'cash', 1),
(270, '2025-06-02', '1-INV0000000007', '1', 0, '7', 10000, 0, '', '', 0, '7', '', 'cash', 1),
(271, '2025-06-05', '1-INV0000000007', '4', 0, '7', 15000, 0, '', '', 0, '7', '', 'cash', 1),
(272, '2025-06-05', '1-INV0000000007', '22', 0, '7', 5000, 0, '', '', 0, '7', '', 'cash', 1),
(273, '2025-06-21', '1-INV0000000007', '13', 0, '7', 50000, 0, '', '', 0, '7', '', 'cash', 1),
(274, '2025-06-21', '1-INV0000000007', '18', 0, '7', 12500, 0, '', '', 0, '7', '', 'cash', 1),
(275, '2025-06-21', '1-INV0000000007', '17', 0, '7', 10000, 0, '', '', 0, '7', '', 'cash', 1),
(276, '2025-06-21', '1-INV0000000007', '3', 0, '7', 15000, 0, '', '', 0, '7', '', 'cash', 1),
(277, '2025-06-21', '1-INV0000000101', '2', 0, '9', 12450, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(278, '2025-06-21', '1-INV0000000102', '1', 0, '9', 24900, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(279, '2025-06-22', '1-INV0000000007', '20', 0, '7', 322000, 0, '', '', 0, '7', '', 'cash', 1),
(280, '2025-06-23', '1-INV0000000007', '4', 0, '7', 20000, 0, '', '', 0, '7', '', 'cash', 1),
(281, '2025-06-23', '1-INV0000000007', '16', 0, '7', 7200, 0, '', '', 0, '7', '', 'cash', 1),
(282, '2025-06-23', '1-INV0000000007', '9', 0, '7', 10000, 0, '', '', 0, '7', '', 'cash', 1),
(283, '2025-06-23', '1-INV0000000007', '1', 0, '7', 16880, 0, '', '', 0, '7', '', 'cash', 1),
(284, '2025-06-24', '1-INV0000000103', '4', 0, '9', 14250, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(285, '2025-06-24', '1-INV0000000104', '22', 0, '9', 13950, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(286, '2025-06-24', '1-INV0000000105', '18', 0, '9', 27900, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(287, '2025-06-25', '1-INV0000000106', '17', 0, '9', 14250, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(289, '2025-06-25', '1-INV0000000107', '20', 0, '9', 81600, 0, '', '', 0, 'sale permanent customer', '', 'cash', 1),
(290, '2025-06-25', '1-INV0000000007', '22', 0, '7', 10000, 0, '', '', 0, '7', '', 'cash', 1),
(291, '2014-01-02', '', '26', 0, '2', 0, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(292, '2025-06-26', '1-INV0000000108', '26', 0, '9', 13950, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(293, '2025-06-28', '1-INV0000000007', '18', 0, '7', 15000, 0, '', '', 0, '7', '', 'cash', 1),
(294, '2025-06-28', '1-INV0000000007', '3', 0, '7', 20000, 0, '', '', 0, '7', '', 'cash', 1),
(295, '2025-06-29', '1-INV0000000007', '11', 0, '7', 50000, 0, '', '', 0, '7', '', 'cash', 1),
(296, '2025-06-29', '1-INV0000000007', '13', 0, '7', 25000, 0, '', '', 0, '7', '', 'cash', 1),
(297, '2025-07-01', '1-INV0000000109', '20', 0, '9', 27900, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(298, '2025-07-01', '1-INV0000000110', '14', 0, '9', 13950, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(299, '2025-07-02', '1-INV0000000007', '18', 0, '7', 12900, 0, '', '', 0, '7', '', 'cash', 1),
(300, '2025-07-02', '1-INV0000000007', '26', 0, '7', 10000, 0, '', '', 0, '7', '', 'cash', 1),
(301, '2025-07-02', '1-INV0000000007', '8', 0, '7', 10000, 0, '', '', 0, '7', '', 'cash', 1),
(302, '2025-07-02', '1-INV0000000007', '1', 0, '7', 10000, 0, '', '', 0, '7', '', 'cash', 1),
(303, '2025-07-07', '1-INV0000000007', '3', 0, '7', 10000, 0, '', '', 0, '7', '', 'cash', 1),
(304, '2025-07-07', '1-INV0000000007', '26', 0, '7', 3900, 0, '', '', 0, '7', '', 'cash', 1),
(305, '2025-07-07', '1-INV0000000007', '14', 0, '7', 10000, 0, '', '', 0, '7', '', 'cash', 1),
(306, '2025-07-08', '1-INV0000000007', '17', 0, '7', 10000, 0, '', '', 0, '7', '', 'cash', 1),
(307, '2025-07-08', '1-INV0000000007', '14', 0, '7', 3950, 0, '', '', 0, '7', '', 'cash', 1),
(308, '2025-07-09', '1-INV0000000007', '22', 0, '7', 5000, 0, '', '', 0, '7', '', 'cash', 1),
(309, '2025-07-12', '1-INV0000000007', '4', 0, '7', 10000, 0, '', '', 0, '7', '', 'cash', 1),
(310, '2025-07-13', '1-INV0000000007', '2', 0, '7', 15000, 0, '', '', 0, '7', '', 'cash', 1),
(311, '2025-07-13', '1-INV0000000007', '3', 0, '7', 10000, 0, '', '', 0, '7', '', 'cash', 1),
(312, '2025-07-13', '1-INV0000000007', '20', 0, '7', 27900, 0, '', '', 0, '7', '', 'cash', 1),
(313, '2025-07-16', '1-INV0000000007', '22', 0, '7', 7000, 0, '', '', 0, '7', '', 'cash', 1),
(314, '2025-07-16', '1-INV0000000007', '2', 0, '7', 9800, 0, '', '', 0, '7', '', 'cash', 1),
(315, '2025-07-16', '1-INV0000000007', '8', 0, '7', 7000, 0, '', '', 0, '7', '', 'cash', 1),
(316, '2025-07-22', '1-INV0000000007', '10', 0, '7', 5000, 0, '', '', 0, '7', '', 'cash', 1),
(317, '2025-07-22', '1-INV0000000007', '9', 0, '7', 10800, 0, '', '', 0, '7', '', 'cash', 1),
(319, '2025-07-22', '1-INV0000000111', '25', 0, '9', 13950, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(320, '2025-07-22', '1-INV0000000007', '13', 0, '7', 10000, 0, '', '', 0, '7', '', 'cash', 1),
(321, '2025-07-23', '1-INV0000000007', '3', 0, '7', 10000, 0, '', '', 0, '7', '', 'cash', 1),
(322, '2025-07-23', '1-INV0000000007', '22', 0, '7', 5000, 0, '', '', 0, '7', '', 'cash', 1),
(323, '2025-07-23', '1-INV0000000007', '4', 0, '7', 10000, 0, '', '', 0, '7', '', 'cash', 1),
(324, '2025-07-23', '1-INV0000000112', '18', 0, '9', 13800, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1),
(325, '2025-07-23', '1-INV0000000113', '22', 0, '9', 13950, 0, '', '', 0, 'sale due permanent customer', '', 'due', 1);

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

--
-- Table structure for table `transaction_history`
--

CREATE TABLE `transaction_history` (
  `transaction_id` int(10) NOT NULL,
  `date` varchar(20) NOT NULL,
  `ref_id` varchar(20) NOT NULL,
  `customer_id` varchar(20) NOT NULL,
  `supplier_id` int(20) NOT NULL,
  `ledger` varchar(50) NOT NULL,
  `debit` int(20) NOT NULL,
  `credit` int(20) NOT NULL,
  `cheque_no` varchar(20) NOT NULL,
  `cheque_date` varchar(20) NOT NULL,
  `bank_id` int(10) NOT NULL,
  `hint` text NOT NULL,
  `details` varchar(50) NOT NULL,
  `payment_type` varchar(5) NOT NULL,
  `branch_id` int(2) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `transaction_history`
--

INSERT INTO `transaction_history` (`transaction_id`, `date`, `ref_id`, `customer_id`, `supplier_id`, `ledger`, `debit`, `credit`, `cheque_no`, `cheque_date`, `bank_id`, `hint`, `details`, `payment_type`, `branch_id`) VALUES
(1, '2014-01-02', '', '', 0, 'primary balance', 103180, 0, '', '', 0, '', '', 'cash', 1),
(2, '2016-01-06', 'BILL0000000001', '', 0, '16', 1500, 0, '', '', 0, '16', '', 'cash', 1),
(3, '2016-01-06', 'BILL0000000002', '', 0, '16', 800, 0, '', '', 0, '16', '', 'cash', 1),
(4, '2016-01-07', 'BILL0000000003', '', 0, '16', 800, 0, '', '', 0, '16', '', 'cash', 1),
(5, '2016-01-07', 'BILL0000000004', '', 0, '16', 2500, 0, '', '', 0, '16', '', 'cash', 1),
(6, '2016-01-07', 'BILL0000000005', '', 0, '16', 1000, 0, '', '', 0, '16', '', 'cash', 1),
(7, '2016-01-07', 'BILL0000000006', '', 0, '16', 1200, 0, '', '', 0, '16', '', 'cash', 1),
(8, '2016-01-07', 'BILL0000000007', '', 0, '16', 1000, 0, '', '', 0, '16', '', 'cash', 1),
(9, '2016-01-07', 'BILL0000000008', '', 0, '16', 4000, 0, '', '', 0, '16', '', 'cash', 1),
(10, '2016-01-09', 'BILL0000000009', '', 0, '16', 2500, 0, '', '', 0, '16', '', 'cash', 1),
(11, '2016-01-09', 'BILL0000000010', '', 0, '16', 1200, 0, '', '', 0, '16', '', 'cash', 1),
(12, '2016-01-09', 'BILL0000000011', '', 0, '16', 3500, 0, '', '', 0, '16', '', 'cash', 1),
(13, '2016-01-09', 'BILL0000000012', '', 0, '16', 1000, 0, '', '', 0, '16', '', 'cash', 1),
(14, '2016-01-09', 'BILL0000000013', '', 0, '16', 1200, 0, '', '', 0, '16', '', 'cash', 1),
(15, '2016-01-09', 'BILL0000000014', '', 0, '16', 600, 0, '', '', 0, '16', '', 'cash', 1),
(16, '2016-01-09', 'BILL0000000015', '', 0, '16', 600, 0, '', '', 0, '16', '', 'cash', 1),
(17, '2016-01-09', 'BILL0000000016', '', 0, '16', 1700, 0, '', '', 0, '16', '', 'cash', 1),
(18, '2016-01-09', 'BILL0000000017', '', 0, '16', 1400, 0, '', '', 0, '16', '', 'cash', 1),
(19, '2016-01-09', 'BILL0000000018', '', 0, '16', 1000, 0, '', '', 0, '16', '', 'cash', 1),
(20, '2016-01-10', 'BILL0000000019', '', 0, '16', 1000, 0, '', '', 0, '16', '', 'cash', 1),
(21, '2016-01-10', 'BILL0000000020', '', 0, '16', 500, 0, '', '', 0, '16', '', 'cash', 1),
(22, '2016-01-10', 'BILL0000000021', '', 0, '16', 3000, 0, '', '', 0, '16', '', 'cash', 1),
(23, '2016-01-10', 'BILL0000000022', '', 0, '16', 2000, 0, '', '', 0, '16', '', 'cash', 1),
(24, '2014-01-02', '', '', 1, '1', 0, 141675, '', '', 0, 'supplier due', '', 'due', 1),
(26, '2014-01-02', '', '', 0, '14', 0, 0, '', '', 1, '', '', 'bank', 1),
(27, '2014-01-02', '', '', 0, '14', 0, 0, '', '', 2, '', '', 'bank', 1),
(28, '2014-01-02', '', '', 2, '1', 0, 0, '', '', 0, 'supplier due', '', 'due', 1),
(29, '2014-01-02', '', '', 3, '1', 0, 0, '', '', 0, 'supplier due', '', 'due', 1),
(30, '2014-01-02', '', '', 4, '1', 0, 0, '', '', 0, 'supplier due', '', 'due', 1),
(31, '2014-01-02', '', '', 5, '1', 0, 0, '', '', 0, 'supplier due', '', 'due', 1),
(32, '2016-01-10', 'BILL0000000023', '', 0, '16', 31038, 0, '', '2016-01-10', 1, '16', '', 'bank', 1),
(33, '2016-01-10', 'BILL0000000024', '', 0, '16', 31038, 0, '', '2016-01-10', 1, '16', '', 'bank', 1),
(34, '2016-01-10', 'BILL0000000025', '', 0, '16', 1000, 0, '', '', 0, '16', '', 'cash', 1),
(35, '2016-01-10', 'BILL0000000026', '', 0, '16', 3000, 0, '', '', 0, '16', '', 'cash', 1),
(36, '2016-01-10', 'BILL0000000027', '', 0, '16', 3000, 0, '', '', 0, '16', '', 'cash', 1),
(37, '2016-01-10', 'BILL0000000028', '', 0, '16', 3500, 0, '', '', 0, '16', '', 'cash', 1),
(38, '2016-01-10', 'BILL0000000029', '', 0, '16', 2000, 0, '', '', 0, '16', '', 'cash', 1),
(39, '2016-01-10', 'BILL0000000030', '', 0, '16', 1000, 0, '', '', 0, '16', '', 'cash', 1),
(40, '2016-01-10', 'BILL0000000031', '', 0, '16', 1000, 0, '', '', 0, '16', '', 'cash', 1),
(41, '2016-01-10', 'BILL0000000032', '', 0, '16', 800, 0, '', '', 0, '16', '', 'cash', 1),
(42, '2016-01-10', 'BILL0000000033', '', 0, '16', 800, 0, '', '', 0, '16', '', 'cash', 1),
(43, '2016-01-10', 'BILL0000000034', '', 0, '16', 800, 0, '', '', 0, '16', '', 'cash', 1),
(44, '2016-01-10', 'BILL0000000035', '', 0, '16', 1500, 0, '', '', 0, '16', '', 'cash', 1),
(45, '2016-01-10', 'BILL0000000036', '', 0, '16', 800, 0, '', '', 0, '16', '', 'cash', 1),
(46, '2016-01-10', 'BILL0000000037', '', 0, '16', 1000, 0, '', '', 0, '16', '', 'cash', 1),
(47, '2016-01-10', 'BILL0000000038', '', 0, '16', 1500, 0, '', '', 0, '16', '', 'cash', 1),
(48, '2016-01-10', 'BILL0000000039', '', 0, '16', 800, 0, '', '', 0, '16', '', 'cash', 1),
(49, '2016-01-10', 'BILL0000000040', '', 0, '16', 1200, 0, '', '', 0, '16', '', 'cash', 1),
(50, '2016-01-10', 'BILL0000000041', '', 0, '16', 1400, 0, '', '', 0, '16', '', 'cash', 1),
(51, '2016-01-10', 'BILL0000000042', '', 0, '16', 800, 0, '', '', 0, '16', '', 'cash', 1),
(52, '2016-01-10', 'BILL0000000043', '', 0, '16', 1000, 0, '', '', 0, '16', '', 'cash', 1),
(53, '2016-01-10', 'BILL0000000044', '', 0, '16', 1500, 0, '', '', 0, '16', '', 'cash', 1),
(54, '2016-01-10', 'BILL0000000045', '', 0, '16', 1500, 0, '', '', 0, '16', '', 'cash', 1),
(55, '2016-01-10', 'BILL0000000046', '', 0, '16', 2200, 0, '', '', 0, '16', '', 'cash', 1),
(56, '2016-01-10', 'BILL0000000047', '', 0, '16', 3200, 0, '', '', 0, '16', '', 'cash', 1),
(57, '2016-01-11', 'BILL0000000048', '', 0, '16', 3000, 0, '', '2016-01-11', 2, '16', '', 'bank', 1),
(58, '2016-01-11', 'BILL0000000049', '', 0, '16', 1200, 0, '', '', 0, '16', '', 'cash', 1),
(59, '2016-01-11', 'BILL0000000050', '', 0, '16', 500, 0, '', '', 0, '16', '', 'cash', 1),
(60, '2016-01-11', 'BILL0000000051', '', 0, '16', 500, 0, '', '', 0, '16', '', 'cash', 1),
(61, '2016-01-11', 'BILL0000000052', '', 0, '16', 1000, 0, '', '', 0, '16', '', 'cash', 1),
(62, '2016-01-04', 'BILL0000000053', '', 0, '16', 500, 0, '', '', 0, '16', '', 'cash', 1),
(63, '2016-01-11', 'BILL0000000054', '', 0, '16', 3000, 0, '', '', 0, '16', '', 'cash', 1),
(64, '2016-01-10', 'BILL0000000055', '', 0, '16', 1500, 0, '', '', 0, '16', '', 'cash', 1),
(65, '2016-01-11', 'BILL0000000056', '', 0, '16', 2300, 0, '', '2016-01-11', 2, '16', '', 'bank', 1),
(66, '2016-01-11', 'BILL0000000057', '', 0, '16', 1000, 0, '', '', 0, '16', '', 'cash', 1),
(67, '2016-01-11', 'BILL0000000058', '', 0, '16', 1500, 0, '', '', 0, '16', '', 'cash', 1),
(68, '2016-01-11', 'BILL0000000059', '', 0, '16', 1500, 0, '', '', 0, '16', '', 'cash', 1),
(69, '2016-01-11', 'BILL0000000060', '', 0, '16', 600, 0, '', '', 0, '16', '', 'cash', 1),
(70, '2016-01-11', 'BILL0000000061', '', 0, '16', 600, 0, '', '', 0, '16', '', 'cash', 1),
(71, '2016-01-12', 'BILL0000000062', '', 0, '16', 1500, 0, '', '', 0, '16', '', 'cash', 1),
(72, '2016-01-12', 'BILL0000000063', '', 0, '16', 600, 0, '', '', 0, '16', '', 'cash', 1),
(73, '2016-01-12', 'BILL0000000064', '', 0, '16', 1500, 0, '', '', 0, '16', '', 'cash', 1),
(74, '2016-01-12', 'BILL0000000065', '', 0, '16', 1500, 0, '', '', 0, '16', '', 'cash', 1),
(75, '2016-01-12', 'BILL0000000066', '', 0, '16', 600, 0, '', '', 0, '16', '', 'cash', 1),
(76, '2016-01-12', 'BILL0000000067', '', 0, '16', 1200, 0, '', '', 0, '16', '', 'cash', 1),
(77, '2016-01-12', 'BILL0000000068', '', 0, '16', 1400, 0, '', '', 0, '16', '', 'cash', 1),
(78, '2016-01-12', 'BILL0000000069', '', 0, '16', 1000, 0, '', '', 0, '16', '', 'cash', 1),
(79, '2016-01-12', 'BILL0000000070', '', 0, '16', 1800, 0, '', '', 0, '16', '', 'cash', 1),
(80, '2016-01-12', 'BILL0000000071', '', 0, '16', 3000, 0, '', '', 0, '16', '', 'cash', 1),
(81, '2016-01-12', 'BILL0000000072', '', 0, '16', 2000, 0, '', '', 0, '16', '', 'cash', 1),
(82, '2016-01-12', 'BILL0000000073', '', 0, '16', 1200, 0, '', '', 0, '16', '', 'cash', 1),
(83, '2016-01-12', 'BILL0000000074', '', 0, '16', 7500, 0, '', '', 0, '16', '', 'cash', 1),
(84, '2016-01-12', 'BILL0000000075', '', 0, '16', 1100, 0, '', '', 0, '16', '', 'cash', 1),
(85, '2016-01-12', 'BILL0000000076', '', 0, '16', 1500, 0, '', '', 0, '16', '', 'cash', 1),
(86, '2016-01-12', 'BILL0000000077', '', 0, '16', 4000, 0, '', '', 0, '16', '', 'cash', 1),
(87, '2016-01-12', 'BILL0000000078', '', 0, '16', 1300, 0, '', '', 0, '16', '', 'cash', 1),
(88, '2016-01-12', 'BILL0000000079', '', 0, '16', 1200, 0, '', '', 0, '16', '', 'cash', 1),
(89, '2016-01-12', 'BILL0000000080', '', 0, '16', 3000, 0, '', '', 0, '16', '', 'cash', 1),
(90, '2016-01-12', 'BILL0000000081', '', 0, '16', 1300, 0, '', '', 0, '16', '', 'cash', 1),
(91, '2016-01-12', 'BILL0000000082', '', 0, '16', 700, 0, '', '', 0, '16', '', 'cash', 1),
(92, '2016-01-13', 'BILL0000000083', '', 0, '16', 1400, 0, '', '2016-01-13', 2, '16', '', 'bank', 1),
(93, '2016-01-13', 'BILL0000000084', '', 0, '16', 1300, 0, '', '', 0, '16', '', 'cash', 1),
(94, '2016-01-13', 'BILL0000000085', '', 0, '16', 1000, 0, '', '', 0, '16', '', 'cash', 1),
(95, '2016-01-02', 'EX0000000001', '', 0, '10', 0, 9500, '', '', 0, 'Expense', '', 'cash', 1),
(96, '2016-01-02', 'EX0000000002', '', 0, '10', 0, 8500, '', '', 0, 'Expense', '', 'cash', 1),
(97, '2016-01-02', 'EX0000000003', '', 0, '10', 0, 9000, '', '', 0, 'Expense', 'BSRM Daily Work purpose total 19 days payment.', 'cash', 1),
(98, '2016-01-02', 'EX0000000004', '', 0, '10', 0, 9500, '', '', 0, 'Expense', 'BSRM Daily Work purpose total 19 days payment.', 'cash', 1),
(99, '2016-01-04', 'BILL0000000086', '', 0, '26', 0, 5000, '', '', 0, '26', 'Cash paid to BSC purpose', 'cash', 1),
(100, '2016-01-04', 'BILL0000000087', '', 0, '27', 0, 4400, '', '', 0, '27', '1 pair A side MC 10 pk cable tai & 10 pcs p cord.', 'cash', 1),
(101, '2016-01-05', 'BILL0000000088', '', 0, '28', 0, 18200, '', '', 0, '28', 'For Dec-15', 'cash', 1),
(102, '2016-01-05', 'BILL0000000089', '', 0, '30', 0, 23200, '', '', 0, '30', 'Office Rent payment for Dec-15', 'cash', 1),
(103, '2016-01-05', 'BILL0000000089', '', 0, '28', 0, 25200, '3748', '2016-01-05', 2, 'BILL0000000089', '', 'bank', 1),
(106, '2016-01-07', 'BILL0000000090', '', 0, '9', 2100, 0, '', '', 0, '9', 'Old Battery sale', 'cash', 1),
(105, '2016-01-06', '2016-000003', '', 1, '3', 0, 120000, '0813745', '2016-01-06', 2, '', '', 'bank', 1),
(107, '2016-01-07', 'BILL0000000091', '', 0, '20', 3000, 0, '', '', 0, '20', 'T S Traders New Conn. Up', 'cash', 1),
(108, '2016-01-10', 'BILL0000000092', '', 0, '31', 500, 0, '', '', 0, '31', '129 no Marine', 'cash', 1),
(109, '2016-01-11', 'BILL0000000093', '', 0, '20', 3000, 0, '', '', 0, '20', 'Abul Shafi Alam Khan', 'cash', 1),
(110, '2016-01-11', 'BILL0000000094', '', 0, '32', 4000, 0, '', '', 0, '32', 'LHF Trading .com', 'cash', 1),
(111, '2016-01-11', 'BILL0000000095', '', 0, '20', 3000, 0, '', '', 0, '20', 'Faju bhai, Mr Jewel link up', 'cash', 1),
(112, '2016-01-12', 'BILL0000000096', '', 0, '20', 3000, 0, '', '', 0, '20', 'K M Shahidul Karim link Up', 'cash', 1),
(113, '2016-01-12', 'BILL0000000097', '', 0, '16', 500, 0, '', '', 0, '16', 'Shahidul Karim', 'cash', 1),
(114, '2016-01-04', 'BILL0000000098', '', 0, '33', 465252, 0, '990230', '2016-01-04', 2, 'BILL0000000098', '', 'bank', 1),
(115, '2016-01-05', 'BILL0000000098', '', 0, '16', 3600, 0, '', '2016-01-05', 2, 'BILL0000000098', '', 'bank', 1),
(116, '2016-01-13', 'BILL0000000099', '', 0, '16', 700, 0, '', '', 0, '16', 'Mr Jubair Ahmed', 'cash', 1),
(117, '2016-01-13', 'BILL0000000100', '', 0, '16', 1000, 0, '', '', 0, '16', 'Md Jahidul Islam', 'cash', 1),
(118, '2016-01-13', 'BILL0000000101', '', 0, '16', 800, 0, '', '', 0, '16', 'Lubna nasrin', 'cash', 1),
(119, '2016-01-13', 'BILL0000000102', '', 0, '16', 1500, 0, '', '', 0, '16', 'Mr Rajib barua', 'cash', 1),
(120, '2016-01-13', 'BILL0000000103', '', 0, '16', 800, 0, '', '', 0, '16', 'Nazim uddin', 'cash', 1),
(121, '2016-01-13', 'BILL0000000104', '', 0, '16', 1000, 0, '', '', 0, '16', 'Nasir Uddin', 'cash', 1),
(122, '2016-01-13', 'BILL0000000105', '', 0, '16', 1200, 0, '', '', 0, '16', 'Nawab Ashlam', 'cash', 1),
(123, '2016-01-13', 'BILL0000000106', '', 0, '16', 1300, 0, '', '', 0, '16', 'Mr Rayhan', 'cash', 1),
(124, '2016-01-13', 'BILL0000000107', '', 0, '16', 1400, 0, '', '', 0, '16', 'Exact Textlie', 'cash', 1),
(125, '2016-01-13', 'BILL0000000108', '', 0, '16', 1000, 0, '', '', 0, '16', 'Mr nishan', 'cash', 1),
(126, '2016-01-13', 'BILL0000000109', '', 0, '16', 600, 0, '', '', 0, '16', ' Jalal Uddin', 'cash', 1),
(127, '2016-01-13', 'BILL0000000110', '', 0, '16', 1100, 0, '', '', 0, '16', 'Care dent', 'cash', 1),
(128, '2016-01-13', 'BILL0000000111', '', 0, '16', 600, 0, '', '', 0, '16', 'Shamima akter', 'cash', 1),
(129, '2016-01-13', 'BILL0000000112', '', 0, '16', 1000, 0, '', '', 0, '16', 'Mr shamimul islam', 'cash', 1),
(130, '2016-01-13', 'BILL0000000112', '', 0, '16', 1000, 0, '', '', 0, '16', 'Mr shamimul islam', 'cash', 1),
(131, '2016-01-13', 'BILL0000000113', '', 0, '16', 2400, 0, '', '1970-01-01', 2, '16', 'ISBL', 'bank', 1),
(132, '2016-01-14', 'BILL0000000114', '', 0, '16', 1000, 0, '', '', 0, '16', 'Mr Rubel Das', 'cash', 1),
(133, '2016-01-14', 'BILL0000000115', '', 0, '16', 1800, 0, '', '', 0, '16', 'S.M.Farhad', 'cash', 1),
(134, '2016-01-14', 'BILL0000000116', '', 0, '16', 800, 0, '', '', 0, '16', 'New Fashion', 'cash', 1),
(135, '2016-01-14', 'BILL0000000117', '', 0, '16', 2400, 0, '', '', 0, '16', 'Jashia mudha', 'cash', 1),
(136, '2016-01-14', 'BILL0000000118', '', 0, '16', 4000, 0, '', '', 0, '16', 'Mr abu taher paid for dec-15', 'cash', 1),
(137, '2016-01-14', 'BILL0000000119', '', 0, '16', 4000, 0, '', '', 0, '16', 'Mr abu taher paid for jan-15', 'cash', 1),
(138, '2016-01-14', 'BILL0000000120', '', 0, '16', 500, 0, '', '', 0, '16', 'Ifthy music', 'cash', 1),
(139, '2016-01-14', 'BILL0000000121', '', 0, '16', 3000, 0, '', '', 0, '16', 'Media tech', 'cash', 1),
(140, '2016-01-14', 'BILL0000000122', '', 0, '16', 1000, 0, '', '', 0, '16', 'Kins computs', 'cash', 1),
(141, '2016-01-14', 'BILL0000000123', '', 0, '16', 600, 0, '', '', 0, '16', 'J N Computs', 'cash', 1),
(142, '2016-01-14', 'BILL0000000124', '', 0, '16', 600, 0, '', '', 0, '16', 'Fakrul Islam', 'cash', 1),
(143, '2016-01-14', 'BILL0000000125', '', 0, '16', 3000, 0, '', '', 0, '16', 'CTG.tell', 'cash', 1),
(144, '2016-01-14', 'BILL0000000126', '', 0, '16', 1400, 0, '', '', 0, '16', 'Jubair islam', 'cash', 1),
(145, '2016-01-14', 'BILL0000000127', '', 0, '16', 1100, 0, '', '', 0, '16', 'Ahasn habib', 'cash', 1),
(146, '2016-01-14', 'BILL0000000128', '', 0, '16', 2400, 0, '', '', 0, '16', 'Photo Expart', 'cash', 1),
(147, '2016-01-14', 'BILL0000000129', '', 0, '16', 2000, 0, '', '', 0, '16', 'Mr Ashrfuddowla', 'cash', 1),
(148, '2016-01-14', 'BILL0000000130', '', 0, '16', 1000, 0, '', '', 0, '16', 'Ehsanul Hoque', 'cash', 1),
(149, '2016-01-14', 'BILL0000000131', '', 0, '16', 500, 0, '', '', 0, '16', 'Shahbas khan', 'cash', 1),
(150, '2016-01-14', 'BILL0000000132', '', 0, '16', 400, 0, '', '', 0, '16', 'Mr joneid', 'cash', 1),
(151, '2016-01-16', 'BILL0000000133', '', 0, '16', 700, 0, '', '', 0, '16', 'Mr jamal ahemed', 'cash', 1),
(152, '2016-01-16', 'BILL0000000134', '', 0, '16', 600, 0, '', '', 0, '16', 'Sayed Ibrahim', 'cash', 1),
(153, '2016-01-16', 'BILL0000000135', '', 0, '16', 1000, 0, '', '', 0, '16', 'Syed solaiman', 'cash', 1),
(154, '2016-01-16', 'BILL0000000136', '', 0, '16', 1000, 0, '', '', 0, '16', 'Shafiqul Quader sajjad', 'cash', 1),
(155, '2016-01-16', 'BILL0000000137', '', 0, '16', 800, 0, '', '', 0, '16', 'Ziaur Rahman', 'cash', 1),
(156, '2016-01-16', 'BILL0000000138', '', 0, '16', 800, 0, '', '', 0, '16', 'Prime Assets', 'cash', 1),
(157, '2016-01-16', 'BILL0000000139', '', 0, '16', 1000, 0, '', '', 0, '16', 'Hasan Corpporation', 'cash', 1),
(158, '2016-01-16', 'BILL0000000140', '', 0, '16', 1200, 0, '', '', 0, '16', 'Arif sadiq chy', 'cash', 1),
(159, '2016-01-16', 'BILL0000000141', '', 0, '16', 2000, 0, '', '', 0, '16', 'Family Electronics', 'cash', 1),
(160, '2016-01-16', 'BILL0000000142', '', 0, '16', 4000, 0, '', '', 0, '16', 'Tofa vedio', 'cash', 1),
(161, '2016-01-16', 'BILL0000000143', '', 0, '16', 1200, 0, '', '', 0, '16', 'N M Honda', 'cash', 1),
(162, '2016-01-16', 'BILL0000000144', '', 0, '16', 1500, 0, '', '', 0, '16', 'Mr Ziko Gosh', 'cash', 1),
(163, '2016-01-16', 'BILL0000000145', '', 0, '16', 1500, 0, '', '', 0, '16', 'RTV', 'cash', 1),
(164, '2016-01-16', 'BILL0000000146', '', 0, '16', 600, 0, '', '', 0, '16', 'Md Azim', 'cash', 1),
(165, '2016-01-17', 'BILL0000000147', '', 0, '16', 2000, 0, '', '2016-01-16', 2, '16', 'BSAA', 'bank', 1),
(166, '2016-01-17', 'BILL0000000148', '', 0, '16', 1000, 0, '', '', 0, '16', 'New S Alam hardware ', 'cash', 1),
(167, '2016-01-17', 'BILL0000000149', '', 0, '16', 600, 0, '', '', 0, '16', 'Lipton Computer', 'cash', 1),
(168, '2016-01-17', 'BILL0000000150', '', 0, '16', 600, 0, '', '', 0, '16', 'Jusna Computer', 'cash', 1),
(169, '2016-01-17', 'BILL0000000151', '', 0, '16', 600, 0, '', '', 0, '16', 'Dibash Computer', 'cash', 1),
(170, '2016-01-17', 'BILL0000000152', '', 0, '16', 600, 0, '', '', 0, '16', 'Gousia Computer', 'cash', 1),
(171, '2016-01-17', 'BILL0000000153', '', 0, '16', 1200, 0, '', '', 0, '16', 'Onnana Book', 'cash', 1),
(172, '2016-01-17', 'BILL0000000154', '', 0, '16', 600, 0, '', '', 0, '16', 'Computer Plus', 'cash', 1),
(173, '2016-01-17', 'BILL0000000155', '', 0, '16', 600, 0, '', '', 0, '16', 'Biton Computer', 'cash', 1),
(174, '2016-01-17', 'BILL0000000156', '', 0, '16', 1000, 0, '', '', 0, '16', 'Sunny Cmputer', 'cash', 1),
(175, '2016-01-17', 'BILL0000000157', '', 0, '16', 1000, 0, '', '', 0, '16', 'Md.Parvez ', 'cash', 1),
(176, '2016-01-17', 'BILL0000000158', '', 0, '16', 1000, 0, '', '', 0, '16', 'Ziaul Hoqe', 'cash', 1),
(177, '2016-01-17', 'BILL0000000159', '', 0, '16', 1300, 0, '', '', 0, '16', 'Land MArk (Faruk)', 'cash', 1),
(178, '2016-01-17', 'BILL0000000160', '', 0, '16', 4500, 0, '', '', 0, '16', 'IDAS Fashion', 'cash', 1),
(179, '2016-01-17', 'BILL0000000161', '', 0, '16', 700, 0, '', '', 0, '16', 'Shahedul Islam', 'cash', 1),
(180, '2016-01-17', 'BILL0000000162', '', 0, '16', 800, 0, '', '', 0, '16', 'Shahedul Islam.', 'cash', 1),
(181, '2016-01-18', 'BILL0000000163', '', 0, '16', 500, 0, '', '', 0, '16', 'CTG Modern Academy', 'cash', 1),
(182, '2016-01-18', 'BILL0000000164', '', 0, '16', 2400, 0, '', '', 0, '16', 'Mr.Khosru ', 'cash', 1),
(183, '2016-01-18', 'BILL0000000165', '', 0, '16', 1200, 0, '', '', 0, '16', 'Maa Telecom', 'cash', 1),
(184, '2016-01-18', 'BILL0000000166', '', 0, '16', 1900, 0, '', '', 0, '16', 'Brother Communication', 'cash', 1),
(185, '2016-01-18', 'BILL0000000167', '', 0, '16', 10000, 0, '', '', 0, '16', 'M A Kuddus ', 'cash', 1),
(186, '2016-01-18', 'BILL0000000168', '', 0, '16', 1000, 0, '', '', 0, '16', 'Mr. Khairul Anam Chotto', 'cash', 1),
(187, '2016-01-18', 'BILL0000000169', '', 0, '16', 1000, 0, '', '', 0, '16', 'Mr. Khairul Anam Chotto', 'cash', 1),
(188, '2016-01-18', 'BILL0000000170', '', 0, '16', 1000, 0, '', '', 0, '16', 'Mr. Khairul Anam Chotto', 'cash', 1),
(189, '2016-01-18', 'BILL0000000171', '', 0, '16', 2000, 0, '', '', 0, '16', 'Sumetal', 'cash', 1),
(190, '2016-01-18', 'BILL0000000172', '', 0, '16', 1500, 0, '', '', 0, '16', 'Spark Polly', 'cash', 1),
(191, '2016-01-18', 'BILL0000000173', '', 0, '16', 1400, 0, '', '', 0, '16', 'Salman Hasnat', 'cash', 1),
(192, '2016-01-18', 'BILL0000000174', '', 0, '16', 1400, 0, '', '', 0, '16', 'Salman Hasnat', 'cash', 1),
(193, '2016-01-18', 'BILL0000000175', '', 0, '16', 2500, 0, '', '', 0, '16', 'Drothy Moon', 'cash', 1),
(194, '2016-01-18', 'BILL0000000176', '', 0, '16', 1400, 0, '', '', 0, '16', 'Mikdad Bin Hanif', 'cash', 1),
(195, '2016-01-18', 'BILL0000000177', '', 0, '16', 1400, 0, '', '', 0, '16', 'Mikdad Bin Hanif', 'cash', 1),
(196, '2016-01-18', 'BILL0000000178', '', 0, '16', 1500, 0, '7180965', '2016-01-18', 2, '16', 'Best Bangla', 'bank', 1),
(197, '2016-01-18', 'BILL0000000179', '', 0, '16', 1500, 0, '7180965', '2016-01-18', 2, '16', 'Best Bangla', 'bank', 1),
(198, '2016-01-18', 'BILL0000000180', '', 0, '16', 2800, 0, '', '', 0, '16', 'Al Marsus', 'cash', 1),
(199, '2016-01-18', 'BILL0000000181', '', 0, '16', 600, 0, '', '', 0, '16', 'Run Way', 'cash', 1),
(200, '2016-01-18', 'BILL0000000182', '', 0, '16', 2500, 0, '', '', 0, '16', 'Kuliarchr Filling Station', 'cash', 1),
(201, '2016-01-18', 'BILL0000000183', '', 0, '16', 3000, 0, '', '', 0, '16', 'J.P Trading', 'cash', 1),
(202, '2016-01-18', 'BILL0000000184', '', 0, '16', 1000, 0, '', '', 0, '16', 'Unitex Garments', 'cash', 1),
(203, '2016-01-18', 'BILL0000000185', '', 0, '16', 2000, 0, '', '', 0, '16', 'C F C', 'cash', 1),
(204, '2016-01-18', 'BILL0000000186', '', 0, '16', 1000, 0, '', '', 0, '16', 'C F C', 'cash', 1),
(205, '2016-01-18', 'BILL0000000187', '', 0, '16', 10000, 0, '', '1970-01-01', 2, '16', 'Perple telecom', 'bank', 1),
(206, '2016-01-18', 'BILL0000000188', '', 0, '16', 600, 0, '', '', 0, '16', 'Chawk fansi', 'cash', 1),
(207, '2016-01-18', 'BILL0000000189', '', 0, '16', 600, 0, '', '', 0, '16', 'Al mokkha', 'cash', 1),
(208, '2016-01-18', 'BILL0000000190', '', 0, '16', 600, 0, '', '', 0, '16', 'Banskhali', 'cash', 1),
(209, '2016-01-18', 'BILL0000000191', '', 0, '16', 1400, 0, '', '', 0, '16', 'Bornil', 'cash', 1),
(210, '2016-01-18', 'BILL0000000192', '', 0, '16', 600, 0, '', '', 0, '16', 'Computech', 'cash', 1),
(211, '2016-01-18', 'BILL0000000193', '', 0, '16', 600, 0, '', '', 0, '16', 'Nor enterprise', 'cash', 1),
(212, '2016-01-18', 'BILL0000000194', '', 0, '16', 600, 0, '', '', 0, '16', 'Labia', 'cash', 1),
(213, '2016-01-18', 'BILL0000000195', '', 0, '16', 3000, 0, '', '', 0, '16', 'Blue sense', 'cash', 1),
(214, '2016-01-18', 'BILL0000000196', '', 0, '16', 1600, 0, '', '', 0, '16', 'Md abu taher', 'cash', 1),
(215, '2016-01-18', 'BILL0000000197', '', 0, '16', 2000, 0, '', '', 0, '16', 'Neckles', 'cash', 1),
(216, '2016-01-18', 'BILL0000000198', '', 0, '16', 2500, 0, '', '', 0, '16', 'Westren tes', 'cash', 1),
(217, '2016-01-18', 'BILL0000000199', '', 0, '16', 1500, 0, '', '', 0, '16', 'Arehe spsce', 'cash', 1),
(218, '2016-01-18', 'BILL0000000200', '', 0, '16', 3500, 0, '', '', 0, '16', 'BD Agreculture', 'cash', 1),
(219, '2016-01-18', 'BILL0000000201', '', 0, '16', 1500, 0, '', '', 0, '16', 'Vision Dainostic', 'cash', 1),
(220, '2016-01-18', 'BILL0000000202', '', 0, '16', 1400, 0, '', '', 0, '16', 'Agrani insurance', 'cash', 1),
(221, '2016-01-18', 'BILL0000000203', '', 0, '16', 4000, 0, '', '', 0, '16', 'Meah bibi', 'cash', 1),
(222, '2016-01-18', 'BILL0000000204', '', 0, '16', 500, 0, '', '', 0, '16', 'Atiqur Rahman', 'cash', 1),
(223, '2016-01-18', 'BILL0000000205', '', 0, '16', 26000, 0, '', '', 0, '16', 'Fair Products', 'cash', 1),
(224, '2016-01-20', 'BILL0000000206', '', 0, '16', 1000, 0, '', '', 0, '16', 'Md Iqbal Hossain', 'cash', 1),
(225, '2016-01-14', 'BILL0000000207', '', 0, '16', 1600, 0, '', '', 0, '16', 'Mr Arif Khan ', 'cash', 1),
(226, '2016-01-14', 'BILL0000000208', '', 0, '21', 1200, 0, '', '', 0, '21', 'Freom BSRM Baijeed', 'cash', 1),
(227, '2016-01-14', 'BILL0000000209', '', 0, '21', 1400, 0, '', '', 0, '21', 'From BSRM Vatiary', 'cash', 1),
(228, '2016-01-16', 'BILL0000000210', '', 0, '33', 20000, 0, '', '', 0, '33', 'From Monir Bhai against Ananda Glass', 'cash', 1),
(229, '2016-01-16', 'BILL0000000211', '', 0, '20', 1300, 0, '', '', 0, '20', 'Tanvir Enterprise wasa', 'cash', 1),
(230, '2016-01-28', 'BILL0000000212', '', 0, '21', 400, 0, '', '', 0, '21', 'panclaish', 'cash', 1),
(231, '2016-01-18', 'BILL0000000213', '', 0, '16', 1000, 0, '', '', 0, '16', 'Md Nazim Uddin', 'cash', 1),
(232, '2016-01-18', 'BILL0000000214', '', 0, '16', 500, 0, '', '', 0, '16', 'mohammadia for new bandwidth.', 'cash', 1),
(233, '2016-01-18', 'BILL0000000215', '', 0, '16', 600, 0, '', '', 0, '16', 'for new billing a/c', 'cash', 1),
(234, '2016-01-18', 'BILL0000000216', '', 0, '28', 3500, 0, '', '', 0, '28', 'From Mr Tutul for rent', 'cash', 1),
(235, '2016-01-28', 'BILL0000000217', '', 0, '20', 9000, 0, '', '', 0, '20', 'fulkoli direcrs house link up purpose.', 'cash', 1),
(236, '2016-01-28', 'BILL0000000218', '', 0, '16', 1500, 0, '', '', 0, '16', 'unique international', 'cash', 1),
(237, '2016-01-18', 'BILL0000000219', '', 0, '33', 21000, 0, '', '', 0, '33', 'From Monir Bhai against Ananda Glass', 'cash', 1),
(238, '2016-01-20', 'BILL0000000220', '', 0, '16', 800, 0, '', '', 0, '16', 'Max intl', 'cash', 1),
(239, '2016-01-20', 'BILL0000000221', '', 0, '16', 800, 0, '', '', 0, '16', 'Taif Overseas', 'cash', 1),
(240, '2016-01-20', 'BILL0000000222', '', 0, '16', 2000, 0, '', '', 0, '16', 'Libass Mimi', 'cash', 1),
(241, '2016-01-20', 'BILL0000000223', '', 0, '16', 1000, 0, '', '', 0, '16', 'Amir Trade', 'cash', 1),
(242, '2016-01-20', 'BILL0000000224', '', 0, '16', 1200, 0, '', '', 0, '16', 'Md Borhan Chy', 'cash', 1),
(243, '2016-01-20', 'BILL0000000225', '', 0, '16', 1500, 0, '', '', 0, '16', 'STTC', 'cash', 1),
(244, '2016-01-20', 'BILL0000000226', '', 0, '16', 2800, 0, '', '', 0, '16', 'Alauddin', 'cash', 1),
(245, '2016-01-20', 'BILL0000000227', '', 0, '16', 1100, 0, '', '', 0, '16', 'Eskandar', 'cash', 1),
(246, '2016-01-20', 'BILL0000000228', '', 0, '16', 1000, 0, '', '', 0, '16', 'D M Corporation', 'cash', 1),
(247, '2016-01-21', 'BILL0000000229', '', 0, '16', 500, 0, '', '', 0, '16', 'Nafisa enterprise', 'cash', 1),
(248, '2016-01-21', 'BILL0000000230', '', 0, '16', 600, 0, '', '', 0, '16', 'Enjoy tel', 'cash', 1),
(249, '2016-01-21', 'BILL0000000231', '', 0, '16', 600, 0, '', '', 0, '16', 'Tutul Enterprise', 'cash', 1),
(250, '2016-01-21', 'BILL0000000232', '', 0, '16', 600, 0, '', '', 0, '16', 'Shedow tel', 'cash', 1),
(251, '2016-01-21', 'BILL0000000233', '', 0, '16', 2000, 0, '', '', 0, '16', 'Hair  & Fair', 'cash', 1),
(252, '2016-01-21', 'BILL0000000234', '', 0, '16', 2000, 0, '', '', 0, '16', 'khaleda Awal', 'cash', 1),
(253, '2016-01-23', 'BILL0000000235', '', 0, '16', 1000, 0, '', '', 0, '16', 'Syedul Hasan khan', 'cash', 1),
(254, '2016-01-23', 'BILL0000000236', '', 0, '16', 1000, 0, '', '', 0, '16', 'Shahid uddin Bhy', 'cash', 1),
(255, '2016-01-23', 'BILL0000000237', '', 0, '16', 12000, 0, '', '', 0, '16', 'Libass', 'cash', 1),
(256, '2016-01-23', 'BILL0000000238', '', 0, '16', 15800, 0, '', '2016-01-23', 1, '16', 'Amber IT', 'bank', 1),
(257, '2016-01-24', 'BILL0000000239', '', 0, '16', 700, 0, '', '', 0, '16', 'BAS Machinery ', 'cash', 1),
(258, '2016-01-24', 'BILL0000000240', '', 0, '16', 700, 0, '', '', 0, '16', 'BAS Machinery', 'cash', 1),
(259, '2016-01-24', 'BILL0000000241', '', 0, '16', 700, 0, '', '', 0, '16', 'BAS Machinery', 'cash', 1),
(260, '2016-01-24', 'BILL0000000242', '', 0, '16', 600, 0, '', '', 0, '16', 'Tanvir Rahman', 'cash', 1),
(261, '2016-01-24', 'BILL0000000243', '', 0, '16', 600, 0, '', '', 0, '16', 'Tanvir Rahman', 'cash', 1),
(262, '2016-01-24', 'BILL0000000244', '', 0, '16', 600, 0, '', '', 0, '16', 'Tanvir Rahman', 'cash', 1),
(263, '2016-01-24', 'BILL0000000245', '', 0, '16', 2300, 0, '', '2016-01-24', 2, '16', 'Liang fashion', 'bank', 1),
(264, '2016-01-24', 'BILL0000000246', '', 0, '16', 600, 0, '', '', 0, '16', 'Gadget', 'cash', 1),
(265, '2016-01-24', 'BILL0000000247', '', 0, '16', 600, 0, '', '', 0, '16', 'Gedget', 'cash', 1),
(266, '2016-01-24', 'BILL0000000248', '', 0, '16', 500, 0, '', '', 0, '16', 'Kamrul Islam Kazal', 'cash', 1),
(267, '2016-01-24', 'BILL0000000249', '', 0, '16', 2000, 0, '', '', 0, '16', 'Golam Mahmud', 'cash', 1),
(268, '2016-01-24', 'BILL0000000250', '', 0, '16', 4000, 0, '', '', 0, '16', 'Creative workshop', 'cash', 1),
(269, '2016-01-24', 'BILL0000000251', '', 0, '16', 4000, 0, '', '', 0, '16', 'Creative workshop', 'cash', 1),
(270, '2016-01-25', 'BILL0000000252', '', 0, '16', 500, 0, '', '', 0, '16', 'IMIRAS', 'cash', 1),
(271, '2016-01-25', 'BILL0000000253', '', 0, '16', 700, 0, '', '', 0, '16', 'Rafco', 'cash', 1),
(272, '2016-01-25', 'BILL0000000254', '', 0, '16', 600, 0, '', '', 0, '16', 'Rakibul hasan', 'cash', 1),
(273, '2016-01-25', 'BILL0000000255', '', 0, '16', 1500, 0, '', '', 0, '16', 'S K R Attier', 'cash', 1),
(274, '2016-01-25', 'BILL0000000256', '', 0, '16', 1600, 0, '', '', 0, '16', 'Royel Associates', 'cash', 1),
(275, '2016-01-25', 'BILL0000000257', '', 0, '16', 800, 0, '', '', 0, '16', 'Syed firoz kabir', 'cash', 1),
(276, '2016-01-25', 'BILL0000000258', '', 0, '16', 500, 0, '', '', 0, '16', 'Afroza Zaman', 'cash', 1),
(277, '2016-01-25', 'BILL0000000259', '', 0, '16', 500, 0, '', '', 0, '16', 'Afroza Zaman', 'cash', 1),
(278, '2016-01-25', 'BILL0000000260', '', 0, '16', 1000, 0, '', '', 0, '16', 'Holy Makkah', 'cash', 1),
(279, '2016-01-25', 'BILL0000000261', '', 0, '16', 1000, 0, '', '', 0, '16', 'Holy Makkah', 'cash', 1),
(280, '2016-01-25', 'BILL0000000262', '', 0, '16', 1000, 0, '', '', 0, '16', 'Holy Makkah', 'cash', 1),
(281, '2016-01-25', 'BILL0000000263', '', 0, '16', 1000, 0, '', '', 0, '16', 'Holy Makkah', 'cash', 1),
(282, '2016-01-26', 'BILL0000000264', '', 0, '16', 5000, 0, '7803793', '2016-01-25', 2, '16', 'IBIT', 'bank', 1),
(283, '2016-01-26', 'BILL0000000265', '', 0, '16', 600, 0, '', '', 0, '16', 'Julia Oishi', 'cash', 1),
(284, '2016-01-26', 'BILL0000000266', '', 0, '16', 600, 0, '', '', 0, '16', 'Century tel', 'cash', 1),
(285, '2016-01-26', 'BILL0000000267', '', 0, '16', 600, 0, '', '', 0, '16', 'Digital Computer', 'cash', 1),
(286, '2016-01-26', 'BILL0000000268', '', 0, '16', 600, 0, '', '', 0, '16', 'Digital Computer', 'cash', 1),
(287, '2016-01-26', 'BILL0000000269', '', 0, '16', 2500, 0, '', '', 0, '16', 'Saz Fashion', 'cash', 1),
(288, '2016-01-26', 'BILL0000000270', '', 0, '16', 2500, 0, '', '', 0, '16', 'Ayon Gold', 'cash', 1),
(289, '2016-01-26', 'BILL0000000271', '', 0, '16', 2500, 0, '', '', 0, '16', 'Ayon Gold', 'cash', 1),
(290, '2016-01-27', 'BILL0000000272', '', 0, '16', 1500, 0, '', '', 0, '16', 'RTV', 'cash', 1),
(291, '2016-01-27', 'BILL0000000273', '', 0, '16', 800, 0, '', '', 0, '16', 'Roksana Begum', 'cash', 1),
(292, '2016-01-27', 'BILL0000000274', '', 0, '16', 800, 0, '', '', 0, '16', 'Roksana Begum', 'cash', 1),
(293, '2016-01-27', 'BILL0000000275', '', 0, '16', 800, 0, '', '', 0, '16', 'Roksana Begum', 'cash', 1),
(294, '2016-01-27', 'BILL0000000276', '', 0, '16', 2000, 0, '', '', 0, '16', 'Fair Holyday', 'cash', 1),
(295, '2016-01-20', 'BILL0000000277', '', 0, '34', 20000, 0, '', '', 0, '34', 'Interns student collection', 'cash', 1),
(296, '2016-01-24', 'BILL0000000278', '', 0, '9', 300, 0, '', '', 0, '9', 'Cat 5E 30mtr ', 'cash', 1),
(297, '2016-01-25', 'BILL0000000279', '', 0, '20', 3000, 0, '', '', 0, '20', 'mr Atiqul Islam  O R Nizam rd link up', 'cash', 1),
(298, '2016-01-25', 'BILL0000000280', '', 0, '16', 10000, 0, '', '', 0, '16', 'Mr M A Kuddus', 'cash', 1),
(299, '2016-01-28', 'BILL0000000281', '', 0, '33', 10000, 0, '', '', 0, '33', 'Anwarul Islam Academy 1 kilo meter', 'cash', 1),
(300, '2016-01-25', 'BILL0000000282', '', 0, '33', 8700, 0, '5245313', '2016-01-25', 2, 'BILL0000000282', '', 'bank', 1),
(301, '2016-01-04', 'BILL0000000283', '', 0, '16', 37400, 0, '', '', 0, '16', '@/1/16 to4/1/16 net bill collection', 'cash', 1),
(302, '2016-01-02', 'BILL0000000284', '', 0, '33', 5000, 0, '', '', 0, '33', 'Anwarul Islam Academy 1 kilo meter', 'cash', 1),
(303, '2016-01-03', 'BILL0000000285', '', 0, '20', 2000, 0, '', '', 0, '20', 'jabed mobile center', 'cash', 1),
(304, '2016-01-04', 'BILL0000000286', '', 0, '20', 3000, 0, '', '', 0, '20', 'Mr Arif Khan ', 'cash', 1),
(305, '2016-01-06', 'BILL0000000287', '', 0, '16', 39625, 0, '', '', 0, '16', '4/1/16 to 6/1/16 total collection', 'cash', 1),
(306, '2016-01-05', 'BILL0000000288', '', 0, '20', 3000, 0, '', '', 0, '20', 'madhuban', 'cash', 1),
(307, '2016-01-06', 'BILL0000000289', '', 0, '20', 4000, 0, '', '', 0, '20', 'sakib enterprise ', 'cash', 1),
(308, '2016-01-05', 'EX0000000005', '', 0, '10', 0, 19000, '', '2016-01-05', 2, 'EX0000000005', '', 'bank', 1),
(310, '2016-01-09', 'EX0000000006', '', 0, '10', 0, 20200, '3746', '2016-01-09', 2, 'EX0000000006', '', 'bank', 1),
(321, '', 'EX0000000007', '', 0, '', 0, 0, '', '', 0, '', '', '', 1),
(322, '2016-01-06', 'EX0000000007', '', 0, '10', 0, 11000, '3749', '2016-01-06', 2, 'EX0000000007', '', 'bank', 1),
(312, '2016-01-27', 'BILL0000000290', '', 0, '16', 900, 0, '', '', 0, '16', 'Sakawat Hosen', 'cash', 1),
(313, '2016-01-27', 'BILL0000000291', '', 0, '16', 1000, 0, '', '', 0, '16', 'Shah Amirul Hajj Kafela', 'cash', 1),
(314, '2016-01-27', 'BILL0000000292', '', 0, '16', 1000, 0, '', '', 0, '16', 'Shah Amirul Hajj Kafela', 'cash', 1),
(315, '2016-01-27', 'BILL0000000293', '', 0, '16', 1000, 0, '', '', 0, '16', 'Shah Amirul Hajj Kafela', 'cash', 1),
(316, '2016-01-27', 'BILL0000000294', '', 0, '16', 1000, 0, '', '', 0, '16', 'Shah Amirul Hajj Kafela', 'cash', 1),
(317, '2016-01-27', 'BILL0000000295', '', 0, '16', 1300, 0, '', '', 0, '16', 'Md Younus', 'cash', 1),
(318, '2016-01-27', 'BILL0000000296', '', 0, '16', 1200, 0, '', '', 0, '16', 'Romana Print', 'cash', 1),
(319, '2016-01-27', 'BILL0000000297', '', 0, '16', 4000, 0, '', '', 0, '16', 'Q- Tex', 'cash', 1),
(320, '2016-01-11', 'BILL0000000298', '', 0, '33', 30000, 0, '', '', 0, '33', 'Ananda glass for cctv bill', 'cash', 1),
(323, '2016-01-06', 'EX0000000008', '', 0, '10', 0, 2000, '', '', 0, 'Expense', 'For Nov-15', 'cash', 1),
(324, '2016-01-06', 'BILL0000000299', '', 0, '26', 0, 5000, '', '', 0, '26', 'Eid E Miladunnabi(sm)', 'cash', 1),
(325, '2016-01-06', 'EX0000000009', '', 0, '10', 0, 9500, '', '', 0, 'Expense', 'Nov-15', 'cash', 1),
(326, '2016-01-06', 'EX0000000010', '', 0, '10', 0, 15000, '', '', 0, 'Expense', 'Nov-15', 'cash', 1),
(327, '2016-01-07', 'EX0000000012', '', 0, '10', 0, 2700, '', '', 0, 'Expense', 'Pickup Servicing cost', 'cash', 1),
(328, '2016-01-07', 'EX0000000013', '', 0, '10', 0, 2500, '', '', 0, 'Expense', '20 pcs Patch Cord', 'cash', 1),
(329, '2016-01-07', 'EX0000000014', '', 0, '10', 0, 2670, '', '', 0, 'Expense', 'tampo repair & servicing', 'cash', 1),
(330, '2016-01-07', 'EX0000000015', '', 0, '10', 0, 1857, '', '', 0, 'Expense', '2553782 bill payment up to Dec-15', 'cash', 1),
(331, '2016-01-07', 'EX0000000016', '', 0, '10', 0, 1092, '', '', 0, 'Expense', 'Sky vision meter', 'cash', 1),
(332, '2016-01-07', 'EX0000000017', '', 0, '10', 0, 4500, '', '', 0, 'Expense', 'M C 2 pair', 'cash', 1),
(333, '2016-01-08', 'EX0000000018', '', 0, '10', 0, 5434, '', '', 0, 'Expense', 'All Staff For every daily work.', 'cash', 1),
(334, '2016-01-08', 'EX0000000019', '', 0, '10', 0, 2530, '', '', 0, 'Expense', 'for tampo, car and pickup', 'cash', 1),
(335, '2016-01-08', 'EX0000000020', '', 0, '10', 0, 3000, '', '', 0, 'Expense', 'For easy Net meter', 'cash', 1),
(336, '2016-01-08', 'EX0000000021', '', 0, '10', 0, 3400, '', '', 0, 'Expense', 'for pickup ', 'cash', 1),
(337, '2014-01-02', '', '', 6, '1', 0, 0, '', '', 0, 'supplier due', '', 'due', 1),
(338, '2016-01-08', '49', '', 6, '4', 0, 4150, '', '', 0, 'supplier payment', '', 'cash', 1),
(339, '2016-01-08', 'EX0000000022', '', 0, '10', 0, 1400, '', '', 0, 'Expense', '2 pcs power supply', 'cash', 1),
(340, '2016-01-08', 'EX0000000023', '', 0, '10', 0, 12200, '', '', 0, 'Expense', '2 pair Giga M C for office', 'cash', 1),
(341, '2016-01-08', 'EX0000000024', '', 0, '10', 0, 1275, '', '', 0, 'Expense', 'for office document', 'cash', 1),
(342, '2016-01-08', 'EX0000000025', '', 0, '10', 0, 545, '', '', 0, 'Expense', 'for office use ', 'cash', 1),
(343, '2016-01-08', 'EX0000000026', '', 0, '10', 0, 1080, '', '', 0, 'Expense', 'BNC Cable tai scrow and others for ip camera setup', 'cash', 1),
(344, '2016-01-08', 'BILL0000000326', '', 0, '26', 0, 1735, '', '', 0, '26', 'For BSRM work purpose', 'cash', 1),
(345, '2016-01-08', 'EX0000000027', '', 0, '10', 0, 300, '', '', 0, 'Expense', 'for Dec-15', 'cash', 1),
(346, '', 'EX0000000028', '', 0, '', 0, 0, '', '', 0, '', '', '', 1),
(347, '2016-01-10', 'EX0000000029', '', 0, '10', 0, 6000, '', '', 0, 'Expense', 'For Loan purpose monthly charge', 'cash', 1),
(348, '2016-01-10', 'EX0000000030', '', 0, '10', 0, 1000, '', '', 0, 'Expense', 'Hafez saheb for Dec-15', 'cash', 1),
(349, '2016-01-10', 'EX0000000031', '', 0, '10', 0, 15750, '', '', 0, 'Expense', 'For marine, sanjon and office for Jan-16', 'cash', 1),
(350, '2016-01-10', 'EX0000000032', '', 0, '10', 0, 6833, '', '', 0, 'Expense', 'Arif Noor For Nov-15', 'cash', 1),
(351, '2016-01-10', 'EX0000000033', '', 0, '10', 0, 2500, '', '', 0, 'Expense', 'for dhaka tour', 'cash', 1),
(352, '2016-01-12', 'EX0000000028', '', 0, '10', 0, 40100, '3750', '2016-01-12', 2, 'EX0000000028', '', 'bank', 1),
(353, '2014-01-02', '', '', 0, '36', 0, 1542644, '', '', 0, '', 'Starting loan from tagar bhai', 'due', 1),
(354, '2016-01-31', '06', '', 3, '5', 0, 2000, '', '', 0, 'supplier due', '', 'due', 1),
(355, '2016-01-11', '3751', '', 0, '12', 190000, 0, '3751', '2016-01-11', 2, 'Bank to Cash Transfer', '', 'cash', 1),
(356, '2016-01-11', '3751', '', 0, '12', 0, 190000, '3751', '2016-01-11', 2, 'Bank to Cash Transfer', '', 'bank', 1),
(357, '2016-01-11', 'EX0000000034', '', 0, '10', 0, 170115, '', '', 0, 'Expense', 'OTDR Machine Purchase', 'cash', 1),
(358, '2016-01-31', '000045', '', 1, '5', 0, 15715, '', '', 0, 'supplier due', '', 'due', 1),
(359, '2016-01-05', '000046', '', 1, '5', 0, 3850, '', '', 0, 'supplier due', '', 'due', 1),
(360, '2016-01-10', '000078', '', 1, '5', 0, 13600, '', '', 0, 'supplier due', '', 'due', 1),
(361, '2016-01-10', '000079', '', 1, '5', 0, 43750, '', '', 0, 'supplier due', '', 'due', 1),
(362, '2016-01-11', '000082', '', 1, '5', 0, 2800, '', '', 0, 'supplier due', '', 'due', 1),
(363, '2016-01-13', '000123', '', 1, '5', 0, 60450, '', '', 0, 'supplier due', '', 'due', 1),
(364, '2016-01-11', '000042', '', 1, '3', 0, 30000, '', '', 0, 'supplier due payment', '', 'cash', 1),
(365, '2016-01-11', 'EX0000000035', '', 0, '10', 0, 6900, '', '', 0, 'Expense', '3 pair net link m C for office', 'cash', 1),
(366, '2016-01-11', 'EX0000000036', '', 0, '10', 0, 1000, '', '', 0, 'Expense', 'Ref aconn', 'cash', 1),
(367, '2016-01-11', 'EX0000000037', '', 0, '10', 0, 7500, '', '', 0, 'Expense', 'Leser  Light', 'cash', 1),
(368, '2016-01-11', 'EX0000000038', '', 0, '10', 0, 6700, '', '', 0, 'Expense', 'Ktg to Moizzar Teck fiber rent', 'cash', 1),
(369, '2016-01-12', 'EX0000000039', '', 0, '10', 0, 20600, '', '', 0, 'Expense', ' Dhaka up down for OTDR purchase', 'cash', 1),
(370, '2016-01-12', 'EX0000000040', '', 0, '10', 0, 8419, '', '', 0, 'Expense', 'Oct-15 ', 'cash', 1),
(371, '2016-01-12', 'EX0000000041', '', 0, '10', 0, 2300, '', '', 0, 'Expense', 'M C D Net 1 pair', 'cash', 1),
(372, '2016-02-01', 'EX0000000042', '', 0, '10', 0, 2520, '', '', 0, 'Expense', '1008 pcs slipeer purchase for office', 'cash', 1),
(373, '2016-01-31', 'BILL0000000300', '', 0, '16', 1500, 0, '', '', 0, '16', 'Cool Tech', 'cash', 1),
(374, '2016-01-18', 'BILL0000000301', '', 0, '16', 1900, 0, '', '', 0, '16', 'Brothers Com', 'cash', 1),
(375, '2016-01-31', 'BILL0000000302', '', 0, '16', 2000, 0, '', '', 0, '16', 'Sadman Sakib', 'cash', 1),
(376, '2016-01-31', 'BILL0000000303', '', 0, '16', 600, 0, '', '', 0, '16', 'Sumon Ali', 'cash', 1),
(377, '2016-01-31', 'BILL0000000304', '', 0, '16', 1500, 0, '', '', 0, '16', 'M A Kabir', 'cash', 1),
(378, '2016-01-31', 'BILL0000000305', '', 0, '16', 8500, 0, '', '', 0, '16', 'Lubricant Asia', 'cash', 1),
(379, '2016-01-31', 'BILL0000000306', '', 0, '16', 6800, 0, '', '', 0, '16', 'Three Gem', 'cash', 1),
(380, '2016-02-01', 'EX0000000043', '', 0, '10', 0, 1480, '', '', 0, 'Expense', 'purchase 20 pk cable tai ', 'cash', 1),
(381, '2016-01-13', 'BILL0000000307', '', 0, '29', 0, 4000, '', '', 0, '29', 'R Bazar for Dec-15', 'cash', 1),
(382, '2016-01-13', 'EX0000000044', '', 0, '10', 0, 2390, '', '', 0, 'Expense', '1 pair MC from LB Dhaka', 'cash', 1),
(383, '2016-01-13', 'EX0000000045', '', 0, '10', 0, 6080, '', '', 0, 'Expense', 'new drill machine 1 pcs and 15pk cable tai for off', 'cash', 1),
(384, '2016-02-04', 'EX0000000046', '', 0, '10', 0, 31015, '', '', 0, 'Expense', 'for daily feeding bill in BSRM work', 'cash', 1),
(385, '2016-01-13', 'EX0000000047', '', 0, '10', 0, 8530, '', '', 0, 'Expense', 'cost for bSRM Mission', 'cash', 1),
(386, '2016-01-13', 'EX0000000048', '', 0, '10', 0, 10727, '', '', 0, 'Expense', 'variety item purchase for setup BSRM Network', 'cash', 1),
(387, '2016-01-13', 'EX0000000049', '', 0, '10', 0, 1842, '', '', 0, 'Expense', 'some item for won use in house', 'cash', 1),
(388, '2016-01-13', 'EX0000000050', '', 0, '10', 0, 3000, '', '', 0, 'Expense', 'for easy Net office', 'cash', 1),
(389, '2016-01-13', 'EX0000000051', '', 0, '10', 0, 10350, '', '', 0, 'Expense', 'labor up down cost  ', 'cash', 1),
(390, '2016-01-14', 'BILL0000000308', '', 0, '29', 0, 10000, '', '', 0, '29', 'Kulshi pop for Dec-16', 'cash', 1),
(391, '2016-01-16', 'BILL0000000309', '', 0, '29', 0, 1500, '', '', 0, '29', 'A K Khan Pop for Dec-15', 'cash', 1),
(392, '2016-01-16', 'EX0000000052', '', 0, '10', 0, 1270, '', '', 0, 'Expense', 'For Mr Shahid  BTRC officer', 'cash', 1),
(393, '2016-01-16', 'EX0000000053', '', 0, '10', 0, 190, '', '', 0, '34315670607287ts5MjAyNQ==30872r65176MDg=2098y542MDE=3281oi6329877261567060728', 'for carrying some accessories from dhaka.', 'li', 1),
(394, '', 'EX0000000054', '', 0, '', 0, 0, '', '', 0, '', '', '', 1),
(395, '', 'EX0000000055', '', 0, '', 0, 0, '', '', 0, '', '', '', 1),
(396, '2016-01-18', 'EX0000000056', '', 0, '10', 0, 2885, '', '', 0, 'Expense', 'for Gas and oil purchase', 'cash', 1),
(397, '2016-01-18', 'BILL0000000310', '', 0, '25', 0, 3102, '', '', 0, '25', 'For Marketing, support, bill collection & fiber te', 'cash', 1),
(398, '2016-01-18', 'BILL0000000311', '', 0, '37', 0, 1358, '', '', 0, '37', 'CCTV Accessories purchase', 'cash', 1),
(399, '2016-01-18', 'BILL0000000312', '', 0, '25', 0, 2646, '', '', 0, '25', 'For Marketing, support, bill collection & fiber te', 'cash', 1),
(400, '2016-01-18', 'BILL0000000313', '', 0, '23', 0, 7272, '', '', 0, '23', 'for fiber & cctv team', 'cash', 1),
(401, '2016-01-18', 'EX0000000057', '', 0, '10', 0, 2100, '', '', 0, 'Expense', 'Maintenance ', 'cash', 1),
(402, '2016-01-18', 'EX0000000058', '', 0, '10', 0, 153, '', '', 0, 'Expense', 'Plus, scrow driver for office', 'cash', 1),
(403, '2016-01-18', 'EX0000000059', '', 0, '10', 0, 820, '', '', 0, 'Expense', 'for All staff and others', 'cash', 1),
(404, '2016-01-18', 'EX0000000060', '', 0, '10', 0, 60, '', '', 0, 'Expense', 'weekly Payment', 'cash', 1),
(405, '2016-01-24', '4496', '', 1, '3', 0, 70000, '3752', '2016-01-24', 2, '4496', '', 'bank', 1),
(406, '2016-01-18', 'EX0000000054', '', 0, '10', 0, 24000, '0813753', '2016-01-18', 2, 'Expense', '', 'bank', 1),
(407, '2016-01-26', 'EX0000000055', '', 0, '10', 0, 7000, '0813754', '2016-01-26', 2, 'Expense', '', 'bank', 1),
(408, '2016-01-18', 'EX0000000061', '', 0, '10', 0, 300, '', '', 0, 'Expense', 'for new link up', 'cash', 1),
(409, '2016-01-18', 'EX0000000062', '', 0, '10', 0, 7300, '', '', 0, 'Expense', 'for office sample', 'cash', 1),
(410, '2016-01-19', 'EX0000000063', '', 0, '10', 0, 19200, '', '', 0, 'Expense', 'for December 2015', 'cash', 1),
(411, '2016-01-19', 'EX0000000064', '', 0, '10', 0, 6919, '', '', 0, 'Expense', 'for December 2015', 'cash', 1),
(412, '2016-01-19', 'EX0000000065', '', 0, '10', 0, 6919, '', '', 0, 'Expense', 'for December 2015', 'cash', 1),
(413, '2016-01-19', 'EX0000000066', '', 0, '10', 0, 9581, '', '', 0, 'Expense', 'for December 2015', 'cash', 1),
(414, '2016-01-19', 'EX0000000067', '', 0, '10', 0, 17000, '', '', 0, 'Expense', 'for December 2015', 'cash', 1),
(415, '2016-01-19', 'EX0000000068', '', 0, '10', 0, 10000, '', '', 0, 'Expense', 'for December 2015', 'cash', 1),
(416, '2016-01-19', 'EX0000000069', '', 0, '10', 0, 13110, '', '', 0, 'Expense', 'for December 2015', 'cash', 1),
(417, '2016-01-19', 'EX0000000070', '', 0, '10', 0, 6548, '', '', 0, 'Expense', 'for December 2015', 'cash', 1),
(418, '2016-01-19', 'EX0000000071', '', 0, '10', 0, 7000, '', '', 0, 'Expense', 'for December 2015', 'cash', 1),
(419, '2016-01-19', 'EX0000000072', '', 0, '10', 0, 6581, '', '', 0, 'Expense', 'for December 2015', 'cash', 1),
(420, '2016-01-19', 'EX0000000073', '', 0, '10', 0, 7200, '', '', 0, 'Expense', 'for December 2015', 'cash', 1),
(421, '2016-01-19', 'EX0000000074', '', 0, '10', 0, 12065, '', '', 0, 'Expense', 'for December 2015', 'cash', 1),
(422, '2016-01-19', 'EX0000000075', '', 0, '10', 0, 17548, '', '', 0, 'Expense', 'for December 2015', 'cash', 1),
(423, '2016-01-19', 'EX0000000076', '', 0, '10', 0, 8700, '', '', 0, 'Expense', 'for December 2015', 'cash', 1),
(424, '2016-01-19', 'EX0000000077', '', 0, '10', 0, 8000, '', '', 0, 'Expense', 'for December 2015', 'cash', 1),
(425, '2016-01-19', 'EX0000000078', '', 0, '10', 0, 9000, '', '', 0, 'Expense', 'for December 2015', 'cash', 1),
(426, '2016-01-19', 'EX0000000079', '', 0, '10', 0, 6700, '', '', 0, 'Expense', 'for December 2015', 'cash', 1),
(427, '2016-01-19', 'EX0000000080', '', 0, '10', 0, 2500, '', '', 0, 'Expense', 'for December 2015', 'cash', 1),
(428, '2016-01-19', 'EX0000000081', '', 0, '10', 0, 8500, '', '', 0, 'Expense', 'for December 2015', 'cash', 1),
(429, '2016-01-20', 'EX0000000082', '', 0, '10', 0, 5960, '', '', 0, 'Expense', 'for office store', 'cash', 1),
(430, '', 'EX0000000083', '', 0, '', 0, 0, '', '', 0, '', '', '', 1),
(431, '2016-01-20', 'EX0000000084', '', 0, '10', 0, 750, '', '', 0, 'Expense', 'kit for water filter', 'cash', 1),
(432, '2016-01-20', 'EX0000000085', '', 0, '10', 0, 500, '', '', 0, 'Expense', 'for  r Bazar client', 'cash', 1),
(433, '2016-01-20', 'EX0000000086', '', 0, '10', 0, 3900, '', '', 0, 'Expense', '2 pair Dlink M C for new link up', 'cash', 1),
(434, '2016-01-20', 'BILL0000000314', '', 0, '38', 0, 5620, '', '', 0, '38', 'Dec-15', 'cash', 1),
(435, '2016-01-20', 'EX0000000087', '', 0, '10', 0, 1700, '', '', 0, 'Expense', 'for vat purpose', 'cash', 1),
(436, '2016-01-20', 'EX0000000088', '', 0, '10', 0, 3000, '', '', 0, 'Expense', 'For easy Net meter', 'cash', 1),
(437, '2016-01-20', 'EX0000000089', '', 0, '10', 0, 13161, '', '', 0, 'Expense', 'Dec-15', 'cash', 1),
(438, '2016-01-20', 'EX0000000090', '', 0, '10', 0, 5871, '', '', 0, 'Expense', 'for December 2015', 'cash', 1),
(439, '2016-01-20', 'EX0000000091', '', 0, '10', 0, 18000, '', '', 0, 'Expense', 'for December 2015', 'cash', 1),
(440, '2016-01-25', 'BILL0000000315', '', 0, '29', 0, 5150, '', '', 0, '29', 'C Bazar for Nov+Dec-15', 'cash', 1),
(441, '', 'EX0000000092', '', 0, '', 0, 0, '', '', 0, '', '', '', 1),
(442, '2016-01-25', 'EX0000000093', '', 0, '10', 0, 1500, '', '', 0, 'Expense', 'For Loan purpose monthly charge', 'cash', 1),
(443, '2016-01-25', 'BILL0000000316', '', 0, '23', 0, 4476, '', '', 0, '23', 'for fiber & cctv work team', 'cash', 1),
(444, '2016-01-25', 'BILL0000000317', '', 0, '25', 0, 3689, '', '', 0, '25', 'For Marketing, support, bill collection & fiber te', 'cash', 1),
(445, '2016-01-25', 'BILL0000000318', '', 0, '25', 0, 3609, '', '', 0, '25', 'For Marketing, support, bill collection & fiber te', 'cash', 1),
(446, '2016-01-25', 'EX0000000094', '', 0, '10', 0, 1285, '', '', 0, 'Expense', 'Repair & servicing', 'cash', 1),
(447, '2016-01-25', 'EX0000000095', '', 0, '10', 0, 2073, '', '', 0, 'Expense', 'for car, tampo & pickup', 'cash', 1),
(448, '2016-01-25', '4536', '', 6, '4', 0, 7470, '', '', 0, 'supplier payment', '', 'cash', 1),
(449, '2016-01-25', 'EX0000000096', '', 0, '10', 0, 3000, '', '', 0, 'Expense', 'For easy Net meter', 'cash', 1),
(450, '2016-01-25', 'EX0000000097', '', 0, '10', 0, 1308, '', '', 0, 'Expense', '2 pcs dc fan and 2 pair battery', 'cash', 1),
(451, '2016-01-25', 'EX0000000098', '', 0, '10', 0, 3848, '', '', 0, 'Expense', '20pk Cable tai , Gi Cable & 10 pcs patch cord', 'cash', 1),
(452, '2016-01-25', 'EX0000000099', '', 0, '10', 0, 110, '', '', 0, 'Expense', 'for office document photocopy', 'cash', 1),
(453, '2016-01-25', 'EX0000000100', '', 0, '10', 0, 707, '', '', 0, 'Expense', 'for office & guest', 'cash', 1),
(454, '2016-01-25', 'EX0000000101', '', 0, '10', 0, 4200, '', '', 0, 'Expense', 'Refat Labtop servicing', 'cash', 1),
(455, '2014-01-02', '', '', 7, '1', 0, 0, '', '', 0, 'supplier due', '', 'due', 1),
(456, '2016-01-25', 'EX0000000102', '', 0, '10', 0, 300, '', '', 0, 'Expense', 'for fiber carying', 'cash', 1),
(457, '2016-01-25', 'EX0000000103', '', 0, '10', 0, 9500, '', '', 0, 'Expense', 'for December 2015', 'cash', 1),
(458, '2016-01-25', 'EX0000000104', '', 0, '10', 0, 4000, '', '', 0, 'Expense', 'for December 2015', 'cash', 1),
(459, '2016-01-25', 'EX0000000105', '', 0, '10', 0, 5807, '', '', 0, 'Expense', 'for December 2015', 'cash', 1),
(460, '2016-01-25', 'EX0000000106', '', 0, '10', 0, 9200, '', '', 0, 'Expense', 'for December 2015', 'cash', 1),
(461, '2016-01-27', 'BILL0000000319', '', 0, '32', 0, 6000, '', '', 0, '32', 'EZPZ bill Payment', 'cash', 1),
(462, '2016-01-27', 'EX0000000107', '', 0, '10', 0, 3000, '', '', 0, 'Expense', 'T J Box', 'cash', 1),
(463, '2016-01-28', 'EX0000000108', '', 0, '10', 0, 1000, '', '', 0, 'Expense', 'Rj45 Connector d-Link 2 box', 'cash', 1),
(464, '', 'BILL0000000320', '', 0, '', 0, 0, '', '', 0, '', '', '', 1),
(465, '2016-01-28', 'BILL0000000321', '', 0, '39', 0, 23200, '', '', 0, '39', 'Getco office rent payment', 'cash', 1),
(466, '', 'BILL0000000322', '', 0, '', 0, 0, '', '', 0, '', '', '', 1),
(467, '2016-01-28', 'EX0000000109', '', 0, '10', 0, 5400, '', '', 0, 'Expense', 'for December 2015', 'cash', 1),
(468, '2016-01-28', 'EX0000000110', '', 0, '10', 0, 8000, '', '', 0, 'Expense', 'for  CCtv Camera work purpose', 'cash', 1),
(469, '2016-01-31', 'EX0000000111', '', 0, '10', 0, 1000, '', '', 0, 'Expense', 'Temporary rent for BSRM Works', 'cash', 1),
(470, '2016-01-31', 'EX0000000092', '', 0, '10', 0, 12600, '3778', '2016-01-31', 1, 'Expense', '', 'bank', 1),
(471, '2016-01-24', 'EX0000000083', '', 0, '10', 0, 12400, '3777', '2016-01-24', 1, 'Expense', '', 'bank', 1),
(472, '2016-01-28', 'BILL0000000320', '', 0, '28', 0, 40000, '3780', '2016-01-28', 1, 'Expense', '', 'bank', 1),
(473, '2016-01-31', 'BILL0000000322', '', 0, '28', 0, 12700, '0813756', '2016-01-31', 2, 'Expense', '', 'bank', 1),
(474, '2016-02-07', '18', '', 3, '5', 0, 4000, '', '', 0, 'supplier due', '', 'due', 1),
(475, '2016-02-07', '000371', '', 1, '5', 0, 4300, '', '', 0, 'supplier due', '', 'due', 1),
(476, '2016-01-04', 'BILL0000000323', '', 0, '16', 200, 0, '', '', 0, '16', 'Miss entry', 'cash', 1),
(477, '2016-01-31', 'BILL0000000324', '', 0, '23', 0, 4150, '', '', 0, '23', 'for fiber & cctv team', 'cash', 1),
(478, '2016-01-31', 'BILL0000000325', '', 0, '25', 0, 8422, '', '', 0, '25', 'For Marketing, support, bill collection & fiber te', 'cash', 1),
(479, '2016-01-31', 'EX0000000112', '', 0, '10', 0, 290, '', '', 0, 'Expense', 'cctv accessories crrying from dhaka to ctg .', 'cash', 1),
(480, '2016-01-31', 'EX0000000113', '', 0, '10', 0, 2468, '', '', 0, 'Expense', 'for all vehicle oil and octen expense', 'cash', 1);
INSERT INTO `transaction_history` (`transaction_id`, `date`, `ref_id`, `customer_id`, `supplier_id`, `ledger`, `debit`, `credit`, `cheque_no`, `cheque_date`, `bank_id`, `hint`, `details`, `payment_type`, `branch_id`) VALUES
(481, '2016-01-31', 'EX0000000114', '', 0, '10', 0, 3700, '', '', 0, 'Expense', 'Gift', 'cash', 1);

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

--
-- Table structure for table `unit_type`
--

CREATE TABLE `unit_type` (
  `unit_type_id` int(10) NOT NULL,
  `unit_type_name` varchar(20) NOT NULL,
  `branch_id` int(2) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `unit_type`
--

INSERT INTO `unit_type` (`unit_type_id`, `unit_type_name`, `branch_id`) VALUES
(3, 'Ps', 1),
(5, 'litter', 1),
(6, 'packet', 1),
(8, 'KG', 1),
(10, 'Set', 0),
(11, 'Carton', 0);

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

--
-- Table structure for table `wastage`
--

CREATE TABLE `wastage` (
  `wastage_id` int(20) NOT NULL,
  `product_id` int(50) NOT NULL,
  `quantity` int(20) NOT NULL,
  `details` varchar(50) NOT NULL,
  `date` varchar(20) NOT NULL,
  `branch_id` int(2) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Indexes for dumped tables
--

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

--
-- Indexes for table `bank_name`
--
ALTER TABLE `bank_name`
  ADD PRIMARY KEY (`bank_id`);

--
-- Indexes for table `bank_name_lc`
--
ALTER TABLE `bank_name_lc`
  ADD PRIMARY KEY (`bank_id`);

--
-- Indexes for table `bank_statement`
--
ALTER TABLE `bank_statement`
  ADD PRIMARY KEY (`bank_statement_id`);

--
-- Indexes for table `branch`
--
ALTER TABLE `branch`
  ADD PRIMARY KEY (`branch_id`);

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

--
-- Indexes for table `concern`
--
ALTER TABLE `concern`
  ADD PRIMARY KEY (`concern_id`);

--
-- Indexes for table `customer_setup`
--
ALTER TABLE `customer_setup`
  ADD PRIMARY KEY (`customer_id`);

--
-- Indexes for table `cus_due_payment`
--
ALTER TABLE `cus_due_payment`
  ADD PRIMARY KEY (`cus_due_payment_id`);

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

--
-- Indexes for table `lc`
--
ALTER TABLE `lc`
  ADD PRIMARY KEY (`lc_id`);

--
-- Indexes for table `lc_taka`
--
ALTER TABLE `lc_taka`
  ADD PRIMARY KEY (`lc_taka_id`);

--
-- Indexes for table `loan_bank_name`
--
ALTER TABLE `loan_bank_name`
  ADD PRIMARY KEY (`loan_bank_name_id`);

--
-- Indexes for table `loan_list`
--
ALTER TABLE `loan_list`
  ADD PRIMARY KEY (`loan_list_id`);

--
-- Indexes for table `particulars`
--
ALTER TABLE `particulars`
  ADD PRIMARY KEY (`particulars_id`);

--
-- Indexes for table `present_stock`
--
ALTER TABLE `present_stock`
  ADD PRIMARY KEY (`present_stock_id`);

--
-- Indexes for table `product_setup`
--
ALTER TABLE `product_setup`
  ADD PRIMARY KEY (`product_id`);

--
-- Indexes for table `sale`
--
ALTER TABLE `sale`
  ADD PRIMARY KEY (`sale_id`);

--
-- Indexes for table `sale_taka`
--
ALTER TABLE `sale_taka`
  ADD PRIMARY KEY (`sale_taka_id`);

--
-- Indexes for table `store`
--
ALTER TABLE `store`
  ADD PRIMARY KEY (`store_id`);

--
-- Indexes for table `store_product`
--
ALTER TABLE `store_product`
  ADD PRIMARY KEY (`store_product_id`);

--
-- Indexes for table `store_transfer`
--
ALTER TABLE `store_transfer`
  ADD PRIMARY KEY (`store_transfer_id`);

--
-- Indexes for table `supplier_payment`
--
ALTER TABLE `supplier_payment`
  ADD PRIMARY KEY (`supplier_payment_id`);

--
-- Indexes for table `supplier_setup`
--
ALTER TABLE `supplier_setup`
  ADD PRIMARY KEY (`supplier_id`);

--
-- Indexes for table `sup_due_payment`
--
ALTER TABLE `sup_due_payment`
  ADD PRIMARY KEY (`sup_due_payment_id`);

--
-- Indexes for table `transaction`
--
ALTER TABLE `transaction`
  ADD PRIMARY KEY (`transaction_id`);

--
-- Indexes for table `transaction_history`
--
ALTER TABLE `transaction_history`
  ADD PRIMARY KEY (`transaction_id`);

--
-- Indexes for table `unit_type`
--
ALTER TABLE `unit_type`
  ADD PRIMARY KEY (`unit_type_id`);

--
-- Indexes for table `wastage`
--
ALTER TABLE `wastage`
  ADD PRIMARY KEY (`wastage_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `bank_name`
--
ALTER TABLE `bank_name`
  MODIFY `bank_id` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `bank_name_lc`
--
ALTER TABLE `bank_name_lc`
  MODIFY `bank_id` int(5) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `bank_statement`
--
ALTER TABLE `bank_statement`
  MODIFY `bank_statement_id` int(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `branch`
--
ALTER TABLE `branch`
  MODIFY `branch_id` int(2) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `cash`
--
ALTER TABLE `cash`
  MODIFY `id` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `concern`
--
ALTER TABLE `concern`
  MODIFY `concern_id` int(2) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `customer_setup`
--
ALTER TABLE `customer_setup`
  MODIFY `customer_id` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;

--
-- AUTO_INCREMENT for table `cus_due_payment`
--
ALTER TABLE `cus_due_payment`
  MODIFY `cus_due_payment_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=153;

--
-- AUTO_INCREMENT for table `expense_sector`
--
ALTER TABLE `expense_sector`
  MODIFY `id` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29;

--
-- AUTO_INCREMENT for table `lc`
--
ALTER TABLE `lc`
  MODIFY `lc_id` int(12) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `lc_taka`
--
ALTER TABLE `lc_taka`
  MODIFY `lc_taka_id` int(12) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `loan_bank_name`
--
ALTER TABLE `loan_bank_name`
  MODIFY `loan_bank_name_id` int(2) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `loan_list`
--
ALTER TABLE `loan_list`
  MODIFY `loan_list_id` int(50) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `particulars`
--
ALTER TABLE `particulars`
  MODIFY `particulars_id` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=41;

--
-- AUTO_INCREMENT for table `present_stock`
--
ALTER TABLE `present_stock`
  MODIFY `present_stock_id` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `product_setup`
--
ALTER TABLE `product_setup`
  MODIFY `product_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `sale`
--
ALTER TABLE `sale`
  MODIFY `sale_id` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=206;

--
-- AUTO_INCREMENT for table `sale_taka`
--
ALTER TABLE `sale_taka`
  MODIFY `sale_taka_id` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=137;

--
-- AUTO_INCREMENT for table `store`
--
ALTER TABLE `store`
  MODIFY `store_id` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `store_product`
--
ALTER TABLE `store_product`
  MODIFY `store_product_id` int(12) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `store_transfer`
--
ALTER TABLE `store_transfer`
  MODIFY `store_transfer_id` int(12) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `supplier_payment`
--
ALTER TABLE `supplier_payment`
  MODIFY `supplier_payment_id` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `supplier_setup`
--
ALTER TABLE `supplier_setup`
  MODIFY `supplier_id` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `sup_due_payment`
--
ALTER TABLE `sup_due_payment`
  MODIFY `sup_due_payment_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `transaction`
--
ALTER TABLE `transaction`
  MODIFY `transaction_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=326;

--
-- AUTO_INCREMENT for table `transaction_history`
--
ALTER TABLE `transaction_history`
  MODIFY `transaction_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=482;

--
-- AUTO_INCREMENT for table `unit_type`
--
ALTER TABLE `unit_type`
  MODIFY `unit_type_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `wastage`
--
ALTER TABLE `wastage`
  MODIFY `wastage_id` int(20) NOT NULL AUTO_INCREMENT;
COMMIT;

