aqbooksellers

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 null
aqbasket.booksellerid aqbasket_ibfk_1R
aqbasketgroups.booksellerid aqbasketgroups_ibfk_1C
aqcontacts.booksellerid booksellerid_aqcontacts_fkC
aqcontract.booksellerid booksellerid_fk1C
aqinvoices.booksellerid aqinvoices_fk_aqbookselleridC
edifact_messages.vendor_id emfk_vendorC
erm_agreements.vendor_id erm_agreements_ibfk_1N
erm_eholdings_packages.vendor_id erm_eholdings_packages_ibfk_1N
erm_eholdings_resources.vendor_id erm_eholdings_resources_ibfk_3N
erm_licenses.vendor_id erm_licenses_ibfk_1N
vendor_edi_accounts.vendor_id vfk_vendor_idR

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

type VARCHAR 255 null
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_1C

currency code for list prices

invoiceprice VARCHAR 10 null
currency.currency aqbooksellers_ibfk_2C

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

external_id VARCHAR 255 null

external id of the vendor

Indexes

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

Relationships