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