| 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 | EDIPMANDT | Allow NULL? |
| 2 | RCVPRN | Partner Number of Receiver | nvarchar | 10 | 0 | CHAR | (N' ') | No | EDPP1 | EDIPRCVPRN | Allow NULL? |
| 3 | RCVPRT | Partner Type of Receiver | nvarchar | 2 | 0 | CHAR | (N' ') | No | TEDST | EDIPRCVPRT | Allow NULL? |
| 4 | RCVPFC | Partner function of recipient | nvarchar | 2 | 0 | CHAR | (N' ') | No | | EDIPRCVPFC | Allow NULL? |
| 5 | MESTYP | Message Type | nvarchar | 30 | 0 | CHAR | (N' ') | No | EDIMSG | EDIPMESTYP | Allow NULL? |
| 6 | MESCOD | Message code | nvarchar | 3 | 0 | CHAR | (N' ') | No | | EDIPMESCOD | Allow NULL? |
| 7 | MESFCT | Message function | nvarchar | 3 | 0 | CHAR | (N' ') | No | | EDIPMESFCT | Allow NULL? |
| 8 | TEST | Flag for test mode | char | 1 | 0 | CHAR | (N' ') | No | | EDIPTEST | Allow NULL? |
| 9 | METHOD | Choice: EDI or ALE (no longer used) | char | 1 | 0 | CHAR | (N' ') | Yes | | EDIPMETHOD | Allow NULL? |
| 10 | DOCTYP | IDoc type | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | * | EDIPDOCTYP | Allow NULL? |
| 11 | SYNCHK | Cancel Processing After Syntax Error | char | 1 | 0 | CHAR | (N' ') | Yes | | EDIPSYNCHK | Allow NULL? |
| 12 | USRTYP | User Type | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | EDIPUSRTYP | Allow NULL? |
| 13 | USRKEY | Permitted users: ID | nvarchar | 70 | 0 | CHAR | (N' ') | Yes | | EDIPUSRKEY | Allow NULL? |
| 14 | USRLNG | Language of notification | char | 1 | 0 | LANG | (N' ') | Yes | T002 | EDIPUSRLNG | Allow NULL? |
| 15 | ALEADR | Address for ALE | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | EDIPALEADR | Allow NULL? |
| 16 | ALESCA | Communication type of recipient for ALE | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | EDIPALESCA | Allow NULL? |
| 17 | OUTMOD | Output Mode | char | 1 | 0 | CHAR | (N' ') | Yes | | EDIPOUTMOD | Allow NULL? |
| 18 | RCVPOR | Receiver port | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | EDIPORT | EDIPRCVPOR | Allow NULL? |
| 19 | IDOCTYP | Basic type | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | EDIMSG | EDIPIDOCTP | Allow NULL? |
| 20 | CIMTYP | Extension (customer extension of basic IDoc type) | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | EDIMSG | EDIPCIMTYP | Allow NULL? |
| 21 | STD | EDI Standard | char | 1 | 0 | CHAR | (N' ') | Yes | | EDI_PVSTD | Allow NULL? |
| 22 | STDVRS | Version of EDI standard | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | EDI_PVSTDV | Allow NULL? |
| 23 | STDMES | EDI message type | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | EDI_PVSTDM | Allow NULL? |
| 24 | PCKSIZ | Size of IDoc packets to be sent (unit: IDoc) | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | EDIPPCKSIZ | Allow NULL? |
| 25 | IDOCVRS | Version of segment definition (not used) | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | EDI_IDCVRS | Allow NULL? |
| 26 | SEGREL | Release of IDoc segment | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | EDI_SEGREL | Allow NULL? |
| 27 | EDIVIEW | View of IDoc type | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | EDVIEW | EDIVIEW | Allow NULL? |
| 28 | SEGAPPLREL | Application Release in which IDoc Segment Released | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | EDI_SEGARL | Allow NULL? |
| 29 | QURULE | Rule Name | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | EDI_REGELNAME | Allow NULL? |
| 30 | SYNNORUN | Disable Outbound Syntax Check Explicitly | char | 1 | 0 | CHAR | (N' ') | Yes | | EDIPNOSYNC | Allow NULL? |
