| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
---|
| 1 | GUID | DMC: Globally Unique Key (22 Characters) | nvarchar | 22 | 0 | CHAR | (N' ') | No | | DMC_GUID | Allow NULL? |
| 2 | MT_ID | Mass Transfer ID | nvarchar | 3 | 0 | CHAR | (N' ') | No | | DMC_MT_IDENTIFIER | Allow NULL? |
| 3 | TABNAME | Table Name | nvarchar | 30 | 0 | CHAR | (N' ') | No | * | TABNAME | Allow NULL? |
| 4 | REPORT_TYPE | Compare data: Report Type | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | DMC_MDS_COMP_DATA_REPORT_TYPE | Allow NULL? |
| 5 | COMP_RESULT | Boolean Variable (X=True, -=False, Space=Unknown) | char | 1 | 0 | CHAR | (N' ') | Yes | | BOOLEAN | Allow NULL? |
| 6 | LOG_TABNAME | Table Name | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | TABNAME | Allow NULL? |
| 7 | ORIG_NR_ENTRIES | Natural Number | int | 10 | 0 | INT4 | ((0)) | Yes | | INT4 | Allow NULL? |
| 8 | NR_DIFFERENCES | Natural Number | int | 10 | 0 | INT4 | ((0)) | Yes | | INT4 | Allow NULL? |
| 9 | GET_LOG_METADATA | Boolean Variable (X=True, -=False, Space=Unknown) | char | 1 | 0 | CHAR | (N' ') | Yes | | BOOLEAN | Allow NULL? |
| 10 | KEYS_FIELDS_AVAI | Boolean Variable (X=True, -=False, Space=Unknown) | char | 1 | 0 | CHAR | (N' ') | Yes | | BOOLEAN | Allow NULL? |
| 11 | ORIG_ROWS_OK | Boolean Variable (X=True, -=False, Space=Unknown) | char | 1 | 0 | CHAR | (N' ') | Yes | | BOOLEAN | Allow NULL? |
| 12 | OPERATION_ERR | | char | 1 | 0 | | (N' ') | Yes | | | Allow NULL? |
| 13 | GET_CONVOBJECT | Boolean Variable (X=True, -=False, Space=Unknown) | char | 1 | 0 | CHAR | (N' ') | Yes | | BOOLEAN | Allow NULL? |
| 14 | LOAD_CONVOBJECT | Boolean Variable (X=True, -=False, Space=Unknown) | char | 1 | 0 | CHAR | (N' ') | Yes | | BOOLEAN | Allow NULL? |
| 15 | CREATE_CONV_INFO | Boolean Variable (X=True, -=False, Space=Unknown) | char | 1 | 0 | CHAR | (N' ') | Yes | | BOOLEAN | Allow NULL? |
| 16 | GENERATE_SUBROUT | Boolean Variable (X=True, -=False, Space=Unknown) | char | 1 | 0 | CHAR | (N' ') | Yes | | BOOLEAN | Allow NULL? |
| 17 | SHADOWTABSND | Table Name | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | TABNAME | Allow NULL? |
| 18 | GET_METADATASND | Boolean Variable (X=True, -=False, Space=Unknown) | char | 1 | 0 | CHAR | (N' ') | Yes | | BOOLEAN | Allow NULL? |
| 19 | SHADTAB_AVAILSND | Boolean Variable (X=True, -=False, Space=Unknown) | char | 1 | 0 | CHAR | (N' ') | Yes | | BOOLEAN | Allow NULL? |
| 20 | CONNECTIONSND | Boolean Variable (X=True, -=False, Space=Unknown) | char | 1 | 0 | CHAR | (N' ') | Yes | | BOOLEAN | Allow NULL? |
| 21 | SHADOWTABRCV | Table Name | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | TABNAME | Allow NULL? |
| 22 | GET_METADATARCV | Boolean Variable (X=True, -=False, Space=Unknown) | char | 1 | 0 | CHAR | (N' ') | Yes | | BOOLEAN | Allow NULL? |
| 23 | SHADTAB_AVAILRCV | Boolean Variable (X=True, -=False, Space=Unknown) | char | 1 | 0 | CHAR | (N' ') | Yes | | BOOLEAN | Allow NULL? |
| 24 | CONNECTIONRCV | Boolean Variable (X=True, -=False, Space=Unknown) | char | 1 | 0 | CHAR | (N' ') | Yes | | BOOLEAN | Allow NULL? |
| 25 | USR | User Name | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | SYUNAME | Allow NULL? |
| 26 | RUN_START_DATE | System Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | SYDATUM | Allow NULL? |
| 27 | RUN_START_TIME | System Time | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | SYUZEIT | Allow NULL? |