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.date_due Due Date
82 items.issuedate Issue Date
83 items.location Location
84 items.ccode Koha Collection
85 items.itype Item-level Item Type
90 statistics.datetime Statistics Date and Time
91 statistics.branch Branch Code
92 statistics.proccode Type of Procedure
93 statistics.value Value
96 statistics.usercode User Code
97 statistics.itemnumber Item Number
98 statistics.itemtype Item Type
99 statistics.borrowernumber Borrower Number
100 biblio.frameworkcode Framework Code
102 biblio.datecreated Creation Date
103 biblio.timestamp Modification Date
104 biblioitems.biblioitemnumber Biblioitem Number
105 biblioitems.biblionumber Biblio Number
106 biblioitems.volume Volume Number
107 biblioitems.number Number
108 biblioitems.classification Classification
109 biblioitems.itemtype Biblio-level Item Type
110 biblioitems.isbn ISBN
111 biblioitems.issn ISSN
112 biblioitems.dewey Dewey/Classification
113 biblioitems.subclass Sub Classification
114 biblioitems.publicationyear Publication Date
115 biblioitems.publishercode Publisher
116 biblioitems.volumedate Volume Date
117 biblioitems.volumeddesc Volume Information
118 biblioitems.timestamp Timestamp
119 biblioitems.illus Illustrator
120 biblioitems.pages Number of Pages
121 biblioitems.notes Notes
122 biblioitems.size Size
123 biblioitems.place Place of Publication
124 biblioitems.lccn LCCN
125 biblioitems.marc MARC Blob