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: ecost_tax_excluded
73 columnname: recommended_retail_price_tax_included
76 columnname: ecost_tax_included
79 columnname: replacement_price
83 columnname: total_tax_excluded
85 columnname: total_tax_included
88 columnname: goods_and_services_tax_percentage
90 columnname: goods_and_services_tax
94 columnname: supplier_report
102 cannot_be_modified: 1
110 cannot_be_modified: 1
114 cannot_be_modified: 1
121 columnname: last_updated
132 columnname: category_name
136 columnname: enrollment_period
138 columnname: age_required
140 columnname: upper_age_limit
142 columnname: enrollment_fee
146 columnname: lost_items
150 columnname: messaging
152 columnname: branches_limitations
154 columnname: default_privacy
158 cannot_be_modified: 1
167 columnname: description
169 columnname: search_category
171 columnname: not_for_loan
173 columnname: hide_in_opac
175 columnname: rental_charge
177 columnname: daily_rental_charge
179 columnname: hourly_rental_charge
181 columnname: default_replacement_cost
183 columnname: lost_processing_fee
185 columnname: checkin_message
187 columnname: library_limitations
191 cannot_be_modified: 1
196 columnname: library_name
198 columnname: library_code
200 columnname: library_address
202 columnname: marc_organization_code
204 columnname: library_ip
206 columnname: is_pickup_location
210 cannot_be_modified: 1
215 acquisitiondetails-table:
221 columnname: basketgroup
225 columnname: ordernumber
227 columnname: creation_date
229 columnname: received_data
235 columnname: order_internalnote
237 columnname: subscription
239 columnname: subscription_callnumber
241 checkoutshistory-table:
245 cannot_be_modified: 1
249 cannot_be_modified: 1
251 columnname: checked_out_from
255 columnname: checkout_on
259 columnname: checkin_on
264 # NOTE: These columns are in the same order as kohastructure.sql, and contain all items
265 # columns except for the following internal/obsolete fields: stack, more_subfields_xml,
266 # cn_sort, permanent_location, damaged_on itemlost_on, withdrawn_on, issues, renewals and
271 columnname: dateaccessioned
273 columnname: booksellerid
275 columnname: homebranch
279 columnname: replacementprice
281 columnname: replacementpricedate
283 columnname: datelastborrowed
285 columnname: datelastseen
289 columnname: notforloan
295 columnname: withdrawn
297 columnname: itemcallnumber
299 columnname: coded_location_qualifier
301 columnname: restricted
303 columnname: itemnotes
305 columnname: itemnotes_nonpublic
307 columnname: holdingbranch
309 columnname: timestamp
315 columnname: cn_source
319 columnname: materials
325 columnname: enumchron
327 columnname: copynumber
329 columnname: stocknumber
350 cannot_be_modified: 1
354 course_reserves_table:
358 columnname: department
360 columnname: course_no
366 columnname: instructors
368 columnname: staff_note
370 columnname: public_note
372 columnname: no_of_students
377 course_reserves_table:
385 columnname: call_number
387 columnname: item_type
389 columnname: collection
395 columnname: staff_note
397 columnname: public_note
401 columnname: other_course_reserves
405 cannot_be_modified: 1
411 columnname: illrequest_id
413 columnname: metadata_author
415 columnname: metadata_title
417 columnname: metadata_article_title
419 columnname: metadata_issue
421 columnname: metadata_volume
423 columnname: metadata_year
425 columnname: metadata_pages
427 columnname: metadata_type
433 columnname: biblio_id
435 columnname: library_branchname
441 cannot_be_modified: 1
444 columnname: placed_formatted
448 cannot_be_modified: 1
451 columnname: updated_formatted
455 columnname: completed
457 cannot_be_modified: 1
460 columnname: completed_formatted
462 columnname: accessurl
468 columnname: notesopac
470 columnname: notesstaff
476 cannot_be_modified: 1
484 columnname: account_type
486 columnname: description
492 columnname: returndate
494 columnname: issuedate
500 cannot_be_modified: 1
502 columnname: amountoutstanding
504 cannot_be_modified: 1
508 cannot_be_modified: 1
515 cannot_be_modified: 1
519 cannot_be_modified: 1
521 columnname: account_type
523 columnname: description
531 columnname: returndate
533 columnname: issuedate
539 columnname: amountoutstanding
546 cannot_be_modified: 1
548 columnname: cardnumber
552 columnname: dateofbirth
558 columnname: expires_on
560 columnname: od_checkouts
564 columnname: circ_notes
568 cannot_be_modified: 1
573 columnname: sort_order
575 cannot_be_modified: 1
578 columnname: todays_or_previous_checkouts
580 cannot_be_modified: 1
583 columnname: due_date_unformatted
585 cannot_be_modified: 1
592 columnname: record_type
594 columnname: item_type
596 columnname: collection
600 columnname: homebranch
602 columnname: checkout_on_unformatted
604 cannot_be_modified: 1
607 columnname: checkout_on
609 columnname: checkout_from
621 cannot_be_modified: 1
625 columnname: claims_returned
629 cannot_be_modified: 1
636 cannot_be_modified: 1
644 columnname: reservedate
646 columnname: expirationdate
648 columnname: waitingdate
650 columnname: cancellationdate
657 checkouthistory-table:
660 cannot_be_modified: 1
668 columnname: call_number
672 columnname: number_of_renewals
674 columnname: checked_out_on
676 columnname: checked_out_from
680 columnname: return_date
687 cannot_be_modified: 1
691 columnname: firstname
701 columnname: expires_on
703 columnname: circ_notes
711 cannot_be_modified: 1
717 columnname: itemlost_on
721 columnname: callnumber
723 columnname: datelastseen
727 columnname: replacementprice
733 columnname: collection_code
735 columnname: current_location
739 columnname: notforloan
746 columnname: selection
748 cannot_be_modified: 1
750 columnname: report_id
752 cannot_be_modified: 1
754 columnname: report_name
766 columnname: creation_date
768 columnname: last_edit
776 columnname: cache_expiry
778 columnname: saved_results
784 cannot_be_modified: 1
790 columnname: sort_order
792 cannot_be_modified: 1
795 columnname: todays_or_previous_checkouts
797 cannot_be_modified: 1
800 columnname: due_date_unformatted
802 cannot_be_modified: 1
809 columnname: record_type
811 columnname: item_type
813 columnname: collection
817 columnname: homebranch
819 columnname: checkout_on_unformatted
821 cannot_be_modified: 1
824 columnname: checkout_on
826 columnname: checkout_from
838 cannot_be_modified: 1
842 columnname: claims_returned
846 cannot_be_modified: 1
852 cannot_be_modified: 1
854 columnname: cardnumber
856 columnname: date_of_birth
877 columnname: homelibrary
879 columnname: holdinglibrary
883 columnname: itemcallnumber
885 columnname: dateaccessioned
888 columnname: record_type
901 columnname: collection
903 columnname: document_type
905 columnname: callnumber
907 columnname: copynumber
909 columnname: enumeration
924 columnname: pull_items
926 columnname: avalaible_items
934 columnname: libraries
936 columnname: call_numbers
938 columnname: copy_numbers
940 columnname: enumeration
942 columnname: itemtypes
944 columnname: locations
946 columnname: hold_date
957 columnname: holds_ratio
961 columnname: home_libraries
963 columnname: holding_libraries
969 columnname: call_numbers
971 columnname: items_needed
973 holds_awaiting_pickup:
976 columnname: waiting_since
978 columnname: date_hold_placed
984 columnname: home_library
986 columnname: current_location
988 columnname: shelving_location
990 columnname: call_number
992 columnname: copy_number
994 columnname: enumeration
1000 columnname: waiting_since
1002 columnname: date_hold_placed
1008 columnname: home_library
1010 columnname: current_location
1012 columnname: shelving_location
1014 columnname: call_number
1016 columnname: copy_number
1018 columnname: enumeration
1025 columnname: due_date
1029 columnname: patron_category
1032 columnname: patron_library
1036 columnname: home_library
1039 columnname: holding_library
1044 columnname: call_number
1046 columnname: item_type
1051 columnname: non-public_note
1057 columnname: item_itemtype
1059 columnname: item_current_location
1061 columnname: item_home_location
1063 columnname: item_shelving_location
1066 columnname: item_ccode
1068 columnname: item_callnumber
1070 columnname: item_enumchron
1072 columnname: item_url
1074 columnname: item_copy
1076 columnname: item_status
1078 columnname: item_notes
1080 columnname: item_datedue
1082 columnname: item_barcode
1085 columnname: item_holds
1087 columnname: item_priority
1089 columnname: item_coursereserves
1093 columnname: serial_serialseq
1095 columnname: serial_publisheddate
1097 columnname: serial_planneddate
1099 columnname: serial_status
1101 columnname: serial_notes
1104 subscription-detail:
1111 columnname: ordernumber
1113 columnname: creation_date
1115 columnname: receive_date
1119 columnname: order_internalnote
1121 columnname: order_vendornote
1141 columnname: copy_notice
1144 cannot_be_toggled: 1
1145 cannot_be_modified: 1
1152 columnname: cyclical
1156 columnname: description
1158 columnname: number_of_items
1161 cannot_be_toggled: 1
1162 cannot_be_modified: 1
1164 stock_rotation_manage_items:
1172 columnname: call_number
1174 columnname: in_transit
1179 cannot_be_toggled: 1
1180 cannot_be_modified: 1