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