| 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 | EINRI | Institution | nvarchar | 4 | 0 | CHAR | (N' ') | No | TN01 | EINRI | Allow NULL? |
| 3 | EDIPROC | IS-HCM: EDI Procedure | nvarchar | 5 | 0 | CHAR | (N' ') | No | TNC301G0 | N_EDIPROC | Allow NULL? |
| 4 | TECHADR | IS-H: Technical Address of Sender or Receiver | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | N_TECHADR | Allow NULL? |
| 5 | ADRTYPE | IS-H EDI: Address Type to Further Classify Technical Address | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | N_EDIADRTY | Allow NULL? |
| 6 | ID1 | IS-H EDI: Hospital/Institution Number (External Code) | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | N_INSTID | Allow NULL? |
| 7 | ID2 | IS-H EDI: Hospital/Institution Number (External Code) | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | N_INSTID2 | Allow NULL? |
| 8 | ID3 | IS-H EDI: Hospital/Institution Number (External Code) | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | N_INSTID3 | Allow NULL? |
| 9 | UPDAT | IS-H: Date of Last Change | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_UPDAT | Allow NULL? |
| 10 | UPTIM | IS-H: Time Data Record was Last Changed | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | ISH_UPTIM | Allow NULL? |
| 11 | UPUSR | IS-H: Name of Person who Last Changed Data | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RI_UPNAM | Allow NULL? |
| 12 | ERDAT | IS-H: Date when Record Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_ERDAT | Allow NULL? |
| 13 | ERTIM | IS-H: Time when Data Record Created | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | ISH_ERTIM | Allow NULL? |
| 14 | ERUSR | IS-H: Name of Employee who Created Record | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RI_ERNAM | Allow NULL? |
| 15 | SUPAUTOCH | IS-H: Suppress Automatic Change Messages | char | 1 | 0 | CHAR | (N' ') | Yes | | N_SUPAUTOCH | Allow NULL? |
| 16 | EREASON | IS-H: Default Change Reason, External Code | char | 1 | 0 | CHAR | (N' ') | Yes | | N_DEFEREASON | Allow NULL? |
| 17 | EXTRANR | IS-H: Additional Number Range for Communicat. Case Desc. | char | 1 | 0 | CHAR | (N' ') | Yes | | N_EXTRANR | Allow NULL? |
| 18 | HOLDEDI | IS-H: Hold Flag Until Another EDI Procedure Has Finished | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_HOLDEDI | Allow NULL? |
| 19 | REFCD | IS-H: Contact Person for Communication Procedure MEDRUC | nvarchar | 17 | 0 | CHAR | (N' ') | Yes | | ISH_MRUCREFCD | Allow NULL? |
| 20 | REFER | IS-H: Contact Person for Communication Procedure MEDRUC | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | ISH_MRUCREFER | Allow NULL? |
| 21 | COMTE | IS-H: Method of Communication for Contact Person | nvarchar | 128 | 0 | CHAR | (N' ') | Yes | | ISH_MRUCCOM | Allow NULL? |
| 22 | COMFC | IS-H: Method of Communication for Contact Person | nvarchar | 128 | 0 | CHAR | (N' ') | Yes | | ISH_MRUCCOM | Allow NULL? |
| 23 | COMEM | IS-H: Method of Communication for Contact Person | nvarchar | 128 | 0 | CHAR | (N' ') | Yes | | ISH_MRUCCOM | Allow NULL? |
| 24 | SEL_PRI | IS-H: Take Printed Invoices into Account | char | 1 | 0 | CHAR | (N' ') | No | | ISH_SEL_PRI | Allow NULL? |
