Type FinancialInstanceToCollectionDetails
Type category Entity
Description This table is used to define the relationship between a financial instance and a financial collection, allowing a collection to be associated with multiple instances
Timeseries key id, updDateavailable from 2025-01-10
Fields
Name Type Filters Description
key id string(100)* = The id field uniquely identifies the entity record.
timeline updDate dateTime* =< >= Last modification date and time of a physical row
currencyISO string(3) ISO Code for reported currency
currencyId long Unique identifier for a currency
link dataCollectionTypeId FinancialCollectionType The unique identifier defining the collection (e.g. income statement, balance sheet, statement of cash flow)
financialCollectionId long The unique identifier for the collection
link financialInstanceDetailsId FinancialInstanceDetails The unique identifier for each financial period & instance combination.
financialInstanceId long The unique identifier for each instance of a financial period.
link instanceToCollectionTypeId FinancialInstanceToCollectionType The TypeId defining the type of collection (e.g. As Reported, LTM From Annual, Q4-BS from Annual, LTM-BS from Quarterly BS, YTD-BS from Quarterly BS, YTD from Quarter 1, Calculated, Rolled Up from Original, etc.)
nativeFinancialInstanceId long The unique identifier for native instance of a financial period.
numMonths long Identifies the number of months
updOperation long Indicates whether the row is new, updated, or (logically) deleted i.e. 0=new, 1=updated, 2=deleted
12 rows of 12 total
API Open API Specification