| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Mandant | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | EINRI | IS-H: Einrichtung | nvarchar | 4 | 0 | CHAR | (N' ') | No | TN01 | EINRI | Allow NULL? |
| 3 | SPEM | Geisteskrankheit fachrichtung | nvarchar | 4 | 0 | CHAR | (N' ') | No | * | ISH_NL_GGZ_SPEM | Allow NULL? |
| 4 | PROD_GRP | IS-H NL: Produkt kode | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | ISH_NL_PRDCODE | Allow NULL? |
| 5 | ENDDT | ISH_NL: Ende datum | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | ISH_NL_DBC_ENDDT | Allow NULL? |
| 6 | BEGDT | ISH_NL: Anfang datum | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ISH_NL_DBC_BEGDT | Allow NULL? |
| 7 | STAY_CODE | Geisteskrankheit productkode aufenthalt | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | ISH_NL_GGZ_STAY_CODE | Allow NULL? |
| 8 | STAY_TEXT | Geisteskrankheit productkode aufenthalt beschreibung | nvarchar | 255 | 0 | CHAR | (N' ') | Yes | | ISH_NL_GGZ_STAY_TXT | Allow NULL? |
| 9 | TREAT_CODE | Geisteskrankheit productkode behandlung | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | ISH_NL_GGZ_TRTM_CODE | Allow NULL? |
| 10 | TREAT_TEXT | Geisteskrankheit productkode behandlung beschreibung | nvarchar | 255 | 0 | CHAR | (N' ') | Yes | | ISH_NL_GGZ_TRTM_TXT | Allow NULL? |
| 11 | TYPE_CODE | Geisteskrankheit productkode type | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | ISH_NL_GGZ_TYPE_CODE | Allow NULL? |
| 12 | TYPE_TEXT | Geisteskrankheit productkode type beschreibung | nvarchar | 255 | 0 | CHAR | (N' ') | Yes | | ISH_NL_GGZ_TYPE_TXT | Allow NULL? |
| 13 | PROD_KZ | Geisteskrankheit productkode kennzeichen | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | ISH_NL_GGZ_PRD_KZ | Allow NULL? |
| 14 | SETTING | Geisteskrankheit productkode fassung | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | ISH_NL_GGZ_SETTING | Allow NULL? |
| 15 | CATEGORY | Geisteskrankheit productkode kategorie | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | ISH_NL_GGZ_CATEGORY | Allow NULL? |
| 16 | LAY_TEXT | Geisteskrankheit leistungscode laientext | nvarchar | 200 | 0 | CHAR | (N' ') | Yes | | ISH_NL_GGZ_LAY_TXT | Allow NULL? |
| 17 | ANONYM | Geisteskrankheit anonym kennzeichen | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_NL_GGZ_ANONYM | Allow NULL? |
