|
Lines 10-30
borrowers.relationship Relationship
Link Here
|
| 10 |
borrowers.guarantorid Guarantor borrower number |
10 |
borrowers.guarantorid Guarantor borrower number |
| 11 |
borrowers.streetnumber Street number |
11 |
borrowers.streetnumber Street number |
| 12 |
borrowers.streettype Street type |
12 |
borrowers.streettype Street type |
| 13 |
borrowers.address |
13 |
borrowers.address Address |
| 14 |
borrowers.address2 |
14 |
borrowers.address2 Address 2 |
| 15 |
borrowers.city City |
15 |
borrowers.city City |
| 16 |
borrowers.state State |
16 |
borrowers.state State |
| 17 |
borrowers.zipcode Zip/postal code |
17 |
borrowers.zipcode Zip/postal code |
| 18 |
borrowers.country Country |
18 |
borrowers.country Country |
| 19 |
borrowers.phone Primary phone |
19 |
borrowers.phone Primary phone |
| 20 |
borrowres.phonepro Secondary phone |
20 |
borrowers.phonepro Secondary phone |
| 21 |
borrowers.mobile Other phone |
21 |
borrowers.mobile Other phone |
| 22 |
borrowers.email Primary email |
22 |
borrowers.email Primary email |
| 23 |
borrowers.emailpro Secondary email |
23 |
borrowers.emailpro Secondary email |
| 24 |
borrowers.fax Fax |
24 |
borrowers.fax Fax |
| 25 |
borrowers.B_streetnumber Alternate address: Street number |
25 |
borrowers.B_streetnumber Alternate address: Street number |
| 26 |
borrowers.B_stretttype Alternatate address: Street type |
26 |
borrowers.B_streettype Alternate address: Street type |
| 27 |
borrowres.B_address Alternate address: Address |
27 |
borrowers.B_address Alternate address: Address |
| 28 |
borrowers.B_address2 Alternate address: Address 2 |
28 |
borrowers.B_address2 Alternate address: Address 2 |
| 29 |
borrowers.B_city Alternate address: City |
29 |
borrowers.B_city Alternate address: City |
| 30 |
borrowers.B_state Alternate address: State |
30 |
borrowers.B_state Alternate address: State |
|
Lines 32-49
borrowers.B_zipcode Alternate address: Zip/postal code
Link Here
|
| 32 |
borrowers.B_country Alternate address: Country |
32 |
borrowers.B_country Alternate address: Country |
| 33 |
borrowers.B_phone Alternate address: Phone |
33 |
borrowers.B_phone Alternate address: Phone |
| 34 |
borrowers.B_email Alternate address: Email |
34 |
borrowers.B_email Alternate address: Email |
| 35 |
borrowers.contactnote Altenate address: contact note |
35 |
borrowers.contactnote Alternate contact: Note |
| 36 |
borrowers.altcontactfirstname Alternate contact: Surname |
36 |
borrowers.altcontactfirstname Alternate contact: Last name |
| 37 |
borrowres.altcontactsurname Alternate contact: First name |
37 |
borrowers.altcontactsurname Alternate contact: First name |
| 38 |
borrowers.altcontactaddress1 Alternate contact: Address |
38 |
borrowers.altcontactaddress1 Alternate contact: Address |
| 39 |
borrowers.altcontactaddress2 Alternate contact: Adress 2 |
39 |
borrowers.altcontactaddress2 Alternate contact: Address 2 |
| 40 |
borrowers.altcontactaddress3 Alternate contact: City |
40 |
borrowers.altcontactaddress3 Alternate contact: City |
|
|
41 |
borrowers.contactname Alternate contact: Surname |
| 42 |
borrowers.contactfirstname Alternate contact: First name |
| 43 |
borrowers.contacttitle Alternate contact: Title |
| 41 |
borrowers.altcontactstate Alternate contact: State |
44 |
borrowers.altcontactstate Alternate contact: State |
| 42 |
borrowers.altcontactzipcode Alternate contact: Zip/postal code |
45 |
borrowers.altcontactzipcode Alternate contact: Zip/postal code |
| 43 |
borrowers.altcontactcountry Alternate contact: Country |
46 |
borrowers.altcontactcountry Alternate contact: Country |
| 44 |
borrowers.altcontactphone Alternate contact: Phone |
47 |
borrowers.altcontactphone Alternate contact: Phone |
| 45 |
borrowers.cardnumber Card number |
48 |
borrowers.cardnumber Card number |
| 46 |
borrowers.branchcode Library |
49 |
borrowers.branchcode Home library |
| 47 |
borrowers.categorycode Category |
50 |
borrowers.categorycode Category |
| 48 |
borrowers.sort1 Sort 1 |
51 |
borrowers.sort1 Sort 1 |
| 49 |
borrowers.sort2 Sort 2 |
52 |
borrowers.sort2 Sort 2 |
|
Lines 51-62
borrowers.dateenrolled Registration date
Link Here
|
| 51 |
borrowers.dateexpiry Expiry date |
54 |
borrowers.dateexpiry Expiry date |
| 52 |
borrowers.opacnote OPAC note |
55 |
borrowers.opacnote OPAC note |
| 53 |
borrowers.borrowernotes Circulation note |
56 |
borrowers.borrowernotes Circulation note |
| 54 |
borrowres.username Username |
57 |
borrowers.userid Username |
| 55 |
borrowers.password Password |
58 |
borrowers.password Password |
| 56 |
borrowers.gonenoaddress Gone no address |
59 |
borrowers.flags System permissions |
| 57 |
borrowers.lost Lost card |
60 |
borrowers.gonenoaddress Gone no address flag |
| 58 |
borrowers.debarred Restricted until |
61 |
borrowers.lost Lost card flag |
| 59 |
borrowers.debarredcomment Coment |
62 |
borrowers.debarred Restricted [until] flag |
|
|
63 |
borrowers.debarredcomment Comment |
| 64 |
borrowers.smsalertnumber Mobile phone number |
| 65 |
borrowers.privacy Privacy settings |
| 60 |
items.itemnumber Item number (internal) |
66 |
items.itemnumber Item number (internal) |
| 61 |
items.biblionumber Biblio number (internal) |
67 |
items.biblionumber Biblio number (internal) |
| 62 |
items.biblioitemnumber Biblioitem number (internal) |
68 |
items.biblioitemnumber Biblioitem number (internal) |
|
Lines 71-77
items.datelastborrowed Date last checked out
Link Here
|
| 71 |
items.datelastseen Date last seen |
77 |
items.datelastseen Date last seen |
| 72 |
items.stack Shelving control number |
78 |
items.stack Shelving control number |
| 73 |
items.onloan Due date |
79 |
items.onloan Due date |
| 74 |
items.cn_source Source of classificaton / shelving scheme |
80 |
items.cn_source Source of classification / shelving scheme |
| 75 |
items.cn_sort Koha normalized classification for sorting |
81 |
items.cn_sort Koha normalized classification for sorting |
| 76 |
items.notforloan Not for loan |
82 |
items.notforloan Not for loan |
| 77 |
items.itemlost Lost status |
83 |
items.itemlost Lost status |
|
Lines 112-118
biblio.timestamp Modification date
Link Here
|
| 112 |
biblioitems.biblioitemnumber Biblioitem number |
118 |
biblioitems.biblioitemnumber Biblioitem number |
| 113 |
biblioitems.biblionumber Biblio number |
119 |
biblioitems.biblionumber Biblio number |
| 114 |
biblioitems.volume Volume number |
120 |
biblioitems.volume Volume number |
| 115 |
biblioitems.number number |
121 |
biblioitems.number Number |
| 116 |
biblioitems.classification Classification |
122 |
biblioitems.classification Classification |
| 117 |
biblioitems.itemtype Biblio-level item type |
123 |
biblioitems.itemtype Biblio-level item type |
| 118 |
biblioitems.isbn ISBN |
124 |
biblioitems.isbn ISBN |
|
Lines 122-128
biblioitems.subclass Sub classification
Link Here
|
| 122 |
biblioitems.publicationyear Publication date |
128 |
biblioitems.publicationyear Publication date |
| 123 |
biblioitems.publishercode Publisher |
129 |
biblioitems.publishercode Publisher |
| 124 |
biblioitems.volumedate Volume date |
130 |
biblioitems.volumedate Volume date |
| 125 |
biblioitems.volumeddesc Volume information |
131 |
biblioitems.volumedesc Volume information |
| 126 |
biblioitems.timestamp Timestamp |
132 |
biblioitems.timestamp Timestamp |
| 127 |
biblioitems.illus Illustrator |
133 |
biblioitems.illus Illustrator |
| 128 |
biblioitems.pages Number of pages |
134 |
biblioitems.pages Number of pages |
| 129 |
- |
|
|