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