1 borrowers.borrowernumber Borrower Number
2 borrowers.cardnumber Card Number
3 borrowers.surname Surname
4 borrowers.firstname Firstname
6 borrowers.othernames Other Names
7 borrowers.initials Initials
8 borrowers.streetaddress Street Address
9 borrowers.suburb Suburb
12 borrowers.emailaddress Email
13 borrowers.faxnumber Fax
14 borrowers.textmessaging Opac Message
15 borrowers.altstreetaddress Alternative Street Address
16 borrowers.altsuburb Alternative Suburb
17 borrowers.altcity Alternative City
18 borrowers.altphone Alternative Phone
19 borrowers.dateofbirth Date of Birth
20 borrowers.branchcode Branch Code
21 borrowers.categorycode Borrowers Category
22 borrowers.dateenrolled Date Enrolled
23 borrowers.gonenoaddress Address Missing
24 borrowers.lost Lost Card
25 borrowers.debarred Debarred
26 borrowers.studentnumber Student Id number
27 borrowers.school School
28 borrowers.contactname Contact Name
29 borrowers.borrowernotes Circulation Notes
30 borrowers.guarantor Guarantor(parent)
32 borrowers.ethnicity Ethnicity
33 borrowers.ethnotes Ethnicity Notes
35 borrowers.expiry Expiry Date
36 borrowers.altnotes Alternative Contact Notes
37 borrowers.altrelationship Relationship of Alternative Contact
38 borrowers.streetcity Streetcity??
39 borrowers.phoneday Work Phone
40 borrowers.preferredcont Preferred method of Contact
41 borrowers.physstreet Physical Street Address
42 borrowers.password Password
43 borrowers.flags Warnings
44 borrowers.userid Login ID
45 borrowers.homezipcode Zip/Post Code
46 borrowers.zipcode Zip/Post Code 2?
47 borrowers.sort1 Sorting Column
48 borrowers.sort2 Sorting Column 2
49 borrowers.cellph Cellphone number
52 items.itemnumber Item Number (koha internal)
53 items.biblionumber Biblio Number (koha internal)
54 items.multivolumepart Item one part of a Multi volume set
55 items.biblioitemnumber Biblioitem Number (koha internal)
57 items.dateaccessioned Accession Date
58 items.booksellerid Supplier ID
59 items.homebranch Home Branch
61 items.replacementprice Replacement Price
62 items.replacementpricedate Date Replacement Price was set
63 items.datelastborrowed Date Item last issued
64 items.datelastseen Date Item was last seen by Koha
65 items.multivolume Volume Number (if part of a multivolume work)
66 items.stack Is the item in the stack?
68 items.notforloan Item Not for loan
69 items.itemlost Item Lost
70 items.wthdrawn Item Cancelled
71 items.itemcallnumber Item Call Number
72 items.issues Issues Count
73 items.renewals Renewals Count
74 items.reserves Reserves Count
75 items.restricted Item Restricted
76 items.binding Item needs binding
77 items.itemnotes Item Notes
78 items.holdingbranch Holding Branch
79 items.paidfor Has Item been lost and then paid for
80 items.timestamp Timestamp
81 items.location Location
82 items.ccode Koha Collection
83 items.itype Item-level Item Type
88 statistics.datetime Statistics Date and Time
89 statistics.branch Branch Code
90 statistics.proccode Type of Procedure
91 statistics.value Value
94 statistics.usercode User Code
95 statistics.itemnumber Item Number
96 statistics.itemtype Item Type
97 statistics.borrowernumber Borrower Number
98 biblio.frameworkcode Framework Code
100 biblio.datecreated Creation Date
101 biblio.timestamp Modification Date
102 biblioitems.biblioitemnumber Biblioitem Number
103 biblioitems.biblionumber Biblio Number
104 biblioitems.volume Volume Number
105 biblioitems.number Number
106 biblioitems.classification Classification
107 biblioitems.itemtype Biblio-level Item Type
108 biblioitems.isbn ISBN
109 biblioitems.issn ISSN
110 biblioitems.dewey Dewey/Classification
111 biblioitems.subclass Sub Classification
112 biblioitems.publicationyear Publication Date
113 biblioitems.publishercode Publisher
114 biblioitems.volumedate Volume Date
115 biblioitems.volumeddesc Volume Information
116 biblioitems.timestamp Timestamp
117 biblioitems.illus Illustrator
118 biblioitems.pages Number of Pages
119 biblioitems.notes Notes
120 biblioitems.size Size
121 biblioitems.place Place of Publication
122 biblioitems.lccn LCCN
123 biblioitems.marc MARC Blob