Payments To Suppliers

supplier_name SUPPLIER NAME	portfolio PORTFOLIO	cost_centre COST CENTRE	expenditure_class EXPENDITURE CLASS	post_date POST. DATE	amount AMOUNT	ref REF.
AA SHOPFITTING & BUILDING SERVICES LTD	Corp Serv, Perform. & Leisure	The Pavilion	Equipment R & M	23/01/2014	265	108194
AA SHOPFITTING & BUILDING SERVICES LTD	Other	General Fund Balance Sheet	In Year Capital Additions	21/01/2014	1790	108195
ACT CREDIT MANAGEMENT LIMITED	Finance, Efficiency & Assets	Financial Services	Debt Collection Services	09/01/2014	320	107606
ADAM TOONE PLUMBING & HEATING SERVICES	Other	General Fund Balance Sheet	In Year Capital Additions	22/01/2014	2345	108321
ADECCO UK LTD	N'Hood & Env. Health Services	Environmental Health	Gross Pay	02/01/2014	448.12	106953
ADECCO UK LTD	N'Hood & Env. Health Services	Environmental Health	Gross Pay	02/01/2014	342.68	107215
ADECCO UK LTD	N'Hood & Env. Health Services	Environmental Health	Gross Pay	02/01/2014	355.86	107226
ADECCO UK LTD	N'Hood & Env. Health Services	Environmental Health	Gross Pay	09/01/2014	428.35	107454
ADECCO UK LTD	N'Hood & Env. Health Services	Environmental Health	Gross Pay	30/01/2014	451.42	108563
AIR QUALITY CONSULTANTS	Other	General Fund Balance Sheet	In Year Capital Additions	29/01/2014	880	103309


CREATE TABLE january_2014 (
  "supplier_name" VARCHAR,
  "portfolio" VARCHAR,
  "cost_centre" VARCHAR,
  "expenditure_class" VARCHAR,
  "post_date" VARCHAR,
  "amount" DOUBLE,
  "ref" DOUBLE
);