12 columnname: basket_creator
14 columnname: basket_group
16 columnname: invoice_number
24 columnname: received_on
26 columnname: quantity_received
28 columnname: pending_order
41 columnname: order_date
43 columnname: estimated_delivery_date
47 columnname: information
49 columnname: total_cost
53 columnname: basket_group
59 columnname: claims_count
61 columnname: claimed_date
65 columnname: basket_number
67 columnname: order_information
69 columnname: recommended_retail_price_tax_excluded
71 columnname: actual_cost_tax_excluded
73 columnname: budgeted_cost_price_tax_included
75 columnname: recommended_retail_price_tax_included
78 columnname: actual_cost_tax_included
81 columnname: budgeted_cost_tax_included
83 columnname: replacement_price
87 columnname: total_tax_excluded
89 columnname: total_tax_included
92 columnname: goods_and_services_tax_percentage
94 columnname: goods_and_services_tax
98 columnname: supplier_report
102 cannot_be_modified: 1
106 cannot_be_modified: 1
114 cannot_be_modified: 1
118 cannot_be_modified: 1
125 columnname: last_updated
136 columnname: category_name
140 columnname: enrollment_period
142 columnname: age_required
144 columnname: upper_age_limit
146 columnname: enrollment_fee
150 columnname: lost_items
154 columnname: messaging
156 columnname: branches_limitations
158 columnname: default_privacy
162 cannot_be_modified: 1
171 columnname: description
173 columnname: search_category
175 columnname: not_for_loan
177 columnname: hide_in_opac
179 columnname: rental_charge
181 columnname: daily_rental_charge
183 columnname: hourly_rental_charge
185 columnname: default_replacement_cost
187 columnname: lost_processing_fee
189 columnname: checkin_message
191 columnname: library_limitations
195 cannot_be_modified: 1
200 columnname: library_name
202 columnname: library_code
204 columnname: library_address
206 columnname: marc_organization_code
208 columnname: library_ip
210 columnname: is_pickup_location
214 cannot_be_modified: 1
219 acquisitiondetails-table:
225 columnname: basketgroup
229 columnname: ordernumber
231 columnname: creation_date
233 columnname: received_data
239 columnname: order_internalnote
241 columnname: subscription
243 columnname: subscription_callnumber
245 checkoutshistory-table:
249 cannot_be_modified: 1
253 cannot_be_modified: 1
255 columnname: checked_out_from
259 columnname: checkout_on
263 columnname: checkin_on
268 # NOTE: These columns are in the same order as kohastructure.sql, and contain all items
269 # columns except for the following internal/obsolete fields: stack, more_subfields_xml,
270 # cn_sort, permanent_location, damaged_on itemlost_on, withdrawn_on, issues, renewals and
275 columnname: dateaccessioned
277 columnname: booksellerid
279 columnname: homebranch
283 columnname: replacementprice
285 columnname: replacementpricedate
287 columnname: datelastborrowed
289 columnname: datelastseen
293 columnname: notforloan
299 columnname: withdrawn
301 columnname: itemcallnumber
303 columnname: coded_location_qualifier
305 columnname: restricted
307 columnname: itemnotes
309 columnname: itemnotes_nonpublic
311 columnname: holdingbranch
313 columnname: timestamp
319 columnname: cn_source
323 columnname: materials
329 columnname: enumchron
331 columnname: copynumber
333 columnname: stocknumber
354 cannot_be_modified: 1
358 course_reserves_table:
362 columnname: department
364 columnname: course_no
370 columnname: instructors
372 columnname: staff_note
374 columnname: public_note
376 columnname: no_of_students
381 course_reserves_table:
389 columnname: call_number
391 columnname: item_type
393 columnname: collection
399 columnname: staff_note
401 columnname: public_note
405 columnname: other_course_reserves
409 cannot_be_modified: 1
415 columnname: illrequest_id
417 columnname: metadata_author
419 columnname: metadata_title
421 columnname: metadata_article_title
423 columnname: metadata_issue
425 columnname: metadata_volume
427 columnname: metadata_year
429 columnname: metadata_pages
431 columnname: metadata_type
437 columnname: biblio_id
439 columnname: library_branchname
445 cannot_be_modified: 1
448 columnname: placed_formatted
452 cannot_be_modified: 1
455 columnname: updated_formatted
459 columnname: completed
461 cannot_be_modified: 1
464 columnname: completed_formatted
466 columnname: accessurl
472 columnname: notesopac
474 columnname: notesstaff
480 cannot_be_modified: 1
488 columnname: account_type
490 columnname: description
496 columnname: returndate
498 columnname: issuedate
504 cannot_be_modified: 1
506 columnname: amountoutstanding
508 cannot_be_modified: 1
512 cannot_be_modified: 1
519 cannot_be_modified: 1
523 cannot_be_modified: 1
525 columnname: account_type
527 columnname: description
535 columnname: returndate
537 columnname: issuedate
543 columnname: amountoutstanding
550 cannot_be_modified: 1
552 columnname: cardnumber
556 columnname: dateofbirth
562 columnname: expires_on
564 columnname: od_checkouts
568 columnname: circ_notes
572 cannot_be_modified: 1
577 columnname: sort_order
579 cannot_be_modified: 1
582 columnname: todays_or_previous_checkouts
584 cannot_be_modified: 1
587 columnname: due_date_unformatted
589 cannot_be_modified: 1
596 columnname: record_type
598 columnname: item_type
600 columnname: collection
604 columnname: homebranch
606 columnname: checkout_on_unformatted
608 cannot_be_modified: 1
611 columnname: checkout_on
613 columnname: checkout_from
625 cannot_be_modified: 1
629 columnname: claims_returned
633 cannot_be_modified: 1
640 cannot_be_modified: 1
648 columnname: reservedate
650 columnname: expirationdate
652 columnname: waitingdate
654 columnname: cancellationdate
661 checkouthistory-table:
664 cannot_be_modified: 1
672 columnname: call_number
676 columnname: number_of_renewals
678 columnname: checked_out_on
680 columnname: checked_out_from
684 columnname: return_date
691 cannot_be_modified: 1
695 columnname: firstname
705 columnname: expires_on
707 columnname: circ_notes
715 cannot_be_modified: 1
721 columnname: itemlost_on
725 columnname: callnumber
727 columnname: datelastseen
731 columnname: replacementprice
737 columnname: collection_code
739 columnname: current_location
743 columnname: notforloan
750 columnname: selection
752 cannot_be_modified: 1
754 columnname: report_id
756 cannot_be_modified: 1
758 columnname: report_name
770 columnname: creation_date
772 columnname: last_edit
780 columnname: cache_expiry
782 columnname: saved_results
788 cannot_be_modified: 1
794 columnname: sort_order
796 cannot_be_modified: 1
799 columnname: todays_or_previous_checkouts
801 cannot_be_modified: 1
804 columnname: due_date_unformatted
806 cannot_be_modified: 1
813 columnname: record_type
815 columnname: item_type
817 columnname: collection
821 columnname: homebranch
823 columnname: checkout_on_unformatted
825 cannot_be_modified: 1
828 columnname: checkout_on
830 columnname: checkout_from
842 cannot_be_modified: 1
846 columnname: claims_returned
850 cannot_be_modified: 1
856 cannot_be_modified: 1
858 columnname: cardnumber
860 columnname: date_of_birth
881 columnname: homelibrary
883 columnname: holdinglibrary
887 columnname: itemcallnumber
889 columnname: dateaccessioned
892 columnname: record_type
905 columnname: collection
907 columnname: document_type
909 columnname: callnumber
911 columnname: copynumber
913 columnname: enumeration
928 columnname: pull_items
930 columnname: avalaible_items
938 columnname: libraries
940 columnname: call_numbers
942 columnname: copy_numbers
944 columnname: enumeration
946 columnname: itemtypes
948 columnname: locations
950 columnname: hold_date
961 columnname: holds_ratio
965 columnname: home_libraries
967 columnname: holding_libraries
973 columnname: call_numbers
975 columnname: items_needed
977 holds_awaiting_pickup:
980 columnname: waiting_since
982 columnname: date_hold_placed
988 columnname: home_library
990 columnname: current_location
992 columnname: shelving_location
994 columnname: call_number
996 columnname: copy_number
998 columnname: enumeration
1004 columnname: waiting_since
1006 columnname: date_hold_placed
1012 columnname: home_library
1014 columnname: current_location
1016 columnname: shelving_location
1018 columnname: call_number
1020 columnname: copy_number
1022 columnname: enumeration
1029 columnname: due_date
1033 columnname: patron_category
1036 columnname: patron_library
1040 columnname: home_library
1043 columnname: holding_library
1048 columnname: call_number
1050 columnname: item_type
1055 columnname: non-public_note
1061 columnname: item_itemtype
1063 columnname: item_current_location
1065 columnname: item_home_location
1067 columnname: item_shelving_location
1070 columnname: item_ccode
1072 columnname: item_callnumber
1074 columnname: item_enumchron
1076 columnname: item_url
1078 columnname: item_copy
1080 columnname: item_status
1082 columnname: item_notes
1084 columnname: item_datedue
1086 columnname: item_barcode
1089 columnname: item_holds
1091 columnname: item_priority
1093 columnname: item_coursereserves
1097 columnname: serial_serialseq
1099 columnname: serial_publisheddate
1101 columnname: serial_planneddate
1103 columnname: serial_status
1105 columnname: serial_notes
1108 subscription-detail:
1115 columnname: ordernumber
1117 columnname: creation_date
1119 columnname: receive_date
1123 columnname: order_internalnote
1125 columnname: order_vendornote
1145 columnname: copy_notice
1148 cannot_be_toggled: 1
1149 cannot_be_modified: 1
1156 columnname: cyclical
1160 columnname: description
1162 columnname: number_of_items
1165 cannot_be_toggled: 1
1166 cannot_be_modified: 1
1168 stock_rotation_manage_items:
1176 columnname: call_number
1178 columnname: in_transit
1183 cannot_be_toggled: 1
1184 cannot_be_modified: 1