This panel displays all the fields in the file that have been activated for data base audit management. The Logging column denotes whether or not logging is active for the field. You can enter individual ones in the table, or click Select all fields to activate all for logging. If one field should be activated, but another field should be displayed for identification when making enquiries or printing log lists, you can select the second field for identification without logging it.
Function keys
| Select all fields | Select all fields for logging. |
Selection fields
DB audit – fields table maintenance (JRND0033)
On this panel you maintain field definitions and add new fields that should be activated for data base audit management.
Function keys
| Select fields | Only valid for new entries. View a listing of all fields in the file from which you select the one(s) to activate. |
- Field name
- This field is used only for new entries. Enter the name of the field for which data base audit management shall be active, or transfer a field from the listing displayed when clicking Select fields.
- Description
- The description for the field will automatically be retrieved when a field name is entered. The description can be changed.
- Logging
- Set this field to YES if logging shall be activated for this field. A field can be entered in this table to be activated later, or if it shall only be used for identification for another field which is being logged.
- Identity sequence
- If this field shall be used for identifying changes that are made for other fields in this file, you can enter a sequence number. When making enquiries, or printing the log list, this field is used as a key to identify the item for which the change was made. At least one sequence number must be entered.
DB audit – edit type maintenance (JRND0034)
If the selected field shall be edited according to any of the edit types displayed, when making enquiries or printing the log list, set the selected edit type to YES. If, e.g., a date is not edited according to the date format in the Language table, it will be displayed and printed in the format used in the file from where it is retrieved.
- Date
- Set to YES if the selected field is a date, and shall be edited according to the date format in the Language table.
- Delivery date
- Set to YES if the selected field is a delivery date, and shall be edited according to the delivery date format in the Language table.
- INACTIVE
- Set to YES if the selected field is the code for INACTIVE, and shall be edited according to the code in the Language table.
- MAND/OPT/NOT ALLOWED
- Set to YES if the selected field is the code for MANDATORY, OPTIONAL or NOT ALLOWED, and shall be edited according to the codes in the Language table.
- DEBIT/CREDIT
- Set to YES if the selected field is the code for DEBIT or CREDIT, and shall be edited according to the codes in the Language table.
- BALANCE/TRADE ACCT
- Set to YES if the selected field is the code for BALANCE ACCOUNT or TRADE ACCOUNT, and shall be edited according to the codes in the Language table.
- AMOUNT/QTY/CURR/COST
- Set to YES if the selected field is the code for AMOUNT, QUANTITY, CURRENCY or COST VALUE, and shall be edited according to the codes in the Language table.
- HIGH/MEDIUM/LOW
- Set to YES if the selected field is the code for HIGH, MEDIUM or LOW, and shall be edited according to the codes in the Language table.
- DAY/WEEK/MONTH/YEAR
- Set to YES if the selected field is the code for DAY, WEEK, MONTH or YEAR, and shall be edited according to the codes in the Language table.
- Exchange rate time
- Set to YES if the selected field is the exchange rate time, and shall be edited according to the date, week, month or year format used in your system.
- YES/NO
- Set to YES if the selected field is YES or NO, and shall be edited according to the codes in the Language table.