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 Permanent Branch Code
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?
67 items.notforloan Item Not for loan
68 items.itemlost Item Lost
69 items.wthdrawn Item Cancelled
70 items.itemcallnumber Item Call Number
71 items.issues Issues Count
72 items.renewals Renewals Count
73 items.reserves Reserves Count
74 items.restricted Item Restricted
75 items.binding Item needs binding
76 items.itemnotes Item Notes
77 items.holdingbranch Current Branch
78 items.paidfor Has Item been lost and then paid for
79 items.timestamp Timestamp
80 items.location Location
81 items.ccode Koha Collection
82 items.itype Item-level Item Type
87 statistics.datetime Statistics Date and Time
88 statistics.branch Branch Code
89 statistics.proccode Type of Procedure
90 statistics.value Value
93 statistics.usercode User Code
94 statistics.itemnumber Item Number
95 statistics.itemtype Item Type
96 statistics.borrowernumber Borrower Number
97 biblioitems.biblioitemnumber Biblioitem Number
98 biblioitems.biblionumber Biblio Number
99 biblioitems.volume Volume Number
100 biblioitems.number Number
101 biblioitems.classification Classification
102 biblioitems.itemtype Biblio-level Item Type
103 biblioitems.isbn ISBN
104 biblioitems.issn ISSN
105 biblioitems.dewey Dewey/Classification
106 biblioitems.subclass Sub Classification
107 biblioitems.publicationyear Publication Date
108 biblioitems.publishercode Publisher
109 biblioitems.volumedate Volume Date
110 biblioitems.volumeddesc Volume Information
111 biblioitems.timestamp Timestamp
112 biblioitems.illus Illustrator
113 biblioitems.pages Number of Pages
114 biblioitems.notes Notes
115 biblioitems.size Size
116 biblioitems.place Place of Publication
117 biblioitems.lccn LCCN
118 biblioitems.marc MARC Blob