create table ISSALIQUOTASIMPLESNACIONAL (
	IDALIQUOTASIMPLESNACIONAL NUMERIC(10,0) NOT NULL,
    DESCRICAO VARCHAR(100) NOT NULL,
    ALIQUOTA NUMERIC(15,2) NOT NULL,
    IRPJ NUMERIC(15,2) NOT NULL,
    CSLL NUMERIC(15,2) NOT NULL,
    COFINS NUMERIC(15,2) NOT NULL,
    PISPASEP NUMERIC(15,2) NOT NULL,
    ISS NUMERIC(15,2) NOT NULL
    CONSTRAINT PK_ISSALIQUOTASIMPLESNACIONAL PRIMARY KEY (IDALIQUOTASIMPLESNACIONAL)
)
#
INSERT INTO ISSALIQUOTASIMPLESNACIONAL (IDALIQUOTASIMPLESNACIONAL, DESCRICAO, ALIQUOTA, IRPJ, CSLL, COFINS, PISPASEP, ISS)
VALUES (1,'Até 180.000,00',4.50,0.00,1.22,1.28,0.00,2.00)
#
INSERT INTO ISSALIQUOTASIMPLESNACIONAL (IDALIQUOTASIMPLESNACIONAL, DESCRICAO, ALIQUOTA, IRPJ, CSLL, COFINS, PISPASEP, ISS)
VALUES (2,'De 180.000,01 a 360.000,00',6.54,0.00,1.84,1.91,0.00,2.79)
#
INSERT INTO ISSALIQUOTASIMPLESNACIONAL (IDALIQUOTASIMPLESNACIONAL, DESCRICAO, ALIQUOTA, IRPJ, CSLL, COFINS, PISPASEP, ISS)
VALUES (3,'De 360.000,01 a 540.000,00',7.70,0.16,1.85,1.95,0.24,3.50)
#
INSERT INTO ISSALIQUOTASIMPLESNACIONAL (IDALIQUOTASIMPLESNACIONAL, DESCRICAO, ALIQUOTA, IRPJ, CSLL, COFINS, PISPASEP, ISS)
VALUES (4,'De 540.000,01 a 720.000,00',8.49,0.52,1.87,1.99,0.27,3.84)
#
INSERT INTO ISSALIQUOTASIMPLESNACIONAL (IDALIQUOTASIMPLESNACIONAL, DESCRICAO, ALIQUOTA, IRPJ, CSLL, COFINS, PISPASEP, ISS)
VALUES (5,'De 720.000,01 a 900.000,00',8.97,0.89,1.89,2.03,0.29,3.87)
#
INSERT INTO ISSALIQUOTASIMPLESNACIONAL (IDALIQUOTASIMPLESNACIONAL, DESCRICAO, ALIQUOTA, IRPJ, CSLL, COFINS, PISPASEP, ISS)
VALUES (6,'De 900.000,01 a 1.080.000,00',9.78,1.25,1.91,2.07,0.32,4.23)
#
INSERT INTO ISSALIQUOTASIMPLESNACIONAL (IDALIQUOTASIMPLESNACIONAL, DESCRICAO, ALIQUOTA, IRPJ, CSLL, COFINS, PISPASEP, ISS)
VALUES (7,'De 1.080.000,01 a 1.260.000,00',10.26,1.62,1.93,2.11,0.34,4.26)
#
INSERT INTO ISSALIQUOTASIMPLESNACIONAL (IDALIQUOTASIMPLESNACIONAL, DESCRICAO, ALIQUOTA, IRPJ, CSLL, COFINS, PISPASEP, ISS)
VALUES (8,'De 1.260.000,01 a 1.440.000,00',10.76,2.00,1.95,2.15,0.35,4.31)
#
INSERT INTO ISSALIQUOTASIMPLESNACIONAL (IDALIQUOTASIMPLESNACIONAL, DESCRICAO, ALIQUOTA, IRPJ, CSLL, COFINS, PISPASEP, ISS)
VALUES (9,'De 1.440.000,01 a 1.620.000,00',11.51,2.37,1.97,2.19,0.37,4.61)
#
INSERT INTO ISSALIQUOTASIMPLESNACIONAL (IDALIQUOTASIMPLESNACIONAL, DESCRICAO, ALIQUOTA, IRPJ, CSLL, COFINS, PISPASEP, ISS)
VALUES (10,'De 1.620.000,01 a 1.800.000,00',12.00,2.74,2.00,2.23,0.38,4.65)
#
INSERT INTO ISSALIQUOTASIMPLESNACIONAL (IDALIQUOTASIMPLESNACIONAL, DESCRICAO, ALIQUOTA, IRPJ, CSLL, COFINS, PISPASEP, ISS)
VALUES (11,'De 1.800.000,01 a 1.980.000,00',12.80,3.12,2.01,2.27,0.40,5.00)
#
INSERT INTO ISSALIQUOTASIMPLESNACIONAL (IDALIQUOTASIMPLESNACIONAL, DESCRICAO, ALIQUOTA, IRPJ, CSLL, COFINS, PISPASEP, ISS)
VALUES (12,'De 1.980.000,01 a 2.160.000,00',13.25,3.49,2.03,2.31,0.42,5.00)
#
INSERT INTO ISSALIQUOTASIMPLESNACIONAL (IDALIQUOTASIMPLESNACIONAL, DESCRICAO, ALIQUOTA, IRPJ, CSLL, COFINS, PISPASEP, ISS)
VALUES (13,'De 2.160.000,01 a 2.340.000,00',13.70,3.86,2.05,2.35,0.44,5.00)
#
INSERT INTO ISSALIQUOTASIMPLESNACIONAL (IDALIQUOTASIMPLESNACIONAL, DESCRICAO, ALIQUOTA, IRPJ, CSLL, COFINS, PISPASEP, ISS)
VALUES (14,'De 2.340.000,01 a 2.520.000,00',14.15,4.23,2.07,2.39,0.46,5.00)
#
INSERT INTO ISSALIQUOTASIMPLESNACIONAL (IDALIQUOTASIMPLESNACIONAL, DESCRICAO, ALIQUOTA, IRPJ, CSLL, COFINS, PISPASEP, ISS)
VALUES (15,'De 2.520.000,01 a 2.700.000,00',14.60,4.60,2.10,2.43,0.47,5.00)
#
INSERT INTO ISSALIQUOTASIMPLESNACIONAL (IDALIQUOTASIMPLESNACIONAL, DESCRICAO, ALIQUOTA, IRPJ, CSLL, COFINS, PISPASEP, ISS)
VALUES (16,'De 2.700.000,01 a 2.880.000,00',15.05,4.90,2.19,2.47,0.49,5.00)
#
INSERT INTO ISSALIQUOTASIMPLESNACIONAL (IDALIQUOTASIMPLESNACIONAL, DESCRICAO, ALIQUOTA, IRPJ, CSLL, COFINS, PISPASEP, ISS)
VALUES (17,'De 2.880.000,01 a 3.060.000,00',15.50,5.21,2.27,2.51,0.51,5.00)
#
INSERT INTO ISSALIQUOTASIMPLESNACIONAL (IDALIQUOTASIMPLESNACIONAL, DESCRICAO, ALIQUOTA, IRPJ, CSLL, COFINS, PISPASEP, ISS)
VALUES (18,'De 3.060.000,01 a 3.240.000,00',15.95,5.51,2.36,2.55,0.53,5.00)
#
INSERT INTO ISSALIQUOTASIMPLESNACIONAL (IDALIQUOTASIMPLESNACIONAL, DESCRICAO, ALIQUOTA, IRPJ, CSLL, COFINS, PISPASEP, ISS)
VALUES (19,'De 3.240.000,01 a 3.420.000,00',16.40,5.81,2.45,2.59,0.55,5.00)
#
INSERT INTO ISSALIQUOTASIMPLESNACIONAL (IDALIQUOTASIMPLESNACIONAL, DESCRICAO, ALIQUOTA, IRPJ, CSLL, COFINS, PISPASEP, ISS)
VALUES (20,'De 3.420.000,01 a 3.600.000,00',16.85,6.12,2.53,2.63,0.57,5.00)
#