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 Permanent Branch Code 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.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 Current Branch items.paidfor Has Item been lost and then paid for items.timestamp Timestamp items.location Location 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 biblioitems.biblioitemnumber Biblioitem Number biblioitems.biblionumber Biblio Number biblioitems.volume Volume Number biblioitems.number Number biblioitems.classification Classification biblioitems.itemtype Itemtype 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