| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
---|
| 1 | MCONAME | Name of a matchcode object (4-digit) | nvarchar | 4 | 0 | CHAR | (N' ') | No | | MCONAME4 | Allow NULL? |
| 2 | MCID | Matchcode ID | char | 1 | 0 | CHAR | (N' ') | No | * | MCID | Allow NULL? |
| 3 | FLAG1 | Flag byte | varbinary | 1 | 0 | RAW | | Yes | | MCFLAGBYTE | |
| 4 | POOLTAB | Name of Pool/Cluster in the Database | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | SQLTABLE | Allow NULL? |
| 5 | TIMESTMP | Time stamp for matchcode generation | nvarchar | 14 | 0 | CHAR | (N' ') | Yes | | MCTIMESTMP | Allow NULL? |
| 6 | TABNO | Length, position in list, etc. | smallint | 5 | 0 | INT2 | ((0)) | Yes | | MCSAPINT2 | |
| 7 | TTABNO | Length, position in list, etc. | smallint | 5 | 0 | INT2 | ((0)) | Yes | | MCSAPINT2 | |
| 8 | FLDNO | Length, position in list, etc. | smallint | 5 | 0 | INT2 | ((0)) | Yes | | MCSAPINT2 | |
| 9 | BPLNO | Length, position in list, etc. | smallint | 5 | 0 | INT2 | ((0)) | Yes | | MCSAPINT2 | |
| 10 | BFLNO | Length, position in list, etc. | smallint | 5 | 0 | INT2 | ((0)) | Yes | | MCSAPINT2 | |
| 11 | LRLG | Length, position in list, etc. | smallint | 5 | 0 | INT2 | ((0)) | Yes | | MCSAPINT2 | |
| 12 | MCIDESC | Runtime object "MC ID" | image | 2147483647 | 0 | LRAW | | Yes | | MCMCIDDESC | |