-
Notifications
You must be signed in to change notification settings - Fork 0
/
SQLQuery3.sql
54 lines (21 loc) · 16.7 KB
/
SQLQuery3.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
select * from SD1630 where d1_doc like '%1123%'
select * from sx2630 where X2_CHAVE = 'SF2'
--
--select * from bdinspetor..sigamat where M0_CGC= '00504095000180'
INSERT INTO SD1630 (D1_FILIAL, D1_ITEM, D1_COD, D1_UM, D1_QUANT, D1_VUNIT, D1_TOTAL, D1_VALIPI, D1_VALICM, D1_TES, D1_CF, D1_DESC, D1_IPI, D1_PICM, D1_FORNECE, D1_LOJA, D1_LOCAL, D1_DOC, D1_EMISSAO, D1_DTDIGIT, D1_TIPO, D1_SERIE, D1_TP, D1_BASEICM, D1_VALDESC, D1_BASEIPI, D1_BASIMP5, D1_BASIMP6, D1_VALIMP5, D1_VALIMP6, D1_ALQIMP5, D1_ALQIMP6, D1_VALFRE, D1_SEGURO, D1_DESPESA, D1_STSERV, D1_ALIQSOL, D1_GARANTI, D1_ALQCSL, D1_ALQPIS, D1_ALQCOF, R_E_C_N_O_) VALUES ('01','1','M003923219001 ','UN','100.0','85.0','8500.00','','','003','5101','','','','000113','01','01','1123',REPLACE(CAST(CAST('2016-03-15T17:36:59' AS DATE) AS VARCHAR(20)), '-', ''),REPLACE(CAST(CAST(GETDATE() AS DATE) AS VARCHAR(20)), '-', ''),'N','1','ME','','','','','','','','','','','','','1','','N','1','','',(SELECT MAX(R_E_C_N_O_) FROM SD1630));
SELECT MAX(R_E_C_N_O_) FROM SE2630
select D1_DOC, * from sd1630 where R_E_C_N_O_ = 4222
UPDATE SD1630 SET D1_DOC = '000001123' WHERE R_E_C_N_O_ = 4222
begin tran
insert into SE2630(E2_FILIAL, E2_PREFIXO, E2_NUM, E2_PARCELA, E2_TIPO, E2_NATUREZ, E2_PORTADO, E2_FORNECE, E2_LOJA, E2_NOMFOR, E2_EMISSAO, E2_VENCTO, E2_VENCREA, E2_VALOR, E2_ISS, E2_IRRF, E2_NUMBCO, E2_INDICE, E2_BAIXA, E2_BCOPAG, E2_EMIS1, E2_HIST, E2_LA, E2_LOTE, E2_MOTIVO, E2_MOVIMEN, E2_OP, E2_SALDO, E2_OK, E2_DESCONT, E2_MULTA, E2_JUROS, E2_CORREC, E2_VALLIQ, E2_VENCORI, E2_VALJUR, E2_PORCJUR, E2_MOEDA, E2_NUMBOR, E2_FATPREF, E2_FATURA, E2_PROJETO, E2_CLASCON, E2_RATEIO, E2_DTVARIA, E2_VARURV, E2_VLCRUZ, E2_DTFATUR, E2_ACRESC, E2_TITORIG, E2_IMPCHEQ, E2_PARCIR, E2_ARQRAT, E2_OCORREN, E2_ORIGEM, E2_IDENTEE, E2_FLUXO, E2_PARCISS, E2_ORDPAGO, E2_DESDOBR, E2_INSS, E2_PARCINS, E2_NUMLIQ, E2_BCOCHQ, E2_AGECHQ, E2_CTACHQ, E2_DATALIB, E2_APROVA, E2_TIPOFAT, E2_FLAGFAT, E2_ANOBASE, E2_MESBASE, E2_TXMOEDA, E2_SDACRES, E2_DECRESC, E2_SDDECRE, E2_USUALIB, E2_MULTNAT, E2_NUMTIT, E2_PROJPMS, E2_PLLOTE, E2_DIRF, E2_CODRET, E2_MODSPB, E2_IDCNAB, E2_PARCCSS, E2_RETENC, E2_CONTAD, E2_CODORCA, E2_SEST, E2_PARCSES, E2_FILDEB, E2_FILORIG, E2_FORNISS, E2_LOJAISS, E2_DEBITO, E2_CCD, E2_ITEMD, E2_CLVLDB, E2_CREDIT, E2_CCC, E2_ITEMC, E2_CLVLCR, E2_COFINS, E2_PIS, E2_CSLL, E2_PARCCOF, E2_PARCPIS, E2_PARCSLL, E2_TITPIS, E2_TITCOF, E2_TITCSL, E2_TITINS, E2_VRETPIS, E2_VRETCOF, E2_VRETCSL, E2_PRETPIS, E2_PRETCOF, E2_PRETCSL, E2_SEQBX, E2_CODBAR, E2_BASECOF, E2_BASEPIS, E2_BASECSL, E2_VRETISS, E2_VENCISS, E2_VBASISS, E2_MDRTISS, E2_VARIAC, E2_PERIOD, E2_MDCONTR, E2_MDREVIS, E2_MDPLANI, E2_MDCRON, E2_MDPARCE, E2_FRETISS, E2_TXMDCOR, E2_APLVLMN, E2_CLEARIN, E2_HORASPB, E2_PRETIRF, E2_SEFIP, E2_TRETISS, E2_VRETIRF, E2_PLOPELT, E2_CODRDA, E2_PARCFET, E2_FETHAB, E2_FORORI, E2_LOJORI, E2_STATUS, E2_DTDIRF, E2_TITADT, E2_TITPAI, E2_INSSRET, E2_CODAGL, E2_PROCPCC, E2_FORNPAI, E2_CODISS, E2_USUASUS, E2_USUACAN, E2_DATASUS, E2_DATACAN, E2_LIMCAN, E2_PREOP, E2_BASEISS, E2_NUMPRO, E2_INDPRO, E2_PARCAGL, E2_NODIA, E2_DIACTB, E2_MDMULT, E2_MDBONI, E2_MDDESC, E2_RETCNTR, E2_CIDE, E2_PRETINS, E2_VRETINS, E2_FATFOR, E2_FATLOJ, E2_BASEIRF, E2_DATAAGE, E2_TEMDOCS, E2_STATLIB, E2_CODAPRO, E2_IDMOV, E2_PRINSS, E2_BASEINS, E2_PARCCID, E2_CODRCSL, E2_CODRPIS, E2_CODRCOF, E2_TIPOLIQ, E2_PARIMP5, E2_PARIMP4, E2_PARIMP3, E2_PARIMP2, E2_PARIMP1, E2_CODINS, E2_IDDARF, E2_DTBORDE, E2_MSIDENT, E2_PRISS, E2_RATFIN, E2_NUMSOL, E2_CODOPE, E2_FABOV, E2_FACS, E2_PARCFAB, E2_PARCFAC, E2_FIMP, E2_NFELETR, E2_AGLIMP, D_E_L_E_T_, R_E_C_N_O_, R_E_C_D_E_L_, E2_FAMAD, E2_PARCFAM, E2_FMPEQ, E2_PARCFMP, E2_FORBCO, E2_FORAGE, E2_FAGEDV, E2_FORCTA, E2_FCTADV) select TOP 1 F1_FILIAL AS E2_FILIAL, 'NF' AS E2_PREFIXO, F1_DOC AS E2_NUM, '' AS E2_PARCELA, 'NF' AS E2_TIPO, '1000' AS E2_NATUREZ, '' AS E2_PORTADO, F1_FORNECE AS E2_FORNECE, F1_LOJA AS E2_LOJA, (SELECT TOP 1 A2_NREDUZ FROM SA2630 WHERE A2_COD = F1_FORNECE AND A2_FILIAL = F1_FILIAL) AS E2_NOMFOR, F1_EMISSAO AS E2_EMISSAO, F1_EMISSAO AS E2_VENCTO, F1_EMISSAO AS E2_VENCREA, F1_VALBRUT AS E2_VALOR, F1_ISS AS E2_ISS, F1_IRRF AS E2_IRRF, '' AS E2_NUMBCO, '' AS E2_INDICE, '' AS E2_BAIXA, '' AS E2_BCOPAG, '' AS E2_EMIS1, '' AS E2_HIST, '' AS E2_LA, '' AS E2_LOTE, '' AS E2_MOTIVO, '' AS E2_MOVIMEN, '' AS E2_OP, F1_VALBRUT AS E2_SALDO, '' AS E2_OK, F1_DESCONT AS E2_DESCONT, '0' AS E2_MULTA, '0' AS E2_JUROS, '0' AS E2_CORREC, '0' AS E2_VALLIQ, F1_EMISSAO AS E2_VENCORI, '0' AS E2_VALJUR, '0' AS E2_PORCJUR, F1_MOEDA AS E2_MOEDA, '' AS E2_NUMBOR, '' AS E2_FATPREF, '' AS E2_FATURA, '' AS E2_PROJETO, '' AS E2_CLASCON, 'N' AS E2_RATEIO, '' AS E2_DTVARIA, '0' AS E2_VARURV, F1_VALBRUT AS E2_VLCRUZ, '' AS E2_DTFATUR, '0' AS E2_ACRESC, '' AS E2_TITORIG, '' AS E2_IMPCHEQ, '' AS E2_PARCIR, '' AS E2_ARQRAT, '01' AS E2_OCORREN, 'FINA050' AS E2_ORIGEM, '' AS E2_IDENTEE, 'S' AS E2_FLUXO, '' AS E2_PARCISS, '' AS E2_ORDPAGO, 'N' AS E2_DESDOBR, F1_INSS AS E2_INSS, '' AS E2_PARCINS, '' AS E2_NUMLIQ, '' AS E2_BCOCHQ, '' AS E2_AGECHQ, '' AS E2_CTACHQ, '' AS E2_DATALIB, '' AS E2_APROVA, '' AS E2_TIPOFAT, '' AS E2_FLAGFAT, '' AS E2_ANOBASE, '' AS E2_MESBASE, F1_TXMOEDA AS E2_TXMOEDA, '0' AS E2_SDACRES, '0' AS E2_DECRESC, '0' AS E2_SDDECRE, '' AS E2_USUALIB, '2' AS E2_MULTNAT, '' AS E2_NUMTIT, '2' AS E2_PROJPMS, '' AS E2_PLLOTE, '1' AS E2_DIRF, '' AS E2_CODRET, '1' AS E2_MODSPB, '' AS E2_IDCNAB, '' AS E2_PARCCSS, '0' AS E2_RETENC, '' AS E2_CONTAD, '' AS E2_CODORCA, '0' AS E2_SEST, '' AS E2_PARCSES, '' E2_FILDEB, F1_FILORIG AS E2_FILORIG, '' AS E2_FORNISS, '' AS E2_LOJAISS, '' AS E2_DEBITO, '1' as E2_CCD, '' AS E2_ITEMD, '' AS E2_CLVLDB, '' AS E2_CREDIT, '' AS E2_CCC, '' AS E2_ITEMC, '' AS E2_CLVLCR, F1_VALCOFI AS E2_COFINS, F1_VALPIS AS E2_PIS, F1_VALCSLL AS E2_CSLL, '' AS E2_PARCCOF, '' AS E2_PARCPIS, '' AS E2_PARCSLL, '' AS E2_TITPIS, '' AS E2_TITCOF, '' AS E2_TITCSL, '' AS E2_TITINS, '0' AS E2_VRETPIS, '0' AS E2_VRETCOF, '0' AS E2_VRETCSL, '' AS E2_PRETPIS, '' AS E2_PRETCOF, '' AS E2_PRETCSL, '' AS E2_SEQBX, '' AS E2_CODBAR, F1_BASCOFI AS E2_BASECOF, F1_BASPIS AS E2_BASEPIS, F1_BASCSLL AS E2_BASECSL, F1_ISS AS E2_VRETISS, '' AS E2_VENCISS, '0' AS E2_VBASISS, '1' AS E2_MDRTISS, '0' AS E2_VARIAC, '' AS E2_PERIOD, '' AS E2_MDCONTR, '' AS E2_MDREVIS, '' AS E2_MDPLANI, '' AS E2_MDCRON, '' AS E2_MDPARCE, '1' AS E2_FRETISS, '0' AS E2_TXMDCOR, '1' AS E2_APLVLMN, '' AS E2_CLEARIN, '' AS E2_HORASPB, '' AS E2_PRETIRF, '' AS E2_SEFIP, '' AS E2_TRETISS, '0' AS E2_VRETIRF, '' AS E2_PLOPELT, '' AS E2_CODRDA, '' AS E2_PARCFET, '0' AS E2_FETHAB, '' AS E2_FORORI, '' AS E2_LOJORI, '' AS E2_STATUS, '' AS E2_DTDIRF, '' AS E2_TITADT, '' AS E2_TITPAI, F1_INSS AS E2_INSSRET, '' AS E2_CODAGL, '' AS E2_PROCPCC, '' AS E2_FORNPAI, '' AS E2_CODISS, '' AS E2_USUASUS, '' AS E2_USUACAN, '' AS E2_DATASUS, '' AS E2_DATACAN, '' AS E2_LIMCAN, '' AS E2_PREOP, F1_BASECPM AS E2_BASEISS, '' AS E2_NUMPRO, '' AS E2_INDPRO, '' AS E2_PARCAGL, '' AS E2_NODIA, '' AS E2_DIACTB, '0' AS E2_MDMULT, '0' AS E2_MDBONI, '0' AS E2_MDDESC, '0' AS E2_RETCNTR, '0' AS E2_CIDE, '' AS E2_PRETINS, '' AS E2_VRETINS, '' AS E2_FATFOR, '' AS E2_FATLOJ, F1_VALBRUT AS E2_BASEIRF, F1_EMISSAO AS E2_DATAAGE, '2' AS E2_TEMDOCS, '01' AS E2_STATLIB, '' AS E2_CODAPRO, '' AS E2_IDMOV, F1_INSS AS E2_PRINSS, F1_BASEINS AS E2_BASEINS, '' AS E2_PARCCID, '' AS E2_CODRCSL, '' AS E2_CODRPIS, '' AS E2_CODRCOF, '' AS E2_TIPOLIQ, '' AS E2_PARIMP5, '' AS E2_PARIMP4, '' AS E2_PARIMP3, '' AS E2_PARIMP2, '' AS E2_PARIMP1, '' AS E2_CODINS, '' AS E2_IDDARF, '' AS E2_DTBORDE, F1_MSIDENT AS E2_MSIDENT, '0' AS E2_PRISS, '' AS E2_RATFIN, '' AS E2_NUMSOL, '' AS E2_CODOPE, '0' AS E2_FABOV, '0' AS E2_FACS, '' AS E2_PARCFAB, '' AS E2_PARCFAC, '' AS E2_FIMP, '' AS E2_NFELETR, '' AS E2_AGLIMP, '' AS D_E_L_E_T_, (SELECT MAX(R_E_C_N_O_)+1 FROM SF1630) AS R_E_C_N_O_, '0' AS R_E_C_D_E_L_, '0' AS E2_FAMAD, '' AS E2_PARCFAM, '0' AS E2_FMPEQ, '' AS E2_PARCFMP, '' AS E2_FORBCO, '' AS E2_FORAGE, '' AS E2_FAGEDV, '' AS E2_FORCTA, '' AS E2_FCTADV from SF1630 where F1_CHVNFE = '35160300745929000140550010000011231940030247';
select * from se2630 where r_e_c_n_o_ = 1869
rollback
delete FROM SE2630 WHERE R_E_C_N_O_ = 1869
select * from SF2630 where F2_CHVNFE = '35160300504095000180550010000204811705510246'
INSERT INTO SD2630 (D2_FILIAL,D2_ITEM,D2_COD,D2_UM,D2_QUANT,D2_PRCVEN,D2_PRUNIT,D2_TOTAL,D2_VALBRUT,D2_VALIPI,D2_VALICM,D2_TES,D2_CF,D2_DESC,D2_IPI, D2_PICM, D2_CLIENTE, D2_LOJA,D2_LOCAL,D2_DOC,D2_EMISSAO,D2_DTDIGIT,D2_TIPO,D2_SERIE,D2_TP,D2_BASEICM,D2_BASEIPI,D2_BASIMP5,D2_BASIMP6,D2_VALIMP5,D2_VALIMP6,D2_ALQIMP5,D2_ALQIMP6,D2_VALFRE,D2_SEGURO,D2_DESPESA,D2_STSERV,D2_ALIQSOL,D2_ALQCSL,D2_ALQPIS,D2_ALQCOF,R_E_C_N_O_,D2_CLASFIS) VALUES('01','1','M004818100012 ','UN','320.0000','69.14','69.14','22124.80','22124.80','','','902','5405','','','','000004','01','01','20480',REPLACE(CAST(CAST('2016-03-01T12:08:25' AS DATE) AS VARCHAR(20)), '-', ''),REPLACE(CAST(CAST(GETDATE() AS DATE) AS VARCHAR(20)), '-', ''),'N','1','ME','','','22124.80','22124.80','0.00','0.00','3.00','0.65','','','','1','','1','0.65','3.00',(SELECT MAX(R_E_C_N_O_)+1 FROM SD2630),'');
delete from SD2630 where d2_doc = '20480'
begin tran
insert into SE1630(E1_FILIAL, E1_PREFIXO, E1_NUM, E1_PARCELA, E1_TIPO, E1_NATUREZ, E1_PORTADO, E1_AGEDEP, E1_CLIENTE, E1_LOJA, E1_NOMCLI, E1_EMISSAO, E1_VENCTO, E1_VENCREA, E1_VALOR, E1_BASEIRF, E1_IRRF, E1_ISS, E1_NUMBCO, E1_INDICE, E1_BAIXA, E1_NUMBOR, E1_DATABOR, E1_EMIS1, E1_HIST, E1_LA, E1_LOTE, E1_MOTIVO, E1_MOVIMEN, E1_OP, E1_SITUACA, E1_CONTRAT, E1_SALDO, E1_SUPERVI, E1_VEND1, E1_VEND2, E1_VEND3, E1_VEND4, E1_VEND5, E1_COMIS1, E1_COMIS2, E1_COMIS3, E1_COMIS4, E1_DESCONT, E1_COMIS5, E1_MULTA, E1_JUROS, E1_CORREC, E1_VALLIQ, E1_VENCORI, E1_CONTA, E1_VALJUR, E1_PORCJUR, E1_MOEDA, E1_BASCOM1, E1_BASCOM2, E1_BASCOM3, E1_BASCOM4, E1_BASCOM5, E1_FATPREF, E1_FATURA, E1_OK, E1_PROJETO, E1_CLASCON, E1_VALCOM1, E1_VALCOM2, E1_VALCOM3, E1_VALCOM4, E1_VALCOM5, E1_OCORREN, E1_INSTR1, E1_INSTR2, E1_PEDIDO, E1_DTVARIA, E1_VARURV, E1_VLCRUZ, E1_DTFATUR, E1_NUMNOTA, E1_SERIE, E1_STATUS, E1_ORIGEM, E1_IDENTEE, E1_NUMCART, E1_FLUXO, E1_DESCFIN, E1_DIADESC, E1_TIPODES, E1_CARTAO, E1_CARTVAL, E1_CARTAUT, E1_ADM, E1_VLRREAL, E1_TRANSF, E1_BCOCHQ, E1_AGECHQ, E1_CTACHQ, E1_NUMLIQ, E1_ORDPAGO, E1_RECIBO, E1_INSS, E1_FILORIG, E1_DTACRED, E1_TIPOFAT, E1_TIPOLIQ, E1_CSLL, E1_COFINS, E1_PIS, E1_FLAGFAT, E1_MESBASE, E1_ANOBASE, E1_PLNUCOB, E1_CODINT, E1_CODEMP, E1_MATRIC, E1_TXMOEDA, E1_ACRESC, E1_SDACRES, E1_DECRESC, E1_SDDECRE, E1_MULTNAT, E1_MSFIL, E1_MSEMP, E1_PROJPMS, E1_DESDOBR, E1_NRDOC, E1_MODSPB, E1_EMITCHQ, E1_IDCNAB, E1_PLCOEMP, E1_PLTPCOE, E1_CODCOR, E1_PARCCSS, E1_CODORCA, E1_CODIMOV, E1_FILDEB, E1_NUMSOL, E1_NUMRA, E1_INSCRIC, E1_SERREC, E1_DATAEDI, E1_CODBAR, E1_CODDIG, E1_CHQDEV, E1_LIDESCF, E1_VLBOLSA, E1_VLFIES, E1_NUMCRD, E1_DEBITO, E1_CCD, E1_ITEMD, E1_CLVLDB, E1_CREDIT, E1_CCC, E1_ITEMC, E1_CLVLCR, E1_DESCON1, E1_DESCON2, E1_DTDESC3, E1_DTDESC1, E1_DTDESC2, E1_VLMULTA, E1_DESCON3, E1_MOTNEG, E1_SABTPIS, E1_SABTCOF, E1_SABTCSL, E1_FORNISS, E1_PARTOT, E1_SITFAT, E1_BASEPIS, E1_BASECOF, E1_BASECSL, E1_VRETISS, E1_PARCIRF, E1_SCORGP, E1_FRETISS, E1_TXMDCOR, E1_SATBIRF, E1_TIPREG, E1_CONEMP, E1_VERCON, E1_SUBCON, E1_VERSUB, E1_PLLOTE, E1_PLOPELT, E1_CODRDA, E1_FORMREC, E1_BCOCLI, E1_AGECLI, E1_CTACLI, E1_PARCFET, E1_FETHAB, E1_MDCRON, E1_MDCONTR, E1_MEDNUME, E1_MDPLANI, E1_MDPARCE, E1_MDREVIS, E1_NUMMOV, E1_PREFORI, E1_IDMOV, E1_NUMPRO, E1_INDPRO, E1_MDMULT, E1_MDBONI, E1_MDDESC, E1_RETCNTR, E1_NODIA, E1_MULTDIA, E1_JURFAT, E1_RELATO, E1_BASEINS, E1_TITPAI, E1_NFELETR, E1_DOCTEF, E1_PRINSS, E1_PARCFAB, E1_PARCFAC, E1_PARTPDP, E1_TPDESC, E1_TPDP, E1_VLMINIS, E1_FACS, E1_FABOV, E1_NUMCON, E1_SABTIRF, E1_IDLAN, E1_IDBOLET, E1_SERVICO, E1_VLBOLP, E1_IDAPLIC, E1_PROCEL, E1_NUMINSC, E1_DIACTB, E1_LTCXA, E1_NOPER, E1_TURMA, E1_NSUTEF, E1_VRETIRF, E1_APLVLMN, E1_BASEISS, E1_SEQBX, E1_RATFIN, E1_CODIRRF, E1_PRISS, E1_CODISS, D_E_L_E_T_, R_E_C_N_O_, R_E_C_D_E_L_, E1_FAMAD, E1_PARCFAM, E1_FMPEQ, E1_PARCFMP, E1_CTRBCO, E1_PRODUTO, E1_PERLET, E1_CHAVENF) SELECT F2_FILIAL AS E1_FILIAL, F2_PREFIXO AS E1_PREFIXO, F2_DOC AS E1_NUM, '' AS E1_PARCELA, 'NF' AS E1_TIPO, '' AS E1_NATUREZ, '' AS E1_PORTADO, '' AS E1_AGEDP, F2_CLIENTE AS E1_CLIENTE, F2_LOJA AS E1_LOJA, (SELECT TOP 1 A1_NREDUZ FROM SA1630 WHERE A1_COD = F2_CLIENTE AND A1_FILIAL = F2_FILIAL) AS E1_NOMCLI, F2_EMISSAO AS E1_EMISSAO, F2_EMISSAO AS E1_VENCTO, F2_EMISSAO AS E1_VENCREA, F2_VALFAT AS E1_VALOR, F2_BASEIRR AS E1_BASEIRF, F2_VALIRRF AS E1_IRRF, F2_VALISS AS E1_ISS, '' AS E1_NUMBCO, '' AS E1_INDICE, '' AS E1_BAIXA, '' AS E1_NUMBOR, '' AS E1_DATABOR, F2_EMISSAO AS E1_EMIS1, '' AS E1_HIST, 'S' AS E1_LA, F2_LOTE AS E1_LOTE, '' AS E1_MOTIVO, '' AS E1_MOVIMEN, '' AS E1_OP, '0' AS E1_SITUACA, '' AS E1_CONTRAT, F2_VALFAT AS E1_SALDO, '' AS E1_SUPERVI, F2_VEND1 AS E1_VEND1, F2_VEND2 AS E2_VEND2, F2_VEND3 AS E2_VEND3, F2_VEND4 AS E2_VEND4, F2_VEND5 AS E2_VEND5, '0' AS E1_COMIS1, '0' AS E1_COMIS2, '0' AS E1_COMIS3, '0' AS E1_COMIS4, F2_DESCONT AS E1_DESCONT, '0' AS E1_COMIS5, '0' AS E1_MULTA, '0' AS E1_JUROS, '0' AS E1_CORREC, '0' AS E1_VALLIQ, F2_EMISSAO AS E1_VENCORI, '' AS E1_CONTA, '0' AS E1_VALJUR, '' AS E1_PORCJUR, F2_MOEDA AS E1_MOEDA, '0' AS E1_BASCOM1, '0' AS E1_BASCOM2, '0' AS E1_BASCOM3, '0' AS E1_BASCOM4, '0' AS E1_BASCOM5, '' AS FATPREF, '' AS E1_FATURA, '' AS E1_OK, '' AS E1_PROJETO, '' AS E1_CLASCON, '0' AS E1_VALCOM1, '0' AS E1_VALCOM2, '0' AS E1_VALCOM3, '0' AS E1_VALCOM4, '0' AS E1_VALCOM5, '01' AS E1_OCORREN, '' AS E1_INSTR1, '' AS E1_INSTR2, '' AS E1_PEDIDO, '' AS E1_DTVARIA, '0' AS E1_VARURV, F2_VALFAT AS E1_VLCRUZ, '' AS E1_DTFATUR, '' AS E1_NUMNOTA, '' AS E1_SERIE, '' AS E1_STATUS, 'MATA460' AS E1_ORIGEM, '' AS E1_IDENTEE, '' AS E1_NUMCART, '' AS E1_FLUXO, '0' AS E1_DESCFIN, '0' AS E1_DIADESC, '' AS E1_TIPODES, '' AS E1_CARTAO, '' AS E1_CARTVAL, '' AS E1_CARTAUT, '' AS E1_ADM, '0' AS E1_VLRREAL, '' AS E1_TRANSF, '' AS E1_BCOHQ, '' AS E1_AGEHG, '' AS E1_CTAHQ, '' AS E1_NUMLIQ, '' AS E1_ORDPAGO, '' AS E1_RECIBO, F2_VALINSS AS E1_INSS, F2_FILIAL AS E1_FILORIG, '' AS E1_DTACRED, '' AS E1_TIPOFAT, '' AS E1_TIPOLIQ, F2_VALCSLL AS E1_CSLL, F2_VALCOFI AS E1_COFINS, F2_VALPIS AS E1_PIS, '' AS E1_FLAGFAT, '' AS E1_MESBASE, '' AS E1_ANOBASE, '' AS E1_PLNUCOB, '' AS E1_CODINT, '' AS E1_CODEMP, '' AS E1_MATRIC, F2_TXMOEDA AS E1_TXMOEDA, F2_VALACRS AS E1_ACRESC, '' AS E1_SDACRES, '0' AS E1_DECRESC, '0' AS E1_SDDECRE, '' AS E1_MULTNAT, F2_FILIAL AS E1_MSFIL, '63' AS E1_MSEMP, '' AS E1_PROJPMS, '' AS E1_DESDOBR, '' AS E1_NRDOC, '' AS E1_MODSPB, '' AS E1_EMITCHQ, '' AS E1_IDCNAB, '' AS E1_PLCOEMP, '' AS E1_PLTPCOE, '' AS E1_CODCOR, '' AS E1_PARCCSS, '' AS E1_CODORCA, '' AS E1_CODIMOV, '' AS E1_FILDEB, '' AS E1_NUMSOL, '' AS E1_NUMRA, '' AS E1_INSCRIC, '' AS E1_SERREC, '' AS E1_DATAEDI, '' AS E1_CODBAR, '' AS E1_CODDIG, '' AS E1_CHQDEV, '' AS E1_LIDESCF, '0' AS VLBOLSA, '0' AS E1_VLFIES, '' AS E1_NUMCRD, '' AS E1_DEBITO, '' AS E1_CCD, '' AS E1_ITEMD, '' AS E1_CLVDB, '' AS E1_CREDIT, '1' AS E1_CCC, '' AS E1_ITEMC, '' AS E1_CLVLCR, '0' AS E1_DESCON1, '0' AS E1_DESCON2, '' AS E1_DTDESC3, '' AS E1_DTDESC1, '' AS E1_DTDESC2, '0' AS E1_VLMULTA, '0' AS E1_DESCON3, '' AS E1_MOTNEG, '0' AS E1_SABTPIS, '0' AS E1_SABTCOF, '0' AS E1_SABTCSL, '' AS E1_FORNISS, '' AS E1_PARTOT, '' AS E1_SITFAT, F2_BASPIS AS E1_BASEPIS, F2_BASCOFI AS E1_BASECOF, F2_BASCSLL AS E1_BASECSL, '0' AS E1_VRETISS, '' AS E1_PARCIRF, '' AS E1_SCORGP, '1' AS E1_FRETISS, '0' AS E1_TXMDCOR, '0' AS E1_SATBIRF, '' AS E1_TIPREG, '' AS E1_CONEMP, '' AS E1_VERCON, '' AS E1_SUBCON, '' AS E1_VERSUB, '' AS E1_PLLOTE, '' AS E1_PLOPELT, '' AS E1_CODRDA, '' AS E1_FORMREC, '' AS E1_BCOCLI, '' AS E1_AGECLI, '' AS E1_CTACLI, '' AS E1_PARCFET, '0' AS E1_FETHAB, '' AS E1_MDCRON, '' AS E1_MDCONTR, '' AS E1_MEDNUME, '' AS E1_MDPLANI, '' AS E1_MDPARCE, '' AS E1_MDREVIS, '' AS E1_NUMMOV, '' AS E1_PREFORI, '' AS E1_IDMOV, '' AS E1_NUMPRO, '' AS E1_INDPRO, '0' AS E1_MDMULT, '0' AS E1_MDBONI, '0' AS E1_MDDESC, '0' AS E1_RETCNTR, '' AS E1_NODIA, '0' AS E1_MULTDIA, '' AS E1_JURFAT, '2' AS E1_RELATO, '0' AS E1_BASEINS, '' AS E1_TITPAI, '' AS E1_NFELETR, '' AS E1_DOCTEF, '0' AS E1_PRINSS, '' AS E1_PARCFAB, '' AS E1_PARCFAC, '' AS E1_PARTPDP, 'C' AS E1_TPDESC, '0' AS E1_TPDP, '' AS E1_VLMINIS, '0' AS E1_FACS, '0' AS E1_FABOV, '' AS E1_NUMCON, '0' AS E1_SABTIRF, '0' E1_IDLAN, '0' AS E1_IDBOLET, '0' AS E1_SERVICO, '0' AS E1_VLBOLP, '0' AS E1_IDAPLIC, '0' AS E1_PROCEL, '0' AS E1_NUMINSC, '' AS E1_DIACTB, '' AS E1_LTCXA, '0' AS E1_NOPER, '' AS E1_TURMA, '' AS E1_NSUTEF, F2_VALIRRF AS E1_VRETIRF, '1' AS E1_APLVLMN, '0' AS E1_BASEISS, '' AS E1_SEQBX, '' AS E1_RATFIN, '' AS E1_CODIRRF, '0' AS E1_PRISS, '' AS E1_CODISS, '' AS D_E_L_E_T_, (SELECT MAX(R_E_C_N_O_)+1 FROM SE1630) R_E_C_N_O_, '0' AS R_E_C_D_E_L_, '0' AS E1_FAMAD, '' AS E1_PARCFAM, '0' AS E1_FMPEQ, '' AS E1_PARCFMP, '' AS E1_CTRBCO, '' AS E1_PRODUTO, '' AS E1_PERLET, F2_CHVNFE AS E1_CHAVENF FROM SF2630 WHERE F2_CHVNFE = '35160300504095000180550010000204801705510249';
delete FROM SD2630
where R_E_C_N_O_ = 9008
select * from sys.sysprocesses where blocked <> 0