Este querie mira CWA y me dice por lote los totales

SELECT lote=
rtrim(CJRMVH_HORMOV) ,SUM (CJRMVI_IMPDEB) AS [importe] , cjrmvh_fchmov
FROM 
GIGA_S_15_INT.gigared.dbo.CJRMVH
INNER JOIN GIGA_S_15_INT.gigared.dbo.CJRMVI ON (CJRMVH.CJRMVH_MODFOR = CJRMVI.CJRMVI_MODFOR AND CJRMVH.CJRMVH_CODFOR = CJRMVI.CJRMVI_CODFOR AND CJRMVH.CJRMVH_NROFOR = CJRMVI.CJRMVI_NROFOR) 
where cjrmvh_textos like 'Importado desde Cablesoft - %' 
group by rtrim(CJRMVH_HORMOV) , cjrmvh_fchmov
order by convert (int, rtrim(CJRMVH_HORMOV))

Querie mira la interfaz y me dice que hay lotes $$$totales

select  sum(ctaimpgrab),nrolot as lote  from hctacte
group by nrolot
order by nrolot asc

Este querie me desglosa por lote y me brinda el IDCTACTE (para cruzar boxi)

Version Parana Analisis (campos que uso)

SELECT (USR_ICRMVI_IDCTAC) AS [Idctacte], USR_DATOSINTERFAZ_LOTE,
(USR_ICRMVI_CNDPAG) AS [tip_comp] ,
(USR_ICRMVI_USERID) AS [USERID] ,(USR_ICRMVI_IMPNAC) AS [Importe] ,
(USR_ICRMVI_ABONRO) AS [abumero] ,(USR_ICRMVI_ABONOM) AS [ABONOM] ,
(CJRMVI_CODFOR) AS [CODFOR] ,(CJRMVI_NROFOR) AS [NROFOR] ,
(CJRMVI_DEBHAB) AS [DEBHAB] ,(CJRMVI_MODCPT) AS [MODCPT] ,
(CJRMVI_CTACTE) AS [dato_CTACTE] ,(CJRMVI_CUENTA) AS [CUENTA] ,(CJRMVI_IMPDEB) AS [IMPDEB] 
FROM GIGA_S_15_INT.gigared.dbo.USR_DATOSINTERFAZ WHERE   USR_DATOSINTERFAZ_LOTE = 571
order by (USR_ICRMVI_IDCTAC) asc

Analisis interfaz (boxicwa)

select id, idctacte,abonumero,ctaimpgrab as importe, ctafemis, estcta,ctacoment,ctausr from hctacte
where nrolot = '571'
order by idctacte asc

Version Original CWA:

SELECT USR_DATOSINTERFAZ_LOTE,
(USR_ICRMVI_CNDPAG) AS [USR_ICRMVI_CNDPAG] ,(USR_ICRMVI_CODSUC) AS [USR_ICRMVI_CODSUC] ,(USR_ICRMVI_NOMSUC) AS [USR_ICRMVI_NOMSUC] ,
(USR_ICRMVI_USERID) AS [USR_ICRMVI_USERID] ,(USR_ICRMVI_IMPNAC) AS [USR_ICRMVI_IMPNAC] ,(USR_ICRMVI_CODBCO) AS [USR_ICRMVI_CODBCO] ,
(USR_ICRMVI_SUCURS) AS [USR_ICRMVI_SUCURS] ,(USR_ICRMVI_CHQNRO) AS [USR_ICRMVI_CHQNRO] ,(USR_ICRMVI_CHQFEC) AS [USR_ICRMVI_CHQFEC] ,
(USR_ICRMVI_ENTTIP) AS [USR_ICRMVI_ENTTIP] ,(USR_ICRMVI_ENTDES) AS [USR_ICRMVI_ENTDES] ,(USR_ICRMVI_ENTCOD) AS [USR_ICRMVI_ENTCOD] ,
(USR_ICRMVI_ENTNOM) AS [USR_ICRMVI_ENTNOM] ,(USR_ICRMVI_TARNRO) AS [USR_ICRMVI_TARNRO] ,(USR_ICRMVI_TARLOT) AS [USR_ICRMVI_TARLOT] ,
(USR_ICRMVI_TARCUP) AS [USR_ICRMVI_TARCUP] ,(USR_ICRMVI_ABONRO) AS [USR_ICRMVI_ABONRO] ,(USR_ICRMVI_ABONOM) AS [USR_ICRMVI_ABONOM] ,
(USR_ICRMVI_ABODIR) AS [USR_ICRMVI_ABODIR] ,(USR_ICRMVI_ABOCUI) AS [USR_ICRMVI_ABOCUI] ,(USR_ICRMVI_IDCTAC) AS [USR_ICRMVI_IDCTAC] ,
(CJRMVI_CODFOR) AS [CJRMVI_CODFOR] ,(CJRMVI_NROFOR) AS [CJRMVI_NROFOR] ,(CJRMVI_DEBHAB) AS [CJRMVI_DEBHAB] ,(CJRMVI_MODCPT) AS [CJRMVI_MODCPT] ,
(CJRMVI_TIPCPT) AS [CJRMVI_TIPCPT] ,(CJRMVI_CODCPT) AS [CJRMVI_CODCPT] ,(CJRMVI_CHEQUE) AS [CJRMVI_CHEQUE] ,(CJRMVI_CODBCO) AS [CJRMVI_CODBCO] ,
(CJRMVI_IMPORT) AS [CJRMVI_IMPORT] ,(CJRMVI_CTACTE) AS [CJRMVI_CTACTE] ,(CJRMVI_CUENTA) AS [CJRMVI_CUENTA] ,(CJRMVI_IMPDEB) AS [CJRMVI_IMPDEB] ,
(CJRMVI_IMPHAB) AS [CJRMVI_IMPHAB]  
FROM GIGA_S_15_INT.gigared.dbo.USR_DATOSINTERFAZ WHERE   USR_DATOSINTERFAZ_LOTE = 552

Parana analisis, BOXI

select idctacte, abonumero, ctaimpgrab, ctafemis from ctacte
where idctacte in (
SELECT (USR_ICRMVI_IDCTAC) AS [Idctacte]
FROM GIGA_S_15_INT.gigared.dbo.USR_DATOSINTERFAZ WHERE   USR_DATOSINTERFAZ_LOTE = 571
)