| 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 | REGEL | IS-H: Rule Number | nvarchar | 8 | 0 | CHAR | (N' ') | No | | ISH_REGEL | Allow NULL? |
| 4 | ICDTXT1 | IS-H: Rule Text 1 of ICD - Rule for FR per Case and PS | nvarchar | 80 | 0 | CHAR | (N' ') | Yes | | ISH_REGTXT | Allow NULL? |
| 5 | ICDTXT2 | IS-H: Rule text 2 of ICD - rule for FR per case and PS | nvarchar | 80 | 0 | CHAR | (N' ') | Yes | | ISH_REGTX2 | Allow NULL? |
| 6 | ICDTXT3 | IS-H: Rule text 3 of ICD - rule for FR per case and PS | nvarchar | 80 | 0 | CHAR | (N' ') | Yes | | ISH_REGTX3 | Allow NULL? |
| 7 | ICPMTXT1 | IS-H: Rule text 1 for ICPM - Rule for FR and PS | nvarchar | 80 | 0 | CHAR | (N' ') | Yes | | ISH_ICPMT1 | Allow NULL? |
| 8 | ICPMTXT2 | IS-H: Rule text 2 for ICPM - Rule for FR and PS | nvarchar | 80 | 0 | CHAR | (N' ') | Yes | | ISH_ICPMT2 | Allow NULL? |
| 9 | ICPMTXT3 | IS-H: Rule text 3 for ICPM - Rule for FR and PS | nvarchar | 80 | 0 | CHAR | (N' ') | Yes | | ISH_ICPMT3 | Allow NULL? |
| 10 | ICDMORE | IS-H: Multiple Birth Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_MORE | Allow NULL? |
| 11 | LEIST | Service in Service Catalog | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | NTPK | TARLS | Allow NULL? |
| 12 | FP_SE | IS-H: FR per Case, Procedures Surcharge or Additional Charge | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_FPSE | Allow NULL? |
| 13 | NO_AGE | IS-H: Flat rate per case validity independent of patient age | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_NOAGE | Allow NULL? |
| 14 | TARIF | IS-H: Service Catalog Identification Key | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TNK01 | TARID | Allow NULL? |
| 15 | GLTVON | Valid From | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ISH_GLTVON | Allow NULL? |
| 16 | GLTBIS | Valid To | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ISH_GLTBIS | Allow NULL? |
| 17 | NOAKT | IS-H: Indicator inactive | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_NOAKT | Allow NULL? |
| 18 | IMENG | Service Quantity | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | I_MENG_LS | Allow NULL? |
| 19 | PERIOD_CHECK | Indicator for ICPM Date Check for Additional Charges | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_PERIOD_CHECK | Allow NULL? |
