sp592_audit_reason_op_config
- Jason Andrew
Owned by Jason Andrew
Oct 02, 2024
1 min read
Loading data...
This table is part of the solutions that provides the ability for users to record reason codes and notes for fixed jobs.
Â
Table Definition
Field | Type | Default | Nullable |
|---|---|---|---|
| operation_no | number(3) | Â |  |
| fru_no | number | Â |  |
| allow_audit | number(1) | Â | |
| require_code | number(1) | Â | |
| require_comment | number(1) | Â | |
Keys
foreign key (operation_no) references SP591_audit_reason_ops (operation_no)Â
foreign key (fru_no) references SP058_responsibility_units (resp_unit_no)
Column Descriptions
| Field | Description |
|---|---|
| operation_no | Operation number. |
| fru_no | Optional FRU number. |
| allow_audit | Allow audit to take place for the given operation. |
| require_code | Ensure a code is provided during auditing. |
| require_comment | Ensure a comment is provided during auditing. |