REPORTFORM;BP1_E.frf
TITLE;PAYMENT SUMMARY REPORT
SQL;select appayhd.DOCNO, appayhd.DATEDOC, appayhd.ACCID,
SQL;apmst.XCOMP, appayhd.CASHAMT, appayhd.CHKAMT,
SQL;appayhd.TAXPAID, appayhd.DISCD, appayhd.OTHERS,
SQL;appayhd.AMOUNT
SQL;from appayhd
SQL;left join apmst on appayhd.ACCID = apmst.ACCID
SQL;where left(appayhd.DOCNO,2)= "BP"
SQL;order by appayhd.DOCNO, appayhd.DATEDOC
CONDITION;FROM DOCUMENT~APPAYHD.DOCNO~Chr~2~SELECT DOCNO FROM APPAYHD ~
CONDITION;FROM DATE~APPAYHD.DATEDOC~Date~2~~
