Type FinancialCollectionInterimData
Type category Entity
Description Processing table which contains the interim data prior to standardization
Timeseries key id, updDateavailable from 2026-06-11
Fields
Name Type Filters Description
key id string(100)* = Id column for composite primary key definition
timeline updDate dateTime* =< >= Last modification date and time of a physical row
link auditType FinancialAuditType Flag indicating of a field is auditable within the S&P Capital IQ database
auditTypeId long(-2147483648,2147483647) Flag indicating of a field is auditable within the S&P Capital IQ database
breakupLineItemId long* Indicates the line number in our collection process for components collected from the breakups in a financial statement
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 reported line item
descriptionId long(-2147483648,2147483647) The unique identifier for the description of the reported line item
financialCollectionId long* The unique identifier for the collection
mainTableLineNumber long* Reflects the table line number in our collection process
nmFlag long Flag indicating that the value data item is not meaningful
originalDataItemId long originalDataItemID
scaleId long TypeId indicating the scale of the value: 1 for actuals (factor of 1), 2 for thousands (factor of 1,000), and 3 for millions (factor of 1,000,000).
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 Indicates whether the row is new, updated, or (logically) deleted i.e. 0=new, 1=updated, 2=deleted
18 rows of 18 total
API Open API Specification