B300

Pro-forma P&L
Input 1 workflow

Properties source
Sources: prospetto

Code
B300
Description
Pro-forma P&L
Web opening
NV
Type flags
Input
Groups
B3 Soft Close & Reporting

Structure source
Sources: prospetto_xml

Form parameters
3
Dimension Hierarchy Parameter
PERIODO
Period
$PER_P
AZIENDA
Entity;fr=Entité
010
All Entities
03
Choose an Entity
SCENARIO
Scenario
$
Scenarios
SCE_SFT
Scenario for Soft Close
Form filters
2 dims
AZIENDAEntity;fr=Entité 1
Hierarchy / FST Item Type TGKML
010 All Entities 03 param
SCENARIOScenario 1
Hierarchy / FST Item Type TGKML
$ Scenarios SCE_SFT param
Flash P&L
Template00 · 6 matrices
Sales CPM
Rows
CONTOAccount;fr=Compte 1
Hierarchy / FST Item Type TGKML
010 Income Statement - Management View 020 TOTAL NET SALES fixed
DEST2Products;fr=Produit 1
Hierarchy / FST Item Type TGKML
010 Products by Category 010 fixed
Cols
PERIODOPeriod 1
$PER_P
CATEGORIACategory 2
Hierarchy / FST Item Type TGKML
200 Fast Close Allocations fixed
010 Original Data fixed
EE Expenses CPM
Rows
CONTOAccount;fr=Compte 1
Hierarchy / FST Item Type TGKML
010 Income Statement - Management View 050 TOTAL EE EXPENSES fixed
DEST4Employees;fr=Employés 1
Hierarchy / FST Item Type TGKML
| fixed
Cols
PERIODOPeriod 1
$PER_P
CATEGORIACategory 1
Hierarchy / FST Item Type TGKML
200 Fast Close Allocations fixed
Overhead CPM
Rows
CONTOAccount;fr=Compte 1
Hierarchy / FST Item Type TGKML
010 Income Statement - Management View 085 TOTAL OVERHEAD EXPENSES fixed
DEST1Cost Centers;fr=Centre cout 1
Hierarchy / FST Item Type TGKML
| fixed
Cols
PERIODOPeriod 1
$PER_P
CATEGORIACategory 2
Hierarchy / FST Item Type TGKML
200 Fast Close Allocations fixed
010 Original Data fixed
Intra Month TB CPM
Filters
CATEGORIACategory 1
Hierarchy / FST Item Type TGKML
010 Original Data fixed
Rows
CONTOAccount;fr=Compte 4
Hierarchy / FST Item Type TGKML
010 Income Statement - Management View 020 TOTAL NET SALES fixed
010 Income Statement - Management View 025 Cost of Goods Sold fixed
010 Income Statement - Management View 050 TOTAL EE EXPENSES fixed
010 Income Statement - Management View 085 TOTAL OVERHEAD EXPENSES fixed
Cols
PERIODOPeriod 1
$PER_P
OH Drivers CPM
Filters
PERIODOPeriod 1
$PER_P
DEST2Products;fr=Produit 1
Hierarchy / FST Item Type TGKML
PD_500 Generic Product fixed
DEST3Customers;fr=Clients 1
Hierarchy / FST Item Type TGKML
CM_500 Generic Customer fixed
DEST4Employees;fr=Employés 1
Hierarchy / FST Item Type TGKML
EE_500 Generic Employee fixed
DEST5Miscellaneous;it=Miscellaneous 1
Hierarchy / FST Item Type TGKML
NA NA fixed
CATEGORIACategory 1
Hierarchy / FST Item Type TGKML
010 Original Data fixed
Rows
CONTOAccount;fr=Compte 2
Hierarchy / FST Item Type TGKML
010 All Accounts - BS, PL & Statistical Accounts ST_970 Square Footage fixed
010 All Accounts - BS, PL & Statistical Accounts ST_980 # of Contracts fixed
Cols
DEST1Cost Centers;fr=Centre cout 1
Hierarchy / FST Item Type TGKML
010 Departmental View ALL fixed
Cost of Sales CPM
Rows
CONTOAccount;fr=Compte 1
Hierarchy / FST Item Type TGKML
010 Income Statement - Management View 025 Cost of Goods Sold fixed
DEST2Products;fr=Produit 1
Hierarchy / FST Item Type TGKML
| fixed
Cols
PERIODOPeriod 1
$PER_P
CATEGORIACategory 2
Hierarchy / FST Item Type TGKML
200 Fast Close Allocations fixed
010 Original Data fixed
Allocation Details
Template01 · 0 matrices

Queries 1 source
Sources: prospetto_xml

Allocation Drill Through
SQL Query00
select cod_conto as "Account", cod_dest1 as "Cost Center", importo as "Amount", Conto_prov as "Sender Account", dest1_prov as "Sender Cost Center", NUMERATORE as "Numerator", DENOMINATORE as "Denominator", userupd as "User", dateupd as "Date"from CL_DATI_MOVIMENTO
where cod_regola_versione ='020'
and cod_regola = '15'

and cod_scenario = ${$Scenario.code}
and cod_periodo = ${$Period.code}
and cod_conto = ${$Account.code}
and cod_dest1 = ${$Cust_Dim1.code}

Used in Workflows 1 source
Sources: RACCOLTA_AZIENDA_WFM, WFM task list

Workflow Phase Task list Task description
SFT Soft Close Workflow 1 Soft Close Prepatation 1 Soft Close Task List Manage Flash Close