| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | LOGON_CLIENT | Client ID | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | SYMANDT | Allow NULL? |
| 2 | MESSAGE_ID | UUID in Character Representation for ICF Recorder | nvarchar | 32 | 0 | CHAR | (N' ') | No | | ICFRECODER_UUID | Allow NULL? |
| 3 | MESSAGE_TYPE | ICF Message Types | char | 1 | 0 | CHAR | (N' ') | No | | ICFMSGTYPE | Allow NULL? |
| 4 | MESSAGE_ROLE | Role of ICF Message (SE, SL, CC, CU, CD, CL) | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | ICFMESSAGE_ROLE | Allow NULL? |
| 5 | STATUS | State of ICF Message | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | ICFSTATUS | Allow NULL? |
| 6 | SYSTEM_ID | Name of SAP System | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | SYSYSID | Allow NULL? |
| 7 | LOGON_SERVER | Logical Destination (Specified in Function Call) | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | * | RFCDEST | Allow NULL? |
| 8 | LOGON_USER | User Name | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | SYUNAME | Allow NULL? |
| 9 | LOGON_LANGUAGE | Language Key | char | 1 | 0 | LANG | (N' ') | Yes | | SYLANGU | Allow NULL? |
| 10 | LOGON_TIMESTAMP | UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) | decimal | 21 | 7 | DEC | ((0)) | Yes | | TIMESTAMPL | |
| 11 | LOGON_METHOD | ICF Logon Procedure | int | 10 | 0 | INT4 | ((0)) | Yes | | ICFLOGON_METHOD | Allow NULL? |
| 12 | LOGON_FAILED | Character field length 1 (large/small) | char | 1 | 0 | CHAR | (N' ') | Yes | | IMCCHAR1 | Allow NULL? |
| 13 | EXPIRE_TIMESTAMP | UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) | decimal | 21 | 7 | DEC | ((0)) | Yes | | TIMESTAMPL | |
| 14 | KEEP_MESSAGE | Keep Record Entry Until Maximum Retention Time | char | 1 | 0 | CHAR | (N' ') | Yes | | ICFKEEP_MESSAGE | Allow NULL? |
| 15 | SCRAMBLE_KEY | Message Key for ICFPERSIST | nvarchar | 64 | 0 | CHAR | (N' ') | Yes | | ICFSCRAMBLE | Allow NULL? |
| 16 | OWNER_SERVER | Logical Destination (Specified in Function Call) | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | * | RFCDEST | Allow NULL? |
| 17 | OWNER_CLIENT | Client ID | nvarchar | 3 | 0 | CLNT | (N'000') | Yes | * | SYMANDT | Allow NULL? |
| 18 | OWNER_USER | User Name | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | SYUNAME | Allow NULL? |
| 19 | OWNER_LANGUAGE | Language Key | char | 1 | 0 | LANG | (N' ') | Yes | | SYLANGU | Allow NULL? |
| 20 | OWNER_TIMESTAMP | UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) | decimal | 21 | 7 | DEC | ((0)) | Yes | | TIMESTAMPL | |
| 21 | SCOPE_MESSAGEID | UUID in Character Representation for ICF Recorder | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | ICFRECODER_UUID | Allow NULL? |
| 22 | SCOPE_MESSAGENR | Loop Index | int | 10 | 0 | INT4 | ((0)) | Yes | | SYINDEX | Allow NULL? |
| 23 | CALLER_MESSAGEID | UUID in Character Representation for ICF Recorder | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | ICFRECODER_UUID | Allow NULL? |
| 24 | ROOT_MESSAGEID | UUID in Character Representation for ICF Recorder | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | ICFRECODER_UUID | Allow NULL? |
| 25 | PARENT_MESSAGEID | UUID in Character Representation for ICF Recorder | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | ICFRECODER_UUID | Allow NULL? |
| 26 | OBJECT_ID | UUID in Character Representation for ICF Recorder | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | ICFRECODER_UUID | Allow NULL? |
| 27 | OBJECT_COUNTER | Loop Index | int | 10 | 0 | INT4 | ((0)) | Yes | | SYINDEX | Allow NULL? |
| 28 | STATEFUL | Is ICF session stateful? | char | 1 | 0 | CHAR | (N' ') | Yes | | ICFSTATEFUL | Allow NULL? |
| 29 | REQUEST_PROTOCOL | Character field length 1 (large/small) | char | 1 | 0 | CHAR | (N' ') | Yes | | IMCCHAR1 | Allow NULL? |
| 30 | REQUEST_HOST | Host Name of ICF Request | nvarchar | 128 | 0 | CHAR | (N' ') | Yes | | ICFREQUEST_HOST | Allow NULL? |
| 31 | REQUEST_PORT | Character field, length 32 | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | CHAR32 | Allow NULL? |
| 32 | REQUEST_PATH | Path of ICF Request | nvarchar | 250 | 0 | CHAR | (N' ') | Yes | | ICFREQUEST_PATH | Allow NULL? |
| 33 | REQUEST_VHOST | Natural Number | int | 10 | 0 | INT4 | ((0)) | Yes | | INT4 | Allow NULL? |
| 34 | REQUEST | ICF Message in Binary Format | image | 2147483647 | 0 | | | Yes | | ICFRAW_MESSAGE | |
| 35 | RESPONSE_STATUS | Status of ICF Response.Message (Status Code and Reason) | nvarchar | 240 | 0 | CHAR | (N' ') | Yes | | ICFRESPONSE_STATUS | Allow NULL? |
| 36 | RESPONSE | ICF Message in Binary Format | image | 2147483647 | 0 | | | Yes | | ICFRAW_MESSAGE | |
| 37 | RESPONSE_TSTAMP | UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) | decimal | 21 | 7 | DEC | ((0)) | Yes | | TIMESTAMPL | |
| 38 | ATTRIBUTES | ICF Message in Binary Format | image | 2147483647 | 0 | | | Yes | | ICFRAW_MESSAGE | |
| 39 | LICENSE_NUMBER | System License Number | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ICFLICENSE_NUMBER | Allow NULL? |
| 40 | SRC_LOGON_CLIENT | Client ID | nvarchar | 3 | 0 | CLNT | (N'000') | Yes | * | SYMANDT | Allow NULL? |
| 41 | SRC_LOGON_USER | User Name | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | SYUNAME | Allow NULL? |
| 42 | SRC_MESSAGEID | UUID in Character Representation for ICF Recorder | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | ICFRECODER_UUID | Allow NULL? |
| 43 | SRC_PMESSAGEID | UUID in Character Representation for ICF Recorder | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | ICFRECODER_UUID | Allow NULL? |
| 44 | SRC_RMESSAGEID | UUID in Character Representation for ICF Recorder | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | ICFRECODER_UUID | Allow NULL? |
| 45 | SRC_SMESSAGEID | UUID in Character Representation for ICF Recorder | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | ICFRECODER_UUID | Allow NULL? |
| 46 | SRC_CMESSAGEID | UUID in Character Representation for ICF Recorder | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | ICFRECODER_UUID | Allow NULL? |
| 47 | SIGNATURE_METHOD | Character field length 1 (large/small) | char | 1 | 0 | CHAR | (N' ') | Yes | | IMCCHAR1 | Allow NULL? |
| 48 | SRC_SIGNATURE | Signature of Recorder Message | nvarchar | 64 | 0 | CHAR | (N' ') | Yes | | ICFORIGIN_SIGNATURE | Allow NULL? |
| 49 | EXTERNAL_MESSAGE | External/Imported Entry | char | 1 | 0 | CHAR | (N' ') | Yes | | ICFEXTERNAL_MESSAGE | Allow NULL? |
| 50 | PROTOCOL_ACTION | Logging of Recorder Message Actions | char | 1 | 0 | CHAR | (N' ') | Yes | | ICFPROTOCOL_ACTION | Allow NULL? |
| 51 | TRACE_LEVEL | Natural Number | int | 10 | 0 | INT4 | ((0)) | Yes | | INT4 | Allow NULL? |
| 52 | REFERENCE_TSTAMP | UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) | decimal | 21 | 7 | DEC | ((0)) | Yes | | TIMESTAMPL | |
| 53 | MODIFIED_SYSTEM | Name of SAP System | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | SYSYSID | Allow NULL? |
| 54 | MODIFIED_CLIENT | Client ID | nvarchar | 3 | 0 | CLNT | (N'000') | Yes | * | SYMANDT | Allow NULL? |
| 55 | MODIFIED_USER | User Name | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | SYUNAME | Allow NULL? |
| 56 | MODIFIED_TSTAMP | UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) | decimal | 21 | 7 | DEC | ((0)) | Yes | | TIMESTAMPL | |
| 57 | PARTNER_TYPE | Communication Partner (User Agent or Server | nvarchar | 128 | 0 | CHAR | (N' ') | Yes | | ICFREC_PARTNER_TYPE | Allow NULL? |
