| 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 | X00PATID | Reference Key of a Referenced Object | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | N2_REFKEY | Allow NULL? |
| 7 | N0_FACHABT | IS-H: Org. Unit (for OU-Related Service Entry Only) | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | * | ORGID_LS | Allow NULL? |
| 8 | N0_ANFOE | Departmental Organizational Unit That Requests the Service | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | * | ANFOE | Allow NULL? |
| 9 | N0_ERBOE | IS-H: Organizational Unit that Performs the Service | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | * | ERBOE | Allow NULL? |
| 10 | X00NUM | Reference Key of a Referenced Object | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | N2_REFKEY | Allow NULL? |
| 11 | N0_NUM | Surgery Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | N2_OPNR | Allow NULL? |
| 12 | N0_DATUM | Document Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | N2_DODAT | Allow NULL? |
| 13 | N0_PATNAME | Patient Name | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | N2_PATNAM | Allow NULL? |
| 14 | N0_GESCHLE | Patient Sex | char | 1 | 0 | CHAR | (N' ') | Yes | | N2_PATGES | Allow NULL? |
| 15 | N0_ALTER | Patient Age | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | N2_ALTERP | Allow NULL? |
| 16 | N0_ALTEINH | Unit of Age | char | 1 | 0 | CHAR | (N' ') | Yes | | N2_ALTEINH | Allow NULL? |
| 17 | N0_FALLNR | IS-H: Case Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | FALNR | Allow NULL? |
| 18 | N0_FALLART | Case Type | char | 1 | 0 | CHAR | (N' ') | Yes | | N2_FALLART | Allow NULL? |
| 19 | X00BDIAGNO | Reference Key of a Referenced Object | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | N2_REFKEY | Allow NULL? |
| 20 | N0_DIAGBEZ | Free Text for Diagnosis | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | ISH_DITEXT | Allow NULL? |
| 21 | N0_DIAGSCH | Diagnosis Code | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | N2_OPDIAS1 | Allow NULL? |
| 22 | N0_LOKALIS | IS-H: Localization of Diagnosis | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | N2_DIALO | Allow NULL? |
| 23 | N0_PROZTXT | Procedures Description | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | N2_OPPROZT | Allow NULL? |
| 24 | N0_PROZSCH | IS-H: Surgical Procedure Code (Service) | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | ICPM_LS | Allow NULL? |
| 25 | N0_KOPIE | Field with Character Length 50 | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | N2_CHAR50 | Allow NULL? |
| 26 | X00TEAMTAB | Reference Key of a Referenced Object | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | N2_REFKEY | Allow NULL? |
