TTdbBatchMove.Mappings
TTdbBatchMove

Contains a list of column assignments for the import.

property Mappings: TStrings;

Description
Set Mappings to specify the correspondence between fields in the Source and fields in the Destination. By default TTdbBatchMove matches fields based on their position in the source and destination tables. That is, the first column in the source is matched with the first column in the destination, and so on. Mappings enables an application to override this default.

To map the column named SourceColName in the source table to the column named DestColName in the destination table, use:
DestColName=SourceColName

You may also use the column no proceeded by a $ for the mapping:
$8=$3

You can mix the column identifiers in a mapping as well:
$8=SourceColName

When adding or appending records, fields in Destination which have no entry in Mappings will be set to NULL. When copying a dataset, fields in Destination which have no entry in Mappings will not appear as columns in the copy of the table.
If source and destination column data types are not the same, TTdbBatchMove can either cancel the batch operation or perform a "best fit". The field values from the Source will be converted, if possible, to be compatible with the Destination.