REPORTFORM;ABILL3_E.frf
TITLE;BILL RECEIPT BY VENDOR
SQL;select billaphd.BILLDATE, billaptr.DOCNO, billaphd.DATEREC,
SQL;billaptr.DATEDOC, billaptr.DUEDATE, billaptr.AMOUNT_L,billaphd.XREMARK,
SQL;billaptr.BDOCNO, billaphd.ACCID, apmst.XCOMP
SQL;from billaptr 
SQL;left join billaphd on billaptr.BDOCNO = billaphd.BDOCNO
SQL;left join apmst on billaphd.ACCID = apmst.ACCID
SQL;order by billaphd.ACCID, billaphd.DATEDOC, billaptr.DOCNO
CONDITION;FROM VONDOR CODE~BILLAPHD.ACCID~Chr~2~SELECT ACCID FROM APMST~AP
CONDITION;FROM DATE~BILLAPHD.DATEDOC~Date~2~~
