Displaying and Naming Additional Verifier Columns: SQL Server - Brainware Intelligent Capture - Foundation 23.1 - Foundation 23.1 - Brainware - external

Brainware Intelligent Capture Installation
Platform
Brainware
Product
Brainware Intelligent Capture
Release
Foundation 23.1
License

To display additional Verifier columns from a SQL database, in Microsoft SQL Server Management Studio, in your BIC database, modify and execute any of the following commands.

  • External group ID
    exec sp_SetGlobalApplicationSetting 'SysAppBatchColumnExternalGroupId', '[Column header name, for example User Group]', True
  • External batch ID
    exec sp_SetGlobalApplicationSetting 'SysAppBatchColumnExternalBatchId', '[Column header name, for example Batch Group]', True
  • Transaction ID
    exec sp_SetGlobalApplicationSetting 'SysAppBatchColumnTransactionId', '[Column header name, for example Transaction]', True
  • Transaction type
    exec sp_SetGlobalApplicationSetting 'SysAppBatchColumnTransactionType', '[Column header name, for example Transaction Type]', True