-borrowers.borrowernumber Borrower Number
-borrowers.cardnumber Card Number
+borrowers.borrowernumber Borrower number
+borrowers.title Salutation
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.firstname First name
+borrowers.dateofbirth Date of birth
+borrowers.initials Initials
+borrowers.othernames Other name
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)
+borrowers.relationship Relationship
+borrowers.guarantorid Guarantor borrower number
+borrowers.streetnumber Street number
+borrowers.streettype Street type
+borrowers.address Address
+borrowers.address2 Address 2
+borrowers.city City
+borrowers.state State
+borrowers.zipcode Zip/postal code
+borrowers.country Country
+borrowers.phone Primary phone
+borrowers.phonepro Secondary phone
+borrowers.mobile Other phone
+borrowers.email Primary email
+borrowers.emailpro Secondary email
+borrowers.fax Fax
+borrowers.B_streetnumber Alternate address: Street number
+borrowers.B_streettype Alternate address: Street type
+borrowers.B_address Alternate address: Address
+borrowers.B_address2 Alternate address: Address 2
+borrowers.B_city Alternate address: City
+borrowers.B_state Alternate address: State
+borrowers.B_zipcode Alternate address: Zip/postal code
+borrowers.B_country Alternate address: Country
+borrowers.B_phone Alternate address: Phone
+borrowers.B_email Alternate address: Email
+borrowers.contactnote Alternate contact: Note
+borrowers.altcontactfirstname Alternate contact: Last name
+borrowers.altcontactsurname Alternate contact: First name
+borrowers.altcontactaddress1 Alternate contact: Address
+borrowers.altcontactaddress2 Alternate contact: Address 2
+borrowers.altcontactaddress3 Alternate contact: City
+borrowers.contactname Alternate contact: Surname
+borrowers.contactfirstname Alternate contact: First name
+borrowers.contacttitle Alternate contact: Title
+borrowers.altcontactstate Alternate contact: State
+borrowers.altcontactzipcode Alternate contact: Zip/postal code
+borrowers.altcontactcountry Alternate contact: Country
+borrowers.altcontactphone Alternate contact: Phone
+borrowers.cardnumber Card number
+borrowers.branchcode Home library
+borrowers.categorycode Category
+borrowers.sort1 Sort 1
+borrowers.sort2 Sort 2
+borrowers.dateenrolled Registration date
+borrowers.dateexpiry Expiry date
+borrowers.opacnote OPAC note
+borrowers.borrowernotes Circulation note
+borrowers.userid Username
+borrowers.password Password
+borrowers.flags System permissions
+borrowers.gonenoaddress Gone no address flag
+borrowers.lost Lost card flag
+borrowers.debarred Restricted [until] flag
+borrowers.debarredcomment Comment
+borrowers.smsalertnumber Mobile phone number
+borrowers.privacy Privacy settings
+items.itemnumber Item number (internal)
+items.biblionumber Biblio number (internal)
+items.biblioitemnumber Biblioitem number (internal)
items.barcode Barcode
-items.dateaccessioned Accession Date
-items.booksellerid Supplier ID
-items.homebranch Home Branch
+items.dateaccessioned Date acquired
+items.booksellerid Source of acquisition
+items.homebranch Permanent library
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.replacementprice Replacement price
+items.replacementpricedate Price effective from
+items.datelastborrowed Date last checked out
+items.datelastseen Date last seen
+items.stack Shelving control number
+items.onloan Due date
+items.cn_source Source of classification / shelving scheme
+items.cn_sort Koha normalized classification for sorting
+items.notforloan Not for loan
+items.itemlost Lost status
+items.wthdrawn Withdrawn status
+items.itemcallnumber Call number
+items.issues Total checkouts
+items.renewals Total renewals
+items.reserves Total holds
+items.restricted Use restrictions
+items.itemnotes Public note
+items.holdingbranch Current library
+items.paidfor
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
+items.location Shelving location
+items.ccode Collection code
+items.itype Koha itemtype
+items.stocknumber Inventory number
+items.damaged Damaged status
+items.materials Materials specified
+items.uri Uniform Resource Identifier
+items.more_subfields_xml Additional subfields (XML)
+items.enumchron Serial enumeraton/chronology
+items.copynumber Copy number
+statistics.datetime Statistics date and time
+statistics.branch Library
+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
+statistics.usercode User code
+statistics.itemnumber Item number
+statistics.itemtype Itemtype
+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
+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.itemtype Biblio-level item type
biblioitems.isbn ISBN
biblioitems.issn ISSN
-biblioitems.dewey Dewey/Classification
-biblioitems.subclass Sub Classification
-biblioitems.publicationyear Publication Date
+biblioitems.dewey Dewey/classification
+biblioitems.subclass Sub classification
+biblioitems.publicationyear Publication date
biblioitems.publishercode Publisher
-biblioitems.volumedate Volume Date
-biblioitems.volumeddesc Volume Information
+biblioitems.volumedate Volume date
+biblioitems.volumedesc Volume information
biblioitems.timestamp Timestamp
biblioitems.illus Illustrator
-biblioitems.pages Number of Pages
+biblioitems.pages Number of pages
biblioitems.notes Notes
biblioitems.size Size
-biblioitems.place Place of Publication
+biblioitems.place Place of publication
biblioitems.lccn LCCN
-biblioitems.marc MARC Blob
+biblioitems.marcxml MARC blob
biblioitems.url URL