-- the commented fields are included because they might be useful for some cases
select
e0.Extender_Key_Values_1 as DOCNUMBR,
e0.Extender_Key_Values_2 as RMDTYPAL,
e10.LNITMSEQ as CommentLineSeq,
--e11.Field_ID,
e11.STRGA255 as Comment,
--fld.FIELDNAM,
--e12.LNITMSEQ,
--e12.Field_ID,
e12.DATE1 as CommentDate
--fld1.FIELDNAM
from ext01100 e0
join ext01110 e10 on e10.Extender_Record_ID = e0.Extender_Record_ID
join ext01111 e11 on e11.Extender_Record_ID = e0.Extender_Record_ID and e11.LNITMSEQ = e10.LNITMSEQ
join ext20010 fld on fld.Field_ID = e11.Field_ID
join ext01112 e12 on e12.Extender_Record_ID = e0.Extender_Record_ID and e12.LNITMSEQ = e10.LNITMSEQ
join ext20010 fld1 on fld1.Field_ID = e12.Field_ID
where e0.Extender_Window_ID = 'sophdr2'
order by 1,3