| id |
INT |
10 |
|
√ |
null |
|
|
primary key and unique identifier assigned by Koha |
| name |
LONGTEXT |
2147483647 |
|
|
null |
|
|
vendor name |
| address1 |
LONGTEXT |
2147483647 |
√ |
|
null |
|
|
first line of vendor physical address |
| address2 |
LONGTEXT |
2147483647 |
√ |
|
null |
|
|
second line of vendor physical address |
| address3 |
LONGTEXT |
2147483647 |
√ |
|
null |
|
|
third line of vendor physical address |
| address4 |
LONGTEXT |
2147483647 |
√ |
|
null |
|
|
fourth line of vendor physical address |
| phone |
VARCHAR |
30 |
√ |
|
null |
|
|
vendor phone number |
| accountnumber |
LONGTEXT |
2147483647 |
√ |
|
null |
|
|
vendor account number |
| notes |
LONGTEXT |
2147483647 |
√ |
|
null |
|
|
order notes |
| postal |
LONGTEXT |
2147483647 |
√ |
|
null |
|
|
vendor postal address (all lines) |
