Bug 21785: Add columns configuration to hold ratios report
[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_unformatted
382           cannot_be_toggled: 1
383           cannot_be_modified: 1
384           is_hidden: 1
385         -
386           columnname: checkout_on
387         -
388           columnname: checkout_from
389         -
390           columnname: callno
391         -
392           columnname: charge
393         -
394           columnname: fine
395         -
396           columnname: price
397         -
398           columnname: renew
399           cannot_be_toggled: 1
400           cannot_be_modified: 1
401         -
402           columnname: checkin
403         -
404           columnname: export
405           cannot_be_toggled: 1
406           cannot_be_modified: 1
407
408     holdshistory:
409       holdshistory-table:
410         -
411           columnname: title
412           cannot_be_toggled: 1
413           cannot_be_modified: 1
414         -
415           columnname: author
416         -
417           columnname: barcode
418         -
419           columnname: branch
420         -
421           columnname: reservedate
422         -
423           columnname: expirationdate
424         -
425           columnname: waitingdate
426         -
427           columnname: cancellationdate
428         -
429           columnname: itemtype
430         -
431           columnname: status
432
433   reports:
434     lostitems:
435       lostitems-table:
436         -
437           columnname: title
438           cannot_be_toggled: 1
439           cannot_be_modified: 1
440         -
441           columnname: author
442         -
443           columnname: lostcode
444         -
445           columnname: itemlost_on
446         -
447           columnname: barcode
448         -
449           columnname: callnumber
450         -
451           columnname: datelastseen
452         -
453           columnname: price
454         -
455           columnname: replacementprice
456         -
457           columnname: library
458         -
459           columnname: itemtype
460         -
461           columnname: current_location
462         -
463           columnname: location
464         -
465           columnname: notforloan
466         -
467           columnname: notes
468
469     saved-sql:
470       table_reports:
471         -
472           columnname: selection
473           cannot_be_toggled: 1
474           cannot_be_modified: 1
475         -
476           columnname: report_id
477           cannot_be_toggled: 1
478           cannot_be_modified: 1
479         -
480           columnname: report_name
481         -
482           columnname: type
483         -
484           columnname: group
485         -
486           columnname: subgroup
487         -
488           columnname: notes
489         -
490           columnname: author
491         -
492           columnname: creation_date
493         -
494           columnname: last_edit
495         -
496           columnname: last_run
497         -
498           columnname: public
499         -
500           columnname: json_url
501         -
502           columnname: cache_expiry
503         -
504           columnname: saved_results
505         -
506           columnname: update
507         -
508           columnname: actions
509           cannot_be_toggled: 1
510           cannot_be_modified: 1
511
512   circ:
513     circulation:
514       issues-table:
515         -
516           columnname: sort_order
517           cannot_be_toggled: 1
518           cannot_be_modified: 1
519           is_hidden: 1
520         -
521           columnname: todays_or_previous_checkouts
522           cannot_be_toggled: 1
523           cannot_be_modified: 1
524           is_hidden: 1
525         -
526           columnname: due_date_unformatted
527           cannot_be_toggled: 1
528           cannot_be_modified: 1
529           is_hidden: 1
530         -
531           columnname: due_date
532         -
533           columnname: title
534         -
535           columnname: item_type
536         -
537           columnname: collection
538         -
539           columnname: location
540         -
541           columnname: homebranch
542         -
543           columnname: checkout_on_unformatted
544           cannot_be_toggled: 1
545           cannot_be_modified: 1
546           is_hidden: 1
547         -
548           columnname: checkout_on
549         -
550           columnname: checkout_from
551         -
552           columnname: callno
553         -
554           columnname: charge
555         -
556           columnname: fine
557         -
558           columnname: price
559         -
560           columnname: renew
561           cannot_be_toggled: 1
562           cannot_be_modified: 1
563         -
564           columnname: checkin
565         -
566           columnname: export
567           cannot_be_toggled: 1
568           cannot_be_modified: 1
569
570     returns:
571       checkedintable:
572         -
573           columnname: due_date
574         -
575           columnname: title
576         -
577           columnname: author
578         -
579           columnname: barcode
580         -
581           columnname: homelibrary
582         -
583           columnname: holdinglibrary
584         -
585           columnname: location
586         -
587           columnname: itemcallnumber
588         -
589           columnname: dateaccessioned
590           is_hidden: 1
591         -
592           columnname: itype
593         -
594           columnname: borrower
595         -
596           columnname: itemnote
597
598     view_holdsqueue:
599       holds-table:
600         -
601           columnname: title
602         -
603           columnname: collection
604         -
605           columnname: document_type
606         -
607           columnname: callnumber
608         -
609           columnname: copynumber
610         -
611           columnname: enumeration
612         -
613           columnname: barcode
614         -
615           columnname: patron
616         -
617           columnname: send_to
618         -
619           columnname: date
620         -
621           columnname: notes
622
623     holds:
624       holds-to-pull:
625         -
626           columnname: pull_items
627         -
628           columnname: avalaible_items
629         -
630           columnname: patrons
631         -
632           columnname: patron
633         -
634           columnname: title
635         -
636           columnname: libraries
637         -
638           columnname: call_numbers
639         -
640           columnname: copy_numbers
641         -
642           columnname: enumeration
643         -
644           columnname: itemtypes
645         -
646           columnname: locations
647         -
648           columnname: hold_date
649         -
650           columnname: action
651
652     holdsratios:
653       holds-ratios:
654         -
655           columnname: holds
656         -
657           columnname: items
658         -
659           columnname: holds_ratio
660         -
661           columnname: title
662         -
663           columnname: home_libraries
664         -
665           columnname: holding_libraries
666         -
667           columnname: location
668         -
669           columnname: itemtype
670         -
671           columnname: call_numbers
672         -
673           columnname: items_needed
674
675   opac:
676     biblio-detail:
677       holdingst:
678         -
679           columnname: item_itemtype
680         -
681           columnname: item_current_location
682         -
683           columnname: item_home_location
684         -
685           columnname: item_shelving_location
686           is_hidden: 1
687         -
688           columnname: item_ccode
689         -
690           columnname: item_callnumber
691         -
692           columnname: item_enumchron
693         -
694           columnname: item_url
695         -
696           columnname: item_copy
697         -
698           columnname: item_status
699         -
700           columnname: item_notes
701         -
702           columnname: item_datedue
703         -
704           columnname: item_barcode
705           is_hidden: 1
706         -
707           columnname: item_holds
708         -
709           columnname: item_priority
710         -
711           columnname: item_coursereserves
712
713       subscriptionst:
714         -
715           columnname: serial_serialseq
716         -
717           columnname: serial_publisheddate
718         -
719           columnname: serial_planneddate
720         -
721           columnname: serial_status
722         -
723           columnname: serial_notes
724
725   serials:
726     subscription-detail:
727       orders:
728         -
729           columnname: invoice
730         -
731           columnname: basket
732         -
733           columnname: ordernumber
734         -
735           columnname: creation_date
736         -
737           columnname: receive_date
738         -
739           columnname: status
740         -
741           columnname: order_internalnote
742         -
743           columnname: order_vendornote
744         -
745           columnname: fund
746         -
747           columnname: ordered
748         -
749           columnname: spent
750
751   tools:
752     notices:
753       lettert:
754         -
755           columnname: library
756         -
757           columnname: module
758         -
759           columnname: code
760         -
761           columnname: name
762         -
763           columnname: copy_notice
764         -
765           columnname: actions
766           cannot_be_toggled: 1
767           cannot_be_modified: 1