| 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 |
|
Idicates if a field is auditable within the S&P Capital IQ database (0 = no, 1 = yes) |
|
auditTypeId |
long(-2147483648,2147483647) |
|
Idicates if a field is auditable within the S&P Capital IQ database (0 = no, 1 = yes) |
|
breakupLineItemId |
long(-2147483648,2147483647)* |
|
Indicates the line number in our collection process for components collected from the breakups in a financial statement |
|
capitalStructureCleanedDescription |
string(255) |
|
For each componentId, the description of the component (e.g., short-term loans at 2.2%, convertible notes, other notes payable through 2006, etc.) |
| link |
capitalStructureIsConvertibleType |
CapitalStructureIsConvertibleType |
|
The unique identifier that displays whether the debt is convertible, and when available, the types of convertible debt.(e.g., yes, no, convertible, exchangeable, with warrants, etc.) |
|
capitalStructureIsConvertibleTypeId |
long(-2147483648,2147483647) |
|
The unique identifier that displays whether the debt is convertible, and when available, the types of convertible debt.(e.g., yes, no, convertible, exchangeable, with warrants, etc.) |
| link |
capitalStructureIsSecuredType |
CapitalStructureIsSecuredType |
|
The unique identifier that indicates whether the debt is secured, and when available, the types of secured debt. (e.g., yes, no, securitized, second lien, etc.) |
|
capitalStructureIsSecuredTypeId |
long(-2147483648,2147483647) |
|
The unique identifier that indicates whether the debt is secured, and when available, the types of secured debt. (e.g., yes, no, securitized, second lien, etc.) |
| link |
capitalStructureLevelType |
CapitalStructureLevelType |
|
The unique identifier for the priority level of the security's claim on assets in the event of liquidation (e.g., senior, subordinated, preferred, etc.) |
|
capitalStructureLevelTypeId |
long(-2147483648,2147483647) |
|
The unique identifier for the priority level of the security's claim on assets in the event of liquidation (e.g., senior, subordinated, preferred, etc.) |
| link |
capitalStructureNonRecourseType |
CapitalStructureNonRecourseType |
|
The unique identifier that displays if the debt is nonrecourse (e.g., NA, Yes, No) |
|
capitalStructureNonRecourseTypeId |
long(-2147483648,2147483647) |
|
The unique identifier that displays if the debt is nonrecourse (e.g., NA, Yes, No) |
| link |
capitalStructureSubType |
CapitalStructureSubType |
|
The unique identifier for the capital subtypes |
|
capitalStructureSubTypeId |
long(-2147483648,2147483647) |
|
The unique identifier for the capital subtypes |
| 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{34,6} |
|
The value of the financial data item |
| link |
description |
FinancialDescription |
|
The unique identifier for the description of the debt component |
|
descriptionId |
long(-2147483648,2147483647) |
|
The unique identifier for the description of the debt component |
|
displayDescriptionId |
long(-2147483648,2147483647) |
|
The unique identifier for the description of the debt component. These descriptions do not have standardized formatting e.g. Bank loans or Notes payable |
|
financialCollectionId |
long(-9223372036854775807,9223372036854775806)* |
|
The unique identifier for the collection |
|
mainTableLineNumber |
long(-2147483648,2147483647)* |
|
Reflects the table line number in our collection process |
|
modifiedDescriptionId |
long(-2147483648,2147483647) |
|
The unique identifier for the description of the debt component. Modified definitions have standardized formatting e.g. Bank Loans or Notes Payable |
|
objectId |
long(-2147483646,2147483647) |
|
The unique identifier for equity component or debt component. |
| link |
unitType |
FinancialUnitType |
|
Reference data describing the type of units that describe the value |
|
unitTypeId |
long(-2147483648,2147483647) |
|
Reference data describing the type of units that describe the value |
|
updOperation |
long(0,2) |
|
Indicates whether the row is new, updated, or (logically) deleted i.e. 0=new, 1=updated, 2=deleted |