--
-- Host: localhost    Database: 1000_flux_retail_base
-- ------------------------------------------------------


--
-- Current Database: `1000_flux_retail_base`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `1000_flux_retail_base` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */;

USE `1000_flux_retail_base`;

--
-- Table structure for table `tbl_acc_details`
--

CREATE TABLE `tbl_acc_details` (
  `id` int NOT NULL AUTO_INCREMENT,
  `_date` date NOT NULL,
  `description` varchar(1000) NOT NULL,
  `cheque_no` varchar(100) NOT NULL,
  `payee` varchar(1000) NOT NULL,
  `amount` decimal(16,2) NOT NULL,
  `type` varchar(10) NOT NULL,
  `tag_id` int NOT NULL,
  `account_id` int NOT NULL,
  `transaction_id` int NOT NULL,
  `event` varchar(200) NOT NULL,
  `is_send` tinyint(1) NOT NULL DEFAULT '0',
  `account_code` varchar(1000) NOT NULL,
  `location_id` varchar(11) NOT NULL,
  `cheque_date` date NOT NULL,
  `sent_on` datetime NOT NULL,
  `log_id` int NOT NULL,
  `created_on` datetime NOT NULL DEFAULT '2025-08-01 00:00:00',
  `transaction_code` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_acc_details`
--


--
-- Table structure for table `tbl_acc_event_log`
--

CREATE TABLE `tbl_acc_event_log` (
  `id` int NOT NULL AUTO_INCREMENT,
  `msg` varchar(5000) NOT NULL,
  `status` varchar(100) NOT NULL,
  `created_on` datetime NOT NULL,
  `event` varchar(100) NOT NULL,
  `transaction_id` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_acc_event_log`
--


--
-- Table structure for table `tbl_acc_events`
--

CREATE TABLE `tbl_acc_events` (
  `id` int NOT NULL AUTO_INCREMENT,
  `type` varchar(500) NOT NULL,
  `scripts` longtext NOT NULL,
  `description` varchar(1000) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_acc_events`
--

INSERT INTO `tbl_acc_events` VALUES (1,'Sales','INSERT INTO `tbl_acc_details`(`_date`, `description`, `cheque_no`, `payee`, `amount`, `type`, `tag_id`, `account_id`, `transaction_id`, `event`, `is_send`, `account_code`, `location_id`, `cheque_date`, `sent_on`, `log_id`, `created_on`,transaction_code)\r\nselect \r\ndate(si.created_on) as _date\r\n,\'by api - \' as description\r\n,\'\' as cheque_no\r\n,c.customer_name as payee\r\n,sum(sip.net_total) as amount\r\n,\'CR\' as `type`\r\n,0 as tag_id\r\n, ( case \r\n		when ifnull(pc.fn_acount_id,0) > 0 then ifnull(pc.fn_acount_id,0)\r\n        else 110 end \r\n	) as account_id \r\n,si.id as transaction_id\r\n,\'Sales\' as `event`\r\n,0 as is_send\r\n,( case \r\n		when ifnull(pc.fn_acount_id,0) > 0 then pc.fn_account_name\r\n        else \'Sales Revenue\' end \r\n	) as account_code\r\n,bil.fn_companyCode as location_id  \r\n,now() as cheque_date\r\n,now() as sent_on\r\n,\'\' as log_id\r\n,now() as created_on\r\n,si.code as transaction_code \r\nfrom tbl_sale_invoice_products sip\r\ninner join tbl_sale_invoice si on si.id = sip.sale_invoice_id\r\ninner join tbl_branch_inventory_locations bil on bil.id = si.location_id\r\ninner join tbl_customers c on c.customer_id = si.customer_id\r\nleft join tbl_products p on p.product_id = sip.product_id\r\nleft join tbl_productcategory pc on pc.productCategory_id = p.category_id \r\nwhere sip.product_name != \'Service Charges\'\r\nand si.id = ?\r\ngroup by ifnull(pc.fn_account_name,\'\')\r\n\r\n\r\n\r\n\r\n\r\n','CR items *'),(2,'Sales','INSERT INTO `tbl_acc_details`(`_date`, `description`, `cheque_no`, `payee`, `amount`, `type`, `tag_id`, `account_id`, `transaction_id`, `event`, `is_send`, `account_code`, `location_id`, `cheque_date`, `sent_on`, `log_id`, `created_on`,transaction_code)\r\nselect \r\n\r\ndate(si.created_on) as _date\r\n,\'by api - \' as description\r\n,\'\' as cheque_no\r\n,c.customer_name as payee\r\n,sip.net_total as amount\r\n,\'CR\' as `type`\r\n,0 as tag_id\r\n, 117 as account_id \r\n,si.id as transaction_id\r\n,\'Sales\' as `event`\r\n,0 as is_send\r\n,\'Colombo Staff Service Chg-10\' as account_code\r\n,bil.fn_companyCode as location_id  \r\n,now() as cheque_date\r\n,now() as sent_on\r\n,\'\' as log_id\r\n,now() as created_on\r\n,si.code as transaction_code\r\n\r\nfrom tbl_sale_invoice_products sip\r\ninner join tbl_sale_invoice si on si.id = sip.sale_invoice_id\r\ninner join tbl_branch_inventory_locations bil on bil.id = si.location_id\r\ninner join tbl_customers c on c.customer_id = si.customer_id\r\nleft join tbl_products p on p.product_id = sip.product_id\r\nleft join tbl_productcategory pc on pc.productCategory_id = p.category_id \r\nwhere sip.product_name = \'Service Charges\'\r\nand si.id = ?','CR service charge *'),(3,'Sales','INSERT INTO `tbl_acc_details`(`_date`, `description`, `cheque_no`, `payee`, `amount`, `type`, `tag_id`, `account_id`, `transaction_id`, `event`, `is_send`, `account_code`, `location_id`, `cheque_date`, `sent_on`, `log_id`, `created_on`,transaction_code)\r\nselect \r\ndate(si.created_on) as _date\r\n,\'by api - \' as description\r\n,\'\' as cheque_no\r\n,c.customer_name as payee\r\n, si.net_total as amount\r\n,\'CR\' as `type`\r\n,0 as tag_id\r\n,34 as account_id \r\n,si.id as transaction_id\r\n,\'Sales\' as `event`\r\n,0 as is_send\r\n,\'Inventory Stock:COLOMBO-07 STOCK\' as account_code\r\n,bil.fn_companyCode as location_id\r\n,now() as cheque_date\r\n,now() as sent_on\r\n,\'\' as log_id\r\n,now() as created_on\r\n,si.code as transaction_code\r\n\r\nfrom tbl_sale_invoice si\r\ninner join tbl_branch_inventory_locations bil on bil.id = si.location_id\r\ninner join tbl_customers c on c.customer_id = si.customer_id\r\nwhere si.id = ?','CR Inventory Stock:COLOMBO-07 STOCK 34'),(4,'Sales','INSERT INTO `tbl_acc_details`(`_date`, `description`, `cheque_no`, `payee`, `amount`, `type`, `tag_id`, `account_id`, `transaction_id`, `event`, `is_send`, `account_code`, `location_id`, `cheque_date`, `sent_on`, `log_id`, `created_on`,transaction_code)\r\nselect \r\ndate(si.created_on) as _date\r\n,\'by api - \' as description\r\n,\'\' as cheque_no\r\n,c.customer_name as payee\r\n,si.net_total as amount\r\n,\'DR\' as `type`\r\n,0 as tag_id\r\n,131 as account_id  \r\n,si.id as transaction_id\r\n,\'Sales\' as `event`\r\n,0 as is_send \r\n,\'Cost of Goods Sold\' as account_code\r\n,bil.fn_companyCode as location_id\r\n,now() as cheque_date\r\n,now() as sent_on\r\n,0 as log_id\r\n,now() as created_on\r\n,si.code as transaction_code\r\n\r\nfrom tbl_sale_invoice si\r\ninner join tbl_branch_inventory_locations bil on bil.id = si.location_id\r\ninner join tbl_customers c on c.customer_id = si.customer_id\r\nwhere si.id = ?','DR Cost of Goods Sold 131'),(5,'Sales_cancel','INSERT INTO `tbl_acc_details`(`_date`, `description`, `cheque_no`, `payee`, `amount`, `type`, `tag_id`, `account_id`, `transaction_id`, `event`, `is_send`, `account_code`, `location_id`, `cheque_date`, `sent_on`, `log_id`, `created_on`,transaction_code)\r\nselect \r\ndate(now()) as _date\r\n,\'by api - \' as description\r\n,\'\' as cheque_no\r\n,c.customer_name as payee\r\n,(si.net_total-si.bill_tax_amount-si.rpt_returns_amount) as amount\r\n,\'DR\' as `type`\r\n,0 as tag_id\r\n,34 as account_id \r\n,si.id as transaction_id\r\n,\'Sales_cancel\' as `event`\r\n,0 as is_send\r\n,\'Inventory Stock:COLOMBO-07 STOCK\' as account_code\r\n,bil.fn_companyCode as location_id\r\n,now() as cheque_date\r\n,now() as sent_on\r\n,\'\' as log_id\r\n,now() as created_on\r\n,si.code as transaction_code\r\n\r\nfrom tbl_sale_invoice si\r\ninner join tbl_branch_inventory_locations bil on bil.id = si.location_id\r\ninner join tbl_customers c on c.customer_id = si.customer_id\r\nwhere si.id = ?','DR Inventory Stock:COLOMBO-07 STOCK 34'),(6,'Sales_cancel','INSERT INTO `tbl_acc_details`(`_date`, `description`, `cheque_no`, `payee`, `amount`, `type`, `tag_id`, `account_id`, `transaction_id`, `event`, `is_send`, `account_code`, `location_id`, `cheque_date`, `sent_on`, `log_id`, `created_on`,transaction_code)\r\nselect \r\ndate(now()) as _date\r\n,\'by api - \' as description\r\n,\'\' as cheque_no\r\n,c.customer_name as payee\r\n,(si.net_total-si.rpt_returns_amount) as amount\r\n,\'CR\' as `type`\r\n,0 as tag_id\r\n,131 as account_id  \r\n,si.id as transaction_id\r\n,\'Sales_cancel\' as `event`\r\n,0 as is_send \r\n,\'Cost of Goods Sold\' as account_code\r\n,bil.fn_companyCode as location_id\r\n,now() as cheque_date\r\n,now() as sent_on\r\n,0 as log_id\r\n,now() as created_on\r\n,si.code as transaction_code\r\n\r\nfrom tbl_sale_invoice si\r\ninner join tbl_branch_inventory_locations bil on bil.id = si.location_id\r\ninner join tbl_customers c on c.customer_id = si.customer_id\r\nwhere si.id = ?','CR Cost of Goods Sold 131'),(7,'Sales_cancel','INSERT INTO `tbl_acc_details`(`_date`, `description`, `cheque_no`, `payee`, `amount`, `type`, `tag_id`, `account_id`, `transaction_id`, `event`, `is_send`, `account_code`, `location_id`, `cheque_date`, `sent_on`, `log_id`, `created_on`,transaction_code)\r\nselect \r\ndate(si.created_on) as _date\r\n,\'by api - \' as description\r\n,\'\' as cheque_no\r\n,c.customer_name as payee\r\n,sip.net_total - sum(ifnull(rp.value,0)) as amount\r\n,\'DR\' as `type`\r\n,0 as tag_id\r\n, ( case \r\n		when ifnull(pc.fn_acount_id,0) > 0 then ifnull(pc.fn_acount_id,0)\r\n        else 110 end \r\n	) as account_id \r\n,si.id as transaction_id\r\n,\'Sales_cancel\' as `event`\r\n,0 as is_send\r\n,( case \r\n		when ifnull(pc.fn_acount_id,0) > 0 then pc.fn_account_name\r\n        else \'Sales Revenue\' end \r\n	) as account_code\r\n,bil.fn_companyCode as location_id  \r\n,now() as cheque_date\r\n,now() as sent_on\r\n,\'\' as log_id\r\n,now() as created_on\r\n,si.code as transaction_code \r\nfrom tbl_sale_invoice_products sip\r\ninner join tbl_sale_invoice si on si.id = sip.sale_invoice_id\r\ninner join tbl_branch_inventory_locations bil on bil.id = si.location_id\r\ninner join tbl_customers c on c.customer_id = si.customer_id\r\nleft join tbl_products p on p.product_id = sip.product_id\r\nleft join tbl_productcategory pc on pc.productCategory_id = p.category_id \r\nleft join tbl_return_products rp on rp.sale_invoice_product_id = sip.id\r\nwhere sip.product_name != \'Service Charges\'\r\nand si.id = ?\r\ngroup by sip.product_id\r\nhaving amount  > 0\r\n\r\n\r\n\r\n\r\n','DR items *'),(8,'Sales_cancel','INSERT INTO `tbl_acc_details`(`_date`, `description`, `cheque_no`, `payee`, `amount`, `type`, `tag_id`, `account_id`, `transaction_id`, `event`, `is_send`, `account_code`, `location_id`, `cheque_date`, `sent_on`, `log_id`, `created_on`,transaction_code)\r\nselect \r\n\r\ndate(si.created_on) as _date\r\n,\'by api - \' as description\r\n,\'\' as cheque_no\r\n,c.customer_name as payee\r\n,sip.net_total as amount\r\n,\'DR\' as `type`\r\n,0 as tag_id\r\n, 117 as account_id \r\n,si.id as transaction_id\r\n,\'Sales_cancel\' as `event`\r\n,0 as is_send\r\n,\'Colombo Staff Service Chg-10\' as account_code\r\n,bil.fn_companyCode as location_id  \r\n,now() as cheque_date\r\n,now() as sent_on\r\n,\'\' as log_id\r\n,now() as created_on\r\n,si.code as transaction_code\r\n\r\nfrom tbl_sale_invoice_products sip\r\ninner join tbl_sale_invoice si on si.id = sip.sale_invoice_id\r\ninner join tbl_branch_inventory_locations bil on bil.id = si.location_id\r\ninner join tbl_customers c on c.customer_id = si.customer_id\r\nleft join tbl_products p on p.product_id = sip.product_id\r\nleft join tbl_productcategory pc on pc.productCategory_id = p.category_id \r\nwhere sip.product_name = \'Service Charges\'\r\nand si.id = ?','DR service charge *'),(9,'sales_return','\r\nINSERT INTO `tbl_acc_details`(`_date`, `description`, `cheque_no`, `payee`, `amount`, `type`, `tag_id`, `account_id`, `transaction_id`, `event`, `is_send`, `account_code`, `location_id`, `cheque_date`, `sent_on`, `log_id`, `created_on`,`transaction_code`)\r\nselect\r\ndate(cr.created_on) as _date\r\n,\'by api - \' as description\r\n,\'\' as cheque_no\r\n,c.customer_name as payee\r\n,round(((sip.net_total/sip.qty)*rp.qty),2) as amount\r\n,\'DR\' as `type`\r\n,0 as tag_id\r\n, ( case \r\n		when ifnull(pc.fn_acount_id,0) > 0 then ifnull(pc.fn_acount_id,0)\r\n        else 110 end \r\n	) as account_id  \r\n,cr.id as transaction_id\r\n,\'sales_return\' as `event`\r\n,0 as is_send \r\n,( case \r\n		when ifnull(pc.fn_acount_id,0) > 0 then pc.fn_account_name\r\n        else \'Sales Revenue\' end \r\n	) as account_code\r\n,bil.fn_companyCode as location_id\r\n,now() as cheque_date\r\n,now() as sent_on\r\n,0 as log_id\r\n,now() as created_on\r\n,si.code as transaction_code\r\n    \r\nfrom tbl_customer_returns cr\r\ninner join tbl_return_products rp on rp.return_id = cr.id\r\ninner join tbl_sale_invoice_products sip on sip.id = rp.sale_invoice_product_id\r\ninner join tbl_sale_invoice si on si.id = cr.sale_invoice_id\r\ninner join tbl_branch_inventory_locations bil on bil.id = si.location_id\r\ninner join tbl_customers c on c.customer_id = si.customer_id\r\nleft join tbl_products p on p.product_id = rp.product_id\r\nleft join tbl_productcategory pc on pc.productCategory_id = p.category_id \r\nwhere cr.id = ?\r\n\r\n\r\n','DR items *'),(10,'sales_return','INSERT INTO `tbl_acc_details`(`_date`, `description`, `cheque_no`, `payee`, `amount`, `type`, `tag_id`, `account_id`, `transaction_id`, `event`, `is_send`, `account_code`, `location_id`, `cheque_date`, `sent_on`, `log_id`, `created_on`,`transaction_code`)\r\nselect\r\ndate(cr.created_on) as _date\r\n,\'by api - \' as description\r\n,\'\' as cheque_no\r\n,c.customer_name as payee\r\n,round((((sip.net_total/sip.qty)*rp.qty)-rp.value),2) as amount \r\n,\'CR\' as `type`\r\n,0 as tag_id\r\n, ( case \r\n		when ifnull(fa.account,0) > 0 then ifnull(fa.account,\'\')\r\n        else 240 end \r\n	) as account_id  \r\n,cr.id as transaction_id\r\n,\'sales_return\' as `event`\r\n,0 as is_send \r\n,( case \r\n		when ifnull(fa.account,0) > 0 then ifnull(fa.name,\'\')\r\n        else \'Customers Discount\' end \r\n	)  as account_code\r\n,bil.fn_companyCode as location_id\r\n,now() as cheque_date\r\n,now() as sent_on\r\n,0 as log_id\r\n,now() as created_on\r\n,si.code as transaction_code\r\n    \r\nfrom tbl_customer_returns cr\r\ninner join tbl_return_products rp on rp.return_id = cr.id\r\ninner join tbl_sale_invoice_products sip on sip.id = rp.sale_invoice_product_id\r\nand sip.sale_invoice_id = rp.invoice_id\r\ninner join tbl_sale_invoice si on si.id = cr.sale_invoice_id\r\ninner join tbl_branch_inventory_locations bil on bil.id = si.location_id\r\ninner join tbl_customers c on c.customer_id = si.customer_id\r\nleft join tbl_fn_discount_accounts fa on fa.rate = si.discount_rate\r\nleft join tbl_products p on p.product_id = rp.product_id\r\nleft join tbl_productcategory pc on pc.productCategory_id = p.category_id \r\nwhere cr.id = ?\r\nand round((((sip.net_total/sip.qty)*rp.qty)-rp.value),2) > 0\r\n\r\n\r\n','CR discount *'),(11,'sales_return','INSERT INTO `tbl_acc_details`(`_date`, `description`, `cheque_no`, `payee`, `amount`, `type`, `tag_id`, `account_id`, `transaction_id`, `event`, `is_send`, `account_code`, `location_id`, `cheque_date`, `sent_on`, `log_id`, `created_on`,`transaction_code`)\r\nselect\r\ndate(cr.created_on) as _date\r\n,\'by api - \' as description\r\n,\'\' as cheque_no\r\n,c.customer_name as payee\r\n,cr.amount as amount\r\n,\'CR\' as `type`\r\n,0 as tag_id\r\n,131 as account_id  \r\n,cr.id as transaction_id\r\n,\'sales_return\' as `event`\r\n,0 as is_send \r\n,\'Cost of Goods Sold\' as account_code\r\n,bil.fn_companyCode as location_id\r\n,now() as cheque_date\r\n,now() as sent_on\r\n,0 as log_id\r\n,now() as created_on\r\n,si.code as transaction_code\r\n    \r\nfrom tbl_customer_returns cr\r\ninner join tbl_sale_invoice si on si.id = cr.sale_invoice_id\r\ninner join tbl_branch_inventory_locations bil on bil.id = si.location_id\r\ninner join tbl_customers c on c.customer_id = si.customer_id\r\nwhere cr.id = ?','CR Cost of Goods Sold 131'),(12,'sales_return','INSERT INTO `tbl_acc_details`(`_date`, `description`, `cheque_no`, `payee`, `amount`, `type`, `tag_id`, `account_id`, `transaction_id`, `event`, `is_send`, `account_code`, `location_id`, `cheque_date`, `sent_on`, `log_id`, `created_on`,`transaction_code`)\r\nselect \r\ndate(cr.created_on) as _date\r\n,\'by api - \' as description\r\n,\'\' as cheque_no\r\n,c.customer_name as payee\r\n,cr.amount as amount\r\n,\'DR\' as `type`\r\n,0 as tag_id\r\n,34 as account_id \r\n,cr.id as transaction_id\r\n,\'sales_return\' as `event`\r\n,0 as is_send\r\n,\'Inventory Stock:COLOMBO-07 STOCK\' as account_code\r\n,bil.fn_companyCode as location_id\r\n,now() as cheque_date\r\n,now() as sent_on\r\n,\'\' as log_id\r\n,now() as created_on\r\n, si.code as transaction_code\r\n\r\nfrom tbl_customer_returns cr\r\ninner join tbl_sale_invoice si on si.id = cr.sale_invoice_id\r\ninner join tbl_branch_inventory_locations bil on bil.id = si.location_id\r\ninner join tbl_customers c on c.customer_id = si.customer_id\r\nwhere cr.id = ?','DR Inventory Stock:COLOMBO-07 STOCK 34'),(13,'GRN','INSERT INTO `tbl_acc_details`(`_date`, `description`, `cheque_no`, `payee`, `amount`, `type`, `tag_id`, `account_id`, `transaction_id`, `event`, `is_send`, `account_code`, `location_id`, `cheque_date`, `sent_on`, `log_id`, `created_on`,transaction_code)\r\nselect \r\ngrn_date as _date\r\n,\'by api - \' as description\r\n,\'\' as cheque_no\r\n,s.name as payee\r\n,g.total as amount\r\n,\'CR\' as `type`\r\n,0 as tag_id\r\n,85 as account_id \r\n,g.grn_id as transaction_id\r\n,\'GRN\' as `event`\r\n,0 as is_send\r\n,\'Accounts Payable\' as account_code\r\n,bil.fn_companyCode as location_id\r\n,now() as cheque_date\r\n,now() as sent_on\r\n,\'\' as log_id\r\n,now() as created_on\r\n,g.code as transaction_code\r\nfrom tbl_grns g\r\ninner join tbl_branch_inventory_locations bil on bil.id = g.location_id\r\ninner join tbl_supplier s on s.supplier_id = g.supplier_id\r\nwhere g.grn_id = ?','CR Accounts Payable 85'),(14,'GRN','INSERT INTO `tbl_acc_details`(`_date`, `description`, `cheque_no`, `payee`, `amount`, `type`, `tag_id`, `account_id`, `transaction_id`, `event`, `is_send`, `account_code`, `location_id`, `cheque_date`, `sent_on`, `log_id`, `created_on`,transaction_code)\r\nselect \r\ngrn_date as _date\r\n,\'by api - \' as description\r\n,\'\' as cheque_no\r\n,s.name as payee\r\n,g.total as amount\r\n,\'DR\' as `type`\r\n,0 as tag_id\r\n,34 as account_id \r\n,g.grn_id as transaction_id\r\n,\'GRN\' as `event`\r\n,0 as is_send\r\n,\'Inventory Stock:COLOMBO-07 STOCK\' as account_code\r\n,bil.fn_companyCode as location_id\r\n,now() as cheque_date\r\n,now() as sent_on\r\n,\'\' as log_id\r\n,now() as created_on\r\n,g.code as transaction_code\r\nfrom tbl_grns g\r\ninner join tbl_branch_inventory_locations bil on bil.id = g.location_id\r\ninner join tbl_supplier s on s.supplier_id = g.supplier_id\r\nwhere g.grn_id = ?','DR Inventory Stock:COLOMBO-07 STOCK 34'),(15,'GRNReturn','INSERT INTO `tbl_acc_details`(`_date`, `description`, `cheque_no`, `payee`, `amount`, `type`, `tag_id`, `account_id`, `transaction_id`, `event`, `is_send`, `account_code`, `location_id`, `cheque_date`, `sent_on`, `log_id`, `created_on`,transaction_code)\r\nselect \r\ngr.return_date as _date\r\n,\'by api - \' as description\r\n,\'\' as cheque_no\r\n,s.name as payee\r\n,gr.total as amount\r\n,\'DR\' as `type`\r\n,0 as tag_id\r\n,85 as account_id \r\n,gr.grn_return_id as transaction_id\r\n,\'GRNReturn\' as `event`\r\n,0 as is_send\r\n,\'Accounts Payable\' as account_code\r\n,bil.fn_companyCode as location_id\r\n,now() as cheque_date\r\n,now() as sent_on\r\n,\'\' as log_id\r\n,now() as created_on\r\n,gr.code as transaction_code  \r\nfrom tbl_grn_return gr \r\ninner join tbl_supplier s on s.supplier_id = gr.supplier_id\r\ninner join tbl_branch_inventory_locations bil on bil.id = gr.location_id\r\nleft join tbl_grns g on g.grn_id = gr.grn_id\r\nwhere gr.grn_return_id = ?','DR Accounts Payable 85'),(16,'GRNReturn','INSERT INTO `tbl_acc_details`(`_date`, `description`, `cheque_no`, `payee`, `amount`, `type`, `tag_id`, `account_id`, `transaction_id`, `event`, `is_send`, `account_code`, `location_id`, `cheque_date`, `sent_on`, `log_id`, `created_on`,transaction_code)\r\nselect \r\ngr.return_date as _date\r\n,\'by api - \' as description\r\n,\'\' as cheque_no\r\n,s.name as payee\r\n,(gr.total-(round((case when ifnull(g.tax_type,\'\') = \'Exclusive\' then (gr.total/100)*SUBSTRING_INDEX(g.tax, \'~\', -1)\r\n	when ifnull(g.tax_type,\'\') = \'Inclusive\' then (gr.total/(100+SUBSTRING_INDEX(g.tax, \'~\', -1)))*SUBSTRING_INDEX(g.tax, \'~\', -1)\r\n    else 0 end),2))) as amount\r\n,\'CR\' as `type`\r\n,0 as tag_id\r\n,34 as account_id \r\n,gr.grn_return_id as transaction_id\r\n,\'GRNReturn\' as `event`\r\n,0 as is_send\r\n,\'Inventory Stock:COLOMBO-07 STOCK\' as account_code\r\n,bil.fn_companyCode as location_id\r\n,now() as cheque_date\r\n,now() as sent_on\r\n,\'\' as log_id\r\n,now() as created_on\r\n,gr.code as transaction_code\r\nfrom tbl_grn_return gr \r\ninner join tbl_supplier s on s.supplier_id = gr.supplier_id\r\ninner join tbl_branch_inventory_locations bil on bil.id = gr.location_id\r\nleft join tbl_grns g on g.grn_id = gr.grn_id\r\nwhere gr.grn_return_id = ?','CR Inventory Stock:COLOMBO-07 STOCK 34'),(17,'Sales','INSERT INTO `tbl_acc_details`(`_date`, `description`, `cheque_no`, `payee`, `amount`, `type`, `tag_id`, `account_id`, `transaction_id`, `event`, `is_send`, `account_code`, `location_id`, `cheque_date`, `sent_on`, `log_id`, `created_on`,transaction_code)\r\nselect \r\n\r\ndate(si.created_on) as _date\r\n,\'by api - \' as description\r\n,\'\' as cheque_no\r\n,c.customer_name as payee\r\n,si.total_discount as amount\r\n,\'DR\' as `type`\r\n,0 as tag_id\r\n, ( case \r\n		when ifnull(fa.account,0) > 0 then ifnull(fa.account,\'\')\r\n        else 240 end \r\n	) as account_id   \r\n,si.id as transaction_id\r\n,\'Sales\' as `event`\r\n,0 as is_send\r\n,( case \r\n		when ifnull(fa.name,0) > 0 then ifnull(fa.account,\'\')\r\n        else \'Customers Discount\' end \r\n	) as account_code\r\n,bil.fn_companyCode as location_id  \r\n,now() as cheque_date\r\n,now() as sent_on\r\n,\'\' as log_id\r\n,now() as created_on\r\n,si.code as transaction_code\r\n\r\nfrom tbl_sale_invoice si \r\ninner join tbl_branch_inventory_locations bil on bil.id = si.location_id\r\ninner join tbl_customers c on c.customer_id = si.customer_id \r\nleft join tbl_fn_discount_accounts fa on fa.rate = si.discount_rate\r\nwhere si.total_discount > 0\r\nand si.id = ?\r\n\r\n','DR discount **'),(18,'payment_summary','INSERT INTO `tbl_acc_details`(`_date`, `description`, `cheque_no`, `payee`, `amount`, `type`, `tag_id`, `account_id`, `transaction_id`, `event`, `is_send`, `account_code`, `location_id`, `cheque_date`, `sent_on`, `log_id`, `created_on`,transaction_code)\r\nselect \r\ndate(si.created_on) as _date\r\n,\'by api - \' as description\r\n,\'\' as cheque_no\r\n,c.customer_name as payee\r\n,pa.allocation_amount as amount\r\n,\'DR\' as `type`\r\n,0 as tag_id\r\n, ( case \r\n		when is_uber_invoice(si.id) > 0 then 275\r\n		when ifnull(cp.fn_acount_id,0) > 0 then ifnull(cp.fn_acount_id,0)\r\n        else 277 end \r\n	) as account_id \r\n,si.id as transaction_id\r\n,\'Sales\' as `event`\r\n,0 as is_send\r\n,( case \r\n		when is_uber_invoice(si.id) > 0 then \'Undeposited UBER Sales\'\r\n		when ifnull(cp.fn_acount_id,0) > 0 then ifnull(cp.fn_account_name,\'\')\r\n        else \'Undeposited Cash\' end \r\n	)  as account_code \r\n,bil.fn_companyCode as location_id\r\n,now() as cheque_date\r\n,now() as sent_on\r\n,\'\' as log_id\r\n,now() as created_on\r\n,si.code as transaction_code\r\nfrom tbl_payment_allocation pa\r\ninner join tbl_sale_invoice si on si.id = pa.invoice_id\r\ninner join tbl_branch_inventory_locations bil on bil.id = si.location_id\r\ninner join tbl_customers c on c.customer_id = si.customer_id\r\ninner join tbl_payment_summary_details psd on psd.id = pa.payment_id\r\nleft join tbl_card_types cp on cp.id = psd.card_type_id\r\nwhere pa.ps_id = ?\r\n\r\n\r\n','DR payments **'),(19,'Sales_cancel','INSERT INTO `tbl_acc_details`(`_date`, `description`, `cheque_no`, `payee`, `amount`, `type`, `tag_id`, `account_id`, `transaction_id`, `event`, `is_send`, `account_code`, `location_id`, `cheque_date`, `sent_on`, `log_id`, `created_on`,transaction_code)\r\nselect \r\n\r\ndate(si.created_on) as _date\r\n,\'by api - \' as description\r\n,\'\' as cheque_no\r\n,c.customer_name as payee\r\n,si.total_discount as amount\r\n,\'CR\' as `type`\r\n,0 as tag_id\r\n, ( case \r\n		when ifnull(fa.account,0) > 0 then ifnull(fa.account,\'\')\r\n        else 240 end \r\n	) as account_id   \r\n,si.id as transaction_id\r\n,\'Sales_cancel\' as `event`\r\n,0 as is_send\r\n,( case \r\n		when ifnull(fa.account,0) > 0 then ifnull(fa.name,\'\')\r\n        else \'Customers Discount\' end \r\n	) as account_code\r\n,bil.fn_companyCode as location_id  \r\n,now() as cheque_date\r\n,now() as sent_on\r\n,\'\' as log_id\r\n,now() as created_on\r\n,si.code as transaction_code\r\n\r\nfrom tbl_sale_invoice si \r\ninner join tbl_branch_inventory_locations bil on bil.id = si.location_id\r\ninner join tbl_customers c on c.customer_id = si.customer_id \r\nleft join tbl_fn_discount_accounts fa on fa.rate = si.discount_rate\r\nwhere si.total_discount > 0\r\nand si.id = ?\r\n\r\n','CR discount **'),(20,'Sales_cancel','INSERT INTO `tbl_acc_details`(`_date`, `description`, `cheque_no`, `payee`, `amount`, `type`, `tag_id`, `account_id`, `transaction_id`, `event`, `is_send`, `account_code`, `location_id`, `cheque_date`, `sent_on`, `log_id`, `created_on`,transaction_code)\r\nselect \r\ndate(si.created_on) as _date\r\n,\'by api - \' as description\r\n,\'\' as cheque_no\r\n,c.customer_name as payee\r\n,pa.allocation_amount-si.rpt_returns_amount as amount\r\n,\'CR\' as `type`\r\n,0 as tag_id\r\n, ( case \r\n		when is_uber_invoice(si.id) > 0 then 275\r\n		when ifnull(cp.fn_acount_id,0) > 0 then ifnull(cp.fn_acount_id,0)\r\n        else 277 end \r\n	) as account_id \r\n,si.id as transaction_id\r\n,\'Sales_cancel\' as `event`\r\n,0 as is_send\r\n,( case \r\n		when is_uber_invoice(si.id) > 0 then \'Undeposited UBER Sales\'\r\n		when ifnull(cp.fn_acount_id,0) > 0 then ifnull(cp.fn_account_name,\'\')\r\n        else \'Undeposited Cash\' end \r\n	)  as account_code \r\n,bil.fn_companyCode as location_id\r\n,now() as cheque_date\r\n,now() as sent_on\r\n,\'\' as log_id\r\n,now() as created_on\r\n,si.code as transaction_code\r\nfrom tbl_payment_allocation pa\r\ninner join tbl_sale_invoice si on si.id = pa.invoice_id\r\ninner join tbl_branch_inventory_locations bil on bil.id = si.location_id\r\ninner join tbl_customers c on c.customer_id = si.customer_id\r\ninner join tbl_payment_summary_details psd on psd.id = pa.payment_id\r\nleft join tbl_card_types cp on cp.id = psd.card_type_id\r\nwhere pa.invoice_id = ?\r\n\r\n','CR payments **'),(21,'sales_return','INSERT INTO `tbl_acc_details`(`_date`, `description`, `cheque_no`, `payee`, `amount`, `type`, `tag_id`, `account_id`, `transaction_id`, `event`, `is_send`, `account_code`, `location_id`, `cheque_date`, `sent_on`, `log_id`, `created_on`,`transaction_code`)\r\nselect\r\ndate(cr.created_on) as _date\r\n,\'by api - \' as description\r\n,\'\' as cheque_no\r\n,c.customer_name as payee\r\n,rp.value as amount\r\n,\'CR\' as `type`\r\n,0 as tag_id\r\n, 274 as account_id  \r\n,cr.id as transaction_id\r\n,\'sales_return\' as `event`\r\n,0 as is_send \r\n,\'Cash In Hand\'  as account_code\r\n,bil.fn_companyCode as location_id\r\n,now() as cheque_date\r\n,now() as sent_on\r\n,0 as log_id\r\n,now() as created_on\r\n,si.code as transaction_code\r\n    \r\nfrom tbl_customer_returns cr\r\ninner join tbl_return_products rp on rp.return_id = cr.id \r\ninner join tbl_sale_invoice si on si.id = cr.sale_invoice_id\r\ninner join tbl_branch_inventory_locations bil on bil.id = si.location_id\r\ninner join tbl_customers c on c.customer_id = si.customer_id \r\nwhere cr.id = ?\r\n\r\n','CR payments **'),(22,'supplier_payments','INSERT INTO `tbl_acc_details`(`_date`, `description`, `cheque_no`, `payee`, `amount`, `type`, `tag_id`, `account_id`, `transaction_id`, `event`, `is_send`, `account_code`, `location_id`, `cheque_date`, `sent_on`, `log_id`, `created_on`,transaction_code)\r\nselect \r\n( case when sp.payment_type = \'CHEQUE\' then sp.cheque_date else sp.payment_date end ) as _date\r\n,\'by api - \' as description\r\n,( case when sp.payment_type = \'CHEQUE\' then sp.cheque_no else \'\' end ) as cheque_no\r\n,s.name as payee\r\n,sp.amount as amount\r\n,\'DR\' as `type`\r\n,0 as tag_id\r\n,85 as account_id \r\n,sp.id as transaction_id \r\n,\'supplier_payments\' as `event`\r\n,0 as is_send\r\n,\'Accounts Payable\' as account_code\r\n,bil.fn_companyCode as location_id\r\n,now() as cheque_date\r\n,now() as sent_on\r\n,\'\' as log_id\r\n,now() as created_on\r\n,sp.code as transaction_code\r\nfrom tbl_supplier_payments sp \r\ninner join tbl_supplier s on s.supplier_id = sp.supplier_id\r\ninner join tbl_branch_inventory_locations bil on bil.id = sp.location_id\r\nwhere sp.payment_type in (\'CASH\',\'CHEQUE\',\'ONLINE\')\r\nand sp.id = ?\r\n\r\n\r\n\r\n\r\n\r\n\r\n','DR Accounts Payable'),(23,'supplier_payments','INSERT INTO `tbl_acc_details`(`_date`, `description`, `cheque_no`, `payee`, `amount`, `type`, `tag_id`, `account_id`, `transaction_id`, `event`, `is_send`, `account_code`, `location_id`, `cheque_date`, `sent_on`, `log_id`, `created_on`,transaction_code)\r\nselect \r\n( case when sp.payment_type = \'CHEQUE\' then sp.cheque_date else sp.payment_date end ) as _date\r\n,\'by api - \' as description\r\n,( case when sp.payment_type = \'CHEQUE\' then sp.cheque_no else \'\' end ) as cheque_no\r\n,s.name as payee\r\n,sp.amount as amount\r\n,\'CR\' as `type`\r\n,0 as tag_id\r\n,( case when ifnull(ba.fn_acount_id,0) > 0 then ba.fn_acount_id else 274 end ) as account_id \r\n,sp.id as transaction_id \r\n,\'supplier_payments\' as `event`\r\n,0 as is_send\r\n,( case when ifnull(ba.fn_acount_id,0) > 0 then ba.fn_account_name else \'CASH IN HAND\' end ) as account_code\r\n,bil.fn_companyCode as location_id\r\n,now() as cheque_date\r\n,now() as sent_on\r\n,\'\' as log_id\r\n,now() as created_on\r\n,sp.code as transaction_code\r\nfrom tbl_supplier_payments sp \r\ninner join tbl_supplier s on s.supplier_id = sp.supplier_id\r\ninner join tbl_branch_inventory_locations bil on bil.id = sp.location_id\r\nleft join tbl_bank_accounts ba on ba.id = sp.bank_id\r\nwhere sp.payment_type in (\'CASH\',\'CHEQUE\',\'ONLINE\')\r\nand sp.id = ?\r\n\r\n\r\n\r\n\r\n\r\n\r\n','CR bank accounts and cash in hand'),(24,'return_cheque','INSERT INTO `tbl_acc_details`(`_date`, `description`, `cheque_no`, `payee`, `amount`, `type`, `tag_id`, `account_id`, `transaction_id`, `event`, `is_send`, `account_code`, `location_id`, `cheque_date`, `sent_on`, `log_id`, `created_on`,transaction_code)\r\nselect \r\ncr.return_date as _date\r\n,\'by api - \' as description\r\n,\'\' as cheque_no\r\n,c.customer_name as payee\r\n,rc.allocation_amount as amount\r\n,\'DR\' as `type`\r\n,0 as tag_id \r\n,(case when c.category = \'1\' then  \'19\' else \'140\' end ) as account_id  \r\n,rc.return_cheque_id as transaction_id\r\n,\'return_cheque\' as `event`\r\n,0 as is_send \r\n,(case when c.category = \'1\' then \'Trade Receivables- SLTB\' else \'Trade Receivables- Dealersale\' end ) as account_code\r\n,bil.fn_companyCode as location_id\r\n,cr.return_date as cheque_date\r\n,now() as sent_on\r\n,\'\' as log_id\r\n,now() as created_on\r\n,si.code as transaction_code\r\n\r\n\r\nfrom tbl_payment_allocation_return_cheque rc\r\ninner join tbl_return_cheques cr on cr.id = rc.return_cheque_id\r\ninner join tbl_sale_invoice si on si.id = rc.invoice_id\r\ninner join tbl_branch_inventory_locations bil on bil.id = si.location_id\r\ninner join tbl_customers c on c.customer_id = si.customer_id \r\ninner join tbl_payment_summary_details psd on psd.id = rc.payment_id\r\nwhere rc.return_cheque_id = ?','DR return cheque invoices'),(25,'return_cheque','INSERT INTO `tbl_acc_details`(`_date`, `description`, `cheque_no`, `payee`, `amount`, `type`, `tag_id`, `account_id`, `transaction_id`, `event`, `is_send`, `account_code`, `location_id`, `cheque_date`, `sent_on`, `log_id`, `created_on`,transaction_code)\r\nselect \r\ncase when pa.payment_type = \'CHEQUE\' then date(psd.received_date) else psd.cash_date end as _date\r\n,\'by api - \' as description\r\n,case when pa.payment_type = \'CHEQUE\' then psd.cheque_no else \'\' end as cheque_no\r\n,c.customer_name as payee\r\n,sum(pa.allocation_amount) as amount\r\n,\'CR\' as `type`\r\n,0 as tag_id\r\n,(case \r\n	when pa.payment_type = \'CHEQUE\' then  \r\n    ( case when c.category = \'1\' then \'28\' else \'151\' end )\r\nelse \'30\' end ) as account_id\r\n,pa.return_cheque_id as transaction_id\r\n,\'return_cheque\' as `event`\r\n,0 as is_send\r\n,(case  when pa.payment_type = \'CHEQUE\' then \r\n ( case when c.category = \'1\' then \'Cheque in hand SLTB\' else \'Cheque In Hand- Dealersale\' end )\r\nelse \'Cash in hand\' end) as account_code\r\n,bil.fn_companyCode as location_id\r\n,case when pa.payment_type = \'CHEQUE\' then date(psd.cheque_date) else psd.cash_date end as cheque_date\r\n,now() as sent_on\r\n,\'\' as log_id\r\n,now() as created_on\r\n,cr.code as transaction_code\r\n\r\nfrom tbl_payment_allocation_return_cheque pa\r\ninner join tbl_return_cheques cr on cr.id = pa.return_cheque_id\r\ninner join tbl_sale_invoice si on si.id = pa.invoice_id\r\ninner join tbl_branch_inventory_locations bil on bil.id = si.location_id\r\ninner join tbl_customers c on c.customer_id = si.customer_id\r\ninner join tbl_payment_summary_details psd on psd.id = pa.payment_id\r\ninner join tbl_payment_summary ps on ps.id = pa.ps_id\r\nleft join tbl_bank_accounts ba on ba.id = psd.bank_account_id\r\nwhere pa.return_cheque_id = ?\r\ngroup by pa.payment_id','CR return cheque'),(26,'supplier_return_cheque','INSERT INTO `tbl_acc_details`(`_date`, `description`, `cheque_no`, `payee`, `amount`, `type`, `tag_id`, `account_id`, `transaction_id`, `event`, `is_send`, `account_code`, `location_id`, `cheque_date`, `sent_on`, `log_id`, `created_on`,transaction_code)\r\nselect \r\nrcp.return_date as _date\r\n,\'by api - \' as description\r\n,sp.cheque_no as cheque_no\r\n,s.name as payee\r\n,sp.amount as amount\r\n,\'CR\' as `type`\r\n,0 as tag_id\r\n, 85 as account_id \r\n,rcp.id as transaction_id \r\n,\'supplier_return_cheque\' as `event`\r\n,0 as is_send\r\n,\'Accounts Payable\' as account_code\r\n,bil.fn_companyCode as location_id\r\n,now() as cheque_date\r\n,now() as sent_on\r\n,\'\' as log_id\r\n,now() as created_on\r\n,rcp.code as transaction_code\r\nfrom tbl_return_cheques_suppliers rcp  \r\ninner join tbl_supplier_payments sp  on sp.id = rcp.payment_id\r\ninner join tbl_supplier s on s.supplier_id = sp.supplier_id\r\ninner join tbl_branch_inventory_locations bil on bil.id = sp.location_id\r\nwhere sp.payment_type in (\'CASH\',\'CHEQUE\',\'ONLINE\')\r\nand sp.type != \'IMPORT_GRN\'\r\nand rcp.id = ?','CR Creditor Control Account '),(27,'supplier_return_cheque','INSERT INTO `tbl_acc_details`(`_date`, `description`, `cheque_no`, `payee`, `amount`, `type`, `tag_id`, `account_id`, `transaction_id`, `event`, `is_send`, `account_code`, `location_id`, `cheque_date`, `sent_on`, `log_id`, `created_on`,transaction_code)\r\nselect \r\nrcp.return_date as _date\r\n,\'by api - \' as description\r\n,sp.cheque_no as cheque_no\r\n,s.name as payee\r\n,sp.amount as amount\r\n,\'DR\' as `type`\r\n,0 as tag_id\r\n,( case when ifnull(ba.fn_acount_id,0) > 0 then ba.fn_acount_id else 274 end ) as account_id \r\n,rcp.id as transaction_id \r\n,\'supplier_return_cheque\' as `event`\r\n,0 as is_send\r\n,( case when ifnull(ba.fn_acount_id,0) > 0 then ba.fn_account_name else \'CASH IN HAND\' end ) as account_code\r\n,bil.fn_companyCode as location_id\r\n,now() as cheque_date\r\n,now() as sent_on\r\n,\'\' as log_id\r\n,now() as created_on\r\n,rcp.code as transaction_code\r\nfrom tbl_return_cheques_suppliers rcp  \r\ninner join tbl_supplier_payments sp  on sp.id = rcp.payment_id\r\ninner join tbl_supplier s on s.supplier_id = sp.supplier_id\r\ninner join tbl_branch_inventory_locations bil on bil.id = sp.location_id\r\nleft join tbl_bank_accounts ba on ba.id = sp.bank_id\r\nwhere sp.payment_type in (\'CASH\',\'CHEQUE\',\'ONLINE\')\r\nand sp.type != \'IMPORT_GRN\'\r\nand rcp.id = ?\r\n','DR bank accounts and cash in hand');

--
-- Table structure for table `tbl_acc_fn_log`
--

CREATE TABLE `tbl_acc_fn_log` (
  `id` int NOT NULL AUTO_INCREMENT,
  `status` varchar(100) NOT NULL,
  `ref_id` int NOT NULL,
  `log` varchar(5000) NOT NULL,
  `event` varchar(100) NOT NULL,
  `transaction_id` int NOT NULL,
  `created_on` datetime NOT NULL,
  `url` varchar(1000) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_acc_fn_log`
--


--
-- Table structure for table `tbl_api_keys`
--

CREATE TABLE `tbl_api_keys` (
  `id` int NOT NULL,
  `user_id` int NOT NULL,
  `api_key` varchar(255) NOT NULL,
  `level` int NOT NULL,
  `ignore_limits` tinyint(1) NOT NULL DEFAULT '0',
  `is_private_key` tinyint(1) NOT NULL DEFAULT '0',
  `ip_addresses` text,
  `date_created` int NOT NULL,
  `api_key_activated` enum('yes','no') NOT NULL DEFAULT 'no'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_api_keys`
--


--
-- Table structure for table `tbl_api_products`
--

CREATE TABLE `tbl_api_products` (
  `type` varchar(100) NOT NULL,
  `header_id` int NOT NULL,
  `product_id` int NOT NULL,
  `price` decimal(11,2) NOT NULL,
  `qty` decimal(11,2) NOT NULL,
  `created_by` int NOT NULL,
  `created_on` datetime NOT NULL,
  `id` int NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_api_products`
--


--
-- Table structure for table `tbl_api_products_header`
--

CREATE TABLE `tbl_api_products_header` (
  `id` int NOT NULL AUTO_INCREMENT,
  `type` varchar(100) NOT NULL,
  `is_used` tinyint(1) NOT NULL DEFAULT '0',
  `created_by` int NOT NULL,
  `created_on` datetime NOT NULL,
  `code` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_api_products_header`
--


--
-- Table structure for table `tbl_assemble`
--

CREATE TABLE `tbl_assemble` (
  `id` int NOT NULL AUTO_INCREMENT,
  `code` varchar(50) NOT NULL,
  `status` varchar(50) NOT NULL,
  `product_id` int NOT NULL DEFAULT '0',
  `discription` varchar(500) NOT NULL,
  `type` varchar(500) NOT NULL,
  `updated_by` int NOT NULL,
  `updated_on` datetime NOT NULL,
  `created_by` int NOT NULL,
  `created_on` datetime NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `is_delete` tinyint(1) NOT NULL DEFAULT '0',
  `qty` decimal(11,2) NOT NULL DEFAULT '0.00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_assemble`
--


--
-- Table structure for table `tbl_assemble_details`
--

CREATE TABLE `tbl_assemble_details` (
  `id` int NOT NULL AUTO_INCREMENT,
  `parent_id` int NOT NULL,
  `field_name` varchar(50) NOT NULL,
  `field_value` varchar(5000) NOT NULL,
  `created_by` int NOT NULL,
  `created_on` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_assemble_details`
--


--
-- Table structure for table `tbl_assemble_products`
--

CREATE TABLE `tbl_assemble_products` (
  `id` int NOT NULL AUTO_INCREMENT,
  `assemble_id` int NOT NULL,
  `product_id` int NOT NULL,
  `qty` decimal(11,2) NOT NULL DEFAULT '0.00',
  `description` varchar(50) NOT NULL,
  `created_by` int NOT NULL,
  `created_on` datetime NOT NULL,
  `updated_by` int NOT NULL,
  `updated_on` datetime NOT NULL,
  `is_delete` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_assemble_products`
--


--
-- Table structure for table `tbl_bank_accounts`
--

CREATE TABLE `tbl_bank_accounts` (
  `id` int NOT NULL AUTO_INCREMENT,
  `bank_id` int NOT NULL,
  `branch_id` int NOT NULL,
  `account_no` varchar(100) NOT NULL,
  `is_active` int NOT NULL,
  `is_delete` int NOT NULL,
  `created_datetime` datetime DEFAULT NULL,
  `created_by` int NOT NULL,
  `account_name` varchar(100) NOT NULL,
  `fn_account_id` varchar(50) NOT NULL,
  `fn_acount_id` int NOT NULL,
  `fn_account_name` varchar(1000) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_bank_accounts`
--


--
-- Table structure for table `tbl_bank_branches`
--

CREATE TABLE `tbl_bank_branches` (
  `bank_branch_id` int NOT NULL AUTO_INCREMENT,
  `bank_id` int NOT NULL,
  `bank_branch_code` varchar(45) DEFAULT NULL,
  `branch_name` varchar(100) NOT NULL,
  PRIMARY KEY (`bank_branch_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3026 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_bank_branches`
--

INSERT INTO `tbl_bank_branches` VALUES (1,4,'001','FORIEGN BRANCH'),(2,4,'038','PANCHIKAWATHTHA'),(3,4,'003','Colombo'),(5,6,'004','duplicate -Maradana'),(6,9,'005','Grandpass'),(7,5,'006','Maligawatta'),(8,10,'007','Old Moor Street'),(9,8,'009','Kurunegala'),(10,8,'011','Badulla'),(11,8,'012','Batticaloa'),(12,8,'015','Central Office'),(13,8,'016','Kalutara S/G'),(14,8,'018','Negombo'),(15,8,'020','Chilaw'),(16,8,'021','Ampara'),(17,8,'022','Anuradhapura'),(18,8,'023','Wellawatte'),(19,8,'024','Matara'),(20,8,'026','Main Street'),(21,8,'027','Kegalle'),(22,8,'028','Point Pedro'),(23,8,'029','Nuwara Eliya'),(24,8,'030','Katubedda'),(25,8,'031','Ratnapura'),(26,8,'032','Aluthkade'),(27,8,'034','Kollupitiya'),(28,8,'035','Haputale'),(29,8,'037','Bambalapitiya'),(30,8,'038','Borella S/G'),(31,8,'039','Ja Ela'),(32,8,'040','Hatton'),(33,8,'041','Maradana'),(34,8,'042','Peliyagoda'),(35,8,'043','Union Place'),(36,8,'044','Vavuniya'),(37,8,'045','Gampaha S/G'),(38,8,'046','Mannar'),(39,8,'047','Ambalangoda'),(40,8,'048','Puttalam'),(41,8,'049','Nugegoda'),(42,8,'050','Nattandiya'),(43,8,'051','Dehiwala'),(44,8,'052','Kuliyapitiya'),(45,8,'053','Chunnakam'),(46,8,'054','Horana'),(47,8,'055','Maharagama'),(48,8,'056','Tangalle'),(49,8,'057','Eheliyagoda'),(50,8,'058','Beruwala'),(51,8,'059','Kadawatha'),(52,8,'060','Fifth City'),(53,8,'061','Idama-Moratuwa'),(54,8,'063','Velanai'),(55,8,'068','Matale'),(56,8,'082','Monaragala'),(57,8,'083','Polonnaruwa New Town'),(58,8,'085','Hambantota'),(59,8,'087','International Division'),(60,8,'088','Mirigama'),(61,8,'089','Galle Bazaar'),(62,8,'092','Naula'),(63,8,'093','Kilinochchi'),(64,8,'098','Anuradhapura New Town'),(65,8,'099','Primary Dealer Unit'),(66,8,'101','Galaha'),(67,8,'102','Bentota'),(68,8,'104','Welpalla'),(69,8,'118','Muttur'),(70,8,'122','Galenbindunuwewa'),(71,8,'127','Padavi Parakramapura'),(72,8,'135','Imaduwa'),(73,8,'139','Weeraketiya'),(74,8,'144','Yatawatte'),(75,8,'152','Pemaduwa'),(76,8,'157','Tirappane'),(77,8,'162','Medawachchiya'),(78,8,'167','Rikillagaskada'),(79,8,'172','Kobeigane'),(80,8,'183','Sewagama'),(81,8,'217','Horowpathana'),(82,8,'236','Ipalogama'),(83,8,'238','Medagama'),(84,8,'250','Tawalama'),(85,8,'255','Malkaduwawa'),(86,8,'256','Thanthirimale'),(87,8,'257','Mawathagama'),(88,8,'258','Elakanda'),(89,8,'259','Rathgama'),(90,8,'260','Diyatalawa'),(91,8,'261','Katuwana'),(92,8,'262','Kekanadura'),(93,8,'263','Kosmodera'),(94,8,'264','Kudawella'),(95,8,'265','Lunugamvehera'),(96,8,'266','Maha-Edanda'),(97,8,'267','Makandura - Matara'),(98,8,'268','Malimbada'),(99,8,'270','Morawaka'),(100,8,'271','Pasgoda'),(101,8,'272','Pitabeddara'),(102,8,'273','Digana'),(103,8,'274','Weli-Oya'),(104,8,'276','Ahangama'),(105,8,'277','Aluthwala'),(106,8,'278','Barawakumbura'),(107,8,'280','Karapitiya'),(108,8,'281','Manipay'),(109,8,'282','Kitulgala'),(110,8,'283','Kolonna'),(111,8,'284','Kotiyakumbura'),(112,8,'285','Morontota'),(113,8,'287','Pinnawala'),(114,8,'288','Sabaragamuwa Provincial Council'),(115,8,'290','Seethawakapura'),(116,8,'291','Udawalawe'),(117,8,'292','Weligepola'),(118,8,'293','Dodangoda'),(119,8,'294','Karawanella'),(120,8,'295','Karawita'),(121,8,'297','Kegalle Hospital'),(122,8,'298','Urubokka'),(123,8,'299','Makandura'),(124,8,'300','Marawila'),(125,8,'301','Palaviya'),(126,8,'302','Pallama'),(127,8,'303','Paragahadeniya'),(128,8,'305','Thoduwawa'),(129,8,'306','Udappuwa'),(130,8,'308','Weerapokuna'),(131,8,'309','Wellawa'),(132,8,'311','Bulathkohupitiya'),(133,8,'312','Embilipitiya City'),(134,8,'313','Endana'),(135,8,'314','Galigamuwa'),(136,8,'315','Ratnapura Hospital'),(137,8,'316','Gonagaldeniya'),(138,8,'317','Kiriella'),(139,8,'318','Potuvil'),(140,8,'319','Mahawewa'),(141,8,'320','Ballaketuwa'),(142,8,'322','Thanamalwila'),(143,8,'323','Kochchikade'),(144,8,'324','Kumbukgete'),(145,8,'325','Kuruwita'),(146,8,'326','Thirumurukandi'),(147,8,'328','Visuvamadu'),(148,8,'329','Ambanpola'),(149,8,'330','Anawilundawa'),(150,8,'331','Dambadeniya'),(151,8,'332','Katuneriya'),(152,8,'333','Katupotha'),(153,8,'334','Kirimetiyana'),(154,8,'335','Mihintale'),(155,8,'336','Thalaimannar Pier'),(156,8,'337','Pussellawa'),(157,8,'338','Savalkaddu'),(158,8,'339','Sirupiddy'),(159,8,'340','Wattegama'),(160,8,'341','Puthukudieruppu'),(161,8,'342','Puthukulam'),(162,8,'343','Uva Paranagama'),(163,8,'344','Pesalai'),(164,8,'345','Poonagary'),(165,8,'346','Poovarasankulam'),(166,8,'348','Padiyatalawa'),(167,8,'349','Mallavi'),(168,8,'351','Manthikai'),(169,8,'353','Mulankavil'),(170,8,'355','Mulliyawalai'),(171,8,'356','Murungan'),(172,8,'357','Nainativu'),(173,8,'358','Nallur'),(174,8,'359','Nanatan'),(175,8,'360','Nedunkerny'),(176,8,'361','Oddusudan'),(177,8,'362','Omanthai'),(178,8,'363','Pallai'),(179,8,'364','Paranthan'),(180,8,'366','Jaffna Bus Stand'),(181,8,'368','Jaffna Main Street'),(182,8,'369','Jaffna University'),(183,8,'370','Kaithady'),(184,8,'371','Kalviyankadu'),(185,8,'372','Karanavai'),(186,8,'373','Kayts'),(187,8,'375','Kodikamam'),(188,8,'376','Kokuvil'),(189,8,'378','Madhu'),(190,8,'379','Wariyapola'),(191,8,'380','Alaveddy'),(192,8,'381','Andankulam'),(193,8,'382','Cheddikulam'),(194,8,'384','Meegahakiwula'),(195,8,'385','Vavunathivu'),(196,8,'386','Vellaveli'),(197,8,'388','Diyabeduma'),(198,8,'389','Diyasenpura'),(199,8,'390','Doramadalawa'),(200,8,'391','Galamuna'),(201,8,'392','\'General Hospital, A\' pura\''),(202,8,'393','Habarana'),(203,8,'394','Minneriya'),(204,8,'395','Padaviya'),(205,8,'396','Rajanganaya'),(206,8,'397','Rajina Junction'),(207,8,'398','Ranajayapura'),(208,8,'399','Sevanapitiya'),(209,8,'400','Thalawa'),(210,8,'401','Ayagama'),(211,8,'402','Oddamavady'),(212,8,'403','Oluwil'),(213,8,'404','Palugamam'),(214,8,'405','Polwatte'),(215,8,'406','Palmuddai'),(216,8,'407','Sainthamarathu'),(217,8,'408','Serunuwara'),(218,8,'409','Thambiluvil'),(219,8,'410','Thampalakamam'),(220,8,'411','Thoppur'),(221,8,'413','Uhana'),(222,8,'414','Uppuvely'),(223,8,'415','Vakarai'),(224,8,'416','Siyambalanduwa'),(225,8,'417','Mollipothana'),(226,8,'418','Morawewa'),(227,8,'419','Navithanvely'),(228,8,'420','Nilavely'),(229,8,'421','Seeduwa'),(230,8,'422','Malwatte'),(231,8,'423','Mamangama'),(232,8,'424','Maruthamunai'),(233,8,'425','Pundaluoya'),(234,8,'426','Kallady'),(235,8,'427','Kallar'),(236,8,'428','Karadiyanaru'),(237,8,'429','Karaitivu'),(238,8,'430','Kiran'),(239,8,'431','Kokkadicholai'),(240,8,'432','Galewela'),(241,8,'433','Divulapitiya'),(242,8,'434','Wellawaya'),(243,8,'436','China Bay'),(244,8,'438','Gonagolla'),(245,8,'439','Irakkamam'),(246,8,'440','Samanthurai'),(247,8,'441','Pujapitiya'),(248,8,'442','Ragala'),(249,8,'443','Sigiriya'),(250,8,'444','Ukuwela'),(251,8,'446','Upcott'),(252,8,'447','Wilgamuwa'),(253,8,'448','Addalachchenai'),(254,8,'449','Alankerny'),(255,8,'451','Araiyampathy'),(256,8,'452','Batticaloa Town'),(257,8,'453','Independent  Square'),(258,8,'455','Kotagala'),(259,8,'456','Marassana'),(260,8,'458','Meepilimana'),(261,8,'459','Menikhinna'),(262,8,'461','Palapathwela'),(263,8,'462','Botanical Gardens Peradeniya'),(264,8,'463','Haldummulla'),(265,8,'465','Bokkawala'),(266,8,'466','Danture'),(267,8,'467','Daulagala'),(268,8,'469','Digana Village'),(269,8,'470','Gampola City'),(270,8,'472','Hatharaliyadda'),(271,8,'471','Ginigathhena'),(272,8,'473','Kandy City Centre'),(273,8,'474','Court Complex Kandy'),(274,8,'476','Ettampitiya'),(275,8,'477','Yatiyantota'),(276,8,'487','Adikarigama'),(277,8,'488','Agarapathana'),(278,8,'489','Akurana'),(279,8,'490','Ankumbura'),(280,8,'491','Bogawantalawa'),(281,8,'492','Padiyapelella'),(282,8,'494','Andiambalama'),(283,8,'497','Dankotuwa'),(284,8,'498','Alawwa'),(285,8,'499','Wijerama Junction'),(286,8,'500','Jaffna 2nd Branch'),(287,8,'501','Chavakachcheri'),(288,8,'502','Kaduruwela'),(289,8,'503','Passara'),(290,8,'504','Devinuwara'),(291,8,'505','Wattala'),(292,8,'506','Maskeliya'),(293,8,'507','Kahawatte'),(294,8,'508','Wennappuwa'),(295,8,'509','Hingurana'),(296,8,'510','Kalmunai'),(297,8,'511','Mullaitivu'),(298,8,'512','Thimbirigasyaya'),(299,8,'513','Kurunegala Bazaar'),(300,8,'514','Galnewa'),(301,8,'515','Bandarawela'),(302,8,'516','Thalawathugoda'),(303,8,'517','Walasmulla'),(304,8,'518','Middeniya'),(305,8,'520','Sri Jayawardenapura Hospital'),(306,8,'521','Hyde Park'),(307,8,'522','Batapola'),(308,8,'524','Geli Oya'),(309,8,'525','Baddegama'),(310,8,'526','Polgahawela'),(311,8,'527','Welisara'),(312,8,'528','Deniyaya'),(313,8,'529','Kamburupitiya'),(314,8,'530','Avissawella'),(315,8,'531','Talawakelle'),(316,8,'532','Ridigama'),(317,8,'533','Pitakotte'),(318,8,'534','Narammala'),(319,8,'535','Embilipitiya'),(320,8,'536','Kegalle Bazaar'),(321,8,'537','Ambalantota'),(322,8,'538','Tissamaharama'),(323,8,'539','Beliatta'),(324,8,'540','Badalkumbura'),(325,8,'541','Pelawatte City Kalutara'),(326,8,'542','Mahiyangana'),(327,8,'543','Kiribathgoda'),(328,8,'544','Madampe'),(329,8,'545','Minuwangoda'),(330,8,'546','Pannala'),(331,8,'547','Nikaweratiya'),(332,8,'548','Anamaduwa'),(333,8,'549','Galgamuwa'),(334,8,'550','Weligama'),(335,8,'551','Anuradhapura Bazzar'),(336,8,'553','Giriulla'),(337,8,'554','Bingiriya'),(338,8,'555','Melsiripura'),(339,8,'556','Matugama'),(340,8,'557','Moratumulla'),(341,8,'558','Waikkal'),(342,8,'559','Mawanella'),(343,8,'560','Buttala'),(344,8,'561','Dematagoda'),(345,8,'562','Warakapola'),(346,8,'563','Dharga Town'),(347,8,'564','Maho'),(348,8,'565','Madurankuliya'),(349,8,'566','Aranayake'),(350,8,'567','Dedicated Economic Centre - Meegoda'),(351,8,'568','Homagama'),(352,8,'569','Hiripitiya'),(353,8,'570','Hettipola'),(354,8,'571','Kirindiwela'),(355,8,'572','Negombo Bazzar'),(356,8,'573','Central Bus Stand'),(357,8,'574','Mankulam'),(358,8,'575','Gampola'),(359,8,'576','Dambulla'),(360,8,'577','Lunugala'),(361,8,'578','Yakkalamulla'),(362,8,'579','Bibile'),(363,8,'580','Dummalasuriya'),(364,8,'581','Madawala'),(365,8,'582','Rambukkana'),(366,8,'583','Mattegoda'),(367,8,'584','Wadduwa'),(368,8,'585','Ruwanwella'),(369,8,'587','Pilimatalawa'),(370,8,'588','Peradeniya'),(371,8,'589','Kalpitiya'),(372,8,'590','Akkaraipattu'),(373,8,'591','Nintavur'),(374,8,'592','Dikwella'),(375,8,'593','Milagiriya'),(376,8,'594','Rakwana'),(377,8,'595','Kolonnawa'),(378,8,'596','Talgaswela'),(379,8,'597','Nivitigala'),(380,8,'598','Nawalapitiya'),(381,8,'599','Aralaganwila'),(382,8,'600','Jayanthipura'),(383,8,'601','Hingurakgoda'),(384,8,'602','Kirulapana'),(385,8,'603','Lanka Hospital'),(386,8,'604','Ingiriya'),(387,8,'605','Kankesanthurai'),(388,8,'606','Uda Dumbara'),(389,8,'607','Panadura Bazaar'),(390,8,'608','Kaduwela'),(391,8,'609','Hikkaduwa'),(392,8,'610','Pitigala'),(393,8,'611','Kaluwanchikudy'),(394,8,'612','Lake View'),(395,8,'613','Akuressa'),(396,8,'614','Matara City'),(397,8,'615','Galagedera'),(398,8,'616','Kataragama'),(399,8,'617','Keselwatte'),(400,8,'618','Metropolitan'),(401,8,'619','Elpitiya'),(402,8,'620','Kesbewa'),(403,8,'621','Kebithigollawa'),(404,8,'622','Kahatagasdigiliya'),(405,8,'623','Kantale Bazaar'),(406,8,'624','Trincomalee Bazaar'),(407,8,'625','Katukurunda'),(408,8,'626','Valachchenai'),(409,8,'627','Regent Street'),(410,8,'628','Grandpass'),(411,8,'629','Koslanda'),(412,8,'630','Chenkalady'),(413,8,'633','Kandapola'),(414,8,'634','Dehiowita'),(415,8,'636','Lake House'),(416,8,'638','Nelliady'),(417,8,'639','Rattota'),(418,8,'640','Pallepola'),(419,8,'641','Medirigiriya'),(420,8,'642','Deraniyagala'),(421,8,'643','Gonapola'),(422,8,'644','Parliamentary Complex'),(423,8,'645','Kalawana'),(424,8,'646','Boralesgamuwa'),(425,8,'647','Lunuwatte'),(426,8,'648','Kattankudy'),(427,8,'649','Kandy 2nd'),(428,8,'650','Talatuoya'),(429,8,'651','Bombuwela'),(430,8,'652','Bakamuna'),(431,8,'653','Galkiriyagama'),(432,8,'654','Madatugama'),(433,8,'655','Tambuttegama'),(434,8,'656','Nochchiyagama'),(435,8,'657','Agalawatta'),(436,8,'658','Katunayake I.P.Z.'),(437,8,'660','Corporate'),(438,8,'662','Baduraliya'),(439,8,'663','Kotahena'),(440,8,'664','Pothuhera'),(441,8,'665','Bandaragama'),(442,8,'666','Katugastota'),(443,8,'667','Neluwa'),(444,8,'668','Borella  2nd'),(445,8,'669','Girandurukotte'),(446,8,'670','Kollupitiya 2nd'),(447,8,'672','Central Super Market'),(448,8,'673','Bulathsinhala'),(449,8,'674','Enderamulla'),(450,8,'675','Nittambuwa'),(451,8,'676','Kekirawa'),(452,8,'677','Weliweriya'),(453,8,'678','Padukka'),(454,8,'679','Battaramulla'),(455,8,'680','Aluthgama'),(456,8,'681','Personal'),(457,8,'682','Veyangoda'),(458,8,'683','Pelmadulla'),(459,8,'684','Ratnapura Bazaar'),(460,8,'685','Ward Place'),(461,8,'686','Dehiattakandiya'),(462,8,'687','Raddolugama'),(463,8,'688','Balangoda'),(464,8,'689','Ratmalana'),(465,8,'690','Pelawatta'),(466,8,'691','Hakmana'),(467,8,'692','Eppawala'),(468,8,'693','Ruhunu Campus'),(469,8,'699','Bogahakumbura'),(470,8,'701','Ella'),(471,8,'703','Keppetipola'),(472,8,'708','Batuwatte'),(473,8,'711','Bopitiya'),(474,8,'713','Asiri Central'),(475,8,'714','Katuwellegama Courtaulds Clothing Lanka (Pvt) Ltd'),(476,8,'715','Dalugama'),(477,8,'716','Delgoda'),(478,8,'718','Fish Market Peliyagoda'),(479,8,'717','Demanhandiya'),(480,8,'720','Ganemulla'),(481,8,'721','Gothatuwa'),(482,8,'723','Mulleriyawa New Town'),(483,8,'722','Katana'),(484,8,'724','Naiwala'),(485,8,'728','Meegalewa'),(486,8,'729','Badulla City'),(487,8,'730','Welimada'),(488,8,'731','CEYBANK Credit card centre'),(489,8,'732','Biyagama'),(490,8,'735','Kinniya'),(491,8,'736','Piliyandala'),(492,8,'741','Hanwella'),(493,8,'743','Walapane'),(494,8,'744','Walgama'),(495,8,'746','Rajagiriya'),(496,8,'747','Taprobane'),(497,8,'748','Uragasmanhandiya'),(498,8,'749','Karainagar'),(499,8,'750','Koggala E.P.Z'),(500,8,'751','Suriyawewa'),(501,8,'752','Thihagoda'),(502,8,'753','Udugama'),(503,8,'754','Ahungalla'),(504,8,'757','Athurugiriya'),(505,8,'760','Treasury Division'),(506,8,'761','Thirunelvely'),(507,8,'762','Narahenpita'),(508,8,'763','Malabe'),(509,8,'764','Ragama'),(510,8,'765','Pugoda'),(511,8,'766','Mount Lavinia'),(512,8,'767','Ranna'),(513,8,'768','Alawathugoda'),(514,8,'769','Yakkala'),(515,8,'770','Ibbagamuwa'),(516,8,'771','Kandana'),(517,8,'772','Hemmathagama'),(518,8,'773','Kottawa'),(519,8,'774','Angunakolapelessa'),(520,8,'775','Visakha'),(521,8,'776','Islamic Banking Unit'),(522,8,'778','Atchuvely'),(523,8,'779','Norchcholei'),(524,8,'780','Kadawatha 2nd City'),(525,8,'781','Teldeniya'),(526,8,'782','Rambewa'),(527,8,'783','Polpithigama'),(528,8,'784','Deiyandara'),(529,8,'785','Hali ela'),(530,8,'786','Godakawela'),(531,8,'787','Kopay'),(532,8,'788','BOC premier'),(533,8,'789','Makola'),(534,8,'790','Eravur'),(535,8,'791','Valvettithurai'),(536,8,'792','Chankanai'),(537,8,'793','Vavuniya City'),(538,8,'794','Urumpirai'),(539,8,'796','Mattala Airport'),(540,8,'797','Medawala'),(541,8,'800','Wanduramba'),(542,8,'802','\'Provincial Council Complex, Pallakelle\''),(543,8,'803','Welioya-Sampath Nuwara'),(544,8,'804','Vaddukoddai'),(545,8,'805','Madawakkulama'),(546,8,'806','Mahaoya'),(547,8,'808','Bogaswewa'),(548,8,'809','Kurunduwatte'),(549,8,'810','Ethimale'),(550,8,'811','Central Camp'),(551,8,'812','Aladeniya'),(552,8,'822','Corporate 2nd'),(553,8,'999','Head Office'),(554,11,'008','Kollupitiya'),(555,11,'010','Pettah'),(556,11,'014','Wattala'),(557,12,'000','Head Office'),(558,12,'100','Cash Mgmt'),(559,11,'001','Head Office'),(560,8,'001','City Office'),(561,8,'002','Kandy'),(562,8,'003','Galle Fort'),(563,8,'004','Pettah'),(564,8,'005','Jaffna'),(565,8,'006','Trincomalee'),(566,8,'007','Panadura'),(567,11,'002','Bambalapitiya'),(568,11,'003','Wellawatte'),(569,11,'004','Kiribathgoda'),(570,11,'005','Kirullapone'),(571,11,'006','Moratuwa'),(572,11,'007','Rajagiriya'),(573,11,'011','Union Place'),(574,11,'012','Negombo'),(575,11,'999','Head Office'),(576,12,'001','Head Office'),(577,12,'999','Head Office'),(578,4,'000','Head Office'),(579,4,'001','Head Office'),(580,4,'002','City Office'),(581,4,'003','Foreign'),(582,4,'004','Kandy'),(583,4,'005','Galle Fort'),(584,4,'006','Jaffna'),(585,4,'007','Matara'),(586,4,'008','Matale'),(587,4,'009','Galewela'),(588,4,'010','Wellawatte'),(589,4,'011','Kollupitiya'),(590,4,'012','Kotahena'),(591,4,'013','Negombo'),(592,4,'014','Hikkaduwa'),(593,4,'015','Hingurakgoda'),(594,4,'016','Kurunegala'),(595,4,'017','Old Moor Street'),(596,4,'018','Maharagama'),(597,4,'019','Borella'),(598,4,'020','Nugegoda'),(599,4,'021','Kegalle'),(600,4,'022','Narahenpita'),(601,4,'023','Mutuwal'),(602,4,'024','Pettah'),(603,4,'025','Katunayake FTZ'),(604,4,'026','Wennappuwa'),(605,4,'027','Galle City'),(606,4,'028','Koggala'),(607,4,'029','Battaramulla'),(608,4,'030','Embilipitiya'),(609,4,'031','Kandana'),(610,4,'032','Maradana'),(611,4,'033','Minuwangoda'),(612,4,'034','Nuwara Eliya'),(613,4,'035','Akuressa'),(614,4,'036','Kalutara'),(615,4,'037','Trincomalee'),(616,4,'038','Panchikawatte'),(617,4,'039','Keyzer Street'),(618,4,'040','Aluthgama'),(619,4,'041','Panadura'),(620,4,'042','Kaduwela'),(621,4,'043','Chilaw'),(622,4,'044','Gampaha'),(623,4,'045','Katugastota'),(624,4,'046','Ratmalana'),(625,4,'047','Kirulapona'),(626,4,'048','Union Place'),(627,4,'049','Ratnapura'),(628,4,'050','Colombo 7'),(629,4,'051','Kuliyapitiya'),(630,4,'052','Badulla'),(631,4,'053','Anuradhapura'),(632,4,'054','Dambulla'),(633,4,'055','Nattandiya'),(634,4,'056','Wattala'),(635,4,'057','Grandpass'),(636,4,'058','Dehiwala'),(637,4,'059','Moratuwa'),(638,4,'060','Narammala'),(639,4,'061','Vavuniya'),(640,4,'062','Rajagiriya'),(641,4,'063','Ambalantota'),(642,4,'064','Seeduwa'),(643,4,'065','Nittambuwa'),(644,4,'066','Mirigama'),(645,4,'067','Kadawatha'),(646,4,'068','Duplication Road'),(647,4,'069','Kiribathgoda'),(648,4,'070','Avissawella'),(649,4,'071','Ekala  (CSP)'),(650,4,'072','Pettah Main Street'),(651,4,'073','Peradeniya  (CSP)'),(652,4,'074','Kochchikade'),(653,4,'075','Homagama'),(654,4,'076','Horana'),(655,4,'077','Piliyandala'),(656,4,'078','Thalawathugoda (C.S.P.)'),(657,4,'079','Mawanella'),(658,4,'080','Bandarawela'),(659,4,'081','Ja-Ela'),(660,4,'082','Balangoda'),(661,4,'083','Nikaweratiya'),(662,4,'084','Bandaragama (C.S.P.)'),(663,4,'085','Yakkala'),(664,4,'086','Malabe (C.S.P.)'),(665,4,'087','Kohuwala - (C.S.P.)'),(666,4,'088','Kaduruwela'),(667,4,'089','Nawalapitiya'),(668,4,'093','Mount Lavinia(C.S.P.)'),(669,4,'096','Mathugama'),(670,4,'097','Ambalangoda'),(671,4,'098','Baddegama'),(672,4,'100','Ampara'),(673,4,'101','Nawala  (C.S.P.)'),(674,4,'102','Gampola'),(675,4,'103','Elpitiya'),(676,4,'104','Kamburupitiya'),(677,4,'105','Batticaloa'),(678,4,'106','Bambalapitiya'),(679,4,'107','Chunakkam'),(680,4,'108','Nelliady'),(681,4,'109','Pilimathalawa'),(682,4,'110','Kekirawa'),(683,4,'111','Deniyaya'),(684,4,'112','Weligama'),(685,4,'113','Baseline'),(686,4,'114','Katubedda'),(687,4,'115','Hatton'),(688,4,'116','Reid Avenue'),(689,4,'117','Pitakotte CSP'),(690,4,'118','Negombo Extension Office'),(691,4,'119','Kotikawatta'),(692,4,'120','Monaragala'),(693,4,'121','Kottawa'),(694,4,'122','Kurunegala City Office'),(695,4,'123','Tangalle'),(696,4,'124','Tissamaharama'),(697,4,'125','Neluwa'),(698,4,'126','Chavakachcheri'),(699,4,'127','\'Stanley Road, Jaffna\''),(700,4,'128','Warakapola'),(701,4,'129','Udugama'),(702,4,'130','Athurugiriya'),(703,4,'131','Raddolugama'),(704,4,'132','Boralesgamuwa CSP'),(705,4,'133','Kahawatta'),(706,4,'134','Delkanda'),(707,4,'135','karapitiya'),(708,4,'136','Welimada'),(709,4,'137','Mahiyanganaya'),(710,4,'138','Kalawana'),(711,4,'139','Kirindiwela'),(712,4,'140','Digana'),(713,4,'141','Polgahawela'),(714,4,'142','Boralesgamuwa'),(715,4,'143','Hanwella'),(716,4,'144','Pannala'),(717,4,'145','Ward Place'),(718,4,'146','Wadduwa'),(719,4,'147','Biyagama'),(720,4,'148','Puttlam'),(721,4,'149','Pelmadulla'),(722,4,'150','Kandy City office'),(723,4,'151','Matara City office'),(724,4,'152','Kalmunai'),(725,4,'153','Manipay'),(726,4,'154','Mannar'),(727,4,'155','Kilinochchi'),(728,4,'156','Atchchuvely'),(729,4,'157','Thirunelvely'),(730,4,'158','Eheliyagoda'),(731,4,'159','Valachchenai'),(732,4,'160','Wellawaya'),(733,4,'161','Mawathagama'),(734,4,'162','Thambuttegama'),(735,4,'163','Ruwanwella'),(736,4,'164','Dankotuwa'),(737,4,'165','Peliyagoda CSP'),(738,4,'166','Hambantota'),(739,4,'167','Katubedda CSP'),(740,4,'168','Eravur'),(741,4,'169','Priority Banking Centre'),(742,4,'170','Velanai'),(743,4,'171','Vavuniya Extension Office'),(744,4,'172','Akkaraipattu'),(745,4,'173','Kataragama'),(746,4,'174','Wariyapola'),(747,4,'175','Kuruwita'),(748,4,'176','Middeniya'),(749,4,'177','Ganemulla'),(750,4,'178','World Trade Centre'),(751,4,'179','Wellawatte 2nd'),(752,4,'180','Divulapitiya'),(753,4,'181','Beliatta'),(754,4,'182','Giriulla'),(755,4,'183','Marawila'),(756,4,'184','Thalawakelle'),(757,4,'185','Anuradhapura New Town'),(758,4,'186','Passara'),(759,4,'187','Padukka'),(760,4,'188','Alawwa'),(761,4,'189','Panadura Extention Office'),(762,4,'190','Katunayake 24/7 Centre'),(763,4,'193','Kattankudy'),(764,4,'194','Pottuvil'),(765,4,'195','Maskeliya'),(766,4,'196','Liberty Plaza CSP'),(767,4,'197','Godakawela CSP'),(768,4,'198','Kodikamam'),(769,4,'199','Makola'),(770,4,'200','Medawachchiya'),(771,4,'204','SLIC- CSP'),(772,4,'206','Palavi'),(773,4,'208','Nawala Service Point'),(774,4,'209','Maharagama Minicom'),(775,4,'210','Moratuwa Minicom'),(776,4,'212','Kurunegala Service Point'),(777,4,'213','Ratnapura (Laugfs Super)'),(778,4,'216','Ramanayake Mawatha'),(779,4,'217','Kirulapone Minicom'),(780,4,'218','Gampaha CSP'),(781,4,'219','Akurana Service Point'),(782,4,'220','Beruwala CSP'),(783,4,'221','Ragama'),(784,4,'222','Matara Minicom Centre'),(785,4,'223','Panadura CSP'),(786,4,'224','Horana Service Point'),(787,4,'225','Wattala Minicom'),(788,4,'226','Bokundara CSP'),(789,4,'227','Katukurunda CSP'),(790,4,'228','Weliweria'),(791,4,'229','Mulliyawalai'),(792,4,'230','Ja - Ela (K-Zone)'),(793,4,'234','Kadawatha (Arpico Super)'),(794,4,'251','Dehiwala Arpico Super Centre'),(795,4,'252','Batharamulla Arpico Super Centre'),(796,4,'253','Hydepark Arpico Service Center'),(797,4,'254','Anniwatte CSP'),(798,4,'255','Kundasale (Dumbara Super CSP)'),(799,4,'256','Negambo Arpico Super Centre'),(800,4,'257','Kiribathgoda Service Point'),(801,4,'258','Holiday Banking Centre - Majestic City'),(802,4,'259','Nawam Mawatha'),(803,4,'260','Wattala Arpico Super Center'),(804,4,'261','Nittambuwa CSP'),(805,4,'262','Pelawatte CSP'),(806,4,'263','Balagolla CSP'),(807,4,'264','Hendala Service Point'),(808,4,'265','Gelioya Service Point'),(809,4,'266','Kohuwala Service Point'),(810,4,'267','Kalutara (Arpico Super)'),(811,4,'268','Mattegoda (Laugfs Super)'),(812,4,'901','Islamic Banking Unit'),(813,4,'999','Head Office'),(814,13,'000','Habib Bank Ltd'),(815,13,'001','Main Branch'),(816,13,'002','Lake View'),(817,13,'003','Kalmunai'),(818,13,'999','Head Office'),(819,5,'001','Aluthkade'),(820,5,'002','City Office'),(821,5,'003','Head Office'),(822,5,'004','Head Office'),(823,5,'005','Green Path'),(824,5,'006','Duplicate Maligawatta'),(825,5,'007','Pettah'),(826,5,'009','Wellawatta'),(827,5,'010','Anuradhapura'),(828,5,'011','Badulla'),(829,5,'012','Bandarawela'),(830,5,'013','Galle'),(831,5,'014','Gampola'),(832,5,'015','Hatton'),(833,5,'016','Jaffna Metro'),(834,5,'017','Kahawatte'),(835,5,'018','Kandy'),(836,5,'019','Kurunegala'),(837,5,'020','Mannar'),(838,5,'021','Maskeliya'),(839,5,'022','Moratuwa'),(840,5,'023','Nawalapitiya'),(841,5,'024','Negombo'),(842,5,'025','Nittambuwa'),(843,5,'026','Nochchiyagama'),(844,5,'027','Nugegoda'),(845,5,'028','Nuwara Eliya'),(846,5,'029','Pussellawa'),(847,5,'030','Ratnapura'),(848,5,'031','Trincomalee'),(849,5,'032','Vavuniya'),(850,5,'033','Welimada'),(851,5,'034','Kalutara'),(852,5,'035','Wattala'),(853,5,'036','Sri Jay\'awardanapura Kotte'),(854,5,'038','Piliyandala'),(855,5,'039','Bambalapitiya'),(856,5,'040','Chilaw'),(857,5,'041','Kegalle'),(858,5,'042','Matara'),(859,5,'043','Kirulapone'),(860,5,'044','Polonnaruwa'),(861,5,'045','Ambalantota'),(862,5,'046','Grandpass'),(863,5,'047','Biyagama'),(864,5,'048','Dambulla'),(865,5,'049','Katunayake'),(866,5,'050','Embilipitiya'),(867,5,'051','Gampaha'),(868,5,'052','Horana'),(869,5,'053','Monaragala'),(870,5,'054','International Division'),(871,5,'055','Borella'),(872,5,'056','Kiribathgoda'),(873,5,'057','Batticaloa'),(874,5,'058','Ampara'),(875,5,'059','Panchikawatta'),(876,5,'060','Bogawanthalawa'),(877,5,'061','Mount Lavinia'),(878,5,'063','Hulftsdorp'),(879,5,'064','Maharagama'),(880,5,'065','Matale'),(881,5,'066','Pinnawala'),(882,5,'067','Suriyawewa'),(883,5,'068','Hambantota'),(884,5,'069','Panadura'),(885,5,'070','Dankotuwa'),(886,5,'071','Balangoda'),(887,5,'072','Sea Street'),(888,5,'073','Moratumulla'),(889,5,'074','Kuliyapitiya'),(890,5,'075','Buttala'),(891,5,'076','Cinnamon Gardens'),(892,5,'077','Homagama'),(893,5,'078','Akkaraipattu'),(894,5,'079','Marandagahamula'),(895,5,'079','Duplicate Marandagahamula'),(896,5,'080','Marawila'),(897,9,'080','Ratmalana'),(898,14,'000','Hongkong & Shanghai Bank'),(899,14,'001','Head Office'),(900,5,'081','Ambalangoda'),(901,5,'082','Kaduwela'),(902,5,'083','Puttalam'),(903,5,'084','Kadawatha'),(904,5,'085','Talangama'),(905,14,'002','Kandy'),(906,5,'086','Tangalle'),(907,5,'087','Ja-Ela'),(908,14,'003','Colpetty'),(909,14,'004','Wellawatte'),(910,14,'005','Nugegoda'),(911,5,'088','Thambuttegama'),(912,14,'006','World Trade Center'),(913,14,'007','Bambalapitiya'),(914,14,'008','Pelawatte'),(915,14,'012','Union Place'),(916,5,'089','Mawanella'),(917,14,'014','Wattala'),(918,5,'090','Tissamaharama'),(919,14,'015','Premier Centre'),(920,5,'091','Kalmunai'),(921,14,'017','Negombo'),(922,5,'092','Thimbirigasyaya'),(923,5,'093','Dehiwala'),(924,14,'018','Moratuwa'),(925,5,'094','Minuwangoda'),(926,14,'020','kohuwela'),(927,5,'095','Kantale'),(928,14,'021','Jaffna'),(929,5,'096','Kotahena'),(930,14,'022','Galle'),(931,14,'999','Head Office'),(932,5,'097','Mutwal'),(933,5,'098','Kottawa'),(934,5,'099','Kirindiwela'),(935,5,'100','Katugastota'),(936,5,'101','Pelmadulla'),(937,5,'102','Ragama'),(938,5,'103','Dematagoda'),(939,5,'104','Narahenpita'),(940,5,'105','Treasury Division'),(941,5,'106','Wellawaya'),(942,5,'107','Elpitiya'),(943,5,'108','Maradana'),(944,5,'109','Aluthgama'),(945,5,'110','Wennappuwa'),(946,5,'111','Avissawella'),(947,5,'112','Boralesgamuwa'),(948,5,'113','Card Centre'),(949,5,'114','Central Colombo'),(950,5,'115','Kollupitiya'),(951,5,'117','Chunnakam'),(952,5,'118','Nelliady'),(953,15,'000','Head Office'),(954,5,'119','Kandana'),(955,15,'001','Head Office'),(956,5,'120','Deniyaya Customer Centre'),(957,15,'002','Jaffna'),(958,5,'121','Nikaweratiya'),(959,5,'122','Delgoda'),(960,15,'999','Head Office'),(961,5,'123','Alawwa'),(962,5,'124','Mahiyanganaya'),(963,5,'125','Mathugama'),(964,23,'000','Head Office'),(965,5,'126','Warakapola'),(966,23,'001','Matara'),(967,5,'127','Middeniya'),(968,23,'999','Head Office'),(969,5,'128','Galgamuwa'),(970,5,'129','Kohuwela'),(971,24,'000','Head Office'),(972,5,'130','Weliweriya'),(973,5,'131','Hendala'),(974,24,'001','Head Office'),(975,5,'132','Point Pedro'),(976,24,'002','Kandy'),(977,5,'133','Norochchole'),(978,24,'003','Jaffna'),(979,5,'134','Thirukovil'),(980,24,'032','Kohuwala'),(981,5,'135','Eravur'),(982,24,'999','Head Office'),(983,5,'136','Ganemulla'),(984,5,'137','Chavakachcheri'),(985,5,'138','Kelaniya'),(986,5,'139','Hanwella'),(987,5,'140','Padukka'),(988,5,'141','Pilimatalawa'),(989,25,'000','Central Clearing'),(990,5,'142','Thalawathugoda'),(991,25,'001','\'NTB.Head Office,\''),(992,5,'143','Medawachchiya'),(993,25,'002','Colpetty'),(994,5,'144','Thirunelvely'),(995,25,'003','Sri Sangharaja Mw.'),(996,5,'145','Negombo Metro'),(997,5,'146','Kilinochchi South'),(998,25,'004','Kandy'),(999,25,'005','Wellawatte'),(1000,5,'147','Nawala'),(1001,25,'006','Corporate'),(1002,5,'148','Giriulla'),(1003,25,'007','Negombo(C.S.P.)'),(1004,5,'149','Galewela'),(1005,5,'150','Manipay'),(1006,25,'008','Pettah'),(1007,5,'151','Akuressa'),(1008,25,'009','Mahabage'),(1009,5,'152','Hettipola'),(1010,25,'010','Battaramulla'),(1011,5,'153','Wariyapola'),(1012,25,'011','Dharmapala Mawatha'),(1013,5,'154','Athurugiriya'),(1014,25,'012','Kurunegala'),(1015,5,'155','Kochchikade'),(1016,25,'013','Maharagama'),(1017,5,'156','Malabe'),(1018,25,'014','Moratuwa'),(1019,5,'157','Chankanai'),(1020,25,'015','Borella'),(1021,5,'158','Pottuvil'),(1022,25,'016','Kiribathgoda'),(1023,5,'159','Ninthavur'),(1024,25,'017','Panadura'),(1025,5,'160','Beruwela'),(1026,25,'018','Gampaha'),(1027,5,'161','Velanai'),(1028,5,'162','Rikillagaskada'),(1029,25,'019','Kotahena'),(1030,5,'163','Yakkala'),(1031,5,'164','Thandenweli'),(1032,5,'165','Kaluwanchikudy'),(1033,25,'020','Ward Place'),(1034,5,'166','Pugoda'),(1035,25,'021','Kadawatha'),(1036,5,'167','Valachchenai'),(1037,25,'022','Crescat'),(1038,5,'168','Madampe'),(1039,25,'023','Dehiwala'),(1040,5,'169','Kinniya'),(1041,25,'024','Nawam Mawatha'),(1042,5,'170','Siyabalanduwa'),(1043,25,'025','Havelock Town'),(1044,25,'026','Peradeniya'),(1045,5,'171','Udappuwa'),(1046,5,'174','Mullipothanai'),(1047,25,'027','Nawala'),(1048,5,'175','Uppuvelli'),(1049,25,'028','Matara'),(1050,5,'176','Digana'),(1051,25,'029','Galle'),(1052,5,'177','Anamaduwa'),(1053,5,'178','Dikwella'),(1054,5,'179','Medirigiriya'),(1055,5,'180','Mirigama'),(1056,5,'181','Padavi Parakramapura'),(1057,5,'182','Uhana'),(1058,5,'183','Mullativu'),(1059,5,'184','Karaitive'),(1060,5,'185','Maruthamunai'),(1061,25,'030','Thalawathugoda'),(1062,5,'186','Serunuwara'),(1063,25,'031','Homagama'),(1064,5,'187','Pitigala'),(1065,5,'188','Kundasale'),(1066,25,'032','Bandarawela'),(1067,5,'189','Atchchuvely'),(1068,25,'033','Vavuniya'),(1069,5,'190','Kodikamam'),(1070,25,'034','Batticaloa'),(1071,5,'191','Muthur'),(1072,25,'035','Jaffna'),(1073,5,'192','Kallady'),(1074,25,'036','Horana'),(1075,5,'193','Aralaganwila'),(1076,25,'037','Kalmunai'),(1077,5,'194','Kolonnawa'),(1078,5,'195','Killinochchi North'),(1079,25,'038','Malabe'),(1080,25,'039','Anuradhapura'),(1081,25,'040','Piliyandala'),(1082,5,'196','Dehiattakandiya'),(1083,25,'041','Ratnapura'),(1084,5,'197','Kalawana'),(1085,5,'198','Galaha'),(1086,25,'042','Nuwara Eliya'),(1087,5,'199','Urubokka'),(1088,5,'200','Hakmana'),(1089,5,'201','Bandaragama'),(1090,25,'043','Chilaw'),(1091,5,'202','Hikkaduwa'),(1092,25,'044','Nelliady'),(1093,25,'045','Kaduruwela'),(1094,5,'203','Wadduwa'),(1095,25,'046','Pettah Second'),(1096,5,'204','Mirihana'),(1097,25,'047','Aluthgama'),(1098,5,'205','Mulliyawalai'),(1099,25,'048','Wennappuwa'),(1100,5,'206','Kurumankadu'),(1101,5,'207','Jampettah Street'),(1102,25,'049','Trincomalee'),(1103,5,'208','Ratmalana'),(1104,25,'055','Kuliyapitiya'),(1105,5,'209','Seeduwa'),(1106,25,'056','Ambalangoda'),(1107,5,'210','Pamunugama'),(1108,25,'057','Akkaraipattu'),(1109,5,'211','Kattankudy'),(1110,25,'058','Hambantota'),(1111,5,'212','Mallavi'),(1112,25,'059','Badulla'),(1113,5,'213','Weligama'),(1114,25,'060','Ja-Ela'),(1115,5,'214','Veyangoda'),(1116,25,'061','Embilipitiya'),(1117,5,'215','Batapola'),(1118,25,'062','Ambalantota'),(1119,25,'063','Akuressa'),(1120,5,'216','Yakkalamulla'),(1121,25,'064','Balangoda'),(1122,5,'217','Walasmulla'),(1123,25,'065','Deniyaya'),(1124,25,'066','Matugama'),(1125,5,'218','Gelioya'),(1126,25,'069','Katugastota'),(1127,5,'219','Jaffna'),(1128,25,'071','Old Moor Street'),(1129,5,'220','Passara'),(1130,25,'072','Bandaragama'),(1131,5,'221','Pamankada'),(1132,25,'400','Card Center'),(1133,5,'250','Islamic Banking Unit'),(1134,25,'500','Liberty Plaza'),(1135,25,'501','Wattala'),(1136,25,'502','Mount Lavinia'),(1137,9,'001','Duke Street'),(1138,25,'503','Nugegoda'),(1139,9,'002','Matale'),(1140,9,'003','Kandy'),(1141,25,'504','Kohuwala'),(1142,9,'004','International Division'),(1143,25,'999','Head Office'),(1144,9,'005','Polonnaruwa'),(1145,26,'000','Head Office'),(1146,9,'006','Hingurakgoda'),(1147,26,'001','Main Branch'),(1148,26,'999','Head Office'),(1149,9,'007','Hambantota'),(1150,9,'008','Anuradhapura'),(1151,9,'009','Puttalam'),(1152,9,'010','Badulla'),(1153,9,'011','Bibile'),(1154,9,'012','Kurunegala'),(1155,9,'013','Galle Fort'),(1156,9,'014','Union Place'),(1157,9,'015','Ampara'),(1158,9,'016','Welimada'),(1159,9,'017','Balangoda'),(1160,9,'018','Gampola'),(1161,9,'019','Dehiwala'),(1162,9,'020','Mulativu'),(1163,9,'021','Minuwangoda'),(1164,9,'022','Hanguranketha'),(1165,9,'023','Kalmunai'),(1166,9,'024','Chilaw'),(1167,9,'025','Hyde park Corner'),(1168,9,'026','Gampaha'),(1169,9,'027','Kegalle'),(1170,9,'028','Kuliyapitiya'),(1171,9,'029','Avissawella'),(1172,9,'031','Kankasanthurai'),(1173,9,'030','Jaffna Stanley Road'),(1174,9,'032','Matara Uyanwatta'),(1175,16,'000','Middle East Bank'),(1176,16,'001','Head Office'),(1177,9,'033','Queens'),(1178,16,'002','Pettah'),(1179,9,'034','Queens'),(1180,16,'003','Maradana'),(1181,9,'035','Ambalangoda'),(1182,9,'036','Ragala'),(1183,9,'037','Bandarawela'),(1184,16,'004','Islamic Banking Unit'),(1185,9,'038','Talawakele'),(1186,16,'005','Wellawatte'),(1187,9,'039','Kalutara'),(1188,16,'006','Kandy'),(1189,9,'040','Vavuniya'),(1190,16,'007','Batticaloa'),(1191,9,'041','Horana'),(1192,16,'008','Galle'),(1193,9,'042','Kekirawa'),(1194,16,'999','Head Office'),(1195,9,'043','Padaviya'),(1196,9,'044','Mannar'),(1197,9,'045','Embilipitiya'),(1198,9,'046','Mudalige Mawatha'),(1199,17,'000','Head Office'),(1200,17,'001','Head Office'),(1201,17,'999','Head Office'),(1202,9,'047','Yatiyantota'),(1203,18,'001','Head Office'),(1204,9,'048','Kilinochchi'),(1205,18,'999','Head Office'),(1206,9,'049','Homagama'),(1207,9,'051','Kahatagasdigiliya'),(1208,27,'001','Sri Lanka Branch'),(1209,9,'052','Maho'),(1210,9,'053','Nawalapitiya'),(1211,29,'002','Colombo'),(1212,9,'054','Warakapola'),(1213,9,'055','Kelaniya'),(1214,9,'056','Sri Sangaraja Mawatha'),(1215,32,'001','Head Office'),(1216,9,'057','Peradeniya'),(1217,9,'058','Mahiyangana'),(1218,37,'001','Head Office'),(1219,9,'059','Polgahawela'),(1220,9,'060','Morawaka'),(1221,37,'998','CBSL-VB'),(1222,9,'061','Tissamaharama'),(1223,9,'062','Wellawaya'),(1224,37,'999','Central Bank Of Sri Lanka'),(1225,9,'063','Akkaraipattu'),(1226,9,'064','Samanthurai'),(1227,9,'065','Kattankudy'),(1228,9,'066','Trincomalee'),(1229,9,'067','Tangalle'),(1230,9,'068','Monaragala'),(1231,9,'069','Mawanella'),(1232,9,'070','Mathugama'),(1233,9,'071','Dematagoda'),(1234,9,'072','Ambalantota'),(1235,9,'073','Elpitiya'),(1236,9,'074','Wattegama'),(1237,9,'075','Batticaloa'),(1238,9,'076','Wennappuwa'),(1239,9,'077','Weligama'),(1240,9,'078','Borella'),(1241,9,'079','Veyangoda'),(1243,9,'081','Ruwanwella'),(1244,9,'082','Narammala'),(1245,9,'083','Nattandiya'),(1246,9,'084','Aluthgama'),(1247,9,'085','Eheliyagoda'),(1248,9,'086','Thimbirigasyaya'),(1249,9,'087','Baddegama'),(1250,9,'088','Ratnapura'),(1251,9,'089','Katugastota'),(1252,9,'090','Kantale'),(1253,9,'091','Moratuwa'),(1254,9,'092','Giriulla'),(1255,9,'093','Pugoda'),(1256,9,'094','Kinniya'),(1257,9,'095','Muttur'),(1258,9,'096','Medawachchiya'),(1259,9,'097','Gangodawila'),(1260,9,'098','Kotikawatte'),(1261,9,'100','Marandagahamula'),(1262,9,'101','Rambukkana'),(1263,9,'102','Valaichechenai'),(1264,9,'103','Piliyandala'),(1265,9,'104','Jaffna Main Street'),(1266,9,'105','Kayts'),(1267,9,'106','Nelliady'),(1268,9,'107','Atchchuvely'),(1269,9,'108','Chankanai'),(1270,9,'109','Chunnakam'),(1271,9,'110','Chavakachcheri'),(1272,9,'111','Paranthan'),(1273,9,'112','Teldeniya'),(1274,9,'113','Batticaloa Town'),(1275,9,'114','Galagedera'),(1276,9,'115','Galewela'),(1277,9,'116','Passara'),(1278,9,'117','Akuressa'),(1279,9,'118','Delgoda'),(1280,9,'119','Narahenpita'),(1281,9,'120','Walasmulla'),(1282,9,'121','Bandaragama'),(1283,9,'122','Wilgamuwa'),(1284,9,'123','Eravur'),(1285,9,'124','Nikeweratiya'),(1286,9,'125','Kalpitiya'),(1287,9,'126','Grandpass'),(1288,9,'127','Nildandahinna.'),(1289,9,'128','Ratthota'),(1290,9,'129','Rakwana'),(1291,9,'130','Hakmana'),(1292,9,'131','Udugama'),(1293,9,'132','Deniyaya'),(1294,9,'133','Kamburupitiya'),(1295,9,'134','Nuwara Eliya'),(1296,9,'135','Dickwella'),(1297,9,'136','Hikkaduwa'),(1298,9,'137','Makandura'),(1299,9,'138','Dambulla'),(1300,9,'139','Pettah'),(1301,9,'140','Hasalaka'),(1302,9,'141','Velvetiturai'),(1303,9,'142','Kochchikade'),(1304,9,'143','Suduwella'),(1305,9,'144','Hettipola'),(1306,9,'145','Wellawatte'),(1307,9,'146','Naula'),(1308,9,'147','Buttala'),(1309,9,'148','Panadura'),(1310,9,'149','Alawwa'),(1311,9,'150','Kebithigollawa'),(1312,9,'151','Diyatalawa'),(1313,9,'152','Matara Dharmapala Mawatha'),(1314,9,'153','Akurana'),(1315,9,'154','Balapitiya'),(1316,9,'155','Kahawatte'),(1317,9,'156','Uva-Paranagama'),(1318,9,'157','Menikhinna'),(1319,9,'158','Senkadagala'),(1320,9,'159','Kadugannawa'),(1321,9,'160','Pelmadulla'),(1322,9,'161','Bulathsinhala'),(1323,9,'162','Jaffna University'),(1324,9,'163','Wariyapola'),(1325,9,'164','Potuvil'),(1326,9,'165','Mankulam'),(1327,9,'166','Murunkan'),(1328,9,'167','\'Town Hall, Colombo\''),(1329,9,'168','Kataragama'),(1330,9,'169','Galle Main Street'),(1331,9,'170','Eppawela'),(1332,9,'171','Nochchiyagama'),(1333,9,'172','Bingiriya'),(1334,9,'173','Pundaluoya'),(1335,9,'174','Nugegoda'),(1336,9,'175','Kandana'),(1337,9,'176','Mid City'),(1338,9,'177','Galenbindunuwewa'),(1339,9,'178','Maskeliya'),(1340,9,'179','Galnewa'),(1341,9,'180','Deraniyagala'),(1342,9,'181','Maha - Oya'),(1343,9,'183','Ankumbura'),(1344,9,'184','Galgamuwa'),(1345,9,'185','Galigamuwa'),(1346,9,'186','Hatton'),(1347,9,'188','Ahangama'),(1348,9,'189','Uhana'),(1349,9,'190','Kaluwanchikudy'),(1350,9,'191','Malwana'),(1351,9,'192','Nivitigala'),(1352,9,'193','Ridigama'),(1353,9,'194','Kolonnawa'),(1354,9,'195','Haldummulla'),(1355,9,'196','Kaduwela'),(1356,9,'197','Uragasmanhandiya'),(1357,9,'198','Mirigama'),(1358,9,'199','Mawathagama'),(1359,9,'200','Majestic City'),(1360,9,'201','Ukuwela'),(1361,9,'202','Kirindiwela'),(1362,9,'203','Habarana'),(1363,9,'204','Head Quarters'),(1364,9,'205','Angunakolapalessa'),(1365,9,'206','Davulagala'),(1366,9,'207','Ibbagamuwa'),(1367,9,'208','Battaramulla'),(1368,9,'209','Boralanda'),(1369,9,'210','Kollupitiya Co-op House'),(1370,9,'211','Panwila'),(1371,9,'214','Mutuwal'),(1372,9,'215','Madampe'),(1373,9,'216','Haputale'),(1374,9,'217','Mahara'),(1375,9,'218','Horowpathana'),(1376,9,'219','Tambuttegama'),(1377,9,'220','Anuradhapura-Nuwarawewa'),(1378,9,'221','Hemmathagama'),(1379,9,'222','Wattala'),(1380,9,'223','Karaitivu'),(1381,9,'224','Thirukkovil'),(1382,9,'225','Haliela'),(1383,9,'226','Kurunegala Maliyadeva'),(1384,9,'227','Chenkalady'),(1385,9,'228','Addalachchene'),(1386,9,'229','Hanwella'),(1387,9,'230','Tanamalwila'),(1388,9,'231','Medirigiriya'),(1389,9,'232','Polonnaruwa Town'),(1390,9,'233','Serunuwara'),(1391,9,'234','Batapola'),(1392,9,'235','Kalawana'),(1393,9,'236','Maradana'),(1394,9,'237','Kiribathgoda'),(1395,9,'238','Gonagaldeniya'),(1396,9,'239','Ja Ela'),(1397,9,'240','Keppetipola'),(1398,9,'241','Pallepola'),(1399,9,'242','Bakamuna'),(1400,9,'243','Devinuwara'),(1401,9,'244','Beliatta'),(1402,9,'245','Godakawela'),(1403,9,'246','Meegalewa'),(1404,9,'247','Imaduwa'),(1405,9,'248','Aranayake'),(1406,9,'249','Neboda'),(1407,9,'250','Kandeketiya'),(1408,9,'252','Bulathkohupitiya'),(1409,9,'251','Lunugala'),(1410,9,'253','Aralaganwila'),(1411,9,'254','Welikanda'),(1412,9,'255','Trincomalee Town'),(1413,9,'256','Pilimatalawa'),(1414,9,'257','Deltota'),(1415,9,'258','Medagama'),(1416,9,'259','Kehelwatte'),(1417,9,'260','Koslanda'),(1418,9,'261','Pelawatte'),(1419,9,'262','Wadduwa'),(1420,9,'263','Kuruwita'),(1421,9,'264','Suriyawewa'),(1422,9,'265','Middeniya'),(1423,9,'266','Kiriella'),(1424,9,'267','Anamaduwa'),(1425,9,'268','Girandurukotte'),(1426,9,'269','Badulla-Muthiyangana'),(1427,9,'270','Thulhiriya'),(1428,9,'271','Urubokka'),(1429,9,'272','Talgaswela'),(1430,9,'273','Kadawatha'),(1431,9,'274','Pussellawa'),(1432,9,'275','Olcott Mawatha'),(1433,9,'276','Katunayake'),(1434,9,'277','Sea Street'),(1435,9,'278','Nittambuwa'),(1436,9,'279','Pitakotte'),(1437,9,'280','Pothuhera'),(1438,9,'281','Kobeigane'),(1439,9,'282','Maggona'),(1440,9,'293','Baduraliya'),(1441,9,'284','Jaffna Kannathiddy'),(1442,9,'285','Point Pedro'),(1443,9,'288','Kudawella'),(1444,9,'289','Kaltota'),(1445,9,'290','Kaltota'),(1446,9,'291','Dankotuwa'),(1447,9,'292','Udapussellawa'),(1448,9,'293','Dehiowita'),(1449,9,'294','Alawathugoda'),(1450,9,'295','Udawalawe'),(1451,9,'296','Nintavur'),(1452,9,'297','Dam Street'),(1453,9,'298','Ginthupitiya'),(1454,9,'299','Kegalle Bazaar'),(1455,9,'300','Ingiriya'),(1456,9,'301','Galkiriyagama'),(1457,9,'302','Ginigathhena'),(1458,9,'303','Mahawewa'),(1459,9,'304','Walasgala'),(1460,9,'306','Maharagama'),(1461,9,'307','Gandara'),(1462,9,'308','Kotahena'),(1463,9,'309','Liberty Plaza'),(1464,9,'310','Bambalapitiya'),(1465,9,'311','Beruwala'),(1466,9,'312','Malwatta Road'),(1467,9,'313','Katubedda'),(1468,9,'315','Talawa'),(1469,9,'316','Ragama'),(1470,9,'317','Ratnapura Town'),(1471,9,'318','Pamunugama'),(1472,9,'319','Kirulapana'),(1473,9,'320','Borella Town'),(1474,9,'321','Panadura Town'),(1475,9,'322','Marawila'),(1476,9,'324','Seeduwa'),(1477,9,'325','Wanduramba'),(1478,9,'326','Capricon'),(1479,9,'327','Kesbewa'),(1480,9,'328','Kottawa'),(1481,9,'329','Koggala'),(1482,9,'330','Dehiattakandiya'),(1483,9,'331','Lucky Plaza'),(1484,9,'332','Ganemulla'),(1485,9,'333','Yakkala'),(1486,9,'334','Kurunegala-Ethugalpura'),(1487,9,'335','Nugegoda City'),(1488,9,'336','Mount Lavinia'),(1489,9,'337','Dehiwela (Galle Rd.)'),(1490,9,'338','Sainthamaruthu'),(1491,9,'339','Kallar'),(1492,9,'340','Oddamavady'),(1493,9,'341','Hataraliyadda'),(1494,9,'342','Kokkaddicholai'),(1495,9,'343','Karapitiya'),(1496,9,'344','Melsiripura'),(1497,9,'345','Ranna'),(1498,9,'346','Maruthamunai'),(1499,9,'347','Badalkubura'),(1500,9,'348','Boralesgamuwa'),(1501,9,'349','Pallebedda'),(1502,9,'350','Weeraketiya'),(1503,9,'351','Thambala'),(1504,9,'352','Pulmudai'),(1505,9,'353','Rikillagaskada'),(1506,9,'354','Bogawanthalawa'),(1507,9,'355','Kotiyakumbura'),(1508,9,'356','Cheddikulam'),(1509,9,'357','Kandy City Centre'),(1510,9,'358','Poojapitiya'),(1511,9,'600','Card Center'),(1512,9,'796','Overseas Customers Unit'),(1513,9,'999','CCD'),(1514,10,'000','Head Office'),(1515,10,'001','Navam Mawatha'),(1516,10,'002','Kandy'),(1517,10,'003','Jawatta'),(1518,10,'004','Nugegoda'),(1519,10,'005','Rajagiriya'),(1520,10,'006','Matara'),(1521,10,'007','Kurunegala'),(1522,10,'008','Wellawatte'),(1523,10,'009','Negombo'),(1524,10,'010','Chilaw'),(1525,10,'011','Wattala'),(1526,10,'012','Maharagama'),(1527,10,'013','Ratnapura'),(1528,10,'014','Head Office'),(1529,10,'015','Moratuwa'),(1530,10,'016','Kalutara'),(1531,10,'017','Kegalle'),(1532,10,'018','Badulla'),(1533,10,'019','Anuradhapura'),(1534,10,'020','Mount Lavinia'),(1535,10,'021','Galle'),(1536,10,'022','Pelawatte'),(1537,10,'023','Piliyandala'),(1538,10,'024','Kotahena'),(1539,10,'025','Kiribathgoda'),(1540,10,'026','Kadawatha'),(1541,10,'027','Horana'),(1542,10,'028','Kandana'),(1543,10,'029','Gampaha'),(1544,10,'030','Homagama'),(1545,10,'031','Malabe'),(1546,10,'032','Kohuwala'),(1547,10,'033','Puttalam'),(1548,10,'034','Awissawella'),(1549,10,'035','Panadura'),(1550,10,'036','Wennappuwa'),(1551,10,'037','Jaffna'),(1552,10,'038','Trincomalee'),(1553,10,'039','Batticaloa'),(1554,10,'040','Ampara'),(1555,10,'041','Vavuniya'),(1556,10,'042','Kuliyapitiya'),(1557,10,'043','Pettah'),(1558,10,'044','Ja Ela'),(1559,10,'045','Matugama'),(1560,10,'046','Matale'),(1561,10,'047','Wariyapola'),(1562,10,'048','Ambalangoda'),(1563,10,'049','Ambalantota'),(1564,10,'050','Pilimatalawa'),(1565,10,'051','Gampola'),(1566,10,'052','Bandarawela'),(1567,10,'053','Borella'),(1568,10,'054','kalmunai'),(1569,10,'055','Nittambuwa'),(1570,10,'056','Kaduwela'),(1571,10,'057','Hambantota'),(1572,10,'058','Embilipitiya'),(1573,10,'059','Aluthgama'),(1574,10,'060','Kaduruwela'),(1575,10,'061','Nawalapitiya'),(1576,10,'062','Chunnakam'),(1577,10,'063','Minuwangoda'),(1578,10,'064','Dambulla'),(1579,10,'065','Akuressa'),(1580,10,'066','Nelliady'),(1581,10,'067','Elpitiya'),(1582,10,'068','Yakkala'),(1583,10,'069','Nikaweratiya'),(1584,10,'070','Monaragala'),(1585,10,'071','Athurugiriya'),(1586,10,'072','Boralesgamuwa'),(1587,10,'073','Ratmalana'),(1588,10,'074','Narahenpita'),(1589,10,'075','Mahiyangana'),(1590,10,'076','Nuwara Eliya'),(1591,10,'078','Eheliyagoda'),(1592,10,'100','Head Office(Retail)'),(1593,10,'900','Head Office(Corporare)'),(1594,10,'999','Head Office'),(1595,7,'001','City Office'),(1596,7,'002','Pettah'),(1597,7,'003','Nugegoda'),(1598,7,'004','Borella'),(1599,7,'005','Kiribathgoda'),(1600,7,'006','Kurunegala'),(1601,7,'007','Kandy'),(1602,7,'008','Wattala'),(1603,7,'009','Nawam Mawatha'),(1604,7,'010','Matara'),(1605,7,'011','Bambalapitiya'),(1606,7,'012','Fort'),(1607,7,'013','Maharagama'),(1608,7,'014','Deniyaya'),(1609,7,'015','Morawaka'),(1610,7,'016','Gampaha'),(1611,7,'017','Dehiwala'),(1612,7,'018','Ratmalana'),(1613,7,'019','Piliyandala'),(1614,7,'020','Eheliyagoda'),(1615,7,'021','Anuradhapura'),(1616,7,'022','Avissawella'),(1617,7,'023','Kuliyapitiya'),(1618,7,'024','Negombo'),(1619,7,'025','Matale'),(1620,7,'026','Panadura'),(1621,7,'027','Old Moor Street'),(1622,7,'028','Tissamaharama'),(1623,7,'029','Corporate'),(1624,7,'030','Wennappuwa'),(1625,7,'031','Moratuwa'),(1626,7,'032','Katugastota'),(1627,7,'033','Rathnapura'),(1628,7,'034','Thimbirigasyaya'),(1629,7,'035','Galle'),(1630,7,'036','Wellawatte Super'),(1631,7,'037','Kotahena'),(1632,7,'038','Kaduruwela'),(1633,7,'039','Malabe'),(1634,7,'040','Narahenpita'),(1635,7,'041','Kalawana'),(1636,7,'042','Main Street'),(1637,7,'043','Embilipitiya'),(1638,7,'044','Wariyapola (PBC)'),(1639,7,'045','Wellampitiya (PBC)'),(1640,7,'046','Bandarawela'),(1641,7,'047','Panadura Wekada'),(1642,7,'048','Thambuttegama (PBC)'),(1643,7,'049','Deraniyagala PBC'),(1644,7,'050','Kalutara'),(1645,7,'051','Peradeniya PBC'),(1646,7,'052','Kottawa PBC'),(1647,7,'053','Alawwa PBC'),(1648,7,'054','Neluwa PBC'),(1649,7,'055','Vavunia'),(1650,7,'056','Mahiyanganaya'),(1651,7,'057','Horana'),(1652,7,'058','Harbour-View PBC'),(1653,7,'059','Bandaragama'),(1654,7,'060','Kadawatha'),(1655,7,'061','Battaramulla'),(1656,7,'062','Ampara'),(1657,7,'063','Pelawatte PBC'),(1658,7,'064','Kegall'),(1659,7,'065','Minuwangoda'),(1660,7,'066','Trincomalee'),(1661,7,'067','Athurugiriya PBC'),(1662,7,'068','Yakkala PBC'),(1663,7,'069','Homagama'),(1664,7,'070','Gregorys Road PBC'),(1665,7,'071','Nittambuwa'),(1666,7,'072','Ambalongoda'),(1667,7,'073','Ragama PBC'),(1668,7,'074','Monaragala'),(1669,7,'075','Wadduwa PBC'),(1670,7,'076','Kandana'),(1671,7,'077','veyangoda PBC'),(1672,7,'078','Ganemulla PBC'),(1673,7,'079','Aluthgama'),(1674,7,'080','Hatton'),(1675,7,'081','Welimada'),(1676,7,'082','Nawala'),(1677,7,'083','Kirindiwela PBC'),(1678,7,'084','Nuwara Eliya'),(1679,7,'085','Digana PBC'),(1680,7,'086','Mirigama'),(1681,7,'087','Kottawa Laugfs Sun Up'),(1682,7,'088','Negombo 2nd'),(1683,7,'089','Attidiya'),(1684,7,'090','Dambulla'),(1685,7,'091','Pitakotte'),(1686,7,'092','Singer Mega-Maharagama'),(1687,7,'093','Badulla'),(1688,7,'094','Kohuwela'),(1689,7,'095','Giriulla'),(1690,7,'096','Hendala'),(1691,7,'097','Balangoda'),(1692,7,'098','Ja-Ela'),(1693,7,'099','Narammala'),(1694,7,'100','Kandy Metro'),(1695,7,'101','Gampola'),(1696,7,'102','Nikaweratiya'),(1697,7,'103','Pelmadulla'),(1698,7,'104','Ambalantota'),(1699,7,'105','Wattegama'),(1700,7,'106','Matugama'),(1701,7,'107','Batticaloa'),(1702,7,'108','Chilaw'),(1703,7,'109','Mawathagama'),(1704,7,'110','Hingurakgoda'),(1705,7,'111','Akkaraipattu'),(1706,7,'112','Kalmunai'),(1707,7,'113','Wellawaya'),(1708,7,'114','Embuldeniya'),(1709,7,'115','Kattankudy'),(1710,7,'116','Tangalle'),(1711,7,'117','Kirulapone'),(1712,7,'118','Baddegama'),(1713,7,'119','Mannar'),(1714,7,'120','Jaffna'),(1715,7,'121','Chenkalady'),(1716,7,'122','Rajagiriya'),(1717,7,'123','Kandy City Centre'),(1718,7,'124','Oddamavady'),(1719,7,'125','Kaluwanchikudy'),(1720,7,'126','Sainthamaruthu'),(1721,7,'127','Grandpass'),(1722,7,'128','Chunnakam'),(1723,7,'129','Nelliady'),(1724,7,'130','Pottuvil'),(1725,7,'131','Platinum Plus'),(1726,7,'132','Nattandiya'),(1727,7,'133','Kundasale'),(1728,7,'134','Kollupitiya'),(1729,7,'135','Gangodawila'),(1730,7,'136','Peliyagoda'),(1731,7,'137','Hanwella'),(1732,7,'139','2nd Branch Batticaloa'),(1733,7,'140','Ingiriya'),(1734,7,'141','Karapitiya'),(1735,7,'142','Boralesgamuwa'),(1736,7,'143','Anamabuwa'),(1737,7,'144','Maradana'),(1738,7,'145','Buttala'),(1739,7,'146','Passara'),(1740,7,'147','Manipay'),(1741,7,'148','Kilinochchi'),(1742,7,'149','Kekirawa'),(1743,7,'150','Pilimatalawa'),(1744,7,'151','Keselwatta'),(1745,7,'152','Pussellawa'),(1746,7,'153','Matara Bazaar'),(1747,7,'154','Aralangawila'),(1748,7,'155','Moratumulla'),(1749,7,'156','Puttalam'),(1750,7,'157','Sooriyawewa'),(1751,7,'158','Middeniya'),(1752,7,'159','Galle Bazaar'),(1753,7,'160','Mawanella'),(1754,7,'161','Bibile'),(1755,7,'162','Kaduwela'),(1756,7,'163','Rikillagaskada'),(1757,7,'164','Chankanai'),(1758,7,'165','Kochchikade'),(1759,7,'166','Pannala'),(1760,7,'167','Dehiattakandiya'),(1761,7,'168','Anuradhapura New Town'),(1762,7,'169','Chavakachcheri'),(1763,7,'170','Vavuniya Super'),(1764,7,'171','Kayts'),(1765,7,'172','Kantale'),(1766,7,'173','Gothatuwa New Town'),(1767,7,'174','Mallavi'),(1768,7,'175','Colombo Super'),(1769,7,'176','Mattegoda'),(1770,7,'177','Kinniya'),(1771,7,'178','Thalawathugoda'),(1772,7,'179','Akuressa'),(1773,7,'180','Beliatta'),(1774,7,'181','Habaraduwa'),(1775,7,'182','Ahangama'),(1776,7,'183','Marandagahamula'),(1777,7,'184','Menikhinna'),(1778,7,'185','Ninthavur'),(1779,7,'186','Thirunelvely'),(1780,7,'187','Hettipola'),(1781,7,'188','Rambukkana'),(1782,7,'189','Madampe'),(1783,7,'190','Galewela'),(1784,7,'191','Maligawatte'),(1785,7,'192','Padukka'),(1786,7,'193','Mutwal'),(1787,7,'194','Marawila'),(1788,7,'195','Nawalapitiya'),(1789,7,'196','Dankotuwa'),(1790,7,'197','Maho'),(1791,7,'198','Divulapitiya'),(1792,7,'199','Mount Lavinia'),(1793,7,'200','Kiribathgoda'),(1794,7,'201','Ruwanwella'),(1795,7,'202','Delgoda'),(1796,7,'203','Kahatagasdigiliya'),(1797,7,'204','Elpitiya'),(1798,7,'205','Warakapola'),(1799,7,'206','Kaburupitiya'),(1800,7,'207','Makola'),(1801,7,'208','Muttur'),(1802,7,'209','Weligama'),(1803,7,'210','Karagampitiya'),(1804,7,'929','Sampath Viswa'),(1805,7,'993','Central Clearing Department'),(1806,7,'996','Card Centre'),(1807,7,'999','Head Office'),(1808,6,'000','Seylan Bank Head Office'),(1809,6,'001','City Office'),(1810,6,'002','Matara'),(1811,6,'003','Mount Lavinia'),(1812,6,'004','Maharagama'),(1813,6,'005','Panadura'),(1814,6,'006','Kiribathgoda'),(1815,6,'007','Ratnapura'),(1816,6,'008','Kollupitiya'),(1817,6,'009','Moratuwa'),(1818,6,'010','Kegalle'),(1819,6,'011','Gampaha'),(1820,7,'012','Nugegoda'),(1821,6,'013','Negombo'),(1822,6,'014','Dehiwala'),(1823,6,'015','Chilaw'),(1824,6,'016','Galle'),(1825,6,'017','Kandy'),(1826,6,'018','Kurunegala'),(1827,6,'019','Nuwara Eliya'),(1828,6,'020','Balangoda'),(1829,6,'021','Anuradhapura'),(1830,6,'022','Grandpass'),(1831,6,'023','Horana'),(1832,6,'024','Ambalangoda'),(1833,6,'025','Gampola'),(1834,6,'026','Badulla'),(1835,6,'027','Ja-Ela'),(1836,6,'028','Kadawatha'),(1837,6,'029','Dehiattakandiya'),(1838,6,'030','Colombo Fort'),(1839,6,'031','Katunayaka'),(1840,6,'032','Cinnamon Gardens'),(1841,6,'033','Kottawa'),(1842,6,'034','Boralesgamuwa'),(1843,6,'035','Yakkala'),(1844,6,'036','Kalutara'),(1845,6,'037','Tissamaharama'),(1846,6,'038','Matale'),(1847,6,'039','Hatton'),(1848,6,'040','Sarikkamulla'),(1849,6,'041','Attidiya'),(1850,6,'042','Kalubowila'),(1851,6,'043','Homagama'),(1852,6,'044','Kuliyapitiya'),(1853,6,'045','Embilipitiya'),(1854,6,'046','Bandarawela'),(1855,6,'047','Maradana'),(1856,6,'048','Mawanella'),(1857,6,'049','Puttalam'),(1858,6,'050','Old Moor Street'),(1859,6,'051','Hingurakgoda'),(1860,6,'052','Nawala'),(1861,6,'053','Manampitiya'),(1862,6,'054','Bandaragama'),(1863,6,'055','Katuneriya'),(1864,6,'056','Koggala'),(1865,6,'057','Welimada'),(1866,6,'058','Kochchikade'),(1867,6,'059','Bogawanthalawa'),(1868,6,'060','Ganemulla'),(1869,6,'061','Kotagala Talawakale'),(1870,6,'062','Raddolugama'),(1871,6,'063','Weliveriya'),(1872,6,'064','Pettah'),(1873,6,'065','Beliatta'),(1874,6,'066','Mathugama'),(1875,6,'067','Malabe'),(1876,6,'068','Colombo South'),(1877,6,'069','Dam Street'),(1878,6,'070','Warakapola'),(1879,6,'071','Wattala'),(1880,6,'072','Vavuniya'),(1881,6,'073','Batticaloa'),(1882,6,'074','Kaththankudy'),(1883,6,'075','Awissawella'),(1884,6,'076','Nawalapitiya'),(1885,6,'077','Kekirawa'),(1886,6,'078','Mirigama'),(1887,6,'079','Soysapura'),(1888,6,'080','Kotiyakumbura'),(1889,6,'081','Hambantota'),(1890,6,'082','Borella'),(1891,6,'083','Havelock Town'),(1892,6,'084','Marandagahamula'),(1893,6,'085','Jaffna'),(1894,6,'086','Millenium'),(1895,6,'087','Ranpokunugama'),(1896,6,'088','Trincomalee'),(1897,6,'089','Meegoda'),(1898,6,'090','Pelmadulla.'),(1899,6,'091','Ampara'),(1900,6,'092','Nelliady'),(1901,6,'093','Kilinochchi'),(1902,6,'094','Mannar'),(1903,6,'095','Chavakachcheri'),(1904,6,'096','Mullativu'),(1905,6,'097','Kalmunai'),(1906,6,'098','Chenkalady'),(1907,6,'099','Piliyandala'),(1908,6,'100','Akuressa'),(1909,6,'101','Battaramulla'),(1910,6,'102','Kaduruwela'),(1911,6,'103','Dambulla'),(1912,6,'104','Monaragala'),(1913,6,'105','Ambalantota'),(1914,6,'106','Narammala'),(1915,6,'107','Mahiyanganaya'),(1916,6,'108','Veyangoda'),(1917,6,'109','Mawathagama'),(1918,6,'110','Pussellawa'),(1919,6,'111','Dummalasooriya'),(1920,6,'112','Godagama'),(1921,6,'113','Galenbidunuwewa'),(1922,6,'114','Pitakotte'),(1923,6,'115','Kanthale'),(1924,6,'116','Akkaraipatthu'),(1925,6,'117','Chankanai'),(1926,6,'996','Central Processing Unit'),(1927,6,'997','Seylan Card Centre (SCC)'),(1928,6,'998','Retail Remittance Center'),(1929,6,'999','Head Office'),(1930,19,'001','Metro'),(1931,19,'002','Panchikawatte'),(1932,19,'003','Kollupitiya'),(1933,19,'004','Pettah'),(1934,19,'005','Kandy'),(1935,19,'006','Rajagiriya'),(1936,19,'007','Ratnapura'),(1937,19,'008','Nugegoda'),(1938,19,'009','Bambalapitiya'),(1939,19,'010','Negombo'),(1940,19,'011','Gampaha'),(1941,19,'012','Gampaha'),(1942,19,'013','Matara'),(1943,19,'014','Kotahena'),(1944,19,'015','Dehiwela'),(1945,19,'016','Wattala'),(1946,19,'017','Panadura'),(1947,19,'018','Old Moor Street'),(1948,19,'019','Dam Street'),(1949,19,'020','Katugastota'),(1950,19,'021','Narahenpita'),(1951,19,'022','Kirulapana'),(1952,19,'023','Maharagama'),(1953,19,'024','Moratuwa'),(1954,19,'025','Galle'),(1955,19,'026','Kadawatha'),(1956,19,'027','Kegalle'),(1957,19,'028','Wennappuwa'),(1958,19,'029','Wellawatta'),(1959,19,'030','Gampola'),(1960,19,'032','Anuradhapura'),(1961,19,'033','Kalutara'),(1962,19,'034','Vavuniya'),(1963,19,'035','Malabe'),(1964,19,'036','Chilaw'),(1965,19,'037','Jaffna'),(1966,19,'038','Embilipitiya'),(1967,19,'039','Matale'),(1968,19,'040','Batticaloa'),(1969,19,'041','Ambalangoda'),(1970,19,'042','Kalmunai'),(1971,19,'043','Kilinochchi'),(1972,19,'044','Kandy City Centre'),(1973,19,'045','Badulla'),(1974,19,'046','Kuliyapitiya'),(1975,19,'047','Kalubowila'),(1976,19,'048','Bandarawela'),(1977,19,'049','Dambulla'),(1978,19,'050','Ratmalana'),(1979,19,'051','Peradeniya'),(1980,19,'052','Kaduruwela'),(1981,19,'053','Ambalanthota'),(1982,19,'054','Kiribathgoda'),(1983,19,'055','Piliyandala'),(1984,19,'056','Nelliady'),(1985,19,'057','Kanthankudy'),(1986,19,'058','Kundasale'),(1987,19,'059','Monaragala'),(1988,19,'060','Akkaraipaththu'),(1989,19,'061','Chunnakam'),(1990,19,'062','Balangoda'),(1991,19,'063','Battaramulla'),(1992,19,'064','Puttalama'),(1993,19,'065','Pilimathalawa'),(1994,19,'066','Ja-Ela'),(1995,19,'067','Kekirawa'),(1996,19,'068','Thalawathugoda'),(1997,19,'069','Minuwangoda'),(1998,19,'070','Warakapola'),(1999,19,'071','Galewela'),(2000,19,'072','Akuressa'),(2001,19,'073','Trincomalee'),(2002,19,'074','Tangalle'),(2003,19,'075','Hatton'),(2004,19,'076','Homagama'),(2005,19,'077','Horana'),(2006,19,'999','Head Office'),(2007,28,'001','Head Office'),(2008,28,'002','Nugegoda'),(2009,28,'003','Malabe'),(2010,28,'004','Matara'),(2011,28,'005','Kurunegala'),(2012,28,'006','Katugastota'),(2013,28,'007','City Office'),(2014,28,'008','Rathnapura'),(2015,28,'009','Anuradhapura'),(2016,28,'010','Gampaha'),(2017,28,'011','Badulla'),(2018,28,'012','Borella'),(2019,28,'014','Kaduruwela'),(2020,28,'015','Bandaranayake Mawatha'),(2021,28,'016','Maharagama'),(2022,28,'017','Bandarawela'),(2023,28,'018','Negambo'),(2024,28,'019','Kottawa'),(2025,28,'020','Dambulla'),(2026,28,'021','Wattala'),(2027,28,'022','Kuliyapitiya'),(2028,28,'023','Panadura'),(2029,28,'024','Piliyandala'),(2030,28,'025','Deniyaya'),(2031,28,'026','Kaluthara'),(2032,28,'027','Kiribathgoda'),(2033,28,'028','Nawala'),(2034,28,'029','Kadawatha'),(2035,28,'030','Gampola'),(2036,28,'031','Matale'),(2037,28,'032','Chilaw'),(2038,28,'033','Wellawatte'),(2039,28,'034','Horana'),(2040,28,'035','Galle'),(2041,28,'036','Nuwara Eliya'),(2042,28,'037','Kalawana'),(2043,28,'038','Ambalangoda'),(2044,28,'039','Avissawella'),(2045,28,'040','Batticaloa'),(2046,28,'041','Ampara'),(2047,28,'042','Jaffna'),(2048,28,'043','Moratuwa'),(2050,28,'044','Trincomalee'),(2051,28,'045','Embilipitiya'),(2052,28,'046','Pettah'),(2053,28,'047','Vavuniya'),(2054,28,'048','Katugastota'),(2055,28,'049','Kegalle'),(2056,28,'050','Monaragala'),(2057,28,'051','Sainthamaruthu'),(2058,28,'052','Kilinochchi'),(2059,28,'053','Elpitiya'),(2060,28,'054','Akuressa'),(2061,28,'055','Kattankudy'),(2062,28,'056','Tangalle'),(2063,28,'057','Oddamavadi'),(2064,28,'058','Akkaraipattu'),(2065,28,'059','Chunnakam'),(2066,28,'060','Manipai'),(2067,28,'061','Nelliady'),(2068,28,'062','Hambantota'),(2069,28,'063','Ja Ela'),(2070,28,'064','Kotahena'),(2071,28,'065','Digana'),(2072,28,'066','Thambuttegama'),(2073,28,'067','Galewela'),(2074,28,'501','Southern Province SLP Units'),(2075,28,'511','Western  Province SLP Units'),(2076,28,'521','North Western Province SLP Units'),(2077,28,'531','Central Province SLP Units'),(2078,28,'541','Sabaragamuwa Province SLP Units'),(2079,28,'551','North Central  Province SLP Units'),(2080,28,'561','Eastern  Province SLP Units'),(2081,28,'571','Uva Province SLP Units'),(2082,28,'700','Premier Banking Centre'),(2083,28,'999','Head Office'),(2084,20,'001','Head Office'),(2085,20,'002','Pettah'),(2086,20,'003','Kandy'),(2087,20,'004','Kattankudy'),(2088,20,'005','Ladies'),(2089,20,'006','Kalmunai'),(2090,20,'008','Galle'),(2091,20,'009','Oddamavadi'),(2092,20,'010','Akurana'),(2093,20,'011','Gampola'),(2094,20,'012','Sammanthurai'),(2095,20,'013','Mawanella'),(2096,20,'014','Kurunegala'),(2097,20,'015','Akkaraipattu'),(2098,20,'016','Dehiwela'),(2099,20,'017','Nintavur'),(2100,20,'018','Kuliyapitiya'),(2101,20,'019','Eravur'),(2102,20,'020','Negombo'),(2103,20,'021','Badulla'),(2104,20,'022','Kaduruwela'),(2105,20,'023','Puttalam'),(2106,20,'024','Kinniya'),(2107,20,'025','Ratnapura'),(2108,30,'001','Head Office'),(2109,30,'002','City'),(2110,30,'003','Galle'),(2111,30,'004','Matara'),(2112,30,'005','Anuradhapura'),(2113,30,'006','Jaffna'),(2114,30,'007','Chilaw'),(2115,30,'008','Kuliyapitiya'),(2116,30,'009','Negombo'),(2117,30,'010','Ratnapura'),(2118,30,'011','Ambalantota'),(2119,30,'012','Kalutara'),(2120,30,'013','Embilipitiya'),(2121,30,'014','Kekirawa'),(2122,30,'015','Kandy'),(2123,30,'016','Matale'),(2124,30,'017','kurunegala'),(2125,30,'018','Kegalle'),(2126,30,'019','Kilinochchi'),(2127,30,'020','Moratuwa'),(2128,30,'021','Batticaloa'),(2129,30,'022','Badulla'),(2130,30,'023','Bambalapitiya'),(2131,30,'024','Dehiwala'),(2132,30,'025','Peliyagoda'),(2133,31,'001','1st Colombo City'),(2134,31,'002','Kegalle'),(2135,30,'026','Nugegoda'),(2136,31,'003','Battaramulla'),(2137,30,'027','Homagama'),(2138,31,'004','Embilipitiya'),(2139,30,'028','Beruwala'),(2140,31,'005','Horana'),(2141,30,'029','Wennappuwa'),(2142,31,'006','Kiribathgoda'),(2143,30,'030','Ampara'),(2144,31,'007','Karapitiya'),(2145,30,'031','Kochchikade'),(2146,30,'032','Point Pedro'),(2147,31,'008','Akurassa'),(2148,30,'033','Ambalangoda'),(2149,31,'009','Matale'),(2150,30,'034','Naththandiya'),(2151,30,'035','Ruwanwella'),(2152,31,'010','Kandy'),(2153,30,'036','Ja-Ela'),(2154,30,'037','Gampaha'),(2155,30,'039','Devinuwara'),(2156,30,'040','Nikaweratiya'),(2157,30,'041','Mahiyanganaya'),(2158,30,'042','Warakapola'),(2159,30,'043','Panadura'),(2160,30,'044','Puttalama'),(2161,30,'045','Matugama'),(2162,31,'011','Chilaw'),(2163,30,'046','Monaragala'),(2164,31,'012','Vavuniya'),(2165,30,'047','Kalmunai'),(2166,31,'013','Manaragala'),(2167,30,'048','Beliatta'),(2168,30,'049','Mannar'),(2169,31,'014','Ruwanwella'),(2170,30,'050','Nawalapitiya'),(2171,31,'015','Rathnapura'),(2172,30,'051','Pettah'),(2173,31,'016','Warakapola'),(2174,30,'052','Katunayake'),(2175,30,'053','Maharagama'),(2176,31,'017','Anuradhapura'),(2177,30,'054','Deniyaya'),(2178,31,'018','Sahasapura'),(2179,30,'055','Akuressa'),(2180,31,'019','Rikillagaskada'),(2181,30,'056','Nuwara Eliya'),(2182,31,'020','Kurunegala'),(2183,30,'057','Avissawella'),(2184,31,'021','Trincomalle'),(2185,30,'058','Galnewa'),(2186,31,'022','Kalmuani'),(2187,30,'059','Mawanella'),(2188,30,'060','Bandarawela'),(2189,31,'023','Ambalanthota'),(2190,30,'061','Borella'),(2191,31,'025','Kalutara'),(2192,30,'062','Hakmana'),(2193,31,'026','Kuliyapitiya'),(2194,30,'063','Horana'),(2195,31,'027','Negombo'),(2196,30,'064','Narahenpita'),(2197,31,'028','Polonnaruwa'),(2198,30,'065','Kollupitiya 2nd'),(2199,30,'066','Weligama'),(2200,31,'029','Batticaloa'),(2201,31,'030','Ambalangoda'),(2202,30,'067','Kiribathgoda'),(2203,31,'031','Matara'),(2204,30,'068','Mount Lavinia'),(2205,30,'069','Marawila'),(2206,31,'032','Galle'),(2207,30,'070','Wellawatta'),(2208,31,'033','Giriulla'),(2209,30,'071','Piliyandala'),(2210,31,'034','Rambukkana'),(2211,30,'072','Chunnakam'),(2212,31,'035','Dambulla'),(2213,30,'073','Chavakachcheri'),(2214,30,'074','Gampola'),(2215,31,'036','Thambuththegama'),(2216,30,'075','Kadawatha'),(2217,31,'037','Maho'),(2218,31,'038','Wennappuwa'),(2219,30,'076','Hingurakgoda'),(2220,30,'077','Maligawatta'),(2221,30,'078','Thalawakele'),(2222,31,'039','Ampara'),(2223,28,'079','Mirigama'),(2224,31,'040','Medawachchiya'),(2225,30,'080','Battaramulla'),(2226,30,'081','Kandy 2nd'),(2227,30,'082','Dickwella'),(2228,30,'083','Mahabage'),(2229,30,'084','Pilimathalawa'),(2230,30,'085','Wattala'),(2231,30,'086','Kamburupitiya'),(2232,30,'087','Kotahena'),(2233,30,'088','Vavuniya'),(2234,30,'089','Trincomalee'),(2235,30,'090','Morawaka'),(2236,30,'091','Balangoda'),(2237,30,'092','Veyangoda'),(2238,30,'093','Katubedda'),(2239,30,'094','Elpitiya'),(2240,30,'095','Kaduwela'),(2241,30,'096','Divulapitiya'),(2242,30,'097','Tissamaharama'),(2243,30,'098','Minuwangoda'),(2244,30,'099','Kirindiwela'),(2245,30,'100','Nittambuwa'),(2246,30,'101','Welimada'),(2247,30,'102','Kottawa'),(2248,30,'103','Dambulla'),(2249,30,'104','Kahathuduwa'),(2250,30,'105','Aluthgama'),(2251,30,'106','Meegoda'),(2252,30,'107','Manipay'),(2253,30,'108','Thirunelvely'),(2254,30,'109','Chenkaladi'),(2255,30,'110','Uragasmanhandiya'),(2256,30,'111','Nawala'),(2257,30,'112','Deraniyagala'),(2258,30,'113','Hikkaduwa'),(2259,30,'114','Kalawanchikudy'),(2260,30,'115','Kalubowila'),(2261,30,'116','Hatton'),(2262,30,'117','Welikada'),(2263,30,'118','Samanthurai'),(2264,30,'119','Delkanda'),(2265,30,'120','Yakkala'),(2266,30,'121','Karapitiya'),(2267,30,'122','Kaduruwela'),(2268,30,'123','Malabe'),(2269,30,'124','Boralesgamuwa'),(2270,30,'125','Moratumulla'),(2271,30,'126','Bandaragama'),(2272,30,'127','Mulgampola'),(2273,30,'701','Ragama Piyasa'),(2274,30,'702','WTC Piyasa'),(2275,30,'703','Athurugiriya Piyasa'),(2276,30,'704','Neluwa Piyasa'),(2277,30,'705','Ganemulla Piyasa'),(2278,30,'706','Wellampitiya Piyasa'),(2279,30,'707','Narammala Piyasa'),(2280,30,'708','\'Bibile\"piyasa\"\''),(2281,30,'709','Hettipola'),(2282,30,'710','Bulathkohupitiya'),(2283,30,'711','Kandy City Center'),(2284,30,'712','Weeraketiya NSB Piyasa'),(2285,30,'713','Tangalle NSB Piyasa'),(2286,30,'714','Walasmulla NSB Piyasa'),(2287,30,'715','Wadduwa NSB Piyasa'),(2288,30,'716','Kelaniya NSB Piyasa'),(2289,30,'717','Nelliady NSB Piyasa'),(2290,30,'718','Atchuvely NSB Piyasa'),(2291,30,'719','Puwakaramba Piyasa'),(2292,30,'720','Valaichenai Piyasa'),(2293,30,'721','Aranayake Piyasa'),(2294,30,'722','Rikillagaskada Piyasa'),(2295,30,'723','Katugastota Piyasa'),(2296,30,'724','Middeniya Piyasa'),(2297,30,'725','Chankanai Piyasa'),(2298,30,'726','Polgahawela'),(2299,30,'727','Arayampathy'),(2300,30,'728','Raddolugama'),(2301,29,'729','Galgamuwa'),(2302,30,'730','Kayts'),(2303,30,'731','Karainagar'),(2304,30,'732','Mutwal'),(2305,30,'733','Mulleriyawa New Town'),(2306,30,'734','Baddegama'),(2307,30,'735','Habaraduwa'),(2308,30,'736','Pelmadulla'),(2309,30,'737','Kahawatte'),(2310,30,'738','Bulathsinhala'),(2311,30,'739','Kalawana'),(2312,30,'740','Wellawaya'),(2313,30,'741','Buttala'),(2314,30,'742','Alawwa'),(2315,30,'743','Yatiyantota'),(2316,30,'744','Pundaluoya'),(2317,30,'745','Nochchiyagama'),(2318,30,'746','Anamaduwa'),(2319,30,'747','Delgoda'),(2320,30,'748','Digana'),(2321,30,'749','Mawathagama'),(2322,30,'750','Hanwella'),(2323,30,'751','Hali Ela'),(2324,30,'752','Akkaraipattu'),(2325,30,'753','Palugamam'),(2326,30,'754','Sooriyawewa'),(2327,30,'755','Galewela'),(2328,30,'756','Tambuttegama'),(2329,30,'757','Imaduwa'),(2330,30,'758','Passara'),(2331,30,'759','Kahatagasdigiliya'),(2332,30,'760','Angunakolapelessa'),(2333,30,'761','Madampe'),(2334,30,'762','Kantale'),(2335,30,'763','Medawachchiya'),(2336,30,'764','Ingiriya'),(2337,30,'765','Rambukkana'),(2338,30,'766','Wariyapola'),(2339,30,'767','Kebithigollawa'),(2340,30,'768','Wattegama'),(2341,30,'769','Pussellawa'),(2342,30,'770','Pothuvil'),(2343,30,'771','Ibbagamuwa'),(2344,30,'772','Kuruwita'),(2345,30,'773','Vankalai'),(2346,30,'774','Mallavi'),(2347,30,'775','Kekanadura'),(2348,30,'776','Medirigiriya'),(2349,30,'777','Nivithigala'),(2350,30,'778','Kiriella'),(2351,30,'779','Naula'),(2352,30,'780','Melsiripura'),(2353,30,'781','Hambantota'),(2354,30,'782','Rideegama'),(2355,30,'783','Deltota'),(2356,30,'784','Ginigathhena'),(2357,30,'785','Bingiriya'),(2358,30,'786','Baduraliya'),(2359,30,'787','Giriulla'),(2360,30,'788','Eppawala'),(2361,30,'789','Thalawathugoda'),(2362,30,'790','Pugoda'),(2363,30,'791','Gelioya'),(2364,30,'901','PBU - Head Office'),(2365,30,'902','PBU - Kandy'),(2366,30,'903','PBU - Galle'),(2367,30,'904','PBU - Matara'),(2368,30,'905','PBU - Kegalle'),(2369,30,'906','PBU - Anuradhapura'),(2370,30,'907','PBU - Kalutara'),(2371,30,'908','PBU - Gampaha'),(2372,30,'909','PBU - Ampara'),(2373,30,'910','\'Credit Division, (H.L Division)\''),(2374,30,'911','IBU (NRFC)'),(2375,30,'912','Br. Management Division'),(2376,30,'915','PBU - Kurunegala'),(2377,30,'916','PBU - Jaffna'),(2378,30,'917','PBU - Eheliyagoda'),(2379,31,'041','Muthur'),(2380,31,'042','Jaffna'),(2381,31,'043','Nanatan'),(2382,31,'044','Badulla'),(2383,31,'045','Pottuvil'),(2384,31,'046','Mapalagama'),(2385,31,'047','Mathugama'),(2386,30,'048','Gampola'),(2387,31,'049','Deniyaya'),(2388,30,'050','Anamaduwa'),(2389,31,'051','Angunakolapalassa'),(2390,31,'052','Aralaganvila'),(2391,31,'053','Galenbidunuwewa'),(2392,31,'054','Wariyapola'),(2393,31,'055','Pilimathalawa'),(2394,31,'056','Kirulapona'),(2395,31,'057','Deraniyagala'),(2396,31,'058','Dehiattakandiya'),(2397,31,'059','Kalawanchikudi'),(2398,31,'060','Samanthurei'),(2399,31,'061','Siyabalanduwa'),(2400,31,'062','Buttala'),(2401,31,'064','Elpitiya'),(2402,31,'063','Valachchena'),(2403,31,'065','Nochchiyagama'),(2404,31,'066','Yakkalamulla'),(2405,31,'067','Katuwana'),(2406,31,'068','Mawanella'),(2407,31,'069','Kilinochchi'),(2408,31,'070','Padavi Parakramapura'),(2409,31,'071','Kekirawa'),(2410,31,'072','Uhana'),(2411,31,'073','Kanthale'),(2412,31,'074','Akkeripattu'),(2413,31,'075','Moratuwa'),(2414,31,'076','Hatharaliyadda'),(2415,31,'077','Hingurna'),(2416,31,'078','Kaduwela'),(2417,31,'079','Narammala'),(2418,31,'080','Aluthgama'),(2419,31,'081','Maharagama'),(2420,31,'082','Gampaha'),(2421,31,'999','Sanasa Development Bank Head Office'),(2422,33,'001','Head Office'),(2423,33,'002','Moratuwa'),(2424,33,'003','Negombo'),(2425,33,'004','Kurunegala'),(2426,33,'005','Kelaniya'),(2427,33,'006','Kandy'),(2428,33,'007','Gampaha'),(2429,33,'008','Rathnapura'),(2430,33,'009','Badulla'),(2431,33,'010','Chilaw'),(2432,33,'011','Anuradhapura'),(2433,33,'012','Wellawatta'),(2434,33,'013','Wattala'),(2435,33,'014','Ja-Ela'),(2436,33,'015','Kaduwela'),(2437,33,'016','Kegalle'),(2438,33,'017','Nittambuwa'),(2439,33,'018','Wennappuwa'),(2440,33,'019','Mathugama'),(2441,33,'020','Kaluthara'),(2442,33,'021','Maharagama'),(2443,33,'022','Matara'),(2444,33,'023','Embilipitiya'),(2445,33,'024','Battaramulla'),(2446,33,'025','Tissamaharama'),(2447,33,'026','Mahara'),(2448,33,'027','Galle'),(2449,33,'028','Dambulla'),(2450,33,'029','Kaduruwela'),(2451,33,'030','Kotahena'),(2452,33,'031','Colombo Office'),(2453,33,'032','Jaffna'),(2454,33,'033','Vavuniya'),(2455,33,'034','Batticaloa'),(2456,33,'035','Trincomalee'),(2457,33,'038','Head Office'),(2458,33,'039','Kadana'),(2459,33,'040','Ragama'),(2460,33,'041','Ela Kanda'),(2461,33,'042','Eheliyagoda'),(2462,33,'043','Boralesgamuwa'),(2463,33,'044','Marawila'),(2464,33,'045','Kuliyapitiya'),(2465,33,'046','Ratmalana'),(2466,33,'047','Panadura'),(2467,35,'001','Head Office City'),(2468,35,'002','Kandy'),(2469,35,'003','SMIB Finance Department'),(2470,35,'004','Gampaha'),(2471,35,'005','Galle'),(2472,35,'006','Kurunegala'),(2473,35,'007','Matugama'),(2474,35,'008','Chilaw'),(2475,35,'009','Matara'),(2476,35,'010','Battaramulla'),(2477,35,'011','Kiribathgoda'),(2478,35,'012','Kegalle'),(2479,35,'013','Horana'),(2480,35,'014','Ambalantota'),(2481,35,'015','Batticaloa'),(2482,35,'016','Jaffna'),(2483,35,'018','Ratnapura'),(2484,35,'019','Kaduruwela'),(2485,35,'020','Vavuniya'),(2486,36,'001','Head Office'),(2487,36,'002','Corporate Office'),(2488,36,'003','Nugegoda'),(2489,36,'004','Negambo'),(2490,36,'005','Kandy'),(2491,36,'006','Badulla'),(2492,36,'007','Panadura'),(2493,36,'008','Anuradhapura'),(2494,36,'009','Galle'),(2495,36,'010','Kiribathgoda'),(2496,36,'011','Kurunegala'),(2497,36,'012','Ratnapura'),(2498,36,'013','Matara'),(2499,36,'014','Kalutara'),(2500,36,'015','Ambalangoda'),(2501,36,'016','Ampara'),(2502,36,'017','Avissawella'),(2503,36,'018','Gampaha'),(2504,36,'019','Chilaw'),(2505,36,'020','Polonnaruwa'),(2506,36,'021','Piliyandala'),(2507,36,'022','Boralesgamuwa'),(2508,36,'023','Dambulla'),(2509,36,'024','Balangoda'),(2510,36,'025','Kegalle'),(2511,36,'026','Bandarawela'),(2512,36,'027','Dehiwala'),(2513,36,'028','Embilipitiya'),(2514,36,'029','Batticaloa'),(2515,36,'030','Elpitiya'),(2516,36,'031','Maradana'),(2517,36,'032','Kandana'),(2518,36,'033','Mahiyanganaya'),(2519,36,'034','Tissamaharama'),(2520,36,'035','Matale'),(2521,36,'036','Maharagama'),(2522,36,'037','Kuliyapitiya'),(2523,36,'038','Puttalam'),(2524,36,'039','Trincomalee'),(2525,36,'040','Gampola'),(2526,36,'041','Horana'),(2527,36,'042','Kadawatha'),(2528,36,'043','Jaffna'),(2529,36,'044','Chunnakam'),(2530,36,'045','Manipay'),(2531,36,'046','Chavakachcheri'),(2532,36,'047','Kilinochchi'),(2533,36,'048','Vavuniya'),(2534,36,'049','Nuwara Eliya'),(2535,36,'050','Hatton'),(2536,36,'051','Nelliady'),(2537,36,'053','Wennappuwa'),(2538,36,'052','Matugama'),(2539,36,'054','Thambuththegama'),(2540,36,'055','Akkaraipattu'),(2541,36,'056','Pothuvil'),(2542,36,'057','Kochchikade'),(2543,36,'058','Kotahena'),(2544,36,'059','Anuradhapura 02'),(2545,36,'060','Rajagiriya'),(2546,36,'061','Welimada'),(2547,36,'062','Pilimathalawa'),(2548,36,'063','Katugasthota'),(2549,36,'064','Kalmunai'),(2550,36,'065','Moratumulla'),(2551,36,'066','Kalawanchikudy'),(2552,36,'067','Sea Street'),(2553,36,'068','Matara City'),(2554,36,'069','Aluthgama'),(2555,36,'070','Kandy City'),(2556,36,'071','Warakapola'),(2557,36,'072','Malabe'),(2558,36,'073','Kaduwela'),(2559,36,'074','Nawalapitiya'),(2560,35,'075','Homagama'),(2561,36,'075','Homagama'),(2562,36,'076','Kurunegala City'),(2563,36,'077','Maskeliya'),(2564,36,'078','Pitigala'),(2565,36,'079','Samanturei'),(2566,36,'080','Saindamarthu'),(2567,36,'081','Kotte'),(2568,36,'082','Badulla City'),(2569,36,'083','Ja Ela'),(2570,36,'084','Delkada'),(2571,36,'085','Kaththankudi'),(2572,36,'086','Dam Street'),(2573,36,'087','Akuressa'),(2574,36,'088','Monaragala'),(2575,36,'089','Tangalle'),(2576,36,'090','Mount Lavinia'),(2577,36,'091','Neluwa'),(2578,36,'092','Battaramulla'),(2579,36,'093','Kurunegala Premier Centre'),(2580,36,'094','Moratuwa'),(2581,34,'001','Head Office'),(2582,34,'003','Provincial Office - Central'),(2583,34,'100','Provincial Office - Western'),(2584,34,'101','Bulathsinghala'),(2585,34,'102','Walagedara'),(2586,34,'103','Agalawatte'),(2587,34,'104','Millaniya'),(2588,34,'105','Goonapola'),(2589,34,'106','Moranthuduwa'),(2590,34,'107','Beruwala'),(2591,34,'108','Panadura'),(2592,34,'109','Horana'),(2593,34,'110','Warakagoda'),(2594,34,'111','Ingiriya'),(2595,34,'112','Dodangoda'),(2596,34,'113','Meegahathenna'),(2597,34,'114','Baduraliya'),(2598,34,'115','Kalutara'),(2599,34,'116','Gampaha'),(2600,34,'117','Mawaramandiya'),(2601,34,'118','Minuwangoda'),(2602,34,'119','Meerigama'),(2603,34,'120','Moragahahena'),(2604,34,'121','Mathugama'),(2605,34,'122','Negombo'),(2606,34,'123','Divulapitiya'),(2607,34,'124','Nittambuwa'),(2608,34,'125','Homagama'),(2609,34,'126','Kolonnawa'),(2610,34,'127','Awissawella'),(2611,34,'128','Piliyandala'),(2612,34,'129','Ragama'),(2613,34,'130','Wadduwa'),(2614,34,'131','Kirindiwela'),(2615,34,'132','J-Ela'),(2616,34,'133','Miriswaththa'),(2617,34,'134','Kelaniya - Head Quarter'),(2618,34,'198','Gampaha District Office'),(2619,34,'199','Kalutara District Office'),(2620,34,'200','Provincial Office - Southern'),(2621,34,'201','Hakmana'),(2622,34,'202','Urubokka'),(2623,34,'203','Deiyandara'),(2624,34,'204','Akuressa'),(2625,34,'205','Weligama'),(2626,34,'206','Gandara'),(2627,34,'207','Kekanadura'),(2628,34,'208','Ambalantota'),(2629,34,'209','Angunukolapalassa'),(2630,34,'210','Katuwana'),(2631,34,'211','Beliatta'),(2632,34,'212','Elpitiya'),(2633,34,'213','Batapola'),(2634,34,'214','Pitigala'),(2635,34,'215','Gonagalapura'),(2636,34,'217','Baddegama'),(2637,34,'216','Imaduwa'),(2638,34,'218','Tissamaharama'),(2639,34,'219','Lunugamwehera'),(2640,34,'220','Pitabaddera'),(2641,34,'221','Thalgaswala'),(2642,34,'222','Akmeemana'),(2643,34,'223','Karandeniya'),(2644,34,'224','Sooriyawewa'),(2645,34,'225','Kamburugamuwa'),(2646,34,'226','Deniyaya'),(2647,34,'227','Kamburupitiya'),(2648,34,'228','Galle'),(2649,34,'229','Uragasmanhandiya'),(2650,34,'230','Uragasmanhandiya'),(2651,34,'231','Weerakatiya'),(2652,34,'232','Thihagoda'),(2653,34,'233','City - Matara'),(2654,34,'234','Tangalle'),(2655,34,'235','Neluwa'),(2656,34,'236','Mawarala'),(2657,34,'237','Morawaka'),(2658,34,'238','Hambantota'),(2659,34,'239','Walasmulla'),(2660,34,'240','Barawakumbuka'),(2661,34,'241','Udugama'),(2662,34,'242','Ranna'),(2663,34,'243','Ahangama'),(2664,34,'244','Hikkaduwa'),(2665,34,'245','Kirinda'),(2666,34,'246','Middeniya'),(2667,34,'247','Dikwella'),(2668,34,'248','Karapitiya'),(2669,34,'249','Balapitiya'),(2670,34,'250','Pamburana'),(2671,34,'251','Mirissa'),(2672,34,'252','Kaluwella'),(2673,34,'253','Warapitiya'),(2674,34,'254','Devinuwara'),(2675,34,'297','District Office - Hambantota'),(2676,34,'298','District Office - Galle'),(2677,34,'299','District Office - Matara'),(2678,34,'300','Wayamba Provincial Office'),(2679,34,'301','Kuliyapitiya'),(2680,34,'302','Pannala'),(2681,34,'303','Panduwasnuwara'),(2682,34,'304','Alawwa'),(2683,34,'305','Dummalasooriya'),(2684,34,'306','Pothuhera'),(2685,34,'307','Nikaweratiya'),(2686,34,'308','Rideegama'),(2687,34,'309','Mawathagama'),(2688,34,'310','Wariyapola'),(2689,34,'311','Kurunegala'),(2690,34,'312','Galgamuwa'),(2691,34,'313','Chilaw'),(2692,34,'314','Palakuda'),(2693,34,'315','Anamaduwa'),(2694,34,'316','Nattandiya'),(2695,34,'317','Kirimetiyana'),(2696,34,'318','Puttlam'),(2697,34,'319','Maho'),(2698,34,'320','Giriulla'),(2699,34,'321','Ibbagamuwa'),(2700,34,'322','Mundel'),(2701,34,'323','Nawagattegama'),(2702,34,'324','Mampuri'),(2703,34,'325','Mahawewa'),(2704,34,'326','Narammala'),(2705,34,'327','Polpithigama'),(2706,34,'328','Bowatte'),(2707,34,'329','HQB'),(2708,34,'330','Melsiripura'),(2709,34,'331','Ambanpola'),(2710,34,'332','Santha Anapura'),(2711,34,'398','Puttlam District Office'),(2712,34,'399','Kurunegala District Office'),(2713,34,'400','Provincial Office - North Central'),(2714,34,'401','Mihinthale'),(2715,34,'402','Town Branch - Anuradhapura'),(2716,34,'403','Thambuththegama'),(2717,34,'404','Kahatagasdigiliya'),(2718,34,'405','Galnewa'),(2719,34,'406','Thalawa'),(2720,34,'407','Medawachchiya'),(2721,34,'408','Thirappane'),(2722,34,'409','Rambewa'),(2723,34,'410','Polonnaruwa'),(2724,34,'411','Medirigiriya'),(2725,34,'412','Pulasthigama'),(2726,34,'413','Hingurakgoda'),(2727,34,'414','Bakamoona'),(2728,34,'415','Galenbindunuwewa'),(2729,34,'416','Gonapathirawa'),(2730,34,'417','Manampitiya'),(2731,34,'418','Galamuna'),(2732,34,'419','New Town - Anuradhapura'),(2733,34,'420','Siripura'),(2734,34,'421','Kaduruwela'),(2735,34,'422','Kekirawa'),(2736,34,'423','Aralaganwila'),(2737,34,'424','Economic Centre'),(2738,34,'425','Sevanapitiya'),(2739,34,'498','Dritrict Office Polonnaruwa'),(2740,34,'500','Provincial Office - Sabaragamuwa'),(2741,34,'501','Kegalle'),(2742,34,'502','Pitagaldeniya'),(2743,34,'503','Rambukkana'),(2744,34,'504','Mawanella'),(2745,34,'505','Warakapola'),(2746,34,'506','Aranayaka'),(2747,34,'507','Kithulgala'),(2748,34,'508','Ruwanwella'),(2749,34,'509','Dewalegama'),(2750,34,'510','Bulathkohupitiya'),(2751,34,'511','Deraniyagala'),(2752,34,'512','Rathnapura'),(2753,34,'513','Pelmadulla'),(2754,34,'514','Balangoda'),(2755,34,'515','Embilipitiya'),(2756,34,'516','Hemmathagama'),(2757,34,'517','Kolonna'),(2758,34,'518','Eheliyagoda'),(2759,34,'519','Nelumdeniya'),(2760,34,'520','Kalawana'),(2761,34,'521','Yatiyantota'),(2762,34,'522','Godakawela'),(2763,34,'523','Erathna'),(2764,34,'524','Kuruwita'),(2765,34,'525','Nivithigala'),(2766,34,'526','Kahawatta'),(2767,34,'527','Kotiyakumbura'),(2768,34,'528','Rakwana'),(2769,34,'529','Dehiovita'),(2770,34,'530','Kiriella'),(2771,34,'531','Pothupitiya'),(2772,34,'532','Weligepola'),(2773,34,'533','Sri Palabaddala'),(2774,34,'534','Pulungupitiya'),(2775,34,'599','Kegalle District Office'),(2776,34,'600','Provincial Office - Central'),(2777,34,'601','Gampola'),(2778,34,'602','Udawela'),(2779,34,'603','Hataraliyadda'),(2780,34,'604','Marassana'),(2781,34,'605','Danture'),(2782,34,'606','Wattegama'),(2783,34,'607','Morayaya'),(2784,34,'608','Teldeniya'),(2785,34,'609','Pujapitiya'),(2786,34,'610','Nuwara Eliya'),(2787,34,'611','Rikillagaskada'),(2788,34,'612','Kandy Marketing Centre'),(2789,34,'613','Ginigathena'),(2790,34,'614','Poondaluoya'),(2791,34,'615','Katugastota'),(2792,34,'616','Nildandahinna'),(2793,34,'617','Agarapathana'),(2794,34,'618','Ududumbara'),(2795,34,'619','Matale'),(2796,34,'620','Dambulla'),(2797,34,'621','Galewela'),(2798,34,'622','Laggala'),(2799,34,'623','Rattota'),(2800,34,'624','Kotagala'),(2801,34,'625','Menikhinna'),(2802,34,'626','Hanguranketha'),(2803,34,'627','Daulagala'),(2804,34,'628','Naula'),(2805,34,'629','Nawalapitiya'),(2806,34,'630','Hedeniya'),(2807,34,'631','Wilgamuwa'),(2808,34,'632','Kandy'),(2809,34,'633','Peradeniya'),(2810,34,'700','Provincial Office - Uva'),(2811,34,'701','Buttala'),(2812,34,'702','Medagama'),(2813,34,'703','Monaragala'),(2814,34,'704','Thanamalvila'),(2815,34,'705','Badulla'),(2816,34,'706','Passara'),(2817,34,'707','Welimada'),(2818,34,'708','Kandaketiya'),(2819,34,'709','Mahiyanganaya'),(2820,34,'710','wellawaya'),(2821,34,'711','Badalkumbura'),(2822,34,'712','Haputhale'),(2823,34,'713','Rideemaliyadda'),(2824,34,'714','Uvaparanagama'),(2825,34,'715','Bandarawela'),(2826,34,'716','Meegahakiula'),(2827,34,'717','Lunugala'),(2828,34,'718','Haldummulla'),(2829,34,'719','Girandurukotte'),(2830,34,'720','Bogahakumbura'),(2831,34,'721','Bibile'),(2832,34,'722','Uva Maligathenna'),(2833,34,'723','Siyambalanduwa'),(2834,34,'724','Diyathalawa'),(2835,34,'725','Sewanagala'),(2836,34,'726','Madulla'),(2837,34,'801','Ampara'),(2838,34,'802','Dehiatthakandiya'),(2839,34,'803','Sammanthurai'),(2840,34,'804','Hingurana'),(2841,34,'805','Akkaraipaththu'),(2842,34,'806','Kalmunai'),(2843,34,'807','Mahaoya'),(2844,34,'808','Pothuvil'),(2845,34,'809','Uhana'),(2846,34,'810','Nintavur'),(2847,34,'811','Batticaloa'),(2848,34,'812','Eraur'),(2849,34,'813','Chenkalady'),(2850,34,'814','Kanthale'),(2851,34,'815','Valachenai'),(2852,34,'816','Kathankudi'),(2853,34,'817','Trincomalee'),(2854,34,'818','Kalauwanchikudi'),(2855,34,'819','Kokkadichcholai'),(2856,34,'820','Muthtur'),(2857,34,'901','Vavuniya'),(2858,34,'902','Kanagarayankulam'),(2859,34,'903','Mannar'),(2860,34,'904','Chunnakam'),(2861,34,'905','Jaffna'),(2862,34,'906','Kilinochchi'),(2863,34,'907','Bogaswewa'),(2864,38,'064','KOTAHENA'),(2865,18,'023','Wattala'),(2866,25,'077','Gothatuwa'),(2867,18,'007','Old Moor Street'),(2868,18,'009','Kurunegala'),(2869,7,'213','Seeduwa'),(2870,6,'152','Samanthurai'),(2871,18,'003','Kandy'),(2872,18,'011','Matara'),(2873,18,'034','Horana'),(2874,25,'067','Karapitiya'),(2875,28,'091','Wennappuwa'),(2876,6,'128','Ranpokunugama'),(2877,19,'080','kottawa'),(2878,25,'085','Nittambuwa'),(2879,18,'027','Galle'),(2880,10,'101','Warakapola'),(2881,10,'082','Katunayake'),(2882,7,'211','Talahena'),(2883,5,'229','Divulapitiya'),(2884,28,'078','Kaduwela'),(2885,6,'127','Yatiyanthota'),(2886,7,'224','Kesbewa'),(2887,7,'224','Duplicate Kesbewa'),(2888,7,'138','Nochchiyagama'),(2889,25,'091','Avissawella'),(2890,21,'004','Matara'),(2891,18,'044','Embilipitiya'),(2892,18,'006','Pettah'),(2893,21,'006','Vavuniya'),(2894,7,'215','Kurunegala Metro'),(2895,18,'054','Nawalapitiya'),(2896,6,'165','Matara Bazzar'),(2897,5,'226','Wijerama'),(2898,4,'275','KELANIYA'),(2899,19,'082','Mawanella'),(2900,4,'250','Veyangoda'),(2901,18,'035','Ambalangoda'),(2902,18,'049','Ambalanthota'),(2903,10,'104','Thambuttegama'),(2904,18,'016','Moratuwa'),(2905,5,'232','Anuradhapura Metro'),(2906,7,'227','Kelaniya'),(2907,6,'140','Hikkuduwa'),(2908,7,'222','Thalawakale'),(2909,18,'055','Ibbagamuwa'),(2910,9,'359','Piliyandala City'),(2911,6,'149','Katugastota'),(2912,6,'012','Nugegoda'),(2913,10,'109','Katana'),(2914,25,'089','Tangalla'),(2915,38,'081','BANDARAGAMA'),(2916,28,'081','BANDARAGAMA'),(2917,6,'148','KATHARAGAMA'),(2918,28,'074','WELIMADA'),(2919,7,'214','Orugodawatte'),(2920,19,'083','DANKOTUWA'),(2921,18,'041','Angunakolapalassa'),(2922,9,'283','BADURELIYA'),(2923,28,'069','Mathugama'),(2924,18,'019','Mannar'),(2925,4,'279','KATANA'),(2926,5,'233','Bibile'),(2927,6,'123','Gothatuwa'),(2928,6,'124','MINUWANGODA'),(2929,25,'053','NUGEGODA'),(2930,38,'092','HIKKADUWA'),(2931,28,'092','HIKKADUWA'),(2932,18,'059','Ganemulla'),(2933,10,'072','Duplicate Boralesgamuwa'),(2934,21,'005','Maharagama'),(2935,10,'081','Uragasmanhandiya'),(2936,25,'076','Kottawa'),(2937,6,'146','KAMBURUPITIYA'),(2938,25,'086','MINUWANGODA'),(2939,6,'170','ALUTHGAMA'),(2940,6,'160','WENNAPPUWA'),(2941,6,'161','DANKOTUWA'),(2942,6,'302','GINIGATHHENA'),(2943,4,'278','RAMBUKKANA'),(2944,7,'229','Hikkaduwa'),(2945,5,'235','GODAKAWELA'),(2946,18,'069','BANDARAWELA'),(2947,25,'054','KOHUWALA'),(2948,38,'071','NIKAWERATIYA'),(2949,28,'071','NIKAWERATIYA'),(2950,6,'133','NOCHCHIYAGAMA'),(2951,19,'081','Kaduwela'),(2952,25,'075','BORALASGAMUWA'),(2953,25,'080','TISSAMAHARAMA'),(2954,7,'220','HEERASSAGALA'),(2955,4,'231','ATTIDIYA'),(2956,38,'107','Mawanella'),(2957,28,'107','Mawanella'),(2958,10,'079','Colombo 02'),(2959,28,'105','Eppawala'),(2960,38,'099','Baddegama'),(2961,28,'099','BADDEGAMA'),(2962,10,'084','COLOMBO 02'),(2963,18,'010','NEGOMBO'),(2964,28,'100','MATARA CITY'),(2965,8,'799','NELUNDENIYA'),(2966,25,'073','DIGANA'),(2967,10,'102','Colombo'),(2968,4,'277','Morawaka'),(2969,6,'154','Padaviya'),(2970,7,'216','Dickwella'),(2971,6,'157','Peradeniya'),(2972,4,'281','Yatiyanthota'),(2973,5,'173','GINIGATHHENA'),(2974,25,'084','Weligama'),(2975,18,'028','Piliyandala'),(2976,6,'162','PANNALA'),(2977,25,'093','KANDY CITY CENTER'),(2978,10,'089','COLOMBO 02'),(2979,5,'227','KARAPITIYA'),(2980,25,'081','NARAHENPITA'),(2981,5,'245','INGIRIYA'),(2982,4,'240','Batapola'),(2983,4,'288','Theldeniya'),(2984,18,'031','Anuradhapura'),(2985,28,'088','Kahawatta'),(2986,28,'094','Dankotuwa'),(2987,28,'103','Buttala'),(2988,6,'155','Hasalaka'),(2989,6,'164','KARAPITIYA'),(2990,10,'601','Islamic Banking Unit'),(2991,5,'7083','-999 CHQ'),(2992,4,'300','-999 CHQ'),(2993,7,'230','-999 CHQ'),(2994,28,'600','-999 CHQ'),(2995,8,'900','-999 CHQ'),(2996,28,'097','Thisamaharama'),(2997,6,'400','-999 CHQ'),(2998,21,'014','Kandy'),(2999,9,'-99','-999 Cheque'),(3000,8,'702','Ethiliwewa'),(3001,38,'108','Nawalapitiya'),(3002,28,'108','Nawalpitiya'),(3003,25,'095','Plimathalawa'),(3004,4,'283','Pitigala'),(3005,28,'093','Nawalapitiya'),(3006,5,'7084','Duplicate'),(3007,7,'401','Duplicate'),(3008,28,'1043','-999'),(3009,6,'098','-999'),(3010,19,'-999','-999'),(3011,20,'031','Beruwala'),(3013,6,'138','Eppawala'),(3014,4,'282','Kolonnawa'),(3015,10,'096','Hanwella'),(3016,28,'079','Hingurakgoda'),(3017,9,'034','Negombo'),(3018,10,'094','Akkarapattu'),(3019,25,'090','Mawathagama'),(3020,28,'080','Balangoda'),(3021,6,'137','Bowatta'),(3022,28,'102','Urubokka'),(3023,8,'798','Thalduwa'),(3024,28,'006','Kandy'),(3025,10,'114','Digana');

--
-- Table structure for table `tbl_banks`
--

CREATE TABLE `tbl_banks` (
  `bank_id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(45) NOT NULL,
  `code` varchar(5) DEFAULT NULL,
  PRIMARY KEY (`bank_id`)
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_banks`
--

INSERT INTO `tbl_banks` VALUES (4,'COM BANK','7056'),(5,'HNB','7083'),(6,'SEYLAN BANK','7287'),(7,'SAMPATH BANK','7278'),(8,'BANK OF CEYLON','7010'),(9,'PEOPLE S BANK','7135'),(10,'NDB BANK','7214'),(11,'STANDARD CHARTED BANK','7038'),(12,'CITI BANK','7047'),(13,'HABIB BANK LTD','7074'),(14,'HONGKONG & SHANGHI BANKING CORP','7092'),(15,'INDIAN BANK','7108'),(16,'MUSLIM COMMERCIAL BANK','7269'),(17,'PUBLIC BANK BERHAD','7296'),(18,'UNION BANK COLOMBO LTD.','7302'),(19,'PAN - ASIA BANK','7311'),(20,'AMANA BANK','7463'),(21,'CARGILLS BANK','7481'),(23,'Indian Overseas Bank','7117'),(24,'State Bank of India','7144'),(25,'Nations Trust Bank PLC','7162'),(26,'Deutsche Bank','7205'),(27,'ICICI Bank Ltd','7384'),(28,'DFCC Vardhana Bank Ltd','7454'),(29,'Axis Bank','7472'),(30,'National Savings Bank','7719'),(31,'Sanasa Development Bank','7728'),(32,'HDFC Bank','7737'),(33,'Citizen Development Business Finance PLC','7746'),(34,'Regional Development Bank','7755'),(35,'State Mortgage & Investment Bank','7764'),(36,'LB Finance PLC','7773'),(37,'Central Bank of Sri Lanka','8004'),(38,'DFCC BANK','3454');

--
-- Table structure for table `tbl_boq`
--

CREATE TABLE `tbl_boq` (
  `boq_id` int NOT NULL AUTO_INCREMENT,
  `code` varchar(50) NOT NULL,
  `product_id` int NOT NULL,
  `name` varchar(50) NOT NULL,
  `description` varchar(500) NOT NULL,
  `updated_by` int NOT NULL,
  `updated_on` datetime NOT NULL,
  `created_by` int NOT NULL,
  `created_on` datetime NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `is_delete` tinyint(1) NOT NULL DEFAULT '0',
  `production_volum` decimal(11,2) NOT NULL,
  `mc_volumn` decimal(11,2) NOT NULL,
  `weight` decimal(11,2) NOT NULL,
  `qty` decimal(11,2) NOT NULL,
  PRIMARY KEY (`boq_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_boq`
--


--
-- Table structure for table `tbl_boq_details`
--

CREATE TABLE `tbl_boq_details` (
  `id` int NOT NULL AUTO_INCREMENT,
  `parent_id` int NOT NULL,
  `field_name` varchar(50) NOT NULL,
  `field_value` varchar(5000) NOT NULL,
  `created_by` int NOT NULL,
  `created_on` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_boq_details`
--


--
-- Table structure for table `tbl_boq_product_details`
--

CREATE TABLE `tbl_boq_product_details` (
  `boq_product_id` int NOT NULL AUTO_INCREMENT,
  `product_id` int NOT NULL,
  `qty` decimal(18,6) NOT NULL,
  `created_by` int NOT NULL,
  `created_on` datetime NOT NULL,
  `updated_by` int NOT NULL,
  `updated_on` datetime NOT NULL,
  `is_delete` tinyint(1) NOT NULL DEFAULT '0',
  `boq_id` int NOT NULL,
  PRIMARY KEY (`boq_product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_boq_product_details`
--


--
-- Table structure for table `tbl_branch`
--

CREATE TABLE `tbl_branch` (
  `branch_id` int NOT NULL AUTO_INCREMENT,
  `Code` varchar(15) DEFAULT NULL,
  `Name` varchar(25) NOT NULL,
  `Address` varchar(45) DEFAULT NULL,
  `Telephone` varchar(50) NOT NULL,
  `Inventory_Location` text NOT NULL,
  `Status` varchar(10) NOT NULL,
  `Created_datetime` datetime NOT NULL,
  `Updated_datetime` datetime NOT NULL,
  `rest` int NOT NULL,
  `is_delete` tinyint(1) NOT NULL DEFAULT '0',
  `Inventory_Location_id` int NOT NULL DEFAULT '0',
  `create_by` int NOT NULL,
  `update_by` int NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `logo` varchar(450) DEFAULT NULL,
  `price_group_id` int NOT NULL DEFAULT '1',
  `vat_no` varchar(500) NOT NULL,
  UNIQUE KEY `Code_id` (`branch_id`)
) ENGINE=InnoDB AUTO_INCREMENT=62 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_branch`
--

INSERT INTO `tbl_branch` VALUES (1,'BR-001','Main','101/138/12A, Nagahamulla Road, Kolannawa.','0701271111','','ACTIVE','2020-09-18 10:49:24','2021-03-09 16:17:43',0,0,0,77,77,0,NULL,1,'');

--
-- Table structure for table `tbl_branch_inventory_locations`
--

CREATE TABLE `tbl_branch_inventory_locations` (
  `id` int NOT NULL AUTO_INCREMENT,
  `branch_id` int NOT NULL,
  `location` varchar(1000) NOT NULL,
  `is_sale_location` tinyint(1) NOT NULL DEFAULT '0',
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `is_remove` tinyint(1) NOT NULL DEFAULT '0',
  `fn_companyCode` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_branch_inventory_locations`
--

INSERT INTO `tbl_branch_inventory_locations` VALUES (1,1,'Main',1,1,0,'ApiCOFN');

--
-- Table structure for table `tbl_call_log`
--

CREATE TABLE `tbl_call_log` (
  `call_log_id` int NOT NULL AUTO_INCREMENT,
  `district_id` int NOT NULL,
  `project_id` int NOT NULL,
  `call_source_id` int NOT NULL,
  `inquiry_mode_id` int NOT NULL,
  `call_status_id` int NOT NULL,
  `lot_number` text NOT NULL,
  `code` varchar(50) NOT NULL,
  `name` varchar(255) NOT NULL,
  `contact_number` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `address` text NOT NULL,
  `updated_by` int NOT NULL,
  `updated_on` datetime NOT NULL,
  `created_by` int NOT NULL,
  `created_on` datetime NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `is_delete` tinyint(1) NOT NULL DEFAULT '0',
  `note` text NOT NULL,
  `nic` varchar(255) NOT NULL,
  `payment_mode` enum('OUT_RIGHT','BANK_LOAN','EASY_PAYMENT') NOT NULL,
  `whatsAppNo` varchar(50) NOT NULL,
  `name_title` varchar(50) NOT NULL,
  `employee_id` int NOT NULL,
  `is_convert_customer` int NOT NULL DEFAULT '0',
  `customer_id` int NOT NULL,
  PRIMARY KEY (`call_log_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_call_log`
--


--
-- Table structure for table `tbl_call_log_other_details`
--

CREATE TABLE `tbl_call_log_other_details` (
  `id` int NOT NULL,
  `parent_id` int NOT NULL,
  `field_name` varchar(50) NOT NULL,
  `field_value` varchar(5000) NOT NULL,
  `created_by` int NOT NULL,
  `created_on` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_call_log_other_details`
--


--
-- Table structure for table `tbl_call_log_reminder`
--

CREATE TABLE `tbl_call_log_reminder` (
  `id` int NOT NULL AUTO_INCREMENT,
  `remind_date` date NOT NULL,
  `remind_note` varchar(500) NOT NULL,
  `status` varchar(50) NOT NULL,
  `status_note` varchar(500) NOT NULL,
  `created_by` int NOT NULL,
  `created_on` datetime NOT NULL,
  `call_log_id` int NOT NULL,
  `updated_by` int NOT NULL,
  `updated_on` datetime NOT NULL,
  `is_delete` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_call_log_reminder`
--


--
-- Table structure for table `tbl_call_source`
--

CREATE TABLE `tbl_call_source` (
  `call_source_id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY (`call_source_id`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_call_source`
--

INSERT INTO `tbl_call_source` VALUES (1,'Banner'),(2,'Leaflet'),(3,'N-Paper'),(4,'E-mail'),(5,'SMS'),(6,'Referral'),(7,'TV'),(8,'Web Site'),(9,'Facebook'),(10,'ikman');

--
-- Table structure for table `tbl_call_status`
--

CREATE TABLE `tbl_call_status` (
  `call_status_id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`call_status_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_call_status`
--

INSERT INTO `tbl_call_status` VALUES (1,'Cancelled'),(2,'Sold'),(3,'Prospects');

--
-- Table structure for table `tbl_canceled_invoice`
--

CREATE TABLE `tbl_canceled_invoice` (
  `id` int NOT NULL AUTO_INCREMENT,
  `invoice_id` int NOT NULL,
  `cancelled_by` int NOT NULL,
  `cancelled_on` datetime NOT NULL,
  `canceled_payment_id` int NOT NULL,
  `amount` decimal(16,2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_canceled_invoice`
--


--
-- Table structure for table `tbl_canceled_payments`
--

CREATE TABLE `tbl_canceled_payments` (
  `id` int NOT NULL AUTO_INCREMENT,
  `code` varchar(50) NOT NULL,
  `status` varchar(50) NOT NULL,
  `type` varchar(50) NOT NULL,
  `created_by` int NOT NULL,
  `created_on` datetime NOT NULL,
  `ps_id` int NOT NULL DEFAULT '0',
  `note` varchar(1000) NOT NULL,
  `payment_type` varchar(50) NOT NULL,
  `overpayment_id` int NOT NULL,
  `customer_id` int NOT NULL,
  `amount` decimal(16,2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_canceled_payments`
--


--
-- Table structure for table `tbl_card_types`
--

CREATE TABLE `tbl_card_types` (
  `id` int NOT NULL AUTO_INCREMENT,
  `card_type` varchar(100) NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `is_remove` tinyint(1) NOT NULL DEFAULT '0',
  `fn_acount_id` int NOT NULL,
  `fn_account_name` varchar(1000) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_card_types`
--

INSERT INTO `tbl_card_types` VALUES (1,'Visa',1,0,51,'Undeposited Visa & Master Card'),(2,'Master',1,0,51,'Undeposited Visa & Master Card'),(3,'Amex',1,0,278,'Undeposited AMEX'),(5,'Other',1,0,0,'');

--
-- Table structure for table `tbl_category_serial_no`
--

CREATE TABLE `tbl_category_serial_no` (
  `id` int NOT NULL AUTO_INCREMENT,
  `cat_id` varchar(45) DEFAULT NULL,
  `type` varchar(45) DEFAULT NULL,
  `serial_no` int DEFAULT '0',
  `year` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_category_serial_no`
--


--
-- Table structure for table `tbl_comisions`
--

CREATE TABLE `tbl_comisions` (
  `id` int NOT NULL AUTO_INCREMENT,
  `sale_invoice_id` int NOT NULL,
  `comis_customer_id` int NOT NULL,
  `comis_mode` varchar(50) NOT NULL,
  `comis_rate` decimal(16,2) NOT NULL,
  `comis_amount` decimal(16,2) NOT NULL,
  `created_by` int NOT NULL,
  `created_on` datetime NOT NULL,
  `approved_by` int NOT NULL,
  `approved_on` datetime NOT NULL,
  `issued_by` int NOT NULL,
  `issued_on` datetime NOT NULL,
  `status` int NOT NULL,
  `code` varchar(1000) NOT NULL,
  `is_settled` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_comisions`
--


--
-- Table structure for table `tbl_commission_history`
--

CREATE TABLE `tbl_commission_history` (
  `id` int NOT NULL AUTO_INCREMENT,
  `sale_invoice_id` int NOT NULL,
  `created_on` datetime NOT NULL,
  `created_by` int NOT NULL,
  `amount` decimal(16,2) NOT NULL,
  `reason` varchar(1000) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_commission_history`
--


--
-- Table structure for table `tbl_company`
--

CREATE TABLE `tbl_company` (
  `company_id` int NOT NULL AUTO_INCREMENT,
  `company_name` varchar(1000) NOT NULL,
  `address` varchar(1000) NOT NULL,
  `mobile_no` varchar(15) NOT NULL,
  `phone_no` varchar(30) NOT NULL,
  `fax` varchar(30) NOT NULL,
  `email` varchar(1000) NOT NULL,
  `web` varchar(1000) NOT NULL,
  `description` varchar(1000) NOT NULL,
  `create_user_Id` int NOT NULL,
  `create_datetime` datetime NOT NULL,
  `logo` varchar(500) NOT NULL,
  `owner_name` varchar(45) DEFAULT NULL,
  `owner_phone_no` varchar(15) DEFAULT NULL,
  `owner_email` varchar(45) DEFAULT NULL,
  `membership` varchar(45) DEFAULT NULL,
  `company_code` varchar(15) DEFAULT NULL,
  `tbl_companycol` varchar(45) DEFAULT NULL,
  `currency` int DEFAULT NULL,
  `time_zone` varchar(45) DEFAULT NULL,
  `password` varchar(45) DEFAULT NULL,
  `vat_no` varchar(20) NOT NULL,
  `phone_no_2` varchar(15) NOT NULL,
  `mobile_no_2` varchar(15) NOT NULL,
  PRIMARY KEY (`company_id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_company`
--

INSERT INTO `tbl_company` VALUES (1,'The Coffee Manor','No.83, R.G Senanayaka Mawatha, Colombo 07 00700 Colombo, Sri Lanka','94 112 082 190','94 112 082 190','0112 478 646','Info@bbk-holdings.com','Info@bbk-holdings.com','',77,'2025-10-28 09:03:41','documents/companylogo.png','Janaka1111111','0777869285','janakadalugama@gmail.com','test','01','',0,'Colombo','123456','-','94 112 082 190','077 797 4236');

--
-- Table structure for table `tbl_contract_boqs`
--

CREATE TABLE `tbl_contract_boqs` (
  `contract_boq_id` int NOT NULL AUTO_INCREMENT,
  `contract_id` int NOT NULL,
  `boq_id` int NOT NULL,
  `qty` decimal(18,6) NOT NULL,
  `qtyMc` decimal(18,6) NOT NULL,
  `grams` decimal(18,6) NOT NULL,
  `bags` decimal(11,2) NOT NULL,
  `CBM` decimal(11,2) NOT NULL,
  `created_by` int NOT NULL,
  `created_on` datetime NOT NULL,
  `updated_by` int NOT NULL,
  `updated_on` datetime NOT NULL,
  `is_delete` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`contract_boq_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_contract_boqs`
--


--
-- Table structure for table `tbl_contract_boqs_details`
--

CREATE TABLE `tbl_contract_boqs_details` (
  `id` int NOT NULL AUTO_INCREMENT,
  `boq_id` int NOT NULL,
  `contract_id` int NOT NULL,
  `boqQty` decimal(18,6) NOT NULL,
  `cartonQty` decimal(18,6) NOT NULL,
  `totalQty` decimal(18,6) NOT NULL,
  `product_id` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_contract_boqs_details`
--


--
-- Table structure for table `tbl_contracts`
--

CREATE TABLE `tbl_contracts` (
  `contract_id` int NOT NULL AUTO_INCREMENT,
  `code` varchar(50) NOT NULL,
  `customer_id` int NOT NULL,
  `description` varchar(500) NOT NULL,
  `updated_by` int NOT NULL,
  `updated_on` datetime NOT NULL,
  `created_by` int NOT NULL,
  `created_on` datetime NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `is_delete` tinyint(1) NOT NULL DEFAULT '0',
  `status` varchar(50) NOT NULL DEFAULT '0',
  PRIMARY KEY (`contract_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_contracts`
--


--
-- Table structure for table `tbl_contracts_details`
--

CREATE TABLE `tbl_contracts_details` (
  `id` int NOT NULL AUTO_INCREMENT,
  `parent_id` int NOT NULL,
  `field_name` varchar(50) NOT NULL,
  `field_value` varchar(5000) NOT NULL,
  `created_by` int NOT NULL,
  `created_on` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_contracts_details`
--


--
-- Table structure for table `tbl_currency`
--

CREATE TABLE `tbl_currency` (
  `currency_id` int NOT NULL AUTO_INCREMENT,
  `currency` varchar(500) NOT NULL,
  `code` varchar(50) NOT NULL,
  PRIMARY KEY (`currency_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_currency`
--

INSERT INTO `tbl_currency` VALUES (1,'Sri Lankan Rupee','LKR'),(2,'United States Dollar','USD');

--
-- Table structure for table `tbl_customer_category`
--

CREATE TABLE `tbl_customer_category` (
  `id` int NOT NULL AUTO_INCREMENT,
  `category` varchar(1000) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_customer_category`
--


--
-- Table structure for table `tbl_customer_other_details`
--

CREATE TABLE `tbl_customer_other_details` (
  `id` int NOT NULL AUTO_INCREMENT,
  `parent_id` int NOT NULL,
  `field_name` varchar(50) NOT NULL,
  `field_value` varchar(5000) NOT NULL,
  `created_by` int NOT NULL,
  `created_on` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_customer_other_details`
--


--
-- Table structure for table `tbl_customer_payments`
--

CREATE TABLE `tbl_customer_payments` (
  `id` int NOT NULL AUTO_INCREMENT,
  `payment_type` varchar(50) NOT NULL,
  `payment_date` date NOT NULL,
  `amount` decimal(16,2) NOT NULL,
  `cheque_date` date NOT NULL,
  `branch` varchar(50) NOT NULL,
  `bank_id` int NOT NULL,
  `online_reference` varchar(100) NOT NULL,
  `cheque_no` varchar(50) NOT NULL,
  `description` varchar(500) NOT NULL,
  `created_by` int NOT NULL,
  `created_on` datetime NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `updated_on` datetime NOT NULL,
  `updated_by` int NOT NULL,
  `status` varchar(50) NOT NULL,
  `code` varchar(50) NOT NULL,
  `so_id` int NOT NULL,
  `is_delete` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_customer_payments`
--


--
-- Table structure for table `tbl_customer_payments_details`
--

CREATE TABLE `tbl_customer_payments_details` (
  `id` int NOT NULL AUTO_INCREMENT,
  `parent_id` int NOT NULL,
  `field_name` varchar(50) NOT NULL,
  `field_value` varchar(5000) NOT NULL,
  `created_by` int NOT NULL,
  `created_on` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_customer_payments_details`
--


--
-- Table structure for table `tbl_customer_returns`
--

CREATE TABLE `tbl_customer_returns` (
  `id` int NOT NULL AUTO_INCREMENT,
  `sale_invoice_id` int NOT NULL,
  `amount` decimal(16,2) NOT NULL,
  `created_by` int NOT NULL,
  `created_on` datetime NOT NULL,
  `customer_id` int NOT NULL,
  `status` varchar(100) NOT NULL,
  `rpt_settled_amount` decimal(16,2) NOT NULL,
  `is_hold` tinyint(1) NOT NULL DEFAULT '0',
  `code` varchar(100) NOT NULL,
  `hold_by` int NOT NULL,
  `hold_on` datetime NOT NULL DEFAULT '2021-01-01 00:00:01',
  `return_type` varchar(100) NOT NULL,
  `is_settled` tinyint(1) NOT NULL DEFAULT '0',
  `settled_amount` decimal(16,2) NOT NULL,
  `total_item_qty` decimal(16,2) NOT NULL,
  `calculatedReturnCommission` decimal(16,2) NOT NULL,
  `returnSubTotalValue` decimal(16,2) NOT NULL,
  `availableCommission` decimal(16,2) NOT NULL,
  `overpayment_id` int NOT NULL,
  `special_note` varchar(500) DEFAULT '',
  `note` varchar(1000) NOT NULL,
  `manual_return_no` varchar(1000) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_customer_returns`
--


--
-- Table structure for table `tbl_customer_transaction_history`
--

CREATE TABLE `tbl_customer_transaction_history` (
  `id` int NOT NULL AUTO_INCREMENT,
  `customer_id` int NOT NULL,
  `parent_id` int NOT NULL,
  `type` varchar(50) NOT NULL,
  `cr_value` decimal(16,2) NOT NULL,
  `br_value` decimal(16,2) NOT NULL,
  `transaction_datetime` datetime NOT NULL,
  `updated_by` int NOT NULL,
  `updated_on` datetime NOT NULL,
  `current_outstanding` decimal(16,2) NOT NULL,
  `parent_code` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_customer_transaction_history`
--


--
-- Table structure for table `tbl_customer_vehicle_details`
--

CREATE TABLE `tbl_customer_vehicle_details` (
  `id` int NOT NULL AUTO_INCREMENT,
  `chassis_no` varchar(50) NOT NULL,
  `reg_no` varchar(50) NOT NULL,
  `make_by` int NOT NULL,
  `model` int NOT NULL,
  `service_interval` varchar(100) NOT NULL,
  `cus_id` int NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `is_delete` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_customer_vehicle_details`
--


--
-- Table structure for table `tbl_customers`
--

CREATE TABLE `tbl_customers` (
  `customer_id` int NOT NULL AUTO_INCREMENT,
  `code` varchar(50) NOT NULL,
  `updated_by` int NOT NULL,
  `created_by` int NOT NULL,
  `created_on` datetime NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '0',
  `is_delete` tinyint(1) NOT NULL DEFAULT '0',
  `customer_name` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `display_name` varchar(500) NOT NULL,
  `address` varchar(500) NOT NULL,
  `category` varchar(200) NOT NULL,
  `payment` varchar(100) NOT NULL,
  `credit_period` int NOT NULL,
  `credit_limit` decimal(13,2) NOT NULL DEFAULT '0.00',
  `vat_no` varchar(50) NOT NULL,
  `rpt_open_outstanding` decimal(13,2) NOT NULL,
  `rpt_invoice_amount` decimal(13,2) NOT NULL,
  `rpt_settlement_amount` decimal(13,2) NOT NULL,
  `rpt_return_amount` decimal(13,2) NOT NULL,
  `rpt_outstanding_amount` decimal(13,2) NOT NULL,
  `rpt_advance_payment` decimal(13,2) NOT NULL,
  `company_name` varchar(100) NOT NULL,
  `company_address` varchar(500) NOT NULL,
  `work_phone` varchar(50) NOT NULL,
  `remarks` varchar(500) NOT NULL,
  `mobile_no` varchar(50) NOT NULL,
  `handel_by` int NOT NULL,
  `is_cash` tinyint(1) NOT NULL,
  `is_credit` tinyint(1) NOT NULL,
  `is_cheque` tinyint(1) NOT NULL,
  `approve_datetime` datetime DEFAULT NULL,
  `approved_by` varchar(50) NOT NULL,
  `company_web` varchar(20) NOT NULL,
  `company_email` varchar(20) NOT NULL,
  `customer_history_generated_on` datetime NOT NULL DEFAULT '2020-01-01 00:00:00',
  `google_remark` varchar(50) NOT NULL,
  `facebook` varchar(50) NOT NULL,
  `how_knows` varchar(50) NOT NULL,
  `is_creditPeriodExceededInvoiceCreate` tinyint(1) NOT NULL,
  `isSend_creditPeriodExceededInvoiceCreateRequest` tinyint(1) NOT NULL DEFAULT '0',
  `version` int DEFAULT '0',
  `updated_on` datetime NOT NULL DEFAULT '2020-01-01 00:00:00',
  `requested_on` datetime DEFAULT NULL,
  `customer_title` varchar(50) NOT NULL DEFAULT '',
  `price_group_id` int NOT NULL DEFAULT '1',
  `tax_no` varchar(1000) NOT NULL,
  `is_tax_customer` tinyint(1) NOT NULL DEFAULT '0',
  `is_svat` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`customer_id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_customers`
--

INSERT INTO `tbl_customers` VALUES (1,'CUS-0001',0,77,'2024-05-07 11:54:17',1,0,'Walking Customer','','','Address','A','',1,0.00,'',1200.00,1300.00,1400.00,1500.00,1600.00,1200.00,'','','','','',0,1,0,0,NULL,'','','','2020-01-01 00:00:00','','','Select',0,0,0,'2024-05-07 11:54:17',NULL,'',1,'',0,0),(2,'CUS-0002',0,0,'0000-00-00 00:00:00',0,0,'COLOMBO BEVERAGE Division','','','Outlet Division','','',0,0.00,'',0.00,0.00,0.00,0.00,0.00,0.00,'','','','','',0,0,0,0,NULL,'','','','2020-01-01 00:00:00','','','',0,0,0,'2020-01-01 00:00:00',NULL,'',1,'',0,0),(3,'CUS-0003',0,0,'0000-00-00 00:00:00',0,0,'COLOMBO CUSTOMER','','','COLOMBO CUSTOMER','','',0,0.00,'',0.00,0.00,0.00,0.00,0.00,0.00,'','','','','',0,0,0,0,NULL,'','','','2020-01-01 00:00:00','','','',0,0,0,'2020-01-01 00:00:00',NULL,'',1,'',0,0),(4,'CUS-0004',0,0,'0000-00-00 00:00:00',0,0,'COLOMBO Kitchen Division','','','Kitchen Division','','',0,0.00,'',0.00,0.00,0.00,0.00,0.00,0.00,'','','','','',0,0,0,0,NULL,'','','','2020-01-01 00:00:00','','','',0,0,0,'2020-01-01 00:00:00',NULL,'',1,'',0,0),(5,'CUS-0005',0,0,'0000-00-00 00:00:00',0,0,'Dining Cash Customer','','','Dining Cash Customer','','',0,0.00,'',0.00,0.00,0.00,0.00,0.00,0.00,'','','','','',0,0,0,0,NULL,'','','','2020-01-01 00:00:00','','','',0,0,0,'2020-01-01 00:00:00',NULL,'',1,'',0,0),(6,'CUS-0006',0,0,'0000-00-00 00:00:00',0,0,'Dining Credit Card Customer','','','Dining Credit Card Customer','','',0,0.00,'',0.00,0.00,0.00,0.00,0.00,0.00,'','','','','',0,0,0,0,NULL,'','','','2020-01-01 00:00:00','','','',0,0,0,'2020-01-01 00:00:00',NULL,'',1,'',0,0),(7,'CUS-0007',0,0,'0000-00-00 00:00:00',0,0,'NAWALA BEVERAGE DIVISION','','','','','',0,0.00,'',0.00,0.00,0.00,0.00,0.00,0.00,'','','','','',0,0,0,0,NULL,'','','','2020-01-01 00:00:00','','','',0,0,0,'2020-01-01 00:00:00',NULL,'',1,'',0,0),(8,'CUS-0008',0,0,'0000-00-00 00:00:00',0,0,'NAWALA CUSTOMER','','','NAWALA CUSTOMER','','',0,0.00,'',0.00,0.00,0.00,0.00,0.00,0.00,'','','','','',0,0,0,0,NULL,'','','','2020-01-01 00:00:00','','','',0,0,0,'2020-01-01 00:00:00',NULL,'',1,'',0,0),(9,'CUS-0009',0,0,'0000-00-00 00:00:00',0,0,'NAWALA KITCHEN DIVISION','','','','','',0,0.00,'',0.00,0.00,0.00,0.00,0.00,0.00,'','','','','',0,0,0,0,NULL,'','','','2020-01-01 00:00:00','','','',0,0,0,'2020-01-01 00:00:00',NULL,'',1,'',0,0),(10,'CUS-0010',0,0,'0000-00-00 00:00:00',0,0,'UBER CUSTOMER','','','UBER CUSTOMER','','',0,0.00,'',0.00,0.00,0.00,0.00,0.00,0.00,'','','','','',0,0,0,0,NULL,'','','','2020-01-01 00:00:00','','','',0,0,0,'2020-01-01 00:00:00',NULL,'',1,'',0,0);
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`phpmyadmin`@`localhost`*/ /*!50003 TRIGGER `tbl_customers_AFTER_INSERT` AFTER INSERT ON `tbl_customers` FOR EACH ROW BEGIN
INSERT INTO `tbl_customers_log`
            (`customer_id`, 
             `code`,
             `updated_by`,
             `updated_on`,
             `created_by`,
             `created_on`, 
             `is_active`,
             `is_delete`,
             `customer_name`, 
             `email`,
             `display_name`,
             `address`,
             `category`,
             `payment`,
             `credit_period`,
             `credit_limit`,
             `vat_no`,
             `rpt_open_outstanding`,
             `rpt_invoice_amount`,
             `rpt_settlement_amount`,
             `rpt_return_amount`,
             `rpt_outstanding_amount`,
             `rpt_advance_payment`,
             `company_name`,
             `company_address`,
             `work_phone`,
             `remarks`,
             `mobile_no`,
             `handel_by`,
             `is_cash`,
             `is_credit`,
             `is_cheque`,
             `approve_datetime`,
             `approved_by`,
             `company_web`,
             `company_email`,
             `customer_history_generated_on`,
             `google_remark`,
             `facebook`,
             `how_knows`,
             `is_creditperiodexceededinvoicecreate`,
             `issend_creditperiodexceededinvoicecreaterequest`,
             `action`,
             `action_date`,
             `version`,
              `customer_title`)
VALUES      (new.customer_id,
             new.code,
             new.updated_by,
             new.updated_on,
             new.created_by,
             new.created_on,
             new.is_active,
             new.is_delete,
             new.customer_name,
             new.email,
             new.display_name,
             new.address,
             new.category,
             new.payment,
             new.credit_period,
             new.credit_limit,
             new.vat_no,
             new.rpt_open_outstanding,
             new.rpt_invoice_amount,
             new.rpt_settlement_amount,
             new.rpt_return_amount,
             new.rpt_outstanding_amount,
             new.rpt_advance_payment,
             new.company_name,
             new.company_address,
             new.work_phone,
             new.remarks,
             new.mobile_no,
             new.handel_by,
             new.is_cash,
             new.is_credit,
             new.is_cheque,
             new.approve_datetime,
             new.approved_by,
             new.company_web,
             new.company_email,
             new.customer_history_generated_on,
             new.google_remark,
             new.facebook,
             new.how_knows,
             new.is_creditperiodexceededinvoicecreate,
             new.issend_creditperiodexceededinvoicecreaterequest,
             'AFTER INSERT',
             Curdate(),
             new.version,
             new.customer_title); 

END */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`phpmyadmin`@`localhost`*/ /*!50003 TRIGGER `tbl_customers_BEFORE_UPDATE` BEFORE UPDATE ON `tbl_customers` FOR EACH ROW BEGIN

INSERT INTO `tbl_customers_log` 
            (`customer_id`, 
             `code`,
             `updated_by`,
             `updated_on`,
             `created_by`,
             `created_on`,
             `is_active`, 
             `is_delete`,
             `customer_name`,
             `email`,
             `display_name`,
             `address`,
             `category`,
             `payment`,
             `credit_period`,
             `credit_limit`,
             `vat_no`,
             `rpt_open_outstanding`,
             `rpt_invoice_amount`,
             `rpt_settlement_amount`,
             `rpt_return_amount`,
             `rpt_outstanding_amount`,
             `rpt_advance_payment`,
             `company_name`,
             `company_address`,
             `work_phone`,
             `remarks`,
             `mobile_no`,
             `handel_by`,
             `is_cash`,
             `is_credit`,
             `is_cheque`,
             `approve_datetime`,
             `approved_by`,
             `company_web`,
             `company_email`,
             `customer_history_generated_on`,
             `google_remark`,
             `facebook`,
             `how_knows`,
             `is_creditperiodexceededinvoicecreate`,
             `issend_creditperiodexceededinvoicecreaterequest`,
             `action`,
             `action_date`,
             `version`,
              `customer_title`)
VALUES      (old.customer_id,
             old.code,
             old.updated_by,
             old.updated_on,
             old.created_by,
             old.created_on,
             old.is_active,
             old.is_delete,
             old.customer_name,
             old.email,
             old.display_name,
             old.address,
             old.category,
             old.payment,
             old.credit_period,
             old.credit_limit,
             old.vat_no,
             old.rpt_open_outstanding,
             old.rpt_invoice_amount,
             old.rpt_settlement_amount,
             old.rpt_return_amount,
             old.rpt_outstanding_amount,
             old.rpt_advance_payment,
             old.company_name,
             old.company_address,
             old.work_phone,
             old.remarks,
             old.mobile_no,
             old.handel_by,
             old.is_cash,
             old.is_credit,
             old.is_cheque,
             old.approve_datetime,
             old.approved_by,
             old.company_web,
             old.company_email,
             old.customer_history_generated_on,
             old.google_remark,
             old.facebook,
             old.how_knows,
             old.is_creditperiodexceededinvoicecreate,
             old.issend_creditperiodexceededinvoicecreaterequest,
             'BEFORE UPDATE',
             Curdate(),
             old.version,
             old.customer_title); 
END */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`phpmyadmin`@`localhost`*/ /*!50003 TRIGGER `tbl_customers_BEFORE_DELETE` BEFORE DELETE ON `tbl_customers` FOR EACH ROW BEGIN
INSERT INTO `tbl_customers_log`
            (`customer_id`,  
             `code`, 
             `updated_by`,
             `updated_on`,
             `created_by`,
             `created_on`,
             `is_active`,
             `is_delete`, 
             `customer_name`,
             `email`,
             `display_name`,
             `address`,
             `category`,
             `payment`,
             `credit_period`,
             `credit_limit`,
             `vat_no`,
             `rpt_open_outstanding`,
             `rpt_invoice_amount`,
             `rpt_settlement_amount`,
             `rpt_return_amount`,
             `rpt_outstanding_amount`,
             `rpt_advance_payment`,
             `company_name`,
             `company_address`,
             `work_phone`,
             `remarks`,
             `mobile_no`,
             `handel_by`,
             `is_cash`,
             `is_credit`,
             `is_cheque`,
             `approve_datetime`,
             `approved_by`,
             `company_web`,
             `company_email`,
             `customer_history_generated_on`,
             `google_remark`,
             `facebook`,
             `how_knows`,
             `is_creditperiodexceededinvoicecreate`,
             `issend_creditperiodexceededinvoicecreaterequest`,
             `action`,
             `action_date`,
             `version`,
              `customer_title`)
VALUES      (old.customer_id,
             old.code,
             old.updated_by,
             old.updated_on,
             old.created_by,
             old.created_on,
             old.is_active,
             old.is_delete,
             old.customer_name,
             old.email,
             old.display_name,
             old.address,
             old.category,
             old.payment,
             old.credit_period,
             old.credit_limit,
             old.vat_no,
             old.rpt_open_outstanding,
             old.rpt_invoice_amount,
             old.rpt_settlement_amount,
             old.rpt_return_amount,
             old.rpt_outstanding_amount,
             old.rpt_advance_payment,
             old.company_name,
             old.company_address,
             old.work_phone,
             old.remarks,
             old.mobile_no,
             old.handel_by,
             old.is_cash,
             old.is_credit,
             old.is_cheque,
             old.approve_datetime,
             old.approved_by,
             old.company_web,
             old.company_email,
             old.customer_history_generated_on,
             old.google_remark,
             old.facebook,
             old.how_knows,
             old.is_creditperiodexceededinvoicecreate,
             old.issend_creditperiodexceededinvoicecreaterequest,
             'BEFORE DELETE',
             Curdate(),
             old.version,
             old.customer_title); 

END */;;
DELIMITER ;

--
-- Table structure for table `tbl_customers_log`
--

CREATE TABLE `tbl_customers_log` (
  `customer_id` int DEFAULT NULL,
  `code` varchar(50) DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  `updated_on` datetime DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `created_on` datetime DEFAULT NULL,
  `is_active` tinyint(1) DEFAULT '0',
  `is_delete` tinyint(1) DEFAULT '0',
  `customer_name` varchar(100) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `display_name` varchar(500) DEFAULT NULL,
  `address` varchar(500) DEFAULT NULL,
  `category` varchar(200) DEFAULT NULL,
  `payment` varchar(100) DEFAULT NULL,
  `credit_period` int DEFAULT NULL,
  `credit_limit` decimal(13,2) DEFAULT '0.00',
  `vat_no` varchar(50) DEFAULT NULL,
  `rpt_open_outstanding` decimal(13,2) DEFAULT NULL,
  `rpt_invoice_amount` decimal(13,2) DEFAULT NULL,
  `rpt_settlement_amount` decimal(13,2) DEFAULT NULL,
  `rpt_return_amount` decimal(13,2) DEFAULT NULL,
  `rpt_outstanding_amount` decimal(13,2) DEFAULT NULL,
  `rpt_advance_payment` decimal(13,2) DEFAULT NULL,
  `company_name` varchar(100) DEFAULT NULL,
  `company_address` varchar(500) DEFAULT NULL,
  `work_phone` varchar(50) DEFAULT NULL,
  `remarks` varchar(500) DEFAULT NULL,
  `mobile_no` varchar(50) DEFAULT NULL,
  `handel_by` int DEFAULT NULL,
  `is_cash` tinyint(1) DEFAULT NULL,
  `is_credit` tinyint(1) DEFAULT NULL,
  `is_cheque` tinyint(1) DEFAULT NULL,
  `approve_datetime` datetime DEFAULT NULL,
  `approved_by` varchar(50) DEFAULT NULL,
  `company_web` varchar(20) DEFAULT NULL,
  `company_email` varchar(20) DEFAULT NULL,
  `customer_history_generated_on` datetime DEFAULT '2020-01-01 00:00:00',
  `google_remark` varchar(50) DEFAULT NULL,
  `facebook` varchar(50) DEFAULT NULL,
  `how_knows` varchar(50) DEFAULT NULL,
  `is_creditPeriodExceededInvoiceCreate` tinyint(1) DEFAULT NULL,
  `isSend_creditPeriodExceededInvoiceCreateRequest` tinyint(1) DEFAULT '0',
  `version` int DEFAULT '0',
  `ACTION` varchar(50) DEFAULT NULL,
  `ACTION_DATE` date DEFAULT NULL,
  `customers_log_id` int NOT NULL AUTO_INCREMENT,
  `customer_title` varchar(100) NOT NULL,
  PRIMARY KEY (`customers_log_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_customers_log`
--


--
-- Table structure for table `tbl_daily_cash`
--

CREATE TABLE `tbl_daily_cash` (
  `id` int NOT NULL AUTO_INCREMENT,
  `description` varchar(1000) NOT NULL,
  `amount` decimal(16,2) NOT NULL,
  `type_id` int NOT NULL,
  `created_on` datetime NOT NULL,
  `created_by` int NOT NULL,
  `cash_in_date` date NOT NULL,
  `is_remove` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_daily_cash`
--


--
-- Table structure for table `tbl_daily_cash_types`
--

CREATE TABLE `tbl_daily_cash_types` (
  `id` int NOT NULL AUTO_INCREMENT,
  `type` varchar(1000) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_daily_cash_types`
--


--
-- Table structure for table `tbl_daily_production`
--

CREATE TABLE `tbl_daily_production` (
  `id` int NOT NULL AUTO_INCREMENT,
  `plan_id` int NOT NULL,
  `process_id` int NOT NULL,
  `completed_date` date NOT NULL,
  `qty` decimal(16,6) NOT NULL,
  `created_by` int NOT NULL,
  `created_on` datetime NOT NULL,
  `tree_id` varchar(50) NOT NULL,
  `boqId` int NOT NULL,
  `product_id` int NOT NULL,
  `note` varchar(5000) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_daily_production`
--


--
-- Table structure for table `tbl_damage`
--

CREATE TABLE `tbl_damage` (
  `damage_id` int NOT NULL AUTO_INCREMENT,
  `code` varchar(50) NOT NULL,
  `description` varchar(500) NOT NULL,
  `damage_date` date NOT NULL,
  `status` varchar(500) NOT NULL,
  `updated_by` int NOT NULL,
  `updated_on` datetime NOT NULL,
  `created_by` int NOT NULL,
  `created_on` datetime NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `is_delete` tinyint(1) NOT NULL DEFAULT '0',
  `location_id` int NOT NULL DEFAULT '0',
  `grn_id` int NOT NULL,
  PRIMARY KEY (`damage_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_damage`
--


--
-- Table structure for table `tbl_damage_details`
--

CREATE TABLE `tbl_damage_details` (
  `id` int NOT NULL AUTO_INCREMENT,
  `parent_id` int NOT NULL,
  `field_name` varchar(50) NOT NULL,
  `field_value` varchar(5000) NOT NULL,
  `created_by` int NOT NULL,
  `created_on` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_damage_details`
--


--
-- Table structure for table `tbl_damage_products`
--

CREATE TABLE `tbl_damage_products` (
  `damage_product_id` int NOT NULL AUTO_INCREMENT,
  `damage_id` int NOT NULL,
  `product_id` int NOT NULL,
  `qty` decimal(18,6) NOT NULL,
  `created_by` int NOT NULL,
  `created_on` datetime NOT NULL,
  `updated_by` int NOT NULL,
  `updated_on` datetime NOT NULL,
  `is_delete` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`damage_product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_damage_products`
--


--
-- Table structure for table `tbl_database_backups`
--

CREATE TABLE `tbl_database_backups` (
  `id` int NOT NULL AUTO_INCREMENT,
  `created_on` datetime NOT NULL,
  `created_by` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_database_backups`
--


--
-- Table structure for table `tbl_dispatch`
--

CREATE TABLE `tbl_dispatch` (
  `dispatch_id` int NOT NULL AUTO_INCREMENT,
  `code` varchar(50) NOT NULL,
  `description` varchar(500) NOT NULL,
  `so_id` int NOT NULL,
  `dispatch_date` date NOT NULL,
  `status` varchar(50) NOT NULL,
  `updated_by` int NOT NULL,
  `updated_on` datetime NOT NULL,
  `created_by` int NOT NULL,
  `created_on` datetime NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `is_delete` tinyint(1) NOT NULL DEFAULT '0',
  `dis_type` varchar(10) NOT NULL,
  `discount_rate` decimal(11,2) NOT NULL,
  `discount` decimal(11,2) NOT NULL,
  `sub_total` decimal(11,2) NOT NULL,
  `total` decimal(11,2) NOT NULL,
  `location_id` int NOT NULL,
  `currency_id` int NOT NULL,
  `exchange_rate` decimal(16,2) NOT NULL,
  PRIMARY KEY (`dispatch_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_dispatch`
--


--
-- Table structure for table `tbl_dispatch_details`
--

CREATE TABLE `tbl_dispatch_details` (
  `id` int NOT NULL AUTO_INCREMENT,
  `parent_id` int NOT NULL,
  `field_name` varchar(50) NOT NULL,
  `field_value` varchar(5000) NOT NULL,
  `created_by` int NOT NULL,
  `created_on` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_dispatch_details`
--


--
-- Table structure for table `tbl_dispatch_products`
--

CREATE TABLE `tbl_dispatch_products` (
  `dispatch_products_id` int NOT NULL AUTO_INCREMENT,
  `dispatch_id` int NOT NULL,
  `so_id` int NOT NULL,
  `so_product_id` int NOT NULL,
  `product_id` int NOT NULL,
  `so_qty` decimal(11,6) NOT NULL,
  `qty` decimal(11,6) NOT NULL,
  `created_by` int NOT NULL,
  `created_on` datetime NOT NULL,
  `updated_by` int NOT NULL,
  `updated_on` datetime NOT NULL,
  `is_delete` tinyint(1) NOT NULL DEFAULT '0',
  `unitPrice` decimal(11,2) NOT NULL,
  `total` decimal(11,2) NOT NULL,
  `status` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`dispatch_products_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_dispatch_products`
--


--
-- Table structure for table `tbl_district`
--

CREATE TABLE `tbl_district` (
  `district_id` int NOT NULL AUTO_INCREMENT,
  `district` varchar(45) DEFAULT NULL,
  `sinhala_district_name` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  PRIMARY KEY (`district_id`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_district`
--

INSERT INTO `tbl_district` VALUES (1,'01 - Ampara','01 - අම්පාර'),(2,'02 - Anuradhapura',''),(3,'03 - Badulla',''),(4,'04 - Batticaloa',''),(5,'05 - Colombo',''),(6,'06 - Galle',''),(7,'07 - Gampaha',''),(8,'08 - Hambantota',''),(9,'09 - Jaffna',''),(10,'10 - Kalutara',''),(11,'11 - Kandy',''),(12,'12 - Kegalle',''),(13,'13 - Kilinochchi',''),(14,'14 - Kurunegala',''),(15,'15 - Mannar',''),(16,'16 - Matale',''),(17,'17 - Matara',''),(18,'18 - Moneragala',''),(19,'19 - Mullaitivu',''),(20,'20 - Nuwara Eliya',''),(21,'21 - Polonnaruwa',''),(22,'22 - Puttalam',''),(23,'23 - Ratnapura',''),(24,'24 - Trincomalee',''),(25,'25 - Vavuniya','');

--
-- Table structure for table `tbl_documents`
--

CREATE TABLE `tbl_documents` (
  `doc_id` int NOT NULL AUTO_INCREMENT,
  `content_id` int NOT NULL,
  `note` varchar(500) NOT NULL,
  `doc_type` varchar(50) NOT NULL,
  `doc_path` varchar(500) NOT NULL,
  `create_by` int NOT NULL,
  `created_datetime` datetime NOT NULL,
  PRIMARY KEY (`doc_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_documents`
--


--
-- Table structure for table `tbl_employee`
--

CREATE TABLE `tbl_employee` (
  `employee_id` int NOT NULL AUTO_INCREMENT,
  `code` varchar(50) NOT NULL,
  `name` varchar(500) NOT NULL,
  `description` varchar(500) NOT NULL,
  `updated_by` int NOT NULL,
  `updated_on` datetime NOT NULL,
  `created_by` int NOT NULL,
  `created_on` datetime NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `is_delete` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`employee_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_employee`
--


--
-- Table structure for table `tbl_employee_other_details`
--

CREATE TABLE `tbl_employee_other_details` (
  `id` int NOT NULL AUTO_INCREMENT,
  `parent_id` int NOT NULL,
  `field_name` varchar(50) NOT NULL,
  `field_value` varchar(5000) NOT NULL,
  `created_by` int NOT NULL,
  `created_on` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_employee_other_details`
--


--
-- Table structure for table `tbl_estimate`
--

CREATE TABLE `tbl_estimate` (
  `estimate_id` int NOT NULL AUTO_INCREMENT,
  `estimate_type` varchar(100) NOT NULL,
  `job_no` varchar(20) NOT NULL,
  `insurance_id` int NOT NULL,
  `job_type` varchar(100) NOT NULL,
  `sub_total` decimal(13,2) NOT NULL,
  `dis_type` varchar(50) NOT NULL,
  `discount_rate` decimal(13,2) NOT NULL,
  `discount_amount` decimal(13,2) NOT NULL,
  `tax_type` varchar(50) NOT NULL,
  `tax_rate` decimal(13,2) NOT NULL,
  `tax_amount` decimal(13,2) NOT NULL,
  `total` decimal(13,2) NOT NULL,
  `date_time` datetime NOT NULL,
  `work_type` varchar(200) NOT NULL,
  `customer_id` int DEFAULT NULL,
  `code` varchar(100) NOT NULL,
  `vehicle_id` int NOT NULL,
  `created_by` int NOT NULL,
  `created_on` datetime NOT NULL DEFAULT '2021-01-01 00:00:01',
  `status` varchar(50) NOT NULL,
  `job_type_id` int NOT NULL,
  PRIMARY KEY (`estimate_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_estimate`
--


--
-- Table structure for table `tbl_estimate_details`
--

CREATE TABLE `tbl_estimate_details` (
  `estimate_details_id` int NOT NULL AUTO_INCREMENT,
  `job` varchar(200) NOT NULL,
  `work_type_id` int NOT NULL,
  `part_type` varchar(150) NOT NULL,
  `description` varchar(500) NOT NULL,
  `qty` int NOT NULL,
  `dis_type` varchar(50) NOT NULL,
  `dis_rate` decimal(13,2) NOT NULL,
  `discount` decimal(13,2) NOT NULL,
  `tax_type` varchar(50) NOT NULL,
  `tax_rate` decimal(13,2) NOT NULL,
  `tax` decimal(13,2) NOT NULL,
  `price` decimal(13,2) NOT NULL,
  `total` decimal(13,2) NOT NULL,
  `insurance` varchar(100) NOT NULL,
  `estimate_id` int NOT NULL,
  `type` varchar(50) NOT NULL,
  `product_name` varchar(1000) NOT NULL,
  `uomId` int NOT NULL,
  `uom` varchar(50) NOT NULL,
  `uomValue` decimal(11,2) NOT NULL,
  PRIMARY KEY (`estimate_details_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_estimate_details`
--


--
-- Table structure for table `tbl_expenses`
--

CREATE TABLE `tbl_expenses` (
  `id` int NOT NULL AUTO_INCREMENT,
  `code` varchar(50) NOT NULL,
  `status` varchar(50) NOT NULL,
  `description` varchar(1000) NOT NULL,
  `date` date NOT NULL,
  `type_id` int NOT NULL,
  `updated_by` int NOT NULL,
  `updated_on` datetime NOT NULL,
  `created_by` int NOT NULL,
  `created_on` datetime NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `is_delete` tinyint(1) NOT NULL DEFAULT '0',
  `amount` decimal(16,2) NOT NULL,
  `branch_id` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_expenses`
--


--
-- Table structure for table `tbl_expenses_details`
--

CREATE TABLE `tbl_expenses_details` (
  `id` int NOT NULL AUTO_INCREMENT,
  `parent_id` int NOT NULL,
  `field_name` varchar(50) NOT NULL,
  `field_value` varchar(5000) NOT NULL,
  `created_by` int NOT NULL,
  `created_on` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_expenses_details`
--


--
-- Table structure for table `tbl_expenses_type`
--

CREATE TABLE `tbl_expenses_type` (
  `id` int NOT NULL AUTO_INCREMENT,
  `code` varchar(50) NOT NULL,
  `type` varchar(50) NOT NULL,
  `description` varchar(500) NOT NULL,
  `updated_by` int NOT NULL,
  `updated_on` datetime NOT NULL,
  `created_by` int NOT NULL,
  `created_on` datetime NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `is_delete` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_expenses_type`
--


--
-- Table structure for table `tbl_expenses_type_details`
--

CREATE TABLE `tbl_expenses_type_details` (
  `id` int NOT NULL AUTO_INCREMENT,
  `parent_id` int NOT NULL,
  `field_name` varchar(50) NOT NULL,
  `field_value` varchar(5000) NOT NULL,
  `created_by` int NOT NULL,
  `created_on` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_expenses_type_details`
--


--
-- Table structure for table `tbl_field_type`
--

CREATE TABLE `tbl_field_type` (
  `id` int NOT NULL AUTO_INCREMENT,
  `field_type` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_field_type`
--

INSERT INTO `tbl_field_type` VALUES (1,'Textbox'),(2,'Date'),(3,'Checkbox'),(4,'Dropdown'),(5,'Ajax Dropdown'),(6,'Multiple Dropdown');

--
-- Table structure for table `tbl_fn_discount_accounts`
--

CREATE TABLE `tbl_fn_discount_accounts` (
  `id` int NOT NULL AUTO_INCREMENT,
  `rate` decimal(10,2) NOT NULL,
  `account` varchar(100) NOT NULL,
  `name` varchar(1000) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_fn_discount_accounts`
--

INSERT INTO `tbl_fn_discount_accounts` VALUES (1,10.00,'241','Cash Customers Discount'),(2,25.00,'244','COLOMBO Staff Discount -25'),(3,50.00,'242','Directors Discount-50'),(4,100.00,'243','COLOMBO Loyalty Card Customer');

--
-- Table structure for table `tbl_gas_pump_reading`
--

CREATE TABLE `tbl_gas_pump_reading` (
  `id` int NOT NULL AUTO_INCREMENT,
  `code` varchar(50) NOT NULL,
  `description` varchar(500) NOT NULL,
  `reading_date` date NOT NULL,
  `status` varchar(500) NOT NULL,
  `updated_by` int NOT NULL,
  `updated_on` datetime NOT NULL,
  `created_by` int NOT NULL,
  `created_on` datetime NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `is_delete` tinyint(1) NOT NULL DEFAULT '0',
  `location_id` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_gas_pump_reading`
--


--
-- Table structure for table `tbl_gas_pump_reading_details`
--

CREATE TABLE `tbl_gas_pump_reading_details` (
  `id` int NOT NULL AUTO_INCREMENT,
  `parent_id` int NOT NULL,
  `field_name` varchar(50) NOT NULL,
  `field_value` varchar(5000) NOT NULL,
  `created_by` int NOT NULL,
  `created_on` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_gas_pump_reading_details`
--


--
-- Table structure for table `tbl_gas_pump_reading_pumps`
--

CREATE TABLE `tbl_gas_pump_reading_pumps` (
  `id` int NOT NULL AUTO_INCREMENT,
  `pump_reading_id` int NOT NULL,
  `product_id` int NOT NULL,
  `pump_id` int NOT NULL,
  `pump_start` decimal(18,6) NOT NULL,
  `pump_end` decimal(18,6) NOT NULL,
  `deference` decimal(18,6) NOT NULL,
  `note` varchar(500) NOT NULL,
  `unitPrice` decimal(16,2) NOT NULL DEFAULT '0.00',
  `amount` decimal(16,2) NOT NULL DEFAULT '0.00',
  `created_by` int NOT NULL,
  `created_on` datetime NOT NULL,
  `updated_by` int NOT NULL,
  `updated_on` datetime NOT NULL,
  `is_delete` tinyint(1) NOT NULL DEFAULT '0',
  `status` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_gas_pump_reading_pumps`
--


--
-- Table structure for table `tbl_gas_pump_receipt`
--

CREATE TABLE `tbl_gas_pump_receipt` (
  `id` int NOT NULL AUTO_INCREMENT,
  `code` varchar(50) NOT NULL,
  `description` varchar(500) NOT NULL,
  `receipt_date` date NOT NULL,
  `status` varchar(500) NOT NULL,
  `customer_id` int NOT NULL,
  `dis_type` varchar(50) NOT NULL,
  `discount_rate` decimal(16,2) NOT NULL DEFAULT '0.00',
  `discount` decimal(16,2) NOT NULL DEFAULT '0.00',
  `sub_total` decimal(16,2) NOT NULL DEFAULT '0.00',
  `total` decimal(16,2) NOT NULL DEFAULT '0.00',
  `updated_by` int NOT NULL,
  `updated_on` datetime NOT NULL,
  `created_by` int NOT NULL,
  `created_on` datetime NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `is_delete` tinyint(1) NOT NULL DEFAULT '0',
  `location_id` int NOT NULL DEFAULT '0',
  `vehicle_id` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_gas_pump_receipt`
--


--
-- Table structure for table `tbl_gas_pump_receipt_details`
--

CREATE TABLE `tbl_gas_pump_receipt_details` (
  `id` int NOT NULL AUTO_INCREMENT,
  `parent_id` int NOT NULL,
  `field_name` varchar(50) NOT NULL,
  `field_value` varchar(5000) NOT NULL,
  `created_by` int NOT NULL,
  `created_on` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_gas_pump_receipt_details`
--


--
-- Table structure for table `tbl_gas_pump_receipt_products`
--

CREATE TABLE `tbl_gas_pump_receipt_products` (
  `id` int NOT NULL AUTO_INCREMENT,
  `receipt_id` int NOT NULL,
  `product_id` int NOT NULL,
  `qty` decimal(18,6) NOT NULL,
  `note` varchar(500) NOT NULL,
  `unitPrice` decimal(16,2) NOT NULL DEFAULT '0.00',
  `total` decimal(16,2) NOT NULL DEFAULT '0.00',
  `created_by` int NOT NULL,
  `created_on` datetime NOT NULL,
  `updated_by` int NOT NULL,
  `updated_on` datetime NOT NULL,
  `is_delete` tinyint(1) NOT NULL DEFAULT '0',
  `status` varchar(50) NOT NULL,
  `pump_id` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_gas_pump_receipt_products`
--


--
-- Table structure for table `tbl_gas_pumps`
--

CREATE TABLE `tbl_gas_pumps` (
  `id` int NOT NULL AUTO_INCREMENT,
  `code` varchar(50) NOT NULL,
  `description` varchar(500) NOT NULL,
  `updated_by` int NOT NULL,
  `updated_on` datetime NOT NULL,
  `created_by` int NOT NULL,
  `created_on` datetime NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `is_delete` tinyint(1) NOT NULL DEFAULT '0',
  `serial_no` varchar(100) NOT NULL DEFAULT '',
  `image` varchar(500) NOT NULL DEFAULT 'dist/img/empty.png',
  `product_id` int NOT NULL,
  `location_id` int NOT NULL,
  `meter_reading` decimal(16,2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_gas_pumps`
--


--
-- Table structure for table `tbl_gas_pumps_details`
--

CREATE TABLE `tbl_gas_pumps_details` (
  `id` int NOT NULL AUTO_INCREMENT,
  `parent_id` int NOT NULL,
  `field_name` varchar(50) NOT NULL,
  `field_value` varchar(5000) NOT NULL,
  `created_by` int NOT NULL,
  `created_on` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_gas_pumps_details`
--


--
-- Table structure for table `tbl_grn_import_charges`
--

CREATE TABLE `tbl_grn_import_charges` (
  `id` int NOT NULL AUTO_INCREMENT,
  `charge_id` int NOT NULL,
  `amount` decimal(16,2) NOT NULL,
  `grn_id` int NOT NULL,
  `note` varchar(1000) NOT NULL,
  `created_by` int NOT NULL,
  `created_on` datetime NOT NULL,
  `is_delete` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_grn_import_charges`
--


--
-- Table structure for table `tbl_grn_import_product_duties`
--

CREATE TABLE `tbl_grn_import_product_duties` (
  `id` int NOT NULL AUTO_INCREMENT,
  `duty_id` int NOT NULL,
  `base_amount` decimal(16,2) NOT NULL,
  `rate` decimal(16,2) NOT NULL,
  `hs_code` varchar(11) NOT NULL,
  `uni_id` varchar(1000) NOT NULL,
  `grn_id` int NOT NULL,
  `created_by` int NOT NULL,
  `created_on` datetime NOT NULL,
  `amount` decimal(16,2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_grn_import_product_duties`
--


--
-- Table structure for table `tbl_grn_import_products`
--

CREATE TABLE `tbl_grn_import_products` (
  `grn_product_id` int NOT NULL AUTO_INCREMENT,
  `grn_id` int NOT NULL,
  `po_id` int NOT NULL,
  `po_product_id` int NOT NULL,
  `product_id` int NOT NULL,
  `po_qty` decimal(18,6) NOT NULL,
  `qty` decimal(18,6) NOT NULL,
  `created_by` int NOT NULL,
  `created_on` datetime NOT NULL,
  `updated_by` int NOT NULL,
  `updated_on` datetime NOT NULL,
  `is_delete` tinyint(1) NOT NULL DEFAULT '0',
  `unitPrice` decimal(11,4) NOT NULL,
  `total` decimal(11,4) NOT NULL,
  `status` varchar(50) NOT NULL DEFAULT '',
  `discountType` varchar(10) NOT NULL,
  `discountRate` decimal(11,2) NOT NULL,
  `discount` decimal(11,2) NOT NULL,
  `inventoryFreeQty` decimal(11,2) NOT NULL,
  `tax` varchar(500) NOT NULL DEFAULT '',
  `tax_amount` decimal(16,2) NOT NULL DEFAULT '0.00',
  `hs_code` varchar(1000) NOT NULL,
  `total_chargers` decimal(18,2) NOT NULL DEFAULT '0.00',
  `total_duty` decimal(18,2) NOT NULL DEFAULT '0.00',
  `lkr_unitCost` decimal(18,2) NOT NULL DEFAULT '0.00',
  `retail_price` decimal(16,2) NOT NULL,
  `retail_margin` decimal(16,2) NOT NULL,
  `calculated_cost` decimal(16,2) NOT NULL,
  `item_charges` decimal(16,2) NOT NULL,
  `item_duties` decimal(16,2) NOT NULL,
  `lkr_price` decimal(16,2) NOT NULL,
  PRIMARY KEY (`grn_product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_grn_import_products`
--


--
-- Table structure for table `tbl_grn_import_return`
--

CREATE TABLE `tbl_grn_import_return` (
  `grn_return_id` int NOT NULL AUTO_INCREMENT,
  `code` varchar(50) NOT NULL,
  `description` varchar(500) NOT NULL,
  `return_date` date NOT NULL,
  `status` varchar(500) NOT NULL,
  `supplier_id` int NOT NULL,
  `dis_type` varchar(50) NOT NULL,
  `discount_rate` decimal(16,2) NOT NULL DEFAULT '0.00',
  `discount` decimal(16,2) NOT NULL DEFAULT '0.00',
  `sub_total` decimal(16,2) NOT NULL DEFAULT '0.00',
  `total` decimal(16,2) NOT NULL DEFAULT '0.00',
  `updated_by` int NOT NULL,
  `updated_on` datetime NOT NULL,
  `created_by` int NOT NULL,
  `created_on` datetime NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `is_delete` tinyint(1) NOT NULL DEFAULT '0',
  `location_id` int NOT NULL DEFAULT '0',
  `currency_id` int NOT NULL DEFAULT '0',
  `exchange_rate` decimal(16,2) NOT NULL DEFAULT '0.00',
  `grn_id` int NOT NULL,
  PRIMARY KEY (`grn_return_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_grn_import_return`
--


--
-- Table structure for table `tbl_grn_import_return_details`
--

CREATE TABLE `tbl_grn_import_return_details` (
  `id` int NOT NULL AUTO_INCREMENT,
  `parent_id` int NOT NULL,
  `field_name` varchar(50) NOT NULL,
  `field_value` varchar(5000) NOT NULL,
  `created_by` int NOT NULL,
  `created_on` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_grn_import_return_details`
--


--
-- Table structure for table `tbl_grn_import_return_products`
--

CREATE TABLE `tbl_grn_import_return_products` (
  `return_product_id` int NOT NULL AUTO_INCREMENT,
  `grn_return_id` int NOT NULL,
  `product_id` int NOT NULL,
  `qty` decimal(18,6) NOT NULL,
  `note` varchar(500) NOT NULL,
  `unitPrice` decimal(16,2) NOT NULL DEFAULT '0.00',
  `total` decimal(16,2) NOT NULL DEFAULT '0.00',
  `created_by` int NOT NULL,
  `created_on` datetime NOT NULL,
  `updated_by` int NOT NULL,
  `updated_on` datetime NOT NULL,
  `is_delete` tinyint(1) NOT NULL DEFAULT '0',
  `status` varchar(50) NOT NULL,
  PRIMARY KEY (`return_product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_grn_import_return_products`
--


--
-- Table structure for table `tbl_grn_imports`
--

CREATE TABLE `tbl_grn_imports` (
  `grn_id` int NOT NULL AUTO_INCREMENT,
  `code` varchar(50) NOT NULL,
  `description` varchar(500) NOT NULL,
  `po_id` int NOT NULL,
  `grn_date` date NOT NULL,
  `status` varchar(50) NOT NULL,
  `updated_by` int NOT NULL,
  `updated_on` datetime NOT NULL,
  `created_by` int NOT NULL,
  `created_on` datetime NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `is_delete` tinyint(1) NOT NULL DEFAULT '0',
  `dis_type` varchar(10) NOT NULL,
  `discount_rate` decimal(11,2) NOT NULL,
  `discount` decimal(11,2) NOT NULL,
  `sub_total` decimal(11,2) NOT NULL,
  `total` decimal(11,2) NOT NULL,
  `location_id` int NOT NULL,
  `currency_id` int NOT NULL DEFAULT '0',
  `exchange_rate` decimal(16,4) NOT NULL DEFAULT '0.0000',
  `supplier_id` int NOT NULL,
  `sgrn_id` int NOT NULL DEFAULT '0',
  `grnType` varchar(100) NOT NULL DEFAULT 'with_po',
  `supplier_invoice_ref` varchar(100) NOT NULL,
  `suplier_invoice_date` date NOT NULL,
  `supplier_invoice_date` date NOT NULL,
  `tax` varchar(500) NOT NULL DEFAULT '',
  `tax_amount` decimal(16,2) NOT NULL,
  `vat_rate` decimal(16,2) NOT NULL,
  `total_charges` decimal(16,2) NOT NULL,
  `total_duties` decimal(16,2) NOT NULL,
  `tax_type` varchar(100) NOT NULL DEFAULT 'Exclusive',
  PRIMARY KEY (`grn_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_grn_imports`
--


--
-- Table structure for table `tbl_grn_imports_details`
--

CREATE TABLE `tbl_grn_imports_details` (
  `id` int NOT NULL AUTO_INCREMENT,
  `parent_id` int NOT NULL,
  `field_name` varchar(50) NOT NULL,
  `field_value` varchar(5000) NOT NULL,
  `created_by` int NOT NULL,
  `created_on` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_grn_imports_details`
--


--
-- Table structure for table `tbl_grn_products`
--

CREATE TABLE `tbl_grn_products` (
  `grn_product_id` int NOT NULL AUTO_INCREMENT,
  `grn_id` int NOT NULL,
  `po_id` int NOT NULL,
  `po_product_id` int NOT NULL,
  `product_id` int NOT NULL,
  `po_qty` decimal(18,6) NOT NULL,
  `qty` decimal(18,6) NOT NULL,
  `created_by` int NOT NULL,
  `created_on` datetime NOT NULL,
  `updated_by` int NOT NULL,
  `updated_on` datetime NOT NULL,
  `is_delete` tinyint(1) NOT NULL DEFAULT '0',
  `unitPrice` decimal(11,4) NOT NULL,
  `total` decimal(11,4) NOT NULL,
  `status` varchar(50) NOT NULL DEFAULT '',
  `discountType` varchar(10) NOT NULL,
  `discountRate` decimal(11,2) NOT NULL,
  `discount` decimal(11,2) NOT NULL,
  `inventoryFreeQty` decimal(11,2) NOT NULL,
  `tax_amount` decimal(16,2) NOT NULL DEFAULT '0.00',
  `tax` int NOT NULL DEFAULT '0',
  `retail_price` decimal(16,2) NOT NULL,
  `retail_margin` decimal(16,2) NOT NULL,
  PRIMARY KEY (`grn_product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_grn_products`
--


--
-- Table structure for table `tbl_grn_return`
--

CREATE TABLE `tbl_grn_return` (
  `grn_return_id` int NOT NULL AUTO_INCREMENT,
  `code` varchar(50) NOT NULL,
  `description` varchar(500) NOT NULL,
  `return_date` date NOT NULL,
  `status` varchar(500) NOT NULL,
  `supplier_id` int NOT NULL,
  `dis_type` varchar(50) NOT NULL,
  `discount_rate` decimal(16,2) NOT NULL DEFAULT '0.00',
  `discount` decimal(16,2) NOT NULL DEFAULT '0.00',
  `sub_total` decimal(16,2) NOT NULL DEFAULT '0.00',
  `total` decimal(16,2) NOT NULL DEFAULT '0.00',
  `updated_by` int NOT NULL,
  `updated_on` datetime NOT NULL,
  `created_by` int NOT NULL,
  `created_on` datetime NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `is_delete` tinyint(1) NOT NULL DEFAULT '0',
  `location_id` int NOT NULL DEFAULT '0',
  `currency_id` int NOT NULL DEFAULT '0',
  `exchange_rate` decimal(16,2) NOT NULL DEFAULT '0.00',
  `grn_id` int NOT NULL,
  PRIMARY KEY (`grn_return_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_grn_return`
--


--
-- Table structure for table `tbl_grn_return_details`
--

CREATE TABLE `tbl_grn_return_details` (
  `id` int NOT NULL AUTO_INCREMENT,
  `parent_id` int NOT NULL,
  `field_name` varchar(50) NOT NULL,
  `field_value` varchar(5000) NOT NULL,
  `created_by` int NOT NULL,
  `created_on` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_grn_return_details`
--


--
-- Table structure for table `tbl_grn_return_products`
--

CREATE TABLE `tbl_grn_return_products` (
  `return_product_id` int NOT NULL AUTO_INCREMENT,
  `grn_return_id` int NOT NULL,
  `product_id` int NOT NULL,
  `qty` decimal(18,6) NOT NULL,
  `note` varchar(500) NOT NULL,
  `unitPrice` decimal(16,2) NOT NULL DEFAULT '0.00',
  `total` decimal(16,2) NOT NULL DEFAULT '0.00',
  `created_by` int NOT NULL,
  `created_on` datetime NOT NULL,
  `updated_by` int NOT NULL,
  `updated_on` datetime NOT NULL,
  `is_delete` tinyint(1) NOT NULL DEFAULT '0',
  `status` varchar(50) NOT NULL,
  PRIMARY KEY (`return_product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_grn_return_products`
--


--
-- Table structure for table `tbl_grns`
--

CREATE TABLE `tbl_grns` (
  `grn_id` int NOT NULL AUTO_INCREMENT,
  `code` varchar(50) NOT NULL,
  `description` varchar(500) NOT NULL,
  `po_id` int NOT NULL,
  `grn_date` date NOT NULL,
  `status` varchar(50) NOT NULL,
  `updated_by` int NOT NULL,
  `updated_on` datetime NOT NULL,
  `created_by` int NOT NULL,
  `created_on` datetime NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `is_delete` tinyint(1) NOT NULL DEFAULT '0',
  `dis_type` varchar(10) NOT NULL,
  `discount_rate` decimal(11,2) NOT NULL,
  `discount` decimal(11,2) NOT NULL,
  `sub_total` decimal(11,2) NOT NULL,
  `total` decimal(11,2) NOT NULL,
  `location_id` int NOT NULL,
  `currency_id` int NOT NULL DEFAULT '0',
  `exchange_rate` decimal(16,4) NOT NULL DEFAULT '0.0000',
  `supplier_id` int NOT NULL,
  `sgrn_id` int NOT NULL DEFAULT '0',
  `grnType` varchar(100) NOT NULL DEFAULT 'with_po',
  `supplier_invoice_ref` varchar(100) NOT NULL,
  `supplier_invoice_date` date NOT NULL,
  `tax_amount` decimal(16,2) NOT NULL,
  `tax` varchar(100) NOT NULL DEFAULT '',
  `tax_type` varchar(100) NOT NULL DEFAULT 'Exclusive',
  `transport` decimal(16,2) NOT NULL,
  `is_direct_purchase` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`grn_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_grns`
--


--
-- Table structure for table `tbl_grns_details`
--

CREATE TABLE `tbl_grns_details` (
  `id` int NOT NULL AUTO_INCREMENT,
  `parent_id` int NOT NULL,
  `field_name` varchar(50) NOT NULL,
  `field_value` varchar(5000) NOT NULL,
  `created_by` int NOT NULL,
  `created_on` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_grns_details`
--


--
-- Table structure for table `tbl_hold_log`
--

CREATE TABLE `tbl_hold_log` (
  `id` int NOT NULL AUTO_INCREMENT,
  `type` varchar(100) NOT NULL,
  `parent_id` int NOT NULL,
  `hold_by` int NOT NULL,
  `hold_on` datetime NOT NULL,
  `is_hold` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_hold_log`
--

INSERT INTO `tbl_hold_log` VALUES (1,'',0,77,'2025-10-28 00:00:00',1),(2,'',0,77,'2025-10-28 00:00:00',0);

--
-- Table structure for table `tbl_import_charges_types`
--

CREATE TABLE `tbl_import_charges_types` (
  `id` int NOT NULL AUTO_INCREMENT,
  `type` varchar(1000) NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `is_delete` tinyint(1) NOT NULL DEFAULT '0',
  `created_by` int NOT NULL,
  `created_on` datetime NOT NULL,
  `updated_by` int NOT NULL,
  `updated_on` datetime NOT NULL,
  `description` varchar(1000) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_import_charges_types`
--


--
-- Table structure for table `tbl_import_duties`
--

CREATE TABLE `tbl_import_duties` (
  `id` int NOT NULL AUTO_INCREMENT,
  `duty` varchar(1000) NOT NULL,
  `rate` decimal(16,2) NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `is_delete` tinyint(1) NOT NULL DEFAULT '0',
  `created_by` int NOT NULL,
  `created_on` datetime NOT NULL,
  `updated_by` int NOT NULL,
  `updated_on` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_import_duties`
--


--
-- Table structure for table `tbl_inquiry_mode`
--

CREATE TABLE `tbl_inquiry_mode` (
  `inquiry_mode_id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`inquiry_mode_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_inquiry_mode`
--


--
-- Table structure for table `tbl_insuarance`
--

CREATE TABLE `tbl_insuarance` (
  `insuarance_id` int NOT NULL AUTO_INCREMENT,
  `insuarance_company_name` varchar(300) NOT NULL,
  `insuarance_contact_person` varchar(100) NOT NULL,
  `insuarance_contact_no` varchar(30) NOT NULL,
  `insurance_address` varchar(200) NOT NULL,
  `email` varchar(200) NOT NULL,
  `is_active` tinyint NOT NULL DEFAULT '1',
  `insuarance_company_name_long` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`insuarance_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_insuarance`
--


--
-- Table structure for table `tbl_inventory`
--

CREATE TABLE `tbl_inventory` (
  `inventory_id` int NOT NULL AUTO_INCREMENT,
  `location_id` int NOT NULL DEFAULT '0',
  `container_id` int NOT NULL DEFAULT '0',
  `product_id` int NOT NULL,
  `qty_in_stock` decimal(18,6) DEFAULT '0.000000',
  `qty_on_order` decimal(18,6) DEFAULT '0.000000',
  `qty_reserved` decimal(18,6) DEFAULT '0.000000',
  `qty_allocated` decimal(18,6) DEFAULT '0.000000',
  `created_by` varchar(50) DEFAULT '',
  `created_date_time` datetime(3) DEFAULT CURRENT_TIMESTAMP(3),
  `modified_by` varchar(50) DEFAULT '',
  `modified_date_time` datetime(3) DEFAULT CURRENT_TIMESTAMP(3),
  PRIMARY KEY (`inventory_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_inventory`
--


--
-- Table structure for table `tbl_inventory_log`
--

CREATE TABLE `tbl_inventory_log` (
  `log_id` int NOT NULL AUTO_INCREMENT,
  `location_id` int NOT NULL DEFAULT '0',
  `container_id` int NOT NULL DEFAULT '0',
  `product_id` int NOT NULL,
  `qty_in_stock` decimal(18,6) DEFAULT '0.000000',
  `qty_on_order` decimal(18,6) DEFAULT '0.000000',
  `qty_reserved` decimal(18,6) DEFAULT '0.000000',
  `qty_allocated` decimal(18,6) DEFAULT '0.000000',
  `created_by` varchar(50) DEFAULT '',
  `created_date_time` datetime(3) DEFAULT CURRENT_TIMESTAMP(3),
  `modified_by` varchar(50) DEFAULT '',
  `modified_date_time` datetime(3) DEFAULT CURRENT_TIMESTAMP(3),
  `transaction_type` varchar(100) NOT NULL,
  `transaction_id` int NOT NULL,
  PRIMARY KEY (`log_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_inventory_log`
--


--
-- Table structure for table `tbl_inventory_transfer_location`
--

CREATE TABLE `tbl_inventory_transfer_location` (
  `id` int NOT NULL AUTO_INCREMENT,
  `code` varchar(100) NOT NULL,
  `description` varchar(1000) NOT NULL,
  `from_location_id` int NOT NULL,
  `to_location_id` int NOT NULL,
  `transfer_date` date NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `created_by` int NOT NULL,
  `created_on` datetime NOT NULL,
  `status` varchar(50) NOT NULL,
  `is_delete` tinyint(1) NOT NULL DEFAULT '0',
  `updated_by` int NOT NULL,
  `updated_on` datetime NOT NULL,
  `grn_id` int NOT NULL DEFAULT '0',
  `type` varchar(100) NOT NULL DEFAULT 'direct_transfer',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_inventory_transfer_location`
--


--
-- Table structure for table `tbl_inventory_transfer_location_details`
--

CREATE TABLE `tbl_inventory_transfer_location_details` (
  `id` int NOT NULL AUTO_INCREMENT,
  `parent_id` int NOT NULL,
  `field_name` varchar(50) NOT NULL,
  `field_value` varchar(5000) NOT NULL,
  `created_by` int NOT NULL,
  `created_on` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_inventory_transfer_location_details`
--


--
-- Table structure for table `tbl_inventory_transfer_location_products`
--

CREATE TABLE `tbl_inventory_transfer_location_products` (
  `id` int NOT NULL AUTO_INCREMENT,
  `transfer_id` int NOT NULL,
  `product_id` int NOT NULL,
  `qty` decimal(18,6) NOT NULL,
  `note` varchar(500) NOT NULL,
  `created_by` int NOT NULL,
  `created_on` datetime NOT NULL,
  `updated_by` int NOT NULL,
  `updated_on` datetime NOT NULL,
  `is_delete` tinyint(1) NOT NULL DEFAULT '0',
  `status` varchar(50) NOT NULL,
  `grn_id` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_inventory_transfer_location_products`
--


--
-- Table structure for table `tbl_invoice_cancel_request`
--

CREATE TABLE `tbl_invoice_cancel_request` (
  `id` int NOT NULL AUTO_INCREMENT,
  `sale_invoice_id` int NOT NULL,
  `created_on` datetime NOT NULL,
  `created_by` int NOT NULL,
  `reason` varchar(5000) NOT NULL,
  `cancelReject_reason` varchar(5000) NOT NULL,
  `previous_invoice_status` varchar(50) NOT NULL,
  `rejected_by` int NOT NULL,
  `rejected_on` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_invoice_cancel_request`
--


--
-- Table structure for table `tbl_invoice_category`
--

CREATE TABLE `tbl_invoice_category` (
  `inv_category_id` int NOT NULL AUTO_INCREMENT,
  `code` varchar(20) NOT NULL,
  `name` varchar(50) NOT NULL,
  PRIMARY KEY (`inv_category_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_invoice_category`
--


--
-- Table structure for table `tbl_invoice_type`
--

CREATE TABLE `tbl_invoice_type` (
  `id` int NOT NULL AUTO_INCREMENT,
  `type` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_invoice_type`
--

INSERT INTO `tbl_invoice_type` VALUES (1,'Retail invoice');

--
-- Table structure for table `tbl_job_type`
--

CREATE TABLE `tbl_job_type` (
  `job_id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL,
  `created_on` datetime DEFAULT NULL,
  `updated_on` datetime DEFAULT NULL,
  `created_by` int NOT NULL,
  `updated_by` int NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `is_delete` tinyint(1) NOT NULL,
  PRIMARY KEY (`job_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_job_type`
--


--
-- Table structure for table `tbl_keywords`
--

CREATE TABLE `tbl_keywords` (
  `id` int NOT NULL AUTO_INCREMENT,
  `keyword` varchar(450) NOT NULL,
  `type` int NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_index` (`keyword`,`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_keywords`
--


--
-- Table structure for table `tbl_make`
--

CREATE TABLE `tbl_make` (
  `id` int NOT NULL AUTO_INCREMENT,
  `make_name` varchar(500) NOT NULL,
  `is_active` tinyint NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_make`
--


--
-- Table structure for table `tbl_meal_ingredients`
--

CREATE TABLE `tbl_meal_ingredients` (
  `id` int NOT NULL AUTO_INCREMENT,
  `product_id` int NOT NULL,
  `uom` varchar(50) NOT NULL,
  `uom_id` int NOT NULL,
  `uom_selling_precentage` int NOT NULL,
  `uom_value` decimal(11,4) NOT NULL,
  `meal_id` int NOT NULL,
  `qty` decimal(11,2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_meal_ingredients`
--


--
-- Table structure for table `tbl_model`
--

CREATE TABLE `tbl_model` (
  `id` int NOT NULL AUTO_INCREMENT,
  `model_name` varchar(500) NOT NULL,
  `is_active` tinyint NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_model`
--

INSERT INTO `tbl_model` VALUES (1,'',1);

--
-- Table structure for table `tbl_mrn_details`
--

CREATE TABLE `tbl_mrn_details` (
  `id` int NOT NULL AUTO_INCREMENT,
  `parent_id` int NOT NULL,
  `field_name` varchar(50) NOT NULL,
  `field_value` varchar(5000) NOT NULL,
  `created_by` int NOT NULL,
  `created_on` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_mrn_details`
--


--
-- Table structure for table `tbl_mrn_issue_details`
--

CREATE TABLE `tbl_mrn_issue_details` (
  `id` int NOT NULL AUTO_INCREMENT,
  `parent_id` int NOT NULL,
  `field_name` varchar(50) NOT NULL,
  `field_value` varchar(5000) NOT NULL,
  `created_by` int NOT NULL,
  `created_on` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_mrn_issue_details`
--


--
-- Table structure for table `tbl_mrn_issue_products`
--

CREATE TABLE `tbl_mrn_issue_products` (
  `mrn_issue_product_id` int NOT NULL AUTO_INCREMENT,
  `mrn_issue_id` int NOT NULL,
  `plan_id` int NOT NULL,
  `qty` decimal(18,6) NOT NULL,
  `created_by` int NOT NULL,
  `created_on` datetime NOT NULL,
  `updated_by` int NOT NULL,
  `updated_on` datetime NOT NULL,
  `is_delete` tinyint(1) NOT NULL DEFAULT '0',
  `product_id` int NOT NULL,
  `status` varchar(50) NOT NULL DEFAULT '',
  `mrn_issues_max_Qty` decimal(18,6) NOT NULL,
  `mrn_id` int NOT NULL,
  PRIMARY KEY (`mrn_issue_product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_mrn_issue_products`
--


--
-- Table structure for table `tbl_mrn_issues`
--

CREATE TABLE `tbl_mrn_issues` (
  `mrn_issue_id` int NOT NULL AUTO_INCREMENT,
  `code` varchar(50) NOT NULL,
  `description` varchar(500) NOT NULL,
  `plan_id` int NOT NULL,
  `mrn_issue_date` date NOT NULL,
  `updated_by` int NOT NULL,
  `updated_on` datetime NOT NULL,
  `created_by` int NOT NULL,
  `created_on` datetime NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `is_delete` tinyint(1) NOT NULL DEFAULT '0',
  `status` varchar(50) NOT NULL,
  `mrn_issue_type` varchar(50) NOT NULL,
  `mrn_id` int NOT NULL,
  PRIMARY KEY (`mrn_issue_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_mrn_issues`
--


--
-- Table structure for table `tbl_mrn_products`
--

CREATE TABLE `tbl_mrn_products` (
  `mrn_product_id` int NOT NULL AUTO_INCREMENT,
  `mrn_id` int NOT NULL,
  `plan_id` int NOT NULL,
  `qty` decimal(18,6) NOT NULL,
  `created_by` int NOT NULL,
  `created_on` datetime NOT NULL,
  `updated_by` int NOT NULL,
  `updated_on` datetime NOT NULL,
  `is_delete` tinyint(1) NOT NULL DEFAULT '0',
  `product_id` int NOT NULL,
  `status` varchar(50) NOT NULL DEFAULT '',
  `mrns_max_Qty` decimal(18,6) DEFAULT NULL,
  PRIMARY KEY (`mrn_product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_mrn_products`
--


--
-- Table structure for table `tbl_mrns`
--

CREATE TABLE `tbl_mrns` (
  `mrn_id` int NOT NULL AUTO_INCREMENT,
  `code` varchar(50) NOT NULL,
  `description` varchar(500) NOT NULL,
  `plan_id` int NOT NULL,
  `mrn_date` date NOT NULL,
  `updated_by` int NOT NULL,
  `updated_on` datetime NOT NULL,
  `created_by` int NOT NULL,
  `created_on` datetime NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `is_delete` tinyint(1) NOT NULL DEFAULT '0',
  `status` varchar(50) NOT NULL,
  `mrn_type` varchar(50) NOT NULL,
  PRIMARY KEY (`mrn_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_mrns`
--


--
-- Table structure for table `tbl_name_titles`
--

CREATE TABLE `tbl_name_titles` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_name_titles`
--

INSERT INTO `tbl_name_titles` VALUES (1,'Mr'),(2,'Mrs'),(3,'Ms'),(4,'Miss'),(5,'Rev');

--
-- Table structure for table `tbl_notes`
--

CREATE TABLE `tbl_notes` (
  `note_id` int NOT NULL AUTO_INCREMENT,
  `note_type` varchar(500) NOT NULL,
  `created_datetime` datetime NOT NULL,
  `create_by` int NOT NULL,
  `note` varchar(5000) NOT NULL,
  `content_id` int NOT NULL,
  PRIMARY KEY (`note_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_notes`
--


--
-- Table structure for table `tbl_overpayments`
--

CREATE TABLE `tbl_overpayments` (
  `id` int NOT NULL AUTO_INCREMENT,
  `ps_id` int NOT NULL,
  `amount` decimal(16,2) NOT NULL,
  `created_by` int NOT NULL,
  `created_on` datetime NOT NULL,
  `customer_id` int NOT NULL,
  `status` varchar(100) NOT NULL,
  `rpt_settled_amount` decimal(16,2) NOT NULL,
  `is_hold` tinyint(1) NOT NULL DEFAULT '0',
  `code` varchar(100) NOT NULL,
  `hold_by` int NOT NULL,
  `hold_on` datetime NOT NULL DEFAULT '2021-01-01 00:00:01',
  `is_settled` tinyint(1) NOT NULL DEFAULT '0',
  `settled_amount` decimal(16,2) NOT NULL,
  `invoice_id` int NOT NULL DEFAULT '0',
  `canceled_payment_id` int NOT NULL,
  `return_id` int NOT NULL,
  `cancelled_customer_id` int NOT NULL,
  `cancelled_note` varchar(1000) NOT NULL,
  `cancelled_on` datetime NOT NULL,
  `cancelled_by` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_overpayments`
--


--
-- Table structure for table `tbl_payment_adjustment_reason`
--

CREATE TABLE `tbl_payment_adjustment_reason` (
  `id` int NOT NULL AUTO_INCREMENT,
  `reason` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_payment_adjustment_reason`
--

INSERT INTO `tbl_payment_adjustment_reason` VALUES (1,'Additional Discount');

--
-- Table structure for table `tbl_payment_adjustments`
--

CREATE TABLE `tbl_payment_adjustments` (
  `id` int NOT NULL AUTO_INCREMENT,
  `code` varchar(50) NOT NULL,
  `status` varchar(50) NOT NULL,
  `reason_id` int NOT NULL DEFAULT '0',
  `grn_id` int NOT NULL DEFAULT '0',
  `invoice_id` int NOT NULL DEFAULT '0',
  `adjustment_type` varchar(500) NOT NULL,
  `discription` varchar(500) NOT NULL,
  `type` varchar(500) NOT NULL,
  `updated_by` int NOT NULL,
  `updated_on` datetime NOT NULL,
  `created_by` int NOT NULL,
  `created_on` datetime NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `is_delete` tinyint(1) NOT NULL DEFAULT '0',
  `adjustment_date` date NOT NULL,
  `amount` decimal(16,2) NOT NULL,
  `rpt_settled_amount` decimal(16,2) NOT NULL,
  `is_hold` tinyint(1) NOT NULL DEFAULT '0',
  `hold_by` int NOT NULL,
  `hold_on` datetime NOT NULL DEFAULT '2022-01-01 00:00:00',
  `is_settled` tinyint(1) NOT NULL DEFAULT '0',
  `settled_amount` decimal(16,2) NOT NULL,
  `canceled_payment_id` int NOT NULL,
  `amountType` varchar(10) NOT NULL,
  `rate` decimal(10,2) NOT NULL,
  `is_lineDiscount` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_payment_adjustments`
--


--
-- Table structure for table `tbl_payment_adjustments_details`
--

CREATE TABLE `tbl_payment_adjustments_details` (
  `id` int NOT NULL AUTO_INCREMENT,
  `parent_id` int NOT NULL,
  `field_name` varchar(50) NOT NULL,
  `field_value` varchar(5000) NOT NULL,
  `created_by` int NOT NULL,
  `created_on` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_payment_adjustments_details`
--


--
-- Table structure for table `tbl_payment_allocation`
--

CREATE TABLE `tbl_payment_allocation` (
  `id` int NOT NULL AUTO_INCREMENT,
  `invoice_id` int NOT NULL,
  `ps_id` int NOT NULL,
  `payment_type` varchar(50) NOT NULL,
  `payment_id` int NOT NULL,
  `created_on` datetime NOT NULL,
  `allocation_amount` decimal(16,2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_payment_allocation`
--


--
-- Table structure for table `tbl_payment_allocation_return_cheque`
--

CREATE TABLE `tbl_payment_allocation_return_cheque` (
  `id` int NOT NULL AUTO_INCREMENT,
  `invoice_id` int NOT NULL,
  `ps_id` int NOT NULL,
  `payment_type` varchar(50) NOT NULL,
  `payment_id` int NOT NULL,
  `created_on` datetime NOT NULL,
  `allocation_amount` decimal(16,2) NOT NULL,
  `removed_on` datetime NOT NULL,
  `removed_by` int NOT NULL,
  `return_cheque_id` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_payment_allocation_return_cheque`
--


--
-- Table structure for table `tbl_payment_summary`
--

CREATE TABLE `tbl_payment_summary` (
  `id` int NOT NULL AUTO_INCREMENT,
  `code` varchar(100) NOT NULL,
  `customer_id` int NOT NULL,
  `amount` decimal(16,2) NOT NULL,
  `created_on` datetime NOT NULL,
  `created_by` int NOT NULL,
  `status` varchar(50) NOT NULL,
  `is_advance_payment` tinyint(1) NOT NULL DEFAULT '0',
  `rpt_receivableTotal` decimal(16,2) NOT NULL,
  `rpt_remittanceTotal` decimal(16,2) NOT NULL,
  `payment_mode` varchar(50) NOT NULL,
  `ps_id` int NOT NULL,
  `note` varchar(5000) NOT NULL DEFAULT '',
  `rpt_settled_amount` decimal(16,2) NOT NULL,
  `is_hold` tinyint(1) NOT NULL DEFAULT '0',
  `hold_by` int NOT NULL,
  `hold_on` datetime NOT NULL DEFAULT '2021-01-01 00:00:01',
  `is_settled` tinyint(1) NOT NULL DEFAULT '0',
  `settled_amount` decimal(16,2) NOT NULL,
  `branch_id` int NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_payment_summary`
--


--
-- Table structure for table `tbl_payment_summary_details`
--

CREATE TABLE `tbl_payment_summary_details` (
  `id` int NOT NULL AUTO_INCREMENT,
  `ps_id` int NOT NULL,
  `customer_id` int NOT NULL,
  `payment_type` varchar(100) NOT NULL,
  `sessionPaymentRef` varchar(100) NOT NULL,
  `amount` decimal(16,2) NOT NULL,
  `note` varchar(500) NOT NULL,
  `reference` varchar(500) NOT NULL,
  `cash_date` date NOT NULL,
  `cheque_date` date NOT NULL,
  `cheque_no` varchar(100) NOT NULL,
  `bank_id` int NOT NULL,
  `bank_branch` varchar(100) NOT NULL,
  `bank_account_id` int NOT NULL,
  `advancePaymnet_date` date NOT NULL,
  `created_on` datetime NOT NULL,
  `created_by` int NOT NULL,
  `card_type_id` int NOT NULL,
  `outstanding_type` varchar(100) NOT NULL,
  `outstanding_amount` decimal(16,2) NOT NULL,
  `outstanding_parent_id` int NOT NULL,
  `outstanding_sale_invoice_id` int NOT NULL,
  `outstanding_ref` varchar(100) NOT NULL,
  `is_advance_payment` tinyint(1) NOT NULL DEFAULT '0',
  `receipt_no` varchar(1000) NOT NULL,
  `received_date` date NOT NULL DEFAULT '2000-01-01',
  `is_cheque_return` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
