| key |
id |
string(100)* |
= |
The id field uniquely identifies the entity record. |
| timeline |
updDate |
dateTime* |
=< >= |
Last modification date and time of a physical row |
| link |
auditType |
FinancialAuditType |
|
Flag indicating if a field is auditable within the S&P Capital IQ database |
|
auditTypeId |
long(-2147483648,2147483647) |
|
Flag indicating if a field is auditable within the S&P Capital IQ database |
| link |
dataItem |
DataItem |
|
Unique identifier for data items such as Revenue, Expense, etc. |
|
dataItemId |
long(-2147483648,2147483647)* |
|
Unique identifier for data items such as Revenue, Expense, etc. |
|
dataItemValue |
decimal{19,6} |
|
The value of the financial data item |
|
financialCollectionId |
long(-9223372036854775807,9223372036854775806)* |
|
The unique identifier for the collection |
|
nmFlag |
boolean |
|
Indicates the value of the data item is not meaningful. |
| link |
unitType |
FinancialUnitType |
|
Reference data displaying the type of units that describe the value (e.g., actual, thousands, and millions). The unit type name and the associated values can be found in the Financial Unit Type table. |
|
unitTypeId |
long(-2147483648,2147483647) |
|
Reference data displaying the type of units that describe the value (e.g., actual, thousands, and millions). The unit type name and the associated values can be found in the Financial Unit Type table. |
|
updOperation |
long(0,2) |
|
Indicates whether the row is new, updated, or (logically) deleted i.e. 0=new, 1=updated, 2=deleted |