| 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 | ACT_CODE | Geisteskrankheit activität kode | nvarchar | 20 | 0 | CHAR | (N' ') | No | | ISH_NL_GGZ_ACT_CODE | 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 | ACT_GRP | Geisteskrankheit activität kode gruppe | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | ISH_NL_GGZ_ACT_GRP | Allow NULL? |
| 8 | ACT_TYPE | Geisteskrankheit activität type | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | ISH_NL_GGZ_ACT_TYPE | Allow NULL? |
| 9 | ACT_DIR_KZ | Geisteskrankheit activität kode direkter zeit | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_NL_GGZ_ACT_DIR | Allow NULL? |
| 10 | ACT_IND_KZ | Geisteskrankheit activität kode indirekter zeit | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_NL_GGZ_ACT_IND | Allow NULL? |
| 11 | ACT_TRV_KZ | Geisteskrankheit activität kode reisezeit | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_NL_GGZ_ACT_TRV | Allow NULL? |
| 12 | ACT_GRP_KZ | Geisteskrankheit activität kode gruppe zeit | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_NL_GGZ_ACT_GRP_ZEIT | Allow NULL? |
| 13 | ACT_KZ | Geisteskrankheit activität kode kennzeichen | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | ISH_NL_GGZ_ACT_KZ | Allow NULL? |
| 14 | ACT_ELM | Geisteskrankheit activität kode element | nvarchar | 255 | 0 | CHAR | (N' ') | Yes | | ISH_NL_GGZ_ACT_ELM | Allow NULL? |
| 15 | TEXT | Beschreibung | nvarchar | 255 | 0 | CHAR | (N' ') | Yes | | ISH_NL_GGZ_TXT | Allow NULL? |