| 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 | TREATMENT | IS-H: Treatment | nvarchar | 10 | 0 | CHAR | (N' ') | No | | ISH_TREATMENT | Allow NULL? |
| 4 | EDATE | IS-H: Date for which Estimated Invoice Is to Be Calculated | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | ISH_EDATE | Allow NULL? |
| 5 | BEKAT | Treatment Category | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | TN24 | BEKAT | Allow NULL? |
| 6 | TEXT | IS-H: Text for Treatment | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | ISH_EBILL_REMARK | Allow NULL? |
| 7 | ICPMK | IS-H: Identification of Surgical Procedure Coding Catalog | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TNK01 | ICPM_ID | Allow NULL? |
| 8 | ICPML | IS-H: Surgical Procedure Code (Service) | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | ICPM_LS | Allow NULL? |
| 9 | OPTAB | IS-H SG: Table of Operation | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | ISH_OPTAB | Allow NULL? |
| 10 | FZIFF | Check Digit for Case | char | 1 | 0 | CHAR | (N' ') | Yes | | PZIFF_FALL | Allow NULL? |
| 11 | FALAE | IS-H: Case Type - User-Specific | char | 1 | 0 | CHAR | (N' ') | Yes | TN15A | FALLARTE | Allow NULL? |
| 12 | FALAR | IS-H: Case Type | char | 1 | 0 | CHAR | (N' ') | Yes | | FALLART | Allow NULL? |
| 13 | ICDKT | IS-H: Identification Key of Diagnosis Coding Catalog | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TNK00 | DIAKAT | Allow NULL? |
| 14 | ICDKY | IS-H: Diagnosis Code | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | NKDI | DIAID | Allow NULL? |
| 15 | CLASS | IS-H: Patient Class | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TNP01 | ISH_PAYCL | Allow NULL? |
| 16 | AUFTYP | Movement Category | char | 1 | 0 | CHAR | (N' ') | Yes | | BEWTY | Allow NULL? |
| 17 | AUFART | IS-H: Movement Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TN14B | RI_BWART | Allow NULL? |
| 18 | ACCCAT | Accommodation Category | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | TNACC | ISH_ACCCAT | Allow NULL? |
| 19 | ORGFA | IS-H: OU with Departmental Responsibility for Case | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | NORG | NZUWFA | Allow NULL? |
| 20 | ORGPF | Organizational Unit Assigned to Case | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | NORG | NZUWPF | Allow NULL? |
| 21 | LOS | IS-H: Length of Stay | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | ISH_LOST | Allow NULL? |
| 22 | DELIVERY | IS-H: Delivery Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_DELIV | Allow NULL? |
| 23 | CHILDREN | IS-H: Number of Children | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | ISH_CHILD | Allow NULL? |
| 24 | RESID | Indicator That Patient Is Non-Resident | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_RESID | Allow NULL? |
| 25 | MEDISAVE | IS-H: 'Carry Out MediSave Claim Estimation' Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_MEDISAVE | Allow NULL? |
| 26 | PSYCHIAT | IS-H: Psychiatric Case Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_PSYCHIAT | Allow NULL? |
| 27 | BARNR | IS-H: Personnel Number of Attending Physician | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | NGPA | BARNR | Allow NULL? |
| 28 | PKGTK | IS-H: Service Catalog Identification Key | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TNK01 | TARID | Allow NULL? |
| 29 | PKGLS | Service in Service Catalog | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | NTPK | TARLS | Allow NULL? |
| 30 | PKGSP | IS-H: Column in Service Catalog | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | NTSI | TARSP | Allow NULL? |
| 31 | FUNCNAME | IS-H: Function Module | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | TFDIR | ISH_EBILL_FB | Allow NULL? |
