| blob | 1ea975dce2c34821ad41687123964f4c7271a7b8 |
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 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
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
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
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: timestamp
277 -
278 columnname: location
279 -
280 columnname: onloan
281 -
282 columnname: cn_source
283 -
284 columnname: ccode
285 -
286 columnname: materials
287 -
288 columnname: uri
289 -
290 columnname: itype
291 -
292 columnname: enumchron
293 -
294 columnname: copynumber
295 -
296 columnname: stocknumber
298 z3950_search:
299 resultst:
300 -
301 columnname: server
302 -
303 columnname: title
304 -
305 columnname: author
306 -
307 columnname: date
308 -
309 columnname: edition
310 -
311 columnname: isbn
312 -
313 columnname: lccn
314 -
315 columnname: actions
316 cannot_be_toggled: 1
317 cannot_be_modified: 1
319 coursereserves:
320 courses:
321 course_reserves_table:
322 -
323 columnname: name
324 -
325 columnname: department
326 -
327 columnname: course_no
328 -
329 columnname: section
330 -
331 columnname: term
332 -
333 columnname: instructors
334 -
335 columnname: staff_note
336 -
337 columnname: public_note
338 -
339 columnname: no_of_students
340 -
341 columnname: enabled
343 reserves:
344 course_reserves_table:
345 -
346 columnname: title
347 -
348 columnname: author
349 -
350 columnname: barcode
351 -
352 columnname: call_number
353 -
354 columnname: item_type
355 -
356 columnname: collection
357 -
358 columnname: location
359 -
360 columnname: library
361 -
362 columnname: staff_note
363 -
364 columnname: public_note
365 -
366 columnname: link
367 -
368 columnname: other_course_reserves
369 -
370 columnname: actions
371 cannot_be_toggled: 1
372 cannot_be_modified: 1
374 illrequests:
375 ill-requests:
376 ill-requests:
377 -
378 columnname: illrequest_id
379 -
380 columnname: metadata_author
381 -
382 columnname: metadata_title
383 -
384 columnname: metadata_article_title
385 -
386 columnname: metadata_issue
387 -
388 columnname: metadata_volume
389 -
390 columnname: metadata_year
391 -
392 columnname: metadata_pages
393 -
394 columnname: metadata_type
395 -
396 columnname: orderid
397 -
398 columnname: patron
399 -
400 columnname: biblio_id
401 -
402 columnname: library_branchname
403 -
404 columnname: status
405 -
406 columnname: placed
407 cannot_be_toggled: 1
408 cannot_be_modified: 1
409 is_hidden: 1
410 -
411 columnname: placed_formatted
412 -
413 columnname: updated
414 cannot_be_toggled: 1
415 cannot_be_modified: 1
416 is_hidden: 1
417 -
418 columnname: updated_formatted
419 -
420 columnname: replied
421 -
422 columnname: completed
423 cannot_be_toggled: 1
424 cannot_be_modified: 1
425 is_hidden: 1
426 -
427 columnname: completed_formatted
428 -
429 columnname: accessurl
430 -
431 columnname: cost
432 -
433 columnname: comments
434 -
435 columnname: notesopac
436 -
437 columnname: notesstaff
438 -
439 columnname: backend
440 -
441 columnname: action
442 cannot_be_toggled: 1
443 cannot_be_modified: 1
445 members:
446 fines:
447 account-fines:
448 -
449 columnname: date
450 -
451 columnname: description
452 -
453 columnname: barcode
454 -
455 columnname: date_due
456 -
457 columnname: returndate
458 -
459 columnname: note
460 -
461 columnname: amount
462 cannot_be_toggled: 1
463 cannot_be_modified: 1
464 -
465 columnname: amountoutstanding
466 cannot_be_toggled: 1
467 cannot_be_modified: 1
468 -
469 columnname: actions
470 cannot_be_toggled: 1
471 cannot_be_modified: 1
473 pay:
474 pay-fines-table:
475 -
476 columnname: checkbox
477 cannot_be_toggled: 1
478 cannot_be_modified: 1
479 -
480 columnname: actions
481 cannot_be_toggled: 1
482 cannot_be_modified: 1
483 -
484 columnname: description
485 -
486 columnname: date
487 -
488 columnname: barcode
489 -
490 columnname: date_due
491 -
492 columnname: returndate
493 -
494 columnname: note
495 -
496 columnname: account_type
497 -
498 columnname: amount
499 -
500 columnname: amountoutstanding
502 member:
503 memberresultst:
504 -
505 columnname: checkbox
506 cannot_be_toggled: 1
507 cannot_be_modified: 1
508 -
509 columnname: cardnumber
510 -
511 columnname: name
512 -
513 columnname: dateofbirth
514 -
515 columnname: category
516 -
517 columnname: library
518 -
519 columnname: expires_on
520 -
521 columnname: od_checkouts
522 -
523 columnname: fines
524 -
525 columnname: circ_notes
526 -
527 columnname: actions
528 cannot_be_toggled: 1
529 cannot_be_modified: 1
531 moremember:
532 issues-table:
533 -
534 columnname: sort_order
535 cannot_be_toggled: 1
536 cannot_be_modified: 1
537 is_hidden: 1
538 -
539 columnname: todays_or_previous_checkouts
540 cannot_be_toggled: 1
541 cannot_be_modified: 1
542 is_hidden: 1
543 -
544 columnname: due_date_unformatted
545 cannot_be_toggled: 1
546 cannot_be_modified: 1
547 is_hidden: 1
548 -
549 columnname: due_date
550 -
551 columnname: title
552 -
553 columnname: item_type
554 -
555 columnname: collection
556 -
557 columnname: location
558 -
559 columnname: homebranch
560 -
561 columnname: checkout_on_unformatted
562 cannot_be_toggled: 1
563 cannot_be_modified: 1
564 is_hidden: 1
565 -
566 columnname: checkout_on
567 -
568 columnname: checkout_from
569 -
570 columnname: callno
571 -
572 columnname: charge
573 -
574 columnname: fine
575 -
576 columnname: price
577 -
578 columnname: renew
579 cannot_be_toggled: 1
580 cannot_be_modified: 1
581 -
582 columnname: checkin
583 -
584 columnname: export
585 cannot_be_toggled: 1
586 cannot_be_modified: 1
588 holdshistory:
589 holdshistory-table:
590 -
591 columnname: title
592 cannot_be_toggled: 1
593 cannot_be_modified: 1
594 -
595 columnname: author
596 -
597 columnname: barcode
598 -
599 columnname: branch
600 -
601 columnname: reservedate
602 -
603 columnname: expirationdate
604 -
605 columnname: waitingdate
606 -
607 columnname: cancellationdate
608 -
609 columnname: itemtype
610 -
611 columnname: status
613 checkouthistory:
614 checkouthistory-table:
615 - columnname: type
616 cannot_be_toggled: 1
617 cannot_be_modified: 1
618 -
619 columnname: date
620 -
621 columnname: title
622 -
623 columnname: author
624 -
625 columnname: call_number
626 -
627 columnname: barcode
628 -
629 columnname: number_of_renewals
630 -
631 columnname: checked_out_on
632 -
633 columnname: checked_out_from
634 -
635 columnname: date_due
636 -
637 columnname: return_date
639 patron-lists:
640 patron-list-table:
641 -
642 columnname: checkbox
643 cannot_be_toggled: 1
644 cannot_be_modified: 1
645 -
646 columnname: card
647 -
648 columnname: firstname
649 -
650 columnname: surname
651 -
652 columnname: address
653 -
654 columnname: category
655 -
656 columnname: library
657 -
658 columnname: expires_on
659 -
660 columnname: circ_notes
662 reports:
663 lostitems:
664 lostitems-table:
665 -
666 columnname: title
667 cannot_be_toggled: 1
668 cannot_be_modified: 1
669 -
670 columnname: author
671 -
672 columnname: lostcode
673 -
674 columnname: itemlost_on
675 -
676 columnname: barcode
677 -
678 columnname: callnumber
679 -
680 columnname: datelastseen
681 -
682 columnname: price
683 -
684 columnname: replacementprice
685 -
686 columnname: library
687 -
688 columnname: itemtype
689 -
690 columnname: collection_code
691 -
692 columnname: current_location
693 -
694 columnname: location
695 -
696 columnname: notforloan
697 -
698 columnname: notes
700 saved-sql:
701 table_reports:
702 -
703 columnname: selection
704 cannot_be_toggled: 1
705 cannot_be_modified: 1
706 -
707 columnname: report_id
708 cannot_be_toggled: 1
709 cannot_be_modified: 1
710 -
711 columnname: report_name
712 -
713 columnname: type
714 -
715 columnname: group
716 -
717 columnname: subgroup
718 -
719 columnname: notes
720 -
721 columnname: author
722 -
723 columnname: creation_date
724 -
725 columnname: last_edit
726 -
727 columnname: last_run
728 -
729 columnname: public
730 -
731 columnname: json_url
732 -
733 columnname: cache_expiry
734 -
735 columnname: saved_results
736 -
737 columnname: update
738 -
739 columnname: actions
740 cannot_be_toggled: 1
741 cannot_be_modified: 1
743 circ:
744 circulation:
745 issues-table:
746 -
747 columnname: sort_order
748 cannot_be_toggled: 1
749 cannot_be_modified: 1
750 is_hidden: 1
751 -
752 columnname: todays_or_previous_checkouts
753 cannot_be_toggled: 1
754 cannot_be_modified: 1
755 is_hidden: 1
756 -
757 columnname: due_date_unformatted
758 cannot_be_toggled: 1
759 cannot_be_modified: 1
760 is_hidden: 1
761 -
762 columnname: due_date
763 -
764 columnname: title
765 -
766 columnname: item_type
767 -
768 columnname: collection
769 -
770 columnname: location
771 -
772 columnname: homebranch
773 -
774 columnname: checkout_on_unformatted
775 cannot_be_toggled: 1
776 cannot_be_modified: 1
777 is_hidden: 1
778 -
779 columnname: checkout_on
780 -
781 columnname: checkout_from
782 -
783 columnname: callno
784 -
785 columnname: charge
786 -
787 columnname: fine
788 -
789 columnname: price
790 -
791 columnname: renew
792 cannot_be_toggled: 1
793 cannot_be_modified: 1
794 -
795 columnname: checkin
796 -
797 columnname: export
798 cannot_be_toggled: 1
799 cannot_be_modified: 1
800 table_borrowers:
801 -
802 columnname: name
803 cannot_be_toggled: 1
804 cannot_be_modified: 1
805 -
806 columnname: cardnumber
807 -
808 columnname: date_of_birth
809 -
810 columnname: category
811 -
812 columnname: library
813 -
814 columnname: address
815 -
816 columnname: phone
817 is_hidden: 1
818 returns:
819 checkedintable:
820 -
821 columnname: due_date
822 -
823 columnname: title
824 -
825 columnname: author
826 -
827 columnname: barcode
828 -
829 columnname: homelibrary
830 -
831 columnname: holdinglibrary
832 -
833 columnname: location
834 -
835 columnname: itemcallnumber
836 -
837 columnname: dateaccessioned
838 is_hidden: 1
839 -
840 columnname: itype
841 -
842 columnname: borrower
843 -
844 columnname: itemnote
846 view_holdsqueue:
847 holds-table:
848 -
849 columnname: title
850 -
851 columnname: collection
852 -
853 columnname: document_type
854 -
855 columnname: callnumber
856 -
857 columnname: copynumber
858 -
859 columnname: enumeration
860 -
861 columnname: barcode
862 -
863 columnname: patron
864 -
865 columnname: send_to
866 -
867 columnname: date
868 -
869 columnname: notes
871 holds:
872 holds-to-pull:
873 -
874 columnname: pull_items
875 -
876 columnname: avalaible_items
877 -
878 columnname: patrons
879 -
880 columnname: patron
881 -
882 columnname: title
883 -
884 columnname: libraries
885 -
886 columnname: call_numbers
887 -
888 columnname: copy_numbers
889 -
890 columnname: enumeration
891 -
892 columnname: itemtypes
893 -
894 columnname: locations
895 -
896 columnname: hold_date
897 -
898 columnname: action
900 holdsratios:
901 holds-ratios:
902 -
903 columnname: holds
904 -
905 columnname: items
906 -
907 columnname: holds_ratio
908 -
909 columnname: title
910 -
911 columnname: home_libraries
912 -
913 columnname: holding_libraries
914 -
915 columnname: location
916 -
917 columnname: itemtype
918 -
919 columnname: call_numbers
920 -
921 columnname: items_needed
923 overdues:
924 circ-overdues:
925 -
926 columnname: due_date
927 -
928 columnname: patron
929 -
930 columnname: patron_category
931 is_hidden: 1
932 -
933 columnname: patron_library
934 -
935 columnname: title
936 -
937 columnname: home_library
938 is_hidden: 1
939 -
940 columnname: holding_library
941 is_hidden: 1
942 -
943 columnname: barcode
944 -
945 columnname: call_number
946 -
947 columnname: item_type
948 is_hidden: 1
949 -
950 columnname: price
951 -
952 columnname: non-public_note
954 opac:
955 biblio-detail:
956 holdingst:
957 -
958 columnname: item_itemtype
959 -
960 columnname: item_current_location
961 -
962 columnname: item_home_location
963 -
964 columnname: item_shelving_location
965 is_hidden: 1
966 -
967 columnname: item_ccode
968 -
969 columnname: item_callnumber
970 -
971 columnname: item_enumchron
972 -
973 columnname: item_url
974 -
975 columnname: item_copy
976 -
977 columnname: item_status
978 -
979 columnname: item_notes
980 -
981 columnname: item_datedue
982 -
983 columnname: item_barcode
984 is_hidden: 1
985 -
986 columnname: item_holds
987 -
988 columnname: item_priority
989 -
990 columnname: item_coursereserves
992 subscriptionst:
993 -
994 columnname: serial_serialseq
995 -
996 columnname: serial_publisheddate
997 -
998 columnname: serial_planneddate
999 -
1000 columnname: serial_status
1001 -
1002 columnname: serial_notes
1004 serials:
1005 subscription-detail:
1006 orders:
1007 -
1008 columnname: invoice
1009 -
1010 columnname: basket
1011 -
1012 columnname: ordernumber
1013 -
1014 columnname: creation_date
1015 -
1016 columnname: receive_date
1017 -
1018 columnname: status
1019 -
1020 columnname: order_internalnote
1021 -
1022 columnname: order_vendornote
1023 -
1024 columnname: fund
1025 -
1026 columnname: ordered
1027 -
1028 columnname: spent
1030 tools:
1031 notices:
1032 lettert:
1033 -
1034 columnname: library
1035 -
1036 columnname: module
1037 -
1038 columnname: code
1039 -
1040 columnname: name
1041 -
1042 columnname: copy_notice
1043 -
1044 columnname: actions
1045 cannot_be_toggled: 1
1046 cannot_be_modified: 1
1048 stockrotation:
1049 stock_rotation:
1050 -
1051 columnname: name
1052 -
1053 columnname: cyclical
1054 -
1055 columnname: active
1056 -
1057 columnname: description
1058 -
1059 columnname: number_of_items
1060 -
1061 columnname: actions
1062 cannot_be_toggled: 1
1063 cannot_be_modified: 1
1065 stock_rotation_manage_items:
1066 -
1067 columnname: barcode
1068 -
1069 columnname: title
1070 -
1071 columnname: author
1072 -
1073 columnname: call_number
1074 -
1075 columnname: in_transit
1076 -
1077 columnname: stages
1078 -
1079 columnname: actions
1080 cannot_be_toggled: 1
1081 cannot_be_modified: 1