| 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 | TN16 | ISH_VTRTY | Allow NULL? |
| 4 | POSNO | IS-H: Item Number | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | ISH_POSNO | Allow NULL? |
| 5 | RANKI | IS-H: Rank of the Contract Scheme Item | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | ISH_RANKI | Allow NULL? |
| 6 | PERCT | IS-H: Coverage Rate | decimal | 6 | 3 | DEC | ((0)) | Yes | | ISH_PERCT | |
| 7 | MAXAM | IS-H: Maximum Amount per Case | decimal | 15 | 2 | CURR | ((0)) | Yes | | ISH_MAXAM | |
| 8 | MAXAD | IS-H: Maximum Amount per Day/Visit | decimal | 15 | 2 | CURR | ((0)) | Yes | | ISH_MAXAD | |
| 9 | EXACT | IS-H: Indicator for Valuation per Day/Visit | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_EXACT | Allow NULL? |
| 10 | EXID | IS-H: Exclusion Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_EXID | Allow NULL? |
| 11 | SERIN | IS-H: Service Inclusions | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | NTPK | ISH_SERIN | Allow NULL? |
| 12 | INFIL | IS-H: Filter for Service Inclusions | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | TFDIR | ISH_INFIL | Allow NULL? |
| 13 | SEREX | IS-H: Service Exclusions | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | NTPK | ISH_SEREX | Allow NULL? |
| 14 | EXFIL | IS-H: Filter for service exclusions | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | TFDIR | ISH_EXFIL | Allow NULL? |
| 15 | TARIF | IS-H: Service Catalog Identification Key | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TNK01 | TARID | Allow NULL? |
| 16 | BWART | IS-H: Movement Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TN14B | RI_BWART | Allow NULL? |
| 17 | PCOND | IS-H SG: Requirement for Contract Scheme | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | ISH_COND | Allow NULL? |
| 18 | ERDAT | IS-H: Date when Record Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_ERDAT | Allow NULL? |
| 19 | ERNAM | IS-H: Name of Employee who Created Record | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RI_ERNAM | Allow NULL? |
| 20 | UPDAT | IS-H: Date of Last Change | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_UPDAT | Allow NULL? |
| 21 | UPUSR | IS-H: Name of Person who Last Changed Data | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RI_UPNAM | Allow NULL? |
| 22 | PWERT | IS-H CH: Charge factor value | decimal | 13 | 6 | DEC | ((0)) | Yes | | ISH_VPWERT | |
| 23 | DAYTO | IS-H CH: Daily Scale for Contract Scheme Items, Scale End | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | ISH_VDEGR | Allow NULL? |
| 24 | MDIND | IS-H CH: Medical Indication Check | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_MDIND | Allow NULL? |
| 25 | /ISHFR/INT_PERCT | IS-H FR: Interpretation of Percentage in Contract Scheme | char | 1 | 0 | CHAR | (N' ') | Yes | | /ISHFR/INT_PERCT | Allow NULL? |
| 26 | FNAME | IS-H: Field Name for Contract Scheme Item | nvarchar | 33 | 0 | CHAR | (N' ') | Yes | | ISH_FIELD_NAME | Allow NULL? |
| 27 | FVALUE | IS-H: Field Value for Addit. Contract Scheme Item Criterion | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | ISH_FIELD_VALUE | Allow NULL? |
| 28 | PLTEXT | IS-H: Text describing the contract scheme | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | VTR_LTEXT | Allow NULL? |
| 29 | CALC | Calculation of Contract Scheme Item | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | ISH_VTR_CALC | Allow NULL? |
