|
Lines 1-124
Link Here
|
| 1 |
borrowers.borrowernumber Borrower Number |
1 |
borrowers.borrowernumber Borrower number |
| 2 |
borrowers.cardnumber Card Number |
2 |
borrowers.title Salutation |
| 3 |
borrowers.surname Surname |
3 |
borrowers.surname Surname |
| 4 |
borrowers.firstname Firstname |
4 |
borrowers.firstname First name |
| 5 |
borrowers.title Title |
5 |
borrowers.dateofbirth Date of birth |
| 6 |
borrowers.othernames Other Names |
6 |
borrowers.initials Initials |
| 7 |
borrowers.initials Initials |
7 |
borrowers.othernames Other name |
| 8 |
borrowers.streetaddress Street Address |
|
|
| 9 |
borrowers.suburb Suburb |
| 10 |
borrowers.city City |
| 11 |
borrowers.phone Phone |
| 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 Restricted |
| 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) |
| 31 |
borrowers.area Area |
| 32 |
borrowers.ethnicity Ethnicity |
| 33 |
borrowers.ethnotes Ethnicity Notes |
| 34 |
borrowers.sex Gender |
8 |
borrowers.sex Gender |
| 35 |
borrowers.expiry Expiry Date |
9 |
borrowers.relationship Relationship |
| 36 |
borrowers.altnotes Alternative Contact Notes |
10 |
borrowers.guarantorid Guarantor borrower number |
| 37 |
borrowers.altrelationship Relationship of Alternative Contact |
11 |
borrowers.streetnumber Street number |
| 38 |
borrowers.streetcity Streetcity?? |
12 |
borrowers.streettype Street type |
| 39 |
borrowers.phoneday Work Phone |
13 |
borrowers.address |
| 40 |
borrowers.preferredcont Preferred method of Contact |
14 |
borrowers.address2 |
| 41 |
borrowers.physstreet Physical Street Address |
15 |
borrowers.city City |
| 42 |
borrowers.password Password |
16 |
borrowers.state State |
| 43 |
borrowers.flags Warnings |
17 |
borrowers.zipcode Zip/postal code |
| 44 |
borrowers.userid Login ID |
18 |
borrowers.country Country |
| 45 |
borrowers.homezipcode Zip/Post Code |
19 |
borrowers.phone Primary phone |
| 46 |
borrowers.zipcode Zip/Post Code 2? |
20 |
borrowres.phonepro Secondary phone |
| 47 |
borrowers.sort1 Sorting Column |
21 |
borrowers.mobile Other phone |
| 48 |
borrowers.sort2 Sorting Column 2 |
22 |
borrowers.email Primary email |
| 49 |
borrowers.cellph Cellphone number |
23 |
borrowers.emailpro Secondary email |
| 50 |
borrowers.borlog |
24 |
borrowers.fax Fax |
| 51 |
borrowers.checkhist |
25 |
borrowers.B_streetnumber Alternate address: Street number |
| 52 |
items.itemnumber Item Number (koha internal) |
26 |
borrowers.B_stretttype Alternatate address: Street type |
| 53 |
items.biblionumber Biblio Number (koha internal) |
27 |
borrowres.B_address Alternate address: Address |
| 54 |
items.multivolumepart Item one part of a Multi volume set |
28 |
borrowers.B_address2 Alternate address: Address 2 |
| 55 |
items.biblioitemnumber Biblioitem Number (koha internal) |
29 |
borrowers.B_city Alternate address: City |
|
|
30 |
borrowers.B_state Alternate address: State |
| 31 |
borrowers.B_zipcode Alternate address: Zip/postal code |
| 32 |
borrowers.B_country Alternate address: Country |
| 33 |
borrowers.B_phone Alternate address: Phone |
| 34 |
borrowers.B_email Alternate address: Email |
| 35 |
borrowers.contactnote Altenate address: contact note |
| 36 |
borrowers.altcontactfirstname Alternate contact: Surname |
| 37 |
borrowres.altcontactsurname Alternate contact: First name |
| 38 |
borrowers.altcontactaddress1 Alternate contact: Address |
| 39 |
borrowers.altcontactaddress2 Alternate contact: Adress 2 |
| 40 |
borrowers.altcontactaddress3 Alternate contact: City |
| 41 |
borrowers.altcontactstate Alternate contact: State |
| 42 |
borrowers.altcontactzipcode Alternate contact: Zip/postal code |
| 43 |
borrowers.altcontactcountry Alternate contact: Country |
| 44 |
borrowers.altcontactphone Alternate contact: Phone |
| 45 |
borrowers.cardnumber Card number |
| 46 |
borrowers.branchcode Library |
| 47 |
borrowers.categorycode Category |
| 48 |
borrowers.sort1 Sort 1 |
| 49 |
borrowers.sort2 Sort 2 |
| 50 |
borrowers.dateenrolled Registration date |
| 51 |
borrowers.dateexpiry Expiry date |
| 52 |
borrowers.opacnote OPAC note |
| 53 |
borrowers.borrowernotes Circulation note |
| 54 |
borrowres.username Username |
| 55 |
borrowers.password Password |
| 56 |
borrowers.gonenoaddress Gone no address |
| 57 |
borrowers.lost Lost card |
| 58 |
borrowers.debarred Restricted until |
| 59 |
borrowers.debarredcomment Coment |
| 60 |
items.itemnumber Item number (internal) |
| 61 |
items.biblionumber Biblio number (internal) |
| 62 |
items.biblioitemnumber Biblioitem number (internal) |
| 56 |
items.barcode Barcode |
63 |
items.barcode Barcode |
| 57 |
items.dateaccessioned Accession Date |
64 |
items.dateaccessioned Date acquired |
| 58 |
items.booksellerid Supplier ID |
65 |
items.booksellerid Source of acquisition |
| 59 |
items.homebranch Home Branch |
66 |
items.homebranch Permanent library |
| 60 |
items.price Price |
67 |
items.price Price |
| 61 |
items.replacementprice Replacement Price |
68 |
items.replacementprice Replacement price |
| 62 |
items.replacementpricedate Date Replacement Price was set |
69 |
items.replacementpricedate Price effective from |
| 63 |
items.datelastborrowed Date Item last issued |
70 |
items.datelastborrowed Date last checked out |
| 64 |
items.datelastseen Date Item was last seen by Koha |
71 |
items.datelastseen Date last seen |
| 65 |
items.multivolume Volume Number (if part of a multivolume work) |
72 |
items.stack Shelving control number |
| 66 |
items.stack Is the item in the stack? |
73 |
items.onloan Due date |
| 67 |
items.onloan On loan |
74 |
items.cn_source Source of classificaton / shelving scheme |
| 68 |
items.notforloan Item Not for loan |
75 |
items.cn_sort Koha normalized classification for sorting |
| 69 |
items.itemlost Item Lost |
76 |
items.notforloan Not for loan |
| 70 |
items.wthdrawn Item Cancelled |
77 |
items.itemlost Lost status |
| 71 |
items.itemcallnumber Item Call Number |
78 |
items.wthdrawn Withdrawn status |
| 72 |
items.issues Issues Count |
79 |
items.itemcallnumber Call number |
| 73 |
items.renewals Renewals Count |
80 |
items.issues Total checkouts |
| 74 |
items.reserves Reserves Count |
81 |
items.renewals Total renewals |
| 75 |
items.restricted Item Restricted |
82 |
items.reserves Total holds |
| 76 |
items.binding Item needs binding |
83 |
items.restricted Use restrictions |
| 77 |
items.itemnotes Item Notes |
84 |
items.itemnotes Public note |
| 78 |
items.holdingbranch Holding Branch |
85 |
items.holdingbranch Current library |
| 79 |
items.paidfor Has Item been lost and then paid for |
86 |
items.paidfor |
| 80 |
items.timestamp Timestamp |
87 |
items.timestamp Timestamp |
| 81 |
items.location Location |
88 |
items.location Shelving location |
| 82 |
items.ccode Koha Collection |
89 |
items.ccode Collection code |
| 83 |
items.itype Item-level Item Type |
90 |
items.itype Koha itemtype |
| 84 |
items.spystatus |
91 |
items.stocknumber Inventory number |
| 85 |
items.spydescr |
92 |
items.damaged Damaged status |
| 86 |
items.itemlog |
93 |
items.materials Materials specified |
| 87 |
items.spycopydata |
94 |
items.uri Uniform Resource Identifier |
| 88 |
statistics.datetime Statistics Date and Time |
95 |
items.more_subfields_xml Additional subfields (XML) |
| 89 |
statistics.branch Branch Code |
96 |
items.enumchron Serial enumeraton/chronology |
| 90 |
statistics.proccode Type of Procedure |
97 |
items.copynumber Copy number |
|
|
98 |
statistics.datetime Statistics date and time |
| 99 |
statistics.branch Library |
| 100 |
statistics.proccode Type of procedure |
| 91 |
statistics.value Value |
101 |
statistics.value Value |
| 92 |
statistics.type Type |
102 |
statistics.type Type |
| 93 |
statistics.other |
103 |
statistics.other |
| 94 |
statistics.usercode User Code |
104 |
statistics.usercode User code |
| 95 |
statistics.itemnumber Item Number |
105 |
statistics.itemnumber Item number |
| 96 |
statistics.itemtype Item Type |
106 |
statistics.itemtype Itemtype |
| 97 |
statistics.borrowernumber Borrower Number |
107 |
statistics.borrowernumber Borrower number |
| 98 |
biblio.frameworkcode Framework Code |
108 |
biblio.frameworkcode Framework code |
| 99 |
biblio.author Author |
109 |
biblio.author Author |
| 100 |
biblio.datecreated Creation Date |
110 |
biblio.datecreated Creation date |
| 101 |
biblio.timestamp Modification Date |
111 |
biblio.timestamp Modification date |
| 102 |
biblioitems.biblioitemnumber Biblioitem Number |
112 |
biblioitems.biblioitemnumber Biblioitem number |
| 103 |
biblioitems.biblionumber Biblio Number |
113 |
biblioitems.biblionumber Biblio number |
| 104 |
biblioitems.volume Volume Number |
114 |
biblioitems.volume Volume number |
| 105 |
biblioitems.number Number |
115 |
biblioitems.number number |
| 106 |
biblioitems.classification Classification |
116 |
biblioitems.classification Classification |
| 107 |
biblioitems.itemtype Biblio-level Item Type |
117 |
biblioitems.itemtype Biblio-level item type |
| 108 |
biblioitems.isbn ISBN |
118 |
biblioitems.isbn ISBN |
| 109 |
biblioitems.issn ISSN |
119 |
biblioitems.issn ISSN |
| 110 |
biblioitems.dewey Dewey/Classification |
120 |
biblioitems.dewey Dewey/classification |
| 111 |
biblioitems.subclass Sub Classification |
121 |
biblioitems.subclass Sub classification |
| 112 |
biblioitems.publicationyear Publication Date |
122 |
biblioitems.publicationyear Publication date |
| 113 |
biblioitems.publishercode Publisher |
123 |
biblioitems.publishercode Publisher |
| 114 |
biblioitems.volumedate Volume Date |
124 |
biblioitems.volumedate Volume date |
| 115 |
biblioitems.volumeddesc Volume Information |
125 |
biblioitems.volumeddesc Volume information |
| 116 |
biblioitems.timestamp Timestamp |
126 |
biblioitems.timestamp Timestamp |
| 117 |
biblioitems.illus Illustrator |
127 |
biblioitems.illus Illustrator |
| 118 |
biblioitems.pages Number of Pages |
128 |
biblioitems.pages Number of pages |
| 119 |
biblioitems.notes Notes |
129 |
biblioitems.notes Notes |
| 120 |
biblioitems.size Size |
130 |
biblioitems.size Size |
| 121 |
biblioitems.place Place of Publication |
131 |
biblioitems.place Place of publication |
| 122 |
biblioitems.lccn LCCN |
132 |
biblioitems.lccn LCCN |
| 123 |
biblioitems.marc MARC Blob |
133 |
biblioitems.marcxml MARC blob |
| 124 |
biblioitems.url URL |
134 |
biblioitems.url URL |
| 125 |
- |
|
|