$VAR1 = {
          'columnsettings' => 'typename,Cost Center

sku,SKU

barcode,Barcode

catname,Category

siname,Stock Item

line,Stock Count',
          'selector' => '2',
          'data' => 'SELECT st.name typename, 

si.sku, si.barcode,

sc.name catname,si.name siname, \'___ ___ ___\' AS line



FROM stockitems si, stocktypes st, stockcats sc

WHERE st.id = si.type AND sc.id = si.stockcats_id

and sc.name like \'%[catfilter]%\'

and st.name like \'%[costfilter]%\'

ORDER BY st.name,sc.name,si.name;',
          'description' => 'List all stockitems for stock take',
          'settings' => 'costfilter,value,Enter Cost Center Filter

catfilter,value,Enter Category Filter',
          'rollup' => '',
          'id' => '9',
          'title' => 'Stock Sheet',
          'category' => 'Stock',
          'code' => '5'
        };