CLOSE TABLES all
USE f:\sistema\systems\system_heb\data\1\ccvent.dbf IN 0
USE f:\sistema\systems\system_heb\data\1\cliaux.dbf IN 0
USE f:\sistema\systems\_system_base\agip\padron_agip_20250201.dbf ALIAS padron IN 0

SELECT ve.cod_cli,ve.suc , ve.fac_ven, ve.fec_ven, ve.des_clie ,cl.entnom, ve.cuit, ve.tot_ven, cl.entpro ;
	FROM ccvent ve ;
	LEFT OUTER JOIN cliaux cl ON ve.fac_ven+ve.causa=cl.comprob+cl.causa ;
	WHERE ve.fec_Ven>DATE(2025,02,01) AND ve.CUIT>"30716426404" AND INLIST(ve.causa,"V","c","d") AND entpro="C";
	ORDER BY cod_cli;
	into cursor TMPComprob
	
SELECT cp.*, pa.percep, pa.retenc FROM tmpcomprob cp LEFT OUTER JOIN padron pa ON pa.cuit=cp.cuit;
	INTO CURSOR TMPFinal 

BROWSE