B300
Pro-forma P&L
Properties Sources: prospetto
- Code
B300- Description
- Pro-forma P&L
- Web opening
NV- Type flags
- Input
- Groups
- B3
Structure
Sources: prospetto_xml
Form parameters
3
▾
Form filters
2 dims
▾
Flash P&L
Template00 · 6 matrices
Sales
CPM
EE Expenses
CPM
Overhead
CPM
Intra Month TB
CPM
OH Drivers
CPM
Filters
PERIODO
1
Allocation Details
Template01 · 0 matrices
Queries 1
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
Sources: RACCOLTA_AZIENDA_WFM, WFM task list
| Workflow | Phase | Task list | Task description |
|---|---|---|---|
SFT
|
1 |
1 |
Manage Flash Close |