                                                       delete from prodserv where psv_codigo >5;
UPDATE OR INSERT INTO PRODSERV (PSV_CODIGO, PSV_DESCRI, PSV_IPPT, PSV_CODNCM, PSV_CEST, PSV_EXTIPI, PSV_STECF, PSV_CSTVENDA, PSV_CSTCOMPRA, PSV_ISSICM, PSV_ICMSC, PSV_CSOSN, PSV_CSOSN_COMPRA, GPS_CODIGO, PSV_USUARG, PSV_ATIVO, PSV_UN, PSV_ALIQPISVENDA, PSV_ALIQCOFINSVENDA, PSV_CSTPISCOFINSVENDA, PSV_QTDMAX, PSV_PESTOQ, PSV_PEDIDO, PSV_ESTMIN, PSV_IPI, PSV_TEMOBS, PSV_QTDEFR, PSV_PERDIS, PSV_RBASCALC, PSV_ULTCUS, PSV_IAT, PSV_PESAVEL, PSV_TERCEIRIZADO, PSV_NATREC, PSV_CNAE, PSV_PRECOMAXIMO, PSV_REDUCAO_BASE_CALCULO_COMPRA) VALUES
(6,'AGUA MINERAL COM GAS','T','22021000','','1','','60','F','0.00','0.00',500.0,null,'2.02',1,1,'CX',0,0,'',1,1,1,0.000,0.00,1,1,0,0.00,0.00,'T',0,0,'','',0.000,0.00);
 UPDATE OR INSERT INTO PRODSERV (PSV_CODIGO, PSV_DESCRI, PSV_IPPT, PSV_CODNCM, PSV_CEST, PSV_EXTIPI, PSV_STECF, PSV_CSTVENDA, PSV_CSTCOMPRA, PSV_ISSICM, PSV_ICMSC, PSV_CSOSN, PSV_CSOSN_COMPRA, GPS_CODIGO, PSV_USUARG, PSV_ATIVO, PSV_UN, PSV_ALIQPISVENDA, PSV_ALIQCOFINSVENDA, PSV_CSTPISCOFINSVENDA, PSV_QTDMAX, PSV_PESTOQ, PSV_PEDIDO, PSV_ESTMIN, PSV_IPI, PSV_TEMOBS, PSV_QTDEFR, PSV_PERDIS, PSV_RBASCALC, PSV_ULTCUS, PSV_IAT, PSV_PESAVEL, PSV_TERCEIRIZADO, PSV_NATREC, PSV_CNAE, PSV_PRECOMAXIMO, PSV_REDUCAO_BASE_CALCULO_COMPRA) VALUES
(7,'AGUA MINERAL SEM GAS','T','22021000','','1','','60','F',0,0,500.0,null,'2',1,1,'UN',0,0,'',1,1,1,0.000,0.00,1,1,0,0.00,0.00,'T',0,0,'','',0.000,0.00);
 UPDATE OR INSERT INTO PRODSERV (PSV_CODIGO, PSV_DESCRI, PSV_IPPT, PSV_CODNCM, PSV_CEST, PSV_EXTIPI, PSV_STECF, PSV_CSTVENDA, PSV_CSTCOMPRA, PSV_ISSICM, PSV_ICMSC, PSV_CSOSN, PSV_CSOSN_COMPRA, GPS_CODIGO, PSV_USUARG, PSV_ATIVO, PSV_UN, PSV_ALIQPISVENDA, PSV_ALIQCOFINSVENDA, PSV_CSTPISCOFINSVENDA, PSV_QTDMAX, PSV_PESTOQ, PSV_PEDIDO, PSV_ESTMIN, PSV_IPI, PSV_TEMOBS, PSV_QTDEFR, PSV_PERDIS, PSV_RBASCALC, PSV_ULTCUS, PSV_IAT, PSV_PESAVEL, PSV_TERCEIRIZADO, PSV_NATREC, PSV_CNAE, PSV_PRECOMAXIMO, PSV_REDUCAO_BASE_CALCULO_COMPRA) VALUES
(8,'COCA COLA 15','T','22021000','','1','','60','F',0,0,500.0,null,'2',1,1,'UN',0,0,'',1,1,1,0.000,0.00,1,1,0,0.00,0.00,'T',0,0,'','',0.000,0.00);
 UPDATE OR INSERT INTO PRODSERV (PSV_CODIGO, PSV_DESCRI, PSV_IPPT, PSV_CODNCM, PSV_CEST, PSV_EXTIPI, PSV_STECF, PSV_CSTVENDA, PSV_CSTCOMPRA, PSV_ISSICM, PSV_ICMSC, PSV_CSOSN, PSV_CSOSN_COMPRA, GPS_CODIGO, PSV_USUARG, PSV_ATIVO, PSV_UN, PSV_ALIQPISVENDA, PSV_ALIQCOFINSVENDA, PSV_CSTPISCOFINSVENDA, PSV_QTDMAX, PSV_PESTOQ, PSV_PEDIDO, PSV_ESTMIN, PSV_IPI, PSV_TEMOBS, PSV_QTDEFR, PSV_PERDIS, PSV_RBASCALC, PSV_ULTCUS, PSV_IAT, PSV_PESAVEL, PSV_TERCEIRIZADO, PSV_NATREC, PSV_CNAE, PSV_PRECOMAXIMO, PSV_REDUCAO_BASE_CALCULO_COMPRA) VALUES
