Depending on the general ledger data being exported, G/L Consolidations creates between two and six files. These files are generated and copied to the export directory specified for the export process on the G/L Consol Export Setup screen. The same files are saved to an archive directory in the source company.
Archive Folder for Exports
Exported files are saved to an archive folder on the server, based on the date of the export.
Archival exports are saved within the installation path in the following folder:
\Company\CompanyID\ZCexport (where CompanyID represents the source company).
The program saves the exported records in a subfolder named YYYY-MM-DD (where YYYY represents the year, MM the month, and DD the day of the export).
If you export more than once on the same day, later exports are archived to the same folder, with newer exports added to the earlier file list.
Note: Exported data remains permanently in this folder, and should be deleted regularly.
File Naming Convention
G/L Consolidations creates unique file names for exported files, using eight characters for the file name and three characters for the file extension, as follows:
- The first four characters of the file name are reserved for the unit ID (this is unique for each source company).
Example: UNIT_ _ _ _ . _ _ _
- The next four characters of the file name are reserved for the export sequence number. The export sequence number is incremented each time general ledger data is exported from the source company (no matter which export process is used). It ranges from 0001 to 9999. For more information, see G/L Consol. Import Screen.
Example: UNIT0001._ _ _
-
The three-character file extension identifies the type of data in the export file.
Extension Data Type Description ZCC Control File This file is generated for each export and contains information about the export. This file must also be present in the import directory for any of the files listed below to be imported. The following files are created for each type of data in the export:
Extension Data Type Description 001 Transactions Summary account data or posted transactions by fiscal period or by posting sequence. ACT Accounts Exported G/L accounts, including account optional fields. AGP Account Groups Exported account groups. BDG Budgets Exported budgets. CSF CS Optional Fields Optional fields exported from Common Services Optional Fields setup. OFD G/L Optional Fields Optional fields exported from G/L Optional Fields setup. SEG Segment Codes Exported G/L segment codes. SRC Source Codes Exported G/L source codes.