aqbooksellers

0 rows


Columns

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
aqbookseller_aliases.vendor_id aqbookseller_aliases_ibfk_1 C
aqbookseller_interfaces.vendor_id aqbookseller_interfaces_ibfk_1 C
aqbookseller_issues.vendor_id aqbookseller_issues_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
erm_agreements.vendor_id erm_agreements_ibfk_1 N
erm_eholdings_packages.vendor_id erm_eholdings_packages_ibfk_1 N
erm_eholdings_resources.vendor_id erm_eholdings_resources_ibfk_3 N
erm_licenses.vendor_id erm_licenses_ibfk_1 N
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
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_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
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