Page History

...

Detalle Se cargan todas las transacciones registradas en la tabla SICOOP.X_ORDENES del día anterior

Code Block

language	sql
theme	DJango
firstline	– En la Base Powerbi SELECT max("FEC_CAMARA") FROM "sicoop" SELECT count( * ), sum(MONTO) , TO_char(FEC_CAMARA ,'yyyymm' ) /, TIPO_TRANSACCION/ FROM "sicoop" s WHERE FEC_CAMARA >= to_date('01/07/2025','dd/mm/yyyy') AND FEC_CAMARA < to_date('01/08/2025','dd/mm/yyyy') GROUP BY TO_char(FEC_CAMARA ,'yyyymm' ) /, TIPO_TRANSACCION /; – En Sicoop SELECT count( * ), sum(MONTO/100) , TO_char(FEC_CAMARA ,'ddyyyymm' ) /, TIPO_TRANSACCION/ FROM SICOOP.X_ORDENES xo WHERE FEC_CAMARA >= to_date('06/08/2025','dd/mm/yyyy') AND FEC_CAMARA < to_date('07/08/2025','dd/mm/yyyy') GROUP BY TO_char(FEC_CAMARA ,'ddyyyymm' ) /, TIPO_TRANSACCION /;applescript
theme	RDark
title	Controles
linenumbers	true
collapse	true

– En la Base Powerbi

SELECT max("FEC_CAMARA") FROM "sicoop"

SELECT
count( * ),
sum(MONTO)
, TO_char(FEC_CAMARA ,'yyyymm' )
/, TIPO_TRANSACCION/
FROM "sicoop" s
WHERE FEC_CAMARA >= to_date('01/07/2025','dd/mm/yyyy')
AND FEC_CAMARA < to_date('01/08/2025','dd/mm/yyyy')
GROUP BY TO_char(FEC_CAMARA ,'yyyymm' ) /*, TIPO_TRANSACCION */;

– En Sicoop
SELECT
count( * ),
sum(MONTO/100)
, TO_char(FEC_CAMARA ,'ddyyyymm' )
/, TIPO_TRANSACCION/
FROM SICOOP.X_ORDENES xo
WHERE FEC_CAMARA >= to_date('06/08/2025','dd/mm/yyyy')
AND FEC_CAMARA < to_date('07/08/2025','dd/mm/yyyy')
GROUP BY TO_char(FEC_CAMARA ,'ddyyyymm' ) /*, TIPO_TRANSACCION */;

...

Page tree

Versions Compared

Old Version 3

New Version 4

Key