Displaying and Naming Additional Verifier Columns: Oracle - 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 an Oracle database, from the SQL*Plus or ORACLE Management Console, in your BIC database, execute any of the following commands.

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