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.
ABRITAS	Community Services	Choice Based Lettings	Professional Services	15/01/2015	913.7	125615
ABRITAS	Community Services	Choice Based Lettings	Software Maintenance	15/01/2015	6458.33	125615
ALLPAY LIMITED DIRECT DEBIT ACCOUNT	Finance, Efficiency & Assets	Banking Charges	Transaction Costs - All Pay	08/01/2015	1314.4	125266
ANCHORPRINT GROUP LIMITED	Partnerships & Corp. Services	Reprographics	Print Mats (Int. Print Room)	29/01/2015	576.35	126190
ANCHORPRINT GROUP LIMITED	Planning, Econ. Dev. & Housing	Economic Development	Publicity & Promotion	22/01/2015	523.63	125924
BEAVER BUS	N'Hood & Env. Health Services	Fleet Management	Mot'S	08/01/2015	1117	125273
BELL & SONS	Finance, Efficiency & Assets	Council Offices & Land	Rea: Building	21/01/2015	420	125908
BIRMINGHAM CITY UNIVERSITY	Leader	Staff Training And Development	Training Costs	22/01/2015	3375	122527
BOTTOMLINE TECHNOLOGIES	Finance, Efficiency & Assets	C.Tax Billing, Coll & Recovery	Software Maintenance	12/01/2015	1000	125274
BOTTOMLINE TECHNOLOGIES	Health Improvement & Leisure	The Pavilion	Software Maintenance	12/01/2015	500	125274


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