UKAEA Transactions

department Department	entity Entity	pay_date Pay Date	product_family Product Family	expense_area Expense Area	supplier_name Supplier Name	transaction_number Transaction Number	net_amount Net Amount
BEIS	UKAEA	Wed May 03 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Engineering Goods	Fusion	BOC Ltd	5007811	£57.50
BEIS	UKAEA	Wed May 03 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Engineering Goods	Fusion	BOC Ltd	5007980	-£9,165.13
BEIS	UKAEA	Wed May 03 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Engineering Goods	Fusion	BOC Ltd	5007981	-£4,365.25
BEIS	UKAEA	Wed May 03 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Engineering Goods	Other	BOC Ltd	5008059	£41.10
BEIS	UKAEA	Wed May 03 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Engineering Goods	Property	BOC Ltd	5008273	£5.55
BEIS	UKAEA	Wed May 03 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Engineering Goods	Fusion	BOC Ltd	5008298	£1,057.40
BEIS	UKAEA	Wed May 03 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Engineering Goods	Fusion	BOC Ltd	5008321	£249.12
BEIS	UKAEA	Wed May 03 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Engineering Goods	Other	BOC Ltd	5008357	£17.25
BEIS	UKAEA	Wed May 03 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Engineering Goods	Other	BOC Ltd	5008358	£13.50
BEIS	UKAEA	Wed May 03 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Engineering Goods	Fusion	BOC Ltd	5008361	£101.22


CREATE TABLE ukaea_transactions (
  "department" VARCHAR,
  "entity" VARCHAR,
  "pay_date" TIMESTAMP,
  "product_family" VARCHAR,
  "expense_area" VARCHAR,
  "supplier_name" VARCHAR,
  "transaction_number" BIGINT,
  "net_amount" VARCHAR
);

Share link

Anyone who has the link will be able to view this.