| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
---|
| 1 | MANDT | IS-H: Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | RI_MANDT | Allow NULL? |
| 2 | KEYFIL | IS-H: Key of Table TN00 | char | 1 | 0 | CHAR | (N' ') | No | | ISH_KEYFIL | Allow NULL? |
| 3 | MANID | IS-H: Identification Valid for Whole Client (all Insts.) | char | 1 | 0 | CHAR | (N' ') | Yes | | MANID | Allow NULL? |
| 4 | MODULO | IS-H: Coding of Modulo Method for Check Digit | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | ISH_MODULO | Allow NULL? |
| 5 | SONDER | IS-H: Special Characters Excluded from Search Fields | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | ISH_SONDER | Allow NULL? |
| 6 | ISHMED | IS-H: Indicator that IS-H*MED Is Active | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_MEDACT | Allow NULL? |
| 7 | SPHON | IS-H: Phonetic Search Active Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_SPHONA | Allow NULL? |
| 8 | NOVAL | IS-H: Special Character for BI - No Field Transfer | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_NOVAL | Allow NULL? |
| 9 | CVERS | IS-H: IS-H Country Version | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TNCTY | ISH_COUNTRY | Allow NULL? |
| 10 | PSEUDO | Indicator 'Pseudonymization Is Active in IS-H' | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_PS_ACTIVE | Allow NULL? |
| 11 | EXPIRY_DAYS | Days for expiry of logs | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | ISH_RAL_EXP_DAYS | Allow NULL? |
| 12 | XIJAUT | Merge Authorization for Client | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_CROSS_INST_JAUTH | Allow NULL? |
| 13 | TREAT_CAT_DT | Time-Dependent Services per Treatment Category Active | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_TREAT_CAT_DT | Allow NULL? |
| 14 | LONG_PAT_ADR | Long Fields for Patient/Patient Address Active | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_LONG_NPAT_NADR | Allow NULL? |
| 15 | EXTFIELDS_ACTIVE | Additional Fields Active | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_EXT_FIELDS_ACTIVE | Allow NULL? |