(9,'COCA COLA LATA 310','T','22021000','','1','','60','F',0,0,500.0,null,'2',1,1,'UN',0,0,'',1,1,1,0.000,0.00,1,1,0,0.00,0.00,'T',0,0,'','',0.000,0.00);
 UPDATE OR INSERT INTO PRODSERV (PSV_CODIGO, PSV_DESCRI, PSV_IPPT, PSV_CODNCM, PSV_CEST, PSV_EXTIPI, PSV_STECF, PSV_CSTVENDA, PSV_CSTCOMPRA, PSV_ISSICM, PSV_ICMSC, PSV_CSOSN, PSV_CSOSN_COMPRA, GPS_CODIGO, PSV_USUARG, PSV_ATIVO, PSV_UN, PSV_ALIQPISVENDA, PSV_ALIQCOFINSVENDA, PSV_CSTPISCOFINSVENDA, PSV_QTDMAX, PSV_PESTOQ, PSV_PEDIDO, PSV_ESTMIN, PSV_IPI, PSV_TEMOBS, PSV_QTDEFR, PSV_PERDIS, PSV_RBASCALC, PSV_ULTCUS, PSV_IAT, PSV_PESAVEL, PSV_TERCEIRIZADO, PSV_NATREC, PSV_CNAE, PSV_PRECOMAXIMO, PSV_REDUCAO_BASE_CALCULO_COMPRA) VALUES
(10,'SUCO KAPO','T','22021000','','1','','60','F',0,0,500.0,null,'2',1,1,'UN',0,0,'',1,1,1,0.000,0.00,1,1,0,0.00,0.00,'T',0,0,'','',0.000,0.00);
 UPDATE OR INSERT INTO PRODSERV (PSV_CODIGO, PSV_DESCRI, PSV_IPPT, PSV_CODNCM, PSV_CEST, PSV_EXTIPI, PSV_STECF, PSV_CSTVENDA, PSV_CSTCOMPRA, PSV_ISSICM, PSV_ICMSC, PSV_CSOSN, PSV_CSOSN_COMPRA, GPS_CODIGO, PSV_USUARG, PSV_ATIVO, PSV_UN, PSV_ALIQPISVENDA, PSV_ALIQCOFINSVENDA, PSV_CSTPISCOFINSVENDA, PSV_QTDMAX, PSV_PESTOQ, PSV_PEDIDO, PSV_ESTMIN, PSV_IPI, PSV_TEMOBS, PSV_QTDEFR, PSV_PERDIS, PSV_RBASCALC, PSV_ULTCUS, PSV_IAT, PSV_PESAVEL, PSV_TERCEIRIZADO, PSV_NATREC, PSV_CNAE, PSV_PRECOMAXIMO, PSV_REDUCAO_BASE_CALCULO_COMPRA) VALUES
(11,'GUARANA LATA','T','22021000','','1','','60','F',0,0,500.0,null,'2',1,1,'UN',0,0,'',1,1,1,0.000,0.00,1,1,0,0.00,0.00,'T',0,0,'','',0.000,0.00);
 UPDATE OR INSERT INTO PRODSERV (PSV_CODIGO, PSV_DESCRI, PSV_IPPT, PSV_CODNCM, PSV_CEST, PSV_EXTIPI, PSV_STECF, PSV_CSTVENDA, PSV_CSTCOMPRA, PSV_ISSICM, PSV_ICMSC, PSV_CSOSN, PSV_CSOSN_COMPRA, GPS_CODIGO, PSV_USUARG, PSV_ATIVO, PSV_UN, PSV_ALIQPISVENDA, PSV_ALIQCOFINSVENDA, PSV_CSTPISCOFINSVENDA, PSV_QTDMAX, PSV_PESTOQ, PSV_PEDIDO, PSV_ESTMIN, PSV_IPI, PSV_TEMOBS, PSV_QTDEFR, PSV_PERDIS, PSV_RBASCALC, PSV_ULTCUS, PSV_IAT, PSV_PESAVEL, PSV_TERCEIRIZADO, PSV_NATREC, PSV_CNAE, PSV_PRECOMAXIMO, PSV_REDUCAO_BASE_CALCULO_COMPRA) VALUES
(12,'GUARANA 200 ML','T','22021000','','1','','60','F',0,0,500.0,null,'2',1,1,'UN',0,0,'',1,1,1,0.000,0.00,1,1,0,0.00,0.00,'T',0,0,'','',0.000,0.00);
 UPDATE OR INSERT INTO PRODSERV (PSV_CODIGO, PSV_DESCRI, PSV_IPPT, PSV_CODNCM, PSV_CEST, PSV_EXTIPI, PSV_STECF, PSV_CSTVENDA, PSV_CSTCOMPRA, PSV_ISSICM, PSV_ICMSC, PSV_CSOSN, PSV_CSOSN_COMPRA, GPS_CODIGO, PSV_USUARG, PSV_ATIVO, PSV_UN, PSV_ALIQPISVENDA, PSV_ALIQCOFINSVENDA, PSV_CSTPISCOFINSVENDA, PSV_QTDMAX, PSV_PESTOQ, PSV_PEDIDO, PSV_ESTMIN, PSV_IPI, PSV_TEMOBS, PSV_QTDEFR, PSV_PERDIS, PSV_RBASCALC, PSV_ULTCUS, PSV_IAT, PSV_PESAVEL, PSV_TERCEIRIZADO, PSV_NATREC, PSV_CNAE, PSV_PRECOMAXIMO, PSV_REDUCAO_BASE_CALCULO_COMPRA) VALUES
