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.
A B & C LIMITED	N'Hood & Env. Health Services	Refuse Coll & Domestic Recyc	Accidental Damage Repair Costs	10/04/2014	260	113060
A B & C LIMITED	N'Hood & Env. Health Services	Refuse Coll & Domestic Recyc	Accidental Damage Repair Costs	17/04/2014	260	113464
ADECCO UK LTD	N'Hood & Env. Health Services	Environmental Health	Gross Pay	10/04/2014	422.63	112970
ADECCO UK LTD	N'Hood & Env. Health Services	Environmental Health	Gross Pay	10/04/2014	422.63	112971
ADECCO UK LTD	N'Hood & Env. Health Services	Environmental Health	Gross Pay	10/04/2014	422.63	112972
ADECCO UK LTD	N'Hood & Env. Health Services	Environmental Health	Gross Pay	10/04/2014	416.99	112973
ADECCO UK LTD	N'Hood & Env. Health Services	Environmental Health Promotion	Fsa -Fhrs Project Expenditure	17/04/2014	422.63	113351
ADECCO UK LTD	N'Hood & Env. Health Services	Environmental Health Promotion	Fsa -Fhrs Project Expenditure	17/04/2014	422.63	113352
ALLPAY LIMITED DIRECT DEBIT ACCOUNT	Finance, Efficiency & Assets	Banking Charges	Transaction Costs - All Pay	03/04/2014	690.38	112662
A M BUILDERS	Other	General Fund Balance Sheet	In Year Capital Additions	09/04/2014	3850	112881


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