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
621 columnname: claims_returned
625 cannot_be_modified: 1
632 cannot_be_modified: 1
640 columnname: reservedate
642 columnname: expirationdate
644 columnname: waitingdate
646 columnname: cancellationdate
653 checkouthistory-table:
656 cannot_be_modified: 1
664 columnname: call_number
668 columnname: number_of_renewals
670 columnname: checked_out_on
672 columnname: checked_out_from
676 columnname: return_date
683 cannot_be_modified: 1
687 columnname: firstname
697 columnname: expires_on
699 columnname: circ_notes
707 cannot_be_modified: 1
713 columnname: itemlost_on
717 columnname: callnumber
719 columnname: datelastseen
723 columnname: replacementprice
729 columnname: collection_code
731 columnname: current_location
735 columnname: notforloan
742 columnname: selection
744 cannot_be_modified: 1
746 columnname: report_id
748 cannot_be_modified: 1
750 columnname: report_name
762 columnname: creation_date
764 columnname: last_edit
772 columnname: cache_expiry
774 columnname: saved_results
780 cannot_be_modified: 1
786 columnname: sort_order
788 cannot_be_modified: 1
791 columnname: todays_or_previous_checkouts
793 cannot_be_modified: 1
796 columnname: due_date_unformatted
798 cannot_be_modified: 1
805 columnname: record_type
807 columnname: item_type
809 columnname: collection
813 columnname: homebranch
815 columnname: checkout_on_unformatted
817 cannot_be_modified: 1
820 columnname: checkout_on
822 columnname: checkout_from
834 cannot_be_modified: 1
838 columnname: claims_returned
842 cannot_be_modified: 1
848 cannot_be_modified: 1
850 columnname: cardnumber
852 columnname: date_of_birth
873 columnname: homelibrary
875 columnname: holdinglibrary
879 columnname: itemcallnumber
881 columnname: dateaccessioned
884 columnname: record_type
897 columnname: collection
899 columnname: document_type
901 columnname: callnumber
903 columnname: copynumber
905 columnname: enumeration
920 columnname: pull_items
922 columnname: avalaible_items
930 columnname: libraries
932 columnname: call_numbers
934 columnname: copy_numbers
936 columnname: enumeration
938 columnname: itemtypes
940 columnname: locations
942 columnname: hold_date
953 columnname: holds_ratio
957 columnname: home_libraries
959 columnname: holding_libraries
965 columnname: call_numbers
967 columnname: items_needed
969 holds_awaiting_pickup:
972 columnname: waiting_since
974 columnname: date_hold_placed
980 columnname: home_library
982 columnname: current_location
984 columnname: shelving_location
986 columnname: call_number
988 columnname: copy_number
990 columnname: enumeration
996 columnname: waiting_since
998 columnname: date_hold_placed
1004 columnname: home_library
1006 columnname: current_location
1008 columnname: shelving_location
1010 columnname: call_number
1012 columnname: copy_number
1014 columnname: enumeration
1021 columnname: due_date
1025 columnname: patron_category
1028 columnname: patron_library
1032 columnname: home_library
1035 columnname: holding_library
1040 columnname: call_number
1042 columnname: item_type
1047 columnname: non-public_note
1053 columnname: item_itemtype
1055 columnname: item_current_location
1057 columnname: item_home_location
1059 columnname: item_shelving_location
1062 columnname: item_ccode
1064 columnname: item_callnumber
1066 columnname: item_enumchron
1068 columnname: item_url
1070 columnname: item_copy
1072 columnname: item_status
1074 columnname: item_notes
1076 columnname: item_datedue
1078 columnname: item_barcode
1081 columnname: item_holds
1083 columnname: item_priority
1085 columnname: item_coursereserves
1089 columnname: serial_serialseq
1091 columnname: serial_publisheddate
1093 columnname: serial_planneddate
1095 columnname: serial_status
1097 columnname: serial_notes
1100 subscription-detail:
1107 columnname: ordernumber
1109 columnname: creation_date
1111 columnname: receive_date
1115 columnname: order_internalnote
1117 columnname: order_vendornote
1137 columnname: copy_notice
1140 cannot_be_toggled: 1
1141 cannot_be_modified: 1
1148 columnname: cyclical
1152 columnname: description
1154 columnname: number_of_items
1157 cannot_be_toggled: 1
1158 cannot_be_modified: 1
1160 stock_rotation_manage_items:
1168 columnname: call_number
1170 columnname: in_transit
1175 cannot_be_toggled: 1
1176 cannot_be_modified: 1