| 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 | LOGID | Logbook: ID of log entry | nvarchar | 12 | 0 | CHAR | (N' ') | No | | DIACL_LOGID | Allow NULL? |
| 3 | STXT | Logbook: log entry short text | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | DIACL_STXT | Allow NULL? |
| 4 | COCE | Logbook: flag for certified completion | char | 1 | 0 | CHAR | (N' ') | Yes | | DIACL_COCE | Allow NULL? |
| 5 | MDOCM_OPTIME | Measurement Document | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | * | IMRC_MDOCM | Allow NULL? |
| 6 | MDOCM_CYCLES | Measurement Document | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | * | IMRC_MDOCM | Allow NULL? |
| 7 | STARTTM | Logbook: start of operation time | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | DIACL_START_TM | Allow NULL? |
| 8 | ENDTM | Logbook: end of operation time | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | DIACL_END_TM | Allow NULL? |
| 9 | STARTDT | Logbook: start of operation date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DIACL_START_DT | Allow NULL? |
| 10 | ENDDT | Logbook: end of operation date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DIACL_END_DT | Allow NULL? |
| 11 | STARTTZ | Logbook: time zone for start of operation time | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | TTZZ | DIACL_START_TZ | Allow NULL? |
| 12 | ENDTZ | Logbook: time zone for end of operation time | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | TTZZ | DIACL_END_TZ | Allow NULL? |
| 13 | CYCLES | Logbook: number of performed cycles | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | | DIACL_CYCLES | Allow NULL? |
| 14 | LETYP | Log Entry Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | DIACL_LETYP_T | DIACL_LETYP | Allow NULL? |
| 15 | OBJNR | Object Number for Log Entry | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | * | DIACL_LEOBJ | Allow NULL? |
| 16 | ORIGIN | Logbook: Flight Origin | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | DIACL_ORIGIN | Allow NULL? |
| 17 | DESTINATION | Logbook: Flight Destination | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | DIACL_DESTINATION | Allow NULL? |
| 18 | FLID | Order Number | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | AUFNR | Allow NULL? |
| 19 | FREE_TEXT | Text (80 Characters) | nvarchar | 80 | 0 | CHAR | (N' ') | Yes | | TEXT80 | Allow NULL? |
| 20 | UTYPE | Log Entry Usage Type | char | 1 | 0 | CHAR | (N' ') | Yes | | DIACL_LGE_UTYPE | Allow NULL? |