-- phpMyAdmin SQL Dump
-- version 4.7.4
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jan 30, 2024 at 10:08 AM
-- Server version: 10.1.28-MariaDB
-- PHP Version: 5.6.32

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


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

--
-- Database: `robipos`
--

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

--
-- Table structure for table `adjustmentcodes`
--

CREATE TABLE `adjustmentcodes` (
  `id` int(50) NOT NULL,
  `name` text NOT NULL,
  `code` varchar(50) NOT NULL,
  `description` text,
  `status` varchar(50) NOT NULL,
  `sort_order` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `adjustmentcodes`
--

INSERT INTO `adjustmentcodes` (`id`, `name`, `code`, `description`, `status`, `sort_order`) VALUES
(1, 'Cargo Transit Out', '01', NULL, 'Y', '1'),
(2, 'Cargo Transit In', '02', NULL, 'Y', '2'),
(3, 'Adjustment In', '03', NULL, 'Y', '3'),
(4, 'Adjustment Out', '04', NULL, 'Y', '4'),
(5, 'Discarding', '05', NULL, 'Y', '5'),
(6, 'Processing Raw', '06', NULL, 'Y', '6'),
(7, 'Processing Result', '07', NULL, 'Y', '7');

--
-- Indexes for dumped tables
--

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `adjustmentcodes`
--
ALTER TABLE `adjustmentcodes`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
COMMIT;

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


-- phpMyAdmin SQL Dump
-- version 4.7.4
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Mar 29, 2024 at 10:31 AM
-- Server version: 10.1.28-MariaDB
-- PHP Version: 5.6.32

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


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

--
-- Database: `robipos`
--

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

--
-- Table structure for table `bankcodes`
--

CREATE TABLE `bankcodes` (
  `id` int(11) NOT NULL,
  `name` text NOT NULL,
  `code` varchar(50) NOT NULL,
  `description` text NOT NULL,
  `status` varchar(20) NOT NULL,
  `sort_order` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `bankcodes`
--

INSERT INTO `bankcodes` (`id`, `name`, `code`, `description`, `status`, `sort_order`) VALUES
(1, 'MAYFAIR BANK LIMITED', '1', 'MAYFAIR BANK LIMITED', 'Y', '1'),
(2, 'M-PAYMENT', '2', 'M-PAYMENT', 'Y', '2'),
(3, 'KENYA POST OFFICE SAVINGS BANK', '3', 'KENYA POST OFFICE SAVINGS BANK', 'Y', '3'),
(4, 'FIRST COMMUNITY BANKS LIMITED', '4', 'FIRST COMMUNITY BANKS LIMITED', 'Y', '4'),
(5, 'GULF AFRICAN BANK LTD', '5', 'GULF AFRICAN BANK LTD', 'Y', '5'),
(6, 'FAMILY BANK LTD', '6', 'FAMILY BANK LTD', 'Y', '6'),
(7, 'EQUITY BANK LIMITED', '7', 'EQUITY BANK LIMITED', 'Y', '7'),
(8, 'SIDIAN BANK LIMITED', '8', 'SIDIAN BANK LIMITED', 'Y', '8'),
(9, 'DIAMOND TRUST BANK LIMITED', '9', 'DIAMOND TRUST BANK LIMITED', 'Y', '9'),
(10, 'HOUSING FINANCE BANK', '10', 'HOUSING FINANCE BANK', 'Y', '10'),
(11, 'SBM BANK (KENYA) LIMITED', '11', 'SBM BANK (KENYA) LIMITED', 'Y', '11'),
(12, 'DEVELOPMENT BANK OF KENYA LIMITED', '12', 'DEVELOPMENT BANK OF KENYA LIMITED', 'Y', '12'),
(13, 'I&M BANK LIMITED', '13', 'I&M BANK LIMITED', 'Y', '13'),
(14, 'GUARDIAN BANK LIMITED', '14', 'GUARDIAN BANK LIMITED', 'Y', '14'),
(15, 'VICTORIA COMMERCIAL BANK LIMITED', '15', 'VICTORIA COMMERCIAL BANK LIMITED', 'Y', '15'),
(16, 'GUARANTY TRUST BANK KENYA LIMITED', '16', 'GUARANTY TRUST BANK KENYA LIMITED', 'Y', '16'),
(17, 'JAMII BORA BANK', '17', 'JAMII BORA BANK', 'Y', '17'),
(18, 'PARAMOUNT UNIVERSAL BANK LIMITED', '18', 'PARAMOUNT UNIVERSAL BANK LIMITED', 'Y', '18'),
(19, 'EQUATORIAL COMMERCIAL HOLDING LIMITED', '19', 'EQUATORIAL COMMERCIAL HOLDING LIMITED', 'Y', '19'),
(20, 'GIRO COMMERCIAL BANK LIMITED', '20', 'GIRO COMMERCIAL BANK LIMITED', 'Y', '20'),
(21, 'NIC BANK LIMITED', '21', 'NIC BANK LIMITED', 'Y', '21'),
(22, 'IMPERIAL BANK LIMITED', '22', 'IMPERIAL BANK LIMITED', 'Y', '22'),
(23, 'CFC STANBIC BANK KENYA LIMITED', '23', 'CFC STANBIC BANK KENYA LIMITED', 'Y', '23'),
(24, 'CHASE BANK LIMITED', '24', 'CHASE BANK LIMITED', 'Y', '24'),
(25, 'ACCESS BANK (KENYA) PLC', '25', 'ACCESS BANK (KENYA) PLC', 'Y', '25'),
(26, 'CREDIT BANK LIMITED', '26', 'CREDIT BANK LIMITED', 'Y', '26'),
(27, 'CONSOLIDATED BANK OF KENYA LIMITED', '27', 'CONSOLIDATED BANK OF KENYA LIMITED', 'Y', '27'),
(28, 'DUBAI BANK KENYA LIMITED', '28', 'DUBAI BANK KENYA LIMITED', 'Y', '28'),
(29, 'BANK OF AFRICA KENYA LIMITED', '29', 'BANK OF AFRICA KENYA LIMITED', 'Y', '29'),
(30, 'MIDDLE EAST BANK KENYA LIMITED', '30', 'MIDDLE EAST BANK KENYA LIMITED', 'Y', '30'),
(31, 'HABIB BANK A.G. ZURICH', '31', 'HABIB BANK A.G. ZURICH', 'Y', '31'),
(32, 'CITIBANK N.A.', '32', 'CITIBANK N.A.', 'Y', '32'),
(33, 'ORIENTAL COMMERCIAL BANK LIMITED', '33', 'ORIENTAL COMMERCIAL BANK LIMITED', 'Y', '33'),
(34, 'NATIONAL BANK OF KENYA LTD', '34', 'NATIONAL BANK OF KENYA LTD', 'Y', '34'),
(35, 'PRIME BANK LIMITED', '35', 'PRIME BANK LIMITED', 'Y', '35'),
(36, 'CENTRAL BANK OF KENYA', '36', 'CENTRAL BANK OF KENYA', 'Y', '36'),
(37, 'HABIB BANK LIMITED', '37', 'HABIB BANK LIMITED', 'Y', '37'),
(38, 'COMMERCIAL BANK OF AFRICA LIMITED', '38', 'COMMERCIAL BANK OF AFRICA LIMITED', 'Y', '38'),
(39, 'BANK OF BARODA KENYA LIMITED', '39', 'BANK OF BARODA KENYA LIMITED', 'Y', '39'),
(40, 'BANK OF INDIA', '40', 'BANK OF INDIA', 'Y', '40'),
(41, 'ABSA BANK KENYA PLC', '41', 'ABSA BANK KENYA PLC', 'Y', '41'),
(42, 'STANDARD CHARTERED BANK KENYA LIMITED', '42', 'STANDARD CHARTERED BANK KENYA LIMITED', 'Y', '42'),
(43, 'KENYA COMMERCIAL BANK LTD', '43', 'KENYA COMMERCIAL BANK LTD', 'Y', '43'),
(44, 'AFRICAN BANKING CORP BANK LTD', '44', 'AFRICAN BANKING CORP BANK LTD', 'Y', '44'),
(45, 'ECO BANK LIMITED', '45', 'ECO BANK LIMITED', 'Y', '45'),
(46, 'UBA KENYA BANK LTD', '46', 'UBA KENYA BANK LTD', 'Y', '46'),
(47, 'CO-OPERATIVE BANK OF KENYA LIMITED', '47', 'CO-OPERATIVE BANK OF KENYA LIMITED', 'Y', '47');

--
-- Indexes for dumped tables
--

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `bankcodes`
--
ALTER TABLE `bankcodes`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=48;
COMMIT;

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


-- phpMyAdmin SQL Dump
-- version 4.7.4
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Mar 29, 2024 at 03:23 PM
-- Server version: 10.1.28-MariaDB
-- PHP Version: 5.6.32

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


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

--
-- Database: `robipos`
--

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

--
-- Table structure for table `branchlist`
--

CREATE TABLE `branchlist` (
  `id` int(11) NOT NULL,
  `tin` varchar(50) NOT NULL,
  `bhfId` varchar(50) NOT NULL,
  `bhfNm` text NOT NULL,
  `bhfSttsCd` varchar(50) NOT NULL DEFAULT 'active',
  `prvncNm` text NOT NULL,
  `dstrtNm` text NOT NULL,
  `sctrNm` varchar(50) NOT NULL,
  `locDesc` varchar(50) DEFAULT NULL,
  `mgrNm` varchar(50) NOT NULL DEFAULT 'KES',
  `mgrTelNo` varchar(50) NOT NULL,
  `mgrEmail` text NOT NULL,
  `hqYn` text NOT NULL,
  `branchid` varchar(50) DEFAULT NULL,
  `companyid` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `branchlist`
--

INSERT INTO `branchlist` (`id`, `tin`, `bhfId`, `bhfNm`, `bhfSttsCd`, `prvncNm`, `dstrtNm`, `sctrNm`, `locDesc`, `mgrNm`, `mgrTelNo`, `mgrEmail`, `hqYn`, `branchid`, `companyid`) VALUES
(1, 'P000000025R', '00', 'Headquarter', '01', 'Turkana', 'Turkana Central District', 'Lodwar', NULL, 'ROBISEARCH LTD', '0714201229', 'ROBISEARCHLTD@gmail.com', 'Y', NULL, ''),
(2, 'P000000025R', '01', 'NYERI 1', '01', 'Nyeri', 'Nyeri Central District', 'Ruringu', NULL, 'LILIAN', '0711111119', 'NYERI001@GMAIL.COM', 'N', NULL, '');

--
-- Indexes for dumped tables
--

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `branchlist`
--
ALTER TABLE `branchlist`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
COMMIT;

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


-- phpMyAdmin SQL Dump
-- version 4.7.4
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jan 30, 2024 at 10:08 AM
-- Server version: 10.1.28-MariaDB
-- PHP Version: 5.6.32

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


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

--
-- Database: `robipos`
--

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

--
-- Table structure for table `countrycodes`
--

CREATE TABLE `countrycodes` (
  `id` int(50) NOT NULL,
  `name` text NOT NULL,
  `code` varchar(50) NOT NULL,
  `description` text,
  `status` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `countrycodes`
--

INSERT INTO `countrycodes` (`id`, `name`, `code`, `description`, `status`) VALUES
(1, 'ASCENSION ISLAND ', 'AC', NULL, 'Y'),
(2, 'ANDORRA', 'AD', NULL, 'Y'),
(3, 'UNITED ARAB EMIRATES ', 'AE', NULL, 'Y'),
(4, 'ANTIGUA AND BARBUDA', 'AG', NULL, 'Y'),
(5, 'ANGUILLA', 'AI', NULL, 'Y'),
(6, 'ALBANIA ', 'AL', NULL, 'Y'),
(7, 'ARMENIA', 'AM', NULL, 'Y'),
(8, 'NETHERLANDS ANTILLES ', 'AN', NULL, 'Y'),
(9, 'ANGOLA', 'AO', NULL, 'Y'),
(10, 'ANTARCTICA', 'AQ', NULL, 'Y'),
(11, 'ARGENTINA', 'AR', NULL, 'Y'),
(12, 'AMERICAN SAMOA', 'AS', NULL, 'Y'),
(13, 'AUSTRIA', 'AT', NULL, 'Y'),
(14, 'AUSTRALIA', 'AU', NULL, 'Y'),
(15, 'ARUBA', 'AW', NULL, 'Y'),
(16, 'ALAND ISLANDS', 'AX', NULL, 'Y'),
(17, 'AZERBAIJAN', 'AZ', NULL, 'Y'),
(18, 'BOSNIA AND HERZEGOVINA ', 'BA', NULL, 'Y'),
(19, 'BARBADOS ', 'BB', NULL, 'Y'),
(20, 'BANGLADESH ', 'BD', NULL, 'Y'),
(21, 'BELGIUM ', 'BE', NULL, 'Y'),
(22, 'BURKINA FASO ', 'BF', NULL, 'Y'),
(23, 'BULGARIA ', 'BG', NULL, 'Y'),
(24, 'BAHRAIN', 'BH', NULL, 'Y'),
(25, 'BURUNDI ', 'BI', NULL, 'Y'),
(26, 'BENIN ', 'BJ', NULL, 'Y'),
(27, 'BERMUDA ', 'BM', NULL, 'Y'),
(28, 'BRUNEI DARUSSALAM ', 'BN', NULL, 'Y'),
(29, 'BOLIVIA ', 'BO', NULL, 'Y'),
(30, 'BRAZIL ', 'BR', NULL, 'Y'),
(31, 'BAHAMAS ', 'BS', NULL, 'Y'),
(32, 'BHUTAN ', 'BT', NULL, 'Y'),
(33, 'BOUVET ISLAND ', 'BV', NULL, 'Y'),
(34, 'BOTSWANA ', 'BW', NULL, 'Y'),
(35, 'BELARUS ', 'BY', NULL, 'Y'),
(36, 'BELIZE ', 'BZ', NULL, 'Y'),
(37, 'CANADA ', 'CA', NULL, 'Y'),
(38, 'COCOS (KEELING) ISLANDS ', 'CC', NULL, 'Y'),
(39, 'CONGO, DEMOCRATIC REPUBLIC ', 'CD', NULL, 'Y'),
(40, 'CENTRAL AFRICAN REPUBLIC ', 'CF', NULL, 'Y'),
(41, 'CONGO ', 'CG', NULL, 'Y'),
(42, 'SWITZERLAND ', 'CH', NULL, 'Y'),
(43, 'COTE D\'IVOIRE (IVORY COAST) ', 'CI', NULL, 'Y'),
(44, 'COOK ISLANDS ', 'CK', NULL, 'Y'),
(45, 'CHILE ', 'CL', NULL, 'Y'),
(46, 'CAMEROON ', 'CM', NULL, 'Y'),
(47, 'CHINA ', 'CN', NULL, 'Y'),
(48, 'COLOMBIA ', 'CO', NULL, 'Y'),
(49, 'COSTA RICA ', 'CR', NULL, 'Y'),
(50, 'CZECHOSLOVAKIA (FORMER) ', 'CS', NULL, 'Y'),
(51, 'CUBA ', 'CU', NULL, 'Y'),
(52, 'CAPE VERDE ', 'CV', NULL, 'Y'),
(53, 'CHRISTMAS ISLAND ', 'CX', NULL, 'Y'),
(54, 'CYPRUS ', 'CY', NULL, 'Y'),
(55, 'CZECH REPUBLIC ', 'CZ', NULL, 'Y'),
(56, 'GERMANY ', 'DE', NULL, 'Y'),
(57, 'DJIBOUTI ', 'DJ', NULL, 'Y'),
(58, 'DENMARK ', 'DK', NULL, 'Y'),
(59, 'DOMINICA ', 'DM', NULL, 'Y'),
(60, 'DOMINICAN REPUBLIC ', 'DO', NULL, 'Y'),
(61, 'ALGERIA', 'DZ', NULL, 'Y'),
(62, 'ECUADOR ', 'EC', NULL, 'Y'),
(63, 'ESTONIA ', 'EE', NULL, 'Y'),
(64, 'EGYPT ', 'EG', NULL, 'Y'),
(65, 'WESTERN SAHARA ', 'EH', NULL, 'Y'),
(66, 'ERITREA ', 'ER', NULL, 'Y'),
(67, 'SPAIN ', 'ES', NULL, 'Y'),
(68, 'ETHIOPIA ', 'ET', NULL, 'Y'),
(69, 'EUROPEAN UNION ', 'EU', NULL, 'Y'),
(70, 'FINLAND ', 'FI', NULL, 'Y'),
(71, 'FIJI ', 'FJ', NULL, 'Y'),
(72, 'FALKLAND ISLANDS (MALVINAS) ', 'FK', NULL, 'Y'),
(73, 'MICRONESIA ', 'FM', NULL, 'Y'),
(74, 'FAROE ISLANDS ', 'FO', NULL, 'Y'),
(75, 'FRANCE ', 'FR', NULL, 'Y'),
(76, 'FRANCE, METROPOLITAN ', 'FX', NULL, 'Y'),
(77, 'GABON ', 'GA', NULL, 'Y'),
(78, 'GREAT BRITAIN (UK) ', 'GB', NULL, 'Y'),
(79, 'GRENADA ', 'GD', NULL, 'Y'),
(80, 'GEORGIA ', 'GE', NULL, 'Y'),
(81, 'FRENCH GUIANA ', 'GF', NULL, 'Y'),
(82, 'GUERNSEY ', 'GG', NULL, 'Y'),
(83, 'GHANA ', 'GH', NULL, 'Y'),
(84, 'GIBRALTAR ', 'GI', NULL, 'Y'),
(85, 'GREENLAND ', 'GL', NULL, 'Y'),
(86, 'GAMBIA ', 'GM', NULL, 'Y'),
(87, 'GUINEA ', 'GN', NULL, 'Y'),
(88, 'GUADELOUPE ', 'GP', NULL, 'Y'),
(89, 'EQUATORIAL GUINEA ', 'GQ', NULL, 'Y'),
(90, 'GREECE ', 'GR', NULL, 'Y'),
(91, 'S. GEORGIA AND S. SANDWICH ISLS. ', 'GS', NULL, 'Y'),
(92, 'GUATEMALA ', 'GT', NULL, 'Y'),
(93, 'GUAM ', 'GU', NULL, 'Y'),
(94, 'GUINEA     BISSAU ', 'GW', NULL, 'Y'),
(95, 'GUYANA ', 'GY', NULL, 'Y'),
(96, 'HONG KONG ', 'HK', NULL, 'Y'),
(97, 'HEARD AND MCDONALD ISLANDS ', 'HM', NULL, 'Y'),
(98, 'HONDURAS ', 'HN', NULL, 'Y'),
(99, 'CROATIA (HRVATSKA) ', 'HR', NULL, 'Y'),
(100, 'HAITI ', 'HT', NULL, 'Y'),
(101, 'HUNGARY ', 'HU', NULL, 'Y'),
(102, 'INDONESIA ', 'ID', NULL, 'Y'),
(103, 'IRELAND ', 'IE', NULL, 'Y'),
(104, 'ISRAEL ', 'IL', NULL, 'Y'),
(105, 'ISLE OF MAN ', 'IM', NULL, 'Y'),
(106, 'INDIA ', 'IN', NULL, 'Y'),
(107, 'BRITISH INDIAN OCEAN TERRITORY ', 'IO', NULL, 'Y'),
(108, 'IRAQ ', 'IQ', NULL, 'Y'),
(109, 'IRAN ', 'IR', NULL, 'Y'),
(110, 'ICELAND ', 'IS', NULL, 'Y'),
(111, 'ITALY ', 'IT', NULL, 'Y'),
(112, 'JERSEY ', 'JE', NULL, 'Y'),
(113, 'JAMAICA ', 'JM', NULL, 'Y'),
(114, 'JORDAN ', 'JO', NULL, 'Y'),
(115, 'JAPAN ', 'JP', NULL, 'Y'),
(116, 'KENYA ', 'KE', NULL, 'Y'),
(117, 'KYRGYZSTAN ', 'KG', NULL, 'Y'),
(118, 'CAMBODIA ', 'KH', NULL, 'Y'),
(119, 'KIRIBATI ', 'KI', NULL, 'Y'),
(120, 'COMOROS ', 'KM', NULL, 'Y'),
(121, 'SAINT KITTS AND NEVIS ', 'KN', NULL, 'Y'),
(122, 'NORTH KOREA', 'KP', NULL, 'Y'),
(123, 'SOUTH KOREA', 'KR', NULL, 'Y'),
(124, 'KUWAIT ', 'KW', NULL, 'Y'),
(125, 'CAYMAN ISLANDS ', 'KY', NULL, 'Y'),
(126, 'KAZAKHSTAN ', 'KZ', NULL, 'Y'),
(127, 'LAOS ', 'LA', NULL, 'Y'),
(128, 'LEBANON ', 'LB', NULL, 'Y'),
(129, 'SAINT LUCIA ', 'LC', NULL, 'Y'),
(130, 'LIECHTENSTEIN ', 'LI', NULL, 'Y'),
(131, 'SRI LANKA ', 'LK', NULL, 'Y'),
(132, 'LIBERIA ', 'LR', NULL, 'Y'),
(133, 'LESOTHO ', 'LS', NULL, 'Y'),
(134, 'LITHUANIA ', 'LT', NULL, 'Y'),
(135, 'LUXEMBOURG ', 'LU', NULL, 'Y'),
(136, 'LATVIA ', 'LV', NULL, 'Y'),
(137, 'LIBYA ', 'LY', NULL, 'Y'),
(138, 'MOROCCO ', 'MA', NULL, 'Y'),
(139, 'MONACO ', 'MC', NULL, 'Y'),
(140, 'MOLDOVA ', 'MD', NULL, 'Y'),
(141, 'MONTENEGRO ', 'ME', NULL, 'Y'),
(142, 'MADAGASCAR ', 'MG', NULL, 'Y'),
(143, 'MARSHALL ISLANDS ', 'MH', NULL, 'Y'),
(144, 'F.Y.R.O.M. (MACEDONIA) ', 'MK', NULL, 'Y'),
(145, 'MALI ', 'ML', NULL, 'Y'),
(146, 'MYANMAR ', 'MM', NULL, 'Y'),
(147, 'MONGOLIA ', 'MN', NULL, 'Y'),
(148, 'MACAU ', 'MO', NULL, 'Y'),
(149, 'NORTHERN MARIANA ISLANDS ', 'MP', NULL, 'Y'),
(150, 'MARTINIQUE ', 'MQ', NULL, 'Y'),
(151, 'MAURITANIA ', 'MR', NULL, 'Y'),
(152, 'MONTSERRAT ', 'MS', NULL, 'Y'),
(153, 'MALTA ', 'MT', NULL, 'Y'),
(154, 'MAURITIUS ', 'MU', NULL, 'Y'),
(155, 'MALDIVES ', 'MV', NULL, 'Y'),
(156, 'MALAWI ', 'MW', NULL, 'Y'),
(157, 'MEXICO ', 'MX', NULL, 'Y'),
(158, 'MALAYSIA ', 'MY', NULL, 'Y'),
(159, 'MOZAMBIQUE ', 'MZ', NULL, 'Y'),
(160, 'NAMIBIA ', 'NA', NULL, 'Y'),
(161, 'NEW CALEDONIA ', 'NC', NULL, 'Y'),
(162, 'NIGER ', 'NE', NULL, 'Y'),
(163, 'NORFOLK ISLAND ', 'NF', NULL, 'Y'),
(164, 'NIGERIA ', 'NG', NULL, 'Y'),
(165, 'NICARAGUA ', 'NI', NULL, 'Y'),
(166, 'NETHERLANDS ', 'NL', NULL, 'Y'),
(167, 'NORWAY ', 'NO', NULL, 'Y'),
(168, 'NEPAL ', 'NP', NULL, 'Y'),
(169, 'NAURU ', 'NR', NULL, 'Y'),
(170, 'NEUTRAL ZONE ', 'NT', NULL, 'Y'),
(171, 'NIUE ', 'NU', NULL, 'Y'),
(172, 'NEW ZEALAND (AOTEAROA) ', 'NZ', NULL, 'Y'),
(173, 'OMAN ', 'OM', NULL, 'Y'),
(174, 'PANAMA ', 'PA', NULL, 'Y'),
(175, 'PERU ', 'PE', NULL, 'Y'),
(176, 'FRENCH POLYNESIA ', 'PF', NULL, 'Y'),
(177, 'PAPUA NEW GUINEA ', 'PG', NULL, 'Y'),
(178, 'PHILIPPINES ', 'PH', NULL, 'Y'),
(179, 'PAKISTAN ', 'PK', NULL, 'Y'),
(180, 'POLAND ', 'PL', NULL, 'Y'),
(181, 'ST. PIERRE AND MIQUELON ', 'PM', NULL, 'Y'),
(182, 'PITCAIRN ', 'PN', NULL, 'Y'),
(183, 'PUERTO RICO ', 'PR', NULL, 'Y'),
(184, 'PALESTINIAN TERRITORY, OCCUPIED ', 'PS', NULL, 'Y'),
(185, 'PORTUGAL ', 'PT', NULL, 'Y'),
(186, 'PALAU ', 'PW', NULL, 'Y'),
(187, 'PARAGUAY ', 'PY', NULL, 'Y'),
(188, 'QATAR ', 'QA', NULL, 'Y'),
(189, 'REUNION ', 'RE', NULL, 'Y'),
(190, 'ROMANIA ', 'RO', NULL, 'Y'),
(191, 'SERBIA ', 'RS', NULL, 'Y'),
(192, 'RUSSIAN FEDERATION ', 'RU', NULL, 'Y'),
(193, 'RWANDA ', 'RW', NULL, 'Y'),
(194, 'SAUDI ARABIA ', 'SA', NULL, 'Y'),
(195, 'SOLOMON ISLANDS ', 'SB', NULL, 'Y'),
(196, 'SEYCHELLES ', 'SC', NULL, 'Y'),
(197, 'SUDAN ', 'SD', NULL, 'Y'),
(198, 'SWEDEN ', 'SE', NULL, 'Y'),
(199, 'SINGAPORE ', 'SG', NULL, 'Y'),
(200, 'ST. HELENA ', 'SH', NULL, 'Y'),
(201, 'SLOVENIA ', 'SI', NULL, 'Y'),
(202, 'SVALBARD & JAN MAYEN ISLANDS ', 'SJ', NULL, 'Y'),
(203, 'SLOVAK REPUBLIC ', 'SK', NULL, 'Y'),
(204, 'SIERRA LEONE ', 'SL', NULL, 'Y'),
(205, 'SAN MARINO ', 'SM', NULL, 'Y'),
(206, 'SENEGAL ', 'SN', NULL, 'Y'),
(207, 'SOMALIA ', 'SO', NULL, 'Y'),
(208, 'SURINAME ', 'SR', NULL, 'Y'),
(209, 'SAO TOME AND PRINCIPE ', 'ST', NULL, 'Y'),
(210, 'USSR (FORMER) ', 'SU', NULL, 'Y'),
(211, 'EL SALVADOR ', 'SV', NULL, 'Y'),
(212, 'SYRIA ', 'SY', NULL, 'Y'),
(213, 'SWAZILAND ', 'SZ', NULL, 'Y'),
(214, 'TURKS AND CAICOS ISLANDS ', 'TC', NULL, 'Y'),
(215, 'CHAD ', 'TD', NULL, 'Y'),
(216, 'FRENCH SOUTHERN TERRITORIES ', 'TF', NULL, 'Y'),
(217, 'TOGO ', 'TG', NULL, 'Y'),
(218, 'THAILAND ', 'TH', NULL, 'Y'),
(219, 'TAJIKISTAN ', 'TJ', NULL, 'Y'),
(220, 'TOKELAU ', 'TK', NULL, 'Y'),
(221, 'TURKMENISTAN ', 'TM', NULL, 'Y'),
(222, 'TUNISIA ', 'TN', NULL, 'Y'),
(223, 'TONGA ', 'TO', NULL, 'Y'),
(224, 'EAST TIMOR ', 'TP', NULL, 'Y'),
(225, 'TURKEY ', 'TR', NULL, 'Y'),
(226, 'TRINIDAD AND TOBAGO ', 'TT', NULL, 'Y'),
(227, 'TUVALU ', 'TV', NULL, 'Y'),
(228, 'TAIWAN ', 'TW', NULL, 'Y'),
(229, 'TANZANIA ', 'TZ', NULL, 'Y'),
(230, 'UKRAINE ', 'UA', NULL, 'Y'),
(231, 'UGANDA ', 'UG', NULL, 'Y'),
(232, 'UNITED KINGDOM ', 'UK', NULL, 'Y'),
(233, 'US MINOR OUTLYING ISLANDS ', 'UM', NULL, 'Y'),
(234, 'UNITED STATES ', 'US', NULL, 'Y'),
(235, 'URUGUAY ', 'UY', NULL, 'Y'),
(236, 'UZBEKISTAN ', 'UZ', NULL, 'Y'),
(237, 'VATICAN CITY STATE (HOLY SEE) ', 'VA', NULL, 'Y'),
(238, 'SAINT VINCENT & THE GRENADINES ', 'VC', NULL, 'Y'),
(239, 'VENEZUELA ', 'VE', NULL, 'Y'),
(240, 'BRITISH VIRGIN ISLANDS ', 'VG', NULL, 'Y'),
(241, 'VIRGIN ISLANDS (U.S.) ', 'VI', NULL, 'Y'),
(242, 'VIET NAM ', 'VN', NULL, 'Y'),
(243, 'VANUATU ', 'VU', NULL, 'Y'),
(244, 'WALLIS AND FUTUNA ISLANDS ', 'WF', NULL, 'Y'),
(245, 'SAMOA ', 'WS', NULL, 'Y'),
(246, 'YEMEN ', 'YE', NULL, 'Y'),
(247, 'MAYOTTE ', 'YT', NULL, 'Y'),
(248, 'SERBIA AND MONTENEGRO (FORMER) ', 'YU', NULL, 'Y'),
(249, 'SOUTH AFRICA ', 'ZA', NULL, 'Y'),
(250, 'ZAMBIA ', 'ZM', NULL, 'Y'),
(251, '(ZAIRE) SEE CD CONGO, DEMOCRATIC REPUBLIC ', 'ZR', NULL, 'Y'),
(252, 'ZIMBABWE', 'ZW', NULL, 'Y');

--
-- Indexes for dumped tables
--

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `countrycodes`
--
ALTER TABLE `countrycodes`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=253;
COMMIT;

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


-- phpMyAdmin SQL Dump
-- version 4.7.4
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jan 30, 2024 at 10:08 AM
-- Server version: 10.1.28-MariaDB
-- PHP Version: 5.6.32

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


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

--
-- Database: `robipos`
--

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

--
-- Table structure for table `currencycodes`
--

CREATE TABLE `currencycodes` (
  `id` int(50) NOT NULL,
  `name` text NOT NULL,
  `code` varchar(50) NOT NULL,
  `description` text,
  `status` varchar(50) NOT NULL,
  `symbol` varchar(50) NOT NULL,
  `sort_order` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `currencycodes`
--

INSERT INTO `currencycodes` (`id`, `name`, `code`, `description`, `status`, `symbol`, `sort_order`) VALUES
(1, 'United Arab Emirates dirham', 'AED', NULL, 'Y', 'AED', '1'),
(2, 'Afghan afghani', 'AFN', NULL, 'Y', 'AFN', '2'),
(3, 'Albanian lek', 'ALL', NULL, 'Y', 'ALL', '3'),
(4, 'Armenian dram', 'AMD', NULL, 'Y', 'AMD', '4'),
(5, 'Netherlands Antillean guilder', 'ANG', NULL, 'Y', 'ANG', '5'),
(6, 'Angolan kwanza', 'AOA', NULL, 'Y', 'AOA', '6'),
(7, 'Argentine peso', 'ARS', NULL, 'Y', 'ARS', '7'),
(8, 'Australian dollar', 'AUD', NULL, 'Y', 'AUD', '8'),
(9, 'Aruban florin', 'AWG', NULL, 'Y', 'AWG', '9'),
(10, 'Azerbaijani manat', 'AZN', NULL, 'Y', 'AZN', '10'),
(11, 'Bosnia and Herzegovina convertible mark', 'BAM', NULL, 'Y', 'BAM', '11'),
(12, 'Barbados dollar', 'BBD', NULL, 'Y', 'BBD', '12'),
(13, 'Bangladeshi taka', 'BDT', NULL, 'Y', 'BDT', '13'),
(14, 'Bulgarian lev', 'BGN', NULL, 'Y', 'BGN', '14'),
(15, 'Bahraini dinar', 'BHD', NULL, 'Y', 'BHD', '15'),
(16, 'Burundian franc', 'BIF', NULL, 'Y', 'BIF', '16'),
(17, 'Bermudian dollar', 'BMD', NULL, 'Y', 'BMD', '17'),
(18, 'Brunei dollar', 'BND', NULL, 'Y', 'BND', '18'),
(19, 'Boliviano', 'BOB', NULL, 'Y', 'BOB', '19'),
(20, 'Bolivian Mvdol (funds code)', 'BOV', NULL, 'Y', 'BOV', '20'),
(21, 'Brazilian real', 'BRL', NULL, 'Y', 'BRL', '21'),
(22, 'Bahamian dollar', 'BSD', NULL, 'Y', 'BSD', '22'),
(23, 'Bhutanese ngultrum', 'BTN', NULL, 'Y', 'BTN', '23'),
(24, 'Botswana pula', 'BWP', NULL, 'Y', 'BWP', '24'),
(25, 'New Belarusian ruble', 'BYN', NULL, 'Y', 'BYN', '25'),
(26, 'Belarusian ruble', 'BYR', NULL, 'Y', 'BYR', '26'),
(27, 'Belize dollar', 'BZD', NULL, 'Y', 'BZD', '27'),
(28, 'Canadian dollar', 'CAD', NULL, 'Y', 'CAD', '28'),
(29, 'Congolese franc', 'CDF', NULL, 'Y', 'CDF', '29'),
(30, 'WIR Euro (complementary currency)', 'CHE', NULL, 'Y', 'CHE', '30'),
(31, 'Swiss franc', 'CHF', NULL, 'Y', 'CHF', '31'),
(32, 'WIR Franc (complementary currency)', 'CHW', NULL, 'Y', 'CHW', '32'),
(33, 'Unidad de Fomento (funds code)', 'CLF', NULL, 'Y', 'CLF', '33'),
(34, 'Chilean peso', 'CLP', NULL, 'Y', 'CLP', '34'),
(35, 'Chinese yuan', 'CNY', NULL, 'Y', 'CNY', '35'),
(36, 'Colombian peso', 'COP', NULL, 'Y', 'COP', '36'),
(37, 'Unidad de Valor Real (UVR) (funds code)', 'COU', NULL, 'Y', 'COU', '37'),
(38, 'Costa Rican colon', 'CRC', NULL, 'Y', 'CRC', '38'),
(39, 'Cuban convertible peso', 'CUC', NULL, 'Y', 'CUC', '39'),
(40, 'Cuban peso', 'CUP', NULL, 'Y', 'CUP', '40'),
(41, 'Cape Verde escudo', 'CVE', NULL, 'Y', 'CVE', '41'),
(42, 'Czech koruna', 'CZK', NULL, 'Y', 'CZK', '42'),
(43, 'Djiboutian franc', 'DJF', NULL, 'Y', 'DJF', '43'),
(44, 'Danish krone', 'DKK', NULL, 'Y', 'DKK', '44'),
(45, 'Dominican peso', 'DOP', NULL, 'Y', 'DOP', '45'),
(46, 'Algerian dinar', 'DZD', NULL, 'Y', 'DZD', '46'),
(47, 'Egyptian pound', 'EGP', NULL, 'Y', 'EGP', '47'),
(48, 'Eritrean nakfa', 'ERN', NULL, 'Y', 'ERN', '48'),
(49, 'Ethiopian birr', 'ETB', NULL, 'Y', 'ETB', '49'),
(50, 'Euro', 'EUR', NULL, 'Y', 'EUR', '50'),
(51, 'Fiji dollar', 'FJD', NULL, 'Y', 'FJD', '51'),
(52, 'Falkland Islands pound', 'FKP', NULL, 'Y', 'FKP', '52'),
(53, 'Pound sterling', 'GBP', NULL, 'Y', 'GBP', '53'),
(54, 'Georgian lari', 'GEL', NULL, 'Y', 'GEL', '54'),
(55, 'Ghanaian cedi', 'GHS', NULL, 'Y', 'GHS', '55'),
(56, 'Gibraltar pound', 'GIP', NULL, 'Y', 'GIP', '56'),
(57, 'Gambian dalasi', 'GMD', NULL, 'Y', 'GMD', '57'),
(58, 'Guinean franc', 'GNF', NULL, 'Y', 'GNF', '58'),
(59, 'Guatemalan quetzal', 'GTQ', NULL, 'Y', 'GTQ', '59'),
(60, 'Guyanese dollar', 'GYD', NULL, 'Y', 'GYD', '60'),
(61, 'Hong Kong dollar', 'HKD', NULL, 'Y', 'HKD', '61'),
(62, 'Honduran lempira', 'HNL', NULL, 'Y', 'HNL', '62'),
(63, 'Croatian kuna', 'HRK', NULL, 'Y', 'HRK', '63'),
(64, 'Haitian gourde', 'HTG', NULL, 'Y', 'HTG', '64'),
(65, 'Hungarian forint', 'HUF', NULL, 'Y', 'HUF', '65'),
(66, 'Indonesian rupiah', 'IDR', NULL, 'Y', 'IDR', '66'),
(67, 'Israeli new shekel', 'ILS', NULL, 'Y', 'ILS', '67'),
(68, 'Indian rupee', 'INR', NULL, 'Y', 'INR', '68'),
(69, 'Iraqi dinar', 'IQD', NULL, 'Y', 'IQD', '69'),
(70, 'Iranian rial', 'IRR', NULL, 'Y', 'IRR', '70'),
(71, 'Icelandic króna', 'ISK', NULL, 'Y', 'ISK', '71'),
(72, 'Jamaican dollar', 'JMD', NULL, 'Y', 'JMD', '72'),
(73, 'Jordanian dinar', 'JOD', NULL, 'Y', 'JOD', '73'),
(74, 'Japanese yen', 'JPY', NULL, 'Y', 'JPY', '74'),
(75, 'Kenyan shilling', 'KES', NULL, 'Y', 'KES', '75'),
(76, 'Kyrgyzstani som', 'KGS', NULL, 'Y', 'KGS', '76'),
(77, 'Cambodian riel', 'KHR', NULL, 'Y', 'KHR', '77'),
(78, 'Comoro franc', 'KMF', NULL, 'Y', 'KMF', '78'),
(79, 'North Korean won', 'KPW', NULL, 'Y', 'KPW', '79'),
(80, 'South Korean won', 'KRW', NULL, 'Y', 'KRW', '80'),
(81, 'Kuwaiti dinar', 'KWD', NULL, 'Y', 'KWD', '81'),
(82, 'Cayman Islands dollar', 'KYD', NULL, 'Y', 'KYD', '82'),
(83, 'Kazakhstani tenge', 'KZT', NULL, 'Y', 'KZT', '83'),
(84, 'Lao kip', 'LAK', NULL, 'Y', 'LAK', '84'),
(85, 'Lebanese pound', 'LBP', NULL, 'Y', 'LBP', '85'),
(86, 'Sri Lankan rupee', 'LKR', NULL, 'Y', 'LKR', '86'),
(87, 'Liberian dollar', 'LRD', NULL, 'Y', 'LRD', '87'),
(88, 'Lesotho loti', 'LSL', NULL, 'Y', 'LSL', '88'),
(89, 'Libyan dinar', 'LYD', NULL, 'Y', 'LYD', '89'),
(90, 'Moroccan dirham', 'MAD', NULL, 'Y', 'MAD', '90'),
(91, 'Moldovan leu', 'MDL', NULL, 'Y', 'MDL', '91'),
(92, 'Malagasy ariary', 'MGA', NULL, 'Y', 'MGA', '92'),
(93, 'Macedonian denar', 'MKD', NULL, 'Y', 'MKD', '93'),
(94, 'Myanmar kyat', 'MMK', NULL, 'Y', 'MMK', '94'),
(95, 'Mongolian tögrög', 'MNT', NULL, 'Y', 'MNT', '95'),
(96, 'Macanese pataca', 'MOP', NULL, 'Y', 'MOP', '96'),
(97, 'Mauritanian ouguiya', 'MRO', NULL, 'Y', 'MRO', '97'),
(98, 'Mauritian rupee', 'MUR', NULL, 'Y', 'MUR', '98'),
(99, 'Maldivian rufiyaa', 'MVR', NULL, 'Y', 'MVR', '99'),
(100, 'Malawian kwacha', 'MWK', NULL, 'Y', 'MWK', '100'),
(101, 'Mexican peso', 'MXN', NULL, 'Y', 'MXN', '101'),
(102, 'Mexican Unidad de Inversion (UDI) (funds code)', 'MXV', NULL, 'Y', 'MXV', '102'),
(103, 'Malaysian ringgit', 'MYR', NULL, 'Y', 'MYR', '103'),
(104, 'Mozambican metical', 'MZN', NULL, 'Y', 'MZN', '104'),
(105, 'Namibian dollar', 'NAD', NULL, 'Y', 'NAD', '105'),
(106, 'Nigerian naira', 'NGN', NULL, 'Y', 'NGN', '106'),
(107, 'Nicaraguan córdoba', 'NIO', NULL, 'Y', 'NIO', '107'),
(108, 'Norwegian krone', 'NOK', NULL, 'Y', 'NOK', '108'),
(109, 'Nepalese rupee', 'NPR', NULL, 'Y', 'NPR', '109'),
(110, 'New Zealand dollar', 'NZD', NULL, 'Y', 'NZD', '110'),
(111, 'Omani rial', 'OMR', NULL, 'Y', 'OMR', '111'),
(112, 'Panamanian balboa', 'PAB', NULL, 'Y', 'PAB', '112'),
(113, 'Peruvian Sol', 'PEN', NULL, 'Y', 'PEN', '113'),
(114, 'Papua New Guinean kina', 'PGK', NULL, 'Y', 'PGK', '114'),
(115, 'Philippine peso', 'PHP', NULL, 'Y', 'PHP', '115'),
(116, 'Pakistani rupee', 'PKR', NULL, 'Y', 'PKR', '116'),
(117, 'Polish zloty', 'PLN', NULL, 'Y', 'PLN', '117'),
(118, 'Paraguayan guaraní', 'PYG', NULL, 'Y', 'PYG', '118'),
(119, 'Qatari riyal', 'QAR', NULL, 'Y', 'QAR', '119'),
(120, 'Romanian leu', 'RON', NULL, 'Y', 'RON', '120'),
(121, 'Serbian dinar', 'RSD', NULL, 'Y', 'RSD', '121'),
(122, 'Russian ruble', 'RUB', NULL, 'Y', 'RUB', '122'),
(123, 'Rwandan franc', 'RWF', NULL, 'Y', 'RWF', '123'),
(124, 'Saudi riyal', 'SAR', NULL, 'Y', 'SAR', '124'),
(125, 'Solomon Islands dollar', 'SBD', NULL, 'Y', 'SBD', '125'),
(126, 'Seychelles rupee', 'SCR', NULL, 'Y', 'SCR', '126'),
(127, 'Sudanese pound', 'SDG', NULL, 'Y', 'SDG', '127'),
(128, 'Swedish krona/kronor', 'SEK', NULL, 'Y', 'SEK', '128'),
(129, 'Singapore dollar', 'SGD', NULL, 'Y', 'SGD', '129'),
(130, 'Saint Helena pound', 'SHP', NULL, 'Y', 'SHP', '130'),
(131, 'Sierra Leonean leone', 'SLL', NULL, 'Y', 'SLL', '131'),
(132, 'Somali shilling', 'SOS', NULL, 'Y', 'SOS', '132'),
(133, 'Surinamese dollar', 'SRD', NULL, 'Y', 'SRD', '133'),
(134, 'South Sudanese pound', 'SSP', NULL, 'Y', 'SSP', '134'),
(135, 'São Tomé and Príncipe dobra', 'STD', NULL, 'Y', 'STD', '135'),
(136, 'Salvadoran colón', 'SVC', NULL, 'Y', 'SVC', '136'),
(137, 'Syrian pound', 'SYP', NULL, 'Y', 'SYP', '137'),
(138, 'Swazi lilangeni', 'SZL', NULL, 'Y', 'SZL', '138'),
(139, 'Thai baht', 'THB', NULL, 'Y', 'THB', '139'),
(140, 'Tajikistani somoni', 'TJS', NULL, 'Y', 'TJS', '140'),
(141, 'Turkmenistani manat', 'TMT', NULL, 'Y', 'TMT', '141'),
(142, 'Tunisian dinar', 'TND', NULL, 'Y', 'TND', '142'),
(143, 'Tongan pa?anga', 'TOP', NULL, 'Y', 'TOP', '143'),
(144, 'Turkish lira', 'TRY', NULL, 'Y', 'TRY', '144'),
(145, 'Trinidad and Tobago dollar', 'TTD', NULL, 'Y', 'TTD', '145'),
(146, 'New Taiwan dollar', 'TWD', NULL, 'Y', 'TWD', '146'),
(147, 'Tanzanian shilling', 'TZS', NULL, 'Y', 'TZS', '147'),
(148, 'Ukrainian hryvnia', 'UAH', NULL, 'Y', 'UAH', '148'),
(149, 'Ugandan shilling', 'UGX', NULL, 'Y', 'UGX', '149'),
(150, 'United States dollar', 'USD', NULL, 'Y', 'USD', '150'),
(151, 'United States dollar (next day) (funds code)', 'USN', NULL, 'Y', 'USN', '151'),
(152, 'Uruguay Peso en Unidades Indexadas (URUIURUI) (funds code)', 'UYI', NULL, 'Y', 'UYI', '152'),
(153, 'Uruguayan peso', 'UYU', NULL, 'Y', 'UYU', '153'),
(154, 'Uzbekistan som', 'UZS', NULL, 'Y', 'UZS', '154'),
(155, 'Venezuelan bolívar', 'VEF', NULL, 'Y', 'VEF', '155'),
(156, 'Vietnamese dong', 'VND', NULL, 'Y', 'VND', '156'),
(157, 'Vanuatu vatu', 'VUV', NULL, 'Y', 'VUV', '157'),
(158, 'Samoan tala', 'WST', NULL, 'Y', 'WST', '158'),
(159, 'CFA franc BEAC', 'XAF', NULL, 'Y', 'XAF', '159'),
(160, 'Silver (one troy ounce)', 'XAG', NULL, 'Y', 'XAG', '160'),
(161, 'Gold (one troy ounce)', 'XAU', NULL, 'Y', 'XAU', '161'),
(162, 'European Composite Unit (EURCO) (bond market unit)', 'XBA', NULL, 'Y', 'XBA', '162'),
(163, 'European Monetary Unit (E.M.U.-6) (bond market unit)', 'XBB', NULL, 'Y', 'XBB', '163'),
(164, 'European Unit of Account 9 (E.U.A.-9) (bond market unit)', 'XBC', NULL, 'Y', 'XBC', '164'),
(165, 'European Unit of Account 17 (E.U.A.-17) (bond market unit)', 'XBD', NULL, 'Y', 'XBD', '165'),
(166, 'East Caribbean dollar', 'XCD', NULL, 'Y', 'XCD', '166'),
(167, 'Special drawing rights', 'XDR', NULL, 'Y', 'XDR', '167'),
(168, 'CFA franc BCEAO', 'XOF', NULL, 'Y', 'XOF', '168'),
(169, 'Palladium (one troy ounce)', 'XPD', NULL, 'Y', 'XPD', '169'),
(170, 'CFP franc (franc Pacifique)', 'XPF', NULL, 'Y', 'XPF', '170'),
(171, 'Platinum (one troy ounce)', 'XPT', NULL, 'Y', 'XPT', '171'),
(172, 'SUCRE', 'XSU', NULL, 'Y', 'XSU', '172'),
(173, 'Code reserved for testing purposes', 'XTS', NULL, 'Y', 'XTS', '173'),
(174, 'ADB Unit of Account', 'XUA', NULL, 'Y', 'XUA', '174'),
(175, 'No currency', 'XXX', NULL, 'Y', 'XXX', '175'),
(176, 'Yemeni rial', 'YER', NULL, 'Y', 'YER', '176'),
(177, 'South African rand', 'ZAR', NULL, 'Y', 'ZAR', '177'),
(178, 'Zambian kwacha', 'ZMW', NULL, 'Y', 'ZMW', '178'),
(179, 'Zimbabwean dollar A/10', 'ZWL', NULL, 'Y', 'ZWL', '179');

--
-- Indexes for dumped tables
--

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `currencycodes`
--
ALTER TABLE `currencycodes`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=180;
COMMIT;

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


-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Mar 29, 2024 at 10:35 AM
-- Server version: 10.6.17-MariaDB
-- PHP Version: 8.1.27

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


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

--
-- Database: `robisear_distinctiongardens`
--

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


CREATE TABLE `itemclassification` (
  `id` int(11) NOT NULL,
  `name` text NOT NULL,
  `itm_class_code` varchar(100) DEFAULT NULL,
  `itm_class_level` varchar(50) NOT NULL,
  `tax_type_code` varchar(50) DEFAULT NULL,
  `status` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `itemclassification`
--

INSERT INTO `itemclassification` (`id`, `name`, `itm_class_code`, `itm_class_level`, `tax_type_code`, `status`) VALUES
(1, 'VAT Act', '99000000', '1', NULL, 'Y'),
(2, 'Goods', '99010000', '2', NULL, 'Y'),
(3, 'Exempt Goods (Paragraph 1 - 99)', '99011000', '3', NULL, 'Y'),
(4, 'Bovine Semen of tariff number 05111000', '99011001', '4', NULL, 'Y'),
(5, 'Fish eggs and roes of tariff number 0511990110', '99011002', '4', NULL, 'Y'),
(6, 'Animal semen other than of bovine of tariff number 0511999010', '99011003', '4', NULL, 'Y'),
(7, 'Soya beans whether or not broken of tariff numbers 12011000 and 12019000', '99011004', '4', NULL, 'Y'),
(8, 'Groundnuts not roasted or otherwise cooked In shell of tariff number 12024100', '99011005', '4', NULL, 'Y'),
(9, 'Groundnuts not roasted or otherwise cooked Shelled whether or not broken of tariff number 12024200', '99011006', '4', NULL, 'Y'),
(10, 'Copra of tariff number 12030000', '99011007', '4', NULL, 'Y'),
(11, 'Linseed whether or not broken of tariff number 12040000', '99011008', '4', NULL, 'Y'),
(12, 'Low erucic acid rape or colza seed of tariff number 12051000', '99011009', '4', NULL, 'Y'),
(13, 'Other rape or colza seed of tariff number  12059000', '99011010', '4', NULL, 'Y'),
(14, 'Sunflower seeds whether or not broken of tariff number 12060000', '99011011', '4', NULL, 'Y'),
(15, 'Cotton seeds  whether or not broken  Seed of tariff numbers 12072100 and 12072900', '99011012', '4', NULL, 'Y'),
(16, 'Sesamum seeds whether or not broken of tariff number 12074000', '99011013', '4', NULL, 'Y'),
(17, 'Mustard seeds whether or  not broken of tariff number 12075000', '99011014', '4', NULL, 'Y'),
(18, 'Safflower seeds  whether or  not broken 12076000', '99011015', '4', NULL, 'Y'),
(19, 'Other oil seeds and oleaginous fruits whether or not broken of tariff number 12079900', '99011016', '4', NULL, 'Y'),
(20, 'Sugarcane of tariff number 1212990300;Sugarcane of tariff number 1212990300;Unprocessed produce of plant species camellia sinensis', '99011017', '4', NULL, 'Y'),
(21, 'Live animals of chapter 1', '99011018', '4', NULL, 'Y'),
(22, 'Meat and edible offals of chapter 2 excluding those of heading 0209 and 0210', '99011019', '4', NULL, 'Y'),
(23, 'Fish and crustaceans molluscs and other aquatic invertebrates of chapter 3 excluding those of tariff heading 0305 0306 and 0307', '99011020', '4', NULL, 'Y'),
(24, 'Unprocessed milk', '99011021', '4', NULL, 'Y'),
(25, 'Fresh birds eggs in shell', '99011022', '4', NULL, 'Y'),
(26, 'Edible Vegetables and certain roots and tubers of Chapter 7 excluding those of tariff heading 0711', '99011023', '4', NULL, 'Y'),
(27, 'Edible fruits and nuts peal of citrus fruits or melon of chapter 8 excluding those of tariff heading 0811 0812 0813 and 0814', '99011024', '4', NULL, 'Y'),
(28, 'Cereals of chapter 10 excluding seeds of tariff heading 1002 ', '99011025', '4', NULL, 'Y'),
(29, 'Syringes with or without needles of tarrif no 90183100', '99011032', '4', NULL, 'Y'),
(30, 'Tubular metal needles and needles for sutures of tariff number 90183200', '99011035', '4', NULL, 'Y'),
(31, 'Catheters cannulae and the like of tariff number 90183900', '99011036', '4', NULL, 'Y'),
(32, 'Blood bags', '99011037', '4', NULL, 'Y'),
(33, 'Blood and fluid infusion sets', '99011038', '4', NULL, 'Y'),
(34, 'Materials articles and equipment including motor vehicles listed under the first schedule paragraph 39 of the VAT Act.', '99011039', '4', NULL, 'Y'),
(35, 'Madeup fishing nets of manmade textile material of tariff number 56081100', '99011040', '4', NULL, 'Y'),
(36, 'Mosquito nets of tariff No 6304990110', '99011041', '4', NULL, 'Y'),
(37, 'Materials waste residues and by products whether or not in the form of pellets and preparations of a kind used in animal feeding of tariff numbers as listed in Part 1 of the first schedule of VAT Act 2013', '99011043', '4', NULL, 'Y'),
(38, 'Unprocessed green tea', '99011044', '4', NULL, 'Y'),
(39, 'Inputs or raw materials supplied to solar equipment manufacturers for manufacture of solar equipment or deep cycle sealed batteries which exclusively use or store solar power ', '99011048', '4', NULL, 'Y'),
(40, 'Aircraft parts of heading 8803 excluding parts of goods of heading 8801', '99011049', '4', NULL, 'Y'),
(41, 'Taxable goods imported or purchased for direct and exclusive use in the implementation of official aid funded projects upon approval by the Cabinet Secretary responsible for the National Treasury', '99011051', '4', NULL, 'Y'),
(42, 'Goods imported or purchased locally for use by the local film producers and local filming agents upon recommendation by the Kenya Film Commission subject to approval by CS TNT', '99011054', '4', NULL, 'Y'),
(43, 'Inputs or raw materials locally purchased or imported by manufacturers of agricultural machinery and implements upon approval by the Cabinet Secretary responsible for industrialization', '99011056', '4', NULL, 'Y'),
(44, 'All goods including material supplies equipment machinery and motor vehicles for official use by the Kenya Defence Forces and the National Police Service', '99011057', '4', NULL, 'Y'),
(45, 'Direction finding compasses instruments and appliances for aircraft', '99011058', '4', NULL, 'Y'),
(46, 'Wheat seeds of tariff numbers 10011100 and 1001990100', '99011059', '4', NULL, 'Y'),
(47, 'Taxable goods for direct and exclusive use for the construction of tourism facilities recreational parks of fifty acres or more convention and conference facilities upon recommendation by the Cabinet Secretary responsible for matters relating to recreational parks', '99011062', '4', NULL, 'Y'),
(48, 'Taxable goods equipment and apparatus for the direct and exclusive use for construction of specialized hospitals with a minimum bed capacity of fifty with accommodation facilities upon the recommendation by the Cabinet Secretary responsible for health who shall issue guidelines for the criteria to be used to determine eligibility for the exemption provided that notwithstanding this subparagraph any approval granted by the cabinet Secretary before the commencement thereof in respect of the supply of taxable goods and which is in supply of taxable goods and which is in force at such commencement shall continue to apply of the exempted taxable goods is made in full', '99011063', '4', NULL, 'Y'),
(49, 'Inputs or raw materials locally purchased or imported by manufacturers of clean cook stoves approved by the CS TNT upon recommendation by the CS responsible for energy', '99011066', '4', NULL, 'Y'),
(50, 'Super absorbent polymer SAP of tariff number 39069000', '99011068', '4', NULL, 'Y'),
(51, 'Carrier tissue white 1 ply 14 point 5 GSM 47032100', '99011069', '4', NULL, 'Y'),
(52, 'IP super soft fluff pulp for fluff 310 treated pulp 488 times 125 mm cellose of tariff number 47032100', '99011070', '4', NULL, 'Y'),
(53, 'Perforated PE film 15 to 22 gsm of tariff number 3990219000', '99011071', '4', NULL, 'Y'),
(54, 'Spunbound nonwoven 15 to 25 gsm of tariff number 56031100', '99011072', '4', NULL, 'Y'),
(55, 'Airlid paper with super absorbent polymer 180gsm67 of tariff number 48030000', '99011073', '4', NULL, 'Y'),
(56, 'Airlid paper with super absorbent polymer 80gsm67 of tariff number 48030000', '99011074', '4', NULL, 'Y'),
(57, 'Pressure sensitive adhesive of tariff number 3506990100', '99011077', '4', NULL, 'Y'),
(58, 'Plain polythene filmLPDE of tariff number 399021199010', '99011078', '4', NULL, 'Y'),
(59, 'Plain polythene filmPE of tariff number 399021199010', '99011079', '4', NULL, 'Y'),
(60, 'PE white 25 to 40 gsm release paper of tarrif number 48114900', '99011080', '4', NULL, 'Y'),
(61, 'ADL 25 to 40 gsm of tariff number 56031100', '99011081', '4', NULL, 'Y'),
(62, 'Elasticized side tape of tariff number 54024400', '99011082', '4', NULL, 'Y'),
(63, '12 to 16 gsm spunbound piyropo nonwoven coverstock 12gsm spunbound PP nonwoven SMS hydrophobic leg cuffs of tariff number 56031100', '99011083', '4', NULL, 'Y'),
(64, 'Polymetric elastic 2 over 3 strands of tariff number 3990199010', '99011084', '4', NULL, 'Y'),
(65, 'Any other aircraft spare parts imported by aircraft operators or persons engaged in the business of aircraft maintenance upon recommendation by the competent authority responsible for civil aviation', '99011089', '4', NULL, 'Y'),
(66, 'Inputs for the manufacture of pesticides upon recommendation by the Cabinet Secretary for the time being responsible for matters relating to agriculture', '99011090', '4', NULL, 'Y'),
(67, 'Locally assembled motor vehicles for transportation of tourists purchased before clearance through Customs following conditions as specified in the VAT Act 2013 1st Schedule Section A no9901', '99011091', '4', NULL, 'Y'),
(68, 'The supply of natural water excluding bottled water by a NG, CGor any political subdivision thereof or a person approved by the CS responsible for water development for domestic or for industrial use', '99011095', '4', NULL, 'Y'),
(69, 'Articles of apparel clothing accessories and equipment specially designed for safety or protective purposes for use in registered hospitals and clinics or by CG or LA in firefighting', '99011096', '4', NULL, 'Y'),
(70, 'Goods imported by passengers arriving from places outside Kenya as specified in the VAT Act 2013 First Schedule section A no 99', '99011099', '4', NULL, 'Y'),
(71, 'Exempt Goods (Paragraph 100 - 146)', '99011100', '3', NULL, 'Y'),
(72, 'Alcoholic or non alcoholic beverages supplied to the Kenya Defence Forces Canteen Organization', '99011101', '4', NULL, 'Y'),
(73, 'Hearing aids excluding parts and accessories of tariff Number 90214000', '99011103', '4', NULL, 'Y'),
(74, 'Locally manufactured motherboards', '99011105', '4', NULL, 'Y'),
(75, 'Inputs for the manufacture of motherboards approved by the Cabinet Secretary responsible for information communication technology', '99011106', '4', NULL, 'Y'),
(76, 'Plant machinery and equipment used in the construction of a plastics recycling plant', '99011107', '4', NULL, 'Y'),
(77, 'The supply of maize corn flour cassava flour wheat or meslin flour and maize flour containing cassava flour by more than ten percent in weight provided that this paragra', '99011108', '4', NULL, 'Y'),
(78, 'Goods imported or purchased locally for the direct and exclusive use in the construction of houses under an affordable housing scheme approved by the CS on the recommendation of the CS responsible for matters relating to housing', '99011109', '4', NULL, 'Y'),
(79, 'Musical instruments and other musical equipment imported or purchased locally for exclusive use by educational institutions upon recommendation by the Cabinet Secretary responsible for Education', '99011110', '4', NULL, 'Y'),
(80, 'Maize corn seeds of tariff no 10051000', '99011111', '4', NULL, 'Y'),
(81, 'Taxable good excl. motor vehicle imported or purchased for direct exclusive use in geothermal, oil, mining prospecting, exploration, product sharing as per the Energy Act 2019, Petroleum Act 2019, the Mining Act 2016 upon recommendation by the CS', '99011112', '4', NULL, 'Y'),
(82, 'Specialized equipment for the development and generation of solar and wind energy upon recommendation to the commissioner by the cabinet secretary responsible for matters relating to energy ', '99011113', '4', NULL, 'Y'),
(83, 'Taxable goods supplied to persons that had a contract with the government prior to 25-04-2020 and contract provided for exemption from VAT provided that this exemption shall apply to the unexpired period of contract upon recommendation by CS Energy', '99011114', '4', NULL, 'Y'),
(84, 'Medical ventilators and the inputs for the manufacture of medical ventilators upon recommendation by the cabinet secretary responsible for matters relating to health ', '99011115', '4', NULL, 'Y'),
(85, 'Physiotherapy accessories treadmills for cardiology therapy and treatment of tariff number 9506990100 for use by licensed hospitals upon approval by the cabinet secretary responsible for matters relating to health ', '99011116', '4', NULL, 'Y'),
(86, 'Dexpanthenol of tariff number 33049900 used for medical nappy rash treatment by licensed hospitals upon approval by the cabinet secretary responsible for matters relating to health ', '99011117', '4', NULL, 'Y'),
(87, 'Medicaments of tariff number 30034100 30034200 30034300 30034900 30036000 excluding goods of heading 3002 3005 or 3006 consisting of two or more constituents which have been mixed together for theraputic or prophylactic uses', '99011118', '4', NULL, 'Y'),
(88, 'Diagnostic or laboratory reagents of tariff number 38220000 on a backing prepared diagnostic or laboratory reagents whether or not on a backing other than those of heading 3002 or 3006 certified reference materials upon approval by CS Health ', '99011119', '4', NULL, 'Y'),
(89, 'Electrodiagnostic apparatus of tariff numbers 90181100 90181200 90181300 90181400 90181900 90182000 90189000  upon approval by the cabinet secretary responsible for matters relating to health ', '99011120', '4', NULL, 'Y'),
(90, 'Other instruments and appliances of tariff number 90184100 used in dental sciences dental drill engines whether or not combined on a single base with other dental equipment  upon approval by CS Health', '99011121', '4', NULL, 'Y'),
(91, 'Other instruments and appliances including surgical blades of tariff number 90184900 90185000 90189000 used in dental sciences dental drill engines whether or not combined on a single base with other dental equipment upon approval by CS Health', '99011122', '4', NULL, 'Y'),
(92, 'Ozone therapy Oxygen therapy aerosol therapy artificial respiration or other theraputic respiration apapratus upon approval by CS Health ', '99011123', '4', NULL, 'Y'),
(93, 'Other breathing appliances and gas masks excluding protective masks having neither mechanical parts nor replaceable filters upon approval by CS Health', '99011124', '4', NULL, 'Y'),
(94, 'Artificial teeth and dental fittings of tariff number 90212100 90212900 and artificial parts of the body of tariff number 90213100 90213900 90215000 and 90219000 upon approval by CS Health', '99011125', '4', NULL, 'Y'),
(95, 'Apparatus based on the use of x rays whether or not for medical surgical or dental of tariff numbers 90221200 90221300 90221400 and 90221900 upon approval by CS Health', '99011126', '4', NULL, 'Y'),
(96, 'Apparatus based on the use of alpha beta or gamma radiations whether or not medical surgical or dental of tariff numbers 90222100 90222900 90223000 and 90229000 upon approval by CS Health', '99011127', '4', NULL, 'Y'),
(97, 'Discs tape solid-state nonvolatile storage devices smart cards and other media for the recording of sound or of other phenomena whether or not recorded of tariff number 85238010 but excluding products of chapter 37 software upon approval by CS Health', '99011128', '4', NULL, 'Y'),
(98, 'Management support services', '80161500', '3', NULL, 'Y'),
(99, 'Silk fabrics', '11161500', '3', NULL, 'Y'),
(100, 'Screws', '31161500', '3', NULL, 'Y'),
(101, 'Agricultural machinery for planting and seeding', '21101600', '3', NULL, 'Y'),
(102, 'Amebicides and Trichomonacides and Antiprotozoals', '51101600', '3', NULL, 'Y'),
(103, 'Mechanical engineering', '81101600', '3', NULL, 'Y'),
(104, 'Paving equipment', '22101600', '3', NULL, 'Y'),
(105, 'Integrated circuits', '32101600', '3', NULL, 'Y'),
(106, 'Broadcast advertising', '82101600', '3', NULL, 'Y'),
(107, 'Fire services', '92101600', '3', NULL, 'Y'),
(108, 'Processed and synthetic rubber', '13101600', '3', NULL, 'Y'),
(109, 'Shirts and blouses', '53101600', '3', NULL, 'Y'),
(110, 'Chemicals and fertilizers production', '73101600', '3', NULL, 'Y'),
(111, 'Oil and gas utilities', '83101600', '3', NULL, 'Y'),
(112, 'Political officials', '93101600', '3', NULL, 'Y'),
(113, 'Lifting equipment and accessories', '24101600', '3', NULL, 'Y'),
(114, 'Paper processing machines and accessories', '44101600', '3', NULL, 'Y'),
(115, 'Aid financing', '84101600', '3', NULL, 'Y'),
(116, 'Solid and gel fuels', '15101600', '3', NULL, 'Y'),
(117, 'Product and material transport vehicles', '25101600', '3', NULL, 'Y'),
(118, 'Printing machinery accessories', '45101600', '3', NULL, 'Y'),
(119, 'Healthcare provider support persons', '85101600', '3', NULL, 'Y'),
(120, 'Commercial land parcels', '95101600', '3', NULL, 'Y'),
(121, 'Ammunition', '46101600', '3', NULL, 'Y'),
(122, 'Outdoor furniture', '56101600', '3', NULL, 'Y'),
(123, 'Hazardous material decontamination', '76101600', '3', NULL, 'Y'),
(124, 'Scientific vocational training services', '86101600', '3', NULL, 'Y'),
(125, 'Water treatment consumables', '47101600', '3', NULL, 'Y'),
(126, 'Environmental planning', '77101600', '3', NULL, 'Y'),
(127, 'Food preparation equipment', '48101600', '3', NULL, 'Y'),
(128, 'Rail cargo transport', '78101600', '3', NULL, 'Y'),
(129, 'Lamps and lightbulbs', '39101600', '3', NULL, 'Y'),
(130, 'Collectibles', '49101600', '3', NULL, 'Y'),
(131, 'Drilling and operation machinery', '20111600', '3', NULL, 'Y'),
(132, 'Cement and lime', '30111600', '3', NULL, 'Y'),
(133, 'Flowering plants', '70111600', '3', NULL, 'Y'),
(134, 'Temporary personnel services', '80111600', '3', NULL, 'Y'),
(135, 'Meeting facilities', '90111600', '3', NULL, 'Y'),
(136, 'Stone', '11111600', '3', NULL, 'Y'),
(137, 'Aquaculture equipment', '21111600', '3', NULL, 'Y'),
(138, 'Length and thickness and distance measuring instruments', '41111600', '3', NULL, 'Y'),
(139, 'Antimetabolites', '51111600', '3', NULL, 'Y'),
(140, 'Computer programmers', '81111600', '3', NULL, 'Y'),
(141, 'Household assistance and care', '91111600', '3', NULL, 'Y'),
(142, 'Non technical writing', '82111600', '3', NULL, 'Y'),
(143, 'Disarmament', '92111600', '3', NULL, 'Y'),
(144, 'Shoes', '53111600', '3', NULL, 'Y'),
(145, 'Mobile communications services', '83111600', '3', NULL, 'Y'),
(146, 'Political representation and participation', '93111600', '3', NULL, 'Y'),
(147, 'Novelty paper', '14111600', '3', NULL, 'Y'),
(148, 'Cash handling supplies', '44111600', '3', NULL, 'Y'),
(149, 'Clocks', '54111600', '3', NULL, 'Y'),
(150, 'Audit services', '84111600', '3', NULL, 'Y'),
(151, 'Safety and rescue water craft', '25111600', '3', NULL, 'Y'),
(152, 'Projectors and supplies', '45111600', '3', NULL, 'Y'),
(153, 'Non contagious disease prevention and control', '85111600', '3', NULL, 'Y'),
(154, 'Open traffic thoroughfares', '95111600', '3', NULL, 'Y'),
(155, 'Power generators', '26111600', '3', NULL, 'Y'),
(156, 'Building component cleaning services', '76111600', '3', NULL, 'Y'),
(157, 'Adult education', '86111600', '3', NULL, 'Y'),
(158, 'Panel systems', '56111600', '3', NULL, 'Y'),
(159, 'Ironing equipment', '47111600', '3', NULL, 'Y'),
(160, 'Forming tools', '27111600', '3', NULL, 'Y'),
(161, 'Environmental rehabilitation', '77111600', '3', NULL, 'Y'),
(162, 'Passenger railway transportation', '78111600', '3', NULL, 'Y'),
(163, 'Exterior lighting fixtures and accessories ', '39111600', '3', NULL, 'Y'),
(164, 'Bird and fowl food', '10121600', '3', NULL, 'Y'),
(165, 'Asphalts', '30121600', '3', NULL, 'Y'),
(166, 'Livestock industry', '70121600', '3', NULL, 'Y'),
(167, 'Business law services', '80121600', '3', NULL, 'Y'),
(168, 'Travel document assistance', '90121600', '3', NULL, 'Y'),
(169, 'Drilling bits', '20121600', '3', NULL, 'Y'),
(170, 'Studio aids', '60121600', '3', NULL, 'Y'),
(171, 'Wood', '11121600', '3', NULL, 'Y'),
(172, 'Monetary systems and issues', '81121600', '3', NULL, 'Y'),
(173, 'Pipette tips', '41121600', '3', NULL, 'Y'),
(174, 'Veterinary products', '42121600', '3', NULL, 'Y'),
(175, 'Table and kitchen linen and accessories', '52121600', '3', NULL, 'Y'),
(176, 'Engraving', '82121600', '3', NULL, 'Y'),
(177, 'Detective services', '92121600', '3', NULL, 'Y'),
(178, 'Textile working machinery and equipment and accessories', '23121600', '3', NULL, 'Y'),
(179, 'Purses and handbags and bags', '53121600', '3', NULL, 'Y'),
(180, 'Information centers', '83121600', '3', NULL, 'Y'),
(181, 'International relations and cooperation', '93121600', '3', NULL, 'Y'),
(182, 'Desk supplies', '44121600', '3', NULL, 'Y'),
(183, 'Tissue papers', '14121600', '3', NULL, 'Y'),
(184, 'Funds transfer and clearance and exchange services', '84121600', '3', NULL, 'Y'),
(185, 'Camera accessories', '45121600', '3', NULL, 'Y'),
(186, 'Labels', '55121600', '3', NULL, 'Y'),
(187, 'Medical doctor specialist services', '85121600', '3', NULL, 'Y'),
(188, 'Transport buildings and structures', '95121600', '3', NULL, 'Y'),
(189, 'Electrical cable and accessories', '26121600', '3', NULL, 'Y'),
(190, 'Nonhazardous waste disposal', '76121600', '3', NULL, 'Y'),
(191, 'Junior colleges', '86121600', '3', NULL, 'Y'),
(192, 'Floor machines and accessories', '47121600', '3', NULL, 'Y'),
(193, 'Soil pollution', '77121600', '3', NULL, 'Y'),
(194, 'Material handling services', '78121600', '3', NULL, 'Y'),
(195, 'Circuit protection devices and accessories', '39121600', '3', NULL, 'Y'),
(196, 'Camping furniture', '49121600', '3', NULL, 'Y'),
(197, 'Animal containment', '10131600', '3', NULL, 'Y'),
(198, 'Bricks', '30131600', '3', NULL, 'Y'),
(199, 'Eggs and egg substitutes', '50131600', '3', NULL, 'Y'),
(200, 'Land and soil preparation', '70131600', '3', NULL, 'Y'),
(201, 'Sale of property and building', '80131600', '3', NULL, 'Y'),
(202, 'Musical instrument sets', '60131600', '3', NULL, 'Y'),
(203, 'Other animal products', '11131600', '3', NULL, 'Y'),
(204, 'Anticoagulants', '51131600', '3', NULL, 'Y'),
(205, 'Pyrotechnics', '12131600', '3', NULL, 'Y'),
(206, 'Blinds and shades', '52131600', '3', NULL, 'Y'),
(207, 'Photographers and cinematographers', '82131600', '3', NULL, 'Y'),
(208, 'Medical staff clothing and related articles', '42131600', '3', NULL, 'Y'),
(209, 'Faceting equipment and accessories', '23131600', '3', NULL, 'Y'),
(210, 'Bath and body', '53131600', '3', NULL, 'Y'),
(211, 'Meat and poultry and seafood processing', '73131600', '3', NULL, 'Y'),
(212, 'Food and nutrition policy planning and programs', '93131600', '3', NULL, 'Y'),
(213, 'Industrial freezers', '24131600', '3', NULL, 'Y'),
(214, 'Life and health and accident insurance', '84131600', '3', NULL, 'Y'),
(215, 'Charity organizations', '94131600', '3', NULL, 'Y'),
(216, 'Civilian and commercial rotary wing aircraft', '25131600', '3', NULL, 'Y'),
(217, 'Moving picture media', '45131600', '3', NULL, 'Y'),
(218, 'Fission fuel assemblies', '15131600', '3', NULL, 'Y'),
(219, 'Medical ethics', '85131600', '3', NULL, 'Y'),
(220, 'Portable commercial and industrial buildings and structures', '95131600', '3', NULL, 'Y'),
(221, 'Toxic spill cleanup', '76131600', '3', NULL, 'Y'),
(222, 'Music and drama', '86131600', '3', NULL, 'Y'),
(223, 'Exhaust structures or screening equipment', '26131600', '3', NULL, 'Y'),
(224, 'Brooms and mops and brushes and accessories', '47131600', '3', NULL, 'Y'),
(225, 'Noise pollution', '77131600', '3', NULL, 'Y'),
(226, 'General goods storage', '78131600', '3', NULL, 'Y'),
(227, 'Wire protection devices', '39131600', '3', NULL, 'Y'),
(228, 'Valves', '40141600', '3', NULL, 'Y'),
(229, 'Crop protection', '70141600', '3', NULL, 'Y'),
(230, 'Sales and business promotion activities', '80141600', '3', NULL, 'Y'),
(231, 'Non metallic waste and scrap', '11141600', '3', NULL, 'Y'),
(232, 'Supply chain management', '81141600', '3', NULL, 'Y'),
(233, 'Domestic laundry appliances and supplies', '52141600', '3', NULL, 'Y'),
(234, 'Graphic display services', '82141600', '3', NULL, 'Y'),
(235, 'Rare earth metals', '12141600', '3', NULL, 'Y'),
(236, 'Basins and bedpans and urinals and admission kits', '42141600', '3', NULL, 'Y'),
(237, 'Mass transit system construction services', '72141600', '3', NULL, 'Y'),
(238, 'Leather preparing machinery and accessories', '23141600', '3', NULL, 'Y'),
(239, 'Thread and yarn processing', '73141600', '3', NULL, 'Y'),
(240, 'Population', '93141600', '3', NULL, 'Y'),
(241, 'Miscellaneous sewing supplies', '53141600', '3', NULL, 'Y'),
(242, 'Cushioning supplies', '24141600', '3', NULL, 'Y'),
(243, 'Personal credit agencies', '84141600', '3', NULL, 'Y'),
(244, 'Prefabricated residential buildings and structures', '95141600', '3', NULL, 'Y'),
(245, 'Darkroom supplies', '45141600', '3', NULL, 'Y'),
(246, 'Herbal treatments', '85141600', '3', NULL, 'Y'),
(247, 'Subcritical assembly equipment', '26141600', '3', NULL, 'Y'),
(248, 'Students organizations', '86141600', '3', NULL, 'Y'),
(249, 'Inspection', '78141600', '3', NULL, 'Y'),
(250, 'Cereal seeds', '10151600', '3', NULL, 'Y'),
(251, 'Roofing accessories', '30151600', '3', NULL, 'Y'),
(252, 'Compressors', '40151600', '3', NULL, 'Y'),
(253, 'Edible animal oils and fats', '50151600', '3', NULL, 'Y'),
(254, 'Forestry industry', '70151600', '3', NULL, 'Y'),
(255, 'International trade services', '80151600', '3', NULL, 'Y'),
(256, 'Threads', '11151600', '3', NULL, 'Y'),
(257, 'Chains', '31151600', '3', NULL, 'Y'),
(258, 'Cholinergic blocking agents', '51151600', '3', NULL, 'Y'),
(259, 'Cartography', '81151600', '3', NULL, 'Y'),
(260, 'Clinical laboratory instruments', '41151600', '3', NULL, 'Y'),
(261, 'Dental and subspecialty instruments and devices', '42151600', '3', NULL, 'Y'),
(262, 'Domestic kitchen tools and utensils', '52151600', '3', NULL, 'Y'),
(263, 'Specialized communication system services', '72151600', '3', NULL, 'Y'),
(264, 'Cement and ceramics and glass industry machinery and equipment and supplies', '23151600', '3', NULL, 'Y'),
(265, 'Packaging services', '73151600', '3', NULL, 'Y'),
(266, 'Public finance', '93151600', '3', NULL, 'Y'),
(267, 'Nutrition issues', '85151600', '3', NULL, 'Y'),
(268, 'Security and control equipment', '46151600', '3', NULL, 'Y'),
(269, 'Ceiling materials', '30161600', '3', NULL, 'Y'),
(270, 'Purification', '40161600', '3', NULL, 'Y'),
(271, 'Flora', '70161600', '3', NULL, 'Y'),
(272, 'Business facilities oversight', '80161600', '3', NULL, 'Y'),
(273, 'Wool fabrics', '11161600', '3', NULL, 'Y'),
(274, 'Bolts', '31161600', '3', NULL, 'Y'),
(275, 'Other oilfield support services', '71161600', '3', NULL, 'Y'),
(276, 'Electronic mail and messaging services', '81161600', '3', NULL, 'Y'),
(277, 'Extracorporeal hemodialysis equipment and supplies', '42161600', '3', NULL, 'Y'),
(278, 'Audio visual equipment accessories', '52161600', '3', NULL, 'Y'),
(279, 'Foundry supplies', '23161600', '3', NULL, 'Y'),
(280, 'Manufacture of transport equipment', '73161600', '3', NULL, 'Y'),
(281, 'Taxes other than income tax', '93161600', '3', NULL, 'Y'),
(282, 'Water safety', '46161600', '3', NULL, 'Y'),
(283, 'Racquet and court sports equipment', '49161600', '3', NULL, 'Y'),
(284, 'Chemical fertilizers and plant nutrients', '10171600', '3', NULL, 'Y'),
(285, 'Windows', '30171600', '3', NULL, 'Y'),
(286, 'Water quality management services', '70171600', '3', NULL, 'Y'),
(287, 'Publicity and marketing support services', '80171600', '3', NULL, 'Y'),
(288, 'Bushings', '31171600', '3', NULL, 'Y'),
(289, 'Laxatives', '51171600', '3', NULL, 'Y'),
(290, 'Stainless steel alloys', '11171600', '3', NULL, 'Y'),
(291, 'Ecological science services', '81171600', '3', NULL, 'Y'),
(292, 'Microbiology devices', '41171600', '3', NULL, 'Y'),
(293, 'Pigments', '12171600', '3', NULL, 'Y'),
(294, 'Mobile medical services extricating and immobilizing and transporting products', '42171600', '3', NULL, 'Y'),
(295, 'Manufacture of precision instruments', '73171600', '3', NULL, 'Y'),
(296, 'International trade', '93171600', '3', NULL, 'Y'),
(297, 'Defrosting and defogging systems', '25171600', '3', NULL, 'Y'),
(298, 'Hospice care', '85171600', '3', NULL, 'Y'),
(299, 'Surveillance and detection equipment', '46171600', '3', NULL, 'Y'),
(300, 'Boxing equipment', '49171600', '3', NULL, 'Y'),
(301, 'Non sanitary residential fixtures', '30181600', '3', NULL, 'Y'),
(302, 'Thyroid and antithyroid drugs', '51181600', '3', NULL, 'Y'),
(303, 'Blood pressure units and related products', '42181600', '3', NULL, 'Y'),
(304, 'Oils', '12181600', '3', NULL, 'Y'),
(305, 'Food cutting machinery', '23181600', '3', NULL, 'Y'),
(306, 'Automotive chassis', '25181600', '3', NULL, 'Y'),
(307, 'Safety footwear', '46181600', '3', NULL, 'Y'),
(308, 'Panel and paint services', '78181600', '3', NULL, 'Y'),
(309, 'Ladders and scaffolding accessories', '30191600', '3', NULL, 'Y'),
(310, 'Abrasive wheels', '31191600', '3', NULL, 'Y'),
(311, 'Electrolytes', '51191600', '3', NULL, 'Y'),
(312, 'Medical facility building systems', '42191600', '3', NULL, 'Y'),
(313, 'Personal communications device accessories or parts', '43191600', '3', NULL, 'Y'),
(314, 'Space transportation support systems and equipment', '25191600', '3', NULL, 'Y'),
(315, 'Fire fighting equipment', '46191600', '3', NULL, 'Y'),
(316, 'Adhesives', '31201600', '3', NULL, 'Y'),
(317, 'Vaccines and antigens and toxoids', '51201600', '3', NULL, 'Y'),
(318, 'Medical magnetic resonance imaging MRI products', '42201600', '3', NULL, 'Y'),
(319, 'Chassis components', '43201600', '3', NULL, 'Y'),
(320, 'Weight and resistance training equipment', '49201600', '3', NULL, 'Y'),
(321, 'Paint additives', '31211600', '3', NULL, 'Y'),
(322, 'Bathroom and bathing aids for the physically challenged', '42211600', '3', NULL, 'Y'),
(323, 'Weighing machinery excluding balances of a sensitivity of 5 cg or better of tariff number 84233100 including weight operated counting or checking machines weighing machine weights of all kinds upon approval by CS Health', '99011129', '4', NULL, 'Y'),
(324, 'Fetal Doppler Pocket Wgd002 Pc and pulse oximeter finger held Gima band Pc of tariff number 90181900 upon approval by the cabinet sectretary responsible for matters relating to health ', '99011130', '4', NULL, 'Y'),
(325, 'Sterilizer Dry Heat Wgd001Grx05A Pc autoclave steam tables tops of tariff number 8419902000 upon approval by the cabinet sectretary responsible for matters relating to health ', '99011131', '4', NULL, 'Y'),
(326, 'Needle holders and urine bags of tariff heading 399026', '99011132', '4', NULL, 'Y'),
(327, 'Tourniquets of tariff number 3990269099 for use by licensed hospitals upon approval by the cabinet sectretary responsible for matters relating to health ', '99011133', '4', NULL, 'Y'),
(328, 'Taxable supplies incl. fish feeding and handling water operations cold storage fish cages pond construction, maintenance, fish processing and handling imported or purchased for direct exclusive use on the recommendation of the relevant State Dept', '99011134', '4', NULL, 'Y'),
(329, 'Pre fabricated biogas digesters ', '99011135', '4', NULL, 'Y'),
(330, 'Biogas ', '99011136', '4', NULL, 'Y'),
(331, 'Sustainable fuel briquettes and pellets for household and commercial use ', '99011137', '4', NULL, 'Y'),
(332, 'The supply of denatured ethanol of tariff number 22072000', '99011138', '4', NULL, 'Y'),
(333, 'Tractors other than road tractors for semitrailers', '99011139', '4', NULL, 'Y'),
(334, 'Plant and machinery of chapter 84 and 85 imported by manufacturers of pharmaceutical products or investors in the manufacture of pharmaceutical products upon the recommendation of CS Health', '99011140', '4', NULL, 'Y'),
(335, 'Medical oxygen supplied to registered hospitals ', '99011141', '4', NULL, 'Y'),
(336, 'Urine bags adult diapers artificial breasts colostomy or ileostomy bags for medical use ', '99011142', '4', NULL, 'Y'),
(337, 'Inputs and raw materials  used in the manufacture of passenger motor vehicle ', '99011143', '4', NULL, 'Y'),
(338, 'Locally manufactured passenger motor vehicles: vehicles for the transportation of passengers whose ex-factory value comprises at least 30 percent of parts designed and manufactured in Kenya by an original equipment manufacturer operating in Kenya.', '99011144', '4', NULL, 'Y'),
(339, 'Taxable goods inputs and raw materials imported  or locally purchased by company under SOFA manufacturing human vaccines with a capital investment of atleast 10Bn shillings subject to approval of CS TNT upon recommendation of CS Health', '99011145', '4', NULL, 'Y'),
(340, 'Such capital goods the exemption of which the Cabinet Secretary may determine to promote investment in the manufacturing sector provided that the value of such investment is not less than two billion shillings ', '99011146', '4', NULL, 'Y'),
(341, 'Zero Rated Goods', '99012000', '3', NULL, 'Y'),
(342, 'Shipstores supplied to international sea or air carriers on international voyage or flight', '99012003', '4', NULL, 'Y'),
(343, 'The supply of coffee and tea for export to coffee or tea auction centers', '99012004', '4', NULL, 'Y'),
(344, 'Transportation of passengers by air carriers on international flight', '99012005', '4', NULL, 'Y'),
(345, 'Goods purchased from duty free shops by passengers departing to places outside Kenya', '99012009', '4', NULL, 'Y'),
(346, 'Inputs or raw materials either produced locally or imported supplied to pharmaceutical manufacturers in Kenya for manufacturing medicaments as approved from time to time by the Cabinet Secretary in consultation with CS Health', '99012011', '4', NULL, 'Y'),
(347, 'The supply of ordinary bread', '99012013', '4', NULL, 'Y'),
(348, 'Milk and cream not concentrated nor containing added sugar or other sweetening matter of tariff numbers 04011000 04012000 04014000 04015000', '99012015', '4', NULL, 'Y'),
(349, 'All inputs and raw materials whether produced locally or imported supplied to manufacturers of agricultural pest control products upon recommendation by CS Agriculture', '99012016', '4', NULL, 'Y'),
(350, 'Agricultural pest control products', '99012019', '4', NULL, 'Y'),
(351, 'The supply of maize corn flour cassava flour wheat or meslin flour and maize flour containing cassava flour by more than ten percent in weight', '99012022', '4', NULL, 'Y'),
(352, 'The Fertilizers of chapter 31', '99012024', '4', NULL, 'Y'),
(353, 'Inputs of raw materials locally purchased or imported by manufacturers of fertilizer as approved from time to time by the Cabinet Secretary responsible for Agriculture', '99012025', '4', NULL, 'Y'),
(354, 'Other Rate Goods (8%)', '99013000', '3', NULL, 'Y'),
(355, 'Petroleum Products', '99013001', '4', NULL, 'Y'),
(356, 'Services', '99020000', '2', NULL, 'Y'),
(357, 'Exempt Service', '99021000', '3', NULL, 'Y'),
(358, 'Financial Services', '99021001', '4', NULL, 'Y'),
(359, 'Insurance & reinsurance services ', '99021002', '4', NULL, 'Y'),
(360, 'Education services ', '99021003', '4', NULL, 'Y'),
(361, 'Medical veterinary dental  Ambulance and nursing services', '99021004', '4', NULL, 'Y'),
(362, 'Agricultural animal husbandry and horticultural services', '99021005', '4', NULL, 'Y'),
(363, 'Burial and cremation services', '99021006', '4', NULL, 'Y'),
(364, 'Transportation of passengers by any means of conveyance excluding international air transport or where the means of conveyance is hired or chartered', '99021007', '4', NULL, 'Y'),
(365, 'Supply by way of sale renting leasing hiring letting of land or residential premises residential premises means land or a building occupied or capable of being occupied as a residence excluding hotel and holiday accomodation and subject to the provi', '99021008', '4', NULL, 'Y'),
(366, 'Community social and welfare services provided by National Government County Government or any political subdivision thereof', '99021009', '4', NULL, 'Y'),
(367, 'Tea and coffee brokerage services', '99021010', '4', NULL, 'Y'),
(368, 'Services rendered by educational, political, religious, welfare & other philanthropic associations to their members and social welfare services provided by charitable organizations.', '99021011', '4', NULL, 'Y'),
(369, 'Entertainment Services', '99021012', '4', NULL, 'Y'),
(370, 'Accommodation and Restaurant Services', '99021013', '4', NULL, 'Y'),
(371, 'Conference services conducted for educational institutions as part of learning where such institutions are approved by the Ministry for the time being responsible for Education', '99021014', '4', NULL, 'Y'),
(372, 'Car park services provided by National Government County Government anypolitical subdivision therefore by an employer to his employees on the premises of the employer', '99021015', '4', NULL, 'Y'),
(373, 'The supply of airtime by any person other than by a provider of cellular mobile telephone services or wireless telephone services', '99021016', '4', NULL, 'Y'),
(374, 'Betting gaming and lotteries services', '99021017', '4', NULL, 'Y'),
(375, 'Hiring leasing and chartering of aircrafts excluding helicopters of tariff 88021100 and 88021200', '99021018', '4', NULL, 'Y'),
(376, 'Taxable services for direct and exclusive use in the implementation of official aid funded projects upon approval by the Cabinet Secretary to the National Treasury', '99021020', '4', NULL, 'Y'),
(377, 'Services imported or procured locally for use by the local film producers or local film agents upon recommendation by the Kenya Film Commission subject to approval by the Cabinet Secretary for the National Treasury', '99021021', '4', NULL, 'Y'),
(378, 'Supply of sewerage services by the national government a county government any political subdivision thereof or a person approved by the Cabinet Secretary for the time being responsible for water development', '99021023', '4', NULL, 'Y'),
(379, 'Entry fees into the national parks and national reserves', '99021024', '4', NULL, 'Y'),
(380, 'The services of tour operators excluding inhouse supplies', '99021025', '4', NULL, 'Y'),
(381, 'Taxable services for direct and exclusive use for the construction of tourism facilities recreational parks of 50 acres or more convention and conference facilities upon the recommendation by the CS responsible for  recreational park', '99021026', '4', NULL, 'Y'),
(382, 'Taxable services for direct and exclusive use for the construction of specialized hospitals with accommodation facilities upon recommendation by CS Health who shall issue guidelines for the criteria to determine the eligibility for the exemption', '99021027', '4', NULL, 'Y'),
(383, 'Postal services provide through the supply of postage stamps including rental post boxes or mail bags and subsidiary services thereto', '99021029', '4', NULL, 'Y'),
(384, 'The transfer of assets and other transactions related to the transfer of asets into real estate investment trusts and asset backed securities', '99021033', '4', NULL, 'Y'),
(385, 'Zero Rated Service', '99022000', '3', NULL, 'Y'),
(386, 'The supply of taxable services to international sea or air carriers on international voyage or flight', '99022006', '4', NULL, 'Y'),
(387, 'Supply of taxable services in respect of goods in transit', '99022010', '4', NULL, 'Y'),
(388, 'The transportation of goods originating from Kenya to a place outside Kenya', '99022020', '4', NULL, 'Y'),
(389, 'Transportation of sugarcane from farms to miling factories', '99022021', '4', NULL, 'Y'),
(390, 'The exportation of taxable services in respect of business process outsourcing ', '99022023', '4', NULL, 'Y'),
(391, 'Goods or Services', '99030000', '2', NULL, 'Y'),
(392, 'Exempt Goods or Services', '99031000', '3', NULL, 'Y'),
(393, 'Zero Rated Goods or Services', '99032000', '3', NULL, 'Y'),
(394, 'The supply of goods or taxable services to an export processing zone business as specified in the Export Processing Zones Act Cap 517 as being eligible forduty and tax free importation', '99032002', '4', NULL, 'Y'),
(395, 'Supply to international and regional organizations', '99032004', '4', NULL, 'Y'),
(396, 'Supply to the War Graves Commission', '99032005', '4', NULL, 'Y'),
(397, 'Supply to National Red Cross Society and St John Ambulance', '99032008', '4', NULL, 'Y'),
(398, 'The supply of goods or taxable services to a special economic zone enterprise', '99032012', '4', NULL, 'Y'),
(399, 'Government Undertaking', '99040000', '2', NULL, 'Y'),
(400, 'Zero Rated Government Undertaking', '99042000', '3', NULL, 'Y'),
(401, 'Physical and occupational therapy and rehabilitation products', '42250000', '2', NULL, 'Y'),
(402, 'Metal forming machinery and accessories', '23250000', '2', NULL, 'Y'),
(403, 'Structural materials', '30260000', '2', NULL, 'Y'),
(404, 'Housings and cabinets and casings', '31260000', '2', NULL, 'Y'),
(405, 'Adrenergic blocking agents', '51260000', '2', NULL, 'Y'),
(406, 'Postmortem and mortuary equipment and supplies', '42260000', '2', NULL, 'Y'),
(407, 'Rapid prototyping machinery and accessories', '23260000', '2', NULL, 'Y'),
(408, 'Diagnoses of endocrine, nutritional and metabolic diseases  ', '85260000', '2', NULL, 'Y'),
(409, 'Machine made parts', '31270000', '2', NULL, 'Y'),
(410, 'Anaesthetic drugs and related adjuncts and analeptics', '51270000', '2', NULL, 'Y'),
(411, 'Respiratory and anesthesia and resuscitation products', '42270000', '2', NULL, 'Y'),
(412, 'Welding and soldering and brazing machinery and accessories and supplies', '23270000', '2', NULL, 'Y'),
(413, 'Diagnoses of mental and behavioral disorders  ', '85270000', '2', NULL, 'Y'),
(414, 'Stampings and sheet components', '31280000', '2', NULL, 'Y'),
(415, 'Antibacterials', '51280000', '2', NULL, 'Y'),
(416, 'Medical cleaning and sterilization products', '42280000', '2', NULL, 'Y'),
(417, 'Metal treatment machinery', '23280000', '2', NULL, 'Y'),
(418, 'Antidepressants', '51290000', '2', NULL, 'Y'),
(419, 'Machined extrusions', '31290000', '2', NULL, 'Y'),
(420, 'Surgical products', '42290000', '2', NULL, 'Y'),
(421, 'Industrial machine tools', '23290000', '2', NULL, 'Y'),
(422, 'Fresh fruits', '50300000', '2', NULL, 'Y'),
(423, 'Antifungal drugs', '51300000', '2', NULL, 'Y'),
(424, 'Machined forgings', '31300000', '2', NULL, 'Y'),
(425, 'Medical training and education supplies', '42300000', '2', NULL, 'Y'),
(426, 'Wire machinery and equipment', '23300000', '2', NULL, 'Y'),
(427, 'Organic fresh fruits', '50310000', '2', NULL, 'Y'),
(428, 'Antihistamines or H1 blockers', '51310000', '2', NULL, 'Y'),
(429, 'Fabricated pipe assemblies', '31310000', '2', NULL, 'Y'),
(430, 'Wound care products', '42310000', '2', NULL, 'Y'),
(431, 'Dried fruit', '50320000', '2', NULL, 'Y'),
(432, 'Antihyperlipidemic and hypocholesterolemic agents', '51320000', '2', NULL, 'Y'),
(433, 'Fabricated bar stock assemblies', '31320000', '2', NULL, 'Y'),
(434, 'Orthopedic surgical implants', '42320000', '2', NULL, 'Y'),
(435, 'Dried organic fruit', '50330000', '2', NULL, 'Y'),
(436, 'Antipsychotics', '51330000', '2', NULL, 'Y'),
(437, 'Fabricated structural assemblies', '31330000', '2', NULL, 'Y'),
(438, 'Frozen fruit', '50340000', '2', NULL, 'Y'),
(439, 'Antiviral drugs', '51340000', '2', NULL, 'Y'),
(440, 'Fabricated sheet assemblies', '31340000', '2', NULL, 'Y'),
(441, 'Estrogens and progestins and internal contraceptives', '51350000', '2', NULL, 'Y'),
(442, 'Fabricated tube assemblies', '31350000', '2', NULL, 'Y'),
(443, 'Compounds and mixtures', '12350000', '2', NULL, 'Y'),
(444, 'Canned or jarred fruit', '50360000', '2', NULL, 'Y'),
(445, 'Hypnotics', '51360000', '2', NULL, 'Y'),
(446, 'Fabricated plate assemblies', '31360000', '2', NULL, 'Y'),
(447, 'Canned or jarred organic fruit', '50370000', '2', NULL, 'Y'),
(448, 'Refractories', '31370000', '2', NULL, 'Y'),
(449, 'Controlled substance analgesics', '51370000', '2', NULL, 'Y'),
(450, 'Fresh fruit purees', '50380000', '2', NULL, 'Y'),
(451, 'Nonsteroidal anti inflammatory drugs NSAIDs', '51380000', '2', NULL, 'Y'),
(452, 'Magnets and magnetic materials', '31380000', '2', NULL, 'Y'),
(453, 'Diagnoses of certain conditions originating in the perinatal period', '85380000', '2', NULL, 'Y'),
(454, 'Sympathomimetic or adrenergic drugs', '51390000', '2', NULL, 'Y'),
(455, 'Machinings', '31390000', '2', NULL, 'Y'),
(456, 'Fresh vegetables', '50400000', '2', NULL, 'Y'),
(457, 'Tranquilizers and antimanic and antianxiety drugs', '51400000', '2', NULL, 'Y'),
(458, 'Gaskets', '31400000', '2', NULL, 'Y'),
(459, 'Organic fresh vegetables', '50410000', '2', NULL, 'Y'),
(460, 'Vasodilators', '51410000', '2', NULL, 'Y'),
(461, 'Seals', '31410000', '2', NULL, 'Y'),
(462, 'Dried vegetables', '50420000', '2', NULL, 'Y'),
(463, 'Corticosteroids', '51420000', '2', NULL, 'Y'),
(464, 'Sintered parts', '31420000', '2', NULL, 'Y'),
(465, 'Dried organic vegetables', '50430000', '2', NULL, 'Y'),
(466, 'Antihypertensive drugs', '51430000', '2', NULL, 'Y'),
(467, 'Frozen vegetables', '50440000', '2', NULL, 'Y'),
(468, 'Radiopharmaceuticals and contrast media', '51440000', '2', NULL, 'Y'),
(469, 'Frozen organic vegetables', '50450000', '2', NULL, 'Y'),
(470, 'Anthelmintics', '51450000', '2', NULL, 'Y'),
(471, 'Canned or jarred vegetables', '50460000', '2', NULL, 'Y'),
(472, 'Herbal drugs', '51460000', '2', NULL, 'Y'),
(473, 'Canned or jarred organic vegetables', '50470000', '2', NULL, 'Y'),
(474, 'Antiseptics', '51470000', '2', NULL, 'Y'),
(475, 'Nutritional supplements', '50500000', '2', NULL, 'Y'),
(476, 'Rapid response kits', '57010100', '3', NULL, 'Y'),
(477, 'Humanitarian operational services', '57020100', '3', NULL, 'Y'),
(478, 'Health emergency kits', '57030100', '3', NULL, 'Y'),
(479, 'Educational kits', '57040100', '3', NULL, 'Y'),
(480, 'Emergency nutritional kits', '57050100', '3', NULL, 'Y'),
(481, 'Emergency clothing kits', '57060100', '3', NULL, 'Y'),
(482, 'Logistics emergency kits', '57070100', '3', NULL, 'Y'),
(483, 'Emergency IT equipment kits', '57080100', '3', NULL, 'Y'),
(484, 'Training services for users of agricultural machinery and equipment ', '70190100', '3', NULL, 'Y'),
(485, 'Emergency latrine facility', '57030200', '3', NULL, 'Y'),
(486, 'Recreational kits', '57040200', '3', NULL, 'Y'),
(487, 'Food emergency rations', '57050200', '3', NULL, 'Y'),
(488, 'Shelter emergency kits', '57060200', '3', NULL, 'Y'),
(489, 'Water, sanitation and hygiene kits', '57030300', '3', NULL, 'Y'),
(490, 'Early childhood development', '57040300', '3', NULL, 'Y'),
(491, 'Food emergency kits', '57050300', '3', NULL, 'Y'),
(492, 'Office emergency kits', '57060300', '3', NULL, 'Y'),
(493, 'Personal protective equipment', '57030400', '3', NULL, 'Y'),
(494, 'Multipurpose emergency kits', '57060400', '3', NULL, 'Y'),
(495, 'Single family dwelling construction services', '72111000', '3', NULL, 'Y'),
(496, 'Resins', '13111000', '3', NULL, 'Y'),
(497, 'New industrial building and warehouse construction services', '72121000', '3', NULL, 'Y'),
(498, 'Library furnishings', '56121000', '3', NULL, 'Y'),
(499, 'Power conditioning equipment', '39121000', '3', NULL, 'Y'),
(500, 'Keyboard instruments', '60131000', '3', NULL, 'Y'),
(501, 'Electronic component parts and raw materials and accessories', '32131000', '3', NULL, 'Y'),
(502, 'Toys', '60141000', '3', NULL, 'Y'),
(503, 'Highway and road construction services', '72141000', '3', NULL, 'Y'),
(504, 'Body tools', '27141000', '3', NULL, 'Y'),
(505, 'Boiler and furnace construction and maintenance services', '72151000', '3', NULL, 'Y'),
(506, 'Oilfield modeling services', '71161000', '3', NULL, 'Y'),
(507, 'Batch mixers', '23191000', '3', NULL, 'Y'),
(508, 'Gas liquid contacting systems', '23201000', '3', NULL, 'Y'),
(509, 'Public safety training equipment', '46201000', '3', NULL, 'Y'),
(510, 'Airport Maintenance', '78201000', '3', NULL, 'Y'),
(511, 'Pulses', '50221000', '3', NULL, 'Y'),
(512, 'Arrival department machinery and equipment', '23221000', '3', NULL, 'Y'),
(513, 'Log debarkers and accessories', '23231000', '3', NULL, 'Y'),
(514, 'Electric alternating current AC motors', '26101100', '3', NULL, 'Y'),
(515, 'Multiple unit dwelling construction services', '72111100', '3', NULL, 'Y'),
(516, 'Rosins', '13111100', '3', NULL, 'Y'),
(517, 'Rapid response kits', '57111100', '3', NULL, 'Y'),
(518, 'Commercial and office building construction services', '72121100', '3', NULL, 'Y'),
(519, 'Distribution and control centers and accessories', '39121100', '3', NULL, 'Y'),
(520, 'Live Plant and Animal Material and Accessories and Supplies', '10000000', '1', NULL, 'Y'),
(521, 'Mining and Well Drilling Machinery and Accessories', '20000000', '1', NULL, 'Y'),
(522, 'Structures and Building and Construction and Manufacturing Components and Supplies', '30000000', '1', NULL, 'Y'),
(523, 'Distribution and Conditioning Systems and Equipment and Components', '40000000', '1', NULL, 'Y'),
(524, 'Food Beverage and Tobacco Products', '50000000', '1', NULL, 'Y'),
(525, 'Farming and Fishing and Forestry and Wildlife Contracting Services', '70000000', '1', NULL, 'Y'),
(526, 'Management and Business Professionals and Administrative Services', '80000000', '1', NULL, 'Y'),
(527, 'Travel and Food and Lodging and Entertainment Services', '90000000', '1', NULL, 'Y'),
(528, 'Musical Instruments and Games and Toys and Arts and Crafts and Educational Equipment and Materials and Accessories and Supplies', '60000000', '1', NULL, 'Y'),
(529, 'Mineral and Textile and Inedible Plant and Animal Materials', '11000000', '1', NULL, 'Y'),
(530, 'Farming and Fishing and Forestry and Wildlife Machinery and Accessories', '21000000', '1', NULL, 'Y'),
(531, 'Manufacturing Components and Supplies', '31000000', '1', NULL, 'Y'),
(532, 'Laboratory and Measuring and Observing and Testing Equipment', '41000000', '1', NULL, 'Y'),
(533, 'Drugs and Pharmaceutical Products', '51000000', '1', NULL, 'Y'),
(534, 'Mining and oil and gas services', '71000000', '1', NULL, 'Y'),
(535, 'Engineering and Research and Technology Based Services', '81000000', '1', NULL, 'Y'),
(536, 'Personal and Domestic Services', '91000000', '1', NULL, 'Y'),
(537, 'Chemicals including Bio Chemicals and Gas Materials', '12000000', '1', NULL, 'Y'),
(538, 'Building and Construction Machinery and Accessories', '22000000', '1', NULL, 'Y'),
(539, 'Electronic Components and Supplies', '32000000', '1', NULL, 'Y'),
(540, 'Medical Equipment and Accessories and Supplies', '42000000', '1', NULL, 'Y'),
(541, 'Domestic Appliances and Supplies and Consumer Electronic Products', '52000000', '1', NULL, 'Y'),
(542, 'Building and Facility Construction and Maintenance Services ', '72000000', '1', NULL, 'Y'),
(543, 'Editorial and Design and Graphic and Fine Art Services', '82000000', '1', NULL, 'Y'),
(544, 'National Defense and Public Order and Security and Safety Services', '92000000', '1', NULL, 'Y'),
(545, 'Resin and Rosin and Rubber and Foam and Film and Elastomeric Materials', '13000000', '1', NULL, 'Y'),
(546, 'Industrial Manufacturing and Processing Machinery and Accessories', '23000000', '1', NULL, 'Y'),
(547, 'Information Technology Broadcasting and Telecommunications', '43000000', '1', NULL, 'Y'),
(548, 'Apparel and Luggage and Personal Care Products', '53000000', '1', NULL, 'Y'),
(549, 'Industrial Production and Manufacturing Services', '73000000', '1', NULL, 'Y'),
(550, 'Public Utilities and Public Sector Related Services', '83000000', '1', NULL, 'Y'),
(551, 'Politics and Civic Affairs Services', '93000000', '1', NULL, 'Y'),
(552, 'Paper Materials and Products', '14000000', '1', NULL, 'Y'),
(553, 'Material Handling and Conditioning and Storage Machinery and their Accessories and Supplies', '24000000', '1', NULL, 'Y');
INSERT INTO `itemclassification` (`id`, `name`, `itm_class_code`, `itm_class_level`, `tax_type_code`, `status`) VALUES
(554, 'Office Equipment and Accessories and Supplies', '44000000', '1', NULL, 'Y'),
(555, 'Timepieces and Jewelry and Gemstone Products', '54000000', '1', NULL, 'Y'),
(556, 'Financial and Insurance Services', '84000000', '1', NULL, 'Y'),
(557, 'Organizations and Clubs', '94000000', '1', NULL, 'Y'),
(558, 'Financial Instruments, Products, Contracts and Agreements', '64000000', '1', NULL, 'Y'),
(559, 'Fuels and Fuel Additives and Lubricants and Anti corrosive Materials', '15000000', '1', NULL, 'Y'),
(560, 'Commercial and Military and Private Vehicles and their Accessories and Components', '25000000', '1', NULL, 'Y'),
(561, 'Printing and Photographic and Audio and Visual Equipment and Supplies', '45000000', '1', NULL, 'Y'),
(562, 'Published Products', '55000000', '1', NULL, 'Y'),
(563, 'Healthcare Services', '85000000', '1', NULL, 'Y'),
(564, 'Land and Buildings and Structures and Thoroughfares', '95000000', '1', NULL, 'Y'),
(565, 'Power Generation and Distribution Machinery and Accessories', '26000000', '1', NULL, 'Y'),
(566, 'Defense and Law Enforcement and Security and Safety Equipment and Supplies', '46000000', '1', NULL, 'Y'),
(567, 'Industrial Cleaning Services', '76000000', '1', NULL, 'Y'),
(568, 'Education and Training Services', '86000000', '1', NULL, 'Y'),
(569, 'Furniture and Furnishings', '56000000', '1', NULL, 'Y'),
(570, 'Tools and General Machinery', '27000000', '1', NULL, 'Y'),
(571, 'Cleaning Equipment and Supplies', '47000000', '1', NULL, 'Y'),
(572, 'Environmental Services', '77000000', '1', NULL, 'Y'),
(573, 'Humanitarian Relief Items, Kits, or Accessories', '57000000', '1', NULL, 'Y'),
(574, 'Service Industry Machinery and Equipment and Supplies', '48000000', '1', NULL, 'Y'),
(575, 'Transportation and Storage and Mail Services', '78000000', '1', NULL, 'Y'),
(576, 'Electrical Systems and Lighting and Components and Accessories and Supplies', '39000000', '1', NULL, 'Y'),
(577, 'Sports and Recreational Equipment and Supplies and Accessories', '49000000', '1', NULL, 'Y'),
(578, 'Survival supplies', '57010000', '2', NULL, 'Y'),
(579, 'Services related to humanitarian relief actions', '57020000', '2', NULL, 'Y'),
(580, 'Humanitarian health supplies', '57030000', '2', NULL, 'Y'),
(581, 'Educational or recreational items', '57040000', '2', NULL, 'Y'),
(582, 'Humanitarian relief food', '57050000', '2', NULL, 'Y'),
(583, 'Shelter and relief items', '57060000', '2', NULL, 'Y'),
(584, 'Humanitarian logistics supplies', '57070000', '2', NULL, 'Y'),
(585, 'Humanitarian IT equipment', '57080000', '2', NULL, 'Y'),
(586, 'Live animals', '10100000', '2', NULL, 'Y'),
(587, 'Mining and quarrying machinery and equipment', '20100000', '2', NULL, 'Y'),
(588, 'Structural components and basic shapes', '30100000', '2', NULL, 'Y'),
(589, 'Heating and ventilation and air circulation', '40100000', '2', NULL, 'Y'),
(590, 'Nuts and seeds', '50100000', '2', NULL, 'Y'),
(591, 'Fisheries and aquaculture', '70100000', '2', NULL, 'Y'),
(592, 'Management advisory services', '80100000', '2', NULL, 'Y'),
(593, 'Restaurants and catering', '90100000', '2', NULL, 'Y'),
(594, 'Developmental and professional teaching aids and materials and accessories and supplies', '60100000', '2', NULL, 'Y'),
(595, 'Minerals and ores and metals', '11100000', '2', NULL, 'Y'),
(596, 'Agricultural and forestry and landscape machinery and equipment', '21100000', '2', NULL, 'Y'),
(597, 'Castings and casting assemblies', '31100000', '2', NULL, 'Y'),
(598, 'Laboratory and scientific equipment', '41100000', '2', NULL, 'Y'),
(599, 'Amebicides and trichomonacides and antiprotozoals', '51100000', '2', NULL, 'Y'),
(600, 'Mining services', '71100000', '2', NULL, 'Y'),
(601, 'Professional engineering services', '81100000', '2', NULL, 'Y'),
(602, 'Personal appearance', '91100000', '2', NULL, 'Y'),
(603, 'Heavy construction machinery and equipment', '22100000', '2', NULL, 'Y'),
(604, 'Printed circuits and integrated circuits and microassemblies', '32100000', '2', NULL, 'Y'),
(605, 'Floor coverings', '52100000', '2', NULL, 'Y'),
(606, 'Building and facility maintenance and repair services', '72100000', '2', NULL, 'Y'),
(607, 'Advertising', '82100000', '2', NULL, 'Y'),
(608, 'Public order and safety', '92100000', '2', NULL, 'Y'),
(609, 'Rubber and elastomers', '13100000', '2', NULL, 'Y'),
(610, 'Raw materials processing machinery', '23100000', '2', NULL, 'Y'),
(611, 'Clothing', '53100000', '2', NULL, 'Y'),
(612, 'Plastic and chemical industries', '73100000', '2', NULL, 'Y'),
(613, 'Utilities', '83100000', '2', NULL, 'Y'),
(614, 'Political systems and institutions', '93100000', '2', NULL, 'Y'),
(615, 'Paper materials', '14100000', '2', NULL, 'Y'),
(616, 'Material handling machinery and equipment', '24100000', '2', NULL, 'Y'),
(617, 'Office machines and their supplies and accessories', '44100000', '2', NULL, 'Y'),
(618, 'Jewelry', '54100000', '2', NULL, 'Y'),
(619, 'Development finance', '84100000', '2', NULL, 'Y'),
(620, 'Work related organizations', '94100000', '2', NULL, 'Y'),
(621, 'Bank offered products ', '64100000', '2', NULL, 'Y'),
(622, 'Fuels', '15100000', '2', NULL, 'Y'),
(623, 'Motor vehicles', '25100000', '2', NULL, 'Y'),
(624, 'Printing and publishing equipment', '45100000', '2', NULL, 'Y'),
(625, 'Printed media', '55100000', '2', NULL, 'Y'),
(626, 'Comprehensive health services', '85100000', '2', NULL, 'Y'),
(627, 'Land parcels', '95100000', '2', NULL, 'Y'),
(628, 'Power sources', '26100000', '2', NULL, 'Y'),
(629, 'Light weapons and ammunition', '46100000', '2', NULL, 'Y'),
(630, 'Accommodation furniture', '56100000', '2', NULL, 'Y'),
(631, 'Decontamination services', '76100000', '2', NULL, 'Y'),
(632, 'Vocational training', '86100000', '2', NULL, 'Y'),
(633, 'Water and wastewater treatment supply and disposal', '47100000', '2', NULL, 'Y'),
(634, 'Environmental management', '77100000', '2', NULL, 'Y'),
(635, 'Institutional food services equipment', '48100000', '2', NULL, 'Y'),
(636, 'Mail and cargo transport', '78100000', '2', NULL, 'Y'),
(637, 'Lamps and lightbulbs and lamp components', '39100000', '2', NULL, 'Y'),
(638, 'Collectibles and awards', '49100000', '2', NULL, 'Y'),
(639, 'Well drilling and operation equipment', '20110000', '2', NULL, 'Y'),
(640, 'Concrete and cement and plaster', '30110000', '2', NULL, 'Y'),
(641, 'Meat and poultry products', '50110000', '2', NULL, 'Y'),
(642, 'Horticulture', '70110000', '2', NULL, 'Y'),
(643, 'Human resources services', '80110000', '2', NULL, 'Y'),
(644, 'Hotels and lodging and meeting facilities', '90110000', '2', NULL, 'Y'),
(645, 'Domestic pet products', '10110000', '2', NULL, 'Y'),
(646, 'Classroom decoratives and supplies', '60110000', '2', NULL, 'Y'),
(647, 'Earth and stone', '11110000', '2', NULL, 'Y'),
(648, 'Fishing and aquaculture equipment', '21110000', '2', NULL, 'Y'),
(649, 'Extrusions', '31110000', '2', NULL, 'Y'),
(650, 'Measuring and observing and testing instruments', '41110000', '2', NULL, 'Y'),
(651, 'Antineoplastic agents', '51110000', '2', NULL, 'Y'),
(652, 'Oil and gas exploration services', '71110000', '2', NULL, 'Y'),
(653, 'Computer services', '81110000', '2', NULL, 'Y'),
(654, 'Domestic and personal assistance', '91110000', '2', NULL, 'Y'),
(655, 'Discrete semiconductor devices', '32110000', '2', NULL, 'Y'),
(656, 'Writing and translations', '82110000', '2', NULL, 'Y'),
(657, 'Military services and national defense', '92110000', '2', NULL, 'Y'),
(658, 'Residential building construction services', '72110000', '2', NULL, 'Y'),
(659, 'Petroleum processing machinery', '23110000', '2', NULL, 'Y'),
(660, 'Footwear', '53110000', '2', NULL, 'Y'),
(661, 'Wood and paper industries', '73110000', '2', NULL, 'Y'),
(662, 'Telecommunications media services', '83110000', '2', NULL, 'Y'),
(663, 'Socio political conditions', '93110000', '2', NULL, 'Y'),
(664, 'Resins and rosins and other resin derived materials', '13110000', '2', NULL, 'Y'),
(665, 'Paper products', '14110000', '2', NULL, 'Y'),
(666, 'Containers and storage', '24110000', '2', NULL, 'Y'),
(667, 'Office and desk accessories', '44110000', '2', NULL, 'Y'),
(668, 'Timepieces', '54110000', '2', NULL, 'Y'),
(669, 'Accounting and bookkeeping services', '84110000', '2', NULL, 'Y'),
(670, 'Religious organizations', '94110000', '2', NULL, 'Y'),
(671, 'Securities', '64110000', '2', NULL, 'Y'),
(672, 'Gaseous fuels and additives', '15110000', '2', NULL, 'Y'),
(673, 'Marine transport', '25110000', '2', NULL, 'Y'),
(674, 'Audio and visual presentation and composing equipment', '45110000', '2', NULL, 'Y'),
(675, 'Electronic reference material', '55110000', '2', NULL, 'Y'),
(676, 'Disease prevention and control', '85110000', '2', NULL, 'Y'),
(677, 'Thoroughfares', '95110000', '2', NULL, 'Y'),
(678, 'Batteries and generators and kinetic power transmission', '26110000', '2', NULL, 'Y'),
(679, 'Conventional war weapons', '46110000', '2', NULL, 'Y'),
(680, 'Cleaning and janitorial services', '76110000', '2', NULL, 'Y'),
(681, 'Alternative educational systems', '86110000', '2', NULL, 'Y'),
(682, 'Commercial and industrial furniture', '56110000', '2', NULL, 'Y'),
(683, 'Hand tools', '27110000', '2', NULL, 'Y'),
(684, 'Industrial laundry and dry cleaning equipment', '47110000', '2', NULL, 'Y'),
(685, 'Environmental protection', '77110000', '2', NULL, 'Y'),
(686, 'Passenger transport', '78110000', '2', NULL, 'Y'),
(687, 'Vending machines', '48110000', '2', NULL, 'Y'),
(688, 'Lighting Fixtures and Accessories', '39110000', '2', NULL, 'Y'),
(689, 'Animal feed', '10120000', '2', NULL, 'Y'),
(690, 'Roads and landscape', '30120000', '2', NULL, 'Y'),
(691, 'Seafood', '50120000', '2', NULL, 'Y'),
(692, 'Livestock services', '70120000', '2', NULL, 'Y'),
(693, 'Legal services', '80120000', '2', NULL, 'Y'),
(694, 'Travel facilitation', '90120000', '2', NULL, 'Y'),
(695, 'Arts and crafts equipment and accessories and supplies', '60120000', '2', NULL, 'Y'),
(696, 'Oil and gas drilling and exploration equipment', '20120000', '2', NULL, 'Y'),
(697, 'Non edible plant and forestry products', '11120000', '2', NULL, 'Y'),
(698, 'Laboratory supplies and fixtures', '41120000', '2', NULL, 'Y'),
(699, 'Antiarrythmics and antianginals and cardioplegics and drugs for heart failure', '51120000', '2', NULL, 'Y'),
(700, 'Economics', '81120000', '2', NULL, 'Y'),
(701, 'Well drilling and construction services', '71120000', '2', NULL, 'Y'),
(702, 'Passive discrete components', '32120000', '2', NULL, 'Y'),
(703, 'Veterinary equipment and supplies', '42120000', '2', NULL, 'Y'),
(704, 'Bedclothes and table and kitchen linen and towels', '52120000', '2', NULL, 'Y'),
(705, 'Reproduction services', '82120000', '2', NULL, 'Y'),
(706, 'Security and personal safety', '92120000', '2', NULL, 'Y'),
(707, 'Nonresidential building construction services', '72120000', '2', NULL, 'Y'),
(708, 'Textile and fabric machinery and accessories', '23120000', '2', NULL, 'Y'),
(709, 'Luggage and handbags and packs and cases', '53120000', '2', NULL, 'Y'),
(710, 'Metal and mineral industries', '73120000', '2', NULL, 'Y'),
(711, 'Information services', '83120000', '2', NULL, 'Y'),
(712, 'International relations', '93120000', '2', NULL, 'Y'),
(713, 'Industrial use papers', '14120000', '2', NULL, 'Y'),
(714, 'Packaging materials', '24120000', '2', NULL, 'Y'),
(715, 'Office supplies', '44120000', '2', NULL, 'Y'),
(716, 'Gemstones', '54120000', '2', NULL, 'Y'),
(717, 'Banking and investment', '84120000', '2', NULL, 'Y'),
(718, 'Clubs', '94120000', '2', NULL, 'Y'),
(719, 'Insurable interest contracts', '64120000', '2', NULL, 'Y'),
(720, 'Lubricants and oils and greases and anti corrosives', '15120000', '2', NULL, 'Y'),
(721, 'Railway and tramway machinery and equipment', '25120000', '2', NULL, 'Y'),
(722, 'Photographic or filming or video equipment', '45120000', '2', NULL, 'Y'),
(723, 'Signage and accessories', '55120000', '2', NULL, 'Y'),
(724, 'Medical practice', '85120000', '2', NULL, 'Y'),
(725, 'Permanent buildings and structures', '95120000', '2', NULL, 'Y'),
(726, 'Electrical wire and cable and harness', '26120000', '2', NULL, 'Y'),
(727, 'Missiles', '46120000', '2', NULL, 'Y'),
(728, 'Refuse disposal and treatment', '76120000', '2', NULL, 'Y'),
(729, 'Educational institutions', '86120000', '2', NULL, 'Y'),
(730, 'Classroom and instructional and institutional furniture and fixtures', '56120000', '2', NULL, 'Y'),
(731, 'Janitorial equipment', '47120000', '2', NULL, 'Y'),
(732, 'Pollution tracking and monitoring and rehabilitation', '77120000', '2', NULL, 'Y'),
(733, 'Hydraulic machinery and equipment', '27120000', '2', NULL, 'Y'),
(734, 'Material packing and handling', '78120000', '2', NULL, 'Y'),
(735, 'Gambling or wagering equipment', '48120000', '2', NULL, 'Y'),
(736, 'Electrical equipment and components and supplies', '39120000', '2', NULL, 'Y'),
(737, 'Camping and outdoor equipment and accessories', '49120000', '2', NULL, 'Y'),
(738, 'Structural building products', '30130000', '2', NULL, 'Y'),
(739, 'Musical Instruments and parts and accessories', '60130000', '2', NULL, 'Y'),
(740, 'Dairy products and eggs', '50130000', '2', NULL, 'Y'),
(741, 'Land and soil preparation and management and protection', '70130000', '2', NULL, 'Y'),
(742, 'Real estate services', '80130000', '2', NULL, 'Y'),
(743, 'Performing arts', '90130000', '2', NULL, 'Y'),
(744, 'Oil and gas drilling and operation materials', '20130000', '2', NULL, 'Y'),
(745, 'Animal containment and habitats', '10130000', '2', NULL, 'Y'),
(746, 'Non edible animal products', '11130000', '2', NULL, 'Y'),
(747, 'Forgings', '31130000', '2', NULL, 'Y'),
(748, 'Hematolic drugs', '51130000', '2', NULL, 'Y'),
(749, 'Statistics', '81130000', '2', NULL, 'Y'),
(750, 'Oil and gas extraction and production enhancement services', '71130000', '2', NULL, 'Y'),
(751, 'Explosive materials', '12130000', '2', NULL, 'Y'),
(752, 'Window treatments', '52130000', '2', NULL, 'Y'),
(753, 'Photographic services', '82130000', '2', NULL, 'Y'),
(754, 'Electronic hardware and component parts and accessories', '32130000', '2', NULL, 'Y'),
(755, 'Medical apparel and textiles', '42130000', '2', NULL, 'Y'),
(756, 'Lapidary machinery and equipment', '23130000', '2', NULL, 'Y'),
(757, 'Personal care products', '53130000', '2', NULL, 'Y'),
(758, 'Food and beverage industries', '73130000', '2', NULL, 'Y'),
(759, 'Humanitarian aid and relief', '93130000', '2', NULL, 'Y'),
(760, 'Industrial refrigeration', '24130000', '2', NULL, 'Y'),
(761, 'Civic organizations and associations and movements', '94130000', '2', NULL, 'Y'),
(762, 'Insurance and retirement services', '84130000', '2', NULL, 'Y'),
(763, 'Fuel for nuclear reactors', '15130000', '2', NULL, 'Y'),
(764, 'Aircraft', '25130000', '2', NULL, 'Y'),
(765, 'Photographic and recording media', '45130000', '2', NULL, 'Y'),
(766, 'Medical science research and experimentation', '85130000', '2', NULL, 'Y'),
(767, 'Portable buildings and structures', '95130000', '2', NULL, 'Y'),
(768, 'Power generation', '26130000', '2', NULL, 'Y'),
(769, 'Rockets and subsystems', '46130000', '2', NULL, 'Y'),
(770, 'Toxic and hazardous waste cleanup', '76130000', '2', NULL, 'Y'),
(771, 'Specialized educational services', '86130000', '2', NULL, 'Y'),
(772, 'Merchandising furniture and accessories', '56130000', '2', NULL, 'Y'),
(773, 'Cleaning and janitorial supplies', '47130000', '2', NULL, 'Y'),
(774, 'Pollutants tracking and monitoring and rehabilitation services', '77130000', '2', NULL, 'Y'),
(775, 'Pneumatic machinery and equipment', '27130000', '2', NULL, 'Y'),
(776, 'Storage', '78130000', '2', NULL, 'Y'),
(777, 'Funeral equipment and materials', '48130000', '2', NULL, 'Y'),
(778, 'Fishing and hunting equipment', '49130000', '2', NULL, 'Y'),
(779, 'Electrical wire management devices and accessories and supplies', '39130000', '2', NULL, 'Y'),
(780, 'Saddlery and harness goods', '10140000', '2', NULL, 'Y'),
(781, 'Insulation', '30140000', '2', NULL, 'Y'),
(782, 'Fluid and gas distribution', '40140000', '2', NULL, 'Y'),
(783, 'Toys and games', '60140000', '2', NULL, 'Y'),
(784, 'Crop production and management and protection', '70140000', '2', NULL, 'Y'),
(785, 'Marketing and distribution', '80140000', '2', NULL, 'Y'),
(786, 'Commercial sports', '90140000', '2', NULL, 'Y'),
(787, 'Oil and gas operating and production equipment', '20140000', '2', NULL, 'Y'),
(788, 'Scrap and waste materials', '11140000', '2', NULL, 'Y'),
(789, 'Moldings', '31140000', '2', NULL, 'Y'),
(790, 'Central nervous system drugs', '51140000', '2', NULL, 'Y'),
(791, 'Manufacturing technologies', '81140000', '2', NULL, 'Y'),
(792, 'Oil and gas restoration and reclamation services', '71140000', '2', NULL, 'Y'),
(793, 'Domestic appliances', '52140000', '2', NULL, 'Y'),
(794, 'Graphic design', '82140000', '2', NULL, 'Y'),
(795, 'Elements and gases', '12140000', '2', NULL, 'Y'),
(796, 'Patient care and treatment products and supplies', '42140000', '2', NULL, 'Y'),
(797, 'Electron tube devices and accessories', '32140000', '2', NULL, 'Y'),
(798, 'Heavy construction services', '72140000', '2', NULL, 'Y'),
(799, 'Leatherworking repairing machinery and equipment', '23140000', '2', NULL, 'Y'),
(800, 'Fibers and textiles and fabric industries', '73140000', '2', NULL, 'Y'),
(801, 'Community and social services', '93140000', '2', NULL, 'Y'),
(802, 'Sewing supplies and accessories', '53140000', '2', NULL, 'Y'),
(803, 'Credit agencies', '84140000', '2', NULL, 'Y'),
(804, 'Packing supplies', '24140000', '2', NULL, 'Y'),
(805, 'Governmental property right conferrals', '64140000', '2', NULL, 'Y'),
(806, 'Prefabricated buildings and structures', '95140000', '2', NULL, 'Y'),
(807, 'Photographic filmmaking supplies', '45140000', '2', NULL, 'Y'),
(808, 'Alternative and holistic medicine', '85140000', '2', NULL, 'Y'),
(809, 'Atomic and nuclear energy machinery and equipment', '26140000', '2', NULL, 'Y'),
(810, 'Launchers', '46140000', '2', NULL, 'Y'),
(811, 'Educational facilities', '86140000', '2', NULL, 'Y'),
(812, 'Decorative adornments', '56140000', '2', NULL, 'Y'),
(813, 'Automotive specialty tools', '27140000', '2', NULL, 'Y'),
(814, 'Environmental laboratory services', '77140000', '2', NULL, 'Y'),
(815, 'Transport services', '78140000', '2', NULL, 'Y'),
(816, 'Watersports equipment', '49140000', '2', NULL, 'Y'),
(817, 'Seeds and bulbs and seedlings and cuttings', '10150000', '2', NULL, 'Y'),
(818, 'Exterior finishing materials', '30150000', '2', NULL, 'Y'),
(819, 'Industrial pumps and compressors', '40150000', '2', NULL, 'Y'),
(820, 'Edible oils and fats', '50150000', '2', NULL, 'Y'),
(821, 'Forestry', '70150000', '2', NULL, 'Y'),
(822, 'Trade policy and services', '80150000', '2', NULL, 'Y'),
(823, 'Entertainment services', '90150000', '2', NULL, 'Y'),
(824, 'Fibers and threads and yarns', '11150000', '2', NULL, 'Y'),
(825, 'Rope and chain and cable and wire and strap', '31150000', '2', NULL, 'Y'),
(826, 'Autonomic nervous system drugs', '51150000', '2', NULL, 'Y'),
(827, 'Earth science services', '81150000', '2', NULL, 'Y'),
(828, 'Oil and gas data management and processing services', '71150000', '2', NULL, 'Y'),
(829, 'Clinical laboratory and toxicology testing systems, components, and supplies', '41150000', '2', NULL, 'Y'),
(830, 'Domestic kitchenware and kitchen supplies', '52150000', '2', NULL, 'Y'),
(831, 'Professional artists and performers', '82150000', '2', NULL, 'Y'),
(832, 'Dental equipment and supplies', '42150000', '2', NULL, 'Y'),
(833, 'Automation control devices and components and accessories', '32150000', '2', NULL, 'Y'),
(834, 'Specialized trade construction and maintenance services', '72150000', '2', NULL, 'Y'),
(835, 'Industrial process machinery and equipment and supplies', '23150000', '2', NULL, 'Y'),
(836, 'Manufacturing support services', '73150000', '2', NULL, 'Y'),
(837, 'Public administration and finance services', '93150000', '2', NULL, 'Y'),
(838, 'Spacecraft', '25150000', '2', NULL, 'Y'),
(839, 'Food and nutrition services', '85150000', '2', NULL, 'Y'),
(840, 'Law enforcement', '46150000', '2', NULL, 'Y'),
(841, 'Winter sports equipment', '49150000', '2', NULL, 'Y'),
(842, 'Floriculture and silviculture products', '10160000', '2', NULL, 'Y'),
(843, 'Interior finishing materials', '30160000', '2', NULL, 'Y'),
(844, 'Industrial filtering and purification', '40160000', '2', NULL, 'Y'),
(845, 'Chocolate and sugars and sweeteners and confectionary products', '50160000', '2', NULL, 'Y'),
(846, 'Wildlife and flora', '70160000', '2', NULL, 'Y'),
(847, 'Business administration services', '80160000', '2', NULL, 'Y'),
(848, 'Fabrics and leather materials', '11160000', '2', NULL, 'Y'),
(849, 'Hardware', '31160000', '2', NULL, 'Y'),
(850, 'Drugs affecting the respiratory tract', '51160000', '2', NULL, 'Y'),
(851, 'Oil and gas well project management services', '71160000', '2', NULL, 'Y'),
(852, 'Information Technology Service Delivery', '81160000', '2', NULL, 'Y'),
(853, 'Dialysis equipment and supplies', '42160000', '2', NULL, 'Y'),
(854, 'Consumer electronics', '52160000', '2', NULL, 'Y'),
(855, 'Additives', '12160000', '2', NULL, 'Y'),
(856, 'Film and theater production support services', '82160000', '2', NULL, 'Y'),
(857, 'Foundry machines and equipment and supplies', '23160000', '2', NULL, 'Y'),
(858, 'Machinery and transport equipment manufacture', '73160000', '2', NULL, 'Y'),
(859, 'Taxation', '93160000', '2', NULL, 'Y'),
(860, 'Non motorized cycles', '25160000', '2', NULL, 'Y'),
(861, 'Medical Surgical Equipment Maintenance Refurbishment and Repair Services', '85160000', '2', NULL, 'Y'),
(862, 'Public safety and control', '46160000', '2', NULL, 'Y'),
(863, 'Field and court sports equipment', '49160000', '2', NULL, 'Y'),
(864, 'Fertilizers and plant nutrients and herbicides', '10170000', '2', NULL, 'Y'),
(865, 'Pipe piping and pipe fittings', '40170000', '2', NULL, 'Y'),
(866, 'Doors and windows and glass', '30170000', '2', NULL, 'Y'),
(867, 'Seasonings and preservatives', '50170000', '2', NULL, 'Y'),
(868, 'Water resources development and oversight', '70170000', '2', NULL, 'Y'),
(869, 'Public relations and professional communications services', '80170000', '2', NULL, 'Y'),
(870, 'Bearings and bushings and wheels and gears', '31170000', '2', NULL, 'Y'),
(871, 'Drugs affecting the gastrointestinal system', '51170000', '2', NULL, 'Y'),
(872, 'Alloys', '11170000', '2', NULL, 'Y'),
(873, 'Biological science services', '81170000', '2', NULL, 'Y'),
(874, 'Diagnostic and microbiological devices', '41170000', '2', NULL, 'Y'),
(875, 'Colorants', '12170000', '2', NULL, 'Y'),
(876, 'Domestic wall treatments', '52170000', '2', NULL, 'Y'),
(877, 'Mobile medical services products', '42170000', '2', NULL, 'Y'),
(878, 'Manufacture of electrical goods and precision instruments', '73170000', '2', NULL, 'Y'),
(879, 'Trade policy and regulation', '93170000', '2', NULL, 'Y'),
(880, 'Transportation components and systems', '25170000', '2', NULL, 'Y'),
(881, 'Death and dying support services', '85170000', '2', NULL, 'Y'),
(882, 'Security surveillance and detection', '46170000', '2', NULL, 'Y'),
(883, 'Gymnastics and boxing equipment', '49170000', '2', NULL, 'Y'),
(884, 'Plumbing fixtures', '30180000', '2', NULL, 'Y'),
(885, 'Bread and bakery products', '50180000', '2', NULL, 'Y'),
(886, 'Tubes tubing and tube fittings', '40180000', '2', NULL, 'Y'),
(887, 'Packings glands boots and covers', '31180000', '2', NULL, 'Y'),
(888, 'Hormones and hormone antagonists', '51180000', '2', NULL, 'Y'),
(889, 'Metal oxide', '11180000', '2', NULL, 'Y'),
(890, 'Waxes and oils', '12180000', '2', NULL, 'Y'),
(891, 'Patient exam and monitoring products', '42180000', '2', NULL, 'Y'),
(892, 'Industrial food and beverage equipment', '23180000', '2', NULL, 'Y'),
(893, 'Machining and processing services', '73180000', '2', NULL, 'Y'),
(894, 'Vehicle bodies and trailers', '25180000', '2', NULL, 'Y'),
(895, 'Personal safety and protection', '46180000', '2', NULL, 'Y'),
(896, 'Transportation repair or maintenance services', '78180000', '2', NULL, 'Y'),
(897, 'Target and table games and equipment', '49180000', '2', NULL, 'Y'),
(898, 'Pest control products', '10190000', '2', NULL, 'Y'),
(899, 'Construction and maintenance support equipment', '30190000', '2', NULL, 'Y'),
(900, 'Prepared and preserved foods', '50190000', '2', NULL, 'Y'),
(901, 'Agricultural machinery and equipment assembly and installation services', '70190000', '2', NULL, 'Y'),
(902, 'Grinding and polishing and smoothing materials', '31190000', '2', NULL, 'Y'),
(903, 'Agents affecting water and electrolytes', '51190000', '2', NULL, 'Y'),
(904, 'Metal waste scrap and by products', '11190000', '2', NULL, 'Y'),
(905, 'Solvents', '12190000', '2', NULL, 'Y'),
(906, 'Medical facility products', '42190000', '2', NULL, 'Y'),
(907, 'Communications Devices and Accessories', '43190000', '2', NULL, 'Y'),
(908, 'Mixers and their parts and accessories', '23190000', '2', NULL, 'Y'),
(909, 'Transportation services equipment', '25190000', '2', NULL, 'Y'),
(910, 'Fire protection', '46190000', '2', NULL, 'Y'),
(911, 'Beverages', '50200000', '2', NULL, 'Y'),
(912, 'Live rose bushes', '10200000', '2', NULL, 'Y'),
(913, 'Adhesives and sealants', '31200000', '2', NULL, 'Y'),
(914, 'Immunomodulating drugs', '51200000', '2', NULL, 'Y'),
(915, 'Medical diagnostic imaging and nuclear medicine products', '42200000', '2', NULL, 'Y'),
(916, 'Components for information technology or broadcasting or telecommunications', '43200000', '2', NULL, 'Y'),
(917, 'Mass transfer equipment', '23200000', '2', NULL, 'Y'),
(918, 'Aerospace systems and components and equipment', '25200000', '2', NULL, 'Y'),
(919, 'Defense and law enforcement and security and safety training equipment', '46200000', '2', NULL, 'Y'),
(920, 'Aviation-Related Services And Consultancy', '78200000', '2', NULL, 'Y'),
(921, 'Fitness equipment', '49200000', '2', NULL, 'Y'),
(922, 'Tobacco and smoking products and substitutes', '50210000', '2', NULL, 'Y'),
(923, 'Live plants of high species or variety count flowers', '10210000', '2', NULL, 'Y'),
(924, 'Paints and primers and finishes', '31210000', '2', NULL, 'Y'),
(925, 'Independent living aids for the physically challenged', '42210000', '2', NULL, 'Y'),
(926, 'Computer Equipment and Accessories', '43210000', '2', NULL, 'Y'),
(927, 'Electronic manufacturing machinery and equipment and accessories', '23210000', '2', NULL, 'Y'),
(928, 'Diagnoses of infectious and parasitic diseases-part a', '85210000', '2', NULL, 'Y'),
(929, 'Workplace safety equipment and supplies and training materials', '46210000', '2', NULL, 'Y'),
(930, 'Other sports', '49210000', '2', NULL, 'Y'),
(931, 'Cereal and pulse products', '50220000', '2', NULL, 'Y'),
(932, 'Live plants of low species or variety count flowers', '10220000', '2', NULL, 'Y'),
(933, 'Dyeing and tanning extracts', '31220000', '2', NULL, 'Y'),
(934, 'Intravenous and arterial administration products', '42220000', '2', NULL, 'Y'),
(935, 'Data Voice or Multimedia Network Equipment or Platforms and Accessories', '43220000', '2', NULL, 'Y'),
(936, 'Chicken processing machinery and equipment', '23220000', '2', NULL, 'Y'),
(937, 'Military weapon and ammunition disarmament and disposal equipment and related products', '46220000', '2', NULL, 'Y'),
(938, 'Sports equipment and accessories', '49220000', '2', NULL, 'Y'),
(939, 'Machined raw stock', '31230000', '2', NULL, 'Y'),
(940, 'Clinical nutrition', '42230000', '2', NULL, 'Y'),
(941, 'Software', '43230000', '2', NULL, 'Y'),
(942, 'Sawmilling and lumber processing machinery and equipment', '23230000', '2', NULL, 'Y'),
(943, 'Portable Structure Building Components', '30240000', '2', NULL, 'Y'),
(944, 'Industrial optics', '31240000', '2', NULL, 'Y'),
(945, 'Drugs affecting the ears, eye, nose and skin', '51240000', '2', NULL, 'Y'),
(946, 'Orthopedic and prosthetic and sports medicine products', '42240000', '2', NULL, 'Y'),
(947, 'Metal cutting machinery and accessories', '23240000', '2', NULL, 'Y'),
(948, 'Recreation and playground and swimming and spa equipment and supplies', '49240000', '2', NULL, 'Y'),
(949, 'Underground mining structures and materials', '30250000', '2', NULL, 'Y'),
(950, 'Pneumatic and hydraulic and electric control systems', '31250000', '2', NULL, 'Y'),
(951, 'Brass instruments', '60131100', '3', NULL, 'Y'),
(952, 'Games', '60141100', '3', NULL, 'Y'),
(953, 'Well plugging and abandonment services', '71141100', '3', NULL, 'Y'),
(954, 'Infrastructure building and surfacing and paving services', '72141100', '3', NULL, 'Y'),
(955, 'Oilfield data management services', '71151100', '3', NULL, 'Y'),
(956, 'Plumbing construction services', '72151100', '3', NULL, 'Y'),
(957, 'Coating services', '73181100', '3', NULL, 'Y'),
(958, 'Continuous mixers', '23191100', '3', NULL, 'Y'),
(959, 'Small arms weapons training equipment', '46201100', '3', NULL, 'Y'),
(960, 'Cereals', '50221100', '3', NULL, 'Y'),
(961, 'Killing and defeathering department machinery and equipment', '23221100', '3', NULL, 'Y'),
(962, 'Ophthalmic agents', '51241100', '3', NULL, 'Y'),
(963, 'Electric direct current DC motors', '26101200', '3', NULL, 'Y'),
(964, 'Plastic films', '13111200', '3', NULL, 'Y'),
(965, 'Agricultural building construction services', '72121200', '3', NULL, 'Y'),
(966, 'Woodwind instruments', '60131200', '3', NULL, 'Y'),
(967, 'Marine construction services', '72141200', '3', NULL, 'Y'),
(968, 'Heating and cooling and air conditioning HVAC construction and maintenance services', '72151200', '3', NULL, 'Y'),
(969, 'Industrial drying equipment', '23201200', '3', NULL, 'Y'),
(970, 'Dermatologic agents', '51241200', '3', NULL, 'Y'),
(971, 'Non electric motors', '26101300', '3', NULL, 'Y'),
(972, 'Foams', '13111300', '3', NULL, 'Y'),
(973, 'Art and craft cutting products', '60121300', '3', NULL, 'Y'),
(974, 'Automotive garage and service station construction services', '72121300', '3', NULL, 'Y'),
(975, 'Electrical boxes and enclosures and fittings and accessories', '39121300', '3', NULL, 'Y'),
(976, 'String instruments', '60131300', '3', NULL, 'Y'),
(977, 'Painting and paper hanging services', '72151300', '3', NULL, 'Y'),
(978, 'Flour and milled products', '50221300', '3', NULL, 'Y'),
(979, 'Motor or generator components', '26101400', '3', NULL, 'Y'),
(980, 'Aviation Specific Training', '86101400', '3', NULL, 'Y'),
(981, 'Language Specific Editorial and Writing Services', '82111400', '3', NULL, 'Y'),
(982, 'Classroom And Language Laboratory Equipment & Interpretation Systems', '45111400', '3', NULL, 'Y'),
(983, 'Completion tools and equipment', '20121400', '3', NULL, 'Y'),
(984, 'Specialized public building construction services', '72121400', '3', NULL, 'Y'),
(985, 'Cafeteria and lunchroom furnishings', '56121400', '3', NULL, 'Y'),
(986, 'Electrical lugs plugs and connectors', '39121400', '3', NULL, 'Y'),
(987, 'Percussion instruments', '60131400', '3', NULL, 'Y'),
(988, 'Safety and Rescue Aircraft', '25131400', '3', NULL, 'Y'),
(989, 'Fundraising Services', '80141400', '3', NULL, 'Y'),
(990, 'Detention facility construction and repair services', '72141400', '3', NULL, 'Y'),
(991, 'Wall covering construction services', '72151400', '3', NULL, 'Y'),
(992, 'System Cards', '43201400', '3', NULL, 'Y'),
(993, 'Metal grinding machines', '23241400', '3', NULL, 'Y'),
(994, 'Welding machinery', '23271400', '3', NULL, 'Y'),
(995, 'Livestock', '10101500', '3', NULL, 'Y'),
(996, 'Cutting equipment', '20101500', '3', NULL, 'Y'),
(997, 'Angles', '30101500', '3', NULL, 'Y'),
(998, 'Ventilation', '40101500', '3', NULL, 'Y'),
(999, 'Fisheries operations', '70101500', '3', NULL, 'Y'),
(1000, 'Business and corporate management consultation services', '80101500', '3', NULL, 'Y');

--
-- Indexes for dumped tables
--

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `itemclassification`
--
ALTER TABLE `itemclassification`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1001;
COMMIT;

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


-- phpMyAdmin SQL Dump
-- version 4.7.4
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Mar 29, 2024 at 10:52 AM
-- Server version: 10.1.28-MariaDB
-- PHP Version: 5.6.32

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


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

--
-- Database: `robipos`
--

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

--
-- Table structure for table `itemstatuscodes`
--

CREATE TABLE `itemstatuscodes` (
  `id` int(50) NOT NULL,
  `code` varchar(50) NOT NULL,
  `description` text,
  `status` varchar(50) NOT NULL,
  `name` text NOT NULL,
  `sort_order` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `itemstatuscodes`
--

INSERT INTO `itemstatuscodes` (`id`, `code`, `description`, `status`, `name`, `sort_order`) VALUES
(1, 'Y', NULL, 'Y', 'Active', '1'),
(2, 'N', NULL, 'N', 'Inactive', '2');

--
-- Indexes for dumped tables
--

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `itemstatuscodes`
--
ALTER TABLE `itemstatuscodes`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
COMMIT;

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


-- phpMyAdmin SQL Dump
-- version 4.7.4
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Mar 29, 2024 at 10:50 AM
-- Server version: 10.1.28-MariaDB
-- PHP Version: 5.6.32

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


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

--
-- Database: `robipos`
--

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

--
-- Table structure for table `itemtypecodes`
--

CREATE TABLE `itemtypecodes` (
  `id` int(50) NOT NULL,
  `name` text NOT NULL,
  `code` varchar(50) NOT NULL,
  `description` text,
  `status` varchar(50) NOT NULL,
  `sort_order` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `itemtypecodes`
--

INSERT INTO `itemtypecodes` (`id`, `name`, `code`, `description`, `status`, `sort_order`) VALUES
(1, 'Raw Material', '1', 'Raw Material', 'Y', '1'),
(2, 'Finished Product', '2', 'Finished Product', 'Y', '2'),
(3, 'Service', '3', 'Service without stock', '', '');

--
-- Indexes for dumped tables
--

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `itemtypecodes`
--
ALTER TABLE `itemtypecodes`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
COMMIT;

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


-- phpMyAdmin SQL Dump
-- version 4.7.4
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Mar 29, 2024 at 10:29 AM
-- Server version: 10.1.28-MariaDB
-- PHP Version: 5.6.32

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


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


/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
ALTER TABLE `nation` CHANGE `description` `description` VARCHAR(40) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL; 
ALTER TABLE `nation` ADD `status` VARCHAR(50) NULL DEFAULT NULL AFTER `description`; 
-- phpMyAdmin SQL Dump
-- version 4.7.4
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Mar 29, 2024 at 10:39 AM
-- Server version: 10.1.28-MariaDB
-- PHP Version: 5.6.32

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


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

--
-- Database: `robipos`
--

-- --------------------------------------------------------
-- phpMyAdmin SQL Dump
-- version 4.7.4
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Mar 30, 2024 at 03:30 PM
-- Server version: 10.1.28-MariaDB
-- PHP Version: 5.6.32

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


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

--
-- Database: `robipos`
--

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

--
-- Table structure for table `noticelist`
--

CREATE TABLE `noticelist` (
  `id` int(50) NOT NULL,
  `noticeNo` varchar(50) NOT NULL,
  `title` text NOT NULL,
  `cont` text NOT NULL,
  `dtlUrl` text NOT NULL,
  `regrNm` varchar(50) NOT NULL,
  `regDt` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Indexes for dumped tables
--

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `noticelist`
--
ALTER TABLE `noticelist`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT;
COMMIT;

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


-- phpMyAdmin SQL Dump
-- version 4.7.4
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jan 30, 2024 at 10:08 AM
-- Server version: 10.1.28-MariaDB
-- PHP Version: 5.6.32

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


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

--
-- Database: `robipos`
--

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

--
-- Table structure for table `packagingcodes`
--

CREATE TABLE `packagingcodes` (
  `id` int(50) NOT NULL,
  `name` text NOT NULL,
  `code` varchar(50) NOT NULL,
  `description` text,
  `status` varchar(50) NOT NULL,
  `sort_order` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `packagingcodes`
--

INSERT INTO `packagingcodes` (`id`, `name`, `code`, `description`, `status`, `sort_order`) VALUES
(1, 'Ampoule', 'AM', 'Ampoule', 'Y', '1'),
(2, 'Barrel', 'BA', 'Barrel', 'Y', '2'),
(3, 'Bottlecrate', 'BC', 'Bottlecrate', 'Y', '3'),
(4, 'Bundle', 'BE', 'Bundle', 'Y', '4'),
(5, 'Balloon, non-protected', 'BF', 'Balloon, non-protected', 'Y', '5'),
(6, 'Bag', 'BG', 'Bag', 'Y', '6'),
(7, 'Bucket', 'BJ', 'Bucket', 'Y', '7'),
(8, 'Basket', 'BK', 'Basket', 'Y', '8'),
(9, 'Bale', 'BL', 'Bale', 'Y', '9'),
(10, 'Bottle, protected cylindrical', 'BQ', 'Bottle, protected cylindrical', 'Y', '10'),
(11, 'Bar', 'BR', 'Bar', 'Y', '11'),
(12, 'Bottle, bulbous', 'BV', 'Bottle, bulbous', 'Y', '12'),
(13, 'Bag', 'BZ', 'Bag', 'Y', '13'),
(14, 'Can', 'CA', 'Can', 'Y', '14'),
(15, 'Chest', 'CH', 'Chest', 'Y', '15'),
(16, 'Coffin', 'CJ', 'Coffin', 'Y', '16'),
(17, 'Coil', 'CL', 'Coil', 'Y', '17'),
(18, 'Wooden Box, Wooden Case', 'CR', 'Wooden Box, Wooden Case', 'Y', '18'),
(19, 'Cassette', 'CS', 'Cassette', 'Y', '19'),
(20, 'Carton', 'CT', 'Carton', 'Y', '20'),
(21, 'Container', 'CTN', 'Container', 'Y', '21'),
(22, 'Cylinder', 'CY', 'Cylinder', 'Y', '22'),
(23, 'Drum', 'DR', 'Drum', 'Y', '23'),
(24, 'Extra Countable Item', 'GT', 'Extra Countable Item', 'Y', '24'),
(25, 'Hand Baggage', 'HH', 'Hand Baggage', 'Y', '25'),
(26, 'Ingots', 'IZ', 'Ingots', 'Y', '26'),
(27, 'Jar', 'JR', 'Jar', 'Y', '27'),
(28, 'Jug', 'JU', 'Jug', 'Y', '28'),
(29, 'Jerry CAN Cylindrical', 'JY', 'Jerry CAN Cylindrical', 'Y', '29'),
(30, 'Canester', 'KZ', 'Canester', 'Y', '30'),
(31, 'Logs, in bundle/bunch/truss', 'LZ', 'Logs, in bundle/bunch/truss', 'Y', '31'),
(32, 'Net', 'NT', 'Net', 'Y', '32'),
(33, 'Non-Exterior Packaging Unit', 'OU', 'Non-Exterior Packaging Unit', 'Y', '33'),
(34, 'Poddon', 'PD', 'Poddon', 'Y', '34'),
(35, 'Plate', 'PG', 'Plate', 'Y', '35'),
(36, 'Pipe', 'PI', 'Pipe', 'Y', '36'),
(37, 'Pilot', 'PO', 'Pilot', 'Y', '37'),
(38, 'Traypack', 'PU', 'Traypack', 'Y', '38'),
(39, 'Reel', 'RL', 'Reel', 'Y', '39'),
(40, 'Roll', 'RO', 'Roll', 'Y', '40'),
(41, 'Rods, in bundle/bunch/truss', 'RZ', 'Rods, in bundle/bunch/truss', 'Y', '41'),
(42, 'Skeletoncase', 'SK', 'Skeletoncase', 'Y', '42'),
(43, 'Tank, cylindrical', 'TY', 'Tank, cylindrical', 'Y', '43'),
(44, 'Bulk,gas(at 1031 mbar 15 oC)', 'VG', 'Bulk,gas(at 1031 mbar 15 oC)', 'Y', '44'),
(45, 'Bulk,liquid(at normal temperature/pressure)', 'VL', 'Bulk,liquid(at normal temperature/pressure)', 'Y', '45'),
(46, 'Bulk, solid, large particles(nodules)', 'VO', 'Bulk, solid, large particles(\"nodules\")', 'Y', '46'),
(47, 'Bulk, gas (liquefied at abnormal temperature/pressure)', 'VQ', 'Bulk, gas(liquefied at abnormal temperature/pressure)', 'Y', '47'),
(48, 'Bulk, solid, granular particles(grains)', 'VR', 'Bulk, solid, granular particles(\"grains\")', 'Y', '48'),
(49, 'Extra Bulk Item', 'VT', 'Extra Bulk Item', 'Y', '49'),
(50, 'Bulk, fine particles(powder)', 'VY', 'Bulk, fine particles(\"powder\")', 'Y', '50'),
(51, 'Mills', 'ML', 'cigarette Mills', 'Y', '51'),
(52, 'TAN', 'TN', '1TAN REFER TO 20BAGS', 'Y', '52');

--
-- Indexes for dumped tables
--

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `packagingcodes`
--
ALTER TABLE `packagingcodes`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=53;
COMMIT;

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


-- phpMyAdmin SQL Dump
-- version 4.7.4
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jan 30, 2024 at 10:09 AM
-- Server version: 10.1.28-MariaDB
-- PHP Version: 5.6.32

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


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

--
-- Database: `robipos`
--

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

--
-- Table structure for table `paymentcodes`
--

CREATE TABLE `paymentcodes` (
  `id` int(50) NOT NULL,
  `name` text NOT NULL,
  `code` varchar(50) NOT NULL,
  `description` text,
  `status` varchar(50) NOT NULL,
  `sort_order` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `paymentcodes`
--

INSERT INTO `paymentcodes` (`id`, `name`, `code`, `description`, `status`, `sort_order`) VALUES
(1, 'CASH', '01', 'CASH', 'Y', '1'),
(2, 'CREDIT', '02', 'CREDIT', 'Y', '2'),
(3, 'CASH/CREDIT', '03', 'CASH/CREDIT', 'Y', '3'),
(4, 'BANK CHECK', '04', 'BANK CHECK PAYMENT', 'Y', '4'),
(5, 'DEBIT&CREDIT CARD', '05', 'PAYMENT USING CARD', 'Y', '5'),
(6, 'MOBILE MONEY', '06', 'ANY TRANSACTION USING MOBILE MONEY SYSTEM', 'Y', '6'),
(7, 'OTHER', '07', 'OTHER MEANS OF PAYMENT', 'Y', '7');

--
-- Indexes for dumped tables
--

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `paymentcodes`
--
ALTER TABLE `paymentcodes`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
COMMIT;

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


-- phpMyAdmin SQL Dump
-- version 4.7.4
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jan 30, 2024 at 10:09 AM
-- Server version: 10.1.28-MariaDB
-- PHP Version: 5.6.32

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


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

--
-- Database: `robipos`
--

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

--
-- Table structure for table `purchasecodes`
--

CREATE TABLE `purchasecodes` (
  `id` int(50) NOT NULL,
  `name` text NOT NULL,
  `code` varchar(50) NOT NULL,
  `description` text,
  `status` varchar(50) NOT NULL,
  `sort_order` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `purchasecodes`
--

INSERT INTO `purchasecodes` (`id`, `name`, `code`, `description`, `status`, `sort_order`) VALUES
(1, 'Wait for Approval', '01', NULL, 'Y', '1'),
(2, 'Approved', '02', NULL, 'Y', '2'),
(3, 'Cancel Requested', '03', NULL, 'Y', '3'),
(4, 'Canceled', '04', NULL, 'Y', '4'),
(5, 'Refunded', '05', NULL, 'Y', '5'),
(6, 'Transferred', '06', NULL, 'Y', '6');

--
-- Indexes for dumped tables
--

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `purchasecodes`
--
ALTER TABLE `purchasecodes`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
COMMIT;

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


-- phpMyAdmin SQL Dump
-- version 4.7.4
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jan 30, 2024 at 10:09 AM
-- Server version: 10.1.28-MariaDB
-- PHP Version: 5.6.32

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


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

--
-- Database: `robipos`
--

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

--
-- Table structure for table `quantitycodes`
--

CREATE TABLE `quantitycodes` (
  `id` int(50) NOT NULL,
  `name` text NOT NULL,
  `code` varchar(50) NOT NULL,
  `description` text,
  `status` varchar(50) NOT NULL,
  `company_id` varchar(20) NOT NULL,
  `sort_order` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `quantitycodes`
--

INSERT INTO `quantitycodes` (`id`, `name`, `code`, `description`, `status`, `company_id`, `sort_order`) VALUES
(1, 'Pair', '4B', 'Pair', 'Y', '1', '1'),
(2, 'Cap', 'AV', 'Cap', 'Y', '1', '2'),
(3, 'Barrel', 'BA', 'Barrel', 'Y', '1', '3'),
(4, 'bundle', 'BE', 'bundle', 'Y', '1', '4'),
(5, 'bag', 'BG', 'bag', 'Y', '1', '5'),
(6, 'block', 'BL', 'block', 'Y', '1', '6'),
(7, 'BLL Barrel (petroleum) (158,987 dm3)', 'BLL', 'BLL Barrel (petroleum) (158,987 dm3)', 'Y', '1', '7'),
(8, 'box', 'BX', 'box', 'Y', '1', '8'),
(9, 'Can', 'CA', 'Can', 'Y', '1', '9'),
(10, 'Cell', 'CEL', 'Cell', 'Y', '1', '10'),
(11, 'centimetre', 'CMT', 'centimetre', 'Y', '1', '11'),
(12, 'CARAT', 'CR', 'CARAT', 'Y', '1', '12'),
(13, 'Drum', 'DR', 'Drum', 'Y', '1', '13'),
(14, 'Dozen', 'DZ', 'Dozen', 'Y', '1', '14'),
(15, 'Gallon', 'GLL', 'Gallon', 'Y', '1', '15'),
(16, 'Gram', 'GRM', 'Gram', 'Y', '1', '16'),
(17, 'Gross', 'GRO', 'Gross', 'Y', '1', '17'),
(18, 'Kilo-Gramme', 'KG', 'Kilo-Gramme', 'Y', '1', '18'),
(19, 'kilometre', 'KTM', 'kilometre', 'Y', '1', '19'),
(20, 'kilowatt', 'KWT', 'kilowatt', 'Y', '1', '20'),
(21, 'Litre', 'L', 'Litre', 'Y', '1', '21'),
(22, 'pound', 'LBR', 'pound', 'Y', '1', '22'),
(23, 'link', 'LK', 'link', 'Y', '1', '23'),
(24, 'Litre', 'LTR', 'Litre', 'Y', '1', '24'),
(25, 'Metre', 'M', 'Metre', 'Y', '1', '25'),
(26, 'Square Metre', 'M2', 'Square Metre', 'Y', '1', '26'),
(27, 'Cubic Metre', 'M3', 'Cubic Metre', 'Y', '1', '27'),
(28, 'milligram', 'MGM', 'milligram', 'Y', '1', '28'),
(29, 'metre', 'MTR', 'metre', 'Y', '1', '29'),
(30, 'megawatt hour (1000 kW.h)', 'MWT', 'megawatt hour (1000 kW.h)', 'Y', '1', '30'),
(31, 'Number', 'NO', 'Number', 'Y', '1', '31'),
(32, 'part per thousand', 'NX', 'part per thousand', 'Y', '1', '32'),
(33, 'packet', 'PA', 'packet', 'Y', '1', '33'),
(34, 'plate', 'PG', 'plate', 'Y', '1', '34'),
(35, 'pair', 'PR', 'pair', 'Y', '1', '35'),
(36, 'reel', 'RL', 'reel', 'Y', '1', '36'),
(37, 'roll', 'RO', 'roll', 'Y', '1', '37'),
(38, 'set', 'SET', 'set', 'Y', '1', '38'),
(39, 'sheet', 'ST', 'sheet', 'Y', '1', '39'),
(40, 'tonne (metric ton)', 'TNE', 'tonne (metric ton)', 'Y', '1', '40'),
(41, 'tube', 'TU', 'tube', 'Y', '1', '41'),
(42, 'Pieces/item [Number]', 'U', 'Pieces/item [Number]', 'Y', '1', '42'),
(43, 'yard', 'YRD', 'yard', 'Y', '1', '43');

--
-- Indexes for dumped tables
--

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `quantitycodes`
--
ALTER TABLE `quantitycodes`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=44;
COMMIT;

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


-- phpMyAdmin SQL Dump
-- version 4.7.4
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jan 30, 2024 at 10:09 AM
-- Server version: 10.1.28-MariaDB
-- PHP Version: 5.6.32

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


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

--
-- Database: `robipos`
--

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

--
-- Table structure for table `refundreasoncodes`
--

CREATE TABLE `refundreasoncodes` (
  `id` int(50) NOT NULL,
  `name` text NOT NULL,
  `code` varchar(50) NOT NULL,
  `description` text,
  `status` varchar(50) NOT NULL,
  `sort_order` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `refundreasoncodes`
--

INSERT INTO `refundreasoncodes` (`id`, `name`, `code`, `description`, `status`, `sort_order`) VALUES
(1, 'Missing Quantity', '01', NULL, 'Y', '1'),
(2, 'Missing Waiting', '02', NULL, 'Y', '2'),
(3, 'Damaged', '03', NULL, 'Y', '3'),
(4, 'Wasted', '04', NULL, 'Y', '4'),
(5, 'Raw Material Shortage', '05', NULL, 'Y', '5'),
(6, 'Refund', '06', NULL, 'Y', '6'),
(7, 'Wrong Customer PIN', '07', NULL, 'Y', '7'),
(8, 'Wrong Customer name', '08', NULL, 'Y', '8'),
(9, 'Wrong Amount/price', '09', NULL, 'Y', '9'),
(10, 'Wrong Quantity', '10', NULL, 'Y', '10'),
(11, 'Wrong Item(s)', '11', NULL, 'Y', '11'),
(12, 'Wrong tax type', '12', NULL, 'Y', '12'),
(13, 'Other reason', '13', NULL, 'Y', '13');

--
-- Indexes for dumped tables
--

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `refundreasoncodes`
--
ALTER TABLE `refundreasoncodes`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;
COMMIT;

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


-- phpMyAdmin SQL Dump
-- version 4.7.4
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jan 30, 2024 at 10:09 AM
-- Server version: 10.1.28-MariaDB
-- PHP Version: 5.6.32

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


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

--
-- Database: `robipos`
--

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

--
-- Table structure for table `salestatuscodes`
--

CREATE TABLE `salestatuscodes` (
  `id` int(50) NOT NULL,
  `code` varchar(50) NOT NULL,
  `description` text,
  `status` varchar(50) NOT NULL,
  `name` text NOT NULL,
  `sort_order` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `salestatuscodes`
--

INSERT INTO `salestatuscodes` (`id`, `code`, `description`, `status`, `name`, `sort_order`) VALUES
(1, '01', NULL, 'Y', 'Wait for Approval', '1'),
(2, '02', NULL, 'Y', 'Approved', '2'),
(3, '03', NULL, 'Y', 'Cancel Requested', '3'),
(4, '04', NULL, 'Y', 'Canceled', '4'),
(5, '05', NULL, 'Y', 'Refunded', '5'),
(6, '06', NULL, 'Y', 'Transferred', '6');

--
-- Indexes for dumped tables
--

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `salestatuscodes`
--
ALTER TABLE `salestatuscodes`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
COMMIT;

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


-- phpMyAdmin SQL Dump
-- version 4.7.4
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jan 30, 2024 at 10:09 AM
-- Server version: 10.1.28-MariaDB
-- PHP Version: 5.6.32

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


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

--
-- Database: `robipos`
--

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

--
-- Table structure for table `stocktypecodes`
--

CREATE TABLE `stocktypecodes` (
  `id` int(50) NOT NULL,
  `name` text NOT NULL,
  `code` varchar(50) NOT NULL,
  `description` text,
  `status` varchar(50) NOT NULL,
  `sort_order` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `stocktypecodes`
--

INSERT INTO `stocktypecodes` (`id`, `name`, `code`, `description`, `status`, `sort_order`) VALUES
(1, 'Import', '01', NULL, 'Y', '1'),
(2, 'Purchase', '02', NULL, 'Y', '2'),
(3, 'Return', '03', NULL, 'Y', '3'),
(4, 'Stock Movement', '04', NULL, 'Y', '4'),
(5, 'Processing', '05', NULL, 'Y', '5'),
(6, 'Adjustment', '06', NULL, 'Y', '6'),
(7, 'Sale', '11', NULL, 'Y', '11'),
(8, 'Return', '12', NULL, 'Y', '12'),
(9, 'Stock Movement', '13', NULL, 'Y', '13'),
(10, 'Processing', '14', NULL, 'Y', '14'),
(11, 'Discarding', '15', NULL, 'Y', '15'),
(12, 'Adjustment', '16', NULL, 'Y', '16');

--
-- Indexes for dumped tables
--

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `stocktypecodes`
--
ALTER TABLE `stocktypecodes`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;
COMMIT;

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


-- phpMyAdmin SQL Dump
-- version 4.7.4
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jan 30, 2024 at 10:09 AM
-- Server version: 10.1.28-MariaDB
-- PHP Version: 5.6.32

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


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

--
-- Database: `robipos`
--

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

--
-- Table structure for table `taxcodes`
--

CREATE TABLE `taxcodes` (
  `id` int(50) NOT NULL,
  `company_id` varchar(50) NOT NULL,
  `name` varchar(70) NOT NULL,
  `tax_code` varchar(50) NOT NULL,
  `sort_order` varchar(50) NOT NULL,
  `rate` varchar(50) NOT NULL,
  `rate_code2` varchar(50) NOT NULL,
  `description` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `taxcodes`
--

INSERT INTO `taxcodes` (`id`, `company_id`, `name`, `tax_code`, `sort_order`, `rate`, `rate_code2`, `description`) VALUES
(1, '1', 'A-Exempt', 'A', '1', '0', 'A-EX', 'A-Exempt'),
(2, '1', 'A-Exempt', 'B', '2', '16', 'B-16%', 'A-Exempt'),
(3, '1', 'C-Zero Rated', 'C', '3', '0', 'TAX C', 'C-Zero Rated'),
(4, '1', 'E-VAT 8%', 'E', '4', '8', 'E-8%', 'E-VAT 8%'),
(5, '1', 'D-Non VAT', 'D', '5', '0', 'TAX D', 'D-Non VAT');

--
-- Indexes for dumped tables
--

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `taxcodes`
--
ALTER TABLE `taxcodes`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
COMMIT;

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


-- phpMyAdmin SQL Dump
-- version 4.7.4
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jan 30, 2024 at 10:09 AM
-- Server version: 10.1.28-MariaDB
-- PHP Version: 5.6.32

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


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

--
-- Database: `robipos`
--

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

--
-- Table structure for table `transtypecodes`
--

CREATE TABLE `transtypecodes` (
  `id` int(11) NOT NULL,
  `name` text NOT NULL,
  `code` varchar(50) NOT NULL,
  `description` text,
  `status` varchar(20) NOT NULL,
  `sort_order` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `transtypecodes`
--

INSERT INTO `transtypecodes` (`id`, `name`, `code`, `description`, `status`, `sort_order`) VALUES
(1, 'Copy', 'C', 'Copy', 'Y', '1'),
(2, 'Normal', 'N', 'Normal', 'Y', '2'),
(3, 'Proforma', 'P', 'Proforma', 'Y', '3'),
(4, 'Training', 'T', 'Training', 'Y', '4');

--
-- Indexes for dumped tables
--

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `transtypecodes`
--
ALTER TABLE `transtypecodes`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
COMMIT;

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


-- phpMyAdmin SQL Dump
-- version 4.7.4
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Mar 30, 2024 at 08:55 AM
-- Server version: 10.1.28-MariaDB
-- PHP Version: 5.6.32

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


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

--
-- Database: `robipos`
--

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

--
-- Table structure for table `insurance`
--

CREATE TABLE `insurance` (
  `id` int(11) NOT NULL,
  `name` text NOT NULL,
  `code` varchar(50) NOT NULL,
  `description` text NOT NULL,
  `status` varchar(20) NOT NULL,
  `rate` varchar(50) NOT NULL,
  `createdate` varchar(50) NOT NULL,
  `branchid` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Indexes for dumped tables
--

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `insurance`
--
ALTER TABLE `insurance`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
COMMIT;

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


--
-- Table structure for table `etiminitialization`
--

CREATE TABLE `etiminitialization` (
  `id` int(11) NOT NULL,
  `tin` varchar(50) NOT NULL,
  `bhfOpenDt` varchar(50) DEFAULT NULL,
  `createdate` datetime NOT NULL,
  `sdcId` varchar(50) DEFAULT '00',
  `mrcNo` text DEFAULT NULL,
  `cmcKey` text DEFAULT NULL,
  `companyid` varchar(50) NOT NULL,
  `branchid` varchar(50) NOT NULL,
  `updatedid` varchar(20) NOT NULL DEFAULT 'KES',
  `updatedby` varchar(20) DEFAULT NULL,
  `userid` int(11) NOT NULL,
  `name` text NOT NULL,
  `bhfid` varchar(50) DEFAULT NULL,
  `bhfSttsCd` varchar(50) DEFAULT NULL,
  `url` text NOT NULL,
  `onlineoffline` varchar(20) NOT NULL,
  `phone` varchar(50) NOT NULL,
  `code` varchar(50) NOT NULL,
  `status` varchar(50) NOT NULL,
  `verification` text NOT NULL,
  `requestdate` varchar(50) NOT NULL,
  `confirmationdate` varchar(50) NOT NULL,
  `businesskey` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Indexes for dumped tables
--

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `etiminitialization`
--
ALTER TABLE `etiminitialization`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
COMMIT;

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


-- phpMyAdmin SQL Dump
-- version 4.7.4
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jan 30, 2024 at 10:13 AM
-- Server version: 10.1.28-MariaDB
-- PHP Version: 5.6.32

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


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

--
-- Database: `robipos`
--

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

--
-- Table structure for table `itemclassification`
--




ALTER TABLE `newstock`  ADD COLUMN IF NOT EXISTS  `frombefore` VARCHAR(20) NOT NULL AFTER `id`,  ADD COLUMN IF NOT EXISTS  `fromafter` VARCHAR(20) NOT NULL AFTER `frombefore`,  ADD COLUMN IF NOT EXISTS  `fromremoved` VARCHAR(20) NOT NULL AFTER `fromafter`; 
ALTER TABLE `products`  ADD COLUMN IF NOT EXISTS  `itemclassification` VARCHAR(50) NOT NULL AFTER `id`,  ADD COLUMN IF NOT EXISTS  `country` VARCHAR(50) NOT NULL AFTER `itemclassification`,  ADD COLUMN IF NOT EXISTS  `itemtype` VARCHAR(50) NOT NULL AFTER `country`,  ADD COLUMN IF NOT EXISTS  `packagingunit` VARCHAR(50) NOT NULL AFTER `itemtype`,  ADD COLUMN IF NOT EXISTS  `salesunit` VARCHAR(50) NOT NULL AFTER `packagingunit`; 
ALTER TABLE `products`  ADD COLUMN IF NOT EXISTS  `itemstatus` VARCHAR(50) NOT NULL AFTER `id`,  ADD COLUMN IF NOT EXISTS  `itemtax` VARCHAR(50) NOT NULL AFTER `itemstatus`; 
ALTER TABLE `productlist`  ADD COLUMN IF NOT EXISTS  `itemclassification` VARCHAR(50) NOT NULL AFTER `id`,  ADD COLUMN IF NOT EXISTS  `country` VARCHAR(50) NOT NULL AFTER `itemclassification`,  ADD COLUMN IF NOT EXISTS  `itemtype` VARCHAR(50) NOT NULL AFTER `country`,  ADD COLUMN IF NOT EXISTS  `packagingunit` VARCHAR(50) NOT NULL AFTER `itemtype`,  ADD COLUMN IF NOT EXISTS  `salesunit` VARCHAR(50) NOT NULL AFTER `packagingunit`;
ALTER TABLE `productlist`  ADD COLUMN IF NOT EXISTS  `itemstatus` VARCHAR(50) NOT NULL AFTER `id`,  ADD COLUMN IF NOT EXISTS  `itemtax` VARCHAR(50) NOT NULL AFTER `itemstatus` ;
ALTER TABLE `purchaseorder`  ADD COLUMN IF NOT EXISTS  `taxblAmtD` VARCHAR(50) NOT NULL AFTER `id`,  ADD COLUMN IF NOT EXISTS  `taxblAmtE` VARCHAR(50) NOT NULL AFTER `taxblAmtD`,  ADD COLUMN IF NOT EXISTS  `taxRtA` VARCHAR(50) NOT NULL AFTER `taxblAmtE`,  ADD COLUMN IF NOT EXISTS  `taxRtC` VARCHAR(50) NOT NULL AFTER `taxRtA`,  ADD COLUMN IF NOT EXISTS  `taxRtD` VARCHAR(50) NOT NULL AFTER `taxRtC`,  ADD COLUMN IF NOT EXISTS  `taxRtE` VARCHAR(50) NOT NULL AFTER `taxRtD`; 
ALTER TABLE `purchaseorder`  ADD COLUMN IF NOT EXISTS  `taxblAmtB` VARCHAR(50) NOT NULL AFTER `id`;
ALTER TABLE `newstock`  ADD COLUMN IF NOT EXISTS  `taskCd` VARCHAR(50) NOT NULL AFTER `id`,  ADD COLUMN IF NOT EXISTS  `itemSeq` VARCHAR(50) NOT NULL AFTER `taskCd`, ADD COLUMN IF NOT EXISTS  `imptItemsttsCd` VARCHAR(50) NOT NULL AFTER `itemSeq`; 
ALTER TABLE `purchaseorder`  ADD COLUMN IF NOT EXISTS  `taxAmtA` VARCHAR(50) NULL DEFAULT NULL AFTER `id`,  ADD COLUMN IF NOT EXISTS  `taxAmtB` VARCHAR(50) NULL DEFAULT NULL AFTER `taxAmtA`,  ADD COLUMN IF NOT EXISTS  `taxAmtC` VARCHAR(50) NULL DEFAULT NULL AFTER `taxAmtB`,  ADD COLUMN IF NOT EXISTS  `taxAmtD` VARCHAR(50) NULL DEFAULT NULL AFTER `taxAmtC`,  ADD COLUMN IF NOT EXISTS  `taxAmtE` VARCHAR(50) NULL DEFAULT NULL AFTER `taxAmtD`; 
ALTER TABLE `sales`  ADD COLUMN IF NOT EXISTS  `taxblAmtA` VARCHAR(50) NULL DEFAULT NULL AFTER `id`,  ADD COLUMN IF NOT EXISTS  `taxblAmtB` VARCHAR(50) NULL DEFAULT NULL AFTER `taxblAmtA`,  ADD COLUMN IF NOT EXISTS  `taxblAmtC` VARCHAR(50) NULL DEFAULT NULL AFTER `taxblAmtB`,  ADD COLUMN IF NOT EXISTS  `taxblAmtD` VARCHAR(50) NULL DEFAULT NULL AFTER `taxblAmtC`,  ADD COLUMN IF NOT EXISTS  `taxblAmtE` VARCHAR(50) NULL DEFAULT NULL AFTER `taxblAmtD`,  ADD COLUMN IF NOT EXISTS  `taxAmtA` VARCHAR(50) NULL DEFAULT NULL AFTER `taxblAmtE`,  ADD COLUMN IF NOT EXISTS  `taxAmtB` VARCHAR(50) NULL DEFAULT NULL AFTER `taxAmtA`,  ADD COLUMN IF NOT EXISTS  `taxAmtC` VARCHAR(50) NULL DEFAULT NULL AFTER `taxAmtB`,  ADD COLUMN IF NOT EXISTS  `taxAmtD` VARCHAR(50) NULL DEFAULT NULL AFTER `taxAmtC`,  ADD COLUMN IF NOT EXISTS  `taxAmtE` VARCHAR(50) NULL DEFAULT NULL AFTER `taxAmtD`,  ADD COLUMN IF NOT EXISTS  `taxRtA` VARCHAR(50) NULL DEFAULT NULL AFTER `taxAmtE`,  ADD COLUMN IF NOT EXISTS  `taxRtB` VARCHAR(50) NULL DEFAULT NULL AFTER `taxRtA`,  ADD COLUMN IF NOT EXISTS  `taxRtC` VARCHAR(50) NULL DEFAULT NULL AFTER `taxRtB`,  ADD COLUMN IF NOT EXISTS  `taxRtD` VARCHAR(50) NULL DEFAULT NULL AFTER `taxRtC`,  ADD COLUMN IF NOT EXISTS  `taxRtE` VARCHAR(50) NULL DEFAULT NULL AFTER `taxRtD`; 

ALTER TABLE `sales_orderraw`  ADD COLUMN IF NOT EXISTS  `taxcode` VARCHAR(50) NULL DEFAULT NULL AFTER `id`; 
ALTER TABLE `sales_order`  ADD COLUMN IF NOT EXISTS  `taxcode` VARCHAR(50) NULL DEFAULT NULL AFTER `id`; 
ALTER TABLE `charges`  ADD COLUMN IF NOT EXISTS  `hscode` VARCHAR(50) NOT NULL AFTER `id`,  ADD COLUMN IF NOT EXISTS  `itemclassification` VARCHAR(50) NOT NULL AFTER `hscode`,  ADD COLUMN IF NOT EXISTS  `country` VARCHAR(50) NOT NULL AFTER `itemclassification`,  ADD COLUMN IF NOT EXISTS  `itemtype` VARCHAR(50) NOT NULL AFTER `country`,  ADD COLUMN IF NOT EXISTS  `packagingunit` VARCHAR(50) NOT NULL AFTER `itemtype`,  ADD COLUMN IF NOT EXISTS  `salesunit` VARCHAR(50) NOT NULL AFTER `packagingunit`; 
ALTER TABLE `sales`  ADD COLUMN IF NOT EXISTS  `currcptno` VARCHAR(50) NOT NULL AFTER `id`,  ADD COLUMN IF NOT EXISTS  `totrcptno` VARCHAR(50) NOT NULL AFTER `currcptno`,  ADD COLUMN IF NOT EXISTS  `intrldata` TEXT NOT NULL AFTER `totrcptno`,  ADD COLUMN IF NOT EXISTS  `rcptsign` TEXT NOT NULL AFTER `intrldata`,  ADD COLUMN IF NOT EXISTS  `sdcdatetime` VARCHAR(50) NOT NULL AFTER `rcptsign`;

ALTER TABLE `sales`  ADD COLUMN IF NOT EXISTS  `sdcId` TEXT NOT NULL AFTER `taxRtE`,  ADD COLUMN IF NOT EXISTS  `mrcNo` TEXT NOT NULL AFTER `sdcId`; 

ALTER TABLE `plot`  ADD COLUMN IF NOT EXISTS  `service` VARCHAR(50) NOT NULL DEFAULT 'no' AFTER `utility`; ALTER TABLE `plot`  ADD COLUMN IF NOT EXISTS  `servicedeposit` VARCHAR(10) NULL DEFAULT 'no' AFTER `service`,  ADD COLUMN IF NOT EXISTS  `lease` VARCHAR(10) NULL DEFAULT 'no' AFTER `servicedeposit`; 