1 package Koha::Database::Columns;
3 # This file is part of Koha.
5 # Koha is free software; you can redistribute it and/or modify it
6 # under the terms of the GNU General Public License as published by
7 # the Free Software Foundation; either version 3 of the License, or
8 # (at your option) any later version.
10 # Koha is distributed in the hope that it will be useful, but
11 # WITHOUT ANY WARRANTY; without even the implied warranty of
12 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
13 # GNU General Public License for more details.
15 # You should have received a copy of the GNU General Public License
16 # along with Koha; if not, see <http://www.gnu.org/licenses>.
20 Koha::Database::Columns
24 use Koha::Database::Columns;
31 use Koha::I18N qw( __ );
36 "borrowernumber" => __("Borrower number"),
37 "title" => __("Salutation"),
38 "surname" => __("Surname"),
39 "firstname" => __("First name"),
40 "dateofbirth" => __("Date of birth"),
41 "initials" => __("Initials"),
42 "othernames" => __("Other name"),
43 "sex" => __("Gender"),
44 "relationship" => __("Relationship"),
45 "streetnumber" => __("Street number"),
46 "streettype" => __("Street type"),
47 "address" => __("Address"),
48 "address2" => __("Address 2"),
50 "state" => __("State"),
51 "zipcode" => __("ZIP/Postal code"),
52 "country" => __("Country"),
53 "phone" => __("Primary phone"),
54 "phonepro" => __("Secondary phone"),
55 "mobile" => __("Other phone"),
56 "email" => __("Primary email"),
57 "emailpro" => __("Secondary email"),
59 "B_streetnumber" => __("Alternate address: Street number"),
60 "B_streettype" => __("Alternate address: Street type"),
61 "B_address" => __("Alternate address: Address"),
62 "B_address2" => __("Alternate address: Address 2"),
63 "B_city" => __("Alternate address: City"),
64 "B_state" => __("Alternate address: State"),
65 "B_zipcode" => __("Alternate address: ZIP/Postal code"),
66 "B_country" => __("Alternate address: Country"),
67 "B_phone" => __("Alternate address: Phone"),
68 "B_email" => __("Alternate address: Email"),
69 "contactnote" => __("Alternate contact: Note"),
70 "altcontactfirstname" => __("Alternate contact: First name"),
71 "altcontactsurname" => __("Alternate contact: Surname"),
72 "altcontactaddress1" => __("Alternate contact: Address"),
73 "altcontactaddress2" => __("Alternate contact: Address 2"),
74 "altcontactaddress3" => __("Alternate contact: City"),
75 "contactname" => __("Alternate contact: Surname"),
76 "contactfirstname" => __("Alternate contact: First name"),
77 "contacttitle" => __("Alternate contact: Title"),
78 "altcontactstate" => __("Alternate contact: State"),
79 "altcontactzipcode" => __("Alternate contact: ZIP/Postal code"),
80 "altcontactcountry" => __("Alternate contact: Country"),
81 "altcontactphone" => __("Alternate contact: Phone"),
82 "cardnumber" => __("Card number"),
83 "branchcode" => __("Home library"),
84 "categorycode" => __("Patron category"),
85 "sort1" => __("Sort 1"),
86 "sort2" => __("Sort 2"),
87 "dateenrolled" => __("Registration date"),
88 "dateexpiry" => __("Expiry date"),
89 "opacnote" => __("OPAC note"),
90 "borrowernotes" => __("Circulation note"),
91 "userid" => __("Username"),
92 "password" => __("Password"),
93 "flags" => __("System permissions"),
94 "gonenoaddress" => __("Gone no address flag"),
95 "lost" => __("Lost card flag"),
96 "debarred" => __("Restricted [until] flag"),
97 "debarredcomment" => __("Comment"),
98 "smsalertnumber" => __("Mobile phone number"),
99 "privacy" => __("Privacy settings"),
100 "autorenew_checkouts" => __("Allow auto-renewals"),
103 "itemnumber" => __("Item number (internal)"),
104 "biblionumber" => __("Biblio number (internal)"),
105 "biblioitemnumber" => __("Biblioitem number (internal)"),
106 "barcode" => __("Barcode"),
107 "dateaccessioned" => __("Date acquired"),
108 "booksellerid" => __("Source of acquisition"),
109 "homebranch" => __("Permanent library"),
110 "price" => __("Price"),
111 "replacementprice" => __("Replacement price"),
112 "replacementpricedate" => __("Price effective from"),
113 "datelastborrowed" => __("Date last checked out"),
114 "datelastseen" => __("Date last seen"),
115 "stack" => __("Shelving control number"),
116 "onloan" => __("Due date"),
117 "cn_source" => __("Source of classification / shelving scheme"),
118 "cn_sort" => __("Koha normalized classification for sorting"),
119 "notforloan" => __("Not for loan"),
120 "itemlost" => __("Lost status"),
121 "itemlost_on" => __("Lost on"),
122 "withdrawn" => __("Withdrawn status"),
123 "withdrawn_on" => __("Withdrawn on"),
124 "itemcallnumber" => __("Call number"),
125 "issues" => __("Total checkouts"),
126 "renewals" => __("Total renewals"),
127 "reserves" => __("Total holds"),
128 "restricted" => __("Use restrictions"),
129 "itemnotes" => __("Public note"),
130 "itemnotes_nonpublic" => __("Internal note"),
131 "holdingbranch" => __("Current library"),
132 "timestamp" => __("Timestamp"),
133 "location" => __("Shelving location"),
134 "permanent_location" => __("Permanent shelving location"),
135 "ccode" => __("Collection"),
136 "itype" => __("Koha itemtype"),
137 "stocknumber" => __("Inventory number"),
138 "damaged" => __("Damaged status"),
139 "damaged_on" => __("Damaged on"),
140 "materials" => __("Materials specified"),
141 "uri" => __("Uniform Resource Identifier"),
142 "more_subfields_xml" => __("Additional subfields (XML)"),
143 "enumchron" => __("Serial enumeraton/chronology"),
144 "copynumber" => __("Copy number"),
145 "new_status" => __("New status"),
148 "datetime" => __("Statistics date and time"),
149 "branch" => __("Library"),
150 "value" => __("Value"),
151 "type" => __("Type"),
153 "itemnumber" => __("Item number"),
154 "itemtype" => __("Itemtype"),
155 "borrowernumber" => __("Borrower number"),
158 "frameworkcode" => __("Framework code"),
159 "author" => __("Author"),
160 "datecreated" => __("Creation date"),
161 "timestamp" => __("Modification date"),
164 "biblioitemnumber" => __("Biblioitem number"),
165 "biblionumber" => __("Biblio number"),
166 "volume" => __("Volume number"),
167 "number" => __("Number"),
168 "classification" => __("Classification"),
169 "itemtype" => __("Biblio-level item type"),
170 "isbn" => __("ISBN"),
171 "issn" => __("ISSN"),
172 "dewey" => __("Dewey/classification"),
173 "subclass" => __("Sub classification"),
174 "publicationyear" => __("Publication date"),
175 "publishercode" => __("Publisher"),
176 "volumedate" => __("Volume date"),
177 "volumedesc" => __("Volume information"),
178 "timestamp" => __("Timestamp"),
179 "illus" => __("Illustrations"),
180 "pages" => __("Number of pages"),
181 "notes" => __("Notes"),
182 "size" => __("Size"),
183 "place" => __("Place of publication"),
184 "lccn" => __("LCCN"),
185 "agerestriction" => __("Age restriction"),
187 "title" => __("Title"),
190 "startdate" => __("Start date"),
191 "enddate" => __("End date"),
192 "periodicity" => __("Periodicity"),
193 "callnumber" => __("Call number"),
194 "location" => __("Location"),
195 "branchcode" => __("Library"),
198 "author" => __("author"),
199 "copyrightdate" => __("copyrightdate"),
200 "isbn" => __("isbn"),
201 "publishercode" => __("publishercode"),
202 "collectiontitle" => __("collectiontitle"),
203 "place" => __("place"),
204 "quantity" => __("quantity"),
205 "itemtype" => __("itemtype"),
206 "branchcode" => __("branchcode"),
207 "patronreason" => __("patronreason"),
208 "note" => __("note"),