Export application parameters

This table shows the export application parameters that can be configured and implemented using Infor SAT.

Parameter Name Description
documentExport.completedRetentionPeriod (parm_id = 3038501) Use this parameter to determine the number of days after which completed (status of 4) export documents are purged from the export tables.

The default value is 30 days.

No dependencies

Is Customer Editable

documentExport.CR.checkErrorsFirst (parm_id = 3083554) This parameter is used by the CRExportVerifyBkg background process. If you wish to have errors processed before successful verifications, set this parameter to 1 instead of 0. You may do this separately for each supported application. This is application specific parameter for TP.

The default value is 0.

Is Customer Editable

documentExport.CR.maxHeadersPerSearch (parm_id = 3083555) This parameter is used by the CRExportVerifyBkg background process. It controls how many headers to process before going back to search again. This affects:
  • Must be <= 1000 due to an Oracle requirement
  • More headers means fewer searches which means fewer queries, which means better performance
  • More headers means more data in memory, which means more memory required.

The default value is 750.

Is Customer Editable

documentExport.CR.maxSuccessfulPerSweep (parm_id = 3083556) This parameter is used by the CRExportVerifyBkg background process. If checkErrorsFirst is set to 1, maxSuccessfulPerSweep will cause the validator to stop processing after a designated number of successful verifications and start over with error verifications. The same thing occurs when it gets to maxHeadersPerSearch.

The default value is 0.

Is Customer Editable

documentExport.CR.maxSuccessfulPerSweep (parm_id = 3083556) This parameter is used by the CRExportVerifyBkg background process. If checkErrorsFirst is set to 1, maxSuccessfulPerSweep will cause the validator to stop processing after a designated number of successful verifications and start over with error verifications. The same thing occurs when it gets to maxHeadersPerSearch.

The default value is 0.

Is Customer Editable

documentExport.ER.checkErrorsFirst (parm_id = 3081905) This parameter is used by the ERExportVerifyBkg background process. If you wish process errors (non payment) before successful verifications, set this parameter to 1. You may do this separately for each supported application. This parameter is for Infor ER.

The default value is 0.

Is Customer Editable

documentExport.ER.checkErrorsFirst (parm_id = 3081905) This parameter is used by the ERExportVerifyBkg background process. If you wish to have errors (non-payments) processed before successful verifications, set this parameter to 1 instead of 0. You may do this separately for each supported application. This is application specific parameter for Infor ER.

The default value is 0.

Is Customer Editable

documentExport.ER.maxHeadersPerSearch (parm_id = 3081906)

This parameter is used by the ERExportVerifyBkg background process. It controls how many headers to process before going back to search again. This affects:

  • Must be <= 1000 due to an Oracle requirement
  • More headers means fewer searches which means fewer queries, which means better performance
  • More headers means more data in memory, which means more memory required.

The default value is 750.

Is Customer Editable

documentExport.ER.maxSuccessfulPerSweep (parm_id = 3081907) This parameter is used by the ERExportVerifyBkg background process. If checkErrorsFirst is set to 1, maxSuccessfulPerSweep will cause the validator to stop processing after a designated number of successful verifications and start over with error verifications. The same thing occurs when it gets to maxHeadersPerSearch.

The default value is 0.

Is Customer Editable

documentExport.ER.maxSuccessfulPerSweep (parm_id = 3081907) This parameter is used by the ERExportVerifyBkg background process. If the checkErrorsFirst parameter is set to 1, maxSuccessfulPerSweep will cause the validator to stop processing after a specified number of successful verifications and start over with error verifications. The same thing occurs for the maxHeadersPerSearch parameter.

The default value is 0.

Is Customer Editable

documentExport.errorRetentionPeriod (parm_id = 3038502) Use this parameter to determine the number of days after which (status of 3 or 5) export documents with errors are purged from the export tables.

The default value is 45 days.

No dependencies

Is Customer Editable

documentExport.inactiveRetentionPeriod (parm_id = 3038503) Use this parameter to determine the number of days after which inactive (status other than 3, 4, or 5) export documents are purged from the export tables.

The default value is 365 days.

No dependencies

Is Customer Editable

documentExport.Locale (parm_id = 3136850) Use this parameter to set the locale in Export function, the exported String key data will be translated with the language you set in this value.

The default value is en. (English)

Dependent on the i18n.localeList application parameter

Is Customer Editable

documentExport.purgeCR (parm_id = 3083550) This parameter is used by the ERExportVerifyBkg background process. It controls how many headers to process before going back to search again. This affects:
  • Must be <= 1000 due to an Oracle requirement
  • More headers means fewer searches which means fewer queries, which means better performance
  • More headers means more data in memory, which means more memory required.

