| 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 | ORIGIN | Geisteskrankheit validierungsbaum herkunft | nvarchar | 10 | 0 | NUMC | (N'0000000000') | No | | ISH_NL_GGZ_ORIGIN | Allow NULL? |
| 4 | ENDDT | ISH_NL: Ende datum | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | ISH_NL_DBC_ENDDT | Allow NULL? |
| 5 | BEGDT | ISH_NL: Anfang datum | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ISH_NL_DBC_BEGDT | Allow NULL? |
| 6 | TEST_KZ | Geisteskrankheit parameter kennzeichen | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | ISH_NL_GGZ_PAR | Allow NULL? |
| 7 | PARAM_1 | Geisteskrankheit parameter 1 | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | ISH_NL_GGZ_PAR_1 | Allow NULL? |
| 8 | PARAM_2 | Geisteskrankheit parameter 2 | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | ISH_NL_GGZ_PAR_2 | Allow NULL? |
| 9 | OPERATION | Geisteskrankheit validierungsbaum operation | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | ISH_NL_GGZ_OPERATOR | Allow NULL? |
| 10 | VALUE_1 | Geisteskrankheit validierungs werte 1 | decimal | 12 | 2 | DEC | ((0)) | Yes | | ISH_NL_GGZ_WERTE_1 | |
| 11 | VALUE_2 | Geisteskrankheit validierungs werte 2 | decimal | 12 | 2 | DEC | ((0)) | Yes | | ISH_NL_GGZ_WERTE_2 | |
| 12 | NODE_TRUE | Geisteskrankheit validierungsbaum true | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | ISH_NL_GGZ_NODE_T | Allow NULL? |
| 13 | VALUE_TRUE | Geisteskrankheit knotenpunkt werte true | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | ISH_NL_GGZ_VAL_T | Allow NULL? |
| 14 | NODE_FALSE | Geisteskrankheit validierungsbaum false | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | ISH_NL_GGZ_NODE_F | Allow NULL? |
| 15 | VALUE_FALSE | Geisteskrankheit knotenpunkt werte false | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | ISH_NL_GGZ_VAL_F | Allow NULL? |
