| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Mandant | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | EINRI | IS-H: Einrichtung | nvarchar | 4 | 0 | CHAR | (N' ') | No | * | EINRI | Allow NULL? |
| 3 | DDSNUM | Laufende Nummer DBC-code | nvarchar | 10 | 0 | NUMC | (N'0000000000') | No | | ISH_NL_DBCNR | Allow NULL? |
| 4 | RESLOG | Declaration dataset Ergebnis log | int | 10 | 0 | INT4 | ((0)) | No | | ISH_NL_RESLOG | Allow NULL? |
| 5 | DBCNR | Laufende Nummer DBC-code | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | ISH_NL_DBCNR | Allow NULL? |
| 6 | DDSNR | Deklaration dataset nummer | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | ISH_NL_DDSNR | Allow NULL? |
| 7 | DLVTY | Verarbeitungs type | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_NL_DLVTY | Allow NULL? |
| 8 | HCAT | IS-H: Art / Typ des Krankenhauses | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | ISH_KART | Allow NULL? |
| 9 | KHNUM | IS-H: Krankenhausnummer für KHStatV | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | ISH_KHNUM | Allow NULL? |
| 10 | GSCHL | IS-H NL: LAZR Geslachtscode | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_GSCHL | Allow NULL? |
| 11 | GBDAT | IS-H NL: Geboortedatum (ddmmjjjj) | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | ISH_GBDAT | Allow NULL? |
| 12 | CLAIM | Haftung ZVW indikation | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_NL_CLAIM_IND | Allow NULL? |
| 13 | ERDAT | IS-H: Datum, an dem der Satz hinzugefügt wurde | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_ERDAT | Allow NULL? |
| 14 | ERNAM | IS-H: Name des Sachbearbeiters, der den Satz hinzugefügt hat | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RI_ERNAM | Allow NULL? |
| 15 | UPDAT | IS-H: Änderungsdatum | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_UPDAT | Allow NULL? |
| 16 | UPNAM | IS-H: Name des ändernden Sachbearbeiters | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RI_UPNAM | Allow NULL? |
| 17 | STORN | IS-H: Stornokennzeichen | char | 1 | 0 | CHAR | (N' ') | Yes | | RI_STORN | Allow NULL? |
| 18 | TIMESTAMP | IS-H: Zeitstempel in Kurzform (JJJJMMTThhmmss) | decimal | 15 | 0 | DEC | ((0)) | Yes | | ISH_TIMESTAMP | |
