| 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 | FALNR | IS-H: Case Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | NFAL | FALNR | Allow NULL? |
| 4 | LFDNR | IS-H: Sequence Number of Insurance Relationship | nvarchar | 3 | 0 | NUMC | (N'000') | No | | LFDVV | Allow NULL? |
| 5 | KOSTR | IS-H: Insurance Provider | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | NGPA | KH_KOSTR | Allow NULL? |
| 6 | AKTKZ | IS-H: Number of Case on File with Insurance Provider | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | RI_AKTKZ | Allow NULL? |
| 7 | PFLZZ | IS-H: Copayment Obligation Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_ZZPFL | Allow NULL? |
| 8 | NZZGR | Reason for Copayment Waiver | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TN22A | GRKZZ | Allow NULL? |
| 9 | BTRZZ | IS-H: Amount of Copayment Request | decimal | 11 | 2 | CURR | ((0)) | Yes | | ISH_BTRZZ | |
| 10 | KZTXT | IS-H: Comment on Case-Related Insurance Relationship | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | TEXT_VVF | Allow NULL? |
| 11 | LGTXT | Indicator that Long Text Exists | char | 1 | 0 | CHAR | (N' ') | Yes | | RI_LGTXT | Allow NULL? |
| 12 | LOEKZ | Deletion Flag/Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | RI_LOEKZ | Allow NULL? |
| 13 | LOUSR | User Who Deleted Record | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RI_LOUSR | Allow NULL? |
| 14 | LODAT | Date of Deletion | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_LODAT | Allow NULL? |
| 15 | ERDAT | IS-H: Date when Record Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_ERDAT | Allow NULL? |
| 16 | ERUSR | IS-H: Name of Employee who Created Record | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RI_ERNAM | 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 | STORN | IS-H: Cancellation Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | RI_STORN | Allow NULL? |
| 20 | STUSR | IS-H: Name of User who Canceled Data Record | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | STORN_USER | Allow NULL? |
| 21 | STDAT | Date of Cancellation | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | STORN_DAT | Allow NULL? |
| 22 | RANGF | IS-H: Ranking Order of Case-Rel. Insurance Relationships | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | ISH_RANGF | Allow NULL? |
| 23 | KVDAT | IS-H: Date Healthcare Smart Card Imported | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ISH_KVDAT | Allow NULL? |
| 24 | VCEND | IS-H: Healthcare Smart Card - Validity | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ISH_VK_END | Allow NULL? |
| 25 | VTRTY | IS-H: Insurance Contract Scheme | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | TN16 | ISH_VTRTY | Allow NULL? |
| 26 | VKVST | Healthcare Smart Card - Status of Insured Person | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | ISH_VK_VST | Allow NULL? |
| 27 | VKVSE | IS-H: Healthcare Smart Card - Health Ins. Status Supplement | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | ISH_VK_VSE | Allow NULL? |
| 28 | VKNRA | IS-H: Healthcare Smart Card - Directory of Health Ins. No's | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | ISH_VK_VKN | Allow NULL? |
| 29 | VKNUM | Healthcare Smart Card - Health Insurer Number | nvarchar | 7 | 0 | CHAR | (N' ') | Yes | | ISH_VK_KNR | Allow NULL? |
| 30 | VKMAN | IS-H: Indicator that HCSC Data Entered Manually | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_KVMAN | Allow NULL? |
| 31 | VERNR | IS-H: Patient Health Insurance Number | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | VERSNR | Allow NULL? |
| 32 | KKFAL | IS-H: Case Number Used by Insurance Provider | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ISH_KKFAL | Allow NULL? |
| 33 | VBGDT | IS-H: Insurance coverage start date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ISH_VBGDT | Allow NULL? |
| 34 | REPAP | IS-H: Invoice requested as printout | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_REPAP | Allow NULL? |
| 35 | VTAGE | IS-H: Previous Days | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | ISH_VTAGE | Allow NULL? |
| 36 | VTDAT | IS-H: Date of Report on Paid Copayment Days | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ISH_VTDAT | Allow NULL? |
| 37 | ADRNR | IS-H: Number of Address in General Address Management | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | ISH_CADRNR | Allow NULL? |
| 38 | CPDKT | IS-H: One-Time Account for Alternative Invoice Recipient | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | ISH_CPDKTO | Allow NULL? |
| 39 | STREA | IS-H: Address Entered with General Address Management | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_STRGRA | Allow NULL? |
| 40 | PAYAM | IS-H: Amount Covered (by Insurance Relationship) | decimal | 15 | 2 | CURR | ((0)) | Yes | | ISH_PAYAM | |
| 41 | WAERS | IS-H: Currency in Case-Related Insurance Relationship | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | WAERS_VVH | Allow NULL? |
| 42 | EXTTY | External Contract Scheme | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | ISH_EXTTY | Allow NULL? |
| 43 | TWKTR | IS-H: Indicator for Main Insurance Relationship | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_MAINI | Allow NULL? |
| 44 | APSTATE | IS-H: Application Status | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TNC301SA | ISH_APSTATE | Allow NULL? |
| 45 | KUAUS | IS-H CH: Disable Case-Related Insurance Verification | char | 1 | 0 | CHAR | (N' ') | Yes | | NWCH_KUAUS | Allow NULL? |
| 46 | TPPROC | | char | 1 | 0 | | (N' ') | Yes | | | Allow NULL? |
| 47 | VCODE | IS-H CA: Version Code for OHIP Health Number | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | ISH_VERSIONCODE | Allow NULL? |
| 48 | KKFAL_NEW | Case Number at Insurance Provider (New) | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | ISH_KKFAL_NEW | Allow NULL? |
| 49 | CONTRACT_IND | | nvarchar | 30 | 0 | | (N' ') | Yes | | | Allow NULL? |
