E201
Comments Analysis
Properties Sources: prospetto
- Code
E201- Description
- Comments Analysis
- Web opening
C- Type flags
- Input
- Groups
- E22
Structure
Sources: prospetto_xml
Comments Analysis
Template00 · 1 matrix
Top 15 Accounts
CPM
Filters
LUNPER
1
Rows
Queries 1
Sources: prospetto_xml
Comments
SQL
▾
AA
SELECT COMMENTI AS "Comment", DESC_AZIENDA0 as "Entity", DESC_DEST10 as "Cost Center", DATI_COMMENTI.USERUPD AS "Edited by", DATI_COMMENTI.dateupd as "Time" FROM DATI_COMMENTI
INNER JOIN DEST1
ON DATI_COMMENTI.DEST1=DEST1.COD_DEST1
INNER JOIN AZIENDA
ON DATI_COMMENTI.AZIENDA=AZIENDA.COD_AZIENDA
WHERE COD_SCENARIO = ${$Scenario.code}
and COD_PERIODO = ${$Period.code}
AND CONTO = ${$Account.code}
AND AZIENDA = ${$Entity.code}
AND FLAG_ATTIVO = 1