The mapitem table in the onpload database

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.

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 VARCHAR(128,0) Name of database column
fname CHAR(128) Name of field in a data-file record