Name: FSA Non-Current Asset Register
Creator: UK Government
License: http://reference.data.gov.uk/id/open-government-licence

About this Dataset

FSA Non-Current Asset Register

Details of the Non-Current Assets held on the FSA’s Statement of Financial Position.
Publisher name: Food Standards Agency
Last updated: 2022-07-01T04:05:59Z

Tables

FSA Non-Current Asset Register

@ukgov.fsa_non_current_asset_register.fsa_non_current_asset_register

22.77 kB
129 rows
26 columns

CREATE TABLE fsa_non_current_asset_register (
  "assetnumber" VARCHAR,
  "company" BIGINT,
  "costcentre" BIGINT,
  "majorcategory" VARCHAR,
  "minorcategory" VARCHAR,
  "lifeinmonths" BIGINT,
  "cost" DOUBLE,
  "accdepn" DOUBLE,
  "nbv" DOUBLE,
  "ytddepn" DOUBLE,
  "dateinservice" TIMESTAMP,
  "monthadded" TIMESTAMP,
  "assetccc" BIGINT,
  "bu" VARCHAR,
  "assetkey" VARCHAR,
  "flag1" VARCHAR,
  "flag2" VARCHAR,
  "flag3" VARCHAR,
  "assettag" VARCHAR,
  "serialnumber" VARCHAR,
  "contacttel" DOUBLE,
  "refc" VARCHAR,
  "checkedby" VARCHAR,
  "checkeddate" VARCHAR,
  "nbvcostcentre" VARCHAR,
  "additionalinformation" VARCHAR
);