Configuring the export settings
Note: Clicking Default resets the property to the system
default value.
To configure the export settings for SSC:
- Open Configuration Manager (CGM).
- Select SSC > Export.
-
Configure the system settings:
- Columns to Sort By
- Specify the sort order for the table, for example, ACCNT_CODE, PERIOD, TRANS_DATETIME, JRNAL_NO, JRNAL_LINE.
- Exclude Empty or Null Values in Export
- Select Yes to exclude empty or null values from the output payload. Select No to ensure exact copies of data, for example, for internal transfers. The default value is Yes and must only be set to No with caution as some empty tags can have an unforeseen effect during import.
- Format generated XML
- Set to Yes to format generated XML with tabs. The default value is No.
- Max Rows in a Export
- Specify the maximum number of rows that can be retrieved from the database during an export. The default value is 0.
- Number of Rows Pre-fetched
- Specify the number of rows for prefetching. This value is used by CDR when exporting from the database. It is also used to tune the performance of the export driver. The default value is 200.
- Save your changes.