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
85 statistics.datetime Statistics Date and Time
86 statistics.branch Branch Code
87 statistics.proccode Type of Procedure
88 statistics.value Value
91 statistics.usercode User Code
92 statistics.itemnumber Item Number
93 statistics.itemtype Item Type
94 statistics.borrowernumber Borrower Number
95 biblioitems.biblioitemnumber Biblioitem Number
96 biblioitems.biblionumber Biblio Number
97 biblioitems.volume Volume Number
98 biblioitems.number Number
99 biblioitems.classification Classification
100 biblioitems.itemtype Itemtype
101 biblioitems.isbn ISBN
102 biblioitems.issn ISSN
103 biblioitems.dewey Dewey/Classification
104 biblioitems.subclass Sub Classification
105 biblioitems.publicationyear Publication Date
106 biblioitems.publishercode Publisher
107 biblioitems.volumedate Volume Date
108 biblioitems.volumeddesc Volume Information
109 biblioitems.timestamp Timestamp
110 biblioitems.illus Illustrator
111 biblioitems.pages Number of Pages
112 biblioitems.notes Notes
113 biblioitems.size Size
114 biblioitems.place Place of Publication
115 biblioitems.lccn LCCN
116 biblioitems.marc MARC Blob