Skip to Content
Author's profile photo Former Member

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

Assigned Tags

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