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
256 columnname: holdings_checkbox
258 cannot_be_modified: 1
260 columnname: holdings_itype
262 columnname: holdings_holdingbranch
264 columnname: holdings_homebranch
266 columnname: holdings_ccode
268 columnname: holdings_itemcallnumber
270 columnname: holdings_status
272 columnname: holdings_lastseen
274 columnname: holdings_dateaccessioned
276 columnname: holdings_barcode
278 columnname: holdings_enumchron
280 columnname: holdings_uri
282 columnname: holdings_copynumber
284 columnname: holdings_stocknumber
286 columnname: holdings_materials
288 columnname: holdings_itemnotes
290 columnname: holdings_itemnotes_nonpublic
292 columnname: holdings_hostrecord
294 columnname: holdings_usedin
296 columnname: holdings_usedin_col
298 columnname: holdings_course_reserves
300 columnname: holdings_spinelabel
302 columnname: holdings_actions
304 cannot_be_modified: 1
308 columnname: otherholdings_checkbox
310 cannot_be_modified: 1
312 columnname: otherholdings_itype
314 columnname: otherholdings_holdingbranch
316 columnname: otherholdings_homebranch
318 columnname: otherholdings_ccode
320 columnname: otherholdings_itemcallnumber
322 columnname: otherholdings_status
324 columnname: otherholdings_lastseen
326 columnname: otherholdings_dateaccessioned
328 columnname: otherholdings_barcode
330 columnname: otherholdings_enumchron
332 columnname: otherholdings_uri
334 columnname: otherholdings_copynumber
336 columnname: otherholdings_stocknumber
338 columnname: otherholdings_materials
340 columnname: otherholdings_itemnotes
342 columnname: otherholdings_itemnotes_nonpublic
344 columnname: otherholdings_hostrecord
346 columnname: otherholdings_usedin
348 columnname: otherholdings_usedin_col
350 columnname: otherholdings_course_reserves
352 columnname: otherholdings_spinelabel
354 columnname: otherholdings_actions
356 cannot_be_modified: 1
358 acquisitiondetails-table:
364 columnname: basketgroup
368 columnname: ordernumber
370 columnname: creation_date
372 columnname: received_data
378 columnname: order_internalnote
380 columnname: subscription
382 columnname: subscription_callnumber
384 checkoutshistory-table:
388 cannot_be_modified: 1
392 cannot_be_modified: 1
394 columnname: checked_out_from
398 columnname: checkout_on
402 columnname: checkin_on
407 # NOTE: These columns are in the same order as kohastructure.sql, and contain all items
408 # columns except for the following internal/obsolete fields: stack, more_subfields_xml,
409 # cn_sort, permanent_location, damaged_on itemlost_on, withdrawn_on, issues, renewals and
414 columnname: dateaccessioned
416 columnname: booksellerid
418 columnname: homebranch
422 columnname: replacementprice
424 columnname: replacementpricedate
426 columnname: datelastborrowed
428 columnname: datelastseen
432 columnname: notforloan
438 columnname: withdrawn
440 columnname: itemcallnumber
442 columnname: coded_location_qualifier
444 columnname: restricted
446 columnname: itemnotes
448 columnname: itemnotes_nonpublic
450 columnname: holdingbranch
452 columnname: timestamp
458 columnname: cn_source
462 columnname: materials
468 columnname: enumchron
470 columnname: copynumber
472 columnname: stocknumber
493 cannot_be_modified: 1
497 course_reserves_table:
501 columnname: department
503 columnname: course_no
509 columnname: instructors
511 columnname: staff_note
513 columnname: public_note
515 columnname: no_of_students
520 course_reserves_table:
528 columnname: call_number
530 columnname: item_type
532 columnname: collection
538 columnname: staff_note
540 columnname: public_note
544 columnname: other_course_reserves
548 cannot_be_modified: 1
554 columnname: illrequest_id
556 columnname: metadata_author
558 columnname: metadata_title
560 columnname: metadata_article_title
562 columnname: metadata_issue
564 columnname: metadata_volume
566 columnname: metadata_year
568 columnname: metadata_pages
570 columnname: metadata_type
576 columnname: biblio_id
578 columnname: library_branchname
584 cannot_be_modified: 1
587 columnname: placed_formatted
591 cannot_be_modified: 1
594 columnname: updated_formatted
598 columnname: completed
600 cannot_be_modified: 1
603 columnname: completed_formatted
605 columnname: accessurl
611 columnname: notesopac
613 columnname: notesstaff
619 cannot_be_modified: 1
627 columnname: account_type
629 columnname: description
635 columnname: returndate
637 columnname: issuedate
643 cannot_be_modified: 1
645 columnname: amountoutstanding
647 cannot_be_modified: 1
651 cannot_be_modified: 1
658 cannot_be_modified: 1
662 cannot_be_modified: 1
664 columnname: account_type
666 columnname: description
674 columnname: returndate
676 columnname: issuedate
682 columnname: amountoutstanding
689 cannot_be_modified: 1
691 columnname: cardnumber
695 columnname: dateofbirth
701 columnname: expires_on
703 columnname: od_checkouts
707 columnname: circ_notes
711 cannot_be_modified: 1
716 columnname: sort_order
718 cannot_be_modified: 1
721 columnname: todays_or_previous_checkouts
723 cannot_be_modified: 1
726 columnname: due_date_unformatted
728 cannot_be_modified: 1
735 columnname: record_type
737 columnname: item_type
739 columnname: collection
743 columnname: homebranch
745 columnname: checkout_on_unformatted
747 cannot_be_modified: 1
750 columnname: checkout_on
752 columnname: checkout_from
764 cannot_be_modified: 1
768 columnname: claims_returned
772 cannot_be_modified: 1
779 cannot_be_modified: 1
787 columnname: reservedate
789 columnname: expirationdate
791 columnname: waitingdate
793 columnname: cancellationdate
800 checkouthistory-table:
803 cannot_be_modified: 1
811 columnname: call_number
815 columnname: number_of_renewals
817 columnname: checked_out_on
819 columnname: checked_out_from
823 columnname: return_date
830 cannot_be_modified: 1
834 columnname: firstname
844 columnname: expires_on
846 columnname: circ_notes
854 cannot_be_modified: 1
860 columnname: itemlost_on
864 columnname: callnumber
866 columnname: datelastseen
870 columnname: replacementprice
876 columnname: collection_code
878 columnname: current_location
882 columnname: notforloan
889 columnname: selection
891 cannot_be_modified: 1
893 columnname: report_id
895 cannot_be_modified: 1
897 columnname: report_name
909 columnname: creation_date
911 columnname: last_edit
919 columnname: cache_expiry
921 columnname: saved_results
927 cannot_be_modified: 1
933 columnname: sort_order
935 cannot_be_modified: 1
938 columnname: todays_or_previous_checkouts
940 cannot_be_modified: 1
943 columnname: due_date_unformatted
945 cannot_be_modified: 1
952 columnname: record_type
954 columnname: item_type
956 columnname: collection
960 columnname: homebranch
962 columnname: checkout_on_unformatted
964 cannot_be_modified: 1
967 columnname: checkout_on
969 columnname: checkout_from
981 cannot_be_modified: 1
985 columnname: claims_returned
989 cannot_be_modified: 1
995 cannot_be_modified: 1
997 columnname: cardnumber
999 columnname: date_of_birth
1001 columnname: category
1012 columnname: due_date
1020 columnname: homelibrary
1022 columnname: holdinglibrary
1024 columnname: location
1026 columnname: itemcallnumber
1028 columnname: dateaccessioned
1031 columnname: record_type
1035 columnname: borrower
1037 columnname: itemnote
1044 columnname: collection
1046 columnname: document_type
1048 columnname: callnumber
1050 columnname: copynumber
1052 columnname: enumeration
1067 columnname: pull_items
1069 columnname: avalaible_items
1077 columnname: libraries
1079 columnname: call_numbers
1081 columnname: copy_numbers
1083 columnname: enumeration
1085 columnname: itemtypes
1087 columnname: locations
1089 columnname: hold_date
1100 columnname: holds_ratio
1104 columnname: home_libraries
1106 columnname: holding_libraries
1108 columnname: location
1110 columnname: itemtype
1112 columnname: call_numbers
1114 columnname: items_needed
1116 holds_awaiting_pickup:
1119 columnname: waiting_since
1121 columnname: date_hold_placed
1127 columnname: home_library
1129 columnname: current_location
1131 columnname: shelving_location
1133 columnname: call_number
1135 columnname: copy_number
1137 columnname: enumeration
1143 columnname: waiting_since
1145 columnname: date_hold_placed
1151 columnname: home_library
1153 columnname: current_location
1155 columnname: shelving_location
1157 columnname: call_number
1159 columnname: copy_number
1161 columnname: enumeration
1168 columnname: due_date
1172 columnname: patron_category
1175 columnname: patron_library
1179 columnname: home_library
1182 columnname: holding_library
1187 columnname: call_number
1189 columnname: item_type
1194 columnname: non-public_note
1200 columnname: item_itemtype
1202 columnname: item_current_location
1204 columnname: item_home_location
1206 columnname: item_shelving_location
1209 columnname: item_ccode
1211 columnname: item_callnumber
1213 columnname: item_enumchron
1215 columnname: item_url
1217 columnname: item_copy
1219 columnname: item_status
1221 columnname: item_notes
1223 columnname: item_datedue
1225 columnname: item_barcode
1228 columnname: item_holds
1230 columnname: item_priority
1232 columnname: item_coursereserves
1234 course_reserves_table:
1236 columnname: coursename
1238 columnname: department
1240 columnname: course_number
1246 columnname: instructor
1252 columnname: serial_serialseq
1254 columnname: serial_publisheddate
1256 columnname: serial_planneddate
1258 columnname: serial_status
1260 columnname: serial_notes
1268 columnname: itemtype
1270 columnname: location
1272 columnname: collection
1274 columnname: callnumber
1276 columnname: copynumber
1287 subscription-detail:
1294 columnname: ordernumber
1296 columnname: creation_date
1298 columnname: receive_date
1302 columnname: order_internalnote
1304 columnname: order_vendornote
1324 columnname: copy_notice
1327 cannot_be_toggled: 1
1328 cannot_be_modified: 1
1335 columnname: cyclical
1339 columnname: description
1341 columnname: number_of_items
1344 cannot_be_toggled: 1
1345 cannot_be_modified: 1
1347 stock_rotation_manage_items:
1355 columnname: call_number
1357 columnname: in_transit
1362 cannot_be_toggled: 1
1363 cannot_be_modified: 1