| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | TABNAME | Table name | nvarchar | 30 | 0 | CHAR | (N' ') | No | * | TNAME | Allow NULL? |
| 2 | ANDAT | Analysis date (yyyymmddhhmm) | nvarchar | 12 | 0 | CHAR | (N' ') | No | | AM_DATE | Allow NULL? |
| 3 | VWTYP | Single-Character Indicator | char | 1 | 0 | CHAR | (N' ') | No | | CHAR1 | Allow NULL? |
| 4 | TABSIZE | Used blocks of a table in KB | decimal | 11 | 0 | DEC | ((0)) | No | | UBLOCKS_KB | |
| 5 | CURROWS | Number of rows in a table | decimal | 15 | 0 | DEC | ((0)) | No | | OROWS | |
| 6 | INDBS | Used blocks of an index-Btree (kb) | decimal | 15 | 0 | DEC | ((0)) | No | | BBLOCKS_KB | |
| 7 | DLTROWS | iSeries: Number of rows / object size | decimal | 15 | 0 | DEC | ((0)) | No | | DB4_ANZ15 | |
| 8 | NUMOPEN | iSeries: Number of rows / object size | decimal | 15 | 0 | DEC | ((0)) | No | | DB4_ANZ15 | |
| 9 | NUMCLOSE | iSeries: Number of rows / object size | decimal | 15 | 0 | DEC | ((0)) | No | | DB4_ANZ15 | |
| 10 | NUMINSERT | iSeries: Number of rows / object size | decimal | 15 | 0 | DEC | ((0)) | No | | DB4_ANZ15 | |
| 11 | NUMUPDATE | iSeries: Number of rows / object size | decimal | 15 | 0 | DEC | ((0)) | No | | DB4_ANZ15 | |
| 12 | NUMDELETE | iSeries: Number of rows / object size | decimal | 15 | 0 | DEC | ((0)) | No | | DB4_ANZ15 | |
| 13 | NUMLREAD | iSeries: Number of rows / object size | decimal | 15 | 0 | DEC | ((0)) | No | | DB4_ANZ15 | |
| 14 | NUMPREAD | iSeries: Number of rows / object size | decimal | 15 | 0 | DEC | ((0)) | No | | DB4_ANZ15 | |
| 15 | NUMCST | iSeries: Number of rows / object size | decimal | 15 | 0 | DEC | ((0)) | Yes | | DB4_ANZ15 | |
| 16 | CSTSIZE | iSeries: Number of rows / object size | decimal | 15 | 0 | DEC | ((0)) | Yes | | DB4_ANZ15 | |
| 17 | CRTDATE | Date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | DATUM | Allow NULL? |
| 18 | CRTTIME | Character field of length 6 | nvarchar | 6 | 0 | CHAR | (N' ') | No | | CHAR6 | Allow NULL? |
| 19 | SAVDATE | Date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | DATUM | Allow NULL? |
| 20 | SAVTIME | Character field of length 6 | nvarchar | 6 | 0 | CHAR | (N' ') | No | | CHAR6 | Allow NULL? |
| 21 | RSTDATE | Date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | DATUM | Allow NULL? |
| 22 | RSTIME | Character field of length 6 | nvarchar | 6 | 0 | CHAR | (N' ') | No | | CHAR6 | Allow NULL? |
