| 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 | * | MANDT | Allow NULL? |
| 2 | VKNUM | Healthcare Smart Card - Health Insurer Number | nvarchar | 7 | 0 | CHAR | (N' ') | No | | ISH_VK_KNR | Allow NULL? |
| 3 | UNTGR | IS-H: Insurance Subgroup | nvarchar | 2 | 0 | CHAR | (N' ') | No | TN16C | UNTGR | Allow NULL? |
| 4 | VAL_QUARTER | IS-H: Validity Quarter Start Date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | ISH_VAL_QUARTER_BEGIN | Allow NULL? |
| 5 | VKNR | IS-H: Healthcare Smart Card - Directory of Health Ins. No's | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | ISH_VK_VKN | Allow NULL? |
| 6 | KNAME | IS-H: Healthcare Smart Card - Health Insurer Name | nvarchar | 28 | 0 | CHAR | (N' ') | Yes | | ISH_VK_KNM | Allow NULL? |
| 7 | KKSNM | IS-H: HI Search Name From Ins. Provider Master File (PPA) | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | | ISH_KSSNAM | Allow NULL? |
| 8 | KGROUP | IS-H: Insurance Provider Group - PPA Ins. Prov. Master | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | ISH_KGROUP | Allow NULL? |
| 9 | KVGBO | IS-H: Charge Catalog (PPA billing Germany) | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_KVGBO | Allow NULL? |
| 10 | STRAS | IS-H: Street | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | ISH_STRASS | Allow NULL? |
| 11 | PSTLZ | IS-H: Postal Code of City | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | ISH_PSTLZO | Allow NULL? |
| 12 | ORT | IS-H: City | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | ISH_CITY1 | Allow NULL? |
| 13 | PFACH | IS-H: Post Office Box | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | ISH_POBOX | Allow NULL? |
| 14 | PSTLP | IS-H: Postal Code of P.O. Box | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | ISH_PSTLZP | Allow NULL? |
| 15 | ORTPF | IS-H: PO Box City | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | ISH_CITYPB | Allow NULL? |