Skip to Content

Query para ver lista de plan Contable

Sres Buenas Tardes, les dejo un pequeño query para ver la lista del plan contable.

select Grupo = case groupmask when 1 then ‘Activos’ when 2 then ‘Pasivos’ when 3 then ‘Patrimonio’

when 4 then ‘Ingresos Operacionales’ when 5 then ‘Costos Operacionales’ when 6 then ‘Gastos Operacionales’

when 7 then ‘Otros ingresos’ when 8 then ‘Otros Gastos’ end,Cuenta_Mayor=

case when acctcode like’_SYS%’ then segment_0+’-‘+segment_1+’-‘+segment_2

when acctcode like’%0000000000%’ then substring(acctcode,1,2) else acctcode end,

acctname Detalle,currtotal Saldo,U_syp_pccd Cta_Destino,U_bpp_pccr Cta_Asociada from oact

order by groupmask,grpline,levels,formatcode

Be the first to leave a comment
You must be Logged on to comment or reply to a post.