REPORTFORM;BR3_E.frf
TITLE;RECEIPT INFORMATION BY SALE CODE REPORT
SQL;SELECT 
SQL;ARCARD.DOCNO,
SQL;ARCARD.DATEDOC,ARCARD.REFNO,
SQL;ARCARD.DATEINV, ARCARD.DUEDATE, ARCARD.ACCID,
SQL;ARCARD.SALEID, ARMST.XCOMP, ARCARD.RECAMT,
SQL;SALEMST.SNAME,
SQL;ARCARD_1.DOCNO
SQL;FROM ARCARD LEFT JOIN ARMST ON ARCARD.ACCID = ARMST.ACCID
SQL;LEFT JOIN ARCARD AS ARCARD_1 ON ARCARD.REFNO = ARCARD_1.DOCNO
SQL;LEFT JOIN SALEMST ON ARCARD_1.SALEID = SALEMST.SID
SQL;WHERE ARCARD.TRTYPE = 'BR1'
SQL;ORDER BY ARCARD_1.SALEID, ARCARD.DATEDOC, ARCARD.DOCNO
CONDITION;FROM SALE CODE~ARCARD_1.SALEID~Chr~2~SELECT SID FROM SALEMST ~SALE
CONDITION;FROM DATE~ARCARD.DATEDOC~Date~2~~
