Displaying and Naming Additional Verifier Columns: Oracle - Brainware Intelligent Capture - Foundation 23.1 - Foundation 23.1 - Brainware - external - Brainware/Brainware-Intelligent-Capture/Foundation-23.1/Brainware-Intelligent-Capture-Installation/Web-Verifier-Configuration/Additional-Columns-in-Verifier-or-Web-Verifier/Displaying-and-Naming-Additional-Verifier-Columns-Oracle - 2025-05-05 - 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.

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)