| 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 |
dataCollectionType |
FinancialCollectionType |
= |
The unique identifier defining the collection (e.g. income statement, balance sheet, statement of cash flow) |
|
dataCollectionTypeId |
long(-2147483648,2147483647) |
|
The unique identifier defining the collection (e.g. income statement, balance sheet, statement of cash flow) |
| filter_list |
financialCollectionId |
long* |
= |
The unique identifier for the collection |
| link |
financialInstanceDetails |
FinancialInstanceDetails |
= |
The unique identifier for each financial period & instance combination. |
|
financialInstanceId |
long* |
|
The unique identifier for each instance of a financial period. |
| link |
instanceToCollectionType |
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.) |
|
instanceToCollectionTypeId |
long(-2147483648,2147483647) |
|
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 |