Exporting Company data - Column definitions

Follow

The below table contains definitions for each of the columns present in a Company Data export (either from your watchlist or from the Prospector tool).

Please see this article for the definitions of the People data export.

 * Please note that the address supplied within this data is the entity's Registered address. We do not currently display both Registered and Trading addresses in these exports.

Column Definition
Registration Number Unique number assigned to the company by Companies House.
Company Name The Registered Company Name as filed at Companies House.
Company Address Line 1* The first company standard address line for the location.
Company Address Line 2* The second company standard address line for the location.
Company Address Line 3* The third company standard address line for the location.
Company Town* The company town for the location.
Company County* The company county for the location.
Company Region* The Company Geographical Region of the UK, derived from the Postcode, e.g. 'East Anglia', 'South West', etc.
Company Postcode* The Company Postcode for the location.
Company District* The Company Outer Postcode, containing the first half of the postcode, e.g. RG12
Company Mail Preference Service A TRUE/FLASE flag indicating whether the company is registered on the Mail Preference Service suppression file. 'TRUE' - Registered on MPS, 'FALSE' or empty - Not registered on MPS.
Company Full Telephone Number The full company telephone number, including dialling code that Thomson or Yell hold for the business.
Company Telephone Preference Service A TRUE/FALSE flag indicating whether the company is registered on the Telephone Preference Service suppression file. 'TRUE' - Registered on TPS, 'FALSE' or empty - Not registered on TPS.
Location Type Whether the location type is the 'HeadOffice', 'Branch', 'SingleSite', or 'None' location of a business.
Corporate Position Indicates the position of the business within the corporate tree, e.g. Independent, Ultimate Parent, Intermediate Parent, Subsidiary
Employee Count The number of employees for the business as a whole. Number could be an estimate.
Employee Count Estimated Is the Employee Count an estimate? TRUE or FALSE
Currency Code Currency that this set of accounts is displayed in.  Standard currency code as controlled by the International Organisation for Standardisation, e.g. GBP.
Turnover Value The Total Turnover value for the business over the accounting period, whether actual or an estimate.
Turnover Estimated Is the Turnover an estimate? TRUE or FALSE
Net Worth Value The Net Worth of the business is an indication of the company’s long-term solvency.  This field forms a check that the company’s Shareholders Funds exceed Intangible Assets, i.e. is the company considered to have covered net losses in the longer term? This can be an actual or an estimated value.
Net Worth Estimated Is the Net Worth an estimate? TRUE or FALSE
Pre Tax Profit Pre-Tax Profit/Loss is the net trading profit (or loss) after deduction of all operating expenses, but before the deduction of Tax or Dividends, whether actual or an estimate.
Pre Tax Profit Estimated Is the Pre-Tax Profit or Loss an estimate? TRUE or FALSE
Export Turnover The amount of turnover (from the total) derived from overseas trading (as opposed to trading within the UK).
Cash at Bank This is the book balance of the cash on hand, and any positive current account balance, at the Balance Sheet date.
Hire Purchase Current Hire Purchase (Current): The total amount of money tied up in Hire Purchase agreements. This figure appears in the Current Liabilities section of the Balance Sheet for monies covering the next 12 months.
Leasing Current Leasing (Current Liabilities): The total amount of money tied up in Leasing arrangements. This may include rented property and equipment. This figure appears in the Current Liabilities section of the Balance Sheet.
Current Liabilities Liabilities that have to be paid within the next 12 months.
Total HP And Leasing Long Term Hire Purchase & Leasing (Long Term Liabilities): The total amount of money tied up in Hire Purchase agreements. This figure appears in the in the Long Term Liabilities section for those items covering period for monies due after the next 12 months.
Fiscal Year End The last month of the year end for the company.
Latest Return Date The date of the latest Annual Return filed at Companies House. Format DD/MM/YYYY 00:00
Latest Accounts Date The date of the latest accounts filed at Companies House. Format DD/MM/YYYY 00:00
Cro Legal Status A textual description of the legal status of the business. See Legal Status Reference Table
Head Office Flag This denotes whether the registered address of the business is their sole location (Single Site) or if it is the headquarters of multiple trading locations.
Age Years The age, in years, of the business calculated from the earliest known date.
Auditors Name Auditor Name
Bank Name Bank Name
Delphi Score  The Experian commercial developed scorecard, scoring from 0-100, predicting the likelihood of business failure within the subsequent 12-month period. 100 equals no chance of business failure.
Delphi Credit Rating The Experian commercial recommended maximum monthly credit exposure for the business.
Delphi Credit Limit The Experian commercial recommended maximum outstanding credit exposure for the business.
Delphi Risk Band An indicator to determine the commercial risk band assigned to the business by Experian, e.g. Risk Score Suppressed, Dissolved/Serious Advers Info, Maximum Risk, High Risk, Abover Average Risk, Below Average Risk, Low Risk and Minimum Risk.
Delphi Star Rating The Experian Commercial Delphi Risk Band expressed as a 0-5 star rating. 5 is good.
1992 SIC Code 1 The 4-digit Standard Industry Classification (1992 version) for the business as a whole.
1992 SIC Code 1 Text The description attributed to the first listed SIC Code (1992 version) for the business.
1992 SIC Code 2 The 2nd listed 4-digit Standard Industry Classification (1992 version) for the business as a whole.
1992 SIC Code 2 Text The description attributed to the second listed SIC Code (1992 version) for the business.
1992 SIC Code 3 The 3rd listed 4-digit Standard Industry Classification (1992 version) for the business as a whole.
1992 SIC Code 3 Text The description attributed to the third listed SIC Code (1992 version) for the business.
1992 SIC Code 4 The 4th listed 4-digit Standard Industry Classification (1992 version) for the business as a whole.
1992 SIC Code 4 Text The description attributed to the fourth listed SIC Code (1992 version) for the business.
Broad Sectors 12 Experian defined business sectors derived from the businesses SIC 2007 Codes.
2007 SIC Code Group 1 First 3-digit Standard Industry Classification Group code and description (2007 version) for the business at all locations.
2007 SIC Code Group 2 Second 3-digit Standard Industry Classification Group code and description (2007 version) for the business at all locations.
2007 SIC Code Group 3 Third 3-digit Standard Industry Classification Group code and description (2007 version) for the business at all locations.
2007 SIC Code Group 4 Fourth 3-digit Standard Industry Classification Group code and description (2007 version) for the business at all locations.
2007 SIC Code 1 First Full Standard Industry Classification Code and description (2007 version) for the business at all locations.
2007 SIC Code 2 Second Full Standard Industry Classification Code and description (2007 version) for the business at all locations.
2007 SIC Code 3 Third Full Standard Industry Classification Code and description (2007 version) for the business at all locations.
2007 SIC Code 4 Fourth Full Standard Industry Classification Code and description (2007 version) for the business at all locations.
Principal Activity The principal activities of the business, as described on the annual accounts.
Care Homes Flag TRUE/FALSE Flag: is the business a care home?
Central Government Flag TRUE/FALSE Flag: is the business part of Central Government?
Charity Flag TRUE/FALSE Flag: Is the business a charity?
Defence Flag TRUE/FALSE Flag: Is the business part of the military?
Emergency Services Flag TRUE/FALSE Flag: is the business part of the Fire, Police or Ambulance services?
Hospitals Flag TRUE/FALSE Flag: is the business a hospital?
Local Government Flag TRUE/FALSE Flag: is the business part of local government?
Limited Companies TRUE/FALSE Flag: The business is a limited company.
Non Limited Business Flag TRUE/FALSE Flag: The business is a non-limited company.
Non Limited Group Flag TRUE/FALSE Flag: The business is a group of non-limited companies.
Public Services Flag TRUE/FALSE Flag: does the business provide a public service?
Schools Universities Flag TRUE/FALSE Flag: is the business a school or university?
Total Tangible Fixed Assets The total value of the company’s buildings, vehicles, equipment, fixtures and fittings. In general, assets held by the business for use in generating sales.
Total Stocks / Work In Progress The value of stock held by the company. This includes goods or other assets purchased for re-sale, consumable stores, raw materials, finished goods and payments on accounts for items yet to be received. When looking at Stock it is important to recognise that not all items are intended for re-sale, e.g. consumable stores, like oil for machines, are included but will never be sold; they simply assist in the running of the business, plus Work in process (WIP) is the value of a company's partially finished goods waiting for completion and eventual sale.
Trade Debtors The total amount of money owed to the company for sales rendered.
Total Long Term Liabilities Liabilities that have to be paid further than the next 12 months.
Plant & Vehicles The total value of plant and vehicle equipment owned by the company.
Current Ratio The worth of a company derived as Current Assets divided by Current Liabilities. This ratio roughly measures a company’s financial risk. Logically the more the financial liabilities, the riskier the company. Thus, small Current Ratio values indicate high risk. Less than 1 is possibly a problem, around 2 is ideal, too big may be a sign of inefficiency.
Acid Test The Acid Test is a measure of the company’s liquidity and is derived by deducting Stocks and Work In Progress from Current Assets. This figure is then divided by Current Liabilities. This approach is cautious as it recognises that stock is not always readily converted into cash at full value. An Acid test ratio of 0.75:1 or greater is preferred.
Working Capital By Sales Percentage of annualised Turnover against Working Capital. Demonstrates the surplus or deficit of funds from normal trading activities, in relation to the company’s size measured by sales. Calculation: 100 * Working Capital / (52 * Total Turnover / Accounting Period).
Credit Period Also known as Collection Period, measures the days a company takes to pay its debts, therefore assessing the effectiveness of the company’s credit control department. Calculation: 365 * Total Debtors / (52 * Total Turnover / Accounting Period)
Trade Creditors By Debtors Ratio The ratio of trade creditors to trade debtors. Calculation: Trade Creditors / Total Debtors.
Auditor Fees Auditor Fees is the Amount that the auditor was paid.
Growth Indicator An indicator to determine whether the business is in growth or decline. Values can be Decline, Growth, Static or Unknown.
Mortgage Indicator A Yes/No flag indicating the presence of a mortgage registered against the company, e.g. 'Y' - Mortgage registered against limited company'N' - No mortgage registered or non-limited business.
Domain The website we have on record for the company.
Have more questions? Submit a request