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	11/02/2015	260	126975
ADVANCED BUSINESS SOLUTIONS	Finance, Efficiency & Assets	Financial Services	Research & Development	05/02/2015	950	126523
ALLPAY LIMITED DIRECT DEBIT ACCOUNT	Finance, Efficiency & Assets	Banking Charges	Transaction Costs - All Pay	05/02/2015	1100.79	126432
ALL SAINTS CHURCH	N'Hood & Env. Health Services	Car Parks	Rent Payments	19/02/2015	1500	127171
AQ DATA SERVICES	N'Hood & Env. Health Services	At. Poll. (Enforce & Mon)	Air Quality Analysis	19/02/2015	880	127332
A & S PROPERTY SERVICES	Community Services	Homelessness	Homelessness	12/02/2015	1150	126964
BANNER BUSINESS SERVICES LIMITED	Finance, Efficiency & Assets	Central Stationery	Stationery	26/02/2015	310.86	125271
BARLOW BLINDS LIMITED	Finance, Efficiency & Assets	Council Offices & Land	Rea: Building	20/02/2015	716.67	126515
BIRMINGHAM CITY UNIVERSITY	Planning, Econ. Dev. & Housing	Local Development Framework	Seminars & Short Training	05/02/2015	3375	126470
BLABY AUDIO VISUAL LIMITED	Finance, Efficiency & Assets	Council Offices & Land	Rea: Electrical	04/02/2015	317	126191


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