borrowers.borrowernumber Borrower Number borrowers.cardnumber Card Number borrowers.surname Surname borrowers.firstname Firstname borrowers.title Title borrowers.othernames Other Names borrowers.initials Initials borrowers.streetaddress Street Address borrowers.suburb Suburb borrowers.city City borrowers.phone Phone borrowers.emailaddress Email borrowers.faxnumber Fax borrowers.textmessaging Opac Message borrowers.altstreetaddress Alternative Street Address borrowers.altsuburb Alternative Suburb borrowers.altcity Alternative City borrowers.altphone Alternative Phone borrowers.dateofbirth Date of Birth borrowers.branchcode Branch Code borrowers.categorycode Borrowers Category borrowers.dateenrolled Date Enrolled borrowers.gonenoaddress Address Missing borrowers.lost Lost Card borrowers.debarred Debarred borrowers.studentnumber Student Id number borrowers.school School borrowers.contactname Contact Name borrowers.borrowernotes Circulation Notes borrowers.guarantor Guarantor(parent) borrowers.area Area borrowers.ethnicity Ethnicity borrowers.ethnotes Ethnicity Notes borrowers.sex Gender borrowers.expiry Expiry Date borrowers.altnotes Alternative Contact Notes borrowers.altrelationship Relationship of Alternative Contact borrowers.streetcity Streetcity?? borrowers.phoneday Work Phone borrowers.preferredcont Preferred method of Contact borrowers.physstreet Physical Street Address borrowers.password Password borrowers.flags Warnings borrowers.userid Login ID borrowers.homezipcode Zip/Post Code borrowers.zipcode Zip/Post Code 2? borrowers.sort1 Sorting Column borrowers.sort2 Sorting Column 2 borrowers.cellph Cellphone number borrowers.borlog borrowers.checkhist items.itemnumber Item Number (koha internal) items.biblionumber Biblio Number (koha internal) items.multivolumepart Item one part of a Multi volume set items.biblioitemnumber Biblioitem Number (koha internal) items.barcode Barcode items.dateaccessioned Accession Date items.booksellerid Supplier ID items.homebranch Home Branch items.price Price items.replacementprice Replacement Price items.replacementpricedate Date Replacement Price was set items.datelastborrowed Date Item last issued items.datelastseen Date Item was last seen by Koha items.multivolume Volume Number (if part of a multivolume work) items.stack Is the item in the stack? items.onloan On loan items.notforloan Item Not for loan items.itemlost Item Lost items.wthdrawn Item Cancelled items.itemcallnumber Item Call Number items.issues Issues Count items.renewals Renewals Count items.reserves Reserves Count items.restricted Item Restricted items.binding Item needs binding items.itemnotes Item Notes items.holdingbranch Holding Branch items.paidfor Has Item been lost and then paid for items.timestamp Timestamp items.location Location items.ccode Koha Collection items.itype Item-level Item Type items.spystatus items.spydescr items.itemlog items.spycopydata statistics.datetime Statistics Date and Time statistics.branch Branch Code statistics.proccode Type of Procedure statistics.value Value statistics.type Type statistics.other statistics.usercode User Code statistics.itemnumber Item Number statistics.itemtype Item Type statistics.borrowernumber Borrower Number biblio.frameworkcode Framework Code biblio.author Author biblio.datecreated Creation Date biblio.timestamp Modification Date biblioitems.biblioitemnumber Biblioitem Number biblioitems.biblionumber Biblio Number biblioitems.volume Volume Number biblioitems.number Number biblioitems.classification Classification biblioitems.itemtype Biblio-level Item Type biblioitems.isbn ISBN biblioitems.issn ISSN biblioitems.dewey Dewey/Classification biblioitems.subclass Sub Classification biblioitems.publicationyear Publication Date biblioitems.publishercode Publisher biblioitems.volumedate Volume Date biblioitems.volumeddesc Volume Information biblioitems.timestamp Timestamp biblioitems.illus Illustrator biblioitems.pages Number of Pages biblioitems.notes Notes biblioitems.size Size biblioitems.place Place of Publication biblioitems.lccn LCCN biblioitems.marc MARC Blob biblioitems.url URL