| 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 | FALNR | IS-H: Case Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | FALNR | Allow NULL? |
| 3 | EINRI | Institution | nvarchar | 4 | 0 | CHAR | (N' ') | No | * | EINRI | Allow NULL? |
| 4 | SEQID | Sequence Number of SSNID per Case | nvarchar | 5 | 0 | NUMC | (N'00000') | No | | ISH_IT_LFDSSNID | Allow NULL? |
| 5 | SEQMR | Sequence Number of SSN Records per Case | nvarchar | 5 | 0 | NUMC | (N'00000') | No | | ISH_IT_LFDNTNR | Allow NULL? |
| 6 | STAND | IS-HCM: Communications Standard | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | * | CMSTD | Allow NULL? |
| 7 | STVER | IS-HCM: Version of Communication Standard | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | STDVER | Allow NULL? |
| 8 | NTOWNERCODE | IS-HCM: Message Type Owner Code | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | NTOWNERCDE | Allow NULL? |
| 9 | NTNR | IS-HCM: Message Type Number | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | NTNR | Allow NULL? |
| 10 | SGOWNERCODE | IS-HCM: Message Segment Owner Code | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | SGOWNERCDE | Allow NULL? |
| 11 | SGNR | IS-HCM: Message Segment Number | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | SGNR | Allow NULL? |
| 12 | DCSTATI | IS-H: Detailed Internal Communication Status | char | 1 | 0 | CHAR | (N' ') | Yes | | N_DCSTATI | Allow NULL? |
| 13 | RECDESC | SDO Record (Inpatient) and AMB Record (Outpatient) | ntext | 1073741823 | 0 | | | Yes | | ISH_IT_RECDESC | |
| 14 | ERDAT | IS-H: Date when Record Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_ERDAT | Allow NULL? |
| 15 | ERTIM | IS-H: Time Record Created | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | RI_ERTIM | Allow NULL? |
| 16 | ERUSR | IS-H: Name of Employee who Created Record | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RI_ERNAM | Allow NULL? |
| 17 | AMBTEMP | Indicator for Temporary AMB Record (ON-Temporary, OFF-Final) | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_IT_AMBTEMP | Allow NULL? |
| 18 | PCNTR | Progressive Counter for AMB Record | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | ISH_IT_PCNTR | Allow NULL? |
