REPORTFORM;PURREG.frf
TITLE;ทะเบียนซื้อ
SQL;select apcard.DOCNO,apcard.DATEDOC,apcard.ACCID,apmst.XCOMP,
SQL;apcard.ORDPONO,apcard.INVAMT, apcard.taxno,
SQL;apcard.VATAMT,apcard.AMOUNT_D
SQL;from apcard left join apmst on apcard.ACCID = apmst.ACCID
SQL;where trtype = 'AP1'
SQL;order by apcard.DOCNO
CONDITION;ตั้งแต่วันที่~APCARD.DATEDOC~Date~2~~
