Name: Council Printers
Creator: UK Government
License: http://reference.data.gov.uk/id/open-government-licence

About this Dataset

Council Printers

A list of Canon printers used at Leeds City Council.
Publisher name: Leeds City Council
Last updated: 2022-07-01T04:02:18Z

Tables

01/03/2018

@ukgov.council_printers.n_01_03_2018

50.84 KB
972 rows
15 columns


CREATE TABLE n_01_03_2018 (
  "contract_number" VARCHAR,
  "model" VARCHAR,
  "serial_num" VARCHAR,
  "installation_date" TIMESTAMP,
  "account_number" DOUBLE,
  "account_name" VARCHAR,
  "address1" VARCHAR,
  "address2" VARCHAR,
  "address3" VARCHAR,
  "postal_code" VARCHAR,
  "location" VARCHAR,
  "cust_ref" VARCHAR,
  "inv_amt_excl_vat" DOUBLE,
  "inv_amt_incl_vat" DOUBLE,
  "trx_type" VARCHAR
);

03/04/2019

@ukgov.council_printers.n_03_04_2019

50.79 KB
935 rows
22 columns


CREATE TABLE n_03_04_2019 (
  "contract_number" VARCHAR,
  "model" VARCHAR,
  "serial_num" VARCHAR,
  "installation_date" TIMESTAMP,
  "account_number" DOUBLE,
  "account_name" VARCHAR,
  "address1" VARCHAR,
  "address2" VARCHAR,
  "address3" VARCHAR,
  "postal_code" VARCHAR,
  "location" VARCHAR,
  "cust_ref" VARCHAR,
  "inv_amt_excl_vat" DOUBLE,
  "inv_amt_incl_vat" DOUBLE,
  "from_date" TIMESTAMP,
  "to_date" TIMESTAMP,
  "trx_type" VARCHAR,
  "unnamed_17" VARCHAR,
  "unnamed_18" VARCHAR,
  "unnamed_19" VARCHAR,
  "unnamed_20" VARCHAR,
  "unnamed_21" VARCHAR
);

19/12/2016

@ukgov.council_printers.n_19_12_2016

51.81 KB
65441 rows
20 columns


CREATE TABLE n_19_12_2016 (
  "contract_number" VARCHAR,
  "model" VARCHAR,
  "serial_num" VARCHAR,
  "installation_date" TIMESTAMP,
  "account_number" DOUBLE,
  "account_name" VARCHAR,
  "address1" VARCHAR,
  "address2" VARCHAR,
  "address3" VARCHAR,
  "postal_code" VARCHAR,
  "location" VARCHAR,
  "cust_ref" VARCHAR,
  "inv_amt_excl_vat" DOUBLE,
  "inv_amt_incl_vat" DOUBLE,
  "trx_type" VARCHAR,
  "unnamed_15" VARCHAR,
  "unnamed_16" VARCHAR,
  "unnamed_17" VARCHAR,
  "unnamed_18" VARCHAR,
  "unnamed_19" VARCHAR
);

24/11/2015

@ukgov.council_printers.n_24_11_2015

40.72 KB
909 rows
16 columns


CREATE TABLE n_24_11_2015 (
  "serial_num" VARCHAR,
  "model" VARCHAR,
  "account_number" DOUBLE,
  "address2" VARCHAR,
  "address3" VARCHAR,
  "postal_code" VARCHAR,
  "location" VARCHAR,
  "quarterly_invoice_amount_excluding_vat" DOUBLE,
  "quarterly_invoice_amount_including_vat" DOUBLE,
  "rental" VARCHAR,
  "add_on_1" VARCHAR,
  "add_on_2" VARCHAR,
  "add_on_3" VARCHAR,
  "add_on_4" VARCHAR,
  "installed" TIMESTAMP,
  "quarters" DOUBLE
);