| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | TABLE_NAME | Table Name | nvarchar | 30 | 0 | CHAR | (N' ') | No | * | TABNAME | Allow NULL? |
| 2 | COLUMN_NAME | Column Name / Header | nvarchar | 60 | 0 | CHAR | (N' ') | No | | COLUMNNAME | Allow NULL? |
| 3 | PART_ID | Natural Number | int | 10 | 0 | INT4 | ((0)) | No | | INT4 | Allow NULL? |
| 4 | KEYFLAG | Identifies a key field of a table | char | 1 | 0 | CHAR | (N' ') | Yes | | KEYFLAG | Allow NULL? |
| 5 | HAS_INDEX | Identifies a key field of a table | char | 1 | 0 | CHAR | (N' ') | Yes | | KEYFLAG | Allow NULL? |
| 6 | MS_TOTAL | Decimal number, 20 digits, none after decimal point | decimal | 20 | 0 | DEC | ((0)) | Yes | | DEC20 | |
| 7 | MS_MAIN | Decimal number, 20 digits, none after decimal point | decimal | 20 | 0 | DEC | ((0)) | Yes | | DEC20 | |
| 8 | EST_MS_MAIN | Decimal number, 20 digits, none after decimal point | decimal | 20 | 0 | DEC | ((0)) | Yes | | DEC20 | |
| 9 | RECORD_COUNT | Decimal number, 20 digits, none after decimal point | decimal | 20 | 0 | DEC | ((0)) | Yes | | DEC20 | |
| 10 | DISTINCT_COUNT | Decimal number, 20 digits, none after decimal point | decimal | 20 | 0 | DEC | ((0)) | Yes | | DEC20 | |
| 11 | LOADED | Character (length 5) | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | CHAR005 | Allow NULL? |
| 12 | INDEX_LOADED | Character String - 16 User-Defined Characters | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | CHAR0016 | Allow NULL? |
| 13 | COMPRESSION_TYPE | Character String - 16 User-Defined Characters | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | CHAR0016 | Allow NULL? |
| 14 | MS_DICT | Decimal number, 20 digits, none after decimal point | decimal | 20 | 0 | DEC | ((0)) | Yes | | DEC20 | |
| 15 | EST_MS_DICT | Decimal number, 20 digits, none after decimal point | decimal | 20 | 0 | DEC | ((0)) | Yes | | DEC20 | |
| 16 | MS_INDEX | Decimal number, 20 digits, none after decimal point | decimal | 20 | 0 | DEC | ((0)) | Yes | | DEC20 | |
| 17 | EST_MS_INDEX | Decimal number, 20 digits, none after decimal point | decimal | 20 | 0 | DEC | ((0)) | Yes | | DEC20 | |
| 18 | MS_DATA | Decimal number, 20 digits, none after decimal point | decimal | 20 | 0 | DEC | ((0)) | Yes | | DEC20 | |
| 19 | EST_MS_DATA | Decimal number, 20 digits, none after decimal point | decimal | 20 | 0 | DEC | ((0)) | Yes | | DEC20 | |
| 20 | MS_MISC | Decimal number, 20 digits, none after decimal point | decimal | 20 | 0 | DEC | ((0)) | Yes | | DEC20 | |
| 21 | EST_MS_MISC | Decimal number, 20 digits, none after decimal point | decimal | 20 | 0 | DEC | ((0)) | Yes | | DEC20 | |
| 22 | TYPEKIND | Category of Dictionary Type | char | 1 | 0 | CHAR | (N' ') | Yes | | TYPEKIND | Allow NULL? |
| 23 | SIZE_IN_BYTE | | decimal | 16 | 0 | | ((0)) | Yes | | | |
| 24 | LOB_SIZE_IN_BYTE | | decimal | 16 | 0 | | ((0)) | Yes | | | |