The default value is 750.

Is Customer Editable

documentExport.purgeER (parm_id = 3038504) This parameter activates the flag for purging exported expense reports. Valid values are:
  • true: Purge exported ERs (default)
  • false: Do not purge exported ERs

No dependencies

Is Customer Editable

documentExport.purgePR (parm_id = 3038507) This parameter activates the flag for purging exported payment requests. Valid values are:
  • true: Purge exported PRs (default)
  • false: Do not purge exported PRs

No dependencies

Is Customer Editable

documentExport.purgeTP (parm_id = 3038505)
  • true: Purge exported ERs (default)
  • false: Do not purge exported ERs
This parameter activates the flag for purging exported travel plans. Valid values are:
  • true: Purge exported TPs (default)
  • false: Do not purge exported TPs

No dependencies

Is Customer Editable

documentExport.purgeTS (parm_id = 3038506) This parameter activates the flag for purging exported timesheets. Valid values are:
  • true: Purge exported Timesheets (default)
  • false: Do not purge exported Timesheets

No dependencies

Is Customer Editable

documentExport.TP.checkErrorsFirst (parm_id = 3083551) This parameter is used by the TPExportVerifyBkg background process. If you wish to have errors processed before successful verifications, set this parameter to 1 instead of 0. You may do this separately for each supported application. This is application specific parameter for Infor TP.

The default value is 0.

Is Customer Editable

documentExport.TP.maxHeadersPerSearch (parm_id = 3083552) This parameter is used by the TPExportVerifyBkg background process. It controls how many headers to process before going back to search again. This affects:
  • Must be <= 1000 due to an Oracle requirement
  • More headers means fewer searches which means fewer queries, which means better performance
  • More headers means more data in memory, which means more memory required.

The default value is 750.

Is Customer Editable

documentExport.TP.maxSuccessfulPerSweep (parm_id = 3083553)

This parameter is used by the TPExportVerifyBkg background process. If checkErrorsFirst is set to 1, maxSuccessfulPerSweep will cause the validator to stop processing after a designated number of successful verifications and start over with error verifications. The same thing occurs when it gets to maxHeadersPerSearch.

The default value is 0.

Is Customer Editable

documentExport.TSExportExceptionTransitionName (parm_id = 78133) This is the workflow transition name to which you route the Timesheet Export Exception. Default is TS Export Exception. Is Not Customer Editable
documentExport.TSExportLevel (parm_id = 78134) Use this parameter to specify the export level for Timesheets. Valid values are:
  • 0: Document level
  • 1: Line item level (default)

No dependencies

Is Not Customer Editable

documentExport.TSExportLevel (parm_id = 78134) This is the export level for Timesheets. Valid values are:
  • 0: Document level
  • 1: Line item level (default)

Is Not Customer Editable

documentExport.TSExportVerifyClass (parm_id = 78132) Use this parameter to specify the class name of the Timesheet Export Verification background process.

The alts_line_item attendance columns have been added to alts_export_line so that this data is available for export, and TSStagingExportBkg can be updated accordingly. After a timesheet’s line items are exported to an external HR system, the application does not allow these line items to be edited. However depending on the documentExport.TSExportLevel application parameter setting, the document is either exported as a whole or its line items are exported individually, in which case the exported line items cannot be modified but new line items can still be added. To keep things simple, the HTML client assumes that the documentExport.TSExportLevel application parameter has been set to 0 (EXPORT_DOCUMENT_LEVEL), so if the user tries to open a document in create mode containing exported line items a fatal error is thrown to alert the user to update their procedures.

The default value is largesoft.documentExport.tsexport.TSStaging ExportVerifier.

No dependencies

Is Not Customer Editable

documentExport.TSExportVerifyClass (parm_id = 78132) This is the class name of the Timesheet Export Verification Process.

The default value is largesoft.documentExport.tsexport.TSStagingExportVerifier.

Is Not Customer Editable

exportFileLocation (parm_id = 3139151) Use this parameter to specify the base location for downloaded data files where the background process can then retrieve them for processing. Is Customer Editable
pagingExport.formats (parm_id = 3146241) Use this parameter to define a comma (,) separated string of the export file formats. For example, excel,csv.

The default is excel. The csv format can be optional.

Is Customer Editable

pagingExport.enabled (parm_id = 3146242) If this parameter is set to true, the paging export feature is enabled.

Is Customer Editable

The default is true.

exportFileReplacementDelimiter parm_id = 3151685 This parameter is used as a replacement if the delimiter already exists in the export file. By default this value is 'null' where the existing delimiter is escaped. Other values include 'SPACE' where the delimiter is replaced with a white-space (' '), alternatively any other valid ASCII character can also be defined for example #,%,$.