| 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 | DOKAR | Document Type | nvarchar | 3 | 0 | CHAR | (N' ') | No | * | DOKAR | Allow NULL? |
| 3 | DOKNR | Document number | nvarchar | 25 | 0 | CHAR | (N' ') | No | * | DOKNR | Allow NULL? |
| 4 | DOKVR | Document Version | nvarchar | 2 | 0 | CHAR | (N' ') | No | | DOKVR | Allow NULL? |
| 5 | DOKTL | Document Part | nvarchar | 3 | 0 | CHAR | (N' ') | No | | DOKTL_D | Allow NULL? |
| 6 | X00KOPF | Reference Key of a Referenced Object | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | N2_REFKEY | Allow NULL? |
| 7 | ISHMFALLNR | IS-H: Case Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | FALNR | Allow NULL? |
| 8 | ISHMPATNAM | Text (30 Characters) | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | TEXT30 | Allow NULL? |
| 9 | ISHMPATGEB | Field of type DATS | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DATS | Allow NULL? |
| 10 | N6AZGVGIK | | char | 1 | 0 | | (N' ') | Yes | | | Allow NULL? |
| 11 | N6AZGGGPL | | char | 1 | 0 | | (N' ') | Yes | | | Allow NULL? |
| 12 | N6AZGAKGB | PERINAT: Indicator whether born outside of clinic | char | 1 | 0 | CHAR | (N' ') | Yes | | N1PDAZGAKGB | Allow NULL? |
| 13 | N6AZGAUFN | PERINAT: Admission date of the mother | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | N1PDAZGAUFN | Allow NULL? |
| 14 | N6AZGMM | | nvarchar | 2 | 0 | | (N'00') | Yes | | | Allow NULL? |
| 15 | N6AZGCTG | | char | 1 | 0 | | (N' ') | Yes | | | Allow NULL? |
| 16 | N6AZGWBDT | | nvarchar | 8 | 0 | | (N'00000000') | Yes | | | Allow NULL? |
| 17 | N6AZGWBTI | | nvarchar | 6 | 0 | | (N'000000') | Yes | | | Allow NULL? |
| 18 | N6AZGMCR | | char | 1 | 0 | | (N' ') | Yes | | | Allow NULL? |
| 19 | N6AZGTAB | | char | 1 | 0 | | (N' ') | Yes | | | Allow NULL? |
| 20 | N6AZGGEL | | char | 1 | 0 | | (N' ') | Yes | | | Allow NULL? |
| 21 | N6AZGGEIN | | char | 1 | 0 | | (N' ') | Yes | | | Allow NULL? |
| 22 | N6AZGAMN | | char | 1 | 0 | | (N' ') | Yes | | | Allow NULL? |
| 23 | N6AZGOXYT | | char | 1 | 0 | | (N' ') | Yes | | | Allow NULL? |
| 24 | N6AZGPROG | | char | 1 | 0 | | (N' ') | Yes | | | Allow NULL? |
| 25 | N6AZGMBU | | char | 1 | 0 | | (N' ') | Yes | | | Allow NULL? |
| 26 | N6AZGCTG1 | PERINAT: Values for CTG - internal, external, none | char | 1 | 0 | CHAR | (N' ') | Yes | | N1PDAZGCTG1 | Allow NULL? |
| 27 | N6AZGKCTG | | nvarchar | 2 | 0 | | (N'00') | Yes | | | Allow NULL? |
| 28 | N6AZGANAL | | char | 1 | 0 | | (N' ') | Yes | | | Allow NULL? |
| 29 | N6AZGANSO | PERINAT: Other anesthesia | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | N1PDAZGANSO | Allow NULL? |
| 30 | N6AZGMEHR | | char | 1 | 0 | | (N' ') | Yes | | | Allow NULL? |
| 31 | N6AZGANKI | | nvarchar | 2 | 0 | | (N'00') | Yes | | | Allow NULL? |
| 32 | N6AZGGEBJ | | nvarchar | 2 | 0 | | (N'00') | Yes | | | Allow NULL? |
| 33 | N6AZGGEB | PERINAT: Birth number | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | | N1PDAZGGEB | Allow NULL? |
| 34 | EINRI | Institution | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | EINRI | Allow NULL? |
| 35 | N6AZGANVO | PERINAT: General anesthesia (checkbox) | char | 1 | 0 | CHAR | (N' ') | Yes | | N1PDAZGANVO | Allow NULL? |
| 36 | N6AZGANPD | PERINAT: Anesthesia - epidural (checkbox) | char | 1 | 0 | CHAR | (N' ') | Yes | | N1PDAZGANPD | Allow NULL? |
| 37 | N6AZGANPU | PERINAT: Anesthesia - pudendal (checkbox) | char | 1 | 0 | CHAR | (N' ') | Yes | | N1PDAZGANPU | Allow NULL? |
| 38 | N6AZGANLO | PERINAT: Anesthesia - local (checkbox) | char | 1 | 0 | CHAR | (N' ') | Yes | | N1PDAZGANLO | Allow NULL? |
| 39 | N6AZGANS | PERINAT: Anesthesia - other (checkbox) | char | 1 | 0 | CHAR | (N' ') | Yes | | N1PDAZGANS | Allow NULL? |
| 40 | N6AZGBAFE | PERINAT: Blood gas analysis pH value (fetal blood) | decimal | 4 | 2 | DEC | ((0)) | Yes | | N1PDAZGBAFE | |
| 41 | N6AZGSPIN | | char | 1 | 0 | CHAR | (N' ') | Yes | | N1PDAZGSPIN | Allow NULL? |
| 42 | N6AZGALTM | PERINAT: Alternative methods | char | 1 | 0 | CHAR | (N' ') | Yes | | N1PDAZGALTM | Allow NULL? |
| 43 | N6AZGAKUP | PERINAT: Acupuncture | char | 1 | 0 | CHAR | (N' ') | Yes | | N1PDAZGAKUP | Allow NULL? |
| 44 | N6AZGBABE | PERINAT: Blood gas analysis BE (fetal blood) | decimal | 3 | 1 | DEC | ((0)) | Yes | | N1PDAZGBABE | |
| 45 | N6AZGGEBN | PERINAT: Birth number (new!) | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | | N1PDAZGGEBN | Allow NULL? |
| 46 | N6AZGANMA | | char | 1 | 0 | | (N' ') | Yes | | | Allow NULL? |
| 47 | N6AZGANMA2 | | char | 1 | 0 | | (N' ') | Yes | | | Allow NULL? |
| 48 | N6AZGBEX | PERINAT: Blood Gas Analysis BE (Fetal Blood) | decimal | 3 | 1 | DEC | ((0)) | Yes | | N1PDAZGBEX | |
| 49 | N6AZGMEDIK | | char | 1 | 0 | | (N' ') | Yes | | | Allow NULL? |
| 50 | N6AZGMETXT | Text Field | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | TEXT50 | Allow NULL? |
| 51 | N6AZGMESO | Checkbox | char | 1 | 0 | CHAR | (N' ') | Yes | | XFELD | Allow NULL? |