SELECT recordtype, importaccountid, DTOS({06/04/2003}) AS postdate, ; > effectivedate, transactiontype, dbcr, ; > SUM(IIF(dbcr = 'C', -1 * VAL(amount), VAL(amount))) AS amount, ; > ref1, ref2, ref3, ref4, ref5, PADR(ALLTRIM(details),40) AS details, ; > scvind, name, company, phone, SPACE(20) AS email, SPACE(15) AS fax, ; > property, address1, address2, city, state, filler, zip, country, ; > filler2 ; > FROM cwtsdata ; > GROUP BY recordtype, importaccountid, postdate, effectivedate, ; > transactiontype, dbcr, ref1, ref2, ref3, ref4, ref5, ; > details, scvind, name, company, phone, email, ; > fax, property, address1, address2, city, state, filler, zip, ; > country, filler2 ; > INTO CURSOR CashwiseTerminalServicesData