Counterparty dynamic groups

Dimensions > Entity > > CTP dynamic groups

Attributes tab

Field	Description
Code	Dynamic group code
Description	Description of the dynamic group
SQL rule	SQL rules for the dynamic extraction of counterparties

SQL rule conventions

The following conventions apply to the composition of SQL rules:

Convention	Description
{AZI}.NOME_CAMPO	Entity elements field: - AZIENDA table - SCENARIO_PERIODO_AZIENDA table (only for time-dependent management)
{AZIV}.NOME_CAMPO	Classifiers field managed for the entity dimension: - AZIENDA_VARIABILE table - AZIENDA_VARIABILE_TV (only for time-dependent management)
{AZIR}.NOME_CAMPO	Field from the SCENARIO_PERIODO_CONS table which stores the parameters used by consolidation data processing on original scenarios for the process/scenario/period/company (only counterparty company, consolidator company, deconsolidation method on the original scenario, optional intercompany matching and generation of counterparty eliminations)
{SCE}.NOME_CAMPO	Scenario elements field