| 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 | * | MANDT | Allow NULL? |
| 2 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | PATNR | Allow NULL? |
| 3 | FALNR | IS-H: Case Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | FALNR | Allow NULL? |
| 4 | LNRTMN | IS-H: Identification of Appointment | nvarchar | 10 | 0 | CHAR | (N' ') | No | | ISH_TMNID | Allow NULL? |
| 5 | LFDNR | Sequence Number of Form Logging | nvarchar | 5 | 0 | NUMC | (N'00000') | No | | LFDNR_NFOR | Allow NULL? |
| 6 | EINRI | Institution | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | EINRI | Allow NULL? |
| 7 | TOMID | IS-H: Work Organizer Key | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | * | TOMID | Allow NULL? |
| 8 | LOMID | IS-H: Work Organizer Type Key | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | * | LOMID | Allow NULL? |
| 9 | FBFORM | IS-H: Customer Function Module for Logical Work Organizer | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | FBFORM_C | Allow NULL? |
| 10 | TDFORM | IS-H: Form name of a SAPscript form | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | N_TDFORM | Allow NULL? |
| 11 | TDTEXT | IS-H: Description of a Form | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | ISH_TDTEXT | Allow NULL? |
| 12 | TDDEST | Spool: Output device | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | RSPOPNAME | Allow NULL? |
| 13 | BEDINGUNG | IS-H: Condition for technical work organizer | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | ISH_BEDING | Allow NULL? |
| 14 | OMTYP | Category of Work Organizer Type | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_OMTYP | Allow NULL? |
| 15 | FBPRINT | IS-H: User-Defined Print Function Module | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | ISH_FUBU | Allow NULL? |
| 16 | PROTTYP | IS-H: Logging Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | N_PROTTYP | Allow NULL? |
| 17 | UPDAT | IS-H: Date of Last Change | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_UPDAT | Allow NULL? |
| 18 | UPZT | IS-H: Time of Last Change | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | RI_UPTIM | Allow NULL? |
| 19 | UPUSR | IS-H: Name of Person who Last Changed Data | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RI_UPNAM | Allow NULL? |
| 20 | LOEKZ | Deletion Flag/Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | RI_LOEKZ | Allow NULL? |
| 21 | SFFNAME | Smart Forms: Form Name | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | STXFADM | TDSFNAME | Allow NULL? |
| 22 | SFVARIA | Smart Forms: Variant | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | STXFVAR | TDVARIANT | Allow NULL? |
| 23 | SMARTFACT | IS-H: Smart Forms Active | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_SMARTFORMS_ACTIVE | Allow NULL? |
| 24 | AFNAME | Name of Form Object | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | ISH_FP_NAME | Allow NULL? |
| 25 | AFACT | PDF-Based Forms Active | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_FP_ACTIVE | Allow NULL? |
| 26 | AFSFCOMP | IS-H: Boolean Data Type for ON (= "X") and OFF (= " ") | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_ON_OFF | Allow NULL? |
| 27 | ACTION_GUID | | nvarchar | 32 | 0 | | (N' ') | Yes | | | Allow NULL? |
| 28 | PROCESSING_TYPE | | nvarchar | 3 | 0 | | (N' ') | Yes | | | Allow NULL? |
| 29 | REQUEST_GUID | | nvarchar | 32 | 0 | | (N' ') | Yes | | | Allow NULL? |
| 30 | LFDBEW | IS-H: Sequence Number of Movement | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | * | LFDBEW | Allow NULL? |
