| key |
id |
string(100)* |
= |
Id column for composite primary key definition |
| timeline |
updDate |
dateTime* |
=< >= |
Last modification date and time of a physical row |
|
calculatedCollectionId |
long* |
|
A record in this field indicates that the collection is a calculated collection |
|
calculationTypeId |
long |
|
Represents how data got derived for that particular instance and collection combination |
|
componentCollectionId |
long* |
|
Component(s) for the calculated CollectioID |
|
currencyConversionFactor |
decimal{28,10} |
|
Factor applied for component collection ID is the component collection ID is in a different currency |
| link |
dataCollectionType |
FinancialCollectionType |
|
The unique identifier defining the collection (e.g. income statement, balance sheet, statement of cash flow) |
|
dataCollectionTypeId |
long(-2147483648,2147483647) |
|
The unique identifier defining the collection (e.g. income statement, balance sheet, statement of cash flow) |
|
fiscalQuarter |
long |
|
The fiscal quarter for this financial period |
|
multiplicationFactor |
decimal{13,10}* |
|
Number by which the component collection is multiplied |
| link |
periodType |
FinancialPeriodType |
|
Denotes whether a period is a quarter, annual, semi-annual, LTM, or YTD |
|
periodTypeId |
long(-2147483648,2147483647) |
|
Denotes whether a period is a quarter, annual, semi-annual, LTM, or YTD |
|
updOperation |
long |
|
Indicates whether the row is new, updated, or (logically) deleted i.e. 0=new, 1=updated, 2=deleted |