| 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 | KOSTR | IS-H: Insurance Provider | nvarchar | 10 | 0 | CHAR | (N' ') | No | NGPA | KH_KOSTR | Allow NULL? |
| 3 | KTTYP | IS-H: Indicator Denoting Insurance Provider Group | char | 1 | 0 | CHAR | (N' ') | Yes | | GRU_KZ | Allow NULL? |
| 4 | KTART | IS-H: Insurance Provider Type (e.g. Private, Statutory) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TN18 | KOSTR_ART | Allow NULL? |
| 5 | ARTPA | IS-H: Determine IV Control Parameters Using Ins. Prov. Type | char | 1 | 0 | CHAR | (N' ') | Yes | | KTART_PARA | Allow NULL? |
| 6 | ZENTR | Key Identifying Insurance Provider's Head Office | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | NGPA | RI_ZENTR | Allow NULL? |
| 7 | KKSNR | IS-H: Number Identifying the Health Insurer | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | KKSNR | Allow NULL? |
| 8 | KVNUM | IS-H: Responsible PPA (panel physician association) | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | NGPA | KVNUM | Allow NULL? |
| 9 | KKSVA | IS-H: Health Insurer Number as per Healthcare Smart Card | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | CHIPNR | Allow NULL? |
| 10 | KZTXT | IS-H: Comment on Insurance Provider | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | TEXT_KTR | Allow NULL? |
| 11 | LGTXT | Indicator that Long Text Exists | char | 1 | 0 | CHAR | (N' ') | Yes | | RI_LGTXT | Allow NULL? |
| 12 | KONT1 | Contact Person, e.g. Inpatient | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | ANPER1 | Allow NULL? |
| 13 | KONT2 | Contact Person, e.g. Outpatient | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | ANPER2 | Allow NULL? |
| 14 | KUEVER | IS-H: Insurance Verification Procedure 'X'=Yes, ' '=No | char | 1 | 0 | CHAR | (N' ') | Yes | | KUEVER | Allow NULL? |
| 15 | REBEA | IS-H: Manual Invoice Processing is Allowed | char | 1 | 0 | CHAR | (N' ') | Yes | | REBEARB | Allow NULL? |
| 16 | SAMRE | IS-H: Invoice List Output per IP at Invoice Print | char | 1 | 0 | CHAR | (N' ') | Yes | | SAMMELRE | Allow NULL? |
| 17 | ZWIAB | IS-H: Ind. Specifying if Int. Bill. is to be Performed | char | 1 | 0 | CHAR | (N' ') | Yes | | ABR_ZWI | Allow NULL? |
| 18 | SORTR | IS-H: Sort Rules for Billing | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | ABRSORT | Allow NULL? |
| 19 | ABRLS | IS-H: Interim Billing for Svces w/o Confirmation of Coverage | char | 1 | 0 | CHAR | (N' ') | Yes | | ABRLEI_ZWI | Allow NULL? |
| 20 | ENDLS | IS-H: Final Billing for Svces w/o Confirmation of Coverage | char | 1 | 0 | CHAR | (N' ') | Yes | | ENDABR_LEI | Allow NULL? |
| 21 | ENDAB | IS-H: Final Billing only if Diagnosis Entered | char | 1 | 0 | CHAR | (N' ') | Yes | | ENDABR_DIA | Allow NULL? |
| 22 | SEPRE | IS-H: Separate Invoice for Companion | char | 1 | 0 | CHAR | (N' ') | Yes | | SEP_RE | Allow NULL? |
| 23 | ABRTG | IS-H: Interim Billing After x Days as of Admission | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | ABR_TAGE | Allow NULL? |
| 24 | ABRIN | IS-H: Interim Billing Interval (Weeks/Days/Quarter) | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | ABR_INTERV | Allow NULL? |
| 25 | RHYTH | IS-H: Final Billing Interval (Weekly, Every 2 Weeks,Monthly) | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | RHYT_ENDAB | Allow NULL? |
| 26 | KUEMAH | IS-H: Insurance Verification Reminder; 'X'=Yes ' '=No | char | 1 | 0 | CHAR | (N' ') | Yes | | KUEMAH | Allow NULL? |
| 27 | KUEMF | IS-H: Reminder Period for IV Request in Days | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | KUE_MAFRI | Allow NULL? |
| 28 | KUEVS | IS-H: Send IV Request Only if Diagnosis Is Maintained | char | 1 | 0 | CHAR | (N' ') | Yes | | KUEVERSAND | Allow NULL? |
| 29 | DIADR | IS-H: Print Diagnosis on IV Request (Yes/No) | char | 1 | 0 | CHAR | (N' ') | Yes | | DIADRUCK | Allow NULL? |
| 30 | AAZKZ | IS-H: Admission Notif. to Be Printed in Standard Form Print | char | 1 | 0 | CHAR | (N' ') | Yes | | AUFN_ANZ | Allow NULL? |
| 31 | ENTAZ | IS-H: Discharge Notification to Be Created | char | 1 | 0 | CHAR | (N' ') | Yes | | ENTL_ANZ | Allow NULL? |
| 32 | VKUAN | IS-H: Interval for Extending IV Requests | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | VERL_KUEAN | Allow NULL? |
| 33 | KUANZ | IS-H: Interval for Creating IV Requests | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | KUEAN_ZTR | Allow NULL? |
| 34 | PFLZZ | IS-H: Insurance Provider Requires Copayment | char | 1 | 0 | CHAR | (N' ') | Yes | | KOSTR_ZUZ | Allow NULL? |
| 35 | VERZZ | IS-H: Copayment Procedure for Billing | char | 1 | 0 | CHAR | (N' ') | Yes | | VERFZUZ | Allow NULL? |
| 36 | STTAG | IS-H: Start Day for Interval | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | STARTTAG | Allow NULL? |
| 37 | WAERS | IS-H: Currency of Insurance Provider | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | WAERS_KTR | Allow NULL? |
| 38 | LOEKZ | Deletion Flag/Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | RI_LOEKZ | Allow NULL? |
| 39 | LOUSR | User Who Deleted Record | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RI_LOUSR | Allow NULL? |
| 40 | LODAT | Date of Deletion | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_LODAT | Allow NULL? |
| 41 | ERDAT | IS-H: Date when Record Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_ERDAT | Allow NULL? |
| 42 | ERUSR | IS-H: Name of Employee who Created Record | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RI_ERNAM | Allow NULL? |
| 43 | UPDAT | IS-H: Date of Last Change | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_UPDAT | Allow NULL? |
| 44 | UPUSR | IS-H: Name of Person who Last Changed Data | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RI_UPNAM | Allow NULL? |
| 45 | TAXKD | IS-H: Tax Classification of Insurance Provider | char | 1 | 0 | CHAR | (N' ') | Yes | * | TAXKD_ISH | Allow NULL? |
| 46 | PM301 | Data Collection Point for EDI Message Transmission | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | NC301P | ISH_DAS301 | Allow NULL? |
| 47 | ABREL | IS-H:Head Office for HC Smart Card, not Relevant for Billing | char | 1 | 0 | CHAR | (N' ') | Yes | | ABR_REL | Allow NULL? |
| 48 | POSTK | IS-H: Head Office Valid for Forms | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_POSTST | Allow NULL? |
| 49 | KSSNM | IS-H: HI Search Name From Ins. Provider Master File (PPA) | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | | ISH_KSSNAM | Allow NULL? |
| 50 | KSSNS | IS-H: Stnd. HI Search Name from Ins. Provider Master File | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | | ISH_KSSNAS | Allow NULL? |
| 51 | KUALF | IS-H CH: Rejection deadline for insurance verification | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | ISH_KUALF | Allow NULL? |
| 52 | KUCODE | IS-H CH: IV procedure | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TNWCH77 | NWCH_KUCODE | Allow NULL? |
| 53 | EANR | IS-H CH: European Article Number (EAN) | nvarchar | 13 | 0 | CHAR | (N' ') | Yes | | NWCH_EANR | Allow NULL? |
| 54 | RDRUCK | IS-H: Control for Invoice Print | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_RDRUCK | Allow NULL? |
| 55 | KNULLR | IS-H: Print Pro Forma Invoice | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_PROFORMA | Allow NULL? |
| 56 | TPPROC | | char | 1 | 0 | | (N' ') | Yes | | | Allow NULL? |
| 57 | SVERS | IS-H: Indicator for Social Insurance | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_SOZIALVERS | Allow NULL? |
| 58 | ABRLF | | char | 1 | 0 | | (N' ') | Yes | | | Allow NULL? |
| 59 | INSTLKF | | nvarchar | 3 | 0 | | (N' ') | Yes | | | Allow NULL? |
| 60 | MIG_DONE | Indicator Specifying Record Is Migrated to BP Table | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_BPMIG_DONE | Allow NULL? |
| 61 | /ISHFR/COMP_INS | IS-H FR: Complementary Insurance | char | 1 | 0 | CHAR | (N' ') | Yes | | /ISHFR/COMP_INS | Allow NULL? |
| 62 | /ISHFR/ELSASS | IS-H FR: Insurance Provider ALSACE | char | 1 | 0 | CHAR | (N' ') | Yes | | /ISHFR/ELSASS | Allow NULL? |
| 63 | /ISHFR/LIMPDVTY | IS-H FR: Limit for Payment Distribution by Contract Scheme | char | 1 | 0 | CHAR | (N' ') | Yes | | /ISHFR/LIMPDVTY | Allow NULL? |
| 64 | /ISHFR/WODAYFR | IS-H FR: Without Per Diem | char | 1 | 0 | CHAR | (N' ') | Yes | | /ISHFR/WODAYFR | Allow NULL? |
| 65 | /ISHFR/HIST | IS-H FR: Health Insurer Type | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | /ISHFR/ISH_HIST | Allow NULL? |
| 66 | /ISHFR/COUNC_GEN | IS-H FR: General Council | char | 1 | 0 | CHAR | (N' ') | Yes | | /ISHFR/COUNCIL_GEN | Allow NULL? |
| 67 | PSIGN | IS-H: Insurance Provider Control | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_KTR_TYPE | Allow NULL? |
| 68 | BAG | | nvarchar | 5 | 0 | | (N'00000') | Yes | | | Allow NULL? |
