20100803 17:35 INSERT INTO Artigos_No_Serie (idx,codigo,designaca,serie,doc_mov,tipo_doc,dcm,d,h,numero,ms,preco,conv,rsv) VALUES(NULL,'1','Artigo 1','123456','D',10,'CO',20061006000000,20000101124200,1,'E',20.00,0,'');
20121115 12:10 INSERT INTO Familias__artigos_ (idx,codigo,descricao,grupo,rsv) VALUES(NULL,'DIVERSOS','DIVERSOS',0,'');
20121115 12:12 INSERT INTO Familias__artigos_ (idx,codigo,descricao,grupo,rsv) VALUES(NULL,'DIVRSOS','DIVRSOS',0,'');
20121115 12:13 INSERT INTO Familias__artigos_ (idx,codigo,descricao,grupo,rsv) VALUES(NULL,'DIVERSOS','DIVERSOS',0,'');
20121115 14:23 INSERT INTO Tipos_de_documentosD (idx,numero,designacao,cli_forn,tipo_desc,no_vias,ficheiro,porta,flg_cco,ctrl_seq,mov_stock,ecr,abvr,mov_finan,carta_anexo,extras,des_cco,cco_banco,mov_caixa,act_preco,edt_temp,doc_org,ficheiro2,porta2,armazem,mov_res,com_cli,inc_vias,no,sem_iva,com_obs,res_bal,des_base,des_altern,tipo_imp,bx_encs,cria_resc,tipo_vcd,linha_preco,saft,irs,hash,rsv) VALUES(NULL,13,'COMPRAS','F','',1,'DOC-F.rpt',1,'C','P','E','DOCSF','CO','S','','N','V/ Factura','','N','S','S','','',0,0,'','N','S',0,'','','','','','','','','',0,'N','','N','');
20130327 15:53 REPLACE INTO documentosextras14 (no_doc,loc_carga,data_carga,hora_carga,motorista,matricula,loc_desc,embalagem,transporte,i0,i1,i2,i3,i4,i5,i6,i7,i8,i9,serdoc,tpdoc,rsv,rsv2) VALUES(1,'',00000000000000,20000101000000,'','','','','','','','','','','','','','','','A','','','');
20130327 15:53 REPLACE INTO documentosextras14 (no_doc,loc_carga,data_carga,hora_carga,motorista,matricula,loc_desc,embalagem,transporte,i0,i1,i2,i3,i4,i5,i6,i7,i8,i9,serdoc,tpdoc,rsv,rsv2) VALUES(1,'',00000000000000,20000101000000,'','','','','','','','','','','','','','','','A','','','');
20130327 15:54 REPLACE INTO documentosextras14 (no_doc,loc_carga,data_carga,hora_carga,motorista,matricula,loc_desc,embalagem,transporte,i0,i1,i2,i3,i4,i5,i6,i7,i8,i9,serdoc,tpdoc,rsv,rsv2) VALUES(2,'',00000000000000,20000101000000,'','','','','','','','','','','','','','','','A','','','');
20130701 16:50 REPLACE INTO documentosextras15 (no_doc,loc_carga,data_carga,hora_carga,motorista,matricula,loc_desc,embalagem,transporte,i0,i1,i2,i3,i4,i5,i6,i7,i8,i9,serdoc,tpdoc,rsv,rsv2) VALUES(1,'',20130701000000,20000101165000,'','','','','','','','','','','','','','','','A','','','');
20130726 12:33 INSERT INTO documento_linhas_d2 (idx,lnh_f,cor,num_doc,codigo,designacao,unidade,com_iva,quantidade,preco_unit,desc1,desc_1,desc2,desc_2,iva,valor,ult_custo,custo_medio,armazem,grupo,ext,flg,sem_stk,m_qtd,m_altura,m_largura,m_extra,preco_serv,d_val,n_enc,linha_enc,qtd_por_emb,guia_n,tp_enc,serie,arm2,serdoc,tpdoc,miva,rsv) VALUES(NULL,5,0,36,'1','TESTW','UN','',0.000000,9.7600000,0.0000000,0.0000000,0.0000000,0.0000000,23.00,0.00,4.0000000,3.0000000,0,0,0,'','',1.00,0.00,0.00,0.00,0.00,00000000000000,0,0,1.000,0,'','',0,'A',0,0,'');
20130731 14:15 REPLACE INTO documentosextras15 (no_doc,loc_carga,data_carga,hora_carga,motorista,matricula,loc_desc,embalagem,transporte,i0,i1,i2,i3,i4,i5,i6,i7,i8,i9,serdoc,tpdoc,rsv,rsv2) VALUES(1,'',00000000000000,20000101000000,'','','','','','','','','','','','','','','','A','','','');
20130731 14:17 REPLACE INTO documentosextras15 (no_doc,loc_carga,data_carga,hora_carga,motorista,matricula,loc_desc,embalagem,transporte,i0,i1,i2,i3,i4,i5,i6,i7,i8,i9,serdoc,tpdoc,rsv,rsv2) VALUES(1,'',00000000000000,20000101000000,'','','','','','','','','','','','','','','','A','','','');
20130731 14:18 REPLACE INTO documentosextras15 (no_doc,loc_carga,data_carga,hora_carga,motorista,matricula,loc_desc,embalagem,transporte,i0,i1,i2,i3,i4,i5,i6,i7,i8,i9,serdoc,tpdoc,rsv,rsv2) VALUES(1,'',00000000000000,20000101000000,'','','','','','','','','','','','','','','','A','','','');
20130903 10:11 INSERT INTO movimentos_de_contas_bancarias (idx,linhas,n_doc,emitido,anulado,d_doc,n_operador,cont_org,ref_conta,cont_dest,ref_conta2,observacao,tot_valor,tipo,clinum,clinome,prazo,data2,rsv) VALUES(NULL,0,1,0,'',20130903000000,0,0,'',0,'','',0.00,3,0,'','','','');
20130903 10:11 INSERT INTO movimentos_de_contas_bancarias (idx,linhas,n_doc,emitido,anulado,d_doc,n_operador,cont_org,ref_conta,cont_dest,ref_conta2,observacao,tot_valor,tipo,clinum,clinome,prazo,data2,rsv) VALUES(NULL,0,1,0,'',20130903000000,0,0,'',1,'4521234567890','',0.00,3,0,'','','','');
20130903 10:11 INSERT INTO movimentos_de_contas_bancarias (idx,linhas,n_doc,emitido,anulado,d_doc,n_operador,cont_org,ref_conta,cont_dest,ref_conta2,observacao,tot_valor,tipo,clinum,clinome,prazo,data2,rsv) VALUES(NULL,0,1,0,'',20130903000000,0,0,'',1,'4521234567890','',0.00,3,0,'','','','');
20130903 10:12 INSERT INTO movimentos_de_contas_bancarias (idx,linhas,n_doc,emitido,anulado,d_doc,n_operador,cont_org,ref_conta,cont_dest,ref_conta2,observacao,tot_valor,tipo,clinum,clinome,prazo,data2,rsv) VALUES(NULL,0,1,0,'',20130903000000,0,0,'',0,'','',0.00,3,0,'','','','');
20130903 10:16 INSERT INTO movimentos_de_contas_bancarias (idx,linhas,n_doc,emitido,anulado,d_doc,n_operador,cont_org,ref_conta,cont_dest,ref_conta2,observacao,tot_valor,tipo,clinum,clinome,prazo,data2,rsv) VALUES(NULL,0,1,0,'',20130903000000,0,0,'',0,'','',0.00,3,0,'','','','');
20130903 10:45 INSERT INTO movimentos_de_contas_bancarias (idx,linhas,n_doc,emitido,anulado,d_doc,n_operador,cont_org,ref_conta,cont_dest,ref_conta2,observacao,tot_valor,tipo,clinum,clinome,prazo,data2,rsv) VALUES(NULL,0,1,0,'',20130903000000,0,0,'',0,'','',0.00,4,0,'','','','');
20140417 13:01 Rename table historicocaixa_00 to historicocaixa_00_old 
20140417 13:01 REPLACE DELAYED historicocaixa_00 SET  data=now() , tpdoc='0' , docmov='M' , numero='0' , tm='E' , mp='0' , h=now() , opr='1' , tipo='ABERTURA' , descricao='' , valor='0.0000' 
20140417 13:01 Rename table historicocaixa_00 to historicocaixa_00_old 
20140417 13:01 REPLACE DELAYED historicocaixa_00 SET  data=now() , tpdoc='0' , docmov='M' , numero='0' , tm='E' , mp='0' , h=now() , opr='1' , tipo='ABERTURA' , descricao='' , valor='0.0000' 
20140828 10:36 INSERT INTO reciboslinhas02 (idx,linha,cor,no,doc_mov,tp,document,n_doc,d_doc,d_venc,ref,deb_cred,val_doc,val_pend,val_liqu,per_desc,val_desc,val_rec,val_iva,irs,prest,serdoc,tot_liquido,tot_iva,tot_valor,suj_valor0,suj_valor1,suj_valor2,suj_valor3,suj_taxa0,suj_taxa1,suj_taxa2,suj_taxa3,suj_iva0,suj_iva1,suj_iva2,suj_iva3,miva,rsv) VALUES(NULL,10,0,2,'D',10,'V/ Factura',2,20130327000000,20130327000000,'','C',373.00,373.00,373.00,0.000,0.00,373.00,0.00,0.00,0,'A',350.00,23.00,373.00,100.00,0.00,0.00,250.00,23.00,13.00,6.00,0.00,23.00,0.00,0.00,0.00,0,'');
20140828 10:36 INSERT INTO reciboslinhas02 (idx,linha,cor,no,doc_mov,tp,document,n_doc,d_doc,d_venc,ref,deb_cred,val_doc,val_pend,val_liqu,per_desc,val_desc,val_rec,val_iva,irs,prest,serdoc,tot_liquido,tot_iva,tot_valor,suj_valor0,suj_valor1,suj_valor2,suj_valor3,suj_taxa0,suj_taxa1,suj_taxa2,suj_taxa3,suj_iva0,suj_iva1,suj_iva2,suj_iva3,miva,rsv) VALUES(NULL,20,0,2,'D',10,'V/ Factura',3,20130731000000,20130731000000,'','C',250.00,250.00,250.00,0.000,0.00,250.00,0.00,0.00,0,'A',250.00,0.00,250.00,0.00,0.00,0.00,250.00,23.00,13.00,6.00,0.00,0.00,0.00,0.00,0.00,0,'');
20140828 10:36 INSERT INTO reciboslinhas02 (idx,linha,cor,no,doc_mov,tp,document,n_doc,d_doc,d_venc,ref,deb_cred,val_doc,val_pend,val_liqu,per_desc,val_desc,val_rec,val_iva,irs,prest,serdoc,tot_liquido,tot_iva,tot_valor,suj_valor0,suj_valor1,suj_valor2,suj_valor3,suj_taxa0,suj_taxa1,suj_taxa2,suj_taxa3,suj_iva0,suj_iva1,suj_iva2,suj_iva3,miva,rsv) VALUES(NULL,30,0,2,'D',10,'V/ Factura',5,20140128000000,20140128000000,'212121','C',1024.60,1024.60,377.00,0.000,0.00,377.00,0.00,0.00,0,'A',1020.00,4.60,1024.60,20.00,0.00,0.00,1000.00,23.00,13.00,6.00,0.00,4.60,0.00,0.00,0.00,0,'');
20160115 11:37 REPLACE historicocaixa_00 SET  data=now() , tpdoc='1' , docmov='D' , numero='19' , tm='D' , mp='0' , h=now() , opr='1' , tipo='FATURA - RECIBOFATURA - RECIBO     ' , descricao='FATURA - RECIBO     ' , valor='0.6200' 
20160115 11:37 DELETE from historicocaixa_00 where   docmov='D' and tpdoc=1  and numero=19 
20160115 11:37 REPLACE historicocaixa_00 SET  data=now() , tpdoc='1' , docmov='D' , numero='19' , tm='D' , mp='0' , h=now() , opr='1' , tipo='Numerário' , descricao='Numerário           ' , valor='0.6200' 
20160115 11:38 REPLACE historicocaixa_00 SET  data=now() , tpdoc='1' , docmov='D' , numero='19' , tm='D' , mp='0' , h=now() , opr='1' , tipo='FATURA - RECIBOFATURA - RECIBO     ' , descricao='FATURA - RECIBO     ' , valor='0.6200' 
20160115 11:38 DELETE from historicocaixa_00 where   docmov='D' and tpdoc=1  and numero=19 
20160115 11:38 REPLACE historicocaixa_00 SET  data=now() , tpdoc='1' , docmov='D' , numero='19' , tm='D' , mp='0' , h=now() , opr='1' , tipo='Numerário' , descricao='Numerário           ' , valor='1.0000' 
20160115 11:38 REPLACE historicocaixa_00 SET  data=now() , tpdoc='1' , docmov='D' , numero='19' , tm='T' , mp='0' , h=now() , opr='1' , tipo='TROCO' , descricao='FATURA - RECIBO     ' , valor='-0.3800' 
20160115 11:40 REPLACE historicocaixa_00 SET  data=now() , tpdoc='1' , docmov='D' , numero='19' , tm='D' , mp='0' , h=now() , opr='1' , tipo='FATURA - RECIBOFATURA - RECIBO     ' , descricao='FATURA - RECIBO     ' , valor='0.6200' 
20160115 11:40 DELETE from historicocaixa_00 where   docmov='D' and tpdoc=1  and numero=19 
20160115 11:40 REPLACE historicocaixa_00 SET  data=now() , tpdoc='1' , docmov='D' , numero='19' , tm='D' , mp='0' , h=now() , opr='1' , tipo='Numerário' , descricao='Numerário           ' , valor='0.6200' 
20160115 11:41 REPLACE historicocaixa_00 SET  data=now() , tpdoc='1' , docmov='D' , numero='19' , tm='D' , mp='0' , h=now() , opr='1' , tipo='FATURA - RECIBOFATURA - RECIBO     ' , descricao='FATURA - RECIBO     ' , valor='0.6200' 
20160115 11:41 DELETE from historicocaixa_00 where   docmov='D' and tpdoc=1  and numero=19 
20160115 11:41 REPLACE historicocaixa_00 SET  data=now() , tpdoc='1' , docmov='D' , numero='19' , tm='D' , mp='0' , h=now() , opr='1' , tipo='Numerário' , descricao='Numerário           ' , valor='0.6200' 
20160119 10:13 TRUNCATE TABLE documento_D15_a_hash
20160119 10:13 TRUNCATE TABLE documento_D17_a_hash
20160119 10:13 TRUNCATE TABLE documento_D18_a_hash
20160203 12:58 TRUNCATE TABLE documento_D15_a_hash
20160203 12:58 TRUNCATE TABLE documento_D17_a_hash
20160203 12:58 TRUNCATE TABLE documento_D18_a_hash
20160308 16:26 INSERT INTO movimentos_de_contas_bancarias (idx,linhas,n_doc,emitido,anulado,d_doc,n_operador,cont_org,ref_conta,cont_dest,ref_conta2,observacao,tot_valor,tipo,clinum,clinome,prazo,data2,rsv) VALUES(NULL,0,1,0,'',20160308000000,0,0,'',0,'','',0.00,3,0,'','','','');
20160308 16:29 INSERT INTO movimentos_de_contas_bancarias (idx,linhas,n_doc,emitido,anulado,d_doc,n_operador,cont_org,ref_conta,cont_dest,ref_conta2,observacao,tot_valor,tipo,clinum,clinome,prazo,data2,rsv) VALUES(NULL,0,1,0,'',20160308000000,0,0,'',0,'','',0.00,3,0,'','','','');
20160308 16:35 INSERT INTO movimentos_de_contas_bancarias (idx,linhas,n_doc,emitido,anulado,d_doc,n_operador,cont_org,ref_conta,cont_dest,ref_conta2,observacao,tot_valor,tipo,clinum,clinome,prazo,data2,rsv) VALUES(NULL,0,1,0,'',20160308000000,0,0,'',0,'','',0.00,3,0,'','','','');
20160308 18:24 REPLACE historicocaixa_00 SET  data=now() , tpdoc='1' , docmov='D' , numero='20' , tm='D' , mp='0' , h=now() , opr='1' , tipo='FATURA - RECIBOFATURA - RECIBO     ' , descricao='FATURA - RECIBO     ' , valor='123.0000' 
20160308 18:24 REPLACE historicocaixa_00 SET  data=now() , tpdoc='1' , docmov='D' , numero='20' , tm='D' , mp='0' , h=now() , opr='1' , tipo='FATURA - RECIBOFATURA - RECIBO     ' , descricao='FATURA - RECIBO     ' , valor='123.0000' 
20160308 18:25 REPLACE historicocaixa_00 SET  data=now() , tpdoc='1' , docmov='D' , numero='20' , tm='D' , mp='0' , h=now() , opr='1' , tipo='FATURA - RECIBOFATURA - RECIBO     ' , descricao='FATURA - RECIBO     ' , valor='123.0000' 
20160309 16:23 INSERT INTO movimentos_de_contas_bancarias (idx,linhas,n_doc,emitido,anulado,d_doc,n_operador,cont_org,ref_conta,cont_dest,ref_conta2,observacao,tot_valor,tipo,clinum,clinome,prazo,data2,rsv) VALUES(NULL,0,1,0,'',20160309000000,0,0,'',0,'','',0.00,5,0,'','','','');
20160309 16:23 INSERT INTO movimentos_de_contas_bancarias (idx,linhas,n_doc,emitido,anulado,d_doc,n_operador,cont_org,ref_conta,cont_dest,ref_conta2,observacao,tot_valor,tipo,clinum,clinome,prazo,data2,rsv) VALUES(NULL,0,1,0,'',20160309000000,0,0,'',0,'','',0.00,5,0,'','','','');
20160309 16:24 INSERT INTO movimentos_de_contas_bancarias (idx,linhas,n_doc,emitido,anulado,d_doc,n_operador,cont_org,ref_conta,cont_dest,ref_conta2,observacao,tot_valor,tipo,clinum,clinome,prazo,data2,rsv) VALUES(NULL,0,1,0,'',20160309000000,0,0,'',0,'','',0.00,5,0,'','','','');
20160309 16:25 INSERT INTO movimentos_de_contas_bancarias (idx,linhas,n_doc,emitido,anulado,d_doc,n_operador,cont_org,ref_conta,cont_dest,ref_conta2,observacao,tot_valor,tipo,clinum,clinome,prazo,data2,rsv) VALUES(NULL,0,1,0,'',20160309000000,0,0,'',0,'','',0.00,5,0,'','','','');
20160309 16:25 INSERT INTO movimentos_de_contas_bancarias (idx,linhas,n_doc,emitido,anulado,d_doc,n_operador,cont_org,ref_conta,cont_dest,ref_conta2,observacao,tot_valor,tipo,clinum,clinome,prazo,data2,rsv) VALUES(NULL,0,1,0,'',20160309000000,0,0,'',0,'','',0.00,3,0,'','','','');
20160309 16:27 INSERT INTO movimentos_de_contas_bancarias_linhas (idx,lnh_f,cor,no_doc,no_form,des_form,d_form,ref,valor,transf,conta,d_mov,doc_mov,tp,no_doc2,linha,estado,tipo,rsv) VALUES(NULL,5,0,1,0,'',20160302000000,'',0.00,'',0,00000000000000,'',0,0,0,'',3,'');
20160713 18:09 TRUNCATE TABLE documento_D15_a_hash
20160713 18:09 TRUNCATE TABLE documento_D17_a_hash
20160713 18:09 TRUNCATE TABLE documento_D18_a_hash
20160801 09:34 TRUNCATE TABLE documento_D15_a_hash
20160801 09:34 TRUNCATE TABLE documento_D17_a_hash
20160801 09:34 TRUNCATE TABLE documento_D18_a_hash
20160801 12:40 TRUNCATE TABLE documento_D17_a_hash
20160801 12:40 TRUNCATE TABLE documento_D18_a_hash
20160801 12:40 TRUNCATE TABLE documento_D21_a_hash
20160801 12:40 TRUNCATE TABLE documento_D22_a_hash
20170103 14:32 INSERT INTO encart_c (idx,td,no,lnh,d_enc,nocli,codigo,flg_iva,qtd_enc,qtd_ent,preco,desc1,desc2,d_prev,estado,refer,rsv) VALUES(NULL,1,1,4,20170103000000,2,'//','',1.00,0.00,0.00,0.00,0.00,20170103000000,0,'','');
20170103 14:32 INSERT INTO encart_c (idx,td,no,lnh,d_enc,nocli,codigo,flg_iva,qtd_enc,qtd_ent,preco,desc1,desc2,d_prev,estado,refer,rsv) VALUES(NULL,1,1,4,20170103000000,2,'//','',1.00,0.00,0.00,0.00,0.00,20170103000000,0,'','');
20170207 10:41 REPLACE encart_c SET  td='1' , no='1' , lnh='3' , d_enc='20170207' , nocli='4' , codigo='123' , flg_iva='' , qtd_enc='2' , qtd_ent='0' , preco='1' , desc1='0' , desc2='0' , d_prev='20170207' , estado='0' , qtd_falta='2' , refer='' 
20170207 11:48 UPDATE contas_bancarias set debito='0.0000',credito='0.0000',saldo='0.0000' where no=1 
20170207 11:48 UPDATE contas_bancarias set debito='0.0000',credito='0.0000',saldo='0.0000' where no=2 
20170207 11:48 UPDATE contas_bancarias set debito='0.0000',credito='0.0000',saldo='0.0000' where no=3 
20170207 11:48 UPDATE contas_bancarias set debito='0.0000',credito='0.0000',saldo='0.0000' where no=4 
20170207 11:48 UPDATE contas_bancarias set debito='0.0000',credito='0.0000',saldo='0.0000' where no=5 
20170207 11:48 UPDATE contas_bancarias set debito='0.0000',credito='0.0000',saldo='0.0000' where no=6 
20170207 11:48 UPDATE contas_bancarias set debito='0.0000',credito='0.0000',saldo='0.0000' where no=7 
20170207 11:48 UPDATE contas_bancarias set debito='0.0000',credito='0.0000',saldo='0.0000' where no=8 
20170207 11:48 UPDATE contas_bancarias set debito='0.0000',credito='0.0000',saldo='0.0000' where no=9 
20170207 11:48 UPDATE contas_bancarias set debito='0.0000',credito='0.0000',saldo='0.0000' where no=10 
20170209 15:46 TRUNCATE TABLE documento_D17_a_hash
20170714 13:21 INSERT INTO movimentos_de_contas_bancarias_linhas (idx,lnh_f,cor,no_doc,no_form,des_form,d_form,ref,valor,transf,conta,d_mov,doc_mov,tp,no_doc2,linha,estado,tipo,rsv) VALUES(NULL,5,0,1,0,'',20170714000000,'',0.00,'',0,00000000000000,'',0,0,0,'',5,'');
20180824 18:15 TRUNCATE TABLE documento_D17_a_hash
20180824 18:15 TRUNCATE TABLE documento_D18_a_hash
20180824 18:15 TRUNCATE TABLE documento_D21_a_hash
20180824 18:15 TRUNCATE TABLE documento_D22_a_hash
20190702 14:26 TRUNCATE TABLE documento_D17_a_hash
20190702 14:26 TRUNCATE TABLE documento_D18_a_hash
20190702 14:26 TRUNCATE TABLE documento_D21_a_hash
20190702 14:26 TRUNCATE TABLE documento_D22_a_hash
20201221 15:21 TRUNCATE TABLE documento_D17_a_hash
20201221 15:21 TRUNCATE TABLE documento_D18_a_hash
20201221 15:21 TRUNCATE TABLE documento_D21_a_hash
20201221 15:21 TRUNCATE TABLE documento_D22_a_hash
20201221 15:21 TRUNCATE TABLE documento_D17_a_hash
20201221 15:21 TRUNCATE TABLE documento_D18_a_hash
20201221 15:21 TRUNCATE TABLE documento_D21_a_hash
20201221 15:21 TRUNCATE TABLE documento_D22_a_hash
