The mapitem table defines the relationship between the columns of a database table and the record fields of a data file. The table stores pairs of column/record entries. The map options modify this table. For more information, see Load and Unload Maps.
| Column | Type | Description |
|---|---|---|
| formid | INTEGER | Specifies the map to which this record belongs (foreign key to the maps table) |
| seq | INTEGER | Unique identifier for the database-column/data file-record pair |
| colname | CHAR(18) | Name of database column |
| fname | CHAR(128) | Name of field in a data-file record |