Type ForeignCompanyData
Type category Entity
Description Company intelligence data sourced from Toyo Keizai for Japanese-listed companies, providing a pivoted view of key operational attributes per company including executive details, contact information, employee statistics, market classification, and financial metrics.
Fields
Name Type Filters Description
key id string(36)* = The identifier that uniquely identifies each company data record. Represents the S&P Cap IQ Company ID as a string.
address string(4000) The street address of the company's registered office.
averageAgeOfEmployeesUnconsolidated decimal{5,2} The average age of employees in years on an unconsolidated basis.
averageAnnualIncomeOfEmployeesUnconsolidated long(0,2147483647) The average annual income of employees on an unconsolidated basis. Values are reported in actuals in the currency indicated by currencyCode.
link batch Batch* = The Batch for which this BatchRun is an instance.
link batchRun BatchRun* = The batchRun that provided the data.
buildingName string(4000) The name of the building where the company's registered office is located.
businessDescription string(4000) Textual description of the company's primary business activities and operations.
businessOffice string(4000) Information about the company's business offices including overseas count.
ceoName string(4000) Name of the Chief Executive Officer (CEO) of the company.
companyId long(-2147483648,2147483647)* The S&P Cap IQ Company ID for each company data record.
companyMainBank string(4000)[255] The primary banking institution(s) associated with the company. Each array element represents one bank.
currencyCode string(3) ISO 4217 three-letter currency code used to represent the currency.
establishmentDate date The date on which the company was officially established or incorporated.
link industryCode ForeignIndustryClassification Reference to the industry classification entity providing the English and Native industry name for the company.
isDeleted boolean* Indicates that this record has been logically deleted and should no longer be considered active.
lastModifiedDate dateTime* The date and time when this record was last updated or modified in the source system.
marketClassification string(4000) The descriptive market classification label for the exchange segment where the company is listed.
marketClassificationCode long(-2147483648,2147483647) The numeric code representing the market classification of the company. This field is part of an unpivoted classification structure and may map to multiple descriptive labels in the marketClassification field.
nameOfAuditFirm string(4000) The name of the audit firm responsible for auditing the company's financial statements.
nameOfUnderwritingSecuritiesCompanies string(4000)[255] The name(s) of underwriting securities companies associated with the company. Each array element represents one securities company.
nativeLanguage string(2) The ISO 639-1 language in which this record's text fields are stored.
numberOfEmployeesConsolidated long(0,2147483647) The total number of employees on a consolidated basis including subsidiaries. (Magnitude: actual)
numberOfEmployeesUnconsolidated long(0,2147483647) The total number of employees on an unconsolidated standalone company basis. (Magnitude: actual)
positionOfRepresentative string(4000) The title or position of the company's representative.
postalCode string(10) The postal code of the company's registered address.
telephoneNumber string(4000) The primary contact telephone number of the company.
27 rows of 27 total
API Open API Specification