| 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 | KTART | IS-H: Insurance Provider Type (e.g. Private, Statutory) | nvarchar | 3 | 0 | CHAR | (N' ') | No | | KOSTR_ART | Allow NULL? |
| 3 | UNTGR | IS-H: Insurance Subgroup | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TN16C | UNTGR | Allow NULL? |
| 4 | KBVAB | IS-H: Classification of Billing Type According to PPA-BDT | char | 1 | 0 | NUMC | (N'0') | Yes | | KBVAB | Allow NULL? |
| 5 | KUEVER | IS-H: Insurance Verification Procedure 'X'=Yes, ' '=No | char | 1 | 0 | CHAR | (N' ') | Yes | | KUEVER | Allow NULL? |
| 6 | REBEA | IS-H: Manual Invoice Processing is Allowed | char | 1 | 0 | CHAR | (N' ') | Yes | | REBEARB | Allow NULL? |
| 7 | SAMRE | IS-H: Invoice List Output per IP at Invoice Print | char | 1 | 0 | CHAR | (N' ') | Yes | | SAMMELRE | Allow NULL? |
| 8 | ZWIAB | IS-H: Ind. Specifying if Int. Bill. is to be Performed | char | 1 | 0 | CHAR | (N' ') | Yes | | ABR_ZWI | Allow NULL? |
| 9 | SORTR | IS-H: Sort Rules for Billing | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | ABRSORT | Allow NULL? |
| 10 | ABRLS | IS-H: Interim Billing for Svces w/o Confirmation of Coverage | char | 1 | 0 | CHAR | (N' ') | Yes | | ABRLEI_ZWI | Allow NULL? |
| 11 | ENDLS | IS-H: Final Billing for Svces w/o Confirmation of Coverage | char | 1 | 0 | CHAR | (N' ') | Yes | | ENDABR_LEI | Allow NULL? |
| 12 | ENDAB | IS-H: Final Billing only if Diagnosis Entered | char | 1 | 0 | CHAR | (N' ') | Yes | | ENDABR_DIA | Allow NULL? |
| 13 | SEPRE | IS-H: Separate Invoice for Companion | char | 1 | 0 | CHAR | (N' ') | Yes | | SEP_RE | Allow NULL? |
| 14 | ABRTG | IS-H: Interim Billing After x Days as of Admission | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | ABR_TAGE | Allow NULL? |
| 15 | ABRIN | IS-H: Interim Billing Interval (Weeks/Days/Quarter) | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | ABR_INTERV | Allow NULL? |
| 16 | RHYTH | IS-H: Final Billing Interval (Weekly, Every 2 Weeks,Monthly) | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | RHYT_ENDAB | Allow NULL? |
| 17 | KUEMAH | IS-H: Insurance Verification Reminder; 'X'=Yes ' '=No | char | 1 | 0 | CHAR | (N' ') | Yes | | KUEMAH | Allow NULL? |
| 18 | KUEMF | IS-H: Reminder Period for IV Request in Days | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | KUE_MAFRI | Allow NULL? |
| 19 | KUEVS | IS-H: Send IV Request Only if Diagnosis Is Maintained | char | 1 | 0 | CHAR | (N' ') | Yes | | KUEVERSAND | Allow NULL? |
| 20 | DIADR | IS-H: Print Diagnosis on IV Request (Yes/No) | char | 1 | 0 | CHAR | (N' ') | Yes | | DIADRUCK | Allow NULL? |
| 21 | AAZKZ | IS-H: Admission Notif. to Be Printed in Standard Form Print | char | 1 | 0 | CHAR | (N' ') | Yes | | AUFN_ANZ | Allow NULL? |
| 22 | ENTAZ | IS-H: Discharge Notification to Be Created | char | 1 | 0 | CHAR | (N' ') | Yes | | ENTL_ANZ | Allow NULL? |
| 23 | VKUAN | IS-H: Interval for Extending IV Requests | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | VERL_KUEAN | Allow NULL? |
| 24 | KUANZ | IS-H: Interval for Creating IV Requests | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | KUEAN_ZTR | Allow NULL? |
| 25 | PFLZZ | IS-H: Insurance Provider Requires Copayment | char | 1 | 0 | CHAR | (N' ') | Yes | | KOSTR_ZUZ | Allow NULL? |
| 26 | VERZZ | IS-H: Copayment Procedure for Billing | char | 1 | 0 | CHAR | (N' ') | Yes | | VERFZUZ | Allow NULL? |
| 27 | STTAG | IS-H: Start Day for Interval | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | STARTTAG | Allow NULL? |
| 28 | KVGBO | IS-H: Charge Catalog (PPA billing Germany) | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_KVGBO | Allow NULL? |
| 29 | UPUSR | IS-H: Name of Person who Last Changed Data | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RI_UPNAM | Allow NULL? |
| 30 | UPDAT | IS-H: Date of Last Change | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_UPDAT | Allow NULL? |
| 31 | KTKEY | IS-H: Internal Insurance Provider Category | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | ISH_KTKEY | Allow NULL? |
| 32 | KUALF | IS-H CH: Rejection deadline for insurance verification | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | ISH_KUALF | Allow NULL? |
| 33 | KUCODE | IS-H CH: IV procedure | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TNWCH77 | NWCH_KUCODE | Allow NULL? |
| 34 | RDRUCK | IS-H: Control for Invoice Print | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_RDRUCK | Allow NULL? |
| 35 | KNULLR | IS-H: Print Pro Forma Invoice | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_PROFORMA | Allow NULL? |
| 36 | SVERS | IS-H: Indicator for Social Insurance | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_SOZIALVERS | Allow NULL? |
| 37 | /ISHFR/COMP_INS | IS-H FR: Complementary Insurance | char | 1 | 0 | CHAR | (N' ') | Yes | | /ISHFR/COMP_INS | Allow NULL? |
| 38 | /ISHFR/ELSASS | IS-H FR: Insurance Provider ALSACE | char | 1 | 0 | CHAR | (N' ') | Yes | | /ISHFR/ELSASS | Allow NULL? |
| 39 | /ISHFR/LIMPDVTY | IS-H FR: Limit for Payment Distribution by Contract Scheme | char | 1 | 0 | CHAR | (N' ') | Yes | | /ISHFR/LIMPDVTY | Allow NULL? |
| 40 | /ISHFR/WODAYFR | IS-H FR: Without Per Diem | char | 1 | 0 | CHAR | (N' ') | Yes | | /ISHFR/WODAYFR | Allow NULL? |
| 41 | /ISHFR/COUNC_GEN | IS-H FR: General Council | char | 1 | 0 | CHAR | (N' ') | Yes | | /ISHFR/COUNCIL_GEN | Allow NULL? |
| 42 | PSIGN | IS-H: Insurance Provider Control | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_KTR_TYPE | Allow NULL? |
| 43 | KGROUP | IS-H: Insurance Provider Group - PPA Ins. Prov. Master | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | ISH_KGROUP | Allow NULL? |
| 44 | COMTY | Insurance Communication Type | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | ISH_CN_COMTYPE | Allow NULL? |
| 45 | INACT | IS-H: 'Inactive' Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_INACTIVE_C | Allow NULL? |
