Payments To Suppliers

supplier_name SUPPLIER NAME	portfolio PORTFOLIO	cost_centre COST CENTRE	expenditure_class EXPENDITURE CLASS	post_date POST. DATE	amount AMOUNT	proclass_ref PROCLASS REF.
AA SHOPFITTING & BUILDING SERVICES LTD	Finance, Efficiency & Assets	The Pavillion - Land And Build	Rea: Roofing	Mon Apr 27 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	290	102300
A B & C LIMITED	N'Hood & Env. Health Services	Refuse Coll & Domestic Recyc	Accidental Damage Repair Costs	Thu Apr 30 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	260	381500
ALLPAY LIMITED DIRECT DEBIT ACCOUNT	Finance, Efficiency & Assets	Banking Charges	Transaction Costs - All Pay	Thu Apr 09 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	690.8	201510
ALL SAINTS CHURCH	N'Hood & Env. Health Services	Car Parks	Rent Payments	Thu Apr 23 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	1500	202000
ALZHEIMER'S SOCIETY	Health Improvement & Leisure	Corporate Health Improvement	Project/Initiatives Fees	Thu Apr 16 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	2327	311410
ANCHORPRINT GROUP LIMITED	Health Improvement & Leisure	Corporate Health Improvement	Publicity & Promotion	Tue Apr 14 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	229.19	191600
ANCHORPRINT GROUP LIMITED	Health Improvement & Leisure	Corporate Health Improvement	Publicity & Promotion	Thu Apr 23 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	405	191600
ANCHORPRINT GROUP LIMITED	Leader	Corporate Management	Provision Amounts	Thu Apr 30 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	540	191600
A & S PROPERTY SERVICES	Community Services	Housing Support - Leics Royal	Homelessness	Thu Apr 23 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	750	321021
BARTON PETROLEUM LIMITED	Other	General Fund Balance Sheet	Fuel	Thu Apr 23 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	16908.41	381100


CREATE TABLE april_2015 (
  "supplier_name" VARCHAR,
  "portfolio" VARCHAR,
  "cost_centre" VARCHAR,
  "expenditure_class" VARCHAR,
  "post_date" TIMESTAMP,
  "amount" DOUBLE,
  "irrecoverable_vat" BIGINT,
  "proclass_ref" BIGINT
);