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