Bug 20966: (follow-up) Add template variable filter; Fix table export
[koha.git] / admin / columns_settings.yml
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
33
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
62     basket:
63       orders:
64         -
65           columnname: basket_number
66         -
67           columnname: order_information
68         -
69           columnname: recommended_retail_price_tax_excluded
70         -
71           columnname: ecost_tax_excluded
72         -
73           columnname: recommended_retail_price_tax_included
74           is_hidden: 1
75         -
76           columnname: ecost_tax_included
77           is_hidden: 1
78         -
79           columnname: replacement_price
80         -
81           columnname: quantity
82         -
83           columnname: total_tax_excluded
84         -
85           columnname: total_tax_included
86           is_hidden: 1
87         -
88           columnname: goods_and_services_tax_percentage
89         -
90           columnname: goods_and_services_tax
91         -
92           columnname: fund
93         -
94           columnname: supplier_report
95         -
96           columnname: modify
97           cannot_be_toggled: 1
98           cannot_be_modified: 1
99         -
100           columnname: cancel
101           cannot_be_toggled: 1
102           cannot_be_modified: 1
103
104   admin:
105     currency:
106       currencies-table:
107         -
108           columnname: currency
109           cannot_be_toggled: 1
110           cannot_be_modified: 1
111         -
112           columnname: rate
113           cannot_be_toggled: 1
114           cannot_be_modified: 1
115         -
116           columnname: symbol
117         -
118           columnname: iso_code
119           is_hidden: 1
120         -
121           columnname: last_updated
122         -
123           columnname: active
124         -
125           columnname: actions
126
127   catalogue:
128     detail:
129       acquisitiondetails-table:
130         -
131           columnname: vendor
132         -
133           columnname: invoice
134         -
135           columnname: basketgroup
136         -
137           columnname: basket
138         -
139           columnname: ordernumber
140         -
141           columnname: creation_date
142         -
143           columnname: received_data
144         -
145           columnname: status
146         -
147           columnname: quantity
148         -
149           columnname: subscription
150         -
151           columnname: subscription_callnumber
152
153       checkoutshistory-table:
154         -
155           columnname: patron
156           cannot_be_toggled: 1
157           cannot_be_modified: 1
158         -
159           columnname: barcode
160           cannot_be_toggled: 1
161           cannot_be_modified: 1
162         -
163           columnname: checked_out_from
164         -
165           columnname: renewed
166         -
167           columnname: checkout_on
168         -
169           columnname: due_date
170         -
171           columnname: checkin_on
172
173   cataloguing:
174     additem:
175       itemst:
176         # NOTE: These columns are in the same order as kohastructure.sql, and contain all items
177         # columns except for the following internal/obsolete fields: stack, more_subfields_xml,
178         # cn_sort, permanent_location, damaged_on itemlost_on, withdrawn_on, issues, renewals and
179         # reserves.
180         -
181           columnname: barcode
182         -
183           columnname: dateaccessioned
184         -
185           columnname: booksellerid
186         -
187           columnname: homebranch
188         -
189           columnname: price
190         -
191           columnname: replacementprice
192         -
193           columnname: replacementpricedate
194         -
195           columnname: datelastborrowed
196         -
197           columnname: datelastseen
198         -
199           columnname: stack
200         -
201           columnname: notforloan
202         -
203           columnname: damaged
204         -
205           columnname: itemlost
206         -
207           columnname: withdrawn
208         -
209           columnname: itemcallnumber
210         -
211           columnname: coded_location_qualifier
212         -
213           columnname: restricted
214         -
215           columnname: itemnotes
216         -
217           columnname: itemnotes_nonpublic
218         -
219           columnname: holdingbranch
220         -
221           columnname: paidfor
222         -
223           columnname: timestamp
224         -
225           columnname: location
226         -
227           columnname: onloan
228         -
229           columnname: cn_source
230         -
231           columnname: ccode
232         -
233           columnname: materials
234         -
235           columnname: uri
236         -
237           columnname: itype
238         -
239           columnname: enumchron
240         -
241           columnname: copynumber
242         -
243           columnname: stocknumber
244
245   coursereserves:
246     courses:
247       course_reserves_table:
248         -
249           columnname: name
250         -
251           columnname: department
252         -
253           columnname: course_no
254         -
255           columnname: section
256         -
257           columnname: term
258         -
259           columnname: instructors
260         -
261           columnname: staff_note
262         -
263           columnname: public_note
264         -
265           columnname: no_of_students
266         -
267           columnname: enabled
268
269     reserves:
270       course_reserves_table:
271         -
272           columnname: title
273         -
274          columnname: author
275         -
276           columnname: barcode
277         -
278           columnname: call_number
279         -
280           columnname: item_type
281         -
282           columnname: collection
283         -
284           columnname: location
285         -
286           columnname: library
287         -
288           columnname: staff_note
289         -
290           columnname: public_note
291         -
292           columnname: link
293         -
294           columnname: other_course_reserves
295         -
296           columnname: actions
297           cannot_be_toggled: 1
298           cannot_be_modified: 1
299
300   members:
301     fines:
302       account-fines:
303         -
304           columnname: date
305         -
306           columnname: description
307         -
308           columnname: note
309         -
310           columnname: amount
311           cannot_be_toggled: 1
312           cannot_be_modified: 1
313         -
314           columnname: amountoutstanding
315           cannot_be_toggled: 1
316           cannot_be_modified: 1
317         -
318           columnname: actions
319           cannot_be_toggled: 1
320           cannot_be_modified: 1
321
322     member:
323       memberresultst:
324         -
325           columnname: checkbox
326           cannot_be_toggled: 1
327           cannot_be_modified: 1
328         -
329           columnname: cardnumber
330         -
331           columnname: name
332         -
333           columnname: dateofbirth
334         -
335           columnname: category
336         -
337           columnname: library
338         -
339           columnname: expires_on
340         -
341           columnname: od_checkouts
342         -
343           columnname: fines
344         -
345           columnname: circ_notes
346         -
347           columnname: actions
348           cannot_be_toggled: 1
349           cannot_be_modified: 1
350
351     moremember:
352       issues-table:
353         -
354           columnname: sort_order
355           cannot_be_toggled: 1
356           cannot_be_modified: 1
357           is_hidden: 1
358         -
359           columnname: todays_or_previous_checkouts
360           cannot_be_toggled: 1
361           cannot_be_modified: 1
362           is_hidden: 1
363         -
364           columnname: due_date_unformatted
365           cannot_be_toggled: 1
366           cannot_be_modified: 1
367           is_hidden: 1
368         -
369           columnname: due_date
370         -
371           columnname: title
372         -
373           columnname: item_type
374         -
375           columnname: collection
376         -
377           columnname: location
378         -
379           columnname: homebranch
380         -
381           columnname: checkout_on
382         -
383           columnname: checkout_from
384         -
385           columnname: callno
386         -
387           columnname: charge
388         -
389           columnname: fine
390         -
391           columnname: price
392         -
393           columnname: renew
394           cannot_be_toggled: 1
395           cannot_be_modified: 1
396         -
397           columnname: checkin
398         -
399           columnname: export
400           cannot_be_toggled: 1
401           cannot_be_modified: 1
402
403     holdshistory:
404       holdshistory-table:
405         -
406           columnname: title
407           cannot_be_toggled: 1
408           cannot_be_modified: 1
409         -
410           columnname: author
411         -
412           columnname: barcode
413         -
414           columnname: branch
415         -
416           columnname: reservedate
417         -
418           columnname: expirationdate
419         -
420           columnname: waitingdate
421         -
422           columnname: cancellationdate
423         -
424           columnname: itemtype
425         -
426           columnname: status
427
428   reports:
429     lostitems:
430       lostitems-table:
431         -
432           columnname: title
433           cannot_be_toggled: 1
434           cannot_be_modified: 1
435         -
436           columnname: author
437         -
438           columnname: lostcode
439         -
440           columnname: itemlost_on
441         -
442           columnname: barcode
443         -
444           columnname: callnumber
445         -
446           columnname: datelastseen
447         -
448           columnname: price
449         -
450           columnname: replacementprice
451         -
452           columnname: library
453         -
454           columnname: itemtype
455         -
456           columnname: current_location
457         -
458           columnname: location
459         -
460           columnname: notforloan
461         -
462           columnname: notes
463
464     saved-sql:
465       table_reports:
466         -
467           columnname: selection
468           cannot_be_toggled: 1
469           cannot_be_modified: 1
470         -
471           columnname: report_id
472           cannot_be_toggled: 1
473           cannot_be_modified: 1
474         -
475           columnname: report_name
476         -
477           columnname: type
478         -
479           columnname: group
480         -
481           columnname: subgroup
482         -
483           columnname: notes
484         -
485           columnname: author
486         -
487           columnname: creation_date
488         -
489           columnname: last_edit
490         -
491           columnname: last_run
492         -
493           columnname: public
494         -
495           columnname: json_url
496         -
497           columnname: cache_expiry
498         -
499           columnname: saved_results
500         -
501           columnname: update
502         -
503           columnname: actions
504           cannot_be_toggled: 1
505           cannot_be_modified: 1
506
507   circ:
508     circulation:
509       issues-table:
510         -
511           columnname: sort_order
512           cannot_be_toggled: 1
513           cannot_be_modified: 1
514           is_hidden: 1
515         -
516           columnname: todays_or_previous_checkouts
517           cannot_be_toggled: 1
518           cannot_be_modified: 1
519           is_hidden: 1
520         -
521           columnname: due_date_unformatted
522           cannot_be_toggled: 1
523           cannot_be_modified: 1
524           is_hidden: 1
525         -
526           columnname: due_date
527         -
528           columnname: title
529         -
530           columnname: item_type
531         -
532           columnname: collection
533         -
534           columnname: location
535         -
536           columnname: homebranch
537         -
538           columnname: checkout_on
539         -
540           columnname: checkout_from
541         -
542           columnname: callno
543         -
544           columnname: charge
545         -
546           columnname: fine
547         -
548           columnname: price
549         -
550           columnname: renew
551           cannot_be_toggled: 1
552           cannot_be_modified: 1
553         -
554           columnname: checkin
555         -
556           columnname: export
557           cannot_be_toggled: 1
558           cannot_be_modified: 1
559
560     returns:
561       checkedintable:
562         -
563           columnname: due_date
564         -
565           columnname: title
566         -
567           columnname: author
568         -
569           columnname: barcode
570         -
571           columnname: homelibrary
572         -
573           columnname: holdinglibrary
574         -
575           columnname: location
576         -
577           columnname: itemcallnumber
578         -
579           columnname: dateaccessioned
580           is_hidden: 1
581         -
582           columnname: itype
583         -
584           columnname: borrower
585         -
586           columnname: itemnote
587
588     view_holdsqueue:
589       holds-table:
590         -
591           columnname: title
592         -
593           columnname: collection
594         -
595           columnname: document_type
596         -
597           columnname: callnumber
598         -
599           columnname: copynumber
600         -
601           columnname: enumeration
602         -
603           columnname: barcode
604         -
605           columnname: patron
606         -
607           columnname: send_to
608         -
609           columnname: date
610         -
611           columnname: notes
612
613     holds:
614       holds-to-pull:
615         -
616           columnname: pull_items
617         -
618           columnname: avalaible_items
619         -
620           columnname: patrons
621         -
622           columnname: patron
623         -
624           columnname: title
625         -
626           columnname: libraries
627         -
628           columnname: call_numbers
629         -
630           columnname: copy_numbers
631         -
632           columnname: enumeration
633         -
634           columnname: itemtypes
635         -
636           columnname: locations
637         -
638           columnname: hold_date
639         -
640           columnname: action
641
642   opac:
643     biblio-detail:
644       holdingst:
645         -
646           columnname: item_itemtype
647         -
648           columnname: item_current_location
649         -
650           columnname: item_home_location
651         -
652           columnname: item_shelving_location
653           is_hidden: 1
654         -
655           columnname: item_ccode
656         -
657           columnname: item_callnumber
658         -
659           columnname: item_enumchron
660         -
661           columnname: item_url
662         -
663           columnname: item_copy
664         -
665           columnname: item_status
666         -
667           columnname: item_notes
668         -
669           columnname: item_datedue
670         -
671           columnname: item_barcode
672           is_hidden: 1
673         -
674           columnname: item_holds
675         -
676           columnname: item_priority
677         -
678           columnname: item_coursereserves
679
680       subscriptionst:
681         -
682           columnname: serial_serialseq
683         -
684           columnname: serial_publisheddate
685         -
686           columnname: serial_planneddate
687         -
688           columnname: serial_status
689         -
690           columnname: serial_notes
691
692   serials:
693     subscription-detail:
694       orders:
695         -
696           columnname: invoice
697         -
698           columnname: basket
699         -
700           columnname: ordernumber
701         -
702           columnname: creation_date
703         -
704           columnname: receive_date
705         -
706           columnname: status
707         -
708           columnname: order_internalnote
709         -
710           columnname: order_vendornote
711         -
712           columnname: fund
713         -
714           columnname: ordered
715         -
716           columnname: spent
717
718   tools:
719     notices:
720       lettert:
721         -
722           columnname: library
723         -
724           columnname: module
725         -
726           columnname: code
727         -
728           columnname: name
729         -
730           columnname: copy_notice
731         -
732           columnname: actions
733           cannot_be_toggled: 1
734           cannot_be_modified: 1