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