Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
---|---|---|---|---|---|---|---|---|---|---|---|
id | INT | 10 | √ | null |
|
|
unique identifier and primary key |
||||
description | VARCHAR | 250 | null |
|
|
description of this account |
|||||
vendor_id | INT | 10 | √ | null |
|
|
vendor id for this account |
||||
budget_id | INT | 10 | √ | null |
|
|
budget id for this account |
||||
download_directory | MEDIUMTEXT | 16777215 | √ | null |
|
|
download directory for this account |
||||
matcher_id | INT | 10 | √ | null |
|
|
the id of the match rule used (matchpoints.matcher_id) |
||||
overlay_action | VARCHAR | 50 | √ | null |
|
|
how to handle duplicate records |
||||
nomatch_action | VARCHAR | 50 | √ | null |
|
|
how to handle records where no match is found |
||||
item_action | VARCHAR | 50 | √ | null |
|
|
what to do with item records |
||||
parse_items | BIT | 0 | √ | null |
|
|
should items be parsed |