(13,'GUARANA 600 ML','T','22021000','','1','','60','F',0,0,500.0,null,'2',1,1,'UN',0,0,'',1,1,1,0.000,0.00,1,1,0,0.00,0.00,'T',0,0,'','',0.000,0.00);
 UPDATE OR INSERT INTO PRODSERV (PSV_CODIGO, PSV_DESCRI, PSV_IPPT, PSV_CODNCM, PSV_CEST, PSV_EXTIPI, PSV_STECF, PSV_CSTVENDA, PSV_CSTCOMPRA, PSV_ISSICM, PSV_ICMSC, PSV_CSOSN, PSV_CSOSN_COMPRA, GPS_CODIGO, PSV_USUARG, PSV_ATIVO, PSV_UN, PSV_ALIQPISVENDA, PSV_ALIQCOFINSVENDA, PSV_CSTPISCOFINSVENDA, PSV_QTDMAX, PSV_PESTOQ, PSV_PEDIDO, PSV_ESTMIN, PSV_IPI, PSV_TEMOBS, PSV_QTDEFR, PSV_PERDIS, PSV_RBASCALC, PSV_ULTCUS, PSV_IAT, PSV_PESAVEL, PSV_TERCEIRIZADO, PSV_NATREC, PSV_CNAE, PSV_PRECOMAXIMO, PSV_REDUCAO_BASE_CALCULO_COMPRA) VALUES
(14,'MONSTER','T','22021000','','1','','60','F',0,0,500.0,null,'2',1,1,'UN',0,0,'',1,1,1,0.000,0.00,1,1,0,0.00,0.00,'T',0,0,'','',0.000,0.00);
 UPDATE OR INSERT INTO PRODSERV (PSV_CODIGO, PSV_DESCRI, PSV_IPPT, PSV_CODNCM, PSV_CEST, PSV_EXTIPI, PSV_STECF, PSV_CSTVENDA, PSV_CSTCOMPRA, PSV_ISSICM, PSV_ICMSC, PSV_CSOSN, PSV_CSOSN_COMPRA, GPS_CODIGO, PSV_USUARG, PSV_ATIVO, PSV_UN, PSV_ALIQPISVENDA, PSV_ALIQCOFINSVENDA, PSV_CSTPISCOFINSVENDA, PSV_QTDMAX, PSV_PESTOQ, PSV_PEDIDO, PSV_ESTMIN, PSV_IPI, PSV_TEMOBS, PSV_QTDEFR, PSV_PERDIS, PSV_RBASCALC, PSV_ULTCUS, PSV_IAT, PSV_PESAVEL, PSV_TERCEIRIZADO, PSV_NATREC, PSV_CNAE, PSV_PRECOMAXIMO, PSV_REDUCAO_BASE_CALCULO_COMPRA) VALUES
(15,'H2O LIMAO ML','T','22021000','','1','','60','F',0,0,500.0,null,'2',1,1,'UN',0,0,'',1,1,1,0.000,0.00,1,1,0,0.00,0.00,'T',0,0,'','',0.000,0.00);
 UPDATE OR INSERT INTO PRODSERV (PSV_CODIGO, PSV_DESCRI, PSV_IPPT, PSV_CODNCM, PSV_CEST, PSV_EXTIPI, PSV_STECF, PSV_CSTVENDA, PSV_CSTCOMPRA, PSV_ISSICM, PSV_ICMSC, PSV_CSOSN, PSV_CSOSN_COMPRA, GPS_CODIGO, PSV_USUARG, PSV_ATIVO, PSV_UN, PSV_ALIQPISVENDA, PSV_ALIQCOFINSVENDA, PSV_CSTPISCOFINSVENDA, PSV_QTDMAX, PSV_PESTOQ, PSV_PEDIDO, PSV_ESTMIN, PSV_IPI, PSV_TEMOBS, PSV_QTDEFR, PSV_PERDIS, PSV_RBASCALC, PSV_ULTCUS, PSV_IAT, PSV_PESAVEL, PSV_TERCEIRIZADO, PSV_NATREC, PSV_CNAE, PSV_PRECOMAXIMO, PSV_REDUCAO_BASE_CALCULO_COMPRA) VALUES
