| key |
id |
string(100)* |
= |
The id field uniquely identifies the entity record. |
| timeline |
lastModifiedDate |
dateTime* |
=< >= |
Date and time the record was last modified |
|
companyId |
long(-2147483648,2147483647)* |
|
Unique S&P Capital IQ company identifier |
|
currencyFactor |
decimal{34,19} |
|
Factor used for currency conversion, expressed as a ratio. [Magnitude: x] |
|
currencyId |
long(-32767,32767) |
|
Unique identifier for a currency |
|
currencyIso |
string(3) |
|
International Organization for Standardization (ISO) 4217 code for the currency. |
| link |
financialInstance |
FinancialInstance |
|
Unique identifier for the current financial instance of the company for which financials are available. |
|
financialInstanceId |
long(-2147483648,2147483647) |
|
Unique identifier for the current financial instance of the company for which financials are available. |
| link |
periodType |
ExcelPeriodConstant |
|
Period type reference. |
|
periodTypeId |
long(0,255)* |
|
Unique identifier for the type of period. |
|
pricingDate |
date* |
|
Date of the market price used in historical valuation analysis. |
|
tradingItemId |
long(-2147483648,2147483647)* |
|
Unique S&P Capital IQ trading item identifier |
|
updOperation |
long(0,2) |
|
Indicates whether the row is new, updated, or (logically) deleted i.e. 0=new, 1=updated, 2=deleted |