| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MCONAME | Name of a matchcode object (4-digit) | nvarchar | 4 | 0 | | | | Allow NULL? |
| 2 | MCID | Matchcode ID | char | 1 | 0 | | | | Allow NULL? |
| 3 | FLAG1 | Flag byte | varbinary | 1 | 0 | | | | |
| 4 | POOLTAB | Name of Pool/Cluster in the Database | nvarchar | 10 | 0 | | | | Allow NULL? |
| 5 | TIMESTMP | Time stamp for matchcode generation | nvarchar | 14 | 0 | | | | Allow NULL? |
| 6 | TABNO | Length, position in list, etc. | smallint | 5 | 0 | | | | |
| 7 | TTABNO | Length, position in list, etc. | smallint | 5 | 0 | | | | |
| 8 | FLDNO | Length, position in list, etc. | smallint | 5 | 0 | | | | |
| 9 | BPLNO | Length, position in list, etc. | smallint | 5 | 0 | | | | |
| 10 | BFLNO | Length, position in list, etc. | smallint | 5 | 0 | | | | |
| 11 | LRLG | Length, position in list, etc. | smallint | 5 | 0 | | | | |
| 12 | MCIDESC | Runtime object "MC ID" | image | 2147483647 | 0 | | | | |