INSERT INTO `ncm` (`codNcm`,`descricao`,`pInternacional`,`pNacional`,`pEstadual`,`pMunicipal`) VALUES 
 ('90200090','OUTROS APARELHOS RESPIRATORIOS','0.00','0.00','0.00','0.00'),
 ('90211110','PROTESES ARTICULARES,FEMURAIS','0.00','0.00','0.00','0.00'),
 ('90211120','PROTESES ARTICULARES,MIOLETRICAS','0.00','0.00','0.00','0.00'),
 ('90211190','OUTRAS PROTESES ARTICULARES','0.00','0.00','0.00','0.00'),
 ('90211910','ARTIGOS E APARELHOS ORTOPEDICOS','0.00','0.00','0.00','0.00'),
 ('90211920','ARTIGOS E APARELHOS PARA FRATURAS','0.00','0.00','0.00','0.00'),
 ('90211991','PARTES E ACESSDE ARTIGOS E APARSORTOPEDIA,ARTICULA','0.00','0.00','0.00','0.00'),
 ('90211999','OUTSPARTES E ACESSDE PROTESES ARTICUL/APARSORTOPED','0.00','0.00','0.00','0.00'),
 ('90212110','DENTES ARTIFICIAIS DE ACRILICO','0.00','0.00','0.00','0.00'),
 ('90212190','OUTROS DENTES ARTIFICIAIS EXCDE ACRILICO','0.00','0.00','0.00','0.00'),
 ('90212900','OUTROS ARTIGOS E APARELHOS DE PROTESE DENTARIA','0.00','0.00','0.00','0.00'),
 ('90213011','VALVULAS CARDIACAS MECANICAS','0.00','0.00','0.00','0.00'),
 ('90213019','VALVULAS CARDIACAS EXCETO AS MECANICAS','0.00','0.00','0.00','0.00'),
 ('90213020','LENTES INTRAOCULARES','0.00','0.00','0.00','0.00'),
 ('90213030','PROTESES DE ARTERIAS VASCULARES REVESTIDAS','0.00','0.00','0.00','0.00'),
 ('90213040','PROTESES MAMARIAS NAO IMPLANTAVEIS','0.00','0.00','0.00','0.00'),
 ('90213080','OUTROS ARTIGOS E APARELHOS DE PROTESE','0.00','0.00','0.00','0.00'),
 ('90213091','PARTES DE PROTESES MODULARES SUBSTMEMBROS SUPERINF','0.00','0.00','0.00','0.00'),
 ('90213099','PARTES E ACESSDE OUTROS ARTIGOS E APARELHOS DE PRO','0.00','0.00','0.00','0.00'),
 ('90214000','APARSP/FACILITAR A AUDICAO DE SURDOS,EXCPARTES/ACE','0.00','0.00','0.00','0.00'),
 ('90215000','MARCA-PASSOS CARDIACOS,EXCPARTES E ACESS','0.00','0.00','0.00','0.00'),
 ('90219011','CARDIODESFIBRILADOR AUTOMATICO','0.00','0.00','0.00','0.00'),
 ('90219019','OUTSAPARSIMPLANTORGANP/COMPENSAR DEFEITO/INCAPACID','0.00','0.00','0.00','0.00'),
 ('90219080','OUTSAPARELHOS P/COMPENSAR DEFICIENCIAS OU ENFERMID','0.00','0.00','0.00','0.00'),
 ('90219091','PARTES E ACESSDE MARCA-PASSOS CARDIACOS','0.00','0.00','0.00','0.00'),
 ('90219092','PARTES E ACESSDE APARSP/FACILITAR AUDICAO DOS SURD','0.00','0.00','0.00','0.00'),
 ('90219099','PARTES E ACESSDE ARTIGOS/APARSP/COMPENSAR DEFICIEN','0.00','0.00','0.00','0.00'),
 ('90221200','APARELHOS DE TOMOGRAFIA COMPUTADORIZADA','0.00','0.00','0.00','0.00'),
 ('90221311','APARSDE RAIOS X,DE DIAGNOSTDE TOMADA MAXILAR PANOR','0.00','0.00','0.00','0.00'),
 ('90221319','OUTROS APARELHOS DE RAIOS X,P/DIAGNOSTICO ODONTOLO','0.00','0.00','0.00','0.00'),
 ('90221390','OUTROS APARELHOS DE RAIOS X,PARA ODONTOLOGIA','0.00','0.00','0.00','0.00'),
 ('90221411','APARELHOS DE RAIOS X,DE DIAGNOSTP/MAMOGRAFIA','0.00','0.00','0.00','0.00'),
 ('90221412','APARELHOS DE RAIOS X,DE DIAGNOSTP/ANGIOGRAFIA','0.00','0.00','0.00','0.00'),
 ('90221413','APARSCOMPUTADORIZDE DIAGNOSTICO,P/DENSITOMETRIA OS','0.00','0.00','0.00','0.00'),
 ('90221419','OUTSAPARELHOS DE RAIOS X,P/DIAGNOSTMEDICO,CIRURGET','0.00','0.00','0.00','0.00'),
 ('90221490','OUTSAPARSDE RAIOS X,P/USO MEDICO,CIRURGICO,VETERIN','0.00','0.00','0.00','0.00'),
 ('90221910','ESPECTROMETROS OU ESPECTROGRAFOS,DE RAIOS X','0.00','0.00','0.00','0.00'),
 ('90221990','OUTSAPARELHOS DE RAIOS X,P/RADIOFOTOGRAFIA/RADIOTE','0.00','0.00','0.00','0.00'),
 ('90222110','APARSDE RADIOCOBALTO (BOMBA DE COBALTO),USO MEDICO','0.00','0.00','0.00','0.00'),
 ('90222120','APARELHOS DE GAMATERAPIA P/USO MEDICO,CIRURGICO,ET','0.00','0.00','0.00','0.00'),
 ('90222190','OUTSAPARSDE RADIACAO ALFA/BETA/GAMA,P/USO MEDICO,E','0.00','0.00','0.00','0.00'),
 ('90222900','OUTROS APARELHOS DE RADIACAO ALFA,BETA OU GAMA','0.00','0.00','0.00','0.00'),
 ('90223000','TUBOS DE RAIOS X','0.00','0.00','0.00','0.00'),
 ('90229011','GERADORES DE TENSAO,P/APARSDE RAIOS X/OUTRAS RADIA','0.00','0.00','0.00','0.00'),
 ('90229012','TELAS RADIOLOGICAS P/APARSDE RAIOS X/OUTRAS RADIAC','0.00','0.00','0.00','0.00'),
 ('90229019','OUTROS APARELHOS GERADORES DE RAIOS X','0.00','0.00','0.00','0.00'),
 ('90229080','OUTROS DISPOSITIVOS GERADORES DE RAIOS X','0.00','0.00','0.00','0.00'),
 ('90229090','PARTES E ACESSP/APARSDE RAIOS X/OUTRAS RADIACOES,E','0.00','0.00','0.00','0.00'),
 ('90230000','INSTRUMENTOS,APARSE MODELOS P/DEMONSTRACAO ENSINO,','0.00','0.00','0.00','0.00'),
 ('90241010','MAQSE APARSP/ENSAIOS DE TRACAO/COMPRESSAO DE METAI','0.00','0.00','0.00','0.00'),
 ('90241020','MAQUINAS E APARELHOS P/ENSAIOS DE DUREZA DE METAIS','0.00','0.00','0.00','0.00'),
 ('90241090','MAQUINAS E APARELHOS P/OUTROS ENSAIOS DE METAIS','0.00','0.00','0.00','0.00'),
 ('90248011','MAQUINAS E APARELHOS P/ENSAIO DE FIOS TEXTEIS,AUTO','0.00','0.00','0.00','0.00'),
 ('90248019','OUTRAS MAQUINAS E APARELHOS P/ENSAIOS DE TEXTEIS','0.00','0.00','0.00','0.00'),
 ('90248020','MAQUINAS E APARSP/ENSAIOS DE PAPEIS,CARTAO,LINOLEO','0.00','0.00','0.00','0.00'),
 ('90248090','OUTSMAQSE APARSP/ENSAIOS DE DUREZA,ETCDE MATERIAIS','0.00','0.00','0.00','0.00'),
 ('90249000','PARTES E ACESSDE MAQSE APARSP/ENSAIOS DE DUREZA,ET','0.00','0.00','0.00','0.00'),
 ('90251110','TERMOMETROS CLINICOS,DE LIQUIDO,DE LEITURA DIRETA','0.00','0.00','0.00','0.00'),
 ('90251190','OUTROS TERMOMETROS E PIROMETROS,DE LIQUIDO,LEITURA','0.00','0.00','0.00','0.00'),
 ('90251910','PIROMETROS OPTICOS','0.00','0.00','0.00','0.00'),
 ('90251990','OUTROS TERMOMETROS E PIROMETROS','0.00','0.00','0.00','0.00'),
 ('90258000','DENSIMETROS,AREOMETROS,HIGROMETROS E OUTSINSTRUMEN','0.00','0.00','0.00','0.00'),
 ('90259010','PARTES E ACESSDE TERMOMETROS','0.00','0.00','0.00','0.00'),
 ('90259090','PARTES E ACESSDE DENSIMETROS E OUTROS INSTRUMENTOS','0.00','0.00','0.00','0.00'),
 ('90261011','MEDIDOR-TRANSMISSOR ELETRONINDUCELETROMAGNETDE VAZ','0.00','0.00','0.00','0.00'),
 ('90261019','OUTROS INSTRUMENTOS E APARSP/MEDIDA/CONTROLE DE VA','0.00','0.00','0.00','0.00'),
 ('90261020','INSTRUMENTOS E APARELHOS P/MEDIDA/CONTROLE DO NIVE','0.00','0.00','0.00','0.00'),
 ('90262010','MANOMETROS','0.00','0.00','0.00','0.00'),
 ('90262090','OUTSINSTRUMENTOS E APARSP/MEDIDA/CONTROLE DA PRESS','0.00','0.00','0.00','0.00'),
 ('90268000','OUTSINSTRUMENTOS E APARSP/MEDIDA/CONTROLE DE LIQET','0.00','0.00','0.00','0.00'),
 ('90269010','PARTES E ACESSP/INSTRUME APARSMEDIDA/CONTROLE NIVE','0.00','0.00','0.00','0.00'),
 ('90269020','PARTES E ACESSP/MANOMETROS','0.00','0.00','0.00','0.00'),
 ('90269090','PARTES E ACESSP/OUTSINSTRUME APARSDE MEDIDA/CONTRO','0.00','0.00','0.00','0.00'),
 ('90271000','ANALISADORES DE GASES OU DE FUMACA (FUMO)','0.00','0.00','0.00','0.00'),
 ('90272011','CROMATOGRAFOS DE FASE GASOSA','0.00','0.00','0.00','0.00'),
 ('90272012','CROMATOGRAFOS DE FASE LIQUIDA','0.00','0.00','0.00','0.00'),
 ('90272019','OUTROS CROMATOGRAFOS','0.00','0.00','0.00','0.00'),
 ('90272020','APARELHOS DE ELETROFORESE','0.00','0.00','0.00','0.00'),
 ('90273011','ESPECTROMETROS DE EMISSAO OPTICA (EMISSAO ATOMICA)','0.00','0.00','0.00','0.00'),
 ('90273019','OUTROS ESPECTROMETROS','0.00','0.00','0.00','0.00'),
 ('90273021','ESPECTROFOTOMETROS DE RADIACOES UV,VISIVEIS E IV','0.00','0.00','0.00','0.00'),
 ('90273022','ESPECTROFOTOMETROS DE ABSORCAO ATOMICA','0.00','0.00','0.00','0.00'),
 ('90273023','ESPECTROFOTOMETROS DE EMISSAO OPTICA (EMISSAO ATOM','0.00','0.00','0.00','0.00'),
 ('90273029','OUTROS ESPECTROFOTOMETROS','0.00','0.00','0.00','0.00'),
 ('90273031','ESPECTROGRAFOS DE EMISSAO OPTICA (EMISSAO ATOMICA)','0.00','0.00','0.00','0.00'),
 ('90273039','OUTROS ESPECTROGRAFOS','0.00','0.00','0.00','0.00'),
 ('90274000','INDICADORES DE TEMPO DE EXPOSICAO','0.00','0.00','0.00','0.00'),
 ('90275010','COLORIMETROS','0.00','0.00','0.00','0.00'),
 ('90275020','FOTOMETROS','0.00','0.00','0.00','0.00'),
 ('90275030','REFRATOMETROS','0.00','0.00','0.00','0.00'),
 ('90275040','SACARIMETROS','0.00','0.00','0.00','0.00'),
 ('90275090','OUTSINSTRUMENTOS E APARSQUE UTILIZRADIACOES OPTICA','0.00','0.00','0.00','0.00'),
 ('90278011','CALORIMETROS','0.00','0.00','0.00','0.00'),
 ('90278012','VISCOSIMETROS','0.00','0.00','0.00','0.00'),
 ('90278013','DENSITOMETROS','0.00','0.00','0.00','0.00'),
 ('90278014','APARELHOS MEDIDORES DE PH','0.00','0.00','0.00','0.00'),
 ('90278020','ESPECTROMETROS DE MASSA','0.00','0.00','0.00','0.00'),
 ('90278030','POLAROGRAFOS','0.00','0.00','0.00','0.00'),
 ('90278090','OUTSINSTRUMENTOS E APARSP/ANALISE/ENSAIO/MEDIDA,ET','0.00','0.00','0.00','0.00'),
 ('90279010','MICROTOMOS','0.00','0.00','0.00','0.00'),
 ('90279091','PARTES E ACESSP/ESPECTROMETROS DE EMISSAO OPTICA','0.00','0.00','0.00','0.00'),
 ('90279092','PARTES E ACESSP/ESPECTROGRAFOS DE EMISSAO OPTICA','0.00','0.00','0.00','0.00'),
 ('90279093','PARTES E ACESSP/POLAROGRAFOS','0.00','0.00','0.00','0.00'),
 ('90279099','PARTES E ACESSP/OUTSINSTRUME APARSP/ANALISE,ETC','0.00','0.00','0.00','0.00'),
 ('90281010','CONTADORES DE GAS NATURAL COMPRIMIDO,ELETRONICOS','0.00','0.00','0.00','0.00'),
 ('90281090','OUTROS CONTADORES DE GASES','0.00','0.00','0.00','0.00'),
 ('90282010','CONTADORES DE LIQUIDOS,PESO<=50KG','0.00','0.00','0.00','0.00'),
 ('90282020','CONTADORES DE LIQUIDOS,PESO>50KG','0.00','0.00','0.00','0.00'),
 ('90283011','CONTADORES MONOFASICOS,P/CORRELETRALTERNADA,DIGITA','0.00','0.00','0.00','0.00'),
 ('90283019','OUTROS CONTADORES MONOFASICOS,P/CORRELETRALTERNADA','0.00','0.00','0.00','0.00'),
 ('90283021','CONTADORES BIFASICOS DE ELETRICIDADE,DIGITAIS','0.00','0.00','0.00','0.00'),
 ('90283029','OUTROS CONTADORES BIFASICOS DE ELETRICIDADE','0.00','0.00','0.00','0.00'),
 ('90283031','CONTADORES TRIFASICOS DE ELETRICIDADE,DIGITAIS','0.00','0.00','0.00','0.00'),
 ('90283039','OUTROS CONTADORES TRIFASICOS DE ELETRICIDADE','0.00','0.00','0.00','0.00'),
 ('90283090','OUTROS CONTADORES DE ELETRICIDADE','0.00','0.00','0.00','0.00'),
 ('90289010','PARTES E ACESSP/CONTADORES DE ELETRICIDADE','0.00','0.00','0.00','0.00'),
 ('90289090','PARTES E ACESSP/CONTADORES DE GASES/LIQUIDOS','0.00','0.00','0.00','0.00'),
 ('90291010','CONTADORES DE VOLTAS OU DE PRODUCAO/HORAS DE TRABA','0.00','0.00','0.00','0.00'),
 ('90291090','TAXIMETROS,TOTALIZADORES DE CAMINHO PERCORRIDO,ETC','0.00','0.00','0.00','0.00'),
 ('90292010','INDICADORES DE VELOCIDADE E TACOMETROS','0.00','0.00','0.00','0.00'),
 ('90292020','ESTROBOSCOPIOS','0.00','0.00','0.00','0.00'),
 ('90299010','PARTES E ACESSP/INDICADORES DE VELOCIDADE/TACOMETR','0.00','0.00','0.00','0.00'),
 ('90299090','PARTES E ACESSP/OUTROS CONTADORES/ESTROBOSCOPIOS','0.00','0.00','0.00','0.00'),
 ('90301010','MEDIDORES DE RADIOATIVIDADE','0.00','0.00','0.00','0.00'),
 ('90301090','OUTSINSTRUMENTOS E APARSP/MEDIDA RADIACOES IONIZAN','0.00','0.00','0.00','0.00'),
 ('90302010','OLCILOSCOPIOS CATODICOS,DIGITAIS','0.00','0.00','0.00','0.00'),
 ('90302021','OLCILOSCOPIOS CATODICOS ANALOGICOS,FREQUENCIA>=60M','0.00','0.00','0.00','0.00'),
 ('90302022','VETORSCOPIOS (OSCILOSCOPIOS ANALOGICOS CATODICOS)','0.00','0.00','0.00','0.00'),
 ('90302029','OUTROS OLCILOSCOPIOS CATODICOS ANALOGICOS','0.00','0.00','0.00','0.00'),
 ('90302030','OSCILOGRAFOS CATODICOS','0.00','0.00','0.00','0.00'),
 ('90303100','MULTIMETROS SEM DISPOSITIVO REGISTRADOR','0.00','0.00','0.00','0.00'),
 ('90303911','VOLTIMETROS DIGITAIS,SEM DISPOSITIVO REGISTRADOR','0.00','0.00','0.00','0.00'),
 ('90303919','OUTROS VOLTIMETROS SEM DISPOSITIVO REGISTRADOR','0.00','0.00','0.00','0.00'),
 ('90303921','AMPERIMETROS SEM DISPOSITREGISTRADOR,P/VEICAUTOMOV','0.00','0.00','0.00','0.00'),
 ('90303929','OUTROS AMPERIMETROS SEM DISPOSITIVO REGISTRADOR','0.00','0.00','0.00','0.00'),
 ('90303990','OUTROS APARELHOS E INSTRUMP/MEDIDA/CONTROLE TENSAO','0.00','0.00','0.00','0.00'),
 ('90304010','ANALISADORES DE PROTOCOLO,PARA TELECOMUNICACAO','0.00','0.00','0.00','0.00'),
 ('90304020','ANALISADORES DE NIVEL SELETIVO,PARA TELECOMUNICACA','0.00','0.00','0.00','0.00'),
 ('90304030','ANALISADORES DIGITAIS DE TRANSMISSAO,P/TELECOMUNIC','0.00','0.00','0.00','0.00'),
 ('90304090','OUTROS INSTRUMENTOS E APARELHOS P/TELECOMUNICACAO','0.00','0.00','0.00','0.00'),
 ('90308210','INSTRUMENTOS E APARSP/TESTES DE CIRCUITOS INTEGRAD','0.00','0.00','0.00','0.00'),
 ('90308290','OUTSINSTRUMENTOS E APARSP/MEDIDA/CONTROLE DISCOS,E','0.00','0.00','0.00','0.00'),
 ('90308310','APARSDE TESTE DE CONTINDE CIRCUITIMPRESSO,C/DISPRE','0.00','0.00','0.00','0.00'),
 ('90308320','APARSDE TESTE AUTOMATCIRCUITIMPRESSO,MONTC/DISPREG','0.00','0.00','0.00','0.00'),
 ('90308330','APARSDE MEDIDA DE PARAMDE SINAIS DE TV,ETCC/DISPRE','0.00','0.00','0.00','0.00'),
 ('90308390','OUTSINSTRUME APARSP/MEDIDA/CONTROLE ELETRC/DISPOSI','0.00','0.00','0.00','0.00'),
 ('90308910','ANALISADORES LOGICOS DE CIRCUITOS DIGITAIS','0.00','0.00','0.00','0.00'),
 ('90308920','ANALISADORES DE ESPECTRO DE FREQUENCIA','0.00','0.00','0.00','0.00'),
 ('90308930','FREQUENCIMETROS','0.00','0.00','0.00','0.00'),
 ('90308940','FASIMETROS','0.00','0.00','0.00','0.00'),
 ('90308990','OUTROS INSTRUMENTOS E APARSP/MEDIDA/CONTROLE ELETR','0.00','0.00','0.00','0.00'),
 ('90309010','PARTES E ACESSP/APARSDE MEDIDA,ETCRADIACAO IONIZAN','0.00','0.00','0.00','0.00'),
 ('90309020','PARTES E ACESSP/APARSDE MEDIDA,ETCELETRSEM DISPREG','0.00','0.00','0.00','0.00'),
 ('90309030','PARTES E ACESSP/APARSDE MEDIDA,ETCSEMICOND/DISPREG','0.00','0.00','0.00','0.00'),
 ('90309090','PARTES E ACESSP/OSCILOSCOPIOS,OSCILOGRAFOS,ETC','0.00','0.00','0.00','0.00'),
 ('90311000','MAQUINAS DE EQUILIBRAR PECAS MECANICAS','0.00','0.00','0.00','0.00'),
 ('90312010','BANCOS DE ENSAIO P/MOTORES','0.00','0.00','0.00','0.00'),
 ('90312090','OUTROS BANCOS DE ENSAIO,EXCP/MOTORES','0.00','0.00','0.00','0.00'),
 ('90313000','PROJETORES DE PERFIS','0.00','0.00','0.00','0.00'),
 ('90314100','INSTRUMENTOS E APARSOPTICOS,P/CONTROLE DE DISCOS,E','0.00','0.00','0.00','0.00'),
 ('90314900','OUTROS INSTRUMENTOS E APARELHOS OPTICOS','0.00','0.00','0.00','0.00'),
 ('90318011','DINAMOMETROS','0.00','0.00','0.00','0.00'),
 ('90318012','RUGOSIMETROS','0.00','0.00','0.00','0.00'),
 ('90318020','MAQUINAS P/MEDICAO TRIDIMENSIONAL','0.00','0.00','0.00','0.00'),
 ('90318030','METROS PADROES','0.00','0.00','0.00','0.00'),
 ('90318040','APARSDIGITAIS UTILEM AUTOMOVEIS (COMPUTADOR DE BOR','0.00','0.00','0.00','0.00'),
 ('90318050','APARELHOS PARA ANALISE DE TEXTEIS,COMPUTADORIZADOS','0.00','0.00','0.00','0.00'),
 ('90318060','CELULAS DE CARGA','0.00','0.00','0.00','0.00'),
 ('90318090','OUTROS INSTRUMENTOS,APARELHOS E MAQSDE MEDIDA/CONT','0.00','0.00','0.00','0.00'),
 ('90319010','PARTES E ACESSP/BANCOS DE ENSAIO','0.00','0.00','0.00','0.00'),
 ('90319090','PARTES E ACESSP/OUTROS INSTRUME APARSMEDIDA/CONTRO','0.00','0.00','0.00','0.00'),
 ('90321010','TERMOSTATOS AUTOMATICOS,DE EXPANSAO DE FLUIDOS','0.00','0.00','0.00','0.00'),
 ('90321090','OUTROS TERMOSTATOS AUTOMATICOS','0.00','0.00','0.00','0.00'),
 ('90322000','MANOSTATOS AUTOMATICOS (PRESSOSTATOS)','0.00','0.00','0.00','0.00'),
 ('90328100','INSTRUMENTOS E APARSHIDRAULICOS/PNEUMATICOS,AUTOMA','0.00','0.00','0.00','0.00'),
 ('90328911','REGULADORES ELETRONICOS,DE VOLTAGEM,AUTOMATICOS','0.00','0.00','0.00','0.00'),
 ('90328919','OUTROS REGULADORES DE VOLTAGEM,AUTOMATICOS','0.00','0.00','0.00','0.00'),
 ('90328921','CONTROLADORES ELETRONP/SISTANTIBLOQDE FREIO,AUTOMA','0.00','0.00','0.00','0.00'),
 ('90328922','CONTROLADORES ELETRONP/SISTDE SUSPENSAO,AUTOMATICO','0.00','0.00','0.00','0.00'),
 ('90328923','CONTROLADORES ELETRONP/SISTDE TRANSMISSAO,AUTOMATI','0.00','0.00','0.00','0.00'),
 ('90328924','CONTROLADORES ELETRONP/SISTDE IGNICAO,AUTOMATICOS','0.00','0.00','0.00','0.00'),
 ('90328925','CONTROLADORES ELETRONP/SISTDE INJECAO,AUTOMATICOS','0.00','0.00','0.00','0.00'),
 ('90328929','OUTROS CONTROLADORES ELETRONAUTOMATP/VEICAUTOMOVEI','0.00','0.00','0.00','0.00'),
 ('90328930','EQUIPAMENTO DIGITAL AUTOMATP/CONTROLE DE VEICFERRO','0.00','0.00','0.00','0.00'),
 ('90328981','INSTRUMENTOS E APARELHOS AUTOMATP/CONTROLE DE PRES','0.00','0.00','0.00','0.00'),
 ('90328982','INSTRUMENTOS E APARSAUTOMATP/CONTROLE DE TEMPERATU','0.00','0.00','0.00','0.00'),
 ('90328983','INSTRUMENTOS E APARELHOS AUTOMATP/CONTROLE DE UMID','0.00','0.00','0.00','0.00'),
 ('90328984','INSTRUMENTOS E APARSAUTOMATP/CONTROLE VELOCIDMOTOR','0.00','0.00','0.00','0.00'),
 ('90328989','OUTSINSTRUME APARSAUTOMATP/CONTROLE GRANDEZN/ELETR','0.00','0.00','0.00','0.00'),
 ('90328990','OUTSINSTRUMENTOS E APARSAUTOMATP/REGULACAO/CONTROL','0.00','0.00','0.00','0.00'),
 ('90329010','CIRCUITO IMPRESSO MONTADO,P/APARSAUTOMATREGULACAO,','0.00','0.00','0.00','0.00'),
 ('90329091','PARTES E ACESSP/TERMOSTATOS AUTOMATICOS','0.00','0.00','0.00','0.00'),
 ('90329099','PARTES E ACESSP/OUTSAPARELHOS AUTOMATP/REGULACAO,E','0.00','0.00','0.00','0.00'),
 ('90330000','PARTES E ACESSP/OUTSMAQSAPARSINSTRUMDE OPTICA,ETC','0.00','0.00','0.00','0.00'),
 ('91011100','RELOGIO DE PULSO,CXMETPRECFUNCELETRMOSTRMECAN','0.00','0.00','0.00','0.00'),
 ('91011200','RELOGIO DE PULSO,CXMETPRECFUNCELETRMOSTROPTOELETR','0.00','0.00','0.00','0.00'),
 ('91011900','OUTSRELOGIOS DE PULSO,CXDE METAL PRECETCFUNCELETR','0.00','0.00','0.00','0.00'),
 ('91012100','RELOGIO DE PULSO,CXMETPRECETCCORDA AUTOMAT','0.00','0.00','0.00','0.00'),
 ('91012900','OUTROS RELOGIOS DE PULSO,CXMETAL PRECETC','0.00','0.00','0.00','0.00'),
 ('91019100','RELOGIO DE BOLSO,SEMELHCXMETPRECETCFUNCELETR','0.00','0.00','0.00','0.00'),
 ('91019900','OUTROS RELOGIOS DE BOLSO,SEMELHCXMETAL PRECETC','0.00','0.00','0.00','0.00'),
 ('91021110','RELOGIO DE PULSO,CXMETCOMUM,FUNCELETRMOSTRMECAN','0.00','0.00','0.00','0.00'),
 ('91021190','OUTROS RELOGIOS DE PULSO,FUNCELETRMOSTRMECAN','0.00','0.00','0.00','0.00'),
 ('91021210','RELOGIO DE PULSO,CXMETCOMUM,FUNCELETRMOSTROPTOELET','0.00','0.00','0.00','0.00'),
 ('91021220','RELOGIO DE PULSO,CXPLASTICO,FUNCELETRMOSTROPTOELET','0.00','0.00','0.00','0.00'),
 ('91021290','OUTROS RELOGIOS DE PULSO,FUNCELETRMOSTROPTOELETR','0.00','0.00','0.00','0.00'),
 ('91021900','OUTROS RELOGIOS DE PULSO,FUNCELETR','0.00','0.00','0.00','0.00'),
 ('91022100','RELOGIO DE PULSO,DE CORDA AUTOMAT','0.00','0.00','0.00','0.00'),
 ('91022900','OUTROS RELOGIOS DE PULSO','0.00','0.00','0.00','0.00'),
 ('91029100','RELOGIO DE BOLSO,SEMELHFUNCELETR','0.00','0.00','0.00','0.00'),
 ('91029900','OUTROS RELOGIOS DE BOLSO,SEMELH','0.00','0.00','0.00','0.00'),
 ('91031000','DESPERTADORES E OUTSRELOGIOS,MAQUINPEQVOLFUNCELETR','0.00','0.00','0.00','0.00'),
 ('91039000','OUTROS DESPERTADORES/OUTROS RELOGIOS,MAQUINPEQVOL','0.00','0.00','0.00','0.00'),
 ('91040000','RELOGIOS P/PAINEIS DE INSTRUMP/AUTOMOVEIS E OUTSVE','0.00','0.00','0.00','0.00'),
 ('91051100','OUTROS DESPERTADORES FUNCELETREXCMAQUINPEQVOL','0.00','0.00','0.00','0.00'),
 ('91051900','OUTROS DESPERTADORES EXCMAQUINPEQVOL','0.00','0.00','0.00','0.00'),
 ('91052100','PENDULAS/RELOGIOS PAREDE,FUNCELETREXCMAQUINPEQVOL','0.00','0.00','0.00','0.00'),
 ('91052900','OUTRAS PENDULAS E RELOGIOS DE PAREDE,EXCMAQUINPEQV','0.00','0.00','0.00','0.00'),
 ('91059100','OUTSAPARSDE RELOJOARIA,FUNCELETREXCMAQUINPEQVOL','0.00','0.00','0.00','0.00'),
 ('91059900','OUTSAPARSDE RELOJOARIA,EXCC/MAQUINISMO DE PEQVOLUM','0.00','0.00','0.00','0.00'),
 ('91061000','RELOGIOS DE PONTO,RELOGDATADORES E CONTADORES DE H','0.00','0.00','0.00','0.00'),
 ('91062000','PARQUIMETROS','0.00','0.00','0.00','0.00'),
 ('91069000','OUTROS APARELHOS DE CONTROLE/CONTADORES DE TEMPO,E','0.00','0.00','0.00','0.00'),
 ('91070010','INTERRUPTORES HORARIOS','0.00','0.00','0.00','0.00'),
 ('91070090','OUTSAPARSP/ACIONAR MECANISMO EM TEMPO DETERMINADO,','0.00','0.00','0.00','0.00'),
 ('91081110','MAQUINISMO MONTADO P/RELOGPULSO,FUNCELETRMOSTRMECA','0.00','0.00','0.00','0.00'),
 ('91081190','MAQUINISMO MONTADO P/OUTSRELOGPEQVOLFELETRMMECAN','0.00','0.00','0.00','0.00'),
 ('91081200','MAQUINISMO MONTADO P/RELOGPULSO,FUNCELETRMOSTROPTO','0.00','0.00','0.00','0.00'),
 ('91081900','MAQUINISMO MONTADO P/OUTSRELOGPEQVOLFELETRMOPTOE','0.00','0.00','0.00','0.00'),
 ('91082000','MAQUINISMO MONTADO P/RELOGIO PEQVOLDE CORDA AUTOMA','0.00','0.00','0.00','0.00'),
 ('91089100','OUTROS MAQUINISMOS MONTADOS MED<=338MM,P/OUTSRELOG','0.00','0.00','0.00','0.00'),
 ('91089900','OUTSMAQUINISMOS MONTADOS PEQVOLCOMPLP/OUTSRELOGIOS','0.00','0.00','0.00','0.00'),
 ('91091100','MAQUINISMO MONTADO EXCPEQVOLP/DESPERTADOR,FUNCELET','0.00','0.00','0.00','0.00'),
 ('91091900','MAQUINISMO MONTADO EXCPEQVOLP/OUTSRELOGFUNCELETR','0.00','0.00','0.00','0.00'),
 ('91099000','MAQUINISMO MONTADO EXCPEQVOLP/OUTSAPARSRELOJOARIA','0.00','0.00','0.00','0.00'),
 ('91101110','MAQUINISMO N/MONTADO COMPLP/RELOGIO DE PULSO,BOLSO','0.00','0.00','0.00','0.00'),
 ('91101190','MAQUINISMO N/MONTADO COMPLP/OUTROS RELOGIOS DE PEQ','0.00','0.00','0.00','0.00'),
 ('91101200','MAQUINISMO MONTADO INCOMPLP/APARSRELOJOARIA PEQVOL','0.00','0.00','0.00','0.00'),
 ('91101900','ESBOCOS DE MAQUINISMOS P/APARSRELOJOARIA DE PEQVOL','0.00','0.00','0.00','0.00'),
 ('91109000','MAQUINISMO N/MONTADO COMPLP/APARSRELOJOAREXCPEQVOL','0.00','0.00','0.00','0.00'),
 ('91111000','CAIXAS P/RELOGIO DE PULSO/BOLSO,DE METAL PRECIOSO,','0.00','0.00','0.00','0.00'),
 ('91112010','CAIXAS P/RELOGIO DE PULSO/BOLSO,DE LATAO,EM ESBOCO','0.00','0.00','0.00','0.00'),
 ('91112090','CAIXAS P/RELOGIO DE PULSO/BOLSO,DE OUTROS METAIS C','0.00','0.00','0.00','0.00'),
 ('91118000','CAIXAS P/RELOGIO DE PULSO/BOLSO,DE OUTRAS MATERIAS','0.00','0.00','0.00','0.00'),
 ('91119010','FUNDOS P/CAIXA DE RELOGIO DE PULSO/BOLSO,DE METAL ','0.00','0.00','0.00','0.00'),
 ('91119090','OUTRAS PARTES P/CAIXA DE RELOGIO DE PULSO/BOLSO','0.00','0.00','0.00','0.00'),
 ('91121000','CAIXAS E SEMELHP/APARELHOS DE RELOJOARIA,DE METAL','0.00','0.00','0.00','0.00'),
 ('91128000','CAIXAS E SEMELHP/APARSDE RELOJOARIA,DE OUTSMATERIA','0.00','0.00','0.00','0.00'),
 ('91129000','PARTES P/CAIXAS E SEMELHP/APARELHOS DE RELOJOARIA','0.00','0.00','0.00','0.00'),
 ('91131000','PULSEIRAS P/RELOGIOS,DE METAL PRECIOSO,FOLHEADO,ET','0.00','0.00','0.00','0.00'),
 ('91132000','PULSEIRAS P/RELOGIOS,DE METAL COMUM','0.00','0.00','0.00','0.00'),
 ('91139000','PULSEIRAS P/RELOGIOS,DE OUTSMATERE PARTES P/PULSEI','0.00','0.00','0.00','0.00'),
 ('91141000','MOLAS P/APARELHOS DE RELOJOARIA,INCLAS ESPIRAIS','0.00','0.00','0.00','0.00'),
 ('91142000','PEDRAS P/APARELHOS DE RELOJOARIA','0.00','0.00','0.00','0.00'),
 ('91143000','QUADRANTES P/APARELHOS DE RELOJOARIA','0.00','0.00','0.00','0.00'),
 ('91144000','PLATINAS E PONTES P/APARELHOS DE RELOJOARIA','0.00','0.00','0.00','0.00'),
 ('91149010','COROAS P/APARELHOS DE RELOJOARIA','0.00','0.00','0.00','0.00'),
 ('91149020','PONTEIROS P/APARELHOS DE RELOJOARIA','0.00','0.00','0.00','0.00'),
 ('91149030','HASTES P/APARELHOS DE RELOJOARIA','0.00','0.00','0.00','0.00'),
 ('91149040','BASCULAS P/APARELHOS DE RELOJOARIA','0.00','0.00','0.00','0.00'),
 ('91149050','EIXOS E PINHOES P/APARELHOS DE RELOJOARIA','0.00','0.00','0.00','0.00'),
 ('91149060','RODAS P/APARELHOS DE RELOJOARIA','0.00','0.00','0.00','0.00'),
 ('91149070','ROTORES P/APARELHOS DE RELOJOARIA','0.00','0.00','0.00','0.00'),
 ('91149090','OUTRAS PARTES E ACESSP/APARELHOS DE RELOJOARIA','0.00','0.00','0.00','0.00'),
 ('92011000','PIANOS VERTICAIS','0.00','0.00','0.00','0.00'),
 ('92012000','PIANOS DE CAUDA','0.00','0.00','0.00','0.00'),
 ('92019000','OUTROS PIANOS,CRAVOS E OUTSINSTRUMDE CORDAS,C/TECL','0.00','0.00','0.00','0.00'),
 ('92021000','INSTRUMENTOS MUSICAIS DE CORDAS,TOCADOS C/AUXILIO ','0.00','0.00','0.00','0.00'),
 ('92029000','OUTROS INSTRUMENTOS MUSICAIS DE CORDAS','0.00','0.00','0.00','0.00'),
 ('92030000','ORGAOS DE TUBOS E DE TECLADO,HARMONIOS E INSTRUMSE','0.00','0.00','0.00','0.00'),
 ('92041000','ACORDEOES E INSTRUMENTOS SEMELHANTES','0.00','0.00','0.00','0.00'),
 ('92042000','HARMONICAS (GAITAS) DE BOCA','0.00','0.00','0.00','0.00'),
 ('92051000','INSTRUMENTOS MUSICAIS DE SOPRO DENOMINADOS \"METAIS','0.00','0.00','0.00','0.00'),
 ('92059000','OUTROS INSTRUMENTOS MUSICAIS DE SOPRO','0.00','0.00','0.00','0.00'),
 ('92060000','INSTRUMENTOS MUSICAIS DE PERCUSSAO (TAMBORES,ETC)','0.00','0.00','0.00','0.00'),
 ('92071010','SINTETIZADORES (INSTRUMENTOS MUSICAIS DE TECLADO)','0.00','0.00','0.00','0.00'),
 ('92071090','OUTROS INSTRUMENTOS MUSICAIS DE TECLADO','0.00','0.00','0.00','0.00'),
 ('92079010','GUITARRA E CONTRABAIXO','0.00','0.00','0.00','0.00'),
 ('92079090','OUTROS INSTRUMENTOS MUSICAIS C/SOM AMPLIFPOR MEIO ','0.00','0.00','0.00','0.00'),
 ('92081000','CAIXAS DE MUSICA','0.00','0.00','0.00','0.00'),
 ('92089000','ORGAOS MECANICOS DE FEIRA E OUTSINSTRUMENTOS MUSIC','0.00','0.00','0.00','0.00'),
 ('92091000','METRONOMOS E DIAPASOES P/INSTRUMENTOS MUSICAIS','0.00','0.00','0.00','0.00'),
 ('92092000','MECANISMO DE CAIXAS DE MUSICA','0.00','0.00','0.00','0.00'),
 ('92093000','CORDAS P/INSTRUMENTOS MUSICAIS','0.00','0.00','0.00','0.00'),
 ('92099100','PARTES E ACESSP/PIANOS','0.00','0.00','0.00','0.00'),
 ('92099200','PARTES E ACESSP/INSTRUMENTOS MUSICAIS DE CORDAS','0.00','0.00','0.00','0.00'),
 ('92099300','PARTES E ACESSP/ORGAOS DE TUBOS E DE TECLADOS,ETC','0.00','0.00','0.00','0.00'),
 ('92099400','PARTES E ACESSP/INSTRUMMUSICAIS SOM AMPLIFMEIO ELE','0.00','0.00','0.00','0.00'),
 ('92099900','PARTES E ACESSP/OUTROS INSTRUMENTOS MUSICAIS','0.00','0.00','0.00','0.00'),
 ('93010000','ARMAS DE GUERRA,EXCREVOLVERES,PISTOLAS E ARMAS BRA','0.00','0.00','0.00','0.00'),
 ('93020000','OUTROS REVOLVERES E PISTOLAS','0.00','0.00','0.00','0.00'),
 ('93031000','ARMAS DE FOGO CARREGAVEIS EXCLUSIVAMENTE PELA BOCA','0.00','0.00','0.00','0.00'),
 ('93032000','ESPINGARDAS/CARABINAS P/CACA/TIRO-AO-ALVO,CANO LIS','0.00','0.00','0.00','0.00'),
 ('93033000','OUTRAS ESPINGARDAS/CARABINAS P/CACA/TIRO-AO-ALVO','0.00','0.00','0.00','0.00'),
 ('93039000','OUTSARMAS DE FOGO QUE UTILDEFLAGRACAO DA POLVORA,E','0.00','0.00','0.00','0.00'),
 ('93040000','OUTSARMAS (ESPINGARDAS/CARABINAS/PISTOLAS/CASSETET','0.00','0.00','0.00','0.00'),
 ('93051000','PARTES E ACESSP/REVOLVERES/PISTOLAS','0.00','0.00','0.00','0.00'),
 ('93052100','PARTES E ACESSP/ESPINGARDA/CARABINA DE FOGO,CANO L','0.00','0.00','0.00','0.00'),
 ('93052900','PARTES E ACESSP/OUTRAS ESPINGARDAS/CARABINAS DE FO','0.00','0.00','0.00','0.00'),
 ('93059010','PARTES E ACESSP/ARMAS DE GUERRA','0.00','0.00','0.00','0.00'),
 ('93059090','PARTES E ACESSP/OUTRAS ARMAS','0.00','0.00','0.00','0.00'),
 ('93061000','CARTUCHOS P/PISTOLAS DE REBITAR/EMBOLO P/ABATER AN','0.00','0.00','0.00','0.00'),
 ('93062100','CARTUCHOS P/ESPINGARDAS/CARABINAS DE CANO LISO','0.00','0.00','0.00','0.00'),
 ('93062900','CHUMBOS P/CARABINAS DE AR COMPRIMIDO,PARTES P/CART','0.00','0.00','0.00','0.00'),
 ('93063000','OUTROS CARTUCHOS E SUAS PARTES','0.00','0.00','0.00','0.00'),
 ('93069000','BOMBAS,GRANADAS,OUTSMUNICOES E PROJETEIS E SUAS PA','0.00','0.00','0.00','0.00'),
 ('93070000','SABRES,ESPADAS,BAIONETAS,OUTSARMAS BRANCAS,SUAS PA','0.00','0.00','0.00','0.00'),
 ('94011010','ASSENTOS EJETAVEIS,PARA VEICULOS AEREOS','0.00','0.00','0.00','0.00'),
 ('94011090','OUTROS ASSENTOS P/VEICULOS AEREOS,EXCEJETAVEIS','0.00','0.00','0.00','0.00'),
 ('94012000','ASSENTOS PARA VEICULOS AUTOMOVEIS','0.00','0.00','0.00','0.00'),
 ('94013010','ASSENTOS GIRATORIOS,DE ALTURA AJUSTAVDE MADEIRA','0.00','0.00','0.00','0.00'),
 ('94013090','ASSENTOS GIRATORIOS,DE ALTURA AJUSTAVDE OUTSMATERI','0.00','0.00','0.00','0.00'),
 ('94014010','ASSENTOS TRANSFORMAVEIS EM CAMAS,DE MADEIRA','0.00','0.00','0.00','0.00'),
 ('94014090','ASSENTOS TRANSFORMAVEIS EM CAMAS,DE OUTRAS MATERIA','0.00','0.00','0.00','0.00'),
 ('94015000','ASSENTOS DE CANA,VIME,BAMBU OU DE MATERIAS SEMELHA','0.00','0.00','0.00','0.00'),
 ('94016100','ASSENTOS ESTOFADOS,COM ARMACAO DE MADEIRA','0.00','0.00','0.00','0.00'),
 ('94016900','OUTROS ASSENTOS C/ARMACAO DE MADEIRA','0.00','0.00','0.00','0.00'),
 ('94017100','ASSENTOS ESTOFADOS,COM ARMACAO DE METAL','0.00','0.00','0.00','0.00'),
 ('94017900','OUTROS ASSENTOS C/ARMACAO DE METAL','0.00','0.00','0.00','0.00'),
 ('94018000','OUTROS ASSENTOS','0.00','0.00','0.00','0.00'),
 ('94019010','PARTES P/ASSENTOS,DE MADEIRA','0.00','0.00','0.00','0.00'),
 ('94019090','PARTES P/ASSENTOS,DE OUTRAS MATERIAS','0.00','0.00','0.00','0.00'),
 ('94021000','CADEIRAS DE DENTISTA/SALOES DE CABELEIREIRO,ETCPAR','0.00','0.00','0.00','0.00'),
 ('94029010','MESAS P/OPERACAO CIRURGICA','0.00','0.00','0.00','0.00'),
 ('94029020','CAMAS DOTADAS DE MECANISMOS P/USOS CLINICOS','0.00','0.00','0.00','0.00'),
 ('94029090','OUTROS MOBILIARIOS P/MEDICINA,CIRURGIA,ODONTOLOGIA','0.00','0.00','0.00','0.00'),
 ('94031000','MOVEIS DE METAL P/ESCRITORIOS','0.00','0.00','0.00','0.00'),
 ('94032000','OUTROS MOVEIS DE METAL','0.00','0.00','0.00','0.00'),
 ('94033000','MOVEIS DE MADEIRA P/ESCRITORIOS','0.00','0.00','0.00','0.00'),
 ('94034000','MOVEIS DE MADEIRA P/COZINHAS','0.00','0.00','0.00','0.00'),
 ('94035000','MOVEIS DE MADEIRA P/QUARTOS DE DORMIR','0.00','0.00','0.00','0.00'),
 ('94036000','OUTROS MOVEIS DE MADEIRA','0.00','0.00','0.00','0.00'),
 ('94037000','MOVEIS DE PLASTICOS','0.00','0.00','0.00','0.00'),
 ('94038000','MOVEIS DE OUTRAS MATERIAS,INCLROTIM,VIME,BAMBU,ETC','0.00','0.00','0.00','0.00'),
 ('94039010','PARTES P/MOVEIS,DE MADEIRA','0.00','0.00','0.00','0.00'),
 ('94039090','PARTES P/MOVEIS,DE OUTRAS MATERIAS','0.00','0.00','0.00','0.00'),
 ('94041000','SUPORTE ELASTICO P/CAMAS','0.00','0.00','0.00','0.00'),
 ('94042100','COLCHOES DE BORRACHA/PLASTICOS ALVEOLARES,MESMO RO','0.00','0.00','0.00','0.00'),
 ('94042900','COLCHOES DE OUTRAS MATERIAS','0.00','0.00','0.00','0.00'),
 ('94043000','SACOS DE DORMIR','0.00','0.00','0.00','0.00'),
 ('94049000','EDEDROES,ALMOFADAS,PUFES,TRAVESSEIROS E ARTIGOS SE','0.00','0.00','0.00','0.00'),
 ('94051010','LAMPADAS ESCIALITICAS','0.00','0.00','0.00','0.00'),
 ('94051091','LUSTRES E APARELHOS ILUMINELETRDE PEDRA,P/TETO/PAR','0.00','0.00','0.00','0.00'),
 ('94051092','LUSTRES E APARELHOS ILUMINELETRDE VIDRO,P/TETO/PAR','0.00','0.00','0.00','0.00'),
 ('94051093','LUSTRES E APARSILUMINELETRDE METCOMUM,P/TETO/PARED','0.00','0.00','0.00','0.00'),
 ('94051099','LUSTRES E APARSILUMINELETRDE OUTSMATERP/TETO/PARED','0.00','0.00','0.00','0.00'),
 ('94052000','ABAJURES DE CABECEIRA OU DE ESCRITORIO,ETCELETRICO','0.00','0.00','0.00','0.00'),
 ('94053000','GUIRLANDAS ELETRICAS P/ARVORES DE NATAL','0.00','0.00','0.00','0.00'),
 ('94054010','OUTSAPARELHOS ELETRICOS DE ILUMINACAO,DE METAIS CO','0.00','0.00','0.00','0.00'),
 ('94054090','OUTSAPARELHOS ELETRICOS DE ILUMINACAO,DE OUTSMATER','0.00','0.00','0.00','0.00'),
 ('94055000','APARELHOS NAO ELETRICOS DE ILUMINACAO','0.00','0.00','0.00','0.00'),
 ('94056000','ANUNCIOS,CARTAZES E PLACAS INDICADORAS,LUMINOSOS,E','0.00','0.00','0.00','0.00'),
 ('94059100','PARTES P/APARELHOS DE ILUMINACAO,DE VIDRO','0.00','0.00','0.00','0.00'),
 ('94059200','PARTES P/APARELHOS DE ILUMINACAO,DE PLASTICOS','0.00','0.00','0.00','0.00'),
 ('94059900','PARTES P/APARELHOS DE ILUMINACAO,DE OUTRAS MATERIA','0.00','0.00','0.00','0.00'),
 ('94060010','ESTUFAS PRE-FABRICADAS','0.00','0.00','0.00','0.00'),
 ('94060091','OUTRAS CONSTRUCOES PRE-FABRICADAS,DE MADEIRA','0.00','0.00','0.00','0.00'),
 ('94060092','OUTRAS CONSTRUCOES PRE-FABRICADAS,DE FERRO OU ACO','0.00','0.00','0.00','0.00'),
 ('94060099','OUTRAS CONSTRUCOES PRE-FABRICADAS,DE OUTRAS MATERI','0.00','0.00','0.00','0.00'),
 ('95010000','BRINQUEDOS DE RODAS P/CRIANCAS E CARRINHOS P/BONEC','0.00','0.00','0.00','0.00'),
 ('95021010','BONECOS DE FIGURA HUMANA,C/MECANISMO A CORDA/ELETR','0.00','0.00','0.00','0.00'),
 ('95021090','OUTROS BONECOS DE FIGURA HUMANA,MESMO VESTIDOS','0.00','0.00','0.00','0.00'),
 ('95029100','VESTUARIO E SEUS ACESSETCP/BONECOS DE FIGURA HUMAN','0.00','0.00','0.00','0.00'),
 ('95029900','OUTRAS PARTES E ACESSP/BONECOS DE FIGURA HUMANA','0.00','0.00','0.00','0.00'),
 ('95031000','TRENS ELETRDE BRINQUEDO,INCLTRILHOS/SINAIS/OUTSACE','0.00','0.00','0.00','0.00'),
 ('95032000','OUTSMODELOS REDUZIDOS,DE BRINQUEDO,EM CONJP/MONTAG','0.00','0.00','0.00','0.00'),
 ('95033000','OUTROS CONJUNTOS E BRINQUEDOS,P/CONSTRUCAO','0.00','0.00','0.00','0.00'),
 ('95034100','BRINQUEDOS C/ENCHIMENTO,DE FIGURA ANIMAL OU NAO-HU','0.00','0.00','0.00','0.00'),
 ('95034900','OUTROS BRINQUEDOS DE FIGURA ANIMAL OU NAO HUMANA','0.00','0.00','0.00','0.00'),
 ('95035000','INSTRUMENTOS E APARELHOS MUSICAIS,DE BRINQUEDO','0.00','0.00','0.00','0.00'),
 ('95036000','QUEBRA-CABECAS (\"PUZZLES\")','0.00','0.00','0.00','0.00'),
 ('95037000','OUTROS BRINQUEDOS EM SORTIDOS OU EM PANOPLIAS','0.00','0.00','0.00','0.00'),
 ('95038010','OUTROS BRINQUEDOS E MODELOS,MOTORIZADOS,ELETRICOS','0.00','0.00','0.00','0.00'),
 ('95038090','OUTROS BRINQUEDOS E MODELOS,MOTORIZADOS','0.00','0.00','0.00','0.00'),
 ('95039010','OUTROS BRINQUEDOS DE FRICCAO,DE CORDA OU DE MOLA','0.00','0.00','0.00','0.00'),
 ('95039090','OUTROS BRINQUEDOS','0.00','0.00','0.00','0.00'),
 ('95041010','JOGOS DE VIDEO P/UTILEM APARSRECEPTORES DE TELEVIS','0.00','0.00','0.00','0.00'),
 ('95041091','CARTUCHOS P/JOGOS DE VIDEO','0.00','0.00','0.00','0.00'),
 ('95041099','OUTRAS PARTES E ACESSP/JOGOS DE VIDEO','0.00','0.00','0.00','0.00'),
 ('95042000','BILHARES E SEUS ACESS','0.00','0.00','0.00','0.00'),
 ('95043000','OUTSJOGOS ACIONADOS POR FICHA/MOEDA,EXCJOGOS BALIZ','0.00','0.00','0.00','0.00'),
 ('95044000','CARTAS DE JOGAR','0.00','0.00','0.00','0.00'),
 ('95049000','OUTROS ARTIGOS P/JOGOS DE SALAO','0.00','0.00','0.00','0.00'),
 ('95051000','ARTIGOS PARA FESTAS DE NATAL','0.00','0.00','0.00','0.00'),
 ('95059000','ARTIGOS P/OUTRAS FESTAS,CARNAVAL OU OUTSDIVERTIMEN','0.00','0.00','0.00','0.00'),
 ('95061100','ESQUIS P/NEVE','0.00','0.00','0.00','0.00'),
 ('95061200','FIXADORES P/ESQUIS','0.00','0.00','0.00','0.00'),
 ('95061900','OUTROS EQUIPAMENTOS P/ESQUIAR NA NEVE','0.00','0.00','0.00','0.00'),
 ('95062100','PRANCHAS A VELA','0.00','0.00','0.00','0.00'),
 ('95062900','ESQUIS AQUATICOS E OUTROS EQUIPAMP/ESPORTES AQUATI','0.00','0.00','0.00','0.00'),
 ('95063100','TACOS COMPLETOS P/GOLFE','0.00','0.00','0.00','0.00'),
 ('95063200','BOLAS P/GOLFE','0.00','0.00','0.00','0.00'),
 ('95063900','OUTROS EQUIPAMENTOS P/GOLFE','0.00','0.00','0.00','0.00'),
 ('95064000','ARTIGOS E EQUIPAMENTOS P/TENIS DE MESA','0.00','0.00','0.00','0.00'),
 ('95065100','RAQUETES DE TENIS,MESMO NAO ENCORDOADAS','0.00','0.00','0.00','0.00'),
 ('95065900','RAQUETES DE \"BADMINTON\" E RAQUETES SEMELH','0.00','0.00','0.00','0.00'),
 ('95066100','BOLAS P/TENIS,EXCTENIS DE MESA','0.00','0.00','0.00','0.00'),
 ('95066200','BOLAS INFLAVEIS','0.00','0.00','0.00','0.00'),
 ('95066900','OUTRAS BOLAS','0.00','0.00','0.00','0.00'),
 ('95067000','PATINS P/GELO E PATINS DE RODAS,INCLFIXADOS EM CAL','0.00','0.00','0.00','0.00'),
 ('95069100','ARTIGOS E EQUIPAMENTOS P/CULTURA FISICA,GINASTICA,','0.00','0.00','0.00','0.00'),
 ('95069900','ARTIGOS E EQUIPAMENTOS P/OUTROS ESPORTES E PISCINA','0.00','0.00','0.00','0.00'),
 ('95071000','VARAS (CANAS) DE PESCA','0.00','0.00','0.00','0.00'),
 ('95072000','ANZOIS,MESMO MONTADOS EM SEDELAS (TERMINAIS)','0.00','0.00','0.00','0.00'),
 ('95073000','MOLINETES (CARRETOS) DE PESCA','0.00','0.00','0.00','0.00'),
 ('95079000','OUTSARTIGOS P/PESCA A LINHA,PUCAS,REDES,ISCAS,CACA','0.00','0.00','0.00','0.00'),
 ('95080000','CARROSSEIS/BALANCOS/OUTSDIVERSOES P/PARQUES,CIRCOS','0.00','0.00','0.00','0.00'),
 ('96011000','MARFIM TRABALHADO E OBRAS DE MARFIM','0.00','0.00','0.00','0.00'),
 ('96019000','OUTRAS MATERIAS ANIMAIS P/ENTALHAR,TRABALHADOS E O','0.00','0.00','0.00','0.00'),
 ('96020010','CAPSULAS DE GELATINAS DIGERIVEIS','0.00','0.00','0.00','0.00'),
 ('96020020','COLMEIAS ARTIFICIAIS','0.00','0.00','0.00','0.00'),
 ('96020090','OUTSMATERIAS VEGET/MINERDE ENTALHAR,TRABALHOBRAS,E','0.00','0.00','0.00','0.00'),
 ('96031000','VASSOURAS E ESCOVAS,DE MATERIAS VEGETAIS EM FEIXES','0.00','0.00','0.00','0.00'),
 ('96032100','ESCOVAS DE DENTES,INCLAS ESCOVAS P/DENTADURAS','0.00','0.00','0.00','0.00'),
 ('96032900','ESCOVAS E PINCEIS DE BARBA,ESCOVAS P/CABELOS,CILIO','0.00','0.00','0.00','0.00'),
 ('96033000','PINCEIS E ESCOVAS P/ARTISTAS,P/PRODSCOSMETICOS,ETC','0.00','0.00','0.00','0.00'),
 ('96034010','ROLOS P/PINTURA','0.00','0.00','0.00','0.00'),
 ('96034090','ESCOVAS E PINCEIS P/PINTAR,CAIAR,ENVERNIZAR,ETCBON','0.00','0.00','0.00','0.00'),
 ('96035000','OUTRAS ESCOVAS CONSTITPARTES DE MAQSAPARSOU VEICUL','0.00','0.00','0.00','0.00'),
 ('96039000','OUTRAS VASSOURAS,ESCOVAS,PINCEIS,ESPANADORES,RODOS','0.00','0.00','0.00','0.00'),
 ('96040000','PENEIRAS E CRIVOS,MANUAIS','0.00','0.00','0.00','0.00'),
 ('96050000','SORTIDOS DE VIAGEM,P/TOUCADOR,P/COSTURA/LIMPEZA RO','0.00','0.00','0.00','0.00'),
 ('96061000','BOTOES DE PRESSAO E SUAS PARTES','0.00','0.00','0.00','0.00'),
 ('96062100','BOTOES DE PLASTICO,N/RECOBDE MATERIAS TEXTEIS','0.00','0.00','0.00','0.00'),
 ('96062200','BOTOES DE METAIS COMUNS,N/RECOBDE MATERIAS TEXTEIS','0.00','0.00','0.00','0.00'),
 ('96062900','OUTROS BOTOES','0.00','0.00','0.00','0.00'),
 ('96063000','FORMAS E OUTRAS PARTES DE BOTOES E ESBOCOS DE BOTO','0.00','0.00','0.00','0.00'),
 ('96071100','FECHOS ECLER C/GRAMPOS DE METAL COMUM','0.00','0.00','0.00','0.00'),
 ('96071900','OUTROS FECHOS ECLER','0.00','0.00','0.00','0.00'),
 ('96072000','PARTES DE FECHOS ECLER','0.00','0.00','0.00','0.00'),
 ('96081000','CANETAS ESFEROGRAFICAS','0.00','0.00','0.00','0.00'),
 ('96082000','CANETAS E MARCADORES,C/PONTA DE FELTRO/PONTAS PORO','0.00','0.00','0.00','0.00'),
 ('96083100','CANETAS P/DESENHAR C/NANQUIM','0.00','0.00','0.00','0.00'),
 ('96083900','OUTRAS CANETAS-TINTEIRO','0.00','0.00','0.00','0.00'),
 ('96084000','LAPISEIRAS','0.00','0.00','0.00','0.00'),
 ('96085000','SORTIDOS DE CANETAS COM LAPISEIRAS','0.00','0.00','0.00','0.00'),
 ('96086000','CARGAS C/PONTA,P/CANETAS ESFEROGRAFICAS','0.00','0.00','0.00','0.00'),
 ('96089100','PENAS (APAROS) E SUAS PONTAS,P/CANETAS-TINTEIRO','0.00','0.00','0.00','0.00'),
 ('96089981','PONTAS POROSAS,P/CANETAS E MARCADORES','0.00','0.00','0.00','0.00'),
 ('96089989','OUTRAS PARTES P/CANETAS,LAPISEIRAS,ETC','0.00','0.00','0.00','0.00'),
 ('96089990','ESTILETES P/DUPLICADORES,PORTA-LAPIS E ARTIGOS SEM','0.00','0.00','0.00','0.00'),
 ('96091000','LAPIS','0.00','0.00','0.00','0.00'),
 ('96092000','MINAS P/LAPIS/LAPISEIRAS','0.00','0.00','0.00','0.00'),
 ('96099000','PASTEIS,CARVOES,GIZES P/ESCREVER/DESENHAR E DE ALF','0.00','0.00','0.00','0.00'),
 ('96100000','LOUSAS E QUADROS P/ESCREVER/DESENHAR,MESMO EMOLDUR','0.00','0.00','0.00','0.00'),
 ('96110000','CARIMBOS,DATADORES,NUMERADORES,SINETES E ARTIGOS S','0.00','0.00','0.00','0.00'),
 ('96121011','FITAS DE PLASTICO,C/TINTA MAGNETIZP/IMPRESSAO CARA','0.00','0.00','0.00','0.00'),
 ('96121012','FITAS DE PLASTICO,CORRETIVAS,P/MAQUINAS DE ESCREVE','0.00','0.00','0.00','0.00'),
 ('96121013','OUTSFITAS DE PLASTICO,EM CARTUCHOS,P/MAQSDE ESCREV','0.00','0.00','0.00','0.00'),
 ('96121019','OUTRAS FITAS IMPRESSORAS DE PLASTICO','0.00','0.00','0.00','0.00'),
 ('96121090','OUTRAS FITAS IMPRESSORAS DE OUTRAS MATERIAS','0.00','0.00','0.00','0.00'),
 ('96122000','ALMOFADAS DE CARIMBO','0.00','0.00','0.00','0.00'),
 ('96131000','ISQUEIROS DE BOLSO,A GAS,N/RECARREGAVEIS','0.00','0.00','0.00','0.00'),
 ('96132000','ISQUEIROS DE BOLSO,A GAS,RECARREGAVEIS','0.00','0.00','0.00','0.00'),
 ('96133000','ISQUEIROS DE MESA','0.00','0.00','0.00','0.00'),
 ('96138000','OUTROS ISQUEIROS E ACENDEDORES','0.00','0.00','0.00','0.00'),
 ('96139000','PARTES DE ISQUEIROS E OUTROS ACENDEDORES','0.00','0.00','0.00','0.00'),
 ('96142000','CACHIMBOS E SEUS FORNILHOS','0.00','0.00','0.00','0.00'),
 ('96149000','PITEIRAS (BOQUILHAS) E SUAS PARTES','0.00','0.00','0.00','0.00'),
 ('96151100','PENTES E TRAVESSAS P/CABELO,DE BORRACHA ENDUR/PLAS','0.00','0.00','0.00','0.00'),
 ('96151900','OUTROS PENTES E TRAVESSAS P/CABELO,DE OUTROS MATER','0.00','0.00','0.00','0.00'),
 ('96159000','GRAMPOS P/CABELO,PINCAS E OUTROS ARTIGOS P/PENTEAD','0.00','0.00','0.00','0.00'),
 ('96161000','VAPORIZADORES DE TOUCADOR,ARMACOES E SUAS CABECAS','0.00','0.00','0.00','0.00'),
 ('96162000','BORLAS/ESPONJAS P/POS/OUTSCOSMETICOS/PRODSDE TOUCA','0.00','0.00','0.00','0.00'),
 ('96170010','GARRAFA TERMICA/OUTSRECIPISOTERMMONTADOS,ISOLVACUO','0.00','0.00','0.00','0.00'),
 ('96170020','PARTES DE GARRAFAS TERMICAS E OUTROS RECIPSISOTERM','0.00','0.00','0.00','0.00'),
 ('96180000','MANEQUIM,AUTOMATO E CENAS ANIMADAS P/VITRINE/MOSTR','0.00','0.00','0.00','0.00'),
 ('97011000','QUADROS,PINTURAS E DESENHOS,FEITOS A MAO','0.00','0.00','0.00','0.00'),
 ('97019000','COLAGENS E QUADROS DECORATIVOS SEMELH','0.00','0.00','0.00','0.00'),
 ('97020000','GRAVURAS,ESTAMPAS E LITOGRAFIAS,ORIGINAIS','0.00','0.00','0.00','0.00'),
 ('97030000','PRODUCOES ORIGINAIS DE ARTE ESTATUARIA OU DE ESCUL','0.00','0.00','0.00','0.00'),
 ('97040000','SELOS POSTAIS,SELOS FISCAIS,MARCAS POSTAIS,ETC','0.00','0.00','0.00','0.00'),
 ('97050000','COLECOES E ESPECIME P/COLECOES ZOOLOGICAS,BOTANICA','0.00','0.00','0.00','0.00'),
 ('97060000','ANTIGUIDADES COM MAIS DE 100 ANOS','0.00','0.00','0.00','0.00'),
 ('99910000','ENCOMENDAS POSTAIS','0.00','0.00','0.00','0.00'),
 ('99920000','AMOSTRAS','0.00','0.00','0.00','0.00'),
 ('99970000','MERCADORIAS DOADAS','0.00','0.00','0.00','0.00'),
 ('99980101','CONSUMO DE BORDO - COMBUSTIVEIS E LUBRIFP/EMBARCAC','0.00','0.00','0.00','0.00'),
 ('99980102','CONSUMO DE BORDO - COMBUSTIVEIS E LUBRIFP/AERONAVE','0.00','0.00','0.00','0.00'),
 ('99980201','CONSUMO DE BORDO - QQOUTRA MERCADORIA P/EMBARCACOE','0.00','0.00','0.00','0.00'),
 ('99980202','CONSUMO DE BORDO - QQOUTRA MERCADORIA P/AERONAVES','0.00','0.00','0.00','0.00'),
 ('99997101','PEDRAS EM BRUTO DO CAPITULO 71 DA `ncm` (codNcm, descricao)','0.00','0.00','0.00','0.00'),
 ('99997102','PEDRAS LAPIDADAS/TRABALHADAS DO CAPITULO 71 DA `ncm` (codNcm, descricao)','0.00','0.00','0.00','0.00'),
 ('99997103','JOALHERIA DE OURO DO CAPITULO 71 DA `ncm` (codNcm, descricao)','0.00','0.00','0.00','0.00'),
 ('99997104','OUTROS ARTIGOS DO CAPITULO 71 DA `ncm` (codNcm, descricao)','0.00','0.00','0.00','0.00'),
 ('99999900','QQOUTRA MERCADORIA SEM COBERTURA CAMBIAL','0.00','0.00','0.00','0.00');


