| 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 | BELNR | IS-H: Document Number of IV Document/Treatment Certificate | nvarchar | 10 | 0 | CHAR | (N' ') | No | NKSK | KS_BELNR | Allow NULL? |
| 3 | POSNR | Item Number per Insurance Verification/Certificate | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | KS_POSNR | Allow NULL? |
| 4 | TARID | IS-H: Service Catalog Identification Key | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TNK01 | TARID | Allow NULL? |
| 5 | LEIID | Service in Service Catalog | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | TARLS | Allow NULL? |
| 6 | KOSTR | IS-H: Insurance Provider | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KH_KOSTR | Allow NULL? |
| 7 | LFDNR | IS-H: Sequence Number of Insurance Relationship | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | LFDVV | Allow NULL? |
| 8 | BEGDT | IS-H: Valid-From Date of Item | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | KS_BEGDP | Allow NULL? |
| 9 | ENDDT | IS-H: Valid-To Date of Item | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | KS_ENDDP | Allow NULL? |
| 10 | PSTAT | Processing Status of Insurance Verification Item | char | 1 | 0 | CHAR | (N' ') | Yes | | KS_PSTAT | Allow NULL? |
| 11 | ABGDT | IS-H: Date when Item Was Completed | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | KS_PABDT | Allow NULL? |
| 12 | UEBAB | IS-H: Ind. Whether Coverage of Service Is Rejected | char | 1 | 0 | CHAR | (N' ') | Yes | | KS_UEBAB | Allow NULL? |
| 13 | KTEXT | IS-H: Comment on item IV/certificate (no long text call up) | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | KS_PTEXT | Allow NULL? |
| 14 | STORN | IS-H: Cancellation Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | RI_STORN | Allow NULL? |
| 15 | STUSR | IS-H: Name of User who Canceled Data Record | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | STORN_USER | Allow NULL? |
| 16 | STDAT | Date of Cancellation | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | STORN_DAT | Allow NULL? |
| 17 | UPDAT | IS-H: Date of Last Change | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_UPDAT | Allow NULL? |
| 18 | UPUSR | IS-H: Name of Person who Last Changed Data | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RI_UPNAM | Allow NULL? |
| 19 | VBEGD | IS-H: Valid-From Date of Item | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ISHZUBEGDP | Allow NULL? |
| 20 | VENDD | IS-H: Valid-To Date of Item | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ISHZUENDDP | Allow NULL? |
| 21 | VPROZ | IS-H: Rate of Coverage per Item | decimal | 5 | 2 | DEC | ((0)) | Yes | | ISHZUANTEI | |
| 22 | VPREIS | IS-H: Total Amount of Coverage Confirmed | decimal | 11 | 2 | CURR | ((0)) | Yes | | ISHZUBTRAG | |
| 23 | VMENGE | IS-H: Maximum quantity of confirmation of coverage | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | ISHZUMENGE | Allow NULL? |
| 24 | VBTRAG | IS-H: Total Amount of Coverage Confirmed | decimal | 11 | 2 | CURR | ((0)) | Yes | | ISHZUBTRAG | |
| 25 | KPROZ | IS-H: Coverage Rate per Item of IV/Treatment Certificate | decimal | 5 | 2 | DEC | ((0)) | Yes | | KS_ANTEI | |
| 26 | KBTRAG | Total Amount Covered | decimal | 11 | 2 | CURR | ((0)) | Yes | | KS_BTRAG | |
| 27 | KPREIS | IS-H: Maximum Price for Insurance Coverage | decimal | 11 | 2 | CURR | ((0)) | Yes | | KS_PREIS | |
| 28 | KMENGE | IS-H: Maximum Quantity Covered | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | KS_MENGE | Allow NULL? |
| 29 | REST | IS-H: Ind. Rem. for Rounding Errors/Ins. Coverage IV Request | char | 1 | 0 | CHAR | (N' ') | Yes | | KZ_REST | Allow NULL? |
| 30 | SEKZ | IS-H: Self-Payer Indicator (Insurance Verification) | char | 1 | 0 | CHAR | (N' ') | Yes | | KS_SEKZ | Allow NULL? |
| 31 | TGRKZ | IS-H: Indicator Denoting a Service Group | char | 1 | 0 | CHAR | (N' ') | Yes | | TGRU_KZ | Allow NULL? |
| 32 | TCODE | IS-H: Report Control: Transaction Code for Application | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | * | ISH_TCODE | Allow NULL? |
| 33 | ABLGR | IS-H AT: Reason for Rejection | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TN19G | ISH_ABGRU | Allow NULL? |
| 34 | REFNR | IS-H: Reference field of an IV item (external reference) | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | NKSP_REFNR | Allow NULL? |
| 35 | IVFACT | IS-H: Coverage of Service | decimal | 15 | 14 | | ((0)) | Yes | | ISH_IVFACT | |
