| 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 |
|
Indicates if a field is auditable within the S&P Capital IQ database |
|
auditTypeId |
long(-2147483648,2147483647) |
|
Indicates if a field is auditable within the S&P Capital IQ database |
| link |
capitalStructureComponent |
FastFinCapitalStructureComponent |
|
The unique identifier for a particular company's debt obligation or equity component.Note: A componentId is not specific to a filing. The same componentId may be used across multiple filings if the details of the debt component did not change. For example, the component ID of 112233 is assigned for a 5% bond with an amount outstanding of $100mm due in 2015 (as listed in a company's 2009 annual report). If this same bond is listed in the company's 2010 annual report with an amount outstanding of $90mm, the same componentId of 112233 will be assigned. |
|
capitalStructureComponentId |
long(-2147483648,2147483647)* |
|
The unique identifier for a particular company's debt obligation or equity component.Note: A componentId is not specific to a filing. The same componentId may be used across multiple filings if the details of the debt component did not change. For example, the component ID of 112233 is assigned for a 5% bond with an amount outstanding of $100mm due in 2015 (as listed in a company's 2009 annual report). If this same bond is listed in the company's 2010 annual report with an amount outstanding of $90mm, the same componentId of 112233 will be assigned. |
| 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 |
| link |
unitType |
FinancialUnitType |
|
Identifier for the type of units that the values are presented in |
|
unitTypeId |
long(-2147483648,2147483647) |
|
Identifier for the type of units that the values are presented in |
|
updOperation |
long(0,2) |
|
Indicates whether the row is new, updated, or (logically) deleted i.e. 0=new, 1=updated, 2=deleted |