SELECT DISTINCT Number() rowid,

A.COMP_CODE,A.BRANCH_CODE,A.CURRENCY_CODE,A.GL_CODE,A.CIF_SUB_NO,A.SL_NO,A.CV_AMOUNT,('REVERSAL'+''+'TEST' + '' + A.DESCRIPTION) AS A_DESCRIPTION,B.COMP_CODE,B.BRANCH_CODE,B.CURRENCY_CODE,B.GL_CODE,B.CIF_SUB_NO,B.SL_NO,GETDATE() 'INSERT_DATE' ,GETDATE() 'UPDATE_DATE','0' STATUS