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: description
490 columnname: returndate
496 cannot_be_modified: 1
498 columnname: amountoutstanding
500 cannot_be_modified: 1
504 cannot_be_modified: 1
511 cannot_be_modified: 1
515 cannot_be_modified: 1
517 columnname: description
525 columnname: returndate
529 columnname: account_type
533 columnname: amountoutstanding
540 cannot_be_modified: 1
542 columnname: cardnumber
546 columnname: dateofbirth
552 columnname: expires_on
554 columnname: od_checkouts
558 columnname: circ_notes
562 cannot_be_modified: 1
567 columnname: sort_order
569 cannot_be_modified: 1
572 columnname: todays_or_previous_checkouts
574 cannot_be_modified: 1
577 columnname: due_date_unformatted
579 cannot_be_modified: 1
586 columnname: record_type
588 columnname: item_type
590 columnname: collection
594 columnname: homebranch
596 columnname: checkout_on_unformatted
598 cannot_be_modified: 1
601 columnname: checkout_on
603 columnname: checkout_from
615 cannot_be_modified: 1
621 cannot_be_modified: 1
628 cannot_be_modified: 1
636 columnname: reservedate
638 columnname: expirationdate
640 columnname: waitingdate
642 columnname: cancellationdate
649 checkouthistory-table:
652 cannot_be_modified: 1
660 columnname: call_number
664 columnname: number_of_renewals
666 columnname: checked_out_on
668 columnname: checked_out_from
672 columnname: return_date
679 cannot_be_modified: 1
683 columnname: firstname
693 columnname: expires_on
695 columnname: circ_notes
703 cannot_be_modified: 1
709 columnname: itemlost_on
713 columnname: callnumber
715 columnname: datelastseen
719 columnname: replacementprice
725 columnname: collection_code
727 columnname: current_location
731 columnname: notforloan
738 columnname: selection
740 cannot_be_modified: 1
742 columnname: report_id
744 cannot_be_modified: 1
746 columnname: report_name
758 columnname: creation_date
760 columnname: last_edit
768 columnname: cache_expiry
770 columnname: saved_results
776 cannot_be_modified: 1
782 columnname: sort_order
784 cannot_be_modified: 1
787 columnname: todays_or_previous_checkouts
789 cannot_be_modified: 1
792 columnname: due_date_unformatted
794 cannot_be_modified: 1
801 columnname: record_type
803 columnname: item_type
805 columnname: collection
809 columnname: homebranch
811 columnname: checkout_on_unformatted
813 cannot_be_modified: 1
816 columnname: checkout_on
818 columnname: checkout_from
830 cannot_be_modified: 1
836 cannot_be_modified: 1
841 cannot_be_modified: 1
843 columnname: cardnumber
845 columnname: date_of_birth
866 columnname: homelibrary
868 columnname: holdinglibrary
872 columnname: itemcallnumber
874 columnname: dateaccessioned
877 columnname: record_type
890 columnname: collection
892 columnname: document_type
894 columnname: callnumber
896 columnname: copynumber
898 columnname: enumeration
913 columnname: pull_items
915 columnname: avalaible_items
923 columnname: libraries
925 columnname: call_numbers
927 columnname: copy_numbers
929 columnname: enumeration
931 columnname: itemtypes
933 columnname: locations
935 columnname: hold_date
946 columnname: holds_ratio
950 columnname: home_libraries
952 columnname: holding_libraries
958 columnname: call_numbers
960 columnname: items_needed
969 columnname: patron_category
972 columnname: patron_library
976 columnname: home_library
979 columnname: holding_library
984 columnname: call_number
986 columnname: item_type
991 columnname: non-public_note
997 columnname: item_itemtype
999 columnname: item_current_location
1001 columnname: item_home_location
1003 columnname: item_shelving_location
1006 columnname: item_ccode
1008 columnname: item_callnumber
1010 columnname: item_enumchron
1012 columnname: item_url
1014 columnname: item_copy
1016 columnname: item_status
1018 columnname: item_notes
1020 columnname: item_datedue
1022 columnname: item_barcode
1025 columnname: item_holds
1027 columnname: item_priority
1029 columnname: item_coursereserves
1033 columnname: serial_serialseq
1035 columnname: serial_publisheddate
1037 columnname: serial_planneddate
1039 columnname: serial_status
1041 columnname: serial_notes
1044 subscription-detail:
1051 columnname: ordernumber
1053 columnname: creation_date
1055 columnname: receive_date
1059 columnname: order_internalnote
1061 columnname: order_vendornote
1081 columnname: copy_notice
1084 cannot_be_toggled: 1
1085 cannot_be_modified: 1
1092 columnname: cyclical
1096 columnname: description
1098 columnname: number_of_items
1101 cannot_be_toggled: 1
1102 cannot_be_modified: 1
1104 stock_rotation_manage_items:
1112 columnname: call_number
1114 columnname: in_transit
1119 cannot_be_toggled: 1
1120 cannot_be_modified: 1