(23,'H2O LIMONETO 500 ML','T','22021000','','1','','60','F',0,0,500.0,null,'2',1,1,'UN',0,0,'',1,1,1,0.000,0.00,1,1,0,0.00,0.00,'T',0,0,'','',0.000,0.00);
 UPDATE OR INSERT INTO PRODSERV (PSV_CODIGO, PSV_DESCRI, PSV_IPPT, PSV_CODNCM, PSV_CEST, PSV_EXTIPI, PSV_STECF, PSV_CSTVENDA, PSV_CSTCOMPRA, PSV_ISSICM, PSV_ICMSC, PSV_CSOSN, PSV_CSOSN_COMPRA, GPS_CODIGO, PSV_USUARG, PSV_ATIVO, PSV_UN, PSV_ALIQPISVENDA, PSV_ALIQCOFINSVENDA, PSV_CSTPISCOFINSVENDA, PSV_QTDMAX, PSV_PESTOQ, PSV_PEDIDO, PSV_ESTMIN, PSV_IPI, PSV_TEMOBS, PSV_QTDEFR, PSV_PERDIS, PSV_RBASCALC, PSV_ULTCUS, PSV_IAT, PSV_PESAVEL, PSV_TERCEIRIZADO, PSV_NATREC, PSV_CNAE, PSV_PRECOMAXIMO, PSV_REDUCAO_BASE_CALCULO_COMPRA) VALUES
(24,'GUARANA ANTARCTICA DIT L T 350','T','22021000','','1','','60','F',0,0,500.0,null,'2',1,1,'UN',0,0,'',1,1,1,0.000,0.00,1,1,0,0.00,0.00,'T',0,0,'','',0.000,0.00);
 UPDATE OR INSERT INTO PRODSERV (PSV_CODIGO, PSV_DESCRI, PSV_IPPT, PSV_CODNCM, PSV_CEST, PSV_EXTIPI, PSV_STECF, PSV_CSTVENDA, PSV_CSTCOMPRA, PSV_ISSICM, PSV_ICMSC, PSV_CSOSN, PSV_CSOSN_COMPRA, GPS_CODIGO, PSV_USUARG, PSV_ATIVO, PSV_UN, PSV_ALIQPISVENDA, PSV_ALIQCOFINSVENDA, PSV_CSTPISCOFINSVENDA, PSV_QTDMAX, PSV_PESTOQ, PSV_PEDIDO, PSV_ESTMIN, PSV_IPI, PSV_TEMOBS, PSV_QTDEFR, PSV_PERDIS, PSV_RBASCALC, PSV_ULTCUS, PSV_IAT, PSV_PESAVEL, PSV_TERCEIRIZADO, PSV_NATREC, PSV_CNAE, PSV_PRECOMAXIMO, PSV_REDUCAO_BASE_CALCULO_COMPRA) VALUES
(25,'COPO DESCATAVEL','T','3924100','','1','','F','F',0,0,null,null,'2',1,1,'UN',0,0,'',1,1,1,0.000,0.00,1,1,0,0.00,0.00,'T',0,0,'','',0.000,0.00);
 UPDATE OR INSERT INTO PRODSERV (PSV_CODIGO, PSV_DESCRI, PSV_IPPT, PSV_CODNCM, PSV_CEST, PSV_EXTIPI, PSV_STECF, PSV_CSTVENDA, PSV_CSTCOMPRA, PSV_ISSICM, PSV_ICMSC, PSV_CSOSN, PSV_CSOSN_COMPRA, GPS_CODIGO, PSV_USUARG, PSV_ATIVO, PSV_UN, PSV_ALIQPISVENDA, PSV_ALIQCOFINSVENDA, PSV_CSTPISCOFINSVENDA, PSV_QTDMAX, PSV_PESTOQ, PSV_PEDIDO, PSV_ESTMIN, PSV_IPI, PSV_TEMOBS, PSV_QTDEFR, PSV_PERDIS, PSV_RBASCALC, PSV_ULTCUS, PSV_IAT, PSV_PESAVEL, PSV_TERCEIRIZADO, PSV_NATREC, PSV_CNAE, PSV_PRECOMAXIMO, PSV_REDUCAO_BASE_CALCULO_COMPRA) VALUES
(26,'PAPEL HIGIENICO','T','48181000','','1','','F','F',0,0,null,null,'2',1,1,'UN',0,0,'',1,1,1,0.000,0.00,1,1,0,0.00,0.00,'T',0,0,'','',0.000,0.00);
 UPDATE OR INSERT INTO PRODSERV (PSV_CODIGO, PSV_DESCRI, PSV_IPPT, PSV_CODNCM, PSV_CEST, PSV_EXTIPI, PSV_STECF, PSV_CSTVENDA, PSV_CSTCOMPRA, PSV_ISSICM, PSV_ICMSC, PSV_CSOSN, PSV_CSOSN_COMPRA, GPS_CODIGO, PSV_USUARG, PSV_ATIVO, PSV_UN, PSV_ALIQPISVENDA, PSV_ALIQCOFINSVENDA, PSV_CSTPISCOFINSVENDA, PSV_QTDMAX, PSV_PESTOQ, PSV_PEDIDO, PSV_ESTMIN, PSV_IPI, PSV_TEMOBS, PSV_QTDEFR, PSV_PERDIS, PSV_RBASCALC, PSV_ULTCUS, PSV_IAT, PSV_PESAVEL, PSV_TERCEIRIZADO, PSV_NATREC, PSV_CNAE, PSV_PRECOMAXIMO, PSV_REDUCAO_BASE_CALCULO_COMPRA) VALUES
