| 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 | SRVID | Technical Key of an Object | nvarchar | 32 | 0 | CHAR | (N' ') | No | | N1UUID | Allow NULL? |
| 3 | SRVTYP | Services: Service Category | char | 1 | 0 | CHAR | (N' ') | Yes | | N1SRVTYP | Allow NULL? |
| 4 | EINRI | Institution | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TN01 | EINRI | Allow NULL? |
| 5 | PAPID | IS-H: Provisional Patient Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | NPAP | ISH_PAPID | Allow NULL? |
| 6 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | NPAT | PATNR | Allow NULL? |
| 7 | BCSHID | | nvarchar | 33 | 0 | | (N' ') | Yes | | | Allow NULL? |
| 8 | BCHID | Basic Catalog: Catalog Key | nvarchar | 33 | 0 | CHAR | (N' ') | Yes | N1BCH | N1BCHID | Allow NULL? |
| 9 | BCPID | Basic Cat.: Item Key | nvarchar | 33 | 0 | CHAR | (N' ') | Yes | N1BCP | N1BCPID | Allow NULL? |
| 10 | NAME | Services: Service Short Text | nvarchar | 128 | 0 | CHAR | (N' ') | Yes | | N1SRVNAME | Allow NULL? |
| 11 | ORGFA | Services: Departmental Organizational Unit | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | * | N1SRV_ORGFA | Allow NULL? |
| 12 | ORGPF | Services: Treatment Organizational Unit | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | * | N1SRV_ORGPF | Allow NULL? |
| 13 | PDUR | Services: Planned Service Duration in Minutes | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | N1SRV_PDUR | Allow NULL? |
| 14 | RDUR | Services: Actual Service Duration in Minutes | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | N1SRV_RDUR | Allow NULL? |
| 15 | STATUS | Service Status - User-Specific | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | N1LSSTA | N1LSSTAE | Allow NULL? |
| 16 | PSDAT | Services: Planned Start Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | N1SRV_PSDAT | Allow NULL? |
| 17 | PSTIM | Services: Planned Start Time | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | N1SRV_PSTIM | Allow NULL? |
| 18 | RSDAT | Services: Actual Start Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | N1SRV_RSDAT | Allow NULL? |
| 19 | RSTIM | Services: Actual Start Time | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | N1SRV_RSTIM | Allow NULL? |
| 20 | CYDAT | Services: Date of Cycle | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | N1SRV_CYDAT | Allow NULL? |
| 21 | CYTIM | Services: Time of Cycle | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | N1SRV_CYTIM | Allow NULL? |
| 22 | GENCYID | Generic Cycle Key | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | N1GENCYKEY | Allow NULL? |
| 23 | MANU | Services: Indicator for Manual Change | char | 1 | 0 | CHAR | (N' ') | Yes | | N1SRV_MANU | Allow NULL? |
| 24 | CANCELIND | Services: Cancellation Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | N1SRV_CANCELIND | Allow NULL? |
| 25 | CYDEFID | Unique ID of Cycle Definition | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | N1CYDEFID | Allow NULL? |
| 26 | TIMSP | ISHMED: Services: Time Span (in Hours) | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | N1SRV_TIMSP | Allow NULL? |
| 27 | ERDAT | IS-H: Date when Record Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_ERDAT | Allow NULL? |
| 28 | ERTIM | IS-H: Time Record Created | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | RI_ERTIM | Allow NULL? |
| 29 | ERUSR | IS-H: Name of Employee who Created Record | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RI_ERNAM | Allow NULL? |
| 30 | UPDAT | IS-H: Date of Last Change | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_UPDAT | Allow NULL? |
| 31 | UPTIM | IS-H: Time of Last Change | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | RI_UPTIM | Allow NULL? |
| 32 | UPUSR | IS-H: Name of Person who Last Changed Data | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RI_UPNAM | Allow NULL? |
| 33 | STOKZ | IS-H: Cancellation Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | RI_STORN | Allow NULL? |
| 34 | STODAT | Date of Cancellation | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | STORN_DAT | Allow NULL? |
| 35 | STOTIM | Time of Cancellation | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | ISH_STORN_TIM | Allow NULL? |
| 36 | STOUSR | IS-H: Name of User who Canceled Data Record | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | STORN_USER | Allow NULL? |
| 37 | STOID | Reason for Canceling Medical Object | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | N1STOID | Allow NULL? |
| 38 | TIMESTAMP | UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) | decimal | 21 | 7 | DEC | ((0)) | Yes | | TIMESTAMPL | |
