| blob | 4b8600367c96cb42d3052a8a6eae2605b8e4506e |
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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