(27,'DETERGENTE','T','34025000','','1','','F','F',0,0,null,null,'2',1,1,'UN',0,0,'',1,1,1,0.000,0.00,1,1,0,0.00,0.00,'T',0,0,'','',0.000,0.00);
 UPDATE OR INSERT INTO PRODSERV (PSV_CODIGO, PSV_DESCRI, PSV_IPPT, PSV_CODNCM, PSV_CEST, PSV_EXTIPI, PSV_STECF, PSV_CSTVENDA, PSV_CSTCOMPRA, PSV_ISSICM, PSV_ICMSC, PSV_CSOSN, PSV_CSOSN_COMPRA, GPS_CODIGO, PSV_USUARG, PSV_ATIVO, PSV_UN, PSV_ALIQPISVENDA, PSV_ALIQCOFINSVENDA, PSV_CSTPISCOFINSVENDA, PSV_QTDMAX, PSV_PESTOQ, PSV_PEDIDO, PSV_ESTMIN, PSV_IPI, PSV_TEMOBS, PSV_QTDEFR, PSV_PERDIS, PSV_RBASCALC, PSV_ULTCUS, PSV_IAT, PSV_PESAVEL, PSV_TERCEIRIZADO, PSV_NATREC, PSV_CNAE, PSV_PRECOMAXIMO, PSV_REDUCAO_BASE_CALCULO_COMPRA) VALUES
(28,'SABAO EM PO','T','34025000','','1','','F','F',0,0,null,null,'2',1,1,'UN',0,0,'',1,1,1,0.000,0.00,1,1,0,0.00,0.00,'T',0,0,'','',0.000,0.00);
 UPDATE OR INSERT INTO PRODSERV (PSV_CODIGO, PSV_DESCRI, PSV_IPPT, PSV_CODNCM, PSV_CEST, PSV_EXTIPI, PSV_STECF, PSV_CSTVENDA, PSV_CSTCOMPRA, PSV_ISSICM, PSV_ICMSC, PSV_CSOSN, PSV_CSOSN_COMPRA, GPS_CODIGO, PSV_USUARG, PSV_ATIVO, PSV_UN, PSV_ALIQPISVENDA, PSV_ALIQCOFINSVENDA, PSV_CSTPISCOFINSVENDA, PSV_QTDMAX, PSV_PESTOQ, PSV_PEDIDO, PSV_ESTMIN, PSV_IPI, PSV_TEMOBS, PSV_QTDEFR, PSV_PERDIS, PSV_RBASCALC, PSV_ULTCUS, PSV_IAT, PSV_PESAVEL, PSV_TERCEIRIZADO, PSV_NATREC, PSV_CNAE, PSV_PRECOMAXIMO, PSV_REDUCAO_BASE_CALCULO_COMPRA) VALUES
(29,'QBOA CLORO','T','34025000','','1','','F','F',0,0,null,null,'2',1,1,'UN',0,0,'',1,1,1,0.000,0.00,1,1,0,0.00,0.00,'T',0,0,'','',0.000,0.00);
 UPDATE OR INSERT INTO PRODSERV (PSV_CODIGO, PSV_DESCRI, PSV_IPPT, PSV_CODNCM, PSV_CEST, PSV_EXTIPI, PSV_STECF, PSV_CSTVENDA, PSV_CSTCOMPRA, PSV_ISSICM, PSV_ICMSC, PSV_CSOSN, PSV_CSOSN_COMPRA, GPS_CODIGO, PSV_USUARG, PSV_ATIVO, PSV_UN, PSV_ALIQPISVENDA, PSV_ALIQCOFINSVENDA, PSV_CSTPISCOFINSVENDA, PSV_QTDMAX, PSV_PESTOQ, PSV_PEDIDO, PSV_ESTMIN, PSV_IPI, PSV_TEMOBS, PSV_QTDEFR, PSV_PERDIS, PSV_RBASCALC, PSV_ULTCUS, PSV_IAT, PSV_PESAVEL, PSV_TERCEIRIZADO, PSV_NATREC, PSV_CNAE, PSV_PRECOMAXIMO, PSV_REDUCAO_BASE_CALCULO_COMPRA) VALUES
(30,'VEJA','T','','','1','','F','F',0,0,null,null,'2',1,1,'UN',0,0,'',1,1,1,0.000,0.00,1,1,0,0.00,0.00,'T',0,0,'','',0.000,0.00);
 UPDATE OR INSERT INTO PRODSERV (PSV_CODIGO, PSV_DESCRI, PSV_IPPT, PSV_CODNCM, PSV_CEST, PSV_EXTIPI, PSV_STECF, PSV_CSTVENDA, PSV_CSTCOMPRA, PSV_ISSICM, PSV_ICMSC, PSV_CSOSN, PSV_CSOSN_COMPRA, GPS_CODIGO, PSV_USUARG, PSV_ATIVO, PSV_UN, PSV_ALIQPISVENDA, PSV_ALIQCOFINSVENDA, PSV_CSTPISCOFINSVENDA, PSV_QTDMAX, PSV_PESTOQ, PSV_PEDIDO, PSV_ESTMIN, PSV_IPI, PSV_TEMOBS, PSV_QTDEFR, PSV_PERDIS, PSV_RBASCALC, PSV_ULTCUS, PSV_IAT, PSV_PESAVEL, PSV_TERCEIRIZADO, PSV_NATREC, PSV_CNAE, PSV_PRECOMAXIMO, PSV_REDUCAO_BASE_CALCULO_COMPRA) VALUES
