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_line
43 columnname: order_date
45 columnname: estimated_delivery_date
49 columnname: information
51 columnname: total_cost
55 columnname: basket_group
61 columnname: claims_count
63 columnname: claimed_date
65 columnname: internal_note
67 columnname: vendor_note
74 columnname: basket_number
76 columnname: order_information
78 columnname: recommended_retail_price_tax_excluded
80 columnname: ecost_tax_excluded
82 columnname: recommended_retail_price_tax_included
85 columnname: ecost_tax_included
88 columnname: replacement_price
92 columnname: total_tax_excluded
94 columnname: total_tax_included
97 columnname: goods_and_services_tax_percentage
99 columnname: goods_and_services_tax
103 columnname: supplier_report
107 cannot_be_modified: 1
111 cannot_be_modified: 1
116 columnname: selections
118 cannot_be_modified: 1
120 columnname: suggestion
122 columnname: suggested_by
124 columnname: suggested_on
126 columnname: managed_by
128 columnname: managed_on
132 columnname: library_fund
134 columnname: suggestion_status
138 cannot_be_modified: 1
146 cannot_be_modified: 1
150 cannot_be_modified: 1
157 columnname: last_updated
168 columnname: category_name
172 columnname: enrollment_period
174 columnname: age_required
176 columnname: upper_age_limit
178 columnname: enrollment_fee
182 columnname: lost_items
186 columnname: messaging
188 columnname: branches_limitations
190 columnname: default_privacy
194 cannot_be_modified: 1
203 columnname: description
205 columnname: search_category
207 columnname: not_for_loan
209 columnname: hide_in_opac
211 columnname: rental_charge
213 columnname: daily_rental_charge
215 columnname: hourly_rental_charge
217 columnname: default_replacement_cost
219 columnname: lost_processing_fee
221 columnname: checkin_message
223 columnname: library_limitations
227 cannot_be_modified: 1
232 columnname: library_name
234 columnname: library_code
236 columnname: library_address
238 columnname: marc_organization_code
240 columnname: library_ip
242 columnname: is_pickup_location
246 cannot_be_modified: 1
251 acquisitiondetails-table:
257 columnname: basketgroup
261 columnname: ordernumber
263 columnname: creation_date
265 columnname: received_data
271 columnname: order_internalnote
273 columnname: subscription
275 columnname: subscription_callnumber
277 checkoutshistory-table:
281 cannot_be_modified: 1
285 cannot_be_modified: 1
287 columnname: checked_out_from
291 columnname: checkout_on
295 columnname: checkin_on
300 # NOTE: These columns are in the same order as kohastructure.sql, and contain all items
301 # columns except for the following internal/obsolete fields: stack, more_subfields_xml,
302 # cn_sort, permanent_location, damaged_on itemlost_on, withdrawn_on, issues, renewals and
307 columnname: dateaccessioned
309 columnname: booksellerid
311 columnname: homebranch
315 columnname: replacementprice
317 columnname: replacementpricedate
319 columnname: datelastborrowed
321 columnname: datelastseen
325 columnname: notforloan
331 columnname: withdrawn
333 columnname: itemcallnumber
335 columnname: coded_location_qualifier
337 columnname: restricted
339 columnname: itemnotes
341 columnname: itemnotes_nonpublic
343 columnname: holdingbranch
345 columnname: timestamp
351 columnname: cn_source
355 columnname: materials
361 columnname: enumchron
363 columnname: copynumber
365 columnname: stocknumber
386 cannot_be_modified: 1
390 course_reserves_table:
394 columnname: department
396 columnname: course_no
402 columnname: instructors
404 columnname: staff_note
406 columnname: public_note
408 columnname: no_of_students
413 course_reserves_table:
421 columnname: call_number
423 columnname: item_type
425 columnname: collection
431 columnname: staff_note
433 columnname: public_note
437 columnname: other_course_reserves
441 cannot_be_modified: 1
447 columnname: illrequest_id
449 columnname: metadata_author
451 columnname: metadata_title
453 columnname: metadata_article_title
455 columnname: metadata_issue
457 columnname: metadata_volume
459 columnname: metadata_year
461 columnname: metadata_pages
463 columnname: metadata_type
469 columnname: biblio_id
471 columnname: library_branchname
477 cannot_be_modified: 1
480 columnname: placed_formatted
484 cannot_be_modified: 1
487 columnname: updated_formatted
491 columnname: completed
493 cannot_be_modified: 1
496 columnname: completed_formatted
498 columnname: accessurl
504 columnname: notesopac
506 columnname: notesstaff
512 cannot_be_modified: 1
520 columnname: account_type
522 columnname: description
528 columnname: returndate
534 cannot_be_modified: 1
536 columnname: amountoutstanding
538 cannot_be_modified: 1
542 cannot_be_modified: 1
549 cannot_be_modified: 1
553 cannot_be_modified: 1
555 columnname: account_type
557 columnname: description
565 columnname: returndate
571 columnname: amountoutstanding
578 cannot_be_modified: 1
580 columnname: cardnumber
584 columnname: dateofbirth
590 columnname: expires_on
592 columnname: od_checkouts
596 columnname: circ_notes
600 cannot_be_modified: 1
605 columnname: sort_order
607 cannot_be_modified: 1
610 columnname: todays_or_previous_checkouts
612 cannot_be_modified: 1
615 columnname: due_date_unformatted
617 cannot_be_modified: 1
624 columnname: record_type
626 columnname: item_type
628 columnname: collection
632 columnname: homebranch
634 columnname: checkout_on_unformatted
636 cannot_be_modified: 1
639 columnname: checkout_on
641 columnname: checkout_from
653 cannot_be_modified: 1
659 cannot_be_modified: 1
666 cannot_be_modified: 1
674 columnname: reservedate
676 columnname: expirationdate
678 columnname: waitingdate
680 columnname: cancellationdate
687 checkouthistory-table:
690 cannot_be_modified: 1
698 columnname: call_number
702 columnname: number_of_renewals
704 columnname: checked_out_on
706 columnname: checked_out_from
710 columnname: return_date
717 cannot_be_modified: 1
721 columnname: firstname
731 columnname: expires_on
733 columnname: circ_notes
741 cannot_be_modified: 1
747 columnname: itemlost_on
751 columnname: callnumber
753 columnname: datelastseen
757 columnname: replacementprice
763 columnname: collection_code
765 columnname: current_location
769 columnname: notforloan
776 columnname: selection
778 cannot_be_modified: 1
780 columnname: report_id
782 cannot_be_modified: 1
784 columnname: report_name
796 columnname: creation_date
798 columnname: last_edit
806 columnname: cache_expiry
808 columnname: saved_results
814 cannot_be_modified: 1
820 columnname: sort_order
822 cannot_be_modified: 1
825 columnname: todays_or_previous_checkouts
827 cannot_be_modified: 1
830 columnname: due_date_unformatted
832 cannot_be_modified: 1
839 columnname: record_type
841 columnname: item_type
843 columnname: collection
847 columnname: homebranch
849 columnname: checkout_on_unformatted
851 cannot_be_modified: 1
854 columnname: checkout_on
856 columnname: checkout_from
868 cannot_be_modified: 1
874 cannot_be_modified: 1
879 cannot_be_modified: 1
881 columnname: cardnumber
883 columnname: date_of_birth
904 columnname: homelibrary
906 columnname: holdinglibrary
910 columnname: itemcallnumber
912 columnname: dateaccessioned
915 columnname: record_type
928 columnname: collection
930 columnname: document_type
932 columnname: callnumber
934 columnname: copynumber
936 columnname: enumeration
951 columnname: pull_items
953 columnname: avalaible_items
961 columnname: libraries
963 columnname: call_numbers
965 columnname: copy_numbers
967 columnname: enumeration
969 columnname: itemtypes
971 columnname: locations
973 columnname: hold_date
984 columnname: holds_ratio
988 columnname: home_libraries
990 columnname: holding_libraries
996 columnname: call_numbers
998 columnname: items_needed
1000 holds_awaiting_pickup:
1003 columnname: waiting_since
1005 columnname: date_hold_placed
1011 columnname: home_library
1013 columnname: current_location
1015 columnname: shelving_location
1017 columnname: call_number
1019 columnname: copy_number
1021 columnname: enumeration
1027 columnname: waiting_since
1029 columnname: date_hold_placed
1035 columnname: home_library
1037 columnname: current_location
1039 columnname: shelving_location
1041 columnname: call_number
1043 columnname: copy_number
1045 columnname: enumeration
1052 columnname: due_date
1056 columnname: patron_category
1059 columnname: patron_library
1063 columnname: home_library
1066 columnname: holding_library
1071 columnname: call_number
1073 columnname: item_type
1078 columnname: non-public_note
1084 columnname: item_itemtype
1086 columnname: item_current_location
1088 columnname: item_home_location
1090 columnname: item_shelving_location
1093 columnname: item_ccode
1095 columnname: item_callnumber
1097 columnname: item_enumchron
1099 columnname: item_url
1101 columnname: item_copy
1103 columnname: item_status
1105 columnname: item_notes
1107 columnname: item_datedue
1109 columnname: item_barcode
1112 columnname: item_holds
1114 columnname: item_priority
1116 columnname: item_coursereserves
1118 course_reserves_table:
1120 columnname: coursename
1122 columnname: department
1124 columnname: course_number
1130 columnname: instructor
1136 columnname: serial_serialseq
1138 columnname: serial_publisheddate
1140 columnname: serial_planneddate
1142 columnname: serial_status
1144 columnname: serial_notes
1147 subscription-detail:
1154 columnname: ordernumber
1156 columnname: creation_date
1158 columnname: receive_date
1162 columnname: order_internalnote
1164 columnname: order_vendornote
1184 columnname: copy_notice
1187 cannot_be_toggled: 1
1188 cannot_be_modified: 1
1195 columnname: cyclical
1199 columnname: description
1201 columnname: number_of_items
1204 cannot_be_toggled: 1
1205 cannot_be_modified: 1
1207 stock_rotation_manage_items:
1215 columnname: call_number
1217 columnname: in_transit
1222 cannot_be_toggled: 1
1223 cannot_be_modified: 1