| blob | eacc02bdd80d1915c6f87e2da016093d7d794ac9 |
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
382 -
383 columnname: checkout_from
384 -
385 columnname: callno
386 -
387 columnname: charge
388 -
389 columnname: fine
390 -
391 columnname: price
392 -
393 columnname: renew
394 cannot_be_toggled: 1
395 cannot_be_modified: 1
396 -
397 columnname: checkin
398 -
399 columnname: export
400 cannot_be_toggled: 1
401 cannot_be_modified: 1
403 holdshistory:
404 holdshistory-table:
405 -
406 columnname: title
407 cannot_be_toggled: 1
408 cannot_be_modified: 1
409 -
410 columnname: author
411 -
412 columnname: barcode
413 -
414 columnname: branch
415 -
416 columnname: reservedate
417 -
418 columnname: expirationdate
419 -
420 columnname: waitingdate
421 -
422 columnname: cancellationdate
423 -
424 columnname: itemtype
425 -
426 columnname: status
428 reports:
429 lostitems:
430 lostitems-table:
431 -
432 columnname: title
433 cannot_be_toggled: 1
434 cannot_be_modified: 1
435 -
436 columnname: author
437 -
438 columnname: lostcode
439 -
440 columnname: itemlost_on
441 -
442 columnname: barcode
443 -
444 columnname: callnumber
445 -
446 columnname: datelastseen
447 -
448 columnname: price
449 -
450 columnname: replacementprice
451 -
452 columnname: library
453 -
454 columnname: itemtype
455 -
456 columnname: current_location
457 -
458 columnname: location
459 -
460 columnname: notforloan
461 -
462 columnname: notes
464 saved-sql:
465 table_reports:
466 -
467 columnname: selection
468 cannot_be_toggled: 1
469 cannot_be_modified: 1
470 -
471 columnname: report_id
472 cannot_be_toggled: 1
473 cannot_be_modified: 1
474 -
475 columnname: report_name
476 -
477 columnname: type
478 -
479 columnname: group
480 -
481 columnname: subgroup
482 -
483 columnname: notes
484 -
485 columnname: author
486 -
487 columnname: creation_date
488 -
489 columnname: last_edit
490 -
491 columnname: last_run
492 -
493 columnname: public
494 -
495 columnname: json_url
496 -
497 columnname: cache_expiry
498 -
499 columnname: saved_results
500 -
501 columnname: update
502 -
503 columnname: actions
504 cannot_be_toggled: 1
505 cannot_be_modified: 1
507 circ:
508 circulation:
509 issues-table:
510 -
511 columnname: sort_order
512 cannot_be_toggled: 1
513 cannot_be_modified: 1
514 is_hidden: 1
515 -
516 columnname: todays_or_previous_checkouts
517 cannot_be_toggled: 1
518 cannot_be_modified: 1
519 is_hidden: 1
520 -
521 columnname: due_date_unformatted
522 cannot_be_toggled: 1
523 cannot_be_modified: 1
524 is_hidden: 1
525 -
526 columnname: due_date
527 -
528 columnname: title
529 -
530 columnname: item_type
531 -
532 columnname: collection
533 -
534 columnname: location
535 -
536 columnname: homebranch
537 -
538 columnname: checkout_on_unformatted
539 cannot_be_toggled: 1
540 cannot_be_modified: 1
541 is_hidden: 1
542 -
543 columnname: checkout_on
544 -
545 columnname: checkout_from
546 -
547 columnname: callno
548 -
549 columnname: charge
550 -
551 columnname: fine
552 -
553 columnname: price
554 -
555 columnname: renew
556 cannot_be_toggled: 1
557 cannot_be_modified: 1
558 -
559 columnname: checkin
560 -
561 columnname: export
562 cannot_be_toggled: 1
563 cannot_be_modified: 1
565 returns:
566 checkedintable:
567 -
568 columnname: due_date
569 -
570 columnname: title
571 -
572 columnname: author
573 -
574 columnname: barcode
575 -
576 columnname: homelibrary
577 -
578 columnname: holdinglibrary
579 -
580 columnname: location
581 -
582 columnname: itemcallnumber
583 -
584 columnname: dateaccessioned
585 is_hidden: 1
586 -
587 columnname: itype
588 -
589 columnname: borrower
590 -
591 columnname: itemnote
593 view_holdsqueue:
594 holds-table:
595 -
596 columnname: title
597 -
598 columnname: collection
599 -
600 columnname: document_type
601 -
602 columnname: callnumber
603 -
604 columnname: copynumber
605 -
606 columnname: enumeration
607 -
608 columnname: barcode
609 -
610 columnname: patron
611 -
612 columnname: send_to
613 -
614 columnname: date
615 -
616 columnname: notes
618 holds:
619 holds-to-pull:
620 -
621 columnname: pull_items
622 -
623 columnname: avalaible_items
624 -
625 columnname: patrons
626 -
627 columnname: patron
628 -
629 columnname: title
630 -
631 columnname: libraries
632 -
633 columnname: call_numbers
634 -
635 columnname: copy_numbers
636 -
637 columnname: enumeration
638 -
639 columnname: itemtypes
640 -
641 columnname: locations
642 -
643 columnname: hold_date
644 -
645 columnname: action
647 opac:
648 biblio-detail:
649 holdingst:
650 -
651 columnname: item_itemtype
652 -
653 columnname: item_current_location
654 -
655 columnname: item_home_location
656 -
657 columnname: item_shelving_location
658 is_hidden: 1
659 -
660 columnname: item_ccode
661 -
662 columnname: item_callnumber
663 -
664 columnname: item_enumchron
665 -
666 columnname: item_url
667 -
668 columnname: item_copy
669 -
670 columnname: item_status
671 -
672 columnname: item_notes
673 -
674 columnname: item_datedue
675 -
676 columnname: item_barcode
677 is_hidden: 1
678 -
679 columnname: item_holds
680 -
681 columnname: item_priority
682 -
683 columnname: item_coursereserves
685 subscriptionst:
686 -
687 columnname: serial_serialseq
688 -
689 columnname: serial_publisheddate
690 -
691 columnname: serial_planneddate
692 -
693 columnname: serial_status
694 -
695 columnname: serial_notes
697 serials:
698 subscription-detail:
699 orders:
700 -
701 columnname: invoice
702 -
703 columnname: basket
704 -
705 columnname: ordernumber
706 -
707 columnname: creation_date
708 -
709 columnname: receive_date
710 -
711 columnname: status
712 -
713 columnname: order_internalnote
714 -
715 columnname: order_vendornote
716 -
717 columnname: fund
718 -
719 columnname: ordered
720 -
721 columnname: spent
723 tools:
724 notices:
725 lettert:
726 -
727 columnname: library
728 -
729 columnname: module
730 -
731 columnname: code
732 -
733 columnname: name
734 -
735 columnname: copy_notice
736 -
737 columnname: actions
738 cannot_be_toggled: 1
739 cannot_be_modified: 1