(31,'AMACIANTE YPE','T','38099190','','1','','F','F',0,0,null,null,'2',1,1,'UN',0,0,'',1,1,1,0.000,0.00,1,1,0,0.00,0.00,'T',0,0,'','',0.000,0.00);
 UPDATE OR INSERT INTO PRODSERV (PSV_CODIGO, PSV_DESCRI, PSV_IPPT, PSV_CODNCM, PSV_CEST, PSV_EXTIPI, PSV_STECF, PSV_CSTVENDA, PSV_CSTCOMPRA, PSV_ISSICM, PSV_ICMSC, PSV_CSOSN, PSV_CSOSN_COMPRA, GPS_CODIGO, PSV_USUARG, PSV_ATIVO, PSV_UN, PSV_ALIQPISVENDA, PSV_ALIQCOFINSVENDA, PSV_CSTPISCOFINSVENDA, PSV_QTDMAX, PSV_PESTOQ, PSV_PEDIDO, PSV_ESTMIN, PSV_IPI, PSV_TEMOBS, PSV_QTDEFR, PSV_PERDIS, PSV_RBASCALC, PSV_ULTCUS, PSV_IAT, PSV_PESAVEL, PSV_TERCEIRIZADO, PSV_NATREC, PSV_CNAE, PSV_PRECOMAXIMO, PSV_REDUCAO_BASE_CALCULO_COMPRA) VALUES
(32,'LEITE PIRACANJUBA','T','4012010','','1','','F','F',0,0,null,null,'2',1,1,'UN',0,0,'',1,1,1,0.000,0.00,1,1,0,0.00,0.00,'T',0,0,'','',0.000,0.00);
 UPDATE OR INSERT INTO PRODSERV (PSV_CODIGO, PSV_DESCRI, PSV_IPPT, PSV_CODNCM, PSV_CEST, PSV_EXTIPI, PSV_STECF, PSV_CSTVENDA, PSV_CSTCOMPRA, PSV_ISSICM, PSV_ICMSC, PSV_CSOSN, PSV_CSOSN_COMPRA, GPS_CODIGO, PSV_USUARG, PSV_ATIVO, PSV_UN, PSV_ALIQPISVENDA, PSV_ALIQCOFINSVENDA, PSV_CSTPISCOFINSVENDA, PSV_QTDMAX, PSV_PESTOQ, PSV_PEDIDO, PSV_ESTMIN, PSV_IPI, PSV_TEMOBS, PSV_QTDEFR, PSV_PERDIS, PSV_RBASCALC, PSV_ULTCUS, PSV_IAT, PSV_PESAVEL, PSV_TERCEIRIZADO, PSV_NATREC, PSV_CNAE, PSV_PRECOMAXIMO, PSV_REDUCAO_BASE_CALCULO_COMPRA) VALUES
(33,'ACUCAR','T','17011400','','1','','F','F',0,0,null,null,'2',1,1,'UN',0,0,'',1,1,1,0.000,0.00,1,1,0,0.00,0.00,'T',0,0,'','',0.000,0.00);
 UPDATE OR INSERT INTO PRODSERV (PSV_CODIGO, PSV_DESCRI, PSV_IPPT, PSV_CODNCM, PSV_CEST, PSV_EXTIPI, PSV_STECF, PSV_CSTVENDA, PSV_CSTCOMPRA, PSV_ISSICM, PSV_ICMSC, PSV_CSOSN, PSV_CSOSN_COMPRA, GPS_CODIGO, PSV_USUARG, PSV_ATIVO, PSV_UN, PSV_ALIQPISVENDA, PSV_ALIQCOFINSVENDA, PSV_CSTPISCOFINSVENDA, PSV_QTDMAX, PSV_PESTOQ, PSV_PEDIDO, PSV_ESTMIN, PSV_IPI, PSV_TEMOBS, PSV_QTDEFR, PSV_PERDIS, PSV_RBASCALC, PSV_ULTCUS, PSV_IAT, PSV_PESAVEL, PSV_TERCEIRIZADO, PSV_NATREC, PSV_CNAE, PSV_PRECOMAXIMO, PSV_REDUCAO_BASE_CALCULO_COMPRA) VALUES
(34,'CAFE','T','','','1','','F','F',0,0,null,null,'2',1,1,'UN',0,0,'',1,1,1,0.000,0.00,1,1,0,0.00,0.00,'T',0,0,'','',0.000,0.00);
 UPDATE OR INSERT INTO PRODSERV (PSV_CODIGO, PSV_DESCRI, PSV_IPPT, PSV_CODNCM, PSV_CEST, PSV_EXTIPI, PSV_STECF, PSV_CSTVENDA, PSV_CSTCOMPRA, PSV_ISSICM, PSV_ICMSC, PSV_CSOSN, PSV_CSOSN_COMPRA, GPS_CODIGO, PSV_USUARG, PSV_ATIVO, PSV_UN, PSV_ALIQPISVENDA, PSV_ALIQCOFINSVENDA, PSV_CSTPISCOFINSVENDA, PSV_QTDMAX, PSV_PESTOQ, PSV_PEDIDO, PSV_ESTMIN, PSV_IPI, PSV_TEMOBS, PSV_QTDEFR, PSV_PERDIS, PSV_RBASCALC, PSV_ULTCUS, PSV_IAT, PSV_PESAVEL, PSV_TERCEIRIZADO, PSV_NATREC, PSV_CNAE, PSV_PRECOMAXIMO, PSV_REDUCAO_BASE_CALCULO_COMPRA) VALUES
