| import_batch_id |
INT |
10 |
|
√ |
null |
|
|
unique identifier and primary key |
| matcher_id |
INT |
10 |
√ |
|
null |
|
|
the id of the match rule used (matchpoints.matcher_id) |
| template_id |
INT |
10 |
√ |
|
null |
|
|
|
| branchcode |
VARCHAR |
10 |
√ |
|
null |
|
|
|
| num_records |
INT |
10 |
|
|
0 |
|
|
number of records in the file |
| num_items |
INT |
10 |
|
|
0 |
|
|
number of items in the file |
| upload_timestamp |
TIMESTAMP |
19 |
|
|
CURRENT_TIMESTAMP |
|
|
date and time the file was uploaded |
| overlay_action |
enum('replace', 'create_new', 'use_template', 'ignore') |
12 |
|
|
create_new |
|
|
how to handle duplicate records |
| nomatch_action |
enum('create_new', 'ignore') |
11 |
|
|
create_new |
|
|
how to handle records where no match is found |
| item_action |
enum('always_add', 'add_only_for_matches', 'add_only_for_new', 'ignore', 'replace') |
20 |
|
|
always_add |
|
|
what to do with item records |
