REPORTFORM;DP1_E.frf
TITLE;CREDIT NOTE INFORMATION REPORT
SQL;select apcard.DOCNO, apcard.DATEDOC, apcard.REFNO,
SQL;apcard.ACCID, apmst.XCOMP, apcard.AMOUNT_D, apcard.DPTID,
SQL;apcard.TAXNO
SQL;from apcard
SQL;left join apmst on apcard.ACCID = apmst.ACCID
SQL;where left(apcard.TRTYPE,2)= "DP"
SQL;order by apcard.DOCNO
CONDITION;FROM DOCUMENT~APCARD.DOCNO~Chr~2~SELECT DOCNO FROM APCARD WHERE LEFT(APCARD.TRTYPE,2)= "DP"~
CONDITION;FROM DATE~APCARD.DATEDOC~Date~2~~