(35,'QUARDANAPO','T','','','1','','F','F',0,0,null,null,'2',1,1,'UN',0,0,'',1,1,1,0.000,0.00,1,1,0,0.00,0.00,'T',0,0,'','',0.000,0.00);
 UPDATE OR INSERT INTO PRODSERV (PSV_CODIGO, PSV_DESCRI, PSV_IPPT, PSV_CODNCM, PSV_CEST, PSV_EXTIPI, PSV_STECF, PSV_CSTVENDA, PSV_CSTCOMPRA, PSV_ISSICM, PSV_ICMSC, PSV_CSOSN, PSV_CSOSN_COMPRA, GPS_CODIGO, PSV_USUARG, PSV_ATIVO, PSV_UN, PSV_ALIQPISVENDA, PSV_ALIQCOFINSVENDA, PSV_CSTPISCOFINSVENDA, PSV_QTDMAX, PSV_PESTOQ, PSV_PEDIDO, PSV_ESTMIN, PSV_IPI, PSV_TEMOBS, PSV_QTDEFR, PSV_PERDIS, PSV_RBASCALC, PSV_ULTCUS, PSV_IAT, PSV_PESAVEL, PSV_TERCEIRIZADO, PSV_NATREC, PSV_CNAE, PSV_PRECOMAXIMO, PSV_REDUCAO_BASE_CALCULO_COMPRA) VALUES
(36,'PAO FATIADO','T','','','1','','F','F',0,0,null,null,'2',1,1,'UN',0,0,'',1,1,1,0.000,0.00,1,1,0,0.00,0.00,'T',0,0,'','',0.000,0.00);
 UPDATE OR INSERT INTO PRODSERV (PSV_CODIGO, PSV_DESCRI, PSV_IPPT, PSV_CODNCM, PSV_CEST, PSV_EXTIPI, PSV_STECF, PSV_CSTVENDA, PSV_CSTCOMPRA, PSV_ISSICM, PSV_ICMSC, PSV_CSOSN, PSV_CSOSN_COMPRA, GPS_CODIGO, PSV_USUARG, PSV_ATIVO, PSV_UN, PSV_ALIQPISVENDA, PSV_ALIQCOFINSVENDA, PSV_CSTPISCOFINSVENDA, PSV_QTDMAX, PSV_PESTOQ, PSV_PEDIDO, PSV_ESTMIN, PSV_IPI, PSV_TEMOBS, PSV_QTDEFR, PSV_PERDIS, PSV_RBASCALC, PSV_ULTCUS, PSV_IAT, PSV_PESAVEL, PSV_TERCEIRIZADO, PSV_NATREC, PSV_CNAE, PSV_PRECOMAXIMO, PSV_REDUCAO_BASE_CALCULO_COMPRA) VALUES
(37,'PRESUNTO MUSSARELA','T','','','1','','F','F',0,0,null,null,'2',1,1,'UN',0,0,'',1,1,1,0.000,0.00,1,1,0,0.00,0.00,'T',0,0,'','',0.000,0.00);
 UPDATE OR INSERT INTO PRODSERV (PSV_CODIGO, PSV_DESCRI, PSV_IPPT, PSV_CODNCM, PSV_CEST, PSV_EXTIPI, PSV_STECF, PSV_CSTVENDA, PSV_CSTCOMPRA, PSV_ISSICM, PSV_ICMSC, PSV_CSOSN, PSV_CSOSN_COMPRA, GPS_CODIGO, PSV_USUARG, PSV_ATIVO, PSV_UN, PSV_ALIQPISVENDA, PSV_ALIQCOFINSVENDA, PSV_CSTPISCOFINSVENDA, PSV_QTDMAX, PSV_PESTOQ, PSV_PEDIDO, PSV_ESTMIN, PSV_IPI, PSV_TEMOBS, PSV_QTDEFR, PSV_PERDIS, PSV_RBASCALC, PSV_ULTCUS, PSV_IAT, PSV_PESAVEL, PSV_TERCEIRIZADO, PSV_NATREC, PSV_CNAE, PSV_PRECOMAXIMO, PSV_REDUCAO_BASE_CALCULO_COMPRA) VALUES
