Bug 23081: [19.11.x] Set items.issues to 0 if not provided (AddItem)
[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: account_type
433         -
434           columnname: description
435         -
436           columnname: barcode
437         -
438           columnname: date_due
439         -
440           columnname: returndate
441         -
442           columnname: note
443         -
444           columnname: amount
445           cannot_be_toggled: 1
446           cannot_be_modified: 1
447         -
448           columnname: amountoutstanding
449           cannot_be_toggled: 1
450           cannot_be_modified: 1
451         -
452           columnname: actions
453           cannot_be_toggled: 1
454           cannot_be_modified: 1
455
456     pay:
457       pay-fines-table:
458         -
459           columnname: checkbox
460           cannot_be_toggled: 1
461           cannot_be_modified: 1
462         -
463           columnname: actions
464           cannot_be_toggled: 1
465           cannot_be_modified: 1
466         -
467           columnname: account_type
468         -
469           columnname: description
470         -
471           columnname: date
472         -
473           columnname: barcode
474         -
475           columnname: date_due
476         -
477           columnname: returndate
478         -
479           columnname: note
480         -
481           columnname: amount
482         -
483           columnname: amountoutstanding
484
485     member:
486       memberresultst:
487         -
488           columnname: checkbox
489           cannot_be_toggled: 1
490           cannot_be_modified: 1
491         -
492           columnname: cardnumber
493         -
494           columnname: name
495         -
496           columnname: dateofbirth
497         -
498           columnname: category
499         -
500           columnname: library
501         -
502           columnname: expires_on
503         -
504           columnname: od_checkouts
505         -
506           columnname: fines
507         -
508           columnname: circ_notes
509         -
510           columnname: actions
511           cannot_be_toggled: 1
512           cannot_be_modified: 1
513
514     moremember:
515       issues-table:
516         -
517           columnname: sort_order
518           cannot_be_toggled: 1
519           cannot_be_modified: 1
520           is_hidden: 1
521         -
522           columnname: todays_or_previous_checkouts
523           cannot_be_toggled: 1
524           cannot_be_modified: 1
525           is_hidden: 1
526         -
527           columnname: due_date_unformatted
528           cannot_be_toggled: 1
529           cannot_be_modified: 1
530           is_hidden: 1
531         -
532           columnname: due_date
533         -
534           columnname: title
535         -
536           columnname: item_type
537         -
538           columnname: collection
539         -
540           columnname: location
541         -
542           columnname: homebranch
543         -
544           columnname: checkout_on_unformatted
545           cannot_be_toggled: 1
546           cannot_be_modified: 1
547           is_hidden: 1
548         -
549           columnname: checkout_on
550         -
551           columnname: checkout_from
552         -
553           columnname: callno
554         -
555           columnname: charge
556         -
557           columnname: fine
558         -
559           columnname: price
560         -
561           columnname: renew
562           cannot_be_toggled: 1
563           cannot_be_modified: 1
564         -
565           columnname: checkin
566         -
567           columnname: export
568           cannot_be_toggled: 1
569           cannot_be_modified: 1
570
571     holdshistory:
572       holdshistory-table:
573         -
574           columnname: title
575           cannot_be_toggled: 1
576           cannot_be_modified: 1
577         -
578           columnname: author
579         -
580           columnname: barcode
581         -
582           columnname: branch
583         -
584           columnname: reservedate
585         -
586           columnname: expirationdate
587         -
588           columnname: waitingdate
589         -
590           columnname: cancellationdate
591         -
592           columnname: itemtype
593         -
594           columnname: status
595
596     checkouthistory:
597       checkouthistory-table:
598         - columnname: type
599           cannot_be_toggled: 1
600           cannot_be_modified: 1
601         -
602           columnname: date
603         -
604           columnname: title
605         -
606           columnname: author
607         -
608           columnname: call_number
609         -
610           columnname: barcode
611         -
612           columnname: number_of_renewals
613         -
614           columnname: checked_out_on
615         -
616           columnname: checked_out_from
617         -
618           columnname: date_due
619         -
620           columnname: return_date
621
622     patron-lists:
623       patron-list-table:
624         -
625           columnname: checkbox
626           cannot_be_toggled: 1
627           cannot_be_modified: 1
628         -
629           columnname: card
630         -
631           columnname: firstname
632         -
633           columnname: surname
634         -
635           columnname: address
636         -
637           columnname: category
638         -
639           columnname: library
640         -
641           columnname: expires_on
642         -
643           columnname: circ_notes
644
645   reports:
646     lostitems:
647       lostitems-table:
648         -
649           columnname: title
650           cannot_be_toggled: 1
651           cannot_be_modified: 1
652         -
653           columnname: author
654         -
655           columnname: lostcode
656         -
657           columnname: itemlost_on
658         -
659           columnname: barcode
660         -
661           columnname: callnumber
662         -
663           columnname: datelastseen
664         -
665           columnname: price
666         -
667           columnname: replacementprice
668         -
669           columnname: library
670         -
671           columnname: itemtype
672         -
673           columnname: collection_code
674         -
675           columnname: current_location
676         -
677           columnname: location
678         -
679           columnname: notforloan
680         -
681           columnname: notes
682
683     saved-sql:
684       table_reports:
685         -
686           columnname: selection
687           cannot_be_toggled: 1
688           cannot_be_modified: 1
689         -
690           columnname: report_id
691           cannot_be_toggled: 1
692           cannot_be_modified: 1
693         -
694           columnname: report_name
695         -
696           columnname: type
697         -
698           columnname: group
699         -
700           columnname: subgroup
701         -
702           columnname: notes
703         -
704           columnname: author
705         -
706           columnname: creation_date
707         -
708           columnname: last_edit
709         -
710           columnname: last_run
711         -
712           columnname: public
713         -
714           columnname: json_url
715         -
716           columnname: cache_expiry
717         -
718           columnname: saved_results
719         -
720           columnname: update
721         -
722           columnname: actions
723           cannot_be_toggled: 1
724           cannot_be_modified: 1
725
726   circ:
727     circulation:
728       issues-table:
729         -
730           columnname: sort_order
731           cannot_be_toggled: 1
732           cannot_be_modified: 1
733           is_hidden: 1
734         -
735           columnname: todays_or_previous_checkouts
736           cannot_be_toggled: 1
737           cannot_be_modified: 1
738           is_hidden: 1
739         -
740           columnname: due_date_unformatted
741           cannot_be_toggled: 1
742           cannot_be_modified: 1
743           is_hidden: 1
744         -
745           columnname: due_date
746         -
747           columnname: title
748         -
749           columnname: item_type
750         -
751           columnname: collection
752         -
753           columnname: location
754         -
755           columnname: homebranch
756         -
757           columnname: checkout_on_unformatted
758           cannot_be_toggled: 1
759           cannot_be_modified: 1
760           is_hidden: 1
761         -
762           columnname: checkout_on
763         -
764           columnname: checkout_from
765         -
766           columnname: callno
767         -
768           columnname: charge
769         -
770           columnname: fine
771         -
772           columnname: price
773         -
774           columnname: renew
775           cannot_be_toggled: 1
776           cannot_be_modified: 1
777         -
778           columnname: checkin
779         -
780           columnname: export
781           cannot_be_toggled: 1
782           cannot_be_modified: 1
783       table_borrowers:
784         -
785           columnname: name
786           cannot_be_toggled: 1
787           cannot_be_modified: 1
788         -
789           columnname: cardnumber
790         -
791           columnname: date_of_birth
792         -
793           columnname: category
794         -
795           columnname: library
796         -
797           columnname: address
798         -
799           columnname: phone
800           is_hidden: 1
801     returns:
802       checkedintable:
803         -
804           columnname: due_date
805         -
806           columnname: title
807         -
808           columnname: author
809         -
810           columnname: barcode
811         -
812           columnname: homelibrary
813         -
814           columnname: holdinglibrary
815         -
816           columnname: location
817         -
818           columnname: itemcallnumber
819         -
820           columnname: dateaccessioned
821           is_hidden: 1
822         -
823           columnname: itype
824         -
825           columnname: borrower
826         -
827           columnname: itemnote
828
829     view_holdsqueue:
830       holds-table:
831         -
832           columnname: title
833         -
834           columnname: collection
835         -
836           columnname: document_type
837         -
838           columnname: callnumber
839         -
840           columnname: copynumber
841         -
842           columnname: enumeration
843         -
844           columnname: barcode
845         -
846           columnname: patron
847         -
848           columnname: send_to
849         -
850           columnname: date
851         -
852           columnname: notes
853
854     holds:
855       holds-to-pull:
856         -
857           columnname: pull_items
858         -
859           columnname: avalaible_items
860         -
861           columnname: patrons
862         -
863           columnname: patron
864         -
865           columnname: title
866         -
867           columnname: libraries
868         -
869           columnname: call_numbers
870         -
871           columnname: copy_numbers
872         -
873           columnname: enumeration
874         -
875           columnname: itemtypes
876         -
877           columnname: locations
878         -
879           columnname: hold_date
880         -
881           columnname: action
882
883     holdsratios:
884       holds-ratios:
885         -
886           columnname: holds
887         -
888           columnname: items
889         -
890           columnname: holds_ratio
891         -
892           columnname: title
893         -
894           columnname: home_libraries
895         -
896           columnname: holding_libraries
897         -
898           columnname: location
899         -
900           columnname: itemtype
901         -
902           columnname: call_numbers
903         -
904           columnname: items_needed
905
906     holds_awaiting_pickup:
907       holdst:
908         -
909           columnname: waiting_since
910         -
911           columnname: date_hold_placed
912         -
913           columnname: title
914         -
915           columnname: patron
916         -
917           columnname: home_library
918         -
919           columnname: current_location
920         -
921           columnname: shelving_location
922         -
923           columnname: call_number
924         -
925           columnname: copy_number
926         -
927           columnname: enumeration
928         -
929           columnname: action
930
931       holdso:
932         -
933           columnname: waiting_since
934         -
935           columnname: date_hold_placed
936         -
937           columnname: title
938         -
939           columnname: patron
940         -
941           columnname: home_library
942         -
943           columnname: current_location
944         -
945           columnname: shelving_location
946         -
947           columnname: call_number
948         -
949           columnname: copy_number
950         -
951           columnname: enumeration
952         -
953           columnname: action
954
955     overdues:
956       circ-overdues:
957         -
958           columnname: due_date
959         -
960           columnname: patron
961         -
962           columnname: patron_category
963           is_hidden: 1
964         -
965           columnname: patron_library
966         -
967           columnname: title
968         -
969           columnname: home_library
970           is_hidden: 1
971         -
972           columnname: holding_library
973           is_hidden: 1
974         -
975           columnname: barcode
976         -
977           columnname: call_number
978         -
979           columnname: item_type
980           is_hidden: 1
981         -
982           columnname: price
983         -
984           columnname: non-public_note
985
986   opac:
987     biblio-detail:
988       holdingst:
989         -
990           columnname: item_itemtype
991         -
992           columnname: item_current_location
993         -
994           columnname: item_home_location
995         -
996           columnname: item_shelving_location
997           is_hidden: 1
998         -
999           columnname: item_ccode
1000         -
1001           columnname: item_callnumber
1002         -
1003           columnname: item_enumchron
1004         -
1005           columnname: item_url
1006         -
1007           columnname: item_copy
1008         -
1009           columnname: item_status
1010         -
1011           columnname: item_notes
1012         -
1013           columnname: item_datedue
1014         -
1015           columnname: item_barcode
1016           is_hidden: 1
1017         -
1018           columnname: item_holds
1019         -
1020           columnname: item_priority
1021         -
1022           columnname: item_coursereserves
1023
1024       subscriptionst:
1025         -
1026           columnname: serial_serialseq
1027         -
1028           columnname: serial_publisheddate
1029         -
1030           columnname: serial_planneddate
1031         -
1032           columnname: serial_status
1033         -
1034           columnname: serial_notes
1035
1036   serials:
1037     subscription-detail:
1038       orders:
1039         -
1040           columnname: invoice
1041         -
1042           columnname: basket
1043         -
1044           columnname: ordernumber
1045         -
1046           columnname: creation_date
1047         -
1048           columnname: receive_date
1049         -
1050           columnname: status
1051         -
1052           columnname: order_internalnote
1053         -
1054           columnname: order_vendornote
1055         -
1056           columnname: fund
1057         -
1058           columnname: ordered
1059         -
1060           columnname: spent
1061
1062   tools:
1063     notices:
1064       lettert:
1065         -
1066           columnname: library
1067         -
1068           columnname: module
1069         -
1070           columnname: code
1071         -
1072           columnname: name
1073         -
1074           columnname: copy_notice
1075         -
1076           columnname: actions
1077           cannot_be_toggled: 1
1078           cannot_be_modified: 1
1079
1080     stockrotation:
1081       stock_rotation:
1082         -
1083           columnname: name
1084         -
1085           columnname: cyclical
1086         -
1087           columnname: active
1088         -
1089           columnname: description
1090         -
1091           columnname: number_of_items
1092         -
1093           columnname: actions
1094           cannot_be_toggled: 1
1095           cannot_be_modified: 1
1096
1097       stock_rotation_manage_items:
1098         -
1099           columnname: barcode
1100         -
1101           columnname: title
1102         -
1103           columnname: author
1104         -
1105           columnname: call_number
1106         -
1107           columnname: in_transit
1108         -
1109           columnname: stages
1110         -
1111           columnname: actions
1112           cannot_be_toggled: 1
1113           cannot_be_modified: 1