| key |
id |
string(100)* |
= |
Id column for composite primary key definition |
| timeline |
updDate |
dateTime* |
=< >= |
Last modification date and time of a physical row |
|
componentCurrencyId |
long(-2147483648,2147483647) |
|
Indicates the currencyID of the component used in the ratio calculation |
|
componentInstanceId |
long(-9223372036854775807,9223372036854775806)* |
|
Instance used in the calculation of ratio |
|
currencyConversionFactor |
decimal{18,9} |
|
Factor applied for component collection ID is the component collection ID is in a different currency |
|
currencyId |
long(-2147483648,2147483647) |
|
Unique identifier for a currency |
|
currencyIso |
string(3) |
|
ISO code for the currency ID |
|
financialInstanceId |
long(-9223372036854775807,9223372036854775806)* |
|
The unique identifier for each instance of a financial period. |
| link |
ratioCategory |
FormulaCategoryType |
|
ID indicating the nature of calculation - Average, sum, division, multiplication etc., |
|
ratioCategoryId |
long(-2147483648,2147483647) |
|
ID indicating the nature of calculation - Average, sum, division, multiplication etc., |
| link |
templateType |
FinancialTemplateType |
|
Template ID for the instance |
|
templateTypeId |
long(-2147483648,2147483647) |
|
Template ID for the instance |
|
unConsolidatedFlag |
boolean |
|
Flag indicating if the data is consolidated or unconsolidated |
|
updOperation |
long(0,2) |
|
Indicates whether the row is new, updated, or (logically) deleted i.e. 0=new, 1=updated, 2=deleted |