| 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 | LNRAPP | IS-H: Sequence Number of Provisional Appointment | nvarchar | 10 | 0 | CHAR | (N' ') | No | | ISH_LNRAPP | Allow NULL? |
| 3 | EINRI | Institution | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TN01 | EINRI | Allow NULL? |
| 4 | FALNR | IS-H: Case Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | FALNR | Allow NULL? |
| 5 | LFDNR | IS-H: Sequence Number of Movement | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | NBEW | LFDBEW | Allow NULL? |
| 6 | DSPTY | IS-H: Scheduling Type for Visit Scheduling | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | TN40B | ISH_DSPT | Allow NULL? |
| 7 | VISTY | IS-H: Code of Visit Category for Visit Scheduling | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_BT | Allow NULL? |
| 8 | BWIDT | IS-H: Date of Movement | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BWIDT | Allow NULL? |
| 9 | BWIZT | IS-H: Time of Movement | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | BWIZT | Allow NULL? |
| 10 | STATU | IS-H: Internal Status of Outpatient Visit | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | ISH_ABSTIN | Allow NULL? |
| 11 | ORGFA | IS-H: OU with Departmental Responsibility for Case | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | NORG | NZUWFA | Allow NULL? |
| 12 | ORGPF | Organizational Unit Assigned to Case | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | NORG | NZUWPF | Allow NULL? |
| 13 | POBNR | IS-H: Internal Sequence Number of Planning Object | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | NPOB | ISH_POBNR | Allow NULL? |
| 14 | PERNR | IS-H: Person Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | NGPA | PERNR_FALL | Allow NULL? |
| 15 | ZIMMR | IS-H: Building ID of Room | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | NBAU | ISH_ZIMMID | Allow NULL? |
| 16 | KZTXT | Comment on Case Movement | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | TEXT_BEW | Allow NULL? |
| 17 | ERDAT | IS-H: Date when Record Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_ERDAT | Allow NULL? |
| 18 | ERUSR | IS-H: Name of Employee who Created Record | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RI_ERNAM | Allow NULL? |
| 19 | UPDAT | IS-H: Date of Last Change | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_UPDAT | Allow NULL? |
| 20 | UPUSR | IS-H: Name of Person who Last Changed Data | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RI_UPNAM | Allow NULL? |
| 21 | LGTXT | Indicator that Long Text Exists | char | 1 | 0 | CHAR | (N' ') | Yes | | RI_LGTXT | Allow NULL? |
| 22 | DAUER | IS-H: Duration in Minutes for Treatment Appointment | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | ISH_APTIME | Allow NULL? |
| 23 | FACHR | Specialty for Physicians | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TNKFA | FACHRTY5 | Allow NULL? |
| 24 | PELOC | IS-H: Person Being Substituted | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | ISH_PELOC | Allow NULL? |
| 25 | STOID | IS-H: Reason for Canceling Movement | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | N1BSTOID | Allow NULL? |
| 26 | STORN | IS-H: Cancellation Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | RI_STORN | Allow NULL? |
| 27 | STUSR | IS-H: Name of User who Canceled Data Record | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | STORN_USER | Allow NULL? |
| 28 | STDAT | Date of Cancellation | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | STORN_DAT | Allow NULL? |
| 29 | TMNID | IS-H: Identification of Appointment | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | NTMN | ISH_TMNID | Allow NULL? |
| 30 | PTINP | IS-H: Inpatient Scheduling Type | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | N1PTI | N1PTINP | Allow NULL? |
