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
130 columnname: lastmodificationby
132 columnname: lastmodificationdate
136 columnname: library_fund
138 columnname: suggestion_status
142 cannot_be_modified: 1
150 cannot_be_modified: 1
154 cannot_be_modified: 1
161 columnname: last_updated
172 columnname: category_name
176 columnname: enrollment_period
178 columnname: age_required
180 columnname: upper_age_limit
182 columnname: enrollment_fee
186 columnname: lost_items
190 columnname: messaging
192 columnname: branches_limitations
194 columnname: default_privacy
198 cannot_be_modified: 1
207 columnname: description
209 columnname: search_category
211 columnname: not_for_loan
213 columnname: hide_in_opac
215 columnname: rental_charge
217 columnname: daily_rental_charge
219 columnname: hourly_rental_charge
221 columnname: default_replacement_cost
223 columnname: lost_processing_fee
225 columnname: checkin_message
227 columnname: library_limitations
231 cannot_be_modified: 1
236 columnname: library_name
238 columnname: library_code
240 columnname: library_address
242 columnname: marc_organization_code
244 columnname: library_ip
246 columnname: is_pickup_location
250 cannot_be_modified: 1
255 acquisitiondetails-table:
261 columnname: basketgroup
265 columnname: ordernumber
267 columnname: creation_date
269 columnname: received_data
275 columnname: order_internalnote
277 columnname: subscription
279 columnname: subscription_callnumber
281 checkoutshistory-table:
285 cannot_be_modified: 1
289 cannot_be_modified: 1
291 columnname: checked_out_from
295 columnname: checkout_on
299 columnname: checkin_on
304 # NOTE: These columns are in the same order as kohastructure.sql, and contain all items
305 # columns except for the following internal/obsolete fields: stack, more_subfields_xml,
306 # cn_sort, permanent_location, damaged_on itemlost_on, withdrawn_on, issues, renewals and
311 columnname: dateaccessioned
313 columnname: booksellerid
315 columnname: homebranch
319 columnname: replacementprice
321 columnname: replacementpricedate
323 columnname: datelastborrowed
325 columnname: datelastseen
329 columnname: notforloan
335 columnname: withdrawn
337 columnname: itemcallnumber
339 columnname: coded_location_qualifier
341 columnname: restricted
343 columnname: itemnotes
345 columnname: itemnotes_nonpublic
347 columnname: holdingbranch
349 columnname: timestamp
355 columnname: cn_source
359 columnname: materials
365 columnname: enumchron
367 columnname: copynumber
369 columnname: stocknumber
390 cannot_be_modified: 1
394 course_reserves_table:
398 columnname: department
400 columnname: course_no
406 columnname: instructors
408 columnname: staff_note
410 columnname: public_note
412 columnname: no_of_students
417 course_reserves_table:
425 columnname: call_number
427 columnname: item_type
429 columnname: collection
435 columnname: staff_note
437 columnname: public_note
441 columnname: other_course_reserves
445 cannot_be_modified: 1
451 columnname: illrequest_id
453 columnname: metadata_author
455 columnname: metadata_title
457 columnname: metadata_article_title
459 columnname: metadata_issue
461 columnname: metadata_volume
463 columnname: metadata_year
465 columnname: metadata_pages
467 columnname: metadata_type
473 columnname: biblio_id
475 columnname: library_branchname
481 cannot_be_modified: 1
484 columnname: placed_formatted
488 cannot_be_modified: 1
491 columnname: updated_formatted
495 columnname: completed
497 cannot_be_modified: 1
500 columnname: completed_formatted
502 columnname: accessurl
508 columnname: notesopac
510 columnname: notesstaff
516 cannot_be_modified: 1
524 columnname: account_type
526 columnname: description
532 columnname: returndate
538 cannot_be_modified: 1
540 columnname: amountoutstanding
542 cannot_be_modified: 1
546 cannot_be_modified: 1
553 cannot_be_modified: 1
557 cannot_be_modified: 1
559 columnname: account_type
561 columnname: description
569 columnname: returndate
575 columnname: amountoutstanding
582 cannot_be_modified: 1
584 columnname: cardnumber
588 columnname: dateofbirth
594 columnname: expires_on
596 columnname: od_checkouts
600 columnname: circ_notes
604 cannot_be_modified: 1
609 columnname: sort_order
611 cannot_be_modified: 1
614 columnname: todays_or_previous_checkouts
616 cannot_be_modified: 1
619 columnname: due_date_unformatted
621 cannot_be_modified: 1
628 columnname: record_type
630 columnname: item_type
632 columnname: collection
636 columnname: homebranch
638 columnname: checkout_on_unformatted
640 cannot_be_modified: 1
643 columnname: checkout_on
645 columnname: checkout_from
657 cannot_be_modified: 1
663 cannot_be_modified: 1
670 cannot_be_modified: 1
678 columnname: reservedate
680 columnname: expirationdate
682 columnname: waitingdate
684 columnname: cancellationdate
691 checkouthistory-table:
694 cannot_be_modified: 1
702 columnname: call_number
706 columnname: number_of_renewals
708 columnname: checked_out_on
710 columnname: checked_out_from
714 columnname: return_date
721 cannot_be_modified: 1
725 columnname: firstname
735 columnname: expires_on
737 columnname: circ_notes
745 cannot_be_modified: 1
751 columnname: itemlost_on
755 columnname: callnumber
757 columnname: datelastseen
761 columnname: replacementprice
767 columnname: collection_code
769 columnname: current_location
773 columnname: notforloan
780 columnname: selection
782 cannot_be_modified: 1
784 columnname: report_id
786 cannot_be_modified: 1
788 columnname: report_name
800 columnname: creation_date
802 columnname: last_edit
810 columnname: cache_expiry
812 columnname: saved_results
818 cannot_be_modified: 1
824 columnname: sort_order
826 cannot_be_modified: 1
829 columnname: todays_or_previous_checkouts
831 cannot_be_modified: 1
834 columnname: due_date_unformatted
836 cannot_be_modified: 1
843 columnname: record_type
845 columnname: item_type
847 columnname: collection
851 columnname: homebranch
853 columnname: checkout_on_unformatted
855 cannot_be_modified: 1
858 columnname: checkout_on
860 columnname: checkout_from
872 cannot_be_modified: 1
878 cannot_be_modified: 1
883 cannot_be_modified: 1
885 columnname: cardnumber
887 columnname: date_of_birth
908 columnname: homelibrary
910 columnname: holdinglibrary
914 columnname: itemcallnumber
916 columnname: dateaccessioned
919 columnname: record_type
932 columnname: collection
934 columnname: document_type
936 columnname: callnumber
938 columnname: copynumber
940 columnname: enumeration
955 columnname: pull_items
957 columnname: avalaible_items
965 columnname: libraries
967 columnname: call_numbers
969 columnname: copy_numbers
971 columnname: enumeration
973 columnname: itemtypes
975 columnname: locations
977 columnname: hold_date
988 columnname: holds_ratio
992 columnname: home_libraries
994 columnname: holding_libraries
1000 columnname: call_numbers
1002 columnname: items_needed
1004 holds_awaiting_pickup:
1007 columnname: waiting_since
1009 columnname: date_hold_placed
1015 columnname: home_library
1017 columnname: current_location
1019 columnname: shelving_location
1021 columnname: call_number
1023 columnname: copy_number
1025 columnname: enumeration
1031 columnname: waiting_since
1033 columnname: date_hold_placed
1039 columnname: home_library
1041 columnname: current_location
1043 columnname: shelving_location
1045 columnname: call_number
1047 columnname: copy_number
1049 columnname: enumeration
1056 columnname: due_date
1060 columnname: patron_category
1063 columnname: patron_library
1067 columnname: home_library
1070 columnname: holding_library
1075 columnname: call_number
1077 columnname: item_type
1082 columnname: non-public_note
1088 columnname: item_itemtype
1090 columnname: item_current_location
1092 columnname: item_home_location
1094 columnname: item_shelving_location
1097 columnname: item_ccode
1099 columnname: item_callnumber
1101 columnname: item_enumchron
1103 columnname: item_url
1105 columnname: item_copy
1107 columnname: item_status
1109 columnname: item_notes
1111 columnname: item_datedue
1113 columnname: item_barcode
1116 columnname: item_holds
1118 columnname: item_priority
1120 columnname: item_coursereserves
1122 course_reserves_table:
1124 columnname: coursename
1126 columnname: department
1128 columnname: course_number
1134 columnname: instructor
1140 columnname: serial_serialseq
1142 columnname: serial_publisheddate
1144 columnname: serial_planneddate
1146 columnname: serial_status
1148 columnname: serial_notes
1156 columnname: itemtype
1158 columnname: location
1160 columnname: collection
1162 columnname: callnumber
1164 columnname: copynumber
1175 subscription-detail:
1182 columnname: ordernumber
1184 columnname: creation_date
1186 columnname: receive_date
1190 columnname: order_internalnote
1192 columnname: order_vendornote
1212 columnname: copy_notice
1215 cannot_be_toggled: 1
1216 cannot_be_modified: 1
1223 columnname: cyclical
1227 columnname: description
1229 columnname: number_of_items
1232 cannot_be_toggled: 1
1233 cannot_be_modified: 1
1235 stock_rotation_manage_items:
1243 columnname: call_number
1245 columnname: in_transit
1250 cannot_be_toggled: 1
1251 cannot_be_modified: 1