Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 null
aqbasket.booksellerid aqbasket_ibfk_1 R
aqbasketgroups.booksellerid aqbasketgroups_ibfk_1 C
aqcontacts.booksellerid booksellerid_aqcontacts_fk C
aqcontract.booksellerid booksellerid_fk1 C
aqinvoices.booksellerid aqinvoices_fk_aqbooksellerid C
edifact_messages.vendor_id emfk_vendor C
vendor_edi_accounts.vendor_id vfk_vendor_id R

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)

url VARCHAR 255 null

vendor web address

active TINYINT 3 null

is this vendor active (1 for yes, 0 for no)

listprice VARCHAR 10 null
currency.currency aqbooksellers_ibfk_1 C

currency code for list prices

invoiceprice VARCHAR 10 null
currency.currency aqbooksellers_ibfk_2 C

currency code for invoice prices

gstreg TINYINT 3 null

is your library charged tax (1 for yes, 0 for no)

listincgst TINYINT 3 null

is tax included in list prices (1 for yes, 0 for no)

invoiceincgst TINYINT 3 null

is tax included in invoice prices (1 for yes, 0 for no)

tax_rate DECIMAL 6,4 null

the tax rate the library is charged

discount FLOAT 6,4 null

discount offered on all items ordered from this vendor

fax VARCHAR 50 null

vendor fax number

deliverytime INT 10 null

vendor delivery time

Table contained 0 rows


Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
invoiceprice Performance Asc invoiceprice
listprice Performance Asc listprice
name Performance Asc name