(38,'PAO DE QUEIJO CONGELADO','T','19052090','','1','','F','F',0,0,null,null,'2',1,1,'UN',0,0,'',1,1,1,0.000,0.00,1,1,0,0.00,0.00,'T',0,0,'','',0.000,0.00);
 UPDATE OR INSERT INTO PRODSERV (PSV_CODIGO, PSV_DESCRI, PSV_IPPT, PSV_CODNCM, PSV_CEST, PSV_EXTIPI, PSV_STECF, PSV_CSTVENDA, PSV_CSTCOMPRA, PSV_ISSICM, PSV_ICMSC, PSV_CSOSN, PSV_CSOSN_COMPRA, GPS_CODIGO, PSV_USUARG, PSV_ATIVO, PSV_UN, PSV_ALIQPISVENDA, PSV_ALIQCOFINSVENDA, PSV_CSTPISCOFINSVENDA, PSV_QTDMAX, PSV_PESTOQ, PSV_PEDIDO, PSV_ESTMIN, PSV_IPI, PSV_TEMOBS, PSV_QTDEFR, PSV_PERDIS, PSV_RBASCALC, PSV_ULTCUS, PSV_IAT, PSV_PESAVEL, PSV_TERCEIRIZADO, PSV_NATREC, PSV_CNAE, PSV_PRECOMAXIMO, PSV_REDUCAO_BASE_CALCULO_COMPRA) VALUES
(39,'MARGARINA','T','','','1','','F','F',0,0,null,null,'2',1,1,'UN',0,0,'',1,1,1,0.000,0.00,1,1,0,0.00,0.00,'T',0,0,'','',0.000,0.00);
 UPDATE OR INSERT INTO PRODSERV (PSV_CODIGO, PSV_DESCRI, PSV_IPPT, PSV_CODNCM, PSV_CEST, PSV_EXTIPI, PSV_STECF, PSV_CSTVENDA, PSV_CSTCOMPRA, PSV_ISSICM, PSV_ICMSC, PSV_CSOSN, PSV_CSOSN_COMPRA, GPS_CODIGO, PSV_USUARG, PSV_ATIVO, PSV_UN, PSV_ALIQPISVENDA, PSV_ALIQCOFINSVENDA, PSV_CSTPISCOFINSVENDA, PSV_QTDMAX, PSV_PESTOQ, PSV_PEDIDO, PSV_ESTMIN, PSV_IPI, PSV_TEMOBS, PSV_QTDEFR, PSV_PERDIS, PSV_RBASCALC, PSV_ULTCUS, PSV_IAT, PSV_PESAVEL, PSV_TERCEIRIZADO, PSV_NATREC, PSV_CNAE, PSV_PRECOMAXIMO, PSV_REDUCAO_BASE_CALCULO_COMPRA) VALUES
(40,'DOCES ','T','','','1','','F','F',0,0,null,null,'2',1,1,'UN',0,0,'',1,1,1,0.000,0.00,1,1,0,0.00,0.00,'T',0,0,'','',0.000,0.00);
 UPDATE OR INSERT INTO PRODSERV (PSV_CODIGO, PSV_DESCRI, PSV_IPPT, PSV_CODNCM, PSV_CEST, PSV_EXTIPI, PSV_STECF, PSV_CSTVENDA, PSV_CSTCOMPRA, PSV_ISSICM, PSV_ICMSC, PSV_CSOSN, PSV_CSOSN_COMPRA, GPS_CODIGO, PSV_USUARG, PSV_ATIVO, PSV_UN, PSV_ALIQPISVENDA, PSV_ALIQCOFINSVENDA, PSV_CSTPISCOFINSVENDA, PSV_QTDMAX, PSV_PESTOQ, PSV_PEDIDO, PSV_ESTMIN, PSV_IPI, PSV_TEMOBS, PSV_QTDEFR, PSV_PERDIS, PSV_RBASCALC, PSV_ULTCUS, PSV_IAT, PSV_PESAVEL, PSV_TERCEIRIZADO, PSV_NATREC, PSV_CNAE, PSV_PRECOMAXIMO, PSV_REDUCAO_BASE_CALCULO_COMPRA) VALUES
(41,'REQUEIJAO','T','','','1','','F','F',0,0,null,null,'2',1,1,'UN',0,0,'',1,1,1,0.000,0.00,1,1,0,0.00,0.00,'T',0,0,'','',0.000,0.00);
 UPDATE OR INSERT INTO PRODSERV (PSV_CODIGO, PSV_DESCRI, PSV_IPPT, PSV_CODNCM, PSV_CEST, PSV_EXTIPI, PSV_STECF, PSV_CSTVENDA, PSV_CSTCOMPRA, PSV_ISSICM, PSV_ICMSC, PSV_CSOSN, PSV_CSOSN_COMPRA, GPS_CODIGO, PSV_USUARG, PSV_ATIVO, PSV_UN, PSV_ALIQPISVENDA, PSV_ALIQCOFINSVENDA, PSV_CSTPISCOFINSVENDA, PSV_QTDMAX, PSV_PESTOQ, PSV_PEDIDO, PSV_ESTMIN, PSV_IPI, PSV_TEMOBS, PSV_QTDEFR, PSV_PERDIS, PSV_RBASCALC, PSV_ULTCUS, PSV_IAT, PSV_PESAVEL, PSV_TERCEIRIZADO, PSV_NATREC, PSV_CNAE, PSV_PRECOMAXIMO, PSV_REDUCAO_BASE_CALCULO_COMPRA) VALUES
(42,'DESINFETANTE','T','38089419','','1','','F','F',0,0,null,null,'2',1,1,'UN',0,0,'',1,1,1,0.000,0.00,1,1,0,0.00,0.00,'T',0,0,'','',0.000,0.00);
