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 |
- |
|
|