| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | EINRI | Institution | nvarchar | 4 | 0 | CHAR | (N' ') | No | TN01 | EINRI | Allow NULL? |
| 3 | PZIFF | IS-H: Patient Check Digit Control | char | 1 | 0 | CHAR | (N' ') | Yes | | PZIFFKZ | Allow NULL? |
| 4 | FZIFF | IS-H: Case Check Digit Control | char | 1 | 0 | CHAR | (N' ') | Yes | | FZIFFKZ | Allow NULL? |
| 5 | WANDER | IS-H: Check Against Bad Dept Party File | char | 1 | 0 | CHAR | (N' ') | Yes | | WANDERKZ | Allow NULL? |
| 6 | DOPPL | IS-H: Check if Patient Already Exists in Database | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_DOPPL | Allow NULL? |
| 7 | HCMAC | IS-HCM: Automatic Message Dispatch Active | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_HCMACT | Allow NULL? |
| 8 | VCARD | IS-H: HC Smart Card Import Active | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_VCARD | Allow NULL? |
| 9 | SONDER | IS-H: Characters Excluded at Name Entry | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | ISH_SONDNM | Allow NULL? |
| 10 | NGROS | IS-H: Patient Names with Initial Caps | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_NGROSS | Allow NULL? |
| 11 | HCM301AC | IS-H: Electronic Data Interchange is Active | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_301ACT | Allow NULL? |
| 12 | AUTORFSH | Indicator: Refresh Case List Automatically | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_AUTORFSH | Allow NULL? |
| 13 | NEHC | Indicator for Patient Merge with Card Data | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_NEHC | Allow NULL? |
