| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | ID | Character Field Length = 10 | nvarchar | 10 | 0 | CHAR | (N' ') | No | | CHAR10 | Allow NULL? |
| 2 | TASKNAME | Character field of length 40 | nvarchar | 40 | 0 | CHAR | (N' ') | No | | CHAR40 | Allow NULL? |
| 3 | TASKMODE | Single-Character Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | CHAR1 | Allow NULL? |
| 4 | TASKICON | Not More Closely Defined Area, Possibly Used for Patchlevels | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | CHAR4 | Allow NULL? |
| 5 | SHORT_TEXT | Text, 40 Characters Long | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | TEXT40 | Allow NULL? |
| 6 | LONG_TEXT | Text (80 Characters) | nvarchar | 80 | 0 | CHAR | (N' ') | Yes | | TEXT80 | Allow NULL? |
| 7 | ICON_1 | Not More Closely Defined Area, Possibly Used for Patchlevels | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | CHAR4 | Allow NULL? |
| 8 | ICON_2 | Not More Closely Defined Area, Possibly Used for Patchlevels | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | CHAR4 | Allow NULL? |
| 9 | ICON_3 | Not More Closely Defined Area, Possibly Used for Patchlevels | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | CHAR4 | Allow NULL? |
| 10 | ICON_4 | Not More Closely Defined Area, Possibly Used for Patchlevels | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | CHAR4 | Allow NULL? |
| 11 | ICON_5 | Not More Closely Defined Area, Possibly Used for Patchlevels | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | CHAR4 | Allow NULL? |
| 12 | ICON_6 | Not More Closely Defined Area, Possibly Used for Patchlevels | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | CHAR4 | Allow NULL? |
| 13 | ICON_7 | Not More Closely Defined Area, Possibly Used for Patchlevels | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | CHAR4 | Allow NULL? |
| 14 | ICON_8 | Not More Closely Defined Area, Possibly Used for Patchlevels | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | CHAR4 | Allow NULL? |
| 15 | ICON_9 | Not More Closely Defined Area, Possibly Used for Patchlevels | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | CHAR4 | Allow NULL? |
| 16 | ICON_10 | Not More Closely Defined Area, Possibly Used for Patchlevels | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | CHAR4 | Allow NULL? |
| 17 | STATUS | Single-Character Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | CHAR1 | Allow NULL? |
| 18 | PLANTIME | ABAP Time Stamp | nvarchar | 14 | 0 | CHAR | (N' ') | Yes | | ABSTAMP | Allow NULL? |
| 19 | REQ_BY | User Name | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | UNAME | Allow NULL? |
| 20 | REQ_SID | Name of SAP System | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | SYSYSID | Allow NULL? |
| 21 | REQ_DEST | Logical Destination (Specified in Function Call) | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | * | RFCDEST | Allow NULL? |
| 22 | REQ_INSTALL_NO | 10 digit number | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | NUM10 | Allow NULL? |
| 23 | CATEGORY | Character Field of Length 12 | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | CHAR12 | Allow NULL? |
| 24 | JOBNAME | Background job name | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | BTCJOB | Allow NULL? |
| 25 | JOBCOUNT | Job ID | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | BTCJOBCNT | Allow NULL? |
| 26 | NO_TRIES | Four-digit number | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | NUM4 | Allow NULL? |
| 27 | CREATED_BY | User Name | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | UNAME | Allow NULL? |
| 28 | CHANGED_BY | User Name | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | UNAME | Allow NULL? |
| 29 | CREATED | ABAP Time Stamp | nvarchar | 14 | 0 | CHAR | (N' ') | Yes | | ABSTAMP | Allow NULL? |
| 30 | CHANGED | ABAP Time Stamp | nvarchar | 14 | 0 | CHAR | (N' ') | Yes | | ABSTAMP | Allow NULL? |
