| blob | 2235aff561d595c520f6e73765f9f93556a7aa35 |
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 catalogue:
128 detail:
129 acquisitiondetails-table:
130 -
131 columnname: vendor
132 -
133 columnname: invoice
134 -
135 columnname: basketgroup
136 -
137 columnname: basket
138 -
139 columnname: ordernumber
140 -
141 columnname: creation_date
142 -
143 columnname: received_data
144 -
145 columnname: status
146 -
147 columnname: quantity
148 -
149 columnname: subscription
150 -
151 columnname: subscription_callnumber
153 checkoutshistory-table:
154 -
155 columnname: patron
156 cannot_be_toggled: 1
157 cannot_be_modified: 1
158 -
159 columnname: barcode
160 cannot_be_toggled: 1
161 cannot_be_modified: 1
162 -
163 columnname: checked_out_from
164 -
165 columnname: renewed
166 -
167 columnname: checkout_on
168 -
169 columnname: due_date
170 -
171 columnname: checkin_on
173 cataloguing:
174 additem:
175 itemst:
176 # NOTE: These columns are in the same order as kohastructure.sql, and contain all items
177 # columns except for the following internal/obsolete fields: stack, more_subfields_xml,
178 # cn_sort, permanent_location, damaged_on itemlost_on, withdrawn_on, issues, renewals and
179 # reserves.
180 -
181 columnname: barcode
182 -
183 columnname: dateaccessioned
184 -
185 columnname: booksellerid
186 -
187 columnname: homebranch
188 -
189 columnname: price
190 -
191 columnname: replacementprice
192 -
193 columnname: replacementpricedate
194 -
195 columnname: datelastborrowed
196 -
197 columnname: datelastseen
198 -
199 columnname: stack
200 -
201 columnname: notforloan
202 -
203 columnname: damaged
204 -
205 columnname: itemlost
206 -
207 columnname: withdrawn
208 -
209 columnname: itemcallnumber
210 -
211 columnname: coded_location_qualifier
212 -
213 columnname: restricted
214 -
215 columnname: itemnotes
216 -
217 columnname: itemnotes_nonpublic
218 -
219 columnname: holdingbranch
220 -
221 columnname: paidfor
222 -
223 columnname: timestamp
224 -
225 columnname: location
226 -
227 columnname: onloan
228 -
229 columnname: cn_source
230 -
231 columnname: ccode
232 -
233 columnname: materials
234 -
235 columnname: uri
236 -
237 columnname: itype
238 -
239 columnname: enumchron
240 -
241 columnname: copynumber
242 -
243 columnname: stocknumber
245 coursereserves:
246 courses:
247 course_reserves_table:
248 -
249 columnname: name
250 -
251 columnname: department
252 -
253 columnname: course_no
254 -
255 columnname: section
256 -
257 columnname: term
258 -
259 columnname: instructors
260 -
261 columnname: staff_note
262 -
263 columnname: public_note
264 -
265 columnname: no_of_students
266 -
267 columnname: enabled
269 reserves:
270 course_reserves_table:
271 -
272 columnname: title
273 -
274 columnname: author
275 -
276 columnname: barcode
277 -
278 columnname: call_number
279 -
280 columnname: item_type
281 -
282 columnname: collection
283 -
284 columnname: location
285 -
286 columnname: library
287 -
288 columnname: staff_note
289 -
290 columnname: public_note
291 -
292 columnname: link
293 -
294 columnname: other_course_reserves
295 -
296 columnname: actions
297 cannot_be_toggled: 1
298 cannot_be_modified: 1
300 members:
301 fines:
302 account-fines:
303 -
304 columnname: date
305 -
306 columnname: description
307 -
308 columnname: note
309 -
310 columnname: amount
311 cannot_be_toggled: 1
312 cannot_be_modified: 1
313 -
314 columnname: amountoutstanding
315 cannot_be_toggled: 1
316 cannot_be_modified: 1
317 -
318 columnname: actions
319 cannot_be_toggled: 1
320 cannot_be_modified: 1
322 member:
323 memberresultst:
324 -
325 columnname: checkbox
326 cannot_be_toggled: 1
327 cannot_be_modified: 1
328 -
329 columnname: cardnumber
330 -
331 columnname: name
332 -
333 columnname: dateofbirth
334 -
335 columnname: category
336 -
337 columnname: library
338 -
339 columnname: expires_on
340 -
341 columnname: od_checkouts
342 -
343 columnname: fines
344 -
345 columnname: circ_notes
346 -
347 columnname: actions
348 cannot_be_toggled: 1
349 cannot_be_modified: 1
351 moremember:
352 issues-table:
353 -
354 columnname: sort_order
355 cannot_be_toggled: 1
356 cannot_be_modified: 1
357 is_hidden: 1
358 -
359 columnname: todays_or_previous_checkouts
360 cannot_be_toggled: 1
361 cannot_be_modified: 1
362 is_hidden: 1
363 -
364 columnname: due_date_unformatted
365 cannot_be_toggled: 1
366 cannot_be_modified: 1
367 is_hidden: 1
368 -
369 columnname: due_date
370 -
371 columnname: title
372 -
373 columnname: item_type
374 -
375 columnname: collection
376 -
377 columnname: location
378 -
379 columnname: homebranch
380 -
381 columnname: checkout_on_unformatted
382 cannot_be_toggled: 1
383 cannot_be_modified: 1
384 is_hidden: 1
385 -
386 columnname: checkout_on
387 -
388 columnname: checkout_from
389 -
390 columnname: callno
391 -
392 columnname: charge
393 -
394 columnname: fine
395 -
396 columnname: price
397 -
398 columnname: renew
399 cannot_be_toggled: 1
400 cannot_be_modified: 1
401 -
402 columnname: checkin
403 -
404 columnname: export
405 cannot_be_toggled: 1
406 cannot_be_modified: 1
408 holdshistory:
409 holdshistory-table:
410 -
411 columnname: title
412 cannot_be_toggled: 1
413 cannot_be_modified: 1
414 -
415 columnname: author
416 -
417 columnname: barcode
418 -
419 columnname: branch
420 -
421 columnname: reservedate
422 -
423 columnname: expirationdate
424 -
425 columnname: waitingdate
426 -
427 columnname: cancellationdate
428 -
429 columnname: itemtype
430 -
431 columnname: status
433 reports:
434 lostitems:
435 lostitems-table:
436 -
437 columnname: title
438 cannot_be_toggled: 1
439 cannot_be_modified: 1
440 -
441 columnname: author
442 -
443 columnname: lostcode
444 -
445 columnname: itemlost_on
446 -
447 columnname: barcode
448 -
449 columnname: callnumber
450 -
451 columnname: datelastseen
452 -
453 columnname: price
454 -
455 columnname: replacementprice
456 -
457 columnname: library
458 -
459 columnname: itemtype
460 -
461 columnname: current_location
462 -
463 columnname: location
464 -
465 columnname: notforloan
466 -
467 columnname: notes
469 saved-sql:
470 table_reports:
471 -
472 columnname: selection
473 cannot_be_toggled: 1
474 cannot_be_modified: 1
475 -
476 columnname: report_id
477 cannot_be_toggled: 1
478 cannot_be_modified: 1
479 -
480 columnname: report_name
481 -
482 columnname: type
483 -
484 columnname: group
485 -
486 columnname: subgroup
487 -
488 columnname: notes
489 -
490 columnname: author
491 -
492 columnname: creation_date
493 -
494 columnname: last_edit
495 -
496 columnname: last_run
497 -
498 columnname: public
499 -
500 columnname: json_url
501 -
502 columnname: cache_expiry
503 -
504 columnname: saved_results
505 -
506 columnname: update
507 -
508 columnname: actions
509 cannot_be_toggled: 1
510 cannot_be_modified: 1
512 circ:
513 circulation:
514 issues-table:
515 -
516 columnname: sort_order
517 cannot_be_toggled: 1
518 cannot_be_modified: 1
519 is_hidden: 1
520 -
521 columnname: todays_or_previous_checkouts
522 cannot_be_toggled: 1
523 cannot_be_modified: 1
524 is_hidden: 1
525 -
526 columnname: due_date_unformatted
527 cannot_be_toggled: 1
528 cannot_be_modified: 1
529 is_hidden: 1
530 -
531 columnname: due_date
532 -
533 columnname: title
534 -
535 columnname: item_type
536 -
537 columnname: collection
538 -
539 columnname: location
540 -
541 columnname: homebranch
542 -
543 columnname: checkout_on_unformatted
544 cannot_be_toggled: 1
545 cannot_be_modified: 1
546 is_hidden: 1
547 -
548 columnname: checkout_on
549 -
550 columnname: checkout_from
551 -
552 columnname: callno
553 -
554 columnname: charge
555 -
556 columnname: fine
557 -
558 columnname: price
559 -
560 columnname: renew
561 cannot_be_toggled: 1
562 cannot_be_modified: 1
563 -
564 columnname: checkin
565 -
566 columnname: export
567 cannot_be_toggled: 1
568 cannot_be_modified: 1
570 returns:
571 checkedintable:
572 -
573 columnname: due_date
574 -
575 columnname: title
576 -
577 columnname: author
578 -
579 columnname: barcode
580 -
581 columnname: homelibrary
582 -
583 columnname: holdinglibrary
584 -
585 columnname: location
586 -
587 columnname: itemcallnumber
588 -
589 columnname: dateaccessioned
590 is_hidden: 1
591 -
592 columnname: itype
593 -
594 columnname: borrower
595 -
596 columnname: itemnote
598 view_holdsqueue:
599 holds-table:
600 -
601 columnname: title
602 -
603 columnname: collection
604 -
605 columnname: document_type
606 -
607 columnname: callnumber
608 -
609 columnname: copynumber
610 -
611 columnname: enumeration
612 -
613 columnname: barcode
614 -
615 columnname: patron
616 -
617 columnname: send_to
618 -
619 columnname: date
620 -
621 columnname: notes
623 holds:
624 holds-to-pull:
625 -
626 columnname: pull_items
627 -
628 columnname: avalaible_items
629 -
630 columnname: patrons
631 -
632 columnname: patron
633 -
634 columnname: title
635 -
636 columnname: libraries
637 -
638 columnname: call_numbers
639 -
640 columnname: copy_numbers
641 -
642 columnname: enumeration
643 -
644 columnname: itemtypes
645 -
646 columnname: locations
647 -
648 columnname: hold_date
649 -
650 columnname: action
652 opac:
653 biblio-detail:
654 holdingst:
655 -
656 columnname: item_itemtype
657 -
658 columnname: item_current_location
659 -
660 columnname: item_home_location
661 -
662 columnname: item_shelving_location
663 is_hidden: 1
664 -
665 columnname: item_ccode
666 -
667 columnname: item_callnumber
668 -
669 columnname: item_enumchron
670 -
671 columnname: item_url
672 -
673 columnname: item_copy
674 -
675 columnname: item_status
676 -
677 columnname: item_notes
678 -
679 columnname: item_datedue
680 -
681 columnname: item_barcode
682 is_hidden: 1
683 -
684 columnname: item_holds
685 -
686 columnname: item_priority
687 -
688 columnname: item_coursereserves
690 subscriptionst:
691 -
692 columnname: serial_serialseq
693 -
694 columnname: serial_publisheddate
695 -
696 columnname: serial_planneddate
697 -
698 columnname: serial_status
699 -
700 columnname: serial_notes
702 serials:
703 subscription-detail:
704 orders:
705 -
706 columnname: invoice
707 -
708 columnname: basket
709 -
710 columnname: ordernumber
711 -
712 columnname: creation_date
713 -
714 columnname: receive_date
715 -
716 columnname: status
717 -
718 columnname: order_internalnote
719 -
720 columnname: order_vendornote
721 -
722 columnname: fund
723 -
724 columnname: ordered
725 -
726 columnname: spent
728 tools:
729 notices:
730 lettert:
731 -
732 columnname: library
733 -
734 columnname: module
735 -
736 columnname: code
737 -
738 columnname: name
739 -
740 columnname: copy_notice
741 -
742 columnname: actions
743 cannot_be_toggled: 1
744 cannot_be_modified: 1