| key |
id |
string(100)* |
= |
The id field uniquely identifies the entity record. |
| timeline |
updDate |
dateTime* |
=< >= |
Last modification date and time of a physical row |
|
accessionNumber |
string |
|
A unique SEC or SEDAR identifier that identifies a document |
|
accountsReceivableTurnover |
decimal{34,6} |
|
Shows how efficiently a company collects payments from its customers. Calculated as net credit sales divided by average accounts receivable. |
|
accountsReceivableTurnoverCurrencyISO |
string(3) |
|
Currency ISO code for Accounts Receivable Turnover |
|
amendmentFlag |
long |
|
Indicates that this instance reflects an amendment filing |
|
avgCashConversionCycle |
decimal{34,6} |
|
The time it takes for a company to convert its investments in inventory and other resources into cash from sales. Calculated as DIO + DSO - DPO. |
|
avgCashConversionCycleCurrencyISO |
string(3) |
|
Currency ISO code for Avg Cash Conversion Cycle |
|
avgDaysInventoryOutstanding |
decimal{34,6} |
|
The average number of days it takes a company to sell its inventory. |
|
avgDaysInventoryOutstandingCurrencyISO |
string(3) |
|
Currency ISO code for Avg Days Inventory Outstanding |
|
avgDaysPayableOutstanding |
decimal{34,6} |
|
The average number of days it takes a company to pay its suppliers after receiving goods or services. |
|
avgDaysPayableOutstandingCurrencyISO |
string(3) |
|
Currency ISO code for Avg Days Payable Outstanding |
|
avgDaysSalesOutstanding |
decimal{34,6} |
|
The average number of days it takes a company to collect payment from customers after making a sale. |
|
avgDaysSalesOutstandingCurrencyISO |
string(3) |
|
Currency ISO code for Avg Days Sales Outstanding |
| link |
bsRestatementType |
FinancialRestatementType |
|
The TypeId identifying the restatement type for the balance sheet (e.g. Press Release, Original, Restated) |
|
bsRestatementTypeId |
long(-2147483648,2147483647) |
|
The TypeId identifying the restatement type for the balance sheet (e.g. Press Release, Original, Restated) |
|
calendarQuarter |
long |
|
The calendar quarter of the audit |
|
calendarYear |
long |
|
The calendar year of the audit |
|
capitalExpenditure |
decimal{34,6} |
|
Money spent by a company to buy, maintain, or improve its long-term assets like buildings or machinery. |
|
capitalExpenditureCurrencyISO |
string(3) |
|
Currency ISO code for Capital Expenditure |
|
cashFromFinancing |
decimal{34,6} |
|
Cash a company receives from raising capital (like issuing stock or debt) or pays out (like repaying debt). |
|
cashFromFinancingCurrencyISO |
string(3) |
|
Currency ISO code for Cash from Financing |
|
cashFromInvesting |
decimal{34,6} |
|
Cash used for or earned from investments in things like buying or selling assets, or acquiring businesses. |
|
cashFromInvestingCurrencyISO |
string(3) |
|
Currency ISO code for Cash from Investing |
|
cashFromOperations |
decimal{34,6} |
|
The cash a company generates from its normal business operations, like selling goods or services. |
|
cashFromOperationsCurrencyISO |
string(3) |
|
Currency ISO code for Cash from Ops |
|
cashFromOperationsToCurrentLiabilities |
decimal{34,6} |
|
Measures how well a company can cover its current liabilities with the cash it generates from operations. |
|
cashFromOperationsToCurrentLiabilitiesCurrencyISO |
string(3) |
|
Currency ISO code for Cash from Operaions to Current Liabilities |
| link |
cfRestatementType |
FinancialRestatementType |
|
The TypeId identifying the restatement type for the statement of cash flow (e.g. Press Release, Original, Restated) |
|
cfRestatementTypeId |
long(-2147483648,2147483647) |
|
The TypeId identifying the restatement type for the statement of cash flow (e.g. Press Release, Original, Restated) |
|
changeInNetWorkingCapital |
decimal{34,6} |
|
The change in a company's current assets minus current liabilities, showing how much short-term liquidity changed. |
|
changeInNetWorkingCapitalCurrencyISO |
string(3) |
|
Currency ISO code for Change in Net Working Capital |
| filter_list |
ciqCompanyId |
long |
= |
Unique identifier denoting a company |
|
commonDividendsPaid |
decimal{34,6} |
|
The amount of money paid to common shareholders as dividends. |
|
commonDividendsPaidCurrencyISO |
string(3) |
|
Currency ISO code for Common Dividends Paid |
|
currencyConversionPeriodEndDate |
date |
|
The date of the currency exchange rate used for conversions |
|
currentPortionOfLeases |
decimal{34,6} |
|
The portion of lease obligations that must be paid within the next year. |
|
currentPortionOfLeasesCurrencyISO |
string(3) |
|
Currency ISO code for Current Portion of Leases |
|
currentPortionOfLongTermDebt |
decimal{34,6} |
|
The portion of long-term debt that needs to be repaid within the next year. |
|
currentPortionOfLongTermDebtCurrencyISO |
string(3) |
|
Currency ISO code for Current Portion of LT Debt |
|
currentPortionOfLongTermDebtToCapitalLeases |
decimal{34,6} |
|
The portion of long-term debt or capital lease obligations that must be repaid within the next year. |
|
currentPortionOfLongTermDebtToCapitalLeasesCurrencyISO |
string(3) |
|
Currency ISO code for Current Portion of LT Debt/Capital Leases |
|
currentRatio |
decimal{34,6} |
|
Measures a company's ability to pay short-term obligations with its short-term assets. Calculated as current assets divided by current liabilities. |
|
currentRatioCurrencyISO |
string(3) |
|
Currency ISO code for Current Ratio |
|
depreciationAndAmortizationTotal |
decimal{34,6} |
|
The reduction in value of physical assets (depreciation) and intangible assets (amortization) over time. |
|
depreciationAndAmortizationTotalCurrencyISO |
string(3) |
|
Currency ISO code for Depreciation & Amortization Total |
|
dilutedEPSBeforeExtra1YearGrowthRate |
decimal{34,6} |
|
The percentage change in diluted earnings per share (EPS) before extraordinary items over one year, showing the change in per-share profit, excluding one-time events. |
|
dilutedEPSBeforeExtra1YearGrowthRateCurrencyISO |
string(3) |
|
Currency ISO code for Diluted EPS before Extra 1 Yr GR |
|
dilutedEPSBeforeExtra2YearCAGR |
decimal{34,6} |
|
The average annual growth rate of diluted earnings per share (EPS) before extraordinary items over two years, showing the change in per-share profit, excluding one-time events. |
|
dilutedEPSBeforeExtra2YearCAGRCurrencyISO |
string(3) |
|
Currency ISO code for Diluted EPS before Extra 2 Yr CAGR |
|
dilutedEPSBeforeExtra3YearCAGR |
decimal{34,6} |
|
The average annual growth rate of diluted earnings per share (EPS) before extraordinary items over three years, showing the change in per-share profit, excluding one-time events. |
|
dilutedEPSBeforeExtra3YearCAGRCurrencyISO |
string(3) |
|
Currency ISO code for Diluted EPS before Extra 3 Yr CAGR |
|
dilutedEPSBeforeExtra5YearCAGR |
decimal{34,6} |
|
The average annual growth rate of diluted earnings per share (EPS) before extraordinary items over five years, showing the change in per-share profit, excluding one-time events. |
|
dilutedEPSBeforeExtra5YearCAGRCurrencyISO |
string(3) |
|
Currency ISO code for Diluted EPS before Extra 5 Yr CAGR |
|
dilutedEPSExcludingExtraItems |
decimal{34,6} |
|
Earnings per share available to each share of common stock, excluding one-time or unusual items. |
|
dilutedEPSExcludingExtraItemsCurrencyISO |
string(3) |
|
Currency ISO code for Diluted EPS |
|
documentDetailsId |
long |
|
Unique identifier for a combination of documentID and PEO date |
|
documentId |
string |
|
A unique CIQ identifier that identifies the source document used for this update |
| filter_list |
documentPeriod |
date |
= |
The period date of the financial report |
|
documentType |
long |
|
documentType |
|
earningsFromContinuingOperation |
decimal{34,6} |
|
Profit from regular, ongoing business activities, excluding sold or shut down parts of the business. |
|
earningsFromContinuingOperationCurrencyISO |
string(3) |
|
Currency ISO code for Earnings from Cont Ops |
|
earningsFromContinuingOperations1YearGrowthRate |
decimal{34,6} |
|
The percentage change in earnings from continuing operations over one year, showing how the company's ongoing operations have performed. |
|
earningsFromContinuingOperations1YearGrowthRateCurrencyISO |
string(3) |
|
Currency ISO code for Earnings from Continuing Ops 1 Yr GR |
|
earningsFromContinuingOperations2YearCAGR |
decimal{34,6} |
|
The average annual growth rate of earnings from continuing operations over two years, showing the performance of a company's ongoing operations. |
|
earningsFromContinuingOperations2YearCAGRCurrencyISO |
string(3) |
|
Currency ISO code for Earnings from Continuing Ops 2 Yr CAGR |
|
earningsFromContinuingOperations3YearCAGR |
decimal{34,6} |
|
The average annual growth rate of earnings from continuing operations over three years, showing the performance of a company's ongoing operations. |
|
earningsFromContinuingOperations3YearCAGRCurrencyISO |
string(3) |
|
Currency ISO code for Earnings from Continuing Ops 3 Yr CAGR |
|
earningsFromContinuingOperations5YearCAGR |
decimal{34,6} |
|
The average annual growth rate of earnings from continuing operations over five years, showing the performance of a company's ongoing operations. |
|
earningsFromContinuingOperations5YearCAGRCurrencyISO |
string(3) |
|
Currency ISO code for Earnings from Continuing Ops 5 Yr CAGR |
|
earningsFromContinuingOperationsMargin |
decimal{34,6} |
|
The percentage of revenue that comes from the company's ongoing, regular operations. Excludes income from discontinued operations or extraordinary items. |
|
earningsFromContinuingOperationsMarginCurrencyISO |
string(3) |
|
Currency ISO code for Earnings from Continuing Ops Margin |
|
ebit |
decimal{34,6} |
|
Profit before interest and taxes; used to assess operational efficiency. |
|
ebit1YearGrowthRate |
decimal{34,6} |
|
The percentage change in EBIT (earnings before interest and taxes) over one year, indicating how operating income has grown or shrunk. |
|
ebit1YearGrowthRateCurrencyISO |
string(3) |
|
Currency ISO code for EBIT 1 Yr GR |
|
ebit2YearCAGR |
decimal{34,6} |
|
The average annual growth rate of EBIT (earnings before interest and taxes) over two years, reflecting growth in operating income. |
|
ebit2YearCAGRCurrencyISO |
string(3) |
|
Currency ISO code for EBIT 2 Yr CAGR |
|
ebit3YearCAGR |
decimal{34,6} |
|
The average annual growth rate of EBIT (earnings before interest and taxes) over three years, reflecting growth in operating income. |
|
ebit3YearCAGRCurrencyISO |
string(3) |
|
Currency ISO code for EBIT 3 Yr CAGR |
|
ebit5YearCAGR |
decimal{34,6} |
|
The average annual growth rate of EBIT (earnings before interest and taxes) over five years, reflecting growth in operating income. |
|
ebit5YearCAGRCurrencyISO |
string(3) |
|
Currency ISO code for EBIT 5 Yr CAGR |
|
ebitCurrencyISO |
string(3) |
|
Currency ISO code for EBIT |
|
ebitMargin |
decimal{34,6} |
|
The percentage of revenue left after covering operating costs, excluding interest and taxes. It measures operating efficiency. |
|
ebitMarginCurrencyISO |
string(3) |
|
Currency ISO code for EBIT Margin |
|
ebita |
decimal{34,6} |
|
Profit before interest, taxes, and amortization; similar to EBITDA but without depreciation included. |
|
ebita1YearGrowthRate |
decimal{34,6} |
|
The percentage change in EBITA (earnings before interest, taxes, and amortization) over one year, showing how core operating profits have changed. |
|
ebita1YearGrowthRateCurrencyISO |
string(3) |
|
Currency ISO code for EBITA 1 Yr GR |
|
ebita2YearCAGR |
decimal{34,6} |
|
The average annual growth rate of EBITA (earnings before interest, taxes, and amortization) over two years, indicating changes in core operating profitability. |
|
ebita2YearCAGRCurrencyISO |
string(3) |
|
Currency ISO code for EBITA 2 Yr CAGR |
|
ebita3YearCAGR |
decimal{34,6} |
|
The average annual growth rate of EBITA (earnings before interest, taxes, and amortization) over three years, indicating changes in core operating profitability. |
|
ebita3YearCAGRCurrencyISO |
string(3) |
|
Currency ISO code for EBITA 3 Yr CAGR |
|
ebita5YearCAGR |
decimal{34,6} |
|
The average annual growth rate of EBITA (earnings before interest, taxes, and amortization) over five years, indicating changes in core operating profitability. |
|
ebita5YearCAGRCurrencyISO |
string(3) |
|
Currency ISO code for EBITA 5 Yr CAGR |
|
ebitaCurrencyISO |
string(3) |
|
Currency ISO code for EBITA |
|
ebitaMargin |
decimal{34,6} |
|
The percentage of revenue left after covering operating costs but excluding interest, taxes, and amortization. Similar to EBITDA but without depreciation. |
|
ebitaMarginCurrencyISO |
string(3) |
|
Currency ISO code for EBITA Margin |
|
ebitda |
decimal{34,6} |
|
Profit before interest, taxes, depreciation, and amortization; a measure of operating performance. |
|
ebitda1YearGrowthRate |
decimal{34,6} |
|
The percentage change in EBITDA (earnings before interest, taxes, depreciation, and amortization) over one year, reflecting changes in operational profitability. |
|
ebitda1YearGrowthRateCurrencyISO |
string(3) |
|
Currency ISO code for EBITDA 1 Yr GR |
|
ebitda2YearCAGR |
decimal{34,6} |
|
The average annual growth rate of EBITDA (earnings before interest, taxes, depreciation, and amortization) over two years, showing operational profit growth. |
|
ebitda2YearCAGRCurrencyISO |
string(3) |
|
Currency ISO code for EBITDA 2 Yr CAGR |
|
ebitda3YearCAGR |
decimal{34,6} |
|
The average annual growth rate of EBITDA (earnings before interest, taxes, depreciation, and amortization) over three years, showing operational profit growth. |
|
ebitda3YearCAGRCurrencyISO |
string(3) |
|
Currency ISO code for EBITDA 3 Yr CAGR |
|
ebitda5YearCAGR |
decimal{34,6} |
|
The average annual growth rate of EBITDA (earnings before interest, taxes, depreciation, and amortization) over five years, showing operational profit growth. |
|
ebitda5YearCAGRCurrencyISO |
string(3) |
|
Currency ISO code for EBITDA 5 Yr CAGR |
|
ebitdaCurrencyISO |
string(3) |
|
Currency ISO code for EBITDA |
|
ebitdaMargin |
decimal{34,6} |
|
The percentage of revenue left after covering operational costs, excluding interest, taxes, depreciation, and amortization. It shows a company's operating profitability. |
|
ebitdaMarginCurrencyISO |
string(3) |
|
Currency ISO code for EBITDA Margin |
|
ebitdar |
decimal{34,6} |
|
Profit before interest, taxes, depreciation, amortization, and rent expenses; used in industries with large rent costs. |
|
ebitdarCurrencyISO |
string(3) |
|
Currency ISO code for EBITDAR |
|
ebtExclUnusualItems |
decimal{34,6} |
|
Profit before taxes, excluding one-time or unusual events. |
|
ebtExclUnusualItemsCurrencyISO |
string(3) |
|
Currency ISO code for EBT Excl Unusal Items |
|
ebtInclUnusualItems |
decimal{34,6} |
|
Profit before taxes, including one-time or unusual events. |
|
ebtInclUnusualItemsCurrencyISO |
string(3) |
|
Currency ISO code for EBT Incl Unusual Items |
|
effectiveTaxRate |
decimal{34,6} |
|
The percentage of earnings that a company pays in taxes, calculated as tax expenses divided by pre-tax earnings. |
|
effectiveTaxRateCurrencyISO |
string(3) |
|
Currency ISO code for Effective Tax Rate |
|
filingDate |
dateTime |
|
Date the source document was filed |
| link |
financialDataSet |
FinancialDataSetType |
|
Source of Data representing inhouse collection, vendor data etc., |
|
financialDataSetId |
long(-2147483648,2147483647) |
|
Source of Data representing inhouse collection, vendor data etc., |
| filter_list |
financialInstanceId |
long* |
= |
Denotes whether a period is a quarter, annual, semi-annual, LTM, or YTD |
|
financialPeriodId |
long |
|
The unique identifier for a company-to-reporting period relationship |
|
fiscalChainSeriesId |
long |
|
The fiscal chain series is used to flag fiscal year changes. The value increments each time a fiscal year change occurs. |
| filter_list |
fiscalQuarter |
long |
= |
The fiscal quarter for this financial period |
| filter_list |
fiscalYear |
long |
= |
The fiscal year for this financial period |
|
fixedAssetTurnover |
decimal{34,6} |
|
Measures how efficiently a company uses its fixed assets (like buildings and equipment) to generate sales. |
|
fixedAssetTurnoverCurrencyISO |
string(3) |
|
Currency ISO code for Fixed Asset Turnover |
|
fixedRateDebt |
decimal{34,6} |
|
Debt with a fixed interest rate that does not change over the life of the loan. |
|
fixedRateDebtCurrencyISO |
string(3) |
|
Currency ISO code for Fixed Rate Debt |
|
formTypeId |
long |
|
The Type Id identifying the from type (1 = Annual; 2= Other than Annual) |
|
formTypeText |
string |
|
The Type Id identifying the from type (1 = Annual; 2= Other than Annual) |
|
fullTimeEmployees |
decimal{34,6} |
|
The number of people working for the company on a full-time basis. |
|
fullTimeEmployeesCurrencyISO |
string(3) |
|
Currency ISO code for Full Time Employees |
|
grossMargin |
decimal{34,6} |
|
The percentage of revenue that exceeds the cost of goods sold. It indicates how much profit is made after covering production costs. |
|
grossMarginCurrencyISO |
string(3) |
|
Currency ISO code for Gross Margin |
|
grossProfit |
decimal{34,6} |
|
The money left after subtracting the cost of making or buying the products sold by the company. |
|
grossProfit1YearGrowthRate |
decimal{34,6} |
|
The percentage change in gross profit (revenue minus cost of goods sold) over one year, indicating how efficiently the company is managing its costs. |
|
grossProfit1YearGrowthRateCurrencyISO |
string(3) |
|
Currency ISO code for Gross Profit 1 Yr GR |
|
grossProfit2YearCAGR |
decimal{34,6} |
|
The average annual growth rate of gross profit (revenue minus cost of goods sold) over two years, indicating efficiency changes in managing costs. |
|
grossProfit2YearCAGRCurrencyISO |
string(3) |
|
Currency ISO code for Gross Profit 2 Yr CAGR |
|
grossProfit3YearCAGR |
decimal{34,6} |
|
The average annual growth rate of gross profit (revenue minus cost of goods sold) over three years, indicating efficiency changes in managing costs. |
|
grossProfit3YearCAGRCurrencyISO |
string(3) |
|
Currency ISO code for Gross Profit 3 Yr CAGR |
|
grossProfit5YearCAGR |
decimal{34,6} |
|
The average annual growth rate of gross profit (revenue minus cost of goods sold) over five years, indicating efficiency changes in managing costs. |
|
grossProfit5YearCAGRCurrencyISO |
string(3) |
|
Currency ISO code for Gross Profit 5 Yr CAGR |
|
grossProfitCurrencyISO |
string(3) |
|
Currency ISO code for Gross Profit |
|
hasConsolidatedFinancialsFlag |
long |
|
hasConsolidatedFinancialsFlag |
|
hasUnConsolidatedFinancialsFlag |
long |
|
hasUnConsolidatedFinancialsFlag |
|
incomeTaxExpense |
decimal{34,6} |
|
The amount a company pays in taxes on its earnings. |
|
incomeTaxExpenseCurrencyISO |
string(3) |
|
Currency ISO code for Income Tax Expense |
| link |
instanceType |
FinancialInstanceType |
|
The TypeId identifying the instance type (e.g. Press Release, Original Instance, Encore) |
|
instanceTypeId |
long(-2147483648,2147483647) |
|
The TypeId identifying the instance type (e.g. Press Release, Original Instance, Encore) |
|
inventoryTurnover |
decimal{34,6} |
|
Indicates how efficiently a company sells and replaces its inventory. Calculated as cost of goods sold divided by average inventory. |
|
inventoryTurnoverCurrencyISO |
string(3) |
|
Currency ISO code for Inventory Turnover |
| link |
isRestatementType |
FinancialRestatementType |
|
The TypeId identifying the restatement type for the income statement (e.g. Press Release, Original, Restated) |
|
isRestatementTypeId |
long(-2147483648,2147483647) |
|
The TypeId identifying the restatement type for the income statement (e.g. Press Release, Original, Restated) |
|
issuanceOfCommonStock |
decimal{34,6} |
|
The money a company receives from selling new shares of common stock. |
|
issuanceOfCommonStockCurrencyISO |
string(3) |
|
Currency ISO code for Issuance of Common Stock |
|
latestFilingForInstanceFlag |
long |
|
The latestFilingForInstanceFlag is used when there are multiple records in the ciqFinInstance table that have the same financialPeriodId and the same filingDate.This would occur, for example, when a company filed its press release and its 10-Q on the same day. The latestFilingForInstanceFlag flag shows you the 'best' instance to use if you are trying to select between these two instances. |
|
latestForFinancialPeriodFlag |
long |
|
A flag indicating that this instance is the latest one for the financial period. If there are multiple instances, 1=the latest filing that exists for the financial period and 0= other instances. The instanceTypeId=4 (Backward column of a press release) are excluded from consideration if instanceTypeIds of 2 or 3 exist (Original Instance or Encore) for that financial period, as this would be replacing a complete source (e.g., an SEC filing) with an incomplete source (e.g., a press release). To view the latest and best source for a company, always screen for latestForFinancialPeriodFlag=1. |
|
latestUnConsolidatedInstanceForFilingDateFlag |
long |
|
The latestFilingForInstanceFlag is used when there are multiple records in the ciqFinInstance table that have the same financialPeriodId and the same filingDate.This would occur, for example, when a company filed its press release and its 10-Q on the same day. The latestFilingForInstanceFlag flag shows you the 'best' instance to use if you are trying to select between these two instances. |
|
latestUnConsolidatedInstanceForPeriodFlag |
long |
|
A flag indicating that this instance is the latest one for the financial period. If there are multiple instances, 1=the latest filing that exists for the financial period and 0= other instances. The instanceTypeId=4 (Backward column of a press release) are excluded from consideration if instanceTypeIds of 2 or 3 exist (Original Instance or Encore) for that financial period, as this would be replacing a complete source (e.g., an SEC filing) with an incomplete source (e.g., a press release). To view the latest and best source for a company, always screen for latestForFinancialPeriodFlag=1. |
|
leveredFreeCashFlowMargin |
decimal{34,6} |
|
The percentage of revenue left as free cash flow after interest payments have been made on the company's debt. |
|
leveredFreeCashFlowMarginCurrencyISO |
string(3) |
|
Currency ISO code for Levered Free Cash Flow Margin |
|
longTermDebt |
decimal{34,6} |
|
The amount of debt that the company owes that doesn't need to be repaid within one year. |
|
longTermDebtCurrencyISO |
string(3) |
|
Currency ISO code for Long Term Debt |
|
longTermDebtIncludingCapitalizedLeases |
decimal{34,6} |
|
The total value of debt and capital lease obligations that are due beyond one year. |
|
longTermDebtIncludingCapitalizedLeasesCurrencyISO |
string(3) |
|
Currency ISO code for Long Term Debt (Incl. Cap. Leases) |
|
longTermDebtIssued |
decimal{34,6} |
|
The amount of new long-term debt (due after one year) that a company has borrowed. |
|
longTermDebtIssuedCurrencyISO |
string(3) |
|
Currency ISO code for Long Term Debt Issued |
|
longTermDebtToCapital |
decimal{34,6} |
|
A ratio comparing long-term debt to total capital (debt + equity), showing how much of a company's capital comes from long-term debt. |
|
longTermDebtToCapitalCurrencyISO |
string(3) |
|
Currency ISO code for LT Debt/Capital |
|
longTermDebtToEquity |
decimal{34,6} |
|
A ratio that compares a company's long-term debt to its shareholders' equity, showing the balance of long-term debt financing. |
|
longTermDebtToEquityCurrencyISO |
string(3) |
|
Currency ISO code for LT Debt/Equity |
|
netChangeInCash |
decimal{34,6} |
|
The overall increase or decrease in the company's cash balance during a period. |
|
netChangeInCashCurrencyISO |
string(3) |
|
Currency ISO code for Net Change in Cash |
|
netDebt |
decimal{34,6} |
|
The total amount of a company's debt after subtracting its cash and short-term investments. |
|
netDebtCurrencyISO |
string(3) |
|
Currency ISO code for Net Debt |
|
netDebtIssued |
decimal{34,6} |
|
The total amount of new debt issued minus the amount of debt repaid during the period. |
|
netDebtIssuedCurrencyISO |
string(3) |
|
Currency ISO code for Net Debt Issued |
|
netDebtToEBITDALessCapex |
decimal{34,6} |
|
A measure of how many years it would take to pay off net debt using earnings before interest, taxes, depreciation, and amortization minus capital expenditures. |
|
netDebtToEBITDALessCapexCurrencyISO |
string(3) |
|
Currency ISO code for Net Debt/(EBITDA-CAPEX) |
|
netDebtToEbitda |
decimal{34,6} |
|
A ratio that shows how many years it would take to pay off all net debt using the company's earnings before interest, taxes, depreciation, and amortization. |
|
netDebtToEbitdaCurrencyISO |
string(3) |
|
Currency ISO code for Net Debt/EBITDA |
|
netIncome |
decimal{34,6} |
|
The total profit after all expenses are paid. |
|
netIncome1YearGrowthRate |
decimal{34,6} |
|
The percentage change in net income over one year, reflecting the overall change in profitability after all expenses, interest, and taxes. |
|
netIncome1YearGrowthRateCurrencyISO |
string(3) |
|
Currency ISO code for Net Income 1 Yr GR |
|
netIncome2YearCAGR |
decimal{34,6} |
|
The average annual growth rate of net income over two years, reflecting changes in overall profitability after expenses, interest, and taxes. |
|
netIncome2YearCAGRCurrencyISO |
string(3) |
|
Currency ISO code for Net Income 2 Yr CAGR |
|
netIncome3YearCAGR |
decimal{34,6} |
|
The average annual growth rate of net income over three years, reflecting changes in overall profitability after expenses, interest, and taxes. |
|
netIncome3YearCAGRCurrencyISO |
string(3) |
|
Currency ISO code for Net Income 3 Yr CAGR |
|
netIncome5YearCAGR |
decimal{34,6} |
|
The average annual growth rate of net income over five years, reflecting changes in overall profitability after expenses, interest, and taxes. |
|
netIncome5YearCAGRCurrencyISO |
string(3) |
|
Currency ISO code for Net Income 5 Yr CAGR |
|
netIncomeAvailableForCommonMargin |
decimal{34,6} |
|
The percentage of revenue left as profit available specifically for common shareholders after all expenses, taxes, and interest. |
|
netIncomeAvailableForCommonMarginCurrencyISO |
string(3) |
|
Currency ISO code for Net Income Available for Common Margin |
|
netIncomeCurrencyISO |
string(3) |
|
Currency ISO code for Net Income |
|
netIncomeMargin |
decimal{34,6} |
|
The percentage of revenue that remains as profit after all expenses, taxes, and interest have been deducted. |
|
netIncomeMarginCurrencyISO |
string(3) |
|
Currency ISO code for Net Income Margin |
|
netIncomeToCommonExcludingExtraItems |
decimal{34,6} |
|
Net income attributable to common shareholders, excluding one-time or unusual items. |
|
netIncomeToCommonExcludingExtraItemsCurrencyISO |
string(3) |
|
Currency ISO code for NI to Common Excl |
|
netIncomeToCommonIncludingExtraItems |
decimal{34,6} |
|
Net income attributable to common shareholders, including one-time or unusual items. |
|
netIncomeToCommonIncludingExtraItemsCurrencyISO |
string(3) |
|
Currency ISO code for NI to Common Incl |
|
netIncomeToCompany |
decimal{34,6} |
|
The total profit left after all expenses, interest, and taxes are subtracted; also known as the "bottom line." |
|
netIncomeToCompanyCurrencyISO |
string(3) |
|
Currency ISO code for Net Income to Company |
|
netInterestExpense |
decimal{34,6} |
|
The cost of borrowing money (interest paid minus interest earned). |
|
netInterestExpenseCurrencyISO |
string(3) |
|
Currency ISO code for Net Interest Expense |
|
netPropertyPlantAndEquipment |
decimal{34,6} |
|
The value of a company's long-term assets, such as buildings, machinery, and equipment, minus depreciation. |
|
netPropertyPlantAndEquipmentCurrencyISO |
string(3) |
|
Currency ISO code for Net Property, Plant & Equipment |
|
nonStandardLengthFlag |
long* |
|
Flag indicating that the period length for this collection is not a standard length. It can be used to filter out nonstandard periods around a Fiscal Year end change. |
|
normalizedNetIncome1YearGrowthRate |
decimal{34,6} |
|
The percentage change in normalized net income (adjusted for unusual or one-time items) over one year, showing a clearer picture of core profitability changes. |
|
normalizedNetIncome1YearGrowthRateCurrencyISO |
string(3) |
|
Currency ISO code for Normalized Net Income 1 Yr GR |
|
normalizedNetIncome2YearCAGR |
decimal{34,6} |
|
The average annual growth rate of normalized net income (adjusted for unusual or one-time items) over two years, providing a clearer picture of core profit growth. |
|
normalizedNetIncome2YearCAGRCurrencyISO |
string(3) |
|
Currency ISO code for Normalized Net Income 2 Yr CAGR |
|
normalizedNetIncome3YearCAGR |
decimal{34,6} |
|
The average annual growth rate of normalized net income (adjusted for unusual or one-time items) over three years, providing a clearer picture of core profit growth. |
|
normalizedNetIncome3YearCAGRCurrencyISO |
string(3) |
|
Currency ISO code for Normalized Net Income 3 Yr CAGR |
|
normalizedNetIncome5YearCAGR |
decimal{34,6} |
|
The average annual growth rate of normalized net income (adjusted for unusual or one-time items) over five years, providing a clearer picture of core profit growth. |
|
normalizedNetIncome5YearCAGRCurrencyISO |
string(3) |
|
Currency ISO code for Normalized Net Income 5 Yr CAGR |
|
normalizedNetIncomeMargin |
decimal{34,6} |
|
The percentage of revenue left as profit after adjusting for one-time items, giving a clearer picture of a company's recurring profitability. |
|
normalizedNetIncomeMarginCurrencyISO |
string(3) |
|
Currency ISO code for Normalized Net Income Margin |
|
operatingIncome |
decimal{34,6} |
|
Profit from regular business activities after subtracting operating expenses but before interest and taxes. |
|
operatingIncomeCurrencyISO |
string(3) |
|
Currency ISO code for Operating Income |
|
otherOperatingExpenseTotal |
decimal{34,6} |
|
Total costs of running a business not directly tied to making products, like administrative salaries and rent. |
|
otherOperatingExpenseTotalCurrencyISO |
string(3) |
|
Currency ISO code for Other Operating Expense Total |
| link |
periodType |
FinancialPeriodType |
|
Denotes whether a period is a quarter, annual, semi-annual, LTM, or YTD |
|
periodTypeId |
long(-2147483648,2147483647) |
|
Denotes whether a period is a quarter, annual, semi-annual, LTM, or YTD |
|
pressReleaseFlag |
long |
|
Indicates if the document is from Preliminary earnings release. This information is usually released by the company prior to the official filing or release of data. |
|
quickRatio |
decimal{34,6} |
|
A stricter version of the current ratio that excludes inventory. It shows a company's ability to pay short-term obligations with its most liquid assets (cash, receivables). |
|
quickRatioCurrencyISO |
string(3) |
|
Currency ISO code for Quick Ratio |
|
reportedCurrencyISO |
string(3) |
|
ISO Code for reported currency |
|
reportedCurrencyId |
long |
|
Code for reported currency |
|
repurchaseOfCommonStock |
decimal{34,6} |
|
The money a company spends to buy back its own shares from the market. |
|
repurchaseOfCommonStockCurrencyISO |
string(3) |
|
Currency ISO code for Repurchase of Common Stock |
|
returnOnAssets |
decimal{34,6} |
|
Measures how efficiently a company uses its assets to generate profit. Calculated as net income divided by total assets. |
|
returnOnAssetsCurrencyISO |
string(3) |
|
Currency ISO code for Return on Assets |
|
returnOnCapital |
decimal{34,6} |
|
Indicates how well a company generates profit from its capital (debt + equity). Calculated as net income divided by total capital. |
|
returnOnCapitalCurrencyISO |
string(3) |
|
Currency ISO code for Return on Capital |
|
returnOnCommonEquity |
decimal{34,6} |
|
Measures the return on equity available specifically to common shareholders. Similar to Return on Equity but focuses on common stockholders. |
|
returnOnCommonEquityCurrencyISO |
string(3) |
|
Currency ISO code for Return on Common Equity |
|
returnOnEquity |
decimal{34,6} |
|
Shows how much profit a company generates from shareholders' equity. Calculated as net income divided by shareholders' equity. |
|
returnOnEquityCurrencyISO |
string(3) |
|
Currency ISO code for Return on Equity |
|
searchedForUnusualItemsTypeId |
long |
|
0 for no, 1 for yes, 2 for not sure |
|
seniorUnsecuredBondsAndNotes |
decimal{34,6} |
|
The total value of senior unsecured bonds and notes that a company has issued, which take priority over other unsecured debts in repayment. |
|
seniorUnsecuredBondsAndNotesCurrencyISO |
string(3) |
|
Currency ISO code for Senior Unsecured Bonds and Notes |
|
sgaMargin |
decimal{34,6} |
|
The percentage of sales that is spent on Selling, General & Administrative expenses (SG&A), such as marketing, salaries, and office expenses. |
|
sgaMarginCurrencyISO |
string(3) |
|
Currency ISO code for SG&A Margin |
|
shortTermDebtIssued |
decimal{34,6} |
|
The amount of new short-term debt (due within one year) that a company has borrowed. |
|
shortTermDebtIssuedCurrencyISO |
string(3) |
|
Currency ISO code for Short Term Debt Issued |
|
totalAssetTurnover |
decimal{34,6} |
|
Measures how efficiently a company uses its total assets to generate sales. Calculated as sales divided by total assets. |
|
totalAssetTurnoverCurrencyISO |
string(3) |
|
Currency ISO code for Total Asset Turnover |
|
totalAssets |
decimal{34,6} |
|
The total value of everything a company owns (both current and long-term assets). |
|
totalAssetsCurrencyISO |
string(3) |
|
Currency ISO code for Total Assets |
|
totalBankDebt |
decimal{34,6} |
|
The total amount of loans a company has borrowed from banks. |
|
totalBankDebtCurrencyISO |
string(3) |
|
Currency ISO code for Total Bank Debt |
|
totalCashAndShortTermInvestments |
decimal{34,6} |
|
The total value of cash and short-term investments that the company holds, which can be quickly converted into cash. |
|
totalCashAndShortTermInvestmentsCurrencyISO |
string(3) |
|
Currency ISO code for Total Cash & ST Investments |
|
totalCommercialPaper |
decimal{34,6} |
|
The total value of short-term, unsecured debt issued by a company, typically to cover immediate financial obligations like payroll or inventory. |
|
totalCommercialPaperCurrencyISO |
string(3) |
|
Currency ISO code for Total Commercial Paper |
|
totalCommonEquity |
decimal{34,6} |
|
The total value of assets that shareholders own after all liabilities are subtracted. |
|
totalCommonEquityCurrencyISO |
string(3) |
|
Currency ISO code for Total Common Equity |
|
totalCurrentAssets |
decimal{34,6} |
|
The total value of all assets that a company expects to convert into cash within one year (e.g., cash, inventory). |
|
totalCurrentAssetsCurrencyISO |
string(3) |
|
Currency ISO code for Total Current Assets |
|
totalCurrentLiabilities |
decimal{34,6} |
|
The total amount of money a company owes that must be paid within one year (e.g., short-term debt, bills). |
|
totalCurrentLiabilitiesCurrencyISO |
string(3) |
|
Currency ISO code for Total Current Liabilities |
|
totalDebt |
decimal{34,6} |
|
The sum of all short-term and long-term debt owed by the company. |
|
totalDebtCurrencyISO |
string(3) |
|
Currency ISO code for Total Debt |
|
totalDebtIssued |
decimal{34,6} |
|
The total amount of both short-term and long-term debt that a company has borrowed. |
|
totalDebtIssuedCurrencyISO |
string(3) |
|
Currency ISO code for Total Debt Issued |
|
totalDebtOutstanding |
decimal{34,6} |
|
The total amount of all types of debt that a company currently owes, including loans, bonds, and leases. |
|
totalDebtOutstandingCurrencyISO |
string(3) |
|
Currency ISO code for Total Debt Outstanding |
|
totalDebtRepaid |
decimal{34,6} |
|
The total amount of debt a company has paid back during the period. |
|
totalDebtRepaidCurrencyISO |
string(3) |
|
Currency ISO code for Total Debt Repaid |
|
totalDebtToCapital |
decimal{34,6} |
|
A ratio comparing a company's total debt to its total capital (debt + equity). It measures how leveraged the company is. |
|
totalDebtToCapitalCurrencyISO |
string(3) |
|
Currency ISO code for Total Debt/Capital |
|
totalDebtToEBITDALessCapex |
decimal{34,6} |
|
A measure of how leveraged a company is when comparing its total debt to its earnings minus capital expenditures. |
|
totalDebtToEBITDALessCapexCurrencyISO |
string(3) |
|
Currency ISO code for Total Debt/(EBITDA-CAPEX) |
|
totalDebtToEbitda |
decimal{34,6} |
|
A ratio comparing total debt to a company's EBITDA, indicating how leveraged the company is. |
|
totalDebtToEbitdaCurrencyISO |
string(3) |
|
Currency ISO code for Total Debt/EBITDA |
|
totalDebtToEquity |
decimal{34,6} |
|
A ratio that compares a company's total debt to its shareholders' equity. It shows how much of the company is financed by debt versus equity. |
|
totalDebtToEquityCurrencyISO |
string(3) |
|
Currency ISO code for Total Debt/Equity |
|
totalDividendsPaid |
decimal{34,6} |
|
The total amount of money a company paid out in dividends, including to common and preferred shareholders. |
|
totalDividendsPaidCurrencyISO |
string(3) |
|
Currency ISO code for Total Dividends Paid |
|
totalEquity |
decimal{34,6} |
|
The total value of ownership in the company, including common and preferred equity. |
|
totalEquityCurrencyISO |
string(3) |
|
Currency ISO code for Total Equity |
|
totalLeaseLiabilities |
decimal{34,6} |
|
The total amount a company owes under lease agreements for using property, equipment, or other assets. |
|
totalLeaseLiabilitiesCurrencyISO |
string(3) |
|
Currency ISO code for Total Lease Liabilities |
|
totalLiabilities |
decimal{34,6} |
|
The total amount of all debts and obligations a company owes, both short-term and long-term. |
|
totalLiabilitiesAndEquity |
decimal{34,6} |
|
The total of a company's liabilities plus shareholders' equity; this equals total assets. |
|
totalLiabilitiesAndEquityCurrencyISO |
string(3) |
|
Currency ISO code for Total Liabilities And Equity |
|
totalLiabilitiesCurrencyISO |
string(3) |
|
Currency ISO code for Total Liabilities |
|
totalLiabilitiesToTotalAssets |
decimal{34,6} |
|
A ratio that compares a company's total liabilities to its total assets, indicating how much of its assets are financed by liabilities. |
|
totalLiabilitiesToTotalAssetsCurrencyISO |
string(3) |
|
Currency ISO code for Total Liabilities/Total Assets |
|
totalPrincipalDue |
decimal{34,6} |
|
The total amount of money the company still owes on all its loans or debt obligations, excluding interest. |
|
totalPrincipalDueCurrencyISO |
string(3) |
|
Currency ISO code for Total Principal Due |
|
totalReceivables |
decimal{34,6} |
|
The total amount of money owed to the company by customers for goods or services sold on credit. |
|
totalReceivablesCurrencyISO |
string(3) |
|
Currency ISO code for Total Receivables |
|
totalRevenue |
decimal{34,6} |
|
The total money a company earns from selling its products or services before any costs are subtracted. |
|
totalRevenue1YearGrowthRate |
decimal{34,6} |
|
The percentage change in a company's total revenue over one year, showing how much the company's sales have grown or shrunk during that period. |
|
totalRevenue1YearGrowthRateCurrencyISO |
string(3) |
|
Currency ISO code for Total Revenue 1 Yr GR |
|
totalRevenue2YearCAGR |
decimal{34,6} |
|
The average annual growth rate of a company's total revenue over two years, showing how much revenue has grown per year on average over that period. |
|
totalRevenue2YearCAGRCurrencyISO |
string(3) |
|
Currency ISO code for Total Revenue 2 Yr CAGR |
|
totalRevenue3YearCAGR |
decimal{34,6} |
|
The average annual growth rate of a company's total revenue over three years, showing how much revenue has grown per year on average over that period. |
|
totalRevenue3YearCAGRCurrencyISO |
string(3) |
|
Currency ISO code for Total Revenue 3 Yr CAGR |
|
totalRevenue5YearCAGR |
decimal{34,6} |
|
The average annual growth rate of a company's total revenue over five years, showing how much revenue has grown per year on average over that period. |
|
totalRevenue5YearCAGRCurrencyISO |
string(3) |
|
Currency ISO code for Total Revenue 5 Yr CAGR |
|
totalRevenueCurrencyISO |
string(3) |
|
Currency ISO code for Total Revenue |
|
totalRevolvingCredit |
decimal{34,6} |
|
The total amount of money available to borrow through a revolving credit line, which allows a company to borrow, repay, and borrow again. |
|
totalRevolvingCreditCurrencyISO |
string(3) |
|
Currency ISO code for Total Revolving Credit |
|
totalSecuredDebt |
decimal{34,6} |
|
The total value of debt that is backed by collateral, such as property or equipment, which the lender can take if the company fails to repay. |
|
totalSecuredDebtCurrencyISO |
string(3) |
|
Currency ISO code for Total Secured Debt |
|
totalSeniorBondsAndNotes |
decimal{34,6} |
|
The total value of bonds and notes that a company has issued which are considered senior, meaning they must be paid off before other debts in bankruptcy. |
|
totalSeniorBondsAndNotesCurrencyISO |
string(3) |
|
Currency ISO code for Total Senior Bonds and Notes |
|
totalSeniorDebt |
decimal{34,6} |
|
The total amount of debt that takes priority for repayment over other debts in the event of liquidation or bankruptcy. |
|
totalSeniorDebtCurrencyISO |
string(3) |
|
Currency ISO code for Total Senior Debt |
|
totalSeniorDebtToEBITDALessCapex |
decimal{34,6} |
|
A measure of how leveraged a company is with its senior debt, relative to its earnings minus capital expenditures. |
|
totalSeniorDebtToEBITDALessCapexCurrencyISO |
string(3) |
|
Currency ISO code for Total Senior Debt/(EBITDA-CAPEX) |
|
totalSeniorDebtToEbitda |
decimal{34,6} |
|
A ratio comparing total senior debt to a company's EBITDA, showing how much priority debt the company has relative to earnings. |
|
totalSeniorDebtToEbitdaCurrencyISO |
string(3) |
|
Currency ISO code for Total Senior Debt/EBITDA |
|
totalSeniorSecuredDebt |
decimal{34,6} |
|
The total value of secured debt that has seniority for repayment over other secured debts in case of liquidation or bankruptcy. |
|
totalSeniorSecuredDebtCurrencyISO |
string(3) |
|
Currency ISO code for Total Senior Secured Debt |
|
totalSeniorSecuredToEBITDALessCapex |
decimal{34,6} |
|
A measure of how leveraged a company is with senior secured debt, relative to earnings minus capital expenditures. |
|
totalSeniorSecuredToEBITDALessCapexCurrencyISO |
string(3) |
|
Currency ISO code for Total Senior Secured/(EBITDA-CAPEX) |
|
totalSeniorSecuredToEbitda |
decimal{34,6} |
|
A ratio comparing total senior secured debt to EBITDA, showing how leveraged the company is with high-priority, collateral-backed debt. |
|
totalSeniorSecuredToEbitdaCurrencyISO |
string(3) |
|
Currency ISO code for Total Senior Secured/EBITDA |
|
totalShortTermBorrowings |
decimal{34,6} |
|
The total value of all debts that need to be repaid within one year. |
|
totalShortTermBorrowingsCurrencyISO |
string(3) |
|
Currency ISO code for Total Short Term Borrowings |
|
totalUndrawnCredit |
decimal{34,6} |
|
The total amount of all credit facilities that the company hasn't used yet but can still draw upon in the future. |
|
totalUndrawnCreditCurrencyISO |
string(3) |
|
Currency ISO code for Total Undrawn Credit |
|
totalUnsecuredDebt |
decimal{34,6} |
|
The total amount of debt that is not backed by any collateral. |
|
totalUnsecuredDebtCurrencyISO |
string(3) |
|
Currency ISO code for Total Unsecured Debt |
| link |
unConsolidatedBSRestatementType |
FinancialRestatementType |
|
The TypeId identifying the restatement type for the balance sheet (e.g. Press Release, Original, Restated) |
|
unConsolidatedBSRestatementTypeId |
long(-2147483648,2147483647) |
|
The TypeId identifying the restatement type for the balance sheet (e.g. Press Release, Original, Restated) |
| link |
unConsolidatedCFRestatementType |
FinancialRestatementType |
|
The TypeId identifying the restatement type for the statement of cash flow (e.g. Press Release, Original, Restated) |
|
unConsolidatedCFRestatementTypeId |
long(-2147483648,2147483647) |
|
The TypeId identifying the restatement type for the statement of cash flow (e.g. Press Release, Original, Restated) |
|
unConsolidatedFlag |
long* |
|
Flag to indicate if financials are unconsolidated |
| link |
unConsolidatedISRestatementType |
FinancialRestatementType |
|
The TypeId identifying the restatement type for the income statement (e.g. Press Release, Original, Restated) |
|
unConsolidatedISRestatementTypeId |
long(-2147483648,2147483647) |
|
The TypeId identifying the restatement type for the income statement (e.g. Press Release, Original, Restated) |
|
undrawnRevolvingCredit |
decimal{34,6} |
|
The amount of available credit in a revolving credit line that the company has not yet used or borrowed. |
|
undrawnRevolvingCreditCurrencyISO |
string(3) |
|
Currency ISO code for Undrawn Revolving Credit |
|
unleveredFreeCashFlowMargin |
decimal{34,6} |
|
The percentage of revenue left as free cash flow before any interest payments on debt. It shows how much cash is available to all capital providers. |
|
unleveredFreeCashFlowMarginCurrencyISO |
string(3) |
|
Currency ISO code for Unlevered Free Cash Flow Margin |
|
updOperation |
long |
|
Indicates whether the row is new, updated, or (logically) deleted i.e. 0=new, 1=updated, 2=deleted |
|
useAsComponentFlag |
long |
|
Flag indicating if the instance can be used as a component in calculating missing period calculations |
|
variableRateDebt |
decimal{34,6} |
|
Debt with an interest rate that fluctuates based on a benchmark, such as LIBOR or the prime rate. |
|
variableRateDebtCurrencyISO |
string(3) |
|
Currency ISO code for Variable Rate Debt |