14.1 sp592_audit_reason_op_config
- Billy Sewell (Unlicensed)
Owned by Billy Sewell (Unlicensed)
Jan 26, 2024
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. |