--
-- Definition of table `notas_referenciadas`
--

CREATE TABLE `notas_referenciadas` (
  `idNotasReferenciadas` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `idMovimentacao` bigint(20) unsigned NOT NULL,
  `tipo` int(10) unsigned NOT NULL COMMENT '1: NFe, 2: NF, 3: Cupom',
  `refNFe` varchar(44) DEFAULT NULL,
  `cUF` int(10) unsigned DEFAULT NULL,
  `dtEmissao` date DEFAULT NULL,
  `CNPJ` varchar(14) DEFAULT NULL,
  `modelo` int(11) DEFAULT NULL,
  `serie` int(11) DEFAULT NULL,
  `nNF` int(11) DEFAULT NULL,
  `nECF` int(11) DEFAULT NULL,
  `nCOO` int(11) DEFAULT NULL,
  PRIMARY KEY (`idNotasReferenciadas`),
  KEY `FK_NotasReferenciadas_movimentacao` (`idMovimentacao`),
  CONSTRAINT `FK_NotasReferenciadas_movimentacao` FOREIGN KEY (`idMovimentacao`) REFERENCES `movimentacao` (`idMovimentacao`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `notas_referenciadas`
--



--
-- Definition of table `num_series`
--

CREATE TABLE `num_series` (
  `idProduto` bigint(20) unsigned NOT NULL,
  `numSerie` varchar(50) NOT NULL DEFAULT '',
  `idMovimentacaoEntrada` bigint(20) DEFAULT NULL,
  `idMovimentacaoSaida` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`idProduto`,`numSerie`),
  CONSTRAINT `FK1_numSeries_produtos` FOREIGN KEY (`idProduto`) REFERENCES `produtos` (`idProduto`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `num_series`
--



--
-- Definition of table `ocupacao`
--

CREATE TABLE `ocupacao` (
  `idOcupacao` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `idQmc` int(10) unsigned NOT NULL,
  `idPessoa` int(10) unsigned DEFAULT NULL,
  `situacao` int(10) unsigned DEFAULT '0' COMMENT '0: Reservado, 1: Ocupado, 2: limpesa/manutencao, 3: liberado, 4: cancelado',
  `dhInicio` datetime DEFAULT NULL,
  `dhFim` datetime DEFAULT NULL,
  `obs` text,
  PRIMARY KEY (`idOcupacao`),
  KEY `FK1_ocupacao_qmc` (`idQmc`),
  CONSTRAINT `FK1_ocupacao_qmc` FOREIGN KEY (`idQmc`) REFERENCES `qmc` (`idQmc`) ON DELETE NO ACTION ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ocupacao`
--



--
-- Definition of table `opcionais`
--

CREATE TABLE `opcionais` (
  `idOpcional` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `idProduto` bigint(20) unsigned NOT NULL,
  `nome` varchar(50) DEFAULT NULL,
  `descricao` text,
  PRIMARY KEY (`idOpcional`,`idProduto`),
  KEY `FK1_opconais_produtos` (`idProduto`),
  CONSTRAINT `FK1_opconais_produtos` FOREIGN KEY (`idProduto`) REFERENCES `produtos` (`idProduto`) ON DELETE NO ACTION ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `opcionais`
--

INSERT INTO `opcionais` (`idOpcional`,`idProduto`,`nome`,`descricao`) VALUES 
 (1,1,'SEM','SEM'),
 (2,1,'COM','COM'),
 (3,2,'SEM','SEM'),
 (4,2,'COM','COM');


--
-- Definition of table `operador_caixa`
--

CREATE TABLE `operador_caixa` (
  `idOperador` int(10) unsigned NOT NULL,
  `idCaixa` int(10) unsigned NOT NULL,
  PRIMARY KEY (`idOperador`,`idCaixa`),
  KEY `FK_operadorCaixa_caixa` (`idCaixa`),
  CONSTRAINT `FK_operadorCaixa_caixa` FOREIGN KEY (`idCaixa`) REFERENCES `caixas` (`idCaixa`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_operadorCaixa_operadores` FOREIGN KEY (`idOperador`) REFERENCES `acesso_operadores` (`idOperador`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `operador_caixa`
--



--
-- Definition of table `paises`
--

CREATE TABLE `paises` (
  `codPais` varchar(4) NOT NULL,
  `pais` varchar(60) DEFAULT NULL,
  PRIMARY KEY (`codPais`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `paises`
--



--
-- Definition of table `pessoas`
--

CREATE TABLE `pessoas` (
  `idPessoa` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `tpCliente` varchar(1) DEFAULT 'N',
  `tpFornecedor` varchar(1) DEFAULT 'N',
  `tpTransportador` varchar(1) DEFAULT 'N',
  `tpFuncionario` varchar(1) DEFAULT 'N',
  `tpVendedor` varchar(1) DEFAULT 'N',
  `tpCredenciada` varchar(1) DEFAULT 'N',
  `tpBeneficiario` varchar(1) DEFAULT 'N',
  `tpFinanceira` varchar(1) DEFAULT 'N',
  `codCidade` varchar(7) DEFAULT NULL,
  `status` varchar(1) DEFAULT 'A' COMMENT 'A: Ativo; I: Inativo; B: Baixada; D: Desvinculada',
  `codPais` varchar(4) DEFAULT '1058',
  `tipo` varchar(1) DEFAULT NULL COMMENT 'F: Fisica; J: Juridica',
  `idClassificacao` int(10) unsigned DEFAULT '0',
  `idContador` int(10) unsigned DEFAULT NULL,
  `mensalista` varchar(1) DEFAULT 'N',
  `tipoMensalidade` varchar(1) DEFAULT 'M' COMMENT 'M: Mensal; A: Anual',
  `razaoSocial` varchar(45) NOT NULL,
  `nomeFantasia` varchar(45) DEFAULT NULL,
  `cpfCnpj` varchar(18) DEFAULT NULL,
  `rgIe` varchar(20) DEFAULT NULL,
  `im` varchar(15) DEFAULT NULL,
  `suframa` varchar(9) DEFAULT NULL,
  `bairro` varchar(30) DEFAULT NULL,
  `logradouro` varchar(40) DEFAULT NULL,
  `numero` varchar(5) DEFAULT NULL,
  `complemento` varchar(15) DEFAULT NULL,
  `cep` varchar(10) DEFAULT NULL,
  `tel` varchar(13) DEFAULT NULL,
  `cel` varchar(13) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `salarioFixo` decimal(8,2) unsigned DEFAULT '0.00',
  `comissaoVenda` decimal(5,2) unsigned DEFAULT '0.00',
  `comissaoServico` decimal(5,2) unsigned DEFAULT '0.00',
  `limiteCredito` decimal(8,2) unsigned DEFAULT '0.00',
  `obs` text,
  `placaVeiculo` varchar(9) DEFAULT NULL,
  `ufVeiculo` varchar(2) DEFAULT NULL,
  `rntc` varchar(20) DEFAULT NULL COMMENT 'ANTT',
  `diaVencimento` int(11) DEFAULT '0',
  `dtNascimento` date DEFAULT NULL,
  `profissao` varchar(45) DEFAULT NULL,
  `nomeMae` varchar(45) DEFAULT NULL,
  `estadoCivil` varchar(2) DEFAULT 'So' COMMENT 'So: Solteiro; C: Casado; Se: Separado; D: Divorciado; V: Viuvo',
  `adicional` varchar(1) DEFAULT 'S',
  `contratoNumero` varchar(15) DEFAULT NULL,
  `contratoData` date DEFAULT NULL,
  `contratoValor` decimal(8,2) DEFAULT NULL,
  `idFaixaPreco` int(10) unsigned DEFAULT NULL COMMENT 'Código da Faixa de Preço para Ajuste Automático',
  `dtAdmissao` date DEFAULT NULL,
  `dtSaida` date DEFAULT NULL,
  `dtAniversario` date DEFAULT NULL,
  `idRota` int(10) unsigned DEFAULT NULL,
  `ordem` int(10) unsigned DEFAULT NULL,
  `pRT` decimal(5,2) unsigned DEFAULT NULL,
  `coordenadas` varchar(40) DEFAULT NULL,
  PRIMARY KEY (`idPessoa`),
  KEY `fk_Clientes_Cidades1` (`codCidade`),
  CONSTRAINT `fk_Clientes_Cidades1` FOREIGN KEY (`codCidade`) REFERENCES `cidades` (`codCidade`) ON DELETE NO ACTION ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `pessoas`
--



--
-- Definition of table `plano_vendas`
--

CREATE TABLE `plano_vendas` (
  `idPlanoVenda` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `nome` varchar(50) NOT NULL,
  `ativo` varchar(1) DEFAULT 'N',
  `entradaMin` decimal(5,2) unsigned DEFAULT '0.00',
  `descontoMax` decimal(5,2) unsigned DEFAULT '0.00',
  `acrescimoMax` decimal(5,2) unsigned DEFAULT '0.00',
  `juros` decimal(5,2) unsigned DEFAULT '0.00',
  `comissao` decimal(5,2) unsigned DEFAULT '0.00',
  `intervalo` varchar(100) DEFAULT NULL,
  `codTipoPgEnt` varchar(2) NOT NULL,
  `codTipoPgPar` varchar(2) NOT NULL,
  `baixarEntrada` varchar(1) DEFAULT 'N' COMMENT 'N: Nao; S: Sim',
  PRIMARY KEY (`idPlanoVenda`),
  KEY `FK_PlanoVendas_tipoPg_1` (`codTipoPgEnt`),
  KEY `FK_PlanoVendas_tipoPg_2` (`codTipoPgPar`),
  CONSTRAINT `FK_PlanoVendas_tipoPg_1` FOREIGN KEY (`codTipoPgEnt`) REFERENCES `tipo_pg` (`codTipoPg`) ON DELETE NO ACTION ON UPDATE CASCADE,
  CONSTRAINT `FK_PlanoVendas_tipoPg_2` FOREIGN KEY (`codTipoPgPar`) REFERENCES `tipo_pg` (`codTipoPg`) ON DELETE NO ACTION ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `plano_vendas`
--



--
-- Definition of table `precos`
--

CREATE TABLE `precos` (
  `idTabelaPreco` int(10) unsigned NOT NULL,
  `idProduto` bigint(20) unsigned NOT NULL,
  `valVenda` decimal(9,3) unsigned DEFAULT '0.000',
  `qtde` int(10) unsigned DEFAULT '0' COMMENT 'indica a quantidade minima vendida de um produto para entar nesta tabela de preço',
  PRIMARY KEY (`idTabelaPreco`,`idProduto`),
  KEY `FK_precos_produtos` (`idProduto`),
  CONSTRAINT `FK_precos_produtos` FOREIGN KEY (`idProduto`) REFERENCES `produtos` (`idProduto`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_precos_tabelaPrecos` FOREIGN KEY (`idTabelaPreco`) REFERENCES `tabela_precos` (`idTabelaPreco`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `precos`
--



--
-- Definition of table `produtos`
--

CREATE TABLE `produtos` (
  `idProduto` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `idgrupoProduto` int(10) unsigned DEFAULT NULL,
  `idCnae` int(10) unsigned DEFAULT NULL,
  `codServico` varchar(4) DEFAULT NULL,
  `codFortes` int(10) unsigned DEFAULT NULL COMMENT 'código usado para a exportação para o fortes',
  `status` varchar(1) DEFAULT 'A' COMMENT 'A: ativo; I: inativo',
  `ncm` varchar(8) DEFAULT NULL COMMENT 'Nomenclatura comum do mercosul',
  `cest` varchar(7) DEFAULT NULL COMMENT 'Código Especificador da Substituição Tributária',
  `dtCadastro` date DEFAULT NULL,
  `dtAtualizacao` date DEFAULT NULL,
  `nome` varchar(50) DEFAULT NULL,
  `descricao` text,
  `referencia` varchar(200) DEFAULT NULL,
  `un` varchar(3) DEFAULT 'UN',
  `codBarras` varchar(20) DEFAULT NULL,
  `localizacao` varchar(50) DEFAULT NULL COMMENT 'Local onde o produto esta localizado, partilheira',
  `EstoqueMin` decimal(9,4) unsigned DEFAULT '0.0000',
  `idOperador` int(10) unsigned DEFAULT NULL,
  `tpManufatura` varchar(1) DEFAULT 'T' COMMENT 'P: propria; T: terceiros',
  `IAT` varchar(1) DEFAULT 'A' COMMENT 'Indicador de Arredondamento ou Truncamento',
  `pSN` decimal(5,2) unsigned DEFAULT '0.00' COMMENT 'percentual do Simples Nacional',
  `cstICMS` varchar(3) DEFAULT NULL COMMENT 'CST ou CSOSN',
  `pRedICMS` decimal(5,2) unsigned DEFAULT '0.00' COMMENT 'percentual de reduçao da base de calculo do ICMS',
  `pICMS` decimal(5,2) unsigned DEFAULT '0.00' COMMENT 'Aliquota do ICMS',
  `pAgrICMSST` decimal(5,2) unsigned DEFAULT '0.00' COMMENT 'percentual de adiçao da base de calculo do ICMS ST',
  `pRedICMSST` decimal(5,2) unsigned DEFAULT '0.00' COMMENT 'percentual de reduçao da base de calculo do ICMS ST',
  `pICMSST` decimal(5,2) unsigned DEFAULT '0.00' COMMENT 'Aliquota do ICMS ST',
  `cstIPI` varchar(2) DEFAULT NULL,
  `pIPI` decimal(5,2) unsigned DEFAULT '0.00' COMMENT 'Aliquota do IPI',
  `exIPI` varchar(2) DEFAULT '0' COMMENT 'Código EX, conforme a tabela do IPI',
  `cstPIS` varchar(2) DEFAULT NULL,
  `pPIS` decimal(5,2) unsigned DEFAULT '0.00' COMMENT 'Aliquota do PIS',
  `idNatReceitaPIS` int(10) unsigned DEFAULT NULL,
  `natReceitaPIS` varchar(6) DEFAULT NULL,
  `natComtribuicaoEstPIS` varchar(2) DEFAULT NULL COMMENT 'Natureza da Contribuição do Estorno PIS. conforme tabela 4.3.5 do SPED',
  `natCreditoEstPIS` varchar(3) DEFAULT NULL COMMENT 'Natureza do Crédito do Estorno PIS. conforme tabela 4.3.6 do SPED',
  `cstCOFINS` varchar(2) DEFAULT NULL,
  `pCOFINS` decimal(5,2) unsigned DEFAULT '0.00' COMMENT 'Aliquota do COFINS',
  `idNatReceitaCOFINS` int(10) unsigned DEFAULT NULL,
  `natReceitaCOFINS` varchar(6) DEFAULT NULL,
  `natComtribuicaoEstCOFINS` varchar(2) DEFAULT NULL COMMENT 'Natureza da Contribuição do Estorno COFINS. conforme tabela 4.3.5 do SPED',
  `natCreditoEstCOFINS` varchar(3) DEFAULT NULL COMMENT 'Natureza do Crédito do Estorno COFINS. conforme tabela 4.3.6 do SPED',
  `cstICMSEnt` varchar(3) DEFAULT NULL COMMENT 'CST ou CSOSN',
  `pRedICMSEnt` decimal(5,2) unsigned DEFAULT '0.00' COMMENT 'percentual de reduçao da base de calculo do ICMS',
  `pICMSEnt` decimal(5,2) unsigned DEFAULT '0.00' COMMENT 'Aliquota do ICMS',
  `pAgrICMSSTEnt` decimal(5,2) unsigned DEFAULT '0.00' COMMENT 'percentual de adiçao da base de calculo do ICMS ST',
  `pRedICMSSTEnt` decimal(5,2) unsigned DEFAULT '0.00' COMMENT 'percentual de reduçao da base de calculo do ICMS ST',
  `pICMSSTEnt` decimal(5,2) unsigned DEFAULT '0.00' COMMENT 'Aliquota do ICMS ST',
  `cstPISEnt` varchar(2) DEFAULT NULL,
  `pPISEnt` decimal(5,2) unsigned DEFAULT '0.00' COMMENT 'Aliquota do PIS',
  `cstCOFINSEnt` varchar(2) DEFAULT NULL,
  `pCOFINSEnt` decimal(5,2) unsigned DEFAULT '0.00' COMMENT 'Aliquota do COFINS',
  `cstIPIEnt` varchar(2) DEFAULT NULL,
  `pIPIEnt` decimal(5,2) unsigned DEFAULT '0.00' COMMENT 'Aliquota do IPI',
  `qtdeDiasVenc` int(10) unsigned DEFAULT '1',
  `cargaBalanca` varchar(1) DEFAULT 'N' COMMENT 'Indica se o produto ira para carga da balança.',
  `valCompra` decimal(9,3) unsigned DEFAULT '0.000',
  `pDescontoComp` decimal(5,2) unsigned DEFAULT '0.00',
  `pImpCompra` decimal(5,2) unsigned DEFAULT '0.00',
  `pImpVenda` decimal(5,2) unsigned DEFAULT '0.00',
  `pFrete` decimal(5,2) unsigned DEFAULT '0.00',
  `pSeguro` decimal(5,2) unsigned DEFAULT '0.00',
  `pOutrDesp` decimal(5,2) unsigned DEFAULT '0.00',
  `valAquisicao` decimal(9,3) unsigned DEFAULT '0.000',
  `pComissao` decimal(5,2) unsigned DEFAULT '0.00',
  `pCusto` decimal(5,2) unsigned DEFAULT '0.00',
  `custo` decimal(9,3) unsigned DEFAULT '0.000',
  `pLucro` decimal(9,3) unsigned DEFAULT '0.000',
  `valVenda` decimal(9,3) unsigned DEFAULT '0.000',
  `controleNumSerie` varchar(1) DEFAULT 'N' COMMENT 'S:sim, N:nao',
  `automatico` varchar(1) DEFAULT 'N' COMMENT 'S:sim, N: não. Indica se um produto foi criado pelo sistema e não pode ser alterado diretamente pelo operador',
  PRIMARY KEY (`idProduto`),
  KEY `FK1_produtos_grupoProdutos` (`idgrupoProduto`),
  CONSTRAINT `FK1_produtos_grupoProdutos` FOREIGN KEY (`idgrupoProduto`) REFERENCES `grupo_produtos` (`idgrupoProduto`) ON DELETE NO ACTION ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=225 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `produtos`
--

INSERT INTO `produtos` (`idProduto`,`idgrupoProduto`,`idCnae`,`codServico`,`codFortes`,`status`,`ncm`,`cest`,`dtCadastro`,`dtAtualizacao`,`nome`,`descricao`,`referencia`,`un`,`codBarras`,`localizacao`,`EstoqueMin`,`idOperador`,`tpManufatura`,`IAT`,`pSN`,`cstICMS`,`pRedICMS`,`pICMS`,`pAgrICMSST`,`pRedICMSST`,`pICMSST`,`cstIPI`,`pIPI`,`exIPI`,`cstPIS`,`pPIS`,`idNatReceitaPIS`,`natReceitaPIS`,`natComtribuicaoEstPIS`,`natCreditoEstPIS`,`cstCOFINS`,`pCOFINS`,`idNatReceitaCOFINS`,`natReceitaCOFINS`,`natComtribuicaoEstCOFINS`,`natCreditoEstCOFINS`,`cstICMSEnt`,`pRedICMSEnt`,`pICMSEnt`,`pAgrICMSSTEnt`,`pRedICMSSTEnt`,`pICMSSTEnt`,`cstPISEnt`,`pPISEnt`,`cstCOFINSEnt`,`pCOFINSEnt`,`cstIPIEnt`,`pIPIEnt`,`qtdeDiasVenc`,`cargaBalanca`,`valCompra`,`pDescontoComp`,`pImpCompra`,`pImpVenda`,`pFrete`,`pSeguro`,`pOutrDesp`,`valAquisicao`,`pComissao`,`pCusto`,`custo`,`pLucro`,`valVenda`,`controleNumSerie`,`automatico`) VALUES 
 (1,3,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','PIZZA JP',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','15.000','N','N'),
 (2,3,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','PIZZA MODA DA CASA',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','14.000','N','N'),
 (3,3,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','PIZZA PORTUGUESA',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','14.000','N','N'),
 (4,3,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','PIZZA FRANGO COM CATUPIRI',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','14.500','N','N'),
 (5,3,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','PIZZA FRANGO',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','13.500','N','N'),
 (6,3,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','PIZZA CALABRESA',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','11.000','N','N'),
 (7,3,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','PIZZA MACEDONA',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','14.500','N','N'),
 (8,3,NULL,NULL,NULL,'A','01039100',NULL,'2016-04-26','2016-04-26','PIZZA BALACUBANA',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','14.000','N','N'),
 (9,3,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','PIZZA CAMARAO',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','15.000','N','N'),
 (10,3,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','PIZZA ATUM',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','16.000','N','N'),
 (11,3,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','PIZZA PICANHA',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','16.000','N','N'),
 (12,3,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','PIZZA CARNE DO SOL',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','17.500','N','N'),
 (13,3,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','PIZZA BOLONHESA',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','13.500','N','N'),
 (14,3,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','PIZZA LOMBINHO',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','14.500','N','N'),
 (15,3,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','PIZZA MISTA',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','10.000','N','N'),
 (16,3,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','PIZZA MARGUERITA',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','13.000','N','N'),
 (17,3,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','PIZZA BACON',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','14.000','N','N'),
 (18,3,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','PIZZA SALAME',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','14.500','N','N'),
 (19,3,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','PIZZA MUSSARELA',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','9.500','N','N'),
 (20,3,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','PIZZA QUATRO QUEIJOS',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','14.500','N','N'),
 (21,3,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','PIZZA SILICIANA',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','14.500','N','N'),
 (22,3,NULL,NULL,NULL,'A','01012000',NULL,'2016-04-26','2016-04-26','PIZZA PALMITO',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','14.000','N','N'),
 (23,3,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','PIZZA TOMATE SECO',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','13.500','N','N'),
 (24,3,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','PIZZA RICOTA C/ MANJERICAO',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','14.500','N','N'),
 (25,3,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','PIZZA HAWAIANA',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','14.000','N','N'),
 (26,3,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','PIZZA PRIMAVERA',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','13.000','N','N'),
 (27,3,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','PIZZA PAULLISTA',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','16.000','N','N'),
 (28,3,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','PIZZA PREDILETA',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','16.000','N','N'),
 (29,3,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','PIZZA BRASILEIRA',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','16.000','N','N'),
 (30,3,NULL,NULL,NULL,'A','01012000',NULL,'2016-04-26','2016-04-26','PIZZA FILE',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','16.000','N','N'),
 (31,3,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','PIZZA FILE C/ CATUPIRY',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','16.500','N','N'),
 (32,3,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','PIZZA FILE COM PALMITO',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','16.500','N','N'),
 (33,3,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','PIZZA PICANHA AO MOLHO MARGUERITA',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','17.000','N','N'),
 (34,3,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','PIZZA CALABRESA AO MOLHO MARGUERITA',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','15.000','N','N'),
 (35,3,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','PIZZA CARNE DO SOL AO MOLHO MARGUERITA',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','16.000','N','N'),
 (36,3,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','PIZZA NORDESTINA',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','15.500','N','N'),
 (37,3,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','PIZZA MILHO VERDE ESPECIAL',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','14.500','N','N'),
 (38,3,NULL,NULL,NULL,'A','01012000',NULL,'2016-04-26','2016-04-26','PIZZA PEPERONE',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','16.000','N','N'),
 (39,3,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','PIZZA BAIANA',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','14.000','N','N'),
 (40,3,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','PIZZA VEGETARIANA',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','15.000','N','N'),
 (41,3,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','PIZZA CROCANTE',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','15.000','N','N'),
 (42,3,NULL,NULL,NULL,'A','01021010',NULL,'2016-04-26','2016-04-26','PIZZA NAPOLITANA',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','16.500','N','N'),
 (43,4,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','PIZZA CHOCOLATE',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','14.000','N','N'),
 (44,4,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','PIZZA CALIFORNIA',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','15.000','N','N'),
 (45,4,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','PIZZA BANANA',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','14.000','N','N'),
 (46,4,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','PIZZA PRESTIGIO',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','14.000','N','N'),
 (47,4,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','PIZZA CHOCOLATE C/ MORANGO',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','16.000','N','N'),
 (48,5,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','PORCAO DE AZEITONA',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','2.500','N','N'),
 (49,5,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','CALABRESA ACEBOLADA ALFACE E TOMATE',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','7.000','N','N'),
 (50,5,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','BATATA FRITA E MOLHO ROSE',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','7.000','N','N'),
 (51,6,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SALGADOS',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','1.500','N','N'),
 (52,6,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','MINI-PIZZA',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','3.000','N','N'),
 (53,6,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','BOLO INTEIRO',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','12.000','N','N'),
 (54,7,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','PUDIM',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','2.000','N','N'),
 (55,7,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','TRUFA RECHEADA',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','1.500','N','N'),
 (56,7,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','BOLO DE POTE',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','2.000','N','N'),
 (57,7,NULL,NULL,NULL,'A','01011900',NULL,'2016-04-26','2016-04-26','MOUSSE',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','2.000','N','N'),
 (58,8,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','PIZZA PEITO DE PERU',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','20.000','N','N'),
 (59,8,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','PIZZA FRANCO C/ CREM DE RICOTA',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','20.000','N','N'),
 (60,8,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','PIZZA FRANCO C/ PASSAS E REQUEIJAO',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','18.000','N','N'),
 (61,8,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','PIZZA RUCULA C/ TOMATE CEREJA',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','17.000','N','N'),
 (62,8,NULL,NULL,NULL,'A','01012000',NULL,'2016-04-26','2016-04-26','PIZZA PRESUNTO LIGHT',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','17.000','N','N'),
 (63,9,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SAND QUEIJO BRANCO C/ PEITO DE PERU',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','6.000','N','N'),
 (64,9,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SAND FRANGO C/ CREME DE RICOTA',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','8.000','N','N'),
 (65,9,NULL,NULL,NULL,'A','01029090',NULL,'2016-04-26','2016-04-26','SAND FRANGO C/ PASSAS E REQUEIJAO',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','8.000','N','N'),
 (66,9,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SAND LIGHT COM RUCULA',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','6.000','N','N'),
 (67,10,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SUCO VERDE',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','5.000','N','N'),
 (68,10,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SUCO VERDE ENERGIZANTE',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','6.000','N','N'),
 (69,10,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SUCO ROSA',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','6.000','N','N'),
 (70,11,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SAND X - J LANCHES C/ PAO BOLA',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','8.500','N','N'),
 (71,11,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SAND X ARABE',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','16.000','N','N'),
 (72,11,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SAND X - BURGER C/ PAO BOLA',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','5.500','N','N'),
 (73,11,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SAND X CALABRESA C/ PAO BOLA',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','6.000','N','N'),
 (74,11,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SAND X FRANGO C/ PAO BOLA',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','6.000','N','N'),
 (75,11,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SAND X FRANCO C/ CATUPIRY PAO BOLA',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','6.500','N','N'),
 (76,11,NULL,NULL,NULL,'I','01011100',NULL,'2016-04-26','2016-04-26','SAND X BACON C/ PAO BOLA',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','6.500','N','N'),
 (77,11,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SAND X CARNE DO SOL C/ PAO BOLA',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','6.500','N','N'),
 (78,11,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SAND X LOMBINHO C/ PAO BOLA',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','6.500','N','N'),
 (79,11,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SAND X HAWAIANO C/ PAO BOLA',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','6.500','N','N'),
 (80,11,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SAND BAURU C/ PAO BOLA',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','5.500','N','N'),
 (81,11,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SAND AMERICANO C/ PAO BOLA',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','6.500','N','N'),
 (82,11,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SAND X CAMARAO C/ PAO BOLA',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','8.000','N','N'),
 (83,11,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SAND X PICANHA C/ PAO BOLA',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','8.500','N','N'),
 (84,11,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SAND X FILE C/ PAO BOLA',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','8.500','N','N'),
 (85,11,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SAND X PRIMAVERA C/ PAO BOLA',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','6.000','N','N'),
 (86,11,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SAND X SALADA C/ PAO BOLA',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','4.500','N','N'),
 (87,11,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SAND HAMBURGER C/ PAO BOLA',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','3.000','N','N'),
 (88,11,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','MISTO QUENTE C/ PAO BOLA',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','2.500','N','N'),
 (89,11,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SAND X ATUM C/ PAO BOLA',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','8.500','N','N'),
 (90,11,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SAND X BOLONHESA C/ PAO BOLA',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','6.000','N','N'),
 (91,12,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SUCO ABACAXI C/ HORTELA ',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','3.000','N','N'),
 (92,12,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SUCO ABACAXI',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','2.500','N','N'),
 (93,12,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SUCO ACEROLA',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','2.000','N','N'),
 (94,12,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SUCO AMEIXA',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','3.500','N','N'),
 (95,12,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SUCO ACAI',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','4.000','N','N'),
 (96,12,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SUCO BANANA',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','1.500','N','N'),
 (97,12,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SUCO CAJU',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','2.000','N','N'),
 (98,12,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SUCO CAJA',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','3.500','N','N'),
 (99,12,NULL,NULL,NULL,'A','01021010',NULL,'2016-04-26','2016-04-26','SUCO GOIABA',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','2.000','N','N'),
 (100,12,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SUCO GRAVIOLA',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','3.500','N','N'),
 (101,12,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SUCO LARANJA',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','3.000','N','N'),
 (102,12,NULL,NULL,NULL,'A','01011900',NULL,'2016-04-26','2016-04-26','SUCO LARANJA C/ ACEROLA',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','3.500','N','N'),
 (103,12,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SUCO LARANJA C/ MAMAO',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','3.500','N','N'),
 (104,12,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SUCO LIMAO',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','2.500','N','N'),
 (105,12,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SUCO MELAO',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','2.000','N','N'),
 (106,12,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SUCO MACA',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','2.000','N','N'),
 (107,12,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SUCO MAMAO',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','2.000','N','N'),
 (108,12,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SUCO MARACUJA',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','3.000','N','N'),
 (109,12,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SUCO MORANGO',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','3.500','N','N'),
 (110,13,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','RED BULL',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','10.000','N','N'),
 (111,13,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','REFRIGERANTE LATA',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','3.000','N','N'),
 (112,13,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','REFRIGERANTE 600ML',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','4.000','N','N'),
 (113,13,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','REFRIGERANTE 1L',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','5.000','N','N'),
 (114,13,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','REFRIGERANTE 1,5L',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','6.000','N','N'),
 (115,13,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','REFRIGERANTE 2L',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','7.000','N','N'),
 (116,13,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','AGUA MINERAL C/ GAS 600ML',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','2.500','N','N'),
 (117,13,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','AGUA S/ GAS 500ML ',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','2.000','N','N'),
 (118,13,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','AGUARIUS FRESH',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','3.000','N','N'),
 (119,9,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SAND QUEIJO BCO C/ PEITO DE PERU PAO ARABE INT',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','7.000','N','N'),
 (120,9,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SAND FRANGO COM CREME DE RICOTA PAO ARABE INT',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','9.000','N','N'),
 (121,9,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SAND FRANGO COM PASSAS E REQUEIJAO PAO ARABE INT',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','9.000','N','N'),
 (122,9,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SAND LIGHT COM RUCULA PAO ARABE INT',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','7.000','N','N'),
 (123,14,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SAND X - J LANCHES PAO ARABE',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','9.000','N','N'),
 (124,15,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SAND X ARABE PAO INT',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','18.000','N','N'),
 (125,14,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SAND X BURGER PAO ARABE',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','6.000','N','N'),
 (126,15,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SAND X BURGER PAO ARABE INT',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','7.000','N','N'),
 (127,14,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SAND X CALABRESA PAO ARABE',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','6.500','N','N'),
 (128,15,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SAND X CALABRESA PAO ARABE INT',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','7.500','N','N'),
 (129,14,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SAND X FRANGO PAO ARABE',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','6.500','N','N'),
 (130,15,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SAND X FRANGO PAO ARABE INT',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','7.500','N','N'),
 (131,14,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SAND X FRANGO C/ CATUPIRI PAO ARABE',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','7.000','N','N'),
 (132,15,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SAND X FRANGO C/ CATUPIRI PAO ARABE INT',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','8.000','N','N'),
 (133,14,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SAND X BACON PAO ARABE ',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','7.000','N','N'),
 (134,15,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SAND X BACON PAO ARABE INT',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','9.000','N','N'),
 (135,14,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SAND X CARNE DE SOL PAO ARABE',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','7.000','N','N'),
 (136,15,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SAND X CARNE DE SOL PAO ARABE INT',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','8.000','N','N'),
 (137,14,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SAND X LOMBINHO PAO ARABE',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','7.000','N','N'),
 (138,15,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SAND X LOMBINHO PAO ARABE INT',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','8.000','N','N'),
 (139,14,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SAND X HAWAIANO PAO ARABE',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','7.000','N','N'),
 (140,15,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SAND X HAWAIANO PAO ARABE INT',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','8.000','N','N'),
 (141,14,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SAND BAURU PAO ARABE',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','6.000','N','N'),
 (142,15,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SAND BAURU PAO ARABE INT',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','7.000','N','N'),
 (143,14,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SAND AMERICANO PAO ARABE',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','6.000','N','N'),
 (144,15,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SAND AMERICANO PAO ARABE INT',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','7.000','N','N'),
 (145,14,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SAND X CAMARAO PAO ARABE ',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','8.500','N','N');
INSERT INTO `produtos` (`idProduto`,`idgrupoProduto`,`idCnae`,`codServico`,`codFortes`,`status`,`ncm`,`cest`,`dtCadastro`,`dtAtualizacao`,`nome`,`descricao`,`referencia`,`un`,`codBarras`,`localizacao`,`EstoqueMin`,`idOperador`,`tpManufatura`,`IAT`,`pSN`,`cstICMS`,`pRedICMS`,`pICMS`,`pAgrICMSST`,`pRedICMSST`,`pICMSST`,`cstIPI`,`pIPI`,`exIPI`,`cstPIS`,`pPIS`,`idNatReceitaPIS`,`natReceitaPIS`,`natComtribuicaoEstPIS`,`natCreditoEstPIS`,`cstCOFINS`,`pCOFINS`,`idNatReceitaCOFINS`,`natReceitaCOFINS`,`natComtribuicaoEstCOFINS`,`natCreditoEstCOFINS`,`cstICMSEnt`,`pRedICMSEnt`,`pICMSEnt`,`pAgrICMSSTEnt`,`pRedICMSSTEnt`,`pICMSSTEnt`,`cstPISEnt`,`pPISEnt`,`cstCOFINSEnt`,`pCOFINSEnt`,`cstIPIEnt`,`pIPIEnt`,`qtdeDiasVenc`,`cargaBalanca`,`valCompra`,`pDescontoComp`,`pImpCompra`,`pImpVenda`,`pFrete`,`pSeguro`,`pOutrDesp`,`valAquisicao`,`pComissao`,`pCusto`,`custo`,`pLucro`,`valVenda`,`controleNumSerie`,`automatico`) VALUES 
 (146,15,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SAND X CAMARAO PAO ARABE INT',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','9.500','N','N'),
 (147,14,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SAND X PICANHA PAO ARABE',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','9.000','N','N'),
 (148,15,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SAND X PICANHA PAO ARABE INT',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','10.000','N','N'),
 (149,14,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SAND X FILE PAO ARABE ',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','9.000','N','N'),
 (150,15,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SAND X FILE PAO ARABE INT',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','10.000','N','N'),
 (151,14,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SAND X PRIMAVERA PAO ARABE',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','6.500','N','N'),
 (152,15,NULL,NULL,NULL,'A','01011900',NULL,'2016-04-26','2016-04-26','SAND X PRIMAVERA PAO ARABE INT',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','7.500','N','N'),
 (153,14,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SAND X SALADA PAO ARABE',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','5.000','N','N'),
 (154,15,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SAND X SALADA PAO ARABE INT',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','6.000','N','N'),
 (155,14,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SAND HAMBURGER PAO ARABE',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','3.500','N','N'),
 (156,15,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SAND HAMBURGER PAO ARABE INT',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','4.500','N','N'),
 (157,14,NULL,NULL,NULL,'A','01012000',NULL,'2016-04-26','2016-04-26','MISTO QUENTE PAO ARABE',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','3.000','N','N'),
 (158,15,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','MISTO QUENTE PAO ARABE INT',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','4.000','N','N'),
 (159,14,NULL,NULL,NULL,'A','01021010',NULL,'2016-04-26','2016-04-26','SAND X ATUM PAO ARABE',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','9.000','N','N'),
 (160,15,NULL,NULL,NULL,'A','01012000',NULL,'2016-04-26','2016-04-26','SAND X ATUM PAO ARABE INT',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','10.000','N','N'),
 (161,14,NULL,NULL,NULL,'A','01012000',NULL,'2016-04-26','2016-04-26','SAND X BOLONHESA PAO ARABE',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','6.500','N','N'),
 (162,15,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SAND X BOLONHESA PAO ARABE INT',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','7.500','N','N'),
 (163,15,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SAND X - J LANCHES PAO ARABE INT',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','10.000','N','N'),
 (164,16,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SUCO ABACAXI E HORTELA C/ LEITE',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','3.500','N','N'),
 (165,16,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SUCO ABACAXI C/LEITE',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','3.000','N','N'),
 (166,16,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SUCO ACEROLA C/LEITE',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','2.500','N','N'),
 (167,16,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SUCO AMEIXA C/LEITE',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','4.000','N','N'),
 (168,16,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SUCO ACAI C/LEITE',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','5.000','N','N'),
 (169,16,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SUCO BANANA C/LEITE',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','2.000','N','N'),
 (170,16,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SUCO CAJU C/LEITE',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','2.500','N','N'),
 (171,16,NULL,NULL,NULL,'A','01021010',NULL,'2016-04-26','2016-04-26','SUCO CAJA C/LEITE',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','4.000','N','N'),
 (172,16,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SUCO GOIABA C/LEITE',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','2.500','N','N'),
 (173,16,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SUCO GRAVIOLA C/LEITE',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','4.000','N','N'),
 (174,16,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SUCO MELAO C/LEITE',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','2.500','N','N'),
 (175,16,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SUCO MACA C/LEITE',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','2.500','N','N'),
 (176,16,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SUCO MAMAO C/LEITE',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','2.500','N','N'),
 (177,16,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SUCO MARACUJA C/LEITE',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','4.000','N','N'),
 (178,16,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','SUCO MORANGO C/LEITE',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','4.000','N','N'),
 (179,17,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','JARRA SUCO ABACAXI C/ HORTELA',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','7.000','N','N'),
 (180,17,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','JARRA SUCO ABACAXI',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','6.000','N','N'),
 (181,17,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','JARRA SUCO ACEROLA',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','5.000','N','N'),
 (182,17,NULL,NULL,NULL,'A','01011900',NULL,'2016-04-26','2016-04-26','JARRA SUCO AMEIXA',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','7.000','N','N'),
 (183,17,NULL,NULL,NULL,'A','01011900',NULL,'2016-04-26','2016-04-26','JARRA SUCO ACAI',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','8.500','N','N'),
 (184,17,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','JARRA SUCO BANANA',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','4.000','N','N'),
 (185,17,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','JARRA SUCO CAJU',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','5.000','N','N'),
 (186,17,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','JARRA SUCO CAJA ',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','7.000','N','N'),
 (187,17,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','JARRA SUCO GOIABA',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','5.000','N','N'),
 (188,17,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','JARRA SUCO GRAVIOLA',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','7.000','N','N'),
 (189,17,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','JARRA SUCO LARANJA',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','7.000','N','N'),
 (190,17,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','JARRA SUCO LARANJA C/ ACEROLA',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','8.000','N','N'),
 (191,17,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','JARRA SUCO LARANJA C/ MAMAO',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','8.000','N','N'),
 (192,17,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','JARRA SUCO LIMAO',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','6.000','N','N'),
 (193,17,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','JARRA SUCO MELAO',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','5.000','N','N'),
 (194,17,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','JARRA SUCO MACA',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','5.000','N','N'),
 (195,17,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','JARRA SUCO MAMAO',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','5.000','N','N'),
 (196,17,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','JARRA SUCO MARACUJA',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','6.500','N','N'),
 (197,17,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','JARRA SUCO MORANGO',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','7.000','N','N'),
 (198,18,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','JARRA SUCO ABACAXI HORTELA C/ LEITE',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','8.000','N','N'),
 (199,18,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','JARRA SUCO ABACAXI C/LEITE',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','7.000','N','N'),
 (200,18,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','JARRA SUCO ACEROLA C/LEITE',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','6.000','N','N'),
 (201,18,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','JARRA SUCO AMEIXA C/LEITE',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','8.500','N','N'),
 (202,18,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','JARRA SUCO ACAI C/LEITE',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','10.000','N','N'),
 (203,18,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','JARRA SUCO BANANA C/LEITE',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','5.000','N','N'),
 (204,18,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','JARRA SUCO CAJU C/LEITE',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','6.000','N','N'),
 (205,18,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','JARRA SUCO CAJA C/LEITE',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','8.500','N','N'),
 (206,18,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','JARRA SUCO GOIABA C/LEITE',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','6.000','N','N'),
 (207,18,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','JARRA SUCO GRAVIOLA C/LEITE',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','8.500','N','N'),
 (208,18,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','JARRA SUCO MELAO C/LEITE',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','6.000','N','N'),
 (209,18,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','JARRA SUCO MACA C/LEITE',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','6.000','N','N'),
 (210,18,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','JARRA SUCO MAMAO C/LEITE',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','6.000','N','N'),
 (211,18,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','JARRA SUCO MARACUJA C/LEITE',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','8.500','N','N'),
 (212,18,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','JARRA SUCO MORANGO C/LEITE',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','8.500','N','N'),
 (213,2,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','BORDA RECHEADA C/ CATUPIRI OPCIONAL (B-P)',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','3.000','N','N'),
 (214,2,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','BORDA RECHEADA C/ MUSSARELA OPCIONAL (B-P) ',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','3.000','N','N'),
 (215,2,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','BORDA RECHEADA C/CHEEDAR OPCIONAL (B-P)',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','4.000','N','N'),
 (216,2,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','BORDA RECHEADA C/ CREAM CHEESE OPCIONAL (B-P)',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','6.000','N','N'),
 (217,2,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','BORDA RECHEADA C/ REQUEIJAO OPCIONAL (B-P)',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','4.000','N','N'),
 (218,2,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','BORDA RECHEADA C/ CHOCOLATE OPCIONAL (B-P)',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','3.000','N','N'),
 (219,2,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','BORDA RECHEADA C/ CATUPIRI OPCIONAL (M-G)',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','4.000','N','N'),
 (220,2,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','BORDA RECHEADA C/ MUSSARELA OPCIONAL (M-G)',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','4.000','N','N'),
 (221,2,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','BORDA RECHEADA C/CHEDDAR OPCIONAL (M-G)',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','5.000','N','N'),
 (222,2,NULL,NULL,NULL,'I','01011100',NULL,'2016-04-26','2016-04-26','BORDA RECHEADA C/ CREAM CHEESE (M-G)',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','8.000','N','N'),
 (223,2,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','BORDA RECHEADA C/ REQUEIJAO OPCIONAL (M-G)',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','5.000','N','N'),
 (224,2,NULL,NULL,NULL,'A','01011100',NULL,'2016-04-26','2016-04-26','BORDA RECHEADA C/ CHOCOLATE OPCIONAL (M-G)',NULL,NULL,'UN',NULL,NULL,'0.0000',NULL,'T','A','0.00','300','0.00','0.00','0.00','0.00','0.00','99','0.00','0','','0.00',NULL,NULL,'','','','0.00',NULL,NULL,'','','300','0.00','0.00','0.00','0.00','0.00','','0.00','','0.00','49','0.00',1,'N','0.000','0.00','0.00','0.00','0.00','0.00','0.00','0.000','0.00','0.00','0.000','0.000','4.000','N','N');


--
-- Definition of trigger `produtos_after_insert_tr`
--

DROP TRIGGER /*!50030 IF EXISTS */ `produtos_after_insert_tr`;

DELIMITER $$

CREATE DEFINER = `root`@`localhost` TRIGGER `produtos_after_insert_tr` AFTER INSERT ON `produtos` FOR EACH ROW BEGIN
  INSERT INTO stoc_chef.`produtos_estoque`(`idProduto`) VALUES(NEW.idProduto);
END $$

DELIMITER ;

--
-- Definition of table `produtos_estoque`
--

CREATE TABLE `produtos_estoque` (
  `idProduto` bigint(20) unsigned NOT NULL,
  `estoque` decimal(10,3) DEFAULT '0.000',
  `alterado` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`idProduto`),
  CONSTRAINT `fk_produtos_estoque_produtos` FOREIGN KEY (`idProduto`) REFERENCES `produtos` (`idProduto`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `produtos_estoque`
--

INSERT INTO `produtos_estoque` (`idProduto`,`estoque`,`alterado`) VALUES 
 (1,'0.000','2016-04-26 10:54:26'),
 (2,'0.000','2016-04-26 10:55:56'),
 (3,'0.000','2016-04-26 10:56:40'),
 (4,'0.000','2016-04-26 10:57:07'),
 (5,'0.000','2016-04-26 10:57:38'),
 (6,'0.000','2016-04-26 10:57:51'),
 (7,'0.000','2016-04-26 10:58:14'),
 (8,'0.000','2016-04-26 10:58:32'),
 (9,'0.000','2016-04-26 10:58:45'),
 (10,'0.000','2016-04-26 10:58:57'),
 (11,'0.000','2016-04-26 10:59:14'),
 (12,'0.000','2016-04-26 10:59:29'),
 (13,'0.000','2016-04-26 13:06:22'),
 (14,'0.000','2016-04-26 13:06:36'),
 (15,'0.000','2016-04-26 13:06:57'),
 (16,'0.000','2016-04-26 13:07:12'),
 (17,'0.000','2016-04-26 13:07:24'),
 (18,'0.000','2016-04-26 13:07:39'),
 (19,'0.000','2016-04-26 13:07:52'),
 (20,'0.000','2016-04-26 13:08:08'),
 (21,'0.000','2016-04-26 13:08:50'),
 (22,'0.000','2016-04-26 13:09:05'),
 (23,'0.000','2016-04-26 13:09:22'),
 (24,'0.000','2016-04-26 13:09:42'),
 (25,'0.000','2016-04-26 13:09:58'),
 (26,'0.000','2016-04-26 13:10:10'),
 (27,'0.000','2016-04-26 13:10:36'),
 (28,'0.000','2016-04-26 13:10:47'),
 (29,'0.000','2016-04-26 13:10:57'),
 (30,'0.000','2016-04-26 13:11:15'),
 (31,'0.000','2016-04-26 13:11:35'),
 (32,'0.000','2016-04-26 13:12:10'),
 (33,'0.000','2016-04-26 13:12:32'),
 (34,'0.000','2016-04-26 13:13:22'),
 (35,'0.000','2016-04-26 13:13:37'),
 (36,'0.000','2016-04-26 13:13:51'),
 (37,'0.000','2016-04-26 13:14:12'),
 (38,'0.000','2016-04-26 13:14:24'),
 (39,'0.000','2016-04-26 13:14:38'),
 (40,'0.000','2016-04-26 13:14:49'),
 (41,'0.000','2016-04-26 13:15:06'),
 (42,'0.000','2016-04-26 13:15:21'),
 (43,'0.000','2016-04-26 13:16:42'),
 (44,'0.000','2016-04-26 13:17:38'),
 (45,'0.000','2016-04-26 13:17:49'),
 (46,'0.000','2016-04-26 13:18:08'),
 (47,'0.000','2016-04-26 13:18:25'),
 (48,'0.000','2016-04-26 13:19:09'),
 (49,'0.000','2016-04-26 13:19:31'),
 (50,'0.000','2016-04-26 13:19:51'),
 (51,'0.000','2016-04-26 13:20:03'),
 (52,'0.000','2016-04-26 13:20:20'),
 (53,'0.000','2016-04-26 13:20:53'),
 (54,'0.000','2016-04-26 13:21:08'),
 (55,'0.000','2016-04-26 13:21:19'),
 (56,'0.000','2016-04-26 13:21:35'),
 (57,'0.000','2016-04-26 13:21:45'),
 (58,'0.000','2016-04-26 13:22:59'),
 (59,'0.000','2016-04-26 13:23:23'),
 (60,'0.000','2016-04-26 13:23:46'),
 (61,'0.000','2016-04-26 13:24:07'),
 (62,'0.000','2016-04-26 13:24:25'),
 (63,'0.000','2016-04-26 13:25:09'),
 (64,'0.000','2016-04-26 13:25:25'),
 (65,'0.000','2016-04-26 13:25:54'),
 (66,'0.000','2016-04-26 13:26:33'),
 (67,'0.000','2016-04-26 13:26:48'),
 (68,'0.000','2016-04-26 13:27:12'),
 (69,'0.000','2016-04-26 13:27:28'),
 (70,'0.000','2016-04-26 13:28:54'),
 (71,'0.000','2016-04-26 13:29:15'),
 (72,'0.000','2016-04-26 13:29:36'),
 (73,'0.000','2016-04-26 13:33:09'),
 (74,'0.000','2016-04-26 13:33:29'),
 (75,'0.000','2016-04-26 13:35:49'),
 (76,'0.000','2016-04-26 13:36:00'),
 (77,'0.000','2016-04-26 13:36:24'),
 (78,'0.000','2016-04-26 13:37:39'),
 (79,'0.000','2016-04-26 13:37:59'),
 (80,'0.000','2016-04-26 13:38:17'),
 (81,'0.000','2016-04-26 13:38:51'),
 (82,'0.000','2016-04-26 13:39:07'),
 (83,'0.000','2016-04-26 13:40:18'),
 (84,'0.000','2016-04-26 13:40:38'),
 (85,'0.000','2016-04-26 13:41:24'),
 (86,'0.000','2016-04-26 13:41:47'),
 (87,'0.000','2016-04-26 13:42:12'),
 (88,'0.000','2016-04-26 13:42:47'),
 (89,'0.000','2016-04-26 13:45:56'),
 (90,'0.000','2016-04-26 13:46:16'),
 (91,'0.000','2016-04-26 13:51:34'),
 (92,'0.000','2016-04-26 13:52:05'),
 (93,'0.000','2016-04-26 13:53:29'),
 (94,'0.000','2016-04-26 13:53:49'),
 (95,'0.000','2016-04-26 13:56:30'),
 (96,'0.000','2016-04-26 13:57:16'),
 (97,'0.000','2016-04-26 13:57:36'),
 (98,'0.000','2016-04-26 13:57:52'),
 (99,'0.000','2016-04-26 13:58:05'),
 (100,'0.000','2016-04-26 13:58:17'),
 (101,'0.000','2016-04-26 13:59:04'),
 (102,'0.000','2016-04-26 13:59:17'),
 (103,'0.000','2016-04-26 13:59:29'),
 (104,'0.000','2016-04-26 13:59:45'),
 (105,'0.000','2016-04-26 14:00:02'),
 (106,'0.000','2016-04-26 14:00:12'),
 (107,'0.000','2016-04-26 14:01:04'),
 (108,'0.000','2016-04-26 14:01:17'),
 (109,'0.000','2016-04-26 14:01:43'),
 (110,'0.000','2016-04-26 14:02:53'),
 (111,'0.000','2016-04-26 14:03:12'),
 (112,'0.000','2016-04-26 14:03:27'),
 (113,'0.000','2016-04-26 14:03:44'),
 (114,'0.000','2016-04-26 14:03:58'),
 (115,'0.000','2016-04-26 14:04:12'),
 (116,'0.000','2016-04-26 14:04:39'),
 (117,'0.000','2016-04-26 14:04:56'),
 (118,'0.000','2016-04-26 14:05:10'),
 (119,'0.000','2016-04-26 14:58:48'),
 (120,'0.000','2016-04-26 14:59:30'),
 (121,'0.000','2016-04-26 15:00:10'),
 (122,'0.000','2016-04-26 15:00:53'),
 (123,'0.000','2016-04-26 15:02:05'),
 (124,'0.000','2016-04-26 15:12:55'),
 (125,'0.000','2016-04-26 15:13:25'),
 (126,'0.000','2016-04-26 15:13:46'),
 (127,'0.000','2016-04-26 15:16:31'),
 (128,'0.000','2016-04-26 15:16:47'),
 (129,'0.000','2016-04-26 15:17:19'),
 (130,'0.000','2016-04-26 15:17:41'),
 (131,'0.000','2016-04-26 15:19:09'),
 (132,'0.000','2016-04-26 15:19:32'),
 (133,'0.000','2016-04-26 15:20:32'),
 (134,'0.000','2016-04-26 15:20:46'),
 (135,'0.000','2016-04-26 15:21:20'),
 (136,'0.000','2016-04-26 15:21:28'),
 (137,'0.000','2016-04-26 15:21:48'),
 (138,'0.000','2016-04-26 15:22:03'),
 (139,'0.000','2016-04-26 15:22:58'),
 (140,'0.000','2016-04-26 15:23:15'),
 (141,'0.000','2016-04-26 15:23:31'),
 (142,'0.000','2016-04-26 15:23:47'),
 (143,'0.000','2016-04-26 15:23:58'),
 (144,'0.000','2016-04-26 15:24:19'),
 (145,'0.000','2016-04-26 15:24:44'),
 (146,'0.000','2016-04-26 15:24:56'),
 (147,'0.000','2016-04-26 15:25:43'),
 (148,'0.000','2016-04-26 15:25:54'),
 (149,'0.000','2016-04-26 15:26:16'),
 (150,'0.000','2016-04-26 15:26:31'),
 (151,'0.000','2016-04-26 15:26:50'),
 (152,'0.000','2016-04-26 15:27:10'),
 (153,'0.000','2016-04-26 15:27:26'),
 (154,'0.000','2016-04-26 15:29:42'),
 (155,'0.000','2016-04-26 15:31:30'),
 (156,'0.000','2016-04-26 15:31:42'),
 (157,'0.000','2016-04-26 15:31:59'),
 (158,'0.000','2016-04-26 15:32:10'),
 (159,'0.000','2016-04-26 15:32:34'),
 (160,'0.000','2016-04-26 15:32:45'),
 (161,'0.000','2016-04-26 15:33:11'),
 (162,'0.000','2016-04-26 15:33:27'),
 (163,'0.000','2016-04-26 15:35:13'),
 (164,'0.000','2016-04-26 15:38:33'),
 (165,'0.000','2016-04-26 15:39:26'),
 (166,'0.000','2016-04-26 15:39:52'),
 (167,'0.000','2016-04-26 15:41:32'),
 (168,'0.000','2016-04-26 15:41:50'),
 (169,'0.000','2016-04-26 15:42:11'),
 (170,'0.000','2016-04-26 15:42:22'),
 (171,'0.000','2016-04-26 15:42:35'),
 (172,'0.000','2016-04-26 15:42:47'),
 (173,'0.000','2016-04-26 15:42:57'),
 (174,'0.000','2016-04-26 15:43:57'),
 (175,'0.000','2016-04-26 15:44:08'),
 (176,'0.000','2016-04-26 15:44:23'),
 (177,'0.000','2016-04-26 15:44:37'),
 (178,'0.000','2016-04-26 15:44:49'),
 (179,'0.000','2016-04-26 15:46:08'),
 (180,'0.000','2016-04-26 15:46:25'),
 (181,'0.000','2016-04-26 15:46:39'),
 (182,'0.000','2016-04-26 15:47:06'),
 (183,'0.000','2016-04-26 15:47:18'),
 (184,'0.000','2016-04-26 15:47:35'),
 (185,'0.000','2016-04-26 15:48:35'),
 (186,'0.000','2016-04-26 15:48:45'),
 (187,'0.000','2016-04-26 15:48:57'),
 (188,'0.000','2016-04-26 15:49:07'),
 (189,'0.000','2016-04-26 15:49:17'),
 (190,'0.000','2016-04-26 15:49:39'),
 (191,'0.000','2016-04-26 15:49:57'),
 (192,'0.000','2016-04-26 15:50:08'),
 (193,'0.000','2016-04-26 15:50:19'),
 (194,'0.000','2016-04-26 15:50:31'),
 (195,'0.000','2016-04-26 15:50:44'),
 (196,'0.000','2016-04-26 15:50:54'),
 (197,'0.000','2016-04-26 15:51:05'),
 (198,'0.000','2016-04-26 15:52:42'),
 (199,'0.000','2016-04-26 15:53:03'),
 (200,'0.000','2016-04-26 15:53:20'),
 (201,'0.000','2016-04-26 15:53:37'),
 (202,'0.000','2016-04-26 15:56:32'),
 (203,'0.000','2016-04-26 15:56:51'),
 (204,'0.000','2016-04-26 15:57:15'),
 (205,'0.000','2016-04-26 15:57:29'),
 (206,'0.000','2016-04-26 15:57:40'),
 (207,'0.000','2016-04-26 15:57:54'),
 (208,'0.000','2016-04-26 15:58:20'),
 (209,'0.000','2016-04-26 15:58:33'),
 (210,'0.000','2016-04-26 15:58:46'),
 (211,'0.000','2016-04-26 15:59:01'),
 (212,'0.000','2016-04-26 15:59:12'),
 (213,'0.000','2016-04-26 16:03:17'),
 (214,'0.000','2016-04-26 16:03:51'),
 (215,'0.000','2016-04-26 16:05:10'),
 (216,'0.000','2016-04-26 16:05:42'),
 (217,'0.000','2016-04-26 16:06:26'),
 (218,'0.000','2016-04-26 16:06:49'),
 (219,'0.000','2016-04-26 16:08:07'),
 (220,'0.000','2016-04-26 16:09:11'),
 (221,'0.000','2016-04-26 16:09:52'),
 (222,'0.000','2016-04-26 16:10:25'),
 (223,'0.000','2016-04-26 16:10:51'),
 (224,'0.000','2016-04-26 16:11:24');


--
-- Definition of table `produtos_imagem`
--

CREATE TABLE `produtos_imagem` (
  `idImagem` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `idProduto` bigint(20) unsigned DEFAULT NULL,
  `nome` varchar(50) DEFAULT NULL,
  `base64` mediumtext,
  PRIMARY KEY (`idImagem`),
  KEY `FK_imagem_produtos` (`idProduto`),
  CONSTRAINT `FK_imagem_produtos` FOREIGN KEY (`idProduto`) REFERENCES `produtos` (`idProduto`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `produtos_imagem`
--



--
-- Definition of table `produtos_tamanho`
--

CREATE TABLE `produtos_tamanho` (
  `idProduto` bigint(20) unsigned NOT NULL,
  `idTamanho` int(10) unsigned NOT NULL,
  `valor` decimal(9,3) unsigned DEFAULT '0.000',
  PRIMARY KEY (`idProduto`,`idTamanho`),
  KEY `FK_produtosTamanho_tamanho` (`idTamanho`),
  CONSTRAINT `FK_produtosTamanho_produtos` FOREIGN KEY (`idProduto`) REFERENCES `produtos` (`idProduto`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_produtosTamanho_tamanho` FOREIGN KEY (`idTamanho`) REFERENCES `tamanho` (`idTamanho`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `produtos_tamanho`
--

INSERT INTO `produtos_tamanho` (`idProduto`,`idTamanho`,`valor`) VALUES 
 (1,1,'15.000'),
 (1,2,'18.000'),
 (1,3,'23.000'),
 (1,4,'28.000'),
 (1,5,'50.000'),
 (2,1,'14.000'),
 (2,2,'17.000'),
 (2,3,'21.000'),
 (2,4,'25.000'),
 (2,5,'45.000'),
 (3,1,'14.000'),
 (3,2,'17.000'),
 (3,3,'22.000'),
 (3,4,'26.000'),
 (3,5,'47.000'),
 (4,1,'14.500'),
 (4,2,'17.500'),
 (4,3,'22.000'),
 (4,4,'26.000'),
 (4,5,'47.000'),
 (5,1,'13.500'),
 (5,2,'17.000'),
 (5,3,'21.000'),
 (5,4,'25.000'),
 (5,5,'45.000'),
 (6,1,'11.000'),
 (6,2,'14.500'),
 (6,3,'18.000'),
 (6,4,'21.000'),
 (6,5,'38.000'),
 (7,1,'14.500'),
 (7,2,'17.500'),
 (7,3,'22.000'),
 (7,4,'26.000'),
 (7,5,'47.000'),
 (8,1,'14.000'),
 (8,2,'17.000'),
 (8,3,'21.000'),
 (8,4,'26.000'),
 (8,5,'47.000'),
 (9,1,'15.000'),
 (9,2,'17.500'),
 (9,3,'22.000'),
 (9,4,'27.000'),
 (9,5,'48.000'),
 (10,1,'16.000'),
 (10,2,'20.000'),
 (10,3,'24.000'),
 (10,4,'30.000'),
 (10,5,'53.000'),
 (11,1,'16.000'),
 (11,2,'20.000'),
 (11,3,'25.000'),
 (11,4,'31.000'),
 (11,5,'54.000'),
 (12,1,'14.500'),
 (12,2,'17.500'),
 (12,3,'22.000'),
 (12,4,'26.000'),
 (12,5,'47.000'),
 (13,1,'13.500'),
 (13,2,'17.000'),
 (13,3,'21.000'),
 (13,4,'25.000'),
 (13,5,'45.000'),
 (14,1,'14.500'),
 (14,2,'17.500'),
 (14,3,'22.000'),
 (14,4,'26.000'),
 (14,5,'47.000'),
 (15,1,'10.000'),
 (15,2,'14.000'),
 (15,3,'17.000'),
 (15,4,'21.000'),
 (15,5,'38.000'),
 (16,1,'13.000'),
 (16,2,'16.000'),
 (16,3,'21.000'),
 (16,4,'25.000'),
 (16,5,'45.000'),
 (17,1,'14.000'),
 (17,2,'17.000'),
 (17,3,'21.000'),
 (17,4,'25.000'),
 (17,5,'45.000'),
 (18,1,'14.500'),
 (18,2,'17.500'),
 (18,3,'22.000'),
 (18,4,'26.000'),
 (18,5,'47.000'),
 (19,1,'9.500'),
 (19,2,'13.000'),
 (19,3,'16.000'),
 (19,4,'19.000'),
 (19,5,'35.000'),
 (20,1,'14.500'),
 (20,2,'17.500'),
 (20,3,'22.000'),
 (20,4,'26.000'),
 (20,5,'47.000'),
 (21,1,'14.000'),
 (21,2,'17.500'),
 (21,3,'22.000'),
 (21,4,'26.000'),
 (21,5,'47.000'),
 (22,1,'14.000'),
 (22,2,'17.500'),
 (22,3,'22.000'),
 (22,4,'26.000'),
 (22,5,'47.000'),
 (23,1,'13.500'),
 (23,2,'16.500'),
 (23,3,'21.000'),
 (23,4,'25.000'),
 (23,5,'45.000'),
 (24,1,'14.500'),
 (24,2,'17.500'),
 (24,3,'22.000'),
 (24,4,'26.000'),
 (24,5,'47.000'),
 (25,1,'14.000'),
 (25,2,'17.000'),
 (25,3,'21.000'),
 (25,4,'25.000'),
 (25,5,'45.000'),
 (26,1,'13.000'),
 (26,2,'16.000'),
 (26,3,'20.000'),
 (26,4,'24.000'),
 (26,5,'43.000'),
 (27,1,'16.000'),
 (27,2,'20.000'),
 (27,3,'25.000'),
 (27,4,'30.000'),
 (27,5,'53.000'),
 (28,1,'16.000'),
 (28,2,'20.000'),
 (28,3,'25.000'),
 (28,4,'30.000'),
 (28,5,'53.000'),
 (29,1,'16.000'),
 (29,2,'20.000'),
 (29,3,'26.000'),
 (29,4,'32.000'),
 (29,5,'56.000'),
 (30,1,'16.000'),
 (30,2,'19.000'),
 (30,3,'25.000'),
 (30,4,'31.000'),
 (30,5,'54.000'),
 (31,1,'16.500'),
 (31,2,'19.500'),
 (31,3,'26.000'),
 (31,4,'32.000'),
 (31,5,'55.000'),
 (32,1,'16.500'),
 (32,2,'19.500'),
 (32,3,'26.000'),
 (32,4,'32.000'),
 (32,5,'55.000'),
 (33,1,'17.000'),
 (33,2,'20.000'),
 (33,3,'26.000'),
 (33,4,'33.000'),
 (33,5,'57.000'),
 (34,1,'15.000'),
 (34,2,'19.000'),
 (34,3,'24.000'),
 (34,4,'28.000'),
 (34,5,'50.000'),
 (35,1,'16.000'),
 (35,2,'20.000'),
 (35,3,'25.000'),
 (35,4,'30.000'),
 (35,5,'53.000'),
 (36,1,'15.500'),
 (36,2,'18.500'),
 (36,3,'23.000'),
 (36,4,'27.000'),
 (36,5,'48.000'),
 (37,1,'14.500'),
 (37,2,'17.500'),
 (37,3,'21.000'),
 (37,4,'25.000'),
 (37,5,'45.000'),
 (38,1,'16.000'),
 (38,2,'19.000'),
 (38,3,'25.000'),
 (38,4,'31.000'),
 (38,5,'55.000'),
 (39,1,'14.000'),
 (39,2,'17.000'),
 (39,3,'21.000'),
 (39,4,'25.000'),
 (39,5,'45.000'),
 (40,1,'15.000'),
 (40,2,'18.500'),
 (40,3,'22.000'),
 (40,4,'26.000'),
 (40,5,'47.000'),
 (41,1,'15.000'),
 (41,2,'18.500'),
 (41,3,'23.000'),
 (41,4,'27.000'),
 (41,5,'48.000'),
 (42,1,'16.500'),
 (42,2,'20.000'),
 (42,3,'25.000'),
 (42,4,'30.000'),
 (42,5,'53.000'),
 (43,1,'14.000'),
 (43,2,'17.000'),
 (43,3,'21.000'),
 (43,4,'25.000'),
 (43,5,'45.000'),
 (44,1,'15.000'),
 (44,2,'18.000'),
 (44,3,'22.000'),
 (44,4,'26.000'),
 (44,5,'47.000'),
 (45,1,'14.000'),
 (45,2,'17.000'),
 (45,3,'21.000'),
 (45,4,'25.000'),
 (45,5,'45.000'),
 (46,1,'14.000'),
 (46,2,'17.000'),
 (46,3,'21.000'),
 (46,4,'25.000'),
 (46,5,'45.000'),
 (47,1,'16.000'),
 (47,2,'20.000'),
 (47,3,'25.000'),
 (47,4,'30.000'),
 (47,5,'53.000'),
 (48,1,'0.000'),
 (48,2,'0.000'),
 (48,3,'0.000'),
 (48,4,'0.000'),
 (48,5,'0.000'),
 (49,1,'0.000'),
 (49,2,'0.000'),
 (49,3,'0.000'),
 (49,4,'0.000'),
 (49,5,'0.000'),
 (50,1,'0.000'),
 (50,2,'0.000'),
 (50,3,'0.000'),
 (50,4,'0.000'),
 (50,5,'0.000'),
 (51,1,'0.000'),
 (51,2,'0.000'),
 (51,3,'0.000'),
 (51,4,'0.000'),
 (51,5,'0.000'),
 (52,1,'0.000'),
 (52,2,'0.000'),
 (52,3,'0.000'),
 (52,4,'0.000'),
 (52,5,'0.000'),
 (53,1,'0.000'),
 (53,2,'0.000'),
 (53,3,'0.000'),
 (53,4,'0.000'),
 (53,5,'0.000'),
 (54,1,'0.000'),
 (54,2,'0.000'),
 (54,3,'0.000'),
 (54,4,'0.000'),
 (54,5,'0.000'),
 (55,1,'0.000'),
 (55,2,'0.000'),
 (55,3,'0.000'),
 (55,4,'0.000'),
 (55,5,'0.000'),
 (56,1,'0.000'),
 (56,2,'0.000'),
 (56,3,'0.000'),
 (56,4,'0.000'),
 (56,5,'0.000'),
 (57,1,'0.000'),
 (57,2,'0.000'),
 (57,3,'0.000'),
 (57,4,'0.000'),
 (57,5,'0.000'),
 (58,1,'20.000'),
 (58,2,'26.000'),
 (58,3,'32.000'),
 (58,4,'39.000'),
 (58,5,'0.000'),
 (59,1,'20.000'),
 (59,2,'26.000'),
 (59,3,'32.000'),
 (59,4,'39.000'),
 (59,5,'0.000'),
 (60,1,'18.000'),
 (60,2,'22.000'),
 (60,3,'28.000'),
 (60,4,'35.000'),
 (60,5,'0.000'),
 (61,1,'17.000'),
 (61,2,'21.000'),
 (61,3,'26.000'),
 (61,4,'33.000'),
 (61,5,'0.000'),
 (62,1,'17.000'),
 (62,2,'21.000'),
 (62,3,'26.000'),
 (62,4,'33.000'),
 (62,5,'0.000'),
 (63,1,'0.000'),
 (63,2,'0.000'),
 (63,3,'0.000'),
 (63,4,'0.000'),
 (63,5,'0.000'),
 (64,1,'0.000'),
 (64,2,'0.000'),
 (64,3,'0.000'),
 (64,4,'0.000'),
 (64,5,'0.000'),
 (65,1,'0.000'),
 (65,2,'0.000'),
 (65,3,'0.000'),
 (65,4,'0.000'),
 (65,5,'0.000'),
 (66,1,'0.000'),
 (66,2,'0.000'),
 (66,3,'0.000'),
 (66,4,'0.000'),
 (66,5,'0.000'),
 (67,1,'0.000'),
 (67,2,'0.000'),
 (67,3,'0.000'),
 (67,4,'0.000'),
 (67,5,'0.000'),
 (68,1,'0.000'),
 (68,2,'0.000'),
 (68,3,'0.000'),
 (68,4,'0.000'),
 (68,5,'0.000'),
 (69,1,'0.000'),
 (69,2,'0.000'),
 (69,3,'0.000'),
 (69,4,'0.000'),
 (69,5,'0.000'),
 (70,1,'0.000'),
 (70,2,'0.000'),
 (70,3,'0.000'),
 (70,4,'0.000'),
 (70,5,'0.000'),
 (71,1,'0.000'),
 (71,2,'0.000'),
 (71,3,'0.000'),
 (71,4,'0.000'),
 (71,5,'0.000'),
 (72,1,'0.000'),
 (72,2,'0.000'),
 (72,3,'0.000'),
 (72,4,'0.000'),
 (72,5,'0.000'),
 (73,1,'0.000'),
 (73,2,'0.000'),
 (73,3,'0.000'),
 (73,4,'0.000'),
 (73,5,'0.000'),
 (74,1,'0.000'),
 (74,2,'0.000'),
 (74,3,'0.000'),
 (74,4,'0.000'),
 (74,5,'0.000'),
 (75,1,'0.000'),
 (75,2,'0.000'),
 (75,3,'0.000'),
 (75,4,'0.000'),
 (75,5,'0.000'),
 (76,1,'0.000'),
 (76,2,'0.000'),
 (76,3,'0.000'),
 (76,4,'0.000'),
 (76,5,'0.000'),
 (77,1,'0.000'),
 (77,2,'0.000'),
 (77,3,'0.000'),
 (77,4,'0.000'),
 (77,5,'0.000'),
 (78,1,'0.000'),
 (78,2,'0.000'),
 (78,3,'0.000'),
 (78,4,'0.000'),
 (78,5,'0.000'),
 (79,1,'0.000'),
 (79,2,'0.000'),
 (79,3,'0.000'),
 (79,4,'0.000'),
 (79,5,'0.000'),
 (80,1,'0.000'),
 (80,2,'0.000'),
 (80,3,'0.000'),
 (80,4,'0.000'),
 (80,5,'0.000'),
 (81,1,'0.000'),
 (81,2,'0.000'),
 (81,3,'0.000'),
 (81,4,'0.000'),
 (81,5,'0.000'),
 (82,1,'0.000'),
 (82,2,'0.000'),
 (82,3,'0.000'),
 (82,4,'0.000'),
 (82,5,'0.000'),
 (83,1,'0.000'),
 (83,2,'0.000'),
 (83,3,'0.000'),
 (83,4,'0.000'),
 (83,5,'0.000'),
 (84,1,'0.000'),
 (84,2,'0.000'),
 (84,3,'0.000'),
 (84,4,'0.000'),
 (84,5,'0.000'),
 (85,1,'0.000'),
 (85,2,'0.000'),
 (85,3,'0.000'),
 (85,4,'0.000'),
 (85,5,'0.000'),
 (86,1,'0.000'),
 (86,2,'0.000'),
 (86,3,'0.000'),
 (86,4,'0.000'),
 (86,5,'0.000'),
 (87,1,'0.000'),
 (87,2,'0.000'),
 (87,3,'0.000'),
 (87,4,'0.000'),
 (87,5,'0.000'),
 (88,1,'0.000'),
 (88,2,'0.000'),
 (88,3,'0.000'),
 (88,4,'0.000'),
 (88,5,'0.000'),
 (89,1,'0.000'),
 (89,2,'0.000'),
 (89,3,'0.000'),
 (89,4,'0.000'),
 (89,5,'0.000'),
 (90,1,'0.000'),
 (90,2,'0.000'),
 (90,3,'0.000'),
 (90,4,'0.000'),
 (90,5,'0.000'),
 (91,1,'0.000'),
 (91,2,'0.000'),
 (91,3,'0.000'),
 (91,4,'0.000'),
 (91,5,'0.000'),
 (92,1,'0.000'),
 (92,2,'0.000'),
 (92,3,'0.000'),
 (92,4,'0.000'),
 (92,5,'0.000'),
 (93,1,'0.000'),
 (93,2,'0.000'),
 (93,3,'0.000'),
 (93,4,'0.000'),
 (93,5,'0.000'),
 (94,1,'0.000'),
 (94,2,'0.000'),
 (94,3,'0.000'),
 (94,4,'0.000'),
 (94,5,'0.000'),
 (95,1,'0.000'),
 (95,2,'0.000'),
 (95,3,'0.000'),
 (95,4,'0.000'),
 (95,5,'0.000'),
 (96,1,'0.000'),
 (96,2,'0.000'),
 (96,3,'0.000'),
 (96,4,'0.000'),
 (96,5,'0.000'),
 (97,1,'0.000'),
 (97,2,'0.000'),
 (97,3,'0.000'),
 (97,4,'0.000'),
 (97,5,'0.000'),
 (98,1,'0.000'),
 (98,2,'0.000'),
 (98,3,'0.000'),
 (98,4,'0.000'),
 (98,5,'0.000'),
 (99,1,'0.000'),
 (99,2,'0.000'),
 (99,3,'0.000'),
 (99,4,'0.000'),
 (99,5,'0.000'),
 (100,1,'0.000'),
 (100,2,'0.000'),
 (100,3,'0.000'),
 (100,4,'0.000'),
 (100,5,'0.000'),
 (101,1,'0.000'),
 (101,2,'0.000'),
 (101,3,'0.000'),
 (101,4,'0.000'),
 (101,5,'0.000'),
 (102,1,'0.000'),
 (102,2,'0.000'),
 (102,3,'0.000'),
 (102,4,'0.000'),
 (102,5,'0.000'),
 (103,1,'0.000'),
 (103,2,'0.000'),
 (103,3,'0.000'),
 (103,4,'0.000'),
 (103,5,'0.000'),
 (104,1,'0.000'),
 (104,2,'0.000'),
 (104,3,'0.000'),
 (104,4,'0.000'),
 (104,5,'0.000'),
 (105,1,'0.000'),
 (105,2,'0.000'),
 (105,3,'0.000'),
 (105,4,'0.000'),
 (105,5,'0.000'),
 (106,1,'0.000'),
 (106,2,'0.000'),
 (106,3,'0.000'),
 (106,4,'0.000'),
 (106,5,'0.000'),
 (107,1,'0.000'),
 (107,2,'0.000'),
 (107,3,'0.000'),
 (107,4,'0.000'),
 (107,5,'0.000'),
 (108,1,'0.000'),
 (108,2,'0.000'),
 (108,3,'0.000'),
 (108,4,'0.000'),
 (108,5,'0.000'),
 (109,1,'0.000'),
 (109,2,'0.000'),
 (109,3,'0.000'),
 (109,4,'0.000'),
 (109,5,'0.000'),
 (110,1,'0.000'),
 (110,2,'0.000'),
 (110,3,'0.000'),
 (110,4,'0.000'),
 (110,5,'0.000'),
 (111,1,'0.000'),
 (111,2,'0.000'),
 (111,3,'0.000'),
 (111,4,'0.000'),
 (111,5,'0.000'),
 (112,1,'0.000'),
 (112,2,'0.000'),
 (112,3,'0.000'),
 (112,4,'0.000'),
 (112,5,'0.000'),
 (113,1,'0.000'),
 (113,2,'0.000'),
 (113,3,'0.000'),
 (113,4,'0.000'),
 (113,5,'0.000'),
 (114,1,'0.000'),
 (114,2,'0.000'),
 (114,3,'0.000'),
 (114,4,'0.000'),
 (114,5,'0.000'),
 (115,1,'0.000'),
 (115,2,'0.000'),
 (115,3,'0.000'),
 (115,4,'0.000'),
 (115,5,'0.000'),
 (116,1,'0.000'),
 (116,2,'0.000'),
 (116,3,'0.000'),
 (116,4,'0.000'),
 (116,5,'0.000'),
 (117,1,'0.000'),
 (117,2,'0.000'),
 (117,3,'0.000'),
 (117,4,'0.000'),
 (117,5,'0.000'),
 (118,1,'0.000'),
 (118,2,'0.000'),
 (118,3,'0.000'),
 (118,4,'0.000'),
 (118,5,'0.000');


--
-- Definition of table `qmc`
--

CREATE TABLE `qmc` (
  `idQmc` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `tipo` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '0: Mesa; 1: Cartao; 2: Quarto',
  `codMesaConta` varchar(5) NOT NULL,
  `anexadaA` int(10) unsigned DEFAULT NULL COMMENT 'indica a qual mesa a mesa atual foi anexada',
  `idGrupoQmc` int(10) unsigned DEFAULT NULL,
  `nome` varchar(20) DEFAULT NULL,
  `valor` decimal(6,2) unsigned DEFAULT '0.00',
  `idProduto` bigint(20) unsigned DEFAULT NULL COMMENT 'Registra a id do produto gerado automaticamente e associado ao quarto',
  PRIMARY KEY (`idQmc`),
  KEY `FK1_qmc_grupoQmc` (`idGrupoQmc`),
  CONSTRAINT `FK1_qmc_grupoQmc` FOREIGN KEY (`idGrupoQmc`) REFERENCES `grupo_qmc` (`idGrupoQmc`) ON DELETE NO ACTION ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `qmc`
--



--
-- Definition of table `rps`
--

CREATE TABLE `rps` (
  `numero` int(10) unsigned NOT NULL,
  `codVer` varchar(8) NOT NULL,
  `disponivel` varchar(1) DEFAULT 'S' COMMENT 'Indica se o PRS já foi utilizado',
  PRIMARY KEY (`numero`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `rps`
--



--
-- Definition of table `servicos`
--

CREATE TABLE `servicos` (
  `idServico` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `idVenda` bigint(20) DEFAULT NULL,
  `idPessoa` int(11) DEFAULT NULL,
  `bairro` varchar(30) DEFAULT NULL,
  `logradouro` varchar(40) DEFAULT NULL,
  `numero` varchar(5) DEFAULT NULL,
  `codcidade` varchar(7) DEFAULT NULL,
  `modoServ` varchar(1) DEFAULT 'S' COMMENT 'E: Entrada / S: Saida',
  `dtEmissao` date DEFAULT NULL,
  `dtPrestacao` date DEFAULT NULL,
  `especie` varchar(2) DEFAULT NULL,
  `serie` varchar(6) DEFAULT NULL,
  `chaveNFe` varchar(44) DEFAULT NULL,
  `fContinuo` varchar(1) DEFAULT 'N',
  `statusRps` varchar(1) DEFAULT 'A' COMMENT 'A: Aguardando; E: Enviado; R: Recebido',
  `cancelado` varchar(1) DEFAULT 'N',
  `motivoCancelamento` varchar(50) DEFAULT NULL,
  `vTotal` decimal(10,2) unsigned DEFAULT '0.00',
  `codServio` varchar(2) DEFAULT NULL COMMENT 'Utilizado para estabelecimentos do município de Maceió estado de Alagoas',
  `vRecTribCofins` decimal(10,2) unsigned DEFAULT '0.00',
  `vRecTribPis` decimal(10,2) unsigned DEFAULT '0.00',
  `vRecTribCsl` decimal(10,2) unsigned DEFAULT '0.00',
  `vRecTribIrpj` decimal(10,2) unsigned DEFAULT '0.00',
  `vCofinsRetFonte` decimal(10,2) unsigned DEFAULT '0.00',
  `vPisRetFonte` decimal(10,2) unsigned DEFAULT '0.00',
  `vCslRetFonte` decimal(10,2) unsigned DEFAULT '0.00',
  `vIrpjRetFonte` decimal(10,2) unsigned DEFAULT '0.00',
  `vInssRetFonte` decimal(10,2) unsigned DEFAULT '0.00',
  `vIrrfRetFonte` decimal(10,2) unsigned DEFAULT '0.00',
  `AMIDF` varchar(10) DEFAULT NULL,
  `obs` text,
  `vSus` decimal(10,2) unsigned DEFAULT '0.00',
  `issRetido` varchar(9) DEFAULT 'N',
  PRIMARY KEY (`idServico`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `servicos`
--



--
-- Definition of table `servicos_itens`
--

CREATE TABLE `servicos_itens` (
  `idServico` int(10) unsigned NOT NULL,
  `idItem` int(10) unsigned NOT NULL,
  `cancelado` varchar(1) DEFAULT 'N',
  `motivoCancelamento` varchar(50) DEFAULT NULL,
  `idProduto` bigint(20) unsigned NOT NULL,
  `valUn` decimal(9,3) unsigned DEFAULT '0.000',
  `qtde` decimal(10,3) unsigned DEFAULT '0.000',
  `vSubTotal` decimal(9,2) unsigned DEFAULT '0.00',
  `codigoISS` varchar(6) DEFAULT NULL,
  `atividade` varchar(9) DEFAULT NULL,
  `bcISS` decimal(9,2) unsigned DEFAULT '0.00',
  `aliquotaISS` decimal(5,2) unsigned DEFAULT '0.00',
  `vISS` decimal(9,2) unsigned DEFAULT '0.00',
  `cstPIS` varchar(2) DEFAULT NULL,
  `bcPIS` decimal(9,2) unsigned DEFAULT '0.00' COMMENT 'base de calculo do PIS',
  `pPIS` decimal(5,2) unsigned DEFAULT '0.00' COMMENT 'Aliquota do PIS',
  `vPIS` decimal(9,2) unsigned DEFAULT '0.00',
  `cstCOFINS` varchar(2) DEFAULT NULL,
  `bcCOFINS` decimal(9,2) unsigned DEFAULT '0.00' COMMENT 'base de calculo do COFINS',
  `pCOFINS` decimal(5,2) unsigned DEFAULT '0.00' COMMENT 'Aliquota do COFINS',
  `vCOFINS` decimal(9,2) unsigned DEFAULT '0.00',
  `obs` text,
  `vIRRF` decimal(9,2) unsigned DEFAULT '0.00',
  `vINSS` decimal(9,2) unsigned DEFAULT '0.00',
  `vCSLL` decimal(9,2) unsigned DEFAULT '0.00',
  `numRps` int(10) unsigned DEFAULT NULL,
  `codVerRps` varchar(8) DEFAULT NULL,
  `numNfse` int(10) unsigned DEFAULT NULL,
  `codVerNfse` varchar(8) DEFAULT NULL,
  `deducoes` decimal(9,2) unsigned DEFAULT '0.00',
  `descCondicional` decimal(9,2) unsigned DEFAULT '0.00',
  `descIncondicional` decimal(9,2) unsigned DEFAULT '0.00',
  `retencoesFederais` decimal(9,2) unsigned DEFAULT '0.00',
  `outrasRetencoes` decimal(9,2) unsigned DEFAULT '0.00',
  `vTotal` decimal(9,2) unsigned DEFAULT '0.00',
  PRIMARY KEY (`idServico`,`idItem`),
  KEY `FK_servicosItens_produtos` (`idProduto`),
  CONSTRAINT `FK_servicosItens_produtos` FOREIGN KEY (`idProduto`) REFERENCES `produtos` (`idProduto`) ON DELETE NO ACTION ON UPDATE CASCADE,
  CONSTRAINT `FK_servicosItens_servicos` FOREIGN KEY (`idServico`) REFERENCES `servicos` (`idServico`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `servicos_itens`
--



--
-- Definition of table `setores`
--

CREATE TABLE `setores` (
  `idSetor` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `nome` varchar(25) NOT NULL,
  PRIMARY KEY (`idSetor`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `setores`
--



--
-- Definition of table `setores_por_operador`
--

CREATE TABLE `setores_por_operador` (
  `idOperador` int(10) unsigned NOT NULL,
  `idSetor` int(10) unsigned NOT NULL,
  `idPessoa` int(10) unsigned DEFAULT NULL,
  `senhaMobile` varchar(20) DEFAULT NULL,
  `processos` int(10) unsigned DEFAULT '0',
  PRIMARY KEY (`idOperador`,`idSetor`),
  KEY `fk_operadores_setores1` (`idSetor`),
  CONSTRAINT `fk_operadores_setores1` FOREIGN KEY (`idSetor`) REFERENCES `setores` (`idSetor`) ON DELETE NO ACTION ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `setores_por_operador`
--



--
-- Definition of table `solicitacao`
--

CREATE TABLE `solicitacao` (
  `idSolicitacao` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `status` varchar(1) DEFAULT '0' COMMENT '0: Montando / 1: Aguardando / 2: Negada / 3: Autorizada / 4: Cancelada',
  `dtEmissao` date DEFAULT NULL,
  `hrEmissao` time DEFAULT NULL,
  `dtResposta` date DEFAULT NULL,
  `hrResposta` time DEFAULT NULL,
  `idSolicitante` int(11) DEFAULT NULL COMMENT 'Destinatario/Remetente',
  `nomeSolicitante` varchar(50) DEFAULT NULL,
  `motivoSolicitacao` varchar(50) DEFAULT NULL,
  `motivoCancelamento` varchar(50) DEFAULT NULL,
  `obs` text,
  `idOperador` int(11) DEFAULT NULL,
  PRIMARY KEY (`idSolicitacao`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `solicitacao`
--



--
-- Definition of table `solicitacao_itens`
--

CREATE TABLE `solicitacao_itens` (
  `idSolicitacao` bigint(20) unsigned NOT NULL,
  `idItem` int(4) unsigned NOT NULL,
  `tipo` varchar(1) DEFAULT NULL,
  `idProduto` bigint(20) unsigned NOT NULL,
  `qtde` decimal(9,3) unsigned DEFAULT '0.000',
  `cancelado` varchar(1) DEFAULT 'N' COMMENT 'N: Não, S: Sim',
  PRIMARY KEY (`idSolicitacao`,`idItem`),
  KEY `FK_itensSolicitacao_produtos` (`idProduto`),
  CONSTRAINT `FK_itensSolicitacao_produtos` FOREIGN KEY (`idProduto`) REFERENCES `produtos` (`idProduto`) ON DELETE NO ACTION ON UPDATE CASCADE,
  CONSTRAINT `FK_itensSolicitacao_solicitacao` FOREIGN KEY (`idSolicitacao`) REFERENCES `solicitacao` (`idSolicitacao`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `solicitacao_itens`
--



--
-- Definition of table `sql_sync`
--

CREATE TABLE `sql_sync` (
  `idSqlSync` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `ordem` int(10) unsigned NOT NULL,
  `qtdeTentativas` int(11) DEFAULT '0',
  `sql` varchar(9000) NOT NULL,
  PRIMARY KEY (`idSqlSync`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sql_sync`
--



--
-- Definition of table `tabela_precos`
--

CREATE TABLE `tabela_precos` (
  `idTabelaPreco` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `status` varchar(1) DEFAULT 'A',
  `nome` varchar(30) NOT NULL,
  `descricao` varchar(100) DEFAULT NULL,
  `comissaoVenda` decimal(5,2) DEFAULT '0.00',
  PRIMARY KEY (`idTabelaPreco`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tabela_precos`
--



--
-- Definition of table `tamanho`
--

CREATE TABLE `tamanho` (
  `idTamanho` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `nome` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`idTamanho`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tamanho`
--

INSERT INTO `tamanho` (`idTamanho`,`nome`) VALUES 
 (1,'BROTO - 4 FATIAS'),
 (2,'PEQUENA - 6 FATIAS'),
 (3,'MEDIA - 8 FATIAS'),
 (4,'GRANDE - 10 FATIAS'),
 (5,'GIGANTE - 14 FATIAS');


--
-- Definition of table `tipo_pg`
--

CREATE TABLE `tipo_pg` (
  `codTipoPg` varchar(2) NOT NULL,
  `descricao` varchar(20) NOT NULL,
  `idPessoa` int(10) unsigned DEFAULT NULL COMMENT 'Quando a forma de pagamento possuir uma financeira o contas a receber será lançado no nome dessa financeira (operações com cartão de grédito)',
  `parcelado` varchar(1) DEFAULT 'N' COMMENT 'indica se o valor pago será recebido parcelado ou em cota única com 30 dias',
  `taxa` decimal(5,2) unsigned DEFAULT '0.00' COMMENT 'taxa é o valor descontado da empresa pela operadora ao financiar a venda',
  PRIMARY KEY (`codTipoPg`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tipo_pg`
--



--
-- Definition of table `vendas`
--

CREATE TABLE `vendas` (
  `idVenda` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `idCliente` int(10) unsigned DEFAULT NULL,
  `razaoSocial` varchar(45) DEFAULT NULL,
  `cpfCnpj` varchar(18) DEFAULT NULL,
  `idVendedor` int(10) unsigned DEFAULT NULL,
  `idPlanoVenda` int(10) unsigned DEFAULT NULL,
  `status` varchar(1) DEFAULT 'A' COMMENT 'A: Aberta, R: Reservado, C: Cancelada, F: Finalizada',
  `dtVenda` date DEFAULT NULL,
  `hrVenda` time DEFAULT NULL,
  `comissao` decimal(8,2) unsigned DEFAULT '0.00',
  `custoVenda` decimal(9,3) unsigned DEFAULT '0.000',
  `subtotal` decimal(9,3) unsigned DEFAULT '0.000',
  `pDesconto` decimal(5,3) unsigned DEFAULT '0.000',
  `pAcrescimo` decimal(5,3) unsigned DEFAULT '0.000',
  `vDesconto` decimal(9,3) unsigned DEFAULT '0.000',
  `vAcrescimo` decimal(9,3) unsigned DEFAULT '0.000',
  `tipoFrete` int(11) DEFAULT '1' COMMENT '0:FOB, 1:CIF',
  `frete` decimal(9,3) unsigned DEFAULT '0.000',
  `entrada` varchar(1) DEFAULT 'N',
  `vEntrada` decimal(9,3) unsigned DEFAULT '0.000',
  `pJuros` decimal(5,2) unsigned DEFAULT '0.00',
  `qtdeParcelas` int(10) unsigned DEFAULT NULL,
  `vParcela` decimal(9,3) unsigned DEFAULT '0.000',
  `vTotal` decimal(10,3) unsigned DEFAULT '0.000',
  `intervalo` varchar(100) DEFAULT NULL,
  `obs` text,
  `idOrdemServico` bigint(20) unsigned DEFAULT NULL,
  `placaVeiculo` varchar(8) DEFAULT NULL,
  `chassiVeiculo` varchar(17) DEFAULT NULL,
  `idQmc` int(10) unsigned DEFAULT NULL,
  `idPessoaRT` int(10) unsigned DEFAULT NULL,
  `nomeRT` varchar(45) DEFAULT NULL,
  `pRT` decimal(5,2) unsigned DEFAULT NULL,
  `vRT` decimal(9,3) unsigned DEFAULT NULL,
  PRIMARY KEY (`idVenda`),
  KEY `FK_vendas_pessoas_1` (`idCliente`),
  KEY `FK_vendas_pessoas_2` (`idVendedor`),
  KEY `FK_vendas_planoVendas` (`idPlanoVenda`),
  CONSTRAINT `FK_vendas_pessoas_1` FOREIGN KEY (`idCliente`) REFERENCES `pessoas` (`idPessoa`) ON DELETE NO ACTION ON UPDATE CASCADE,
  CONSTRAINT `FK_vendas_pessoas_2` FOREIGN KEY (`idVendedor`) REFERENCES `pessoas` (`idPessoa`) ON DELETE NO ACTION ON UPDATE CASCADE,
  CONSTRAINT `FK_vendas_planoVendas` FOREIGN KEY (`idPlanoVenda`) REFERENCES `plano_vendas` (`idPlanoVenda`) ON DELETE NO ACTION ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `vendas`
--



--
-- Definition of function `getId`
--

DROP FUNCTION IF EXISTS `getId`;

DELIMITER $$

/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ $$
CREATE DEFINER=`root`@`localhost` FUNCTION `getId`(_tabela varchar(100)) RETURNS bigint(20)
BEGIN
	declare _idServ tinyint;
  declare _qtdeServ tinyint;
	declare _id bigint;
 
    select coalesce(valor, 1) into _idServ   from configuracoes where grupo = "MYSQL" AND chave = "IDSERV";
    select coalesce(valor, 1) into _qtdeServ from configuracoes where grupo = "MYSQL" AND chave = "QTDESERV";
 
    select `auto_increment` into _id from information_schema.`TABLES` where TABLE_SCHEMA = SCHEMA() and TABLE_NAME = _tabela;
 
    while mod((_id - _idServ), _qtdeServ) <> 0 do
		set _id = _id + 1;
    end while;
 
RETURN _id;
END $$
/*!50003 SET SESSION SQL_MODE=@TEMP_SQL_MODE */  $$

DELIMITER ;



