| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | DEST | SMOI_WS: Destination for CCMS Agents (sapstartsrv) | nvarchar | 32 | 0 | CHAR | (N' ') | No | | SMOI_WS_DEST | Allow NULL? |
| 2 | LPNAME | SRT Name of Logical Port | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | | SMOI_WS_LPNAME | Allow NULL? |
| 3 | SID | System Identifier of an SAP NetWeaver Component | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | SMOI_WS_SYSID | Allow NULL? |
| 4 | INST_TYPE | Instance Type (ABAP, DS, Java, TREX, SCS, and so on) | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | SMOI_WS_INSTANCE_TYPE | Allow NULL? |
| 5 | INST_FEATURES | SMOI_WS: Properties of an Instance | ntext | 1073741823 | 0 | | | Yes | | SMOI_WS_INSTANCE_FEATURES | |
| 6 | PORT_TYPE | SMOI_WS: CCMS Port Type | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | SMOI_WS_PORTTYPE | Allow NULL? |
| 7 | COMM_TYPE | SMOI_WS: Web Service Communication Type (HTTP, HTTPS, ...) | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | SMOI_WS_COMM_TYPE | Allow NULL? |
| 8 | HOST | Host Name (or IP Address or FQDN) | nvarchar | 255 | 0 | CHAR | (N' ') | Yes | | SMOI_WS_HOSTNAME | Allow NULL? |
| 9 | PORT | Port Number | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | | SMOI_WS_PORTNO | Allow NULL? |
| 10 | IS_DBHOST | Boolean Variable (X=True, -=False, Space=Unknown) | char | 1 | 0 | CHAR | (N' ') | Yes | | BOOLEAN | Allow NULL? |
| 11 | IS_REMOTE | Boolean Variable (X=True, -=False, Space=Unknown) | char | 1 | 0 | CHAR | (N' ') | Yes | | BOOLEAN | Allow NULL? |
| 12 | COMM_STATUS | SMOI_WS: Status of CCMS Connection | char | 1 | 0 | CHAR | (N' ') | Yes | | SMOI_WS_STATUS_COMM | Allow NULL? |
| 13 | AGENT_STATUS | SMOI_WS: Status of CCMS Agent Registration in CEN | char | 1 | 0 | CHAR | (N' ') | Yes | | SMOI_WS_STATUS_AGENT | Allow NULL? |
| 14 | ADD_USER | SMOI_WS: User | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | SMOI_WS_USER | Allow NULL? |
| 15 | ADD_TIME | SMOI_WS: UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | DEC | ((0)) | Yes | | SMOI_WS_TIMESTAMP | |
| 16 | CHG_USER | SMOI_WS: User | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | SMOI_WS_USER | Allow NULL? |
| 17 | CHG_TIME | SMOI_WS: UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | DEC | ((0)) | Yes | | SMOI_WS_TIMESTAMP | |
| 18 | SAPADM_USERID | 16 Byte UUID in 32 Characters (Hexadecimal Encoded) | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | SYSUUID_C32 | Allow NULL? |
| 19 | SAPADM_PWDID | 16 Byte UUID in 32 Characters (Hexadecimal Encoded) | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | SYSUUID_C32 | Allow NULL? |
| 20 | PROXY_USERID | 16 Byte UUID in 32 Characters (Hexadecimal Encoded) | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | SYSUUID_C32 | Allow NULL? |
| 21 | PROXY_PWDID | 16 Byte UUID in 32 Characters (Hexadecimal Encoded) | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | SYSUUID_C32 | Allow NULL? |
| 22 | PROXY_HOST | Host Name (or IP Address or FQDN) | nvarchar | 255 | 0 | CHAR | (N' ') | Yes | | SMOI_WS_HOSTNAME | Allow NULL? |
| 23 | PROXY_PORT | Port Number | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | | SMOI_WS_PORTNO | Allow NULL? |
| 24 | REGPROFILE | Registration Profile Name | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | SMOI_WS_PROFILE_NAME | Allow NULL? |
| 25 | AD_ENABLED | Boolean Variable (X=True, -=False, Space=Unknown) | char | 1 | 0 | CHAR | (N' ') | Yes | | BOOLEAN | Allow NULL? |
