Bug 21852: Add more columns and column configuration to overdues 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     categories:
128       patron_categories:
129         -
130           columnname: code
131         -
132           columnname: category_name
133         -
134           columnname: type
135         -
136           columnname: enrollment_period
137         -
138           columnname: age_required
139         -
140           columnname: upper_age_limit
141         -
142           columnname: enrollment_fee
143         -
144           columnname: overdue
145         -
146           columnname: lost_items
147         -
148           columnname: hold_fee
149         -
150           columnname: messaging
151         -
152           columnname: branches_limitations
153         -
154           columnname: default_privacy
155         -
156           columnname: actions
157           cannot_be_toggled: 1
158           cannot_be_modified: 1
159
160     libraries:
161       libraries:
162         -
163           columnname: library_name
164         -
165           columnname: library_code
166         -
167           columnname: library_address
168         -
169           columnname: marc_organization_code
170         -
171           columnname: library_ip
172         -
173           columnname: is_pickup_location
174         -
175           columnname: actions
176           cannot_be_toggled: 1
177           cannot_be_modified: 1
178
179
180   catalogue:
181     detail:
182       acquisitiondetails-table:
183         -
184           columnname: vendor
185         -
186           columnname: invoice
187         -
188           columnname: basketgroup
189         -
190           columnname: basket
191         -
192           columnname: ordernumber
193         -
194           columnname: creation_date
195         -
196           columnname: received_data
197         -
198           columnname: status
199         -
200           columnname: quantity
201         -
202           columnname: order_internalnote
203         -
204           columnname: subscription
205         -
206           columnname: subscription_callnumber
207
208       checkoutshistory-table:
209         -
210           columnname: patron
211           cannot_be_toggled: 1
212           cannot_be_modified: 1
213         -
214           columnname: barcode
215           cannot_be_toggled: 1
216           cannot_be_modified: 1
217         -
218           columnname: checked_out_from
219         -
220           columnname: renewed
221         -
222           columnname: checkout_on
223         -
224           columnname: due_date
225         -
226           columnname: checkin_on
227
228   cataloguing:
229     additem:
230       itemst:
231         # NOTE: These columns are in the same order as kohastructure.sql, and contain all items
232         # columns except for the following internal/obsolete fields: stack, more_subfields_xml,
233         # cn_sort, permanent_location, damaged_on itemlost_on, withdrawn_on, issues, renewals and
234         # reserves.
235         -
236           columnname: barcode
237         -
238           columnname: dateaccessioned
239         -
240           columnname: booksellerid
241         -
242           columnname: homebranch
243         -
244           columnname: price
245         -
246           columnname: replacementprice
247         -
248           columnname: replacementpricedate
249         -
250           columnname: datelastborrowed
251         -
252           columnname: datelastseen
253         -
254           columnname: stack
255         -
256           columnname: notforloan
257         -
258           columnname: damaged
259         -
260           columnname: itemlost
261         -
262           columnname: withdrawn
263         -
264           columnname: itemcallnumber
265         -
266           columnname: coded_location_qualifier
267         -
268           columnname: restricted
269         -
270           columnname: itemnotes
271         -
272           columnname: itemnotes_nonpublic
273         -
274           columnname: holdingbranch
275         -
276           columnname: timestamp
277         -
278           columnname: location
279         -
280           columnname: onloan
281         -
282           columnname: cn_source
283         -
284           columnname: ccode
285         -
286           columnname: materials
287         -
288           columnname: uri
289         -
290           columnname: itype
291         -
292           columnname: enumchron
293         -
294           columnname: copynumber
295         -
296           columnname: stocknumber
297
298     z3950_search:
299       resultst:
300         -
301           columnname: server
302         -
303           columnname: title
304         -
305           columnname: author
306         -
307           columnname: date
308         -
309           columnname: edition
310         -
311           columnname: isbn
312         -
313           columnname: lccn
314         -
315           columnname: actions
316           cannot_be_toggled: 1
317           cannot_be_modified: 1
318
319   coursereserves:
320     courses:
321       course_reserves_table:
322         -
323           columnname: name
324         -
325           columnname: department
326         -
327           columnname: course_no
328         -
329           columnname: section
330         -
331           columnname: term
332         -
333           columnname: instructors
334         -
335           columnname: staff_note
336         -
337           columnname: public_note
338         -
339           columnname: no_of_students
340         -
341           columnname: enabled
342
343     reserves:
344       course_reserves_table:
345         -
346           columnname: title
347         -
348          columnname: author
349         -
350           columnname: barcode
351         -
352           columnname: call_number
353         -
354           columnname: item_type
355         -
356           columnname: collection
357         -
358           columnname: location
359         -
360           columnname: library
361         -
362           columnname: staff_note
363         -
364           columnname: public_note
365         -
366           columnname: link
367         -
368           columnname: other_course_reserves
369         -
370           columnname: actions
371           cannot_be_toggled: 1
372           cannot_be_modified: 1
373
374   illrequests:
375     ill-requests:
376       ill-requests:
377         -
378           columnname: illrequest_id
379         -
380           columnname: metadata_author
381         -
382           columnname: metadata_title
383         -
384           columnname: metadata_article_title
385         -
386           columnname: metadata_issue
387         -
388           columnname: metadata_volume
389         -
390           columnname: metadata_year
391         -
392           columnname: metadata_pages
393         -
394           columnname: metadata_type
395         -
396           columnname: orderid
397         -
398           columnname: patron
399         -
400           columnname: biblio_id
401         -
402           columnname: library_branchname
403         -
404           columnname: status
405         -
406           columnname: placed
407           cannot_be_toggled: 1
408           cannot_be_modified: 1
409           is_hidden: 1
410         -
411           columnname: placed_formatted
412         -
413           columnname: updated
414           cannot_be_toggled: 1
415           cannot_be_modified: 1
416           is_hidden: 1
417         -
418           columnname: updated_formatted
419         -
420           columnname: replied
421         -
422           columnname: completed
423           cannot_be_toggled: 1
424           cannot_be_modified: 1
425           is_hidden: 1
426         -
427           columnname: completed_formatted
428         -
429           columnname: accessurl
430         -
431           columnname: cost
432         -
433           columnname: comments
434         -
435           columnname: notesopac
436         -
437           columnname: notesstaff
438         -
439           columnname: backend
440         -
441           columnname: action
442           cannot_be_toggled: 1
443           cannot_be_modified: 1
444
445   members:
446     fines:
447       account-fines:
448         -
449           columnname: date
450         -
451           columnname: description
452         -
453           columnname: barcode
454         -
455           columnname: date_due
456         -
457           columnname: returndate
458         -
459           columnname: note
460         -
461           columnname: amount
462           cannot_be_toggled: 1
463           cannot_be_modified: 1
464         -
465           columnname: amountoutstanding
466           cannot_be_toggled: 1
467           cannot_be_modified: 1
468         -
469           columnname: actions
470           cannot_be_toggled: 1
471           cannot_be_modified: 1
472
473     pay:
474       pay-fines-table:
475         -
476           columnname: checkbox
477           cannot_be_toggled: 1
478           cannot_be_modified: 1
479         -
480           columnname: actions
481           cannot_be_toggled: 1
482           cannot_be_modified: 1
483         -
484           columnname: description
485         -
486           columnname: date
487         -
488           columnname: barcode
489         -
490           columnname: date_due
491         -
492           columnname: returndate
493         -
494           columnname: note
495         -
496           columnname: account_type
497         -
498           columnname: amount
499         -
500           columnname: amountoutstanding
501
502     member:
503       memberresultst:
504         -
505           columnname: checkbox
506           cannot_be_toggled: 1
507           cannot_be_modified: 1
508         -
509           columnname: cardnumber
510         -
511           columnname: name
512         -
513           columnname: dateofbirth
514         -
515           columnname: category
516         -
517           columnname: library
518         -
519           columnname: expires_on
520         -
521           columnname: od_checkouts
522         -
523           columnname: fines
524         -
525           columnname: circ_notes
526         -
527           columnname: actions
528           cannot_be_toggled: 1
529           cannot_be_modified: 1
530
531     moremember:
532       issues-table:
533         -
534           columnname: sort_order
535           cannot_be_toggled: 1
536           cannot_be_modified: 1
537           is_hidden: 1
538         -
539           columnname: todays_or_previous_checkouts
540           cannot_be_toggled: 1
541           cannot_be_modified: 1
542           is_hidden: 1
543         -
544           columnname: due_date_unformatted
545           cannot_be_toggled: 1
546           cannot_be_modified: 1
547           is_hidden: 1
548         -
549           columnname: due_date
550         -
551           columnname: title
552         -
553           columnname: item_type
554         -
555           columnname: collection
556         -
557           columnname: location
558         -
559           columnname: homebranch
560         -
561           columnname: checkout_on_unformatted
562           cannot_be_toggled: 1
563           cannot_be_modified: 1
564           is_hidden: 1
565         -
566           columnname: checkout_on
567         -
568           columnname: checkout_from
569         -
570           columnname: callno
571         -
572           columnname: charge
573         -
574           columnname: fine
575         -
576           columnname: price
577         -
578           columnname: renew
579           cannot_be_toggled: 1
580           cannot_be_modified: 1
581         -
582           columnname: checkin
583         -
584           columnname: export
585           cannot_be_toggled: 1
586           cannot_be_modified: 1
587
588     holdshistory:
589       holdshistory-table:
590         -
591           columnname: title
592           cannot_be_toggled: 1
593           cannot_be_modified: 1
594         -
595           columnname: author
596         -
597           columnname: barcode
598         -
599           columnname: branch
600         -
601           columnname: reservedate
602         -
603           columnname: expirationdate
604         -
605           columnname: waitingdate
606         -
607           columnname: cancellationdate
608         -
609           columnname: itemtype
610         -
611           columnname: status
612
613     checkouthistory:
614       checkouthistory-table:
615         - columnname: type
616           cannot_be_toggled: 1
617           cannot_be_modified: 1
618         -
619           columnname: date
620         -
621           columnname: title
622         -
623           columnname: author
624         -
625           columnname: call_number
626         -
627           columnname: barcode
628         -
629           columnname: number_of_renewals
630         -
631           columnname: checked_out_on
632         -
633           columnname: checked_out_from
634         -
635           columnname: date_due
636         -
637           columnname: return_date
638
639     patron-lists:
640       patron-list-table:
641         -
642           columnname: checkbox
643           cannot_be_toggled: 1
644           cannot_be_modified: 1
645         -
646           columnname: card
647         -
648           columnname: firstname
649         -
650           columnname: surname
651         -
652           columnname: address
653         -
654           columnname: category
655         -
656           columnname: library
657         -
658           columnname: expires_on
659         -
660           columnname: circ_notes
661
662   reports:
663     lostitems:
664       lostitems-table:
665         -
666           columnname: title
667           cannot_be_toggled: 1
668           cannot_be_modified: 1
669         -
670           columnname: author
671         -
672           columnname: lostcode
673         -
674           columnname: itemlost_on
675         -
676           columnname: barcode
677         -
678           columnname: callnumber
679         -
680           columnname: datelastseen
681         -
682           columnname: price
683         -
684           columnname: replacementprice
685         -
686           columnname: library
687         -
688           columnname: itemtype
689         -
690           columnname: collection_code
691         -
692           columnname: current_location
693         -
694           columnname: location
695         -
696           columnname: notforloan
697         -
698           columnname: notes
699
700     saved-sql:
701       table_reports:
702         -
703           columnname: selection
704           cannot_be_toggled: 1
705           cannot_be_modified: 1
706         -
707           columnname: report_id
708           cannot_be_toggled: 1
709           cannot_be_modified: 1
710         -
711           columnname: report_name
712         -
713           columnname: type
714         -
715           columnname: group
716         -
717           columnname: subgroup
718         -
719           columnname: notes
720         -
721           columnname: author
722         -
723           columnname: creation_date
724         -
725           columnname: last_edit
726         -
727           columnname: last_run
728         -
729           columnname: public
730         -
731           columnname: json_url
732         -
733           columnname: cache_expiry
734         -
735           columnname: saved_results
736         -
737           columnname: update
738         -
739           columnname: actions
740           cannot_be_toggled: 1
741           cannot_be_modified: 1
742
743   circ:
744     circulation:
745       issues-table:
746         -
747           columnname: sort_order
748           cannot_be_toggled: 1
749           cannot_be_modified: 1
750           is_hidden: 1
751         -
752           columnname: todays_or_previous_checkouts
753           cannot_be_toggled: 1
754           cannot_be_modified: 1
755           is_hidden: 1
756         -
757           columnname: due_date_unformatted
758           cannot_be_toggled: 1
759           cannot_be_modified: 1
760           is_hidden: 1
761         -
762           columnname: due_date
763         -
764           columnname: title
765         -
766           columnname: item_type
767         -
768           columnname: collection
769         -
770           columnname: location
771         -
772           columnname: homebranch
773         -
774           columnname: checkout_on_unformatted
775           cannot_be_toggled: 1
776           cannot_be_modified: 1
777           is_hidden: 1
778         -
779           columnname: checkout_on
780         -
781           columnname: checkout_from
782         -
783           columnname: callno
784         -
785           columnname: charge
786         -
787           columnname: fine
788         -
789           columnname: price
790         -
791           columnname: renew
792           cannot_be_toggled: 1
793           cannot_be_modified: 1
794         -
795           columnname: checkin
796         -
797           columnname: export
798           cannot_be_toggled: 1
799           cannot_be_modified: 1
800       table_borrowers:
801         -
802           columnname: name
803           cannot_be_toggled: 1
804           cannot_be_modified: 1
805         -
806           columnname: cardnumber
807         -
808           columnname: date_of_birth
809         -
810           columnname: category
811         -
812           columnname: library
813         -
814           columnname: address
815         -
816           columnname: phone
817           is_hidden: 1
818     returns:
819       checkedintable:
820         -
821           columnname: due_date
822         -
823           columnname: title
824         -
825           columnname: author
826         -
827           columnname: barcode
828         -
829           columnname: homelibrary
830         -
831           columnname: holdinglibrary
832         -
833           columnname: location
834         -
835           columnname: itemcallnumber
836         -
837           columnname: dateaccessioned
838           is_hidden: 1
839         -
840           columnname: itype
841         -
842           columnname: borrower
843         -
844           columnname: itemnote
845
846     view_holdsqueue:
847       holds-table:
848         -
849           columnname: title
850         -
851           columnname: collection
852         -
853           columnname: document_type
854         -
855           columnname: callnumber
856         -
857           columnname: copynumber
858         -
859           columnname: enumeration
860         -
861           columnname: barcode
862         -
863           columnname: patron
864         -
865           columnname: send_to
866         -
867           columnname: date
868         -
869           columnname: notes
870
871     holds:
872       holds-to-pull:
873         -
874           columnname: pull_items
875         -
876           columnname: avalaible_items
877         -
878           columnname: patrons
879         -
880           columnname: patron
881         -
882           columnname: title
883         -
884           columnname: libraries
885         -
886           columnname: call_numbers
887         -
888           columnname: copy_numbers
889         -
890           columnname: enumeration
891         -
892           columnname: itemtypes
893         -
894           columnname: locations
895         -
896           columnname: hold_date
897         -
898           columnname: action
899
900     holdsratios:
901       holds-ratios:
902         -
903           columnname: holds
904         -
905           columnname: items
906         -
907           columnname: holds_ratio
908         -
909           columnname: title
910         -
911           columnname: home_libraries
912         -
913           columnname: holding_libraries
914         -
915           columnname: location
916         -
917           columnname: itemtype
918         -
919           columnname: call_numbers
920         -
921           columnname: items_needed
922
923     overdues:
924       circ-overdues:
925         -
926           columnname: due_date
927         -
928           columnname: patron
929         -
930           columnname: patron_category
931           is_hidden: 1
932         -
933           columnname: patron_library
934         -
935           columnname: title
936         -
937           columnname: home_library
938           is_hidden: 1
939         -
940           columnname: holding_library
941           is_hidden: 1
942         -
943           columnname: barcode
944         -
945           columnname: call_number
946         -
947           columnname: item_type
948           is_hidden: 1
949         -
950           columnname: price
951         -
952           columnname: non-public_note
953
954   opac:
955     biblio-detail:
956       holdingst:
957         -
958           columnname: item_itemtype
959         -
960           columnname: item_current_location
961         -
962           columnname: item_home_location
963         -
964           columnname: item_shelving_location
965           is_hidden: 1
966         -
967           columnname: item_ccode
968         -
969           columnname: item_callnumber
970         -
971           columnname: item_enumchron
972         -
973           columnname: item_url
974         -
975           columnname: item_copy
976         -
977           columnname: item_status
978         -
979           columnname: item_notes
980         -
981           columnname: item_datedue
982         -
983           columnname: item_barcode
984           is_hidden: 1
985         -
986           columnname: item_holds
987         -
988           columnname: item_priority
989         -
990           columnname: item_coursereserves
991
992       subscriptionst:
993         -
994           columnname: serial_serialseq
995         -
996           columnname: serial_publisheddate
997         -
998           columnname: serial_planneddate
999         -
1000           columnname: serial_status
1001         -
1002           columnname: serial_notes
1003
1004   serials:
1005     subscription-detail:
1006       orders:
1007         -
1008           columnname: invoice
1009         -
1010           columnname: basket
1011         -
1012           columnname: ordernumber
1013         -
1014           columnname: creation_date
1015         -
1016           columnname: receive_date
1017         -
1018           columnname: status
1019         -
1020           columnname: order_internalnote
1021         -
1022           columnname: order_vendornote
1023         -
1024           columnname: fund
1025         -
1026           columnname: ordered
1027         -
1028           columnname: spent
1029
1030   tools:
1031     notices:
1032       lettert:
1033         -
1034           columnname: library
1035         -
1036           columnname: module
1037         -
1038           columnname: code
1039         -
1040           columnname: name
1041         -
1042           columnname: copy_notice
1043         -
1044           columnname: actions
1045           cannot_be_toggled: 1
1046           cannot_be_modified: 1
1047
1048     stockrotation:
1049       stock_rotation:
1050         -
1051           columnname: name
1052         -
1053           columnname: cyclical
1054         -
1055           columnname: active
1056         -
1057           columnname: description
1058         -
1059           columnname: number_of_items
1060         -
1061           columnname: actions
1062           cannot_be_toggled: 1
1063           cannot_be_modified: 1
1064
1065       stock_rotation_manage_items:
1066         -
1067           columnname: barcode
1068         -
1069           columnname: title
1070         -
1071           columnname: author
1072         -
1073           columnname: call_number
1074         -
1075           columnname: in_transit
1076         -
1077           columnname: stages
1078         -
1079           columnname: actions
1080           cannot_be_toggled: 1
1081           cannot_be_modified: 1