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
498 cannot_be_modified: 1
500 columnname: amountoutstanding
502 cannot_be_modified: 1
506 cannot_be_modified: 1
513 cannot_be_modified: 1
517 cannot_be_modified: 1
519 columnname: account_type
521 columnname: description
529 columnname: returndate
535 columnname: amountoutstanding
542 cannot_be_modified: 1
544 columnname: cardnumber
548 columnname: dateofbirth
554 columnname: expires_on
556 columnname: od_checkouts
560 columnname: circ_notes
564 cannot_be_modified: 1
569 columnname: sort_order
571 cannot_be_modified: 1
574 columnname: todays_or_previous_checkouts
576 cannot_be_modified: 1
579 columnname: due_date_unformatted
581 cannot_be_modified: 1
588 columnname: record_type
590 columnname: item_type
592 columnname: collection
596 columnname: homebranch
598 columnname: checkout_on_unformatted
600 cannot_be_modified: 1
603 columnname: checkout_on
605 columnname: checkout_from
617 cannot_be_modified: 1
623 cannot_be_modified: 1
630 cannot_be_modified: 1
638 columnname: reservedate
640 columnname: expirationdate
642 columnname: waitingdate
644 columnname: cancellationdate
651 checkouthistory-table:
654 cannot_be_modified: 1
662 columnname: call_number
666 columnname: number_of_renewals
668 columnname: checked_out_on
670 columnname: checked_out_from
674 columnname: return_date
681 cannot_be_modified: 1
685 columnname: firstname
695 columnname: expires_on
697 columnname: circ_notes
705 cannot_be_modified: 1
711 columnname: itemlost_on
715 columnname: callnumber
717 columnname: datelastseen
721 columnname: replacementprice
727 columnname: collection_code
729 columnname: current_location
733 columnname: notforloan
740 columnname: selection
742 cannot_be_modified: 1
744 columnname: report_id
746 cannot_be_modified: 1
748 columnname: report_name
760 columnname: creation_date
762 columnname: last_edit
770 columnname: cache_expiry
772 columnname: saved_results
778 cannot_be_modified: 1
784 columnname: sort_order
786 cannot_be_modified: 1
789 columnname: todays_or_previous_checkouts
791 cannot_be_modified: 1
794 columnname: due_date_unformatted
796 cannot_be_modified: 1
803 columnname: record_type
805 columnname: item_type
807 columnname: collection
811 columnname: homebranch
813 columnname: checkout_on_unformatted
815 cannot_be_modified: 1
818 columnname: checkout_on
820 columnname: checkout_from
832 cannot_be_modified: 1
838 cannot_be_modified: 1
843 cannot_be_modified: 1
845 columnname: cardnumber
847 columnname: date_of_birth
868 columnname: homelibrary
870 columnname: holdinglibrary
874 columnname: itemcallnumber
876 columnname: dateaccessioned
879 columnname: record_type
892 columnname: collection
894 columnname: document_type
896 columnname: callnumber
898 columnname: copynumber
900 columnname: enumeration
915 columnname: pull_items
917 columnname: avalaible_items
925 columnname: libraries
927 columnname: call_numbers
929 columnname: copy_numbers
931 columnname: enumeration
933 columnname: itemtypes
935 columnname: locations
937 columnname: hold_date
948 columnname: holds_ratio
952 columnname: home_libraries
954 columnname: holding_libraries
960 columnname: call_numbers
962 columnname: items_needed
964 holds_awaiting_pickup:
967 columnname: waiting_since
969 columnname: date_hold_placed
975 columnname: home_library
977 columnname: current_location
979 columnname: shelving_location
981 columnname: call_number
983 columnname: copy_number
985 columnname: enumeration
991 columnname: waiting_since
993 columnname: date_hold_placed
999 columnname: home_library
1001 columnname: current_location
1003 columnname: shelving_location
1005 columnname: call_number
1007 columnname: copy_number
1009 columnname: enumeration
1016 columnname: due_date
1020 columnname: patron_category
1023 columnname: patron_library
1027 columnname: home_library
1030 columnname: holding_library
1035 columnname: call_number
1037 columnname: item_type
1042 columnname: non-public_note
1048 columnname: item_itemtype
1050 columnname: item_current_location
1052 columnname: item_home_location
1054 columnname: item_shelving_location
1057 columnname: item_ccode
1059 columnname: item_callnumber
1061 columnname: item_enumchron
1063 columnname: item_url
1065 columnname: item_copy
1067 columnname: item_status
1069 columnname: item_notes
1071 columnname: item_datedue
1073 columnname: item_barcode
1076 columnname: item_holds
1078 columnname: item_priority
1080 columnname: item_coursereserves
1084 columnname: serial_serialseq
1086 columnname: serial_publisheddate
1088 columnname: serial_planneddate
1090 columnname: serial_status
1092 columnname: serial_notes
1095 subscription-detail:
1102 columnname: ordernumber
1104 columnname: creation_date
1106 columnname: receive_date
1110 columnname: order_internalnote
1112 columnname: order_vendornote
1132 columnname: copy_notice
1135 cannot_be_toggled: 1
1136 cannot_be_modified: 1
1143 columnname: cyclical
1147 columnname: description
1149 columnname: number_of_items
1152 cannot_be_toggled: 1
1153 cannot_be_modified: 1
1155 stock_rotation_manage_items:
1163 columnname: call_number
1165 columnname: in_transit
1170 cannot_be_toggled: 1
1171 cannot_be_modified: 1