B200

Consolidated BS, IS, CF
Input 1 workflow

Properties source
Sources: prospetto

Code
B200
Description
Consolidated BS, IS, CF
Web opening
NV
Type flags
Input
Groups
B2 Consolidated Statements

Structure source
Sources: prospetto_xml

Form parameters
2
▾
Dimension Hierarchy Parameter
SCENARIO
Scenario 		› $
Scenarios 		› SCE_CON
Consolidated Scenario
PERIODO
Period 		› — › $PER_P
Form filters
2 dims
▾
PERIODOPeriod 1
▾
$PER_P
SCENARIOScenario 1
▾
Hierarchy / FST Item Type TGKML
$ Scenarios › SCE_CON param
Cash Flow
Template02 · 1 matrix
▾
Cons. CashFlow CPM
▾
Filters
TIP 1
▾
Hierarchy / FST Item Type TGKML
— › TIP_CV fixed
DEST1Cost Centers;fr=Centre cout 1
▾
Hierarchy / FST Item Type TGKML
010 Departmental View › 010 fixed
AZIENDAEntity;fr=Entité 1
▾
Hierarchy / FST Item Type TGKML
010 All Entities › 010 fixed
DEST2Products;fr=Produit 1
▾
Hierarchy / FST Item Type TGKML
010 Products by Category › 010 fixed
Rows
CONTOAccount;fr=Compte 1
▾
Hierarchy / FST Item Type TGKML
— › 030 fixed
Cols
CATEGORIACategory 7
▾
Hierarchy / FST Item Type TGKML
$ Categories › 021 fixed
$ Categories › 022 Allocation to Customers and Products fixed
$ Categories › 080 IC Elimination fixed
$ Categories › 031 fixed
$ Categories › 090 Minority Interest fixed
$ Categories › 095 Dividends fixed
$ Categories › 097 Profit in Stock Elimination fixed
Income Statement
Template00 · 1 matrix
▾
Cons. Statements CPM
▾
Filters
DEST2Products;fr=Produit 1
▾
Hierarchy / FST Item Type TGKML
010 Products by Category › 010 fixed
DEST1Cost Centers;fr=Centre cout 1
▾
Hierarchy / FST Item Type TGKML
010 Departmental View › 010 fixed
DEST3Customers;fr=Clients 1
▾
Hierarchy / FST Item Type TGKML
— › | fixed
DEST4Employees;fr=Employés 1
▾
Hierarchy / FST Item Type TGKML
— › | fixed
TIP 1
▾
Hierarchy / FST Item Type TGKML
— › TIP_CV fixed
Rows
CONTOAccount;fr=Compte 24
▾
Hierarchy / FST Item Type TGKML
010 Income Statement - Management View › 010 Sales Revenue fixed
010 Income Statement - Management View › 015 Discounts & Promotions fixed
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 › 030 GROSS MARGIN fixed
010 Income Statement - Management View › 035 Wages & Salary fixed
010 Income Statement - Management View › 040 Payroll Taxes fixed
010 Income Statement - Management View › 045 EE Benefits fixed
010 Income Statement - Management View › 050 TOTAL EE EXPENSES fixed
010 Income Statement - Management View › 055 General & Administrative Expenses fixed
010 Income Statement - Management View › 060 Marketing Expenses fixed
010 Income Statement - Management View › 065 Travel Expenses fixed
010 Income Statement - Management View › 070 Training & Staffing fixed
010 Income Statement - Management View › 075 External Services fixed
010 Income Statement - Management View › 080 Depreciation & Amortization fixed
010 Income Statement - Management View › 085 TOTAL OVERHEAD EXPENSES fixed
010 Income Statement - Management View › 090 TOTAL OPERATING EXPENSES fixed
010 Income Statement - Management View › 095 OPERATING INCOME fixed
010 Income Statement - Management View › 100 Other Expense/Income fixed
010 Income Statement - Management View › 105 EARNINGS BEFORE TAXES fixed
010 Income Statement - Management View › 110 Income Taxes fixed
010 Income Statement - Management View › 111 NET INCOME/LOSS Before NCI fixed
010 Income Statement - Management View › 112 NCI Net Income fixed
010 Income Statement - Management View › 115 NET INCOME/LOSS fixed
Cols
CATEGORIACategory 7
▾
Hierarchy / FST Item Type TGKML
$ Categories › 021 fixed
$ Categories › 022 Allocation to Customers and Products fixed
$ Categories › 080 IC Elimination fixed
$ Categories › 031 fixed
$ Categories › 090 Minority Interest fixed
$ Categories › 095 Dividends fixed
$ Categories › 097 Profit in Stock Elimination fixed
AZIENDAEntity;fr=Entité 1
▾
Hierarchy / FST Item Type TGKML
010 All Entities › 010 fixed
Balance Sheet
Template01 · 1 matrix
▾
Matrix00 CPM
▾
Filters
DEST2Products;fr=Produit 1
▾
Hierarchy / FST Item Type TGKML
010 Products by Category › 010 fixed
DEST1Cost Centers;fr=Centre cout 1
▾
Hierarchy / FST Item Type TGKML
010 Departmental View › 010 fixed
DEST3Customers;fr=Clients 1
▾
Hierarchy / FST Item Type TGKML
— › | fixed
DEST4Employees;fr=Employés 1
▾
Hierarchy / FST Item Type TGKML
— › | fixed
AZIENDAEntity;fr=Entité 1
▾
Hierarchy / FST Item Type TGKML
010 All Entities › 010 fixed
TIP 1
▾
Hierarchy / FST Item Type TGKML
— › TIP_CV fixed
Rows
CONTOAccount;fr=Compte 18
▾
Hierarchy / FST Item Type TGKML
020 Balance Sheet › 010 ASSETS fixed
020 Balance Sheet › 015 Current Assets fixed
020 Balance Sheet › 020 Tangible Assets fixed
020 Balance Sheet › 025 Intangible Assets fixed
020 Balance Sheet › 030 Depreciation & Amortization fixed
020 Balance Sheet › 035 TOTAL ASSETS fixed
020 Balance Sheet › 040 LIABILITIES fixed
020 Balance Sheet › 045 Current Liabilities fixed
020 Balance Sheet › 050 Long Term Liabilities fixed
020 Balance Sheet › 055 TOTAL LIABILITIES fixed
020 Balance Sheet › 060 EQUITY fixed
020 Balance Sheet › 065 Common Stock fixed
020 Balance Sheet › 070 OCI fixed
020 Balance Sheet › 075 Retained Earnings fixed
020 Balance Sheet › 080 Current Year results fixed
020 Balance Sheet › 083 Non Controlling Interest fixed
020 Balance Sheet › 085 TOTAL EQUITY fixed
020 Balance Sheet › 090 TOTAL LIABILITIES & EQUITY fixed
Cols
CATEGORIACategory 7
▾
Hierarchy / FST Item Type TGKML
$ Categories › 021 fixed
$ Categories › 022 Allocation to Customers and Products fixed
$ Categories › 080 IC Elimination fixed
$ Categories › 031 fixed
$ Categories › 090 Minority Interest fixed
$ Categories › 095 Dividends fixed
$ Categories › 097 Profit in Stock Elimination fixed

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

Workflow Phase Task list Task description
ACT Close & Consolidation Workflow 006 Consolidation Journals 06 Consolidation Journals Consolidated Statements