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.
AC TRAINING SERVICES	N'Hood & Env. Health Services	Vehicle Maintenance	Seminars & Short Training	06/08/2014	472	118334
ALLPAY LIMITED DIRECT DEBIT ACCOUNT	Finance, Efficiency & Assets	Banking Charges	Transaction Costs - All Pay	06/08/2014	1514.28	118328
ALL SAINTS CHURCH	N'Hood & Env. Health Services	Car Parks	Rent Payments	21/08/2014	1500	118715
ANCHORPRINT GROUP LIMITED	N'Hood & Env. Health Services	Refuse Coll & Domestic Recyc	Publicity & Promotion	07/08/2014	299.68	118284
AQ DATA SERVICES	N'Hood & Env. Health Services	At. Poll. (Enforce & Mon)	Air Quality Analysis	15/08/2014	820	118735
ASSETT ADVANTAGE	Other	General Fund Balance Sheet	Creditors - Asset Leasing	28/08/2014	8234.19	119364
ASSOCIATION OF BUILDING ENGINEERS	N'Hood & Env. Health Services	Building Control Division	E'Es Subscriptions	15/08/2014	232	118738
ASSOCIATION OF BUILDING ENGINEERS	N'Hood & Env. Health Services	Building Control Division	E'Es Subscriptions	15/08/2014	252	118739
ASSOCIATION OF BUILDING ENGINEERS	N'Hood & Env. Health Services	Building Control Division	E'Es Subscriptions	15/08/2014	232	118740
BARLOW BLINDS LIMITED	Health Improvement & Leisure	The Pavilion	Equipment R & M	06/08/2014	758.74	118148


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