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