In the Procedure the data - readers which load the Consolidation
Trial Balances use the "Current Selection" Option that means
Data can be loaded only on Selected Items.The Batch Data Loading Screen is basically a Data Loading Procedure based on a set of predefined Data Reader Protocols and related ASCII files that can be used to load the Application Settings and Measure Types
The following pre-Package data-readers are provided :
| Data Reader Name | Asci File Name | Ascii File Track (TAB separator) | Comment |
| account_H | TreeD022.csv | Code0000100000D022Account Desc0000200000D022Account Code0000300000D020Account Category Desc0000400000D020Account Category Code0000500000D021Statement Desc0000600000D021Statement Code0000700000D023Movement Group (Acc) Desc0000800000D023Movement Group (Acc) Code0000900000D025Tech Acc for Select Desc0001000000D025Tech Acc for Select Code0001100000D014Movement Group Total (Acc) Desc0001200000D014Movement Group Total (Acc) Code0001300000D051Custom 1 Group (Acc) Desc0001400000D051Custom 1 Group (Acc) Code0001500000D050Custom 2 Group (Acc) Desc0001600000D050Custom 2 Group (Acc) Code0001700000D024Investment Cost Group (Acc) Desc0001800000D024Investment Cost Group (Acc) |
It loads the Chart of Account and mandatory attributes |
| account_f_leaf | V0030001.csv | Code0000100000D022Account 0000200000V003F Leaf (Y/N) |
Boolean Counter that identifies the Leaf Account |
| account_f_input | V0040001.csv | Code0000100000D022Account 0000200000V004F Input Value (Y/N) |
Boolean Counter that identifies the Input Account |
| account_f_input_details | V0050001.csv | Code0000100000D022Account 0000200000V005F Input Requires Details (Y/N) |
Boolean Counter that identifies the Movement Account |
| account_f_IC_oth | V0060001.csv | Code0000100000D022Account 0000200000V006F I/C and Others (Y/N) |
Boolean Counter that identifies the IC and 3P Account |
| account_f_IC | V0070001.csv | Code0000100000D022Account 0000200000V007F I/C Strictly (Y/N) |
Boolean Counter that identifies the IC Account |
| account_inv_rule | V1470001.csv | Code0000100000D022Account 0000200000V147S Investement Rule Account |
Boolean Counter that identifies the those Accounts which TB must be eliminated during the Elimination of Investment Step |
| account_res_rule | V1560001.csv | Code0000100000D022Account 0000200000V156S Reserve Rule Account |
Boolean Counter that identifies the those Accounts which TB must be eliminated during the Elimination of Reserve Step |
| account_div_rule | V1660001.csv | Code0000100000D022Account 0000200000V166S Dividend Rule Account |
Boolean Counter that identifies the those Accounts which TB must be eliminated during the Elimination of Dividend Step |
| account_IC_f_cd_rule | V2100001.csv | Code0000100000D022Account 0000200000V210S IC Rule Account (Financial Credit/Debit) |
Boolean Counter that identifies the those Accounts which TB must be eliminated during the Elimination of IC Step |
| account_IC_f_re_rule | V2130001.csv | Code0000100000D022Account 0000200000V213S IC Rule Account (Financial Revenue/Expenses) |
Boolean Counter that identifies the those Accounts which TB must be eliminated during the Elimination of IC Step |
| account_IC_o_cd_rule | V2140001.csv | Code0000100000D022Account 0000200000V214S IC Rule Account (Operation Credit/Debit) |
Boolean Counter that identifies the those Accounts which TB must be eliminated during the Elimination of IC Step |
| account_IC_o_re_rule | V2150001.csv | Code0000100000D022Account 0000200000V215S IC Rule Account (Operation Revenue/Expenses) |
Boolean Counter that identifies the those Accounts which TB must be eliminated during the Elimination of IC Step |
| account_f_clo_rate | V0330001.csv | Code0000100000D022Account 0000200000V033F Closing Rate |
Boolean Counter that identifies the Account translated at Closing Rate |
| account_f_avg_rate | V0350001.csv | Code0000100000D022Account 0000200000V035F Average Rate |
Boolean Counter that identifies the Account translated at Closing Rate |
| account_f_his_rate | V0340001.csv | Code0000100000D022Account 0000200000V034F Historical Rate |
Boolean Counter that identifies the Account translated at His Rate |
| account_no_mon_rate | V0360001.csv | Code0000100000D022Account 0000200000V036F No Monetary |
Boolean Counter that identifies the Account that are not translated |
| reporting_unit_H | TreeD013.csv | Code0000100000D013Reporting Unit Desc0000200000D013Reporting Unit Code0000300000D011Intercompany Party (Y/N) Desc0000400000D011Intercompany Party (Y/N) Code0000500000D017Currency Desc0000600000D017Currency |
RU
attributes :
> IC Party is a boolean counter that identifies those RUs that are in scope also as IC Parties > Currency identifies the Local RU Currency |
| intercompany_H | TreeD018.csv | Code0000100000D018IC and Related Parties Desc0000200000D018IC and Related Parties Code0000300000D019Intra Group Party (Y/N) Desc0000400000D019Intra Group Party (Y/N) Code0000500000D028Total IG Desc0000600000D028Total IG |
IC
attributes :
> Intra Group Party is a boolean counter that identifies those ICs that are in scope also as RUs (e.g. Customers are false) > Total IG is a Tech dimension : it must be IG for All |
| ownership_% | V1790001.csv | Code0000100000D013Reporting Unit Code0000200000D048Reporting Unit [R] Code0000300000D036Scenario Date0000400000A001Month 0000500000V179Ownerships (input) |
%s
of Ownership of the in Scope RUs :
> RUs codes must be consistent with the Hierarchy codes > Scenario Codes must be consistent with the Scenario codes > Month codes must be provided in yyyymm format > ownerships must be provided in numeric double precision format |
| x_clo_rate | V0520001.csv | Code0000100000D012Node Currency Code0000200000D017Currency Code0000300000D036Scenario Date0000400000A001Month 0000500000V052S X-Rate (Closing) |
Translation
Closing Rates
> Currency codes must be consistent with the Currency codes > Scenario Codes must be consistent with the Scenario codes > Month codes must be provided in yyyymm format > rates must be provided in numeric double precision format |
| x_avg_rate | V0540001.csv | Code0000100000D012Node Currency Code0000200000D017Currency Code0000300000D036Scenario Date0000400000A001Month 0000500000V054S X-Rate (Average) |
Translation
Average Rates
> Currency codes must be consistent with the Currency codes > Scenario Codes must be consistent with the Scenario codes > Month codes must be provided in yyyymm format > rates must be provided in numeric double precision format |
| conso_value_data_load | V0010001.csv | Code0000100000D022Account Code0000200000D013Reporting Unit Code0000300000D016Consolidation Node Code0000400000D018IC and Related Parties Code0000500000D030Investment Cost Code0000600000D031Custom 1 Code0000700000D039Custom 2 Code0000800000D036Scenario Code0000900000D034Movement Code0001000000D035Layer Date0001100000A001Month 0001200000V001Conso Layer Value |
RU
Trial Balances :
> all the dimension codes must be consistent with previous coding Attention : > Consolidation Node code must be '99' > if IC code is not available it is by default '3P' > if investment cost code is not available it is by default '_' > if Custom 1 code is not available it is by default '_' > if Custom 2 code is not available it is by default '_' > Scenario code must be 'ACT' (for Actuals, any for others) > if movement code is not available it is by default 'CLO' : Closing Movement must be anyway provided > Layer code must be 'L01' > Month codes must be provided in yyyymm format > TBs must be provided - in numeric double precision format - with proper sign (Negative for Credit, Positive for Debit) - P&L Profit must NOT be provided |
| conso_value_at_his_rate | V1280001.csv | Code0000100000D022Account Code0000200000D013Reporting Unit Code0000300000D018IC and Related Parties Code0000400000D030Investment Cost Code0000500000D031Custom 1 Code0000600000D039Custom 2 Code0000700000D012Node Currency Code0000800000D036Scenario Code0000900000D034Movement Code0001000000D035Layer Date0001100000A001Month 0001200000V128Conso Value (L1 at Group Currency for HIS Rate Accounts) |
RU Trial at His Rate Please see above. |
| adj_value_credit | V1420001.csv | Code0000100000D029Adjustment Number Code0000200000D022Account Code0000300000D013Reporting Unit Code0000400000D016Consolidation Node Code0000500000D018IC and Related Parties Code0000600000D030Investment Cost Code0000700000D031Custom 1 Code0000800000D039Custom 2 Code0000900000D036Scenario Code0001000000D034Movement Code0001100000D035Layer Date0001200000A001Month 0001300000V142Conso Adjustment (credit) |
Adjusment
(Credit) Trial Balances
Please see above. Attention : > CLO Movement must NOT be provided > TBs must be provided - in numeric double precision format - with proper sign (Negative for Credit, Positive for Debit) - P&L Profit must NOT be provided |
| adj_value_debit | V1430001.csv | Code0000100000D029Adjustment Number Code0000200000D022Account Code0000300000D013Reporting Unit Code0000400000D016Consolidation Node Code0000500000D018IC and Related Parties Code0000600000D030Investment Cost Code0000700000D031Custom 1 Code0000800000D039Custom 2 Code0000900000D036Scenario Code0001000000D034Movement Code0001100000D035Layer Date0001200000A001Month 0001300000V143Conso Adjustment (debit) |
Adjusment
(Debit) Trial Balances
Please see above. Attention : > CLO Movement must NOT be provided > TBs must be provided - in numeric double precision format - with proper sign (Negative for Credit, Positive for Debit) - P&L Profit must NOT be provided |
| conso_value_L01_document_registration_currency | V0670001.csv | Code0000100000D043Transaction Document/Currency Code0000200000D022Account Code0000300000D013Reporting Unit Code0000400000D016Consolidation Node Code0000500000D018IC and Related Parties Code0000600000D030Investment Cost Code0000700000D031Custom 1 Code0000800000D039Custom 2 Code0000900000D036Scenario Code0001000000D034Movement Code0001100000D035Layer Date0001200000A001Month 0001300000V009Conso Layer Value for I/C Matching at Transaction Document (Local Currency) |
It loads the L01 CN=99 Balances at Transaction Document Level by Registration Currency |
| conso_value_L01_document_local_currency.csv | V0090001.csv | Code0000100000D043Transaction Document/Currency Code0000200000D022Account Code0000300000D013Reporting Unit Code0000400000D016Consolidation Node Code0000500000D018IC and Related Parties Code0000600000D030Investment Cost Code0000700000D031Custom 1 Code0000800000D039Custom 2 Code0000900000D036Scenario Code0001000000D034Movement Code0001100000D035Layer Date0001200000A001Month 0001300000V067Conso Layer Value for I/C Matching at Transaction Document |
It loads the L01 CN=99 Balances at Transaction Document Level by Local Currency |
The ASCII files must be CSV type with Tab Separators. They must be located in the Folder %conso%\batch_loading\ .
Ideally with such specs you can in advance prepare all the data set which are required for the full loading and mandatory configuration of the Application.
This Layer only facilitates the Data Loading : it can't replace an accurate activity of data validation and the execution of all the procedure which must be run along all the steps of the Application and Scenario configuration.
In the Procedure the data - readers which load the Consolidation
Trial Balances use the "Current Selection" Option that means
Data can be loaded only on Selected Items.
This prevents the data-reader to delete manual data entry or adjustment that have been posted on that Scenario and Period.
For the Selection Logics and how these twist the Procedure behavior please have a look at Logics of the Flow of Data
Change the Selection if this doesn't fit your scenario.