| 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(-32768,32768) |
|
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) |
|
financialCollectionId |
long(-9223372036854775807,9223372036854775806)* |
|
The unique identifier for the collection |
| link |
financialInstanceDetails |
FinancialInstanceDetails |
|
The unique identifier for each financial period & instance combination. |
|
financialInstanceId |
long(-9223372036854775807,9223372036854775806)* |
|
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(-2147483648,2147483647) |
|
The unique identifier for native instance of a financial period. |
|
numMonths |
long(0,255) |
|
Identifies the number of months |
|
updOperation |
long(0,2) |
|
Indicates whether the row is new, updated, or (logically) deleted i.e. 0=new, 1=updated, 2=deleted |