Batch Files for Consolidation Reports
The definitions for the consolidation reports are no longer part of the meta data automatically delivered by IDL since release 2010.1. Since then the table for "Voucher classifications / consolidation functions" (CNSFNC) contains no data for consolidation reports in newly installed databases. The corresponding column options had been renamed from '#CNSFNC', '#KVAGE' and '#KVAMB' into '$CNSFNC', '$KVAGE' or '$KVAMB', respectively, by the release migration program 2010.1.
This LieferBatch directory serves for the purpose to provide the formerly generally valid column allocations of the consolidation functions and the column options for new users, too. This standard was based on the following column allocations:
- reserved
- reserved
- reserved
- reserved
- GC
- CF
- CC
- Without allocation
- KS
- TC
- EF
- EU
- IE
- CD
- ZA
- ZU
- TX
- Without allocation
- JM
- M0
- M1
- M2
- M3
- M4
- M5
- M6
- M7
- M8
- M9
- TU
- MC
- FR
- QR
The data are provided in the Excel file KVA_SPO.xlsm with references for IDL.XLSLINK. The data are split into several sheets of this file, one for each database table:
- CNSFNC- Consolidation functions
- SPO - Report column options
- REPCLCDSC - Report column descriptions
- FED - Column formula lines
The first sheet of the file is titled "General" and contains some central specifications on which the formulae of the following sheets refer. These are:
- the name of the database (default name is "IDLDB")
- the keys of the languages of the provided descriptions
- a unique valid-from period for all master data (default is "12.2012")
Please replace the specifications for database and valid-from period by the values applying for you or desired by you, respectively. The language keys can be replaced by an invalid key ('XXX' e.g.) if descriptions in the respective language are not wanted. You receive corresponding error messages at export then.