| 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 | VTRTY | IS-H: Insurance Contract Scheme | nvarchar | 6 | 0 | CHAR | (N' ') | No | | ISH_VTRTY | Allow NULL? |
| 4 | PERCT | IS-H: Coverage Rate | decimal | 6 | 3 | DEC | ((0)) | Yes | | ISH_PERCT | |
| 5 | MAXAM | IS-H: Maximum Amount per Case | decimal | 15 | 2 | CURR | ((0)) | Yes | | ISH_MAXAM | |
| 6 | MAXAD | IS-H: Maximum Amount per Day/Visit | decimal | 15 | 2 | CURR | ((0)) | Yes | | ISH_MAXAD | |
| 7 | EXACT | IS-H: Indicator for Valuation per Day/Visit | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_EXACT | Allow NULL? |
| 8 | MAXDY | IS-H: Maximum Number of Days per Year | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | ISH_MAXDY | Allow NULL? |
| 9 | WAERS | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | WAERS | Allow NULL? |
| 10 | BEGDT | IS-H: Validity Start of Contract Scheme | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ISH_CCFRM | Allow NULL? |
| 11 | ENDDT | IS-H: Validity End of Contract Scheme | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ISH_CCTO | Allow NULL? |
| 12 | FALAR | IS-H: Case Type | char | 1 | 0 | CHAR | (N' ') | Yes | | FALLART | Allow NULL? |
| 13 | HCOND | IS-H SG: Requirement for Contract Scheme | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | ISH_COND | Allow NULL? |
| 14 | EXTIN | IS-H: Indicator for Contract Scheme with External Processing | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_EXTIN | Allow NULL? |
| 15 | EXTFU | IS-H: Function module for external processing | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | TFDIR | ISH_EXTFU | Allow NULL? |
| 16 | ERDAT | IS-H: Date when Record Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_ERDAT | Allow NULL? |
| 17 | ERNAM | IS-H: Name of Employee who Created Record | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RI_ERNAM | Allow NULL? |
| 18 | UPDAT | IS-H: Date of Last Change | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_UPDAT | Allow NULL? |
| 19 | UPUSR | IS-H: Name of Person who Last Changed Data | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RI_UPNAM | Allow NULL? |
| 20 | RFCDE | Logical Destination (Specified in Function Call) | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | RFCDES | RFCDEST | Allow NULL? |
| 21 | INBIL | IS-H: Indicator that Interim Billing Is Allowed | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_INBIL | Allow NULL? |
| 22 | COMPS | IS-H: Compensation Service | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | NTPK | ISH_COMPS | Allow NULL? |
| 23 | COMPC | IS-H: Service Catalog Identification Key | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TNK01 | TARID | Allow NULL? |
| 24 | VARMAX | IS-H: Calculation for Maximum Amount | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TN16B | ISH_COMPMAX | Allow NULL? |
| 25 | DISCS | | nvarchar | 10 | 0 | | (N' ') | Yes | | | Allow NULL? |
| 26 | DISCC | IS-H: Service Catalog Identification Key | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TNK01 | TARID | Allow NULL? |
| 27 | /ISHFR/INT_PERCT | IS-H FR: Interpretation of Percentage in Contract Scheme | char | 1 | 0 | CHAR | (N' ') | Yes | | /ISHFR/INT_PERCT | Allow NULL? |
