| blob | 19e0bebb3cf832c75033a77eee5e71b3a4e40033 |
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_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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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