A250

Routine Capital
Input 1 workflow

Properties source
Sources: prospetto

Code
A250
Description
Routine Capital
Web opening
NV
Type flags
Input
Groups
A25 Capital Expenditure Planning

Structure source
Sources: prospetto_xml

Form parameters
3
▾
Dimension Hierarchy Parameter
AZIENDA
Entity;fr=Entité 		› 010
All Entities 		› $AZI_010_P
SCENARIO
Scenario 		› $
Scenarios 		› SCE_BDG
Scenario for Budget
DEST1
Cost Centers;fr=Centre cout 		› 010
Departmental View 		› CC_ALL
Cost Center
Form filters
5 dims
▾
AZIENDAEntity;fr=Entité 1
▾
Hierarchy / FST Item Type TGKML
010 All Entities › $AZI_010_P param
DEST2Products;fr=Produit 1
▾
Hierarchy / FST Item Type TGKML
010 Products by Category › PD_500 Generic Product fixed
DEST4Employees;fr=Employés 1
▾
Hierarchy / FST Item Type TGKML
100 Total Workforce › EE_500 Generic Employee fixed
SCENARIOScenario 1
▾
Hierarchy / FST Item Type TGKML
$ Scenarios › SCE_BDG param
DEST1Cost Centers;fr=Centre cout 1
▾
Hierarchy / FST Item Type TGKML
010 Departmental View › CC_ALL param
Routine Capital
Template00 · 5 matrices
▾
Asset Class Recap CPM
▾
Filters
CONTOAccount;fr=Compte 1
▾
Hierarchy / FST Item Type TGKML
$ Account - Default view › ST_100 Purchase Price fixed
DEST5Miscellaneous;it=Miscellaneous 1
▾
Hierarchy / FST Item Type TGKML
— › NA NA fixed
TIP 1
▾
Hierarchy / FST Item Type TGKML
— › TIP_O fixed
CATEGORIACategory 1
▾
Hierarchy / FST Item Type TGKML
— › 010 Original Data fixed
LUNPER 1
▾
LUN_0
Rows
DEST3Customers;fr=Clients 1
▾
Hierarchy / FST Item Type TGKML
500 Asset Classes › ALL fixed
Cols
PERIODOPeriod 12
▾
01, 02, 03, 04, 05, 06, 07, 08, 09, 10, 11, 12
Asset Class Calculations CPM
▾
Filters
LUNPER 1
▾
LUN_1
CONTOAccount;fr=Compte 1
▾
Hierarchy / FST Item Type TGKML
$ Account - Default view › ST_100 Purchase Price fixed
DEST5Miscellaneous;it=Miscellaneous 1
▾
Hierarchy / FST Item Type TGKML
— › NA NA fixed
TIP 1
▾
Hierarchy / FST Item Type TGKML
— › TIP_O fixed
CATEGORIACategory 1
▾
Hierarchy / FST Item Type TGKML
— › 010 Original Data fixed
Rows
DEST3Customers;fr=Clients 1
▾
Hierarchy / FST Item Type TGKML
500 Asset Classes › ALL fixed
Cols
PERIODOPeriod 12
▾
01, 02, 03, 04, 05, 06, 07, 08, 09, 10, 11, 12
PL Depreciation Allocations CPM
▾
Filters
DEST5Miscellaneous;it=Miscellaneous 1
▾
Hierarchy / FST Item Type TGKML
— › NA NA fixed
TIP 1
▾
Hierarchy / FST Item Type TGKML
— › TIP_O fixed
CATEGORIACategory 2
▾
Hierarchy / FST Item Type TGKML
— › 010 Original Data fixed
— › $AMOUNT System Generated Category fixed
LUNPER 1
▾
LUN_1
Rows
DEST3Customers;fr=Clients 1
▾
Hierarchy / FST Item Type TGKML
500 Asset Classes › ALL fixed
CONTOAccount;fr=Compte 1
▾
Hierarchy / FST Item Type TGKML
010 All Accounts - BS, PL & Statistical Accounts › 510 fixed
Cols
PERIODOPeriod 12
▾
01, 02, 03, 04, 05, 06, 07, 08, 09, 10, 11, 12
BS Depreciation Allocations CPM
▾
Filters
DEST5Miscellaneous;it=Miscellaneous 1
▾
Hierarchy / FST Item Type TGKML
— › NA NA fixed
TIP 1
▾
Hierarchy / FST Item Type TGKML
— › TIP_O fixed
CATEGORIACategory 2
▾
Hierarchy / FST Item Type TGKML
— › 010 Original Data fixed
— › $AMOUNT System Generated Category fixed
LUNPER 1
▾
LUN_0
Rows
DEST3Customers;fr=Clients 1
▾
Hierarchy / FST Item Type TGKML
500 Asset Classes › ALL fixed
CONTOAccount;fr=Compte 1
▾
Hierarchy / FST Item Type TGKML
010 All Accounts - BS, PL & Statistical Accounts › 720 fixed
Cols
PERIODOPeriod 12
▾
01, 02, 03, 04, 05, 06, 07, 08, 09, 10, 11, 12
New Asset Additions CPM
▾
Filters
LUNPER 1
▾
LUN_1
CONTOAccount;fr=Compte 1
▾
Hierarchy / FST Item Type TGKML
$ Account - Default view › ST_100 Purchase Price fixed
DEST3Customers;fr=Clients 1
▾
Hierarchy / FST Item Type TGKML
500 Asset Classes › CM_500 Generic Customer fixed
CATEGORIACategory 1
▾
Hierarchy / FST Item Type TGKML
— › 010 Original Data fixed
Rows
DEST5Miscellaneous;it=Miscellaneous 10
▾
Hierarchy / FST Item Type TGKML
LI_10 Line Item Details › LI_010 1 fixed
LI_10 Line Item Details › LI_015 2 fixed
LI_10 Line Item Details › LI_020 3 fixed
LI_10 Line Item Details › LI_025 4 fixed
LI_10 Line Item Details › LI_030 5 fixed
LI_10 Line Item Details › LI_035 6 fixed
LI_10 Line Item Details › LI_040 7 fixed
LI_10 Line Item Details › LI_045 8 fixed
LI_10 Line Item Details › LI_050 9 fixed
LI_10 Line Item Details › LI_055 10 fixed
Cols
TIP 2
▾
Hierarchy / FST Item Type TGKML
— › TIP_DES fixed
— › TIP_O fixed
PERIODOPeriod 12
▾
12, 11, 01, 02, 03, 04, 05, 06, 07, 08, 09, 10

Queries 1 source
Sources: prospetto_xml

Asset Class Validation
SQL ASSET_CLASSES
▾ 
SELECT DESC_DEST30 FROM DEST3 WHERE COD_DEST3 IN(SELECT COD_DEST3

as CODE FROM DEST3_GERARCHIA_ABBI

WHERE COD_DEST3_GERARCHIA = '500'

AND COD_DEST3_ELEGER = 'ALL')

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

Workflow Phase Task list Task description
BDG Annual Budget Workflow 40_OP Expense Plan OPX Opex Detail Complete Capex Plan