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