REPORTFORM;ARBILL_1.frf
TITLE;ãºá¨é§ÂÍ´ºÑ­ªÕ
SQL;drop table if exists _xarbill&
SQL;
SQL;create table _xarbill 
SQL;select config.XCOMP as ourcompany, config.COMADD1 as ouradd1, config.COMADD2 as ouradd2,
SQL;armst.XCOMP, armst.ADD_1, armst.ADD_2,
SQL;arcard.ACCID, arcard.DOCNO, arcard.DATEDOC, arcard.DUEDATE, arcard.NBAL,:m11 as DATEBILL,
SQL;:m31 as daterange1, :m32 as daterange2
SQL;from arcard inner join armst on arcard.ACCID = armst.ACCID
SQL;inner join config on '01' = config.XINDEX
SQL;where (left(arcard.trtype,2) = 'AR' OR left(arcard.trtype,2) = 'DR')
SQL;and arcard.accid >= :m21 and arcard.accid <= :m22
SQL;and arcard.datedoc >= :m31 and arcard.datedoc <= :m32
SQL;and arcard.nbal <> 0
SQL;order by arcard.accid, arcard.datedoc, arcard.docno&
SQL;
SQL;select * from _xarbill order by accid, datedoc, docno
CONDITION;á¨é§ÂÍ´ºÑ­ªÕ ÇÑ¹·Õè~ARCARD.DATEDOC~Date~1~~
CONDITION;µÑé§áµèÃËÑÊÅÙ¡¤éÒ~ARCARD.ACCID~Chr~2~SELECT ACCID FROM ARCARD~AR
CONDITION;µÑé§áµèÇÑ¹·ÕèàÍ¡ÊÒÃ~ARCARD.DATEDOC~Date~2~~
EXCELSQL;drop table if exists _xarbill&
EXCELSQL;
EXCELSQL;create table _xarbill 
EXCELSQL;select config.XCOMP as ourcompany, config.COMADD1 as ouradd1, config.COMADD2 as ouradd2,
EXCELSQL;armst.XCOMP, armst.ADD_1, armst.ADD_2,
EXCELSQL;arcard.ACCID, arcard.DOCNO, arcard.DATEDOC, arcard.DUEDATE, arcard.NBAL,:m11 as DATEBILL
EXCELSQL;from arcard inner join armst on arcard.ACCID = armst.ACCID
EXCELSQL;inner join config on '01' = config.XINDEX
EXCELSQL;where (left(arcard.trtype,2) = 'AR' OR left(arcard.trtype,2) = 'DR')
EXCELSQL;and arcard.accid >= :m21 and arcard.accid <= :m22
EXCELSQL;and arcard.datedoc >= :m31 and arcard.datedoc <= :m32
EXCELSQL;and arcard.nbal <> 0
EXCELSQL;order by arcard.accid, arcard.datedoc, arcard.docno&
EXCELSQL;
EXCELSQL;select * from _xarbill order by accid, datedoc, docno
