daniness (4/16/2014)

---

Hi Sean,

This is the query:

SELECT ISNULL(ath_stlmnt_instr_id, ae.stlmnt_line_instr_id) AS ath_instr_id

,ath_instr_id AS orig_instr_id

,ath_gl_num

,ath_cost_cntr

,CASE

WHEN ath_postype = 'GLD'

THEN sum(ath_usdamt)

WHEN ath_postype = 'GLC'

THEN sum(ath_usdamt) * - 1

END AS ath_usdamt

,count(*)

FROM dbo.ACCTING_TRANSACTION_HISTORY

left join Accting_body ae on ae.header_id = ath_header_id AND ae.body_id = ath_body_id

inner join MTB_CHART_ACCTS mca on mca.acct = ath_gl_num

WHERE mca.acct_category = 'AST'

AND ath_postype IN ('GLD', 'GLC')

group by ath_stlmnt_instr_id, ath_instr_id, ath_gl_num, ath_cost_cntr

Union

SELECT stlmnt_instr_id,instr_id,gl_num, cost_cntr, usdamt

FROM dbo.ACCTING_ADJUST

group by stlmnt_instr_id, instr_id, gl_num, cost_cntr