Bug 33137: Make column names match
[koha-ffzg.git] / admin / columns_settings.yml
1 modules:
2   acqui:
3     acq_acqui-home:
4       accounts:
5         columns:
6             -
7               columnname: active
8               cannot_be_toggled: 1
9               cannot_be_modified: 1
10             -
11               columnname: budget_period_descriptions
12               cannot_be_toggled: 1
13               cannot_be_modified: 1
14             -
15               columnname: fund_code
16             -
17               columnname: fund_name
18             -
19               columnname: owner
20             -
21               columnname: library
22             -
23               columnname: amount
24             -
25               columnname: ordered
26             -
27               columnname: spent
28             -
29               columnname: total_available
30
31     histsearch:
32       histsearcht:
33         default_display_length: 20
34         default_sort_order: 0
35         columns:
36             -
37               columnname: order_line
38             -
39               columnname: status
40             -
41               columnname: basket
42             -
43               columnname: basket_creator
44             -
45               columnname: basket_group
46             -
47               columnname: managing_library
48             -
49               columnname: invoice_number
50             -
51               columnname: summary
52             -
53               columnname: vendor
54             -
55               columnname: placed_on
56             -
57               columnname: received_on
58             -
59               columnname: quantity_received
60             -
61               columnname: pending_order
62             -
63               columnname: unit_cost
64             -
65               columnname: fund
66             -
67               columnname: internalnote
68             -
69               columnname: vendornote
70
71     lateorders:
72       late_orders:
73         default_display_length: 20
74         default_sort_order: 0
75         columns:
76             -
77               columnname: checkbox
78               cannot_be_toggled: 1
79               cannot_be_modified: 1
80             -
81               columnname: order_line
82             -
83               columnname: order_date
84             -
85               columnname: estimated_delivery_date
86             -
87               columnname: vendor
88             -
89               columnname: information
90             -
91               columnname: quantity
92             -
93               columnname: total_cost
94             -
95               columnname: basket
96             -
97               columnname: basket_group
98             -
99               columnname: library
100             -
101               columnname: budget
102             -
103               columnname: fund
104             -
105               columnname: claims_count
106             -
107               columnname: claimed_date
108             -
109               columnname: internal_note
110             -
111               columnname: vendor_note
112             -
113               columnname: isbn
114
115     basket:
116       orders:
117         default_display_length: 20
118         default_sort_order: 0
119         columns:
120             -
121               columnname: basket_number
122             -
123               columnname: order_information
124             -
125               columnname: recommended_retail_price_tax_excluded
126             -
127               columnname: actual_cost_tax_excluded
128             -
129               columnname: budgeted_cost_price_tax_included
130             -
131               columnname: recommended_retail_price_tax_included
132               is_hidden: 1
133             -
134               columnname: actual_cost_tax_included
135               is_hidden: 1
136             -
137               columnname: budgeted_cost_tax_included
138             -
139               columnname: replacement_price
140             -
141               columnname: quantity
142             -
143               columnname: total_tax_excluded
144             -
145               columnname: total_tax_included
146               is_hidden: 1
147             -
148               columnname: goods_and_services_tax_percentage
149             -
150               columnname: goods_and_services_tax
151             -
152               columnname: fund
153             -
154               columnname: estimated_delivery_date
155             -
156               columnname: supplier_report
157             -
158               columnname: modify
159               cannot_be_toggled: 1
160               cannot_be_modified: 1
161             -
162               columnname: cancel
163               cannot_be_toggled: 1
164               cannot_be_modified: 1
165
166     suggestions:
167       suggestions:
168         columns:
169             -
170               columnname: selections
171               cannot_be_toggled: 1
172               cannot_be_modified: 1
173             -
174               columnname: suggestion
175             -
176               columnname: suggested_by
177             -
178               columnname: suggested_category
179             -
180               columnname: suggested_on
181             -
182               columnname: patron_reason
183             -
184               columnname: managed_by
185             -
186               columnname: managed_on
187             -
188               columnname: lastmodificationby
189             -
190               columnname: lastmodificationdate
191             -
192               columnname: last_updated_date
193             -
194               columnname: library
195             -
196               columnname: library_fund
197             -
198               columnname: staff_note
199             -
200               columnname: suggestion_status
201             -
202               columnname: actions
203               cannot_be_toggled: 1
204               cannot_be_modified: 1
205   admin:
206     cities:
207       table_cities:
208         default_display_length: 20
209         default_sort_order: 0
210         columns:
211             -
212               columnname: city_id
213             -
214               columnname: city_name
215             -
216               columnname: city_state
217             -
218               columnname: city_zipcode
219             -
220               columnname: city_country
221             -
222               columnname: actions
223               cannot_be_toggled: 1
224               cannot_be_modified: 1
225     currency:
226       currencies-table:
227         columns:
228             -
229               columnname: currency
230               cannot_be_toggled: 1
231               cannot_be_modified: 1
232             -
233               columnname: rate
234               cannot_be_toggled: 1
235               cannot_be_modified: 1
236             -
237               columnname: symbol
238             -
239               columnname: iso_code
240               is_hidden: 1
241             -
242               columnname: last_updated
243             -
244               columnname: active
245             -
246               columnname: actions
247
248     categories:
249       patron_categories:
250         default_display_length: 20
251         default_sort_order: 1
252         columns:
253             -
254               columnname: code
255             -
256               columnname: category_name
257             -
258               columnname: type
259             -
260               columnname: enrollment_period
261             -
262               columnname: password_expiration
263             -
264               columnname: age_required
265             -
266               columnname: upper_age_limit
267             -
268               columnname: enrollment_fee
269             -
270               columnname: overdue
271             -
272               columnname: lost_items
273             -
274               columnname: hold_fee
275             -
276               columnname: messaging
277             -
278               columnname: branches_limitations
279             -
280               columnname: can_be_guarantee
281             -
282               columnname: default_privacy
283             -
284               columnname: exclude_from_local_holds_priority
285             -
286               columnname: actions
287               cannot_be_toggled: 1
288               cannot_be_modified: 1
289
290     itemtypes:
291       table_item_type:
292         default_display_length: 10
293         default_sort_order: 1
294         columns:
295             -
296               columnname: image
297             -
298               columnname: description
299             -
300               columnname: code
301             -
302               columnname: parent_code
303             -
304               columnname: search_category
305             -
306               columnname: not_for_loan
307             -
308               columnname: hide_in_opac
309             -
310               columnname: rental_charge
311             -
312               columnname: daily_rental_charge
313             -
314               columnname: hourly_rental_charge
315             -
316               columnname: default_replacement_cost
317             -
318               columnname: lost_processing_fee
319             -
320               columnname: checkin_message
321             -
322               columnname: library_limitations
323             -
324               columnname: automatic_checkin
325               is_hidden: 1
326             -
327               columnname: actions
328               cannot_be_toggled: 1
329               cannot_be_modified: 1
330
331     libraries:
332       libraries:
333         default_display_length: 20
334         default_sort_order: 0
335         columns:
336             -
337               columnname: library_name
338             -
339               columnname: library_code
340             -
341               columnname: library_address
342             -
343               columnname: marc_organization_code
344             -
345               columnname: library_ip
346             -
347               columnname: is_pickup_location
348             -
349               columnname: public
350             -
351               columnname: smtp_server
352             -
353               columnname: actions
354               cannot_be_toggled: 1
355               cannot_be_modified: 1
356
357   catalogue:
358     detail:
359       holdings_table:
360         columns:
361             -
362               columnname: holdings_checkbox
363               cannot_be_toggled: 1
364               cannot_be_modified: 1
365             -
366               columnname: holdings_cover_image
367             -
368               columnname: holdings_itype
369             -
370               columnname: holdings_holdingbranch
371             -
372               columnname: holdings_homebranch
373             -
374               columnname: holdings_ccode
375             -
376               columnname: holdings_volume
377             -
378               columnname: holdings_itemcallnumber
379             -
380               columnname: holdings_status
381             -
382               columnname: holdings_lastseen
383             -
384               columnname: holdings_issues
385               is_hidden: 1
386             -
387               columnname: holdings_renewals
388               is_hidden: 1
389             -
390               columnname: holdings_dateaccessioned
391             -
392               columnname: holdings_datelastborrowed
393             -
394               columnname: holdings_barcode
395             -
396               columnname: holdings_enumchron
397             -
398               columnname: holdings_uri
399             -
400               columnname: holdings_copynumber
401             -
402               columnname: holdings_stocknumber
403             -
404               columnname: holdings_materials
405             -
406               columnname: holdings_itemnotes
407             -
408               columnname: holdings_itemnotes_nonpublic
409             -
410               columnname: holdings_hostrecord
411             -
412               columnname: holdings_usedin
413             -
414               columnname: holdings_usedin_col
415             -
416               columnname: holdings_course_reserves
417             -
418               columnname: holdings_spinelabel
419             -
420               columnname: holdings_actions
421               cannot_be_toggled: 1
422               cannot_be_modified: 1
423
424       otherholdings_table:
425         columns:
426             -
427               columnname: otherholdings_checkbox
428               cannot_be_toggled: 1
429               cannot_be_modified: 1
430             -
431               columnname: otherholdings_cover_image
432             -
433               columnname: otherholdings_itype
434             -
435               columnname: otherholdings_holdingbranch
436             -
437               columnname: otherholdings_homebranch
438             -
439               columnname: otherholdings_ccode
440             -
441               columnname: otherholdings_volume
442             -
443               columnname: otherholdings_itemcallnumber
444             -
445               columnname: otherholdings_status
446             -
447               columnname: otherholdings_lastseen
448             -
449               columnname: otherholdings_issues
450               is_hidden: 1
451             -
452               columnname: otherholdings_renewals
453               is_hidden: 1
454             -
455               columnname: otherholdings_dateaccessioned
456             -
457               columnname: otherholdings_datelastborrowed
458             -
459               columnname: otherholdings_barcode
460             -
461               columnname: otherholdings_enumchron
462             -
463               columnname: otherholdings_uri
464             -
465               columnname: otherholdings_copynumber
466             -
467               columnname: otherholdings_stocknumber
468             -
469               columnname: otherholdings_materials
470             -
471               columnname: otherholdings_itemnotes
472             -
473               columnname: otherholdings_itemnotes_nonpublic
474             -
475               columnname: otherholdings_hostrecord
476             -
477               columnname: otherholdings_usedin
478             -
479               columnname: otherholdings_usedin_col
480             -
481               columnname: otherholdings_course_reserves
482             -
483               columnname: otherholdings_spinelabel
484             -
485               columnname: otherholdings_actions
486               cannot_be_toggled: 1
487               cannot_be_modified: 1
488
489       acquisitiondetails-table:
490         columns:
491             -
492               columnname: vendor
493             -
494               columnname: invoice
495             -
496               columnname: basketgroup
497             -
498               columnname: basket
499             -
500               columnname: ordernumber
501             -
502               columnname: creation_date
503             -
504               columnname: received_data
505             -
506               columnname: status
507             -
508               columnname: quantity
509             -
510               columnname: price
511             -
512               columnname: order_internalnote
513             -
514               columnname: subscription
515             -
516               columnname: subscription_callnumber
517
518       checkoutshistory-table:
519         default_display_length: 20
520         columns:
521             -
522               columnname: patron
523               cannot_be_toggled: 1
524               cannot_be_modified: 1
525             -
526               columnname: barcode
527               cannot_be_toggled: 1
528               cannot_be_modified: 1
529             -
530               columnname: checked_out_from
531             -
532               columnname: checked_out_by
533             -
534               columnname: renewed
535             -
536               columnname: checkout_on
537             -
538               columnname: due_date
539             -
540               columnname: checkin_on
541
542       bundle_tables:
543         columns:
544             -
545               columnname: title
546               cannot_be_toggled: 1
547             -
548               columnname: author
549             -
550               columnname: callnumber
551             -
552               columnname: barcode
553             -
554               columnname: status
555             -
556               columnname: bundle_actions
557               cannot_be_toggled: 1
558               cannot_be_modified: 1
559
560   cataloguing:
561     addbooks:
562       reservoir-table:
563         columns:
564             -
565               columnname: title
566             -
567               columnname: isbn
568             -
569               columnname: coming_from
570             -
571               columnname: import_date
572             -
573               columnname: actions
574               cannot_be_toggled: 1
575               cannot_be_modified: 1
576     additem:
577       itemst:
578         # NOTE: These columns are in the same order as kohastructure.sql, and contain all items
579         # columns except for the following internal/obsolete fields: stack, more_subfields_xml,
580         # cn_sort, permanent_location, damaged_on itemlost_on, withdrawn_on, issues, renewals and
581         # reserves.
582         columns:
583             -
584               columnname: barcode
585             -
586               columnname: dateaccessioned
587             -
588               columnname: booksellerid
589             -
590               columnname: homebranch
591             -
592               columnname: price
593             -
594               columnname: replacementprice
595             -
596               columnname: replacementpricedate
597             -
598               columnname: datelastborrowed
599             -
600               columnname: datelastseen
601             -
602               columnname: stack
603             -
604               columnname: notforloan
605             -
606               columnname: damaged
607             -
608               columnname: itemlost
609             -
610               columnname: withdrawn
611             -
612               columnname: itemcallnumber
613             -
614               columnname: coded_location_qualifier
615             -
616               columnname: restricted
617             -
618               columnname: itemnotes
619             -
620               columnname: itemnotes_nonpublic
621             -
622               columnname: holdingbranch
623             -
624               columnname: timestamp
625             -
626               columnname: location
627             -
628               columnname: onloan
629             -
630               columnname: cn_source
631             -
632               columnname: ccode
633             -
634               columnname: materials
635             -
636               columnname: uri
637             -
638               columnname: itype
639             -
640               columnname: enumchron
641             -
642               columnname: copynumber
643             -
644               columnname: stocknumber
645
646     concerns:
647       table_concerns:
648         default_sort_order: 0
649         columns:
650             -
651               columnname: reported
652             -
653               columnname: details
654             -
655               columnname: title
656             -
657               columnname: status
658             -
659               columnname: actions
660               cannot_be_toggled: 1
661               cannot_be_modified: 1
662
663     z3950_search:
664       resultst:
665         default_sort_order: 1
666         columns:
667             -
668               columnname: server
669             -
670               columnname: title
671             -
672               columnname: author
673             -
674               columnname: date
675             -
676               columnname: edition
677             -
678               columnname: isbn
679             -
680               columnname: lccn
681             -
682               columnname: actions
683               cannot_be_toggled: 1
684               cannot_be_modified: 1
685
686   coursereserves:
687     courses:
688       course_reserves_table:
689         default_display_length: 20
690         default_sort_order: 0
691         columns:
692             -
693               columnname: name
694             -
695               columnname: department
696             -
697               columnname: course_no
698             -
699               columnname: section
700             -
701               columnname: term
702             -
703               columnname: instructors
704             -
705               columnname: staff_note
706             -
707               columnname: public_note
708             -
709               columnname: no_of_students
710             -
711               columnname: enabled
712
713     reserves:
714       course_reserves_table:
715         default_display_length: 20
716         default_sort_order: 0
717         columns:
718             -
719               columnname: title
720             -
721              columnname: author
722             -
723               columnname: barcode
724             -
725               columnname: call_number
726             -
727               columnname: item_type
728             -
729               columnname: collection
730             -
731               columnname: location
732             -
733               columnname: home_library
734             -
735               columnname: holding_library
736             -
737               columnname: staff_note
738             -
739               columnname: public_note
740             -
741               columnname: link
742             -
743               columnname: other_course_reserves
744             -
745               columnname: actions
746               cannot_be_toggled: 1
747               cannot_be_modified: 1
748
749   erm:
750     agreements:
751       agreements:
752         columns:
753             -
754               columnname: name
755             -
756               columnname: vendor
757             -
758               columnname: description
759             -
760               columnname: status
761             -
762               columnname: closure_reason
763             -
764               columnname: is_perpetual
765             -
766               columnname: renewal_priority
767             -
768               columnname: actions
769               cannot_be_toggled: 1
770               cannot_be_modified: 1
771     licenses:
772       licenses:
773         columns:
774             -
775               columnname: name
776             -
777               columnname: vendor
778             -
779               columnname: description
780             -
781               columnname: type
782             -
783               columnname: status
784             -
785               columnname: started_on
786             -
787               columnname: ended_on
788             -
789               columnname: actions
790               cannot_be_toggled: 1
791               cannot_be_modified: 1
792     eholdings:
793       packages:
794         columns:
795             -
796               columnname: name
797             -
798               columnname: vendor
799             -
800               columnname: type
801             -
802               columnname: content_type
803             -
804               columnname: created_on
805             -
806               columnname: notes
807             -
808               columnname: actions
809               cannot_be_toggled: 1
810               cannot_be_modified: 1
811       titles:
812         columns:
813             -
814               columnname: title
815             -
816               columnname: contributors
817             -
818               columnname: publication_type
819             -
820               columnname: identifier
821             -
822               columnname: actions
823               cannot_be_toggled: 1
824               cannot_be_modified: 1
825
826   illrequests:
827     ill-requests:
828       ill-requests:
829         columns:
830             -
831               columnname: illrequest_id
832             -
833               columnname: metadata_author
834             -
835               columnname: metadata_title
836             -
837               columnname: metadata_article_title
838             -
839               columnname: metadata_issue
840             -
841               columnname: metadata_volume
842             -
843               columnname: metadata_year
844             -
845               columnname: metadata_pages
846             -
847               columnname: metadata_type
848             -
849               columnname: orderid
850             -
851               columnname: patron
852             -
853               columnname: biblio_id
854             -
855               columnname: library_branchname
856             -
857               columnname: status
858             -
859               columnname: placed
860               cannot_be_toggled: 1
861               cannot_be_modified: 1
862               is_hidden: 1
863             -
864               columnname: placed_formatted
865             -
866               columnname: updated
867               cannot_be_toggled: 1
868               cannot_be_modified: 1
869               is_hidden: 1
870             -
871               columnname: updated_formatted
872             -
873               columnname: replied
874             -
875               columnname: completed
876               cannot_be_toggled: 1
877               cannot_be_modified: 1
878               is_hidden: 1
879             -
880               columnname: completed_formatted
881             -
882               columnname: accessurl
883             -
884               columnname: cost
885             -
886               columnname: price_paid
887             -
888               columnname: comments
889             -
890               columnname: notesopac
891             -
892               columnname: notesstaff
893             -
894               columnname: backend
895             -
896               columnname: action
897               cannot_be_toggled: 1
898               cannot_be_modified: 1
899
900   members:
901     fines:
902       account-fines:
903         default_display_length: 20
904         columns:
905             -
906               columnname: date
907             -
908               columnname: timestamp
909             -
910               columnname: credit_number
911               is_hidden: 1
912             -
913               columnname: account_type
914             -
915               columnname: description
916             -
917               columnname: barcode
918             -
919               columnname: callnumber
920             -
921               columnname: date_due
922             -
923               columnname: returndate
924             -
925               columnname: issuedate
926             -
927               columnname: checked_out_from
928             -
929               columnname: home_library
930             -
931               columnname: note
932             -
933               columnname: amount
934               cannot_be_toggled: 1
935               cannot_be_modified: 1
936             -
937               columnname: amountoutstanding
938               cannot_be_toggled: 1
939               cannot_be_modified: 1
940             -
941               columnname: actions
942               cannot_be_toggled: 1
943               cannot_be_modified: 1
944
945     pay:
946       pay-fines-table:
947         default_display_length: 20
948         default_sort_order: 3
949         columns:
950             -
951               columnname: checkbox
952               cannot_be_toggled: 1
953               cannot_be_modified: 1
954             -
955               columnname: actions
956               cannot_be_toggled: 1
957               cannot_be_modified: 1
958             -
959               columnname: account_type
960             -
961               columnname: description
962             -
963               columnname: date
964             -
965               columnname: barcode
966             -
967               columnname: callnumber
968             -
969               columnname: date_due
970             -
971               columnname: returndate
972             -
973               columnname: issuedate
974             -
975               columnname: checked_out_from
976             -
977               columnname: home_library
978             -
979               columnname: note
980             -
981               columnname: amount
982             -
983               columnname: amountoutstanding
984
985     member:
986       memberresultst:
987         columns:
988             -
989               columnname: checkbox
990               cannot_be_toggled: 1
991               cannot_be_modified: 1
992             -
993               columnname: cardnumber
994             -
995               columnname: name
996             -
997               columnname: dateofbirth
998             -
999               columnname: category
1000             -
1001               columnname: library
1002             -
1003               columnname: expires_on
1004             -
1005               columnname: od_checkouts
1006             -
1007               columnname: fines
1008             -
1009               columnname: circ_notes
1010             -
1011               columnname: actions
1012               cannot_be_toggled: 1
1013               cannot_be_modified: 1
1014
1015     moremember:
1016       issues-table:
1017         columns:
1018             -
1019               columnname: sort_order
1020               cannot_be_toggled: 1
1021               cannot_be_modified: 1
1022               is_hidden: 1
1023             -
1024               columnname: todays_or_previous_checkouts
1025               cannot_be_toggled: 1
1026               cannot_be_modified: 1
1027               is_hidden: 1
1028             -
1029               columnname: due_date_unformatted
1030               cannot_be_toggled: 1
1031               cannot_be_modified: 1
1032               is_hidden: 1
1033             -
1034               columnname: due_date
1035             -
1036               columnname: title
1037             -
1038               columnname: record_type
1039             -
1040               columnname: item_type
1041             -
1042               columnname: collection
1043             -
1044               columnname: location
1045             -
1046               columnname: homebranch
1047             -
1048               columnname: checkout_on_unformatted
1049               cannot_be_toggled: 1
1050               cannot_be_modified: 1
1051               is_hidden: 1
1052             -
1053               columnname: checkout_on
1054             -
1055               columnname: checkout_from
1056             -
1057               columnname: callno
1058             -
1059               columnname: copynumber
1060             -
1061               columnname: charge
1062             -
1063               columnname: fine
1064             -
1065               columnname: price
1066             -
1067               columnname: renew
1068               cannot_be_toggled: 1
1069               cannot_be_modified: 1
1070             -
1071               columnname: checkin
1072             -
1073               columnname: claims_returned
1074             -
1075               columnname: export
1076               cannot_be_toggled: 1
1077               cannot_be_modified: 1
1078
1079       relatives-issues-table:
1080         columns:
1081             -
1082               columnname: due_date_unformatted
1083               cannot_be_toggled: 1
1084               cannot_be_modified: 1
1085               is_hidden: 1
1086             -
1087               columnname: due_date
1088             -
1089               columnname: title
1090             -
1091               columnname: record_type
1092             -
1093               columnname: item_type
1094             -
1095               columnname: collection
1096             -
1097               columnname: location
1098             -
1099               columnname: checkout_on_unformatted
1100               cannot_be_toggled: 1
1101               cannot_be_modified: 1
1102               is_hidden: 1
1103             -
1104               columnname: checkout_on
1105             -
1106               columnname: checkout_from
1107             -
1108               columnname: callno
1109             -
1110               columnname: copynumber
1111             -
1112               columnname: charge
1113             -
1114               columnname: fine
1115             -
1116               columnname: price
1117             -
1118               columnname: patron
1119
1120     holdshistory:
1121       holdshistory-table:
1122         default_display_length: 20
1123         columns:
1124             -
1125               columnname: title
1126               cannot_be_toggled: 1
1127               cannot_be_modified: 1
1128             -
1129               columnname: author
1130             -
1131               columnname: barcode
1132             -
1133               columnname: branch
1134             -
1135               columnname: reservedate
1136             -
1137               columnname: expirationdate
1138             -
1139               columnname: waitingdate
1140             -
1141               columnname: cancellationdate
1142             -
1143               columnname: itemtype
1144             -
1145               columnname: status
1146
1147     checkouthistory:
1148       checkouthistory-table:
1149         default_display_length: 20
1150         columns:
1151             - columnname: type
1152               cannot_be_toggled: 1
1153               cannot_be_modified: 1
1154             -
1155               columnname: date
1156             -
1157               columnname: title
1158             -
1159               columnname: author
1160             -
1161               columnname: call_number
1162             -
1163               columnname: enumchron
1164             -
1165               columnname: barcode
1166             -
1167               columnname: number_of_renewals
1168             -
1169               columnname: checked_out_on
1170             -
1171               columnname: checked_out_from
1172             -
1173               columnname: date_due
1174             -
1175               columnname: return_date
1176
1177     patron-lists:
1178       patron-list-table:
1179         default_display_length: 20
1180         default_sort_order: 3
1181         columns:
1182             -
1183               columnname: checkbox
1184               cannot_be_toggled: 1
1185               cannot_be_modified: 1
1186             -
1187               columnname: card
1188             -
1189               columnname: firstname
1190             -
1191               columnname: surname
1192             -
1193               columnname: address
1194             -
1195               columnname: category
1196             -
1197               columnname: library
1198             -
1199               columnname: expires_on
1200             -
1201               columnname: circ_notes
1202
1203   reports:
1204     lostitems:
1205       lostitems-table:
1206         columns:
1207             -
1208               columnname: title
1209               cannot_be_toggled: 1
1210               cannot_be_modified: 1
1211             -
1212               columnname: author
1213             -
1214               columnname: lostcode
1215             -
1216               columnname: itemlost_on
1217             -
1218               columnname: barcode
1219             -
1220               columnname: callnumber
1221             -
1222               columnname: datelastseen
1223             -
1224               columnname: price
1225             -
1226               columnname: replacementprice
1227             -
1228               columnname: library
1229             -
1230               columnname: itemtype
1231             -
1232               columnname: collection_code
1233             -
1234               columnname: current_location
1235             -
1236               columnname: location
1237             -
1238               columnname: notforloan
1239             -
1240               columnname: notes
1241
1242     orders_by_fund:
1243       funds-table:
1244         default_display_length: 20
1245         default_sort_order: 0
1246         columns:
1247             -
1248               columnname: fund
1249             -
1250               columnname: basket
1251               cannot_be_toggled: 1
1252               cannot_be_modified: 1
1253             -
1254               columnname: basket_name
1255             -
1256               columnname: basket_by
1257             -
1258               columnname: title
1259             -
1260               columnname: currency
1261             -
1262               columnname: list_price
1263             -
1264               columnname: rrp
1265             -
1266               columnname: budgeted_cost
1267             -
1268               columnname: quantity
1269             -
1270               columnname: total_rrp
1271             -
1272               columnname: total_cost
1273             -
1274               columnname: entry_date
1275             -
1276               columnname: date_received
1277             -
1278               columnname: internal_note
1279             -
1280               columnname: vendor_note
1281
1282     saved-sql:
1283       table_reports:
1284         default_display_length: 20
1285         default_sort_order: 0
1286         columns:
1287             -
1288               columnname: selection
1289               cannot_be_toggled: 1
1290               cannot_be_modified: 1
1291             -
1292               columnname: report_id
1293               cannot_be_toggled: 1
1294               cannot_be_modified: 1
1295             -
1296               columnname: report_name
1297             -
1298               columnname: type
1299             -
1300               columnname: group
1301             -
1302               columnname: subgroup
1303             -
1304               columnname: notes
1305             -
1306               columnname: author
1307             -
1308               columnname: creation_date
1309             -
1310               columnname: last_edit
1311             -
1312               columnname: last_run
1313             -
1314               columnname: public
1315             -
1316               columnname: json_url
1317             -
1318               columnname: cache_expiry
1319             -
1320               columnname: saved_results
1321             -
1322               columnname: update
1323             -
1324               columnname: actions
1325               cannot_be_toggled: 1
1326               cannot_be_modified: 1
1327
1328   circ:
1329     circulation:
1330       issues-table:
1331         columns:
1332             -
1333               columnname: sort_order
1334               cannot_be_toggled: 1
1335               cannot_be_modified: 1
1336               is_hidden: 1
1337             -
1338               columnname: todays_or_previous_checkouts
1339               cannot_be_toggled: 1
1340               cannot_be_modified: 1
1341               is_hidden: 1
1342             -
1343               columnname: due_date_unformatted
1344               cannot_be_toggled: 1
1345               cannot_be_modified: 1
1346               is_hidden: 1
1347             -
1348               columnname: due_date
1349             -
1350               columnname: title
1351             -
1352               columnname: record_type
1353             -
1354               columnname: item_type
1355             -
1356               columnname: collection
1357             -
1358               columnname: location
1359             -
1360               columnname: homebranch
1361             -
1362               columnname: checkout_on_unformatted
1363               cannot_be_toggled: 1
1364               cannot_be_modified: 1
1365               is_hidden: 1
1366             -
1367               columnname: checkout_on
1368             -
1369               columnname: checkout_from
1370             -
1371               columnname: callno
1372             -
1373               columnname: copynumber
1374             -
1375               columnname: charge
1376             -
1377               columnname: fine
1378             -
1379               columnname: price
1380             -
1381               columnname: renew
1382               cannot_be_toggled: 1
1383               cannot_be_modified: 1
1384             -
1385               columnname: checkin
1386             -
1387               columnname: claims_returned
1388             -
1389               columnname: export
1390               cannot_be_toggled: 1
1391               cannot_be_modified: 1
1392
1393       relatives-issues-table:
1394         columns:
1395             -
1396               columnname: due_date_unformatted
1397               cannot_be_toggled: 1
1398               cannot_be_modified: 1
1399               is_hidden: 1
1400             -
1401               columnname: due_date
1402             -
1403               columnname: title
1404             -
1405               columnname: record_type
1406             -
1407               columnname: item_type
1408             -
1409               columnname: collection
1410             -
1411               columnname: location
1412             -
1413               columnname: checkout_on_unformatted
1414               cannot_be_toggled: 1
1415               cannot_be_modified: 1
1416               is_hidden: 1
1417             -
1418               columnname: checkout_on
1419             -
1420               columnname: checkout_from
1421             -
1422               columnname: callno
1423             -
1424               columnname: copynumber
1425             -
1426               columnname: charge
1427             -
1428               columnname: fine
1429             -
1430               columnname: price
1431             -
1432               columnname: patron
1433
1434       table_borrowers:
1435         columns:
1436             -
1437               columnname: name
1438               cannot_be_toggled: 1
1439               cannot_be_modified: 1
1440             -
1441               columnname: cardnumber
1442             -
1443               columnname: date_of_birth
1444             -
1445               columnname: category
1446             -
1447               columnname: library
1448             -
1449               columnname: address
1450             -
1451               columnname: phone
1452               is_hidden: 1
1453
1454     returns:
1455       checkedintable:
1456         columns:
1457             -
1458               columnname: due_date
1459             -
1460               columnname: title
1461             -
1462               columnname: author
1463             -
1464               columnname: barcode
1465             -
1466               columnname: homelibrary
1467             -
1468               columnname: transferlibrary
1469             -
1470               columnname: location
1471             -
1472               columnname: itemcallnumber
1473             -
1474               columnname: dateaccessioned
1475               is_hidden: 1
1476             -
1477               columnname: record_type
1478             -
1479               columnname: itype
1480             -
1481               columnname: ccode
1482             -
1483               columnname: borrower
1484             -
1485               columnname: itemnote
1486
1487     view_holdsqueue:
1488       holds-table:
1489         default_sort_order: 3
1490         columns:
1491             -
1492               columnname: title
1493             -
1494               columnname: holdingbranch
1495               is_hidden: 1
1496             -
1497               columnname: collection
1498             -
1499               columnname: document_type
1500             -
1501               columnname: callnumber
1502             -
1503               columnname: copynumber
1504             -
1505               columnname: enumeration
1506             -
1507               columnname: barcode
1508             -
1509               columnname: patron
1510             -
1511               columnname: patroncategory
1512             -
1513               columnname: send_to
1514             -
1515               columnname: date
1516             -
1517               columnname: notes
1518
1519     holds:
1520       holds-to-pull:
1521         default_display_length: 20
1522         default_sort_order: 0
1523         columns:
1524             -
1525               columnname: pull_items
1526             -
1527               columnname: avalaible_items
1528             -
1529               columnname: patrons
1530             -
1531               columnname: patron
1532             -
1533               columnname: title
1534             -
1535               columnname: libraries
1536             -
1537               columnname: barcodes
1538             -
1539               columnname: call_numbers
1540             -
1541               columnname: copy_numbers
1542             -
1543               columnname: enumeration
1544             -
1545               columnname: itemtypes
1546             -
1547               columnname: locations
1548             -
1549               columnname: collection
1550             -
1551               columnname: hold_date
1552             -
1553               columnname: reserve_notes
1554             -
1555               columnname: pickup_location
1556             -
1557               columnname: action
1558
1559     holdsratios:
1560       holds-ratios:
1561         default_display_length: 20
1562         columns:
1563             -
1564               columnname: holds
1565             -
1566               columnname: items
1567             -
1568               columnname: holds_ratio
1569             -
1570               columnname: title
1571             -
1572               columnname: home_libraries
1573             -
1574               columnname: holding_libraries
1575             -
1576               columnname: location
1577             -
1578               columnname: itemtype
1579             -
1580               columnname: call_numbers
1581             -
1582               columnname: items_needed
1583
1584     holds_awaiting_pickup:
1585       holdst:
1586         columns:
1587             -
1588               columnname: checkbox
1589               cannot_be_toggled: 1
1590               cannot_be_modified: 1
1591             -
1592               columnname: waiting_since
1593             -
1594               columnname: date_hold_placed
1595             -
1596               columnname: expiration_date
1597             -
1598               columnname: title
1599             -
1600               columnname: patron
1601             -
1602               columnname: home_library
1603             -
1604               columnname: current_location
1605             -
1606               columnname: shelving_location
1607             -
1608               columnname: call_number
1609             -
1610               columnname: copy_number
1611             -
1612               columnname: enumeration
1613             -
1614               columnname: action
1615
1616       holdso:
1617         columns:
1618             -
1619               columnname: checkbox
1620               cannot_be_toggled: 1
1621               cannot_be_modified: 1
1622             -
1623               columnname: waiting_since
1624             -
1625               columnname: date_hold_placed
1626             -
1627               columnname: expiration_date
1628             -
1629               columnname: title
1630             -
1631               columnname: patron
1632             -
1633               columnname: home_library
1634             -
1635               columnname: current_location
1636             -
1637               columnname: shelving_location
1638             -
1639               columnname: call_number
1640             -
1641               columnname: copy_number
1642             -
1643               columnname: enumeration
1644             -
1645               columnname: action
1646
1647       holdscr:
1648         columns:
1649             -
1650                 columnname: checkbox
1651                 cannot_be_toggled: 1
1652                 cannot_be_modified: 1
1653             -
1654                 columnname: waiting_since
1655             -
1656                 columnname: date_hold_placed
1657             -
1658                 columnname: expiration_date
1659             -
1660                 columnname: title
1661             -
1662                 columnname: patron
1663             -
1664                 columnname: home_library
1665             -
1666                 columnname: current_location
1667             -
1668                 columnname: shelving_location
1669             -
1670                 columnname: call_number
1671             -
1672                 columnname: copy_number
1673             -
1674                 columnname: enumeration
1675             -
1676                 columnname: action
1677
1678     overdues:
1679       circ-overdues:
1680         default_display_length: 20
1681         default_sort_order: 0
1682         columns:
1683             -
1684               columnname: due_date
1685             -
1686               columnname: patron
1687             -
1688               columnname: patron_category
1689               is_hidden: 1
1690             -
1691               columnname: patron_library
1692             -
1693               columnname: title
1694             -
1695               columnname: home_library
1696               is_hidden: 1
1697             -
1698               columnname: holding_library
1699               is_hidden: 1
1700             -
1701               columnname: shelving_location
1702             -
1703               columnname: barcode
1704             -
1705               columnname: call_number
1706             -
1707               columnname: item_type
1708               is_hidden: 1
1709             -
1710               columnname: price
1711             -
1712               columnname: non-public_note
1713             -
1714               columnname: claims_returned
1715
1716     print_summary:
1717         print-summary-checkouts:
1718             columns:
1719                 -
1720                     columnname: title
1721                 -
1722                     columnname: author
1723                 -
1724                     columnname: call_number
1725                 -
1726                     columnname: item_type
1727                 -
1728                     columnname: date_due
1729                 -
1730                     columnname: barcode
1731                 -
1732                     columnname: inventory_number
1733                 -
1734                     columnname: charge
1735                 -
1736                     columnname: price
1737                 -
1738                     columnname: status
1739
1740         print-summary-holds:
1741             columns:
1742                 -
1743                     columnname: title
1744                 -
1745                     columnname: author
1746                 -
1747                     columnname: placed_on
1748                 -
1749                     columnname: expires_on
1750                 -
1751                     columnname: pick up_location
1752
1753         print-summary-fines:
1754             columns:
1755                 -
1756                     columnname: date
1757                 -
1758                     columnname: description_of_charges
1759                 -
1760                     columnname: note
1761                 -
1762                     columnname: amount
1763                 -
1764                     columnname: outstanding
1765
1766   opac:
1767     biblio-detail:
1768       holdingst:
1769         columns:
1770             -
1771               columnname: item_cover
1772             -
1773               columnname: item_itemtype
1774             -
1775               columnname: item_current_location
1776             -
1777               columnname: item_home_location
1778             -
1779               columnname: item_shelving_location
1780               is_hidden: 1
1781             -
1782               columnname: item_ccode
1783             -
1784               columnname: item_callnumber
1785             -
1786               columnname: item_materials
1787               is_hidden: 1
1788             -
1789               columnname: item_enumchron
1790             -
1791               columnname: item_url
1792             -
1793               columnname: item_copy
1794             -
1795               columnname: item_status
1796             -
1797               columnname: item_notes
1798             -
1799               columnname: item_datedue
1800             -
1801               columnname: item_barcode
1802               is_hidden: 1
1803             -
1804               columnname: item_holds
1805             -
1806               columnname: item_priority
1807             -
1808               columnname: item_coursereserves
1809
1810       course_reserves_table:
1811         columns:
1812             -
1813               columnname: coursename
1814             -
1815               columnname: department
1816             -
1817               columnname: course_number
1818             -
1819               columnname: section
1820             -
1821               columnname: term
1822             -
1823               columnname: instructor
1824             -
1825               columnname: notes
1826
1827       subscriptionst:
1828         columns:
1829             -
1830               columnname: serial_serialseq
1831             -
1832               columnname: serial_publisheddate
1833             -
1834               columnname: serial_planneddate
1835             -
1836               columnname: serial_status
1837             -
1838               columnname: serial_notes
1839
1840       course-items-table:
1841         columns:
1842             -
1843               columnname: title
1844             -
1845               columnname: author
1846             -
1847               columnname: itemtype
1848             -
1849               columnname: location
1850             -
1851               columnname: collection
1852             -
1853               columnname: callnumber
1854             -
1855               columnname: copynumber
1856             -
1857               columnname: status
1858             -
1859               columnname: datedue
1860             -
1861               columnname: notes
1862             -
1863               columnname: link
1864
1865   serials:
1866     subscription-detail:
1867       orders:
1868         columns:
1869             -
1870               columnname: invoice
1871             -
1872               columnname: basket
1873             -
1874               columnname: ordernumber
1875             -
1876               columnname: creation_date
1877             -
1878               columnname: receive_date
1879             -
1880               columnname: status
1881             -
1882               columnname: order_internalnote
1883             -
1884               columnname: order_vendornote
1885             -
1886               columnname: fund
1887             -
1888               columnname: ordered
1889             -
1890               columnname: spent
1891
1892   tools:
1893     batch_patron_modification:
1894       borrowerst:
1895         columns:
1896             -
1897               columnname: batch_patron_edit_selections
1898               cannot_be_toggled: 1
1899               cannot_be_modified: 1
1900             -
1901               columnname: batch_patron_edit_cardnumber
1902             -
1903               columnname: batch_patron_edit_surname
1904             -
1905               columnname: batch_patron_edit_firstname
1906             -
1907               columnname: batch_patron_edit_branchcode
1908             -
1909               columnname: batch_patron_edit_categorycode
1910             -
1911               columnname: batch_patron_edit_streetnumber
1912             -
1913               columnname: batch_patron_edit_address
1914             -
1915               columnname: batch_patron_edit_address2
1916             -
1917               columnname: batch_patron_edit_city
1918             -
1919               columnname: batch_patron_edit_state
1920             -
1921               columnname: batch_patron_edit_zipcode
1922             -
1923               columnname: batch_patron_edit_country
1924             -
1925               columnname: batch_patron_edit_email
1926             -
1927               columnname: batch_patron_edit_phone
1928             -
1929               columnname: batch_patron_edit_mobile
1930             -
1931               columnname: batch_patron_edit_dateenrolled
1932             -
1933               columnname: batch_patron_edit_dateexpiry
1934             -
1935               columnname: batch_patron_edit_borrowernotes
1936             -
1937               columnname: batch_patron_edit_opacnote
1938             -
1939               columnname: batch_patron_edit_debarred
1940             -
1941               columnname: batch_patron_edit_debarredcomment
1942
1943     logviewer:
1944       logst:
1945         default_display_length: 20
1946         columns:
1947             -
1948               columnname: date
1949             -
1950               columnname: librarian
1951             -
1952               columnname: module
1953             -
1954               columnname: action
1955             -
1956               columnname: object
1957             -
1958               columnname: info
1959             -
1960               columnname: interface
1961     marc-modification-templates:
1962       templatest:
1963         columns:
1964             -
1965               columnname: id
1966               is_hidden: 1
1967             -
1968               columnname: template
1969             -
1970               columnname: actions
1971               cannot_be_toggled: 1
1972               cannot_be_modified: 1
1973     notices:
1974       lettert:
1975         default_sort_order: 3
1976         columns:
1977             -
1978               columnname: library
1979             -
1980               columnname: module
1981             -
1982               columnname: code
1983             -
1984               columnname: name
1985             -
1986               columnname: updated_on
1987             -
1988               columnname: copy_notice
1989             -
1990               columnname: actions
1991               cannot_be_toggled: 1
1992               cannot_be_modified: 1
1993
1994     stockrotation:
1995       stock_rotation:
1996         columns:
1997             -
1998               columnname: name
1999             -
2000               columnname: cyclical
2001             -
2002               columnname: active
2003             -
2004               columnname: description
2005             -
2006               columnname: number_of_items
2007             -
2008               columnname: actions
2009               cannot_be_toggled: 1
2010               cannot_be_modified: 1
2011
2012       stock_rotation_manage_items:
2013         columns:
2014             -
2015               columnname: barcode
2016             -
2017               columnname: title
2018             -
2019               columnname: author
2020             -
2021               columnname: call_number
2022             -
2023               columnname: in_transit
2024             -
2025               columnname: stages
2026             -
2027               columnname: actions
2028               cannot_be_toggled: 1
2029               cannot_be_modified: 1
2030
2031     upload:
2032       uploadresults:
2033         default_display_length: 20
2034         columns:
2035             -
2036               columnname: filename
2037             -
2038               columnname: size
2039             -
2040               columnname: hashvalue
2041             -
2042               columnname: date
2043               is_hidden: 1
2044             -
2045               columnname: category
2046             -
2047               columnname: public
2048             -
2049               columnname: temporary
2050             -
2051               columnname: actions
2052               cannot_be_toggled: 1
2053               cannot_be_modified: 1
2054   pos:
2055     pay:
2056       invoices:
2057         columns:
2058             -
2059               columnname: code
2060             -
2061               columnname: description
2062             -
2063               columnname: cost
2064             -
2065               columnname: actions
2066               cannot_be_toggled: 1
2067               cannot_be_modified: 1