| key |
id |
string(100)* |
= |
Id column for composite primary key definition |
| timeline |
updDate |
dateTime* |
=< >= |
Last modification date and time of a physical row |
| link |
auditTypeId |
FinancialAuditType |
|
Flag indicating of a field is auditable within the S&P Capital IQ database |
|
breakupLineItemId |
long |
|
Reserved for future use |
| link |
dataItemID |
DataItem |
|
Unique identifier for data items such as Revenue, Expense, etc. |
|
dataItemValue |
decimal{34,6} |
|
The value of the financial data item |
| link |
descriptionId |
FinancialDescription |
|
Reserved for future use |
|
displayDescriptionId |
long |
|
Reserved for future use |
|
financialCollectionId |
long |
|
The unique identifier for the collection |
|
mainTableLineNumber |
long |
|
Reflects the table line number in our collection process |
|
modifiedDescriptionId |
long |
|
Reserved for future use |
|
scaleId |
long |
|
TypeID for magnitude |
| link |
unitTypeId |
FinancialUnitType |
|
Identifier for the type of units that the values are presented in |
|
updOperation |
long |
|
Indicates whether the row is new, updated, or (logically) deleted i.e. 0=new, 1=updated, 2=deleted |