| 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 | DEXTASKID | Internal Key for Data Exchange Task | nvarchar | 22 | 0 | CHAR | (N' ') | No | | E_DEXTASKID | Allow NULL? |
| 3 | INT_UI | Internal key for point of delivery | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | EUIHEAD | INT_UI | Allow NULL? |
| 4 | DEXPROC | Data Exchange Process | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | EDEXPROC | E_DEXPROC | Allow NULL? |
| 5 | DEXSERVPROV | Third Party Service Provider | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | ESERVPROV | E_DEXSERVPROV | Allow NULL? |
| 6 | DEXSERVPROVSELF | Own Service Provider | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | ESERVPROV | E_DEXSERVPROVSELF | Allow NULL? |
| 7 | DEXSTATUS | Status in Data Exchange Process | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | EDEXSTATUS | E_DEXSTATUS | Allow NULL? |
| 8 | CORRECTED | Error in Data Exchange Task Task Corrected | char | 1 | 0 | CHAR | (N' ') | Yes | | E_DEXERRORCORR | Allow NULL? |
| 9 | DEXTASKREASON | Reason for Data Exchange Task | char | 1 | 0 | CHAR | (N' ') | Yes | | E_DEXTASKREASON | Allow NULL? |
| 10 | DEXDUEDATE | Due Date for Data Exchange Task | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | E_DEXDUEDATE | Allow NULL? |
| 11 | DEXDUETIME | Time Due for Data Exchange Task | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | E_DEXDUETIME | Allow NULL? |
| 12 | DEXREFDATEFROM | From Date for Reference Period | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | E_DEXREFDATEFROM | Allow NULL? |
| 13 | DEXREFTIMEFROM | From Time for Reference Period | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | E_DEXREFTIMEFROM | Allow NULL? |
| 14 | DEXREFDATETO | To Date for Reference Period | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | E_DEXREFDATETO | Allow NULL? |
| 15 | DEXREFTIMETO | Time for Reference Period | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | E_DEXREFTIMETO | Allow NULL? |
| 16 | DEXAEDAT | Date of Last Data Exchange Task Change | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | E_DEXAEDAT | Allow NULL? |
| 17 | DEXAETIM | Time of Last Change to Data Exchange Task | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | E_DEXAETIM | Allow NULL? |
| 18 | AENAM | Name of Person Who Changed Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | AENAM | Allow NULL? |
| 19 | DEXCOMMFORMID | Identification of Communication Type | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | EDEXCOMMFORMAT | E_DEXCOMMFORMID | Allow NULL? |