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