| key |
id |
string(100)* |
= |
Unique identifier for the financial period instance associated with the filing. |
| timeline |
updDate |
dateTime* |
=< >= |
Last modification date and time of a physical row. |
|
asReportedPeriodEndDate |
date |
|
End date of the financial reporting period as it was originally reported. |
| link |
bsGAAP |
GAAPCodes |
|
Indicates the GAAP code used for the balance sheet. |
| link |
bsRestatementType |
FinancialRestatementType |
|
The TypeId identifying the restatement type for the balance sheet (e.g. Press Release, Original, Restated) |
|
bsRestatementTypeId |
long(-2147483648,2147483647) |
|
The TypeId identifying the restatement type for the balance sheet (e.g. Press Release, Original, Restated) |
| link |
cfGAAP |
GAAPCodes |
|
Indicates the GAAP code used for the cash flow statement. |
| link |
cfRestatementType |
FinancialRestatementType |
|
The TypeId identifying the restatement type for the statement of cash flow (e.g. Press Release, Original, Restated) |
|
cfRestatementTypeId |
long(-2147483648,2147483647) |
|
The TypeId identifying the restatement type for the statement of cash flow (e.g. Press Release, Original, Restated) |
| filter_list |
companyId |
long(-2147483648,2147483647) |
= |
Unique identifier denoting a company. |
| link |
documentDetails |
DocumentDetails |
|
Unique identifier for the document details record. |
|
documentDetailsId |
long(-2147483648,2147483647) |
|
Unique identifier for the document details record. |
|
documentId |
long(-2147483648,2147483647) |
|
A unique Capital IQ identifier that identifies the source document used for this update. |
| filter_list |
documentPeriod |
date |
= |
Period end date of the financial report. |
|
filingDateTime |
date |
|
Date and time when the source document was filed. |
|
filingId |
long(-2147483648,2147483647) |
|
Unique identifier for the document |
| link |
financialInstance |
FinancialInstance |
|
Numeric identifier for the financial period instance associated with the as-presented filing. |
| filter_list |
financialInstanceId |
long(-2147483648,2147483647)* |
= |
Numeric identifier for the financial period instance associated with the as-presented filing. |
| link |
financialPeriod |
FinancialPeriod |
|
Unique identifier for the financial period. |
|
financialPeriodId |
long(-2147483648,2147483647) |
|
Unique identifier for the financial period. |
|
hasBalanceSheet |
boolean |
|
Indicates that the document contains a balance sheet. |
|
hasCashFlow |
boolean |
|
Indicates that the document contains a cash flow statement. |
|
hasDMCF |
boolean |
|
Indicates that the document contains a direct method cash flow statement. |
|
hasIncomeStatement |
boolean |
|
Indicates that the document contains an income statement. |
| link |
isGAAP |
GAAPCodes |
|
Indicates the GAAP code used for the income statement. |
| link |
isRestatementType |
FinancialRestatementType |
|
Unique identifier for the restatement type of the income statement (for example, Preliminary, Original, No Change). |
|
isRestatementTypeId |
long(-2147483648,2147483647) |
|
Unique identifier for the restatement type of the income statement (for example, Preliminary, Original, No Change). |
|
issuedAsAmendmentFlag |
boolean |
|
Indicates that the filing is an amendment to a previous report. |
|
issuedAsPreliminaryFlag |
boolean |
|
Indicates that the filing was issued as a preliminary report. |
|
numMonths |
long(0,255) |
|
The number of months covered by the financial reporting period(Magnitude: months) |
| link |
periodType |
FinancialPeriodType |
|
Unique identifier for the type of financial period (for example, annual, quarterly, year-to-date). |
| filter_list |
periodTypeId |
long(-2147483648,2147483647) |
= |
Unique identifier for the type of financial period (for example, annual, quarterly, year-to-date). |
|
updOperation |
long(0,2) |
|
Indicates whether the row is new, updated, or (logically) deleted i.e. 0=new, 1=updated, 2=deleted |