$VAR1 = {
          'columnsettings' => 'date,CASHUP DATE

code,MEMBER CODE

name,MEMBER NAME

credit,CREDIT CARD AMOUNT,total:sum;number:yes;align:right;

description,DESCRIPTION',
          'selector' => '2',
          'data' => 'SELECT

    `dcash`.`date`

    , `tillclients`.`code`

    , `tillclients`.`name`

    , `accounts`.`credit`

    , `accounts`.`transaction_type`

    , `accounts`.`description`

FROM

    `dcash`

    INNER JOIN `accounts` 

        ON (`dcash`.`date` = `accounts`.`date`)

    INNER JOIN `tillclients` 

        ON (`accounts`.`entityid` = `tillclients`.`id`)

        WHERE account = 1 AND transaction_type = \'Card\' AND accounts.`credit` > 0

        AND  dcash.date >= \'[sdate]\' AND dcash.date <= \'[edate]\';

',
          'description' => 'Credit Card Receipts on Accounts',
          'settings' => 'sdate,date,Start Date

edate,date,End Date',
          'rollup' => 'date',
          'id' => '60',
          'title' => 'Credit Card Report',
          'category' => 'OAKDALE - REPORTS',
          'code' => '106'
        };