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
aqbookseller_aliases.vendor_id aqbookseller_aliases_ibfk_1C
aqbookseller_interfaces.vendor_id aqbookseller_interfaces_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

Close relationships within degrees of separation