select
h.linkcode,
h.posted,
h.cmpcode,
h.doccode,
h.docnum,
h.docdate,
h.descr as descr_pce,
l.doclinenum,
l.accode,
l.valuedoc,
l.debitcredit,
case when l.debitcredit = 161 then l.valuedoc
else -valuedoc
end
as mt_sig,
l.descr as descr_lig,
l.extref1,
l.extref2,
l.extref3,
l.extref4,
l.extref5
from
[TCACODDP].[dbo].[oas_linkhead] h, [TCACODDP].[dbo].[oas_linkline] l
where
h.posted in (23, 46)
and h.cmpcode like 'G-%'
and h.cmpcode = l.cmpcode
and h.doccode = l.doccode
and h.docnum = l.docnum