REPORTFORM;TR1_E.frf
TITLE;STOCK TRANSFER INFORMATION REPORT
SQL;select trantail.DATEDOC, tranhd.DPTID, trantail.ID,
SQL;invmst.XDESC, trantail.QUAN, trantail.UNIT, 
SQL;tranhd.LOCIDFRM, tranhd.LOCIDTO,
SQL;trantail.DOCNO
SQL;from trantail
SQL;left join tranhd on trantail.DOCNO = tranhd.DOCNO
SQL;left join invmst on trantail.ID = invmst.ID 
SQL;order by trantail.DOCNO, trantail.DATEDOC,trantail.ID
CONDITION;FROM DOCUMENT~TRANTAIL.DOCNO~Chr~2~SELECT DOCNO FROM TRANTAIL~
CONDITION;FROM DATE~TRANTAIL.DATEDOC~Date~2~~
