{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["490000017"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"490000017","index":0,"n_rows":284,"n_cols":7,"rows_kept":284,"cut":false,"hidden":false,"merged":[]}
["tableAlias","tableName","name","columnGroupHeading","columnHeading","calculation","Oncalculation"]
["UDM_FINANCE","UDM_FINANCE","FISCALYEAR",null,"Exercice"]
["UDM_FINANCE","UDM_FINANCE","FISCALPERIOD",null,"Période fiscale"]
["UDM_FINANCE","UDM_FINANCE","ACCOUNTNUM","Compte","Code"]
["UDM_ACCOUNTS","UDM_ACCOUNTS","ACCOUNTDESC","Compte","Description"]
["*SERVER","*SERVER","FLD00000034",null,"Exercice-période","([Exercice]*100) + UDM_FINANCE.FISCALPERIOD"]
["*SERVER","*SERVER","FLD00000037",null,"Trimestre","CASE \nWHEN [Période fiscale] IN(1,2,3) THEN 'Q1'\nWHEN [Période fiscale] IN(4,5,6) THEN 'Q2'\nWHEN [Période fiscale] IN(7,8,9) THEN 'Q3'\nELSE 'Q4'\nEND"]
["UDM_FINANCE","UDM_FINANCE","CHARTOFACCOUNT",null,"Plan de comptes"]
["UDM_FINANCE","UDM_FINANCE","LEDGER",null,"Référentiel"]
["UDM_FINANCE","UDM_FINANCE","LEDGERCURRENCY",null,"Devise réf."]
["UDM_FINANCE","UDM_FINANCE","COMPANY","Société","Code"]
["UDM_DIMCOMPANY","UDM_DIMCOMPANY","COMPANYNAME","Société","Nom"]
["UDM_FINANCE","UDM_FINANCE","SITE","Site","Code"]
["UDM_DIMSITES","UDM_DIMSITES","FCYNAM","Site","Nom"]
["UDM_FINANCE","UDM_FINANCE","POSTING",null,"Solde"]
["UDM_FINANCE","UDM_FINANCE","POSTINGLY",null,"Solde N-1"]
["*SERVER","*SERVER","FLD00000029",null,"Débit","case when [Solde] > 0 then\n[Solde]\nelse\n0\nend"]
["*SERVER","*SERVER","FLD00000030",null,"Crédit","case when [Solde] < 0 then\n[Solde]*-1\nelse\n0\nend"]
["*SERVER","*SERVER","FLD00000031",null,"Solde d'ouverture","[Solde de fermeture]-UDM_FINANCE.POSTING"]
["*SERVER","*SERVER","FLD00000060",null,"Variance","[Solde]-[Solde]LY"]
["*SERVER","*SERVER","FLD00000061",null,"Variance %",0,"if ([Solde N-1] !== 0)\nnecResult=([Solde]-[Solde N-1])/[Solde N-1];\nelse\nnecResult=0;"]
["*SERVER","*SERVER","FLD00000064",null,"Solde de fermeture","/*$$GLOBALCURR*/UDM_FINANCE.ENDINGBALANCE"]
["UDM_FINANCE","UDM_FINANCE","ENDINGBALANCE",null,"Solde de fermeture"]
["UDM_FINANCE","UDM_FINANCE","YTD",null,"Cumul annuel"]
["UDM_FINANCE","UDM_FINANCE","YTD_LY",null,"Cumul annuelN-1"]
["*SERVER","*SERVER","FLD000000162","Rapport","Cumul annuel","[Cumul annuel] * UDM_MAP_REPCODE_REPORT.SIGN"]
["*SERVER","*SERVER","FLD000000163","Rapport","Cumul annuelN-1","[Cumul annuelN-1] * UDM_MAP_REPCODE_REPORT.SIGN"]
["*SERVER","*SERVER","FLD00000062","Cumul annuel","Variance","[Cumul annuel]-[Cumul annuel]_LY"]
["*SERVER","*SERVER","FLD00000063","Cumul annuel","Variance %",0,"if ([Cumul annuel]_LY!== 0)\nnecResult=[Cumul annuel]/[Cumul annuel]_LY- 1;\nelse\nnecResult=0;"]
["*SERVER","*SERVER","FLD000000166","Rapport","Cumul annuel variance","([Cumul annuel] * [Signe Rapport])-\n([Cumul annuel]_LY * [Signe Rapport])"]
["*SERVER","*SERVER","FLD000000168","Rapport","Cumul annuel variance %",0,"if ( [Cumul annuel]_LY !== 0)\n\nnecResult = ([Cumul annuel] - [Cumul annuel]_LY) / [Cumul annuel]_LY;\nelse \n\nnecResult = 0;"]
["*SERVER","*SERVER","FLD00000070","Solde de fermeture","Variance","[Solde de fermeture N-1]-\nUDM_FINANCE.ENDINGBALANCE"]
["*SERVER","*SERVER","FLD00000033","Rapport","Solde de fermeture Variance","([Solde de fermeture] * [Signe Rapport])-([Solde de fermeture]LY * [Signe Rapport])"]
["*SERVER","*SERVER","FLD00000071","Solde de fermeture","Variance %","0.0\n/*\ncase when [Solde de fermeture N-1] <> 0 then\n([Solde de fermeture]-[Solde de fermeture N-1])/[Solde de fermeture N-1]\nelse\n0\nend\n*/","if ([Rapport Solde de fermeture N-1] !== 0)\n\nnecResult = [Rapport Solde de fermeture Variance] / [Rapport Solde de fermeture N-1];\nelse \n\nnecResult = 0;"]
["*SERVER","*SERVER","FLD00000026","Rapport","Solde d'ouverture","([Solde de fermeture]-[Solde]) * UDM_MAP_REPCODE_REPORT.SIGN"]
["*SERVER","*SERVER","FLD00000056","Rapport","Solde N-1","([Solde de fermeture N-1]-[Solde N-1]) * UDM_MAP_REPCODE_REPORT.SIGN"]
["*SERVER","*SERVER","FLD0000001",null,"Marge nette","-(Case when [Groupe de comptes Code] = 'KPI_SALES' then \n[Solde] else 0 End) -\n(Case when [Groupe de comptes Code] = 'KPI_COGS' then \n[Solde] else 0 End) - \n(Case when [Groupe de comptes Code] = 'KPI_EXPENSES' then \n[Solde] else 0 End)"]
["*SERVER","*SERVER","FLD00000018",null,"Marge nette N-1","-(Case when [Groupe de comptes Code] = 'KPI_SALES' then \n[Solde N-1] else 0 End) -\n(Case when [Groupe de comptes Code] = 'KPI_COGS' then \n[Solde N-1] else 0 End) - \n(Case when [Groupe de comptes Code] = 'KPI_EXPENSES' then \n[Solde N-1] else 0 End)"]
["*SERVER","*SERVER","FLD000000131","Profit net","12 mois glissants","-(Case when [Groupe de comptes Code] = 'KPI_SALES' then \n[Solde Sommes (12 mois glissants)] else 0 End) -\n(Case when [Groupe de comptes Code] = 'KPI_COGS' then \n[Solde Sommes (12 mois glissants)]  else 0 End) - \n(Case when [Groupe de comptes Code] = 'KPI_EXPENSES' then \n[Solde Sommes (12 mois glissants)] else 0 End)"]
["*SERVER","*SERVER","FLD000000132","Profit net N-1","12 mois glissants","-(Case when [Groupe de comptes Code] = 'KPI_SALES' then \n[Solde Sommes (12 mois glissants) N-1] else 0 End) -\n(Case when [Groupe de comptes Code] = 'KPI_COGS' then \n[Solde Sommes (12 mois glissants) N-1]  else 0 End) - \n(Case when [Groupe de comptes Code] = 'KPI_EXPENSES' then \n[Solde Sommes (12 mois glissants) N-1] else 0 End)"]
["*SERVER","*SERVER","FLD0000002",null,"EBE","CASE WHEN [Période fiscale] <> 0 THEN\n((Case when [Groupe de comptes Code] = 'KPI_SALES' then \n[Solde]*-1 else 0 End) -\n(Case when [Groupe de comptes Code] = 'KPI_COGS' then \n[Solde] else 0 End) - \n(Case when [Groupe de comptes Code] = 'KPI_OPERATING_EXPENSES' then \n[Solde] else 0 End))\n+\n(Case when [Groupe de comptes Code] = 'KPI_AMORTIZATION' then \n[Solde] else 0 End)\nELSE\n0\nEND"]
["*SERVER","*SERVER","FLD00000039",null,"EBE N-1","CASE WHEN [Période fiscale] <> 0 THEN\n((Case when [Groupe de comptes Code] = 'KPI_SALES' then \n[Solde N-1]*-1 else 0 End) -\n(Case when [Groupe de comptes Code] = 'KPI_COGS' then \n[Solde N-1] else 0 End) - \n(Case when [Groupe de comptes Code] = 'KPI_OPERATING_EXPENSES' then \n[Solde N-1] else 0 End))\n+\n(Case when [Groupe de comptes Code] = 'KPI_AMORTIZATION' then \n[Solde N-1] else 0 End)\nELSE\n0\nEND"]
["*SERVER","*SERVER","FLD00000036",null,"Marge EBITDA",0,"if ([Ventes] !== 0)\nnecResult=[EBE]/[Ventes];\nelse\nnecResult=0;"]
["*SERVER","*SERVER","FLD00000050",null,"Marge net",0,"if ([Ventes] !== 0)\nnecResult=[Marge nette]/[Ventes];\nelse\nnecResult=0;"]
["*SERVER","*SERVER","FLD00000078",null,"Marge net N-1",0,"if ([Revenu N-1] !== 0)\nnecResult=[Marge nette N-1]/[Revenu N-1];\nelse\nnecResult=0;"]
["*SERVER","*SERVER","FLD0000005",null,"Dépenses d’exploitation","(Case when [Groupe de comptes Code] = 'KPI_OPERATING_EXPENSES' then \n[Solde] else 0 End)"]
["*SERVER","*SERVER","FLD00000081",null,"Dépenses d’exploitation N-1","(Case when [Groupe de comptes Code] = 'KPI_OPERATING_EXPENSES' then \n[Solde N-1] else 0 End)"]
["*SERVER","*SERVER","FLD00000051",null,"Bénéfice d'exploitation (BAII)","(Case when [Groupe de comptes Code] = 'KPI_SALES' then \n[Solde]*-1 else 0 End) -\n(Case when [Groupe de comptes Code] = 'KPI_COGS' then \n[Solde] else 0 End) -\n(Case when [Groupe de comptes Code] = 'KPI_OPERATING_EXPENSES' then \n[Solde] else 0 End)"]
["*SERVER","*SERVER","FLD00000082",null,"Bénéfice d'exploitation (BAII) N-1","(Case when [Groupe de comptes Code] = 'KPI_SALES' then \n[Solde N-1]*-1 else 0 End) -\n(Case when [Groupe de comptes Code] = 'KPI_COGS' then \n[Solde N-1] else 0 End) -\n(Case when [Groupe de comptes Code] = 'KPI_OPERATING_EXPENSES' then \n[Solde N-1] else 0 End)"]
["*SERVER","*SERVER","FLD00000052","Bénéfice d'exploitation (BAII)","Marge",0,"if ([Ventes] !== 0)\nnecResult=[Bénéfice d'exploitation (BAII)]/[Ventes];\nelse\nnecResult=0;"]
["*SERVER","*SERVER","FLD00000083","Bénéfice d'exploitation (BAII)","Marge N-1",0,"if ([Revenu N-1] !== 0)\nnecResult=[Bénéfice d'exploitation (BAII) N-1]/[Revenu N-1];\nelse\nnecResult=0;"]
["*SERVER","*SERVER","FLD000000143","Bénéfice d'exploitation (BAII)","12 mois glissants","(Case when [Groupe de comptes Code] = 'KPI_SALES' then \n[Solde Sommes (12 mois glissants)]*-1 else 0 End) -\n(Case when [Groupe de comptes Code] = 'KPI_COGS' then \n[Solde Sommes (12 mois glissants)] else 0 End) -\n(Case when [Groupe de comptes Code] = 'KPI_OPERATING_EXPENSES' then \n[Solde Sommes (12 mois glissants)] else 0 End)"]
["*SERVER","*SERVER","FLD000000144","Bénéfice d'exploitation (BAII)","12 mois glissants","(Case when [Groupe de comptes Code] = 'KPI_SALES' then \n[Solde Sommes (12 mois glissants) N-1]*-1 else 0 End) -\n(Case when [Groupe de comptes Code] = 'KPI_COGS' then \n[Solde Sommes (12 mois glissants) N-1] else 0 End) -\n(Case when [Groupe de comptes Code] = 'KPI_OPERATING_EXPENSES' then \n[Solde Sommes (12 mois glissants) N-1] else 0 End)"]
["*SERVER","*SERVER","FLD0000006",null,"Ventes","(Case when [Groupe de comptes Code] = 'KPI_SALES' then \n[Solde]*-1 else 0 End)"]
["*SERVER","*SERVER","FLD000000135","Revenu","Somme 12 mois glissants","(Case when [Groupe de comptes Code] = 'KPI_SALES' then \n[Solde Sommes (12 mois glissants)]*-1 else 0 End)"]
["*SERVER","*SERVER","FLD000000136","Revenu","Somme 12 mois glissants N-1","(Case when [Groupe de comptes Code] = 'KPI_SALES' then \n[Solde Sommes (12 mois glissants) N-1]*-1 else 0 End)"]
["*SERVER","*SERVER","FLD000000129","Revenu","Balance de fermeture","(Case when [Groupe de comptes Code] = 'KPI_SALES' then \n[Cumul annuel]*-1 else 0 End)"]
["*SERVER","*SERVER","FLD000000130","Revenu","Balance de fermeture N-1","(Case when [Groupe de comptes Code] = 'KPI_SALES' then \n[Cumul annuelN-1]*-1 else 0 End)"]
["*SERVER","*SERVER","FLD00000079",null,"Revenu N-1","(Case when [Groupe de comptes Code] = 'KPI_SALES' then \n[Solde N-1]*-1 else 0 End)"]
["*SERVER","*SERVER","FLD00000055",null,"Liquidité","CASE\nWHEN\n[Groupe de comptes Code] =  'KPI_CASH'\nTHEN\n\n[Solde de fermeture]\n\nELSE\n0\nEND"]
["*SERVER","*SERVER","FLD00000058",null,"Liquidité N-1","CASE\nWHEN\n[Groupe de comptes Code] =  'KPI_CASH'\nTHEN\n\n[Solde de fermeture N-1]\n\nELSE\n0\nEND"]
["*SERVER","*SERVER","FLD0000008",null,"Actifs","CASE\nWHEN\n[Groupe de comptes Code] =   'KPI_ASSET' \nTHEN\n\n[Solde de fermeture]\n\nELSE\n0\nEND"]
["*SERVER","*SERVER","FLD0000003",null,"Actifs N-1","CASE WHEN\n[Groupe de comptes Code] =   'KPI_ASSET' \nTHEN\n\n[Solde de fermeture N-1]\n\nELSE\n0\nEND"]
["*SERVER","*SERVER","FLD000000128",null,"Rotation de l’actif N-1",0,"if ([Actifs N-1]!==0)\nnecResult=[Revenu Somme 12 mois glissants N-1]/[Actifs N-1];\nelse\nnecResult=0;"]
["*SERVER","*SERVER","FLD0000009",null,"Passif courant","-(CASE\nWHEN\n[Groupe de comptes Code] =   'KPI_CURRENTLIABILITIES' \nTHEN\n[Solde de fermeture] \nELSE\n0\nEND)"]
["*SERVER","*SERVER","FLD000000127",null,"Rotation de l’actif",0,"if ([Actifs]!==0)\nnecResult=[Revenu Somme 12 mois glissants]/[Actifs];\nelse\nnecResult=0;"]
["*SERVER","*SERVER","FLD00000044",null,"Passif courant N-1","-(CASE\nWHEN\n[Groupe de comptes Code] =   'KPI_CURRENTLIABILITIES' \nTHEN\n[Solde de fermeture N-1]\nELSE\n0\nEND)"]
["*SERVER","*SERVER","FLD00000010",null,"Actif circulant","CASE\nWHEN\n[Groupe de comptes Code] =   'KPI_CURRENT_ASSET' \nTHEN\n\n[Solde de fermeture]\n\nELSE\n0\nEND"]
["*SERVER","*SERVER","FLD00000043",null,"Actif circulant N-1","CASE\nWHEN\n[Groupe de comptes Code] =   'KPI_CURRENT_ASSET' \nTHEN\n\n[Solde de fermeture N-1]\n\nELSE\n0\nEND"]
["*SERVER","*SERVER","FLD00000053",null,"Rentabilité de l’actif (ROA)",0,"if ([Actifs] !== 0)\nnecResult=[Profit net 12 mois glissants]/[Actifs];\nelse\nnecResult=0;"]
["*SERVER","*SERVER","FLD00000084",null,"Rentabilité de l’actif (ROA) N-1",0,"if ([Actifs N-1] !== 0)\nnecResult=[Profit net N-1 12 mois glissants]/[Actifs N-1];\nelse\nnecResult=0;"]
["*SERVER","*SERVER","FLD00000054",null,"Rentabilité des capitaux propres (ROE)",0,"if ([Capitaux propres] !== 0)\nnecResult=[Profit net 12 mois glissants]/[Capitaux propres];\nelse\nnecResult=0;"]
["*SERVER","*SERVER","FLD00000085",null,"Rendement des capitaux propres (ROE) N-1",0,"if ([Capitaux propres N-1] !== 0)\nnecResult=[Profit net N-1 12 mois glissants]/[Capitaux propres N-1];\nelse\nnecResult=0;"]
["*SERVER","*SERVER","FLD00000011",null,"Immobilisations corporelle","CASE\nWHEN\n[Groupe de comptes Code] =   'KPI_FIXED_ASSET' \nTHEN\n\n[Solde de fermeture]\n\nELSE\n0\nEND"]
["*SERVER","*SERVER","FLD00000086",null,"Immobilisations corporelle N-1","CASE\nWHEN\n[Groupe de comptes Code] =   'KPI_FIXED_ASSET' \nTHEN\n\n[Solde de fermeture N-1]\n\nELSE\n0\nEND"]
["*SERVER","*SERVER","FLD000000145","Immobilisations corporelle","Somme (12 mois glissants)","(Case when [Groupe de comptes Code] = 'KPI_FIXED_ASSET' then \n[Solde Sommes (12 mois glissants)] else 0 End)"]
["*SERVER","*SERVER","FLD000000146","Immobilisations corporelle N-1","Somme (12 mois glissants)","(Case when [Groupe de comptes Code] = 'KPI_FIXED_ASSET' then \n[Solde Sommes (12 mois glissants) N-1] else 0 End)"]
["*SERVER","*SERVER","FLD00000013",null,"Bénéfice non distribués","(Case when [Groupe de comptes Code] = 'KPI_RETAINED_EARNINGS' then \n[Solde de fermeture] else 0 End)"]
["*SERVER","*SERVER","FLD00000087",null,"Bénéfice non distribués N-1","(Case when [Groupe de comptes Code] = 'KPI_RETAINED_EARNINGS' then \n[Solde de fermeture N-1]  else 0 End)"]
["*SERVER","*SERVER","FLD000000147",null,"Rendement du capital investi",0,"if ((([Immobilisations corporelle]-[Immobilisations corporelle Somme (12 mois glissants)])+[Immobilisations corporelle])!==0)\nnecResult=[Bénéfice d'exploitation (BAII) 12 mois glissants]/((([Immobilisations corporelle]-[Immobilisations corporelle Somme (12 mois glissants)])+[Immobilisations corporelle])/2);\nelse\nnecResult = 0;"]
["*SERVER","*SERVER","FLD000000148",null,"Rendement du capital investi N-1",0,"if ((([Immobilisations corporelle N-1]-[Immobilisations corporelle N-1 Somme (12 mois glissants)])+[Immobilisations corporelle N-1])!==0)\nnecResult=[Bénéfice d'exploitation (BAII) 12 mois glissants]/((([Immobilisations corporelle N-1]-[Immobilisations corporelle N-1 Somme (12 mois glissants)])+[Immobilisations corporelle N-1])/2);\nelse\nnecResult = 0;"]
["*SERVER","*SERVER","FLD00000012",null,"Dettes à long terme","-(CASE\nWHEN\n[Groupe de comptes Code] =   'KPI_LONG_TERM_LIABILITIES' \nTHEN\n\n[Solde de fermeture]\n\nELSE\n0\nEND)"]
["*SERVER","*SERVER","FLD00000088",null,"Dettes à long terme N-1","-(CASE\nWHEN\n[Groupe de comptes Code] =   'KPI_LONG_TERM_LIABILITIES' \nTHEN\n\n[Solde de fermeture N-1]\n\nELSE\n0\nEND)"]
["*SERVER","*SERVER","FLD00000014",null,"Passif","-(CASE\nWHEN\n [Groupe de comptes Code] =   'KPI_LIABILITIES' \nTHEN\n\n[Solde de fermeture]\n\nELSE\n0\nEND)"]
["*SERVER","*SERVER","FLD0000004",null,"Passif N-1","-(CASE\nWHEN\n[Groupe de comptes Code] =   'KPI_LIABILITIES' \nTHEN\n\n[Solde de fermeture N-1]\n\nELSE\n0\nEND)"]
["*SERVER","*SERVER","FLD00000015",null,"Capitaux propres","-(CASE\nWHEN\n[Groupe de comptes Code] =   'KPI_TOTAL_EQUITY'\nTHEN\n\n[Solde de fermeture]\n\nELSE\n0\nEND)"]
["*SERVER","*SERVER","FLD0000007",null,"Capitaux propres N-1","-(CASE\nWHEN\n[Groupe de comptes Code] =   'KPI_TOTAL_EQUITY'\nTHEN\n\n[Solde de fermeture N-1]\n\nELSE\n0\nEND)"]
["*SERVER","*SERVER","FLD000000151",null,"Ratio Dette-actif",0,"if ([Passif]!==0)\nnecResult=[Actifs]/[Passif];\nelse\nnecResult=0;"]
["*SERVER","*SERVER","FLD000000152",null,"Ratio Dette-actif",0,"if ([Passif N-1]!==0)\nnecResult=[Actifs N-1]/[Passif N-1];\nelse\nnecResult=0;"]
["*SERVER","*SERVER","FLD000000153",null,"Ratio Effet levier financier",0,"if ([Capitaux propres]!==0)\nnecResult=[Actifs]/[Capitaux propres];\nelse\nnecResult=0;"]
["*SERVER","*SERVER","FLD000000154",null,"Ratio Effet levier financier N-1",0,"if ([Capitaux propres N-1]!==0)\nnecResult=[Actifs N-1]/[Capitaux propres N-1];\nelse\nnecResult=0;"]
["*SERVER","*SERVER","FLD000000155",null,"Ratio dette/capital",0,"if (([Passif]+[Capitaux propres])!==0)\nnecResult=[Passif]/([Passif]+[Capitaux propres]);\nelse\nnecResult=0;"]
["*SERVER","*SERVER","FLD000000156",null,"Ratio dette/capital N-1",0,"if (([Passif N-1]+[Capitaux propres N-1])!==0)\nnecResult=[Passif N-1]/([Passif N-1]+[Capitaux propres N-1]);\nelse\nnecResult=0;"]
["*SERVER","*SERVER","FLD000000108","Ratio dette Long Terme","sur capitaux propres",0,"if ([Capitaux propres]!==0)\nnecResult=[Dettes à long terme] / [Capitaux propres];\nelse necResult=0;"]
["*SERVER","*SERVER","FLD000000109","Ratio dette Long Terme","sur capitaux propres N-1",0,"if ([Capitaux propres N-1]!==0)\nnecResult=[Dettes à long terme N-1] / [Capitaux propres N-1];\nelse necResult=0;"]
["*SERVER","*SERVER","FLD000000106",null,"Ratio d’endettement",0,"if ([Actifs]!==0)\nnecResult=[Passif] / [Actifs];\nelse necResult=0;"]
["*SERVER","*SERVER","FLD000000107",null,"Ratio d’endettement N-1",0,"if ([Actifs N-1]!==0)\nnecResult=[Passif N-1] / [Actifs N-1];\nelse necResult=0;"]
["*SERVER","*SERVER","FLD00000017",null,"Ratio dettes/Capitaux propres",0,"if ([Capitaux propres]!==0)\nnecResult=[Passif] / [Capitaux propres];\nelse necResult=0;"]
["*SERVER","*SERVER","FLD00000089",null,"Ratio dettes/Capitaux propres N-1",0,"if ([Capitaux propres N-1]!==0)\nnecResult=[Passif N-1] / [Capitaux propres N-1];\nelse necResult=0;"]
["*SERVER","*SERVER","FLD000000110",null,"Délai d’écoulement des stocks (DIO)",0,"if ([Coût des ventes 12 mois glissants]!==0)\nnecResult=(((([Stock]-[Stock 12 mois glissants])+[Stock])/2) / [Coût des ventes 12 mois glissants])*365;\nelse necResult=0;"]
["*SERVER","*SERVER","FLD000000111",null,"Délai d’écoulement des stocks (DIO) N-1",0,"if ([Coût des ventes N-1 12 mois glissants]!==0)\nnecResult=(((([Stock N-1]-[Stock N-1 12 mois glissants])+[Stock N-1])/2) / [Coût des ventes N-1 12 mois glissants]) * 365;\nelse necResult=0;"]
["*SERVER","*SERVER","FLD000000112",null,"Rotation des stocks",0,"if ((([Stock]-[Stock 12 mois glissants])+[Solde Stock])!==0)\nnecResult=[Revenu Somme 12 mois glissants] / (\n(([Stock]-[Stock 12 mois glissants])+[Solde Stock])/2);\nelse necResult=0;"]
["*SERVER","*SERVER","FLD000000113",null,"Rotation des stocks  N-1",0,"if ((([Stock N-1]-[Stock N-1 12 mois glissants])+[Stock N-1])!==0)\nnecResult=[Revenu Somme 12 mois glissants N-1] / (\n(([Stock N-1]-[Stock N-1 12 mois glissants])+[Stock N-1])/2);"]
["*SERVER","*SERVER","FLD000000137",null,"Jours en Stock",0,"if ([Rotation des stocks] !==0)\nnecResult=365/[Rotation des stocks];\nelse\nnecResult=0;"]
["*SERVER","*SERVER","FLD000000138",null,"Jours en stock N-1",0,"if ([Rotation des stocks  N-1] !==0)\nnecResult=365/[Rotation des stocks  N-1];\nelse\nnecResult=0;"]
["*SERVER","*SERVER","FLD000000114",null,"Délai de recouvrement des créances clients (DSO)",0,"if ([Revenu Somme 12 mois glissants]!==0)\nnecResult=([Comptes Clients] / [Revenu Somme 12 mois glissants])*365;\nelse necResult=0;"]
["*SERVER","*SERVER","FLD000000115",null,"Délai de recouvrement des créances clients (DSO) N-1",0,"if ([Revenu Somme 12 mois glissants N-1]!==0)\nnecResult=([Immobilisations corporelle N-1] / [Revenu Somme 12 mois glissants N-1])*365;\nelse necResult=0;"]
["*SERVER","*SERVER","FLD000000116",null,"Délai de crédit fournisseurs (DPO)",0,"if ([Coût des ventes 12 mois glissants]!==0)\nnecResult=[Comptes fournisseurs] / ([Coût des ventes 12 mois glissants]/365);\nelse necResult=0;"]
["*SERVER","*SERVER","FLD000000117",null,"Délai de crédit fournisseurs (DPO) N-1",0,"if ([Coût des ventes N-1 12 mois glissants]!==0)\nnecResult=[Comptes fournisseurs  N-1] / ([Coût des ventes N-1 12 mois glissants]/365);\nelse necResult=0;"]
["*SERVER","*SERVER","FLD000000118",null,"Cycle d’exploitation  (CCC)",0,"necResult=[Délai d’écoulement des stocks (DIO)] + [Délai de recouvrement des créances clients (DSO)] - [Délai de crédit fournisseurs (DPO)];"]
["*SERVER","*SERVER","FLD000000119",null,"Cycle d’exploitation  (CCC) N-1",0,"necResult=[Délai d’écoulement des stocks (DIO) N-1] + [Délai de recouvrement des créances clients (DSO) N-1] - [Délai de crédit fournisseurs (DPO) N-1];"]
["*SERVER","*SERVER","FLD00000016",null,"Comptes Clients","CASE\nWHEN\n[Groupe de comptes Code] =  'KPI_ACCOUNT_RECEIVABLE'\nTHEN\n\n[Solde de fermeture]\n\nELSE\n0\nEND"]
["*SERVER","*SERVER","FLD00000090",null,"Comptes Clients N-1","CASE\nWHEN\n[Groupe de comptes Code] =  'KPI_ACCOUNT_RECEIVABLE'\nTHEN\n\n[Solde de fermeture N-1]\n\nELSE\n0\nEND"]
["*SERVER","*SERVER","FLD000000139","Comptes Clients","12 mois glissants","(Case when [Groupe de comptes Code] = 'KPI_ACCOUNT_RECEIVABLE' then \n[Solde Sommes (12 mois glissants)] else 0 End)"]
["*SERVER","*SERVER","FLD000000140","Comptes Clients","12 mois glissants N-1","(Case when [Groupe de comptes Code] = 'KPI_ACCOUNT_RECEIVABLE' then \n[Solde Sommes (12 mois glissants) N-1] else 0 End)"]
["*SERVER","*SERVER","FLD00000072","Transactions","Comptes Clients","(Case when [Groupe de comptes Code] = 'KPI_ACCOUNT_RECEIVABLE'\n\nthen \n[Solde] else 0 End)"]
["*SERVER","*SERVER","FLD00000091","Transactions N-1","Comptes Clients","(Case when [Groupe de comptes Code] = 'KPI_ACCOUNT_RECEIVABLE'\n\nthen \n[Solde N-1] else 0 End)"]
["*SERVER","*SERVER","FLD000000158","Cumul annuel","Account Recivable","(Case when [Groupe de comptes Code] = 'KPI_ACCOUNT_RECEIVABLE' then \n[Cumul annuel] else 0 End)"]
["*SERVER","*SERVER","FLD000000159","Cumul annuel N-1","Account Receivable","(Case when [Groupe de comptes Code] = 'KPI_ACCOUNT_RECEIVABLE' then \n[Cumul annuelN-1] else 0 End)"]
["*SERVER","*SERVER","FLD00000019",null,"Rotation des comptes clients",0,"if ((([Comptes Clients]-[Comptes Clients 12 mois glissants])+ [Comptes Clients])!==0)\nnecResult=[Revenu Somme 12 mois glissants]/((([Comptes Clients]-[Comptes Clients 12 mois glissants])+ [Comptes Clients])/2);\nelse necResult=0;"]
["*SERVER","*SERVER","FLD00000092",null,"Rotation des comptes clients N-1",0,"if ((([Comptes Clients N-1]-[Comptes Clients 12 mois glissants N-1])+ [Comptes Clients N-1])!==0)\nnecResult=[Revenu Somme 12 mois glissants N-1]/((([Comptes Clients N-1]-[Comptes Clients 12 mois glissants N-1])+ [Comptes Clients N-1])/2);\nelse necResult=0;"]
["*SERVER","*SERVER","FLD000000141",null,"Délai moyen de recouvrement des comptes clients",0,"if ([Rotation des comptes clients]!==0)\nnecResult=365/[Rotation des comptes clients];\nelse\nnecResult=0;"]
["*SERVER","*SERVER","FLD000000142",null,"Délai moyen de recouvrement des comptes clients  N-1",0,"if ([Rotation des comptes clients N-1]!==0)\nnecResult=365/[Rotation des comptes clients N-1];\nelse\nnecResult=0;"]
["*SERVER","*SERVER","FLD00000020",null,"Coût des ventes","(Case when [Groupe de comptes Code] = 'KPI_COGS' then \n[Solde] else 0 End)"]
["*SERVER","*SERVER","FLD00000093",null,"Coût des ventes  N-1","(Case when [Groupe de comptes Code] = 'KPI_COGS' then \n[Solde N-1] else 0 End)"]
["*SERVER","*SERVER","FLD000000149","Coût des ventes","12 mois glissants","(Case when [Groupe de comptes Code] = 'KPI_COGS' then \n[Solde Sommes (12 mois glissants)] else 0 End)"]
["*SERVER","*SERVER","FLD000000150","Coût des ventes N-1","12 mois glissants","(Case when [Groupe de comptes Code] = 'KPI_COGS' then \n[Solde Sommes (12 mois glissants) N-1] else 0 End)"]
["*SERVER","*SERVER","FLD00000021",null,"Stock","CASE\nWHEN\n[Groupe de comptes Code] = 'KPI_INVENTORY' \nTHEN\n\n[Solde de fermeture]\n\nELSE\n0\nEND"]
["*SERVER","*SERVER","FLD000000102",null,"Stock N-1","CASE\nWHEN\n[Groupe de comptes Code] = 'KPI_INVENTORY' \nTHEN\n\n[Solde de fermeture N-1]\n\nELSE\n0\nEND"]
["*SERVER","*SERVER","FLD000000133","Stock","12 mois glissants","(Case when [Groupe de comptes Code] = 'KPI_INVENTORY' then \n[Solde Sommes (12 mois glissants)] else 0 End)"]
["*SERVER","*SERVER","FLD000000134","Stock N-1","12 mois glissants","(Case when [Groupe de comptes Code] = 'KPI_INVENTORY' then \n[Solde Sommes (12 mois glissants) N-1] else 0 End)"]
["*SERVER","*SERVER","FLD00000022",null,"Comptes fournisseurs","-(CASE\nWHEN\n[Groupe de comptes Code] =  'KPI_ACCOUNTS_PAYABLE'\nTHEN\n\n[Solde de fermeture]\n\nELSE\n0\nEND)"]
["*SERVER","*SERVER","FLD00000097",null,"Comptes fournisseurs  N-1","-(CASE\nWHEN\n[Groupe de comptes Code] =  'KPI_ACCOUNTS_PAYABLE'\nTHEN\n\n[Solde de fermeture N-1]\n\nELSE\n0\nEND)"]
["*SERVER","*SERVER","FLD000000125","Comptes fournisseurs","12 mois glissants","-(Case when [Groupe de comptes Code] = 'KPI_ACCOUNTS_PAYABLE' then \n[Solde Sommes (12 mois glissants)] else 0 End)"]
["*SERVER","*SERVER","FLD000000126","Comptes fournisseurs  N1-1","12 mois glissants","-(Case when [Groupe de comptes Code] = 'KPI_ACCOUNTS_PAYABLE' then \n[Solde Sommes (12 mois glissants) N-1] else 0 End)"]
["*SERVER","*SERVER","FLD00000023","Solde","Stock","(Case\nwhen [Groupe de comptes Code] = 'KPI_INVENTORY'\nthen \n[Solde] else 0 End)"]
["*SERVER","*SERVER","FLD00000095","Solde","Stock N-1","Case \nwhen [Groupe de comptes Code] = 'KPI_INVENTORY'\nthen \n[Solde N-1] else 0 End"]
["*SERVER","*SERVER","FLD00000046",null,"Charges payées d’avance","CASE\nWHEN\n[Groupe de comptes Code] =  'KPI_PRE_PAID_EXPENSES'\nTHEN\n\n[Solde de fermeture]\n\nELSE\n0\nEND"]
["*SERVER","*SERVER","FLD00000045",null,"Charges payées d’avance  N-1","CASE\nWHEN\n[Groupe de comptes Code] =  'KPI_PRE_PAID_EXPENSES'\nTHEN\n\n[Solde de fermeture N-1]\n\nELSE\n0\nEND"]
["*SERVER","*SERVER","FLD00000024","Transactions","Comptes fournisseurs","-(Case when [Groupe de comptes Code] = 'KPI_ACCOUNTS_PAYABLE' \nthen [Solde] else 0 End)"]
["*SERVER","*SERVER","FLD00000096","Transactions","Comptes fournisseurs N-1","-(Case when [Groupe de comptes Code] = 'KPI_ACCOUNTS_PAYABLE'\nthen \n[Solde N-1] else 0 End)"]
["*SERVER","*SERVER","FLD00000025",null,"Rotation des comptes fournisseurs",0,"if ((([Comptes fournisseurs] -[Comptes fournisseurs 12 mois glissants])+ [Comptes fournisseurs])!==0)\nnecResult=([Coût des ventes 12 mois glissants] + [Stock 12 mois glissants])/ ((([Comptes fournisseurs] -[Comptes fournisseurs 12 mois glissants])+ [Comptes fournisseurs])/2);\nelse necResult=0;"]
["*SERVER","*SERVER","FLD00000094",null,"Rotation des comptes fournisseurs N-1",0,"if ((([Comptes fournisseurs  N-1] -[Comptes fournisseurs  N1-1 12 mois glissants])+ [Comptes fournisseurs])!==0)\nnecResult=([Coût des ventes N-1 12 mois glissants] + [Stock N-1 12 mois glissants])/ ((([Comptes fournisseurs  N-1] -[Comptes fournisseurs  N1-1 12 mois glissants])+ [Comptes fournisseurs  N-1])/2);\nelse necResult=0;"]
["*SERVER","*SERVER","FLD00000028",null,"Fonds de roulement","CASE\nWHEN\n([Groupe de comptes Code] = 'KPI_CURRENT_ASSET' or [Groupe de comptes Code] ='KPI_CURRENTLIABILITIES')\nTHEN\n\n[Solde de fermeture]\n\nELSE\n0\nEND"]
["*SERVER","*SERVER","FLD000000100",null,"Fonds de roulement N-1","CASE\nWHEN\n([Groupe de comptes Code] = 'KPI_CURRENT_ASSET' or [Groupe de comptes Code] ='KPI_CURRENTLIABILITIES')\nTHEN\n\n[Solde de fermeture N-1]\n\nELSE\n0\nEND"]
["*SERVER","*SERVER","FLD00000041","Ratio","Fonds de roulement",0,"if ([Passif courant]!==0)\nnecResult=[Actif circulant]/[Passif courant];\nelse necResult=0;"]
["*SERVER","*SERVER","FLD00000099","Ratio N-1","Fonds de roulement N-1",0,"if ([Passif courant N-1]!==0)\nnecResult=[Actif circulant N-1]/[Passif courant N-1];\nelse necResult=0;"]
["*SERVER","*SERVER","FLD00000042","Ratio","Fonds de roulement rapide",0,"if ([Passif courant]!==0)\nnecResult=([Actif circulant]-[Stock]-[Charges payées d’avance])/[Passif courant];\nelse necResult=0;"]
["*SERVER","*SERVER","FLD00000098","Ratio","Fonds de roulement rapide N-1",0,"if ([Passif courant N-1]!==0)\nnecResult=([Actif circulant N-1]-[Stock N-1] -[Charges payées d’avance  N-1])/[Passif courant N-1];\nelse necResult=0;"]
["*SERVER","*SERVER","FLD00000049","Ratio","d’exploitation (OER)",0,"if ([Ventes]!==0)\nnecResult=[Dépenses d’exploitation]/[Ventes];\nelse necResult=0;"]
["*SERVER","*SERVER","FLD000000101","Ratio","d’exploitation (OER)",0,"if ([Revenu N-1]!==0)\nnecResult=[Dépenses d’exploitation N-1]/[Revenu N-1];\nelse necResult=0;"]
["*SERVER","*SERVER","FLD000000103","Rotation","Fonds de roulement",0,"if ([Fonds de roulement]!==0)\nnecResult=[Revenu Somme 12 mois glissants]/[Fonds de roulement];\nelse necResult=0;"]
["*SERVER","*SERVER","FLD000000104","Rotation N-1","Fonds de roulement N-1",0,"if ([Fonds de roulement N-1]!==0)\nnecResult=[Revenu Somme 12 mois glissants N-1]/[Fonds de roulement N-1];\nelse necResult=0;"]
["*SERVER","*SERVER","FLD00000035",null,"Marge brute  %",0,"if ([Ventes]!==0)\nnecResult=[Marge brute]/[Ventes];\nelse necResult=0;"]
["*SERVER","*SERVER","FLD000000105",null,"Marge brute % N-1",0,"if ([Revenu N-1]!==0)\nnecResult=[Marge brute N-1]/[Revenu N-1];\nelse necResult=0;"]
["*SERVER","*SERVER","FLD00000038",null,"Marge brute","(Case when [Groupe de comptes Code] = 'KPI_SALES' then \n[Solde]*-1 else 0 End) -\n(Case when [Groupe de comptes Code] = 'KPI_COGS' then \n[Solde] else 0 End)"]
["*SERVER","*SERVER","FLD00000040",null,"Marge brute N-1","(Case when [Groupe de comptes Code] = 'KPI_SALES' then \n[Solde N-1]*-1 else 0 End) -\n(Case when [Groupe de comptes Code] = 'KPI_COGS' then \n[Solde N-1] else 0 End)"]
["UDM_FINANCE","UDM_FINANCE","INOUT",null,"Rentrés Sortie (Liquidité)"]
["UDM_FINANCE","UDM_FINANCE","POSTINGOUT",null,"Sorties (Liquidité)"]
["UDM_FINANCE","UDM_FINANCE","POSTINGIN",null,"Rentrés (Liquidité)"]
["UDM_FINANCE","UDM_FINANCE","ENDINGBALANCELY",null,"Solde de fermeture N-1"]
["*SERVER","*SERVER","FLD00000076","Rapport","Solde de fermeture","[Solde de fermeture] * UDM_MAP_REPCODE_REPORT.SIGN"]
["*SERVER","*SERVER","FLD00000075","Rapport","Solde de fermeture N-1","[Solde de fermeture N-1]* UDM_MAP_REPCODE_REPORT.SIGN"]
["UDM_FINANCE","UDM_FINANCE","TRANTYPE",null,"Type de transaction"]
["UDM_FINANCE","UDM_FINANCE","DOCNUM",null,"Numéro de document"]
["*SERVER","*SERVER","FLD00000047","Rapport","Solde","[Solde] * UDM_MAP_REPCODE_REPORT.SIGN"]
["*SERVER","*SERVER","FLD00000048","Rapport","Solde N-1","[Solde N-1] * UDM_MAP_REPCODE_REPORT.SIGN"]
["*SERVER","*SERVER","FLD000000169","Rapport","Solde variance","([Solde] * [Signe Rapport])-\n([Solde]LY * [Signe Rapport])"]
["*SERVER","*SERVER","FLD000000167","Rapport","Solde variance %",0,"if ([Rapport Solde N-1] !== 0)\n\nnecResult = [Rapport Solde variance] / [Rapport Solde N-1];\nelse \n\nnecResult = 0;"]
["UDM_FINANCE","UDM_FINANCE","DIMENSION1","Section analytique 01","Code"]
["UDM_FINANCE","UDM_FINANCE","DIMENSION2","Section analytique 02","Code"]
["UDM_FINANCE","UDM_FINANCE","DIMENSION3","Section analytique 03","Code"]
["UDM_FINANCE","UDM_FINANCE","DIMENSION4","Section analytique 04","Code"]
["UDM_FINANCE","UDM_FINANCE","DIMENSION5","Section analytique 05","Code"]
["UDM_FINANCE","UDM_FINANCE","DIMENSION6","Section analytique 06","Code"]
["UDM_FINANCE","UDM_FINANCE","DIMENSION7","Section analytique 07","Code"]
["UDM_FINANCE","UDM_FINANCE","DIMENSION8","Section analytique 08","Code"]
["UDM_FINANCE","UDM_FINANCE","DIMENSION9","Section analytique 09","Code"]
["UDM_FINANCE","UDM_FINANCE","DIMENSION10","Section analytique 10","Code"]
["UDM_FINANCE","UDM_FINANCE","DIMENSION11","Section analytique 11","Code"]
["UDM_FINANCE","UDM_FINANCE","DIMENSION12","Section analytique 12","Code"]
["UDM_FINANCE","UDM_FINANCE","DIMENSION13","Section analytique 13","Code"]
["UDM_FINANCE","UDM_FINANCE","DIMENSION14","Section analytique 14","Code"]
["UDM_FINANCE","UDM_FINANCE","DIMENSION15","Section analytique 15","Code"]
["UDM_FINANCE","UDM_FINANCE","DIMENSION16","Section analytique 16","Code"]
["UDM_FINANCE","UDM_FINANCE","DIMENSION17","Section analytique 17","Code"]
["UDM_FINANCE","UDM_FINANCE","DIMENSION18","Section analytique 18","Code"]
["UDM_FINANCE","UDM_FINANCE","DIMENSION19","Section analytique 19","Code"]
["UDM_FINANCE","UDM_FINANCE","DIMENSION20","Section analytique 20","Code"]
["UDM_DIMENSIONS","UDM_DIMENSIONS","DESCRIPTION","Section analytique 01","Desc"]
["UDM_DIMENSIONS_1","UDM_DIMENSIONS","DESCRIPTION","Section analytique 02","Desc"]
["UDM_DIMENSIONS_2","UDM_DIMENSIONS","DESCRIPTION","Section analytique 03","Desc"]
["UDM_DIMENSIONS_3","UDM_DIMENSIONS","DESCRIPTION","Section analytique 04","Desc"]
["UDM_DIMENSIONS_4","UDM_DIMENSIONS","DESCRIPTION","Section analytique 05","Desc"]
["UDM_DIMENSIONS_5","UDM_DIMENSIONS","DESCRIPTION","Section analytique 06","Desc"]
["UDM_DIMENSIONS_6","UDM_DIMENSIONS","DESCRIPTION","Section analytique 07","Desc"]
["UDM_DIMENSIONS_7","UDM_DIMENSIONS","DESCRIPTION","Section analytique 08","Desc"]
["UDM_DIMENSIONS_8","UDM_DIMENSIONS","DESCRIPTION","Section analytique 09","Desc"]
["UDM_DIMENSIONS_9","UDM_DIMENSIONS","DESCRIPTION","Section analytique 10","Desc"]
["UDM_DIMENSIONS_10","UDM_DIMENSIONS","DESCRIPTION","Section analytique 11","Desc"]
["UDM_DIMENSIONS_11","UDM_DIMENSIONS","DESCRIPTION","Section analytique 12","Desc"]
["UDM_DIMENSIONS_12","UDM_DIMENSIONS","DESCRIPTION","Section analytique 13","Desc"]
["UDM_DIMENSIONS_13","UDM_DIMENSIONS","DESCRIPTION","Section analytique 14","Desc"]
["UDM_DIMENSIONS_14","UDM_DIMENSIONS","DESCRIPTION","Section analytique 15","Desc"]
["UDM_DIMENSIONS_15","UDM_DIMENSIONS","DESCRIPTION","Section analytique 16","Desc"]
["UDM_DIMENSIONS_16","UDM_DIMENSIONS","DESCRIPTION","Section analytique 17","Desc"]
["UDM_DIMENSIONS_17","UDM_DIMENSIONS","DESCRIPTION","Section analytique 18","Desc"]
["UDM_DIMENSIONS_18","UDM_DIMENSIONS","DESCRIPTION","Section analytique 19","Desc"]
["UDM_DIMENSIONS_19","UDM_DIMENSIONS","DESCRIPTION","Section analytique 20","Desc"]
["UDM_FINANCE","UDM_FINANCE","LEDTYP",null,"Type de référentiel"]
["UDM_LEDTYP","UDM_LEDTYP","DESCRIPTION",null,"Type de référentiel desc"]
["UDM_FINANCE","UDM_FINANCE","BUDGET",null,"Budget"]
["*SERVER","*SERVER","FLD00000057","Budget","Montant","CASE WHEN [Budget] = '$$BUDGET'  THEN\n[Budget]AMOUNT\nELSE\n0\nEND"]
["*SERVER","*SERVER","FLD00000027","Budget","Solde de fermeture","CASE WHEN [Budget] = '$$BUDGET'  THEN\n[Budget Solde de fermeture (Excel)]\nELSE\n0\nEND"]
["UDM_FINANCE","UDM_FINANCE","BUDGETAMOUNT","Budget","Montant (Excel)"]
["UDM_FINANCE","UDM_FINANCE","BUDENDINGBALANCE","Budget","Solde de fermeture (Excel)","UDM_FINANCE.BUDENDINGBALANCE"]
["*SERVER","*SERVER","FLD00000073","Rapport","Budget","CASE WHEN [Budget] = '$$BUDGET'  THEN\n[Budget]AMOUNT * [Signe Rapport]\nELSE\n0\nEND"]
["*SERVER","*SERVER","FLD00000032","Rapport","Solde de fermeture Budget","CASE WHEN [Budget] = '$$BUDGET'  THEN\n[Budget Solde de fermeture (Excel)] * [Signe Rapport]\nELSE\n0\nEND"]
["*SERVER","*SERVER","FLD00000077","BudgetRéel","Montant","CASE \nWHEN [Période fiscale] < $$CURPER THEN \n[Solde]\nELSE\nCASE WHEN '$$BUDGET' = [Budget] THEN\n[Budget]AMOUNT\nELSE\n0\nEND\nEND"]
["*SERVER","*SERVER","FLD000000124","BudgetRéel","Rapport Solde","CASE \nWHEN  [Période fiscale] < $$CURPER\nTHEN [Solde] * [Signe Rapport]\n\nELSE\n\nCASE WHEN  [Budget] = '$$BUDGET'  \nTHEN [Budget]AMOUNT * [Signe Rapport]\nELSE\n0\nEND\n\nEND"]
["*SERVER","*SERVER","FLD00000080","BudgetRéel","Solde de fermeture","CASE WHEN [Période fiscale] < $$CURPER\nTHEN [Solde de fermeture]\n\nELSE\n\nCASE WHEN [Budget] = '$$BUDGET'\nTHEN [Budget Solde de fermeture (Excel)]\nELSE\n0\nEND\n\nEND"]
["*SERVER","*SERVER","FLD000000121","BudgetRéel","Revenus","CASE \nWHEN [Période fiscale] < $$CURPER\nTHEN (Case when [Groupe de comptes Code] = 'KPI_SALES' then [Solde]*-1 else 0 End)\n\nELSE CASE WHEN [Budget] = '$$BUDGET'  \n\nTHEN (Case when [Groupe de comptes Code] = 'KPI_SALES' then [Budget]AMOUNT*-1 else 0 End)\n\nELSE\n0\nEND\n\nEND"]
["*SERVER","*SERVER","FLD00000059","BudgetRéel","Bénéfice net","CASE \nWHEN [Période fiscale] < $$CURPER\nTHEN \n(Case when [Groupe de comptes Code] = 'KPI_SALES' then [Solde] * -1 else 0 End) -\n(Case when [Groupe de comptes Code] = 'KPI_COGS' then [Solde] else 0 End) - \n(Case when [Groupe de comptes Code] = 'KPI_EXPENSES' then [Solde] else 0 End)\n\n\nELSE\nCASE WHEN [Budget] = '$$BUDGET'  \n\nTHEN\n(Case when [Groupe de comptes Code] = 'KPI_SALES' then [Budget]AMOUNT * -1 else 0 End) -\n(Case when [Groupe de comptes Code] = 'KPI_COGS' then [Budget]AMOUNT else 0 End) - \n(Case when [Groupe de comptes Code] = 'KPI_EXPENSES' then [Budget]AMOUNT else 0 End)\n\nELSE\n0\nEND\n\nEND"]
["*SERVER","*SERVER","FLD000000123","BudgetRéel","Marge nette",0,"if ([BudgetRéel Revenus] !== 0)\nnecResult=[BudgetRéel Bénéfice net]/[BudgetRéel Revenus];\nelse\nnecResult=0;"]
["*SERVER","*SERVER","FLD000000120","BudgetRéel","BAIIDA","CASE \nWHEN  [Période fiscale] < $$CURPER\n\nTHEN \nCASE\nWHEN [Période fiscale] <> 0 THEN\n((Case when [Groupe de comptes Code] = 'KPI_SALES' then [Solde]*-1 else 0 End) -\n(Case when [Groupe de comptes Code] = 'KPI_COGS' then [Solde] else 0 End) - \n(Case when [Groupe de comptes Code] = 'KPI_OPERATING_EXPENSES' then [Solde] else 0 End)) +\n(Case when [Groupe de comptes Code] = 'KPI_AMORTIZATION' then [Solde] else 0 End)\nELSE\n0\nEND\n\n\nELSE CASE WHEN [Budget] = '$$BUDGET'  \n\nTHEN\nCASE\nWHEN [Période fiscale] <> 0 THEN\n((Case when [Groupe de comptes Code] = 'KPI_SALES' then [Budget]AMOUNT*-1 else 0 End) -\n(Case when [Groupe de comptes Code] = 'KPI_COGS' then [Budget]AMOUNT else 0 End) - \n(Case when [Groupe de comptes Code] = 'KPI_OPERATING_EXPENSES' then [Budget]AMOUNT else 0 End)) +\n(Case when [Groupe de comptes Code] = 'KPI_AMORTIZATION' then [Budget]AMOUNT else 0 End)\nELSE\n0\nEND\n\n\nEND\n\nEND"]
["*SERVER","*SERVER","FLD000000122","BudgetRéel","BAIIDA Marge",0,"if ([BudgetRéel Revenus] !== 0)\nnecResult=[BudgetRéel BAIIDA]/[BudgetRéel Revenus];\nelse\nnecResult=0;"]
["UDM_FINANCE","UDM_FINANCE","ROLLING12","Solde","Sommes (12 mois glissants)"]
["UDM_FINANCE","UDM_FINANCE","ROLLING12LY","Solde","Sommes (12 mois glissants) N-1"]
["*SERVER","*SERVER","FLD000000160","Rapport","Solde sommes (12 mois glissants)","[Solde Sommes (12 mois glissants)] * UDM_MAP_REPCODE_REPORT.SIGN"]
["*SERVER","*SERVER","FLD000000161","Rapport","Solde sommes (12 mois glissants) N-1","[Solde Sommes (12 mois glissants) N-1] * UDM_MAP_REPCODE_REPORT.SIGN"]
["*SERVER","*SERVER","FLD000000165","Rapport","Solde sommes (12 mois glissants) variance","([Solde Sommes (12 mois glissants)] * [Signe Rapport])-\n([Solde Sommes (12 mois glissants)]LY * [Signe Rapport])"]
["*SERVER","*SERVER","FLD000000164","Rapport","Solde sommes (12 mois glissants) variance %",0,"if ([Rapport Solde sommes (12 mois glissants) N-1] !== 0)\n\nnecResult = [Rapport Solde sommes (12 mois glissants) variance] / [Rapport Solde sommes (12 mois glissants) N-1];\nelse \n\nnecResult = 0;"]
["UDM_FINANCE","UDM_FINANCE","GLOBALCURRENCY",null,"Devise de référence"]
["*SERVER","*SERVER","FLD000000157",null,"Devise de référence PP","$$GLOBALCURR'"]
["UDM_MAP_REPCODE_REPORT","UDM_MAP_REPCODE_REPORT","GROUP01ORDER","Niveau de rapport 1","Tri"]
["UDM_MAP_REPCODE_REPORT","UDM_MAP_REPCODE_REPORT","GROUP01","Niveau de rapport 1","Description"]
["UDM_MAP_REPCODE_REPORT","UDM_MAP_REPCODE_REPORT","GROUP02ORDER","Niveau de rapport 2","Tri"]
["UDM_MAP_REPCODE_REPORT","UDM_MAP_REPCODE_REPORT","GROUP02","Niveau de rapport 2","Description"]
["UDM_MAP_REPCODE_REPORT","UDM_MAP_REPCODE_REPORT","GROUP03ORDER","Niveau de rapport 3","Tri"]
["UDM_MAP_REPCODE_REPORT","UDM_MAP_REPCODE_REPORT","GROUP03","Niveau de rapport 3","Description"]
["UDM_MAP_REPCODE_REPORT","UDM_MAP_REPCODE_REPORT","REPORTCODE","Rapport","Code"]
["UDM_ACCT_TO_ACCGROUP","UDM_ACCT_TO_ACCGROUP","ACCOUNTGRP","Groupe de comptes","Code"]
["UDM_ACCOUNTS","UDM_ACCOUNTS","ACCTUDF01","Compte CDU 01","Code"]
["UDM_ACCOUNTS","UDM_ACCOUNTS","ACCTUDF01DESC","Compte CDU 01","Desc"]
["UDM_ACCOUNTS","UDM_ACCOUNTS","ACCTUDF02","Compte CDU 02","Code"]
["UDM_ACCOUNTS","UDM_ACCOUNTS","ACCTUDF02DESC","Compte CDU 02","Desc"]
["UDM_ACCOUNTS","UDM_ACCOUNTS","ACCTUDF03","Compte CDU 03","Code"]
["UDM_ACCOUNTS","UDM_ACCOUNTS","ACCTUDF03DESC","Compte CDU 03","Desc"]
["UDM_ACCOUNTS","UDM_ACCOUNTS","ACCTUDF04","Compte CDU 04","Code"]
["UDM_ACCOUNTS","UDM_ACCOUNTS","ACCTUDF04DESC","Compte CDU 04","Desc"]
["UDM_ACCOUNTS","UDM_ACCOUNTS","ACCTUDF05","Compte CDU 05","Code"]
["UDM_ACCOUNTS","UDM_ACCOUNTS","ACCTUDF05DESC","Compte CDU 05","Desc"]
["UDM_ACCOUNTS","UDM_ACCOUNTS","ACCTUDF06","Compte CDU 06","Code"]
["UDM_ACCOUNTS","UDM_ACCOUNTS","ACCTUDF06DESC","Compte CDU 06","Desc"]
["UDM_ACCOUNTS","UDM_ACCOUNTS","ACCTUDF07","Compte CDU 07","Code"]
["UDM_ACCOUNTS","UDM_ACCOUNTS","ACCTUDF07DESC","Compte CDU 07","Desc"]
["UDM_ACCOUNTS","UDM_ACCOUNTS","ACCTUDF08","Compte CDU 08","Code"]
["UDM_ACCOUNTS","UDM_ACCOUNTS","ACCTUDF08DESC","Compte CDU 08","Desc"]
["UDM_ACCOUNTS","UDM_ACCOUNTS","ACCTUDF09","Compte CDU 09","Code"]
["UDM_ACCOUNTS","UDM_ACCOUNTS","ACCTUDF09DESC","Compte CDU 09","Desc"]
["UDM_ACCOUNTS","UDM_ACCOUNTS","ACCTUDF10","Compte CDU 10","Code"]
["UDM_ACCOUNTS","UDM_ACCOUNTS","ACCTUDF10DESC","Compte CDU 10","Desc"]
["UDM_DIMSUBACCOUNTS","UDM_DIMSUBACCOUNTS","SEGMENT01","Segment 01","Code"]
["UDM_DIMSUBACCOUNTS","UDM_DIMSUBACCOUNTS","SEGMENT01DESC","Segment 01","Desc"]
["UDM_DIMSUBACCOUNTS","UDM_DIMSUBACCOUNTS","SEGMENT02","Segment 02","Code"]
["UDM_DIMSUBACCOUNTS","UDM_DIMSUBACCOUNTS","SEGMENT02DESC","Segment 02","Desc"]
["UDM_DIMSUBACCOUNTS","UDM_DIMSUBACCOUNTS","SEGMENT03","Segment 03","Code"]
["UDM_DIMSUBACCOUNTS","UDM_DIMSUBACCOUNTS","SEGMENT03DESC","Segment 03","Desc"]
["UDM_DIMSUBACCOUNTS","UDM_DIMSUBACCOUNTS","SEGMENT04","Segment 04","Code"]
["UDM_DIMSUBACCOUNTS","UDM_DIMSUBACCOUNTS","SEGMENT04DESC","Segment 04","Desc"]
["UDM_DIMSUBACCOUNTS","UDM_DIMSUBACCOUNTS","SEGMENT05","Segment 05","Code"]
["UDM_DIMSUBACCOUNTS","UDM_DIMSUBACCOUNTS","SEGMENT05DESC","Segment 05","Desc"]
["UDM_DIMSUBACCOUNTS","UDM_DIMSUBACCOUNTS","SEGMENT06","Segment 06","Code"]
["UDM_DIMSUBACCOUNTS","UDM_DIMSUBACCOUNTS","SEGMENT06DESC","Segment 06","Desc"]
["UDM_DIMSUBACCOUNTS","UDM_DIMSUBACCOUNTS","SEGMENT07","Segment 07","Code"]
["UDM_DIMSUBACCOUNTS","UDM_DIMSUBACCOUNTS","SEGMENT07DESC","Segment 07","Desc"]
["UDM_DIMSUBACCOUNTS","UDM_DIMSUBACCOUNTS","SEGMENT08","Segment 08","Code"]
["UDM_DIMSUBACCOUNTS","UDM_DIMSUBACCOUNTS","SEGMENT08DESC","Segment 08","Desc"]
["UDM_DIMSUBACCOUNTS","UDM_DIMSUBACCOUNTS","SEGMENT09","Segment 09","Code"]
["UDM_DIMSUBACCOUNTS","UDM_DIMSUBACCOUNTS","SEGMENT09DESC","Segment 09","Desc"]
["UDM_DIMSUBACCOUNTS","UDM_DIMSUBACCOUNTS","SEGMENT10","Segment 10","Code"]
["UDM_DIMSUBACCOUNTS","UDM_DIMSUBACCOUNTS","SEGMENT10DESC","Segment 10","Desc"]
["UDM_DIMSUBACCOUNTS","UDM_DIMSUBACCOUNTS","PYRAMIDID",null,"ID de la pyramide"]
["UDM_MAP_REPCODE_REPORT","UDM_MAP_REPCODE_REPORT","SIGN","Signe","Rapport"]