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.
1ST CHOICE PROPERTY MAINTENANCE COMMERCIAL	Finance, Efficiency & Assets	Council Offices & Land	Rea: Building	31/03/2015	2100	129466
42ND LEICESTER GLENFIELD SCOUT GROUP	Other	General Fund Balance Sheet	In Year Capital Additions	19/03/2015	5000	128736
ABEL ALARM COMPANY LIMITED	N'Hood & Env. Health Services	Car Parks	Security Systems Inc Cctv	12/03/2015	443	127794
ADSO	Leader	Staff Training And Development	Training Costs	18/03/2015	1875	128351
ADVANCE STAMP & PLATE COMPANY	Planning, Econ. Dev. & Housing	Planning Administration	Stationery	18/03/2015	316.16	128310
ALLPAY LIMITED DIRECT DEBIT ACCOUNT	Finance, Efficiency & Assets	Banking Charges	Transaction Costs - All Pay	05/03/2015	381.85	127825
AMR DEVELOPMENTS LIMITED	Other	General Fund Balance Sheet	In Year Capital Additions	25/03/2015	3561	129011
ANCHORPRINT GROUP LIMITED	Finance, Efficiency & Assets	C.Tax Billing, Coll & Recovery	Books, Newspapers And Pubs	25/03/2015	317.09	129007
ANCHORPRINT GROUP LIMITED	N'Hood & Env. Health Services	Refuse Coll & Domestic Recyc	Publicity & Promotion	31/03/2015	553.4	129405
ANCHORPRINT GROUP LIMITED	N'Hood & Env. Health Services	Refuse Coll & Domestic Recyc	Publicity & Promotion	31/03/2015	519	129404


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