| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
---|
| 1 | DETAILNO | Link between master and detail result table | int | 10 | 0 | INT4 | ((0)) | No | | CKDETAILLN | Allow NULL? |
| 2 | PARAM | Informix/OS parameter name (to check): LTXHWM, ... | nvarchar | 50 | 0 | CHAR | (N' ') | No | | CHECKPARAM | Allow NULL? |
| 3 | PERFORMANC | Performance check or not ('Y'/'N') ? | char | 1 | 0 | CHAR | (N' ') | No | | CKPERFORMA | Allow NULL? |
| 4 | CKDETAILNO | (Serial) detail number of logical check (LTXHWM: 1 & 2) | smallint | 5 | 0 | INT2 | ((0)) | No | | CKDETAILNO | |
| 5 | ONCFGFLAG | Check tool: got param from oncfg table or file | char | 1 | 0 | CHAR | (N' ') | No | | CKONCFGFL | Allow NULL? |
| 6 | OCLASS | Origin class of parameter: 'ONCONFIG','OS',... | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | CHCKOCLASS | Allow NULL? |
| 7 | SEVERITY | Check severity: 'A'...abort, 'E'...error, 'W'...warning | char | 1 | 0 | CHAR | (N' ') | Yes | | CKSEVERITY | Allow NULL? |
| 8 | CHECKOP | Check operator: '=','!=','<','>','<=','>=' or 'D' -> dynamic | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | CHECKOP | Allow NULL? |
| 9 | CHECKVAL | Absolute check value or 'D' (-> dynamic check) | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | CHECKVAL | Allow NULL? |
| 10 | ACTVAL | Actual (absolute) value (found by infcfgcheck) | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | CKACTVAL | Allow NULL? |
| 11 | BYTEUNIT | Byte unit of check value: T...tera, G...giga, M...mega, ... | char | 1 | 0 | CHAR | (N' ') | Yes | | CKBYTEUNIT | Allow NULL? |
| 12 | MODTIME | Modification (or inserting) timestamp (YYYYMMDDHHMMSS) | nvarchar | 14 | 0 | CHAR | (N' ') | Yes | | CKMODTIME | Allow NULL? |
| 13 | MODUSER | Normal SAP User or Special User '#SAP#' | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | CKMODUSER | Allow NULL? |
| 14 | MSGTEXT | Detail message text for check | nvarchar | 80 | 0 | CHAR | (N' ') | Yes | | CKMSGTEXTD | Allow NULL? |