CREATE TABLE IF NOT EXISTS `pldespesa` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cdorgao` varchar(2) NOT NULL,
  `cdunidade` varchar(2) NOT NULL,
  `cdfuncao` varchar(2) NOT NULL,
  `cdsubfuncao` varchar(3) NOT NULL,
  `cdprograma` varchar(4) NOT NULL,
  `cdprojeto` varchar(4) NOT NULL,
  `cdelemento` varchar(8) NOT NULL,
  `tipo` varchar(1) NOT NULL,
  `classe` varchar(1) NOT NULL,
  `vlorcado` decimal(16,2) NOT NULL,
  `conta` varchar(25) NOT NULL,
  `exercicio` int(4) NOT NULL,
  `fonte` varchar(6) NOT NULL,
  `saldo_atual` decimal(16,2) NOT NULL,
  `vlrsupl` decimal(16,2) NOT NULL,
  `vlredu` decimal(16,2) NOT NULL,
  `dot_atual` decimal(16,2) NOT NULL,
  `valor_exer` decimal(16,2) NOT NULL,
  `valor_mes` decimal(16,2) NOT NULL,
  `dconta` varchar(26) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=379 ;

--
-- Extraindo dados da tabela `pldespesa`
--

INSERT INTO `pldespesa` (`id`, `cdorgao`, `cdunidade`, `cdfuncao`, `cdsubfuncao`, `cdprograma`, `cdprojeto`, `cdelemento`, `tipo`, `classe`, `vlorcado`, `conta`, `exercicio`, `fonte`, `saldo_atual`, `vlrsupl`, `vlredu`, `dot_atual`, `valor_exer`, `valor_mes`, `dconta`) VALUES
(4, '01', '', '', '', '', '', '', 'S', '', '1085000.00', '01', 2018, '', '1085000.00', '60000.00', '100000.00', '1085000.00', '837544.83', '0.00', ''),
(5, '01', '01', '', '', '', '', '', 'S', '', '738000.00', '0101', 2018, '', '1166139.48', '700380.50', '100000.00', '1166139.48', '163105.57', '0.00', ''),
(6, '01', '01', '01', '', '', '', '', 'S', '', '738000.00', '010101', 2018, '', '738000.00', '272241.02', '100000.00', '738000.00', '163105.57', '0.00', ''),
(7, '01', '01', '01', '031', '', '', '', 'S', '', '615000.00', '010101031', 2018, '', '615000.00', '60000.00', '100000.00', '615000.00', '163105.57', '0.00', ''),
(8, '01', '01', '01', '031', '0001', '', '', 'S', '', '123000.00', '0101010310001', 2018, '', '123000.00', '60000.00', '100000.00', '123000.00', '163105.57', '0.00', ''),
(9, '01', '01', '01', '031', '0001', '2001', '', 'S', '', '347000.00', '01010103100012001', 2018, '', '347000.00', '60000.00', '100000.00', '347000.00', '837544.83', '0.00', ''),
(54, '01', '01', '01', '031', '0001', '2001', '30000000', 'S', '', '910000.00', '0101010310001200130000000', 2018, '', '-4733019.49', '700380.50', '557592.88', '854350.00', '7899729.29', '258959.41', ''),
(55, '01', '01', '01', '031', '0001', '2001', '31000000', 'S', '', '560000.00', '0101010310001200131000000', 2018, '', '-3506490.18', '364031.17', '0.00', '804320.15', '6032191.91', '213240.33', ''),
(56, '01', '01', '01', '031', '0001', '2001', '31900000', 'S', '', '520000.00', '0101010310001200131900000', 2018, '', '-3638868.61', '360281.17', '220803.40', '585320.15', '5896628.08', '209648.33', ''),
(57, '01', '01', '01', '031', '0001', '2001', '31901100', 'N', '', '445000.00', '0101010310001200131901100', 2018, '', '445000.00', '20000.00', '0.00', '445000.00', '460523.48', '0.00', ''),
(58, '01', '01', '01', '031', '0001', '2001', '31901300', 'N', '', '125000.00', '0101010310001200131901300', 2018, '', '125000.00', '0.00', '0.00', '125000.00', '89492.36', '0.00', ''),
(59, '01', '01', '01', '031', '0001', '2001', '33000000', 'S', '', '350000.00', '0101010310001200133000000', 2018, '', '-1038349.87', '336349.33', '327610.04', '238209.29', '1867537.38', '45719.08', ''),
(60, '01', '01', '01', '031', '0001', '2001', '33900000', 'S', '', '350000.00', '0101010310001200133900000', 2018, '', '-1038349.87', '336349.33', '327610.04', '238209.29', '1867537.38', '45719.08', ''),
(61, '01', '01', '01', '031', '0001', '2001', '33901400', 'N', '', '40000.00', '0101010310001200133901400', 2018, '', '40000.00', '0.00', '0.00', '40000.00', '17973.55', '0.00', ''),
(62, '01', '01', '01', '031', '0001', '2001', '33903000', 'N', '', '50000.00', '0101010310001200133903000', 2018, '', '50000.00', '0.00', '0.00', '50000.00', '5895.68', '0.00', ''),
(63, '01', '01', '01', '031', '0001', '2001', '33903600', 'N', '', '60000.00', '0101010310001200133903600', 2018, '', '60000.00', '0.00', '0.00', '60000.00', '29535.53', '0.00', ''),
(64, '01', '01', '01', '031', '0001', '2001', '33903900', 'N', '', '200000.00', '0101010310001200133903900', 2018, '', '200000.00', '40000.00', '0.00', '200000.00', '234124.23', '0.00', ''),
(65, '01', '01', '01', '031', '0001', '2001', '40000000', 'S', '', '90000.00', '0101010310001200140000000', 2018, '', '-109350.80', '0.00', '242350.00', '-51350.00', '58600.80', '0.00', ''),
(66, '01', '01', '01', '031', '0001', '2001', '44000000', 'S', '', '90000.00', '0101010310001200144000000', 2018, '', '-51350.00', '0.00', '142350.00', '-51350.00', '0.00', '0.00', ''),
(67, '01', '01', '01', '031', '0001', '2001', '44900000', 'S', '', '90000.00', '0101010310001200144900000', 2018, '', '-109350.80', '0.00', '142350.00', '-51350.00', '58200.80', '0.00', ''),
(68, '01', '01', '01', '031', '0001', '2001', '44905100', 'N', '', '40000.00', '0101010310001200144905100', 2018, '', '40000.00', '0.00', '40000.00', '40000.00', '0.00', '0.00', ''),
(69, '01', '01', '01', '031', '0001', '2001', '44905200', 'N', '', '50000.00', '0101010310001200144905200', 2018, '', '50000.00', '0.00', '60000.00', '50000.00', '0.00', '0.00', ''),
(70, '01', '', '', '', '', '', '', 'S', '', '1150000.00', '', 2019, '00', '1067989.02', '0.00', '2100000.00', '1150000.00', '82010.98', '0.00', ''),
(71, '01', '01', '', '', '', '', '', 'S', '', '1150000.00', '0101', 2019, '00', '1304500.00', '366741.02', '0.00', '1304500.00', '0.00', '0.00', ''),
(72, '01', '01', '01', '', '', '', '', 'S', '', '1150000.00', '010101', 2019, '', '1304500.00', '154500.00', '0.00', '1304500.00', '0.00', '0.00', ''),
(73, '01', '01', '01', '031', '', '', '', 'S', '', '1150000.00', '010101031', 2019, '10', '1150000.00', '0.00', '0.00', '1150000.00', '0.00', '0.00', ''),
(74, '01', '01', '01', '031', '0001', '', '', 'S', '', '1150000.00', '0101010310001', 2019, '00', '1150000.00', '0.00', '0.00', '1150000.00', '0.00', '0.00', ''),
(75, '01', '01', '01', '031', '0001', '2001', '', 'S', '', '1150000.00', '01010103100012001', 2019, '', '1150000.00', '0.00', '0.00', '1150000.00', '0.00', '0.00', ''),
(76, '01', '01', '01', '031', '0001', '2001', '30000000', 'S', '', '1060000.00', '0101010310001200130000000', 2019, '', '-4583019.49', '640380.50', '557592.88', '1004350.00', '5693105.58', '258959.41', ''),
(77, '01', '01', '01', '031', '0001', '2001', '31000000', 'S', '', '710000.00', '0101010310001200131000000', 2019, '', '-3356490.18', '344031.17', '0.00', '954320.15', '4383123.22', '213240.33', ''),
(78, '01', '01', '01', '031', '0001', '2001', '31900000', 'S', '', '670000.00', '0101010310001200131900000', 2019, '', '-3488868.61', '340281.17', '220803.40', '735320.15', '4289977.99', '209648.33', ''),
(79, '01', '01', '01', '031', '0001', '2001', '31901100', 'S', '', '595000.00', '0101010310001200131901100', 2019, '', '-1070691.90', '0.00', '0.00', '595000.00', '1730728.64', '85420.86', ''),
(80, '01', '01', '01', '031', '0001', '2001', '31901103', 'N', '', '220000.00', '0101010310001200131901103', 2019, '', '247029.89', '47029.89', '20000.40', '200000.00', '267029.48', '0.00', ''),
(81, '01', '01', '01', '031', '0001', '2001', '31901105', 'N', '', '45000.00', '0101010310001200131901105', 2019, '', '45000.00', '484.86', '0.00', '45000.00', '45484.86', '0.00', ''),
(82, '01', '01', '01', '031', '0001', '2001', '31901106', 'N', '', '290000.00', '0101010310001200131901106', 2019, '', '290000.00', '34027.46', '41803.94', '290000.00', '282223.50', '0.00', ''),
(83, '01', '01', '01', '031', '0001', '2001', '31901110', 'N', '', '40000.00', '0101010310001200131901110', 2019, '', '40000.00', '8669.75', '0.00', '40000.00', '48669.75', '0.00', ''),
(84, '01', '01', '01', '031', '0001', '2001', '31901300', 'S', '', '75000.00', '0101010310001200131901300', 2019, '', '75000.00', '0.00', '0.00', '75000.00', '6930.58', '0.00', ''),
(85, '01', '01', '01', '031', '0001', '2001', '31901304', 'N', '', '75000.00', '0101010310001200131901304', 2019, '', '75000.00', '5750.00', '0.00', '75000.00', '72810.29', '0.00', ''),
(86, '01', '01', '01', '031', '0001', '2001', '31910000', 'S', '', '40000.00', '0101010310001200131910000', 2019, '', '-46621.57', '0.00', '0.00', '40000.00', '93145.23', '3592.00', ''),
(87, '01', '01', '01', '031', '0001', '2001', '31911300', 'S', '', '40000.00', '0101010310001200131911300', 2019, '', '-46621.57', '0.00', '0.00', '40000.00', '93145.23', '3592.00', ''),
(88, '01', '01', '01', '031', '0001', '2001', '31911304', 'N', '', '40000.00', '0101010310001200131911304', 2019, '', '40000.00', '4750.00', '0.00', '40000.00', '44747.72', '0.00', ''),
(89, '01', '01', '01', '031', '0001', '2001', '33000000', 'S', '', '350000.00', '0101010310001200133000000', 2019, '', '-1038349.87', '296349.33', '327610.04', '238209.29', '1309982.36', '45719.08', ''),
(90, '01', '01', '01', '031', '0001', '2001', '33900000', 'S', '', '350000.00', '0101010310001200133900000', 2019, '', '-1038349.87', '296349.33', '327610.04', '238209.29', '1309982.36', '45719.08', ''),
(91, '01', '01', '01', '031', '0001', '2001', '33901400', 'N', '', '40000.00', '0101010310001200133901400', 2019, '', '40000.00', '54000.00', '0.00', '40000.00', '92539.08', '0.00', ''),
(92, '01', '01', '01', '031', '0001', '2001', '33903000', 'N', '', '50000.00', '0101010310001200133903000', 2019, '', '50000.00', '0.00', '34000.00', '50000.00', '13953.62', '0.00', ''),
(93, '01', '01', '01', '031', '0001', '2001', '33903600', 'N', '', '60000.00', '0101010310001200133903600', 2019, '', '60000.00', '0.00', '20000.00', '60000.00', '39150.00', '0.00', ''),
(94, '01', '01', '01', '031', '0001', '2001', '33903900', 'N', '', '200000.00', '0101010310001200133903900', 2019, '', '200000.00', '110030.00', '0.00', '200000.00', '310017.80', '0.00', ''),
(95, '01', '01', '01', '031', '0001', '2001', '40000000', 'S', '', '90000.00', '0101010310001200140000000', 2019, '', '-109350.80', '0.00', '141350.00', '-51350.00', '58000.80', '0.00', ''),
(96, '01', '01', '01', '031', '0001', '2001', '44000000', 'S', '', '90000.00', '0101010310001200144000000', 2019, '', '-51350.00', '0.00', '141350.00', '-51350.00', '0.00', '0.00', ''),
(97, '01', '01', '01', '031', '0001', '2001', '44900000', 'S', '', '90000.00', '0101010310001200144900000', 2019, '', '-109350.80', '0.00', '142350.00', '-51350.00', '58000.80', '0.00', ''),
(98, '01', '01', '01', '031', '0001', '2001', '44905100', 'N', '', '40000.00', '0101010310001200144905100', 2019, '', '40000.00', '0.00', '40000.00', '40000.00', '0.00', '0.00', ''),
(99, '01', '01', '01', '031', '0001', '2001', '44905200', 'N', '', '50000.00', '0101010310001200144905200', 2019, '', '50000.00', '0.00', '45000.00', '50000.00', '3150.00', '0.00', ''),
(100, '02', '20', '', '', '', '', '', 'S', '', '2028000.00', '0220', 2019, '03', '3288000.00', '1260000.00', '0.00', '3288000.00', '0.00', '0.00', ''),
(101, '02', '20', '09', '', '', '', '', 'S', '', '2028000.00', '022009', 2019, '', '2928000.00', '900000.00', '0.00', '2928000.00', '0.00', '0.00', ''),
(102, '02', '20', '09', '272', '', '', '', 'S', '2', '2028000.00', '022009272', 2019, '10', '2028000.00', '0.00', '0.00', '2028000.00', '0.00', '0.00', ''),
(103, '02', '20', '09', '272', '0023', '', '', 'S', '2', '858000.00', '0220092720023', 2019, '10', '858000.00', '0.00', '0.00', '858000.00', '0.00', '0.00', ''),
(104, '02', '20', '09', '272', '0023', '1034', '', 'S', '2', '10000.00', '02200927200231034', 2019, '10', '10000.00', '0.00', '0.00', '10000.00', '0.00', '0.00', ''),
(105, '02', '20', '09', '272', '0023', '1034', '40000000', 'S', '', '10000.00', '0220092720023103440000000', 2019, '', '710649.20', '900000.00', '141350.00', '768650.00', '58000.80', '0.00', ''),
(106, '02', '20', '09', '272', '0023', '1034', '44000000', 'S', '', '10000.00', '0220092720023103444000000', 2019, '', '768650.00', '900000.00', '141350.00', '768650.00', '0.00', '0.00', ''),
(107, '02', '20', '09', '272', '0023', '1034', '44900000', 'S', '', '10000.00', '0220092720023103444900000', 2019, '', '710649.20', '900000.00', '141350.00', '768650.00', '58000.80', '0.00', ''),
(108, '02', '20', '09', '272', '0023', '1034', '44905100', 'N', '', '10000.00', '0220092720023103444905100', 2019, '', '10000.00', '0.00', '0.00', '10000.00', '0.00', '0.00', ''),
(109, '02', '20', '09', '272', '0023', '2050', '30000000', 'S', '', '198000.00', '0220092720023205030000000', 2019, '', '-5052588.80', '580000.00', '483789.48', '294210.52', '5346799.32', '258959.41', ''),
(110, '02', '20', '09', '272', '0023', '2050', '31000000', 'S', '', '72000.00', '0220092720023205031000000', 2019, '', '-3498923.84', '525000.00', '0.00', '597000.00', '4095923.84', '213240.33', ''),
(111, '02', '20', '09', '272', '0023', '2050', '31900000', 'S', '', '72000.00', '0220092720023205031900000', 2019, '', '-3594542.99', '525000.00', '179000.00', '418000.00', '4012542.99', '209648.33', ''),
(112, '02', '20', '09', '272', '0023', '2050', '31900500', 'N', '', '1000.00', '0220092720023205031900500', 2019, '', '1000.00', '0.00', '0.00', '1000.00', '0.00', '0.00', ''),
(113, '02', '20', '09', '272', '0023', '2050', '31901100', 'N', '', '70000.00', '0220092720023205031901100', 2019, '', '20896.00', '0.00', '0.00', '70000.00', '49104.00', '0.00', ''),
(114, '02', '20', '09', '272', '0023', '2050', '31901300', 'N', '', '1000.00', '0220092720023205031901300', 2019, '', '1000.00', '0.00', '0.00', '1000.00', '0.00', '0.00', ''),
(115, '02', '20', '09', '272', '0023', '2050', '33000000', 'S', '', '126000.00', '0220092720023205033000000', 2019, '', '-1365485.52', '55000.00', '295610.04', '-114610.04', '1250875.48', '45719.08', ''),
(116, '02', '20', '09', '272', '0023', '2050', '33900000', 'S', '', '126000.00', '0220092720023205033900000', 2019, '', '-1365485.52', '55000.00', '295610.04', '-114610.04', '1250875.48', '45719.08', ''),
(117, '02', '20', '09', '272', '0023', '2050', '33901400', 'N', '', '10000.00', '0220092720023205033901400', 2019, '', '5470.00', '0.00', '0.00', '10000.00', '4530.00', '0.00', ''),
(118, '02', '20', '09', '272', '0023', '2050', '33903000', 'N', '', '10000.00', '0220092720023205033903000', 2019, '', '6330.71', '0.00', '0.00', '10000.00', '3669.29', '0.00', ''),
(119, '02', '20', '09', '272', '0023', '2050', '33903300', 'N', '', '5000.00', '0220092720023205033903300', 2019, '', '3915.41', '0.00', '0.00', '5000.00', '1084.59', '0.00', ''),
(120, '02', '20', '09', '272', '0023', '2050', '33903500', 'N', '', '10000.00', '0220092720023205033903500', 2019, '', '10000.00', '0.00', '0.00', '10000.00', '0.00', '0.00', ''),
(121, '02', '20', '09', '272', '0023', '2050', '33903600', 'N', '', '30000.00', '0220092720023205033903600', 2019, '', '2442.50', '0.00', '0.00', '30000.00', '27557.50', '0.00', ''),
(122, '02', '20', '09', '272', '0023', '2050', '33903900', 'N', '', '60000.00', '0220092720023205033903900', 2019, '', '7802.17', '0.00', '0.00', '60000.00', '52197.83', '0.00', ''),
(123, '02', '20', '09', '272', '0023', '2050', '31909200', 'N', '', '1000.00', '0220092720023205031909200', 2019, '', '1000.00', '0.00', '0.00', '1000.00', '0.00', '0.00', ''),
(124, '02', '20', '09', '272', '0023', '2050', '40000000', 'S', '', '5000.00', '0220092720023205040000000', 2019, '', '705649.20', '900000.00', '141350.00', '763650.00', '58000.80', '0.00', ''),
(125, '02', '20', '09', '272', '0023', '2050', '44000000', 'S', '', '5000.00', '0220092720023205044000000', 2019, '', '763650.00', '900000.00', '141350.00', '763650.00', '0.00', '0.00', ''),
(126, '02', '20', '09', '272', '0023', '2050', '44900000', 'S', '', '5000.00', '0220092720023205044900000', 2019, '', '705649.20', '900000.00', '141350.00', '763650.00', '58000.80', '0.00', ''),
(127, '02', '20', '09', '272', '0023', '2050', '44905200', 'N', '', '5000.00', '0220092720023205044905200', 2019, '', '4800.00', '0.00', '0.00', '5000.00', '200.00', '0.00', ''),
(128, '02', '20', '09', '272', '0023', '2054', '', 'S', '2', '645000.00', '02200927200232054', 2019, '10', '645000.00', '0.00', '0.00', '645000.00', '0.00', '0.00', ''),
(129, '02', '20', '09', '272', '0023', '2054', '30000000', 'S', '', '645000.00', '0220092720023205430000000', 2019, '', '-4605588.80', '580000.00', '483789.48', '741210.52', '5346799.32', '258959.41', ''),
(130, '02', '20', '09', '272', '0023', '2054', '31000000', 'S', '', '625000.00', '0220092720023205431000000', 2019, '', '-2945923.84', '525000.00', '0.00', '1150000.00', '4095923.84', '213240.33', ''),
(131, '02', '20', '09', '272', '0023', '2054', '31900000', 'S', '', '625000.00', '0220092720023205431900000', 2019, '', '-3041542.99', '525000.00', '179000.00', '971000.00', '4012542.99', '209648.33', ''),
(132, '02', '20', '09', '272', '0023', '2054', '31900100', 'N', '', '450000.00', '0220092720023205431900100', 2019, '', '130690.10', '450000.00', '0.00', '900000.00', '769309.90', '0.00', ''),
(133, '02', '20', '09', '272', '0023', '2054', '31900300', 'N', '', '70000.00', '0220092720023205431900300', 2019, '', '9457.13', '0.00', '0.00', '70000.00', '60542.87', '0.00', ''),
(134, '02', '20', '09', '272', '0023', '2054', '31900500', 'N', '', '105000.00', '0220092720023205431900500', 2019, '', '1365.02', '0.00', '0.00', '105000.00', '103634.98', '0.00', ''),
(135, '02', '20', '09', '272', '0023', '2054', '30000000', 'S', '', '20000.00', '0220092720023205430000000', 2019, '', '-5230588.80', '580000.00', '483789.48', '116210.52', '5346799.32', '258959.41', ''),
(136, '02', '20', '09', '272', '0023', '2054', '33900000', 'S', '', '20000.00', '0220092720023205433900000', 2019, '', '-1471485.52', '55000.00', '295610.04', '-220610.04', '1250875.48', '45719.08', ''),
(137, '02', '20', '09', '272', '0023', '2054', '33909300', 'N', '', '20000.00', '0220092720023205433909300', 2019, '', '12740.92', '0.00', '0.00', '20000.00', '7259.08', '0.00', ''),
(138, '02', '20', '09', '272', '9999', '', '', 'S', '2', '117000.00', '0220092729999', 2019, '10', '117000.00', '0.00', '0.00', '117000.00', '0.00', '0.00', ''),
(139, '02', '20', '09', '272', '9999', '9999', '', 'S', '2', '117000.00', '02200927299999999', 2019, '10', '117000.00', '0.00', '0.00', '117000.00', '0.00', '0.00', ''),
(140, '02', '20', '09', '997', '9999', '9999', '90000000', 'S', '', '117000.00', '0220099979999999990000000', 2019, '', '117000.00', '0.00', '0.00', '117000.00', '0.00', '0.00', ''),
(141, '02', '20', '09', '997', '9999', '9999', '99000000', 'S', '', '117000.00', '0220099979999999999000000', 2019, '', '117000.00', '0.00', '0.00', '117000.00', '0.00', '0.00', ''),
(142, '02', '20', '09', '999', '9999', '9999', '99990000', 'S', '', '117000.00', '0220099999999999999990000', 2019, '', '117000.00', '0.00', '0.00', '117000.00', '0.00', '0.00', ''),
(144, '02', '20', '09', '997', '9999', '9999', '99999999', 'N', '', '1170000.00', '0220099979999999999999999', 2019, '', '935000.00', '0.00', '235000.00', '935000.00', '0.00', '0.00', ''),
(145, '01', '', '', '', '', '', '', 'S', '2', '1350000.00', '01', 2020, '', '1350000.00', '0.00', '0.00', '1350000.00', '0.00', '0.00', ''),
(146, '01', '01', '', '', '', '', '', 'S', '2', '1350000.00', '2020', 0, '', '1350000.00', '0.00', '0.00', '1350000.00', '0.00', '0.00', ''),
(147, '01', '01', '01', '', '', '', '', 'S', '2', '1350000.00', '010101', 2020, '', '1350000.00', '0.00', '0.00', '1350000.00', '0.00', '0.00', ''),
(148, '01', '01', '01', '031', '', '', '', 'S', '2', '1350000.00', '010101031', 2020, '', '1350000.00', '0.00', '0.00', '1350000.00', '0.00', '0.00', ''),
(149, '01', '01', '01', '031', '0001', '', '', 'S', '2', '1350000.00', '0101010310001', 2020, '', '1350000.00', '0.00', '0.00', '1350000.00', '0.00', '0.00', ''),
(150, '01', '01', '01', '031', '0001', '2001', '', 'S', '2', '1350000.00', '01010103100012001', 2020, '', '1350000.00', '0.00', '0.00', '1350000.00', '0.00', '0.00', ''),
(151, '01', '01', '01', '031', '0001', '2001', '30000000', 'S', '', '1350000.00', '0101010310001200130000000', 2020, '', '-878261.27', '273639.48', '240289.48', '1383350.00', '2261611.27', '258959.41', ''),
(152, '01', '01', '01', '031', '0001', '2001', '31000000', 'S', '', '635000.00', '0101010310001200131000000', 2020, '', '-935677.01', '89820.15', '0.00', '724820.15', '1660497.16', '213240.33', ''),
(153, '01', '01', '01', '031', '0001', '2001', '31900000', 'S', '', '635000.00', '0101010310001200131900000', 2020, '', '-926129.23', '89820.15', '23000.00', '701820.15', '1627949.38', '209648.33', ''),
(154, '01', '01', '01', '031', '0001', '2001', '31901100', 'S', '', '635000.00', '0101010310001200131901100', 2020, '', '-13495.31', '0.00', '0.00', '635000.00', '648495.31', '85420.86', ''),
(155, '01', '01', '01', '031', '0001', '2001', '31901103', 'N', '', '245000.00', '0101010310001200131901103', 2020, '', '162481.57', '0.00', '0.00', '245000.00', '82518.43', '0.00', ''),
(156, '01', '01', '01', '031', '0001', '2001', '31901105', 'N', '', '40000.00', '0101010310001200131901105', 2020, '', '19048.71', '0.00', '0.00', '40000.00', '20951.29', '0.00', ''),
(157, '01', '01', '01', '031', '0001', '2001', '31901106', 'N', '', '300000.00', '0101010310001200131901106', 2020, '', '196434.00', '0.00', '0.00', '300000.00', '103566.00', '0.00', ''),
(158, '01', '01', '01', '031', '0001', '2001', '31901110', 'N', '', '50000.00', '0101010310001200131901110', 2020, '', '33569.00', '0.00', '0.00', '50000.00', '16431.00', '0.00', ''),
(159, '01', '01', '01', '031', '0001', '2001', '31901300', 'S', '', '85000.00', '0101010310001200131901300', 2020, '', '85000.00', '0.00', '0.00', '85000.00', '0.00', '0.00', ''),
(160, '01', '01', '01', '031', '0001', '2001', '31901304', 'N', '', '85000.00', '0101010310001200131901304', 2020, '', '48001.69', '0.00', '0.00', '85000.00', '36998.31', '0.00', ''),
(161, '01', '01', '01', '031', '0001', '2001', '31911300', 'S', '', '50000.00', '0101010310001200131911300', 2020, '', '17452.22', '0.00', '0.00', '50000.00', '32547.78', '3592.00', ''),
(162, '01', '01', '01', '031', '0001', '2001', '31911304', 'N', '', '50000.00', '0101010310001200131911304', 2020, '', '37019.93', '0.00', '0.00', '50000.00', '12980.07', '0.00', ''),
(163, '01', '01', '01', '031', '0001', '2001', '33000000', 'S', '', '490000.00', '0101010310001200133000000', 2020, '', '-135404.82', '183819.33', '208110.04', '465709.29', '601114.11', '45719.08', ''),
(164, '01', '01', '01', '031', '0001', '2001', '33900000', 'S', '', '490000.00', '0101010310001200133900000', 2020, '', '-135404.82', '183819.33', '208110.04', '465709.29', '601114.11', '45719.08', ''),
(165, '01', '01', '01', '031', '0001', '2001', '33903000', 'N', '', '40000.00', '0101010310001200133903000', 2020, '', '37527.52', '0.00', '0.00', '40000.00', '2472.48', '0.00', ''),
(166, '01', '01', '01', '031', '0001', '2001', '33903600', 'N', '', '50000.00', '0101010310001200133903600', 2020, '', '44200.00', '0.00', '0.00', '50000.00', '5800.00', '0.00', ''),
(167, '01', '01', '01', '031', '0001', '2001', '33903900', 'N', '', '320000.00', '0101010310001200133903900', 2020, '', '237081.64', '0.00', '0.00', '320000.00', '82918.36', '0.00', ''),
(168, '01', '01', '01', '031', '0001', '2001', '40000000', 'S', '', '90000.00', '0101010310001200140000000', 2020, '', '-32073.90', '0.00', '105350.00', '-15350.00', '16723.90', '0.00', ''),
(169, '01', '01', '01', '031', '0001', '2001', '44000000', 'S', '', '90000.00', '0101010310001200144000000', 2020, '', '-15350.00', '0.00', '105350.00', '-15350.00', '0.00', '0.00', ''),
(170, '01', '01', '01', '031', '0001', '2001', '44900000', 'S', '', '90000.00', '0101010310001200144900000', 2020, '', '-32073.90', '0.00', '105350.00', '-15350.00', '16723.90', '0.00', ''),
(171, '01', '01', '01', '031', '0001', '2001', '44905100', 'N', '', '30000.00', '0101010310001200144905100', 2020, '', '30000.00', '0.00', '0.00', '30000.00', '0.00', '0.00', ''),
(172, '01', '01', '01', '031', '0001', '2001', '44905200', 'N', '', '60000.00', '0101010310001200144905200', 2020, '', '60000.00', '0.00', '0.00', '60000.00', '0.00', '0.00', ''),
(173, '01', '01', '01', '031', '0001', '2001', '33901400', 'N', '', '80000.00', '0101010310001200133901400', 2020, '', '68005.88', '0.00', '0.00', '80000.00', '11994.12', '0.00', ''),
(174, '02', '', '', '', '', '', '', 'S', '2', '2200000.00', '02', 2002, '', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '2'),
(175, '02', '20', '', '', '', '', '', 'S', '2', '2200000.00', '0220', 2020, '', '2420000.00', '220000.00', '0.00', '2420000.00', '0.00', '0.00', ''),
(176, '02', '20', '09', '', '', '', '', 'S', '2', '2200000.00', '022009', 2020, '14', '2200000.00', '0.00', '0.00', '2200000.00', '0.00', '0.00', ''),
(177, '02', '20', '09', '272', '', '', '', 'S', '2', '2200000.00', '022009272', 2020, '', '2200000.00', '0.00', '0.00', '2200000.00', '0.00', '0.00', ''),
(178, '02', '20', '09', '272', '0023', '', '', 'S', '2', '1030000.00', '0220092720023', 2020, '', '1030000.00', '0.00', '0.00', '1030000.00', '0.00', '0.00', ''),
(179, '02', '20', '09', '272', '0023', '1034', '', 'S', '2', '10000.00', '02200927200231034', 2020, '', '10000.00', '0.00', '0.00', '10000.00', '0.00', '0.00', ''),
(180, '02', '20', '09', '031', '0023', '1034', '40000000', 'S', '', '10000.00', '0220092720023103440000000', 2020, '', '-145521.70', '0.00', '105350.00', '-95350.00', '50171.70', '0.00', ''),
(181, '02', '20', '09', '272', '0023', '1034', '44000000', 'S', '', '10000.00', '0220092720023103444000000', 2020, '', '-95350.00', '0.00', '105350.00', '-95350.00', '0.00', '0.00', ''),
(182, '02', '20', '09', '272', '0023', '1034', '44900000', 'S', '', '10000.00', '0220092720023103444900000', 2020, '', '-112073.90', '0.00', '105350.00', '-95350.00', '16723.90', '0.00', ''),
(183, '02', '20', '09', '272', '0023', '1034', '44905100', 'N', '', '10000.00', '0220092720023103444905100', 2020, '', '10000.00', '0.00', '0.00', '10000.00', '0.00', '0.00', ''),
(184, '02', '20', '09', '272', '0023', '2050', '30000000', 'S', '', '72000.00', '0220092720023205030000000', 2020, '', '-3061800.18', '220000.00', '240289.48', '51710.52', '3113510.70', '258959.41', ''),
(185, '02', '20', '09', '272', '0023', '2050', '31000000', 'S', '', '72000.00', '0220092720023205031000000', 2020, '', '-2067554.11', '165000.00', '0.00', '237000.00', '2304554.11', '213240.33', ''),
(186, '02', '20', '09', '272', '0023', '2050', '31900000', 'S', '', '72000.00', '0220092720023205031900000', 2020, '', '-2046213.85', '165000.00', '23000.00', '214000.00', '2260213.85', '209648.33', ''),
(187, '02', '20', '09', '272', '0023', '2050', '31900500', 'N', '', '1000.00', '0220092720023205031900500', 2020, '', '60.07', '0.00', '0.00', '1000.00', '939.93', '0.00', ''),
(188, '02', '20', '09', '272', '0023', '2050', '31901100', 'N', '', '70000.00', '0220092720023205031901100', 2020, '', '13416.83', '0.00', '10000.00', '60000.00', '46583.17', '0.00', ''),
(189, '02', '20', '09', '272', '0023', '2050', '31911300', 'S', '', '1000.00', '0220092720023205031911300', 2020, '', '-43340.26', '0.00', '0.00', '1000.00', '44340.26', '3592.00', ''),
(190, '02', '20', '09', '272', '0023', '2050', '33000000', 'S', '', '161000.00', '0220092720023205033000000', 2020, '', '-801066.63', '55000.00', '208110.04', '7889.96', '808956.59', '45719.08', ''),
(191, '02', '20', '09', '272', '0023', '2050', '33900000', 'S', '', '161000.00', '0220092720023205033900000', 2020, '', '-801066.63', '55000.00', '208110.04', '7889.96', '808956.59', '45719.08', ''),
(192, '02', '20', '09', '272', '0023', '2050', '33901400', 'N', '', '20000.00', '0220092720023205033901400', 2020, '', '5000.00', '0.00', '15000.00', '5000.00', '0.00', '0.00', ''),
(193, '02', '20', '09', '272', '0023', '2050', '33903000', 'N', '', '10000.00', '0220092720023205033903000', 2020, '', '6046.52', '0.00', '0.00', '10000.00', '3953.48', '0.00', ''),
(194, '02', '20', '09', '272', '0023', '2050', '33903300', 'N', '', '10000.00', '0220092720023205033903300', 2020, '', '10000.00', '0.00', '0.00', '10000.00', '0.00', '0.00', ''),
(195, '02', '20', '09', '272', '0023', '2050', '33903500', 'N', '', '20000.00', '0220092720023205033903500', 2020, '', '20000.00', '0.00', '0.00', '20000.00', '0.00', '0.00', ''),
(196, '02', '20', '09', '272', '0023', '2050', '33903600', 'N', '', '30000.00', '0220092720023205033903600', 2020, '', '11346.85', '0.00', '0.00', '30000.00', '18653.15', '0.00', ''),
(197, '02', '20', '09', '272', '0023', '2050', '33903900', 'N', '', '60000.00', '0220092720023205033903900', 2020, '', '11290.15', '0.00', '0.00', '60000.00', '48709.85', '0.00', ''),
(198, '02', '20', '09', '272', '0023', '2050', '33909200', 'N', '', '1000.00', '0220092720023205033909200', 2020, '', '1000.00', '0.00', '0.00', '1000.00', '0.00', '0.00', ''),
(199, '02', '20', '09', '272', '0023', '2050', '40000000', 'S', '', '10000.00', '0220092720023205040000000', 2020, '', '-145521.70', '0.00', '105350.00', '-95350.00', '50171.70', '0.00', ''),
(200, '02', '20', '09', '272', '0023', '2050', '44000000', 'S', '', '10000.00', '0220092720023205044000000', 2020, '', '-95350.00', '0.00', '105350.00', '-95350.00', '0.00', '0.00', ''),
(201, '02', '20', '09', '272', '0023', '2050', '44900000', 'S', '', '10000.00', '0220092720023205044900000', 2020, '', '-112073.90', '0.00', '105350.00', '-95350.00', '16723.90', '0.00', ''),
(202, '02', '20', '09', '272', '0023', '2050', '44905200', 'N', '', '10000.00', '0220092720023205044905200', 2020, '', '10000.00', '0.00', '0.00', '10000.00', '0.00', '0.00', ''),
(203, '02', '20', '09', '272', '0023', '2054', '', 'S', '2', '787000.00', '02200927200232054', 2020, '', '787000.00', '0.00', '0.00', '787000.00', '0.00', '0.00', ''),
(204, '02', '20', '09', '272', '0023', '2054', '30000000', 'S', '', '787000.00', '0220092720023205430000000', 2020, '', '-2346800.18', '220000.00', '240289.48', '766710.52', '3113510.70', '258959.41', ''),
(205, '02', '20', '09', '272', '0023', '2054', '31000000', 'S', '', '767000.00', '0220092720023205431000000', 2020, '', '-1372554.11', '165000.00', '0.00', '932000.00', '2304554.11', '213240.33', ''),
(206, '02', '20', '09', '272', '0023', '2054', '31900000', 'S', '', '767000.00', '0220092720023205431900000', 2020, '', '-1351213.85', '165000.00', '23000.00', '909000.00', '2260213.85', '209648.33', ''),
(207, '02', '20', '09', '272', '0023', '2054', '31900100', 'N', '', '500000.00', '0220092720023205431900100', 2020, '', '31269.78', '360000.00', '0.00', '860000.00', '828730.22', '0.00', ''),
(208, '02', '20', '09', '272', '0023', '2054', '31900300', 'N', '', '80000.00', '0220092720023205431900300', 2020, '', '41.05', '0.00', '0.00', '80000.00', '79958.95', '0.00', ''),
(209, '02', '20', '09', '272', '0023', '2054', '31900500', 'N', '', '187000.00', '0220092720023205431900500', 2020, '', '55176.22', '0.00', '100000.00', '87000.00', '31823.78', '0.00', ''),
(210, '02', '20', '09', '272', '0023', '2054', '33000000', 'S', '', '20000.00', '0220092720023205433000000', 2020, '', '-942066.63', '55000.00', '208110.04', '-133110.04', '808956.59', '45719.08', ''),
(211, '02', '20', '09', '272', '0023', '2054', '33900000', 'S', '', '20000.00', '0220092720023205433900000', 2020, '', '-942066.63', '55000.00', '208110.04', '-133110.04', '808956.59', '45719.08', ''),
(212, '02', '20', '09', '272', '0023', '2054', '33390930', 'N', '', '20000.00', '0220092720023205433390930', 2020, '', '20000.00', '0.00', '0.00', '20000.00', '0.00', '0.00', ''),
(213, '02', '20', '09', '272', '0023', '2050', '', 'S', '2', '232000.00', '02200927200232050', 2020, '', '232000.00', '0.00', '0.00', '232000.00', '0.00', '0.00', ''),
(214, '02', '20', '09', '272', '9999', '', '', 'S', '2', '1171000.00', '0220092729999', 2020, '10', '1171000.00', '0.00', '0.00', '1171000.00', '0.00', '0.00', ''),
(215, '02', '20', '09', '272', '9999', '9999', '', 'S', '2', '1171000.00', '02200927299999999', 2020, '10', '1171000.00', '0.00', '0.00', '1171000.00', '0.00', '0.00', ''),
(216, '02', '20', '09', '997', '9999', '9999', '90000000', 'S', '', '1171000.00', '0220099979999999990000000', 2020, '', '1171000.00', '0.00', '0.00', '1171000.00', '0.00', '0.00', ''),
(217, '02', '20', '09', '997', '9999', '9999', '99000000', 'S', '', '1171000.00', '0220099979999999999000000', 2020, '', '1171000.00', '0.00', '0.00', '1171000.00', '0.00', '0.00', ''),
(218, '02', '20', '09', '997', '9999', '9999', '99990000', 'S', '', '1171000.00', '0220099979999999999990000', 2020, '', '1171000.00', '0.00', '0.00', '1171000.00', '0.00', '0.00', ''),
(219, '02', '20', '09', '997', '9999', '9999', '99999999', 'N', '', '1171000.00', '0220099979999999999999999', 2020, '', '271000.00', '0.00', '900000.00', '271000.00', '0.00', '0.00', ''),
(220, '01', '', '', '', '', '', '', 'S', '', '1450000.00', '01', 2021, '10000', '1450000.00', '0.00', '0.00', '1450000.00', '0.00', '0.00', ''),
(221, '01', '01', '', '', '', '', '', 'S', '', '1450000.00', '0101', 2021, '100000', '1450000.00', '0.00', '0.00', '1450000.00', '0.00', '0.00', ''),
(222, '01', '01', '01', '', '', '', '', 'S', '', '1450000.00', '010101', 2021, '100000', '1450000.00', '0.00', '0.00', '1450000.00', '0.00', '0.00', ''),
(223, '01', '01', '01', '031', '', '', '', 'S', '', '1450000.00', '010101031', 2021, '100000', '1450000.00', '0.00', '0.00', '1450000.00', '0.00', '0.00', ''),
(224, '01', '01', '01', '031', '0001', '', '', 'S', '', '1450000.00', '0101010310001', 2021, '100000', '1450000.00', '0.00', '0.00', '1450000.00', '0.00', '0.00', ''),
(225, '01', '01', '01', '031', '0001', '2001', '', 'S', '', '1450000.00', '01010103100012001', 2021, '100000', '1450000.00', '0.00', '0.00', '1450000.00', '0.00', '0.00', ''),
(226, '01', '01', '01', '031', '0001', '2001', '30000000', 'S', '', '1450000.00', '0101010310001200130000000', 2021, '', '1187504.19', '0.00', '0.00', '1450000.00', '262495.81', '258959.41', ''),
(227, '01', '01', '01', '031', '0001', '2001', '31000000', 'S', '', '860000.00', '0101010310001200131000000', 2021, '', '643223.27', '0.00', '0.00', '860000.00', '216776.73', '213240.33', ''),
(228, '01', '01', '01', '031', '0001', '2001', '31900000', 'S', '', '860000.00', '0101010310001200131900000', 2021, '', '646815.27', '0.00', '0.00', '860000.00', '213184.73', '209648.33', ''),
(229, '01', '01', '01', '031', '0001', '2001', '31901100', 'S', '', '715000.00', '0101010310001200131901100', 2021, '', '626042.74', '0.00', '0.00', '715000.00', '88957.26', '85420.86', ''),
(230, '01', '01', '01', '031', '0001', '2001', '31901103', 'N', '', '280000.00', '0101010310001200131901103', 2021, '', '0.00', '15699.48', '0.00', '295699.48', '295699.48', '0.00', ''),
(231, '01', '01', '01', '031', '0001', '2001', '31901105', 'N', '', '73000.00', '0101010310001200131901105', 2021, '', '245.16', '0.00', '0.00', '73000.00', '72754.84', '0.00', ''),
(232, '01', '01', '01', '031', '0001', '2001', '31901106', 'N', '', '312000.00', '0101010310001200131901106', 2021, '', '0.00', '24589.50', '0.00', '336589.50', '336589.50', '0.00', ''),
(233, '01', '01', '01', '031', '0001', '2001', '31901110', 'N', '', '50000.00', '0101010310001200131901110', 2021, '', '0.00', '3361.75', '0.00', '53361.75', '53361.75', '0.00', ''),
(234, '01', '01', '01', '031', '0001', '2001', '33000000', 'S', '', '500000.00', '0101010310001200133000000', 2021, '', '454280.92', '0.00', '0.00', '500000.00', '45719.08', '45719.08', ''),
(235, '01', '01', '01', '031', '0001', '2001', '33900000', 'S', '', '500000.00', '0101010310001200133900000', 2021, '', '454280.92', '0.00', '0.00', '500000.00', '45719.08', '45719.08', ''),
(236, '01', '01', '01', '031', '0001', '2001', '33901400', 'N', '', '80000.00', '0101010310001200133901400', 2021, '', '280.80', '175000.00', '395.03', '254604.97', '254324.17', '0.00', ''),
(237, '01', '01', '01', '031', '0001', '2001', '33903000', 'N', '', '40000.00', '0101010310001200133903000', 2021, '', '0.00', '0.00', '11239.28', '28760.72', '28760.72', '0.00', ''),
(238, '01', '01', '01', '031', '0001', '2001', '33903600', 'N', '', '60000.00', '0101010310001200133903600', 2021, '', '100.00', '0.00', '20000.00', '40000.00', '39900.00', '0.00', ''),
(239, '01', '01', '01', '031', '0001', '2001', '33903900', 'N', '', '320000.00', '0101010310001200133903900', 2021, '', '0.00', '8891.33', '90000.00', '238891.33', '238891.33', '0.00', ''),
(240, '01', '01', '01', '031', '0001', '2001', '40000000', 'S', '', '90000.00', '0101010310001200140000000', 2021, '', '90000.00', '0.00', '0.00', '90000.00', '0.00', '0.00', ''),
(241, '01', '01', '01', '031', '0001', '2001', '44000000', 'S', '', '90000.00', '0101010310001200144000000', 2021, '', '90000.00', '0.00', '0.00', '90000.00', '0.00', '0.00', ''),
(242, '01', '01', '01', '031', '0001', '2001', '44900000', 'S', '', '90000.00', '0101010310001200144900000', 2021, '', '90000.00', '0.00', '0.00', '90000.00', '0.00', '0.00', ''),
(243, '01', '01', '01', '031', '0001', '2001', '44905100', 'N', '', '30000.00', '0101010310001200144905100', 2021, '', '0.00', '0.00', '30000.00', '0.00', '0.00', '0.00', ''),
(244, '01', '01', '01', '031', '0001', '2001', '44905200', 'N', '', '60000.00', '0101010310001200144905200', 2021, '', '0.00', '0.00', '45175.00', '14825.00', '14825.00', '0.00', ''),
(245, '01', '01', '01', '031', '0001', '2001', '31901300', 'S', '', '102000.00', '0101010310001200131901300', 2021, '', '102000.00', '0.00', '0.00', '102000.00', '0.00', '0.00', ''),
(246, '01', '01', '01', '031', '0001', '2001', '31901304', 'N', '', '95000.00', '0101010310001200131901304', 2021, '', '0.00', '2518.99', '0.00', '97518.99', '97518.99', '0.00', ''),
(247, '01', '01', '01', '031', '0001', '2001', '31910000', 'S', '', '50000.00', '0101010310001200131910000', 2021, '', '46408.00', '0.00', '0.00', '50000.00', '3592.00', '3592.00', ''),
(248, '01', '01', '01', '031', '0001', '2001', '31911304', 'N', '', '50000.00', '0101010310001200131911304', 2021, '', '0.00', '0.00', '9251.74', '40748.26', '40748.26', '0.00', ''),
(249, '02', '20', '', '', '', '', '', 'S', '', '2400000.00', '02', 2021, '', '2400000.00', '0.00', '0.00', '2400000.00', '0.00', '0.00', ''),
(250, '02', '20', '', '', '', '', '', 'S', '', '2400000.00', '0220', 2021, '', '2400000.00', '0.00', '0.00', '2400000.00', '0.00', '0.00', ''),
(251, '02', '20', '09', '', '', '', '', 'S', '', '2400000.00', '022009', 2021, '', '2400000.00', '0.00', '0.00', '2400000.00', '0.00', '0.00', ''),
(252, '02', '20', '09', '272', '', '', '', 'S', '', '1400000.00', '022009272', 2021, '', '1400000.00', '0.00', '0.00', '1400000.00', '0.00', '0.00', ''),
(253, '02', '20', '09', '272', '0023', '', '', 'S', '', '1400000.00', '0220092720020', 2021, '', '1400000.00', '0.00', '0.00', '1400000.00', '0.00', '0.00', ''),
(254, '02', '20', '09', '272', '0023', '1034', '', 'S', '', '10000.00', '02200927200201034', 2021, '', '10000.00', '0.00', '0.00', '10000.00', '0.00', '0.00', ''),
(255, '02', '20', '09', '272', '0023', '1034', '40000000', 'S', '', '10000.00', '0220092720020103440000000', 2021, '', '10000.00', '0.00', '0.00', '10000.00', '0.00', '0.00', ''),
(256, '02', '20', '09', '272', '0023', '1034', '44000000', 'S', '', '10000.00', '0220092720020103444000000', 2021, '', '10000.00', '0.00', '0.00', '10000.00', '0.00', '0.00', ''),
(257, '02', '20', '09', '272', '0023', '1034', '44900000', 'S', '', '10000.00', '0220092720020103444900000', 2021, '', '10000.00', '0.00', '0.00', '10000.00', '0.00', '0.00', ''),
(258, '02', '20', '09', '272', '0023', '1034', '44905100', 'N', '', '10000.00', '0220092720020103444905100', 2021, '', '10000.00', '0.00', '0.00', '10000.00', '0.00', '0.00', ''),
(259, '02', '20', '09', '272', '0023', '2050', '', 'S', '', '350000.00', '02200927200202050', 2021, '', '350000.00', '0.00', '0.00', '350000.00', '0.00', '0.00', ''),
(260, '02', '20', '09', '272', '0023', '2050', '30000000', 'S', '', '320000.00', '0220092720020205030000000', 2021, '', '-38675.12', '0.00', '0.00', '320000.00', '358675.12', '258959.41', ''),
(261, '02', '20', '09', '272', '0023', '2050', '31000000', 'S', '', '90000.00', '0220092720020205031000000', 2021, '', '-221156.48', '0.00', '0.00', '90000.00', '311156.48', '213240.33', ''),
(262, '02', '20', '09', '272', '0023', '2050', '31900000', 'S', '', '90000.00', '0220092720020205031900000', 2021, '', '-217564.48', '0.00', '0.00', '90000.00', '307564.48', '209648.33', ''),
(264, '02', '20', '09', '272', '0023', '2050', '31901100', 'N', '', '80000.00', '0220092720020205031901100', 2021, '', '13363.20', '0.00', '23000.00', '57000.00', '43636.80', '0.00', ''),
(265, '02', '20', '09', '272', '0023', '2050', '31910000', 'S', '', '10000.00', '0220092720020205031910000', 2021, '', '6408.00', '0.00', '0.00', '10000.00', '3592.00', '3592.00', ''),
(266, '02', '20', '09', '272', '0023', '2050', '31911300', 'S', '', '10000.00', '0220092720020205031911300', 2021, '', '6408.00', '0.00', '0.00', '10000.00', '3592.00', '3592.00', ''),
(267, '02', '20', '09', '272', '0023', '2050', '33000000', 'S', '', '230000.00', '0220092720020205033000000', 2021, '', '182481.36', '0.00', '0.00', '230000.00', '47518.64', '45719.08', ''),
(268, '02', '20', '09', '272', '0023', '2050', '33900000', 'S', '', '230000.00', '0220092720020205033900000', 2021, '', '182481.36', '0.00', '0.00', '230000.00', '47518.64', '45719.08', ''),
(269, '02', '20', '09', '272', '0023', '2050', '33901400', 'N', '', '20000.00', '0220092720020205033901400', 2021, '', '3583.40', '10000.00', '13000.00', '17000.00', '13416.60', '0.00', ''),
(270, '02', '20', '09', '272', '0023', '2050', '33903000', 'N', '', '20000.00', '0220092720020205033903000', 2021, '', '16452.48', '0.00', '0.00', '20000.00', '3547.52', '0.00', ''),
(271, '02', '20', '09', '272', '0023', '2050', '33903300', 'N', '', '20000.00', '0220092720020205033903300', 2021, '', '7217.78', '0.00', '12000.00', '8000.00', '782.22', '0.00', ''),
(272, '02', '20', '09', '272', '0023', '2050', '33903500', 'N', '', '40000.00', '0220092720020205033903500', 2021, '', '0.00', '0.00', '30000.00', '10000.00', '10000.00', '0.00', ''),
(273, '02', '20', '09', '272', '0023', '2050', '33903600', 'N', '', '50000.00', '0220092720020205033903600', 2021, '', '16966.40', '0.00', '0.00', '50000.00', '33033.60', '0.00', ''),
(274, '02', '20', '09', '272', '0023', '2050', '33903900', 'N', '', '60000.00', '0220092720020205033903900', 2021, '', '5740.24', '15000.00', '0.00', '75000.00', '69259.76', '0.00', ''),
(275, '02', '20', '09', '272', '0023', '2050', '33904700', 'N', '', '10000.00', '0220092720020205033904700', 2021, '', '10000.00', '0.00', '0.00', '10000.00', '0.00', '0.00', ''),
(276, '02', '20', '09', '272', '0023', '2050', '33909200', 'N', '', '10000.00', '0220092720020205033909200', 2021, '', '10000.00', '0.00', '0.00', '10000.00', '0.00', '0.00', ''),
(277, '02', '20', '09', '272', '0023', '2050', '40000000', 'S', '', '30000.00', '0220092720020205040000000', 2021, '', '30000.00', '0.00', '0.00', '30000.00', '0.00', '0.00', ''),
(278, '02', '20', '09', '272', '0023', '2050', '44000000', 'S', '', '30000.00', '0220092720020205044000000', 2021, '', '30000.00', '0.00', '0.00', '30000.00', '0.00', '0.00', ''),
(279, '02', '20', '09', '272', '0023', '2050', '44900000', 'S', '', '30000.00', '0220092720020205044900000', 2021, '', '30000.00', '0.00', '0.00', '30000.00', '0.00', '0.00', ''),
(280, '02', '20', '09', '272', '0023', '2050', '44905200', 'N', '', '30000.00', '0220092720020205044905200', 2021, '', '8101.10', '0.00', '20000.00', '10000.00', '1898.90', '0.00', ''),
(281, '02', '20', '09', '272', '0023', '2054', '', 'S', '', '1040000.00', '02200927200202054', 2021, '', '1040000.00', '0.00', '0.00', '1040000.00', '0.00', '0.00', '1'),
(282, '02', '20', '09', '272', '0023', '2054', '30000000', 'S', '', '1040000.00', '0220092720020205430000000', 2021, '', '681324.88', '0.00', '0.00', '1040000.00', '358675.12', '258959.41', ''),
(283, '02', '20', '09', '272', '0023', '2054', '31000000', 'S', '', '1000000.00', '0220092720020205431000000', 2021, '', '688843.52', '0.00', '0.00', '1000000.00', '311156.48', '213240.33', ''),
(284, '02', '20', '09', '272', '0023', '2054', '31900000', 'S', '', '1000000.00', '0220092720020205431900000', 2021, '', '692435.52', '0.00', '0.00', '1000000.00', '307564.48', '209648.33', ''),
(285, '02', '20', '09', '272', '0023', '2054', '31900100', 'N', '', '900000.00', '0220092720020205431900100', 2021, '', '5483.64', '50000.00', '0.00', '950000.00', '944516.36', '0.00', ''),
(286, '02', '20', '09', '272', '0023', '2054', '31900300', 'N', '', '100000.00', '0220092720020205431900300', 2021, '', '8512.20', '115000.00', '0.00', '215000.00', '206487.80', '0.00', ''),
(287, '02', '20', '09', '272', '0023', '2054', '31900500', 'N', '', '10000.00', '0220092720020205431900500', 2021, '', '10000.00', '0.00', '0.00', '10000.00', '0.00', '0.00', ''),
(288, '02', '20', '09', '272', '0023', '2054', '33000000', 'S', '', '40000.00', '0220092720020205433000000', 2021, '', '-7518.64', '0.00', '0.00', '40000.00', '47518.64', '45719.08', ''),
(289, '02', '20', '09', '272', '0023', '2054', '33900000', 'S', '', '40000.00', '0220092720020205433900000', 2021, '', '-7518.64', '0.00', '0.00', '40000.00', '47518.64', '45719.08', ''),
(290, '02', '20', '09', '272', '0023', '2054', '33909300', 'N', '', '40000.00', '0220092720020205433909300', 2021, '', '12821.75', '30000.00', '22000.00', '48000.00', '35178.25', '0.00', ''),
(291, '02', '20', '99', '', '', '', '', 'S', '', '1000000.00', '022099', 2021, '', '900000.00', '0.00', '0.00', '900000.00', '0.00', '0.00', ''),
(292, '02', '20', '99', '997', '', '', '', 'S', '', '1000000.00', '022099997', 2021, '', '900000.00', '0.00', '0.00', '900000.00', '0.00', '0.00', ''),
(293, '02', '20', '99', '997', '0023', '', '', 'S', '', '1000000.00', '0220999979999', 2021, '', '900000.00', '0.00', '0.00', '900000.00', '0.00', '0.00', ''),
(294, '02', '20', '99', '997', '0023', '9999', '', 'S', '', '1000000.00', '02209999799999999', 2021, '', '900000.00', '0.00', '0.00', '900000.00', '0.00', '0.00', ''),
(295, '02', '20', '99', '997', '0023', '9999', '90000000', 'S', '', '1000000.00', '0220999979999999900000000', 2021, '', '900000.00', '0.00', '0.00', '900000.00', '0.00', '0.00', ''),
(296, '02', '20', '99', '997', '0023', '9999', '99000000', 'S', '', '1000000.00', '0220999979999999999000000', 2021, '', '900000.00', '0.00', '0.00', '900000.00', '0.00', '0.00', ''),
(297, '02', '20', '99', '997', '0023', '9999', '99990000', 'S', '', '1000000.00', '0220999979999999999990000', 2021, '', '900000.00', '0.00', '0.00', '900000.00', '0.00', '0.00', ''),
(298, '02', '20', '99', '997', '0023', '9999', '99999999', 'N', '', '1000000.00', '0220999979999999999999999', 2021, '', '900000.00', '0.00', '100000.00', '900000.00', '0.00', '0.00', ''),
(299, '02', '20', '09', '272', '0023', '2050', '31910000', 'S', '', '10000.00', '0220092720020205031910000', 2021, '', '6408.00', '0.00', '0.00', '10000.00', '3592.00', '3592.00', ''),
(300, '02', '20', '09', '272', '0023', '2050', '31911300', 'S', '', '10000.00', '0220092720020205031911300', 2021, '', '6408.00', '0.00', '0.00', '10000.00', '3592.00', '3592.00', ''),
(301, '01', '', '', '', '', '', '', 'S', '', '1500000.00', '01', 2022, '0', '1500000.00', '0.00', '0.00', '1500000.00', '0.00', '0.00', ''),
(302, '01', '01', '', '', '', '', '', 'S', '1', '1500000.00', '0101', 2022, '0', '1500000.00', '0.00', '0.00', '1500000.00', '0.00', '0.00', ''),
(303, '01', '01', '01', '', '', '', '', 'S', '', '1500000.00', '010101', 2022, '', '1500000.00', '0.00', '0.00', '1500000.00', '0.00', '0.00', ''),
(304, '01', '01', '01', '031', '', '', '', 'S', '', '1500000.00', '010101031', 2022, '', '1500000.00', '0.00', '0.00', '1500000.00', '0.00', '0.00', ''),
(305, '01', '01', '01', '031', '0001', '', '', 'S', '', '1500000.00', '0101010310001', 2022, '', '1500000.00', '0.00', '0.00', '1500000.00', '0.00', '0.00', ''),
(306, '01', '01', '01', '031', '0001', '2001', '', 'S', '', '1500000.00', '01010103100012001', 2022, '', '1500000.00', '0.00', '0.00', '1500000.00', '0.00', '0.00', ''),
(307, '01', '01', '01', '031', '0001', '2001', '30000000', 'S', '', '1410000.00', '0101010310001200130000000', 2022, '', '1410000.00', '0.00', '0.00', '1410000.00', '0.00', '0.00', ''),
(308, '01', '01', '01', '031', '0001', '2001', '31000000', 'S', '', '860000.00', '0101010310001200131000000', 2022, '', '860000.00', '0.00', '0.00', '860000.00', '0.00', '0.00', ''),
(309, '01', '01', '01', '031', '0001', '2001', '31900000', 'S', '', '860000.00', '0101010310001200131900000', 2022, '', '860000.00', '0.00', '0.00', '860000.00', '0.00', '0.00', ''),
(310, '01', '01', '01', '031', '0001', '2001', '31901100', 'S', '', '715000.00', '0101010310001200131901100', 2022, '', '715000.00', '0.00', '0.00', '715000.00', '0.00', '0.00', ''),
(311, '01', '01', '01', '031', '0001', '2001', '31901103', 'N', '', '280000.00', '0101010310001200131901103', 2022, '', '254281.87', '0.00', '0.00', '280000.00', '25718.13', '25718.13', ''),
(312, '01', '01', '01', '031', '0001', '2001', '31901105', 'N', '', '73000.00', '0101010310001200131901105', 2022, '', '66363.18', '0.00', '0.00', '73000.00', '6636.82', '6636.82', ''),
(313, '01', '01', '01', '031', '0001', '2001', '31901106', 'N', '', '312000.00', '0101010310001200131901106', 2022, '', '272300.69', '0.00', '0.00', '312000.00', '39699.31', '39699.31', ''),
(314, '01', '01', '01', '031', '0001', '2001', '31901110', 'N', '', '50000.00', '0101010310001200131901110', 2022, '', '43706.20', '0.00', '0.00', '50000.00', '6293.80', '6293.80', ''),
(315, '01', '01', '01', '031', '0001', '2001', '31901300', 'S', '', '95000.00', '0101010310001200131901300', 2022, '', '95000.00', '0.00', '0.00', '95000.00', '0.00', '0.00', ''),
(316, '01', '01', '01', '031', '0001', '2001', '31901304', 'N', '', '95000.00', '0101010310001200131901304', 2022, '', '86551.16', '0.00', '0.00', '95000.00', '8448.84', '8448.84', ''),
(317, '01', '01', '01', '031', '0001', '2001', '31910000', 'S', '', '50000.00', '0101010310001200131910000', 2022, '', '50000.00', '0.00', '0.00', '50000.00', '0.00', '0.00', ''),
(318, '01', '01', '01', '031', '0001', '2001', '31911300', 'S', '', '50000.00', '0101010310001200131911300', 2022, '', '50000.00', '0.00', '0.00', '50000.00', '0.00', '0.00', ''),
(319, '01', '01', '01', '031', '0001', '2001', '31911304', 'N', '', '50000.00', '0101010310001200131911304', 2022, '', '46408.00', '0.00', '0.00', '50000.00', '3592.00', '3592.00', ''),
(320, '01', '01', '01', '031', '0001', '2001', '33000000', 'S', '', '550000.00', '0101010310001200133000000', 2022, '', '550000.00', '0.00', '0.00', '550000.00', '0.00', '0.00', ''),
(321, '01', '01', '01', '031', '0001', '2001', '33900000', 'S', '', '550000.00', '0101010310001200133900000', 2022, '', '550000.00', '0.00', '0.00', '550000.00', '0.00', '0.00', ''),
(322, '01', '01', '01', '031', '0001', '2001', '33901400', 'N', '', '130000.00', '0101010310001200133901400', 2022, '', '130000.00', '0.00', '0.00', '130000.00', '0.00', '0.00', ''),
(323, '01', '01', '01', '031', '0001', '2001', '33903000', 'N', '', '40000.00', '0101010310001200133903000', 2022, '', '38794.72', '0.00', '0.00', '40000.00', '1205.28', '1205.28', ''),
(324, '01', '01', '01', '031', '0001', '2001', '33903600', 'N', '', '60000.00', '0101010310001200133903600', 2022, '', '53766.60', '0.00', '0.00', '60000.00', '6233.40', '6233.40', ''),
(325, '01', '01', '01', '031', '0001', '2001', '33903900', 'N', '', '320000.00', '0101010310001200133903900', 2022, '', '282496.20', '0.00', '0.00', '320000.00', '37503.80', '37503.80', '');
INSERT INTO `pldespesa` (`id`, `cdorgao`, `cdunidade`, `cdfuncao`, `cdsubfuncao`, `cdprograma`, `cdprojeto`, `cdelemento`, `tipo`, `classe`, `vlorcado`, `conta`, `exercicio`, `fonte`, `saldo_atual`, `vlrsupl`, `vlredu`, `dot_atual`, `valor_exer`, `valor_mes`, `dconta`) VALUES
(326, '01', '01', '01', '031', '0001', '2001', '40000000', 'S', '', '90000.00', '0101010310001200140000000', 2022, '', '90000.00', '0.00', '0.00', '90000.00', '0.00', '0.00', ''),
(327, '01', '01', '01', '031', '0001', '2001', '44000000', 'S', '', '90000.00', '0101010310001200144000000', 2022, '', '90000.00', '0.00', '0.00', '90000.00', '0.00', '0.00', ''),
(328, '01', '01', '01', '031', '0001', '2001', '44900000', 'S', '', '90000.00', '0101010310001200144900000', 2022, '', '90000.00', '0.00', '0.00', '90000.00', '0.00', '0.00', ''),
(329, '01', '01', '01', '031', '0001', '2001', '44905100', 'N', '', '30000.00', '0101010310001200144905100', 2022, '', '30000.00', '0.00', '0.00', '30000.00', '0.00', '0.00', ''),
(330, '01', '01', '01', '031', '0001', '2001', '44905200', 'N', '', '60000.00', '0101010310001200144905200', 2022, '', '60000.00', '0.00', '0.00', '60000.00', '0.00', '0.00', ''),
(331, '07', '', '', '', '', '', '', 'S', '', '0.00', '07', 2022, '', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', ''),
(332, '07', '20', '', '', '', '', '', 'S', '', '0.00', '0720', 2022, '', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', ''),
(333, '07', '20', '09', '', '', '', '', 'S', '', '0.00', '072009', 2022, '', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', ''),
(334, '07', '20', '09', '272', '', '', '', 'S', '', '0.00', '072009272', 2022, '', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', ''),
(335, '07', '20', '09', '272', '0016', '', '', 'S', '', '0.00', '0720092720016', 2022, '', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', ''),
(336, '07', '20', '09', '272', '0016', '1007', '', 'S', '', '0.00', '07200927200161007', 2022, '', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', ''),
(337, '07', '20', '09', '272', '0016', '1007', '40000000', 'S', '', '0.00', '0720092720016100740000000', 2022, '', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', ''),
(338, '07', '20', '09', '272', '0016', '1007', '44000000', 'S', '', '0.00', '0720092720016100744000000', 2022, '', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', ''),
(339, '07', '20', '09', '272', '0016', '1007', '44900000', 'N', '', '0.00', '0720092720016100744900000', 2022, '', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', ''),
(340, '07', '20', '09', '272', '0016', '1007', '44905100', 'N', '', '10000.00', '0720092720016100744905100', 2022, '', '10000.00', '0.00', '0.00', '10000.00', '0.00', '0.00', ''),
(341, '07', '20', '09', '272', '0016', '2054', '', 'S', '', '0.00', '07200927200162054', 2022, '', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', ''),
(342, '07', '20', '09', '272', '0016', '2054', '30000000', 'S', '', '0.00', '0720092720016205430000000', 2022, '', '-166483.33', '0.00', '0.00', '0.00', '166483.33', '166483.33', ''),
(343, '07', '20', '09', '272', '0016', '2054', '31000000', 'S', '', '0.00', '0720092720016205431000000', 2022, '', '-134892.27', '0.00', '0.00', '0.00', '134892.27', '134892.27', ''),
(344, '07', '20', '09', '272', '0016', '2054', '31900000', 'S', '', '0.00', '0720092720016205431900000', 2022, '', '-131300.27', '0.00', '0.00', '0.00', '131300.27', '131300.27', ''),
(345, '07', '20', '09', '272', '0016', '2054', '31901100', 'N', '', '80000.00', '0720092720016205431901100', 2022, '', '72927.20', '0.00', '0.00', '80000.00', '7072.80', '7072.80', ''),
(346, '07', '20', '09', '272', '0016', '2054', '31911300', 'S', '', '0.00', '0720092720016205431911300', 2022, '', '-3592.00', '0.00', '0.00', '0.00', '3592.00', '3592.00', ''),
(347, '07', '20', '09', '272', '0016', '2054', '31911304', 'N', '', '10000.00', '0720092720016205431911304', 2022, '', '10000.00', '0.00', '0.00', '10000.00', '0.00', '0.00', ''),
(348, '07', '20', '09', '272', '0016', '2054', '33000000', 'S', '', '0.00', '0720092720016205433000000', 2022, '', '-31591.06', '0.00', '0.00', '0.00', '31591.06', '31591.06', ''),
(349, '07', '20', '09', '272', '0016', '2054', '33900000', 'S', '', '0.00', '0720092720016205433900000', 2022, '', '-31591.06', '0.00', '0.00', '0.00', '31591.06', '31591.06', ''),
(350, '07', '20', '09', '272', '0016', '2054', '33901400', 'N', '', '70000.00', '0720092720016205433901400', 2022, '', '70000.00', '0.00', '0.00', '70000.00', '0.00', '0.00', ''),
(351, '07', '20', '09', '272', '0016', '2054', '33903000', 'N', '', '20000.00', '0720092720016205433903000', 2022, '', '20000.00', '0.00', '0.00', '20000.00', '0.00', '0.00', ''),
(352, '07', '20', '09', '272', '0016', '2054', '33903300', 'N', '', '20000.00', '0720092720016205433903300', 2022, '', '20000.00', '0.00', '0.00', '20000.00', '0.00', '0.00', ''),
(353, '07', '20', '09', '272', '0016', '2054', '33903500', 'N', '', '40000.00', '0720092720016205433903500', 2022, '', '40000.00', '0.00', '0.00', '40000.00', '0.00', '0.00', ''),
(354, '07', '20', '09', '272', '0016', '2054', '33903600', 'N', '', '50000.00', '0720092720016205433903600', 2022, '', '50000.00', '0.00', '0.00', '50000.00', '0.00', '0.00', ''),
(355, '07', '20', '09', '272', '0016', '2054', '33903900', 'N', '', '60000.00', '0720092720016205433903900', 2022, '', '59223.40', '0.00', '0.00', '60000.00', '776.60', '776.60', ''),
(356, '07', '20', '09', '272', '0016', '2054', '33904700', 'N', '', '10000.00', '0720092720016205433904700', 2022, '', '10000.00', '0.00', '0.00', '10000.00', '0.00', '0.00', ''),
(357, '07', '20', '09', '272', '0016', '2054', '33909200', 'N', '', '10000.00', '0720092720016205433909200', 2022, '', '10000.00', '0.00', '0.00', '10000.00', '0.00', '0.00', ''),
(358, '07', '20', '09', '272', '0016', '2054', '40000000', 'S', '', '0.00', '0720092720016205440000000', 2022, '', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', ''),
(359, '07', '20', '09', '272', '0016', '2054', '44000000', 'S', '', '0.00', '0720092720016205444000000', 2022, '', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', ''),
(360, '07', '20', '09', '272', '0016', '2054', '44900000', 'N', '', '0.00', '0720092720016205444900000', 2022, '', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', ''),
(361, '07', '20', '09', '272', '0016', '2054', '44905200', 'N', '', '30000.00', '0720092720016205444905200', 2022, '', '30000.00', '0.00', '0.00', '30000.00', '0.00', '0.00', ''),
(362, '07', '20', '09', '272', '0016', '2055', '', 'S', '', '0.00', '07200927200162055', 2022, '', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', ''),
(363, '07', '20', '09', '272', '0016', '2055', '30000000', 'S', '', '0.00', '0720092720016205530000000', 2022, '', '-166483.33', '0.00', '0.00', '0.00', '166483.33', '166483.33', ''),
(364, '07', '20', '09', '272', '0016', '2055', '31000000', 'S', '', '0.00', '0720092720016205531000000', 2022, '', '-134892.27', '0.00', '0.00', '0.00', '134892.27', '134892.27', ''),
(365, '07', '20', '09', '272', '0016', '2055', '31900000', 'S', '', '0.00', '0720092720016205531900000', 2022, '', '-131300.27', '0.00', '0.00', '0.00', '131300.27', '131300.27', ''),
(366, '07', '20', '09', '272', '0016', '2055', '31900100', 'N', '', '1200000.00', '0720092720016205531900100', 2022, '', '1109797.36', '0.00', '0.00', '1200000.00', '90202.64', '90202.64', ''),
(367, '07', '20', '09', '272', '0016', '2055', '31900300', 'N', '', '130000.00', '0720092720016205531900300', 2022, '', '104424.01', '0.00', '0.00', '130000.00', '25575.99', '25575.99', ''),
(368, '07', '20', '09', '272', '0016', '2055', '33000000', 'S', '', '0.00', '0720092720016205533000000', 2022, '', '-31591.06', '0.00', '0.00', '0.00', '31591.06', '31591.06', ''),
(369, '07', '20', '09', '272', '0016', '2055', '33900000', 'S', '', '0.00', '0720092720016205533900000', 2022, '', '-31591.06', '0.00', '0.00', '0.00', '31591.06', '31591.06', ''),
(370, '07', '20', '09', '272', '0016', '2055', '33909300', 'N', '', '40000.00', '0720092720016205533909300', 2022, '', '40000.00', '0.00', '0.00', '40000.00', '0.00', '0.00', ''),
(371, '07', '20', '99', '', '', '', '', 'S', '', '0.00', '072099', 2022, '', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', ''),
(372, '07', '20', '99', '997', '', '', '', 'S', '', '0.00', '072099997', 2022, '', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', ''),
(373, '07', '20', '99', '997', '7999', '', '', 'S', '', '0.00', '0720999977999', 2022, '', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', ''),
(374, '07', '20', '99', '997', '7999', '7999', '', 'S', '', '0.00', '07209999779997999', 2022, '', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', ''),
(375, '07', '20', '99', '997', '7999', '7999', '90000000', 'S', '', '0.00', '0720999977999799990000000', 2022, '', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', ''),
(376, '07', '20', '99', '997', '7999', '7999', '99000000', 'S', '', '0.00', '0720999977999799999000000', 2022, '', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', ''),
(377, '07', '20', '99', '997', '7999', '7999', '99990000', 'S', '', '0.00', '0720999977999799999990000', 2022, '', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', ''),
(378, '07', '20', '99', '997', '7999', '7999', '99999999', 'N', '', '1000000.00', '0720999977999799999999999', 2022, '', '1000000.00', '0.00', '0.00', '1000000.00', '0.00', '0.00', '');

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

--
-- Estrutura da tabela `plprevrec`
--

CREATE TABLE IF NOT EXISTS `plprevrec` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `plp_codigo` varchar(10) NOT NULL,
  `plp_descri` varchar(80) NOT NULL,
  `plp_santer` decimal(16,2) NOT NULL,
  `plp_debito` decimal(16,2) NOT NULL,
  `plp_credito` decimal(16,2) NOT NULL,
  `plp_satual` decimal(16,2) NOT NULL,
  `plp_exerc` varchar(4) NOT NULL,
  `plp_unida` varchar(2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Extraindo dados da tabela `plprevrec`
--

INSERT INTO `plprevrec` (`id`, `plp_codigo`, `plp_descri`, `plp_santer`, `plp_debito`, `plp_credito`, `plp_satual`, `plp_exerc`, `plp_unida`) VALUES
(1, '113620101', 'Contribuição do RPPS a Receber Pratonal', '158341.23', '2464188.59', '2405618.92', '216910.90', '', '02'),
(2, '1.1.3.6.2.', 'Contribuição do RPPS a Receber , Servidor, Aposentado e Pensionista', '0.00', '1120052.94', '1120052.94', '0.00', '', '02'),
(3, '121150604', 'Receita de Parcelamento Com a Prefeitura', '0.00', '0.00', '0.00', '0.00', '', '02');

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

--
-- Estrutura da tabela `plreceita`
--

CREATE TABLE IF NOT EXISTS `plreceita` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `codigo` varchar(14) NOT NULL,
  `descricao` varchar(80) NOT NULL,
  `cdorgao` varchar(2) NOT NULL,
  `cdunidade` varchar(2) NOT NULL,
  `fonte` varchar(6) NOT NULL,
  `exercicio` int(4) NOT NULL,
  `vlprevisto` decimal(16,2) NOT NULL,
  `tipo` varchar(1) NOT NULL,
  `educacao` varchar(1) NOT NULL,
  `saude` varchar(1) NOT NULL,
  `dedutiva` varchar(1) NOT NULL,
  `id_banco` int(11) NOT NULL,
  `vlr_mes` decimal(16,2) NOT NULL,
  `vlr_exer` decimal(16,2) NOT NULL,
  `vlr_saldo` decimal(16,2) NOT NULL,
  `vlr_ante` decimal(16,2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=303 ;

--
-- Extraindo dados da tabela `plreceita`
--

INSERT INTO `plreceita` (`id`, `codigo`, `descricao`, `cdorgao`, `cdunidade`, `fonte`, `exercicio`, `vlprevisto`, `tipo`, `educacao`, `saude`, `dedutiva`, `id_banco`, `vlr_mes`, `vlr_exer`, `vlr_saldo`, `vlr_ante`) VALUES
(35, '10000000000000', 'Receitas Corrertes', '02', '20', '41', 2019, '1498000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(36, '12000000000000', 'Contribuições', '02', '20', '41', 2019, '610000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(37, '12100000000000', 'Contribuições Sociais0000', '02', '20', '41', 2019, '610000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(38, '12180000000000', 'Contrib. Sociais Específica de Estados e Municípios', '01', '20', '41', 2019, '610000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(39, '12180100000000', 'Contribuição do Servidor Civil', '02', '20', '41', 2019, '600000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(40, '12180101000000', 'CPSSS do Servidor Civil Ativo-Poder Executivo', '02', '20', '41', 2019, '594000.00', 'N', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(41, '12080102000000', 'CPSSS do Servidor Civil Ativo-Poder Legislativo', '02', '20', '41', 2019, '6000.00', 'N', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(42, '12180200000000', 'CPSSS do Servidor iNATIVO ', '02', '20', '41', 2019, '5000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(43, '12180201000000', 'CPSSS do Servidor iNATIVO -Executivo', '02', '20', '41', 2019, '4950.00', 'N', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(44, '12180202000000', 'CPSSS do Servidor iNATIVO -Legislativo', '02', '20', '41', 2019, '50.00', 'N', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(45, '12180300000000', 'CPSSS-Patronal Servidor Civil', '02', '20', '41', 2019, '5000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(46, '12180301000000', 'CPSSS-Servidor Civil Ativo', '02', '20', '41', 2019, '4950.00', 'N', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(47, '12180302000000', 'CPSSS do Servidor Civil Pensionistas-Poder Legislativo', '02', '20', '41', 2019, '50.00', 'N', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(48, '13000000000000', 'Receitas Patrimoniais', '02', '20', '41', 2019, '403000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(49, '13200000000000', 'Valores Mobiliários', '02', '20', '41', 2019, '403000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(50, '13210000000000', 'Juros e Correções Monetárias', '02', '20', '41', 2019, '373000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(51, '13210040000000', 'Remuneração  dos Recursos Regime Próprio de Previdência-RPPS ', '02', '20', '41', 2019, '373000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(52, '13210041000000', 'Remuneração dos Serviços Próprios de Previdência-RPPS', '02', '20', '41', 2019, '373000.00', 'N', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(53, '13290000000000', 'Outros Valores Mobiliarios ', '02', '20', '41', 2019, '30000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(54, '13290110000000', 'Outros Valores Mobiliários ', '02', '20', '41', 2019, '30000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(55, '13290110100000', 'Outros Valores Mobiliários -Principal', '02', '20', '41', 2019, '30000.00', 'N', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(56, '19000000000000', 'Outras Receitas Correntes', '02', '20', '41', 2019, '485000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(57, '19200000000000', 'Indenizações, Restituições e Ressarcimentos', '02', '20', '41', 2019, '280000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(58, '19220000000000', 'Restituições', '02', '20', '41', 2019, '280000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(59, '19229900000000', 'Outras Restituições', '02', '20', '41', 2019, '280000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(60, '19229901000000', 'Outras Restituições-Principal', '02', '20', '41', 2019, '280000.00', 'N', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(61, '19900000000000', 'Demais Receitas Correntes', '02', '20', '41', 2019, '205000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(62, '19901100000000', 'Aportes Periódicos para Amortização do Déficit', '02', '20', '41', 2019, '200000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(63, '19900110100000', 'Aportes Periódicos para Amortização do Déficit', '02', '20', '41', 2019, '200000.00', 'N', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(64, '19909000000000', 'Demais Receitas Correntes', '02', '20', '0', 2019, '5000.00', 'N', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(65, '70000000000000', 'Receitas Correntes Intra-Orçamentárias', '02', '20', '41', 2019, '530000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(66, '72000000000000', 'Contribuições', '02', '20', '41', 2019, '530000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(67, '72100000000000', 'Contribuições Sociais', '02', '20', '41', 2019, '530000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(68, '72180300000000', 'CPSSS Patronal Servidor Civil Específico Est/Mun.', '02', '20', '41', 2019, '530000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(69, '72180310000000', 'CPSSS patronal Servidor  Civil Ativo', '02', '20', '41', 2019, '530000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(70, '72180310100000', 'Executivo', '02', '20', '41', 2019, '445500.00', 'N', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(71, '72180310100000', 'Poder Legislativo', '02', '20', '41', 2019, '4500.00', 'N', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(72, '72180320000000', 'CPSSS do Servidor iNATIVO ', '02', '20', '41', 2019, '40000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(73, '72180320200000', 'Poder Executivo', '02', '20', '41', 2019, '39600.00', 'N', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(74, '72180320200000', 'Poder Legislativo', '02', '20', '41', 2019, '400.00', 'N', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(75, '72180330000000', 'CPSSS do Servidor Civil Pensionista ', '02', '20', '41', 2019, '40000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(76, '72180330300000', 'Poder Executivo', '02', '20', '41', 2019, '39600.00', 'N', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(77, '72180330300000', 'Poder Legislativo', '02', '20', '41', 2019, '400.00', 'N', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(78, '90000000000000', 'Deduções da Receita Correntes', '02', '20', '0', 2019, '0.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(79, '91000000000000', 'Demais Receitas Correntes', '02', '20', '0', 2019, '0.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(80, '91300000000000', 'Dedução da Receita Patrimonial', '02', '20', '0', 2019, '0.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(81, '91302000000000', 'Dedução da Receita de Valores Imobiliários', '02', '20', '0', 2019, '0.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(82, '19302040000000', 'Dedução da Receita de Previd. Social-RPPS-Principal Remuneração de Recursos ', '02', '20', '0', 2019, '0.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(83, '913240410000', '(-)Remuneração dos Recursos do Regime Próprio de Previd.Social-RPPS-Principal', '02', '20', '0', 2019, '0.00', 'N', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(84, '10000000000000', 'Receitas Correntes', '02', '20', '41', 2020, '1400000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(85, '12000000000000', 'Contribuições', '02', '20', '41', 2020, '665000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(86, '12100000000000', 'Contribuições Sociais', '02', '20', '0', 2019, '0.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(87, '12180000000000', 'Contribuições Especiais Específicas do Estado, DF e Munícipios ', '02', '20', '0', 2020, '0.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(88, '12180100000000', 'Contribuição do servidor civil para o plano de seguridade social - CPS', '02', '20', '41', 2020, '0.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(89, '12180110000000', 'CPSSS do servidor civil ativo', '02', '20', '41', 2020, '0.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(90, '12180111000000', 'CPSSS do servidor civil ativo - Principal', '02', '20', '41', 2020, '620000.00', 'N', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(91, '12180112000000', 'CPSSS do servidor civil ativo - Multas e Juros', '02', '20', '41', 2020, '5000.00', 'N', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(92, '12180120000000', 'CPSSS do servidor civil Inativo', '02', '20', '41', 2020, '0.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(93, '12180121000000', 'CPSSS do servidor civil inativo - Principal', '02', '20', '41', 2020, '10000.00', 'N', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(94, '12180122000000', 'CPSSS do servidor civil inativo - Multas e Juros', '02', '20', '41', 2020, '10000.00', 'N', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(95, '12180130000000', 'CPSSS do servidor civil - Pensionista', '02', '20', '41', 2020, '0.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(96, '12180131000000', 'CPSSS do servidor civil - Pensionista - Principal', '02', '20', '41', 2020, '10000.00', 'N', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(97, '12180132000000', 'CPSSS do servidor civil - Pensionista - Multas e Juros', '02', '20', '41', 2020, '10000.00', 'N', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(98, '13000000000000', 'Receita Patrimonial', '02', '20', '41', 2020, '0.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(99, '13200000000000', 'Valores Mobiliários', '02', '20', '41', 2020, '0.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(100, '13210000000000', 'Juros e Correções Monetárias', '02', '20', '41', 2020, '0.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(101, '13100400000000', 'Remuneração dos recursos do regime próprio de previdência social ', '02', '20', '41', 2020, '0.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(102, '13210041000000', 'Remuneração dos recurso do regime próprio de previdência social', '02', '20', '41', 2020, '625000.00', 'N', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(103, '13200000000000', 'Outros Valores Mobiliarios', '02', '20', '41', 2020, '0.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(104, '13290010000000', 'Outros Valores Mobilirarios', '02', '20', '41', 2020, '0.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(105, '13290011000000', 'Outros Valores Mobiliários - Principal', '02', '20', '41', 2020, '30000.00', 'N', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(106, '13900000000000', 'Demais receitas patrimoniais', '02', '20', '41', 2020, '0.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(107, '13900010000000', 'Demais receitas patrimoniais', '02', '20', '41', 2020, '0.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(108, '13900011000000', 'Demais receitas patrimoniais - Principal', '02', '20', '41', 2020, '5000.00', 'N', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(109, '19000000000000', 'Outras receitas correntes', '02', '20', '41', 2020, '0.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(110, '19100000000000', 'Multas Administrativas, contratuais e judiciais', '02', '20', '41', 2020, '0.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(111, '19100100000000', 'Multas previstas em legislação  especifica', '02', '20', '41', 2020, '0.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(112, '19100100000000', 'Multas previstas em legislação  especifica', '02', '20', '41', 2020, '0.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(113, '19100100000000', 'Multas previstas em legislação  especifica', '02', '20', '41', 2020, '0.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(114, '19100110000000', 'Multas previstas em legislação especifica ', '02', '20', '41', 2020, '0.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(115, '19100111000000', 'Multas previstas em legislação especifica - Principal', '02', '20', '41', 2020, '20000.00', 'N', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(116, '19100112000000', 'Multas previstas em legislação especifica - Multas e Juros', '02', '20', '41', 2020, '0.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(117, '19200000000000', 'Indenizações, Restituições e Ressarcimentos ', '02', '20', '41', 2020, '0.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(118, '19210000000000', 'Indenizações', '02', '20', '41', 2020, '0.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(119, '19219900000000', 'Outras Indenizações', '02', '20', '41', 2020, '0.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(120, '19219910000000', 'Outras Indenizações', '02', '20', '41', 2020, '0.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(121, '19219911000000', 'Outras Indenizações - Principal', '02', '20', '41', 2020, '30000.00', 'N', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(122, '19220000000000', 'Restituições', '02', '20', '41', 2020, '0.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(123, '19220300000000', 'Restituição de benefícios previdenciários ', '02', '20', '41', 2020, '0.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(124, '19220310000000', 'Restituição de benefícios previdenciários', '02', '20', '41', 2020, '0.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(125, '19220311000000', 'Restituição de benefícios previdenciários - Principal', '02', '20', '41', 2020, '5000.00', 'N', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(126, '19229900000000', 'Outras Restituições', '02', '20', '41', 2020, '0.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(127, '19229910000000', 'Outras Restituições', '02', '20', '41', 2020, '0.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(128, '19229911000000', 'Outras Restituições - Principal', '02', '20', '41', 2020, '0.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(129, '19900000000000', 'Demais Receitas Correntes', '02', '20', '41', 2020, '0.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(130, '19900100000000', 'Aportes periódicos para amortização de deficit atuarial do RPPS', '02', '20', '41', 2020, '0.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(131, '19900110000000', 'Aportes periódicos para amortização de deficit atuarial do RPPS', '02', '20', '41', 2020, '0.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(132, '19900111000000', 'Aportes periódicos para amortização de deficit atuarial do RPPS - Principal', '02', '20', '41', 2020, '0.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(133, '19900300000000', 'Compensações financeiras entre regime geral e os regimes próprios ', '02', '20', '41', 2020, '0.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(134, '19900310000000', 'Compensações financeiras entre regime geral e regimes próprios', '02', '20', '41', 2020, '0.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(135, '19900311000000', 'Compensações financeiras entre regime geral e regimes próprios', '02', '20', '41', 2020, '50000.00', 'N', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(136, '19900990000000', 'Outras Receitas', '02', '20', '41', 2020, '0.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(137, '19909910000000', 'Outras Receitas - Primárias', '02', '20', '41', 2020, '0.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(138, '19909911000000', 'Outras Receitas - Primarias - Principal', '02', '20', '41', 2020, '20000.00', 'N', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(139, '70000000000000', 'Receitas Correntes', '02', '20', '41', 2020, '0.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(140, '72000000000000', 'Contribuições', '02', '20', '41', 2020, '0.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(141, '72100000000000', 'Contribuições Sociais', '02', '20', '41', 2020, '0.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(142, '72180000000000', 'Contribuições sociais especificas de Estado, DF e Munucipios', '02', '20', '41', 2020, '0.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(143, '72180300000000', 'CPSSS Patrimonial - Servidor Civil - Especifico de Est/DF/Mun', '02', '20', '41', 2020, '0.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(144, '72180310000000', 'CPSSS Patronal - Servidor civil ativo', '02', '20', '41', 2020, '0.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(145, '72180311000000', 'CPSSS Patronal - Servidor Civil Ativo - Principal', '02', '20', '41', 2020, '620000.00', 'N', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(146, '72180312000000', 'CPSSS Patronal - Servidor Civil Ativo - Multas e Juros', '02', '20', '41', 2020, '10000.00', 'N', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(147, '72180320000000', 'CPSS Patronal - Servidor Civil Inativo', '02', '20', '41', 2020, '0.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(148, '72180321000000', 'CPSSS Patronal - Servidor Civil Inativo - Principal', '02', '20', '41', 2020, '5000.00', 'N', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(149, '72180322000000', 'CPSSS Patronal - Servidor civil Inativo - Multas E Juros', '02', '20', '41', 2020, '5000.00', 'N', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(150, '72180330000000', 'CPSSS Patronal - Servidor Civil - Pensionistas', '02', '20', '41', 2020, '0.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(151, '72180331000000', 'CPSSS Patronal - Servidor Civil - Pensionista - Principal', '02', '20', '41', 2020, '5000.00', 'N', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(152, '72180332000000', 'CPSSS Patronal - Servidor Civil - Pensionistas - Multas e Juros', '02', '20', '41', 2020, '5000.00', 'N', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(153, '79000000000000', 'Outras Receitas Correntes', '02', '20', '41', 2020, '0.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(154, '79900000000000', 'Demais Receitas Correntes', '02', '20', '41', 2020, '0.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(155, '79900100000000', 'Aportes Periodicos para amortização de defict atuarial do RPPS', '02', '20', '41', 2020, '0.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(156, '79900110000000', 'Aportes Periodicos para amortização de defict atuarial do RPPS', '02', '20', '41', 2020, '0.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(157, '79900111000000', 'Aportes Periodicos para amortização de defict atuarial do RPPS - Principal', '02', '20', '41', 2020, '100000.00', 'N', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(158, '10000000000000', 'Receitas Correntes', '02', '20', '100000', 2021, '1600000.00', 'S', '1', '1', '1', 0, '131299.09', '1430496.10', '169503.90', '1299197.01'),
(159, '12100000000000', 'Contribuições', '02', '20', '100000', 2021, '715000.00', 'S', '1', '1', '1', 0, '83840.94', '951419.16', '-236419.16', '867578.22'),
(160, '12180000000000', 'Contribuições Sociais Especificas de Estado, DF e Municipios', '02', '20', '100000', 2021, '715000.00', 'S', '1', '1', '1', 0, '83840.94', '951419.16', '-236419.16', '867578.22'),
(161, '12180100000000', 'Contribuição do Servidor Civil para o Plano de seguridade Social - CPSS', '02', '20', '100000', 2021, '715000.00', 'S', '1', '1', '1', 0, '83840.94', '951419.16', '-236419.16', '867578.22'),
(162, '12180110000000', 'CPSSS do Servidor Civil Ativo', '02', '20', '100000', 2021, '675000.00', 'S', '1', '1', '1', 0, '83840.94', '951419.16', '-276419.16', '867578.22'),
(163, '12180111000000', 'CPSSS do Servidor Civil Ativo - Principal', '02', '20', '100000', 2021, '670000.00', 'N', '1', '1', '1', 0, '83840.94', '951419.16', '-281419.16', '0.00'),
(164, '12180112000000', 'CPSSS do Servidor Civil Ativo - Multa e Juros de Mora', '02', '20', '100000', 2021, '5000.00', 'N', '1', '1', '1', 0, '0.00', '0.00', '5000.00', '0.00'),
(165, '12180120000000', 'CPSSS do Servidor Civil Inativo', '02', '20', '100000', 2021, '20000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '20000.00', '0.00'),
(166, '12180121000000', 'CPSSS do Servidor Civil Inativo - Principal', '02', '20', '100000', 2021, '10000.00', 'N', '1', '1', '1', 0, '0.00', '0.00', '10000.00', '0.00'),
(167, '12180122000000', 'CPSSS do Servidor Civil Inativo - Multas e Juros de Mora', '02', '20', '100000', 2021, '10000.00', 'N', '1', '1', '1', 0, '0.00', '0.00', '10000.00', '0.00'),
(168, '12180130000000', 'CPSSS do Servidor Civil - Pensionistas', '02', '20', '100000', 2021, '20000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '20000.00', '0.00'),
(169, '12180131000000', 'CPSSS do Servidor Civil - Pensionistas - Principal', '02', '20', '100000', 2021, '10000.00', 'N', '1', '1', '1', 0, '0.00', '0.00', '10000.00', '0.00'),
(170, '12180132000000', 'CPSSS do Servidor Civil - Pensionistas - Multas e Juros de Mora', '02', '20', '100000', 2021, '10000.00', 'N', '1', '1', '1', 0, '0.00', '0.00', '10000.00', '0.00'),
(171, '13000000000000', 'Receita Patrimonial', '02', '20', '100000', 2021, '750000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '750000.00', '0.00'),
(172, '13200000000000', 'Valores Mobiliários ', '02', '20', '100000', 2021, '745000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '745000.00', '0.00'),
(173, '13210000000000', 'Juros e Correções Monetarias', '02', '20', '100000', 2021, '715000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '715000.00', '0.00'),
(174, '13210040000000', 'Remuneração dos Recursos do Regime Próprio de Previdência Social', '02', '20', '100000', 2021, '715000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '715000.00', '0.00'),
(175, '13210041000000', 'Remuneração dos Recursos do Regime Próprio de Previdência Social', '02', '20', '100000', 2021, '715000.00', 'N', '1', '1', '1', 0, '0.00', '0.00', '715000.00', '0.00'),
(176, '13290000000000', 'Outros Valores Mobiliários ', '02', '20', '100000', 2021, '30000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '30000.00', '0.00'),
(177, '13290010000000', 'Outros Valores Mobiliários', '02', '20', '100000', 2021, '30000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '30000.00', '0.00'),
(178, '13290011000000', 'Outros Valores Mobiliários - Principal', '02', '20', '100000', 2021, '30000.00', 'N', '1', '1', '1', 0, '0.00', '0.00', '30000.00', '0.00'),
(179, '13900000000000', 'Demais Receitas Patrimoniais', '02', '20', '100000', 2021, '5000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '5000.00', '0.00'),
(180, '13900010000000', 'Demais Receitas Patrimoniais', '02', '20', '100000', 2021, '5000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '5000.00', '0.00'),
(181, '13900011000000', 'Demais Receitas Patrimoniais - Principal', '02', '20', '100000', 2021, '5000.00', 'N', '1', '1', '1', 0, '0.00', '0.00', '5000.00', '0.00'),
(182, '19000000000000', 'Outras Receitas Correntes', '02', '20', '100000', 2021, '135000.00', 'S', '1', '1', '1', 0, '47458.15', '479076.94', '-344076.94', '431618.79'),
(183, '19100000000000', 'Multas Administrativas, Contratuais e Judiciais', '02', '20', '100000', 2021, '20000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '20000.00', '0.00'),
(184, '19100100000000', 'Multas Previstas em Legislação Específica', '02', '20', '100000', 2021, '20000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '20000.00', '0.00'),
(185, '19100110000000', 'Multas Previstas em Legislação Específica', '02', '20', '100000', 2021, '20000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '20000.00', '0.00'),
(186, '19100111000000', 'Multas Previstas em Legislação Específica - Principal', '02', '20', '100000', 2021, '20000.00', 'N', '1', '1', '1', 0, '0.00', '0.00', '20000.00', '0.00'),
(187, '19100112000000', 'Multas Previstas em Legislação Específica - Multas e Juros de Mora', '02', '20', '100000', 2021, '0.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(188, '19200000000000', 'Indenizações, Restituições e Ressarcimentos', '02', '20', '100000', 2021, '35000.00', 'S', '1', '1', '1', 0, '0.00', '136623.45', '-101623.45', '136623.45'),
(189, '19210000000000', 'Indenizações', '02', '20', '100000', 2021, '30000.00', 'S', '1', '1', '1', 0, '0.00', '136623.45', '-106623.45', '136623.45'),
(190, '19219900000000', 'Outras Indenizações', '02', '20', '100000', 2021, '30000.00', 'S', '1', '1', '1', 0, '0.00', '136623.45', '-106623.45', '136623.45'),
(191, '19219910000000', 'Outras Indenizações', '02', '20', '100000', 2021, '30000.00', 'S', '1', '1', '1', 0, '0.00', '136623.45', '-106623.45', '136623.45'),
(192, '19219911000000', 'Outras Indenizações - Principal', '02', '20', '100000', 2021, '30000.00', 'N', '1', '1', '1', 0, '0.00', '136623.45', '-106623.45', '0.00'),
(193, '19220000000000', 'Restituições', '02', '20', '100000', 2021, '5000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '5000.00', '0.00'),
(194, '19220300000000', 'Restituições de Benefícios Previdenciários', '02', '20', '100000', 2021, '5000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '5000.00', '0.00'),
(195, '19220310000000', 'Restituições de Benefícios Previdenciários', '02', '20', '100000', 2021, '5000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '5000.00', '0.00'),
(196, '19220311000000', 'Restituições de Benefícios Previdenciários - Principal', '02', '20', '100000', 2021, '5000.00', 'N', '1', '1', '1', 0, '0.00', '0.00', '5000.00', '0.00'),
(197, '19229900000000', 'Outras Restituições', '02', '20', '100000', 2021, '0.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(198, '19229910000000', 'Outras Restituições', '02', '20', '100000', 2021, '0.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(199, '19229911000000', 'Outras Restituições - Principal', '02', '20', '100000', 2021, '0.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(200, '19900000000000', 'Demais Receitas Correntes', '02', '20', '100000', 2021, '80000.00', 'S', '1', '1', '1', 0, '47458.15', '342453.49', '-262453.49', '294995.34'),
(201, '19900100000000', 'Aportes Periódicos para Amortização de Deficit Atuarial do RPPS', '02', '20', '100000', 2021, '0.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(202, '19900110000000', 'Aportes Periódicos para Amortização de Deficit Atuarial do RPPS', '02', '20', '100000', 2021, '0.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(203, '19900111000000', 'Aportes Periódicos para Amortização de Deficit Atuarial do RPPS - Principal', '02', '20', '100000', 2021, '0.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(204, '19900300000000', 'Compensações Financeiras entre o Regime Geral e os Regimes Próprios ', '02', '20', '100000', 2021, '20000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '20000.00', '0.00'),
(205, '19900310000000', 'Compensações Financeiras entre o Regime Geral e os Regimes Próprios', '02', '20', '100000', 2021, '20000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '20000.00', '0.00'),
(206, '19900311000000', 'Compensações Financeiras entre o Regime Geral e os Regimes Próprios - Princip', '02', '20', '100000', 2021, '20000.00', 'N', '1', '1', '1', 0, '0.00', '0.00', '20000.00', '0.00'),
(207, '19909900000000', 'Outras Receitas', '02', '20', '100000', 2021, '60000.00', 'S', '1', '1', '1', 0, '47458.15', '342453.49', '-282453.49', '294995.34'),
(208, '19909910000000', 'Outras Receitas - Primárias', '02', '20', '100000', 2021, '60000.00', 'S', '1', '1', '1', 0, '47458.15', '342453.49', '-282453.49', '294995.34'),
(209, '19909911000000', 'Receitas de Parcelamento - Outras Receitas - Primárias - Principal', '02', '20', '100000', 2021, '60000.00', 'N', '1', '1', '1', 0, '47458.15', '342453.49', '-282453.49', '0.00'),
(210, '70000000000000', 'Receitas Correntes - Intra OFSS', '02', '20', '100000', 2021, '800000.00', 'S', '1', '1', '1', 0, '87994.73', '1184846.10', '-384846.10', '1096851.37'),
(211, '72000000000000', 'Contribuições', '02', '20', '100000', 2021, '700000.00', 'S', '1', '1', '1', 0, '87994.73', '999541.70', '-299541.70', '911546.97'),
(212, '72100000000000', 'Contribuições Sociais', '02', '20', '100000', 2021, '700000.00', 'S', '1', '1', '1', 0, '87994.73', '999541.70', '-299541.70', '911546.97'),
(213, '72180000000000', 'Contribuições Sociais Especificas de Estados, DF e Municipios', '02', '20', '100000', 2021, '700000.00', 'S', '1', '1', '1', 0, '87994.73', '999541.70', '-299541.70', '911546.97'),
(214, '72180300000000', 'CPSSS Patronal - Servidor Civil - Especifico de EST/DF/MUN', '02', '20', '100000', 2021, '700000.00', 'S', '1', '1', '1', 0, '87994.73', '999541.70', '-299541.70', '911546.97'),
(215, '72180310000000', 'CPSSS Patronal - Servidor Civil Ativo', '02', '20', '100000', 2021, '680000.00', 'S', '1', '1', '1', 0, '87994.73', '999541.70', '-319541.70', '911546.97'),
(216, '72180311000000', 'CPSSS Patronal - Servidor Civil - Principal', '02', '20', '100000', 2021, '670000.00', 'N', '1', '1', '1', 0, '87994.73', '999541.70', '-329541.70', '0.00'),
(217, '72180312000000', 'CPSSS Patronal - Servidor Civil - Multas e Juros de Mora', '02', '20', '100000', 2021, '10000.00', 'N', '1', '1', '1', 0, '0.00', '0.00', '10000.00', '0.00'),
(218, '72180320000000', 'CPSSS Patronal - Servidor Civil Inativo', '02', '20', '100000', 2021, '10000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '10000.00', '0.00'),
(219, '72180321000000', 'CPSSS Patronal - Servidor Civil Inativo - Principal', '02', '20', '100000', 2021, '5000.00', 'N', '1', '1', '1', 0, '0.00', '0.00', '5000.00', '0.00'),
(220, '72180322000000', 'CPSSS Patronal - Servidor Civil Inativo - Multas e Juros de Mora', '02', '20', '100000', 2021, '5000.00', 'N', '1', '1', '1', 0, '0.00', '0.00', '5000.00', '0.00'),
(221, '79000000000000', 'Outras Receitas Correntes', '02', '20', '100000', 2021, '100000.00', 'S', '1', '1', '1', 0, '0.00', '185304.40', '-85304.40', '185304.40'),
(222, '79900000000000', 'Demais Receitas Correntes', '02', '20', '100000', 2021, '100000.00', 'S', '1', '1', '1', 0, '0.00', '185304.40', '-85304.40', '185304.40'),
(223, '79900100000000', 'Aportes Periódicos para Amortização de Deficit Atuarial do RPPS', '02', '20', '100000', 2021, '100000.00', 'S', '1', '1', '1', 0, '0.00', '185304.40', '-85304.40', '185304.40'),
(224, '79900110000000', 'Aportes Periódicos para Amortização de Deficit Atuarial do RPPS', '02', '20', '100000', 2021, '100000.00', 'S', '1', '1', '1', 0, '0.00', '185304.40', '-85304.40', '185304.40'),
(225, '79900111000000', 'Aportes Periódicos para Amortização de Deficit Atuarial do RPPS - Principal', '02', '20', '100000', 2021, '100000.00', 'N', '1', '1', '1', 0, '0.00', '185304.40', '-85304.40', '0.00'),
(226, '12100000000000', 'Contribuições Sociais', '02', '20', '100000', 2021, '715000.00', 'S', '1', '1', '1', 0, '83840.94', '951419.16', '-236419.16', '867578.22'),
(227, '72180330000000', 'CPSSS Patronal - Servidor Civil - Pensionista', '02', '20', '100000', 2021, '10000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '10000.00', '0.00'),
(228, '72180331000000', 'CPSSS Patronal - Servidor Civil - Pensionistas - Principal', '02', '20', '100000', 2021, '5000.00', 'N', '1', '1', '1', 0, '0.00', '0.00', '5000.00', '0.00'),
(229, '72180332000000', 'CPSSS Patronal - Servidor Civil - Pensionistas - Multas e Juros de Mora', '02', '20', '100000', 2021, '5000.00', 'N', '1', '1', '1', 0, '0.00', '0.00', '5000.00', '0.00'),
(230, '10000000000000', 'Receitas Correntes', '07', '20', '100000', 2022, '1507000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '1507000.00', '0.00'),
(231, '12000000000000', 'Contribuições', '07', '20', '100000', 2022, '727000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '727000.00', '0.00'),
(232, '12100000000000', 'Contribuições Sociais', '07', '20', '100000', 2022, '727000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '727000.00', '0.00'),
(233, '12150000000000', 'Contribuições para Regimes Próprios de Previdência e Sistema de Proteção S', '07', '20', '100000', 2022, '727000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '727000.00', '0.00'),
(234, '12150200000000', 'Contribuição Patronal - Servidor Civil-CM', '07', '20', '100000', 2022, '682000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '682000.00', '0.00'),
(235, '12150210000000', 'Contribuição Patronal - Servidor Civil Ativo', '07', '20', '100000', 2022, '682000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '682000.00', '0.00'),
(236, '12150211000000', 'Contribuição Patronal - Servidor Civil Ativo - Principal', '07', '20', '100000', 2022, '672000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '672000.00', '0.00'),
(237, '12150211010000', 'Principal', '07', '20', '103000', 2022, '670000.00', 'N', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(238, '12150211020000', 'Taxa Administração', '07', '20', '143000', 2022, '2000.00', 'N', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(239, '12150212000000', 'Contribuição Patronal - Servidor Civil Ativo - Multas e Juros de Mora', '07', '20', '100000', 2022, '10000.00', 'N', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(240, '12150213000000', 'Contribuição Patronal - Servidor Civil Ativo - Dívida Ativa', '07', '20', '103000', 2022, '0.00', 'N', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(241, '12150214000000', 'Contribuição Patronal - Servidor Civil Ativo - Dívida Ativa - Multas e Juros ', '07', '20', '103000', 2022, '0.00', 'N', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(242, '12155000000000', 'Contribuição Patronal - Servidor Civil Inativo e Pensionistas', '07', '20', '100000', 2022, '45000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '45000.00', '0.00'),
(243, '12155010000000', 'Contribuição Patronal - Servidor Civil - Inativo', '07', '20', '100000', 2022, '30000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '30000.00', '0.00'),
(244, '12155011000000', 'Contribuição Patronal - Servidor Civil - Inativo - Principal', '07', '20', '103000', 2022, '20000.00', 'N', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(245, '12155012000000', 'Contribuição Patronal - Servidor Civil - Inativo - Multas e Juros de Mora', '07', '20', '103000', 2022, '10000.00', 'N', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(246, '12155020000000', 'Contribuição Patronal - Servidor Civil - Pensionistas', '07', '20', '100000', 2022, '15000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '15000.00', '0.00'),
(247, '12155021000000', 'Contribuição Patronal - Servidor Civil - Pensionistas - Principal', '07', '20', '103000', 2022, '10000.00', 'N', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(248, '12155022000000', 'Contribuição Patronal - Servidor Civil - Pensionistas - Multas e Juros de Mora', '07', '20', '103000', 2022, '5000.00', 'N', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(249, '12155100000000', 'Contribuição Patronal - Parcelamentos', '07', '20', '100000', 2022, '0.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(250, '12155110000000', 'Contribuição Patronal - Servidor Civil Ativo - Parcelamentos', '07', '20', '100000', 2022, '0.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(251, '12155111000000', 'Contribuição Patronal - Servidor Civil Ativo - Parcelamentos - Principal', '07', '20', '100000', 2022, '0.00', 'N', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(253, '12155112000000', 'Contribuição Patronal - Servidor Civil Ativo - Parcelamentos - Multas e Juros ', '07', '20', '100000', 2022, '0.00', 'N', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(254, '13000000000000', 'Receita Patrimonial', '07', '20', '100000', 2022, '715000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '715000.00', '0.00'),
(255, '13200000000000', 'Valores Mobiliários', '07', '20', '100000', 2022, '715000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '715000.00', '0.00'),
(256, '13210000000000', 'uros e Correções Monetárias', '07', '20', '100000', 2022, '700000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '700000.00', '0.00'),
(257, '13210400000000', 'Remuneração dos Recursos do Regime Próprio de Previdência Social - RPPS', '07', '20', '100000', 2022, '700000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '700000.00', '0.00'),
(258, '13210401000000', 'Remuneração dos Recursos do Regime Próprio de Previdência Social - RPPS - Pr', '07', '20', '103000', 2022, '700000.00', 'N', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(259, '13290000000000', 'Outros Valores Mobiliários', '07', '20', '100000', 2022, '15000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '15000.00', '0.00'),
(260, '13299900000000', 'Outros Valores Mobiliários', '07', '20', '100000', 2022, '15000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '15000.00', '0.00'),
(261, '13299901000000', 'Outros Valores Mobiliários - Principal', '07', '20', '103000', 2022, '15000.00', 'N', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(262, '19000000000000', 'Outras Receitas Correntes', '07', '20', '100000', 2022, '65000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '65000.00', '0.00'),
(263, '19100000000000', 'Multas Administrativas, Contratuais e Judiciais', '07', '20', '100000', 2022, '10000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '10000.00', '0.00'),
(264, '19111000000000', 'Multas Previstas na Legislação sobre Regime de Previdência Privada Complement', '07', '20', '100000', 2022, '10000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '10000.00', '0.00'),
(265, '19111001000000', 'Multas Previstas na Legislação sobre Regime de Previdência Privada Complement', '07', '20', '103000', 2022, '10000.00', 'N', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(266, '19200000000000', 'Indenizações, Restituições e Ressarcimentos', '07', '19', '100000', 2022, '15000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '15000.00', '0.00'),
(267, '19220000000000', 'Restituições', '07', '20', '100000', 2022, '15000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '15000.00', '0.00'),
(268, '19220500000000', 'Restituição de Contribuições Previdenciárias Complementares', '07', '20', '100000', 2022, '15000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '15000.00', '0.00'),
(269, '19220501000000', 'Restituição de Contribuições Previdenciárias Complementares - Principal', '07', '20', '103000', 2022, '15000.00', 'N', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(270, '19900000000000', 'Demais Receitas Correntes', '07', '20', '100000', 2022, '40000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '40000.00', '0.00'),
(271, '19990100000000', 'Aportes Periódicos para Amortização de Déficit Atuarial do Regimes Próprios', '07', '20', '100000', 2022, '0.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(272, '19990101000000', 'Aportes Periódicos para Amortização de Déficit Atuarial do Regimes Próprios', '07', '19', '103000', 2022, '0.00', 'N', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(273, '19990300000000', 'Compensações Financeiras Entre o Regime Geral e os Regimes Próprios de Previd', '07', '20', '100000', 2022, '40000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '40000.00', '0.00'),
(274, '19990301000000', 'Compensações Financeiras Entre o Regime Geral e os Regimes Próprios de Previd', '07', '20', '103000', 2022, '40000.00', 'N', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(275, '70000000000000', 'Receitas Correntes - Intra OFSS', '07', '20', '100000', 2022, '1273000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '1273000.00', '0.00'),
(276, '72000000000000', 'Contribuições - Intra OFSS', '07', '20', '100000', 2022, '1213000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '1213000.00', '0.00'),
(277, '72100000000000', 'Contribuições Sociais - Intra OFSS', '07', '20', '100000', 2022, '1213000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '1213000.00', '0.00'),
(278, '72150000000000', 'Contribuições para Regimes Próprios de Previdência e Sistema de Proteção S', '07', '20', '100000', 2022, '1203000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '1203000.00', '0.00'),
(279, '72150200000000', 'Contribuição Patronal - Servidor Civil - Intra OFSS', '07', '20', '100000', 2022, '1072000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '1072000.00', '0.00'),
(280, '72150210000000', 'Contribuição Patronal - Servidor Civil Ativo - Intra OFSS', '07', '20', '100000', 2022, '1071000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '1071000.00', '0.00'),
(281, '72150211000000', 'Contribuição Patronal - Servidor Civil Ativo - Principal - Intra OFSS', '07', '20', '100000', 2022, '1020000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '1020000.00', '0.00'),
(282, '72150211010000', 'Principal', '07', '20', '103000', 2022, '212000.00', 'N', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(283, '72150211020000', 'Taxa Administração', '07', '20', '143000', 2022, '808000.00', 'N', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(284, '72102120000000', 'Contribuição Patronal - Servidor Civil Ativo - Multas e Juros de Mora - Intra ', '07', '20', '103000', 2022, '10000.00', 'N', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(285, '72150213000000', 'Contribuição Patronal - Servidor Civil Ativo - Dívida Ativa - Intra OFSS', '07', '20', '103000', 2022, '50000.00', 'N', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(286, '72150214000000', 'Contribuição Patronal - Servidor Civil Ativo - Dívida Ativa - Multas e Juros ', '07', '20', '103000', 2022, '1000.00', 'N', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(287, '72155000000000', 'Contribuição Patronal - Servidor Civil Inativo e Pensionistas - Intra OFSS', '07', '20', '100000', 2022, '131000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '131000.00', '0.00'),
(288, '72155010000000', 'Contribuição Patronal - Servidor Civil - Inativo - Intra OFSS', '07', '20', '100000', 2022, '11000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '11000.00', '0.00'),
(289, '72155011000000', 'Contribuição Patronal - Servidor Civil - Inativo - Principal - Intra OFSS', '07', '20', '103000', 2022, '10000.00', 'N', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(290, '72155012000000', 'Contribuição Patronal - Servidor Civil - Inativo - Multas e Juros de Mora - In', '07', '20', '103000', 2022, '1000.00', 'N', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(291, '72155020000000', 'Contribuição Patronal - Servidor Civil - Pensionistas - Intra OFSS', '07', '20', '100000', 2022, '10000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '10000.00', '0.00'),
(292, '72155021000000', 'Contribuição Patronal - Servidor Civil - Pensionistas - Principal - Intra OFSS', '07', '20', '103000', 2022, '10000.00', 'N', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(293, '72150220000000', 'Contribuição Patronal - Servidor Civil - Pensionistas - Multas e Juros de Mora', '07', '20', '103000', 2022, '1000.00', 'N', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(294, '72155100000000', 'Contribuição Patronal - Parcelamentos - Intra OFSS', '07', '20', '100000', 2022, '110000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '110000.00', '0.00'),
(295, '72155110000000', 'Contribuição Patronal - Servidor Civil Ativo - Parcelamentos - Intra OFSS', '07', '20', '100000', 2022, '110000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '110000.00', '0.00'),
(296, '72155111000000', 'Contribuição Patronal - Servidor Civil Ativo - Parcelamentos - Principal - Int', '07', '20', '103000', 2022, '100000.00', 'N', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(297, '72155112000000', 'Contribuição Patronal - Servidor Civil Ativo - Parcelamentos - Multas e Juros ', '07', '20', '103000', 2022, '10000.00', 'N', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(298, '79000000000000', 'Outras Receitas Correntes - Intra OFSS', '07', '20', '100000', 2022, '60000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '60000.00', '0.00'),
(299, '79900000000000', 'Demais Receitas Correntes - Intra OFSS', '07', '20', '100000', 2022, '60000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '60000.00', '0.00'),
(300, '79990100000000', 'Aportes Periódicos para Amortização de Déficit Atuarial do Regimes Próprios', '07', '20', '100000', 2022, '60000.00', 'S', '1', '1', '1', 0, '0.00', '0.00', '60000.00', '0.00'),
(301, '79990101000000', 'Aportes Periódicos para Amortização de Déficit Atuarial do Regimes Próprios', '07', '20', '103000', 2022, '60000.00', 'N', '1', '1', '1', 0, '0.00', '0.00', '0.00', '0.00'),
(302, '12000000000000', 'Contribuições', '02', '20', '100000', 2021, '715000.00', 'S', '1', '1', '1', 0, '83840.94', '951419.16', '-236419.16', '867578.22');

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

--
-- Estrutura da tabela `prevrec`
--

CREATE TABLE IF NOT EXISTS `prevrec` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pr_idpl` int(11) NOT NULL,
  `pr_data` date NOT NULL,
  `pr_unid` varchar(2) NOT NULL,
  `pr_exer` varchar(4) NOT NULL,
  `pr_periodo` varchar(6) CHARACTER SET utf8 NOT NULL,
  `pr_debito` decimal(16,2) NOT NULL,
  `pr_credito` decimal(16,2) NOT NULL,
  `pr_histo` text NOT NULL,
  `pr_cdrec` varchar(14) NOT NULL,
  `pr_codigo` varchar(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;

--
-- Extraindo dados da tabela `prevrec`
--

INSERT INTO `prevrec` (`id`, `pr_idpl`, `pr_data`, `pr_unid`, `pr_exer`, `pr_periodo`, `pr_debito`, `pr_credito`, `pr_histo`, `pr_cdrec`, `pr_codigo`) VALUES
(1, 2, '2021-09-30', '20', '2021', '092021', '0.00', '77734.76', 'REFERENTE RECEITA DE SERVIDOR ATIVO CIVIL', '', '113620102'),
(2, 1, '2021-09-30', '20', '2021', '092021', '0.00', '77734.76', 'REFERENTE RECEITA PATRONAL', '', '113620101'),
(3, 1, '2021-10-31', '20', '2021', '102021', '0.00', '79146.42', 'Referente receita Patronal.', '', '113620101'),
(4, 2, '2021-10-31', '20', '2021', '102021', '0.00', '79146.42', 'Referente receita de Servidor Ativo Civil.', '', '113620102'),
(5, 1, '2021-11-30', '20', '2021', '112021', '0.00', '46110.28', 'RECEITA DE PARCELAMENTO DE DÉBITOS PREVIDENCIÃRIOS.', '', '113620101'),
(6, 1, '2021-11-30', '20', '2021', '112021', '0.00', '78541.09', 'RECEITA PATRONAL', '', '113620101'),
(7, 2, '2021-11-30', '20', '2021', '112021', '0.00', '77629.96', 'RECEITA DE SERVIDOR ATIVO CIVIL', '', '113620102'),
(8, 2, '2021-12-31', '20', '2021', '122021', '0.00', '87994.73', 'receita de servidor ativo', '', '113620102'),
(9, 1, '2021-12-31', '20', '2021', '122021', '0.00', '87994.73', 'receita patronal', '', '113620101'),
(10, 1, '2021-12-31', '20', '2021', '122021', '0.00', '47458.15', 'receita de parcelamento', '', '113620101'),
(11, 2, '2022-01-31', '20', '2022', '012022', '0.00', '1274.51', 'Receita da taxa de administração da parte patronal patronal', '', '113620102'),
(12, 2, '2022-01-31', '20', '2022', '012022', '0.00', '62451.15', 'referente receita patronal', '', '113620102'),
(13, 1, '2022-01-31', '20', '2022', '012022', '0.00', '1274.51', 'Receita da taxa de administração da parte descontada do servidor.', '', '113620101'),
(14, 1, '2022-01-31', '20', '2022', '012022', '0.00', '62451.15', 'referente receita de servidor ativo', '', '113620101');

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

--
-- Estrutura da tabela `programa`
--

CREATE TABLE IF NOT EXISTS `programa` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `codigo` varchar(4) NOT NULL,
  `descricao` varchar(50) NOT NULL,
  `metas` text NOT NULL,
  `tipo` int(1) NOT NULL,
  `exercicio` int(4) NOT NULL,
  `vlano1` float NOT NULL,
  `vlano2` float NOT NULL,
  `vlano3` float NOT NULL,
  `vlano4` float NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=52 ;

--
-- Extraindo dados da tabela `programa`
--

INSERT INTO `programa` (`id`, `codigo`, `descricao`, `metas`, `tipo`, `exercicio`, `vlano1`, `vlano2`, `vlano3`, `vlano4`) VALUES
(26, '0001', 'Legislando com a comunidade', 'Prover o Poder Legislativo com meios materiais, recursos humanos e tecnológicos para exercício de suas atividades legislativas e seu poder de fiscalização sobre a administração pública.                                        ', 1, 2018, 800000, 890000, 900000, 1000000),
(27, '0002', 'Administração com competencia', 'Racionalizar o uso de recursos humanos, materiais e financeiros do setor público, com o objetivo de melhorar a qualidade dos serviços prestados.                                        ', 1, 2018, 800000, 890000, 900000, 1000000),
(28, '0003', 'Gerenciamento Tributário', 'Modernizar e operacionalizar o sistema de cadastro e arrecadação municipal, procurando incrementar a receita própria.        ', 1, 2018, 800000, 890000, 900000, 1000000),
(29, '0004', 'Desenvolvimento do Ensino Fundadmental', 'Promover a universalização do atendimento nos  níveis de ensino, valorizando e integrando as unidades da REME e a comunidade para garantir a melhoria da qualidade de vida.            ', 1, 2018, 800000, 890000, 900000, 1000000),
(30, '0005', 'Gestão administrativa Financeira', 'Oferecer à população estudantil na faixa etária de 0 a 4 anos de idade, condições básicas de desenvolvimento.                                                                                ', 1, 2018, 800000, 890000, 900000, 1000000),
(31, '0006', 'Educação Cada Dia Melhor', 'Promover assistência alimentar ao educando, visando o seu desenvolvimento.                                          ', 1, 2018, 800000, 890000, 900000, 1000000),
(32, '0007', 'Esporte Cultura Cada Dia Melhor', 'Propiciar atendimento aos portadores de necessidades especiais.                   ', 1, 2018, 800000, 890000, 900000, 1000000),
(33, '0008', 'Vicentina Cidadã', 'Garantir o funcionamento das unidades de saúde, integrando-as à Rede Municipal de Saúde e melhorando a oferta de assistência com qualidade.   ', 1, 2018, 800000, 890000, 900000, 1000000),
(34, '0009', 'Vicentina Cada dia Melhor', 'Oferecer um sistema de controle eficiente e eficaz à população.                                          ', 1, 2018, 800000, 890000, 900000, 1000000),
(35, '0010', 'Gestão Ambiental', 'Promover ações preventivas à situações de risco social através de ressocialização, possibilitando a proteção da familia.              ', 1, 2018, 800000, 890000, 900000, 1000000),
(36, '0011', 'Saúde Cada Dia Melhor', 'Aumentar o nível de empregabilidade da população ativa através da valorização, qualificação, requalificação e humanização das relações de trabalho.         ', 1, 2018, 800000, 890000, 900000, 1000000),
(37, '0012', 'Vicentina Rurral', 'Diminuir o déficit habitacional do Município e melhorar as condições de habitabilidade da população.                                        ', 1, 2018, 800000, 890000, 900000, 1000000),
(38, '0013', 'Regime próprio de Regima Social', 'Reforçar as ações de fomento, na perspectiva do desenvolvimento sócio-econômico do Município, articulando e integrando iniciativas públicas e privadas.                                         ', 1, 2018, 800000, 890000, 900000, 1000000),
(39, '0014', 'Apoio as Manifestações Culturais', 'Preservar, incentivar e divulgar as manifestações culturais do Município.      ', 1, 2018, 800000, 890000, 900000, 1000000),
(40, '0016', 'Manutenção das Ações do Instituto de Previdencia', 'Desenvolver a infra-estrutura da cidade, melhorando a qualidade de vida e proporcionando segurança e conforto para a população.              ', 1, 2018, 800000, 890000, 900000, 1000000),
(41, '0017', 'Vicentina Rurral', 'Melhorar as condições sócio-esconômicas do produtor rural, com ações de fomento à produção e à produtividade do setor.         ', 1, 2018, 800000, 890000, 900000, 1000000),
(42, '0018', 'Preservação ambiental', 'Promover a conscientização e a capacitação da população na prevenção e na solução dos problemas ambientais.                                              ', 1, 2018, 800000, 890000, 900000, 1000000),
(43, '0019', 'Saúde da Familia', 'Consolidar a estratégia de saúde da família como modelo de reorientação da atenção básica à saúde no Município.                                          ', 1, 2018, 800000, 890000, 900000, 1000000),
(44, '0020', 'Regime Proprio de Previdencia Social', 'Pagamento de juros, encargos e do principal relacionados com a divida interna.                                         ', 1, 2018, 800000, 890000, 900000, 1000000),
(45, '0021', 'Fomento ao Ensino Superior', 'Oportunizar o acesso ao ensino superior à população local.                                          ', 1, 2018, 800000, 890000, 900000, 1000000),
(46, '0022', 'Programa Municipal de Acesso a Alimentação ', 'Reforçar os niveis nutricionais e alimentares, beneficiando familias de menor poder aquisitivo, desnutridas ou à beira da desnutrição.      ', 1, 2018, 800000, 890000, 900000, 1000000),
(47, '0023', 'Regime Proprio de Previdencia Social ', 'Promover o resgate da cidadania da família, potencializando e definindo a assistência a partir das reais demandas da população.           ', 1, 2018, 800000, 890000, 900000, 1000000),
(48, '0024', 'Construção e Impl.Centro Político Administrativ', 'Dotar os diversos Órgãos de Administração, do mínimo de infra-estrutra para o seu funcionamento.', 1, 2018, 800000, 890000, 900000, 1000000),
(49, '0025', 'Reserva de Contingência', 'Garantir as situações de riscos imprevistos.                                         ', 1, 2018, 800000, 890000, 900000, 1000000),
(50, '9999', 'Reserva do RPPS', 'DESENVOLVIMENTO DO ENSINO MÉDIO ', 1, 2018, 800000, 890000, 900000, 1000000),
(51, '7999', 'Reserva do RPPS', 'DESENVOLVIMENTO DO ENSINO MÉDIO ', 1, 2018, 800000, 890000, 900000, 1000000);

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

--
-- Estrutura da tabela `projetos`
--

CREATE TABLE IF NOT EXISTS `projetos` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `codigo` varchar(4) NOT NULL,
  `cdorgao` varchar(2) NOT NULL,
  `cdunidade` varchar(2) NOT NULL,
  `cdprograma` varchar(4) NOT NULL,
  `cdfuncao` varchar(2) NOT NULL,
  `cdsubfunc` varchar(3) NOT NULL,
  `natureza` varchar(1) NOT NULL,
  `esfera` int(1) NOT NULL,
  `descricao` varchar(60) NOT NULL,
  `publico` text NOT NULL,
  `produto` text NOT NULL,
  `descacao` text NOT NULL,
  `unidmedida` int(2) NOT NULL,
  `meta1` float NOT NULL,
  `meta2` float NOT NULL,
  `meta3` float NOT NULL,
  `meta4` float NOT NULL,
  `recurso1` float NOT NULL,
  `recurso2` float NOT NULL,
  `recurso3` float NOT NULL,
  `recurso4` float NOT NULL,
  `exercicio` int(4) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=46 ;

--
-- Extraindo dados da tabela `projetos`
--

INSERT INTO `projetos` (`id`, `codigo`, `cdorgao`, `cdunidade`, `cdprograma`, `cdfuncao`, `cdsubfunc`, `natureza`, `esfera`, `descricao`, `publico`, `produto`, `descacao`, `unidmedida`, `meta1`, `meta2`, `meta3`, `meta4`, `recurso1`, `recurso2`, `recurso3`, `recurso4`, `exercicio`) VALUES
(10, '1001', '02', '02', '0002', '04', '122', '1', 1, 'Aq. de Veiculos pra o Gabinete', 'funcionarios do gabinte', 'Veiculo', 'adminstrativa', 3, 200000, 220000, 230000, 250000, 200000, 220000, 230000, 240000, 2018),
(11, '1002', '02', '05', '0026', '12', '368', '1', 1, 'Construção,Ampliação e Reformas Unidades Escolares ', 'Estudantes', 'material e mão de obra', 'Reformas de escolas ', 3, 200000, 220000, 230000, 250000, 200000, 220000, 230000, 240000, 2018),
(12, '1003', '02', '05', '0006', '12', '122', '1', 1, 'Construção Ampl. e Reformas', 'Estudantes', 'material e mão de obra', 'Reformas de escolas ', 3, 200000, 220000, 230000, 250000, 200000, 220000, 230000, 240000, 2018),
(13, '1004', '02', '05', '0006', '12', '122', '1', 1, 'Construção e Manutenção  Infra-Estrutura Esportiva', 'Estudantes', 'material e mão de obra', 'Consstrução e Reformas', 3, 200000, 220000, 230000, 250000, 200000, 220000, 230000, 240000, 2018),
(14, '1005', '02', '08', '0002', '04', '122', '1', 1, 'Construção,Ampliação,Reformas Próprios Municipais  ', 'público', 'material e mão de obra', 'adminstrativa', 3, 200000, 220000, 230000, 250000, 200000, 220000, 230000, 240000, 2018),
(15, '1006', '02', '08', '0001', '01', '122', '1', 1, 'Modernização da Frota Municpal', 'ãdministrativo', 'Veiculo', 'adminstrativa', 3, 200000, 220000, 230000, 250000, 200000, 220000, 230000, 240000, 2018),
(16, '1007', '02', '08', '0002', '04', '122', '1', 1, 'Pavinetação Asfáltica', 'público', 'material e mão de obra', 'adminstrativa', 3, 200000, 220000, 230000, 250000, 200000, 220000, 230000, 240000, 2018),
(17, '1008', '02', '08', '0002', '01', '122', '1', 1, 'Construção e Manutenção Praças e Jardins', 'público', 'material e mão de obra', 'adminstrativa', 3, 200000, 220000, 230000, 250000, 200000, 220000, 230000, 240000, 2018),
(18, '1009', '02', '08', '0002', '04', '122', '1', 1, 'Ampliação e Manutenção Iluminação Pública', 'público', 'material e mão de obra', 'adminstrativa', 3, 200000, 220000, 230000, 250000, 200000, 220000, 230000, 240000, 2018),
(19, '1010', '02', '15', '0011', '04', '122', '1', 1, 'Aquisição de Veículo para a Saúde', 'público', 'Veiculo', 'adminstrativa', 1, 200000, 220000, 230000, 250000, 200000, 220000, 230000, 240000, 2018),
(20, '1011', '02', '15', '0011', '10', '122', '1', 1, 'Construção, Ampliação e Reformas Unidades de Saúde', 'público', 'material e mão de obra', 'adminstrativa', 3, 200000, 220000, 230000, 250000, 200000, 220000, 230000, 240000, 2018),
(21, '1012', '02', '15', '0011', '04', '122', '1', 1, 'Ampliação Rede Ãgua e Esgotomento Sanitário', 'público', 'material e mão de obra', 'adminstrativa', 3, 200000, 220000, 230000, 250000, 200000, 220000, 230000, 240000, 2018),
(22, '1013', '02', '18', '0008', '04', '122', '1', 1, 'Moradia para Quem Precisa', 'público', 'gestão', 'adminstrativa', 3, 200000, 220000, 230000, 250000, 200000, 220000, 230000, 240000, 2018),
(23, '1014', '02', '17', '0001', '01', '122', '1', 1, 'Construção Ampliação de Unidades Sociais', 'público', 'gestão', 'adminstrativa', 3, 200000, 220000, 230000, 250000, 200000, 220000, 230000, 240000, 2018),
(24, '1015', '02', '08', '0002', '04', '122', '1', 1, 'Construção do Terminal Rododviário', 'público', 'gestão', 'adminstrativa', 3, 200000, 220000, 230000, 250000, 200000, 220000, 230000, 240000, 2018),
(25, '2001', '01', '01', '0001', '01', '031', '2', 1, 'Gestão das Atividades Legislativas', 'público', 'gestão', 'adminstrativa', 3, 200000, 220000, 230000, 250000, 200000, 220000, 230000, 240000, 2018),
(26, '2002', '02', '02', '0002', '04', '122', '2', 1, 'Gestão das Atividades do Gabinete', 'ãdministrativo', 'gestão', 'adminstrativa', 3, 200000, 220000, 230000, 250000, 200000, 220000, 230000, 240000, 2018),
(27, '1034', '02', '20', '0023', '09', '272', '1', 2, 'Construção e Reformas para o Instituto', 'público', 'gestão', 'adminstrativa', 1, 1, 1, 1, 1, 10000, 10000, 10000, 10000, 2019),
(28, '2050', '02', '20', '0023', '09', '272', '2', 2, 'Manutenção das Atividades Administrativas  e de Csuteio', 'público', 'gestão', 'adminstrativa', 1, 1, 1, 1, 1, 203000, 203000, 203000, 203000, 2019),
(29, '2054', '02', '20', '0023', '09', '272', '1', 2, 'manutenção e Encargos Com a Previdência ', 'público', 'gestão', 'adminstrativa', 1, 1, 1, 1, 1, 645000, 645000, 645000, 645000, 2019),
(30, '9999', '02', '20', '0023', '99', '997', '1', 2, 'Reserva do RPPS', 'público', 'gestão', 'adminstrativa', 1, 1, 1, 1, 1, 117000, 117000, 117000, 117000, 2019),
(31, '2001', '01', '01', '0001', '01', '031', '2', 1, 'manutenção da Ação Legislativatividades ', 'público', 'gestão', 'adminstrativa', 1, 1350000, 1350000, 1350000, 1350000, 1350000, 1350000, 13500000, 1350000, 2020),
(32, '1034', '02', '20', '0023', '09', '272', '1', 1, 'Contrução e reforma Para o Instituto', 'público', 'gestão', 'Previdencia', 1, 1, 1, 1, 1, 1, 1, 1, 1, 2020),
(33, '2050', '02', '20', '0023', '09', '272', '1', 2, 'Manutenção das Atividades Administrativas  e de Csuteio', 'Previdência', 'Social', 'Social', 1, 1, 1, 1, 1, 1, 1, 1, 1, 2020),
(34, '9999', '02', '20', '9999', '09', '272', '1', 2, 'Reserva do RPPS', 'Previdência', 'Social', 'Previdencia', 1, 1, 1, 1, 1, 1, 1, 1, 1, 2020),
(35, '2054', '02', '20', '0023', '09', '272', '1', 2, 'Manutenção e encargos com Previdência', 'Previdência', 'Social', 'Social', 1, 1, 1, 1, 1, 1, 1, 1, 1, 2020),
(36, '2001', '01', '01', '0001', '01', '031', '2', 1, 'Manutenção da Ação  Legislativa', 'público', 'gestão', 'adminstrativa', 1, 0, 0, 0, 0, 0, 0, 0, 0, 2021),
(37, '1034', '02', '20', '0023', '09', '272', '1', 2, 'Construção e Reformas para o Instituto', 'público', 'gestão', 'adminstrativa', 1, 0, 0, 0, 0, 0, 0, 0, 0, 2021),
(38, '2050', '02', '20', '0020', '09', '272', '2', 2, 'Manutenção das Atividades Administrativas  e de Csuteio', '0', '0', '0', 1, 0, 0, 0, 0, 0, 0, 0, 0, 2021),
(39, '2054', '02', '20', '0020', '09', '272', '2', 2, 'Manutenção e Encargos Com a Previdência ', 'público', 'gestão', 'adminstrativa', 1, 0, 0, 0, 0, 0, 0, 0, 0, 2021),
(40, '9999', '02', '20', '9999', '99', '997', '2', 2, 'Reserva do RPPS', '0', '0', '0', 1, 0, 0, 0, 0, 0, 0, 0, 0, 2021),
(41, '2001', '01', '01', '0001', '01', '031', '2', 1, 'Manutenção da Ação  Legislativa', 'público', 'gestão', 'adminstrativa', 1, 0, 0, 0, 0, 0, 0, 0, 0, 2022),
(42, '1007', '07', '20', '0016', '09', '272', '1', 2, 'Projeto de Construção e reforma para  o Instituto', 'público', 'gestão', 'adminstrativa', 1, 1, 1, 1, 1, 1, 1, 1, 1, 2022),
(43, '2054', '07', '20', '0016', '09', '272', '1', 2, 'Manutenção das Atividades Administrativas  e de Csuteio', 'público', 'gestão', 'adminstrativa', 1, 1, 1, 1, 1, 1, 1, 1, 1, 2022),
(44, '2055', '07', '20', '0016', '09', '272', '1', 2, 'manutenção e Encargos Com a Previdência ', 'público', 'gestão', 'adminstrativa', 1, 1, 1, 1, 1, 1, 1, 1, 1, 2022),
(45, '7999', '07', '20', '7999', '99', '997', '2', 2, 'Reserva do RPPS', 'público', 'gestão', 'adminstrativa', 1, 1, 1, 1, 1, 1, 1, 1, 1, 2022);

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

--
-- Estrutura da tabela `responsavel`
--

CREATE TABLE IF NOT EXISTS `responsavel` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nome` varchar(22) NOT NULL,
  `cpf` varchar(11) NOT NULL,
  `endereco` varchar(80) NOT NULL,
  `bairro` varchar(20) NOT NULL,
  `cidade` varchar(20) NOT NULL,
  `estado` varchar(2) NOT NULL,
  `telefone` int(10) NOT NULL,
  `dt_inicio` date NOT NULL,
  `dt_final` date NOT NULL,
  `cdorgao` varchar(2) NOT NULL,
  `cargo_gestor` varchar(20) NOT NULL,
  `cod_postal` varchar(8) NOT NULL,
  `email_gestor` varchar(100) NOT NULL,
  `escola` varchar(2) NOT NULL,
  `crccontador` varchar(11) NOT NULL,
  `estadocrc` varchar(2) NOT NULL,
  `provim` varchar(2) NOT NULL,
  `cnpjempterc` varchar(14) NOT NULL,
  `razaempr` varchar(80) NOT NULL,
  `cdunid` varchar(2) NOT NULL,
  `codident` varchar(4) NOT NULL,
  `identidade` varchar(20) NOT NULL,
  `dtgestao` varchar(30) NOT NULL,
  `user` int(11) NOT NULL,
  `exerc` varchar(4) NOT NULL,
  `mes_inicio` varchar(2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ;

--
-- Extraindo dados da tabela `responsavel`
--

INSERT INTO `responsavel` (`id`, `nome`, `cpf`, `endereco`, `bairro`, `cidade`, `estado`, `telefone`, `dt_inicio`, `dt_final`, `cdorgao`, `cargo_gestor`, `cod_postal`, `email_gestor`, `escola`, `crccontador`, `estadocrc`, `provim`, `cnpjempterc`, `razaempr`, `cdunid`, `codident`, `identidade`, `dtgestao`, `user`, `exerc`, `mes_inicio`) VALUES
(10, 'Marivaldo S. de Souza', '52893456120', 'Melvin Jones, 1366 - Centro - Fátima do Sul/MS 79700000', '', 'Vicentina', 'MS', 0, '2021-01-01', '2021-12-31', '02', 'Contador', '', 'marivaldossouza33@hotma il.com', '04', ' 008571/0-9', 'MS', '', '', '', '20', '55', '572744 SSP/MS', '1/03/2020 a 30/03/2021', 0, '2021', '12'),
(11, 'Jalmir Santos Silva', '32258143187', 'RUA ANTONIO ROBERTO DIAS, 325 - VISTA ALEGRE - Vicentina/MS 79710000', '', 'Vicentina', 'MS', 0, '2021-01-01', '2022-12-31', '02', 'ordenador', '', 'jalmirvicentina@hotmail.com', '04', '', '', '', '', '', '20', '51', '295544 SSP/MS ', '25/04/2021 a 31/12/2021', 0, '2021', '12');

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

--
-- Estrutura da tabela `saldo_banco`
--

CREATE TABLE IF NOT EXISTS `saldo_banco` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_conta` int(11) NOT NULL,
  `sl_inicial` decimal(16,2) NOT NULL,
  `sl_periodo` varchar(6) NOT NULL,
  `sl_exerc` varchar(4) NOT NULL,
  `sl_final` decimal(16,2) NOT NULL,
  `sl_unid` varchar(2) NOT NULL,
  `sl_salex` decimal(16,2) NOT NULL,
  `sl_slfon1` decimal(16,2) NOT NULL,
  `sl_slfon2` decimal(16,2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=207 ;

--
-- Extraindo dados da tabela `saldo_banco`
--

INSERT INTO `saldo_banco` (`id`, `id_conta`, `sl_inicial`, `sl_periodo`, `sl_exerc`, `sl_final`, `sl_unid`, `sl_salex`, `sl_slfon1`, `sl_slfon2`) VALUES
(1, 1, '0.00', '012019', '', '43798.06', '01', '0.00', '0.00', '0.00'),
(2, 1, '43798.06', '022019', '2019', '30316.06', '01', '0.00', '0.00', '0.00'),
(3, 1, '30316.06', '032019', '2019', '46994.68', '01', '0.00', '0.00', '0.00'),
(4, 1, '46994.68', '042019', '2019', '35620.54', '01', '0.00', '0.00', '0.00'),
(5, 1, '35620.54', '052019', '2019', '23836.58', '01', '0.00', '0.00', '0.00'),
(6, 1, '23836.58', '062019', '2019', '7699.66', '01', '0.00', '0.00', '0.00'),
(7, 1, '7699.66', '072019', '2019', '20830.37', '01', '0.00', '0.00', '0.00'),
(8, 1, '20830.37', '082019', '2019', '28395.33', '01', '0.00', '0.00', '0.00'),
(9, 1, '28395.33', '092019', '2019', '19823.90', '01', '0.00', '0.00', '0.00'),
(10, 1, '19823.90', '102019', '2019', '16398.50', '01', '0.00', '0.00', '0.00'),
(11, 1, '16398.50', '112019', '2019', '3419.70', '01', '0.00', '0.00', '0.00'),
(12, 2, '2399.52', '012019', '2019', '693.68', '20', '7783186.58', '0.00', '0.00'),
(13, 3, '1976250.84', '012019', '2019', '1915285.86', '20', '0.00', '0.00', '0.00'),
(14, 4, '5679064.63', '012019', '2019', '5756550.61', '20', '0.00', '0.00', '0.00'),
(15, 5, '125471.59', '012019', '2019', '130776.93', '20', '0.00', '0.00', '0.00'),
(16, 2, '693.68', '022019', '2019', '3331.24', '20', '0.00', '0.00', '0.00'),
(17, 3, '1915285.86', '022019', '2019', '2260782.32', '20', '0.00', '0.00', '0.00'),
(18, 4, '5756550.61', '022019', '2019', '5785403.32', '20', '0.00', '0.00', '0.00'),
(19, 5, '130776.93', '022019', '2019', '131423.00', '20', '0.00', '0.00', '0.00'),
(20, 2, '3331.24', '032019', '2019', '1649.69', '20', '0.00', '0.00', '0.00'),
(21, 3, '2260782.32', '032019', '2019', '2252102.93', '20', '0.00', '0.00', '0.00'),
(22, 4, '5785403.32', '032019', '2019', '5823576.93', '20', '0.00', '0.00', '0.00'),
(23, 5, '131423.00', '032019', '2019', '332751.04', '20', '0.00', '0.00', '0.00'),
(28, 2, '1649.69', '042019', '2019', '6121.58', '20', '0.00', '0.00', '0.00'),
(29, 3, '2252102.93', '042019', '2019', '2196628.18', '20', '0.00', '0.00', '0.00'),
(30, 4, '5823576.93', '042019', '2019', '5878202.06', '20', '0.00', '0.00', '0.00'),
(31, 5, '332751.04', '042019', '2019', '337702.58', '20', '0.00', '0.00', '0.00'),
(32, 2, '6121.58', '052019', '2019', '1316.51', '20', '0.00', '0.00', '0.00'),
(33, 3, '2196628.18', '052019', '2019', '2143878.46', '20', '0.00', '0.00', '0.00'),
(34, 4, '5878202.06', '052019', '2019', '5964735.52', '20', '0.00', '0.00', '0.00'),
(35, 5, '337702.58', '052019', '2019', '350007.53', '20', '0.00', '0.00', '0.00'),
(36, 2, '1316.51', '062019', '2019', '1695.60', '20', '0.00', '0.00', '0.00'),
(37, 3, '2143878.46', '062019', '2019', '2881935.35', '20', '0.00', '0.00', '0.00'),
(38, 4, '5964735.52', '062019', '2019', '5258984.54', '20', '0.00', '0.00', '0.00'),
(39, 5, '350007.53', '062019', '2019', '363416.70', '20', '0.00', '0.00', '0.00'),
(40, 2, '1695.60', '072019', '2019', '5122.76', '20', '0.00', '0.00', '0.00'),
(41, 3, '2881935.35', '072019', '2019', '2817650.00', '20', '0.00', '0.00', '0.00'),
(42, 4, '5258984.54', '072019', '2019', '5309026.08', '20', '0.00', '0.00', '0.00'),
(43, 5, '363416.70', '072019', '2019', '367770.72', '20', '0.00', '0.00', '0.00'),
(44, 2, '5122.76', '082019', '2019', '3473.17', '20', '0.00', '0.00', '0.00'),
(45, 3, '2817650.00', '082019', '2019', '3075215.33', '20', '0.00', '0.00', '0.00'),
(46, 4, '5309026.08', '082019', '2019', '5312983.09', '20', '0.00', '0.00', '0.00'),
(47, 5, '367770.72', '082019', '2019', '366429.52', '20', '0.00', '0.00', '0.00'),
(48, 2, '3473.17', '092019', '2019', '1263.91', '20', '0.00', '0.00', '0.00'),
(49, 3, '3075215.33', '092019', '2019', '3050926.79', '20', '0.00', '0.00', '0.00'),
(50, 4, '5312983.09', '092019', '2019', '5398419.18', '20', '0.00', '0.00', '0.00'),
(51, 5, '366429.52', '092019', '2019', '377154.16', '20', '0.00', '0.00', '0.00'),
(56, 2, '1263.91', '102019', '2019', '122150.86', '20', '0.00', '0.00', '0.00'),
(57, 3, '3050926.79', '102019', '2019', '3090758.19', '20', '0.00', '0.00', '0.00'),
(58, 4, '5398419.18', '102019', '2019', '5398419.18', '20', '0.00', '0.00', '0.00'),
(59, 5, '377154.16', '102019', '2019', '390308.50', '20', '0.00', '0.00', '0.00'),
(61, 2, '122150.86', '112019', '2019', '2290.63', '20', '0.00', '0.00', '0.00'),
(62, 3, '3090758.19', '112019', '2019', '3056891.20', '20', '0.00', '0.00', '0.00'),
(63, 4, '5398419.18', '112019', '2019', '5463477.02', '20', '0.00', '0.00', '0.00'),
(64, 5, '390308.50', '112019', '2019', '380231.66', '20', '0.00', '0.00', '0.00'),
(65, 1, '3419.70', '122019', '2019', '0.00', '01', '0.00', '0.00', '0.00'),
(66, 2, '976.42', '012020', '2020', '1326.33', '20', '1325.83', '0.00', '0.00'),
(68, 3, '2963446.76', '012020', '2020', '3295148.68', '20', '3295583.49', '350851.17', '2963446.76'),
(69, 4, '5510827.73', '012020', '2020', '5543468.70', '20', '0.00', '32640.97', '5510827.73'),
(70, 5, '387067.98', '012020', '2020', '388600.32', '20', '388600.32', '1532.34', '387067.98'),
(71, 2, '693.68', '122019', '2019', '976.42', '20', '7783186.58', '282.74', '0.00'),
(72, 3, '1915285.86', '122019', '2019', '2963446.76', '20', '0.00', '1089572.35', '0.00'),
(73, 4, '5756550.61', '122019', '2019', '5510827.73', '20', '0.00', '-238886.56', '0.00'),
(74, 5, '130776.93', '122019', '2019', '387067.98', '20', '0.00', '249454.73', '0.00'),
(75, 2, '6896828.11', '012018', '2018', '7783186.58', '20', '6896828.11', '0.00', '0.00'),
(76, 2, '0.00', '122018', '2018', '7783186.58', '20', '7783186.58', '0.00', '0.00'),
(77, 2, '1326.33', '022020', '2020', '236.26', '20', '351.82', '-974.51', '0.00'),
(78, 3, '3295148.68', '022020', '2020', '3488470.79', '20', '231524.35', '187141.30', '0.00'),
(79, 4, '5543468.70', '022020', '2020', '5575534.68', '20', '0.00', '0.00', '0.00'),
(80, 5, '388600.32', '022020', '2020', '390313.98', '20', '0.00', '0.00', '0.00'),
(81, 1, '16062.27', '022020', '2020', '29303.78', '01', '29303.78', '0.00', '0.00'),
(82, 1, '0.00', '012020', '2020', '16062.27', '01', '0.00', '0.00', '0.00'),
(83, 2, '351.82', '032020', '2020', '2347.08', '20', '0.00', '-760.93', '0.00'),
(84, 3, '3488355.23', '032020', '2020', '3454895.27', '20', '0.00', '72490.53', '0.00'),
(85, 4, '5575534.68', '032020', '2020', '5529006.59', '20', '0.00', '0.00', '0.00'),
(86, 5, '390313.98', '032020', '2020', '360500.76', '20', '0.00', '0.00', '0.00'),
(87, 1, '29303.78', '032020', '2020', '92201.36', '01', '0.00', '-11356.09', '0.00'),
(88, 1, '92201.36', '042020', '2020', '100676.32', '01', '0.00', '-49958.26', '0.00'),
(89, 2, '2347.08', '042020', '2020', '2551.43', '20', '2414.47', '-1297.00', '-735.00'),
(90, 3, '3454895.27', '042020', '2020', '3398737.60', '20', '9644.99', '-46792.42', '0.00'),
(91, 4, '5529006.59', '042020', '2020', '5565228.90', '20', '0.00', '36222.31', '0.00'),
(92, 5, '360500.76', '042020', '2020', '365082.37', '20', '0.00', '4581.61', '0.00'),
(93, 1, '104385.41', '052020', '2020', '104321.99', '01', '104321.99', '104385.41', '0.00'),
(95, 2, '2551.43', '052020', '2020', '1423.88', '20', '1423.88', '-1407.55', '-140.00'),
(96, 3, '3398737.60', '052020', '2020', '3397660.11', '20', '3377.34', '-36905.42', '0.00'),
(97, 4, '5565228.90', '052020', '2020', '5652357.51', '20', '0.00', '0.00', '0.00'),
(98, 5, '365082.37', '052020', '2020', '370767.94', '20', '0.00', '0.00', '0.00'),
(99, 1, '104321.99', '062020', '2020', '107259.88', '01', '0.00', '-97109.09', '0.00'),
(101, 2, '1423.88', '062020', '2020', '640.03', '20', '0.00', '-783.85', '0.00'),
(102, 3, '3397660.11', '062020', '2020', '3513713.66', '20', '18064.73', '138859.86', '0.00'),
(103, 4, '5652357.51', '062020', '2020', '5701838.34', '20', '0.00', '49480.83', '0.00'),
(104, 5, '370767.94', '062020', '2020', '378100.32', '20', '0.00', '7332.38', '0.00'),
(105, 1, '107259.88', '072020', '2020', '121074.43', '01', '121072.43', '-81819.12', '0.00'),
(106, 2, '640.03', '072020', '2020', '2001.08', '20', '0.00', '12705.03', '-578.01'),
(107, 3, '3513713.66', '072020', '2020', '3721960.76', '20', '0.00', '4587.64', '0.00'),
(108, 4, '5701838.34', '072020', '2020', '5749241.99', '20', '0.00', '47403.65', '0.00'),
(109, 5, '378100.32', '072020', '2020', '397814.34', '20', '0.00', '219714.02', '0.00'),
(110, 2, '2001.08', '082020', '2020', '4096.72', '20', '0.00', '780.30', '-657.67'),
(111, 3, '3721960.76', '082020', '2020', '3459528.72', '20', '2888.66', '-51006.66', '0.00'),
(112, 4, '5749241.99', '082020', '2020', '5756899.99', '20', '0.00', '0.00', '0.00'),
(113, 5, '397814.34', '082020', '2020', '586578.91', '20', '0.00', '200000.00', '0.00'),
(114, 1, '121074.43', '082020', '2020', '150634.58', '01', '0.00', '-67557.19', '0.00'),
(115, 1, '150634.58', '092020', '2020', '169316.81', '01', '0.00', '-77258.81', '0.00'),
(116, 2, '4096.72', '092020', '2020', '5570.92', '20', '5570.47', '1474.20', '0.00'),
(117, 3, '3459528.72', '092020', '2020', '3392765.69', '20', '0.00', '-47287.05', '0.00'),
(118, 4, '5756899.99', '092020', '2020', '5746533.89', '20', '0.00', '0.00', '0.00'),
(119, 5, '586578.91', '092020', '2020', '685549.01', '20', '0.00', '110000.00', '0.00'),
(120, 2, '5570.92', '102020', '2020', '1965.41', '20', '1965.41', '-3605.51', '0.00'),
(121, 3, '3392765.69', '102020', '2020', '3435466.51', '20', '6786.31', '43093.29', '0.00'),
(122, 4, '5746533.89', '102020', '2020', '5751067.34', '20', '0.00', '0.00', '0.00'),
(123, 5, '685549.01', '102020', '2020', '685503.83', '20', '0.00', '0.00', '0.00'),
(124, 1, '169316.81', '102020', '2020', '177916.62', '01', '0.00', '-85941.71', '0.00'),
(129, 1, '177916.62', '112020', '2020', '195059.82', '01', '196663.38', '-83741.91', '-2259.18'),
(130, 2, '1965.41', '112020', '2020', '4706.89', '20', '0.00', '2741.48', '0.00'),
(131, 3, '3435466.51', '112020', '2020', '3415246.53', '20', '5099.59', '-52252.93', '0.00'),
(132, 4, '5751067.34', '112020', '2020', '5804434.85', '20', '0.00', '0.00', '0.00'),
(133, 5, '685503.83', '112020', '2020', '699149.91', '20', '0.00', '0.00', '0.00'),
(134, 1, '195059.82', '122020', '2020', '0.00', '01', '0.00', '5875.24', '0.00'),
(137, 2, '4706.89', '122020', '2020', '2167.16', '20', '0.00', '-1983.69', '0.00'),
(138, 3, '3415246.53', '122020', '2020', '3533147.56', '20', '18549.22', '75846.74', '0.00'),
(139, 4, '5804434.85', '122020', '2020', '5887428.91', '20', '0.00', '0.00', '0.00'),
(140, 5, '699149.91', '122020', '2020', '733827.01', '20', '0.00', '0.00', '0.00'),
(141, 1, '0.00', '012021', '2021', '43045.07', '01', '0.00', '-66692.82', '0.00'),
(142, 2, '2167.16', '012021', '2021', '4212.80', '20', '4212.80', '-4843.95', '2167.16'),
(143, 3, '3533147.56', '012021', '2021', '3471097.98', '20', '0.00', '-41981.14', '3533147.56'),
(144, 4, '5887428.91', '012021', '2021', '5891402.14', '20', '0.00', '0.00', '5887428.91'),
(145, 5, '733827.01', '012021', '2021', '727560.61', '20', '0.00', '0.00', '733827.01'),
(146, 1, '43045.07', '022021', '2021', '58859.17', '01', '58859.82', '-84499.53', '0.00'),
(147, 2, '4212.80', '022021', '2021', '4352.31', '20', '0.00', '139.51', '0.00'),
(148, 3, '3471097.98', '022021', '2021', '3533227.07', '20', '105993.07', '98516.40', '0.00'),
(149, 4, '5891402.14', '022021', '2021', '5863795.20', '20', '0.00', '0.00', '0.00'),
(150, 5, '727560.61', '022021', '2021', '716431.86', '20', '0.00', '0.00', '0.00'),
(151, 1, '58859.17', '032021', '2021', '77299.56', '01', '0.00', '-83408.87', '0.00'),
(152, 2, '4352.31', '032021', '2021', '10586.13', '20', '10586.13', '6233.76', '0.00'),
(153, 3, '3533227.07', '032021', '2021', '3716294.03', '20', '28335.87', '188726.31', '0.00'),
(154, 4, '5863795.20', '032021', '2021', '5879937.99', '20', '0.00', '0.00', '0.00'),
(155, 5, '716431.86', '032021', '2021', '711890.78', '20', '0.00', '0.00', '0.00'),
(156, 1, '77299.56', '042021', '2021', '103086.40', '01', '0.00', '-81821.70', '0.00'),
(157, 2, '10586.13', '042021', '2021', '1915.01', '20', '0.00', '-8598.62', '0.00'),
(158, 3, '3716294.03', '042021', '2021', '4065839.43', '20', '1682.34', '339431.79', '0.00'),
(159, 4, '5879937.99', '042021', '2021', '5923889.98', '20', '0.00', '0.00', '0.00'),
(160, 5, '711890.78', '042021', '2021', '716473.03', '20', '0.00', '0.00', '0.00'),
(161, 2, '1915.01', '052021', '2021', '3040.95', '20', '0.00', '1219.34', '0.00'),
(162, 3, '4065839.43', '052021', '2021', '4231753.23', '20', '5297.22', '151417.32', '0.00'),
(163, 4, '5923889.98', '052021', '2021', '3940520.93', '20', '0.00', '-2000000.00', '0.00'),
(164, 5, '716473.03', '052021', '2021', '2761438.89', '20', '0.00', '2000000.00', '0.00'),
(165, 1, '103086.40', '052021', '2021', '135437.06', '01', '0.00', '-72103.15', '0.00'),
(166, 1, '135437.06', '062021', '2021', '138447.95', '01', '0.00', '-88874.66', '0.00'),
(167, 2, '3040.95', '062021', '2021', '1647.83', '20', '3046.83', '-1320.62', '0.00'),
(168, 3, '4231753.23', '062021', '2021', '4371590.85', '20', '5301.22', '149033.41', '0.00'),
(169, 4, '3940520.93', '062021', '2021', '3936212.30', '20', '0.00', '0.00', '0.00'),
(170, 5, '2761438.89', '062021', '2021', '2798249.64', '20', '0.00', '0.00', '0.00'),
(171, 2, '1647.83', '072021', '2021', '9350.71', '20', '9350.71', '-25997.07', '-17372.00'),
(172, 3, '4371590.85', '072021', '2021', '4456959.35', '20', '0.00', '123084.09', '0.00'),
(173, 4, '3936212.30', '072021', '2021', '3921454.05', '20', '0.00', '0.00', '0.00'),
(174, 5, '2798249.64', '072021', '2021', '2768417.32', '20', '0.00', '0.00', '0.00'),
(175, 1, '138447.95', '072021', '2021', '138743.39', '01', '0.00', '-101053.78', '0.00'),
(176, 1, '138743.39', '082021', '2021', '147959.58', '01', '0.00', '-98392.15', '0.00'),
(177, 2, '9350.71', '082021', '2021', '8176.70', '20', '8176.80', '-1101.51', '0.00'),
(178, 3, '4456959.35', '082021', '2021', '4565027.67', '20', '0.00', '135685.93', '0.00'),
(179, 4, '3921454.05', '082021', '2021', '3898560.29', '20', '0.00', '0.00', '0.00'),
(180, 5, '2768417.32', '082021', '2021', '2729447.03', '20', '0.00', '0.00', '0.00'),
(181, 1, '147959.58', '092021', '2021', '115563.42', '01', '0.00', '-125069.90', '0.00'),
(182, 2, '8176.70', '092021', '2021', '8112.01', '20', '0.00', '716.47', '0.00'),
(183, 3, '4565027.67', '092021', '2021', '4698925.07', '20', '0.00', '130535.46', '0.00'),
(184, 4, '3898560.29', '092021', '2021', '3926054.92', '20', '0.00', '0.00', '0.00'),
(185, 5, '2729447.03', '092021', '2021', '2649625.49', '20', '0.00', '0.00', '0.00'),
(186, 2, '8112.01', '102021', '2021', '94.37', '20', '94.37', '-2156.71', '0.00'),
(187, 3, '4698925.07', '102021', '2021', '4717526.51', '20', '0.00', '84821.80', '0.00'),
(188, 4, '3926054.92', '102021', '2021', '3887852.64', '20', '0.00', '0.00', '0.00'),
(189, 5, '2649625.49', '102021', '2021', '2548262.44', '20', '0.00', '0.00', '0.00'),
(190, 1, '115563.42', '102021', '2021', '81200.51', '01', '0.00', '-132499.62', '0.00'),
(191, 1, '81200.51', '112021', '2021', '81538.34', '01', '81538.24', '-99795.16', '0.00'),
(193, 2, '94.37', '112021', '2021', '5993.61', '20', '5993.61', '5971.74', '0.00'),
(194, 3, '4717526.51', '112021', '2021', '4915725.40', '20', '5604.25', '119047.51', '0.00'),
(195, 4, '3887852.64', '112021', '2021', '3953654.18', '20', '0.00', '0.00', '0.00'),
(196, 5, '2548262.44', '112021', '2021', '2543848.72', '20', '0.00', '0.00', '0.00'),
(197, 2, '5993.61', '122021', '2021', '9323.78', '20', '9523.78', '3655.67', '0.00'),
(198, 3, '4915725.40', '122021', '2021', '4914726.06', '20', '0.00', '52457.37', '0.00'),
(199, 4, '3953654.18', '122021', '2021', '3984586.35', '20', '0.00', '0.00', '0.00'),
(200, 5, '2543848.72', '122021', '2021', '2571093.29', '20', '0.00', '0.00', '0.00'),
(201, 1, '81538.34', '122021', '2021', '0.00', '01', '0.00', '-173923.20', '0.00'),
(202, 1, '0.00', '012022', '2021', '19895.94', '01', '22460.94', '-18199.42', '0.00'),
(203, 2, '9323.78', '012022', '2021', '6729.92', '20', '6719.92', '-2521.36', '9323.78'),
(204, 3, '4914726.06', '012022', '2021', '5012699.59', '20', '6454.16', '95590.56', '4914726.06'),
(205, 4, '3984586.35', '012022', '2021', '3998400.05', '20', '0.00', '0.00', '3984586.35'),
(206, 5, '2571093.29', '012022', '2021', '2638339.44', '20', '0.00', '0.00', '2571093.29');

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

--
-- Estrutura da tabela `sequencia`
--

CREATE TABLE IF NOT EXISTS `sequencia` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `seq_exer` int(4) NOT NULL,
  `seq_empe` int(6) NOT NULL,
  `seq_orde` int(6) NOT NULL,
  `seq_cred` int(6) NOT NULL,
  `seq_conc` int(5) NOT NULL,
  `seq_extra` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Estrutura da tabela `setor`
--

CREATE TABLE IF NOT EXISTS `setor` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `set_cod` varchar(2) NOT NULL,
  `set_res` int(11) NOT NULL,
  `set_des` varchar(50) NOT NULL,
  `set_uni` varchar(2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

--
-- Extraindo dados da tabela `setor`
--

INSERT INTO `setor` (`id`, `set_cod`, `set_res`, `set_des`, `set_uni`) VALUES
(2, '01', 6, 'VicentinaPrev', '20');

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

--
-- Estrutura da tabela `subfunc`
--

CREATE TABLE IF NOT EXISTS `subfunc` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `codigo` varchar(3) NOT NULL,
  `descricao` varchar(50) NOT NULL,
  `codigo_tipo` varchar(2) NOT NULL,
  `exercicio` int(4) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=124 ;

--
-- Extraindo dados da tabela `subfunc`
--

INSERT INTO `subfunc` (`id`, `codigo`, `descricao`, `codigo_tipo`, `exercicio`) VALUES
(9, '031', 'Ação Legislativa', '02', 2018),
(10, '032', 'Controle Externo', '01', 2018),
(11, '061', 'Ação Judiciária', '01', 2018),
(12, '062', '	Defesa do Interesse Público no Processo Judiciá', '01', 2018),
(13, '091', 'Defesa da Ordem Jurídica', '01', 2018),
(14, '092', '	Representação Judicial e Extrajudicial', '01', 2018),
(15, '121', 'Planejamento e Orçamento', '01', 2018),
(16, '122', 'Administração Geral', '01', 2018),
(17, '123', 'Administração Financeira', '01', 2018),
(18, '124', '	Controle Interno', '01', 2018),
(19, '125', 'Normatização e Fiscalização', '01', 2018),
(20, '126', 'Tecnologia da Informação', '01', 2018),
(21, '127', 'Ordenamento Territorial', '01', 2018),
(22, '128', 'Formação de Recursos Humanos', '01', 2018),
(23, '129', 'Administração de Receitas', '01', 2018),
(24, '130', 'Administração de Concessões', '01', 2018),
(25, '131', 'Comunicação Social', '01', 2018),
(26, '151', 'Defesa Aérea', '01', 2018),
(27, '152', 'Defesa Naval', '01', 2018),
(28, '153', 'Defesa Terrestre', '01', 2018),
(29, '181', 'Policiamento', '01', 2018),
(30, '182', 'Defesa Civil', '01', 2018),
(31, '183', '	Informação e Inteligência', '01', 2018),
(32, '211', 'Relações Diplomáticas', '01', 2018),
(33, '212', 'Cooperação Internacional', '01', 2018),
(34, '241', 'Assistência ao Idoso', '01', 2018),
(35, '242', 'Assistência ao Portador de Deficiência', '01', 2018),
(36, '243', '	Assistência à Criança e ao Adolescente', '01', 2018),
(37, '244', 'Assistência Comunitária', '01', 2018),
(38, '271', 'Previdência Básica', '01', 2018),
(39, '272', 'Previdência do Regime Estatutário', '01', 2018),
(40, '273', 'Previdência Complementar', '01', 2018),
(41, '274', 'Previdência Especial', '01', 2018),
(42, '301', 'Atenção Básica', '01', 2018),
(43, '302', 'Assistência Hospitalar e Ambulatoria', '01', 2018),
(44, '303', 'Suporte Profilático e Terapêutico', '01', 2018),
(45, '304', 'Vigilância Sanitária', '01', 2018),
(46, '305', '	Vigilância Epidemiológica', '01', 2018),
(47, '306', 'Alimentação e Nutrição', '01', 2018),
(48, '331', '	Proteção e Benefícios ao Trabalhador', '01', 2018),
(49, '332', 'Relações de Trabalho', '01', 2018),
(50, '333', 'Empregabilidade', '01', 2018),
(51, '334', 'Fomento ao Trabalho', '01', 2018),
(52, '361', 'Ensino Fundamental (Educação Básica)', '01', 2018),
(53, '362', '	Ensino Médio', '01', 2018),
(54, '363', 'Ensino Profissional', '01', 2018),
(55, '364', 'Ensino Superior', '01', 2018),
(56, '365', 'Educação Infantil (Educação Básica)', '01', 2018),
(57, '366', 'Educação de Jovens e Adultos', '01', 2018),
(58, '367', 'Educação Especial', '01', 2018),
(59, '368', 'Educação Básica', '01', 2018),
(60, '391', 'Patrimônio Histórico, Artístico e Arqueológico', '01', 2018),
(61, '392', 'Difusão Cultural', '01', 2018),
(62, '421', 'Custódia e Reintegração Social', '01', 2018),
(63, '422', 'Direitos Individuais, Coletivos e Difusos', '01', 2018),
(64, '423', 'Assistência aos Povos Indígenas', '01', 2018),
(65, '451', 'InfraEstrutura Urbana', '01', 2018),
(66, '452', '	Serviços Urbanos', '01', 2018),
(67, '453', '	Transportes Coletivos Urbanos', '01', 2018),
(68, '481', 'Habitação Rural', '01', 2018),
(69, '482', 'Habitação Urbana', '01', 2018),
(70, '511', '	Saneamento Básico Rural', '01', 2018),
(71, '512', 'Saneamento Básico Urbano', '01', 2018),
(72, '541', 'Preservação e Conservação Ambiental', '01', 2018),
(73, '542', 'Controle Ambiental', '01', 2018),
(74, '543', 'Recuperação de Ãreas Degradadas', '01', 2018),
(75, '544', 'Recursos Hídricos', '01', 2018),
(76, '545', 'Meteorologia', '01', 2018),
(77, '571', 'Desenvolvimento Científico', '01', 2018),
(78, '572', 'Desenvolvimento Tecnológico e Engenharia', '01', 2018),
(79, '573', '	Difusão do Conhecimento Científico e Tecnológi', '01', 2018),
(80, '601', '	Promoção da Produção Vegeta', '01', 2018),
(81, '602', '	Promoção da Produção Animal', '01', 2018),
(82, '603', '	Defesa Sanitária Vegetal', '01', 2018),
(83, '604', '	Defesa Sanitária Animal', '01', 2018),
(84, '605', 'Abastecimento', '01', 2018),
(85, '606', 'Extensão Rural', '01', 2018),
(86, '607', 'Irrigação', '01', 2018),
(87, '608', 'Promoção da Produção Agropecuária', '01', 2018),
(88, '609', 'Defesa Agropecuária', '01', 2018),
(89, '631', 'Reforma Agrária', '01', 2018),
(90, '632', 'Colonização', '01', 2018),
(91, '661', 'Promoção Industrial', '01', 2018),
(92, '662', 'Produção Industrial', '01', 2018),
(93, '663', 'Mineração', '01', 2018),
(94, '664', 'Propriedade Industrial', '01', 2018),
(95, '665', 'Normalização e Qualidade', '01', 2018),
(96, '691', 'Promoção Comercial', '01', 2018),
(97, '692', 'Comercialização', '01', 2018),
(98, '693', 'Comércio Exterior', '01', 2018),
(99, '694', 'Serviços Financeiros', '01', 2018),
(100, '695', 'Turismo', '01', 2018),
(101, '721', 'Comunicações Postais', '01', 2018),
(102, '722', 'Telecomunicações', '01', 2018),
(103, '751', 'Conservação de Energia', '01', 2018),
(104, '752', 'Energia Elétrica', '01', 2018),
(105, '753', 'Petróleo', '01', 2018),
(106, '754', 'Ãlcool', '01', 2018),
(107, '781', 'Transporte Aéreo', '01', 2018),
(108, '782', 'Transporte Rodoviário', '01', 2018),
(109, '783', 'Transporte Ferroviário', '01', 2018),
(110, '784', 'Transporte Hidroviário', '01', 2018),
(111, '785', 'Transportes Especiais', '01', 2018),
(112, '811', 'Desporto de Rendimento', '01', 2018),
(113, '812', 'Desporto Comunitário', '01', 2018),
(114, '813', 'Lazer', '01', 2018),
(115, '841', 'Refinanciamento da Dívida Interna', '01', 2018),
(116, '842', '	Refinanciamento da Dívida Externa', '01', 2018),
(117, '843', 'Serviço da Dívida Interna', '01', 2018),
(118, '844', 'Serviço da Dívida Externa', '01', 2018),
(119, '845', 'Transferências', '01', 2018),
(120, '846', '	Outros Encargos Especiai', '01', 2018),
(121, '847', 'Transferências para a Educação Básica', '01', 2018),
(122, '997', '	Reserva do RPPS', '01', 2018),
(123, '999', 'Reserva de Contingência', '01', 2018);

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

--
-- Estrutura da tabela `tabdesc`
--

CREATE TABLE IF NOT EXISTS `tabdesc` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `desc` varchar(20) NOT NULL,
  `ttipo` varchar(1) NOT NULL,
  `subti` varchar(3) NOT NULL,
  `desd` varchar(3) NOT NULL,
  `tipos` varchar(2) NOT NULL,
  `destc` varchar(50) NOT NULL,
  `rectc` varchar(50) NOT NULL,
  `orde` int(11) NOT NULL,
  `tiptce` int(2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=15 ;

--
-- Extraindo dados da tabela `tabdesc`
--

INSERT INTO `tabdesc` (`id`, `desc`, `ttipo`, `subti`, `desd`, `tipos`, `destc`, `rectc`, `orde`, `tiptce`) VALUES
(1, 'I.N.S.S...........', '1', '001', '001', '01', 'Depósitos / Consignações 001 001 2314601', 'Depósitos / Consignações 001 001 2312601', 1, 1),
(2, 'RPPS...............', '1', '002', '002', '01', 'Depósitos / Consignações 002 002 2314604', 'Depósitos / Consignações 002 002 2312604', 2, 4),
(3, 'IRRF...........', '1', '003', '003', '01', 'Depósitos / Consignações 003 003 2314602', 'Depósitos / Consignações 003 003 2312602', 3, 2),
(4, 'Transf. Duodecimo', '3', '001', '001', '04', 'Transferências Financeiras 001 001 2312201', 'Transferências Financeiras 001 001 2314201', 9, 0),
(5, 'Transf. Financeira', '2', '', '', '', '', '', 0, 0),
(6, 'Caixa Economica ', '1', '005', '000', '01', 'Depósitos / Consignações 005 000 2312605', 'Depósitos / Consignações 005 000 2314605', 5, 99),
(7, 'Banco do Brasil', '1', '007', '000', '01', 'Depósitos / Consignações 007 000 2312609', 'Depósitos / Consignações 007 000 2314609', 7, 99),
(8, 'Pensao Alimenticia', '1', '006', '000', '01', 'Depósitos / Consignações 006 000 2312608', 'Depósitos / Consignações 006 000 2314608', 8, 99),
(9, 'I.S.S...............', '1', '004', '004', '01', 'Depósitos / Consignações 004 004 2312603', 'Depósitos / Consignações 004 004 2314603', 4, 3),
(10, 'Cassems', '1', '001', '000', '01', 'Depósitos / Consignações 003 003 2312610', 'Depósitos / Consignações 003 003 2312610', 0, 99),
(11, 'Sindicato', '1', '001', '000', '', '', '', 0, 0),
(12, 'Variações Patrimonia', '3', '001', '001', '04', 'Variaçoes patrimoniais-VPA 001 001 23122', 'Variações Financeiras-VPD 001 001 23122', 12, 4),
(13, 'Sicred', '1', '008', '008', '', 'Sicredi', 'Sicredi', 0, 99),
(14, 'Adesao Cassems', '1', '001', '000', '01', 'Adesao Casems', 'Adesao Cassems', 0, 0);

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

--
-- Estrutura da tabela `tablan`
--

CREATE TABLE IF NOT EXISTS `tablan` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `codigo` varchar(13) NOT NULL,
  `debito` varchar(9) NOT NULL,
  `credito` varchar(9) NOT NULL,
  `tplanc` varchar(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=164 ;

--
-- Extraindo dados da tabela `tablan`
--

INSERT INTO `tablan` (`id`, `codigo`, `debito`, `credito`, `tplanc`) VALUES
(81, '31901100', '812310101', '712310100', 'empenho'),
(82, '31901100', '622130300', '522110100', 'empenho'),
(83, '31901100', '311110101', '213110399', 'empenho'),
(84, '1218', '111110100', '421120101', 'receita'),
(85, '1218', '521110000', '622110000', 'receita'),
(86, '1218', '721110000', '821110100', 'receita'),
(87, '33901400', '812310101', '712310100', 'empenho'),
(88, '33901400', '622130300', '522110100', 'empenho'),
(89, '33901400', '332119900', '213110399', 'empenho'),
(90, '33903000', '812310101', '712310100', 'empenho'),
(91, '33903000', '622130300', '522110100', 'empenho'),
(92, '33903000', '331119900', '213110399', 'empenho'),
(93, '33903300', '812310101', '712310100', 'empenho'),
(94, '33903300', '622130300', '522110100', 'empenho'),
(95, '33903300', '332219900', '213110399', 'empenho'),
(96, '33903500', '812310101', '712310100', 'empenho'),
(97, '33903500', '622130300', '522110100', 'empenho'),
(98, '33903500', '332319900', '213110399', 'empenho'),
(99, '33903600', '812310101', '712310100', 'empenho'),
(100, '33903600', '622130300', '522110100', 'empenho'),
(101, '33903600', '332219900', '213110399', 'empenho'),
(102, '33903900', '812310101', '712310100', 'empenho'),
(103, '33903900', '622130300', '522110100', 'empenho'),
(104, '33903900', '332319900', '213110399', 'empenho'),
(105, '31900100', '812310101', '712310100', 'empenho'),
(106, '31900100', '622130300', '522110100', 'empenho'),
(107, '31900100', '321110101', '213110399', 'empenho'),
(108, '31900300', '812310101', '712310100', 'empenho'),
(109, '31900300', '622130300', '522110100', 'empenho'),
(110, '31900300', '322110100', '213110399', 'empenho'),
(111, '31900500', '812310101', '712310100', 'empenho'),
(112, '31900500', '622130300', '522110100', 'empenho'),
(113, '31900500', '329119900', '213110399', 'empenho'),
(114, '2000000000', '213110399', '111110100', 'pagamento'),
(115, '2000000000', '622130400', '622130300', 'pagamento'),
(116, '2000000000', '712310100', '812310102', 'pagamento'),
(117, '8888', '111110100', '218810199', 'recextra'),
(118, '9999', '218810199', '111110100', 'pgtoextra'),
(119, '7218', '111110100', '421120101', 'receita'),
(120, '7218', '521110000', '622110000', 'receita'),
(121, '7218', '721110000', '821110100', 'receita'),
(122, '1321', '111110100', '445110000', 'receita'),
(123, '1321', '521110000', '622110000', 'receita'),
(124, '1321', '721110000', '821110100', 'receita'),
(125, '1921', '111110100', '499650000', 'receita'),
(126, '1921', '521110000', '622110000', 'receita'),
(127, '1921', '721110000', '821110100', 'receita'),
(128, '1922', '111110100', '499650000', 'receita'),
(129, '1922', '521110000', '622110000', 'receita'),
(130, '1922', '721110000', '821110100', 'receita'),
(131, '1990', '111110100', '499250000', 'receita'),
(132, '1990', '521110000', '622110000', 'receita'),
(133, '1990', '721110000', '821110100', 'receita'),
(134, '44905200', '812310101', '712310100', 'empenho'),
(135, '44905200', '622130300', '522110100', 'empenho'),
(136, '44905200', '331119900', '213110399', 'empenho'),
(137, '44905200', '123110101', '463210000', 'empenho'),
(138, '44905100', '812310101', '712310100', 'empenho'),
(139, '44905100', '622130300', '522110100', 'empenho'),
(140, '7990', '111110100', '499910000', 'receita'),
(141, '7990', '521110000', '622110000', 'receita'),
(142, '7990', '721110000', '821110100', 'receita'),
(143, '3000000000', '213110399', '111110100', 'pgrpn'),
(144, '3000000000', '631100000', '631400000', 'pgrpn'),
(146, '4000000000', '213110399', '111110100', 'pgrpp'),
(147, '4000000000', '632100000', '632200000', 'pgrpp'),
(150, '8888', '721300000', '821110100', 'recextra'),
(151, '9999', '821110100', '821900000', 'pgtoextra'),
(153, '2001', '111110100', '492220000', 'vpa'),
(154, '2002', '361710400', '111110100', 'vpd'),
(155, '31901300', '812310101', '712310100', 'empenho'),
(156, '31901300', '622130300', '522110100', 'empenho'),
(157, '31901300', '329119900', '213110399', 'empenho'),
(158, '31911300', '812310101', '712310100', 'empenho'),
(159, '31911300', '622130300', '522110100', 'empenho'),
(160, '31911300', '329119900', '213110399', 'empenho'),
(161, '33909300', '812310101', '712310100', 'empenho'),
(162, '33909300', '622130300', '522110100', 'empenho'),
(163, '33909300', '332319900', '213110399', 'empenho');

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

--
-- Estrutura da tabela `tempdesc`
--

CREATE TABLE IF NOT EXISTS `tempdesc` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `iddes` int(2) NOT NULL,
  `vlval` float NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

--
-- Extraindo dados da tabela `tempdesc`
--

INSERT INTO `tempdesc` (`id`, `iddes`, `vlval`) VALUES
(1, 1, 0),
(2, 1, 0),
(3, 1, 0);

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

--
-- Estrutura da tabela `tipaltorc`
--

CREATE TABLE IF NOT EXISTS `tipaltorc` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `alorc_codi` varchar(2) NOT NULL,
  `alorc_desc` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=17 ;

--
-- Extraindo dados da tabela `tipaltorc`
--

INSERT INTO `tipaltorc` (`id`, `alorc_codi`, `alorc_desc`) VALUES
(1, '1', 'Suplementacao por Superavit Financeiro'),
(2, '2', 'Suplementacao por Excesso de Arrecadacao'),
(3, '3', 'Suplementacao por Anulacao de Dotacoes'),
(4, '4', 'Suplementacao por Operacao de Credito'),
(5, '5', 'Creditos Especiais por Superavit Financeiro'),
(6, '6', 'Creditos Especiais por Excesso de Arrecadacao'),
(7, '7', 'Creditos Especiais por Anulacao de Dotacaoes'),
(8, '8', 'Creditos Especiais por Operacao de Credito'),
(9, '9', 'Anulacao de Dotacao Orcamentaria (Lei 4.320/64, Ar'),
(10, '10', 'Limitacao Empenho'),
(11, '11', 'Credito Extraordinario'),
(12, '12', 'Reversao de Limitacao de Empenho'),
(13, '13', 'Correcao de Orcamento'),
(14, '14', 'Anulação de Dotacao Orcamentária para Realocacao ('),
(15, '15', 'Transposicao de Recursos por Anulacao de Dotacao'),
(16, '16', 'Suplementacao - Nova Fonte de Recurso');

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

--
-- Estrutura da tabela `tipo`
--

CREATE TABLE IF NOT EXISTS `tipo` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tip_cod` varchar(4) NOT NULL,
  `tip_des` varchar(50) NOT NULL,
  `tip_tipo` varchar(1) NOT NULL,
  `tip_util` int(2) NOT NULL,
  `tip_perc` decimal(6,2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;

--
-- Extraindo dados da tabela `tipo`
--

INSERT INTO `tipo` (`id`, `tip_cod`, `tip_des`, `tip_tipo`, `tip_util`, `tip_perc`) VALUES
(1, '1', 'Bens Móveis', 'S', 0, '0.00'),
(2, '1001', 'Equipamentos  de Informática', 'N', 5, '20.00'),
(3, '1002', 'Máquinas e Utensílios ', 'N', 10, '10.00'),
(4, '1003', 'Veículos', 'N', 10, '10.00'),
(5, '1004', 'Implementos Agrícolas', 'N', 10, '10.00'),
(6, '1005', 'Móveis de Escritórios', 'N', 10, '10.00'),
(7, '2', 'Bens Imóveis', 'S', 0, '0.00'),
(8, '2001', 'Terrenos', 'N', 0, '0.00'),
(9, '2002', 'Edificações', 'N', 0, '0.00');

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

--
-- Estrutura da tabela `tpo_orgao`
--

CREATE TABLE IF NOT EXISTS `tpo_orgao` (
  `id` int(2) NOT NULL AUTO_INCREMENT,
  `codigo` varchar(2) NOT NULL,
  `descricao` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=15 ;

--
-- Extraindo dados da tabela `tpo_orgao`
--

INSERT INTO `tpo_orgao` (`id`, `codigo`, `descricao`) VALUES
(1, '01', 'Poder Executivo'),
(2, '02', 'Poder Legislativo'),
(3, '03', 'FUNDEF/FUNDEB'),
(4, '04', 'Adm. Direta Fund Especial'),
(5, '05', 'Adm. Indireta  Autarquia'),
(6, '06', 'Adm. Indireta Fundação'),
(7, '07', 'Empresa Públicas'),
(8, '08', 'Sociedade de Economia Mista'),
(9, '09', 'RPPS(Regime de Próprio de Previdência Social)'),
(10, '10', 'FMS - Fundo  Municipal de Saúde'),
(11, '11', 'FMAS - Fundo Municipal de Assistência Social'),
(12, '12', 'FMCA - Fundo Municipal da Criança e do Adolescente'),
(13, '13', 'FMH - Fundo Municipal de Habitação'),
(14, '14', 'FME - Fundo Municipal de Educação');

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

--
-- Estrutura da tabela `unidade`
--

CREATE TABLE IF NOT EXISTS `unidade` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uni_codi` varchar(2) NOT NULL,
  `uni_desc` varchar(100) NOT NULL,
  `uni_orga` varchar(2) NOT NULL,
  `uni_tipo` varchar(1) NOT NULL,
  `uni_ortc` varchar(2) NOT NULL,
  `uni_exer` varchar(4) NOT NULL,
  `cnpjuni` varchar(18) NOT NULL,
  `uni_tiptc` varchar(2) NOT NULL,
  `refuni` varchar(6) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `uniorg` (`uni_codi`,`uni_orga`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=34 ;

--
-- Extraindo dados da tabela `unidade`
--

INSERT INTO `unidade` (`id`, `uni_codi`, `uni_desc`, `uni_orga`, `uni_tipo`, `uni_ortc`, `uni_exer`, `cnpjuni`, `uni_tiptc`, `refuni`) VALUES
(16, '01', 'Camara Municipal de Vicentina', '01', 'F', '01', '2019', '24644544000154', '01', '287822'),
(17, '02', 'Gabinete do Prefeito', '02', 'S', '01', '2018', '', '', ''),
(18, '03', 'Assessoria Jurídica', '02', 'S', '01', '2018', '', '', ''),
(19, '04', 'Secretaria Munic.de Administração e Finanças', '02', 'S', '01', '2018', '', '', ''),
(20, '05', 'Secretaria Munic.de Educação e Desportos', '02', 'S', '01', '2018', '', '', ''),
(21, '07', 'Secretaria Munic.Agricultura,Indústria e Comércio', '02', 'S', '01', '2018', '', '', ''),
(22, '08', 'Secretaria Munic.Obras, Viação e Serv.Urbanos', '02', 'S', '01', '2018', '', '', ''),
(23, '09', 'Secretaria Munic.do Meio Ambiente', '02', 'S', '01', '2018', '', '', ''),
(24, '10', 'Secretaria Munic. Assistência Social', '02', 'S', '01', '2018', '', '', ''),
(25, '06', 'Fundeb', '02', 'S', '03', '2018', '', '', ''),
(26, '11', 'Encargos Gerais do Municipio', '02', 'S', '01', '2018', '', '', ''),
(27, '13', 'Fundo Municipal de Investimento', '02', 'S', '06', '2018', '', '', ''),
(28, '15', 'Fundo Municipal de Saúde', '02', 'F', '10', '2018', '', '', ''),
(29, '16', 'Fundo Municipal dos Dir. da Criança/Adolescente', '02', 'F', '12', '2018', '', '', ''),
(30, '17', 'Fundo Municipal de Assistência Social', '02', 'F', '11', '2018', '', '', ''),
(31, '18', 'Fundo Municipal de Habitação ', '02', 'F', '13', '2018', '', '', ''),
(32, '19', 'Fundo Municipal de Meio Ambiente', '02', 'F', '06', '2018', '', '', ''),
(33, '20', 'Instituto de Previd.Social de Vicentina', '02', 'F', '09', '2019', '09437156000109', '', '287840');

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

--
-- Estrutura da tabela `userunid`
--

CREATE TABLE IF NOT EXISTS `userunid` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_usu` varchar(11) NOT NULL,
  `id_uni` varchar(11) NOT NULL,
  `uni_nome` varchar(40) NOT NULL,
  `periodo` varchar(6) NOT NULL,
  `cdunidade` varchar(2) NOT NULL,
  `cdorgao` varchar(2) NOT NULL,
  `logo` varchar(20) NOT NULL,
  `seqempe` int(6) NOT NULL,
  `seqorde` int(6) NOT NULL,
  `rcl` decimal(16,2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ;

--
-- Extraindo dados da tabela `userunid`
--

INSERT INTO `userunid` (`id`, `id_usu`, `id_uni`, `uni_nome`, `periodo`, `cdunidade`, `cdorgao`, `logo`, `seqempe`, `seqorde`, `rcl`) VALUES
(11, '23', '33', 'Instituto de Previd.Social de Vicentina', '012022', '20', '02', 'logo_vicprev.jpg', 104, 14, '0.00');

/*!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 */;
