| 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 | EVENTID | Identification of an Event | nvarchar | 32 | 0 | CHAR | (N' ') | No | | ISH_HCF_EVENT_ID | Allow NULL? |
| 3 | LUWID | Identification of the Application Transaction | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | ISH_HCF_LUW_ID | Allow NULL? |
| 4 | TCODE | Transaction Code | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | * | TCODE | Allow NULL? |
| 5 | APPLK | Application (Always N for IS-H) | char | 1 | 0 | CHAR | (N' ') | Yes | | APPKL | Allow NULL? |
| 6 | EVENT | IS-H: Event for Triggering Messages, Forms | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | * | N_EVENT | Allow NULL? |
| 7 | EINRI | Institution | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | EINRI | Allow NULL? |
| 8 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | PATNR | Allow NULL? |
| 9 | FALNR | IS-H: Case Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | FALNR | Allow NULL? |
| 10 | LFDBEW | IS-H: Sequence Number of Movement | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | * | LFDBEW | Allow NULL? |
| 11 | MEDRECFLDRID | IS-H : Identifier for the Medical Record Folder | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | ISH_MEDRECID | Allow NULL? |
| 12 | KEY1 | IS-HCM: Key Value for Data Retrieval for Dispatch Order | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | KEYARG | Allow NULL? |
| 13 | KEY2 | IS-HCM: Key Value for Data Retrieval for Dispatch Order | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | KEYARG | Allow NULL? |
| 14 | KEY3 | IS-HCM: Key Value for Data Retrieval for Dispatch Order | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | KEYARG | Allow NULL? |
| 15 | KEY4 | IS-HCM: Key Value for Data Retrieval for Dispatch Order | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | KEYARG | Allow NULL? |
| 16 | KEY5 | IS-HCM: Key Value for Data Retrieval for Dispatch Order | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | KEYARG | Allow NULL? |
| 17 | KEY6 | IS-HCM: Key Value for Data Retrieval for Dispatch Order | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | KEYARG | Allow NULL? |
| 18 | CREATE_TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | DEC | ((0)) | Yes | | TZNTSTMPS | |
| 19 | CREATE_USER | IS-H: Name of Employee who Created Record | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RI_ERNAM | Allow NULL? |
| 20 | CHANGE_TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | DEC | ((0)) | Yes | | TZNTSTMPS | |
| 21 | CHANGE_USER | IS-H: Name of Employee who Created Record | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RI_ERNAM | Allow NULL? |
| 22 | ERRORTEXT | Event Processing Error | ntext | 1073741823 | 0 | | | Yes | | ISH_HCF_EVENT_ERROR | |
| 23 | RUNID | Identification of a Report Run | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | ISH_HCF_RUN_ID | Allow NULL? |
