while (@fetch = $sth1->fetchrow)
		{
			$vendor          = $fetch[0];
			$terminal_id     = $fetch[1]; 
			$terminal_name   = $fetch[3];
			$refunds         = $fetch[4];
			$sales           = $fetch[5];
			$count           = $fetch[6];
			
      $vendor_sales{$vendor}{terminals}{$terminal_id}{terminal_name}   = $terminal_name;
      $vendor_sales{$vendor}{terminals}{$terminal_id}{sales}   = $sales;
      $vendor_sales{$vendor}{terminals}{$terminal_id}{refunds}   = $refunds;
      $vendor_sales{$vendor}{terminals}{$terminal_id}{count}   = $count;
     }                                     

##</code><code>##

        'Book Shop' => {
                         '10' => {
                                   'count' => 222,
                                   'refunds' => '90.00',
                                   'sales' => '1200',
                                   'terminal_name' => 'Front Till'
                                 },
                         '20' => {
                                   'count' => 149,
                                   'refunds' => '124.00',
                                   'sales' => '7000.00',
                                   'terminal_name' => 'Side Till'
                                 }
                       },
          'Sweet Shop' => {
                               '40' => {
                                         'count' => 2,
                                         'refunds' => '0.00',
                                         'sales' => '400.00',
                                         'terminal_name' => 'Cash Till'
                                       },
                               '60' => {
                                        'count' => 241,
                                        'refunds' => '20.00',
                                        'sales' => '600.00',
                                        'terminal_name' => 'Credit Till'
                                      }
                             }

##</code><code>##

[% FOREACH vendor IN vendor_sales %] 
       	    [% vendor.key %] : [% vendor.terminals.terminal_name %]
[% END %]