From the Extender main window, create a new 'window', and fill in the form as you see below
Click on the 'Options' button, and fill that in as shown
Save, and open the Receivables Transaction Inquiry form. If you added a short cut key as we indicated, you can click on a document in the grid and hit CTRL + J to open our new RM Doc Inquiry form.
Add some test records for a few documents.
The query below will access those records and can be used in reporting.
-- 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