| key |
id |
string(500)* |
= |
The id field uniquely identifies the entity record. It's equivalent to the ciqCompanyId |
| timeline |
updDate |
dateTime* |
=< >= |
Last modification date and time |
|
activityCode |
string(50) |
|
Vendor Industry Code |
|
address1 |
string(500) |
|
Line 1 of the companies registered address. Typically street name and number. |
|
address2 |
string(500) |
|
Line 2 of the companies registered address. Usually optional |
|
address3 |
string(500) |
|
Line 3 of the companies registered address. Usually optional |
|
address4 |
string(500) |
|
Line 5 of the companies registered address; this is typically region, province, county or state. |
|
annualSales |
decimal{18,2} |
|
Latest Turnover Value |
| link |
batch |
Batch |
= |
The Batch for which this BatchRun is an instance. |
| link |
batchRun |
BatchRun |
= |
The BatchRun in which the Price is calculated. |
|
changeDate |
date |
|
Date of the last known change of the company |
|
ciqCompanyId |
long |
|
CIQ Identifier for a company |
|
ciqIndustryName |
string(2000) |
|
Legacy CIQ industry and GICS industry classifications |
|
city |
string(100) |
|
Line 4 of the companies registered address; The town of the company. |
| filter_list |
country |
string(2) |
=timeline |
The country or territory of the registered company. |
|
description |
string(8000) |
|
Business description for the private company |
|
email |
string(500) |
|
Known contact Email address for the Company |
| filter_list |
employees |
long |
=< >= |
Number of employees recorded working at the company |
|
formerName1 |
string(2000) |
|
The previous name of the company |
|
formerName2 |
string(2000) |
|
The Name before Previous Name of the company |
|
incorporationDate |
date |
|
Date of the Incorporation of the Company |
|
isConsolidatedAccounts |
boolean |
|
Whether the Group files consolidated financials i.e. 1=Yes, 0=No |
|
keyInstn |
long |
|
CIQ Pro Identifier for a company |
|
latestAccounts |
date |
|
Last Accounts Filed Date |
|
legalForm |
string(8000) |
|
Outlines the type of legal entity the company is registered as at the local registry |
| filter_list |
longName |
string(2000) |
= |
The registered name of the company |
| filter_list |
miIndustryName |
string(2000) |
= |
Legacy MI Industry Classification |
|
officeType |
long |
|
Indicates that a company is headquarter, branch or other i.e. 1=headquarter, 2=branch,3=otherĀ |
|
orgNumber |
string(100) |
|
Local Unique Identifier (Companies House ID; KvK; Chamber Of Commerce; etc.) |
|
phone |
string(80) |
|
Known contact phone number for the Company |
|
postalCode |
string(50) |
|
Postal/Zip code of the companies registered address |
|
province |
string(8000) |
|
Geographic Region, if relevant to local address custom. |
|
registryNumber |
string(100) |
|
Local Unique Identifier (Companies House ID; KvK; Chamber of Commerce; etc) Differs from ORG_NUMBER by not including Branch ID where applicable |
|
registryType |
long |
|
Registration type (0=limited, 1=non-limited) |
|
shareCapital |
decimal{18,2} |
|
Companies Share capital value |
|
shortName |
string(2000) |
|
An alternative name a company may be known as |
| filter_list |
status |
long |
= |
Indicator of companies generalized status, 1 is Active, 2 is Inactive |
|
tradingName |
string(2000) |
|
The name a company trades under, if different to its registered name |
|
turnoverBand |
string(200) |
|
Estimated Banding that the company turnover falls in (e.g. 5,000 to 50,000) if turnover not known as an exact value |
|
updOperation |
long |
|
Indicates whether the row is new, updated, or (logically) deleted i.e. 0=new, 1=updated, 2=deleted |
|
vatNumber |
string(100) |
|
VAT Number for the company (Tax Code) |
|
vendorId |
string(50) |
|
Vendor identifier |
|
webUrl |
string(500) |
|
Known website URL for the Company |