Bug 18786: Update database
[koha.git] / admin / columns_settings.yml
blob23903646b075d3fe13e46fab827eefd934a44561
1 modules:
2   acqui:
3     histsearch:
4       histsearcht:
5         -
6           columnname: order_line
7         -
8           columnname: status
9         -
10           columnname: basket
11         -
12           columnname: basket_creator
13         -
14           columnname: basket_group
15         -
16           columnname: invoice_number
17         -
18           columnname: summary
19         -
20           columnname: vendor
21         -
22           columnname: placed_on
23         -
24           columnname: received_on
25         -
26           columnname: quantity_received
27         -
28           columnname: pending_order
29         -
30           columnname: unit_cost
31         -
32           columnname: fund
34     lateorders:
35       late_orders:
36         -
37           columnname: checkbox
38           cannot_be_toggled: 1
39           cannot_be_modified: 1
40         -
41           columnname: order_date
42         -
43           columnname: estimated_delivery_date
44         -
45           columnname: vendor
46         -
47           columnname: information
48         -
49           columnname: total_cost
50         -
51           columnname: basket
52         -
53           columnname: basket_group
54         -
55           columnname: library
56         -
57           columnname: fund
58         -
59           columnname: claims_count
60         -
61           columnname: claimed_date
63   admin:
64     currency:
65       currencies-table:
66         -
67           columnname: currency
68           cannot_be_toggled: 1
69           cannot_be_modified: 1
70         -
71           columnname: rate
72           cannot_be_toggled: 1
73           cannot_be_modified: 1
74         -
75           columnname: symbol
76         -
77           columnname: iso_code
78           is_hidden: 1
79         -
80           columnname: last_updated
81         -
82           columnname: active
83         -
84           columnname: actions
86   cataloguing:
87     additem:
88       itemst:
89         # NOTE: These columns are in the same order as kohastructure.sql, and contain all items
90         # columns except for the following internal/obsolete fields: stack, more_subfields_xml,
91         # cn_sort, permanent_location, damaged_on itemlost_on, withdrawn_on, issues, renewals and
92         # reserves.
93         -
94           columnname: barcode
95         -
96           columnname: dateaccessioned
97         -
98           columnname: booksellerid
99         -
100           columnname: homebranch
101         -
102           columnname: price
103         -
104           columnname: replacementprice
105         -
106           columnname: replacementpricedate
107         -
108           columnname: datelastborrowed
109         -
110           columnname: datelastseen
111         -
112           columnname: stack
113         -
114           columnname: notforloan
115         -
116           columnname: damaged
117         -
118           columnname: itemlost
119         -
120           columnname: withdrawn
121         -
122           columnname: itemcallnumber
123         -
124           columnname: coded_location_qualifier
125         -
126           columnname: restricted
127         -
128           columnname: itemnotes
129         -
130           columnname: itemnotes_nonpublic
131         -
132           columnname: holdingbranch
133         -
134           columnname: paidfor
135         -
136           columnname: timestamp
137         -
138           columnname: location
139         -
140           columnname: onloan
141         -
142           columnname: cn_source
143         -
144           columnname: ccode
145         -
146           columnname: materials
147         -
148           columnname: uri
149         -
150           columnname: itype
151         -
152           columnname: enumchron
153         -
154           columnname: copynumber
155         -
156           columnname: stocknumber
158   members:
159     fines:
160       account-fines:
161         -
162           columnname: date
163         -
164           columnname: description
165         -
166           columnname: note
167         -
168           columnname: amount
169           cannot_be_toggled: 1
170           cannot_be_modified: 1
171         -
172           columnname: amountoutstanding
173           cannot_be_toggled: 1
174           cannot_be_modified: 1
175         -
176           columnname: actions
177           cannot_be_toggled: 1
178           cannot_be_modified: 1
180     member:
181       memberresultst:
182         -
183           columnname: checkbox
184           cannot_be_toggled: 1
185           cannot_be_modified: 1
186         -
187           columnname: cardnumber
188         -
189           columnname: name
190         -
191           columnname: dateofbirth
192         -
193           columnname: category
194         -
195           columnname: library
196         -
197           columnname: expires_on
198         -
199           columnname: od_checkouts
200         -
201           columnname: fines
202         -
203           columnname: circ_notes
204         -
205           columnname: actions
206           cannot_be_toggled: 1
207           cannot_be_modified: 1
209     moremember:
210       issues-table:
211         -
212           columnname: sort_order
213           cannot_be_toggled: 1
214           cannot_be_modified: 1
215           is_hidden: 1
216         -
217           columnname: todays_or_previous_checkouts
218           cannot_be_toggled: 1
219           cannot_be_modified: 1
220           is_hidden: 1
221         -
222           columnname: due_date_unformatted
223           cannot_be_toggled: 1
224           cannot_be_modified: 1
225           is_hidden: 1
226         -
227           columnname: due_date
228         -
229           columnname: title
230         -
231           columnname: item_type
232         -
233           columnname: location
234         -
235           columnname: homebranch
236         -
237           columnname: checkout_on
238         -
239           columnname: checkout_from
240         -
241           columnname: callno
242         -
243           columnname: charge
244         -
245           columnname: fine
246         -
247           columnname: price
248         -
249           columnname: renew
250           cannot_be_toggled: 1
251           cannot_be_modified: 1
252         -
253           columnname: checkin
254         -
255           columnname: export
256           cannot_be_toggled: 1
257           cannot_be_modified: 1
259     holdshistory:
260       holdshistory-table:
261         -
262           columnname: title
263           cannot_be_toggled: 1
264           cannot_be_modified: 1
265         -
266           columnname: author
267         -
268           columnname: barcode
269         -
270           columnname: branch
271         -
272           columnname: reservedate
273         -
274           columnname: expirationdate
275         -
276           columnname: waitingdate
277         -
278           columnname: cancellationdate
279         -
280           columnname: itemtype
281         -
282           columnname: status
284   reports:
285     lostitems:
286       lostitems-table:
287         -
288           columnname: title
289           cannot_be_toggled: 1
290           cannot_be_modified: 1
291         -
292           columnname: author
293         -
294           columnname: lostcode
295         -
296           columnname: itemlost_on
297         -
298           columnname: barcode
299         -
300           columnname: callnumber
301         -
302           columnname: datelastseen
303         -
304           columnname: price
305         -
306           columnname: replacementprice
307         -
308           columnname: library
309         -
310           columnname: itemtype
311         -
312           columnname: current_location
313         -
314           columnname: location
315         -
316           columnname: notforloan
317         -
318           columnname: notes
320     saved-sql:
321       table_reports:
322         -
323           columnname: selection
324           cannot_be_toggled: 1
325           cannot_be_modified: 1
326         -
327           columnname: report_id
328           cannot_be_toggled: 1
329           cannot_be_modified: 1
330         -
331           columnname: report_name
332         -
333           columnname: type
334         -
335           columnname: group
336         -
337           columnname: subgroup
338         -
339           columnname: notes
340         -
341           columnname: author
342         -
343           columnname: creation_date
344         -
345           columnname: last_edit
346         -
347           columnname: last_run
348         -
349           columnname: public
350         -
351           columnname: json_url
352         -
353           columnname: cache_expiry
354         -
355           columnname: saved_results
356         -
357           columnname: update
358         -
359           columnname: actions
360           cannot_be_toggled: 1
361           cannot_be_modified: 1
363   circ:
364     circulation:
365       issues-table:
366         -
367           columnname: sort_order
368           cannot_be_toggled: 1
369           cannot_be_modified: 1
370           is_hidden: 1
371         -
372           columnname: todays_or_previous_checkouts
373           cannot_be_toggled: 1
374           cannot_be_modified: 1
375           is_hidden: 1
376         -
377           columnname: due_date_unformatted
378           cannot_be_toggled: 1
379           cannot_be_modified: 1
380           is_hidden: 1
381         -
382           columnname: due_date
383         -
384           columnname: title
385         -
386           columnname: item_type
387         -
388           columnname: location
389         -
390           columnname: homebranch
391         -
392           columnname: checkout_on
393         -
394           columnname: checkout_from
395         -
396           columnname: callno
397         -
398           columnname: charge
399         -
400           columnname: fine
401         -
402           columnname: price
403         -
404           columnname: renew
405           cannot_be_toggled: 1
406           cannot_be_modified: 1
407         -
408           columnname: checkin
409         -
410           columnname: export
411           cannot_be_toggled: 1
412           cannot_be_modified: 1
414     returns:
415       checkedintable:
416         -
417           columnname: due_date
418         -
419           columnname: title
420         -
421           columnname: author
422         -
423           columnname: barcode
424         -
425           columnname: homelibrary
426         -
427           columnname: holdinglibrary
428         -
429           columnname: location
430         -
431           columnname: itemcallnumber
432         -
433           columnname: dateaccessioned
434           is_hidden: 1
435         -
436           columnname: itype
437         -
438           columnname: borrower
439         -
440           columnname: itemnote
442     view_holdsqueue:
443       holds-table:
444         -
445           columnname: title
446         -
447           columnname: collection
448         -
449           columnname: document_type
450         -
451           columnname: callnumber
452         -
453           columnname: copynumber
454         -
455           columnname: enumeration
456         -
457           columnname: barcode
458         -
459           columnname: patron
460         -
461           columnname: send_to
462         -
463           columnname: date
464         -
465           columnname: notes
467     holds:
468       holds-to-pull:
469         -
470           columnname: pull_items
471         -
472           columnname: avalaible_items
473         -
474           columnname: patrons
475         -
476           columnname: patron
477         -
478           columnname: title
479         -
480           columnname: libraries
481         -
482           columnname: call_numbers
483         -
484           columnname: copy_numbers
485         -
486           columnname: enumeration
487         -
488           columnname: itemtypes
489         -
490           columnname: locations
491         -
492           columnname: hold_date
494   opac:
495     biblio-detail:
496       holdingst:
497         -
498           columnname: item_itemtype
499         -
500           columnname: item_current_location
501         -
502           columnname: item_home_location
503         -
504           columnname: item_shelving_location
505           is_hidden: 1
506         -
507           columnname: item_ccode
508         -
509           columnname: item_callnumber
510         -
511           columnname: item_enumchron
512         -
513           columnname: item_url
514         -
515           columnname: item_copy
516         -
517           columnname: item_status
518         -
519           columnname: item_notes
520         -
521           columnname: item_datedue
522         -
523           columnname: item_barcode
524           is_hidden: 1
525         -
526           columnname: item_holds
527         -
528           columnname: item_priority
529         -
530           columnname: item_coursereserves
532       subscriptionst:
533         -
534           columnname: serial_serialseq
535         -
536           columnname: serial_publisheddate
537         -
538           columnname: serial_planneddate
539         -
540           columnname: serial_status
541         -
542           columnname: serial_notes