Configuring the export settings

注意：Clicking 「Default」 resets the property to the system default value.

To configure the export settings for SSC:

1. Open 「Configuration Manager (CGM)」.
2. Select 「SSC」 > 「Export」.
3. 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」.

4. Save your changes.